Solved (Logblock) Logblock not connecting MySQL

When I run my server with logblock, it does not connect to MySQL and gives me an error instead.

The error is below with all the other information regarding the problem.

Information:

I use WAMPServer to run MySQL

My MySQL port I use is 1026

The config file and MySQL stuff matches perfectly. (I have checked this over multiple times.)

The error I get:


21:14:16 [SEVERE] [LogBlock] Error while fetching connection:
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link fai
lure

The last packet sent successfully to the server was 0 milliseconds ago. The driv
er has not received any packets from the server.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1
116)
at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:687)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1090)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2
371)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
:305)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at de.diddiz.util.MySQLConnectionPool.getConnection(MySQLConnectionPool.
java:72)
at de.diddiz.LogBlock.LogBlock.getConnection(LogBlock.java:216)
at de.diddiz.LogBlock.LogBlock.onLoad(LogBlock.java:63)
at org.bukkit.craftbukkit.v1_4_R1.CraftServer.loadPlugins(CraftServer.ja
va:244)
at org.bukkit.craftbukkit.v1_4_R1.CraftServer.<init>(CraftServer.java:21
7)
at net.minecraft.server.v1_4_R1.PlayerList.<init>(PlayerList.java:55)
at net.minecraft.server.v1_4_R1.DedicatedPlayerList.<init>(SourceFile:11
)
at net.minecraft.server.v1_4_R1.DedicatedServer.init(DedicatedServer.jav
a:104)
at net.minecraft.server.v1_4_R1.MinecraftServer.run(MinecraftServer.java
:399)
at net.minecraft.server.v1_4_R1.ThreadServerApplication.run(SourceFile:8
49)
Caused by: java.io.EOFException: Can not read response from server. Expected to
read 4 bytes, read 0 bytes before connection was unexpectedly lost.
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2529)
at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:611)
... 25 more

 

by chance did you try the default port of 3306? I know you said you changed the port, but give it a try and see if it fixes your problem.

 

Default port by changing the port in MySQL and everything else?
That would mess up my MySQL, I wouldn't change a port unless it fixed something.

 

no, change your config to point to 3306, not change your port internally. Just to see if maybe it didn't stick.

 

Oh my god, that actually worked. Thank you very much!

 

Glad I could help