Openfire unable to connect to MYSQL

Openfire Openfire Support
1

So my openfire server has stopped working ever since I turned off bin files on my mysql server. This shouldn’t affect it at all but for some reason I can now no longer connect to the db.

I’ve tried a completely fresh reinstall of openfire along with using both localhost/127.0.0.1 and even the remote ip of the server when setting up openfire.

Error remains the same

2015.10.30 22:59:52 org.jivesoftware.util.log.util.CommonsLogFactory - Prototype

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.

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

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructor AccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:526)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)

at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1127)

at com.mysql.jdbc.MysqlIO.(MysqlIO.java:356)

at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2502)

at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2539)

at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2321)

at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:832)

at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:46)

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

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructor AccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:526)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)

at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:417)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:344)

at java.sql.DriverManager.getConnection(DriverManager.java:571)

at java.sql.DriverManager.getConnection(DriverManager.java:187)

at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConn ectionBuilder.java:39)

at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)

at org.logicalcobwebs.proxool.Prototyper.sweep(Prototyper.java:102)

at org.logicalcobwebs.proxool.PrototyperThread.run(PrototyperThread.java:44)

Caused by: java.net.SocketException: Network is unreachable

at java.net.PlainSocketImpl.socketConnect(Native Method)

at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)

at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java: 200)

at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)

at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)

at java.net.Socket.connect(Socket.java:579)

at java.net.Socket.connect(Socket.java:528)

at java.net.Socket.(Socket.java:425)

at java.net.Socket.(Socket.java:241)

at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:258)

at com.mysql.jdbc.MysqlIO.(MysqlIO.java:306)

… 17 more

2

you may try updating the mysql driver used by openfire.

MySQL :: Download Connector/J

simple stop openfire, and locate openfire\lib\mysql.jar and rename it to something like mysql.jar.bak

Then take the mysql-connector-java-5…jar and copy it as mysql.jar into openfire\lib

start openfire.

3

Same error

4

may sound like an odd question, but have you verified that mysql is running, and that you’re able to connect to the database? Do you see any errors in your mysql logs?

5

DB is running fine as I have other things (forums, other game specific services) that are working fine.

6

My first thought is that this isn’t an issue with openfire. Many people are running openfire and mysql without any problems. I’ll try to recreate your issue when I have time. My guess is a misconfiguraiton, usersname and password issue, firewall/network, etc., although I’m sure you’ve already checks those things!