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

    nbeerbower

    Maybe you're not understanding what I'm trying to say... It would cut down on spam, so someone who doesn't login cant keep joining and leaving and having their messages spam up the server.
     
  3. Offline

    Cactuz

    Best auth plugin for CraftBukkit! Thanks !! I will donate soon.
     
  4. Offline

    contex


    We will add that option to a future version :)

    Anyway, all bugs for 2.2.0 should now be fixed, we're currently working on 3 addons: Ban, Groups and Messaging.



    Why, thank you :) That just makes us want to work even more with this plugin!
     
  5. Offline

    Jonathan Bloom

    WOOT! I can't wait for 2.2.0!
     
  6. Offline

    contex

    Just to list what the new features in 2.2.0 are:

    *NEW FEATURES*
    • Add addon: Messaging
    • Add addon: Groups
    • Add addon: Ban
    • Automatically generate config.yml and messages.yml if they don't exist instead of defaults in jar
    • Add new way to check for messages and config.yml
    • Rewrite supported script code so each script is self-contained in it's own class
    • Change to allow versions outside of supported script versionrange, but show warning in console
    • Add setting/option for max characters allowed for username
    • Add blocking empty/blank usernames
    • Make login password prompt customizable
    • Add support for Invision Power Board / IP Board / IPB 3.1.4
    • Add support for Drupal 7.0
    • Add session start options for at time of login of logoff
    • Make local database and /link username password command to link 2 different usernames together
    • Change /login username password to /link username password and automaticly link the player and forum user
    • Add check for invalid characters in passwords when players register
    • Add option to set amount of wrong password tries before kick/ban
    *FIXED BUGS*
    • Users can't login if they use a different character case other than what they registered with
    • Players who register on forum site can't login until server restart and sometimes not at all because shown as guest
    • Players may not be able to login when they use capital or symbols letters in their passwords
    • Make "Time difference: 1, caneling damage" message show only with debugmode: true and change "caneling" to canceling"
     
  7. Offline

    Jonathan Bloom

    WOW! Looks incredible! 2.2.0 will be an awesome update.
     
  8. Offline

    evilserge

    im think that 2,2,0 will be released at new bukkit stable build (for v1.5 minecraft)
     
  9. Offline

    Wulfspider

    Hopefully or soon after depending on if anything changed. :)
    It will not have the addons and Drupal 7 support as we had hoped though as those will take a little more time and wanted to get fixes out for current issues.
     
  10. Offline

    Rietas

    Can I use it without forum/CMS script with only Database?
     
  11. Offline

    Wulfspider

    Yes, just set enable: true under customdb: to use with your own database you have setup. Currently it doesn't make the database tables and fields for you. If you want something simple, then here is a basic schema for you: http://google.com/search?q=referral+links#/1zRXyen. The field settings under customdb: need to match whatever you have in your database. The defaults should match the SQL file I linked.
     
  12. Offline

    [Kor]Deer

    server error....
    unregister Player's moveing! Error
    Code:
    2011-04-24 13:59:16 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'username' in 'where clause'
    2011-04-24 13:59:16 [SEVERE]     at sun.reflect.GeneratedConstructorAccessor26.newInstance(Unknown Source)
    2011-04-24 13:59:16 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-04-24 13:59:16 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-04-24 13:59:16 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-04-24 13:59:16 [SEVERE]     at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011-04-24 13:59:16 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011-04-24 13:59:16 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-04-24 13:59:16 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-04-24 13:59:16 [SEVERE]     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-04-24 13:59:16 [SEVERE]     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-04-24 13:59:16 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    2011-04-24 13:59:16 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    2011-04-24 13:59:16 [SEVERE]     at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1474)
    2011-04-24 13:59:16 [SEVERE]     at com.authdb.util.databases.MySQL.getfromtable(MySQL.java:93)
    2011-04-24 13:59:16 [SEVERE]     at com.authdb.util.Util.CheckScript(Util.java:68)
    2011-04-24 13:59:16 [SEVERE]     at com.authdb.AuthDB.isRegistered(AuthDB.java:251)
    2011-04-24 13:59:16 [SEVERE]     at com.authdb.listeners.AuthDBEntityListener.onEntityDamage(AuthDBEntityListener.java:104)
    2011-04-24 13:59:16 [SEVERE]     at org.bukkit.plugin.java.JavaPluginLoader$42.execute(JavaPluginLoader.java:458)
    2011-04-24 13:59:16 [SEVERE]     at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:59)
    2011-04-24 13:59:16 [SEVERE]     at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:257)
    2011-04-24 13:59:16 [SEVERE]     at net.minecraft.server.EntityLiving.L(EntityLiving.java:130)
    2011-04-24 13:59:16 [SEVERE]     at net.minecraft.server.Entity.f_(Entity.java:181)
    2011-04-24 13:59:16 [SEVERE]     at net.minecraft.server.EntityLiving.f_(EntityLiving.java:230)
    2011-04-24 13:59:16 [SEVERE]     at net.minecraft.server.EntityHuman.f_(EntityHuman.java:91)
    2011-04-24 13:59:16 [SEVERE]     at net.minecraft.server.EntityPlayer.a(EntityPlayer.java:156)
    2011-04-24 13:59:16 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:292)
    2011-04-24 13:59:16 [SEVERE]     at net.minecraft.server.Packet10Flying.a(SourceFile:126)
    2011-04-24 13:59:16 [SEVERE]     at net.minecraft.server.NetworkManager.a(NetworkManager.java:198)
    2011-04-24 13:59:16 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:72)
    2011-04-24 13:59:16 [SEVERE]     at net.minecraft.server.NetworkListenThread.a(SourceFile:100)
    2011-04-24 13:59:16 [SEVERE]     at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:368)
    2011-04-24 13:59:16 [SEVERE]     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:283)
    2011-04-24 13:59:16 [SEVERE]     at net.minecraft.server.ThreadServerApplication.run(SourceFile:375)
    2011-04-24 13:59:16 [WARNING] [AuthDB] ERRORS in checking user. Plugin will NOT work. Disabling it.
    2011-04-24 13:59:16 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'username' in 'where clause'
    2011-04-24 13:59:16 [SEVERE]     at sun.reflect.GeneratedConstructorAccessor26.newInstance(Unknown Source)
    2011-04-24 13:59:16 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-04-24 13:59:16 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-04-24 13:59:16 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-04-24 13:59:16 [SEVERE]     at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011-04-24 13:59:16 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011-04-24 13:59:16 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-04-24 13:59:16 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-04-24 13:59:16 [SEVERE]     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-04-24 13:59:16 [SEVERE]     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-04-24 13:59:16 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    2011-04-24 13:59:16 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    2011-04-24 13:59:16 [SEVERE]     at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1474)
    2011-04-24 13:59:16 [SEVERE]     at com.authdb.util.databases.MySQL.getfromtable(MySQL.java:93)
    2011-04-24 13:59:16 [SEVERE]     at com.authdb.util.Util.CheckScript(Util.java:68)
    2011-04-24 13:59:16 [SEVERE]     at com.authdb.AuthDB.isRegistered(AuthDB.java:251)
    2011-04-24 13:59:16 [SEVERE]     at com.authdb.listeners.AuthDBEntityListener.onEntityDamage(AuthDBEntityListener.java:104)
    2011-04-24 13:59:16 [SEVERE]     at org.bukkit.plugin.java.JavaPluginLoader$42.execute(JavaPluginLoader.java:458)
    2011-04-24 13:59:16 [SEVERE]     at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:59)
    2011-04-24 13:59:16 [SEVERE]     at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:257)
    2011-04-24 13:59:16 [SEVERE]     at net.minecraft.server.EntityLiving.L(EntityLiving.java:130)
    2011-04-24 13:59:16 [SEVERE]     at net.minecraft.server.Entity.f_(Entity.java:181)
    2011-04-24 13:59:16 [SEVERE]     at net.minecraft.server.EntityLiving.f_(EntityLiving.java:230)
    2011-04-24 13:59:16 [SEVERE]     at net.minecraft.server.EntityHuman.f_(EntityHuman.java:91)
    2011-04-24 13:59:16 [SEVERE]     at net.minecraft.server.EntityPlayer.a(EntityPlayer.java:156)
    2011-04-24 13:59:16 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:292)
    2011-04-24 13:59:16 [SEVERE]     at net.minecraft.server.Packet10Flying.a(SourceFile:126)
    2011-04-24 13:59:16 [SEVERE]     at net.minecraft.server.NetworkManager.a(NetworkManager.java:198)
    2011-04-24 13:59:16 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:72)
    2011-04-24 13:59:16 [SEVERE]     at net.minecraft.server.NetworkListenThread.a(SourceFile:100)
    2011-04-24 13:59:16 [SEVERE]     at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:368)
    2011-04-24 13:59:16 [SEVERE]     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:283)
    2011-04-24 13:59:16 [SEVERE]     at net.minecraft.server.ThreadServerApplication.run(SourceFile:375)
    2011-04-24 13:59:16 [WARNING] [AuthDB] ERRORS in checking user. Plugin will NOT work. Disabling it.
    2011-04-24 13:59:16 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'username' in 'where clause'
    2011-04-24 13:59:16 [SEVERE]     at sun.reflect.GeneratedConstructorAccessor26.newInstance(Unknown Source)
    2011-04-24 13:59:16 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-04-24 13:59:16 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-04-24 13:59:16 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-04-24 13:59:16 [SEVERE]     at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011-04-24 13:59:16 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011-04-24 13:59:16 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-04-24 13:59:16 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-04-24 13:59:16 [SEVERE]     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-04-24 13:59:16 [SEVERE]     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-04-24 13:59:16 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    2011-04-24 13:59:16 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    2011-04-24 13:59:16 [SEVERE]     at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1474)
    2011-04-24 13:59:16 [SEVERE]     at com.authdb.util.databases.MySQL.getfromtable(MySQL.java:93)
    2011-04-24 13:59:16 [SEVERE]     at com.authdb.util.Util.CheckScript(Util.java:68)
    2011-04-24 13:59:16 [SEVERE]     at com.authdb.AuthDB.isRegistered(AuthDB.java:251)
    2011-04-24 13:59:16 [SEVERE]     at com.authdb.listeners.AuthDBEntityListener.onEntityDamage(AuthDBEntityListener.java:104)
    2011-04-24 13:59:16 [SEVERE]     at org.bukkit.plugin.java.JavaPluginLoader$42.execute(JavaPluginLoader.java:458)
    2011-04-24 13:59:16 [SEVERE]     at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:59)
    2011-04-24 13:59:16 [SEVERE]     at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:257)
    2011-04-24 13:59:16 [SEVERE]     at net.minecraft.server.EntityLiving.L(EntityLiving.java:130)
    2011-04-24 13:59:16 [SEVERE]     at net.minecraft.server.Entity.f_(Entity.java:181)
    2011-04-24 13:59:16 [SEVERE]     at net.minecraft.server.EntityLiving.f_(EntityLiving.java:230)
    2011-04-24 13:59:16 [SEVERE]     at net.minecraft.server.EntityHuman.f_(EntityHuman.java:91)
    2011-04-24 13:59:16 [SEVERE]     at net.minecraft.server.EntityPlayer.a(EntityPlayer.java:156)
    2011-04-24 13:59:16 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:292)
    2011-04-24 13:59:16 [SEVERE]     at net.minecraft.server.Packet10Flying.a(SourceFile:126)
    2011-04-24 13:59:16 [SEVERE]     at net.minecraft.server.NetworkManager.a(NetworkManager.java:198)
    2011-04-24 13:59:16 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:72)
    2011-04-24 13:59:17 [SEVERE]     at net.minecraft.server.NetworkListenThread.a(SourceFile:100)
    2011-04-24 13:59:17 [SEVERE]     at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:368)
    2011-04-24 13:59:17 [SEVERE]     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:283)
    2011-04-24 13:59:17 [SEVERE]     at net.minecraft.server.ThreadServerApplication.run(SourceFile:375)
    2011-04-24 13:59:17 [WARNING] [AuthDB] ERRORS in checking user. Plugin will NOT work. Disabling it.
    2011-04-24 13:59:17 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'username' in 'where clause'
    2011-04-24 13:59:17 [SEVERE]     at sun.reflect.GeneratedConstructorAccessor26.newInstance(Unknown Source)
    2011-04-24 13:59:17 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-04-24 13:59:17 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-04-24 13:59:17 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-04-24 13:59:17 [SEVERE]     at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011-04-24 13:59:17 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011-04-24 13:59:17 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-04-24 13:59:17 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-04-24 13:59:17 [SEVERE]     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-04-24 13:59:17 [SEVERE]     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-04-24 13:59:17 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    2011-04-24 13:59:17 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    2011-04-24 13:59:17 [SEVERE]     at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1474)
    2011-04-24 13:59:17 [SEVERE]     at com.authdb.util.databases.MySQL.getfromtable(MySQL.java:93)
    2011-04-24 13:59:17 [SEVERE]     at com.authdb.util.Util.CheckScript(Util.java:68)
    2011-04-24 13:59:17 [SEVERE]     at com.authdb.AuthDB.isRegistered(AuthDB.java:251)
    2011-04-24 13:59:17 [SEVERE]     at com.authdb.listeners.AuthDBEntityListener.onEntityDamage(AuthDBEntityListener.java:104)
    2011-04-24 13:59:17 [SEVERE]     at org.bukkit.plugin.java.JavaPluginLoader$42.execute(JavaPluginLoader.java:458)
    2011-04-24 13:59:17 [SEVERE]     at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:59)
    2011-04-24 13:59:17 [SEVERE]     at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:257)
    2011-04-24 13:59:17 [SEVERE]     at net.minecraft.server.EntityLiving.L(EntityLiving.java:130)
    2011-04-24 13:59:17 [SEVERE]     at net.minecraft.server.Entity.f_(Entity.java:181)
    2011-04-24 13:59:17 [SEVERE]     at net.minecraft.server.EntityLiving.f_(EntityLiving.java:230)
    2011-04-24 13:59:17 [SEVERE]     at net.minecraft.server.EntityHuman.f_(EntityHuman.java:91)
    2011-04-24 13:59:17 [SEVERE]     at net.minecraft.server.EntityPlayer.a(EntityPlayer.java:156)
    2011-04-24 13:59:17 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:292)
    2011-04-24 13:59:17 [SEVERE]     at net.minecraft.server.Packet10Flying.a(SourceFile:126)
    2011-04-24 13:59:17 [SEVERE]     at net.minecraft.server.NetworkManager.a(NetworkManager.java:198)
    2011-04-24 13:59:17 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:72)
    2011-04-24 13:59:17 [SEVERE]     at net.minecraft.server.NetworkListenThread.a(SourceFile:100)
    2011-04-24 13:59:17 [SEVERE]     at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:368)
    2011-04-24 13:59:17 [SEVERE]     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:283)
    2011-04-24 13:59:17 [SEVERE]     at net.minecraft.server.ThreadServerApplication.run(SourceFile:375)
    2011-04-24 13:59:17 [WARNING] [AuthDB] ERRORS in checking user. Plugin will NOT work. Disabling it.
    2011-04-24 13:59:17 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'username' in 'where clause'
    2011-04-24 13:59:17 [SEVERE]     at sun.reflect.GeneratedConstructorAccessor26.newInstance(Unknown Source)
    2011-04-24 13:59:17 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-04-24 13:59:17 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-04-24 13:59:17 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-04-24 13:59:17 [SEVERE]     at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011-04-24 13:59:17 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011-04-24 13:59:17 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-04-24 13:59:17 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-04-24 13:59:17 [SEVERE]     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-04-24 13:59:17 [SEVERE]     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-04-24 13:59:17 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    2011-04-24 13:59:17 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    2011-04-24 13:59:17 [SEVERE]     at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1474)
    2011-04-24 13:59:17 [SEVERE]     at com.authdb.util.databases.MySQL.getfromtable(MySQL.java:93)
    2011-04-24 13:59:17 [SEVERE]     at com.authdb.util.Util.CheckScript(Util.java:68)
    2011-04-24 13:59:17 [SEVERE]     at com.authdb.AuthDB.isRegistered(AuthDB.java:251)
    2011-04-24 13:59:17 [SEVERE]     at com.authdb.listeners.AuthDBEntityListener.onEntityDamage(AuthDBEntityListener.java:104)
    2011-04-24 13:59:17 [SEVERE]     at org.bukkit.plugin.java.JavaPluginLoader$42.execute(JavaPluginLoader.java:458)
    2011-04-24 13:59:17 [SEVERE]     at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:59)
    2011-04-24 13:59:17 [SEVERE]     at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:257)
    2011-04-24 13:59:17 [SEVERE]     at net.minecraft.server.EntityLiving.L(EntityLiving.java:130)
    2011-04-24 13:59:17 [SEVERE]     at net.minecraft.server.Entity.f_(Entity.java:181)
    2011-04-24 13:59:17 [SEVERE]     at net.minecraft.server.EntityLiving.f_(EntityLiving.java:230)
    2011-04-24 13:59:17 [SEVERE]     at net.minecraft.server.EntityHuman.f_(EntityHuman.java:91)
    2011-04-24 13:59:17 [SEVERE]     at net.minecraft.server.EntityPlayer.a(EntityPlayer.java:156)
    2011-04-24 13:59:17 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:292)
    2011-04-24 13:59:17 [SEVERE]     at net.minecraft.server.Packet10Flying.a(SourceFile:126)
    2011-04-24 13:59:17 [SEVERE]     at net.minecraft.server.NetworkManager.a(NetworkManager.java:198)
    2011-04-24 13:59:17 [SEVERE]     at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:72)
    2011-04-24 13:59:17 [SEVERE]     at net.minecraft.server.NetworkListenThread.a(SourceFile:100)
    2011-04-24 13:59:17 [SEVERE]     at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:368)
    2011-04-24 13:59:17 [SEVERE]     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:283)
    2011-04-24 13:59:17 [SEVERE]     at net.minecraft.server.ThreadServerApplication.run(SourceFile:375)
    2011-04-24 13:59:17 [WARNING] [AuthDB] ERRORS in checking user. Plugin will NOT work. Disabling it.
    and config
    Code:
    Core:
      plugin:
        debugmode: false
        usagestats: true
      database:
        driver: mysql
        host: localhost
        port: 3306
        username: root
        password: root
        name:
        prefix: phpbb_
      script:
        name: phpBB
        version: 3.0.8
      customdb:
        enabled: true
        table: users
        userfield: username
        passfield: password
        emailfield: email
        encryption: md5
      register:
        enabled: true
        force: true
      login:
        method: prompt
      password:
        kick: true
      session:
        time: minutes
        length: 30
      idle:
        time: seconds
        length: 30
        kick: true
        whitelist: Contex,Wulfspider
      guest:
        commands: false
        chat: false
        building: false
        destruction: false
        movement: false
        interactions: false
        inventory: false
        drop: false
        pickup: false
        health: false
        pvp: false
        mobtargeting: false
        mobdamage: false
      badcharacters:
        kick: true
        characters: "`~!@#$%^&*()-=+{[]}|\\:;\"<,>.?/ "
        whitelist: Contex,Wulfspider
    
    Plugins:
      CraftIRC:
        enabled: false
        tag: admin
        prefix: "%b%%green%[{PLUGIN}]%k%%b%"
    Install :
    Server start -> Error Server Down -> Database And Table (way auto not setting?) Manually setting -> Server restart
    -> Error

    Good!!! thank!!

    .......
    register info not save....T_T

    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

    Are you using a custom database table or a script such as phpBB? If you are using customdb, make sure your database is actually created as AuthDB does not do it for you and make sure you have the right table names under customdb. The error you are getting is because it can't find the username field that is in the config.
     
  14. Offline

    [Kor]Deer

    Nono....
    Database : minecraft_forum
    table : users
    setting! T_T
    ----- web server -----
    • Apache
    • MySQL client version: 5.0.51a
    • PHP extension: mysql
     
  15. Offline

    Wulfspider

    You haven't set your database info:

    database:
    driver: mysql
    host: localhost (set this to your MySQL database hostname or IP)
    port: 3306
    username: root (set this to your MySQL database username)
    password: root (set this to your MySQL database password)
    name: minecraft_forum
    prefix: (this needs to be blank if you are not using a prefix for your table name)
     
  16. Offline

    [Kor]Deer

    NONO setting!
    ------------------- web server ----------
    connect ID : root
    passowrd : root
    port : 3306
     
  17. Offline

    Wulfspider

    Are you saying that is what your username and password is? Bad idea if it is. You need to change from the default username and password (which are both root in the config.yml by default).

    As I said with the messages before too, it can't find your username field, so double check that your database matches your config.yml.
     
  18. Offline

    Wulfspider

    Because you don't have your database setup right.
     
  19. Offline

    contex

  20. Offline

    l104693

    Thanks! 2.2.0 works great! :D
     
  21. Offline

    contex

    Glad to hear that :)
     
  22. Offline

    l104693

    I found a small bug!
    I'm not using a script, I'm using a custom database, but AuthDB is nagging about the script version :S
    The server is giving me this error:
    Code:
    18:24:08 [WARNING] [AuthDB] WARNING!! COULD NOT FIND A COMPATIBLE SCRIPT VERSION
    , PLEASE CHECK YOUR SCRIPT VERSION AND TRY AGAIN. PLUGIN MAY OR MAY NOT WORK.
    18:24:08 [INFO] [AuthDB] AuthDB plugin 2.2.0 is enabled
    18:24:08 [INFO] [AuthDB] AuthDB is developed by CraftFire <[email protected]>
    My config:
    Code:
    database:
        driver: mysql
        host: localhost
        port: 3306
        username: root
        password: ***
        name: minecraft
        prefix:
      script:
        name: phpBB
        version: 3.0.8
      customdb:
        enabled: true
        table: authdb
        userfield: username
        passfield: password
        emailfield: email
        encryption: md5
     
  23. Offline

    contex

    Thanks for reporting :)
    Fixed for 2.2.1, just waiting a day for any bug reports, if none, I'll release the new version ASAP!
     
  24. Offline

    ChickenFighter

    I have a small problem with this beautiful Plugin :(
    Pls, help me :(

    Bukkit version: 720

    config:
    Code:
    database:
        driver: mysql
        host: localhost
        port: 3306
        username: minecraft
        password: ***
        name: minecraft
        prefix: 
    Error code:

    Code:
    [ERROR] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'minecraft.users' doesn't exist
    2011-04-25 13:51:02 [ERROR]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-04-25 13:51:02 [ERROR]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-04-25 13:51:02 [ERROR]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-04-25 13:51:02 [ERROR]     at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-04-25 13:51:02 [ERROR]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-04-25 13:51:02 [ERROR]     at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011-04-25 13:51:02 [ERROR]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011-04-25 13:51:02 [ERROR]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-04-25 13:51:02 [ERROR]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-04-25 13:51:02 [ERROR]     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2011-04-25 13:51:02 [ERROR]     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2011-04-25 13:51:02 [ERROR]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
    2011-04-25 13:51:02 [ERROR]     at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
    2011-04-25 13:51:02 [ERROR]     at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2273)
    2011-04-25 13:51:02 [ERROR]     at com.authdb.util.Util.CheckScript(Util.java:516)
    2011-04-25 13:51:02 [ERROR]     at com.authdb.AuthDB.onEnable(AuthDB.java:175)
    2011-04-25 13:51:02 [ERROR]     at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
    2011-04-25 13:51:02 [ERROR]     at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:584)
    2011-04-25 13:51:02 [ERROR]    aTorg.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:218)
    2011-04-25 13:51:02 [ERROR]     at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:116)
    2011-04-25 13:51:02 [ERROR]     at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:94)
    2011-04-25 13:51:02 [ERROR]     at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:217)
    2011-04-25 13:51:02 [ERROR]     at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:204)
    2011-04-25 13:51:02 [ERROR]     at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:144)
    2011-04-25 13:51:02 [ERROR]     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:259)
    2011-04-25 13:51:02 [ERROR]     at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
     
  25. Offline

    contex

    You might be using a custom script, are you sure you've setup the config correctly? Please pastebin/pastie your config or just post it here so we can help you find the problem :)
     
  26. Offline

    ChickenFighter

    Here:
    Code:
    Core:
      plugin:
        debugmode: true
        usagestats: true
      database:
        driver: mysql
        host: localhost
        port: 3306
        username: minecraft
        password: ***
        name: minecraft
        prefix:
      script:
        name: phpBB
        version: 3.0.8
      customdb:
        enabled: false
        table: authdb_users
        userfield: username
        passfield: password
        emailfield: email
        encryption: md5
      register:
        enabled: true
        force: true
      login:
        method: prompt
        tries: 3
        kick: true
      link:
        enabled: true
      unlink:
        enabled: true
      username:
        minimum: 3
        maximum: 20
      password:
        minimum: 6
        maximum: 20
      session:
        start: login
        time: minutes
        length: 30
      idle:
        time: seconds
        length: 30
        kick: true
        whitelist: Contex,Wulfspider
      guest:
        commands: false
        chat: false
        building: false
        destruction: false
        movement: false
        interactions: false
        inventory: false
        drop: false
        pickup: false
        health: false
        pvp: false
        mobtargeting: false
        mobdamage: false
      badcharacters:
        kick: true
        username: "`~!@#$%^&*()-=+{[]}|\\:;\"<,>.?/ "
        password: "&"
        whitelist: Contex,Wulfspider
    
    Plugins:
      CraftIRC:
        enabled: false
        tag: admin
        prefix: "%b%%green%[{PLUGIN}]%k%%b%"
     
  27. Offline

    Wulfspider

    Are you using your own custom database table or are you using a forum script such as phpBB?
    If you are using a custom database table, then you need to set enabled: true under customdb: and then make the table, userfield, passfield, and emailfield match what is in your database.

    customdb:
    enabled: true
    table: authdb_users
    userfield: username
    passfield: password
    emailfield: email
    encryption: md5

    Basically, AuthDB can't find your user table.
     
    ChickenFighter likes this.
  28. Offline

    ChickenFighter

    Thanks :) Working now. Love this Plugin *-*
     
  29. Offline

    digga

    hi,
    I have a question. I am using permission for the plugin permissions and usergroups. And now i want to use authdb to force ppl to registrate on my forum to get buildrights. But can authdb change the users group?
     
  30. Offline

    Wulfspider

    Not yet, but that feature is in the works along with group whitelists, titles, etc.

    Edit: You can force people to register before they can do any of the options under guest:. But you can't change what permissions/forum group they are in yet.
     
  31. Offline

    digga

    so i can change the default group to builder and give them in the permission file the right to build, but when they havent registered at the forum they can build anything right?
     

Share This Page