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

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.​

 

Not everyone uses Spout and Spoutcraft, so we have to make it work for all.

We store them in AuthDB.db temporarily until a player logs in.

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

Sometimes its start to spam

Code:

011-08-31 14:54:40 [INFO] [AuthDB] Database type in config: mysql
2011-08-31 14:54:40 [INFO] [AuthDB] Database type set to MySQL
2011-08-31 14:54:40 [INFO] [AuthDB] Connecting to MySQL....
2011-08-31 14:54:40 [INFO] [AuthDB] Lauching function: connect()
2011-08-31 14:54:40 [INFO] [AuthDB] MySQL: jdbc:mysql://HOST:3306/blabla_site
2011-08-31 14:54:40 [INFO] [AuthDB] MySQL driver: mysql
2011-08-31 14:54:40 [INFO] [AuthDB] MySQL username: LOGIN
2011-08-31 14:54:40 [INFO] [AuthDB] MySQL password: PASSWORD
2011-08-31 14:54:40 [INFO] [AuthDB] MySQL host: IP
2011-08-31 14:54:40 [INFO] [AuthDB] MySQL port: 3306
2011-08-31 14:54:40 [INFO] [AuthDB] MySQL database: BLABLA_site
2011-08-31 14:54:40 [INFO] [AuthDB] MySQL prefix: jos_

And server is stuck.. can't close , cant do anything...
Mb just add limit in trues for Connect to DB ?

+ sever lugs when..

Code:

2011-08-31 15:06:18 [INFO] [AuthDB] Launching function: replaceStrings(String string, Player player, String additional)
2011-08-31 15:06:18 [INFO] [AuthDB] Took 0 seconds (27ms) to replace tags.
2011-08-31 15:06:18 [INFO] [AuthDB] Took 0 seconds (47ms) to send a message.

 

Are you using a permissions plugin of any sort? Using PermissionsBukkit or similar SuperPerms plugin should default to allowing users to use all the authdb.command.user nodes.

What starts to spam? Disable the debug mode to not show all the messages.

Could you get a screenshot of what is happening in the chat in game when this happens?

The "Password accepted" message isn't always instant because you may have a bit of lag in checking sometimes and it only shows the message when the password is actually successful after that check. We are hoping that with the eBeans sync, it would reduce the lag...

Ignore the BukkitContrib message. It's just a debug message for us.

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

Its spams to server. I Enabled debug to see when , why server start to lag.
When its start to write this - SERVER LUGGINNNGGG. Its not from debug..

 

I see, but I was able to move/walk for about a second before that message showed

 

Could you post a log with a bit more information? It's hard to tell anything from just a short piece of your log.

Yeah, just a delay in checking the password I think. We'll have to double check and see.

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

I think you only need spout plugin spoutcraft isn't required.

There is please enter your passwor or sth in blue and white color. I will post screenshot when this occurs again.

 

That's not the point though. The point is that we have to make it work WITHOUT other plugins too.

 

Here you are:

 

It said you just joined, so of course it would have the password prompt. Are you saying that it sends to password to chat and that's it?

 

When server falls and kicks everybody i connect again and it prompts for password but i can walk and type into chat and everything else. If i relog it prompts me and correctly blocks everything.

 

hello, I tried to register via game, then login to web (i have joomla CMS)
but it doesn't work and after registration I got this error in game

Code:

script:
  name: Joomla                                      # Name of the script you are using.
  version: 1.5.23                                   # Version of the script you are using.
  tableprefix: GgG_                              # Database table prefix for the script, if you use one.
#  passwordsalt:                                    # NOT IMPLEMENTED YET! Unique/custom password salt, if needed by the script.

Code:

