Can't connect to database after moving to Linux

Classic Servoy
1

We built a solution in Servoy 3.0 under Windows and have been running it successfully for months. I have copied the Servoy folder to a new Ubuntu Linux machine and now when we launch Servoy Developer, it can’t connect to the database. I have changed the paths to the database files in the sybase.config file. Upon launching Servoy Developer we get the error:

Can’t connect to the repository server specified in the application preferences
org.apache.commons.dbcp.DbcpException:
java.sql.SQLException: JZOOL: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).

If I go to Edit > Preferences > DB Servers, then double lick on log_server and click OK in the window that comes up, I get:

Cannot setup server
org.apache.commons.dbcp.DbcpException:
java.sql.SQLException: JZOOL: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).

To prove that Servoy Developer will run on this machine, I downloaded and installed version 3.1 and it connects to the sample solutions perfectly.

Can anyone help?

2

I assume you replaced the sybase_db directory with the linux version? And did you adjust your servoy.properties if you are autolaunching dbsrv at developer launch?

3

Ok, I replaced the sybase_db folder with the one from the Linux install and changed the paths to the db files in sybase.config as needed. Then I edited the servoy.properties file to reference dbsrv9 instead of dbsrv9.exe. Now when I try to launch Servoy developer I get a different error:

Can’t connect to the repository server specified in the application preferences
org.apache.commons.dbcp.DbcpException:
java.sql.SQLException: JZOO6: Caught IOException:
java.net.ConnectException: Conection refused

What have I missed?

4

That error means sybase hasn’t started so there has to be something wrong with that still.

-What’s the contents of your sybase.config file
-what exactly is now your startup line in your servoy.properties?
-There has to be an error about sybase not starting earlier in your logs to OR in the sybase logfile.

5

Here is the sybase.config file:

-ti 0 -x tcpip{dobroadcast=no} -qs -qw -o sybase_db/sybase_log.txt
database/servoy_repository.db
database/log_data.db
database/contacts.db
database/pdf_forms.db
database/holders.db
database/updates.db

This is the only line in the servoy.propertiesb file that refers to dbsrv9:

nativeStartupLauncher=sybase_db\dbsrv9|@sybase_db\sybase.config

This is the last part of the servoy_log.txt file:

2007-07-30 12:11:49,904 ERROR [TaskExecuter[1]] com.servoy.j2db.persistence.Server - Final get connection failure for server contacts in 1 times
2007-07-30 12:11:49,904 ERROR [TaskExecuter[1]] com.servoy.j2db.util.Debug - Throwable
org.apache.commons.dbcp.DbcpException: java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:85)
at com.servoy.j2db.persistence.datasource.n.createConnection(Unknown Source)
at com.servoy.j2db.persistence.datasource.r.makeObject(Unknown Source)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:110)
at com.servoy.j2db.persistence.datasource.i.getConnection(Unknown Source)
at com.servoy.j2db.persistence.Server.getConnection(Unknown Source)
at com.servoy.j2db.persistence.Server.testConnection(Unknown Source)
at com.servoy.j2db.develop.q$2.run(Unknown Source)
at com.servoy.j2db.util.an.run(Unknown Source)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused
at com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:487)
at com.sybase.jdbc2.jdbc.ErrorMessage.raiseErrorCheckDead(ErrorMessage.java:723)
at com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:3071)
at com.sybase.jdbc2.tds.Tds.login(Tds.java:394)
at com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybConnection.java:218)
at com.sybase.jdbc2.jdbc.SybConnection.regularConnect(SybConnection.java:195)
at com.sybase.jdbc2.jdbc.SybConnection.(SybConnection.java:174)
at com.sybase.jdbc2.jdbc.SybConnection.(SybConnection.java:126)
at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:179)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:83)
… 10 more

This is the sybase_log.txt file. There are no entries from today, even though I have tried starting Servoy developer several times toady.

I. 07/26 15:36:56. Running on Linux 2.6.20-16-generic #2 SMP Thu Jun 7 20:19:32 UTC 2007
I. 07/26 15:36:56. Database server started at Thu Jul 26 2007 15:36
I. 07/26 15:36:56. Trying to start SharedMemory link …
I. 07/26 15:36:56. SharedMemory link started successfully
I. 07/26 15:36:56. Trying to start TCPIP link …
I. 07/26 15:36:56. Starting on port 2638
I. 07/26 15:36:56. TCPIP link started successfully
I. 07/26 15:36:56. Now accepting requests
I. 07/26 15:38:17. Connection terminated abnormally
I. 07/27 09:54:47. Running on Linux 2.6.20-16-generic #2 SMP Thu Jun 7 20:19:32 UTC 2007
I. 07/27 09:54:49. Database server started at Fri Jul 27 2007 09:54
I. 07/27 09:54:49. Trying to start SharedMemory link …
I. 07/27 09:54:50. SharedMemory link started successfully
I. 07/27 09:54:50. Trying to start TCPIP link …
I. 07/27 09:54:50. Starting on port 2638
I. 07/27 09:54:50. TCPIP link started successfully
I. 07/27 09:54:50. Now accepting requests
I. 07/27 09:56:03. Connection terminated abnormally
I. 07/27 09:59:31. Connection terminated abnormally

6

adamk:
This is the only line in the servoy.propertiesb file that refers to dbsrv9:

nativeStartupLauncher=sybase_db\dbsrv9|@sybase_db\sybase.config

[/quote]

That doesn’t look right to me. I don’t see the path variable. Have a look at that line when you do a clean linux install and copy that over.

7

That fixed it. Thanks, Jan!