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

    firefwing24

    So Lets try again...

    Core:
    plugin:
    debugmode: false
    usagestats: true
    database:
    driver: mysql
    host: localhost
    port: 3306
    username: root
    password: **************
    name: minecraft_forum(is this correct)
    prefix:
    script:
    name: phpBB
    version: 3.0.8
    customdb:
    enabled: true
    table: authdb_users
    userfield: username
    passfield: password
    emailfield: email
    encryption: md5

    Code:
    [WARNING] [AuthDB] MYSQL CANNOT CONNECT!!!
    2011-06-20 15:24:53 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'minecraft_forum'
    2011-06-20 15:24:53 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-06-20 15:24:53 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-06-20 15:24:53 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-06-20 15:24:53 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-06-20 15:24:53 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-06-20 15:24:53 [SEVERE]     at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2011-06-20 15:24:53 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2011-06-20 15:24:53 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-06-20 15:24:53 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-06-20 15:24:53 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:931)
    2011-06-20 15:24:53 [SEVERE]     at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4031)
    2011-06-20 15:24:53 [SEVERE]     at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1296)
    2011-06-20 15:24:53 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338)
    2011-06-20 15:24:53 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
    2011-06-20 15:24:53 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
    2011-06-20 15:24:53 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
    2011-06-20 15:24:53 [SEVERE]     at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    2011-06-20 15:24:53 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-06-20 15:24:53 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-06-20 15:24:53 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-06-20 15:24:53 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-06-20 15:24:53 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-06-20 15:24:53 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
    2011-06-20 15:24:53 [SEVERE]     at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
    2011-06-20 15:24:53 [SEVERE]     at java.sql.DriverManager.getConnection(Unknown Source)
    2011-06-20 15:24:53 [SEVERE]     at java.sql.DriverManager.getConnection(Unknown Source)
    2011-06-20 15:24:53 [SEVERE]     at com.authdb.util.databases.MySQL.connect(MySQL.java:70)
    2011-06-20 15:24:53 [SEVERE]     at com.authdb.AuthDB.onEnable(AuthDB.java:173)
    2011-06-20 15:24:53 [SEVERE]     at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:125)
    2011-06-20 15:24:53 [SEVERE]     at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:799)
    2011-06-20 15:24:53 [SEVERE]     at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:253)
    2011-06-20 15:24:53 [SEVERE]     at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:140)
    2011-06-20 15:24:53 [SEVERE]     at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:118)
    2011-06-20 15:24:54 [SEVERE]     at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:232)
    2011-06-20 15:24:54 [SEVERE]     at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:219)
    2011-06-20 15:24:54 [SEVERE]     at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:146)
    2011-06-20 15:24:54 [SEVERE]     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:283)
    2011-06-20 15:24:54 [SEVERE]     at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    2011-06-20 15:24:54 [INFO] [AuthDB] AuthDB plugin 2.2.0 is enabled
    2011-06-20 15:24:54 [INFO] [AuthDB] AuthDB is developed by CraftFire <dev@craftfire.com> 
    Oh i see... It can't find a Database named Minecraft_forum..
    But how can u fix that...
    Do you have to access the Database files themselves?
     
  3. Offline

    CraftFire

    So did you make a database on your MySQL server named minecraft_forum with a table called authdb_users with the fields username, password, and email?
     
  4. Offline

    firefwing24

    Ohhhh
    Sorry I dont have a database viewer.
    Ill try this out and then see if it works

    Edit: Can you help me with how to make a database?
    I'm having a bit of trouble.
     
  5. Offline

    CraftFire

  6. Offline

    firefwing24

    yeah I'm having a lot of trouble with this sadly
    First i dont have anything to read .sql files

    This sounds like a stupid question but
    How do you run sql commands?
    There's nothing in my mysql folder that can run cmdlines

    I'm getting it to work

    Ok CraftFire

    I'm using NaviCat to create my tables
    It wont let me create a blank table so I'm wondering
    Can you give me a screenshot how you would set it up?

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

    CraftFire

    Sounds like you need to learn how to use MySQL and it's tools before you go any further. There are plenty of tutorials available through YouTube and Google on how to setup, create, and manage MySQL. I believe there should be a command-line utility such as mysqladmin in your bin folder, if not then I am not sure what release you have. ;)
    http://dev.mysql.com/doc/refman/5.5/en/mysqladmin.html

    Google is your friend, use it.
    I've haven't used NaviCat in half a decade or more.
    http://support.navicat.com/visual_tutorial_mysql.php
    Plenty of tutorials available on the internet.
     
  8. Offline

    firefwing24

    Is it possible for you, in your upcoming updates, to automatically make the table?
    iConomy and Essentials seem to be able to do that

    The table's the only issue now.. To make it correctly.
    I'm off for now -.-'
     
  9. Offline

    CraftFire

    Yes, it is already planned to have that option available in an upcoming version for those using with customdb.
     
  10. Offline

    firefwing24

    For the table..

    The field section looks like this

    Name ________Type ________________Length __Decimals Allow Null
    So i know i put down
    username
    password
    email
    Under Names

    I dont know what to put for the rest of the table to make it savable

    If you'd like to answer go ahead, otherwise I'll be waiting for the version with the auto-table making version
     
  11. Offline

    CraftFire

    http://wiki.navicat.com/wiki/index.php/How_do_I_import_SQL_file_into_the_Server?

    As I've said, I haven't used NaviCat in quite some time so I am unsure as to how it functions.
    What is asking is what type of field to set each field to, the length, and it the field can be allowed to be blank/null or not.

    I think you will find it easier to just import the SQL file I linked you earlier by following the link to the tutorial above.

    I'm not sure what to tell you. It's either either the MySQL server blocking the connection or your VPS not allowing the connection. More than likely the MySQL server though. Double check your settings to make sure they are correct as well in terms of IP and port.

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

    firefwing24

    THANK YOU
    IT WORKED :D

    But It still says
    "WARNING!! COULD NOT FIND A COMPATIBLE SCRIPT VERSION, PLEASE CHECK YOUR SCRIPT VERSION AND TRY AGAIN. PLUGIN MAY OR MAY NOT WORK"

    But ill check to see if it actually works :p
     
  13. Offline

    CraftFire

    As noted in the Known Issues, that will be fixed in the next version. It doesn't affect anything at all. It's just a bug when using customdb. It's supposed to only be for use with scripts.
     
  14. Offline

    davedavy

    Yesterday in the morning ; Everything works fine!
    Tomorrow: Connection with database failed, i tryed 3 hosts , and no one works anymore?!

    Code:
    2011-06-21 18:42:45 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
    
    The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
    2011-06-21 18:42:45 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-06-21 18:42:45 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-06-21 18:42:45 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-06-21 18:42:45 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-06-21 18:42:45 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-06-21 18:42:45 [SEVERE]     at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
    2011-06-21 18:42:45 [SEVERE]     at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)
    2011-06-21 18:42:45 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334)
    2011-06-21 18:42:45 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
    2011-06-21 18:42:45 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
    2011-06-21 18:42:45 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
    2011-06-21 18:42:45 [SEVERE]     at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    2011-06-21 18:42:45 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-06-21 18:42:45 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-06-21 18:42:45 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-06-21 18:42:45 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-06-21 18:42:45 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-06-21 18:42:45 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
    2011-06-21 18:42:45 [SEVERE]     at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
    2011-06-21 18:42:45 [SEVERE]     at java.sql.DriverManager.getConnection(Unknown Source)
    2011-06-21 18:42:45 [SEVERE]     at java.sql.DriverManager.getConnection(Unknown Source)
    2011-06-21 18:42:45 [SEVERE]     at com.authdb.util.databases.MySQL.connect(MySQL.java:70)
    2011-06-21 18:42:45 [SEVERE]     at com.authdb.AuthDB.isRegistered(AuthDB.java:256)
    2011-06-21 18:42:45 [SEVERE]     at com.authdb.listeners.AuthDBPlayerListener.onPlayerJoin(AuthDBPlayerListener.java:144)
    2011-06-21 18:42:45 [SEVERE]     at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:243)
    2011-06-21 18:42:45 [SEVERE]     at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
    2011-06-21 18:42:45 [SEVERE]     at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:310)
    2011-06-21 18:42:45 [SEVERE]     at net.minecraft.server.ServerConfigurationManager.c(ServerConfigurationManager.java:126)
    2011-06-21 18:42:45 [SEVERE]     at net.minecraft.server.NetLoginHandler.b(NetLoginHandler.java:96)
    2011-06-21 18:42:45 [SEVERE]     at net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:74)
    2011-06-21 18:42:45 [SEVERE]     at net.minecraft.server.Packet1Login.a(SourceFile:43)
    2011-06-21 18:42:45 [SEVERE]     at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
    2011-06-21 18:42:45 [SEVERE]     at net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:40)
    2011-06-21 18:42:45 [SEVERE]     at net.minecraft.server.NetworkListenThread.a(SourceFile:91)
    2011-06-21 18:42:45 [SEVERE]     at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:399)
    2011-06-21 18:42:45 [SEVERE]     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:309)
    2011-06-21 18:42:45 [SEVERE]     at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    2011-06-21 18:42:45 [SEVERE] Caused by: java.net.ConnectException: Connection timed out: connect
    2011-06-21 18:42:45 [SEVERE]     at java.net.PlainSocketImpl.socketConnect(Native Method)
    2011-06-21 18:42:45 [SEVERE]     at java.net.PlainSocketImpl.doConnect(Unknown Source)
    2011-06-21 18:42:45 [SEVERE]     at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
    2011-06-21 18:42:45 [SEVERE]     at java.net.PlainSocketImpl.connect(Unknown Source)
    2011-06-21 18:42:45 [SEVERE]     at java.net.SocksSocketImpl.connect(Unknown Source)
    2011-06-21 18:42:45 [SEVERE]     at java.net.Socket.connect(Unknown Source)
    2011-06-21 18:42:45 [SEVERE]     at java.net.Socket.connect(Unknown Source)
    2011-06-21 18:42:45 [SEVERE]     at java.net.Socket.<init>(Unknown Source)
    2011-06-21 18:42:45 [SEVERE]     at java.net.Socket.<init>(Unknown Source)
    2011-06-21 18:42:45 [SEVERE]     at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:254)
    2011-06-21 18:42:45 [SEVERE]     at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)
    2011-06-21 18:42:45 [SEVERE]     ... 30 more
    2011-06-21 18:43:06 [WARNING] [AuthDB] MYSQL CANNOT CONNECT!!!
    2011-06-21 18:43:06 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
    
    The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
    2011-06-21 18:43:06 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-06-21 18:43:06 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-06-21 18:43:06 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-06-21 18:43:06 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-06-21 18:43:06 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-06-21 18:43:06 [SEVERE]     at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
    2011-06-21 18:43:06 [SEVERE]     at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)
    2011-06-21 18:43:06 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334)
    2011-06-21 18:43:06 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
    2011-06-21 18:43:06 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
    2011-06-21 18:43:06 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
    2011-06-21 18:43:06 [SEVERE]     at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    2011-06-21 18:43:06 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-06-21 18:43:06 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-06-21 18:43:06 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-06-21 18:43:06 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-06-21 18:43:06 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-06-21 18:43:06 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
    2011-06-21 18:43:06 [SEVERE]     at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
    2011-06-21 18:43:06 [SEVERE]     at java.sql.DriverManager.getConnection(Unknown Source)
    2011-06-21 18:43:06 [SEVERE]     at java.sql.DriverManager.getConnection(Unknown Source)
    2011-06-21 18:43:06 [SEVERE]     at com.authdb.util.databases.MySQL.connect(MySQL.java:70)
    2011-06-21 18:43:06 [SEVERE]     at com.authdb.AuthDB.isRegistered(AuthDB.java:256)
    2011-06-21 18:43:06 [SEVERE]     at com.authdb.listeners.AuthDBPlayerListener.onPlayerJoin(AuthDBPlayerListener.java:144)
    2011-06-21 18:43:06 [SEVERE]     at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:243)
    2011-06-21 18:43:06 [SEVERE]     at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
    2011-06-21 18:43:06 [SEVERE]     at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:310)
    2011-06-21 18:43:06 [SEVERE]     at net.minecraft.server.ServerConfigurationManager.c(ServerConfigurationManager.java:126)
    2011-06-21 18:43:06 [SEVERE]     at net.minecraft.server.NetLoginHandler.b(NetLoginHandler.java:96)
    2011-06-21 18:43:06 [SEVERE]     at net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:74)
    2011-06-21 18:43:06 [SEVERE]     at net.minecraft.server.Packet1Login.a(SourceFile:43)
    2011-06-21 18:43:06 [SEVERE]     at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
    2011-06-21 18:43:06 [SEVERE]     at net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:40)
    2011-06-21 18:43:06 [SEVERE]     at net.minecraft.server.NetworkListenThread.a(SourceFile:91)
    2011-06-21 18:43:06 [SEVERE]     at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:399)
    2011-06-21 18:43:06 [SEVERE]     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:309)
    2011-06-21 18:43:06 [SEVERE]     at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    2011-06-21 18:43:06 [SEVERE] Caused by: java.net.ConnectException: Connection timed out: connect
    2011-06-21 18:43:06 [SEVERE]     at java.net.PlainSocketImpl.socketConnect(Native Method)
    2011-06-21 18:43:06 [SEVERE]     at java.net.PlainSocketImpl.doConnect(Unknown Source)
    2011-06-21 18:43:06 [SEVERE]     at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
    2011-06-21 18:43:06 [SEVERE]     at java.net.PlainSocketImpl.connect(Unknown Source)
    2011-06-21 18:43:06 [SEVERE]     at java.net.SocksSocketImpl.connect(Unknown Source)
    2011-06-21 18:43:06 [SEVERE]     at java.net.Socket.connect(Unknown Source)
    2011-06-21 18:43:06 [SEVERE]     at java.net.Socket.connect(Unknown Source)
    2011-06-21 18:43:06 [SEVERE]     at java.net.Socket.<init>(Unknown Source)
    2011-06-21 18:43:06 [SEVERE]     at java.net.Socket.<init>(Unknown Source)
    2011-06-21 18:43:06 [SEVERE]     at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:254)
    2011-06-21 18:43:06 [SEVERE]     at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)
    2011-06-21 18:43:06 [SEVERE]     ... 30 more
     
  15. Offline

    CraftFire

    Sounds like remote access is not allowed on any of those hosts or your server IP hasn't been allowed to pass through. Are you hosting the CraftBukkit server on a connection with a dynamic IP?
     
  16. Offline

    davedavy

    The MC server is hosted op a VPS , and im sure it is a dynamic IP. I can login on the old ip, but whatismyip.com give me a other ip :S.

    The ip is changed :p Thanks!

    Edit 2:

    Ah man, i got the same error :(

    Code:
    2011-06-21 19:08:51 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
    
    The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
    2011-06-21 19:08:51 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-06-21 19:08:51 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-06-21 19:08:51 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-06-21 19:08:51 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-06-21 19:08:51 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-06-21 19:08:51 [SEVERE]     at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
    2011-06-21 19:08:51 [SEVERE]     at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)
    2011-06-21 19:08:51 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334)
    2011-06-21 19:08:51 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
    2011-06-21 19:08:51 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
    2011-06-21 19:08:51 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
    2011-06-21 19:08:51 [SEVERE]     at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    2011-06-21 19:08:51 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-06-21 19:08:51 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-06-21 19:08:51 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-06-21 19:08:51 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-06-21 19:08:51 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-06-21 19:08:51 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
    2011-06-21 19:08:51 [SEVERE]     at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
    2011-06-21 19:08:51 [SEVERE]     at java.sql.DriverManager.getConnection(Unknown Source)
    2011-06-21 19:08:51 [SEVERE]     at java.sql.DriverManager.getConnection(Unknown Source)
    2011-06-21 19:08:51 [SEVERE]     at com.authdb.util.databases.MySQL.connect(MySQL.java:70)
    2011-06-21 19:08:51 [SEVERE]     at com.authdb.AuthDB.onEnable(AuthDB.java:173)
    2011-06-21 19:08:51 [SEVERE]     at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:125)
    2011-06-21 19:08:51 [SEVERE]     at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:799)
    2011-06-21 19:08:51 [SEVERE]     at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:253)
    2011-06-21 19:08:51 [SEVERE]     at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:140)
    2011-06-21 19:08:51 [SEVERE]     at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:118)
    2011-06-21 19:08:51 [SEVERE]     at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:232)
    2011-06-21 19:08:51 [SEVERE]     at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:219)
    2011-06-21 19:08:51 [SEVERE]     at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:146)
    2011-06-21 19:08:51 [SEVERE]     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:283)
    2011-06-21 19:08:51 [SEVERE]     at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    2011-06-21 19:08:51 [SEVERE] Caused by: java.net.ConnectException: Connection timed out: connect
    2011-06-21 19:08:51 [SEVERE]     at java.net.PlainSocketImpl.socketConnect(Native Method)
    2011-06-21 19:08:51 [SEVERE]     at java.net.PlainSocketImpl.doConnect(Unknown Source)
    2011-06-21 19:08:51 [SEVERE]     at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
    2011-06-21 19:08:51 [SEVERE]     at java.net.PlainSocketImpl.connect(Unknown Source)
    2011-06-21 19:08:51 [SEVERE]     at java.net.SocksSocketImpl.connect(Unknown Source)
    2011-06-21 19:08:51 [SEVERE]     at java.net.Socket.connect(Unknown Source)
    2011-06-21 19:08:51 [SEVERE]     at java.net.Socket.connect(Unknown Source)
    2011-06-21 19:08:51 [SEVERE]     at java.net.Socket.<init>(Unknown Source)
    2011-06-21 19:08:51 [SEVERE]     at java.net.Socket.<init>(Unknown Source)
    2011-06-21 19:08:51 [SEVERE]     at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:254)
    2011-06-21 19:08:51 [SEVERE]     at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)
    2011-06-21 19:08:51 [SEVERE]     ... 26 more
     
  17. Offline

    panade

    hmmm i use it and i like it :-

    but wont it be usefull to try to avoid registration abuse?
    i for example use joomla and people can register there or ingame.
    to avoid abuse now i need to close registration on the website.

    but usualy a user that registers ingame should be a higher priotiy than one
    on website.
    so ingame u can register also if there is already a password.
    you would need to wipe out the database entry then i think or just sending an admin ticket.

    also a problem is, i dont find any function to put of this move protection if u dont enter a password.

    i know this is meant to offline mode servers but i would be happy to see this. because then its perfect and simple. :)

    btw the commands link for wiki ist not correct. there are no commands in the wiki
     
  18. Offline

    CraftFire

    I have no idea what you are talking about in the first half about abuse, priority, and wiping out database entries so you will need to make that a little clearer.

    Protection options against guests are under the guest section of the config. Set whatever you want to true to allow or false to not allow guests to do that action. There is no point to allow registered users to do anything unless they enter their password because that is the whole point of AuthDB; protecting registered users. If you a registered user was allowed to do things without entering a password, then what would the point be to even use AuthDB?

    AuthDB can be used with online and offline mode servers. We are working on adding a feature where it verifies users against Minecraft.net to allow them access without entering their password after they have linked their account once.

    I haven't migrated the commands over to the wiki yet. There isn't a lot of commands right now other than /register, /login, /link, and /unlink.
     
  19. Offline

    panade

    my post was no argue :)

    but lets explain my stuff with an example

    player A comes on server and use the normal register stuff ---> alright
    but sadly player A also loves to troll others and see that player B is asking how to build
    instead of showing player B who isnt able to read (obviously XD) he register his name on forums
    result = player B cant move if he reconnects

    the secound part with the settings was about that if a user joins he can move and this part of the config works
    but at the moment he is a registred user he has to login (also after every server restart and a amount of time what is wanted by the plugin)
    i just see a problem that if player A from the example does what a troll does then player B cant even move around

    on my server i want guests moving but not building

    this is what i was about abuse
    and the priority part was about:
    if a player is logged into minecraft (online mode) hes usualy the player who maybe wants to reg
    but the player who registers on forums is maybe or maybe not the player who atleast plays.
     
  20. Offline

    CraftFire

    So you are saying there is an issue with players not being able to login if they register on the forums instead of in-game? They should be able to do both and it shouldn't matter. Either way, they should be prompted to enter their password or login when they join the server after registering. Registered users can't move at all until they login. I can't help it if they can't read and I can't help it if someone else registers another players name before them on the forum or game. I can't see any way of preventing that easily.
     
  21. Offline

    panade

    i know that this is a more difficult part XD
    but maybe it would help to make an optional "u can moove but u still need to enter password" toggle
    or an escape or an /help admin message

    but thx for listening ur doing a good job anyways :)
     
  22. Offline

    CraftFire

    We are planning on adding a message that repeats a message when they try to do something they can't do until they register or login. :)
     
  23. Offline

    aykutmania

    Some news about WBB-compatility? ;-) neeeeed
     
  24. Offline

    davedavy

    My problem is solved.

    Is it also possible to disable the e-mail by the registration?
     
  25. Offline

    CraftFire

    Not for forums and other scripts. For customdb yes, but I think it's currently bugged until the next version.
     
  26. Offline

    davedavy

    Ok, i cant wait until the next version then ^^
     
  27. Offline

    nala3

    ok well I just switched to phpBB3 so i could use this and i jus started my server and it seems to be a bit laggy... I'm thinking its because of AuthDB because it wasn't laggy until I installed it. If you have an answer it would be apreciated.
    :)
     
  28. Offline

    CraftFire

    Lagging how? You may lag a little while it processes your user information after entering your password. It shouldn't lag after that as it only processes info at start and for each login.
     
  29. Offline

    nala3

    well i used world edits /debug clock feature. and when im not running AuthDB it gives me a good report. when i do run AuthDB though the clock either goes way to like 30 when its supposed to be 20 or down to like 16. I also looked and the CPU usage when nobody was on was like 30% with it on. 2%without it. but when i get on ( just one player ) the usage shoots up to about 50% and the clock can get even more unstable...

    ohh i guess i should also add that block breaking is laggy, doors, pretty much everything

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

    CraftFire

    Are you in the spawn protection area? What build of CraftBukkit are you using? Are you logged in as a registered user or a guest?

    Are you sure you are looking at the server and not the client? My server bounces around between 06 and 10% when sitting idle in the server by myself after logging in with AuthDB. I get the same results without AuthDB.

    My client usually runs around 40% when not in a game, and even higher when in a game.

    Also, WorldEdit does not have a debug clock feature... that would be CommandBook.
    My tests have also resulted in no change in tick rate when using /debug clock with and without AuthDB. So you must have something weird with your setup.

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

    nala3

    ohh right lol command book XD i forget things sometimes >.> anyway yes im sure it was not the client. seeing as i had it closed and the client proccess is javaw.exe :p and yeah I probably do have something weird with the setup >.> but It let me login with no problems at all so idk why its doing that. and no I'm not in spawn protection. and I just updated to 927(yes ik its not a recomended build) I think it was build 860 before so yeah...
     

Share This Page