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

    n0nick

    Hello,

    i have found a bug, with the inventory... When a Player exit and the session is timeoutet then the inventory is clear.

    I have fixed it in Process.java..
    public static boolean Logout
    player.getInventory().clear(); is very bad on exit, because the invenctory is not saved....because Logout Method will be execute on Exit...

    I know this is not a good fix, but it work..
     
  3. Offline

    contex

    Could you show me your bukkit.yml in the root directory of the server?


    Thanks for reporting, we might have mixed something up, I will check once I get home from work.
     
  4. Offline

    Wulfspider

    He meant to ask @Aus ;)
     
  5. Offline

    Aus

    Code:
    settings:
        spawn-radius: 10
        permissions-file: permissions.yml
        update-folder: update
    aliases:
        icanhasbukkit:
        - version
    database:
        username: mad
        isolation: SERIALIZABLE
        driver: com.mysql.jdbc.Driver
        password: ***
        url: jdbc:mysql://localhost/bukkit
    
     
  6. Offline

    contex

    Could you show me your bukkit.yml in the root directory of the server?

    Thanks for reporting, we might have mixed something up, I will check once I get home from work.
     
  7. Offline

    Aus

    Okay. In the post above
     
  8. Offline

    MiddleEarth

    Ugh.. seems I contributed to inundating you with what you already knew. Apologies. For those having similar problems with wiped inventories, I suggest you just tell players to store their items before they log out and warn them during reloads/restarts to do so. Thanks for the tireless work guys, take as long as you need.
     
  9. Offline

    Massimo1993

    @Wulfspider

    uff they take too much to resolve the lose of inventory u.u
     
  10. Offline

    Wulfspider

    Could you try the latest build? http://ci.getspout.org/job/AuthDB/182/
    We've tested it locally and the inventory issue seems to be resolved.
     
  11. Offline

    IJosephI

    With last dev build authdb write me error with Primary Key. That it should be unique.
     
  12. Offline

    Wulfspider

    182? Do you only get that on first join? Did you delete your AuthDB.db before trying it?
     
  13. Offline

    IJosephI

    181. ingame situation - it say that i have already logged in and don't allow me to self moving or camera moving. No, i didn't delete AuthDB.db

    I'll try now with clear 182 on clean server.
     
  14. Offline

    Wulfspider

    182 is the latest dev build.

    You need to delete bukkit.yml and let bukkit recreate it. It looks like you modified it and shouldn't have. The username and password are also wrong along with everything else in there. You modified a section that was not meant to be modified in the way that you did. Basically, you changed it so that any plugin that uses bukkit's eBeans persistence will not work.

    I'll let @contex know. He may have overlooked that.

    Restart? As in /reload or as in completely restarting the server that your minecraft server is hosted on without properly stopping it first? Because we can't find any inventory loss with just a /reload.

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Dec 28, 2018
  15. Offline

    contex

  16. Offline

    RockIsLife

    Put 182 on the main server. Collect statistics on user xD
    So far so good.
     
  17. Offline

    Massimo1993

    @contex
    inventory work but i receive this error
    Code:
    2011-09-01 18:33:43 [SEVERE] Could not pass event PLAYER_LOGIN to AuthDB
    javax.persistence.PersistenceException: ERROR executing DML bindLog[] error[[SQLITE_CONSTRAINT]  Abort due to constraint violation (PRIMARY KEY must be unique)]
        at com.avaje.ebeaninternal.server.persist.dml.DmlBeanPersister.execute(DmlBeanPersister.java:116)
        at com.avaje.ebeaninternal.server.persist.dml.DmlBeanPersister.insert(DmlBeanPersister.java:76)
        at com.avaje.ebeaninternal.server.persist.DefaultPersistExecute.executeInsertBean(DefaultPersistExecute.java:91)
        at com.avaje.ebeaninternal.server.core.PersistRequestBean.executeNow(PersistRequestBean.java:527)
        at com.avaje.ebeaninternal.server.core.PersistRequestBean.executeOrQueue(PersistRequestBean.java:557)
        at com.avaje.ebeaninternal.server.persist.DefaultPersister.insert(DefaultPersister.java:404)
        at com.avaje.ebeaninternal.server.persist.DefaultPersister.saveVanillaInsert(DefaultPersister.java:377)
        at com.avaje.ebeaninternal.server.persist.DefaultPersister.saveVanillaRecurse(DefaultPersister.java:361)
        at com.avaje.ebeaninternal.server.persist.DefaultPersister.saveRecurse(DefaultPersister.java:308)
        at com.avaje.ebeaninternal.server.persist.DefaultPersister.save(DefaultPersister.java:282)
        at com.avaje.ebeaninternal.server.core.DefaultServer.save(DefaultServer.java:1577)
        at com.avaje.ebeaninternal.server.core.DefaultServer.save(DefaultServer.java:1567)
        at com.authdb.util.databases.EBean.save(EBean.java:80)
        at com.authdb.util.databases.EBean.sync(EBean.java:98)
        at com.authdb.util.databases.EBean.sync(EBean.java:84)
        at com.authdb.listeners.AuthDBPlayerListener.onPlayerLogin(AuthDBPlayerListener.java:64)
        at org.bukkit.plugin.java.JavaPluginLoader$13.execute(JavaPluginLoader.java:328)
        at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
        at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:338)
        at net.minecraft.server.ServerConfigurationManager.a(ServerConfigurationManager.java:184)
        at net.minecraft.server.NetLoginHandler.b(NetLoginHandler.java:82)
        at net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:74)
        at net.minecraft.server.Packet1Login.a(SourceFile:43)
        at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
        at net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:40)
        at net.minecraft.server.NetworkListenThread.a(SourceFile:91)
        at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:454)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    Caused by: java.sql.SQLException: [SQLITE_CONSTRAINT]  Abort due to constraint violation (PRIMARY KEY must be unique)
        at org.sqlite.DB.newSQLException(DB.java:383)
        at org.sqlite.DB.newSQLException(DB.java:387)
        at org.sqlite.DB.execute(DB.java:342)
        at org.sqlite.DB.executeUpdate(DB.java:363)
        at org.sqlite.PrepStmt.executeUpdate(PrepStmt.java:85)
        at com.avaje.ebeaninternal.server.lib.sql.ExtendedPreparedStatement.executeUpdate(ExtendedPreparedStatement.java:164)
        at com.avaje.ebeaninternal.server.type.DataBind.executeUpdate(DataBind.java:74)
        at com.avaje.ebeaninternal.server.persist.dml.InsertHandler.execute(InsertHandler.java:155)
        at com.avaje.ebeaninternal.server.persist.dml.DmlBeanPersister.execute(DmlBeanPersister.java:105)
        ... 28 more
     
  18. Offline

    RockIsLife

    Disappears wearing armor :(
     
  19. Offline

    Massimo1993

    @contex

    edit: when i restart server all lose inventory
     
  20. Offline

    lucasdidur

    I'm using IPB 3.1.4, and sometimes the plugin stops working out of nowhere

    In the log, it appears that:



    NOTE: I could not I join http://issues.craftfire.com/



    Code:
    2011/09/01 15:36:53 - --------------------------- STACKTRACE ERROR ---------------------------
    2011/09/01 15:36:53 - Class name: com.authdb.AuthDB
    2011/09/01 15:36:53 - File name: AuthDB.java
    2011/09/01 15:36:53 - Function name: isRegistered
    2011/09/01 15:36:53 - Error line: 801
    2011/09/01 15:36:53 - --------------------------- STACKTRACE START ---------------------------
    2011/09/01 15:36:53 - sun.reflect.GeneratedConstructorAccessor84.newInstance(Unknown Source)
    2011/09/01 15:36:53 - sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    2011/09/01 15:36:53 - java.lang.reflect.Constructor.newInstance(Constructor.java:532)
    2011/09/01 15:36:53 - com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011/09/01 15:36:53 - com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011/09/01 15:36:53 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
    2011/09/01 15:36:53 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
    2011/09/01 15:36:53 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
    2011/09/01 15:36:53 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
    2011/09/01 15:36:53 - com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.java:1213)
    2011/09/01 15:36:53 - com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1200)
    2011/09/01 15:36:53 - com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2485)
    2011/09/01 15:36:53 - com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2467)
    2011/09/01 15:36:53 - com.authdb.util.databases.MySQL.getfromtable(MySQL.java:213)
    2011/09/01 15:36:53 - com.authdb.util.Util.checkScript(Util.java:645)
    2011/09/01 15:36:53 - com.authdb.AuthDB.isRegistered(AuthDB.java:793)
    2011/09/01 15:36:53 - com.authdb.listeners.AuthDBPlayerListener.onPlayerCommandPreprocess(AuthDBPlayerListener.java:287)
    2011/09/01 15:36:53 - org.bukkit.plugin.java.JavaPluginLoader$5.execute(JavaPluginLoader.java:272)
    2011/09/01 15:36:53 - org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
    2011/09/01 15:36:53 - org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:338)
    2011/09/01 15:36:53 - net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:730)
    2011/09/01 15:36:53 - net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:701)
    2011/09/01 15:36:53 - net.minecraft.server.NetServerHandler.a(NetServerHandler.java:694)
    2011/09/01 15:36:53 - net.minecraft.server.Packet3Chat.a(Packet3Chat.java:33)
    2011/09/01 15:36:53 - net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
    2011/09/01 15:36:53 - net.minecraft.server.NetServerHandler.a(NetServerHandler.java:89)
    2011/09/01 15:36:53 - org.getspout.spout.SpoutNetServerHandler.a(SpoutNetServerHandler.java:478)
    2011/09/01 15:36:53 - net.minecraft.server.NetworkListenThread.a(SourceFile:105)
    2011/09/01 15:36:53 - net.minecraft.server.MinecraftServer.h(MinecraftServer.java:454)
    2011/09/01 15:36:53 - net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
    2011/09/01 15:36:53 - net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    2011/09/01 15:36:53 - ---------------------------- STACKTRACE END ----------------------------
    
    
    
    
    2011/09/01 15:36:56 - --------------------------- STACKTRACE ERROR ---------------------------
    2011/09/01 15:36:56 - Class name: com.authdb.AuthDB
    2011/09/01 15:36:56 - File name: AuthDB.java
    2011/09/01 15:36:56 - Function name: isRegistered
    2011/09/01 15:36:56 - Error line: 836
    2011/09/01 15:36:56 - --------------------------- STACKTRACE START ---------------------------
    2011/09/01 15:36:56 - sun.reflect.GeneratedConstructorAccessor84.newInstance(Unknown Source)
    2011/09/01 15:36:56 - sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    2011/09/01 15:36:56 - java.lang.reflect.Constructor.newInstance(Constructor.java:532)
    2011/09/01 15:36:56 - com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011/09/01 15:36:56 - com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011/09/01 15:36:56 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
    2011/09/01 15:36:56 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
    2011/09/01 15:36:56 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
    2011/09/01 15:36:56 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
    2011/09/01 15:36:56 - com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.java:1213)
    2011/09/01 15:36:56 - com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1200)
    2011/09/01 15:36:56 - com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2485)
    2011/09/01 15:36:56 - com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2467)
    2011/09/01 15:36:56 - com.authdb.util.databases.MySQL.getfromtable(MySQL.java:213)
    2011/09/01 15:36:56 - com.authdb.util.Util.checkScript(Util.java:645)
    2011/09/01 15:36:56 - com.authdb.AuthDB.isRegistered(AuthDB.java:824)
    2011/09/01 15:36:56 - com.authdb.listeners.AuthDBPlayerListener.onPlayerQuit(AuthDBPlayerListener.java:271)
    2011/09/01 15:36:56 - org.bukkit.plugin.java.JavaPluginLoader$2.execute(JavaPluginLoader.java:251)
    2011/09/01 15:36:56 - org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
    2011/09/01 15:36:56 - org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:338)
    2011/09/01 15:36:56 - net.minecraft.server.ServerConfigurationManager.disconnect(ServerConfigurationManager.java:146)
    2011/09/01 15:36:56 - net.minecraft.server.NetServerHandler.disconnect(NetServerHandler.java:121)
    2011/09/01 15:36:56 - org.getspout.spout.SpoutNetServerHandler.disconnect(SpoutNetServerHandler.java:485)
    2011/09/01 15:36:56 - org.bukkit.craftbukkit.entity.CraftPlayer.kickPlayer(CraftPlayer.java:139)
    2011/09/01 15:36:56 - com.mcmyadmin.bukkitcompat.ConsoleCommandHandler.onCommand(ConsoleCommandHandler.java:108)
    2011/09/01 15:36:56 - org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
    2011/09/01 15:36:56 - org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:129)
    2011/09/01 15:36:56 - org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:344)
    2011/09/01 15:36:56 - net.minecraft.server.MinecraftServer.b(MinecraftServer.java:489)
    2011/09/01 15:36:56 - net.minecraft.server.MinecraftServer.h(MinecraftServer.java:468)
    2011/09/01 15:36:56 - net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
    2011/09/01 15:36:56 - net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    2011/09/01 15:36:56 - ---------------------------- STACKTRACE END ----------------------------
    
     
  21. Offline

    Wulfspider

    It says you joined on the site.

    We'll look into the error.
     
  22. Offline

    Massimo1993

    only restart the .jar
     
  23. Offline

    contex

    How are you restarting the .jar?
     
  24. Offline

    Wulfspider

    Test the latest dev build #184. I'm not getting armor/equipment loss with it.
     
  25. Offline

    Massimo1993

    ehm i mean i restart the server ( stop )
     
  26. Offline

    Nexans

    Hello
    I just tested the 182.
    A new inventory is cleared when the server reboot and the player was still connected.
     
  27. Offline

    contex

    Could you test 184? http://ci.craftfire.com/job/AuthDB/184/
     
  28. Offline

    Nexans

    184 OK . Inventory is not cleared even when server reboot with players connected.
    but I have another problem it does not take my repertoire FRENCH Translation.
    thank you
     
  29. Offline

    Wulfspider

    Where did you put the files?
    Also, the commands.yml is not completely working yet.
     
  30. Offline

    Nexans

    The files are in "/ plugins / authdb / translations / Frensh"
    And I left the command.yml by default
     
  31. Offline

    contex

    What does the console say?
     

Share This Page