Please help. This is URGENT.
I have tried various possible configurations/installations.
The one that I am posting here, and I'd like to get working, is the Servoy installation with the bundled PostgreSQL database option.
The installation goes well, but when I start Servoy from the Start menu...
But then Servoy server terminal windows opens and close. The error that is stored in the servoy_log.txt file is this:
- Code: Select all
2012-09-09 01:24:58,078 ERROR [main] com.servoy.j2db.util.Debug - Cannot start repository: [ ]
com.servoy.j2db.persistence.RepositoryException: Error checking repository
at com.servoy.j2db.server.Za.Za.Zb(Za.java:34)
at com.servoy.j2db.server.Za.Za.<init>(Za.java:1684)
at com.servoy.j2db.server.Za.Za.<init>(Za.java:706)
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:8)
at com.servoy.j2db.server.main.ApplicationServer.main(ApplicationServer.java:686)
Caused by: 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:136)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:393)
at org.postgresql.Driver.connect(Driver.java:267)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at com.servoy.j2db.datasource.Zp.createConnection(Zp.java:5)
at com.servoy.j2db.datasource.Ze.createConnection(Ze.java:5)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1158)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
at com.servoy.j2db.datasource.Za.getConnection(Za.java:14)
at com.servoy.j2db.datasource.jmx.ManagedBasicPoolingDataSource.getConnection(ManagedBasicPoolingDataSource.java:34)
at com.servoy.j2db.server.Za.Zo.getRawConnection(Zo.java:1272)
at com.servoy.j2db.server.Za.Zo.Zf(Zo.java:644)
at com.servoy.j2db.server.Za.Za.Zb(Za.java:1625)
... 4 more
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.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at org.postgresql.core.PGStream.<init>(PGStream.java:62)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:76)
... 21 more
2012-09-09 01:24:58,078 ERROR [main] com.servoy.j2db.util.Debug - Do note Servoy server does not start any database! [ ]
Then, I tried to start from the command line using ‘servoy_server.bat –upgradeRepository,’ but I get this…
See the error log with the added lines at the bottom here..
- Code: Select all
2012-09-09 01:24:58,078 ERROR [main] com.servoy.j2db.util.Debug - Cannot start repository: [ ]
com.servoy.j2db.persistence.RepositoryException: Error checking repository
at com.servoy.j2db.server.Za.Za.Zb(Za.java:34)
at com.servoy.j2db.server.Za.Za.<init>(Za.java:1684)
at com.servoy.j2db.server.Za.Za.<init>(Za.java:706)
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:8)
at com.servoy.j2db.server.main.ApplicationServer.main(ApplicationServer.java:686)
Caused by: 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:136)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:393)
at org.postgresql.Driver.connect(Driver.java:267)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at com.servoy.j2db.datasource.Zp.createConnection(Zp.java:5)
at com.servoy.j2db.datasource.Ze.createConnection(Ze.java:5)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1158)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
at com.servoy.j2db.datasource.Za.getConnection(Za.java:14)
at com.servoy.j2db.datasource.jmx.ManagedBasicPoolingDataSource.getConnection(ManagedBasicPoolingDataSource.java:34)
at com.servoy.j2db.server.Za.Zo.getRawConnection(Zo.java:1272)
at com.servoy.j2db.server.Za.Zo.Zf(Zo.java:644)
at com.servoy.j2db.server.Za.Za.Zb(Za.java:1625)
... 4 more
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.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at org.postgresql.core.PGStream.<init>(PGStream.java:62)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:76)
... 21 more
2012-09-09 01:24:58,078 ERROR [main] com.servoy.j2db.util.Debug - Do note Servoy server does not start any database! [ ]
2012-09-09 01:27:24,216 ERROR [main] com.servoy.j2db.util.Debug - Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag. [ ]
The I modified the servoy_server.bat file adding this line (as suggested in the same .bat file):
postgres_db\bin\pg_ctl start -D database -l postgres_db\postgres_log.txt
Still nothing! It says that the process cannot be accessed because the file is being used…. See here:
The entire error log is below. Please note the added lines at the bottom don;t say much (Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag)
- Code: Select all
2012-09-09 01:24:58,078 ERROR [main] com.servoy.j2db.util.Debug - Cannot start repository: [ ]
com.servoy.j2db.persistence.RepositoryException: Error checking repository
at com.servoy.j2db.server.Za.Za.Zb(Za.java:34)
at com.servoy.j2db.server.Za.Za.<init>(Za.java:1684)
at com.servoy.j2db.server.Za.Za.<init>(Za.java:706)
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:8)
at com.servoy.j2db.server.main.ApplicationServer.main(ApplicationServer.java:686)
Caused by: 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:136)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:393)
at org.postgresql.Driver.connect(Driver.java:267)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at com.servoy.j2db.datasource.Zp.createConnection(Zp.java:5)
at com.servoy.j2db.datasource.Ze.createConnection(Ze.java:5)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1158)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
at com.servoy.j2db.datasource.Za.getConnection(Za.java:14)
at com.servoy.j2db.datasource.jmx.ManagedBasicPoolingDataSource.getConnection(ManagedBasicPoolingDataSource.java:34)
at com.servoy.j2db.server.Za.Zo.getRawConnection(Zo.java:1272)
at com.servoy.j2db.server.Za.Zo.Zf(Zo.java:644)
at com.servoy.j2db.server.Za.Za.Zb(Za.java:1625)
... 4 more
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.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at org.postgresql.core.PGStream.<init>(PGStream.java:62)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:76)
... 21 more
2012-09-09 01:24:58,078 ERROR [main] com.servoy.j2db.util.Debug - Do note Servoy server does not start any database! [ ]
2012-09-09 01:27:24,216 ERROR [main] com.servoy.j2db.util.Debug - Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag. [ ]
2012-09-09 01:28:24,246 ERROR [main] com.servoy.j2db.util.Debug - Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag. [ ]
Same thing happen if I use MySQL instead of the bundled PostgreSQL (of course, configuring the properties file/repository_server/using the correct driver, etc.)
Now, the only way I can get Servoy Server working is when after installing Developer I start Developer. Only then, Servoy server works. If I close Developer and I try to start just Servoy Server from the command line (and of course after modifying the .bat file to start PostgreSQL), Servoy does not work. Same happens!
Any help will be appreciated.
Thank you VERY MUCH in advance, Carlos