Openfire database connection timedout error.log

Openfire Openfire Support
1

** BEGIN NESTED EXCEPTION **

java.net.ConnectException
MESSAGE: Connection timed out

STACKTRACE:

java.net.ConnectException: Connection timed out
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.(Unknown Source)
at java.net.Socket.(Unknown Source)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)
at com.mysql.jdbc.MysqlIO.(MysqlIO.java:271)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2771)
at com.mysql.jdbc.Connection.(Connection.java:1555)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
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)

A connection to the database could not be made. View the error message by opening the “/logs/error.log” log file, then go back to fix the problem.

Please I have revieved the forum for similar problem but I cannot solve this problem. Please can you help me in details with every step I need to follow

** END NESTED EXCEPTION **

Last packet sent to the server was 1 ms ago.
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2847)
at com.mysql.jdbc.Connection.(Connection.java:1555)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
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)

2

Hi,

when does this happen? This is likely no problem of Openfire but with your database or the network between Openfire and the database.

LG

3

I need help to configure my DB in sync with Openfire so that I can have instant messenger working.

It is new server with LAMP ( Linux CENTOS 5.4, Apache, MYSQL & PHP ). I need few clarification.

  1. Do I need Tomcat server for openfire to work. I guess I don’t need however just wanted to confirm. I don’t have any servlet or JSP on our website.

  2. Do I need JDK. I guess I don’t need JDK ( Java compiler ). I feel that I just need JRE environment so that .jar files i.e. class file can be accessed by openfire.

  3. When I reach the openfire URL http://localhost:9090/ while connecting the Database, I get the above mentioned error. I am not sure whether it is issue with remote access of MYSQL or issue with some firewall / iptables which is blocking. I can locally access the mysql as root & openfire user. It is up & running.

  4. How can I do the autologin for all the users. Please help me on this as well.

  5. Please suggest me the good website IM client which can be invoked as soon as someone visits the website after initial authentication.

Please help.

4

Hi,

1+2: no

3: Which is the database URL? Something like dbserver:3306? Try “telnet dbserver 3306” and you should get a connection and not a timeout.

4: depends on your client

5: Look for SparkWeb, JWChat, …

LG

5

This problem is fixed. I have reinstalled everything with proper Iptables settings.

Rgds,