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

    SweetCraft Girl

    Will XenForo be supported anytime soon?

    XenForo and vBulletin = uber popular.
     
  3. Offline

    contex

    I'm just looking for more boards to add, added those two to the todo list. Thanks!
     
  4. Offline

    Wulfspider

    Perfect! I was looking for something like this today, so perfect timing.
     
  5. Offline

    Jay1029

    This is beyond sweet!
    Nice job on this plugin!
    [​IMG]
     
  6. Offline

    Wulfspider

    @contex , the mysql-connector-java-bin.jar you included is outdated. It is version 5.1.6, the latest is 5.1.15.

    Error with latest recommended CraftBukkit 531 and both mysql-connector-java-bin.jar version 5.1.15 and 5.1.6 :
    Code:
    00:54:53 [SEVERE] java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
    00:54:53 [SEVERE]       at java.net.URLClassLoader$1.run(Unknown Source)
    00:54:53 [SEVERE]       at java.security.AccessController.doPrivileged(Native Me
    thod)
    00:54:53 [SEVERE]       at java.net.URLClassLoader.findClass(Unknown Source)
    00:54:53 [SEVERE]       at org.bukkit.plugin.java.PluginClassLoader.findClass(Pl
    uginClassLoader.java:30)
    00:54:53 [SEVERE]       at java.lang.ClassLoader.loadClass(Unknown Source)
    00:54:53 [SEVERE]       at java.lang.ClassLoader.loadClass(Unknown Source)
    00:54:53 [SEVERE]       at java.lang.Class.forName0(Native Method)
    00:54:53 [SEVERE]       at java.lang.Class.forName(Unknown Source)
    00:54:53 [SEVERE]       at com.contex.bukkit.forumauth.ForumAuthMySQL.connect(Fo
    rumAuthMySQL.java:19)
    00:54:53 [SEVERE]       at com.contex.bukkit.forumauth.ForumAuth.onEnable(ForumA
    uth.java:136)
    00:54:53 [SEVERE]       at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlug
    in.java:118)
    00:54:53 [SEVERE]       at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(
    JavaPluginLoader.java:451)
    00:54:53 [SEVERE]       at org.bukkit.plugin.SimplePluginManager.enablePlugin(Si
    mplePluginManager.java:217)
    00:54:53 [SEVERE]       at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftSe
    rver.java:83)
    00:54:53 [SEVERE]       at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftS
    erver.java:61)
    00:54:53 [SEVERE]       at net.minecraft.server.MinecraftServer.e(MinecraftServe
    r.java:204)
    00:54:53 [SEVERE]       at net.minecraft.server.MinecraftServer.a(MinecraftServe
    r.java:191)
    00:54:53 [SEVERE]       at net.minecraft.server.MinecraftServer.d(MinecraftServe
    r.java:131)
    00:54:53 [SEVERE]       at net.minecraft.server.MinecraftServer.run(MinecraftSer
    ver.java:246)
    00:54:53 [SEVERE]       at net.minecraft.server.ThreadServerApplication.run(Sour
    ceFile:366)
    00:54:53 [WARNING] [ForumAuth] ERRORS in the ClassNotFoundException. Plugin will
     NOT work. Disabling it.
    00:54:53 [WARNING] Plugin 'ForumAuth' (ver 2) is registering events before it is
     enabled. It may be misbehaving and the author needs to fix this.
    00:54:53 [WARNING] Plugin 'ForumAuth' (ver 2) is registering events before it is
     enabled. It may be misbehaving and the author needs to fix this.
    00:54:53 [WARNING] Plugin 'ForumAuth' (ver 2) is registering events before it is
     enabled. It may be misbehaving and the author needs to fix this.
    00:54:53 [WARNING] Plugin 'ForumAuth' (ver 2) is registering events before it is
     enabled. It may be misbehaving and the author needs to fix this.
    00:54:53 [WARNING] Plugin 'ForumAuth' (ver 2) is registering events before it is
     enabled. It may be misbehaving and the author needs to fix this.
    00:54:53 [WARNING] Plugin 'ForumAuth' (ver 2) is registering events before it is
     enabled. It may be misbehaving and the author needs to fix this.
    00:54:53 [WARNING] Plugin 'ForumAuth' (ver 2) is registering events before it is
     enabled. It may be misbehaving and the author needs to fix this.
    00:54:53 [WARNING] Plugin 'ForumAuth' (ver 2) is registering events before it is
     enabled. It may be misbehaving and the author needs to fix this.
    00:54:53 [WARNING] Plugin 'ForumAuth' (ver 2) is registering events before it is
     enabled. It may be misbehaving and the author needs to fix this.
    00:54:53 [INFO] [ForumAuth] ForumAuth plugin build 1 is enabled
    mysql-connector-java-bin.jar is in the root bukkit folder with craftbukkit.jar.

    Another error on joining:
    Code:
    01:45:05 [SEVERE] Could not pass event PLAYER_JOIN to ForumAuth
    java.lang.NullPointerException
            at com.contex.bukkit.forumauth.ForumAuthMySQL.getfromtable(ForumAuthMySQ
    L.java:39)
            at com.contex.bukkit.forumauth.ForumAuthSMF1.checkuser(ForumAuthSMF1.jav
    a:77)
            at com.contex.bukkit.forumauth.ForumAuth.isRegistered(ForumAuth.java:193
    )
            at com.contex.bukkit.forumauth.ForumAuthPlayerListener.onPlayerJoin(Foru
    mAuthPlayerListener.java:29)
            at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.ja
    va:162)
            at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.jav
    a:59)
            at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.j
    ava:255)
            at net.minecraft.server.ServerConfigurationManager.a(ServerConfiguration
    Manager.java:98)
            at net.minecraft.server.NetLoginHandler.b(NetLoginHandler.java:87)
            at net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:68)
            at net.minecraft.server.Packet1Login.a(SourceFile:46)
            at net.minecraft.server.NetworkManager.a(SourceFile:230)
            at net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:34)
            at net.minecraft.server.NetworkListenThread.a(SourceFile:87)
            at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:357)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:272)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:366)
    01:45:06 [INFO] Freed 16.168373107910156 MB.
    >
     
  7. Offline

    contex

    Strange, thanks for reporting, I'll check right away :)
    Could you test out the 1.2 please, thanks!
     
  8. Offline

    Spazmic

    Is it possible to whitelist the users by if they are registered on the forums too? I would prefer that user register on forums before having access to the server... (Whitelist by Silence is an exemple of what I mean)
     
  9. Offline

    contex

    It does not matter if the user registers on the forum or the server, they all use the same encryption if you have provided the correct settings. Is that what you mean?
     
  10. Offline

    shadrxninga

    MyBB Support Please?
     
  11. Offline

    contex

    I just finished it, only got a problem with the main page as the MyBB forum saves the stats in a plaintext cache. Check back later today and it should be added :)
     
  12. Offline

    shadrxninga

    Thanks! I will do that.
     
  13. Offline

    Wulfspider

    @contex , new errors with 1.2. Going to double check that I can access my forum database externally too. I also have a pile of conflicts and other plugins breaking before I removed them all to test standalone.

    Edit: I can connect to my database through various methods outside of the server, so I know that is not the issue. :)

    Code:
    04:24:32 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionExc
    eption: Cannot load connection class because of underlying exception: 'java.lang
    .NumberFormatException: For input string: "3306xxxxxxxxxxxx"'.
    04:24:32 [SEVERE]       at sun.reflect.NativeConstructorAccessorImpl.newInstance
    0(Native Method)
    04:24:32 [SEVERE]       at sun.reflect.NativeConstructorAccessorImpl.newInstance
    (Unknown Source)
    04:24:32 [SEVERE]       at sun.reflect.DelegatingConstructorAccessorImpl.newInst
    ance(Unknown Source)
    04:24:32 [SEVERE]       at java.lang.reflect.Constructor.newInstance(Unknown Sou
    rce)
    04:24:32 [SEVERE]       at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    04:24:32 [SEVERE]       at com.mysql.jdbc.Util.getInstance(Util.java:382)
    04:24:32 [SEVERE]       at com.mysql.jdbc.SQLError.createSQLException(SQLError.j
    ava:1013)
    04:24:32 [SEVERE]       at com.mysql.jdbc.SQLError.createSQLException(SQLError.j
    ava:987)
    04:24:32 [SEVERE]       at com.mysql.jdbc.SQLError.createSQLException(SQLError.j
    ava:982)
    04:24:32 [SEVERE]       at com.mysql.jdbc.SQLError.createSQLException(SQLError.j
    ava:927)
    04:24:32 [SEVERE]       at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegist
    eringDriver.java:314)
    04:24:32 [SEVERE]       at java.sql.DriverManager.getConnection(Unknown Source)
    04:24:32 [SEVERE]       at java.sql.DriverManager.getConnection(Unknown Source)
    04:24:32 [SEVERE]       at com.contex.bukkit.forumauth.ForumAuthMySQL.connect(Fo
    rumAuthMySQL.java:20)
    04:24:32 [SEVERE]       at com.contex.bukkit.forumauth.ForumAuth.onEnable(ForumA
    uth.java:146)
    04:24:32 [SEVERE]       at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlug
    in.java:118)
    04:24:32 [SEVERE]       at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(
    JavaPluginLoader.java:451)
    04:24:32 [SEVERE]       at org.bukkit.plugin.SimplePluginManager.enablePlugin(Si
    mplePluginManager.java:217)
    04:24:32 [SEVERE]       at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftSe
    rver.java:83)
    04:24:32 [SEVERE]       at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftS
    erver.java:61)
    04:24:32 [SEVERE]       at net.minecraft.server.MinecraftServer.e(MinecraftServe
    r.java:204)
    04:24:32 [SEVERE]       at net.minecraft.server.MinecraftServer.a(MinecraftServe
    r.java:191)
    04:24:32 [SEVERE]       at net.minecraft.server.MinecraftServer.d(MinecraftServe
    r.java:131)
    04:24:32 [SEVERE]       at net.minecraft.server.MinecraftServer.run(MinecraftSer
    ver.java:246)
    04:24:32 [SEVERE]       at net.minecraft.server.ThreadServerApplication.run(Sour
    ceFile:366)
    04:24:32 [SEVERE] Caused by: java.lang.NumberFormatException: For input string:
    "3306xxxxxxxxxxxx"
    04:24:32 [SEVERE]       at java.lang.NumberFormatException.forInputString(Unknow
    n Source)
    04:24:32 [SEVERE]       at java.lang.Integer.parseInt(Unknown Source)
    04:24:32 [SEVERE]       at java.lang.Integer.parseInt(Unknown Source)
    04:24:32 [SEVERE]       at com.mysql.jdbc.NonRegisteringDriver.port(NonRegisteri
    ngDriver.java:831)
    04:24:32 [SEVERE]       at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegist
    eringDriver.java:305)
    04:24:32 [SEVERE]       ... 14 more
    04:24:32 [WARNING] [ForumAuth] ERRORS in the SQLException. Plugin will NOT work.
     Disabling it.
    04:24:32 [WARNING] Plugin 'ForumAuth' (ver 3) is registering events before it is
     enabled. It may be misbehaving and the author needs to fix this.
    04:24:32 [WARNING] Plugin 'ForumAuth' (ver 3) is registering events before it is
     enabled. It may be misbehaving and the author needs to fix this.
    04:24:32 [WARNING] Plugin 'ForumAuth' (ver 3) is registering events before it is
     enabled. It may be misbehaving and the author needs to fix this.
    04:24:32 [WARNING] Plugin 'ForumAuth' (ver 3) is registering events before it is
     enabled. It may be misbehaving and the author needs to fix this.
    04:24:32 [WARNING] Plugin 'ForumAuth' (ver 3) is registering events before it is
     enabled. It may be misbehaving and the author needs to fix this.
    04:24:32 [WARNING] Plugin 'ForumAuth' (ver 3) is registering events before it is
     enabled. It may be misbehaving and the author needs to fix this.
    04:24:32 [WARNING] Plugin 'ForumAuth' (ver 3) is registering events before it is
     enabled. It may be misbehaving and the author needs to fix this.
    04:24:32 [WARNING] Plugin 'ForumAuth' (ver 3) is registering events before it is
     enabled. It may be misbehaving and the author needs to fix this.
    04:24:32 [WARNING] Plugin 'ForumAuth' (ver 3) is registering events before it is
     enabled. It may be misbehaving and the author needs to fix this.
    04:24:32 [INFO] [ForumAuth] ForumAuth plugin build 3 is enabled
     
  14. Offline

    contex

    I think I know what I did wrong, are you using a prefix?
     
  15. Offline

    Wulfspider

    Yes, I am using smf_ as the prefix.
    Code:
    settings:
    allow-register: true
    force-register: true
    kick-on-bad-password: true
    post-topic: false
    forum-board: SMF1
    database:
    driver: com.mysql.jdbc.Driver
    username: myforumuser
    password: mypassword
    port: "3306"
    host: 23.62.632.62
    database: myforumuser
    prefix: smf_
    Also, how about an option for kicking a user after a certain amount of idle time without logging in?[/FONT][/COLOR]
    kick-on-idle: true
    kick-on-idle-time: 300 (seconds)

    Also, what is the point in having quotations around the port?
     
  16. Offline

    contex

    Going to try to recreate the problem, thanks for reporting :)
    Oh yeah, added that idea.
    --
    Edit: Found out what was wrong, I wasn't using the connector at all, instead I assumed that MySQL was already installed on the server. Working on fix for the next release :)
    Edit 2: Yeah it had nothing to do with localhost or MySQL installed from before, I think I figured out what's wrong, check the next release in about 30 minutes.
     
  17. Offline

    Wulfspider

    @contex , I wanted to show you all the other errors I get when I run your plugin with the rest of my plugins... unfortunately it's too long to post here, so here it is: http://pastebin.com/S1i2sE2J . I'm wondering if the "java.sql.SQLException: invalid database address" part in the very beginning is the whole cause of all my problems.
     
  18. Offline

    contex

    Releasing the fix in about 10 minutes :)
     
  19. Offline

    Wulfspider

    Your download link doesn't work... looks like you forgot to upload it ;)
     
  20. Offline

    contex

    Jesus, WinSCP was waiting for a "click". Thanks for telling!
     
  21. Offline

    Wulfspider

    By the way, how about having your plugin automatically download mysql-connector-java-bin.jar only if not available in the root Bukkit dir or not the latest version? I've seen others that download needed libs and such when they were not there.
     
  22. Offline

    contex

    Not a dumb idea acctualy, added to the list (-:
     
  23. Offline

    Wulfspider

    Also, any way of not displaying passwords in plain text in the server console/logs?
     
  24. Offline

    contex

    Yes. Going to add it to the next version.
     
  25. Offline

    Wulfspider

    Awesome, thanks!

    Another idea... how having the option to enable/disable registration on the forums when registration is disabled on the plugin too?

    For SMF1:
    Admin > Members > Registration > Settings > Change method of registration to Registration Disabled.

    Does the plugin have any checks for invalid characters too such as $^@(#)$!+? I noticed the iBlock plugin and thought about that... players using names with unacceptable characters for the forum's registration.

    Any way of showing the user as "Playing Minecraft" on the "Who" or "Who's Online" or whatever else it may be called when they are logged into the game server?

    Also... it's working smoothly now! Thanks for the fix. :)
    [MERGETIME="1300120995"][/MERGETIME]
    Oooo, bad bug to report... after I used @ in a username to test... I can no longer use /login... just kicks me for incorrect password and shows this error in console:
    Code:
    12:41:11 [INFO] login myhiddenpassword
    12:41:11 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionExc
    eption: No operations allowed after connection closed.
    12:41:11 [SEVERE]       at sun.reflect.NativeConstructorAccessorImpl.newInstance
    0(Native Method)
    12:41:11 [SEVERE]       at sun.reflect.NativeConstructorAccessorImpl.newInstance
    (Unknown Source)
    12:41:11 [SEVERE]       at sun.reflect.DelegatingConstructorAccessorImpl.newInst
    ance(Unknown Source)
    12:41:11 [SEVERE]       at java.lang.reflect.Constructor.newInstance(Unknown Sou
    rce)
    12:41:11 [SEVERE]       at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    12:41:11 [SEVERE]       at com.mysql.jdbc.Util.getInstance(Util.java:382)
    12:41:11 [SEVERE]       at com.mysql.jdbc.SQLError.createSQLException(SQLError.j
    ava:1013)
    12:41:11 [SEVERE]       at com.mysql.jdbc.SQLError.createSQLException(SQLError.j
    ava:987)
    12:41:11 [SEVERE]       at com.mysql.jdbc.SQLError.createSQLException(SQLError.j
    ava:982)
    12:41:11 [SEVERE]       at com.mysql.jdbc.SQLError.createSQLException(SQLError.j
    ava:927)
    12:41:11 [SEVERE]       at com.mysql.jdbc.ConnectionImpl.throwConnectionClosedEx
    ception(ConnectionImpl.java:1213)
    12:41:11 [SEVERE]       at com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionI
    mpl.java:1200)
    12:41:11 [SEVERE]       at com.mysql.jdbc.ConnectionImpl.createStatement(Connect
    ionImpl.java:2485)
    12:41:11 [SEVERE]       at com.mysql.jdbc.ConnectionImpl.createStatement(Connect
    ionImpl.java:2467)
    12:41:11 [SEVERE]       at com.contex.bukkit.forumauth.ForumAuthMySQL.getfromtab
    le(ForumAuthMySQL.java:42)
    12:41:11 [SEVERE]       at com.contex.bukkit.forumauth.boards.SMF1.checkpassword
    (SMF1.java:66)
    12:41:11 [SEVERE]       at com.contex.bukkit.forumauth.ForumAuth.checkPassword(F
    orumAuth.java:178)
    12:41:11 [SEVERE]       at com.contex.bukkit.forumauth.listeners.ForumAuthPlayer
    Listener.onPlayerCommandPreprocess(ForumAuthPlayerListener.java:73)
    12:41:11 [SEVERE]       at org.bukkit.plugin.java.JavaPluginLoader$5.execute(Jav
    aPluginLoader.java:182)
    12:41:11 [SEVERE]       at org.bukkit.plugin.RegisteredListener.callEvent(Regist
    eredListener.java:59)
    12:41:11 [SEVERE]       at org.bukkit.plugin.SimplePluginManager.callEvent(Simpl
    ePluginManager.java:255)
    12:41:11 [SEVERE]       at net.minecraft.server.NetServerHandler.c(NetServerHand
    ler.java:637)
    12:41:11 [SEVERE]       at net.minecraft.server.NetServerHandler.chat(NetServerH
    andler.java:608)
    12:41:11 [SEVERE]       at net.minecraft.server.NetServerHandler.a(NetServerHand
    ler.java:602)
    12:41:11 [SEVERE]       at net.minecraft.server.Packet3Chat.a(SourceFile:24)
    12:41:11 [SEVERE]       at net.minecraft.server.NetworkManager.a(SourceFile:230)
    
    12:41:11 [SEVERE]       at net.minecraft.server.NetServerHandler.a(NetServerHand
    ler.java:76)
    12:41:11 [SEVERE]       at net.minecraft.server.NetworkListenThread.a(SourceFile
    :100)
    12:41:11 [SEVERE]       at net.minecraft.server.MinecraftServer.h(MinecraftServe
    r.java:357)
    12:41:11 [SEVERE]       at net.minecraft.server.MinecraftServer.run(MinecraftSer
    ver.java:272)
    12:41:11 [SEVERE]       at net.minecraft.server.ThreadServerApplication.run(Sour
    ceFile:366)
    12:41:11 [WARNING] [ForumAuth] ERRORS in checking password. Plugin will NOT work
    . Disabling it.
    12:41:13 [INFO] Freed 34.61756896972656 MB.
    >
    and here is the error I received when I used the @ in a username:
    Code:
    @Wulf has logged in for the first time.
    2011-03-14 12:33:37 [INFO] @Wulf [/10.0.1.1:49972] logged in with entity id 21594
    2011-03-14 12:33:37 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
    
    The last packet successfully received from the server was 758,470 milliseconds ago.  The last packet sent successfully to the server was 20 milliseconds ago.
    2011-03-14 12:33:37 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-03-14 12:33:37 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-03-14 12:33:37 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-03-14 12:33:37 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-03-14 12:33:37 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-03-14 12:33:37 [SEVERE]     at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
    2011-03-14 12:33:37 [SEVERE]     at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3092)
    2011-03-14 12:33:37 [SEVERE]     at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2978)
    2011-03-14 12:33:37 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3526)
    2011-03-14 12:33:37 [SEVERE]     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989)
    2011-03-14 12:33:37 [SEVERE]     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150)
    2011-03-14 12:33:37 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    2011-03-14 12:33:37 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    2011-03-14 12:33:37 [SEVERE]     at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1476)
    2011-03-14 12:33:37 [SEVERE]     at com.contex.bukkit.forumauth.ForumAuthMySQL.getfromtable(ForumAuthMySQL.java:43)
    2011-03-14 12:33:37 [SEVERE]     at com.contex.bukkit.forumauth.boards.SMF1.checkuser(SMF1.java:73)
    2011-03-14 12:33:37 [SEVERE]     at com.contex.bukkit.forumauth.ForumAuth.isRegistered(ForumAuth.java:211)
    2011-03-14 12:33:37 [SEVERE]     at com.contex.bukkit.forumauth.listeners.ForumAuthPlayerListener.onPlayerJoin(ForumAuthPlayerListener.java:32)
    2011-03-14 12:33:37 [SEVERE]     at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:162)
    2011-03-14 12:33:37 [SEVERE]     at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:59)
    2011-03-14 12:33:37 [SEVERE]     at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:255)
    2011-03-14 12:33:37 [SEVERE]     at net.minecraft.server.ServerConfigurationManager.a(ServerConfigurationManager.java:98)
    2011-03-14 12:33:37 [SEVERE]     at net.minecraft.server.NetLoginHandler.b(NetLoginHandler.java:87)
    2011-03-14 12:33:37 [SEVERE]     at net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:68)
    2011-03-14 12:33:37 [SEVERE]     at net.minecraft.server.Packet1Login.a(SourceFile:46)
    2011-03-14 12:33:37 [SEVERE]     at net.minecraft.server.NetworkManager.a(SourceFile:230)
    2011-03-14 12:33:37 [SEVERE]     at net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:34)
    2011-03-14 12:33:37 [SEVERE]     at net.minecraft.server.NetworkListenThread.a(SourceFile:87)
    2011-03-14 12:33:37 [SEVERE]     at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:357)
    2011-03-14 12:33:37 [SEVERE]     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:272)
    2011-03-14 12:33:37 [SEVERE]     at net.minecraft.server.ThreadServerApplication.run(SourceFile:366)
    2011-03-14 12:33:37 [SEVERE] Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
    2011-03-14 12:33:37 [SEVERE]     at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2539)
    2011-03-14 12:33:37 [SEVERE]     at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2989)
    2011-03-14 12:33:37 [SEVERE]     ... 24 more
    2011-03-14 12:33:37 [WARNING] [ForumAuth] ERRORS in checking user. Plugin will NOT work. Disabling it.
    I assume this would happen for other bad characters as well, hence the iBlock filter idea.
     
  26. Offline

    contex

    • Registration disabled/enabled sounds like a good idea, I will look into it!
    • And yes, I could change signature/forum title, to that they are Online and playing. What do you think? Or I could create a custom mod for each boards which you just have to install and it could add a new section under "Users online" called "Users playing Minecraft"?
    • Hm, about the special characters, need to recreate the problem and see how I can fix it.

      I just got to say that I appricate you helping me test the different bugs :)! Add me on skype if you have: contexmoh.
     
  27. Offline

    Wulfspider

    I think just updating their status would be easiest instead of creating a mod for each.

    Example of what I am saying is below. It wouldn't really need to have the IP address of the server... I just put that in there for kicks. It could just say Playing Minecraft, but if you are using the forum database for multiple Minecraft servers, then it would be useful. Displaying IP and port would be best probably.
    2hrpr1t.png
     
  28. Offline

    contex

    That should be no problem at all, infact, I'll do it right now :)
     
  29. Offline

    Wulfspider

    Still unusable for me now due to that whole @ error :(
    Code:
    13:01:51 [INFO] Wulfspider [/10.0.1.1:50663] logged in with entity id 162
    13:01:51 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Commu
    nications link failure
    
    The last packet successfully received from the server was 1,073,460 milliseconds
     ago.  The last packet sent successfully to the server was 6 milliseconds ago.
    13:01:51 [SEVERE]       at sun.reflect.NativeConstructorAccessorImpl.newInstance
    0(Native Method)
    13:01:51 [SEVERE]       at sun.reflect.NativeConstructorAccessorImpl.newInstance
    (Unknown Source)
    13:01:51 [SEVERE]       at sun.reflect.DelegatingConstructorAccessorImpl.newInst
    ance(Unknown Source)
    13:01:51 [SEVERE]       at java.lang.reflect.Constructor.newInstance(Unknown Sou
    rce)
    13:01:51 [SEVERE]       at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    13:01:51 [SEVERE]       at com.mysql.jdbc.SQLError.createCommunicationsException
    (SQLError.java:1116)
    13:01:51 [SEVERE]       at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.jav
    a:3092)
    13:01:51 [SEVERE]       at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.jav
    a:2978)
    13:01:51 [SEVERE]       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:
    3526)
    13:01:51 [SEVERE]       at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989)
    
    13:01:51 [SEVERE]       at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:21
    50)
    13:01:51 [SEVERE]       at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.
    java:2620)
    13:01:51 [SEVERE]       at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.
    java:2570)
    13:01:51 [SEVERE]       at com.mysql.jdbc.StatementImpl.executeQuery(StatementIm
    pl.java:1476)
    13:01:51 [SEVERE]       at com.contex.bukkit.forumauth.ForumAuthMySQL.getfromtab
    le(ForumAuthMySQL.java:43)
    13:01:51 [SEVERE]       at com.contex.bukkit.forumauth.boards.SMF1.checkuser(SMF
    1.java:73)
    13:01:51 [SEVERE]       at com.contex.bukkit.forumauth.ForumAuth.isRegistered(Fo
    rumAuth.java:211)
    13:01:51 [SEVERE]       at com.contex.bukkit.forumauth.listeners.ForumAuthPlayer
    Listener.onPlayerJoin(ForumAuthPlayerListener.java:32)
    13:01:51 [SEVERE]       at org.bukkit.plugin.java.JavaPluginLoader$1.execute(Jav
    aPluginLoader.java:162)
    13:01:51 [SEVERE]       at org.bukkit.plugin.RegisteredListener.callEvent(Regist
    eredListener.java:59)
    13:01:51 [SEVERE]       at org.bukkit.plugin.SimplePluginManager.callEvent(Simpl
    ePluginManager.java:255)
    13:01:51 [SEVERE]       at net.minecraft.server.ServerConfigurationManager.a(Ser
    verConfigurationManager.java:98)
    13:01:51 [SEVERE]       at net.minecraft.server.NetLoginHandler.b(NetLoginHandle
    r.java:87)
    13:01:51 [SEVERE]       at net.minecraft.server.NetLoginHandler.a(NetLoginHandle
    r.java:68)
    13:01:51 [SEVERE]       at net.minecraft.server.Packet1Login.a(SourceFile:46)
    13:01:51 [SEVERE]       at net.minecraft.server.NetworkManager.a(SourceFile:230)
    
    13:01:51 [SEVERE]       at net.minecraft.server.NetLoginHandler.a(NetLoginHandle
    r.java:34)
    13:01:51 [SEVERE]       at net.minecraft.server.NetworkListenThread.a(SourceFile
    :87)
    13:01:51 [SEVERE]       at net.minecraft.server.MinecraftServer.h(MinecraftServe
    r.java:357)
    13:01:51 [SEVERE]       at net.minecraft.server.MinecraftServer.run(MinecraftSer
    ver.java:272)
    13:01:51 [SEVERE]       at net.minecraft.server.ThreadServerApplication.run(Sour
    ceFile:366)
    13:01:51 [SEVERE] Caused by: java.io.EOFException: Can not read response from se
    rver. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly
    lost.
    13:01:51 [SEVERE]       at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2539)
    13:01:51 [SEVERE]       at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.jav
    a:2989)
    13:01:51 [SEVERE]       ... 24 more
    13:01:51 [WARNING] [ForumAuth] ERRORS in checking user. Plugin will NOT work. Di
    sabling it.
    If the plugin isn't working, you should also have it not show "Please register with /register <password> <email>" when you login. I verified I can still connect externally, so that is not the issue.

    Edit: This issue seems to go away with a server restart... so the invalid characters such as @ just break the plugin till server is restarted.
     
  30. Offline

    Spazmic

    Yes you answered my question. I will try your plugin today, it has A LOT of potential.
     

Share This Page