Can't Start Servoy Server

Classic Servoy
1

I have Servoy Developer 2.2.5 installed on Win XP with Java 1.5

Previoulsy I had no trouble starting Server with servoy_server.bat
Now I get this error message, and it won’t start. I’ve tried doing a clean install into a new folder, same prob.

Developer works fine.
I shut down Developer and the Sybase server before trying to launch Servoy Server

Loading servoy.properties from C:\Program Files\Servoy225\servoy.properties
Loading - Done
Server: repository_server, url=jdbc:sybase:Tds:localhost:2638?ServiceName=servoy_repository&CHARSET=utf8
driver=com.sybase.jdbc2.jdbc.SybDriver@a61164
url=jdbc:sybase:Tds:localhost:2638?ServiceName=servoy_repository&CHARSET=utf8
connectionProperties={user=DBA, password=SQL}
Exception in thread "main" org.apache.commons.dbcp.DbcpException: java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect
        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.int(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: connect
        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.<init>(SybConnection.java:174)
        at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:126)
        at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:179)
        at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:83)
        ... 12 more

Any ideas?
There’s no entries in the Servoy or Sybase_db logfiles.

2

Possibly related, I just tried to open user_data.db from Sybase Central, and I get this

[Sybase][ODBC Driver][Adaptive Server Anywhere]Connection error: NamedPipes requires a server name

	Error code=-832

	SQL state=08001



Connection parameters:

	User=dba

	Password=***

	LINKS=all

	DBF=C:\Program Files\Servoy\database\user_data.db

Same thing happens with any of my DBs. What’s a named pipe? What might I have done to see this? I haven’t seen it before now, I can usually open any sybase DB with Sybase Central.

3

If sybase does not launch the first place to look is the sybase logfile in the sybase_db directory. It will tell you what’s wrong

4

Hi Jan,

I did look at both the /Sybase_db/sybase_log.txt and the Servoy .log.txt files. There are no entries in either, as I mentioned above. I only see log entries in these files when I launch developer.

The only clues I can find are in my first post.

BTW, I see the passwords in plain text in the log files. Is this a bad thing?

5

I missed the bit where you say you are starting server. Before you start server make sure Sybase runs. The server docs explain how to make it a service for example to make this automatic, alternatively add it to your bat file.

6

Thanks for your patience Jan. What I am trying to achieve is to install Servoy Offline and a solution onto a test machine, and then automate the upload of a new version to that machine. In a previous communication, you described how to do this, ie

  1. Stop Servoy Offline
  2. Start server (servoy_server.bat)
  3. upload new version automated using HTTP requests
  4. stop server

If I understand correctly, I’ll need to have ASA set up as a service before I can do step 2.

I had installed Developer, but without checking the Windows Service option during install.

I’m really looking for a 1 step installation of Servoy + Solution for my offline clients. Possible?

7

If you run offline and don’t stop ASA the server should work fine.

8

Hi Guys,

It’s true, I can run Offline, then exit it without stopping the server, and start Sybase Central to examine the DB.

However, previously I had no trouble connecting to the DB directly from Sybase Central, even if the server was stopped. The NamedPipes error is a new thing. What might I have done to be seeing this?

T.