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

    [​IMG]
    v2.3.5
    Download ZIP bundle or JAR only
    Changelog
    Fixed "javax.persistence.PersistenceException: Unique expecting 0 or 1 rows but got [2]" errors.​
    Fixed Java complaining how a default field in MySQL is NULL. Set it to none instead.​
     
  3. Offline

    contex

    Would just like to thank rustymetal for helping me test :)
     
  4. Offline

    rustymetal

    Anytime. Is there something that must be done to a current database? If I use my old database I am getting the Syncthread error line 49. But appears to work with new DB / 1 user.
     
  5. 2.3.5.240 is definetely an improvement on the previous build as it doesn't flood/spam any OnEvent-errors and the plugin finally functions :D , but i'm getting some stracktrace errors on an existing MySQL/AuthDB.db database and each new player that connects/haven't registered an account yet.

    Server console:
    2012-03-12-error.log:

    EDIT: Hmm, this is strange. When testing it on a fresh MySQL database/AuthDB.db it refuses to create the authdb_users table (this while customdb and autocreate is true in advanced.yml).

    Server console:
    2012-03-12-error.log
    And whenever someone connects i get the following:

    In-game
    Server console
    2012-03-12-error.log
    TLDR? :p

    (edited 21 times... :oops:)
     
  6. Offline

    Archa

    Same here... Stacktrace:

    2012/03/12 11:07:00 - --------------------------- STACKTRACE ERROR ---------------------------
    2012/03/12 11:07:00 - Class name: com.authdb.util.threads.SyncThread
    2012/03/12 11:07:00 - File name: SyncThread.java
    2012/03/12 11:07:00 - Function name: run
    2012/03/12 11:07:00 - Error line: 49
    2012/03/12 11:07:00 - AuthDB version: 2.3.5.240
    2012/03/12 11:07:00 - Keep alive: false
    2012/03/12 11:07:00 - MySQL connection: true
    2012/03/12 11:07:00 - Latest query: SELECT username FROM `authdb_users` WHERE `username` = 'player' LIMIT 1
    2012/03/12 11:07:00 - Script: Custom
    2012/03/12 11:07:00 - Custom table: authdb_users
    2012/03/12 11:07:00 - Custom passfield: password
    2012/03/12 11:07:00 - Custom userfield: username
    2012/03/12 11:07:00 - Custom encryption: md5
    2012/03/12 11:07:00 - Custom table schema:
    2012/03/12 11:07:01 - Table Name : authdb_users
    2012/03/12 11:07:01 - Column Type(size)
    2012/03/12 11:07:01 - id INT(4)
    2012/03/12 11:07:01 - regdate TIMESTAMP(19)
    2012/03/12 11:07:01 - username VARCHAR(40)
    2012/03/12 11:07:01 - password VARCHAR(40)
    2012/03/12 11:07:01 - email VARCHAR(100)
    2012/03/12 11:07:01 - Plugins: WorldEdit 5.3-SNAPSHOT, iConomy 6.0.9b, AuthDB 2.3.5.240, Vault 1.2.12-b136, PermissionsEx 1.19.1, Modifyworld 1.19, CombatTag 3.8, WorldGuard 5.5.2-SNAPSHOT, FoundDiamonds 3.1.1, Essentials 2.8.3, EssentialsSpawn 2.8.3, Permissions 2.7.7, VanishNoPacket 3.5, EssentialsChat 2.8.3, LWC 4.1.1 (b645-git-b24cc99e), Factions 1.6.6b, Jobs 2.6.3, ChestShop 3.36,
    2012/03/12 11:07:01 - --------------------------- STACKTRACE START ---------------------------
    2012/03/12 11:07:01 - sun.reflect.GeneratedConstructorAccessor62.newInstance(Unknown Source)
    2012/03/12 11:07:01 - sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    2012/03/12 11:07:01 - java.lang.reflect.Constructor.newInstance(Constructor.java:525)
    2012/03/12 11:07:01 - com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2012/03/12 11:07:01 - com.mysql.jdbc.Util.getInstance(Util.java:382)
    2012/03/12 11:07:01 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
    2012/03/12 11:07:01 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
    2012/03/12 11:07:01 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
    2012/03/12 11:07:01 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
    2012/03/12 11:07:01 - com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.java:1213)
    2012/03/12 11:07:01 - com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1200)
    2012/03/12 11:07:01 - com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2485)
    2012/03/12 11:07:01 - com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2467)
    2012/03/12 11:07:01 - com.authdb.util.databases.MySQL.getfromtable(MySQL.java:226)
    2012/03/12 11:07:01 - com.authdb.util.Util.checkScript(Util.java:103)
    2012/03/12 11:07:01 - com.authdb.util.threads.SyncThread.run(SyncThread.java:29)
    2012/03/12 11:07:01 - com.authdb.util.databases.EBean.sync(EBean.java:89)
    2012/03/12 11:07:01 - com.authdb.util.databases.EBean.sync(EBean.java:84)
    2012/03/12 11:07:01 - com.authdb.listeners.AuthDBPlayerListener.onPlayerLogin(AuthDBPlayerListener.java:75)
    2012/03/12 11:07:01 - sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2012/03/12 11:07:01 - sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    2012/03/12 11:07:01 - sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    2012/03/12 11:07:01 - java.lang.reflect.Method.invoke(Method.java:601)
    2012/03/12 11:07:01 - org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:301)
    2012/03/12 11:07:01 - org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62)
    2012/03/12 11:07:01 - org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:441)
    2012/03/12 11:07:01 - net.minecraft.server.ServerConfigurationManager.attemptLogin(ServerConfigurationManager.java:229)
    2012/03/12 11:07:01 - net.minecraft.server.NetLoginHandler.b(NetLoginHandler.java:102)
    2012/03/12 11:07:01 - net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:94)
    2012/03/12 11:07:01 - net.minecraft.server.Packet1Login.handle(SourceFile:68)
    2012/03/12 11:07:01 - net.minecraft.server.NetworkManager.b(NetworkManager.java:229)
    2012/03/12 11:07:01 - net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:48)
    2012/03/12 11:07:01 - net.minecraft.server.NetworkListenThread.a(NetworkListenThread.java:61)
    2012/03/12 11:07:01 - net.minecraft.server.MinecraftServer.w(MinecraftServer.java:554)
    2012/03/12 11:07:01 - net.minecraft.server.MinecraftServer.run(MinecraftServer.java:452)
    2012/03/12 11:07:01 - net.minecraft.server.ThreadServerApplication.run(SourceFile:490)
    2012/03/12 11:07:01 - ---------------------------- STACKTRACE END ----------------------------
     
  7. Offline

    rustymetal

    I compared the 2 databases, and there is 2 differences.
    password changes from varchar(40) to varchar(128)
    Email is no longer is default NULL.

    I made these changes to my real database, and the error still appearing. :(
    edit > probably need to change all my current entry emails off of NULL let me give that a try.

    Hmm I made these changes and the error is the same, but the behavior is different.

    Instead of appearing on every user loggin in the server, it only appears when a player logs in that is not registered/sessioned or [i think] is not in the AuthDB.db file

    If I were to make a new server/database, login and register i would get the error but after i restart server and join the server the error no-longer presents itself.

    I can force the error by deleted the AuthDB.db file. Seems to be a security hole; as the AuthDB.db file appears to not refresh itself from a server restart. Possibly time based?

    edit>
    Also contex I tried the dev build u gave me last night again, because I remember that had no problems. But I only deleted the sql database as instructed and not the AuthDB.db. I didn't notice at the time I stayed logged-in as I was focused on server log. it works but if I delete the AuthDB file it will error. [v2.3.4.239]
     
  8. Offline

    dfdgsdfg

    Server crash with 2.3.5

    Code:
    2012-03-12 20:31:10 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    org.bukkit.event.EventException
        at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:303)
        at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62)
        at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:441)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:212)
        at lishid.orebfuscator.hook.NetServerHandlerProxy.a(NetServerHandlerProxy.java:76)
        at net.minecraft.server.Packet10Flying.handle(SourceFile:126)
        at net.minecraft.server.NetworkManager.b(NetworkManager.java:229)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:116)
        at lishid.orebfuscator.hook.NetServerHandlerProxy.a(NetServerHandlerProxy.java:60)
        at net.minecraft.server.NetworkListenThread.a(NetworkListenThread.java:78)
        at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:554)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:452)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:490)
    Caused by: 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
        at com.avaje.ebeaninternal.server.transaction.TransactionManager.createQueryTransaction(TransactionManager.java:356)
        at com.avaje.ebeaninternal.server.core.DefaultServer.createQueryTransaction(DefaultServer.java:2021)
        at com.avaje.ebeaninternal.server.core.OrmQueryRequest.initTransIfRequired(OrmQueryRequest.java:241)
        at com.avaje.ebeaninternal.server.core.DefaultServer.findList(DefaultServer.java:1468)
        at com.avaje.ebeaninternal.server.core.DefaultServer.findUnique(DefaultServer.java:1236)
        at com.avaje.ebeaninternal.server.querydefn.DefaultOrmQuery.findUnique(DefaultOrmQuery.java:924)
        at com.avaje.ebeaninternal.util.DefaultExpressionList.findUnique(DefaultExpressionList.java:217)
        at com.authdb.util.databases.EBean.checkPlayer(EBean.java:68)
        at com.authdb.util.databases.EBean.find(EBean.java:150)
        at com.authdb.AuthDB.isAuthorized(AuthDB.java:701)
        at com.authdb.listeners.AuthDBPlayerListener.onPlayerMove(AuthDBPlayerListener.java:436)
        at sun.reflect.GeneratedMethodAccessor36.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:301)
        ... 12 more
    Caused by: java.sql.SQLException: Unsuccessfully waited [1000] millis for a connection to be returned. No connections are free. You need to Increase the max connections of [20] or look for a connection pool leak using datasource.xxx.capturestacktrace=true
        at com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue._getPooledConnectionWaitLoop(PooledConnectionQueue.java:329)
        at com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue._getPooledConnection(PooledConnectionQueue.java:307)
        at com.avaje.ebeaninternal.server.lib.sql.PooledConnectionQueue.getPooledConnection(PooledConnectionQueue.java:247)
        at com.avaje.ebeaninternal.server.lib.sql.DataSourcePool.getPooledConnection(DataSourcePool.java:658)
        at com.avaje.ebeaninternal.server.lib.sql.DataSourcePool.getConnection(DataSourcePool.java:646)
        at com.avaje.ebeaninternal.server.transaction.TransactionManager.createQueryTransaction(TransactionManager.java:339)
        ... 26 more
    Here is my environment with world guard report.

    Code:
    WorldGuard Configuration Report
    Generated 2012-03-12 20:35 +0900
     
    Version: 5.5.2-SNAPSHOT
     
    ------------------
    Server Information
    ------------------
     
    Java                : Oracle Corporation 1.7.0_03 (http://java.oracle.com/)
    Operating system    : Windows Server 2008 R2 6.1 (amd64)
    Available processors: 3
    Free memory        : 3770 MB
    Max memory          : 4096 MB
    Total memory        : 4096 MB
    Server ID          : unnamed
    Server name        : Se Ma Ul
    Implementation      : git-Bukkit-1.2.3-R0.2-b2060jnks (MC: 1.2.3)
    Player count        : 3/40
     
    -------
    Plugins
    -------
     
    LagMeter            : 1.7
    Orebfuscator        : 1.4.1-beta8
    WorldEdit            : 5.3-SNAPSHOT
    CommandBook          : 2.1-SNAPSHOT
    MeasuringTape        : 0.9c
    Backup              : 1.8.9-dev
    Vault                : 1.2.12-b136
    Multiverse-Core      : 2.4-b515
    PermissionsEx        : 1.19.1
    WorldGuard          : 5.5.2-SNAPSHOT
    Whitelist            : 2.7
    RemoteToolkitPlugin  : 0.6
    mChatSuite          : 1.1-b164jnks-R10
    PhysicalShop        : 9.0.13
    CraftIRC            : 3.3
    iConomy              : 6.0.9b
    ProperTime          : 2.1
    Permissions          : 2.7.7
    Warrant              : 4.0.3
    ChestBank            : 1.4.3
    NoFarm              : 0.3.6
    BKCommonLib          : 1.15
    RedstoneClockDetector: 0.2.5
    Lockette            : 1.5
    Modifyworld          : 1.19
    kNoHax              : 0.5.0
    WorldBorder          : 1.5.3
    Multiverse-Portals  : 2.4-b523
    dynmap              : 0.34-957
    Dynmap-WorldGuard    : 0.15
    HawkEye              : 1.0.6
    NoLagg              : 1.77
    VanishNoPacket      : 3.5
    Dynmap-SimpleClans  : 1.2.3
    PreciousStones      : 8.3.2
    SimpleClans          : 2.2
     
     
    -------------
    END OF REPORT
    
     
  9. Offline

    nFamous

    I have to report the same error, happening with every build since #236. At the moment, I'm running a testing server to evaluate Bukkit for Minecraft 1.2 and especially the plugin compatibility. All other plugins used (see below) are running smoothly compared to AuthDB.

    Whenever a player logs in, does an action or logs out, I get those 'Could not pass event XY' errors:
    Console Errors

    The server environment:
    • Windows Server 2008 R2 x64 with Java 1.7.0_03-b05 64-bit (Java 7)
    • Latest Bukkit dev build (atm: #2063)
    • MySQL 5.5.20 running on the same box
    Other Plugins:
    Plugins (open)

    • Essentials & EssentialsProtect
    • LWC
    • MaxEnchanting
    • MineBackup
    • Modifyworld
    • Multiverse-Core, Inventories, NetherPortals
    • PermissionsEX & PermissionsCompat
    • Residence
    • TreeAssist
    • Vault

    What I already tried:
    • Removing all plugins except AuthDB -> even more 'Could not pass event XY' errors
    • Creating new database for AuthDB -> it succesfully creates all needed tables, but the same errors occur after player login
    • Tried different AuthDB and Bukkit builds (both dev and beta) -> still the same
    Interestingly, AuthDB never stops working, it only throws those exceptions, but neither gives any errors, debug logs or stacktrace itself nor more information with debug: true option. The connection to the MySQL runs perfectly and the configured user has all privileges to do anything with the specified database.

    Besides this nasty, nasty bug I never had any of those other errors like those fixed in v2.3.5.

    Thanks in advance for any help given and if I forgot an important piece of information let me know.
     
  10. Offline

    ashimi

    Code:
    2012-03-12 10:12:26 [SEVERE] Could not pass event PlayerLoginEvent to AuthDB
    org.bukkit.event.EventException 
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:303) 
    at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62) 
    at org.bukkit.plugin.TimedRegisteredListener.callEvent(TimedRegisteredListener.java:30) 
    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:441) 
    at net.minecraft.server.ServerConfigurationManager.attemptLogin(ServerConfigurationManager.java:229) 
    at net.minecraft.server.NetLoginHandler.b(NetLoginHandler.java:102) 
    at net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:94) 
    at net.minecraft.server.Packet1Login.handle(SourceFile:68) 
    at net.minecraft.server.NetworkManager.b(NetworkManager.java:229) 
    at net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:48) 
    at net.minecraft.server.NetworkListenThread.a(NetworkListenThread.java:61) 
    at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:554) 
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:452) 
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:490) 
    Caused by: [2] 
    at com.avaje.ebeaninternal.server.core.DefaultServer.findUnique(DefaultServer.java:1242) 
    at com.avaje.ebeaninternal.server.querydefn.DefaultOrmQuery.findUnique(DefaultOrmQuery.java:924) 
    at com.avaje.ebeaninternal.util.DefaultExpressionList.findUnique(DefaultExpressionList.java:217) 
    at com.authdb.util.databases.EBean.checkPlayer(EBean.java:56) 
    at com.authdb.util.threads.SyncThread.run(SyncThread.java:23) 
    at com.authdb.util.databases.EBean.sync(EBean.java:89) 
    at com.authdb.util.databases.EBean.sync(EBean.java:84) 
    at com.authdb.listeners.AuthDBPlayerListener.onPlayerLogin(AuthDBPlayerListener.java:75) 
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) 
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) 
    at java.lang.reflect.Method.invoke(Unknown Source) 
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:301) 
    ... 13 more 
    2012-03-12 10:12:26 [INFO] Whitelist: Player Andre is trying to join...
    2012-03-12 10:12:26 [INFO] allow!
    2012-03-12 10:12:26 [INFO] Andre [/189.73.77.173:2795] logged in with entity id 866 at ([MacCraft] 637.3232860220517, 81.0, 770.1824702382235)
    2012-03-12 10:12:26 [SEVERE] Could not pass event PlayerJoinEvent to AuthDB
    org.bukkit.event.EventException 
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:303) 
    at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62) 
    at org.bukkit.plugin.TimedRegisteredListener.callEvent(TimedRegisteredListener.java:30) 
    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:441) 
    at net.minecraft.server.ServerConfigurationManager.c(ServerConfigurationManager.java:135) 
    at net.minecraft.server.NetLoginHandler.b(NetLoginHandler.java:128) 
    at net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:94) 
    at net.minecraft.server.Packet1Login.handle(SourceFile:68) 
    at net.minecraft.server.NetworkManager.b(NetworkManager.java:229) 
    at net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:48) 
    at net.minecraft.server.NetworkListenThread.a(NetworkListenThread.java:61) 
    at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:554) 
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:452) 
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:490) 
    Caused by: [2] 
    at com.avaje.ebeaninternal.server.core.DefaultServer.findUnique(DefaultServer.java:1242) 
    at com.avaje.ebeaninternal.server.querydefn.DefaultOrmQuery.findUnique(DefaultOrmQuery.java:924) 
    at com.avaje.ebeaninternal.util.DefaultExpressionList.findUnique(DefaultExpressionList.java:217) 
    at com.authdb.util.databases.EBean.checkPlayer(EBean.java:56) 
    at com.authdb.util.databases.EBean.checkIP(EBean.java:120) 
    at com.authdb.listeners.AuthDBPlayerListener.onPlayerJoin(AuthDBPlayerListener.java:116) 
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) 
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) 
    at java.lang.reflect.Method.invoke(Unknown Source) 
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:301) 
    ... 13 more 
    2012-03-12 10:12:27 [INFO] false-mode
    2012-03-12 10:12:27 [INFO] [UltraBan] Logged Andre connecting from ip:189.73.77.173
    2012-03-12 10:12:29 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    org.bukkit.event.EventException 
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:303) 
    at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62) 
    at org.bukkit.plugin.TimedRegisteredListener.callEvent(TimedRegisteredListener.java:30) 
    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:441) 
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:212) 
    at net.minecraft.server.Packet10Flying.handle(SourceFile:126) 
    at net.minecraft.server.NetworkManager.b(NetworkManager.java:229) 
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:116) 
    at net.minecraft.server.NetworkListenThread.a(NetworkListenThread.java:78) 
    at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:554) 
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:452) 
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:490) 
    Caused by: [2] 
    at com.avaje.ebeaninternal.server.core.DefaultServer.findUnique(DefaultServer.java:1242) 
    at com.avaje.ebeaninternal.server.querydefn.DefaultOrmQuery.findUnique(DefaultOrmQuery.java:924) 
    at com.avaje.ebeaninternal.util.DefaultExpressionList.findUnique(DefaultExpressionList.java:217) 
    at com.authdb.util.databases.EBean.checkPlayer(EBean.java:68) 
    at com.authdb.util.databases.EBean.find(EBean.java:150) 
    at com.authdb.AuthDB.isAuthorized(AuthDB.java:701) 
    at com.authdb.listeners.AuthDBPlayerListener.onPlayerMove(AuthDBPlayerListener.java:436) 
    at sun.reflect.GeneratedMethodAccessor24.invoke(Unknown Source) 
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) 
    at java.lang.reflect.Method.invoke(Unknown Source) 
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:301) 
    ... 11 more 
    2012-03-12 10:12:29 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    org.bukkit.event.EventException 
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:303) 
    at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62) 
    at org.bukkit.plugin.TimedRegisteredListener.callEvent(TimedRegisteredListener.java:30) 
    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:441) 
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:212) 
    at net.minecraft.server.Packet10Flying.handle(SourceFile:126) 
    at net.minecraft.server.NetworkManager.b(NetworkManager.java:229) 
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:116) 
    at net.minecraft.server.NetworkListenThread.a(NetworkListenThread.java:78) 
    at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:554) 
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:452) 
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:490) 
    Caused by: [2] 
    at com.avaje.ebeaninternal.server.core.DefaultServer.findUnique(DefaultServer.java:1242) 
    at com.avaje.ebeaninternal.server.querydefn.DefaultOrmQuery.findUnique(DefaultOrmQuery.java:924) 
    at com.avaje.ebeaninternal.util.DefaultExpressionList.findUnique(DefaultExpressionList.java:217) 
    at com.authdb.util.databases.EBean.checkPlayer(EBean.java:68) 
    at com.authdb.util.databases.EBean.find(EBean.java:150) 
    at com.authdb.AuthDB.isAuthorized(AuthDB.java:701) 
    at com.authdb.listeners.AuthDBPlayerListener.onPlayerMove(AuthDBPlayerListener.java:436) 
    at sun.reflect.GeneratedMethodAccessor24.invoke(Unknown Source) 
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) 
    at java.lang.reflect.Method.invoke(Unknown Source) 
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:301) 
    ... 11 more 
    2012-03-12 10:12:29 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    org.bukkit.event.EventException 
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:303) 
    at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62) 
    at org.bukkit.plugin.TimedRegisteredListener.callEvent(TimedRegisteredListener.java:30) 
    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:441) 
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:212) 
    at net.minecraft.server.Packet10Flying.handle(SourceFile:126) 
    at net.minecraft.server.NetworkManager.b(NetworkManager.java:229) 
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:116) 
    at net.minecraft.server.NetworkListenThread.a(NetworkListenThread.java:78) 
    at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:554) 
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:452) 
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:490) 
    Caused by: [2] 
    at com.avaje.ebeaninternal.server.core.DefaultServer.findUnique(DefaultServer.java:1242) 
    at com.avaje.ebeaninternal.server.querydefn.DefaultOrmQuery.findUnique(DefaultOrmQuery.java:924) 
    at com.avaje.ebeaninternal.util.DefaultExpressionList.findUnique(DefaultExpressionList.java:217) 
    at com.authdb.util.databases.EBean.checkPlayer(EBean.java:68) 
    at com.authdb.util.databases.EBean.find(EBean.java:150) 
    at com.authdb.AuthDB.isAuthorized(AuthDB.java:701) 
    at com.authdb.listeners.AuthDBPlayerListener.onPlayerMove(AuthDBPlayerListener.java:436) 
    at sun.reflect.GeneratedMethodAccessor24.invoke(Unknown Source) 
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) 
    at java.lang.reflect.Method.invoke(Unknown Source) 
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:301) 
    ... 11 more 
    2012-03-12 10:12:30 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    org.bukkit.event.EventException 
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:303) 
    at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62) 
    at org.bukkit.plugin.TimedRegisteredListener.callEvent(TimedRegisteredListener.java:30) 
    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:441) 
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:212) 
    at net.minecraft.server.Packet10Flying.handle(SourceFile:126) 
    at net.minecraft.server.NetworkManager.b(NetworkManager.java:229) 
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:116) 
    at net.minecraft.server.NetworkListenThread.a(NetworkListenThread.java:78) 
    at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:554) 
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:452) 
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:490) 
    Caused by: [2] 
    at com.avaje.ebeaninternal.server.core.DefaultServer.findUnique(DefaultServer.java:1242) 
    at com.avaje.ebeaninternal.server.querydefn.DefaultOrmQuery.findUnique(DefaultOrmQuery.java:924) 
    at com.avaje.ebeaninternal.util.DefaultExpressionList.findUnique(DefaultExpressionList.java:217) 
    at com.authdb.util.databases.EBean.checkPlayer(EBean.java:68) 
    at com.authdb.util.databases.EBean.find(EBean.java:150) 
    at com.authdb.AuthDB.isAuthorized(AuthDB.java:701) 
    at com.authdb.listeners.AuthDBPlayerListener.onPlayerMove(AuthDBPlayerListener.java:436) 
    at sun.reflect.GeneratedMethodAccessor24.invoke(Unknown Source) 
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) 
    at java.lang.reflect.Method.invoke(Unknown Source) 
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:301) 
    ... 11 more 
    2012-03-12 10:12:30 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    org.bukkit.event.EventException 
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:303) 
    at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62) 
    at org.bukkit.plugin.TimedRegisteredListener.callEvent(TimedRegisteredListener.java:30) 
    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:441) 
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:212) 
    at net.minecraft.server.Packet10Flying.handle(SourceFile:126) 
    at net.minecraft.server.NetworkManager.b(NetworkManager.java:229) 
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:116) 
    at net.minecraft.server.NetworkListenThread.a(NetworkListenThread.java:78) 
    at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:554) 
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:452) 
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:490) 
    Caused by: [2] 
    at com.avaje.ebeaninternal.server.core.DefaultServer.findUnique(DefaultServer.java:1242) 
    at com.avaje.ebeaninternal.server.querydefn.DefaultOrmQuery.findUnique(DefaultOrmQuery.java:924) 
    at com.avaje.ebeaninternal.util.DefaultExpressionList.findUnique(DefaultExpressionList.java:217) 
    at com.authdb.util.databases.EBean.checkPlayer(EBean.java:68) 
    at com.authdb.util.databases.EBean.find(EBean.java:150) 
    at com.authdb.AuthDB.isAuthorized(AuthDB.java:701) 
    at com.authdb.listeners.AuthDBPlayerListener.onPlayerMove(AuthDBPlayerListener.java:436) 
    at sun.reflect.GeneratedMethodAccessor24.invoke(Unknown Source) 
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) 
    at java.lang.reflect.Method.invoke(Unknown Source) 
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:301) 
    ... 11 more 
    2012-03-12 10:12:30 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    org.bukkit.event.EventException 
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:303) 
    at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62) 
    at org.bukkit.plugin.TimedRegisteredListener.callEvent(TimedRegisteredListener.java:30) 
    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:441) 
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:212) 
    at net.minecraft.server.Packet10Flying.handle(SourceFile:126) 
    at net.minecraft.server.NetworkManager.b(NetworkManager.java:229) 
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:116) 
    at net.minecraft.server.NetworkListenThread.a(NetworkListenThread.java:78) 
    at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:554) 
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:452) 
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:490) 
    Caused by: [2] 
    at com.avaje.ebeaninternal.server.core.DefaultServer.findUnique(DefaultServer.java:1242) 
    at com.avaje.ebeaninternal.server.querydefn.DefaultOrmQuery.findUnique(DefaultOrmQuery.java:924) 
    at com.avaje.ebeaninternal.util.DefaultExpressionList.findUnique(DefaultExpressionList.java:217) 
    at com.authdb.util.databases.EBean.checkPlayer(EBean.java:68) 
    at com.authdb.util.databases.EBean.find(EBean.java:150) 
    at com.authdb.AuthDB.isAuthorized(AuthDB.java:701) 
    at com.authdb.listeners.AuthDBPlayerListener.onPlayerMove(AuthDBPlayerListener.java:436) 
    at sun.reflect.GeneratedMethodAccessor24.invoke(Unknown Source) 
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) 
    at java.lang.reflect.Method.invoke(Unknown Source) 
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:301) 
    ... 11 more 
    2012-03-12 10:12:30 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    org.bukkit.event.EventException 
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:303) 
    at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62) 
    at org.bukkit.plugin.TimedRegisteredListener.callEvent(TimedRegisteredListener.java:30) 
    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:441) 
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:212) 
    at net.minecraft.server.Packet10Flying.handle(SourceFile:126) 
    at net.minecraft.server.NetworkManager.b(NetworkManager.java:229) 
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:116) 
    at net.minecraft.server.NetworkListenThread.a(NetworkListenThread.java:78) 
    at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:554) 
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:452) 
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:490) 
    Caused by: [2] 
    at com.avaje.ebeaninternal.server.core.DefaultServer.findUnique(DefaultServer.java:1242) 
    at com.avaje.ebeaninternal.server.querydefn.DefaultOrmQuery.findUnique(DefaultOrmQuery.java:924) 
    at com.avaje.ebeaninternal.util.DefaultExpressionList.findUnique(DefaultExpressionList.java:217) 
    at com.authdb.util.databases.EBean.checkPlayer(EBean.java:68) 
    at com.authdb.util.databases.EBean.find(EBean.java:150) 
    at com.authdb.AuthDB.isAuthorized(AuthDB.java:701) 
    at com.authdb.listeners.AuthDBPlayerListener.onPlayerMove(AuthDBPlayerListener.java:436) 
    at sun.reflect.GeneratedMethodAccessor24.invoke(Unknown Source) 
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) 
    at java.lang.reflect.Method.invoke(Unknown Source) 
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:301) 
    ... 11 more 
    2012-03-12 10:12:30 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    org.bukkit.event.EventException 
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:303) 
    at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62) 
    at org.bukkit.plugin.TimedRegisteredListener.callEvent(TimedRegisteredListener.java:30) 
    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:441) 
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:212) 
    at net.minecraft.server.Packet10Flying.handle(SourceFile:126) 
    at net.minecraft.server.NetworkManager.b(NetworkManager.java:229) 
    at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:116) 
    at net.minecraft.server.NetworkListenThread.a(NetworkListenThread.java:78) 
    at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:554) 
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:452) 
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:490) 
    Caused by: [2] 
    at com.avaje.ebeaninternal.server.core.DefaultServer.findUnique(DefaultServer.java:1242) 
    at com.avaje.ebeaninternal.server.querydefn.DefaultOrmQuery.findUnique(DefaultOrmQuery.java:924) 
    at com.avaje.ebeaninternal.util.DefaultExpressionList.findUnique(DefaultExpressionList.java:217) 
    at com.authdb.util.databases.EBean.checkPlayer(EBean.java:68) 
    at com.authdb.util.databases.EBean.find(EBean.java:150) 
    at com.authdb.AuthDB.isAuthorized(AuthDB.java:701) 
    at com.authdb.listeners.AuthDBPlayerListener.onPlayerMove(AuthDBPlayerListener.java:436) 
    at sun.reflect.GeneratedMethodAccessor24.invoke(Unknown Source) 
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) 
    at java.lang.reflect.Method.invoke(Unknown Source) 
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:301) 
    ... 11 more 
    lol!! HELP?
     
  11. Offline

    contex

    This sure seems like no other I've seen here before, could you backup your AuthDB.db and delete it, then start the server again. Does solve the issue?

    This seems like an issue related to Ebean persitence.
    What does your bukkit.yml settings look like, and are you using AuthDB custom database?
    If so, what is the table name (authdb_users?).

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

    gorenova

    00:26:27 [ì •ë³´] [AuthDB] Enabling AuthDB v2.3.5.240
    00:26:27 [ì •ë³´] [AuthDB] messages language set to English
    00:26:27 [ì •ë³´] [AuthDB] commands language set to English
    00:26:28 [경고] [AuthDB] Could not find script's tables in database: authname!
    00:26:28 [경고] [AuthDB]
    |-----------------------------------------------------------------------------|
    |--------------------------------AUTHDB WARNING-------------------------------|
    |-----------------------------------------------------------------------------|
    | STACKTRACE ERROR
    |-----------------------------------------------------------------------------|
    00:26:28 [경고] [AuthDB] Class name: com.authdb.AuthDB
    00:26:28 [경고] [AuthDB] File name: AuthDB.java
    00:26:28 [경고] [AuthDB] Function name: onEnable
    00:26:28 [경고] [AuthDB] Error line: 277
    00:26:28 [경고] [AuthDB] Enable logging in the config to get more information about the error.
    00:26:28 [ì •ë³´] [AuthDB] 2.3.5.240 is enabled
    00:26:28 [ì •ë³´] [AuthDB] developed by CraftFire <[email protected]>



    00:28:08 [ì •ë³´] This server is running CraftBukkit version git-Bukkit-1.1-R6-b1988jnks (MC: 1.1) (Implementing API version 1.1-R6)
     
  13. Offline

    nFamous

    Got it: in the bukkit.yml the database settings were changed from sqlite to mysql. Reverted this to the default settings and voilà AuthDB is doing its job without any errors.
    Nevertheless, on the first start after this change I got one SyncThread error which disappeared after one server restart.

    Thanks for this idea!
     
  14. Offline

    Wulfspider

    You're getting that error because you didn't enable the customdb option under advanced.yml.
     
  15. Offline

    djrazr

    Hay Wulfspider, since yesterday 18:30 i had the old Version v2.3.4.236 in, to test if the errospam stops.. and indeed th major spam was gone..




    I looked at the server some minutes ago and it was crashed... It seems to be AuthDB causing that - beside some messages of users, these where the last pluginmessages before "Connection reset" and "Reat timed out" began..


    You maybe have to rework your Ebeanhandling :D

    Would it help to just drop that db? What d ya think?
     
  16. Offline

    Wulfspider

    What version/build of AuthDB are you using?

    Looks like you are getting those errors because the database you are trying to connect to doesn't allow those permissions to create. There is no way for it to create a user and such when the table doesn't exist. ;)

    So you'll need to fix your MySQL permissions to allow creating and inserting, or manually import the SQL file yourself.

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Jul 15, 2016
  17. Thanks for your reply, but all permissions are correct e.g. i triple checked everything and couldn't find something that could cause this :S

    I'm running the latest GA release of MySQL (using TCP, not named pipes) and created a seperate account with the correct permissions/access to authdb's database only.

    Permissions were set using HeidiSQL and are as followed:

    SELECT, ALTER, CREATE, DELETE, DROP, INDEX, INSERT, UPDATE

    Things i didn't select: EXECUTE, SHOW VIEW, ALTER ROUTINE, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE VIEW, EVENT, REFERENCES, TRIGGER, GRANT, LOCK TABLES

    Importing the file also didn't work.
     
  18. Offline

    contex

    [​IMG]
    v2.3.6
    Download ZIP bundle or JAR only
    Changelog
    Removed threading, as it seems to be causing issues for unknown reasons.​
    Removed a specific catch which caused recent errors.​

    I can't really do anything without you testing it for me, perhaps you have Steam/Skype? Any type of IM?
    My username on both is "contexmoh", add me and we can test out for a bit.

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

    JohnPulse

    Hello,

    This was reported previously but I have to report again because I like to keep the chat nice and clean :)

    The {NEWLINE} and {N} are not working.

    CB 2034
    AuthDB version 2.3.5.240
    Using not the default language (AuthDB\translations\Portuguese)

    Regards,
    John
     
  20. Offline

    contex

    Will take a look at it and put it in the list for 2.3.7 :)
     
  21. Offline

    JohnPulse

    Thanks for the quick feedback! :)
     
  22. I added you to my steam and Skype (well, on my gf's computer :p)
    Also downloaded and tested the new build @ CB 1.1-R8.

    Now i'm only getting an error when trying to register an account.

    in-game
    Processing registration...
    Registration failed!

    server.log
    2012-03-13-error.log
    There's also something positive to mention. In this build the authdb_users table is (automatically) created!

    Anyway, i'm looking forward getting in touch with you ;-)
     
  23. Offline

    ashimi

    v2.3.5
     
  24. Offline

    vanmc

    I am running a anarchy server so hiding coordinates of bases is important for somehow I notice my players started using this kind of exploit where they login to a target and just do f3 or have some mini map mod and just list down the coordinate where there homes / bases are found and basically raid them.

    My idea of fix is like on authme where players are forced to spawn at Default set Spawn to prevent of this exploit from happening. I hope for the fix soon :D
     
  25. Offline

    contex

    That would be fully possible, to have a sort of a "temporary spawn" in the config.
    I'll add it to 2.3.7!
     
  26. Offline

    IOn Vash

    How do I fix this?

    Code:
    2012-03-13 18:14:17 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:17 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:17 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:17 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:17 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:17 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:17 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:17 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:17 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:17 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:17 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:17 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:17 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:17 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:17 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:17 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:18 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:18 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:18 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:18 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:18 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:18 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:18 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:18 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:18 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:18 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:18 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:18 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:18 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:18 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:18 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:18 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:18 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:18 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:18 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:18 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:18 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:18 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:18 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:18 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:18 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:18 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:18 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:19 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:19 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:19 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:19 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:19 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:19 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:19 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:19 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:19 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:19 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:19 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:19 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:19 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:19 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:19 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:19 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:19 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:19 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:19 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:19 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:19 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:19 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:19 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:19 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:19 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:19 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:19 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:19 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:19 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:19 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:19 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:19 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:19 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:19 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:19 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:19 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:20 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:20 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:20 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:20 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:20 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:20 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:20 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:20 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:20 [SEVERE] Could not pass event PlayerInteractEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:20 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:20 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:20 [INFO] [LogBlock Consumer] Queue overloaded. Size: 13325
    2012-03-13 18:14:20 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:20 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:20 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:20 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:20 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:20 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:20 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:20 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:21 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    Caused by: javax.persistence.PersistenceException: Unique expecting 0 or 1 rows
    but got [2]
    2012-03-13 18:14:21 [SEVERE] Could not pass event PlayerMoveEvent to AuthDB
    It makes the console unusable and my server log larger by about 100MB a hour.
     
  27. Are you running the latest AuthDB build 2.3.6.242?
     
  28. Offline

    vanmc

    Ty so much :D
     
  29. Offline

    OakyTree

    This happens when I try to compile from the latest github, any ideas?

    Code:
    [INFO] ------------------------------------------------------------------------
    [INFO] Building AuthDB Legacy dev-SNAPSHOT
    [INFO] ------------------------------------------------------------------------
    Downloading: http://repo.craftfire.com/org/bukkit/craftbukkit/1.2.3-R0.2-SNAPSHO
    T/maven-metadata.xml
    [WARNING] Could not transfer metadata org.bukkit:craftbukkit:1.2.3-R0.2-SNAPSHOT
    /maven-metadata.xml from/to craftfire-repo (http://repo.craftfire.com): Failed t
    o transfer file: http://repo.craftfire.com/org/bukkit/craftbukkit/1.2.3-R0.2-SNA
    PSHOT/maven-metadata.xml. Return code is: 503, ReasonPhrase:Service Temporarily
    Unavailable.
    [WARNING] Failure to transfer org.bukkit:craftbukkit:1.2.3-R0.2-SNAPSHOT/maven-m
    etadata.xml from http://repo.craftfire.com was cached in the local repository, r
    esolution will not be reattempted until the update interval of craftfire-repo ha
    s elapsed or updates are forced. Original error: Could not transfer metadata org
    .bukkit:craftbukkit:1.2.3-R0.2-SNAPSHOT/maven-metadata.xml from/to craftfire-rep
    o (http://repo.craftfire.com): Failed to transfer file: http://repo.craftfire.co
    m/org/bukkit/craftbukkit/1.2.3-R0.2-SNAPSHOT/maven-metadata.xml. Return code is:
     503, ReasonPhrase:Service Temporarily Unavailable.
    Downloading: http://repo.craftfire.com/org/bukkit/craftbukkit/1.2.3-R0.2-SNAPSHO
    T/craftbukkit-1.2.3-R0.2-SNAPSHOT.pom
    [INFO] ------------------------------------------------------------------------
    [INFO] BUILD FAILURE
    [INFO] ------------------------------------------------------------------------
    [INFO] Total time: 1.269s
    [INFO] Finished at: Wed Mar 14 04:55:29 EDT 2012
    [INFO] Final Memory: 8M/183M
    [INFO] ------------------------------------------------------------------------
    [ERROR] Failed to execute goal on project authdb: Could not resolve dependencies
     for project com.authdb:authdb:jar:dev-SNAPSHOT: Failed to collect dependencies
    for [org.bukkit:craftbukkit:jar:1.2.3-R0.2-SNAPSHOT (compile), org.bukkit:bukkit
    -permissions:jar:0.1.0-SNAPSHOT (compile), com.nijikokun.bukkit:Permissions:jar:
    3.1.6 (compile), com.ensifera.animosity:craftirc:jar:2.13 (compile)]: Failed to
    read artifact descriptor for org.bukkit:craftbukkit:jar:1.2.3-R0.2-SNAPSHOT: Cou
    ld not transfer artifact org.bukkit:craftbukkit:pom:1.2.3-R0.2-SNAPSHOT from/to
    craftfire-repo (http://repo.craftfire.com): Failed to transfer file: http://repo
    .craftfire.com/org/bukkit/craftbukkit/1.2.3-R0.2-SNAPSHOT/craftbukkit-1.2.3-R0.2
    -SNAPSHOT.pom. Return code is: 503, ReasonPhrase:Service Temporarily Unavailable
    . -> [Help 1]
    [ERROR]
    [ERROR] To see the full stack trace of the errors, re-run Maven with the -e swit
    ch.
    [ERROR] Re-run Maven using the -X switch to enable full debug logging.
    [ERROR]
    [ERROR] For more information about the errors and possible solutions, please rea
    d the following articles:
    [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/DependencyReso
    lutionException
     
  30. Offline

    Wulfspider

    You're running an old version. Update! :p

    Should be fixed now. :)

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

    b4ck

    i got this message every time when i connect to my server ..

    you cannot join when the server has no database connection

    any solution !!
     

Share This Page