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

    Jan Tojnar

    I have another error for you:
    bukkit 1066, authdb 2.3.0.176
    Code:
    2011/08/30 23:36:27 - --------------------------- STACKTRACE ERROR ---------------------------
    2011/08/30 23:36:27 - Class name: com.authdb.AuthDB
    2011/08/30 23:36:27 - File name: AuthDB.java
    2011/08/30 23:36:27 - Function name: onEnable
    2011/08/30 23:36:27 - Error line: 321
    2011/08/30 23:36:27 - --------------------------- STACKTRACE START ---------------------------
    2011/08/30 23:36:27 - sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011/08/30 23:36:27 - sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    2011/08/30 23:36:27 - sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    2011/08/30 23:36:27 - java.lang.reflect.Constructor.newInstance(Constructor.java:532)
    2011/08/30 23:36:27 - com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011/08/30 23:36:27 - com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011/08/30 23:36:27 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011/08/30 23:36:27 - com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011/08/30 23:36:27 - com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011/08/30 23:36:27 - com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011/08/30 23:36:27 - com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011/08/30 23:36:27 - com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
    2011/08/30 23:36:27 - com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
    2011/08/30 23:36:27 - com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2273)
    2011/08/30 23:36:27 - com.authdb.util.Util.checkScript(Util.java:625)
    2011/08/30 23:36:27 - com.authdb.AuthDB.onEnable(AuthDB.java:281)
    2011/08/30 23:36:27 - org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:126)
    2011/08/30 23:36:27 - org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:885)
    2011/08/30 23:36:27 - org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:278)
    2011/08/30 23:36:27 - org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:178)
    2011/08/30 23:36:27 - org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:161)
    2011/08/30 23:36:27 - net.minecraft.server.MinecraftServer.e(MinecraftServer.java:286)
    2011/08/30 23:36:27 - net.minecraft.server.MinecraftServer.a(MinecraftServer.java:273)
    2011/08/30 23:36:27 - net.minecraft.server.MinecraftServer.init(MinecraftServer.java:149)
    2011/08/30 23:36:27 - net.minecraft.server.MinecraftServer.run(MinecraftServer.java:337)
    2011/08/30 23:36:27 - net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    2011/08/30 23:36:27 - ---------------------------- STACKTRACE END ----------------------------
    
    plus tons of these after login:
    Code:
    23:43:29 [SEVERE] Could not pass event PLAYER_MOVE to AuthDB
    javax.persistence.PersistenceException: java.sql.SQLException: Unsuccessfully waited [1000] millis for a connection to be returned. No connections are free. Y
    ou need to Increase the max connections of [20] or look for a connection pool leak using datasource.xxx.capturestacktrace=true
            at com.avaje.ebeaninternal.server.transaction.TransactionManager.createQueryTransaction(TransactionManager.java:356)
            at com.avaje.ebeaninternal.server.core.DefaultServer.createQueryTransaction(DefaultServer.java:2021)
            at com.avaje.ebeaninternal.server.core.OrmQueryRequest.initTransIfRequired(OrmQueryRequest.java:241)
            at com.avaje.ebeaninternal.server.core.DefaultServer.findList(DefaultServer.java:1468)
            at com.avaje.ebeaninternal.server.core.DefaultServer.findUnique(DefaultServer.java:1236)
            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:67)
            at com.authdb.util.databases.EBean.find(EBean.java:173)
            at com.authdb.AuthDB.isAuthorized(AuthDB.java:594)
            at com.authdb.listeners.AuthDBPlayerListener.onPlayerMove(AuthDBPlayerListener.java:428)
            at org.bukkit.plugin.java.JavaPluginLoader$7.execute(JavaPluginLoader.java:286)
            at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
            at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:338)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:174)
            at org.getspout.spout.SpoutNetServerHandler.a(SpoutNetServerHandler.java:592)
            at net.minecraft.server.Packet10Flying.a(SourceFile:126)
            at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:89)
            at org.getspout.spout.SpoutNetServerHandler.a(SpoutNetServerHandler.java:478)
            at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
            at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:453)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    Caused by: java.sql.SQLException: Unsuccessfully waited [1000] millis for a connection to be returned. No connections are free. You need to Increase the max connections of [20] or look for a connection pool leak using datasource.xxx.capturestacktrace=true
            at com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue._getPooledConnectionWaitLoop(PooledConnectionQueue.java:329)
            at com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue._getPooledConnection(PooledConnectionQueue.java:307)
            at com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue.getPooledConnection(PooledConnectionQueue.java:247)
            at com.avaje.ebeaninternal.server.lib.sql.DataSourcePool.getPooledConnection(DataSourcePool.java:658)
            at com.avaje.ebeaninternal.server.lib.sql.DataSourcePool.getConnection(DataSourcePool.java:646)
            at com.avaje.ebeaninternal.server.transaction.TransactionManager.createQueryTransaction(TransactionManager.java:339)
            ... 23 more
    
    I deleted authdb.db file or such, i have only tons of yml files (because they are renamed in every version) but error persists, i have craftbukkit 1060, i mistyped first time
    config/basic.yml (open)

    Code:
    plugin:
    
      language: Czech                                # Language you want to use 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: yyyy-MM-dd                            # 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: root                                   # Username used to connect to your database. Only valid for MySQL.
    
      password: mysecretpassword                                   # Password used to connect to your database. MySQL only.
    
      name: minecraft                                      # Name of the database you are connecting to. MySQL only.
    
      keepalive: true                                  # Enable/disable keeping database connection alive. MySQL only.
    
    script:
    
      name: phpBB                                      # Name of the script you are using.
    
      version: 3.0.8                                   # Version of the script you are using.
    
      tableprefix: phpbb_                              # Database table prefix for the script, if you use one.
    
    #  passwordsalt:                                    # NOT IMPLEMENTED YET! Unique/custom password salt, if needed by the script.
    

    config/advanced.yml (open)

    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: 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: sha1                                  # 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: true                                    # 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 playerh as 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 messaage 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                                       # Minumum number of characters a username can be.
      maximum: 16                                      # Maximum number of characters a username can be.
    password:
      minimum: 6                                       # Minumum 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: logoff                                     # When to start the player's session. Options are login and logoff.
      length: 5 minutes                                    # 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: false                                  # Enable/disable guest commands.
      chat: false                                      # Enable/disable guest chat.
      building: false                                  # Enable/disable guest building.
      destruction: false                               # Enable/disable guest destruction.
      movement: false                                  # Enable/disable guest movement.
      interactions: false                              # 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.
    


    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Nov 10, 2018
  3. Offline

    Wulfspider

    Did you try one of the other builds I linked?

    http://ci.getspout.org/job/AuthDB/178/artifact/target/authdb-dev-SNAPSHOT.jar
    perhaps that?

    Try setting keepalive: false under basic.yml.

    With the issue of it now showing all of the register message, that is probably from a conflicting plugin for client mod that modifies the chat. I'd have to see a plugin list and such.

    Regarding the username, you said you are using phpBB 3.0.9? If your username is Curthiany in the game and in phpBB, then the dev build that I linked should work.

    Could you this build and see if it works? Make sure you do not have AuthDB.jar and authdb-dev-SNAPSHOT.jar in your plugins; just one.
    http://ci.craftfire.com/job/AuthDB/180/artifact/target/authdb-dev-SNAPSHOT.jar

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Nov 10, 2018
  4. Offline

    Jan Tojnar

  5. Offline

    Wulfspider

    We split the config so that users wouldn't have to worry about the advanced options unless they really didn't want defaults for something. Most people would be using the script and language options under basic.yml.
     
  6. Offline

    Jan Tojnar

    Do you have al least little idea by what it could be caused by? I should go sleep so i will try to solve this tomorrow.
     
  7. Offline

    Wulfspider

    Code:
    javax.persistence.PersistenceException: java.sql.SQLException: Unsuccessfully waited [1000] millis for a connection to be returned. No connections are free. You need to Increase the max connections of [20] or look for a connection pool leak using datasource.xxx.capturestacktrace=trueat com.avaje.ebeaninternal.server.transaction.TransactionManager.createQueryTransaction(TransactionManager.java:356)
    This is our first time using eBean, so we are not sure what every little message is that it spits out. We are trying to figure it all out and get them resolved.
     
  8. Offline

    Curthiany

    My Username As Exactly Says Even in Mysql is Curthiany

    ok well only my account works.... all the other groups do not work they have the same problem i have and they have permission - 'authdb.command.user.*'

    Edit: Now It Just Stopped Working Again.... Everytime i Run it The First Time its fine until i restart it just stops working -_-

    Edit 2: Errors i Get From The Error Log
    Code:
    2011/08/30 21:17:26 - --------------------------- STACKTRACE ERROR ---------------------------
    2011/08/30 21:17:26 - Class name: com.authdb.AuthDB
    2011/08/30 21:17:26 - File name: AuthDB.java
    2011/08/30 21:17:26 - Function name: isRegistered
    2011/08/30 21:17:26 - Error line: 836
    2011/08/30 21:17:26 - --------------------------- STACKTRACE START ---------------------------
    2011/08/30 21:17:26 - sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011/08/30 21:17:26 - sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011/08/30 21:17:26 - sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011/08/30 21:17:26 - java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011/08/30 21:17:26 - com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011/08/30 21:17:26 - com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011/08/30 21:17:26 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
    2011/08/30 21:17:26 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
    2011/08/30 21:17:26 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
    2011/08/30 21:17:26 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
    2011/08/30 21:17:26 - com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.java:1213)
    2011/08/30 21:17:26 - com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1200)
    2011/08/30 21:17:26 - com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2485)
    2011/08/30 21:17:26 - com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2467)
    2011/08/30 21:17:26 - com.authdb.util.databases.MySQL.getfromtable(MySQL.java:213)
    2011/08/30 21:17:26 - com.authdb.util.Util.checkScript(Util.java:613)
    2011/08/30 21:17:26 - com.authdb.AuthDB.isRegistered(AuthDB.java:824)
    2011/08/30 21:17:26 - com.authdb.listeners.AuthDBPlayerListener.onPlayerQuit(AuthDBPlayerListener.java:271)
    2011/08/30 21:17:26 - org.bukkit.plugin.java.JavaPluginLoader$2.execute(JavaPluginLoader.java:251)
    2011/08/30 21:17:26 - org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
    2011/08/30 21:17:26 - org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:338)
    2011/08/30 21:17:26 - net.minecraft.server.ServerConfigurationManager.disconnect(ServerConfigurationManager.java:146)
    2011/08/30 21:17:26 - net.minecraft.server.NetServerHandler.a(NetServerHandler.java:628)
    2011/08/30 21:17:26 - net.minecraft.server.NetworkManager.b(NetworkManager.java:231)
    2011/08/30 21:17:26 - net.minecraft.server.NetServerHandler.a(NetServerHandler.java:89)
    2011/08/30 21:17:26 - net.minecraft.server.NetworkListenThread.a(SourceFile:105)
    2011/08/30 21:17:26 - net.minecraft.server.MinecraftServer.h(MinecraftServer.java:454)
    2011/08/30 21:17:26 - net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
    2011/08/30 21:17:26 - net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    2011/08/30 21:17:26 - ---------------------------- STACKTRACE END ----------------------------
    2011/08/30 21:17:27 - --------------------------- STACKTRACE ERROR ---------------------------
    2011/08/30 21:17:27 - Class name: com.authdb.AuthDB
    2011/08/30 21:17:27 - File name: AuthDB.java
    2011/08/30 21:17:27 - Function name: isRegistered
    2011/08/30 21:17:27 - Error line: 836
    2011/08/30 21:17:27 - --------------------------- STACKTRACE START ---------------------------
    2011/08/30 21:17:27 - sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011/08/30 21:17:27 - sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011/08/30 21:17:27 - sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011/08/30 21:17:27 - java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011/08/30 21:17:27 - com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011/08/30 21:17:27 - com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011/08/30 21:17:27 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
    2011/08/30 21:17:27 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
    2011/08/30 21:17:27 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
    2011/08/30 21:17:27 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
    2011/08/30 21:17:27 - com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.java:1213)
    2011/08/30 21:17:27 - com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1200)
    2011/08/30 21:17:27 - com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2485)
    2011/08/30 21:17:27 - com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2467)
    2011/08/30 21:17:27 - com.authdb.util.databases.MySQL.getfromtable(MySQL.java:213)
    2011/08/30 21:17:27 - com.authdb.util.Util.checkScript(Util.java:613)
    2011/08/30 21:17:27 - com.authdb.AuthDB.isRegistered(AuthDB.java:824)
    2011/08/30 21:17:27 - com.authdb.listeners.AuthDBPlayerListener.onPlayerQuit(AuthDBPlayerListener.java:271)
    2011/08/30 21:17:27 - org.bukkit.plugin.java.JavaPluginLoader$2.execute(JavaPluginLoader.java:251)
    2011/08/30 21:17:27 - org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
    2011/08/30 21:17:27 - org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:338)
    2011/08/30 21:17:27 - net.minecraft.server.ServerConfigurationManager.disconnect(ServerConfigurationManager.java:146)
    2011/08/30 21:17:27 - net.minecraft.server.NetServerHandler.a(NetServerHandler.java:628)
    2011/08/30 21:17:27 - net.minecraft.server.NetworkManager.b(NetworkManager.java:231)
    2011/08/30 21:17:27 - net.minecraft.server.NetServerHandler.a(NetServerHandler.java:89)
    2011/08/30 21:17:27 - net.minecraft.server.NetworkListenThread.a(SourceFile:105)
    2011/08/30 21:17:27 - net.minecraft.server.MinecraftServer.h(MinecraftServer.java:454)
    2011/08/30 21:17:27 - net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
    2011/08/30 21:17:27 - net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    2011/08/30 21:17:27 - ---------------------------- STACKTRACE END ----------------------------
    Plugins:
    Permissions 3.1.6
    AuthDB Dev Build 180
    IChat For Permissions 3.1.6. also tried it without IChat and doesnt work

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

    Jokaru

    i have a stupid question, but pls answer me. If player lost password how to change or delete his pass?
     
  10. Offline

    Boon Pek

    This plugin is excellent, though I'm waiting for more features to be added.

    My server links to a database on an external server, located about halfway across the globe :p

    Is there a way to cache the user data into a AuthDB's database as to minimise lag, and have a command that will allow recaching the usernames?

    Thanks!
     
  11. Offline

    contex

    We are using cache. Once a player prepare to join the server we sync them with the MySQL (newest password/salt). So when a player enters their password it will check the Ebean database (local cache) first for the password, if the password is wrong AuthDB will check if the MySQL has a newer/different password. If it does, it syncs the newest password. If it doesnt it returns the player the "Wrong password" message.
     
  12. Offline

    RockIsLife

    Build #180
    The problem is relevant
    Code:
    2011-08-31 10:28:50 [INFO] [AuthDB] 3410 user registrations in database
    2011-08-31 10:28:50 [INFO] [AuthDB] AuthDB plugin 2.3.1.180 is enabled
    2011-08-31 10:28:50 [INFO] [AuthDB] AuthDB is developed by CraftFire <[email protected]>
    2011-08-31 10:28:51 [INFO] Server permissions file permissions.yml is empty, ignoring it
    2011-08-31 10:28:51 [INFO] Done (0.121s)! For help, type "help" or "?"
    2011-08-31 10:28:58 [INFO] RockIsLife [/***.***.***.***:2998] logged in with entity id 26 at ([world] 475.1875, 121.0, -2229.0625)
    2011-08-31 10:29:03 [WARNING] [AuthDB]
    |-----------------------------------------------------------------------------|
    |--------------------------------AUTHDB WARNING-------------------------------|
    |-----------------------------------------------------------------------------|
    | STACKTRACE ERROR
    |-----------------------------------------------------------------------------|
    2011-08-31 10:29:03 [WARNING] [AuthDB] Class name: com.authdb.AuthDB
    2011-08-31 10:29:03 [WARNING] [AuthDB] File name: AuthDB.java
    2011-08-31 10:29:03 [WARNING] [AuthDB] Function name: checkPassword
    2011-08-31 10:29:03 [WARNING] [AuthDB] Error line: 621
    2011-08-31 10:29:03 [WARNING] [AuthDB] Check log file: plugins/AuthDB\logs\error\2011-08-31-error.log
    2011-08-31 10:29:03 [WARNING] [AuthDB]
    |-----------------------------------------------------------------------------|
    |--------------------------------AUTHDB WARNING-------------------------------|
    |-----------------------------------------------------------------------------|
    | ERROR IN CHECKING PASSWORD. PLUGIN WILL NOT WORK. DISABLING IT.
    |-----------------------------------------------------------------------------|
    2011-08-31 10:29:03 [INFO] [AuthDB] AuthDB plugin 2.3.1.180 has been disabled
    2011-08-31 10:29:03 [WARNING] [AuthDB]
    |-----------------------------------------------------------------------------|
    |--------------------------------AUTHDB WARNING-------------------------------|
    |-----------------------------------------------------------------------------|
    | STACKTRACE ERROR
    |-----------------------------------------------------------------------------|
    2011-08-31 10:29:03 [WARNING] [AuthDB] Class name: com.authdb.AuthDB
    2011-08-31 10:29:03 [WARNING] [AuthDB] File name: AuthDB.java
    2011-08-31 10:29:03 [WARNING] [AuthDB] Function name: isRegistered
    2011-08-31 10:29:03 [WARNING] [AuthDB] Error line: 836
    2011-08-31 10:29:03 [WARNING] [AuthDB] Check log file: plugins/AuthDB\logs\error\2011-08-31-error.log
    2011-08-31 10:29:03 [WARNING] [AuthDB]
    |-----------------------------------------------------------------------------|
    |--------------------------------AUTHDB WARNING-------------------------------|
    |-----------------------------------------------------------------------------|
    | ERRORS IN CHECKING USER. PLUGIN WILL NOT WORK. DISABLING IT.
    |-----------------------------------------------------------------------------|
    2011-08-31 10:29:03 [WARNING] [AuthDB]
    |-----------------------------------------------------------------------------|
    |--------------------------------AUTHDB WARNING-------------------------------|
    |-----------------------------------------------------------------------------|
    | STACKTRACE ERROR
    |-----------------------------------------------------------------------------|
    2011-08-31 10:29:03 [WARNING] [AuthDB] Class name: com.authdb.AuthDB
    2011-08-31 10:29:03 [WARNING] [AuthDB] File name: AuthDB.java
    2011-08-31 10:29:03 [WARNING] [AuthDB] Function name: isRegistered
    2011-08-31 10:29:03 [WARNING] [AuthDB] Error line: 836
    2011-08-31 10:29:03 [WARNING] [AuthDB] Check log file: plugins/AuthDB\logs\error\2011-08-31-error.log
    2011-08-31 10:29:03 [WARNING] [AuthDB]
    |-----------------------------------------------------------------------------|
    |--------------------------------AUTHDB WARNING-------------------------------|
    |-----------------------------------------------------------------------------|
    | ERRORS IN CHECKING USER. PLUGIN WILL NOT WORK. DISABLING IT.
    |-----------------------------------------------------------------------------|
    
     

    Attached Files:

  13. Offline

    contex

    It seems to be an error with IPB, I will look at it in lunch time, could be that its looking for the wrong fields in MySQL or something more advanced.
     
  14. Offline

    Wulfspider

    Right now there is no way with customdb. If you are using a script, change it on the site or let them change it on the CMS/forum. We will be adding commands for changing emails and passwords soon.
     
    Jokaru likes this.
  15. Offline

    contex

    Which IPB do you have installed and what version did you set in the config?
     
  16. Offline

    RockIsLife

    2.2 worked fine :oops:
     
  17. Offline

    Jokaru

  18. Offline

    contex

    Which IPB do you have installed and what is the script version set to in the config?

    Yes, but Spout added new functions so i wanted to get 2.3.0 out first. Spout GUI will be in the 2.4.0 version of AuthDB.

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Oct 10, 2018
  19. Offline

    Curthiany

    So is there a Fix or going to have a fix for my problem??

    Not to Critisize or anything but i just wanted a fix for the authdb player move thats spamming my console everytime someone logs on .... v2.2 works properly and how i want it to be but that player move is lagging up people who enters the game...... please i really need help on making this work
     
  20. Offline

    RockIsLife

    Code:
    plugin:
      language: Russian                                # Language you want to use 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: yyyy-MM-dd                            # 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: *******                                   # Username used to connect to your database. Only valid for MySQL.
      password: *******                                 # Password used to connect to your database. MySQL only.
      name: ********                                      # Name of the database you are connecting to. MySQL only.
      keepalive: true                                  # Enable/disable keeping database connection alive. MySQL only.
    script:
      name: ipb                                      # Name of the script you are using.
      version: 3.1.4                                  # Version of the script you are using.
      tableprefix:                              # Database table prefix for the script, if you use one.
    #  passwordsalt:                                    # NOT IMPLEMENTED YET! Unique/custom password salt, if needed by the script.
    
     
  21. Offline

    Jan Tojnar

    No change
    BTW in debug mode:
    Code:
    10:52:38 [INFO] [AuthDB] Server is running without BukkitContrib.
    It is spout now and i am running it

    EDIT: I forgot to set customdb to true it is working now
     
  22. Offline

    Boon Pek

    Is there a way to make the "Password accepted! Welcome!" message appear immediately after a successful login as opposed to waiting a long time?

    Also, did I not see a Spout GUI sometime ago?
     
  23. Offline

    RockIsLife

    keepalive: false
    Climbs just that. But the plugin is not disabled. Only errors in theconsole spam.
    Code:
    13:15:30 [WARNING] [AuthDB]
    |-----------------------------------------------------------------------------|
    |--------------------------------AUTHDB WARNING-------------------------------|
    |-----------------------------------------------------------------------------|
    | STACKTRACE ERROR
    |-----------------------------------------------------------------------------|
    13:15:30 [WARNING] [AuthDB] Class name: com.authdb.AuthDB
    13:15:30 [WARNING] [AuthDB] File name: AuthDB.java
    13:15:30 [WARNING] [AuthDB] Function name: checkPassword
    13:15:30 [WARNING] [AuthDB] Error line: 621
    13:15:30 [WARNING] [AuthDB] Check log file: plugins/AuthDB\logs\error\2011-08-31-error.log
    13:15:30 [WARNING] [AuthDB]
    |-----------------------------------------------------------------------------|
    |--------------------------------AUTHDB WARNING-------------------------------|
    |-----------------------------------------------------------------------------|
    | ERROR IN CHECKING PASSWORD. PLUGIN WILL NOT WORK. DISABLING IT.
    |-----------------------------------------------------------------------------|
    
     
  24. Offline

    Boon Pek

    Oh, nice ;) is it in the dev-builds (specifically, #180) by any chance? :p

    Also, I'd love an immediate "Password accepted!" message. Possible? :)

    There seems to be a problem with movement protection; sometimes the player would be teleported slightly higher and repeatedly fall instead of remaining on the ground.
     
  25. Offline

    contex

    What script version are you running? We know that 3.2.x has a different table schema and we are working on adding it to 2.3.1.

    We will add it in 2.4.0, the current dev builds are for 2.3.1 (just some quick fixes for 2.3.0), once that version is fixed; we will start on 2.4.0

    With spout you will get a notification like a achivement "Logged in!". Regarding the movement protection, we have worked on several of fixed and are still plundering a bit around with it, I will test a bit more once I get home from work, thanks for reporting!

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

    Jan Tojnar

    Sometimes i am prompted for password but i am already logged in and password is shown in chat. Especially after server restart.
    EDIT: i have also this bug i think it is critical http://issues.craftfire.com/view.php?id=413
     
  27. Offline

    Zero9195

    hi guys, still nice Plugin and it's cool that the new version is finally out ;)
    But I get errors all the time. Every error is the same, except some are from moving others from login, every error looks exactly like this:
    Code:
    12:24:28 [SEVERE] Could not pass event PLAYER_QUIT to AuthDB
    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:55)
            at com.authdb.util.Util.checkOtherName(Util.java:1260)
            at com.authdb.listeners.AuthDBPlayerListener.onPlayerQuit(AuthDBPlayerListener.java:250)
            at org.bukkit.plugin.java.JavaPluginLoader$2.execute(JavaPluginLoader.java:251)
            at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
            at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:338)
            at net.minecraft.server.ServerConfigurationManager.disconnect(ServerConfigurationManager.java:146)
            at net.minecraft.server.NetServerHandler.disconnect(NetServerHandler.java:121)
            at org.getspout.spout.SpoutNetServerHandler.disconnect(SpoutNetServerHandler.java:485)
            at org.bukkit.craftbukkit.entity.CraftPlayer.kickPlayer(CraftPlayer.java:139)
            at com.drdanick.McRKit.plugin.RTKEventHandler.onCommand(RTKEventHandler.java:64)
            at com.drdanick.McRKit.plugin.RTKPlugin.onCommand(RTKPlugin.java:65)
            at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
            at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:129)
            at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:344)
            at net.minecraft.server.MinecraftServer.b(MinecraftServer.java:489)
            at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:468)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    
    I'm using a phpBB3 v3.0.9. In the description it says only 3.0.8 ork, but with AuthDB 2.2 everything worked fine. Is it my fault or yours? Hopre we can fix this soon ;)
     
  28. Offline

    IOn Vash

    I just updated to the latest version for 1060 and now im getting this error.

    Code:
    2011-08-31 05:30:44 [SEVERE] Could not pass event PLAYER_JOIN to AuthDB
    javax.persistence.PersistenceException: ERROR executing DML bindLog[] error[Data truncation: Data too long for column 'inventory' at row 1]
        at com.avaje.ebeaninternal.server.persist.dml.DmlBeanPersister.execute(DmlBeanPersister.java:116)
        at com.avaje.ebeaninternal.server.persist.dml.DmlBeanPersister.update(DmlBeanPersister.java:85)
        at com.avaje.ebeaninternal.server.persist.DefaultPersistExecute.executeUpdateBean(DefaultPersistExecute.java:110)
        at com.avaje.ebeaninternal.server.core.PersistRequestBean.executeNow(PersistRequestBean.java:531)
        at com.avaje.ebeaninternal.server.core.PersistRequestBean.executeOrQueue(PersistRequestBean.java:557)
        at com.avaje.ebeaninternal.server.persist.DefaultPersister.update(DefaultPersister.java:430)
        at com.avaje.ebeaninternal.server.persist.DefaultPersister.saveEnhanced(DefaultPersister.java:343)
        at com.avaje.ebeaninternal.server.persist.DefaultPersister.saveRecurse(DefaultPersister.java:315)
        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.craftfire.util.managers.PlayerManager.storeInventory(PlayerManager.java:60)
        at com.authdb.listeners.AuthDBPlayerListener.onPlayerJoin(AuthDBPlayerListener.java:200)
        at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:244)
        at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
        at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:338)
        at net.minecraft.server.ServerConfigurationManager.c(ServerConfigurationManager.java:124)
        at net.minecraft.server.NetLoginHandler.b(NetLoginHandler.java:97)
        at net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:74)
        at net.minecraft.server.Packet1Login.a(SourceFile:43)
        at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
        at net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:40)
        at net.minecraft.server.NetworkListenThread.a(SourceFile:91)
        at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:454)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'inventory' at row 1
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2407)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2325)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2310)
        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.UpdateHandler.execute(UpdateHandler.java:105)
        at com.avaje.ebeaninternal.server.persist.dml.DmlBeanPersister.execute(DmlBeanPersister.java:105)
        ... 25 more
    And my users also cannot login it says they are "not authorized to do that" when they try to login.
     
  29. Offline

    contex

    Strange, are there any errors in console about PLAYER_CHAT event?

    Going to check the source once I get home from work, sorry for any problems it has caused :)
    Seems to be an error about storing inventory, do you have any plugins that modify the inventory in any way? I will check more once I get home from work.
     
  30. Offline

    IOn Vash

    I don't have any plugins that modify the inventory. Where are the players inventories stored?
     
  31. Offline

    Jan Tojnar

    I haven't noticed any, btw is it possible to modify outgoing packets (eg. via spout) and send empty inventory? You wouldn't need saving inventories and deleting them in world/players folder.
    EDIT: there are only:
    Code:
    13:11:55 [SEVERE] An error occured in the CommandHelper plugin: null[com.laytons
    mith.aliasengine.Script.match(Script.java:428), com.laytonsmith.aliasengine.AliasCore.alias(AliasCore.java:84), com.sk89q.commandhelper.CommandHelperListener.runAlias(CommandHelperListener.java:96), com.sk89q.commandhelper.CommandHelperListener.onPlayerCommandPreprocess(CommandHelperListener.java:143), org.bukkit.plugin.java.JavaPluginLoader$5.execute(JavaPluginLoader.java:272), org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58), org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:338), net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:730), net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:701), net.minecraft.server.NetServerHandler.a(NetServerHandler.java:694), net.minecraft.server.Packet3Chat.a(Packet3Chat.java:33), net.minecraft.server.NetworkManager.b(NetworkManager.java:226), net.minecraft.server.NetServerHandler.a(NetServerHandler.java:89), org.getspout.spout.SpoutNetServerHandler.a(SpoutNetServerHandler.java:478), net.minecraft.server.NetworkListenThread.a(SourceFile:105), net.minecraft.server.MinecraftServer.h(MinecraftServer.java:454), net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363), net.minecraft.server.ThreadServerApplication.run(SourceFile:422)]
    
    
     

Share This Page