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

    Massimo1993

    @Wulfspider
    @contex

    with buil 181 the lose of inventory occuring and i have this error:

    Code:
    [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:79)
        at com.authdb.util.databases.EBean.sync(EBean.java:97)
        at com.authdb.util.databases.EBean.sync(EBean.java:83)
        at com.authdb.listeners.AuthDBPlayerListener.onPlayerLogin(AuthDBPlayerListener.java:64)
        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:184)
        at net.minecraft.server.NetLoginHandler.b(NetLoginHandler.java:82)
        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: 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
     
  3. Offline

    Curthiany

    ok i'll do that
    cause i seriously dont want to put this on my live server... if that happens

    Edit: Also what would be cool if you guys add a feature where if Register=False there will be a diffrent message output when someone logs in not registered? like Please Register At <website> to access the Server.. Custom Message
     
  4. Offline

    Aus

  5. Offline

    contex

    Already in the bug list, but thanks for confirming :)


    Don't test it on your live server, cause currently there are a few bugs we have to fix.
    Also, I will ask @Wulfspider to add a message for that, thank you for the idea.
     
  6. Offline

    dawon

    Trying 181 and still getting "Could not pass ...." after first login and losing inventory...

    Same as @Massimo1993
     
  7. Offline

    Curthiany

    Glad To Help..... ok well i tried /logout then /login <password> my inventory didnt wipe....
    i force crash my local server and it wiped my inventory i think thats what its suppose to do.. i guess lol

    Edit: Not Getting Any Errors When i Login nor losing inventory..... but i have one question
    when i upgrade my live server from authdb 2.2.0 - 2.3.0 since the file "PlayerName_inv" will everyone lose their inventory that way? should i tell them to clear inventory before switching?

    Edit 2:Also maybe from the bugs located on top list your
    plugins ran with authdb

    Edit 3: Build 181 :Ok well i tried set my character have full inventory of cobblestone i typed /logout... Crashed the Server without saving... ran the server again.... Typed /login <password> and my cobblestone is still there
     
  8. Offline

    lenivets

    More errors..

    Code:
    2011-08-31 23:41:30 [INFO] [AuthDB] Launching function: replaceStrings(String string, Player player, String additional)
    2011-08-31 23:41:30 [SEVERE] Could not pass event ENTITY_DAMAGE to AuthDB
    java.lang.NullPointerException
    at com.craftfire.util.managers.PlayerManager.getIP(PlayerManager.java:163)
    at com.authdb.util.Util.replaceStrings(Util.java:1083)
    at com.authdb.util.Messages.sendMessage(Messages.java:397)
    at com.authdb.listeners.AuthDBEntityListener.checkGuest(AuthDBEntityListener.java:102)
    at com.authdb.listeners.AuthDBEntityListener.onEntityDamage(AuthDBEntityListener.java:64)
    at org.bukkit.plugin.java.JavaPluginLoader$59.execute(JavaPluginLoader.java:656)
    at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:338)
    at net.minecraft.server.EntityHuman.damageEntity(EntityHuman.java:427)
    at net.minecraft.server.EntityPlayer.damageEntity(EntityPlayer.java:180)
    at net.minecraft.server.EntityHuman.d(EntityHuman.java:566)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:883)
    at net.minecraft.server.Packet7UseEntity.a(SourceFile:33)
    at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:89)
    at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
    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)
    2011-08-31 23:41:53 [INFO] [AuthDB] Launching function: replaceStrings(String string, Player player, String additional)
    Using WorldGuard , bananregion .
     
  9. Offline

    Smorfy

    It is possible to use old mysql structre mit 2.3.0. Because, every time when I try to login, i get the message, i were not registered.
     
  10. Offline

    Aus

    Examined mysq logs and noticed that plugin is asking for authdb_users table. While config files are set in such way:
    Code:
    plugin:
      language:
        commands: English                              # Language you want to use for commands that matches a directory under translations.
        messages: English                              # 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: 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: mad_j                                      # 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: joomla                                     # Name of the script you are using.
      version: 1.6.1                                   # Version of the script you are using.
      tableprefix: jos_                              # Database table prefix for the script, if you use one.
    #  passwordsalt:                                    # NOT IMPLEMENTED YET! Unique/custom password salt, if needed by the script.
    
    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: 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 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: 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.
    
     
  11. Offline

    Zero9195

    No idea whats wrong with my version? Sad :( Maybe I'll just wait for the next bugfixed version...
     
  12. Offline

    MiddleEarth

    Had some reports of people getting their inventory cleared after reload/restarts. Has anyone else encountered this problem?
     
    Jan Tojnar likes this.
  13. Offline

    Curthiany

    Yes i'm actually also getting inventory wipes at Build 181... says its being fixed
     
  14. Offline

    IJosephI

    I had it once so after that i returned to 2.2.0
     
  15. Offline

    Zero9195

    @contex
    I will wait for the bugfixed version, and test it out with it again. Until then, good luck finding the other bugs ;)
     
  16. Offline

    Wulfspider

    The authdb_users is also the name of the local table inside AuthDB.db that AuthDB syncs your MySQL database with locally.
     
  17. Offline

    Massimo1993

    @Wulfspider

    Do you understand what problem is it? (player lose inventory)
     
  18. Offline

    Aus

    Any ideas what to do?
     
  19. Offline

    Wulfspider

    The inventory bug is our biggest issue right now and we are trying to resolve it.

    We're trying to get it fixed.

    Yes, we are trying to get the inventory bug fixed.

    Do you get the same message after you leave the server and join again?

    Are you using a script or customdb?

    I think we'll need to add something that looks for inv files or just make sure that everyone has logged in before the switched perhaps so that their inventory is not stored in the files.

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

    wolfz18

    how i add items in blacklist.yml ? just the ID like ex: 4,3,32,12

    ups sorry

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

    Wulfspider

    Wha? There is no blacklist.yml. What are you talking about?
     
  22. Offline

    wolfz18

    yes it is CraftBukkit\plugins\AdminCmd
     
  23. Offline

    Aus

    Wrong plugin thread? It's AuthDB thread
     
  24. Offline

    contex

    I think you are looking for this thread: http://forums.bukkit.org/threads/ad...ll-warp-weather-afk-multi-lingual-1060.10770/
    They moved to: http://dev.bukkit.org/server-mods/admincmd/

    Oh right, try: "find / -name 'AuthDB.db' ", see if that results anything

    We havent fixed it yet, you could however use AuthDB 2.2.0.

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

    Wulfspider

    Yeah, wrong plugin thread. This is for AuthDB, not AdminCmd.

    No problem. :)

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

    Aus

    I apologize for being so annoying, but what my next step should be?

    Review:
    1. Getting com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 't0.equipment' in 'field list'" error
    2. Using AuthDB 181 build, CraftBukkit 1066, Spout 258, CentOS Linux 6.0
    3. Setting to connect Joomla 1.6.1
    4. Already uploaded AuthDB.db into plugins/AuthDB. No changes.
     
  27. Offline

    contex

    I know whats wrong, but I cant understand why that is going on.
    It seems like it finds the AuthDB.db (but you are using a few days old AuthDB.db), are you sure that its not located anywhere else? What if you type "find AuthDB.db /" and let it scan your whole vps/pc.
     
  28. Offline

    Aus

    Nothing found. Scanned from / directory.
     
  29. Offline

    Massimo1993

    @contex

    hi excuse me again, i know you have work to do but i have a dedicate server with 50 people and i've installed auth db 181, you can relase a dev build only with inventory bug fixed please or i loose all player ç.ç

    @contex

    Code:
    settings:
        spawn-radius: 16
        permissions-file: permissions.yml
        update-folder: update
    aliases:
        icanhasbukkit:
        - version
    database:
        username: bukkit
        isolation: SERIALIZABLE
        driver: org.sqlite.JDBC
        password: walrus
        url: jdbc:sqlite:{DIR}{NAME}.db
    
    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Oct 10, 2018
  30. Offline

    Aus

    Blank result. Nothing.

    Firs thought of error cause was permission mistake.. but no. Permissions are alright. 755 on whole server folder. Recursively
     
  31. Offline

    Massimo1993

    with 2.2 i've too much error and the server lag
     

Share This Page