Solved [URGENT] MySQL error

Discussion in 'Plugin Development' started by macboinc, Jul 10, 2014.

Thread Status:
Not open for further replies.
  1. Offline

    macboinc

    Hey guys!
    I ran my plugin and I got this error, and I know nothing is wrong with the code. I know it has to do with drivers.
    Code:
    [20:29:44] [Server thread/WARN]: 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.
    [20:29:44] [Server thread/WARN]:    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    [20:29:44] [Server thread/WARN]:    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    [20:29:44] [Server thread/WARN]:    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    [20:29:44] [Server thread/WARN]:    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    [20:29:44] [Server thread/WARN]:    at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    [20:29:44] [Server thread/WARN]:    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
    [20:29:44] [Server thread/WARN]:    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)
    [20:29:44] [Server thread/WARN]:    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334)
    [20:29:44] [Server thread/WARN]:    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
    [20:29:44] [Server thread/WARN]:    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
    [20:29:44] [Server thread/WARN]:    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
    [20:29:44] [Server thread/WARN]:    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    [20:29:44] [Server thread/WARN]:    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    [20:29:44] [Server thread/WARN]:    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    [20:29:44] [Server thread/WARN]:    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    [20:29:44] [Server thread/WARN]:    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    [20:29:44] [Server thread/WARN]:    at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    [20:29:44] [Server thread/WARN]:    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
    [20:29:44] [Server thread/WARN]:    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
    [20:29:44] [Server thread/WARN]:    at java.sql.DriverManager.getConnection(Unknown Source)
    [20:29:44] [Server thread/WARN]:    at java.sql.DriverManager.getConnection(Unknown Source)
    [20:29:44] [Server thread/WARN]:    at me.macboinc1.punishment.MySQL.<init>(MySQL.java:17)
    [20:29:44] [Server thread/WARN]:    at me.macboinc1.punishment.Punishment.onEnable(Punishment.java:19)
    [20:29:44] [Server thread/WARN]:    at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:316)
    [20:29:44] [Server thread/WARN]:    at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:324)
    [20:29:44] [Server thread/WARN]:    at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:404)
    [20:29:44] [Server thread/WARN]:    at org.bukkit.craftbukkit.v1_7_R3.CraftServer.loadPlugin(CraftServer.java:457)
    [20:29:44] [Server thread/WARN]:    at org.bukkit.craftbukkit.v1_7_R3.CraftServer.enablePlugins(CraftServer.java:391)
    [20:29:44] [Server thread/WARN]:    at net.minecraft.server.v1_7_R3.MinecraftServer.n(MinecraftServer.java:352)
    [20:29:44] [Server thread/WARN]:    at net.minecraft.server.v1_7_R3.MinecraftServer.g(MinecraftServer.java:326)
    [20:29:44] [Server thread/WARN]:    at net.minecraft.server.v1_7_R3.MinecraftServer.a(MinecraftServer.java:282)
    [20:29:44] [Server thread/WARN]:    at net.minecraft.server.v1_7_R3.DedicatedServer.init(DedicatedServer.java:182)
    [20:29:44] [Server thread/WARN]:    at net.minecraft.server.v1_7_R3.MinecraftServer.run(MinecraftServer.java:436)
    [20:29:44] [Server thread/WARN]:    at net.minecraft.server.v1_7_R3.ThreadServerApplication.run(SourceFile:628)
    [20:29:44] [Server thread/WARN]: Caused by: java.net.ConnectException: Connection refused: connect
    [20:29:44] [Server thread/WARN]:    at java.net.DualStackPlainSocketImpl.connect0(Native Method)
    [20:29:44] [Server thread/WARN]:    at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
    [20:29:44] [Server thread/WARN]:    at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
    [20:29:44] [Server thread/WARN]:    at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
    [20:29:44] [Server thread/WARN]:    at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
    [20:29:44] [Server thread/WARN]:    at java.net.PlainSocketImpl.connect(Unknown Source)
    [20:29:44] [Server thread/WARN]:    at java.net.SocksSocketImpl.connect(Unknown Source)
    [20:29:44] [Server thread/WARN]:    at java.net.Socket.connect(Unknown Source)
    [20:29:44] [Server thread/WARN]:    at java.net.Socket.connect(Unknown Source)
    [20:29:44] [Server thread/WARN]:    at java.net.Socket.<init>(Unknown Source)
    [20:29:44] [Server thread/WARN]:    at java.net.Socket.<init>(Unknown Source)
    [20:29:44] [Server thread/WARN]:    at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:254)
    [20:29:44] [Server thread/WARN]:    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)
    [20:29:44] [Server thread/WARN]:    ... 27 more
    IF it is a driver error, can you send me a link to the right driver to use?
    Thanks!
    -Mac
     
  2. Offline

    fireblast709

    macboinc Your server does not seem to be accepting connections.
    1. Is the server up?
    2. Is the MySQL server actually accessible
    3. Is remote access (if applicable) enabled
     
  3. Offline

    macboinc

    After hours of testing, I got my final answer: Yes, Yes, Yes
     
  4. Offline

    Giant

    Have you tried debugging the information it attempts to connect to the server with? From the error it would seem that it feels to receive a reply from the server...

    Could you show some code perhaps, might give a slight bit more insight in the situation.
     
  5. Offline

    macboinc

    How would I do that

    !Can someone please help me!:mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad::mad:

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Jun 9, 2016
  6. Offline

    mythbusterma

  7. Offline

    ZodiacTheories

  8. Offline

    macboinc

    No not all!
    Yes, I am very f****** pissed.

    Thanks, now I got this error:
    Code:
    [12:36:07] [Server thread/WARN]: java.sql.SQLException: Access denied for user 'root'@'ip70-172-221-165.ri.ri.cox.net' (using password: YES)
    [12:36:07] [Server thread/WARN]:    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
    [12:36:07] [Server thread/WARN]:    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    [12:36:07] [Server thread/WARN]:    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    [12:36:07] [Server thread/WARN]:    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:931)
    [12:36:07] [Server thread/WARN]:    at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4031)
    [12:36:07] [Server thread/WARN]:    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1296)
    [12:36:07] [Server thread/WARN]:    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338)
    [12:36:07] [Server thread/WARN]:    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
    [12:36:07] [Server thread/WARN]:    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
    [12:36:07] [Server thread/WARN]:    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
    [12:36:07] [Server thread/WARN]:    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    [12:36:07] [Server thread/WARN]:    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    [12:36:07] [Server thread/WARN]:    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    [12:36:07] [Server thread/WARN]:    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    [12:36:07] [Server thread/WARN]:    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    [12:36:07] [Server thread/WARN]:    at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    [12:36:07] [Server thread/WARN]:    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
    [12:36:07] [Server thread/WARN]:    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
    [12:36:07] [Server thread/WARN]:    at java.sql.DriverManager.getConnection(Unknown Source)
    [12:36:07] [Server thread/WARN]:    at java.sql.DriverManager.getConnection(Unknown Source)
    [12:36:07] [Server thread/WARN]:    at me.macboinc1.punishment.MySQL.<init>(MySQL.java:17)
    [12:36:07] [Server thread/WARN]:    at me.macboinc1.punishment.Punishment.onEnable(Punishment.java:20)
    [12:36:07] [Server thread/WARN]:    at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:316)
    [12:36:07] [Server thread/WARN]:    at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:324)
    [12:36:07] [Server thread/WARN]:    at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:404)
    [12:36:07] [Server thread/WARN]:    at org.bukkit.craftbukkit.v1_7_R3.CraftServer.loadPlugin(CraftServer.java:446)
    [12:36:07] [Server thread/WARN]:    at org.bukkit.craftbukkit.v1_7_R3.CraftServer.enablePlugins(CraftServer.java:380)
    [12:36:07] [Server thread/WARN]:    at net.minecraft.server.v1_7_R3.MinecraftServer.n(MinecraftServer.java:352)
    [12:36:07] [Server thread/WARN]:    at net.minecraft.server.v1_7_R3.MinecraftServer.g(MinecraftServer.java:326)
    [12:36:07] [Server thread/WARN]:    at net.minecraft.server.v1_7_R3.MinecraftServer.a(MinecraftServer.java:282)
    [12:36:07] [Server thread/WARN]:    at net.minecraft.server.v1_7_R3.DedicatedServer.init(DedicatedServer.java:182)
    [12:36:07] [Server thread/WARN]:    at net.minecraft.server.v1_7_R3.MinecraftServer.run(MinecraftServer.java:436)
    [12:36:07] [Server thread/WARN]:    at net.minecraft.server.v1_7_R3.ThreadServerApplication.run(SourceFile:628)
    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Jun 9, 2016
  9. Offline

    mythbusterma

    macboinc

    It says access denied....either the username or password is wrong.
     
  10. Offline

    macboinc

    It isn't wrong though.
     
  11. Offline

    mythbusterma

  12. Offline

    mazentheamazin

    macboinc
    Another reason that may occur is due to remote connections being disabled (i.e root doesn't have access to the database on a remote connection)
     
  13. Offline

    macboinc

    How would I enable it?
     
  14. Offline

    mazentheamazin

    macboinc
    First login to your MySQL server and run these commands:
    Code:mysql
    1. using databasename;
    2.  
    3. grant all privileges on databasename.* to 'root'@'ip' identified by 'yourpassword';


    You can use the % wildcard.
     
  15. Offline

    xize

    it sounds that the mysql server it self does may not allow remote connections alot of hosting companies are doing that especially when its shared hosting to.

    however since its able to say your password is wrong this error it could mean a few things:

    1. database could be wrongly named
    2. your host could be named wrong
    3. the database is maybe down but for some reason it is still cached or one of the services does conflict think about into the direction of: it sents out a 500 internal server error in some cases mysql could spit this error out to.
    4. or as it says your username or password is wrong.
     
  16. Offline

    macboinc

    Got this error now:
    Code:
    [14:12:23] [Server thread/WARN]: java.sql.SQLException: null,  message from server: "Host 'ip70-172-221-165.ri.ri.cox.net' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"
    [14:12:23] [Server thread/WARN]:    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
    [14:12:23] [Server thread/WARN]:    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
    [14:12:23] [Server thread/WARN]:    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
    [14:12:23] [Server thread/WARN]:    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1116)
    [14:12:23] [Server thread/WARN]:    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338)
    [14:12:23] [Server thread/WARN]:    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
    [14:12:23] [Server thread/WARN]:    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
    [14:12:23] [Server thread/WARN]:    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
    [14:12:23] [Server thread/WARN]:    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    [14:12:23] [Server thread/WARN]:    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    [14:12:23] [Server thread/WARN]:    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    [14:12:23] [Server thread/WARN]:    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    [14:12:23] [Server thread/WARN]:    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    [14:12:23] [Server thread/WARN]:    at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    [14:12:23] [Server thread/WARN]:    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
    [14:12:23] [Server thread/WARN]:    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
    [14:12:23] [Server thread/WARN]:    at java.sql.DriverManager.getConnection(Unknown Source)
    [14:12:23] [Server thread/WARN]:    at java.sql.DriverManager.getConnection(Unknown Source)
    [14:12:23] [Server thread/WARN]:    at me.macboinc1.punishment.MySQL.<init>(MySQL.java:17)
    [14:12:23] [Server thread/WARN]:    at me.macboinc1.punishment.Punishment.onEnable(Punishment.java:20)
    [14:12:23] [Server thread/WARN]:    at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:316)
    [14:12:23] [Server thread/WARN]:    at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:324)
    [14:12:23] [Server thread/WARN]:    at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:404)
    [14:12:23] [Server thread/WARN]:    at org.bukkit.craftbukkit.v1_7_R3.CraftServer.loadPlugin(CraftServer.java:446)
    [14:12:23] [Server thread/WARN]:    at org.bukkit.craftbukkit.v1_7_R3.CraftServer.enablePlugins(CraftServer.java:380)
    [14:12:23] [Server thread/WARN]:    at net.minecraft.server.v1_7_R3.MinecraftServer.n(MinecraftServer.java:352)
    [14:12:23] [Server thread/WARN]:    at net.minecraft.server.v1_7_R3.MinecraftServer.g(MinecraftServer.java:326)
    [14:12:23] [Server thread/WARN]:    at net.minecraft.server.v1_7_R3.MinecraftServer.a(MinecraftServer.java:282)
    [14:12:23] [Server thread/WARN]:    at net.minecraft.server.v1_7_R3.DedicatedServer.init(DedicatedServer.java:182)
    [14:12:23] [Server thread/WARN]:    at net.minecraft.server.v1_7_R3.MinecraftServer.run(MinecraftServer.java:436)
    [14:12:23] [Server thread/WARN]:    at net.minecraft.server.v1_7_R3.ThreadServerApplication.run(SourceFile:628)
     
  17. Offline

    mazentheamazin

    macboinc
    Please read the error, it was blocked and you can unblock it by running this command through ssh or terminal (depending on what you're using to run this):
    Code:
    mysqladmin flush-hosts
     
  18. Offline

    macboinc

    I got an error when I typed that:
    http://imgur.com/PE2KE0W
     
  19. Offline

    mazentheamazin

    macboinc
    My mistake, go logon your MySQL server and type this in:

    Code:mysql
    1. flush hosts;
     
    macboinc likes this.
  20. Offline

    macboinc

    THANK YOU SO FUC**** MUCH YOUR AWESOME!
     
Thread Status:
Not open for further replies.

Share This Page