I are having to install the Server on a new Cloud Instance and I am running into a problem.
I have loaded pgadmin and restored all databases with no problems. The issue I am having is when installing Servoy 6.1
When I run the Verify Connection at the beginning of the Servoy install - I get “Connection to the database failed!”
Because the pgadmin in the Servoy server install was a lower version I installed pgadmin separately and am using the Connect to an existing Database option on the install.
The Server URL: jdbc:posgresql://localhost:5432
The JDBC driver classname: org.postgresql.Driver
The user name: postgres
and password is entered correctly
update: I was able to get everything installed - the initial problem was two fold -
1: the ports 8080 and 1099 needed to be open
2: java 64 needed t be installed.
However now there is an issue with the Service not remaining “Started” - below is some information from the log file
2013-07-31 15:09:33,709 ERROR [WrapperSimpleAppMain] 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.(Za.java:1684)
at com.servoy.j2db.server.Za.Za.(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)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:238)
at java.lang.Thread.run(Unknown Source)
Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user “postgres”
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:291)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:108)
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.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)
… 10 more
2013-07-31 15:09:33,724 ERROR [WrapperSimpleAppMain] com.servoy.j2db.util.Debug - Do note Servoy server does not start any database!
During the installation the connection and password was verified - How can I set this password after the installation has completed? The password in the servoy.properties file is encrypted
after setting the passwords to the real passwords for each of the databases II now get the following in the server_log file
2013-08-01 11:13:46,701 ERROR [pool-1-thread-1] com.servoy.j2db.server.Za.Zo - Final get connection failure for server abbrev in 1 times
Also when I look at the command window I have this additional information
log4j:ERROR setFile(null,true) call failed.
java.io.FileNotFoundException: C:\Servoy\application_server\servoy_log.txt (Access is denied)
at java.io.FileOutputStream.open(Native Method)
at java.io.FileOutputStream.(Unknown Source)
at java.io.FileOutputStream.(Unknown Source)
at org.apache.log4j.FileAppender.setFile(FileAppender.java:294)
at org.apache.log4j.RollingFileAppender.setFile(RollingFileAppender.java:207)
at org.apache.log4j.FileAppender.activateOptions(FileAppender.java:165)
at org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:307)
at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:172)
at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:104)
at org.apache.log4j.PropertyConfigurator.parseAppender(PropertyConfigurator.java:809)
at org.apache.log4j.PropertyConfigurator.parseCategory(PropertyConfigurator.java:735)
at org.apache.log4j.PropertyConfigurator.configureRootCategory(PropertyConfigurator.java:615)
at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:502)
at org.apache.log4j.PropertyConfigurator.configure(PropertyConfigurator.java:428)
at com.servoy.j2db.server.main.ApplicationServer.initLoggingSystem(ApplicationServer.java:274)
at com.servoy.j2db.server.main.ApplicationServer.main(ApplicationServer.java:128)
Exception in thread “pool-1-thread-1” java.lang.NoSuchMethodError: com.hxtt.sql.dp.a(ILjava/lang/String;Ljava/util/Properties;)Lcom/hxtt/concurrent/aa;
at com.hxtt.sql.access.EmbeddedDriver.connect(Unknown Source)
at com.hxtt.global.SQLState.getConnection(Unknown Source)
at com.hxtt.sql.HxttDriver.if(Unknown Source)
at com.hxtt.sql.HxttDriver.connect(Unknown Source)
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.Zo.Za(Zo.java:721)
at com.servoy.j2db.server.Za.Zo.Zk(Zo.java:1044)
at com.servoy.j2db.server.Za.Zo.getTableAndViewNames(Zo.java:819)
at com.servoy.j2db.server.Za.Zo.getTableAndViewNames(Zo.java:268)
at com.servoy.j2db.server.main.Zs.run(Zs.java:31)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Exception in thread “main” java.lang.NoSuchMethodError: com.hxtt.sql.dp.a(ILjava
/lang/String;Ljava/util/Properties;)Lcom/hxtt/concurrent/aa;
at com.hxtt.sql.access.EmbeddedDriver.connect(Unknown Source)
at com.hxtt.global.SQLState.getConnection(Unknown Source)
at com.hxtt.sql.HxttDriver.if(Unknown Source)
at com.hxtt.sql.HxttDriver.connect(Unknown Source)
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.Zo.Za(Zo.java:721)
at com.servoy.j2db.server.Za.Zo.Zk(Zo.java:1044)
at com.servoy.j2db.server.Za.Zo.getTable(Zo.java:38)
at com.servoy.j2db.server.Za.Zo.getTable(Zo.java:1428)
at com.servoy.j2db.persistence.ServerProxy.getTable(ServerProxy.java:84)
at com.servoy.j2db.server.Za.Za.Za(Za.java:582)
at com.servoy.j2db.server.Za.Za.loadRootObject(Za.java:903)
at com.servoy.j2db.persistence.RootObjectCache.getRootObject(RootObjectCache.java:226)
at com.servoy.j2db.persistence.RootObjectCache.getActiveRootObject(RootObjectCache.java:160)
at com.servoy.j2db.persistence.AbstractRepository.getActiveRootObject(AbstractRepository.java:421)
at com.servoy.j2db.server.main.ApplicationServer.loadAllSolutionsCompletelyInMem(ApplicationServer.java:432)
at com.servoy.j2db.server.main.ApplicationServer.main(ApplicationServer.java:433)
the process has no rights to save into that dir somehow at least thats the first part
the second part is a bit weird but that could be the result of the the first.
I entered the password in straight into the properties file. I’m also doing a cloud installaiton and got all the exact same problems, although for me my ’ "FATAL: password authentication failed for user “postgres” ’ is still showing up.
This is the error output from the log file:
2014-01-10 20:43:08,750 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:1664)
at com.servoy.j2db.server.Za.Za.(Za.java:155)
at com.servoy.j2db.server.Za.Za.(Za.java:1280)
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:1380)
at com.servoy.j2db.server.main.ApplicationServer.main(ApplicationServer.java:59)
Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user “postgres”
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:291)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:108)
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.datasource.Zp.createConnection(Zp.java:3)
at com.servoy.j2db.datasource.Ze.createConnection(Ze.java:1)
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:40)
at com.servoy.j2db.datasource.jmx.ManagedBasicPoolingDataSource.getConnection(ManagedBasicPoolingDataSource.java:39)
at com.servoy.j2db.server.Za.Zo.getRawConnection(Zo.java:866)
at com.servoy.j2db.server.Za.Zo.Zf(Zo.java:886)
at com.servoy.j2db.server.Za.Za.Zb(Za.java:1056)
… 4 more
2014-01-10 20:43:08,759 ERROR [main] com.servoy.j2db.util.Debug - Do note Servoy server does not start any database!
This is the properties file:
Servoy properties file
NOTE: At least one connection must be called ‘repository_server’ !!
Number of servers defined in this file
ServerManager.numberOfServers=1
Definition 1
server.0.serverName=repository_server
server.0.URL=jdbc:postgresql://localhost:5432/servoy_repository
server.0.driver=org.postgresql.Driver
server.0.userName=postgres
server.0.password=****** (I’m sure the password is right)
server.0.catalog=#start database enginenativeStartupLauncher=%%user.dir%%\postgres_db\bin\pg_ctl|start|-D|database|-l|postgres_db\postgres_log.txt
waitForNativeStartup=falsenativeShutdownLauncher=%%user.dir%%\postgres_db\bin\pg_ctl|stop|-D|database|-l|postgres_db\postgres_log.txt#for use by pdf_forms plugin
pdf_forms_plugin_servername=pdf_forms#network configSocketFactory.useTwoWaySocket=trueSocketFactory.useSSL=truejava.rmi.server.hostname=localhost
Hi Johan, I can’t really get to the admin page since I can’t start the server in the first place… Also, I went in and manually changed the server.0.userName, it was orginally DBA even though I specified postgres in the installation not sure why this would have been either…