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

    CraftFire

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

    contex

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

    l104693

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

    sypheac

    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

    Wulfspider

    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 pastebin.com 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 http://craftfire.com/tools/mysql.

    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

    Brett

    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

    Wulfspider

    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

    Brett

    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

    contex

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

    Brett

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

    Wulfspider

    Sounds like you might need something a little more simplistic. There are websites such as www.freesql.org 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

    Brett


    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 http://www.mysql.com/

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

    Wulfspider

    http://www.youtube.com/watch?v=oylVvq-3Tfk
    http://dev.mysql.com/tech-resources/articles/mysql_intro.html
    http://www.youtube.com/results?search_query=mysql+server+installation
    https://github.com/contex/AuthDB/wiki/Configuration

    Like I said, the easiest way for you is to use a free MySQL host like www.freesql.org 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

    Brett

    I thinkkkkkk i did ittt :D
    [​IMG]
     
  15. Offline

    Wulfspider

    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:

    customdb:
    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:
    http://google.com/search?q=referral+links#/1zRXyen

    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

    Brett

    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`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

    http://pastebin.com/L2ZCWpEa

    Sorry i keep bugging you :(
     
  17. Offline

    Wulfspider

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

    sypheac

    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

    Wulfspider

    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

    soulreafer

    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

    Wulfspider

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

    Brett

    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

    GrillGuth

    Hey ^^,
    I have a problem. I have the following important settings in config.yml:
    Code:
    script:
       name: phpBB
       version: 3.0.8
    register:
       enabled: false
       force: true
    login:
       method: login
    But newly registered players can not login until the server gets restarted/the plugin is reloaded.
    Here some important log exerps:
    Code:
    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:
    Code:
    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

    contex

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

    Wulfspider

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

    GrillGuth

    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

    Wulfspider

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

    soulreafer

    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

    contex

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

    sypheac

    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

    soulreafer

    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.

    Thanks
     

Share This Page