How to run two Servoy Server with Sybase on one Hardware

Classic Servoy
1

Hello,

Servoy 4.1.7 with Sybase 10

Tying to get two Servoy Server running on one Windows Server 2000.
Made two Servoy Installations Servoy_A and Servoy_B.
Point them to different http Ports. 8080 and 8081
Setup different Database Servers.
But the second starting Server shows the repository, tables and content of the first started one, even the developers and also the servoy-admin shows different URL´s.

Any idea what going wrong?

Thanks
Thomas

2

and did you change the database connections on one of the servers to point to the second database instance?

Paul

3

Hello Paul,

yes …
Server_A: jdbc:sybase:Tds:localhost:2638?ServiceName=servoy_repository&CHARSET=utf8
“servoy_repository”
Server_B: jdbc:sybase:Tds:localhost:2638?ServiceName=servoy_repository_f&CHARSET=utf8
“servoy_repository_f”

and so one the other Applications Database Servers.

Thomas

4

these url’s use the same port numbers, so if you installed two different database engines they will be running on different port numbers and your jdbc urls should reflect that.

Paul

5

yes they have same port numbers, but different Servicenames …
so they need different Port numbers ?

Where to set them up?

Thomas

6

Hi Thomas, no, you can use just one Sybase database instance, with one portnumber, and two different repository databases

the servername in Servoy on BOTH has to be: repository_server

in my case:

server.1.serverName=repository_server

one pointing to the database: servoy_repository

server.1.URL=jdbc\:sybase\:Tds\:localhost\:2638?ServiceName\=servoy_repository&CHARSET\=utf8

and one pointing to the database: servoy_repository_f

server.1.URL=jdbc\:sybase\:Tds\:localhost\:2638?ServiceName\=servoy_repository_f&CHARSET\=utf8

that should work…

7

Hello Harjo,

yes that´s what I thought.
Pointing the databases servoy_repository exactly this way should work, but it looks like the repositories get mixed.

At the servoy-admin/dbservers

ServoyServer_A
http://localhost:8080/servoy-admin/dbservers
jdbc:sybase:Tds:localhost:2638?ServiceName=servoy_repository&CHARSET=utf8

and

ServoyServer_B
http://localhost:8081/servoy-admin/dbservers
jdbc:sybase:Tds:localhost:2638?ServiceName=servoy_repository_f&CHARSET=utf8

are showing the right setting connections with the Server status online.

But first starting ServoyServer_A and then ServoyServer_B
starting a Client to B with http://localhost:8081/servoy-client it catchs the RepositoryA

First starting ServoyServer_B and then ServoyServer_A
starting a Client to A with http://localhost:8080/servoy-client it catchs the RepositoryB

Any ideas, what´s going on?
Thomas

8

Can you post the entire config of your servers on the Servoy side, because there must be something amiss.

Paul

9

As you have 2 sybase.config files, I think you’re runnign 2 sybase database engines

If you didn’t take care of running them on a different port and making sure in Servoy that you connect to the proper database on the right port, then it is pretty obvious that it won’t work.

Paul

Hello Paul,

thank you, checking the config files.
So I changed the installation this way, just one sybase database engine is running.
Looks like it running fine now.

Thank you very much

Thomas