I’ve just done a new install of 5.2 and get the following error whenever I try and enable the repository server (all database servers after install show an error).
“Connection Refused chek that the hostname and port are correct and that the postmaster is accepting TCP/IP connections”
I’ve disabled the firewall and tried again but still get the same error. I’ve added a new Mysql database and that connects fine.
Any suggestions would be appreciated.
Thanks.
Did you check if PostgreSQL is running ?
Heres the log … theres no firewall running,
org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:122)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:65)
at org.postgresql.jdbc2.AbstractJdbc2Connection.(AbstractJdbc2Connection.java:116)
at org.postgresql.jdbc3.AbstractJdbc3Connection.(AbstractJdbc3Connection.java:30)
at org.postgresql.jdbc3.Jdbc3Connection.(Jdbc3Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:369)
at org.postgresql.Driver.connect(Driver.java:245)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at com.servoy.j2db.Za.Za.Zd.createConnection(Zd.java:4)
at com.servoy.j2db.Za.Za.Zo.makeObject(Zo.java:33)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
at com.servoy.j2db.Za.Za.Za.getConnection(Za.java:48)
at com.servoy.j2db.server.Zc.Zo.Zg(Zo.java:1365)
at com.servoy.j2db.server.Zc.Zo.testConnection(Zo.java:858)
at com.servoy.j2db.server.ApplicationServer.initStandalone(ApplicationServer.java:437)
at com.servoy.j2db.server.starter.StandaloneServerStarter.initFromDeveloper(StandaloneServerStarter.java:10)
at com.servoy.j2db.server.starter.EclipseServerStarter.startApplicationServer(EclipseServerStarter.java:2)
at com.servoy.eclipse.appserver.Activator.startAppServer(Activator.java:148)
at com.servoy.eclipse.core.ServoyModel.startAppServer(ServoyModel.java:464)
at com.servoy.eclipse.core.util.SplashHandler$1.run(SplashHandler.java:52)
at java.lang.Thread.run(Unknown Source)
Caused by: java.net.ConnectException: Connection refused: connect
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 org.postgresql.core.PGStream.(PGStream.java:60)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:77)
… 21 more
2010-11-26 09:41:31,220 ERROR [main] com.servoy.j2db.server.Zc.Zo - org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
2010-11-26 09:41:32,204 ERROR [main] com.servoy.j2db.server.Zc.Zo - org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
2010-11-26 09:41:33,298 ERROR [main] com.servoy.j2db.server.Zc.Zo - org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
2010-11-26 09:41:34,392 ERROR [main] com.servoy.j2db.server.Zc.Zo - org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
2010-11-26 09:41:35,485 ERROR [main] com.servoy.j2db.server.Zc.Zo - org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
2010-11-26 09:41:36,579 ERROR [main] com.servoy.j2db.server.Zc.Zo - org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
2010-11-26 09:41:37,564 ERROR [main] com.servoy.j2db.server.Zc.Zo - org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
2010-11-26 09:41:41,282 ERROR [Worker-6] com.servoy.j2db.server.Zc.Zo - Final get connection failure for server repository_server in 1 times
2010-11-26 09:41:42,267 ERROR [Worker-6] com.servoy.j2db.server.Zc.Zo - Final get connection failure for server bug_db in 1 times
2010-11-26 09:41:43,251 ERROR [Worker-6] com.servoy.j2db.server.Zc.Zo - Final get connection failure for server example_data in 1 times
2010-11-26 09:41:44,345 ERROR [Worker-6] com.servoy.j2db.server.Zc.Zo - Final get connection failure for server log_server in 1 times
2010-11-26 09:41:45,439 ERROR [Worker-6] com.servoy.j2db.server.Zc.Zo - Final get connection failure for server pdf_forms in 1 times
2010-11-26 09:41:45,439 ERROR [main] com.servoy.j2db.server.Zc.Zo - org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
2010-11-26 09:41:46,532 ERROR [Worker-6] com.servoy.j2db.server.Zc.Zo - Final get connection failure for server udm in 1 times
2010-11-26 09:41:47,517 ERROR [main] com.servoy.j2db.server.Zc.Zo - org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
2010-11-26 09:41:47,517 ERROR [Worker-6] com.servoy.j2db.server.Zc.Zo - Final get connection failure for server user_data in 1 times
2010-11-26 09:42:02,173 ERROR [Worker-0] com.servoy.j2db.server.Zc.Zo - Final get connection failure for server repository_server in 6 times
Firewall switched off, any suggestions as to why Postgres is not starting or fix ?
Is there a way to start postgres manually?
I’ve had the same issue on new 2003 and 2008 VPS servers. Therefore I can only assume something is not running on the servers which is required for the install.
I’ve had a look and compared the failed installations with a 5.2 install on windows 7 system and I notice the folder E:\servoy\application_server\database is empty on the the failing installs where as in the w7 install its full of files and folders. Is this related I’ve no idea what and how these folders are used in w7 and why on the w2003 an w2008 servers they are empty.
check this thread:
Thanks that thread had the solution.
This issue will be fixed in Servoy 5.2.5 (installation will work in C:\Servoy).