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. Lets hope so! :p
    Thanks ;)

    Oh btw, i believe the reproducing part is even more simple than i've explained.
    By leaving the game/server while being in mid-air (in creative), you can already fly around with freeze enabled after rejoining the server.

    There ya go, the simplified explanation =)
     
  3. Sometimes when players log in they have had their inventory cleared. It's strange since it only seems to affect 5% of the players (they on the other hand are experiencing this 2-5 times).

    AuthDB also seems to shut down from time to time. I have to restart the server to make it run again but it doesn't say anything in the console. If I let the server run and noone even plays it can shutdown without any error messages (or any messages at all, you have to play to see that the login is disabled).

    I have no idea why any of these to things happens now. I've used it for a month withaout any problems and now it started acting like this. No special chenges to the server or anything. I had the problem with cleared inventories a couple of month ago to and that time it started like this. No problems for a month and then it just, well..

    Anyway. Just wanted to see if you have any idea why this could happen. And how it shuts down without any messages.
     
  4. Offline

    Wulfspider

    Inventory issues are usually caused by conflicting plugins that mess with the inventory.

    How does it shutdown? Likely it loses connection to your MySQL server is my guess.
     
  5. I don't know how it shuts down since it actually doesn't say that it has/did shut down. It just isn't "on" anymore. That is the strange part. It works flawless for a day and then it's just like if I never had it installed. It just doesn't exist.
     
  6. Offline

    Wulfspider

    Your whole server shuts down or just AuthDB? It has to say what is going on, it just doesn't randomly shutdown. You could try enabling the debug mode for more info.
     
  7. Only AuthDB. And nothing shows. Not a single error. But gonna run extra debug. It's strange.
     
  8. Offline

    vanmc

    I got this wierd letters for somereason after i updated to 1.2.5 R2.0
    [​IMG]
     
  9. Offline

    JohnPulse

    Same here, I guess it's a result to a change on the Bukkit's Wordwrap feature.

    Regards,
    John
     
  10. Offline

    OklaMokla

    Does anyone have a script or idea how I can get authDB work with wordpress (or buddypress or bbpress)? :)
     
  11. Yes. :)
    Just gimmie a minute to figure it out ;)

    So...
    If you just read through AuthDB bukkitdev site you'll see what different forum and CMS-scripts it supports.
    Show Spoiler

    Scripts Supported

    Versions of scripts listed below are only what we have tested with. You are free to use versions beyond what we specify, but you do so at your own risk as there may be changes between versions.
    CMS

    Forum

    If you open the basic config you'll see something like this:
    Code:
    script:
     
    name: WordPress                                      # Name of the script you are using.
     
        version: 3.2.1                                  # Version of the script you are using.
     
        tableprefix: phpbb_                              # Database table prefix for the script, if you use
    one.
    Just change phpbb after "name:" to the correct cms/forum and then vrite the correct version you want to use.

    For example. If you're using Wordpress 3.2.1 you'd write:
    Code:
        name: WordPress                                      # Name of the script you are using.
     
        version: 3.2.1                                  # Version of the script you are using.
     
        tableprefix: phpbb_                              # Database table prefix for the script, if you use 
    If you use a newer version of WordPress you'd still write version 3.2.1 since that is the newest version supported by AuthDB according to the site.

    Table prefix can be named anything and is just what every part in the database is starting with, so change it to the same as you chose for your cms/forum.

    Simple? :)
     
  12. Offline

    OklaMokla

    Thanks for help. I still keep getting the
    9:05:27 [INFO] [AuthDB] messages language set to English
    09:05:27 [INFO] [AuthDB] commands language set to English
    09:05:27 [WARNING] [AuthDB] Cannot connect to MySQL server on localhost!
    09:05:27 [WARNING] [AuthDB] Access denied, check if the password/username is correct and that remote connection is enabled if the MySQL database is located on another host then your server.
    09:05:27 [INFO] [AuthDB] 2.3.6.242 is enabled
    09:05:27 [INFO] [AuthDB] developed by CraftFire <[email protected]>
     
  13. Offline

    vanmc

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

    There is currently and glitch also players during the process of logging in they can hit people close to them.
     
  14. 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)
     
  15. Offline

    Serios

    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.
     
  16. 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?
     
  17. Offline

    Serios

    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...
     
  18. Offline

    baliks

    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?
     
  19. Offline

    Wulfspider

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

    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.

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

    spiritx

    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:
    Log (open)

    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.
     
  21. Offline

    spiritx

    Any ideas?
     
  22. Same problem here, but with keepalive: true, authdb chrashes and nobody need to login.
     
  23. Offline

    baliks

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

    spiritx

    I have the same thing after an hour. Plagin crash, no need to login. I posted from above log when keepalive: true/
     
  25. 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

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

    kikostaki

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

    dscm

    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

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

    Wulfspider

    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.

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

    dscm

    How about enabling commands for Registered users?
     
  30. Offline

    Wulfspider

    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.
     
  31. Offline

    Regulus123

    It looks like this plugin lags a lot:
    [​IMG]

    What do I have to do?
     

Share This Page