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

    AndyPandy89

    Hey, nice plugin :)

    Will this be compatible with MCBans?

    Andy
     
  3. Offline

    CraftFire

    There were plans to add an option to integrate with MCBans at some point.
     
  4. Offline

    AndyPandy89

    Alright, well if you decide to implement it, then I would be most grateful :)
     
  5. Offline

    algiuxas

    I don't know whether it is a bug or not, but whenever someone authenticates in my server, there is ~10 second delay before server actually responds. Like, when I type my password and hit enter I have to wait for at least 10 seconds before server actually tells if my password is correct or not.
    This started happening after I updated to RB 953. There was no delay at all before.
    My SQL server is hosted locally and is running well. Plugins are listed in my signature.
     
  6. Offline

    contex

    That is very odd, if the MySQL is located localy it should take less than a second to get the response from the database.
    I will see what I can test and maybe add an option to keep-alive the MySQL connection, which will cause less lagg. I will test some more with RB 953 and come back to you, thanks for reporting!
     
  7. Offline

    jeanpoivrot

    hello i can confirme the issue, 5 to 10sec delay.craftbukkit 953. local database - punbb 1.3.5
     
  8. Offline

    algiuxas

    What is even weirder, the mentioned issue sometimes completely randomly just goes away. Its like I login at 8 PM the delay is here, when I come back at 9 PM there is no delay at all.
     
  9. Offline

    Pim1234

  10. Offline

    Max Black

    I was curious if you would be willing to add a feature? Where I could specify if a column needed to have a value (with maybe a custom error message). I have email validation on the registration of my site, and to get around allowing them to login with a fake email, I set it so they would be added to one table, and when the email was verified, move them to the real table. This works ok, but it makes all my SQL require two selects (not exactly a good thing). If you could confirm if say the `email_vel` column is set to '1', and if not return a custom error message (say 'Email not validated'), and not let them login?
    Thanks,
    Max
     
  11. Offline

    CraftFire

    If anyone wants to play with or test the fixes and new features implemented in v2.3.0 so far, you can get the latest successful development build:

    Download latest successful dev JAR only.
    View the Changelog for a list a fixes and new features.

     
    lemachinbidule and Jan Tojnar like this.
  12. Offline

    nero0345

    Is it possible that authdb also works with the whitelist? So new users enters there?
     
  13. Offline

    Wulfspider

    You basically want it so that only players who have registered on your forum or CMS can enter the server?
    We are planning on adding an option that would only allow registered players to join the server. This would server as a whitelist and then you wouldn't need the other whitelist really.
     
  14. Offline

    Hrdkr

    I just checked the list of issues here but unfortunately did not found the one I mentioned in my post. Is it really planned? I suppose this is a major bug, cause it can reveal the last location of any registered player.
     
  15. Offline

    Brett

    can you guys set me up with a table that will work with mysql. i am running it through mysqlforfree.com
     
  16. Offline

    CraftFire

    Yes, it's called session protection and also setting temporary spawn coordinates of guests and registered players when they join before login. After login, they are moved to their original location. Both are optional. Looks like the coordinates option didn't get added to the changelog. I'll add it now as I think Contex added that in v2.3.0 already as we were talking about it, but I'll double check to make sure.
    MySQL tables can be automatically created in the dev builds of AuthDB v2.3.0.
    For AuthDB v2.2.0, you can use something like this:
    http://dl.dropbox.com/u/7446930/CraftFire/Plugins/AuthDB/authdb_users.sql
     
    Hrdkr likes this.
  17. Hey there is problem with Multicraft i have bought a server where multicraft is admin panel and authDB is resetting server every 50 sec (when i run it on my computer it was working) without any error. Can you repair that ?
     
  18. Offline

    CraftFire

    Logs would be useful if you have them.
    I'll test to see what I can figure out.
     
  19. Ok i have solved problem but have another (i don't know , probably it's plugin problem)
    Code:
    2011-07-07 08:53:56 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
    
    The last packet successfully received from the server was 40,000 milliseconds ago.  The last packet sent successfully to the server was 0 milliseconds ago.
    2011-07-07 08:53:56 [SEVERE] 	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-07-07 08:53:56 [SEVERE] 	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    2011-07-07 08:53:56 [SEVERE] 	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    2011-07-07 08:53:56 [SEVERE] 	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    2011-07-07 08:53:56 [SEVERE] 	at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-07-07 08:53:56 [SEVERE] 	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
    2011-07-07 08:53:56 [SEVERE] 	at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3082)
    2011-07-07 08:53:56 [SEVERE] 	at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2968)
    2011-07-07 08:53:56 [SEVERE] 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3516)
    2011-07-07 08:53:56 [SEVERE] 	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-07-07 08:53:56 [SEVERE] 	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-07-07 08:53:56 [SEVERE] 	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
    2011-07-07 08:53:56 [SEVERE] 	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
    2011-07-07 08:53:56 [SEVERE] 	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2273)
    2011-07-07 08:53:56 [SEVERE] 	at com.griefcraft.sql.PhysDB.resolveProtections(Unknown Source)
    2011-07-07 08:53:56 [SEVERE] 	at com.griefcraft.sql.PhysDB.loadProtections(Unknown Source)
    2011-07-07 08:53:56 [SEVERE] 	at com.griefcraft.modules.flag.MagnetModule$MagnetTask.run(Unknown Source)
    2011-07-07 08:53:56 [SEVERE] 	at org.bukkit.craftbukkit.scheduler.CraftScheduler.mainThreadHeartbeat(CraftScheduler.java:137)
    2011-07-07 08:53:56 [SEVERE] 	at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:438)
    2011-07-07 08:53:56 [SEVERE] 	at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:361)
    2011-07-07 08:53:56 [SEVERE] 	at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    2011-07-07 08:53:56 [SEVERE] Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
    2011-07-07 08:53:56 [SEVERE] 	at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2529)
    2011-07-07 08:53:56 [SEVERE] 	at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2979)
    2011-07-07 08:53:56 [SEVERE] 	... 14 more
    But my webpage is working very well ...

    I'm using IP's for that ...
    Edit: Maybe it's really problem with connection to database?
    Edit2: Now i'm getting connection with database problem in game..

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Sep 9, 2018
  20. Offline

    Wulfspider

    That typically means your MySQL host isn't allowing your server IP access to it. Basically denying remote access.
     
  21. But problem is it IS allowing connection.
     
  22. Offline

    Wulfspider

    Well, something is blocking it. Is the MySQL server on the same machine and are you connecting by localhost or IP?
     
  23. By ip My server game is on s7.csrv.pl and my forum is on minecampf.co.cc ...
     
  24. Offline

    Wulfspider

    Are you using the IP or hostname in the database settings of AuthDB's config.yml?

    Did you manually download the MySQL connector jar or are you using what is built into CraftBukkit?
    Also, are you sure you are using the correct port?

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Dec 28, 2018
  25. Yes i'm sure because yesterday it was working well, I have manually downloaded all connectors. Build is the newset #953
    Edit: if it's not problem with plugin i will try SPAM my host of forum ....
     
  26. Offline

    Wulfspider

    Then it's probably just a poor connection between each of your servers.
     
  27. Ok so my host need to kill me or i will DoS their ticket system :>
     
  28. Offline

    Wulfspider

    I would say ask them as that is typically the case of either remote access being denied, timeouts, and poor connections between servers.
     
  29. Offline

    jeanpoivrot

    can't be a issue with co.cc subdomain ? i hear those subdomain are sometime blocked because they are is used SO MUCH for spamming, phishing and other malicious activity, google have already removed .co.cc websites from there index.



    Any news about the delay problem for login ? sometime is 15sec, sometime it log instantly.
    thanks
     
  30. Offline

    Hrdkr

    One more suggestion, not so essential maybe. I've noticed that players have often mistyped the login sequence, e.g.
    Code:
    login 123456
    or
    Code:
    123456
    instead of
    Code:
    /login 123456
    so, the people on the server view the actual password of these newbies.
    In upcoming AuthDB release there are such features as 'unregister' and 'change password', so when the player mistypes in mentioned way it will need to very quickly change the password before somebody changes it for him.
    Suggestion is let AuthDB to check the very first message of the player, when he enters the server, and if it contains password of the player, but login sequence is not typed correctly, to alert this player and do not let this message to pass to the public chat.
     
  31. Offline

    CraftFire

    Sounds like a good idea. We'll look into it. :)

    Sounds like you have issues connecting to your MySQL server. The only delay is the delay between your game server and MySQL server and it's ability to process the query.

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

Share This Page