Ignite Realtime

powered by Jive Software

Ignite Realtime Community Forums

Can't connect to the database

Openfire Openfire Support

sreeprasad September 23, 2015, 5:46am 1

i am new to the openfire server…we are developing windows phone app using openfire xmpp and postgreesql.but when installing the openfire showing database connection error…what is that actually? i cant fix the problem pleas help me .my error log says…

2015.09.23 11:09:59 org.jivesoftware.util.log.util.CommonsLogFactory - Prototype

org.postgresql.util.PSQLException: The connection attempt failed.

at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFacto ryImpl.java:249)

at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)

at org.postgresql.jdbc2.AbstractJdbc2Connection.(AbstractJdbc2Connection.jav a:127)

at org.postgresql.jdbc3.AbstractJdbc3Connection.(AbstractJdbc3Connection.jav a:29)

at org.postgresql.jdbc3g.AbstractJdbc3gConnection.(AbstractJdbc3gConnection. java:21)

at org.postgresql.jdbc4.AbstractJdbc4Connection.(AbstractJdbc4Connection.jav a:41)

at org.postgresql.jdbc4.Jdbc4Connection.(Jdbc4Connection.java:24)

at org.postgresql.Driver.makeConnection(Driver.java:414)

at org.postgresql.Driver.connect(Driver.java:282)

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)

Caused by: java.net.UnknownHostException: [host-name]

at java.net.AbstractPlainSocketImpl.connect(Unknown Source)

at java.net.PlainSocketImpl.connect(Unknown Source)

at java.net.SocksSocketImpl.connect(Unknown Source)

at java.net.Socket.connect(Unknown Source)

at org.postgresql.core.PGStream.(PGStream.java:61)

at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFacto ryImpl.java:121)

… 14 more

2015.09.23 11:10:29 org.jivesoftware.util.log.util.CommonsLogFactory - Prototype

org.postgresql.util.PSQLException: The connection attempt failed.

at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFacto ryImpl.java:249)

at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)

at org.postgresql.jdbc2.AbstractJdbc2Connection.(AbstractJdbc2Connection.jav a:127)

at org.postgresql.jdbc3.AbstractJdbc3Connection.(AbstractJdbc3Connection.jav a:29)

at org.postgresql.jdbc3g.AbstractJdbc3gConnection.(AbstractJdbc3gConnection. java:21)

at org.postgresql.jdbc4.AbstractJdbc4Connection.(AbstractJdbc4Connection.jav a:41)

at org.postgresql.jdbc4.Jdbc4Connection.(Jdbc4Connection.java:24)

at org.postgresql.Driver.makeConnection(Driver.java:414)

at org.postgresql.Driver.connect(Driver.java:282)

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)

Caused by: java.net.UnknownHostException: [host-name]

at java.net.AbstractPlainSocketImpl.connect(Unknown Source)

at java.net.PlainSocketImpl.connect(Unknown Source)

at java.net.SocksSocketImpl.connect(Unknown Source)

at java.net.Socket.connect(Unknown Source)

at org.postgresql.core.PGStream.(PGStream.java:61)

at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFacto ryImpl.java:121)

… 14 more

2015.09.23 11:10:59 org.jivesoftware.util.log.util.CommonsLogFactory - Prototype

org.postgresql.util.PSQLException: The connection attempt failed.

at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFacto ryImpl.java:249)

at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)

at org.postgresql.jdbc2.AbstractJdbc2Connection.(AbstractJdbc2Connection.jav a:127)

at org.postgresql.jdbc3.AbstractJdbc3Connection.(AbstractJdbc3Connection.jav a:29)

at org.postgresql.jdbc3g.AbstractJdbc3gConnection.(AbstractJdbc3gConnection. java:21)

at org.postgresql.jdbc4.AbstractJdbc4Connection.(AbstractJdbc4Connection.jav a:41)

at org.postgresql.jdbc4.Jdbc4Connection.(Jdbc4Connection.java:24)

at org.postgresql.Driver.makeConnection(Driver.java:414)

at org.postgresql.Driver.connect(Driver.java:282)

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)

Caused by: java.net.UnknownHostException: [host-name]

at java.net.AbstractPlainSocketImpl.connect(Unknown Source)

at java.net.PlainSocketImpl.connect(Unknown Source)

at java.net.SocksSocketImpl.connect(Unknown Source)

at java.net.Socket.connect(Unknown Source)

at org.postgresql.core.PGStream.(PGStream.java:61)

at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFacto ryImpl.java:121)

… 14 more

2015.09.23 11:11:29 org.jivesoftware.util.log.util.CommonsLogFactory - Prototype

org.postgresql.util.PSQLException: The connection attempt failed.

at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFacto ryImpl.java:249)

at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)

at org.postgresql.jdbc2.AbstractJdbc2Connection.(AbstractJdbc2Connection.jav a:127)

at org.postgresql.jdbc3.AbstractJdbc3Connection.(AbstractJdbc3Connection.jav a:29)

at org.postgresql.jdbc3g.AbstractJdbc3gConnection.(AbstractJdbc3gConnection. java:21)

at org.postgresql.jdbc4.AbstractJdbc4Connection.(AbstractJdbc4Connection.jav a:41)

at org.postgresql.jdbc4.Jdbc4Connection.(Jdbc4Connection.java:24)

at org.postgresql.Driver.makeConnection(Driver.java:414)

at org.postgresql.Driver.connect(Driver.java:282)

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)

Caused by: java.net.UnknownHostException: [host-name]

at java.net.AbstractPlainSocketImpl.connect(Unknown Source)

at java.net.PlainSocketImpl.connect(Unknown Source)

at java.net.SocksSocketImpl.connect(Unknown Source)

at java.net.Socket.connect(Unknown Source)

at org.postgresql.core.PGStream.(PGStream.java:61)

at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFacto ryImpl.java:121)

… 14 more

Message was edited by: wroot

wroot September 23, 2015, 6:37am 2

I have edited your thread’s title. There is no need to put a whole paragraph in there.

sreeprasad September 23, 2015, 7:52am 3

please suggest me a solution

wroot September 23, 2015, 8:19am 4

It’s hard to tell from the log what is the problem. It fails to connect to the database. So check your firewalls and make sure you are providing correct credentials for the database user.