Installing Application Server

Classic Servoy
1

I have installed Servoy 6.0.6 Application Server on my company server…
I have problems running it…after i start it (using the servoy_server.bat not modified) the command window is opened and after few seconds it is closed…
In the servoy_log.txt i have this:

2012-05-17 10:04:42,836 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:832)
at com.servoy.j2db.server.Za.Za.(Za.java:59)
at com.servoy.j2db.server.Za.Za.(Za.java:1692)
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:669)
at com.servoy.j2db.server.main.ApplicationServer.main(ApplicationServer.java:538)
Caused by: org.postgresql.util.PSQLException: Connessione rifiutata. Controllare che il nome dell’host e la porta siano corretti, e che il server (postmaster) sia in esecuzione con l’opzione -i, che abilita le connessioni attraverso la rete TCP/IP.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:136)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
at org.postgresql.jdbc2.AbstractJdbc2Connection.(AbstractJdbc2Connection.java:125)
at org.postgresql.jdbc3.AbstractJdbc3Connection.(AbstractJdbc3Connection.java:30)
at org.postgresql.jdbc3.Jdbc3Connection.(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.Za.Zp.createConnection(Zp.java:4)
at com.servoy.j2db.Za.Ze.createConnection(Ze.java:4)
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.Za.Za.getConnection(Za.java:42)
at com.servoy.j2db.server.Za.Zo.getRawConnection(Zo.java:295)
at com.servoy.j2db.server.Za.Zo.Zf(Zo.java:652)
at com.servoy.j2db.server.Za.Za.Zb(Za.java:998)
… 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.(Unknown Source)
at java.net.Socket.(Unknown Source)
at org.postgresql.core.PGStream.(PGStream.java:62)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:76)
… 20 more
2012-05-17 10:04:42,852 ERROR [main] com.servoy.j2db.util.Debug - Do note Servoy server does not start any database!

Where is the problem ?

Thanks

2

Hi,

Like the error says (at the bottom) Servoy Server (unlike Developer) does not start the database server for you.
So is PostgreSQL already running ? If not you need to launch it yourself before launching Servoy Server.

Hope this helps.

3

If i modify the servoy_server.bat to run postgres (there is an apposite note in the batch) adding this row
postgres_db\bin\pg_ctl start -D database -l postgres_db\postgres_log.txt

when i run the bat i have in the command window:

Server is starting
Cannot upgrade the repository: make a backup of your repository and start server with -upgradeRepository flag

and the command window is frozen

In the log file of postgres i have:

LOG: database system was interrupted; last known up at 2012-05-18 09:53:22 CEST
LOG: database system was not properly shut down; automatic recovery in progress
LOG: consistent recovery state reached at 0/15F4550
LOG: record with zero length at 0/15F4550
LOG: redo is not required
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
LOG: could not receive data from client: Unknown winsock error 10061
LOG: unexpected EOF on client connection
LOG: statistics collector process (PID 4888) was terminated by exception 0xC000013A
HINT: See C include file “ntstatus.h” for a description of the hexadecimal value.
LOG: autovacuum launcher process (PID 7712) was terminated by exception 0xC000013A
HINT: See C include file “ntstatus.h” for a description of the hexadecimal value.
LOG: terminating any other active server processes
LOG: received fast shutdown request
LOG: abnormal database system shutdown

Then i launch servoy_server.bat -upgradeRepository and after one time i had errors, it runs correctly…

Now it works fine…