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

    Wulfspider

    That only shows the first time a user logs into a server. If you deleted your AuthDB.db, it will show this for each user that logs in the first time. We are working on a fix, but it doesn't affect anything.
     
  3. Offline

    WolwX

    Ok fine I understand and I don't worry about it

    About the fact I can login do you have any tips for correct it ?

    http://forums.bukkit.org/posts/678571/
     
  4. Offline

    Wulfspider

    Did you change your password recently on the forums? Do you get a message in-game after you try to login?
     
  5. Offline

    WolwX

    No I don't changed my password, but I tried to reset it into the forum and that's still the same problem

    About ingame message here it's =>

    [​IMG]
     
  6. Offline

    Black_Jack

    Session lookup was at logoff. I'm setted it at login. Lets see what will this change/

    Yes, the problem is logoff session starting. So, when unathorized player logoff, he automatically login without password required. Please, fix it. I want logoff session enable ^^

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

    Kiborgik

    Code:
    18.09 11:00:11 [Multicraft] Minecraft shut down
    18.09 11:00:11 [Multicraft] Forcefully killing Minecraft
    18.09 11:00:10 [Server] INFO Stopping server
    18.09 11:00:10 [Multicraft] Terminating Minecraft via signal
    18.09 11:00:10 [Server] INFO     ... 21 more
    18.09 11:00:10 [Server] INFO     at com.avaje.ebeaninternal.server.transaction.TransactionManager.createQueryTransaction(TransactionManager.java:339)
    18.09 11:00:10 [Server] INFO     at com.avaje.ebeaninternal.server.lib.sql.DataSourcePool.getConnection(DataSourcePool.java:646)
    18.09 11:00:10 [Server] INFO     at com.avaje.ebeaninternal.server.lib.sql.DataSourcePool.getPooledConnection(DataSourcePool.java:658)
    18.09 11:00:10 [Server] INFO     at com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue.getPooledConnection(PooledConnectionQueue.java:247)
    18.09 11:00:10 [Server] INFO     at com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue._getPooledConnection(PooledConnectionQueue.java:307)
    18.09 11:00:10 [Server] INFO     at com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue._getPooledConnectionWaitLoop(PooledConnectionQueue.java:329)
    18.09 11:00:10 [Server] INFO 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
    18.09 11:00:10 [Server] INFO     at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    18.09 11:00:10 [Server] INFO     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
    18.09 11:00:10 [Server] INFO     at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:454)
    18.09 11:00:10 [Server] INFO     at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
    18.09 11:00:10 [Server] INFO     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:89)
    18.09 11:00:10 [Server] INFO     at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
    18.09 11:00:10 [Server] INFO     at net.minecraft.server.Packet10Flying.a(SourceFile:126)
    18.09 11:00:10 [Server] INFO     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:174)
    18.09 11:00:10 [Server] INFO     at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:338)
    18.09 11:00:10 [Server] INFO     at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
    18.09 11:00:10 [Server] INFO     at org.bukkit.plugin.java.JavaPluginLoader$7.execute(JavaPluginLoader.java:286)
    18.09 11:00:10 [Server] INFO     at com.authdb.listeners.AuthDBPlayerListener.onPlayerMove(AuthDBPlayerListener.java:439)
    18.09 11:00:10 [Server] INFO     at com.authdb.AuthDB.isAuthorized(AuthDB.java:588)
    18.09 11:00:10 [Server] INFO     at com.authdb.util.databases.EBean.find(EBean.java:181)
    18.09 11:00:10 [Server] INFO     at com.authdb.util.databases.EBean.checkPlayer(EBean.java:69)
    18.09 11:00:10 [Server] INFO     at com.avaje.ebeaninternal.util.DefaultExpressionList.findUnique(DefaultExpressionList.java:217)
    18.09 11:00:10 [Server] INFO     at com.avaje.ebeaninternal.server.querydefn.DefaultOrmQuery.findUnique(DefaultOrmQuery.java:924)
    18.09 11:00:10 [Server] INFO     at com.avaje.ebeaninternal.server.core.DefaultServer.findUnique(DefaultServer.java:1236)
    18.09 11:00:10 [Server] INFO     at com.avaje.ebeaninternal.server.core.DefaultServer.findList(DefaultServer.java:1468)
    18.09 11:00:10 [Server] INFO     at com.avaje.ebeaninternal.server.core.OrmQueryRequest.initTransIfRequired(OrmQueryRequest.java:241)
    18.09 11:00:10 [Server] INFO     at com.avaje.ebeaninternal.server.core.DefaultServer.createQueryTransaction(DefaultServer.java:2021)
    18.09 11:00:10 [Server] INFO     at com.avaje.ebeaninternal.server.transaction.TransactionManager.createQueryTransaction(TransactionManager.java:356)
    18.09 11:00:10 [Server] INFO 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=true
    18.09 11:00:10 [Server] SEVERE Could not pass event PLAYER_MOVE to AuthDB
    18.09 11:00:09 [Server] INFO     ... 21 more
    18.09 11:00:09 [Server] INFO     at com.avaje.ebeaninternal.server.transaction.TransactionManager.createQueryTransaction(TransactionManager.java:339)
    18.09 11:00:09 [Server] INFO     at com.avaje.ebeaninternal.server.lib.sql.DataSourcePool.getConnection(DataSourcePool.java:646)
    18.09 11:00:09 [Server] INFO     at com.avaje.ebeaninternal.server.lib.sql.DataSourcePool.getPooledConnection(DataSourcePool.java:658)
    18.09 11:00:09 [Server] INFO     at com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue.getPooledConnection(PooledConnectionQueue.java:247)
    18.09 11:00:09 [Server] INFO     at com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue._getPooledConnection(PooledConnectionQueue.java:307)
    18.09 11:00:09 [Server] INFO     at com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue._getPooledConnectionWaitLoop(PooledConnectionQueue.java:329)
    18.09 11:00:09 [Server] INFO 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
    18.09 11:00:09 [Server] INFO     at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    18.09 11:00:09 [Server] INFO     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
    18.09 11:00:09 [Server] INFO     at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:454)
    18.09 11:00:09 [Server] INFO     at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
    18.09 11:00:09 [Server] INFO     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:89)
    18.09 11:00:09 [Server] INFO     at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
    18.09 11:00:09 [Server] INFO     at net.minecraft.server.Packet10Flying.a(SourceFile:126)
    18.09 11:00:09 [Server] INFO     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:174)
    18.09 11:00:09 [Server] INFO     at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:338)
    18.09 11:00:09 [Server] INFO     at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
    18.09 11:00:09 [Server] INFO     at org.bukkit.plugin.java.JavaPluginLoader$7.execute(JavaPluginLoader.java:286)
    18.09 11:00:09 [Server] INFO     at com.authdb.listeners.AuthDBPlayerListener.onPlayerMove(AuthDBPlayerListener.java:439)
    18.09 11:00:09 [Server] INFO     at com.authdb.AuthDB.isAuthorized(AuthDB.java:588)
    18.09 11:00:09 [Server] INFO     at com.authdb.util.databases.EBean.find(EBean.java:181)
    18.09 11:00:09 [Server] INFO     at com.authdb.util.databases.EBean.checkPlayer(EBean.java:69)
    18.09 11:00:09 [Server] INFO     at com.avaje.ebeaninternal.util.DefaultExpressionList.findUnique(DefaultExpressionList.java:217)
    18.09 11:00:09 [Server] INFO     at com.avaje.ebeaninternal.server.querydefn.DefaultOrmQuery.findUnique(DefaultOrmQuery.java:924)
    18.09 11:00:09 [Server] INFO     at com.avaje.ebeaninternal.server.core.DefaultServer.findUnique(DefaultServer.java:1236)
    18.09 11:00:09 [Server] INFO     at com.avaje.ebeaninternal.server.core.DefaultServer.findList(DefaultServer.java:1468)
    18.09 11:00:09 [Server] INFO     at com.avaje.ebeaninternal.server.core.OrmQueryRequest.initTransIfRequired(OrmQueryRequest.java:241)
    18.09 11:00:09 [Server] INFO     at com.avaje.ebeaninternal.server.core.DefaultServer.createQueryTransaction(DefaultServer.java:2021)
    18.09 11:00:09 [Server] INFO     at com.avaje.ebeaninternal.server.transaction.TransactionManager.createQueryTransaction(TransactionManager.java:356)
    18.09 11:00:09 [Server] INFO 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=true
    18.09 11:00:09 [Server] SEVERE Could not pass event PLAYER_MOVE to AuthDB
    18.09 11:00:08 [Server] INFO     ... 21 more
    18.09 11:00:08 [Server] INFO     at com.avaje.ebeaninternal.server.transaction.TransactionManager.createQueryTransaction(TransactionManager.java:339)
    18.09 11:00:08 [Server] INFO     at com.avaje.ebeaninternal.server.lib.sql.DataSourcePool.getConnection(DataSourcePool.java:646)
    18.09 11:00:08 [Server] INFO     at com.avaje.ebeaninternal.server.lib.sql.DataSourcePool.getPooledConnection(DataSourcePool.java:658)
    18.09 11:00:08 [Server] INFO     at com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue.getPooledConnection(PooledConnectionQueue.java:247)
    18.09 11:00:08 [Server] INFO     at com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue._getPooledConnection(PooledConnectionQueue.java:307)
    18.09 11:00:08 [Server] INFO     at com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue._getPooledConnectionWaitLoop(PooledConnectionQueue.java:329)
    18.09 11:00:08 [Server] INFO 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
    18.09 11:00:08 [Server] INFO     at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    18.09 11:00:08 [Server] INFO     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
    18.09 11:00:08 [Server] INFO     at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:454)
    18.09 11:00:08 [Server] INFO     at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
    18.09 11:00:08 [Server] INFO     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:89)
    18.09 11:00:08 [Server] INFO     at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
    18.09 11:00:08 [Server] INFO     at net.minecraft.server.Packet10Flying.a(SourceFile:126)
    18.09 11:00:08 [Server] INFO     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:174)
    18.09 11:00:08 [Server] INFO     at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:338)
    18.09 11:00:08 [Server] INFO     at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
    18.09 11:00:08 [Server] INFO     at org.bukkit.plugin.java.JavaPluginLoader$7.execute(JavaPluginLoader.java:286)
    18.09 11:00:08 [Server] INFO     at com.authdb.listeners.AuthDBPlayerListener.onPlayerMove(AuthDBPlayerListener.java:439)
    18.09 11:00:08 [Server] INFO     at com.authdb.AuthDB.isAuthorized(AuthDB.java:588)
    18.09 11:00:08 [Server] INFO     at com.authdb.util.databases.EBean.find(EBean.java:181)
    18.09 11:00:08 [Server] INFO     at com.authdb.util.databases.EBean.checkPlayer(EBean.java:69)
    18.09 11:00:08 [Server] INFO     at com.avaje.ebeaninternal.util.DefaultExpressionList.findUnique(DefaultExpressionList.java:217)
    18.09 11:00:08 [Server] INFO     at com.avaje.ebeaninternal.server.querydefn.DefaultOrmQuery.findUnique(DefaultOrmQuery.java:924)
    18.09 11:00:08 [Server] INFO     at com.avaje.ebeaninternal.server.core.DefaultServer.findUnique(DefaultServer.java:1236)
    18.09 11:00:08 [Server] INFO     at com.avaje.ebeaninternal.server.core.DefaultServer.findList(DefaultServer.java:1468)
    18.09 11:00:08 [Server] INFO     at com.avaje.ebeaninternal.server.core.OrmQueryRequest.initTransIfRequired(OrmQueryRequest.java:241)
    18.09 11:00:08 [Server] INFO     at com.avaje.ebeaninternal.server.core.DefaultServer.createQueryTransaction(DefaultServer.java:2021)
    18.09 11:00:08 [Server] INFO     at com.avaje.ebeaninternal.server.transaction.TransactionManager.createQueryTransaction(TransactionManager.java:356)
    18.09 11:00:08 [Server] INFO 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=true
    18.09 11:00:08 [Server] SEVERE Could not pass event PLAYER_MOVE to AuthDB
    18.09 11:00:07 [Server] INFO     ... 21 more
    18.09 11:00:07 [Server] INFO     at com.avaje.ebeaninternal.server.transaction.TransactionManager.createQueryTransaction(TransactionManager.java:339)
    18.09 11:00:07 [Server] INFO     at com.avaje.ebeaninternal.server.lib.sql.DataSourcePool.getConnection(DataSourcePool.java:646)
    18.09 11:00:07 [Server] INFO     at com.avaje.ebeaninternal.server.lib.sql.DataSourcePool.getPooledConnection(DataSourcePool.java:658)
    18.09 11:00:07 [Server] INFO     at com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue.getPooledConnection(PooledConnectionQueue.java:247)
    18.09 11:00:07 [Server] INFO     at com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue._getPooledConnection(PooledConnectionQueue.java:307)
    18.09 11:00:07 [Server] INFO     at com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue._getPooledConnectionWaitLoop(PooledConnectionQueue.java:329)
    18.09 11:00:07 [Server] INFO 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
    18.09 11:00:07 [Server] INFO     at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    18.09 11:00:07 [Server] INFO     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
    18.09 11:00:07 [Server] INFO     at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:454)
    18.09 11:00:07 [Server] INFO     at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
    18.09 11:00:07 [Server] INFO     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:89)
    18.09 11:00:07 [Server] INFO     at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
    18.09 11:00:07 [Server] INFO     at net.minecraft.server.Packet10Flying.a(SourceFile:126)
    18.09 11:00:07 [Server] INFO     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:174)
    18.09 11:00:07 [Server] INFO     at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:338)
    18.09 11:00:07 [Server] INFO     at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
    18.09 11:00:07 [Server] INFO     at org.bukkit.plugin.java.JavaPluginLoader$7.execute(JavaPluginLoader.java:286)
    18.09 11:00:07 [Server] INFO     at com.authdb.listeners.AuthDBPlayerListener.onPlayerMove(AuthDBPlayerListener.java:439)
    18.09 11:00:07 [Server] INFO     at com.authdb.AuthDB.isAuthorized(AuthDB.java:588)
    18.09 11:00:07 [Server] INFO     at com.authdb.util.databases.EBean.find(EBean.java:181)
    18.09 11:00:07 [Server] INFO     at com.authdb.util.databases.EBean.checkPlayer(EBean.java:69)
    18.09 11:00:07 [Server] INFO     at com.avaje.ebeaninternal.util.DefaultExpressionList.findUnique(DefaultExpressionList.java:217)
    18.09 11:00:07 [Server] INFO     at com.avaje.ebeaninternal.server.querydefn.DefaultOrmQuery.findUnique(DefaultOrmQuery.java:924)
    18.09 11:00:07 [Server] INFO     at com.avaje.ebeaninternal.server.core.DefaultServer.findUnique(DefaultServer.java:1236)
    18.09 11:00:07 [Server] INFO     at com.avaje.ebeaninternal.server.core.DefaultServer.findList(DefaultServer.java:1468)
    18.09 11:00:07 [Server] INFO     at com.avaje.ebeaninternal.server.core.OrmQueryRequest.initTransIfRequired(OrmQueryRequest.java:241)
    18.09 11:00:07 [Server] INFO     at com.avaje.ebeaninternal.server.core.DefaultServer.createQueryTransaction(DefaultServer.java:2021)
    18.09 11:00:07 [Server] INFO     at com.avaje.ebeaninternal.server.transaction.TransactionManager.createQueryTransaction(TransactionManager.java:356)
    18.09 11:00:07 [Server] INFO 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=true
    18.09 11:00:07 [Server] SEVERE Could not pass event PLAYER_MOVE to AuthDB
    18.09 11:00:06 [Server] INFO     ... 21 more
    18.09 11:00:06 [Server] INFO     at com.avaje.ebeaninternal.server.transaction.TransactionManager.createQueryTransaction(TransactionManager.java:339)
    18.09 11:00:06 [Server] INFO     at com.avaje.ebeaninternal.server.lib.sql.DataSourcePool.getConnection(DataSourcePool.java:646)
    18.09 11:00:06 [Server] INFO     at com.avaje.ebeaninternal.server.lib.sql.DataSourcePool.getPooledConnection(DataSourcePool.java:658)
    18.09 11:00:06 [Server] INFO     at com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue.getPooledConnection(PooledConnectionQueue.java:247)
    18.09 11:00:06 [Server] INFO     at com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue._getPooledConnection(PooledConnectionQueue.java:307)
    18.09 11:00:06 [Server] INFO     at com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue._getPooledConnectionWaitLoop(PooledConnectionQueue.java:329)
    18.09 11:00:06 [Server] INFO 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
    18.09 11:00:06 [Server] INFO     at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    18.09 11:00:06 [Server] INFO     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
    18.09 11:00:06 [Server] INFO     at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:454)
    18.09 11:00:06 [Server] INFO     at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
    18.09 11:00:06 [Server] INFO     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:89)
    18.09 11:00:06 [Server] INFO     at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
    18.09 11:00:06 [Server] INFO     at net.minecraft.server.Packet10Flying.a(SourceFile:126)
    18.09 11:00:06 [Server] INFO     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:174)
    18.09 11:00:06 [Server] INFO     at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:338)
    18.09 11:00:06 [Server] INFO     at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
    18.09 11:00:06 [Server] INFO     at org.bukkit.plugin.java.JavaPluginLoader$7.execute(JavaPluginLoader.java:286)
    18.09 11:00:06 [Server] INFO     at com.authdb.listeners.AuthDBPlayerListener.onPlayerMove(AuthDBPlayerListener.java:439)
    18.09 11:00:06 [Server] INFO     at com.authdb.AuthDB.isAuthorized(AuthDB.java:588)
    18.09 11:00:06 [Server] INFO     at com.authdb.util.databases.EBean.find(EBean.java:181)
    18.09 11:00:06 [Server] INFO     at com.authdb.util.databases.EBean.checkPlayer(EBean.java:69)
    18.09 11:00:06 [Server] INFO     at com.avaje.ebeaninternal.util.DefaultExpressionList.findUnique(DefaultExpressionList.java:217)
    18.09 11:00:06 [Server] INFO     at com.avaje.ebeaninternal.server.querydefn.DefaultOrmQuery.findUnique(DefaultOrmQuery.java:924)
    18.09 11:00:06 [Server] INFO     at com.avaje.ebeaninternal.server.core.DefaultServer.findUnique(DefaultServer.java:1236)
    18.09 11:00:06 [Server] INFO     at com.avaje.ebeaninternal.server.core.DefaultServer.findList(DefaultServer.java:1468)
    18.09 11:00:06 [Server] INFO     at com.avaje.ebeaninternal.server.core.OrmQueryRequest.initTransIfRequired(OrmQueryRequest.java:241)
    18.09 11:00:06 [Server] INFO     at com.avaje.ebeaninternal.server.core.DefaultServer.createQueryTransaction(DefaultServer.java:2021)
    18.09 11:00:06 [Server] INFO     at com.avaje.ebeaninternal.server.transaction.TransactionManager.createQueryTransaction(TransactionManager.java:356)
    18.09 11:00:06 [Server] INFO 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=true
    18.09 11:00:06 [Server] SEVERE Could not pass event PLAYER_MOVE to AuthDB
    18.09 11:00:05 [Server] INFO     ... 21 more
    18.09 11:00:05 [Server] INFO     at com.avaje.ebeaninternal.server.transaction.TransactionManager.createQueryTransaction(TransactionManager.java:339)
    18.09 11:00:05 [Server] INFO     at com.avaje.ebeaninternal.server.lib.sql.DataSourcePool.getConnection(DataSourcePool.java:646)
    18.09 11:00:05 [Server] INFO     at com.avaje.ebeaninternal.server.lib.sql.DataSourcePool.getPooledConnection(DataSourcePool.java:658)
    18.09 11:00:05 [Server] INFO     at com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue.getPooledConnection(PooledConnectionQueue.java:247)
    18.09 11:00:05 [Server] INFO     at com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue._getPooledConnection(PooledConnectionQueue.java:307)
    18.09 11:00:05 [Server] INFO     at com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue._getPooledConnectionWaitLoop(PooledConnectionQueue.java:329)
    18.09 11:00:05 [Server] INFO 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
    18.09 11:00:05 [Server] INFO     at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    18.09 11:00:05 [Server] INFO     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
    18.09 11:00:05 [Server] INFO     at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:454)
    18.09 11:00:05 [Server] INFO     at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
    18.09 11:00:05 [Server] INFO     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:89)
    18.09 11:00:05 [Server] INFO     at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
    18.09 11:00:05 [Server] INFO     at net.minecraft.server.Packet10Flying.a(SourceFile:126)
    18.09 11:00:05 [Server] INFO     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:174)
    18.09 11:00:05 [Server] INFO     at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:338)
    18.09 11:00:05 [Server] INFO     at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
    18.09 11:00:05 [Server] INFO     at org.bukkit.plugin.java.JavaPluginLoader$7.execute(JavaPluginLoader.java:286)
    18.09 11:00:05 [Server] INFO     at com.authdb.listeners.AuthDBPlayerListener.onPlayerMove(AuthDBPlayerListener.java:439)
    18.09 11:00:05 [Server] INFO     at com.authdb.AuthDB.isAuthorized(AuthDB.java:588)
    18.09 11:00:05 [Server] INFO     at com.authdb.util.databases.EBean.find(EBean.java:181)
    18.09 11:00:05 [Server] INFO     at com.authdb.util.databases.EBean.checkPlayer(EBean.java:69)
    18.09 11:00:05 [Server] INFO     at com.avaje.ebeaninternal.util.DefaultExpressionList.findUnique(DefaultExpressionList.java:217)
    18.09 11:00:05 [Server] INFO     at com.avaje.ebeaninternal.server.querydefn.DefaultOrmQuery.findUnique(DefaultOrmQuery.java:924)
    18.09 11:00:05 [Server] INFO     at com.avaje.ebeaninternal.server.core.DefaultServer.findUnique(DefaultServer.java:1236)
    18.09 11:00:05 [Server] INFO     at com.avaje.ebeaninternal.server.core.DefaultServer.findList(DefaultServer.java:1468)
    18.09 11:00:05 [Server] INFO     at com.avaje.ebeaninternal.server.core.OrmQueryRequest.initTransIfRequired(OrmQueryRequest.java:241)
    18.09 11:00:05 [Server] INFO     at com.avaje.ebeaninternal.server.core.DefaultServer.createQueryTransaction(DefaultServer.java:2021)
    18.09 11:00:05 [Server] INFO     at com.avaje.ebeaninternal.server.transaction.TransactionManager.createQueryTransaction(TransactionManager.java:356)
    18.09 11:00:05 [Server] INFO 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=true
    18.09 11:00:05 [Server] SEVERE Could not pass event PLAYER_MOVE to AuthDB
    18.09 11:00:04 [Server] INFO     ... 21 more
    18.09 11:00:04 [Server] INFO     at com.avaje.ebeaninternal.server.transaction.TransactionManager.createQueryTransaction(TransactionManager.java:339)
    18.09 11:00:04 [Server] INFO     at com.avaje.ebeaninternal.server.lib.sql.DataSourcePool.getConnection(DataSourcePool.java:646)
    18.09 11:00:04 [Server] INFO     at com.avaje.ebeaninternal.server.lib.sql.DataSourcePool.getPooledConnection(DataSourcePool.java:658)
    18.09 11:00:04 [Server] INFO     at com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue.getPooledConnection(PooledConnectionQueue.java:247)
    18.09 11:00:04 [Server] INFO     at com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue._getPooledConnection(PooledConnectionQueue.java:307)
    18.09 11:00:04 [Server] INFO     at com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue._getPooledConnectionWaitLoop(PooledConnectionQueue.java:329)
    [B]18.09 11:00:04 [Server] INFO 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[/B]
    18.09 11:00:04 [Server] INFO     at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    18.09 11:00:04 [Server] INFO     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
    18.09 11:00:04 [Server] INFO     at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:454)
    18.09 11:00:04 [Server] INFO     at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
    18.09 11:00:04 [Server] INFO     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:89)
    18.09 11:00:04 [Server] INFO     at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
    18.09 11:00:04 [Server] INFO     at net.minecraft.server.Packet10Flying.a(SourceFile:126)
    18.09 11:00:04 [Server] INFO     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:174)
    18.09 11:00:04 [Server] INFO     at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:338)
    18.09 11:00:04 [Server] INFO     at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
    18.09 11:00:04 [Server] INFO     at org.bukkit.plugin.java.JavaPluginLoader$7.execute(JavaPluginLoader.java:286)
    18.09 11:00:04 [Server] INFO     at com.authdb.listeners.AuthDBPlayerListener.onPlayerMove(AuthDBPlayerListener.java:439)
    18.09 11:00:04 [Server] INFO     at com.authdb.AuthDB.isAuthorized(AuthDB.java:588)
    18.09 11:00:04 [Server] INFO     at com.authdb.util.databases.EBean.find(EBean.java:181)
    18.09 11:00:04 [Server] INFO     at com.authdb.util.databases.EBean.checkPlayer(EBean.java:69)
    18.09 11:00:04 [Server] INFO     at com.avaje.ebeaninternal.util.DefaultExpressionList.findUnique(DefaultExpressionList.java:217)
    
     
  8. Offline

    Black_Jack

    Yea, and another issue. The delay between mesagges. Does it work properly? I'm setted it to 10 seconds, but it still showing me before motd. For example:
    [​IMG]
     
  9. Offline

    Kiborgik

    timeouts not working
    таймауты не работают у них сейчас, это одна из главных проблем :)

    Code:
    18.09 14:24:34 [Connect] User Pryxas, IP 91.124.131.231
    18.09 14:24:32 [Server] INFO [PLAYER_COMMAND] Grimnir: /town spawn
    18.09 14:24:26 [Disconnect] User Pryxas has disconnected, reason: disconnect.endOfStream
    18.09 14:24:21 [Disconnect] User Wolf_man has disconnected, reason: disconnect.endOfStream
    18.09 14:24:16 [Disconnect] User YurikNazarov has disconnected, reason: disconnect.endOfStream
    18.09 14:24:08 [Multicraft] OIL ran command Message of the Day
    18.09 14:24:08 [Connect] User OIL, IP 194.247.190.6
    18.09 14:24:01 [Disconnect] User Overjay has disconnected, reason: disconnect.endOfStream
    18.09 14:23:56 [Disconnect] User 4Donic has disconnected, reason: disconnect.endOfStream
    18.09 14:23:51 [Disconnect] User Kostyashka has disconnected, reason: disconnect.endOfStream
    18.09 14:23:47 [Disconnect] User OIL has disconnected, reason: disconnect.endOfStream
    18.09 14:23:47 [Server] INFO Disconnecting Overjay [/178.94.61.57:8347]: Sorry, a player with that name is already logged in on this server.
    18.09 14:23:46 [Server] INFO Pryxas [/91.124.131.231:1615] lost connection
    18.09 14:23:46 [Server] INFO Disconnecting Pryxas [/91.124.131.231:1615]: Sorry, a player with that name is already logged in on this server.
    18.09 14:23:40 [Disconnect] User cherchuk has disconnected, reason: disconnect.endOfStream
    18.09 14:23:40 [Server] INFO /178.158.105.204:1917 lost connection
    18.09 14:23:40 [Server] INFO Pryxas [/91.124.131.231:1600] lost connection
    18.09 14:23:40 [Server] INFO Disconnecting Pryxas [/91.124.131.231:1600]: Sorry, a player with that name is already logged in on this server.
    18.09 14:23:14 [Disconnect] User slava0010 has disconnected, reason: disconnect.endOfStream
    18.09 14:22:58 [Server] INFO Disconnecting Pryxas [/91.124.131.231:1599]: Sorry, a player with that name is already logged in on this server.
    18.09 14:22:58 [Server] INFO /91.124.131.231:1598 lost connection
    18.09 14:22:58 [Server] INFO /91.124.131.231:1595 lost connection
    18.09 14:22:58 [Server] INFO Wolf_man [/178.158.105.204:1886] lost connection
    18.09 14:22:58 [Server] INFO Disconnecting Wolf_man [/178.158.105.204:1886]: Sorry, a player with that name is already logged in on this server.
    18.09 14:22:58 [Server] INFO Pryxas [/91.124.131.231:1592] lost connection
    18.09 14:22:58 [Server] INFO Disconnecting Pryxas [/91.124.131.231:1592]: Sorry, a player with that name is already logged in on this server.
    18.09 14:22:58 [Server] INFO Connection reset
    18.09 14:22:24 [Server] INFO /92.47.212.131:1975 lost connection
    18.09 14:22:24 [Server] INFO Pryxas [/91.124.131.231:1591] lost connection
    18.09 14:22:24 [Server] INFO Disconnecting Pryxas [/91.124.131.231:1591]: Sorry, a player with that name is already logged in on this server.
    18.09 14:22:24 [Server] INFO Wolf_man [/178.158.105.204:1849] lost connection
    18.09 14:22:24 [Server] INFO Disconnecting Wolf_man [/178.158.105.204:1849]: Sorry, a player with that name is already logged in on this server.
    18.09 14:22:24 [Server] INFO Overjay [/178.94.61.57:8336] lost connection
    18.09 14:22:24 [Server] INFO Disconnecting Overjay [/178.94.61.57:8336]: Sorry, a player with that name is already logged in on this server.
    18.09 14:21:39 [Server] SEVERE     at net.minecraft.server.NetworkReaderThread.run(SourceFile:84)
    18.09 14:21:39 [Server] SEVERE     at net.minecraft.server.NetworkManager.c(NetworkManager.java:259)
    18.09 14:21:39 [Server] SEVERE     at net.minecraft.server.NetworkManager.g(NetworkManager.java:149)
    18.09 14:21:39 [Server] SEVERE     at net.minecraft.server.Packet.a(Packet.java:73)
    18.09 14:21:39 [Server] SEVERE java.io.IOException: Bad packet id 254
    18.09 14:21:37 [Server] INFO /92.47.212.131:1960 lost connection
    18.09 14:21:37 [Server] INFO /195.211.229.250:1259 lost connection
    18.09 14:21:37 [Server] INFO /178.158.105.204:1828 lost connection
    18.09 14:21:37 [Server] INFO /92.47.212.131:1948 lost connection
    18.09 14:21:37 [Server] INFO /195.211.229.250:1257 lost connection
    18.09 14:21:37 [Server] INFO /91.124.131.231:1590 lost connection
    18.09 14:21:36 [Server] INFO Save complete.
    18.09 14:21:34 [Server] INFO Forcing save..
    18.09 14:21:34 [Server] INFO Enabling level saving..
    
    some advanced info, maybe help you

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

    Black_Jack

    Is it able to login only users, which confirmed theirs accounts, for example, via e-mail?
     
  11. Offline

    Wulfspider

    Did they register in-game or online? Pretty sure we don't have activation checks yet.
     
  12. Offline

    Black_Jack

    Online, not in-game
     
  13. Offline

    Wulfspider

    Are you certain they aren't activated? Could you view your AuthDB.db with a tool such as Lita and look to see if it shows a 1 under the activated column next to their name? I don't think this is the issue though as I don't see anything using that code yet.
     
  14. Offline

    Kiborgik

    Hello, any prognoses when your fix a VERY BIG lags, when player connected but not logon (include not working timeouts). It's a best auth plugin, but 1 bug crash all server (maybe problem on new player_move on bukkit? maybe need some configure? ). I tested allow-fly: true/false (result is one), disabled all plugins, but result is one...
     
  15. Offline

    Black_Jack

    Nope, noone have 1
     
  16. Offline

    l104693

    Hey Wolfspider!

    Thank you for updating to 2.3 and the bugfixes :)

    I have a problem with Authdb and my server.
    When I have: "keepalive: false" everything works but at each player join and login there is an immense lagg.
    I can solve this with: "keepalive: true" However, after several minutes (15 or something) my whole server is crashing because authdb is spamming error's. http://pastebin.com/0QqLvX6Q

    What do you suggest I do?

    Kind Regards, l104693
     
  17. Offline

    Kiborgik

    AuthDB version: 2.3.3.222 0_o
    hm.....maybe problem only on 3.0.9 phpbb ???
     
  18. Offline

    Wulfspider

    Could you stop your server, backup your AuthDB.db some where safe, and then delete the one under plugins/AuthDB and then start the server again and see if it works?

    Most servers can't handle keepalive: true, and that shouldn't solve your issue because each player would be opening a new connection either way. We'll have to look into it more. What are your server specs and how much memory have you assigned to your server?

    Could you try setting the freeze delay to a little longer or disabling it and then testing if you have the lag issues?

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Jul 15, 2016
  19. This plugin works perfekt with Minecraft 1.8.1 and Bukkit 1043, just so you know. :) (Well, it works for me anyway)

    I just have a small noob-question. Is there any way to disable the registration ingame and force everyone to first register on the webpage? This way I can make sure that every player registers with the information I want them to and not just a playername and email.

    Anyway. Cheers :)
     
  20. Offline

    Wulfspider

    register:
    enabled: false

    We're going to add an option in an upcoming version for sending them a custom message too.
     
  21. Ah, ok. Didn't have the guts to try that one. Was afraid it meant that all registrations was turned of and only those already registred could log in :p

    Thanks for the quick reply btw. :)

    EDIT: I think I'll wait for the update with a custom message and just continue using it as I am right now. I've just changed the "please register with..." to a "To be able to play here, register at <website>". This way only those that knows AuthDB and knows it's AuthDB I'm using knows that you need both pass and email.

    It's my halfway solution :)
     
  22. I was having troubles making Drupal 7 work with this (using the dev version) because the hash seemed to come out wrong so I edited it to make the hash from the password work correctly, and I can see that the password check in the script returns true but ingame it still says password incorrect, are there known bugs outside the script itself?
     
  23. Offline

    Wulfspider

    Drupal 7 isn't supported yet.
     
  24. Yes I know, I had already ported the password.inc of drupal 7, it was pretty similar to the Drupal.java included in the dev release with a couple of small differences, but it successfully can check a password against the hashed password from the database, was just wondering why even though the method returns true AuthDB still thinks it failed

    Think I found the problem, user_check_password returns whether the password is equal to the hashed version from the database whereas Util.java:343 says

    Code:
    if (storedPassword != null && storedPassword.equals(Drupal.user_check_password(password, storedPassword))) {
                                return true;
                            }
                            String hash = MySQL.getfromtable(Config.script_tableprefix + "" + usertable + "", "`" + passwordfield + "`", "" + usernamefield + "", player);
                            EBean.checkPassword(player, hash);
                            if (hash.equals(Drupal.user_check_password(password, hash))) {
                                return true;
                            }
    if user_check_password returns a boolean we dont need to check it against the stored password

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

    l104693

    "Keepalive: true" does solve the solution! I don't experience lagg :) Honestly! Only problem is that stacktrace thing.
    My server specs:
    Windows 7 x64, Intel Core Quad 2.2 Ghz, 4 GB ram, 2,5 GB allocated to the server.
    Running java x64,
     
  26. Offline

    Wulfspider

    It is also the cause of your problem as you run out of available connections I believe.
     
  27. Changing those lines in Util.java and copying the classes into my jar solved the login issue for drupal 7, I changed them to this:

    Code:
    if (storedPassword != null && Drupal.user_check_password(password, storedPassword)) {
                                return true;
                            }
                            String hash = MySQL.getfromtable(Config.script_tableprefix + "" + usertable + "", "`" + passwordfield + "`", "" + usernamefield + "", player);
                            EBean.checkPassword(player, hash);
                            if (Drupal.user_check_password(password, hash)) {
                                return true;
                            }
    
    Don't know about registering or the other functions, all I needed was login to work[/CODE]
     
  28. Offline

    l104693

    Okay, I will get used to the current login lagg then :)
    Or do you know a way to synchronize your forum database with your local database each hour?
     
  29. Offline

    Wulfspider

    If we did that, people would have a pile of lag instead of a tiny period. We'd rather work on a fix for the login sync.
     
  30. Offline

    Kiborgik

    yes, have, i disable it, and players can walking, but not logon, and lags...even i player dont logon :(((

    i send this file few days ago?
    1. when i connect whith test acount in logs NO INFO with debug mode on (and not logon)
    2. have lag every player on server
    3. when i disconect from server with test acaount
    4. and no lags

    and every day i see log like this...
    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Feb 15, 2019
  31. Offline

    Wulfspider

    If you have debug mode on, do you see anything spamming in the console during that time?
     

Share This Page