Inactive [ADMN/SEC] AuthDB v2.3.6 - Database authentication and protection [1.1-1.4.5]

When will there be an update?
I can't wait to test out those temp spawn every login.

There is currently and glitch also players during the process of logging in they can hit people close to them.

Well. Obviously it can't connect to the local database. Make sure you have the right login/pass and that it's run on the same computer as the server (since it's looking for localhost) and that you've entered the right databasename (the same database that wordpress uses if it's wordpress you're using)

I have almost the same problem like @OklaMokla what is different to me is, that the server is running fine, but at some point console start spamming this http://pastebin.com/XALNBe2j when I open Authdb log file is the same. What causing this? I think the answer is different from "Your Mysql is down" since my website is running on the same server, using same DB and running fine at the time when Authdb report, that can't connect. Only solution is to restart the minecraft server.

Same prob for me. Runs fine first and then after a month this shows up for me to. Feels like it's failing when the database are expanding?

At first I think, that DB is over flooded with connections and crippled down, but as I said my website using the same database and the same tables as AuthDB and worked fine at the time when this error occur, so I think the problem is in AuthDB itself, and also notice the log files the problem start to appear randomly after I updated to the last version, another thing is that after checking the log files the older ones show error message that I posted above, only one or two times, recent ones however, showed like a 20 or so...

Hello,
I would like to learn one thing. I couldn't configure the plugin to like white-list. I mean I set that guests can't register and they get kicked in 2 seconds. But what I want is they can't even join.
Could someone please help me with that?

Thanks, we'll have a look into the issue. Sorry for the delay. The forums tend to not email notifications after awhile.

There will be an update when @contex is able to. He's been busy with some exams lately.

It doesn't really have any whitelist integration right now. Our new AuthDB will though, but that will likely be on the Spout server though.

Hi. I have a problem.
1. keepalive: false - when players connect to the server all connected players get lag for 2-3 seconds. Sometimes the server crashes for a minute, no errors in the console. Approximately every 10-20 joining - crash. In the console when joining players sometimes get "[WARNING] Can't keep up! Did the system time change, or is the server overloaded?".

2. "keepalive: true" - All is well, but after about an hour start to happen strange things. First stop working all authdb commands, such as login \ register \ logout. There were even cases of death notices about alive players.
Error log:

2012/06/06 23:01:47 - --------------------------- STACKTRACE ERROR ---------------------------
2012/06/06 23:01:47 - Class name: com.authdb.AuthDB
2012/06/06 23:01:47 - File name: AuthDB.java
2012/06/06 23:01:47 - Function name: isRegistered
2012/06/06 23:01:47 - Error line: 937
2012/06/06 23:01:47 - AuthDB version: 2.3.6.242
2012/06/06 23:01:47 - Keep alive: true
2012/06/06 23:01:47 - MySQL connection: true
2012/06/06 23:01:47 - Latest query: SELECT memberName FROM `smf_members` WHERE `memberName` = 'anton' LIMIT 1
2012/06/06 23:01:47 - Script: smf
2012/06/06 23:01:47 - Script version: 1.1.13
2012/06/06 23:01:47 - Table prefix: smf_
2012/06/06 23:01:47 - Plugins: Orebfuscator 1.4.5, bPermissions 2.9.4, Maplicate 1.2, PlugMan 1.6.8, WorldEdit 5.3, iConomy 7.0, AuthDB 2.3.6.242, CraftBukkitUpToDate 2.8.6, Vault 1.2.16-b184, rTriggers 2.4.2, Stargate 0.7.7.2, BanHammer 1.9.1, Chatlogging 2.2, SimpleModerator 0.5.1, SimpleRestart 1.3.3, Residence 2.6.0, HyperConomy 0.924, mChatSuite 1.2.5-b216jnks-R3, MineBackup 5.9.3, Turnstile 2.5.1, ChestShop 3.42, ResidenceSigns 2.1.1,
2012/06/06 23:01:47 - --------------------------- STACKTRACE START ---------------------------
2012/06/06 23:01:47 - sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
2012/06/06 23:01:47 - sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
2012/06/06 23:01:47 - sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
2012/06/06 23:01:47 - java.lang.reflect.Constructor.newInstance(Constructor.java:532)
2012/06/06 23:01:47 - com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
2012/06/06 23:01:47 - com.mysql.jdbc.Util.getInstance(Util.java:382)
2012/06/06 23:01:47 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
2012/06/06 23:01:47 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
2012/06/06 23:01:47 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
2012/06/06 23:01:47 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
2012/06/06 23:01:47 - com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.java:1213)
2012/06/06 23:01:47 - com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1200)
2012/06/06 23:01:47 - com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2485)
2012/06/06 23:01:47 - com.mysql.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:2467)
2012/06/06 23:01:47 - com.authdb.util.databases.MySQL.getfromtable(MySQL.java:226)
2012/06/06 23:01:47 - com.authdb.util.Util.checkScript(Util.java:726)
2012/06/06 23:01:47 - com.authdb.AuthDB.isRegistered(AuthDB.java:925)
2012/06/06 23:01:47 - com.authdb.listeners.AuthDBPlayerListener.onPlayerJoin(AuthDBPlayerListener.java:146)
2012/06/06 23:01:47 - sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2012/06/06 23:01:47 - sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
2012/06/06 23:01:47 - sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
2012/06/06 23:01:47 - java.lang.reflect.Method.invoke(Method.java:616)
2012/06/06 23:01:47 - org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:302)
2012/06/06 23:01:47 - org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62)
2012/06/06 23:01:47 - org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:459)
2012/06/06 23:01:47 - net.minecraft.server.ServerConfigurationManager.c(ServerConfigurationManager.java:132)
2012/06/06 23:01:47 - net.minecraft.server.NetLoginHandler.b(NetLoginHandler.java:129)
2012/06/06 23:01:47 - net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:94)
2012/06/06 23:01:47 - net.minecraft.server.Packet1Login.handle(SourceFile:68)
2012/06/06 23:01:47 - net.minecraft.server.NetworkManager.b(NetworkManager.java:229)
2012/06/06 23:01:47 - net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:48)
2012/06/06 23:01:47 - net.minecraft.server.NetworkListenThread.a(NetworkListenThread.java:61)
2012/06/06 23:01:47 - net.minecraft.server.MinecraftServer.w(MinecraftServer.java:567)
2012/06/06 23:01:47 - net.minecraft.server.MinecraftServer.run(MinecraftServer.java:459)
2012/06/06 23:01:47 - net.minecraft.server.ThreadServerApplication.run(SourceFile:492)
2012/06/06 23:01:47 - ---------------------------- STACKTRACE END ----------------------------

