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

    alfskan

    can't change password?

    couldn't find related command
     
  3. I didnt have a "commit" button. Logged in to check just what really showed and now I have it. Actually everything looks totaly different now than befoe. Strange. Prob something that went wrong with loading the page or something.

    Works now anyway :)
     
  4. Offline

    Wulfspider

    It's planned. It's a lot of work to add something for each script we support even if it's just one command.

    Glad you got it figured out. :)

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Jul 15, 2016
  5. That's why you get alot of kids and teach them to code early in life so that they can do it for you :p
     
  6. Have this been fixed so that the players inventory doesn't get viped from time to time? That was one prob with the dev.
     
  7. Offline

    Wulfspider

    We haven't encountered any inventory wipes yet so we have been unable to fix them. We will be testing more as we have time.
     
  8. Ok. Well. I'll give this a try again anyway :)

    One more question thought.
    I'm using wordpress and want to link it. It is possible, but the thing I wonder about is this:
    "# Encription type to use for password hashing. Options are MD5, SHA1, and SHA512."

    Wordpress uses phpass to encrypt the passwords. Så where to go here? :)
     
  9. Offline

    Wulfspider

    WordPress is supported natively. Just configure it as you would any other script in AuthDB.
     
  10. Yeah, noticed it worked. I forgot to save the config when I did the last change :p
    Sometimes it's nice when the solution is simple. :)
     
  11. Offline

    Black_Jack

    Users, that not registred on forum have access to server. So, they are playing and griefing, but didnt registred on forum.
    regisrter:
    force: true

    Yes, no linked name

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Feb 15, 2019
  12. Offline

    Wulfspider

    Are you sure they didn't use /link?
     
  13. Offline

    Black_Jack

    Yes, I'm sure

    If I ask them: Did you register on forum? They answer : No

    Register in-game also turned off
     
  14. Offline

    Wulfspider

    You have link disabled and have checked in your AuthDB.db using a database viewer such as Lita?
     
  15. Offline

    Evild67

    I have this error with AuthDB 2.3.2

    Caused by: java.sql.SQLException: Unsuccessfully waited [1000] millis for a conn
    ection to be returned. No connections are free. You need to Increase the max con
    nections of [20] or look for a connection pool leak using datasource.xxx.capture
    stacktrace=true
    at com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue._getPool
    edConnectionWaitLoop(PooledConnectionQueue.java:329)
    at com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue._getPool
    edConnection(PooledConnectionQueue.java:307)
    at com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue.getPoole
    dConnection(PooledConnectionQueue.java:247)
    at com.avaje.ebeaninternal.server.lib.sql.DataSourcePool.getPooledConnec
    tion(DataSourcePool.java:658)
    at com.avaje.ebeaninternal.server.lib.sql.DataSourcePool.getConnection(D
    ataSourcePool.java:646)
    at com.avaje.ebeaninternal.server.transaction.TransactionManager.createQ
    ueryTransaction(TransactionManager.java:339)
    ... 23 more

    I have changed from phpbb to Mybb but with the 2.2 nothing work with mybb 1.6.4 and with the 2.3.2 I have this error with phpbb and mybb.

    My MYSQL is by Verygames and my server too.

    Excuse me for my bad English I'm French.

    i
     
  16. Offline

    Wulfspider

    Set keepalive: false
     
  17. Offline

    Evild67

    It's already set to keepalive: false
     
  18. Offline

    Wulfspider

    I'm not sure what's causing it then without knowing how they are doing it.

    They your MySQL probably doesn't allow many connections. Is your server fairly big?

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

    Evild67

    I dont no. I must request verygames. The Support are Open Monday. I wait and then I tell you the answer from Verygames.

    But with phpbb and Auth 2.20 all work fine.

    I can juste say that I have 50Mb on my MYSQL server.
     
  20. Offline

    Wulfspider

    Could I see your bukkit.yml?
     
  21. Offline

    Evild67

    :confused: I delete my bukkit.yml en reload my server and it Work =) Thanks
     
  22. Offline

    Kiborgik

    when you update to 2.3.3? thank you
     
  23. Offline

    Wulfspider

    When we have time to get the issues fixed. ;)
     
  24. Offline

    Black_Jack

    I asked that people, how they are playing here. They answered: I'm connected to server but he requred register. Then I just reconnected and then just start plaing flawlessy.
    So, they just reconnect and AuthDB dont ask them for a login. Hmmm. Keepalive is false.

    Ye, and I see this sometime:
     
  25. Offline

    Kiborgik

    its a ping check from 1.8.1 client, when your server on server list
    --------------------------
    and problem like that (keeplive:false, max_connections on mysql 1000)
    Code:
    17.09 18:08:39 [Server] WARNING [AuthDB] Cannot connect to MySQL server on localhost!
    17.09 18:08:39 [Server] 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.
    also big lags when you try logon in nether

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

    Wulfspider

    Do you have sessions enabled? Could I see your advanced.yml? You are running 1.7.3 stuff still right?
     
  27. Offline

    WolwX

    Error here too :/

    Code:
    Could not pass event PLAYER_LOGIN to AuthDB
    javax.persistence.PersistenceException: ERROR executing DML bindLog[] error[[SQLITE_CONSTRAINT] Abort due to constraint violation (PRIMARY KEY must be unique)]
    Impossible to login :(
    It can't recognise the forum password (using smf script)

    That's was working with thoses settings some revision ago, and now I try with a 1.8 craftbukkit revision

    Any trick for this bug ?
     
  28. Offline

    Wulfspider

    A full log would be more useful. Also, what verison and build of AuthDB are you using?
     
  29. Offline

    WolwX

    :) thanks @Wulfspider

    My bug is I can't login, the plugin tell me I use a wrong password always and here are my informations =>

    [INFO] This server is running Craftbukkit version git-Bukkit-0.0.0-1037-g69a082f-b1139jnks (MC: 1.8.1)
    [INFO] [AuthDB] 2.3.2.220 is enabled

    Configuration :

    basic.yml
    Code:
    plugin:
      language:
        commands: French                              # Language you want to use for commands that matches a directory under translations.
        messages: French                              # Language you want to use for messages that matches a directory under translations.
      debugmode: false                                 # Enable/disable debugging mode and additional console output.
      usagestats: true                                 # Enable/disable usage stats reporting to CraftFire devs.
      logging: true                                    # Enable/disable logging to files.
      logformat: dd-MM-yyyy                           # Filename format of the AuthDB debug and error log files.
    database:
      type: mysql                                      # Database type/driver to use. Current options are MySQL and eBean (Bukkit persistence).
      host: localhost                                  # MySQL server hostname, domain, IP, or localhost for local connections. MySQL only.
      port: 3306                                       # Port used for connecting to your MySQL server. This is usually 3306. MySQL only.
      username: xxx                                   # Username used to connect to your database. Only valid for MySQL.
      password: xxx                                   # Password used to connect to your database. MySQL only.
      name: www-xxx                                      # Name of the database you are connecting to. MySQL only.
      keepalive: false                              # Enable/disable keeping database connection alive. Do not use if your connection limit is low. MySQL only.
    script:
      name: smf                                    # Name of the script you are using.
      version: 1.1.13                                   # Version of the script you are using.
      tableprefix: smf_                              # Database table prefix for the script, if you use one.
    advanced.yml

    Code:
    customdb:
      enabled: false                                   # Enable/disable custom database support. Leave this disabled if using a script such as phpBB.
      autocreate: true                                 # Enable/disable automatic creation of the database tables and columns for a custom database.
      table: authdb_users                              # Table name to use for your custom database.
      userfield: username                              # Field/column name to use for storing user names.
      passfield: password                              # Field/column name to use for storing user passwords.
      emailfield: email                                # Field/column name to use for storing user email addresses. Leave blank to disable email requirement.
      emailrequired: true                             # Enable/disable registration email requirement.
      encryption: md5                                  # Encription type to use for password hashing. Options are MD5, SHA1, and SHA512.
    #  saltfield: salt                                  # NOT IMPLEMENTED YET! Field/column name to use for storing the passwordsalt.
    #  hashformat: "{PASSWORD}{SALT}{NAME}"             # NOT IMPLEMENTED YET! Format/layout to use for the password hash.
    register:
      enabled: false                                    # Enable/disable allowing users to register.
      force: true                                      # Enable/disable forcing users to register.
      delay: 4 seconds                                 # Amount of time before register message is shown to player.
      timeout: 3 minutes                               # Amount of time a player has to register before the configured action is taken.
    login:
    #  enabled: true                                    # NOT IMPLEMENTED YET! Enable/disable players being able to login.
      method: prompt                                   # Login method to use. Options are normal and prompt.
      delay: 4 seconds                                 # Amount of time before login message is shown to player.
      timeout: 3 minutes                               # Amount of time a player has to login before the configured action is taken.
      tries: 3                                         # Number of allowed incorrect password tries.
      action: kick                                     # Action to perform when a maximum number of password tries is reached. Currently only option is kick.
    link:
      enabled: true                                    # Enable/disable username linking.
      rename: true                                     # Enable/disable renaming users to linked name on link.
    unlink:
      enabled: true                                    # Enable/disable username unlinking.
      rename: true                                     # Enable/disable renaming users to original name on unlink.
    username:
      minimum: 3                                       # Minimum number of characters a username can be.
      maximum: 16                                      # Maximum number of characters a username can be.
    password:
      minimum: 6                                       # Minimum number of characters a password can be.
      maximum: 16                                      # Maximum number of characters a password can be.
    session:
      enabled: true                                    # Enable/disable player sessions.
      start: login                                     # When to start the player's session. Options are login and logoff.
      length: 1 hour                                   # Length of the player's session. Can be any number of seconds, minutes, hours, or days.
      protect: true                                    # Enable/disable protecting player from being logged out from another location.
    guest:
      commands: true                                  # Enable/disable guest commands.
      chat: true                                      # Enable/disable guest chat.
      building: false                                  # Enable/disable guest building.
      destruction: false                               # Enable/disable guest destruction.
      movement: true                                  # Enable/disable guest movement.
      interactions: true                              # Enable/disable guest interactions with objects.
      inventory: false                                 # Enable/disable guest inventory usage.
      drop: false                                      # Enable/disable guest being able to drop items.
      pickup: false                                    # Enable/disable guest being able to pickup items.
      health: false                                    # Enable/disable guest getting hurt.
      pvp: false                                       # Enable/disable guest hurting players.
      mobtargeting: false                              # Enable/disable mobs targeting guest.
      mobdamage: false                                 # Enable/disable mob damage from guest.
    protection:
      freeze:
        enabled: true                                  # Enable/disable freezing players on join to prevent movement.
        delay: 2 seconds                               # Amount of time before players are frozen and unable to move.
      notify:
        enabled: true                                  # Enable/disable protection message being sent to player.
        delay: 3 seconds                               # Amount of time before protection message can be sent to player again.
    filter:
      action: kick                                     # Action to perform when a username matches the filter. Options are kick and rename.
      username: "`~!@#$%^&*()-=+{[]}|\\:;\"<,>.?/ "    # Characters and symbols to check for in usernames. We recommend leaving this as is.
      password: "$&\\\""                               # Characters and symbols to check for in passwords. We recommend leaving this as is.
      whitelist: Contex,Wulfspider                     # Usernames to exclude from username and password filtering.
    
    Debulog :

    Code:
    02:41:27 [INFO] [AuthDB] Launching function: toTicks(String time, String length) - seconds:4
    >
    02:41:27 [INFO] [AuthDB] Launching function: toSeconds(String time, String length) - seconds:10
    >
    02:41:27 [INFO] [AuthDB] Launching function: toTicks(String time, String length) - minutes:3
    >
    02:41:27 [INFO] [AuthDB] Launching function: toTicks(String time, String length) - seconds:4
    >
    02:41:27 [INFO] [AuthDB] Launching function: toSeconds(String time, String length) - seconds:10
    >
    02:41:27 [INFO] [AuthDB] Launching function: toTicks(String time, String length) - minutes:3
    >
    02:41:27 [INFO] [AuthDB] Launching function: toSeconds(String time, String length) - hour:1
    >
    02:41:27 [INFO] [AuthDB] Launching function: toSeconds(String time, String length) - seconds:2
    >
    02:41:27 [INFO] [AuthDB] Launching function: toSeconds(String time, String length) - seconds:3
    >
    02:41:27 [INFO] [AuthDB] Directory: English
    >
    02:41:27 [INFO] [AuthDB] Found 2 directories for messages
    >
    02:41:27 [INFO] [AuthDB] messages language set to French
    >
    02:41:27 [INFO] [AuthDB] Directory: English
    >
    02:41:27 [INFO] [AuthDB] Found 2 directories for commands
    >
    02:41:27 [INFO] [AuthDB] commands language set to French
    >
    02:41:27 [INFO] [AuthDB] Found supported plugin: Permissions 2.7.2
    >
    02:41:27 [INFO] [AuthDB] Server is running without CraftIRC.
    >
    02:41:27 [INFO] [AuthDB] Server is running without Backpack.
    >
    02:41:27 [INFO] [AuthDB] Server is running without BukkitContrib.
    >
    02:41:27 [INFO] [AuthDB] Server is running without Buildr.
    >
    02:41:27 [INFO] [AuthDB] Server is running without bPermissions.
    >
    02:41:27 [INFO] [AuthDB] Online mode: false
    >
    02:41:27 [INFO] [AuthDB] Database type in config: mysql
    >
    02:41:27 [INFO] [AuthDB] Database type set to MySQL
    >
    02:41:27 [INFO] [AuthDB] Connecting to MySQL....
    >
    02:41:27 [INFO] [AuthDB] Lauching function: connect()
    >
    02:41:27 [INFO] [AuthDB] MySQL: jdbc:mysql://localhost:3306/www-sexyminecraft
    >
    02:41:27 [INFO] [AuthDB] MySQL driver: mysql
    >
    02:41:27 [INFO] [AuthDB] MySQL username: xxxx
    >
    02:41:27 [INFO] [AuthDB] MySQL password: xxxx
    >
    02:41:27 [INFO] [AuthDB] MySQL host: localhost
    >
    02:41:27 [INFO] [AuthDB] MySQL port: 3306
    >
    02:41:27 [INFO] [AuthDB] MySQL database: www-xxxx
    >
    02:41:27 [INFO] [AuthDB] MySQL prefix: smf_
    >
    02:41:27 [INFO] [AuthDB] MySQL: jdbc:mysql://localhost:3306/www-xxx?user=xxx&password=xxx
    >
    02:41:27 [INFO] [AuthDB] Database type in config: mysql
    >
    02:41:27 [INFO] [AuthDB] Database type set to MySQL
    >
    02:41:27 [INFO] [AuthDB] Config version: 1.1.13
    >
    02:41:27 [INFO] [AuthDB] Version range: 1.1.1-1.1.13
    >
    02:41:27 [INFO] [AuthDB] Version range 1: 1.1.1
    >
    02:41:27 [INFO] [AuthDB] Version range 2: 1.1.13
    >
    02:41:27 [INFO] [AuthDB] Version checking PASSED at first check.
    >
    02:41:27 [INFO] [AuthDB] 280 user registrations in database
    >
    02:41:27 [INFO] [AuthDB] 2.3.2.220 is enabled
    >
    02:41:27 [INFO] [AuthDB] Debug is ENABLED, get ready for some heavy spam
    >
    02:41:27 [INFO] [AuthDB] developed by CraftFire
    >
    02:41:27 [INFO] [AuthDB] Preparing usage stats for submission.
    >
    02:41:27 [INFO] [AuthDB] Usage stats submission timeout is 4000 ms (4 seconds).
    >
    02:41:27 [INFO] [AuthDB] Attempting to submit usage stats.
    >
    02:41:27 [INFO] [AuthDB] Successfully sent usage stats to CraftFire.
    >
    Code:
    02:41:27 [INFO] Done (0.323s)! For help, type "help" or "?"
    >
    02:41:27 [INFO] 'spawn-protection' in server.properties has been moved to 'settings.spawn-radius' in bukkit.yml. I will move your config for you.
    >
    02:44:42 [INFO] [AuthDB] Database type in config: mysql
    >
    02:44:42 [INFO] [AuthDB] Database type set to MySQL
    >
    02:44:42 [INFO] [AuthDB] Connecting to MySQL....
    >
    02:44:42 [INFO] [AuthDB] Lauching function: connect()
    >
    02:44:42 [INFO] [AuthDB] MySQL: jdbc:mysql://localhost:3306/www-xxx
    >
    02:44:42 [INFO] [AuthDB] MySQL driver: mysql
    >
    02:44:42 [INFO] [AuthDB] MySQL username: xxx
    >
    02:44:42 [INFO] [AuthDB] MySQL password: xxx
    >
    02:44:42 [INFO] [AuthDB] MySQL host: localhost
    >
    02:44:42 [INFO] [AuthDB] MySQL port: 3306
    >
    02:44:42 [INFO] [AuthDB] MySQL database: www-xxx
    >
    02:44:42 [INFO] [AuthDB] MySQL prefix: smf_
    >
    02:44:42 [INFO] [AuthDB] MySQL: jdbc:mysql://localhost:3306/www-xxx?user=xxx&password=xxx
    >
    02:44:42 [INFO] [AuthDB] Database type in config: mysql
    >
    02:44:42 [INFO] [AuthDB] Database type set to MySQL
    >
    02:44:42 [INFO] [AuthDB] Config version: 1.1.13
    >
    02:44:42 [INFO] [AuthDB] Version range: 1.1.1-1.1.13
    >
    02:44:42 [INFO] [AuthDB] Version range 1: 1.1.1
    >
    02:44:42 [INFO] [AuthDB] Version range 2: 1.1.13
    >
    02:44:42 [INFO] [AuthDB] Version checking PASSED at first check.
    >
    02:44:42 [INFO] [AuthDB] Executing MySQL query: SELECT * FROM `smf_members` WHERE `memberName` = 'WolwX' LIMIT 1
    >
    02:44:42 [INFO] [AuthDB] Database type in config: mysql
    >
    02:44:42 [INFO] [AuthDB] Database type set to MySQL
    >
    02:44:42 [INFO] [AuthDB] Config version: 1.1.13
    >
    02:44:42 [INFO] [AuthDB] Version range: 1.1.1-1.1.13
    >
    02:44:42 [INFO] [AuthDB] Version range 1: 1.1.1
    >
    02:44:42 [INFO] [AuthDB] Version range 2: 1.1.13
    >
    02:44:42 [INFO] [AuthDB] Version checking PASSED at first check.
    >
    02:44:42 [INFO] [AuthDB] Executing MySQL query: SELECT `passwd` FROM `smf_members` WHERE `memberName` = 'WolwX' LIMIT 1
    >
    02:44:42 [INFO] [AuthDB] Database type in config: mysql
    >
    02:44:42 [INFO] [AuthDB] Database type set to MySQL
    >
    02:44:42 [INFO] [AuthDB] Config version: 1.1.13
    >
    02:44:42 [INFO] [AuthDB] Version range: 1.1.1-1.1.13
    >
    02:44:42 [INFO] [AuthDB] Version range 1: 1.1.1
    >
    02:44:42 [INFO] [AuthDB] Version range 2: 1.1.13
    >
    02:44:42 [INFO] [AuthDB] Version checking PASSED at first check.
    >
    02:44:42 [INFO] [AuthDB] Executing MySQL query: SELECT `passwordSalt` FROM `smf_members` WHERE `memberName` = 'WolwX' LIMIT 1
    >
    02:44:42 [INFO] [AuthDB] Database type in config: mysql
    >
    02:44:42 [INFO] [AuthDB] Database type set to MySQL
    >
    02:44:42 [INFO] [AuthDB] Closing MySQL connection....
    >
    02:44:42 [INFO] [AuthDB] Launching function: checkFilter(String what, String string) - `~!@#$%^&*()-=+{[]}|\:;"<,>.?/
    >
    02:44:42 [INFO] [AuthDB] WolwX does not have bad characters in his/her name.
    >
    02:44:42 [INFO] WolwX [/82.235.110.22:60531] logged in with entity id 225 at ([rebirth] 693.0625, 71.0, -63.40625)
    >
    02:44:42 [INFO] [AuthDB] Check to see if user is registered is needed, performing check
    >
    02:44:42 [INFO] [OKB3] [BRIDGE] WolwX's ranks synced.
    >
    02:44:42 [INFO] [AuthDB] Database type in config: mysql
    >
    02:44:42 [INFO] [AuthDB] Database type set to MySQL
    >
    02:44:42 [INFO] [OKB3] Updated WolwX's nickname to WolwX.
    >
    02:44:42 [INFO] [AuthDB] Connecting to MySQL....
    >
    02:44:42 [INFO] [AuthDB] Lauching function: connect()
    >
    02:44:42 [INFO] [AuthDB] MySQL: jdbc:mysql://localhost:3306/www-xxx
    >
    02:44:42 [INFO] [AuthDB] MySQL driver: mysql
    >
    02:44:42 [INFO] [AuthDB] MySQL username: xxx
    >
    02:44:42 [INFO] [AuthDB] MySQL password: xxx
    >
    02:44:42 [INFO] [AuthDB] MySQL host: localhost
    >
    02:44:42 [INFO] [AuthDB] MySQL port: 3306
    >
    02:44:42 [INFO] [AuthDB] MySQL database: www-sexyminecraft
    >
    02:44:42 [INFO] [AuthDB] MySQL prefix: smf_
    >
    02:44:42 [INFO] [AuthDB] MySQL: jdbc:mysql://localhost:3306/www-xxx?user=xxx&password=xxx
    >
    02:44:42 [INFO] [AuthDB] Database type in config: mysql
    >
    02:44:42 [INFO] [AuthDB] Database type set to MySQL
    >
    02:44:42 [INFO] [AuthDB] Config version: 1.1.13
    >
    02:44:42 [INFO] [AuthDB] Version range: 1.1.1-1.1.13
    >
    02:44:42 [INFO] [AuthDB] Version range 1: 1.1.1
    >
    02:44:42 [INFO] [AuthDB] Version range 2: 1.1.13
    >
    02:44:42 [INFO] [AuthDB] Version checking PASSED at first check.
    >
    02:44:42 [INFO] [AuthDB] Executing MySQL query: SELECT * FROM `smf_members` WHERE `memberName` = 'WolwX' LIMIT 1
    >
    02:44:42 [INFO] [AuthDB] Database type in config: mysql
    >
    02:44:42 [INFO] [AuthDB] Database type set to MySQL
    >
    02:44:42 [INFO] [AuthDB] Closing MySQL connection....
    >
    02:44:42 [INFO] [AuthDB] Login timeout time is: 3600 ticks.
    >
    02:44:42 [INFO] [AuthDB] Adding schedule ID to hashmap and persitence: 50
    >
    02:44:42 [INFO] [AuthDB] Database type in config: mysql
    >
    02:44:42 [INFO] [AuthDB] Database type set to MySQL
    >
    02:44:42 [INFO] [AuthDB] Connecting to MySQL....
    >
    02:44:42 [INFO] [AuthDB] Lauching function: connect()
    >
    02:44:42 [INFO] [AuthDB] MySQL: jdbc:mysql://localhost:3306/www-sexyminecraft
    >
    02:44:42 [INFO] [AuthDB] MySQL driver: mysql
    >
    02:44:42 [INFO] [AuthDB] MySQL username: xxx
    >
    02:44:42 [INFO] [AuthDB] MySQL password: xxx
    >
    02:44:42 [INFO] [AuthDB] MySQL host: localhost
    >
    02:44:42 [INFO] [AuthDB] MySQL port: 3306
    >
    02:44:42 [INFO] [AuthDB] MySQL database: www-xxx
    >
    02:44:42 [INFO] [AuthDB] MySQL prefix: smf_
    >
    02:44:42 [INFO] [AuthDB] MySQL: jdbc:mysql://localhost:3306/www-xxx?user=xxx&password=xxx
    >
    02:44:42 [INFO] [AuthDB] Database type in config: mysql
    >
    02:44:42 [INFO] [AuthDB] Database type set to MySQL
    >
    02:44:42 [INFO] [AuthDB] Config version: 1.1.13
    >
    02:44:42 [INFO] [AuthDB] Version range: 1.1.1-1.1.13
    >
    02:44:42 [INFO] [AuthDB] Version range 1: 1.1.1
    >
    02:44:42 [INFO] [AuthDB] Version range 2: 1.1.13
    >
    02:44:42 [INFO] [AuthDB] Version checking PASSED at first check.
    >
    02:44:42 [INFO] [AuthDB] Executing MySQL query: SELECT * FROM `smf_members` WHERE `memberName` = 'WolwX' LIMIT 1
    >
    02:44:42 [INFO] [AuthDB] Database type in config: mysql
    >
    02:44:42 [INFO] [AuthDB] Database type set to MySQL
    >
    02:44:42 [INFO] [AuthDB] Closing MySQL connection....
    >
    02:44:42 [INFO] [AuthDB] Sucessfully stored WolwX's inventory: 0:0:0:0,0:0:0:0,0:0:0:0,0:0:0:0,0:0:0:0,0:0:0:0,0:0:0:0,0:0:0:0,0:0:0:0,0:0:0:0,0:0:0:0,0:0:0:0,0:0:0:0,0:0:0:0,0:0:0:0,0:0:0:0,0:0:0:0,0:0:0:0,0:0:0:0,0:0:0:0,0:0:0:0,0:0:0:0,0:0:0:0,0:0:0:0,0:0:0:0,0:0:0:0,0:0:0:0,0:0:0:0,0:0:0:0,0:0:0:0,0:0:0:0,0:0:0:0,0:0:0:0,0:0:0:0,0:0:0:0,0:0:0:0,
    >
    02:44:42 [INFO] [AuthDB] Sucessfully stored WolwX's armor inventory: 0:0:0:-1,0:0:0:-1,0:0:0:-1,0:0:0:-1,
    >
    02:44:42 [INFO] [AuthDB] Launching function: replaceStrings(String string, Player player, String additional)
    >
    02:44:42 [INFO] [AuthDB] Took 0 seconds (1ms) to replace tags.
    >
    02:44:42 [INFO] [AuthDB] Took 0 seconds (2ms) to send a message.
    >
    02:44:42 [INFO] New max size: 484
    >
    02:44:42 [INFO] New max size: 784
    >
     
  30. Offline

    Wulfspider

    I meant the log that actually contains the error... and AuthDB version/build, not CraftBukkit.
     
  31. Offline

    WolwX

    Sorry I was editing with full informations

    And the full bug mentionned before don't come again into my server.log, but in case, here it's =>
    Code:
    2011-09-18 01:38:54 [SEVERE] Could not pass event PLAYER_LOGIN to AuthDB
    javax.persistence.PersistenceException: ERROR executing DML bindLog[] error[[SQLITE_CONSTRAINT]  Abort due to constraint violation (PRIMARY KEY must be unique)]
        at com.avaje.ebeaninternal.server.persist.dml.DmlBeanPersister.execute(DmlBeanPersister.java:116)
        at com.avaje.ebeaninternal.server.persist.dml.DmlBeanPersister.insert(DmlBeanPersister.java:76)
        at com.avaje.ebeaninternal.server.persist.DefaultPersistExecute.executeInsertBean(DefaultPersistExecute.java:91)
        at com.avaje.ebeaninternal.server.core.PersistRequestBean.executeNow(PersistRequestBean.java:527)
        at com.avaje.ebeaninternal.server.core.PersistRequestBean.executeOrQueue(PersistRequestBean.java:557)
        at com.avaje.ebeaninternal.server.persist.DefaultPersister.insert(DefaultPersister.java:404)
        at com.avaje.ebeaninternal.server.persist.DefaultPersister.saveVanillaInsert(DefaultPersister.java:377)
        at com.avaje.ebeaninternal.server.persist.DefaultPersister.saveVanillaRecurse(DefaultPersister.java:361)
        at com.avaje.ebeaninternal.server.persist.DefaultPersister.saveRecurse(DefaultPersister.java:308)
        at com.avaje.ebeaninternal.server.persist.DefaultPersister.save(DefaultPersister.java:282)
        at com.avaje.ebeaninternal.server.core.DefaultServer.save(DefaultServer.java:1577)
        at com.avaje.ebeaninternal.server.core.DefaultServer.save(DefaultServer.java:1567)
        at com.authdb.util.databases.EBean.save(EBean.java:81)
        at com.authdb.util.databases.EBean.sync(EBean.java:101)
        at com.authdb.util.databases.EBean.sync(EBean.java:85)
        at com.authdb.listeners.AuthDBPlayerListener.onPlayerLogin(AuthDBPlayerListener.java:68)
        at org.bukkit.plugin.java.JavaPluginLoader$13.execute(JavaPluginLoader.java:328)
        at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
        at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:338)
        at net.minecraft.server.ServerConfigurationManager.a(ServerConfigurationManager.java:195)
        at net.minecraft.server.NetLoginHandler.b(NetLoginHandler.java:83)
        at net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:75)
        at net.minecraft.server.Packet1Login.a(SourceFile:59)
        at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
        at net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:41)
        at net.minecraft.server.NetworkListenThread.a(SourceFile:94)
        at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:464)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:374)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:417)
    Caused by: java.sql.SQLException: [SQLITE_CONSTRAINT]  Abort due to constraint violation (PRIMARY KEY must be unique)
        at org.sqlite.DB.newSQLException(DB.java:383)
        at org.sqlite.DB.newSQLException(DB.java:387)
        at org.sqlite.DB.execute(DB.java:342)
        at org.sqlite.DB.executeUpdate(DB.java:363)
        at org.sqlite.PrepStmt.executeUpdate(PrepStmt.java:85)
        at com.avaje.ebeaninternal.server.lib.sql.ExtendedPreparedStatement.executeUpdate(ExtendedPreparedStatement.java:164)
        at com.avaje.ebeaninternal.server.type.DataBind.executeUpdate(DataBind.java:74)
        at com.avaje.ebeaninternal.server.persist.dml.InsertHandler.execute(InsertHandler.java:155)
        at com.avaje.ebeaninternal.server.persist.dml.DmlBeanPersister.execute(DmlBeanPersister.java:105)
        ... 28 more
    2011-09-18 01:38:54 [INFO] WolwX [/82.235.110.22:52172] logged in with entity id 158 at ([rebirth] 697.832473189416, 71.0, -66.87107754339495)
    
     

Share This Page