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

    Thanks for reporting, there was a simple missing "`" causing the problems.
     
  3. Offline

    Wulfspider

    Could we have a list of the plugins you are using?

    Why are you trying to link when you are using a custom database? Did you make sure all your values in advanced.yml are correct?

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

    Aus

    Code:
    aused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 't0.equipment' in 'field list'
            at sun.reflect.GeneratedConstructorAccessor30.newInstance(Unknown Source)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
            at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
            at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
            at com.mysql.jdbc.Util.getInstance(Util.java:382)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
            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.executeQuery(PreparedStatement.java:2273)
            at com.avaje.ebeaninternal.server.lib.sql.ExtendedPreparedStatement.executeQuery(ExtendedPreparedStatement.java:150)
            at com.avaje.ebeaninternal.server.query.CQuery.prepareBindExecuteQuery(CQuery.java:416)
            at com.avaje.ebeaninternal.server.query.CQueryEngine.findMany(CQueryEngine.java:198)
            ... 23 more
    
    Please, help.
    Using Craftbukkit 1066, AuthDB 181 and spout build 258

    Deleted previously

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Mar 26, 2019
  5. Offline

    Zero9195

    Hm, no Errors anymore, but this appears when starting the Server:
    Code:
    Can not test connection as heartbeatsql is not set
    2011-08-31 20:39:46 [INFO] Closing Connection[AuthDB.1] psReuse[0] psCreate[1] psSize[0]
    2011-08-31 20:39:46 [INFO] [AuthDB] Installing persistence database for AuthDB due to first time usage
    2011-08-31 20:39:46 [INFO] runScript
    2011-08-31 20:39:46 [INFO] executing 1 of 1 create table authdb_users ( id                        integer primary key, playe...
    2011-08-31 20:39:46 [INFO] ... end of script
    2011-08-31 20:39:46 [INFO] [AuthDB] Found supported plugin: Permissions 3.1.5
    2011-08-31 20:39:46 [INFO] [AuthDB] 52 user registrations in database
    2011-08-31 20:39:46 [INFO] [AuthDB] AuthDB plugin 2.3.0.176 is enabled
    2011-08-31 20:39:46 [INFO] [AuthDB] AuthDB is developed by CraftFire <[email protected]>
    
    And I can't login, or at least I can't link my Username to another. And it didn't seems as anyone else was able to login.
    Btw, Is the plugin already checking for banned users?
    EDIT: Tested It again, and noone can login. But the User is recognised, so it Says "Welcome back Zero9195 ..."
     
  6. Offline

    contex

    2011-08-31 20:39:46 [INFO] [AuthDB] Installing persistence database for AuthDB due to first time usage
    Says clearly there that it's creating the first-time databse.
    Ehm how can't you login? Are there any errors in console? Do you have permission to login?
     
  7. Offline

    Aus

    Deleted previously​
    Still getting same errors​
     
  8. Offline

    Zero9195

    I am not using a customdb, I'm using phpBB3 v3.0.9.
    Yes, eveything there is false with customdb. I wondered about that line too, thats why I asked.
    No, no errors. But the player is recognised, so it says "welcome back Zero9195 ..."
     
  9. Offline

    Wulfspider

    Oh nevermind haha, that was AuthDB creating the local eBeans database. I forgot that is what we named it.

    Are you using any permissions plugins?

    Bans will be with the addon AuthDB Bans, which is not ready yet.
     
  10. Offline

    Zero9195

    Ok ;) Was just wondering.
    I am using Permissions 3.1.5 as you can see here:
    Code:
    2011-08-31 20:39:46 [INFO] [AuthDB] Found supported plugin: Permissions 3.1.5
    
    Me as Admin has EVERY permission, so at least i should be able to link/login. Really strange...

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

    Wulfspider

    Could you try adding authdb.* to your group and see if it makes a difference?
     
  12. Offline

    Aus

    Excuse me my persistance, but situation is hot.
    Waiting for any advice
     
  13. Offline

    Wulfspider

    Could you send me your AuthDB.db after having started the server? I'd like to see what the columns look like in it. You can PM it to me.
     
  14. Offline

    Aus

    There is MySQL connection to Joomla database
    There is no AuthDB.db file in plugins/AuthDB folder
     
  15. Offline

    Zero9195

    @Wulfspider
    nope, no difference. It seems we are allowed to login and link. It says "Username linking failed". Maybe it's because of the phpBB3 version? you support 3.0.8, I'm using 3.0.9. If ou want I can drop my configuration if it'll help ya...
     
  16. Offline

    Wulfspider

    There should be. What CraftBukkit build are you using and what OS?
     
  17. Offline

    Jan Tojnar

    It seems inventories are cleared by AuthDb i removed all plugins except authdb.
     
  18. Offline

    Wulfspider

    Yeah, that is the issue we are working on now. Not sure why it's doing it AFTER release... as we didn't encounter any issues before release haha.
     
  19. Offline

    Aus

    CentOS Linux 6.0
    CraftBukkit 1066

    Code:
    Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 't0.equipment' in 'field list'
            at sun.reflect.GeneratedConstructorAccessor20.newInstance(Unknown Source)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
            at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
            at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
            at com.mysql.jdbc.Util.getInstance(Util.java:382)
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
            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.executeQuery(PreparedStatement.java:2273)
            at com.avaje.ebeaninternal.server.lib.sql.ExtendedPreparedStatement.executeQuery(ExtendedPreparedStatement.java:150)
            at com.avaje.ebeaninternal.server.query.CQuery.prepareBindExecuteQuery(CQuery.java:416)
            at com.avaje.ebeaninternal.server.query.CQueryEngine.findMany(CQueryEngine.java:198)
    
    Cause is very strange com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 't0.equipment' in 'field list'

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

    Wulfspider

    Yes, it's because it can't find that field in AuthDB.db, and if you don't even have AuthDB.db in your plugins folder, then it can't find that field. ;)
    I'm not sure why it wouldn't be creating it.
     
  21. Offline

    Aus

    Can i download it somewhere?
     
  22. Offline

    Zero9195

    Here are my configs, maybe they'll help you finding the problem.
    basic.yml
    Code:
    plugin:^M
      language: English                                # Language you want to use that matches a directory under translations.^M
      debugmode: false                                 # Enable/disable debugging mode and additional console output.^M
      usagestats: true                                 # Enable/disable usage stats reporting to CraftFire devs.^M
      logging: true                                    # Enable/disable logging to files.^M
      logformat: yyyy-MM-dd                            # Filename format of the AuthDB debug and error log files.^M
    database:^M
      type: MySQL                                      # Database type/driver to use. Current options are MySQL and eBean (Bukkit persistence).^M
      host: localhost                                  # MySQL server hostname, domain, IP, or localhost for local connections. MySQL only.^M
      port: 3306                                       # Port used for connecting to your MySQL server. This is usually 3306. MySQL only.^M
      username: blablablabla                                   # Username used to connect to your database. Only valid for MySQL.^M
      password: moreblablablabla                          # Password used to connect to your database. MySQL only.^M
      name: even more...you know                               # Name of the database you are connecting to. MySQL only.^M
      keepalive: true                                  # Enable/disable keeping database connection alive. MySQL only.^M
    script:^M
      name: phpBB                                      # Name of the script you are using.^M
      version: 3.0.9                                   # Version of the script you are using.^M
      tableprefix: phpbb_                              # Database table prefix for the script, if you use one.^M
    #  passwordsalt:                                    # NOT IMPLEMENTED YET! Unique/custom password salt, if needed by the script.^M
    
    
    advanced.yml
    Code:
    customdb:
      enabled: false                                   # Enable/disable custom database support. Leave this disabled if using a script such as phpBB.
      autocreate: false                                # 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: false                             # 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 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: 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: 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.
    
    
     
  23. Offline

    contex

    Could you do me a favour and type "find AuthDB.db" in your server directory. Type it in the terminal/shell.
     
  24. Offline

    Aus

    Scanned entire srver folder. Nothing:(
    Maybe I should download it?
     
  25. Offline

    Curthiany

    Well Ty Recent Build 181 Fixed all my problems.... but i'm worried about that inventory bug
    - 0000413: [Bugs] Players losing inventory after each login
    is it occuring in Build 181?
     
  26. Offline

    contex

    But you said you had it ealier ? The AuthDB.db file.

    Edit: I added the AuthDB.db default file in the zip file, see if that works.
     

    Attached Files:

  27. Offline

    Aus

    Maybe it was left bu some previous versions.
    I wiped entire plugins/AuthDB directory
     
  28. Offline

    contex

    We're having a strange issue with inventory now.
    Could you test Build 181 and see if it works for you or not?
     
  29. Offline

    Wulfspider

    Does the user you are starting the server in have permissions to that directory? Make sure the AuthDB directory is set to the same user you are running your server as.
     
  30. Offline

    Aus

    Yes. Folder is under current user's permission

    >Edit: I added the AuthDB.db default file in the zip file, see if that works.
    Tried. Same error.
    Dunno, what's done wrong
     
  31. Offline

    contex

    The heck, it seems like it's looking for a different AuthDB.db than the one you have in AuthDB/plugins/AuthDB.db
     

Share This Page