Inactive [ADMN/SEC] AuthDB v2.3.6 - Database authentication and protection [1.1-1.4.5]

Discussion in 'Inactive/Unsupported Plugins' started by CraftFire, Mar 13, 2011.

  1. Offline


    In order to centralize support of our legacy projects, we will no longer be providing support on Bukkit. Please use for support with our projects going forward.
  2. Offline


    That's yet not added, going to add it for the next version ! :)
  3. Offline


    That's great! :D
    Your plugin is getting better and better!
    Just a while and it's perfect :D
  4. Offline


    First, thank you for your work, it's an awesome plugin !

    Then you should add a automatic and manual command to reload database ! Because now, if players register on the website, he still cannot login in game until server is restarted.

    Thank you again !
  5. Offline


    There should be no need to reload the entire user database with each registration on the website. The MySQL database is checked when the user logs in each time. There is no caching involved right now. Is the player in-game when he registers on the website?

    Whoa, you should post that
    Whoa, posts like that should be used with or something. ;)

    First, more than likely your MySQL host does not accept remote connections. Meaning they do not allow anything to connect outside of it's local network or on the same server. To test this, use

    Second, the prefix is the table prefix of your database table that you are connecting to. What PHP script are you trying to use AuthDB with?

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
    Last edited by a moderator: May 16, 2016
  6. Offline


    How do I enable it?
    The page you sent me to asked me for a password?

    "Could not connect to the server '99.xx.183.76'
    Lost connection to MySQL server at 'reading initial communication packet', system error: 111Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)"

    What do you mean PHP script?

    Im sorry :/
  7. Offline


    You don't have to enter a password there. I might customize the script some just to a simple remote check instead of full check

    Either way, your MySQL server doesn't accept remote connections. I am guessing your MySQL server is not on the same server as your Minecraft server?

    AuthDB is made to work with either a custom database you've setup just for it or another script or for use with a forum or CMS script like phpBB, Simple Machines Forum, or even the script you are talking to me on right now (XenForo). Are you trying to use AuthDB with a forum or anything?

    No need to be sorry, I'm here to answer questions. :)
  8. Offline


    Okay i found the "mysql-connector-java-bin" file. and moved it into my server folder. Is there a way to activate it to accept incoming traffic?

    How do i get and or set up a database?
  9. Offline


    First of all, do you have a MySQL database?
    If not, there is no way to use this plugin.
  10. Offline


    okay i went to this website and im downloading a mysql community server will that work?
  11. Offline


    Sounds like you might need something a little more simplistic. There are websites such as that offer free MySQL databases. You might be better off using something like that as it probably won't be a simple task for you to setup MySQL if you have no idea what you are doing.
  12. Offline


    Ive spent almost all day trying to get this to work, you guys should make a youtube video on how to set up a database with this MySQL

    I tryed that website but i kept getting errors.
  13. Offline


    Like I said, the easiest way for you is to use a free MySQL host like to make a free database to use with AuthDB. There are other free SQL providers around. We may be offering them sometime to donators even.

    It may be easier for you to just a purely offline, server-based auth plugin such as xAuth. As right now, AuthDB is mainly for connecting to forums and CMS script user databases.
  14. Offline


    I thinkkkkkk i did ittt :D
  15. Offline


    Did you create the MySQL database and table? ;)
    If you are not using a script, then you will need to do that and import or create the fields in the database table.

    You will also need to use this section in the config.yml:

    enabled: true
    table: authdb_users
    userfield: username
    passfield: password
    emailfield: email
    encryption: md5

    You can change the table and field settings to match what you make in the database.
    Here is a simple SQL file you can import into the database once you figure out how to do that:

    We will probably be adding an option to AuthDB to create a basic database table for use with customdb in an future version.
  16. Offline


    okay i looked for the longest time on how to import the .sql file you sent me but no luck.

    Is this the correct way to input the code?

    INSERT INTO mine VALUES (`id` int(4) auto_increment,);
    INSERT INTO mine VALUES (`username` varchar(40) NOT NULL,);
    INSERT INTO mine VALUES (`password` varchar(40) NOT NULL, );
    I would go ahead and try it but i dont want to input the wrong thing

    Here is the code from the file

    CREATE TABLE IF NOT EXISTS `authdb_users` (
    `id` int(4) NOT NULL auto_increment,
    `username` varchar(40) NOT NULL,
    `password` varchar(40) NOT NULL,
    `email` varchar(100) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `username` (`username`)

    Sorry i keep bugging you :(
  17. Offline


    You could use a GUI front-end tool such as HeidiSQL: to import the SQL file.
    Brett likes this.
  18. Offline


    Ok, It looks you're true. I did tests, and obviously plugins check the database at every connection. I tried to register on the website and connect in game without restarting the server, and it worked.

    But it's strange because two of my players (who haven't registered into the board before I put the plugin) couldn't connect ! They could not tell me what message they got. I restarted the server and it worked.

    Any Idea of where the problem is located ?
  19. Offline


    I tested my theory... and it seems that those players were probably in-game as guests when they registered on the website. I have found that players who are in-game and register on the website are not seen as registered users until the server is reloaded or restarted. This is odd... as a player who was not in-game on the server at the time they registered on the website are recognized and are able to login fine.

    We'll be looking into it more.
  20. Offline


    I think i found an Bug?!

    If a new player joins our Forum ( MyBB ) he is aktually a Guest on the Gameserver.
    Only if i reboot the Gameserver the user is set as an registered Player. There is no Database Update to the login plugin in realtime.
  21. Offline


    Someone mentioned this previously. Do you know if the player was in-game when he registered on the forum website?
  22. Offline


    haha atleast now if someone doesnt know how to do it they can read all the posts you and me posted.

    Thanks again
  23. Offline


    Hey ^^,
    I have a problem. I have the following important settings in config.yml:
       name: phpBB
       version: 3.0.8
       enabled: false
       force: true
       method: login
    But newly registered players can not login until the server gets restarted/the plugin is reloaded.
    Here some important log exerps:
    2011-04-03 17:29:28 [INFO] This server is running Craftbukkit version git-Bukkit-0.0.0-612-g4c7a9e7-b617jnks (MC: 1.4)
    2011-04-03 17:29:30 [INFO] [AuthDB] 3 user registrations in database
    2011-04-03 17:29:30 [INFO] [AuthDB] AuthDB plugin 2.1.3 is enabled
    2011-04-03 17:29:30 [INFO] [AuthDB] AuthDB is developed by CraftFire <[email protected]>
    Now some users had registered @ the forum but were not be able to login (It says: "You are not registered yet!".
    After the restart:
    2011-04-04 04:33:19 [INFO] This server is running Craftbukkit version git-Bukkit-0.0.0-612-g4c7a9e7-b617jnks (MC: 1.4)
    2011-04-04 04:33:22 [INFO] [AuthDB] 5 user registrations in database
    2011-04-04 04:33:22 [INFO] [AuthDB] AuthDB plugin 2.1.3 is enabled
    2011-04-04 04:33:22 [INFO] [AuthDB] AuthDB is developed by CraftFire <[email protected]>
    They can login.
  24. Offline


    Thanks for reporting :) Going to fix it for the next version!
  25. Offline


    Were those players on the server when they registered on the forums?
  26. Offline


    Hmm, I don't realy know, but I don't think so because they cant login an get kicked after 30s :)
    But if you want I can look it up @ the log files/database.

    edit: Oh I noticed that I am blind...... somebody else replied this bug already :D sry 4 penetrating you :D
  27. Offline


    It's fine, I was just curious as when I tested, that was the only time the problem happened. Silly I know.
  28. Offline


    I followed new registrations today. New players which are in game at the same time they registered on my forum are not updatet to the authorize plugin. like your theorie.

    best regards
  29. Offline


    Going to be fixed for the next version, seems to be something wrong with how I use the cache.
    Thanks for confirming!
  30. Offline


    Hey ! I'm back with a new bug report ! =P

    There is a problem with the spawn point for new players. I tested with and without your plugin. Without, they spawn at the normal spawn point. With, they appear in the air, near to the spawn point but some blocks around.

    It's very annoying because a made a room for newcomers.

    Hope you'll fix it ! (I'd love to help you programming this plugin, but I have no much time for now, and I'm a shit at java :p)
  31. Offline


    Thanks for this. I found an other bug. a few players are angry that inventorys are cleared after an server restart. without the authorize plugin everythink is fine.


Share This Page