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

    There's no connection to the database, and therefore AuthDB is not allowing any connections.
    Check the server log and AuthDB logs and see what they are saying.

    Post the results here.
     
  3. Offline

    OakyTree

    Yup, good to go. Thank you!
     
  4. Offline

    gorenova

    using 1.1-r6 craftbukkit. and your customdb.sql has some error like this;

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `username` (`username`)
    ) ENGINE' at line 6
     
  5. Offline

    contex

    Are you using AuthDB 2.3.6?
     
  6. Offline

    gevaarlijke9

    Hello
    I am pretty noob with this XD
    but i need /register plugin for 1.2.3
    and if i use this one in cant join my server stands thi :

    DISCONNECTET BY SERVER

    You cannot join when the server
    has no database connection.



    please help
     
  7. Offline

    contex

    There's no connection to the database, and therefore AuthDB is not allowing any connections.
    Enabled debugmode in basic.yml and check the server log and AuthDB logs and see what they are saying.

    Post the results here.
     
  8. Offline

    gevaarlijke9

    Debugmode is true.
    AuthDB Log : 2012/03/17 10:28:51 - Cannot connect to MySQL server on localhost!
    2012/03/17 10:28:51 - Access denied, check if the password/username is correct and that remote connection is enabled if the MySQL database is located on another host then your server.
     
  9. Offline

    doggon

    2012-03-17 11:30:57 [INFO] [AuthDB] Enabling AuthDB v2.3.7.243
    2012-03-17 11:30:57 [INFO] [AuthDB] Launching function: toTicks(String time, String length) - seconds:4
    2012-03-17 11:30:57 [INFO] [AuthDB] Launching function: toSeconds(String time, String length) - seconds:10
    2012-03-17 11:30:57 [INFO] [AuthDB] Launching function: toTicks(String time, String length) - minutes:3
    2012-03-17 11:30:57 [INFO] [AuthDB] Launching function: toTicks(String time, String length) - seconds:4
    2012-03-17 11:30:57 [INFO] [AuthDB] Launching function: toSeconds(String time, String length) - seconds:10
    2012-03-17 11:30:57 [INFO] [AuthDB] Launching function: toTicks(String time, String length) - minutes:3
    2012-03-17 11:30:57 [INFO] [AuthDB] Launching function: toSeconds(String time, String length) - hour:1
    2012-03-17 11:30:57 [INFO] [AuthDB] Launching function: toSeconds(String time, String length) - seconds:2
    2012-03-17 11:30:57 [INFO] [AuthDB] Launching function: toSeconds(String time, String length) - seconds:3
    2012-03-17 11:30:57 [INFO] [AuthDB] Directory: English
    2012-03-17 11:30:57 [INFO] [AuthDB] Found 1 directories for messages
    2012-03-17 11:30:57 [INFO] [AuthDB] messages language set to English
    2012-03-17 11:30:57 [INFO] [AuthDB] Directory: English
    2012-03-17 11:30:57 [INFO] [AuthDB] Found 1 directories for commands
    2012-03-17 11:30:57 [INFO] [AuthDB] commands language set to English
    2012-03-17 11:30:57 [INFO] [AuthDB] Server is running without Backpack.
    2012-03-17 11:30:57 [INFO] [AuthDB] Server is running without Buildr.
    2012-03-17 11:30:57 [INFO] [AuthDB] Server is running without bPermissions.
    2012-03-17 11:30:57 [INFO] [AuthDB] Online mode: false
    2012-03-17 11:30:57 [INFO] [AuthDB] Database type in config: mysql
    2012-03-17 11:30:57 [INFO] [AuthDB] Database type set to MySQL
    2012-03-17 11:30:57 [INFO] [AuthDB] Connecting to MySQL....
    2012-03-17 11:30:57 [INFO] [AuthDB] Lauching function: connect()
    2012-03-17 11:30:57 [INFO] [AuthDB] MySQL: jdbc:mysql://localhost:3306/authdb?jdbcCompliantTruncation=false
    2012-03-17 11:30:57 [INFO] [AuthDB] MySQL driver: mysql
    2012-03-17 11:30:57 [INFO] [AuthDB] MySQL username: root
    2012-03-17 11:30:57 [INFO] [AuthDB] MySQL password: root
    2012-03-17 11:30:57 [INFO] [AuthDB] MySQL host: localhost
    2012-03-17 11:30:57 [INFO] [AuthDB] MySQL port: 3306
    2012-03-17 11:30:57 [INFO] [AuthDB] MySQL database: authdb (i edited was root)
    2012-03-17 11:30:57 [INFO] [AuthDB] MySQL prefix: phpbb_
    2012-03-17 11:30:57 [INFO] [AuthDB] MySQL: jdbc:mysql://localhost:3306/authdb?jdbcCompliantTruncation=false?user=root&password=root
    2012-03-17 11:30:57 [WARNING] [AuthDB] MYSQL CANNOT CONNECT!!!
    2012-03-17 11:30:57 [INFO] [AuthDB] Launching function: replaceStrings(String string, Player player, String additional)
    2012-03-17 11:30:57 [INFO] [AuthDB] Took 0 seconds (3ms) to replace tags.
    2012-03-17 11:30:57 [INFO] [AuthDB] Took 0 seconds (6ms) to send a message.
    2012-03-17 11:30:57 [WARNING] [AuthDB]
    |-----------------------------------------------------------------------------|
    |--------------------------------AUTHDB WARNING-------------------------------|
    |-----------------------------------------------------------------------------|
    | STACKTRACE ERROR
    |-----------------------------------------------------------------------------|
    2012-03-17 11:30:57 [WARNING] [AuthDB] Class name: com.authdb.util.databases.MySQL
    2012-03-17 11:30:57 [WARNING] [AuthDB] File name: MySQL.java
    2012-03-17 11:30:57 [WARNING] [AuthDB] Function name: connect
    2012-03-17 11:30:57 [WARNING] [AuthDB] Error line: 128
    2012-03-17 11:30:57 [WARNING] [AuthDB] Check log file: plugins\AuthDB\logs\error\2012-03-17-error.log
    2012-03-17 11:30:58 [INFO] [AuthDB] Database type in config: mysql
    2012-03-17 11:30:58 [INFO] [AuthDB] Database type set to MySQL
    2012-03-17 11:30:58 [INFO] [AuthDB] 2.3.7.243 is enabled
    2012-03-17 11:30:58 [INFO] [AuthDB] Debug is ENABLED, get ready for some heavy spam
    2012-03-17 11:30:58 [INFO] [AuthDB] developed by CraftFire <[email protected]>
    2012-03-17 11:30:58 [INFO] [AuthDB] Preparing usage stats for submission.
    2012-03-17 11:30:58 [INFO] [AuthDB] Usage stats submission timeout is 4000 ms (4 seconds).
    2012-03-17 11:30:58 [INFO] [AuthDB] Attempting to submit usage stats.
    2012-03-17 11:30:58 [INFO] [AuthDB] Could not send usage stats to main server.

    This error don't let me join in my server. and write "You cannot join when the server
    has no database connection."
     
  10. Offline

    sharonna

    hi i just tested this plugin on craftbukkit-1.2.3-R0.2, it is working perfect love it.
    But i have one problem im using worldedit on bukkit and worldedit client mod CUI, but since i have this plugin the worldedit CUI marking ingame is not working anymore, meaning its invisible.
    Any solution for this ?
    I also tried Authme reloaded, with that its working, but i dont like the plugin, no session on loggoff, and im stuck in survival mode.
    thanks
     
  11. Offline

    djrazr

    AuthDB is still not workin 4 me....
    15:44:54 [SEVERE] Could not pass event PlayerQuitEvent to AuthDB
    org.bukkit.event.EventException
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:303)
    at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62)
    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:441)
    at net.minecraft.server.ServerConfigurationManager.disconnect(ServerConfigurationManager.java:181)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:784)
    at net.minecraft.server.NetworkManager.b(NetworkManager.java:234)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:116)
    at net.minecraft.server.NetworkListenThread.a(NetworkListenThread.java:78)
    at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:554)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:452)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:490)
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows but got [2]
    at com.avaje.ebeaninternal.server.core.DefaultServer.findUnique(DefaultServer.java:1242)
    at com.avaje.ebeaninternal.server.querydefn.DefaultOrmQuery.findUnique(DefaultOrmQuery.java:924)
    at com.avaje.ebeaninternal.util.DefaultExpressionList.findUnique(DefaultExpressionList.java:217)
    at com.authdb.util.databases.EBean.checkPlayer(EBean.java:57)
    at com.authdb.AuthDB.isRegistered(AuthDB.java:819)
    at com.authdb.listeners.AuthDBPlayerListener.checkGuest(AuthDBPlayerListener.java:527)
    at com.authdb.listeners.AuthDBPlayerListener.onPlayerQuit(AuthDBPlayerListener.java:266)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:301)
    ... 10 more
    >
    [/QUOTE]
    Spammin for hours....
     
  12. Offline

    contex

    Are you sure that user with the username root and password root has access to the database you're trying to connect to?

    Hmm, I haven't tried the WorldEdit client mod, I'll check it out.
    Does it not work after you login?

    Are you using AuthDB 2.3.6?

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Jul 15, 2016
  13. Offline

    Wulfspider

    As it says, it's unable to connect because either your username or password is wrong and/or remote access is not allowed. Nothing we can do about that as that is all on your end.
     
  14. Offline

    doggon

    Yea, really connect ok, but why i cannot login in to server??
     
  15. Offline

    djrazr

    Yep, +latest Beta of Bukkit.
     
  16. Offline

    sharonna

    Nope, doesnt work logged in either.
    thanks for checking it out.
     
  17. Offline

    contex

    Cause there is a protection for when there is no MySQL connection.
    You need to recheck the username and/or password in the basic.yml.
     
  18. Offline

    gevaarlijke9

    But what means that can u help me please ?
     
  19. Offline

    contex

    That is strange, could you turn debugmode to true and paste the output here?
     
  20. Offline

    Wulfspider

    That means, your MySQL server isn't allowing you to access it over the internet. If your server is hosted on the internet on a different server than your Minecraft server, then that is the reason. The other reason is that your password or username could be entered wrong/incorrect/invalid.
     
  21. Offline

    gevaarlijke9

    Can you help my ? :$
    i am really stupid with this :$
     
  22. Offline

    doggon

    Why in this plugin added MySQL? i hate this program becouse.How i install i cannot done. Configuration time MySQL dont install....REMOVE MySQL
     
  23. Offline

    djrazr

    I did that, and there was nothin in that log... Server just crashed... seems like its somethin different, but if i disable authdb it doesnt crash at all.... http://pastebin.com/UM0W346Y

    I think that i found a bug on player connect ... i get some "Could not pass
    event PlayerLoginEvent to AuthDB" exceptions caused by: javax.persistence.PersistenceException ... am not sure but i guess its the problem of people joining with underscores & the query for the name (log here: http://pastebin.com/wcWGzmXg)

    Is your mysql on the same machine as the mcserver? so take 127.0.0.1 as mysql adress... otherwise you have to ask your mysql provider to enable external access to the db / or if you are hosting the mysqlserver yourself, set the allowed hosts in your mysqluserdb to "%".

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Jul 15, 2016
  24. Offline

    gevaarlijke9

    heyy
    i dont understand u like i said i am really stupid with this :/
    u got skype / Team viewer ? :$
     
  25. Offline

    contex

    The idea with AuthDB was to allow people to use authetnication against a script (CMS/Forum), which is why MySQL is required. However, with the rewrite we're allowing a local storage, instead of MySQL.

    That does indeed look like an old error code, could you show me the log from when you are launching the server (it should show the AuthDB version).

    Feel free to add me on Skype: contexmoh
    I'll try to help you out.

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Jul 15, 2016
    Wulfspider likes this.
  26. Offline

    djrazr

    19:25:29 [INFO] [AuthDB] 2.3.6.242 is enabled
    I tested that again, it IS a problem with underscores...​
     
  27. Offline

    IOn Vash

    this needs to be fixed

    Code:
    2012-03-18 15:18:47 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-18 15:18:47 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-18 15:18:47 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-18 15:18:47 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-18 15:18:47 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-18 15:18:47 [SEVERE] Could not pass event PlayerInteractEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-18 15:18:47 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-18 15:18:47 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-18 15:18:47 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-18 15:18:47 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    
    This keeps spamming my console and lagging the server it needs to be fixed.
     
  28. Offline

    Wulfspider

    It's been fixed for the last few released versions. Simply update to the latest. ;)
     
  29. Offline

    IOn Vash

    i just updated like 10 minutes ago and have tried updating every day it still keeps doing it.

    Also if i use the /reload command it wont let anyone join it says. "you cannot join when the server has no database connection" to everyone.
     
  30. is there a way to put up a maximum of registers/IP?
     
  31. Offline

    vitaxa

    I have this error at any random moment

    Code:
    [WARNING] [AuthDB] Cannot connect to MySQL server on triniti.ru-hoster.com!
     
    [WARNING] [AuthDB] Access denied, check if the password/username is correct and that remote connection is enabled if the MySQL database is located on another host then your server.
     
    [INFO] ?database connection failed! Access is denied! Contact admin.
    
     

Share This Page