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

    Snaipe

    The main problem is that the config files exists... What should I do ?
     
  3. Offline

    Wulfspider

    There is no authdb_users table in the database.
    It never tried to create that table before I started typing out this reply..[/quote]
    The authdb_users table is referring to the local AuthDB.db table that is a cache for your script's database. Don't worry about it.

    The last error happens the first time for each new user. It's an open issue, but it doesn't affect anything really.

    Next time user spoilers. ;)

    Not sure... likely something screwy with your server setup. It's having issues trying to write and read files from the sound of it. If you could, copy the server locally and test.

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

    _bLah

    @Wulfspier
    Something I can do so you can better help me?
    or
    "Could it be because I am using vBulletin suite 4.1.5 and not vBulletin forum 4.1.5?"

    I will donate $5 to craftfire or wulf if you guys can help me get this working with vb suite 4.1.5 or anyone else who wants to help.
     
  5. Offline

    Wulfspider

    I'm not sure. I'll have to test with the vBulletin Suite and see.
     
  6. Offline

    _bLah

    I guess I will get a nulled version of just the forums and test with that.


    edit::
    Same issue with just the forums. 4.1.5, craftbukkit 1337.
    help por favor :(

    edit:::
    forgot to mention its Version 4.1.5 Patch Level 1
     
  7. Offline

    Wulfspider

    It's likely the user table doesn't match up somehow and it's throwing it off. I think on some of our older supported scripts, it doesn't allow for changes or variations to the table from default.
     
  8. Offline

    _bLah

    It also does not work with just plain old 4.1.5 without patch level 1
    It being nulled should mean nothing. It don't change the mysql tables.

    Im about to jump into that source file.. I hope java isnt too much different from php
    edit:: idk about that.. im not ready to learn java
    maybe it is just different, here is what I get:
    Table; user[username, password, salt] Obviously thats not all the columns but thos are the only three that matter, right?
    Is that the same as whats in the vbulletin script?


    I would like to get this working and get my server open before I go back to work Wednesday.. :(
     
  9. Offline

    aymanh

    Thank you for aswome plugin but Please fix all the bugs,i am using authme in mean time.
    I hope you find Developer!
     
  10. Offline

    _bLah

    Has anyone any idea why it wont work for my vb 4.1.5? Has anyone even seen it work with vb at all? .. Has it even been tested with vb4?

    Spending my days off trying to get this damn thing figured out is not very fun..

    It connects to the database, pulls the correct number of entries/users from the correct table but is not reading the password correctly.
    You tell me, what forums has this been tested with and are people using the most. PHPBB? Cause I will install it and set it up just to prove that this isn't an error on my end. It cant be..

    forgot to mention i also get this in server log on every start with authdb installed:
    maybe fixing that will fix it?

    I think updating my plugins fixed it.. I really hope I am not speaking too soon.. :/

    I got two people logged in and so far no restarting. I will open up the server and see what it does with more people.
    Even /register works. :)

    I spoke too soon..

    After people started to login it started again. Still no god damn logs or errors.. :-/

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Nov 10, 2018
  11. Offline

    Wulfspider

    Each script is different. It has been tested with all the scripts it supports, but all are not bug-free.

    I just tested it with vBulletin 4.1.5 and it connects fine. The password acceptance may have issues in-game though. A few of the scripts have issues with that right now.

    Go ahead and get the latest dev build from http://ci.craftfire.com/job/AuthDB when it gets done building. The check for the salt was missing and I've fixed that and it seems to be working now.

    Thanks, hopefully I can get a few people to get started toward AuthDB 3.0.0 and get some fixes made for AuthDB 2.x.

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

    _bLah

    So your saying that when you tested it you were also unable to login to the server? Or, are you saying that you were able to login without getting "password incorrect..."?
    You said it connects fine, so does mine.

    Another bug I have refound, yes refound, is it restarting the server. Remmber how I said it was restarting my server without any error on ipb? Well, now it is doing it on vbulletin. It has not triggered for me since now because I was only ever loging in with an existing user and not trying to register. It happends on vb4.1.3 (not tested on 4.1.5) when a new user, without an account in the database, connects, randomly. It also happens when you register, not sure if its always or random, I only registered once. Though it still creates the user in the database.
    That one is probably a plugin interaction or something.. idk. feel free to look into it.


    Ill just suck it up for now and do a manual whitelist.
    I really hope you guys can get this fixed up before 1.9. My donation still stands but your not getting it until this is a lot more bug free, or at least usable on my server.

     
  13. Offline

    Wulfspider

    If you look in my post above, I already stated that I fixed the incorrect password issue. I asked that you would test the latest dev build that I linked.

    Regarding the restarting issue, I have no idea how it would be doing that unless you gave someone permission to use /authdb reload. It wouldn't be reloading the whole server though.
     
  14. Offline

    _bLah

    Didn't see it, sorry.
    Tried it. It works :) The logging in part works anyway. Thank you wulfspider :)

    Umm... about the mysterious restarting; still doing that and I already know its going to do it a lot if I open my server. I will still try it.
    It happened twice while testing that dev build to me. before I logged in and a few minutes after i logged in. I dont know if its the massive ammounts of people trying to connect an getting kicked or a plugin conflict or a bug, or maybe the fact that im connecting to a remote mysql?

    I gotta go smoke a bowl ill do some more testing and get back to you

    Just confirmed it is not my two admins with restart access, its certainly not me. I'm the only person connecting to the server out of 5 people who are able to connect. So its very unlikely that someone is restarting or reloading anything. Hell, i'm not even moving in the game just logged in and standing there, so far its restarted 3 times.
    Here is server log when it happens:
    Then from there it disables all plugin and starts back up. JUST like a normal restart when I do it in multicraft.
    No hs_log files in root and no log files in authdb dir.


    It restarted again while typing this.
    I haven't updated plugins in a week so I guess I will do that now and see if that helps.

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

    Wulfspider

    I have no idea. Sounds like something silly MultiCraft is doing.

    That isn't anything big. It's just the ebean.properties missing. By default, it only contains ebean.logging=none. That's a CraftBukkit thing.

    Try without MultiCraft?

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

    _bLah

    Paid hosting. I will ask my host for any multicraft error logs. Think that would tell you anything?
     
  17. Offline

    XeroXo

    i got the same problem....
    Code:
    2011-10-26 00:05:25 [INFO] IceCream3o5 [/91.xx.24.xxx:xxxx] logged in with entity id 149 at ([world] -101.1875, 68.0, 306.40625)
    2011-10-26 00:05:26 [INFO] [PermissionsEx] Permissions handler for IceCream3o5 successfuly injected
    2011-10-26 00:05:26 [INFO] New max size: 484
    2011-10-26 00:05:26 [INFO] New max size: 784
    2011-10-26 00:05:34 [WARNING] [AuthDB]
    |-----------------------------------------------------------------------------|
    |--------------------------------AUTHDB WARNING-------------------------------|
    |-----------------------------------------------------------------------------|
    | STACKTRACE ERROR
    |-----------------------------------------------------------------------------|
    2011-10-26 00:05:34 [WARNING] [AuthDB] Class name: com.authdb.listeners.AuthDBPlayerListener
    2011-10-26 00:05:34 [WARNING] [AuthDB] File name: AuthDBPlayerListener.java
    2011-10-26 00:05:34 [WARNING] [AuthDB] Function name: onPlayerCommandPreprocess
    2011-10-26 00:05:34 [WARNING] [AuthDB] Error line: 418
    2011-10-26 00:05:34 [WARNING] [AuthDB] Check log file: plugins/AuthDB\logs\error\2011-10-26-error.log
    2011-10-26 00:07:01 [WARNING] [AuthDB]
    and the Errolog

    Code:
    2011/10/26 00:02:33 - Could not find script's tables in database: ni35945_2_DB!
    2011/10/26 00:02:33 - --------------------------- STACKTRACE ERROR ---------------------------
    2011/10/26 00:02:33 - Class name: com.authdb.AuthDB
    2011/10/26 00:02:33 - File name: AuthDB.java
    2011/10/26 00:02:33 - Function name: onEnable
    2011/10/26 00:02:33 - Error line: 308
    2011/10/26 00:02:33 - AuthDB version: 2.3.2.220
    2011/10/26 00:02:33 - Keep alive: false
    2011/10/26 00:02:33 - MySQL connection: true
    2011/10/26 00:02:33 - Latest query:
    2011/10/26 00:02:33 - Script: phpbb
    2011/10/26 00:02:33 - Script version: 3.0.8
    2011/10/26 00:02:33 - Table prefix: phpbb_
    2011/10/26 00:02:33 - Plugins: Residence 2.4.2, WorldEdit 4.7, PermissionsEx 1.15.1, ResidenceSigns 0.2, Essentials 2.6.4, EssentialsProtect 2.6.4, Modifyworld 1.15, EssentialsSpawn 2.6.4, ChatManager 1.15, Permissions 2.7.7, AuthDB 2.3.2.220,
    2011/10/26 00:02:33 - --------------------------- STACKTRACE START ---------------------------
    2011/10/26 00:02:33 - sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011/10/26 00:02:33 - sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    2011/10/26 00:02:33 - sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    2011/10/26 00:02:33 - java.lang.reflect.Constructor.newInstance(Constructor.java:525)
    2011/10/26 00:02:33 - com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011/10/26 00:02:33 - com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011/10/26 00:02:33 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011/10/26 00:02:33 - com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011/10/26 00:02:33 - com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011/10/26 00:02:33 - com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011/10/26 00:02:33 - com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011/10/26 00:02:33 - com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
    2011/10/26 00:02:33 - com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
    2011/10/26 00:02:33 - com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2273)
    2011/10/26 00:02:33 - com.authdb.util.Util.checkScript(Util.java:731)
    2011/10/26 00:02:33 - com.authdb.AuthDB.onEnable(AuthDB.java:268)
    2011/10/26 00:02:33 - org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:174)
    2011/10/26 00:02:33 - org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:957)
    2011/10/26 00:02:33 - org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:280)
    2011/10/26 00:02:33 - org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:171)
    2011/10/26 00:02:33 - org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:154)
    2011/10/26 00:02:33 - net.minecraft.server.MinecraftServer.e(MinecraftServer.java:297)
    2011/10/26 00:02:33 - net.minecraft.server.MinecraftServer.a(MinecraftServer.java:284)
    2011/10/26 00:02:33 - net.minecraft.server.MinecraftServer.init(MinecraftServer.java:152)
    2011/10/26 00:02:33 - net.minecraft.server.MinecraftServer.run(MinecraftServer.java:348)
    2011/10/26 00:02:33 - net.minecraft.server.ThreadServerApplication.run(SourceFile:417)
    2011/10/26 00:02:33 - ---------------------------- STACKTRACE END ----------------------------
    2011/10/26 00:05:34 - --------------------------- STACKTRACE ERROR ---------------------------
    2011/10/26 00:05:34 - Class name: com.authdb.listeners.AuthDBPlayerListener
    2011/10/26 00:05:34 - File name: AuthDBPlayerListener.java
    2011/10/26 00:05:34 - Function name: onPlayerCommandPreprocess
    2011/10/26 00:05:34 - Error line: 418
    2011/10/26 00:05:34 - AuthDB version: 2.3.2.220
    2011/10/26 00:05:34 - Keep alive: false
    2011/10/26 00:05:34 - MySQL connection: true
    2011/10/26 00:05:34 - Latest query: com.mysql.jdbc.JDBC4PreparedStatement@3826ea10: INSERT INTO `authdb_users` (`username`,`password`)  VALUES ('IceCream3o5','1c7cc9aec48d3c2699513201728c24e1')
    2011/10/26 00:05:34 - Script: Custom
    2011/10/26 00:05:34 - Custom table: authdb_users
    2011/10/26 00:05:34 - Custom passfield: password
    2011/10/26 00:05:34 - Custom userfield: username
    2011/10/26 00:05:34 - Custom encryption: md5
    2011/10/26 00:05:34 - Custom table schema:
    2011/10/26 00:05:34 - Table Name : authdb_users
    2011/10/26 00:05:34 - Column    Type(size)
    2011/10/26 00:05:34 - id    INT(11)
    2011/10/26 00:05:34 - playername    VARCHAR(255)
    2011/10/26 00:05:34 - linkedname    VARCHAR(255)
    2011/10/26 00:05:34 - password    VARCHAR(255)
    2011/10/26 00:05:34 - salt    VARCHAR(255)
    2011/10/26 00:05:34 - ip    VARCHAR(255)
    2011/10/26 00:05:34 - email    VARCHAR(255)
    2011/10/26 00:05:34 - inventory    VARCHAR(600)
    2011/10/26 00:05:34 - equipment    VARCHAR(255)
    2011/10/26 00:05:34 - activated    VARCHAR(255)
    2011/10/26 00:05:34 - registered    VARCHAR(255)
    2011/10/26 00:05:34 - authorized    VARCHAR(255)
    2011/10/26 00:05:34 - timeoutid    INT(11)
    2011/10/26 00:05:34 - reloadtime    BIGINT(20)
    2011/10/26 00:05:34 - sessiontime    BIGINT(20)
    2011/10/26 00:05:34 - Plugins: Residence 2.4.2, WorldEdit 4.7, PermissionsEx 1.15.1, ResidenceSigns 0.2, Essentials 2.6.4, EssentialsProtect 2.6.4, Modifyworld 1.15, EssentialsSpawn 2.6.4, ChatManager 1.15, Permissions 2.7.7, AuthDB 2.3.2.220,
    2011/10/26 00:05:34 - --------------------------- STACKTRACE START ---------------------------
    2011/10/26 00:05:34 - sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011/10/26 00:05:34 - sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    2011/10/26 00:05:34 - sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    2011/10/26 00:05:34 - java.lang.reflect.Constructor.newInstance(Constructor.java:525)
    2011/10/26 00:05:34 - com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011/10/26 00:05:34 - com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011/10/26 00:05:34 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011/10/26 00:05:34 - com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011/10/26 00:05:34 - com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011/10/26 00:05:34 - com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011/10/26 00:05:34 - com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011/10/26 00:05:34 - com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
    2011/10/26 00:05:34 - com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
    2011/10/26 00:05:34 - com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2407)
    2011/10/26 00:05:34 - com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2325)
    2011/10/26 00:05:34 - com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2310)
    2011/10/26 00:05:34 - com.authdb.scripts.Custom.adduser(Custom.java:52)
    2011/10/26 00:05:34 - com.authdb.util.Util.checkScript(Util.java:119)
    2011/10/26 00:05:34 - com.authdb.AuthDB.register(AuthDB.java:648)
    2011/10/26 00:05:34 - com.authdb.listeners.AuthDBPlayerListener.onPlayerCommandPreprocess(AuthDBPlayerListener.java:404)
    2011/10/26 00:05:34 - org.bukkit.plugin.java.JavaPluginLoader$5.execute(JavaPluginLoader.java:288)
    2011/10/26 00:05:34 - org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
    2011/10/26 00:05:34 - org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:339)
    2011/10/26 00:05:34 - net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:750)
    2011/10/26 00:05:34 - net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:722)
    2011/10/26 00:05:34 - net.minecraft.server.NetServerHandler.a(NetServerHandler.java:715)
    2011/10/26 00:05:34 - net.minecraft.server.Packet3Chat.a(Packet3Chat.java:33)
    2011/10/26 00:05:34 - net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
    2011/10/26 00:05:34 - net.minecraft.server.NetServerHandler.a(NetServerHandler.java:92)
    2011/10/26 00:05:34 - net.minecraft.server.NetworkListenThread.a(SourceFile:108)
    2011/10/26 00:05:34 - net.minecraft.server.MinecraftServer.h(MinecraftServer.java:471)
    2011/10/26 00:05:34 - net.minecraft.server.MinecraftServer.run(MinecraftServer.java:374)
    2011/10/26 00:05:34 - net.minecraft.server.ThreadServerApplication.run(SourceFile:417)
    2011/10/26 00:05:34 - ---------------------------- STACKTRACE END ----------------------------
    2011/10/26 00:07:01 - --------------------------- STACKTRACE ERROR ---------------------------
    2011/10/26 00:07:01 - Class name: com.authdb.listeners.AuthDBPlayerListener
    2011/10/26 00:07:01 - File name: AuthDBPlayerListener.java
    2011/10/26 00:07:01 - Function name: onPlayerCommandPreprocess
    2011/10/26 00:07:01 - Error line: 418
    2011/10/26 00:07:01 - AuthDB version: 2.3.2.220
    2011/10/26 00:07:01 - Keep alive: false
    2011/10/26 00:07:01 - MySQL connection: true
    2011/10/26 00:07:01 - Latest query: com.mysql.jdbc.JDBC4PreparedStatement@29d5862: INSERT INTO `authdb_users` (`username`,`password`)  VALUES ('IceCream3o5','1c7cc9aec48d3c2699513201728c24e1')
    2011/10/26 00:07:01 - Script: Custom
    2011/10/26 00:07:01 - Custom table: authdb_users
    2011/10/26 00:07:01 - Custom passfield: password
    2011/10/26 00:07:01 - Custom userfield: username
    2011/10/26 00:07:01 - Custom encryption: md5
    2011/10/26 00:07:01 - Custom table schema:
    2011/10/26 00:07:01 - Table Name : authdb_users
    2011/10/26 00:07:01 - Column    Type(size)
    2011/10/26 00:07:01 - id    INT(11)
    2011/10/26 00:07:01 - playername    VARCHAR(255)
    2011/10/26 00:07:01 - linkedname    VARCHAR(255)
    2011/10/26 00:07:01 - password    VARCHAR(255)
    2011/10/26 00:07:01 - salt    VARCHAR(255)
    2011/10/26 00:07:01 - ip    VARCHAR(255)
    2011/10/26 00:07:01 - email    VARCHAR(255)
    2011/10/26 00:07:01 - inventory    VARCHAR(600)
    2011/10/26 00:07:01 - equipment    VARCHAR(255)
    2011/10/26 00:07:01 - activated    VARCHAR(255)
    2011/10/26 00:07:01 - registered    VARCHAR(255)
    2011/10/26 00:07:01 - authorized    VARCHAR(255)
    2011/10/26 00:07:01 - timeoutid    INT(11)
    2011/10/26 00:07:01 - reloadtime    BIGINT(20)
    2011/10/26 00:07:01 - sessiontime    BIGINT(20)
    2011/10/26 00:07:01 - Plugins: Residence 2.4.2, WorldEdit 4.7, PermissionsEx 1.15.1, ResidenceSigns 0.2, Essentials 2.6.4, EssentialsProtect 2.6.4, Modifyworld 1.15, EssentialsSpawn 2.6.4, ChatManager 1.15, Permissions 2.7.7, AuthDB 2.3.2.220,
    2011/10/26 00:07:01 - --------------------------- STACKTRACE START ---------------------------
    2011/10/26 00:07:01 - sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011/10/26 00:07:01 - sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    2011/10/26 00:07:01 - sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    2011/10/26 00:07:01 - java.lang.reflect.Constructor.newInstance(Constructor.java:525)
    2011/10/26 00:07:01 - com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011/10/26 00:07:01 - com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011/10/26 00:07:01 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011/10/26 00:07:01 - com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011/10/26 00:07:01 - com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011/10/26 00:07:01 - com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011/10/26 00:07:01 - com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011/10/26 00:07:01 - com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
    2011/10/26 00:07:01 - com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
    2011/10/26 00:07:01 - com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2407)
    2011/10/26 00:07:01 - com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2325)
    2011/10/26 00:07:01 - com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2310)
    2011/10/26 00:07:01 - com.authdb.scripts.Custom.adduser(Custom.java:52)
    2011/10/26 00:07:01 - com.authdb.util.Util.checkScript(Util.java:119)
    2011/10/26 00:07:01 - com.authdb.AuthDB.register(AuthDB.java:648)
    2011/10/26 00:07:01 - com.authdb.listeners.AuthDBPlayerListener.onPlayerCommandPreprocess(AuthDBPlayerListener.java:404)
    2011/10/26 00:07:01 - org.bukkit.plugin.java.JavaPluginLoader$5.execute(JavaPluginLoader.java:288)
    2011/10/26 00:07:01 - org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
    2011/10/26 00:07:01 - org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:339)
    2011/10/26 00:07:01 - net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:750)
    2011/10/26 00:07:01 - net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:722)
    2011/10/26 00:07:01 - net.minecraft.server.NetServerHandler.a(NetServerHandler.java:715)
    2011/10/26 00:07:01 - net.minecraft.server.Packet3Chat.a(Packet3Chat.java:33)
    2011/10/26 00:07:01 - net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
    2011/10/26 00:07:01 - net.minecraft.server.NetServerHandler.a(NetServerHandler.java:92)
    2011/10/26 00:07:01 - net.minecraft.server.NetworkListenThread.a(SourceFile:108)
    2011/10/26 00:07:01 - net.minecraft.server.MinecraftServer.h(MinecraftServer.java:471)
    2011/10/26 00:07:01 - net.minecraft.server.MinecraftServer.run(MinecraftServer.java:374)
    2011/10/26 00:07:01 - net.minecraft.server.ThreadServerApplication.run(SourceFile:417)
    2011/10/26 00:07:01 - ---------------------------- STACKTRACE END ----------------------------
    
     
  18. Offline

    Wulfspider

    The same problem as who? The errors you posted are not the same.

    Why did you add all of that info to your customdb table? Did you modify your bukkit.yml?

    Also... please use spoilers or pastie.org when posting log messages... :/
     
  19. Offline

    XeroXo

    I think it was 2 sides before but ok
    sorry its the first time i wride here...
    next time i use a spoiler

    now i got it
    i must delete the MySQL DB file
    and the bukkit.yml
    that was the problem ^^
    nice plugin thx a lot
     
  20. Offline

    Wulfspider

    Glad you got it figured out. :)
     
  21. Offline

    WolwX

    Hello @Wulfspider :)

    I reported a bug, one month ago, with smf interaction and "bad password" result when user have CAPS in their name.

    I checked the jar you provided yersterday for a similar bug with vb, but that's still the same issue :(

    http://ci.craftfire.com/job/AuthDB/226/

    Can you help me ? :(
     
  22. Offline

    Wulfspider

    I'll look and see now.

    Give this a shot and see how it does: http://ci.getspout.org/job/AuthDB/229/artifact/target/authdb-dev-SNAPSHOT.jar. I've tested it locally and it works now. Sorry for the delay.

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

    WolwX

    Here are my result =>

    Code:
    2011-10-26 21:01:37 [INFO] [AuthDB] messages language set to French
    2011-10-26 21:01:37 [INFO] [AuthDB] commands language set to French
    2011-10-26 21:01:38 [INFO] Can not test connection as heartbeatsql is not set
    2011-10-26 21:01:38 [INFO] Closing Connection[AuthDB.1] psReuse[0] psCreate[1] psSize[0]
    2011-10-26 21:01:38 [INFO] [AuthDB] Installing persistence database for AuthDB due to first time usage
    2011-10-26 21:01:38 [INFO] runScript
    2011-10-26 21:01:38 [INFO] executing 1 of 1 create table authdb_users ( id integer primary key, playe...
    2011-10-26 21:01:38 [INFO] ... end of script
    2011-10-26 21:01:38 [INFO] [AuthDB] Found supported plugin: Permissions 3.1.6
    2011-10-26 21:01:38 [INFO] [AuthDB] 282 user registrations in database
    2011-10-26 21:01:38 [INFO] [AuthDB] 2.3.3.229 is enabled
    2011-10-26 21:01:38 [INFO] [AuthDB] developed by CraftFire <dev@craftfire.com>
    Still have a problem with player using CAPS
    Processing login...
    Password Incorrect, please try again.

    Include when I use only my basic.yml file :/
     
  24. Offline

    Wulfspider

    Mmmk, I'll look and see what I can do.
     
  25. Offline

    MJRamon

    There are still problems with too many connections to MySQL. Problem appears regular in some time after fixing it by deleting .db file
     
  26. Thanks again for this great plugin :)
    Is there any news about account activation? Cause the plugin still bypasses any account which is not activated and let the user login :D I like users to verify their email :)
     
  27. Offline

    Wulfspider

    The project is somewhat on hold right now until I can find able developers to assist. New features won't be added until then, but I'll do what I can to fix small bugs.
     
  28. Offline

    _bLah

    I told my host about this situation and they went to the multicraft support peeps. I guess its a happening to others as well:
    From my host, Zen-GC.
    :-/
     
  29. Offline

    _bLah

    My host "Disabled timeouts"? and now it don't restart the server.

    I noticed a big. After 3 minutes of someone not logging in it says "You have been kicked for not blah blah.." but it does not kick the player.
     
  30. Offline

    Wulfspider

    The not kicking is a bug in the current.
     
  31. Offline

    _bLah

    Do you think you could add support for vb4.1.7? Shouldnt be too much different from 4.1.5.

    I would like to donate towards authdb but is it going to die?
     

Share This Page