Weird 'Cannot start repository' problem (7.4.11)
Posted: Fri Apr 09, 2021 6:59 pm
Hi all,
couldn't quite work out best section for this post, so settled on here...
I am trying to set up a Mac mini [macOS High Sierra 10.13.6] to act as a Servoy Application Server (SAS) for a client who is 'stuck' on Servoy version 7.4.11 [-releaseNumber 2050]
Their solution is running in Smart Client within the DataSutra (DS) framework.
It was running on a Windows Server with a Postgres Database Server until some Microsoft Windows update was forced upon the server causing SAS to stop working (well actually it just constantly generated loads of networking errors.
So I then set up a stand alone Windows PC to act as SAS talking to PG server on above server, which is running fine, but client is worried that some other Windows update might suddenly render that SAS unusable, hence me suggesting a Mac mini...
I did manage to get everything installed and up & running (even though I had to 'sign' everything on the Mac, but not on the PC), but when they started testing, it wouldn't send email to the cloud Office 365 mail server which used TLS & trying to look in to it, I thought was an issue with the version of Java it was running (JDK 6).
So I have been trying to set it up with Java 7 Update 80 instead as I thought that would be highest version Servoy 7.x might like.
I installed Servoy first as just the 'Application Server service' but when this wouldn't work, I thought I'd install Developer as well to try & see what might be wrong.
TL;DR, basically when SAS starts, it fails saying it can't open Repository database or Windows Postgres Server, even though PGAdmin, Postico & Servoy Developer can all connect to all DB's on that server from Mac & the other PC SAS also can.
When I try to use server 'name' in servoy.properties file, I get this error
(same without the '.proconferences.local' bit)
If I try with it's actual IP address I get the same thing
I also tried removing Java 7 & installing latest Java 8, same problem!
(& as stated, Developer that is using same servoy.properties file launches and can access all DB's without a problem)
There is probably something in the above error messages that someone far more knowledgable about Java than myself will see and know what the issue is, but I am stumped & have been trying to 'tweak' things for days to get it to work & it is driving me mad
Any help would be greatly appreciated (& please don't suggest using another PC or upgrading to a newer version of Servoy which is not possible for them currently)
Thanks
Rafi
couldn't quite work out best section for this post, so settled on here...
I am trying to set up a Mac mini [macOS High Sierra 10.13.6] to act as a Servoy Application Server (SAS) for a client who is 'stuck' on Servoy version 7.4.11 [-releaseNumber 2050]
Their solution is running in Smart Client within the DataSutra (DS) framework.
It was running on a Windows Server with a Postgres Database Server until some Microsoft Windows update was forced upon the server causing SAS to stop working (well actually it just constantly generated loads of networking errors.
So I then set up a stand alone Windows PC to act as SAS talking to PG server on above server, which is running fine, but client is worried that some other Windows update might suddenly render that SAS unusable, hence me suggesting a Mac mini...
I did manage to get everything installed and up & running (even though I had to 'sign' everything on the Mac, but not on the PC), but when they started testing, it wouldn't send email to the cloud Office 365 mail server which used TLS & trying to look in to it, I thought was an issue with the version of Java it was running (JDK 6).
So I have been trying to set it up with Java 7 Update 80 instead as I thought that would be highest version Servoy 7.x might like.
I installed Servoy first as just the 'Application Server service' but when this wouldn't work, I thought I'd install Developer as well to try & see what might be wrong.
TL;DR, basically when SAS starts, it fails saying it can't open Repository database or Windows Postgres Server, even though PGAdmin, Postico & Servoy Developer can all connect to all DB's on that server from Mac & the other PC SAS also can.
When I try to use server 'name' in servoy.properties file, I get this error
- Code: Select all
2021-04-08 16:47:16,056 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:810)
at com.servoy.j2db.server.Za.Za.<init>(Za.java:972)
at com.servoy.j2db.server.Za.Za.<init>(Za.java:1068)
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:516)
at com.servoy.j2db.server.main.ApplicationServer.Za(ApplicationServer.java:226)
at com.servoy.j2db.server.main.Zob.start(Zob.java:38)
at com.servoy.j2db.server.main.ApplicationServer.main(ApplicationServer.java:104)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:238)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.postgresql.util.PSQLException: The connection attempt failed.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:272)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:51)
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:215)
at org.postgresql.Driver.makeConnection(Driver.java:404)
at org.postgresql.Driver.connect(Driver.java:272)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at com.servoy.j2db.datasource.Zp.createConnection(Zp.java:2)
at com.servoy.j2db.datasource.Ze.createConnection(Ze.java:3)
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:39)
at com.servoy.j2db.datasource.jmx.ManagedBasicPoolingDataSource.getConnection(ManagedBasicPoolingDataSource.java:24)
at com.servoy.j2db.server.Za.Zo.getRawConnection(Zo.java:360)
at com.servoy.j2db.server.Za.Zo.Zf(Zo.java:25)
at com.servoy.j2db.server.Za.Za.Zb(Za.java:1096)
... 12 more
Caused by: java.net.UnknownHostException: proconf-dc01.proconferences.local
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:178)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at org.postgresql.core.PGStream.<init>(PGStream.java:61)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144)
... 27 more
2021-04-08 16:47:16,072 ERROR [WrapperSimpleAppMain] com.servoy.j2db.util.Debug - Do note Servoy server does not start any database! [ ]
(same without the '.proconferences.local' bit)
If I try with it's actual IP address I get the same thing
- Code: Select all
2021-04-08 18:27:33,545 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:810)
at com.servoy.j2db.server.Za.Za.<init>(Za.java:972)
at com.servoy.j2db.server.Za.Za.<init>(Za.java:1068)
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:516)
at com.servoy.j2db.server.main.ApplicationServer.Za(ApplicationServer.java:226)
at com.servoy.j2db.server.main.Zob.start(Zob.java:38)
at com.servoy.j2db.server.main.ApplicationServer.main(ApplicationServer.java:104)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:238)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.postgresql.util.PSQLException: Connection to 192.168.1.4:5437 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:262)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:51)
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:215)
at org.postgresql.Driver.makeConnection(Driver.java:404)
at org.postgresql.Driver.connect(Driver.java:272)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at com.servoy.j2db.datasource.Zp.createConnection(Zp.java:2)
at com.servoy.j2db.datasource.Ze.createConnection(Ze.java:3)
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:39)
at com.servoy.j2db.datasource.jmx.ManagedBasicPoolingDataSource.getConnection(ManagedBasicPoolingDataSource.java:24)
at com.servoy.j2db.server.Za.Zo.getRawConnection(Zo.java:360)
at com.servoy.j2db.server.Za.Zo.Zf(Zo.java:25)
at com.servoy.j2db.server.Za.Za.Zb(Za.java:1096)
... 12 more
Caused by: java.net.ConnectException: Network is unreachable
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at org.postgresql.core.PGStream.<init>(PGStream.java:61)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144)
... 27 more
2021-04-08 18:27:33,558 ERROR [WrapperSimpleAppMain] com.servoy.j2db.util.Debug - Do note Servoy server does not start any database! [ ]
I also tried removing Java 7 & installing latest Java 8, same problem!
(& as stated, Developer that is using same servoy.properties file launches and can access all DB's without a problem)
There is probably something in the above error messages that someone far more knowledgable about Java than myself will see and know what the issue is, but I am stumped & have been trying to 'tweak' things for days to get it to work & it is driving me mad
Any help would be greatly appreciated (& please don't suggest using another PC or upgrading to a newer version of Servoy which is not possible for them currently)
Thanks
Rafi