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

    MJRamon

    @CraftFire

    I just don't know why, but:
    Your plugin was halting my server. I couldn't figure out, what did such a lag, was disabling/enabling plugins, tried other worlds...
    I use MyBB 1.6.2, Bukkit 1240 and AuthDB 2.3.2.220.
    So, I disabled your plugin - and everuthing went smooth. I enabled it - lagging, CPU overload, "Can't keep up" and so on.
    Then I deleted AuthDB.db in plugin's folder (it was about 1 Mb), started over the server and it began to work like a charm. For now though.

    Question: what is this file, authdb.db? Do we need it? Can you at least make that plugin will delete it every X mnutes/hours/days?
     
  3. Offline

    Wulfspider

    AuthDB.db is meant as a cache for players to speed up player checks so that everything doesn't have to go through MySQL. It also stores their inventory while they are logging in. I am sure it needs some reworking though, as it is our first attempt at eBeans. It wouldn't be a good practice to delete it though, as players may have inventory stored in there sometimes.
     
  4. Offline

    MJRamon

    So what should I do in described situation again? Cause it will happen again, I'm sure.
     
  5. Quick question: Why does AuthDB loose it's connection to MySQL if the server runs for over 6h without a restart?

    Longer question will come if there really isn't any quick and easy answer, and after I've done some testing of my own ^^
     
  6. Offline

    BlancoLanda

    Is there a way for, when a non-registered player (Registers are made at website), tryes to join the game, get kicked for "Not registered"? It's better than letting him join and doesn't let him register. For example, "User1" didn't register at test.com (bridged with server). When he tries to join the server a message appears: You have been kicked! (You must register an account at test.com first!)
     
  7. In the advanced config you have this part:
    Code:
    register:
      enabled: false                                    # Enable/disable allowing users to register.
      force: true                                      # Enable/disable forcing users to register.
      delay: 4 seconds                                 # Amount of time before register message is shown to player.
      timeout: 3 minutes                               # Amount of time a player has to register before the configured action is taken.
    Try change the timeout to 1 sek?
    I haven't tried it myself, but seems like it should work (whatever "Configured action" is)

    I keep getting this error if my server runs for a couple of hours. It works perfectly when starting and arestart always fixes it, but why in the first place?
    (I have webserver/MySQL on the same machine as the minecraft server btw)

    Code:
    2011/10/12 04:22:13 - --------------------------- STACKTRACE ERROR ---------------------------
    2011/10/12 04:22:13 - Class name: com.authdb.AuthDB
    2011/10/12 04:22:13 - File name: AuthDB.java
    2011/10/12 04:22:13 - Function name: isRegistered
    2011/10/12 04:22:13 - Error line: 824
    2011/10/12 04:22:13 - AuthDB version: 2.3.2.220
    2011/10/12 04:22:13 - Keep alive: true
    2011/10/12 04:22:13 - MySQL connection: true
    2011/10/12 04:22:13 - Latest query: SELECT * FROM `wpmc_users` WHERE `user_login` = '******' LIMIT 1
    2011/10/12 04:22:13 - Script: wordpress
    2011/10/12 04:22:13 - Script version: 3.2.1
    2011/10/12 04:22:13 - Table prefix: wpmc_
    2011/10/12 04:22:13 - Plugins: BS-GUIPlugin 1.2, iConomy 6.0.6b, IRCraft 2.1, LogBlockQuestioner 0.02, RemoteToolkitPlugin 0.5, Minequery 1.5, MobileAdmin 3.2.1, Multiverse-Core 2.0-b271, PermissionsBukkit 1.2, ServerEvents 1.4.0, Spout 1.0.6.403, Stargate 0.6.9, Permissions 2.7.7, AuthDB 2.3.2.220, BookWorm 1.7, Catacombs 0.4, dynmap 0.24, mcMMO 1.1.16, Citizens 1.1.1, LogBlock 1.32, MagicSpells 1.2,
    2011/10/12 04:22:13 - --------------------------- STACKTRACE START ---------------------------
    2011/10/12 04:22:13 - sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011/10/12 04:22:13 - sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    2011/10/12 04:22:13 - sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    2011/10/12 04:22:13 - java.lang.reflect.Constructor.newInstance(Constructor.java:525)
    2011/10/12 04:22:13 - com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011/10/12 04:22:13 - com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011/10/12 04:22:13 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
    2011/10/12 04:22:13 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
    2011/10/12 04:22:13 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
    2011/10/12 04:22:13 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
    2011/10/12 04:22:13 - com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.java:1213)
    2011/10/12 04:22:13 - com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1200)
    2011/10/12 04:22:13 - com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2485)
    2011/10/12 04:22:13 - com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2467)
    2011/10/12 04:22:13 - com.authdb.util.databases.MySQL.getfromtable(MySQL.java:219)
    2011/10/12 04:22:13 - com.authdb.util.Util.checkScript(Util.java:717)
    2011/10/12 04:22:13 - com.authdb.AuthDB.isRegistered(AuthDB.java:812)
    2011/10/12 04:22:13 - com.authdb.listeners.AuthDBPlayerListener.onPlayerJoin(AuthDBPlayerListener.java:138)
    2011/10/12 04:22:13 - org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:244)
    2011/10/12 04:22:13 - org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
    2011/10/12 04:22:13 - org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:339)
    2011/10/12 04:22:13 - net.minecraft.server.ServerConfigurationManager.c(ServerConfigurationManager.java:129)
    2011/10/12 04:22:13 - net.minecraft.server.NetLoginHandler.b(NetLoginHandler.java:121)
    2011/10/12 04:22:13 - net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:80)
    2011/10/12 04:22:13 - net.minecraft.server.Packet1Login.a(SourceFile:59)
    2011/10/12 04:22:13 - net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
    2011/10/12 04:22:13 - net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:46)
    2011/10/12 04:22:13 - net.minecraft.server.NetworkListenThread.a(SourceFile:94)
    2011/10/12 04:22:13 - net.minecraft.server.MinecraftServer.h(MinecraftServer.java:471)
    2011/10/12 04:22:13 - net.minecraft.server.MinecraftServer.run(MinecraftServer.java:374)
    2011/10/12 04:22:13 - net.minecraft.server.ThreadServerApplication.run(SourceFile:417)
    2011/10/12 04:22:13 - ---------------------------- STACKTRACE END ----------------------------
    RemoteToolkit seems to fix this by restarting the server after a couple of hours,
    but I still would love it I didn't have to restart so often.

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

    Wulfspider

    We don't have that feature yet, but you could fool around with settings like what Sketaful suggested.

    I'm not sure there is much you can do right now until we clean things up and improve that setup.

    AuthDB does seem to be hateful sometimes when the MySQL jar is in the lib or root folder too being as the MySQL connector already comes built into CraftBukkit. I do not think that is the sole cause though.

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Jul 15, 2016
  9. I tried it and it doesn't kick the player if he doesn't register within the given time. So that sucks (not the plugin, just the fact that I had my hopes up for something :p).

    What I suggest you do is:
    Open advanced.yml (open)
    (found in "AuthDB\Config")
    Change "enabled: true" to "Enabled: false" and "timeout: 3 minutes" to "timeout: 3 seconds" so it looks like this:
    Code:
    register:
      enabled: false                                    # Enable/disable allowing users to register.
      force: true                                      # Enable/disable forcing users to register.
      delay: 4 seconds                                 # Amount of time before register message is shown to player.
      timeout: 3 seconds                               # Amount of time a player has to register before the configured action is taken.
    Save the file and close it

    Open messages.yml (open)
    (It's found in "AuthDB/translations/English")
    Look for:
    Code:
    register:
        welcome: "{YELLOW}Welcome {WHITE}{PLAYER}{YELLOW}! Please use {REGISTERCMD} password {EMAILREQUIRED}"
        processing: "{YELLOW}Processing registration..."
        success: "{BRIGHTGREEN}You have successfully registered! You are now logged in."
        failure: "{RED}Registration failed!"
        offline: "{RED}Database is unavailable. Registration is disabled!"
        exists: "{RED}You are already registered!"
        disabled: "{RED}Registration is disabled!"
        timeout: "Kicked because you failed to register within {REGISTERTIMEOUT}."
        usage: "{YELLOW}Correct usage is: {WHITE}{REGISTERCMD} password email"
    and remove the line "{YELLOW}Welcome {WHITE}{PLAYER}{YELLOW}! Please use {REGISTERCMD} password {EMAILREQUIRED}" from "welcome:".
    After that, change the "timeout:"-message to something like: "Please register on our webpage http://www.whateveradressyouhave.com to be able to play on this server."
    (Or chose a better message that you find fitting)

    If you've done it right it should look like this:
    Code:
    register:
        welcome: ""
        processing: "{YELLOW}Processing registration..."
        success: "{BRIGHTGREEN}You have successfully registered! You are now logged in."
        failure: "{RED}Registration failed!"
        offline: "{RED}Database is unavailable. Registration is disabled!"
        exists: "{RED}You are already registered!"
        disabled: "{RED}Registration is disabled!"
        timeout: "Please register on our webpage http://www.whateveradressyouhave.com to be able to play on this server."
        usage: "{YELLOW}Correct usage is: {WHITE}{REGISTERCMD} password email"


    If you've done it correct every unregistered user that connects to your server has no rights, can't register on the gameserver and gets the message: "Please register on our webpage http://www.whateveradressyouhave.com to be able to play on this server." as soon as they connect.

    EDIT: You should also change
    messages.yml (open)
    Code:
      protection:
        denied: "{RED}You do not have permission to use that command."
        notauthorized: "{RED}You are not authorized to do that."
    to something like
    Code:
      protection:
        denied: "{RED}Please register on http://yoursite.com."
        notauthorized: "{RED}You need to register on http//yoursite.com before you can do that"
    Or to what text you'd like.

    This way the unregistered player get this message as soon as he/she tries to do anything in the gameworld.

    It's not a "kick" but it's the best I could come up with. :)
     
    BlancoLanda likes this.
  10. Offline

    BlancoLanda

    Thank you! I exactly did that except the last except. Now I made all you said... thank you :)
     
  11. Glad I could help. :)
     
    BlancoLanda likes this.
  12. Offline

    Massimo1993

    @Wulfspider

    can you make a version without the inventory save on sql
     
  13. Offline

    MJRamon

    So, here we are again (lagging badly). All I can do is to delete authdb.db to make lags go away :(

    Okey, one more bug: the plugin creates tons of queries to the MySQL and doesn't close them. So it goes overloaded, and loses connect because of limitation of active queries at one time.

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

    Wulfspider

    Do you have keepalive: true?
     
  15. Offline

    MJRamon

    Nope, it's false
    Queries grow while people keep log in and log out

    UPDATE:
    Code:
    23:30:18 [INFO] [AuthDB] Executing MySQL query: SELECT * FROM `mybb_users` WHERE `username` = '***SKIPPED***' LIMIT 1
    
    Why everything? If then there are two queries, where it selects password and salt??
     
  16. Offline

    rom_t

    @Wulfspider > same error :

    I installed phpbb3 and tried to use its database with autdb, but keep getting the same error.
    As phpbb works, my database can be accessed. I don't know why authdb can't...
     
  17. Offline

    Massimo1993

    @Wulfspider

    can you make a version without the inventory save on sql
     
  18. Offline

    Wulfspider

    Unlikely in the near future as @contex is MIA. I've been seeking someone to join the CraftFire team and assist with revamping AuthDB for 3.0 along with BabelCraft 2.0.

    I'm not sure then. Likely something it doesn't like with the way you setup your database. I've helped others before and often is ends up being something silly like the wrong permissions or a rouge field in the database table.

    If keepalive is not true, it shouldn't be keeping them open. If it is, then it's a bug. It checks users as they login to sync their info the the .db. I'm not sure why it would be talking to MySQL on logout. It only be talking to the AuthDB.db on logout.

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

    Massimo1993

    @Wulfspider

    hi excuse me again but the plugin you have make is tooo complicate, i mean, what you do only a simple auth plugin for all forum: remove the inventory save on sql, remove the account link, remove all the function useless and done a plugin with more stability - work + stable

    ps: with bukkit 1340 and spout dev i receive a lot of error with player_login and player_damage
     
  20. Offline

    Wulfspider

    The inventory saving to the local database is so people don't mess with your inventory. As most of the options are optional, it really isn't that bulky as they do not run unless they are used. It used to save to flatfiles, which was not as resourceful.

    The features that have been added were features that were requested and we saw fit to add. They are far from being useless. A simple feature is far less bulky than supporting ALL forum scripts too. You aren't connecting to ALL the forums at once, so you aren't using ALL the code that applies to them. The same logic apples to the features you don't use.

    As I've said, @contex is MIA and things will not be progressing until I find others to assist with the project revamp for 3.0. We'll see where things go when that time comes.
     
  21. Offline

    _bLah

    I dont know whats going on... I tried this first on IPBoards 3.0.2 and we could login in game but after 2+ people came on the server would just restart with no error or anything, just "Stopping server...". So, I went and tried it with vBulletin 4.1.5. Same thing except we cant even login. No errors, it loads the right amount of accounts and says its all good but when I login it says wrong password..

    Plugins: FalseBookExtra, Spout, HeroChat, SimpleSignEdit, FalseBookCart, LogBlockQuestioner, MyWarp, NoLaggChunks, SaysWho, FalseBookCore, CFBanner, AutoMessage, FalseBookIC, OKLogger, WorldEdit, PermissionsEx, PhysicalShop, Minequery, Cookiez, WorldGuard, Essentials, mcMMO, FailAnnounce, OKSpamSecurity, RawcriticsOreObfuscationPluginSpout, FalseBookBlock, HeroicDeath, BukkitCompat, DwarfForge, NoCheat, Modifyworld, EssentialsSpawn, Permissions, MyHome, VanishNoPacket, Factions, NoLagg, LogBlock, EasyBan, properTime

    RB1317
     
  22. Offline

    Wulfspider

    Are you using a different case variation from what your forum username is?
     
  23. Offline

    _bLah

    I am not but others may be. Ill check it out after work.
     
  24. Offline

    Snaipe

    Hello, I am experiencing a dupe glitch with every items on my server.

    This can only occur when a per-world inventory is set up.

    If a player log out on a creative world, log in, then walks to another world, then log in, he will have his creative inventory ( well, only the item bar ). this is quite annoying atm...

    Could you make options for registered but non-logged players ? such as guest settings.

    A fix could be to either activate their inventories ( since they can't build, no problem. ), or deactivate their movement.
    But there is no option for them, only for guests, and I want my guest to be able to move freely around...

    Please help me, this is ruining the gameplay...
     
  25. Offline

    WolwX

    Hello,

    Any news ?

    I tried with the last recommended build and the last dev build (http://ci.craftfire.com/job/AuthDB/225/)
    but my sync using smf forums still not functional with user using Caps into username ...
     
  26. Offline

    _bLah

    Same letter case when logging in. Genuine on forums Genuine in game. Why would it be causing the server to restart without error and how can I find the error if its hidden somewhere?
     
  27. Offline

    Wulfspider

    I don't see how it would be restarting the server. I would say check the root for an hs_ log files, in the plugins/AuthDB/logs, and the server.log in the root.
     
  28. Offline

    HighBomber

    I am requesting SASL support. I am not sure if this is possible in Java, however this would greatly help consolidate my database.
     
  29. Offline

    Snaipe

    @Wulfspider

    When I updated the server to 1337, the plugin stopped working at all, spamming the console with :

    Code:
    2011-10-23 00:41:26 [WARNING] [AuthDB]
    |-----------------------------------------------------------------------------|
    |--------------------------------AUTHDB WARNING-------------------------------|
    |-----------------------------------------------------------------------------|
    | STACKTRACE ERROR
    |-----------------------------------------------------------------------------|
    2011-10-23 00:41:26 [WARNING] [AuthDB] Class name: com.authdb.AuthDB
    2011-10-23 00:41:26 [WARNING] [AuthDB] File name: AuthDB.java
    2011-10-23 00:41:26 [WARNING] [AuthDB] Function name: DefaultFile
    2011-10-23 00:41:26 [WARNING] [AuthDB] Error line: 888
    2011-10-23 00:41:26 [WARNING] [AuthDB] Enable logging in the config to get more information about the error.
    2011-10-23 00:41:26 [INFO] [AuthDB] advanced.yml could not be found in plugins/AuthDB/config/! Creating advanced.yml!
    2011-10-23 00:41:26 [WARNING] [AuthDB]
    |-----------------------------------------------------------------------------|
    |--------------------------------AUTHDB WARNING-------------------------------|
    |-----------------------------------------------------------------------------|
    | STACKTRACE ERROR
    |-----------------------------------------------------------------------------|
    2011-10-23 00:41:26 [WARNING] [AuthDB] Class name: com.authdb.AuthDB
    2011-10-23 00:41:26 [WARNING] [AuthDB] File name: AuthDB.java
    2011-10-23 00:41:26 [WARNING] [AuthDB] Function name: DefaultFile
    2011-10-23 00:41:26 [WARNING] [AuthDB] Error line: 888
    2011-10-23 00:41:26 [WARNING] [AuthDB] Check log file: plugins/AuthDB\logs\error\2011-10-23-error.log
    2011-10-23 00:41:26 [WARNING] [AuthDB]
    |-----------------------------------------------------------------------------|
    |--------------------------------AUTHDB WARNING-------------------------------|
    |-----------------------------------------------------------------------------|
    | STACKTRACE ERROR
    |-----------------------------------------------------------------------------|
    2011-10-23 00:41:26 [WARNING] [AuthDB] Class name: com.craftfire.util.managers.LoggingManager
    2011-10-23 00:41:26 [WARNING] [AuthDB] File name: LoggingManager.java
    2011-10-23 00:41:26 [WARNING] [AuthDB] Function name: ToFile
    2011-10-23 00:41:26 [WARNING] [AuthDB] Error line: 255
    2011-10-23 00:41:26 [WARNING] [AuthDB] Check log file: plugins/AuthDB\logs\error\2011-10-23-error.log
    2011-10-23 00:41:26 [WARNING] [AuthDB]
    Plus, here's the error log :

    Code:
    2011/10/23 00:19:40 - ---------------------------- STACKTRACE END ----------------------------
    2011/10/23 00:19:40 - Class name: com.craftfire.util.managers.LoggingManager
    2011/10/23 00:19:40 - File name: LoggingManager.java
    2011/10/23 00:19:40 - Function name: ToFile
    2011/10/23 00:19:40 - Error line: 255
    2011/10/23 00:19:40 - AuthDB version: 2.3.2.220
    2011/10/23 00:19:40 - Keep alive: false
    2011/10/23 00:19:40 - MySQL connection: false
    2011/10/23 00:19:40 - Latest query: 
    2011/10/23 00:19:40 - Script: phpbb
    2011/10/23 00:19:40 - Script version: 3.0.8
    2011/10/23 00:19:40 - Table prefix: 
    2011/10/23 00:19:40 - Plugins: BukkitCompat r15A, CustomDifficulty 4.4.0 (for CB: 1185), AutoClear 1.2, MineMaze 1.5, MobRider 0.39, CommandBook 1.6, iConomy 6.0.7b, Giant Trees 0.3.3, DropClear 1.7.6_1, ThunderTools 0.3, Skills 1.3, ColoredSigns 1.1, PermissionsEx 1.15, TGM 1.0, MultiInv 2.4.1, PickACard 2.2, OpenInv 1.5.2, WorldEdit 4.7, Spout 1.0.6.483, ClearInventory 0.3, ControlORBle 2.2.1, Modifyworld 1.15, godPowers 2.5, SpoutTrade 1.4.1, MobDisguise 1.63, AuthDB 2.3.2.220, CraftGroup 0.3.3, HeroicDeath 1.11.2, GlobalChestBanking 1.2.3, Multiverse-Core 2.1-b326, Announcements 0.3, Permissions 2.7.7, WorldGuard 5.3, Graveyard 0.4.0, Questioner 0.4, SpoutBlocks 1.4, BookWorm 1.8, SpoutFlight 1.2, Highlighter 0.3, dynmap 0.23, ChatManager 1.15, MagicSpells 1.2, Showcase 0.7.7.11, NarrowtuxLib 1.0.0, HawkEye 1.0.5, PreciousStones 7.0.2, Register 1.5, Citizens 1.1.1, CreativeGates 1.3.2, TownyChat 0.2, Towny 0.77.0.3, 
    2011/10/23 00:19:40 - --------------------------- STACKTRACE START ---------------------------
    2011/10/23 00:19:40 - java.io.FileOutputStream.openAppend(Native Method)
    2011/10/23 00:19:40 - java.io.FileOutputStream.<init>(FileOutputStream.java:207)
    2011/10/23 00:19:40 - java.io.FileOutputStream.<init>(FileOutputStream.java:131)
    2011/10/23 00:19:40 - java.io.FileWriter.<init>(FileWriter.java:78)
    2011/10/23 00:19:40 - com.craftfire.util.managers.LoggingManager.ToFile(LoggingManager.java:249)
    2011/10/23 00:19:40 - com.craftfire.util.managers.LoggingManager.logError(LoggingManager.java:209)
    2011/10/23 00:19:40 - com.craftfire.util.managers.LoggingManager.StackTrace(LoggingManager.java:116)
    2011/10/23 00:19:40 - com.craftfire.util.managers.LoggingManager.ToFile(LoggingManager.java:255)
    Don't know if this is supposed to tell basic informations about the config, but these are not the values that I had once configured...

    Plus, the files "basic.yml" and "advanced.yml were not generated on first time.
     
  30. Offline

    Wulfspider

    Looks like it simply couldn't find your config files and tried to make new ones.
     
  31. Offline

    _bLah

    I tried to recreate the restarting with ipb and it wouldn't do it. Everything was working fine for a little while. Then, while I was trying to get the message, "you need to register on the forums, with the same name...", to the players, everything went wrong. I went to relog and it wouldnt log me in it just kept saying you need to log in blah blah blah.. No "wrong password" or anything. Then the server kicks me and I cant join because, "no connection to the database", authdb disabled..
    The error log in the authdb folder is attached. This is with IPBoard 3.2.0
    server.log events:
    Code:
    2011-10-23 04:35:11 [INFO] Genuine [/*.*.*.*:*] logged in with entity id 301039 at ([survival] 152.5, 78.0, 483.5)
    2011-10-23 04:35:11 [WARNING] [AuthDB]
    |-----------------------------------------------------------------------------|
    |--------------------------------AUTHDB WARNING-------------------------------|
    |-----------------------------------------------------------------------------|
    | STACKTRACE ERROR
    |-----------------------------------------------------------------------------|
    2011-10-23 04:35:11 [WARNING] [AuthDB] Class name: com.authdb.AuthDB
    2011-10-23 04:35:11 [WARNING] [AuthDB] File name: AuthDB.java
    2011-10-23 04:35:11 [WARNING] [AuthDB] Function name: isRegistered
    2011-10-23 04:35:11 [WARNING] [AuthDB] Error line: 824
    2011-10-23 04:35:11 [WARNING] [AuthDB] Check log file: plugins/AuthDB\logs\error\2011-10-23-error.log
    2011-10-23 04:35:11 [WARNING] [AuthDB]
    |-----------------------------------------------------------------------------|
    |--------------------------------AUTHDB WARNING-------------------------------|
    |-----------------------------------------------------------------------------|
    | ERRORS IN CHECKING USER. PLUGIN WILL NOT WORK. DISABLING IT.
    |-----------------------------------------------------------------------------|
    2011-10-23 04:35:11 [INFO] [AuthDB] 2.3.2.220 has been disabled
    2011-10-23 04:35:11 [WARNING] [AuthDB]
    |-----------------------------------------------------------------------------|
    |--------------------------------AUTHDB WARNING-------------------------------|
    |-----------------------------------------------------------------------------|
    | STACKTRACE ERROR
    |-----------------------------------------------------------------------------|
    2011-10-23 04:35:11 [WARNING] [AuthDB] Class name: com.authdb.AuthDB
    2011-10-23 04:35:11 [WARNING] [AuthDB] File name: AuthDB.java
    2011-10-23 04:35:11 [WARNING] [AuthDB] Function name: isRegistered
    2011-10-23 04:35:11 [WARNING] [AuthDB] Error line: 824
    2011-10-23 04:35:11 [WARNING] [AuthDB] Check log file: plugins/AuthDB\logs\error\2011-10-23-error.log
    2011-10-23 04:35:11 [WARNING] [AuthDB]
    |-----------------------------------------------------------------------------|
    |--------------------------------AUTHDB WARNING-------------------------------|
    |-----------------------------------------------------------------------------|
    | ERRORS IN CHECKING USER. PLUGIN WILL NOT WORK. DISABLING IT.
    |-----------------------------------------------------------------------------|
    2011-10-23 04:35:11 [WARNING] [AuthDB]
    |-----------------------------------------------------------------------------|
    |--------------------------------AUTHDB WARNING-------------------------------|
    |-----------------------------------------------------------------------------|
    | STACKTRACE ERROR
    |-----------------------------------------------------------------------------|
    2011-10-23 04:35:11 [WARNING] [AuthDB] Class name: com.authdb.AuthDB
    2011-10-23 04:35:11 [WARNING] [AuthDB] File name: AuthDB.java
    2011-10-23 04:35:11 [WARNING] [AuthDB] Function name: isRegistered
    2011-10-23 04:35:11 [WARNING] [AuthDB] Error line: 768
    2011-10-23 04:35:11 [WARNING] [AuthDB] Check log file: plugins/AuthDB\logs\error\2011-10-23-error.log

    As for the vBulletin problem; It wont accept the correct password on vB 4.1.5
    This is my main concern, vbulletin. I have grown to it very fast. Tried the demo for vb suite, found the perfect style, and had to buy it. Now I just need a plugin like authdb to work with it..
    Could it be because I am using vBulletin suite 4.1.5 and not vBulletin forum 4.1.5?

    Code:
    2011-10-23 05:53:33 [INFO] [AuthDB] messages language set to English
    2011-10-23 05:53:33 [INFO] [AuthDB] commands language set to English
    2011-10-23 05:53:33 [INFO] Can not test connection as heartbeatsql is not set
    2011-10-23 05:53:33 [INFO] Closing Connection[AuthDB.1] psReuse[0] psCreate[1] psSize[0]
    2011-10-23 05:53:33 [INFO] [AuthDB] Installing persistence database for AuthDB due to first time usage
    2011-10-23 05:53:33 [INFO] runScript
    2011-10-23 05:53:33 [INFO] executing 1 of 1 create table authdb_users ( id                        integer primary key, playe...
    2011-10-23 05:53:33 [INFO] ... end of script
    2011-10-23 05:53:33 [INFO] [AuthDB] Found supported plugin: Permissions 2.7.7
    2011-10-23 05:53:35 [INFO] [AuthDB] 5 user registrations in database
    2011-10-23 05:53:35 [INFO] [AuthDB] 2.3.2.220 is enabled
    2011-10-23 05:53:35 [INFO] [AuthDB] developed by CraftFire <dev@craftfire.com>
    Never had that before... and now I also get this when I try to login:
    Code:
    2011-10-23 05:54:12 [INFO] Can not test connection as heartbeatsql is not set
    2011-10-23 05:54:12 [INFO] Closing Connection[AuthDB.0] psReuse[3] psCreate[7] psSize[7]
    2011-10-23 05:54:12 [INFO] DataSourcePool [AuthDB] grow; id[AuthDB.2] busy[3] max[20]
    2011-10-23 05:54:12 [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:81)
    	at com.authdb.util.databases.EBean.sync(EBean.java:101)
    	at com.authdb.util.databases.EBean.sync(EBean.java:85)
    	at com.authdb.listeners.AuthDBPlayerListener.onPlayerLogin(AuthDBPlayerListener.java:68)
    	at org.bukkit.plugin.java.JavaPluginLoader$13.execute(JavaPluginLoader.java:344)
    	at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
    	at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:339)
    	at net.minecraft.server.ServerConfigurationManager.a(ServerConfigurationManager.java:200)
    	at net.minecraft.server.NetLoginHandler.b(NetLoginHandler.java:88)
    	at net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:80)
    	at net.minecraft.server.Packet1Login.a(SourceFile:59)
    	at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
    	at net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:46)
    	at net.minecraft.server.NetworkListenThread.a(SourceFile:94)
    	at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:471)
    	at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:374)
    	at net.minecraft.server.ThreadServerApplication.run(SourceFile:417)
    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
    There is no authdb_users table in the database.
    It never tried to create that table before I started typing out this reply..
     

    Attached Files:

Share This Page