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

    Jan Tojnar

    There is one problem actually: You don't know player password. Everybody who has at least little sense saves passwords hashed (sha1 + salt preffered).
     
  3. Offline

    Wulfspider

    AuthDB just needs compare the hashed/salted password against what is in the database.
    A check that the first message is not their password would be good.
     
  4. Offline

    Jan Tojnar

     
  5. Offline

    Wulfspider

    @Jan, Any message to go with your quotes?
     
  6. Offline

    jeanpoivrot

    i dont have delay issue with any other bukkit plugins, or web application that use mysql.
    dedicaced server : local mysql 5.5, 2 core cpu so not overloaded... ram is OK, i din't know what appened, how i can try to solve that ?
     
  7. Offline

    alfskan

    Code:
    18:24:51 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unk
    nown column 'username_clean' in 'where clause'
    18:24:51 [SEVERE]      at sun.reflect.NativeConstructorAccessorImpl.newInstance
    0(Native Method)
    18:24:51 [SEVERE]      at sun.reflect.NativeConstructorAccessorImpl.newInstance
    (Unknown Source)
    18:24:51 [SEVERE]      at sun.reflect.DelegatingConstructorAccessorImpl.newInst
    ance(Unknown Source)
    18:24:51 [SEVERE]      at java.lang.reflect.Constructor.newInstance(Unknown Sou
    rce)
    18:24:51 [SEVERE]      at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    18:24:51 [SEVERE]      at com.mysql.jdbc.Util.getInstance(Util.java:382)
    18:24:51 [SEVERE]      at com.mysql.jdbc.SQLError.createSQLException(SQLError.j
    ava:1052)
    18:24:51 [SEVERE]      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:
    3593)
    18:24:51 [SEVERE]      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:
    3525)
    18:24:51 [SEVERE]      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    
    18:24:51 [SEVERE]      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:21
    40)
    18:24:51 [SEVERE]      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.
    java:2620)
    18:24:51 [SEVERE]      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.
    java:2570)
    18:24:51 [SEVERE]      at com.mysql.jdbc.StatementImpl.executeQuery(StatementIm
    pl.java:1474)
    18:24:51 [SEVERE]      at com.authdb.util.databases.MySQL.getfromtable(MySQL.ja
    va:92)
    18:24:51 [SEVERE]      at com.authdb.util.Util.CheckScript(Util.java:504)
    18:24:51 [SEVERE]      at com.authdb.AuthDB.isRegistered(AuthDB.java:259)
    18:24:51 [SEVERE]      at com.authdb.listeners.AuthDBPlayerListener.onPlayerJoi
    n(AuthDBPlayerListener.java:144)
    18:24:51 [SEVERE]      at org.bukkit.plugin.java.JavaPluginLoader$1.execute(Jav
    aPluginLoader.java:244)
    18:24:51 [SEVERE]      at org.bukkit.plugin.RegisteredListener.callEvent(Regist
    eredListener.java:58)
    18:24:51 [SEVERE]      at org.bukkit.plugin.SimplePluginManager.callEvent(Simpl
    ePluginManager.java:321)
    18:24:51 [SEVERE]      at net.minecraft.server.ServerConfigurationManager.c(Ser
    verConfigurationManager.java:124)
    18:24:51 [SEVERE]      at net.minecraft.server.NetLoginHandler.b(NetLoginHandle
    r.java:97)
    18:24:51 [SEVERE]      at net.minecraft.server.NetLoginHandler.a(NetLoginHandle
    r.java:74)
    18:24:51 [SEVERE]      at net.minecraft.server.Packet1Login.a(SourceFile:43)
    18:24:51 [SEVERE]      at net.minecraft.server.NetworkManager.b(NetworkManager.
    java:226)
    18:24:51 [SEVERE]      at net.minecraft.server.NetLoginHandler.a(NetLoginHandle
    r.java:40)
    18:24:51 [SEVERE]      at net.minecraft.server.NetworkListenThread.a(SourceFile
    :91)
    18:24:51 [SEVERE]      at net.minecraft.server.MinecraftServer.h(MinecraftServe
    r.java:451)
    18:24:51 [SEVERE]      at net.minecraft.server.MinecraftServer.run(MinecraftSer
    ver.java:361)
    18:24:51 [SEVERE]      at net.minecraft.server.ThreadServerApplication.run(Sour
    ceFile:422)
    18:24:51 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unk
    nown column 'username_clean' in 'where clause'
    18:24:51 [SEVERE]      at sun.reflect.NativeConstructorAccessorImpl.newInstance
    0(Native Method)
    18:24:51 [SEVERE]      at sun.reflect.NativeConstructorAccessorImpl.newInstance
    (Unknown Source)
    18:24:51 [SEVERE]      at sun.reflect.DelegatingConstructorAccessorImpl.newInst
    ance(Unknown Source)
    18:24:51 [SEVERE]      at java.lang.reflect.Constructor.newInstance(Unknown Sou
    rce)
    18:24:51 [SEVERE]      at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    18:24:51 [SEVERE]      at com.mysql.jdbc.Util.getInstance(Util.java:382)
    18:24:51 [SEVERE]      at com.mysql.jdbc.SQLError.createSQLException(SQLError.j
    ava:1052)
    18:24:51 [SEVERE]      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:
    3593)
    18:24:51 [SEVERE]      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:
    3525)
    18:24:51 [SEVERE]      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    
    18:24:51 [SEVERE]      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:21
    40)
    18:24:51 [SEVERE]      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.
    java:2620)
    18:24:51 [SEVERE]      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.
    java:2570)
    18:24:51 [SEVERE]      at com.mysql.jdbc.StatementImpl.executeQuery(StatementIm
    pl.java:1474)
    18:24:51 [SEVERE]      at com.authdb.util.databases.MySQL.getfromtable(MySQL.ja
    va:92)
    18:24:51 [SEVERE]      at com.authdb.util.Util.CheckScript(Util.java:504)
    18:24:51 [SEVERE]      at com.authdb.AuthDB.isRegistered(AuthDB.java:259)
    18:24:51 [SEVERE]      at com.authdb.listeners.AuthDBPlayerListener.onPlayerJoi
    n(AuthDBPlayerListener.java:144)
    18:24:51 [SEVERE]      at org.bukkit.plugin.java.JavaPluginLoader$1.execute(Jav
    aPluginLoader.java:244)
    18:24:51 [SEVERE]      at org.bukkit.plugin.RegisteredListener.callEvent(Regist
    eredListener.java:58)
    18:24:51 [SEVERE]      at org.bukkit.plugin.SimplePluginManager.callEvent(Simpl
    ePluginManager.java:321)
    18:24:51 [SEVERE]      at net.minecraft.server.ServerConfigurationManager.c(Ser
    verConfigurationManager.java:124)
    18:24:51 [SEVERE]      at net.minecraft.server.NetLoginHandler.b(NetLoginHandle
    r.java:97)
    18:24:51 [SEVERE]      at net.minecraft.server.NetLoginHandler.a(NetLoginHandle
    r.java:74)
    18:24:51 [SEVERE]      at net.minecraft.server.Packet1Login.a(SourceFile:43)
    18:24:51 [SEVERE]      at net.minecraft.server.NetworkManager.b(NetworkManager.
    java:226)
    18:24:51 [SEVERE]      at net.minecraft.server.NetLoginHandler.a(NetLoginHandle
    r.java:40)
    18:24:51 [SEVERE]      at net.minecraft.server.NetworkListenThread.a(SourceFile
    :91)
    18:24:51 [SEVERE]      at net.minecraft.server.MinecraftServer.h(MinecraftServe
    r.java:451)
    18:24:51 [SEVERE]      at net.minecraft.server.MinecraftServer.run(MinecraftSer
    ver.java:361)
    18:24:51 [SEVERE]      at net.minecraft.server.ThreadServerApplication.run(Sour
    ceFile:422)
    
    I got this error when I tried to register.

    I made mysql database, and linked it.

    And use your authdb_users.sql file.(you linked it fore comment)

    database, table, fields are all linked.

    I dont know how I solve this prob...
     
  8. Offline

    Wulfspider

    Strange for sure... possibly something with the latest builds of CraftBukkit or Minecraft. I'll be testing further.

    I've never used that site before. It's just one that I found. My guess is that if they offer phpMyAdmin access or something similar, then you could use the authdb_users.sql that I've linked before to create a basic customdb setup. It would be easiest for you to use either install a script using a database.
    We thought about adding a feature to send out customization emails to users asking them to verify their email address. This could potentially require a code or be integrated with forum/CMS functions. We'll work on adding additional options and such for customdb too. I've been trying to figure out the best way to redo it so to provide better options and customization.
    Sorry, I didn't notice that you had posted earlier... apparently I wasn't alerted to the past 6 or so posts. I'll look into it and see. It was working fine before, so I am not sure what the problem is other than possibly being something with the latest builds of CraftBukkit or Minecraft.
    Looks like you set a script in the settings and didn't enable customdb.

    customdb:
    enabled: true

    That is... if you are meaning to use a custom database and not a script.
     
    lemachinbidule likes this.
  9. Offline

    Jan Tojnar

    Nevermind.
    BTW what is progress with 2.3.0? I had some errors with it few days ago but i couldn't report it because people couldn't log in and i had to downgrade immediately. There are server errors on ci.craftfire.com so i can't download latest dev build to try it now.
     
  10. Offline

    alfskan

    aww

    I did it! It works xD thanks!

    But have one more little prob..

    the welcome message doesnt work...T.T

    I didnt configure anything about messages.yml...
     
  11. Offline

    Wulfspider

    I know what you were getting at, but AuthDB can check whatever it needs to with the passwords. We are basically doing the same thing the forum/CMS script is doing, just with Java.

    What errors were you having with the dev-SNAPSHOT? It's a dev-SNAPSHOT for a reason, as it's not finished and not intended to be bug free. ;) Once I get things setup completely, I'll start having recommended builds like what Bukkit does. The CI server is currently being moved to it's own machine, that's why it has been unavailable.

    What version are you using? The welcome message as in the login/register messages? What login method are you using, default or prompt? Does it not show at all?
     
  12. Offline

    alfskan

    I using authdb2.2.0, cb953, mc1.7.2, prompt, custom db.

    all of messages doesnt work.

    T.T

    ps. It tell me like this when I tried to register.

    Code:
    20:08:09 [WARNING] [AuthDB] WARNING!! COULD NOT FIND A COMPATIBLE SCRIPT VERSION
    , PLEASE CHECK YOUR SCRIPT VERSION AND TRY AGAIN. PLUGIN MAY OR MAY NOT WORK.
    
    aww..I cant wait !

    1. support PlayerEditor(uses BukkitContrib SP mod) properly. please please please..
    2. support automatically create mysql table and fields
    3. support configurable email section(everyone annoying this when they register... T.T)

    and will be a Great auth plugin!
    cheer up!

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Sep 9, 2018
  13. Offline

    Wulfspider

    I'm not sure why you don't see any messages at all because the plugin has default values inside it and looks first for configured messages in messages.yml. Are you using any client mods? Any other plugins?

    The warning message is just a bug when using customdb in v2.2.0. It is fixed in 2.3.0 dev builds.

    Do you happen to be using BukkitContrib SP mod? I tested with that and it somehow keeps AuthDB messages from showing. Still looking into it.

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

    Jan Tojnar

    I know what dev build is. I just want to help you with testing because there is bigger chance to find an error if plugin is tested by more people. I will report it ASAP.
     
  15. Offline

    Wulfspider

    Yeah, just didn't want you to expect them to always be working properly. ;)

    Also, I'm having a hard time pinpointing the cause of the MySQL delays. There doesn't seem to be any problem with when using MC 1.6.6 and CB 860 compared to newer MC 1.7.x versions and compatible CB builds. Any extra testing in this regard would be useful in determining what is causing the random MySQL delays. There also seems to be a lot of client lag in newer MC versions for me as well sometimes... chat, movement, etc.
     
  16. Offline

    alfskan

    nice plugin!

    but can you make another version?

    I mean, automatically create mysql table and fields. xD
     
  17. Offline

    Wulfspider

    The dev version does this, but there isn't a good version of it right now.
     
  18. Offline

    dawon

    Hi, I am using AuthDB since I started my first server. (It was my first installed plugin) and I had absolutely no problems with it. So firstly thank you for it! Good job!

    Well I have only one suggestion. Would it be possible to make it compatible with bukkitContrib client mod? Because, when I login (I am prompted for password) I can't see any changes bukkitContrib does (i.e. MyWolf plugin does not show Wolf's name above it...). But when I reconnect(AuthDB remembers my login) everything is ok.

    Thank you!

    Edit: I see, that alfskan was faster:D
     
  19. Offline

    Wulfspider

    There have been numerous requests to fix issues related to BukkitContrib. ;)
    We've done a few things in dev builds for v2.3.0, but haven't tested them completely yet.

    It's back up and running now by the way. Test way if you'd like. ;)

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

    dawon

    Really looking forward to 2.3!

    Thanks!;-)
     
  21. Offline

    Wulfspider

    Dev builds are always available; if you feel brave. ;)
    There has been a significant number of changes overall to the config files, organization, and cleanup of AuthDB from v2.2.0.

    Yeah, I'm still missing what you are saying...

    AuthDB v2.2.0 and before just stored all the files in plugins\AuthDB.

    AuthDB v2.3.0+ will be storing config.yml, commands.yml, and customdb.sql files in plugins\AuthDB\config,
    _inv files under plugins\AuthDB\messages, .db files under plugins\AuthDB\data, and message translations inplugins\AuthDB\messages such as English.yml and German.yml.

    and... @contex , he is running FreeBSD as he mentioned above in his post. ;)

    Edit: Contex explained it to me now... haha. I was completely missing the point... that's what I get for not sleeping!

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

    jeanpoivrot

    what u mean ? i run mc 953 - bukkitcontrib 0.1.2 (+ client mod (im using also Worldedit bukkit + client mod)) - playerEditor 0.9.1 - authdb 2.2.0. it work well, except about the login delay issue.

    edit; ok i din't see dawon post =)
     
  23. Offline

    dawon


    Well I've just tried it and found a bug. :D (I know it's dev version)

    It created folders named "AuthDB\config" etc.. instead of creating folder AuthDB and config in it...

    I am using freebsd, so it's might be the reason. Don't know...
     
  24. Offline

    Wulfspider

    That's one of the changes we've made. ;) The config files are still in the config folder right?
     
  25. Offline

    dawon

    I think you don't understand me... It created folder named "AuthDB\config" (so it's name of the folder, not path...)

    so in my case it created three folders in plugins folder named "AuthDB\config", "AuthDB\data" and "AuthDB\inventories" and not one named AuthDB and folders config, data and inventories in it...
     
  26. Offline

    contex

    Are you running Linux?
     
  27. Offline

    dawon

    Yup, FreeBSD. But I don't think it is such difference...

    I think problem is that Linux/Freebsd uses slashes and windows backslashes... (But not sure, my java knowledge is really poooor:D)
     
  28. Offline

    Wulfspider

    Yup, it should be fixed now, but we need to compile the build still.
     
  29. Offline

    dawon

    Thanks!

    I know, I am starting to be annoying, but there is still some problem...

    http://pastebin.com/bmD0KKH4

    It has already created correct files, but it behaves, that they aren't there. But It doesn't rewrite them. And it seems it is not reading them (I changed mySQL host to something else, but it still writes that can't connect to localhost...

    Strange...

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

    contex

    Could you please test the newest build (created 1 min ago). I did something wrong regarding the plugin name and such. Try again and please report back :)
     
  31. Offline

    dawon

    Yup, it seems, it is working fine now. Thank you very much!

    EDIT: But it doesn't create messages.yml file....:-(
     

Share This Page