2011/08/31 14:14:39 - --------------------------- STACKTRACE ERROR ---------------------------
2011/08/31 14:14:39 - Class name: com.authdb.listeners.AuthDBPlayerListener
2011/08/31 14:14:39 - File name: AuthDBPlayerListener.java
2011/08/31 14:14:39 - Function name: onPlayerCommandPreprocess
2011/08/31 14:14:39 - Error line: 409
2011/08/31 14:14:39 - --------------------------- STACKTRACE START ---------------------------
2011/08/31 14:14:39 - sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
2011/08/31 14:14:39 - sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
2011/08/31 14:14:39 - sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
2011/08/31 14:14:39 - java.lang.reflect.Constructor.newInstance(Constructor.java:513)
2011/08/31 14:14:39 - com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
2011/08/31 14:14:39 - com.mysql.jdbc.Util.getInstance(Util.java:382)
2011/08/31 14:14:39 - com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
2011/08/31 14:14:39 - com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
2011/08/31 14:14:39 - com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
2011/08/31 14:14:39 - com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
2011/08/31 14:14:39 - com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
2011/08/31 14:14:39 - com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
2011/08/31 14:14:39 - com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
2011/08/31 14:14:39 - com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2407)
2011/08/31 14:14:39 - com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2325)
2011/08/31 14:14:39 - com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2310)
2011/08/31 14:14:39 - com.authdb.scripts.cms.Joomla.adduser(Joomla.java:92)
2011/08/31 14:14:39 - com.authdb.util.Util.checkScript(Util.java:329)
2011/08/31 14:14:39 - com.authdb.AuthDB.register(AuthDB.java:654)
2011/08/31 14:14:39 - com.authdb.listeners.AuthDBPlayerListener.onPlayerCommandPreprocess(AuthDBPlayerListener.java:395)
2011/08/31 14:14:39 - org.bukkit.plugin.java.JavaPluginLoader$5.execute(JavaPluginLoader.java:272)
2011/08/31 14:14:39 - org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
2011/08/31 14:14:39 - org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:338)
2011/08/31 14:14:39 - net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:730)
2011/08/31 14:14:39 - net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:701)
2011/08/31 14:14:39 - net.minecraft.server.NetServerHandler.a(NetServerHandler.java:694)
2011/08/31 14:14:39 - net.minecraft.server.Packet3Chat.a(Packet3Chat.java:33)
2011/08/31 14:14:39 - net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
2011/08/31 14:14:39 - net.minecraft.server.NetServerHandler.a(NetServerHandler.java:89)
2011/08/31 14:14:39 - org.getspout.spout.SpoutNetServerHandler.a(SpoutNetServerHandler.java:478)
2011/08/31 14:14:39 - net.minecraft.server.NetworkListenThread.a(SourceFile:105)
2011/08/31 14:14:39 - net.minecraft.server.MinecraftServer.h(MinecraftServer.java:454)
2011/08/31 14:14:39 - net.minecraft.server.MinecraftServer.run(MinecraftServer.java:363)
2011/08/31 14:14:39 - net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
2011/08/31 14:14:39 - ---------------------------- STACKTRACE END ----------------------------

 

Try setting the script version to 1.5.22 in basic.yml.

 

registration successful, thank you

 

No problem! We need to add a more advanced version check.

 

We do already have something for version checking, however if the script version is not in the version range that we support it uses the newest script version, in this case it used Joomla 1.6, and it should've prompted the user to recheck their config file. Maybe we can find a way to default to the version range for example 1.5.24 to 1.5.22 instead of 1.6.x?

 

Already added an issue.

 

@Wulfspider
@contex

hi excusme but you can make a dev build working with inventory save disabled for today?

 

3.1.4 or it's not what you ask?

 

Are you sure you aren't on 3.2.0 or 3.2.1 of IP.Board?

 

@Wulfspider

with authDB when i disconnect without any other plugin i lose inventory, please fix this, it's very important.

 

Okay, so the error only shows in the console for the first time each player logs in. Right?
Is that the only issue you are having with it?

It seems with that issue, the player isn't recognized as registered at first, but if they log back in, they will be recognized as they should. Issue with eBeans no doubt.

 

@contex
No problem, take your time. Just notify me when you may know something^^

 

By looking to log , i that AuthDB , doesnt check password from LocalDB first , everytime its try to connect to MySQL..
And looping..

 

Test to himself, with no other players. An error occurs when you write a wrongpassword.

 

How is it looping?
AuthDB syncs the players password/salt from the MySQL on join.
Then later it checks the players password from the local cache when they do /login.
If the passwords do not match, it checks the MySQL to see if the password is the same; if it is it returns "wrong password", if its not the same, it syncs the new password from the MySQL to the local cache and returns "correct password" if the passwords match.

 

Ahhh, okay. Got it. Thanks.

He gave me his log, I'll show you when you get on Skype.

Have you used a dev build before? Delete the AuthDB.db under your plugins/AuthDB folder and try again.

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

Okay, Ill be home in about 30-40 minutes.

Could you try to delete the AuthDB.db file under plugins/AuthDB/ and try again?
Tell me if you get any bugs/errors.

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

#181 no longer produces errors. On the new Error necessarily tell. thanks