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

    No problem!
     
  3. Offline

    Black_Jack

    Okay, new log file. With latest stable build.
     

    Attached Files:

  4. Offline

    contex

    Do me a favour, put keepalive: true to keepalive: false in the basic.yml. Check if you still get the error. Also, are you sure that you are not using any tableprefix?
     
  5. Offline

    Wulfspider

    Check that you have your config right. The error you are getting is from AuthDB being unable to find your script's (IP.Board) database. More than likely you are actually using a table prefix, but do not have it specified in the config.
     
  6. Offline

    oglop

    Hello It's me, today I was at school, tomorow I moved to college and I dind't bring my laptop with me, so I didn't have any reports from server, but it seems that error that happened me Sunday morning didn't occure this morning its strange, I'll download latest build asap
    thank you
     
  7. Offline

    Curthiany

    can't really test without AuthDB cause of people gonna try to login into my account.....
     
  8. Offline

    forceserver

    4444.png 55555.png
    server die when user join server without error sometimes
    do you know this problem ??
     
  9. Offline

    Wulfspider

  10. Offline

    kastrator

    If you have some errors in first logon try
    keepalive: false
    It works for me, i think :) when its true i get STACKTRACE ERROR

    Using SMF 2.0 database
     
  11. Hello again, guys...
    Whats wrong with my CB#1066 and 2.3.1.200 AuthDB?
    I am just trying to get new version working with no another plugins.

    Code:
    00:49:51 [SEVERE] Could not pass event PLAYER_LOGIN to AuthDB
    javax.persistence.PersistenceException: Query threw SQLException:Unknown column 't0.equipment' in 'f
    ield list'
    Bind values:[aiquen]
    Query was:
    select t0.id c0, t0.playername c1, t0.linkedname c2, t0.password c3, t0.salt c4, t0.ip c5, t0.email
    c6, t0.inventory c7, t0.equipment c8, t0.activated c9, t0.registered c10, t0.authorized c11, t0.time
    outid c12, t0.reloadtime c13, t0.sessiontime c14
    from authdb_users t0
    where lower(t0.playername) =?
     
            at com.avaje.ebeaninternal.server.query.CQuery.createPersistenceException(CQuery.java:849)
            at com.avaje.ebeaninternal.server.query.CQuery.createPersistenceException(CQuery.java:829)
            at com.avaje.ebeaninternal.server.query.CQueryEngine.findMany(CQueryEngine.java:238)
            at com.avaje.ebeaninternal.server.query.DefaultOrmQueryEngine.findMany(DefaultOrmQueryEngine
    .java:104)
            at com.avaje.ebeaninternal.server.core.OrmQueryRequest.findList(OrmQueryRequest.java:344)
            at com.avaje.ebeaninternal.server.core.DefaultServer.findList(DefaultServer.java:1469)
            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:56)
            at com.authdb.util.databases.EBean.sync(EBean.java:90)
            at com.authdb.util.databases.EBean.sync(EBean.java:84)
            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:453)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 't0.equipment'
    in 'field list'
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
            at java.lang.reflect.Constructor.newInstance(Unknown Source)
            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(ExtendedPre
    paredStatement.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
    I've changed almost everything in setting files, but i can to attach them how they are right now...
    Wierd is line "from authdb_users t0" because i have different customDB name (authdb2 right now)

    Code:
    ###ADVANCED###
    customdb:
      enabled: true                                   # 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: authdb2                              # 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 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.
    
    ###BASIC###
    plugin:
      language: English                                # Language you want to use that matches a directory under translations.
      debugmode: false                                 # Enable/disable debugging mode and additional console output.
      usagestats: false                                 # 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: pass                                   # 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:                                     # 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.
    
    ok.. I have set MySQL in bukkit.yml... so authdb_users was on mysql server, deleted, recreated... solved, thank you...

    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

    Delete your AuthDB.db file under plugins/AuthDB and start the server again. You are using an older version of AuthDB's local eBeans database.
     
  13. Offline

    fragger505

    Tested with build 211 due to 210 having filter character issues and it is working as intended, thank you. ^^
     
  14. Offline

    Wulfspider

    No problem, glad all is working well for you. :)
     
  15. I suppose it's in some of your guide... so I am sorry for that... but I dont have any AuthDB.db file in plugin/AuthDB folder ..
     
  16. Offline

    Wulfspider

    Then you modified bukkit.yml to put them somewhere else or not at all.
    Please post your bukkit.yml so I can see as that is most likely the cause.
     
  17. Offline

    Wulfspider

    No problem. :)
     
  18. Offline

    oglop

    hello, I donwloaded latest bulild #211
    it worked, maybe it deleted items from my inventory bcz of new installation
    but after night I tried to log in .. I appeared at place where I ended last night, I appeared as jumpimg (thats awful, is it possible to do something about it? thanks)

    then I typed password and a I was disconnected bcz of flying (fly=false on my bukkit)
    Then I wanted to log back and I got database connection error
    strange is that last build I had (maybe #195) dind't occure error over 1 night of 3
    then I changed to keepalive= false will se what happen
    I hope you understad all I typed :)
    error:
    Show Spoiler

    2011/09/06 09:06:43 - --------------------------- STACKTRACE ERROR ---------------------------
    2011/09/06 09:06:43 - Class name: com.authdb.AuthDB
    2011/09/06 09:06:43 - File name: AuthDB.java
    2011/09/06 09:06:43 - Function name: isRegistered
    2011/09/06 09:06:43 - Error line: 830
    2011/09/06 09:06:43 - Script: joomla
    2011/09/06 09:06:43 - Script version: 1.5.22
    2011/09/06 09:06:43 - Table prefix: GgG_
    2011/09/06 09:06:43 - Keep alive: true
    2011/09/06 09:06:43 - MySQL connected: true
    2011/09/06 09:06:43 - Latest query: SELECT * FROM `GgG_users` WHERE `username` = 'oglop' LIMIT 1
    2011/09/06 09:06:43 - Plugins: DropChest 0.8.1, DefaultPermissions 0.3.4, WorldEdit 4.6, Vault 1.0.0dev-b21, PermissionsEx 1.13, TimeAndWeatherControl 0.5, BanHammer 1.4.2, Spout 1.0.5.227, Permissions 2.7.7, ChopTree 1.24, MyWarp 2.0, HeroChat 4.10.3, mcMMO 1.1.13, HeroicDeath 1.9.1, Administrate 1.3.2-b32, LoginQueue2 0.1, SpoutTrade 1.3.1-BETA, AuthDB 2.3.1.211, VirtualChest 4.4.4, MyHome 2.0, dynmap 0.20.1, Factions 1.4.7, WorldBorder 1.4.1,
    2011/09/06 09:06:43 - --------------------------- STACKTRACE START ---------------------------
    2011/09/06 09:06:43 - sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011/09/06 09:06:43 - sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    2011/09/06 09:06:43 - sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    2011/09/06 09:06:43 - java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    2011/09/06 09:06:43 - com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011/09/06 09:06:43 - com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011/09/06 09:06:43 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
    2011/09/06 09:06:43 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
    2011/09/06 09:06:43 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
    2011/09/06 09:06:43 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
    2011/09/06 09:06:43 - com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.java:1213)
    2011/09/06 09:06:43 - com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1200)
    2011/09/06 09:06:43 - com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2485)
    2011/09/06 09:06:43 - com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2467)
    2011/09/06 09:06:43 - com.authdb.util.databases.MySQL.getfromtable(MySQL.java:219)
    2011/09/06 09:06:43 - com.authdb.util.Util.checkScript(Util.java:718)
    2011/09/06 09:06:43 - com.authdb.AuthDB.isRegistered(AuthDB.java:818)
    2011/09/06 09:06:43 - com.authdb.listeners.AuthDBPlayerListener.onPlayerJoin(AuthDBPlayerListener.java:136)
    2011/09/06 09:06:43 - org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:244)
    2011/09/06 09:06:43 - org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
    2011/09/06 09:06:43 - org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:338)
    2011/09/06 09:06:43 - net.minecraft.server.ServerConfigurationManager.c(ServerConfigurationManager.java:124)
    2011/09/06 09:06:43 - net.minecraft.server.NetLoginHandler.b(NetLoginHandler.java:97)
    2011/09/06 09:06:43 - net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:74)
    2011/09/06 09:06:43 - net.minecraft.server.Packet1Login.a(SourceFile:43)
    2011/09/06 09:06:43 - net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
    2011/09/06 09:06:43 - net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:40)
    2011/09/06 09:06:43 - net.minecraft.server.NetworkListenThread.a(SourceFile:91)
    2011/09/06 09:06:43 - net.minecraft.server.MinecraftServer.h(MinecraftServer.java:454)
    2011/09/06 09:06:43 - net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
    2011/09/06 09:06:43 - net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    2011/09/06 09:06:43 - ---------------------------- STACKTRACE END ----------------------------
    2011/09/06 09:06:43 - --------------------------- STACKTRACE ERROR ---------------------------
    2011/09/06 09:06:43 - Class name: com.authdb.AuthDB
    2011/09/06 09:06:43 - File name: AuthDB.java
    2011/09/06 09:06:43 - Function name: isRegistered
    2011/09/06 09:06:43 - Error line: 830
    2011/09/06 09:06:43 - Script: joomla
    2011/09/06 09:06:43 - Script version: 1.5.22
    2011/09/06 09:06:43 - Table prefix: GgG_
    2011/09/06 09:06:43 - Keep alive: true
    2011/09/06 09:06:43 - MySQL connected: false
    2011/09/06 09:06:43 - Latest query: SELECT * FROM `GgG_users` WHERE `username` = 'oglop' LIMIT 1
    2011/09/06 09:06:43 - Plugins: DropChest 0.8.1, DefaultPermissions 0.3.4, WorldEdit 4.6, Vault 1.0.0dev-b21, PermissionsEx 1.13, TimeAndWeatherControl 0.5, BanHammer 1.4.2, Spout 1.0.5.227, Permissions 2.7.7, ChopTree 1.24, MyWarp 2.0, HeroChat 4.10.3, mcMMO 1.1.13, HeroicDeath 1.9.1, Administrate 1.3.2-b32, LoginQueue2 0.1, SpoutTrade 1.3.1-BETA, AuthDB 2.3.1.211, VirtualChest 4.4.4, MyHome 2.0, dynmap 0.20.1, Factions 1.4.7, WorldBorder 1.4.1,
    2011/09/06 09:06:43 - --------------------------- STACKTRACE START ---------------------------
    2011/09/06 09:06:43 - sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011/09/06 09:06:43 - sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    2011/09/06 09:06:43 - sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    2011/09/06 09:06:43 - java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    2011/09/06 09:06:43 - com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011/09/06 09:06:43 - com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011/09/06 09:06:43 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
    2011/09/06 09:06:43 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
    2011/09/06 09:06:43 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
    2011/09/06 09:06:43 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
    2011/09/06 09:06:43 - com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.java:1213)
    2011/09/06 09:06:43 - com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1200)
    2011/09/06 09:06:43 - com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2485)
    2011/09/06 09:06:43 - com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2467)
    2011/09/06 09:06:43 - com.authdb.util.databases.MySQL.getfromtable(MySQL.java:219)
    2011/09/06 09:06:43 - com.authdb.util.Util.checkScript(Util.java:718)
    2011/09/06 09:06:43 - com.authdb.AuthDB.isRegistered(AuthDB.java:818)
    2011/09/06 09:06:43 - com.authdb.listeners.AuthDBPlayerListener.onPlayerJoin(AuthDBPlayerListener.java:139)
    2011/09/06 09:06:43 - org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:244)
    2011/09/06 09:06:43 - org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
    2011/09/06 09:06:43 - org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:338)
    2011/09/06 09:06:43 - net.minecraft.server.ServerConfigurationManager.c(ServerConfigurationManager.java:124)
    2011/09/06 09:06:43 - net.minecraft.server.NetLoginHandler.b(NetLoginHandler.java:97)
    2011/09/06 09:06:43 - net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:74)
    2011/09/06 09:06:43 - net.minecraft.server.Packet1Login.a(SourceFile:43)
    2011/09/06 09:06:43 - net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
    2011/09/06 09:06:43 - net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:40)
    2011/09/06 09:06:43 - net.minecraft.server.NetworkListenThread.a(SourceFile:91)
    2011/09/06 09:06:43 - net.minecraft.server.MinecraftServer.h(MinecraftServer.java:454)
    2011/09/06 09:06:43 - net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
    2011/09/06 09:06:43 - net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    2011/09/06 09:06:43 - ---------------------------- STACKTRACE END ----------------------------
    2011/09/06 09:06:43 - --------------------------- STACKTRACE ERROR ---------------------------
    2011/09/06 09:06:43 - Class name: com.authdb.AuthDB
    2011/09/06 09:06:43 - File name: AuthDB.java
    2011/09/06 09:06:43 - Function name: isRegistered
    2011/09/06 09:06:43 - Error line: 774
    2011/09/06 09:06:43 - Script: joomla
    2011/09/06 09:06:43 - Script version: 1.5.22
    2011/09/06 09:06:43 - Table prefix: GgG_
    2011/09/06 09:06:43 - Keep alive: true
    2011/09/06 09:06:43 - MySQL connected: false
    2011/09/06 09:06:43 - Latest query: SELECT * FROM `GgG_users` WHERE `username` = 'oglop' LIMIT 1
    2011/09/06 09:06:43 - Plugins: DropChest 0.8.1, DefaultPermissions 0.3.4, WorldEdit 4.6, Vault 1.0.0dev-b21, PermissionsEx 1.13, TimeAndWeatherControl 0.5, BanHammer 1.4.2, Spout 1.0.5.227, Permissions 2.7.7, ChopTree 1.24, MyWarp 2.0, HeroChat 4.10.3, mcMMO 1.1.13, HeroicDeath 1.9.1, Administrate 1.3.2-b32, LoginQueue2 0.1, SpoutTrade 1.3.1-BETA, AuthDB 2.3.1.211, VirtualChest 4.4.4, MyHome 2.0, dynmap 0.20.1, Factions 1.4.7, WorldBorder 1.4.1,
    2011/09/06 09:06:43 - --------------------------- STACKTRACE START ---------------------------
    2011/09/06 09:06:43 - sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011/09/06 09:06:43 - sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    2011/09/06 09:06:43 - sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    2011/09/06 09:06:43 - java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    2011/09/06 09:06:43 - com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011/09/06 09:06:43 - com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011/09/06 09:06:43 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
    2011/09/06 09:06:43 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
    2011/09/06 09:06:43 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
    2011/09/06 09:06:43 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
    2011/09/06 09:06:43 - com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.java:1213)
    2011/09/06 09:06:43 - com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1200)
    2011/09/06 09:06:43 - com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2485)
    2011/09/06 09:06:43 - com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2467)
    2011/09/06 09:06:43 - com.authdb.util.databases.MySQL.getfromtable(MySQL.java:219)
    2011/09/06 09:06:43 - com.authdb.util.Util.checkScript(Util.java:718)
    2011/09/06 09:06:43 - com.authdb.AuthDB.isRegistered(AuthDB.java:769)
    2011/09/06 09:06:43 - com.authdb.listeners.AuthDBPlayerListener.onPlayerJoin(AuthDBPlayerListener.java:194)
    2011/09/06 09:06:43 - org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:244)
    2011/09/06 09:06:43 - org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
    2011/09/06 09:06:43 - org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:338)
    2011/09/06 09:06:43 - net.minecraft.server.ServerConfigurationManager.c(ServerConfigurationManager.java:124)
    2011/09/06 09:06:43 - net.minecraft.server.NetLoginHandler.b(NetLoginHandler.java:97)
    2011/09/06 09:06:43 - net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:74)
    2011/09/06 09:06:43 - net.minecraft.server.Packet1Login.a(SourceFile:43)
    2011/09/06 09:06:43 - net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
    2011/09/06 09:06:43 - net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:40)
    2011/09/06 09:06:43 - net.minecraft.server.NetworkListenThread.a(SourceFile:91)
    2011/09/06 09:06:43 - net.minecraft.server.MinecraftServer.h(MinecraftServer.java:454)
    2011/09/06 09:06:43 - net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
    2011/09/06 09:06:43 - net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    2011/09/06 09:06:43 - ---------------------------- STACKTRACE END ----------------------------
     
  19. Offline

    contex

    Thanks for reporting :) I will check it during launch.
    Edit: What happens if you put keep-alive to false?
     
  20. Offline

    oglop

    idk but with #195 it worked (I didn't checked times) .. i just happened over night (maybe it happened if noone will login for longer time)
    Just now its working with false will see what happens


    btw. Is it possible to add smthing like {NEWLINE} or {NL} to messages file, it is good for formating ingame text, thank you (or it is already included?)
     
  21. Offline

    contex

    Thank you for testing.
    We already have newline added, its currently {N}/{n} and {NEWLINE}/{newline} but i will add {NL}, thank you for requesting :)!
     
  22. Offline

    oglop

    {N}/{n} I think I tried it but it didn't work, I'll try it once again, bcz when I was translating messagest I saw {N} and I thoung it was new line, but in game I saw "{N}" (maybe its repaired, already :)
    I have plugin chop tree but its causing strange "for screen" error
    Now I cant login Im getting internal server error
    I got this error bcz of chop tree, it loged me out, then I wanted to login an I got
    Show Spoiler
    [WARNING] Failed to handle packet: java.lang.NullPointerException
    java.lang.NullPointerException
    at net.minecraft.server.ItemStack.d(ItemStack.java:95)
    at net.minecraft.server.ItemStack.f(ItemStack.java:103)
    at net.minecraft.server.InventoryPlayer.pickup(InventoryPlayer.java:142)
    at net.minecraft.server.EntityItem.b(EntityItem.java:144)
    at net.minecraft.server.EntityHuman.i(EntityHuman.java:220)
    at net.minecraft.server.EntityHuman.v(EntityHuman.java:212)
    at net.minecraft.server.EntityPlayer.v(EntityPlayer.java:281)
    at net.minecraft.server.EntityLiving.m_(EntityLiving.java:218)
    at net.minecraft.server.EntityHuman.m_(EntityHuman.java:97)
    at net.minecraft.server.EntityPlayer.a(EntityPlayer.java:193)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:299)
    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:454)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    2011-09-06 11:26:13 [INFO] Connection reset


    other error maybe related to authdb

    WARNING] Failed to handle packet: java.lang.NullPointerException
    java.lang.NullPointerException
    at net.minecraft.server.ItemStack.d(ItemStack.java:95)
    at net.minecraft.server.ItemStack.f(ItemStack.java:103)
    at net.minecraft.server.InventoryPlayer.pickup(InventoryPlayer.java:142)
    at net.minecraft.server.EntityItem.b(EntityItem.java:144)
    at net.minecraft.server.EntityHuman.i(EntityHuman.java:220)
    at net.minecraft.server.EntityHuman.v(EntityHuman.java:212)
    at net.minecraft.server.EntityPlayer.v(EntityPlayer.java:281)
    at net.minecraft.server.EntityLiving.m_(EntityLiving.java:218)
    at net.minecraft.server.EntityHuman.m_(EntityHuman.java:97)
    at net.minecraft.server.EntityPlayer.a(EntityPlayer.java:193)
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:299)
    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:454)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)


    btw it kick me out when I was at leaves, then they disaapeared and now when I try to log in I see taht database remembers me and I'm fall abou 4 blocks then internal server error

    Is it possible that the authdb will remember loged off user for 5 minutes after log off
    Instead of seasion length?

    Now I'm sure that {N} and {NEWLINE} don't appear at game text, but still doesn't work :)
    if I'm right it should be:

    source:
    Hey this is a test file for {N}newline.

    output(ingame):
    Hey this is a test file for
    newline.

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

    Black_Jack

    I dont use any table prefix. Look at this screenshot.
    http://prntscr.com/2xk8l
    I left the table prefix without any params. So i have tableprefix :
     
  24. Offline

    contex

    Strange. Did you put keepalive to false?
    Do me a favour and execute this mysql command in phpmyadmin: SELECT * FROM `members` WHERE `members_l_username` = 'pillarofautumn' LIMIT 1

    Strange, it might be related to Spout. We will have to test once Wulfspider wakes up and finds some time for it. I dont see the point with remember users that logged off, to remember their session? What is the point with that.

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

    Wulfspider

    The occasionally kicked for flying and bouncing in the air is something we've been trying to work out.
     
  26. Offline

    oglop

    Point is if i have MAX player limit and I have Login Queue so if someone has to restart game or PC htne he won't have to wait again, but maybe its handeled by queue plugin
     
  27. Offline

    Wulfspider

    I'd say that would be handled by the login queue plugin. AuthDB just remembers the player so they don't have to enter their password again.
     
  28. Offline

    Smorfy

    Try #214 with CB1060, NES.

    after 5 Minutes i get this error:

    00:15:43 [WARNUNG] [AuthDB]
    |-----------------------------------------------------------------------------|
    |--------------------------------AUTHDB WARNING-------------------------------|
    |-----------------------------------------------------------------------------|
    | STACKTRACE ERROR
    |-----------------------------------------------------------------------------|
    00:15:43 [WARNUNG] [AuthDB] Class name: com.authdb.listeners.AuthDBPlayerListener
    00:15:43 [WARNUNG] [AuthDB] File name: AuthDBPlayerListener.java
    00:15:43 [WARNUNG] [AuthDB] Function name: onPlayerCommandPreprocess
    00:15:43 [WARNUNG] [AuthDB] Error line: 415
    00:15:43 [WARNUNG] [AuthDB] Check log file: plugins/AuthDB\logs\error\2011-09-07-error.log
    00:16:05 [INFO] Connection reset

    The file 2011-09-07-error.log
     

    Attached Files:

  29. Offline

    Wulfspider

    Set keepalive: false in basic.yml and see if you have the same problem after restarting your server. Also, do you have the MySQL Java Connector somewhere in your server root too? It's not needed since CraftBukkit has it built-in.
     
  30. Offline

    Smorfy

    OK, it seems to be work. I let the server run for a day, and tomorrow after work i check the logs. THX (in hope that is it^^)
     
  31. Offline

    contex

    Thank you for trying, i was 100 percent sure that we had that working, what OS are you running?
     

Share This Page