Mac OS X Intel Install

Classic Servoy
1

I just upgraded to an Intel Mac running Leopard (OS X 10.5).

I downloaded and Installed the latest version (3.5.2 - Build 515). It works beautifully.

I downloaded Sybase 10 and tried to create a new database with Sybase Central. It does not connect to the Servoy Repository.

Can anyone help?

2

Hi Tom,

Are you using the latest Sybase Central ?
Also did you read this thread?

Hope this helps.

3

ROCLASI:
Hi Tom,

Are you using the latest Sybase Central ?
Also did you read this thread?

Hope this helps.

Thanks for the quick reply.

SQLAnywhere10 version 10.0.1.3415
Sybase Central version 5.0.0.3278

I read the thread and could not make anything work

I must admit to being Terminally Challenged, so the simple stuff is best for me.

4

Hi Tom,

Just to make sure, check with Activity Monitor (in /Applications/Utilities/) what process is running when you have Servoy running.
It is dbsrv9 or dbsrv10.

5

ROCLASI:
Hi Tom,

Just to make sure, check with Activity Monitor (in /Applications/Utilities/) what process is running when you have Servoy running.
It is dbsrv9 or dbsrv10.

It is dbsrv10

6

Do you use the correct version of Sybase Central?

Have you tried to stop and restart the repository?

I have created 10 db10 databases on my macintel yesterday without any issues!

7