In what may be the problem? The server is powerful enough, 32GB ram, i7-2600.
PS: sorry for my english.

Any ideas?

Same problem here, but with keepalive: true, authdb chrashes and nobody need to login.

Is it possible to set so server doesnt accept connection cause like this people join and get kicked in 2 seconds.

I have the same thing after an hour. Plagin crash, no need to login. I posted from above log when keepalive: true/

I have reported it as a bug. Hope they will fix it

Please look at this bug: http://issues.craftfire.com/view.php?id=478

i can't disable email requirement...i have cinfigure the file but nothing happens...

Hi, I have the same issue but I managed to get a workaround and fix the login issues.
I do it by automatically reloading the plugin for every 5 minutes.
There is a plugin called "PlugMan" install that. It's a plugin manager that lets you enable/disable/reload plugins.

Now if you have a server panel (McMyAdmin or others that support scheduled tasks)
Go ahead and set a scheduled server command: plugman reload AuthDB
I think there's also a plugin that let's you set a schedule if you don't have a server panel.

This should be fixed though, it's a major security flaw for this plugin.

By the way, I need some help @Wulfspider

I wish to enable certain commands to Guests,
I've already edited my advanced.yml

Code:

guest:
    commands: true

commands is set to true but for some reason guests can't use any other commands except for /login and /li
and they are still forced to login

Also, is it possible to make custom commands for /login /link /unlink?

I'm using CommandHelper to make command aliases but it doesn't actually work because Guests cannot input any command, lol

Email is required for all scripts except for custom databases.

Guests are not the same as registered users. If a username is already registered, they have to login. There also is no way of allowing specific commands with it right now, it's all or nothing.

Not with AuthDB currently. Likely in the future versions something could be added.

How about enabling commands for Registered users?

That would be silly, because you'd be allowing a user not logged in to execute commands on someone else's account. They can just login to get access.

It looks like this plugin lags a lot:


What do I have to do?

That's an odd looking graph, would you by any chance have logs of what was happening during that graph?
If so, PM them to me and I'll take a look at them, I sense it's a mix of MySQL and the fact that the plugin is not threaded, yet.

Log sent.

Same issue, lag spikes on player join, it also take long to login

I have the same thing. I gave just above the log plugin crash.
Same server config like Regulus123 from here: http://forums.bukkit.org/threads/random-lags-and-crashes.80892/#post-1166046

@contex My NoLagg stats showing the same lag spikes on player join as @samschaap and @Regulus123, here is my graph:

Apparently NoFloatingTrees lags even more than AuthDB, but is already out of my plugins list!