Okay, you said you upgraded to this Intel mac. So you used Sybase Central before?
Also can you tell me what error/message Sybase Central gives? And are there any errors or messages in the sybase log ({servoy folder}/sybase_db/sybase_log.txt

8

Marcel, he says he uses Sybase Central version 5.0.0.3278.
Can you check what version you use. I can’t check since I don’t have an Intel mac handy.

9

that is the same version as I have

10

I really appreciate all the responses

ROCLASI:
Okay, you said you upgraded to this Intel mac. So you used Sybase Central before?
Also can you tell me what error/message Sybase Central gives? And are there any errors or messages in the sybase log ({servoy folder}/sybase_db/sybase_log.txt

Here is the Sybase Central Error

[Sybase][ODBC Driver][SQL Anywhere]Unable to start database server
Error code=-80
SQL state=08001

Connection parameters:
User=DBA
Password=***
ENG=_sc850522408
START=dbeng10 -c 10M -gp32768 -qi
DBN=utility_db

Here is the sybase_log

I. 11/29 05:25:25. Running Darwin 9.1.0 Darwin Kernel Version 9.1.0: Wed Oct 31 17:46:22 PDT 2007; root:xnu-1228.0.2~1/RELEASE_I386 on X86 (X86_64)
I. 11/29 05:25:25. Server built for X86 processor architecture
I. 11/29 05:25:26. Database server started at Thu Nov 29 2007 05:25
I. 11/29 05:25:26. Trying to start SharedMemory link …
I. 11/29 05:25:26. SharedMemory link started successfully
I. 11/29 05:25:26. Trying to start TCPIP link …
I. 11/29 05:25:26. Starting on port 2638
I. 11/29 05:25:26. TCPIP link started successfully
I. 11/29 05:25:26. Now accepting requests
I. 11/29 05:26:23. Connection terminated abnormally
I. 11/29 05:26:23. Disconnected TCPIP client’s AppInfo: HOST=tommy-gills-imac.local
I. 11/29 05:34:19. Connection terminated abnormally
I. 11/29 05:34:19. Disconnected TCPIP client’s AppInfo: HOST=tommy-gills-imac.local
I. 11/29 05:36:11. Running Darwin 9.1.0 Darwin Kernel Version 9.1.0: Wed Oct 31 17:46:22 PDT 2007; root:xnu-1228.0.2~1/RELEASE_I386 on X86 (X86_64)
I. 11/29 05:36:11. Server built for X86 processor architecture
I. 11/29 05:36:14. Database server started at Thu Nov 29 2007 05:36
I. 11/29 05:36:14. Trying to start SharedMemory link …
I. 11/29 05:36:14. SharedMemory link started successfully
I. 11/29 05:36:14. Trying to start TCPIP link …
I. 11/29 05:36:14. Starting on port 2638
I. 11/29 05:36:14. TCPIP link started successfully
I. 11/29 05:36:14. Now accepting requests
I. 11/29 06:06:44. Connection terminated abnormally
I. 11/29 06:06:44. Disconnected TCPIP client’s AppInfo: HOST=tommy-gills-imac.local
I. 11/29 06:57:09. Connection terminated abnormally
I. 11/29 06:57:09. Disconnected TCPIP client’s AppInfo: HOST=tommy-gills-imac.local
I. 11/29 07:41:56. Connection terminated abnormally
I. 11/29 07:41:56. Disconnected TCPIP client’s AppInfo: HOST=tommy-gills-imac.local

I have in the past used Sybase Central with SQLAnywhere9 and had good success.

Thanks for all the help

11

Are you connecting to the database file or are you connecting to the repository server. When Servoy’s Instance of Sybase is running you can’t open the same database file with Sybase Central. You need to connect to dbsrv10 then.

12

ROCLASI:
Are you connecting to the database file or are you connecting to the repository server. When Servoy’s Instance of Sybase is running you can’t open the same database file with Sybase Central. You need to connect to dbsrv10 then.

What I am trying to do is to create a new database and I keep getting the same error.

13

I still cannot get Sybase Central to create a new database.

I tried a different tact. I exported a working Solution from my old computer put it along with it’s database and log on my Intel machine.

When I attempt make a connection to the database I get the following error.

Cannot setup server

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

What does this mean?

14

Tom,

It means that you can connect to a running sybase but that the username/password was wrong.

Note that a difference between sybase 9 and 10 is that since sybase 10 passwords are case sensitive.

Rob

15

… and I think the username as well …

16

Intel-based Mac OSX
Servoy 3.5.3
ASA 10

Fresh install. Developer starts up just fine. Sybase Central 10 works fine.
But when I run servoy_server.sh it just drops me back on the command line - no output, dbsrv10 doesn’t start, nothing. Any ideas?

sybase_log.txt:

Running Darwin 9.1.0 Darwin Kernel Version 9.1.0: Wed Oct 31 17:46:22 PDT 2007; root:xnu-1228.0.2~1/RELEASE_I386 on X86
I. 02/06 14:28:24. Server built for X86 processor architecture
I. 02/06 14:28:25. Database server started at Wed Feb 06 2008 14:28
I. 02/06 14:28:25. Trying to start SharedMemory link ...
I. 02/06 14:28:25.     SharedMemory link started successfully
I. 02/06 14:28:25. Trying to start TCPIP link ...
I. 02/06 14:28:25. Starting on port 2638
I. 02/06 14:28:25.     TCPIP link started successfully
I. 02/06 14:28:25. Now accepting requests
I. 02/06 14:29:26. Connection terminated abnormally
I. 02/06 14:29:26. Disconnected TCPIP client's AppInfo: HOST=SmartTrash.local

server.log:

0 [main] INFO com.servoy.j2db.util.Debug  - Loading servoy.properties from /Applications/Servoy/servoy.properties
808 [main] INFO com.servoy.j2db.util.Debug  - Loading - Done
Exception in thread "main" 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.checkIfTableExistsInDatabase(Unknown Source)
	at com.servoy.j2db.persistence.Repository.for(Unknown Source)
	at com.servoy.j2db.persistence.Repository.<init>(Unknown Source)
	at com.servoy.j2db.persistence.Repository.<init>(Unknown Source)
	at com.servoy.j2db.persistence.Server.getRepository(Unknown Source)
	at com.servoy.j2db.server.ApplicationServer.main(Unknown Source)
Caused by: java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused
	at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)
	at com.sybase.jdbc3.jdbc.ErrorMessage.raiseErrorCheckDead(Unknown Source)
	at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
	at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
	at com.sybase.jdbc3.tds.Tds.login(Unknown Source)
	at com.sybase.jdbc3.jdbc.SybConnection.a(Unknown Source)
	at com.sybase.jdbc3.jdbc.SybConnection.a(Unknown Source)
	at com.sybase.jdbc3.jdbc.SybConnection.<init>(Unknown Source)
	at com.sybase.jdbc3.jdbc.SybConnection.<init>(Unknown Source)
	at com.sybase.jdbc3.jdbc.SybDriver.connect(Unknown Source)
	at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:83)
	... 12 more