How to install remotely on Linux Debian

[a.mariottini]

I have to install Servoy Server on a remote Debian machine.
I have ssh access to that machine so I can use the terminal etc.....
The remote machine has JDK 1.4 installed but not X11.
Locally I have access to a MacOS X machine or a Windows machine.
How can I install on Debian?

[Harjo]

You have to install locally on a debian(linux) machine with GUI using the installer.
Than copy the whole map of Servoy to your remote server.

(See also the server manuall)

[a.mariottini]

But I don't have a Linux box locally!
Is there any way to run setup without user interface?

[Harjo]

No, I don't think so!

[Jan Aleman]

There isn't at the moment. We hope to have a headless installer in the future but we do not have one at the moment. If you do not need sybase you can do a install on mac os x, remove the sybase_db directory, configure your db connections and copy the whole directory to the target linux box. If you do need to run sybase please contact support@servoy.com for a solution.

[a.mariottini]

Thank you for the tar file.
I have some problems. I tried to reply to your email but have no response.
This is the problem: I installed in /usr/local but whe I run servoy_server.sh I have this:

Loading servoy.properties from /usr/local/Servoy/servoy.properties
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.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
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

What is happening?

[Jan Aleman]

The database is not yet started. On linux you have to start it before you start servoy server. Instructions are in the server manual.

[a.mariottini]

Sorry but in the manual I found only this:

For the information needed to create, start, and stop a database service on Linux/Unix, check
the documentation for your operating system or refer to the man pages for your specific
vendor.

Could you give me some tips?

[Jan Aleman]

It looks like I was reading a newer (not yet released) version of the server doc. I can't find it in the current docs either. Here's how to start sybase on linux/unix systems if you run servoy server (and not developer)

Code: Select all

export LD_LIBRARY_PATH=/Applications/Servoy/sybase_db
export PATH=$PATH:PATHTOSERVOY/sybase_db
cd PATHTOSERVOY/
sybase_db/dbsrv9 @sybase_db/sybase.config


then start server

make sure to replace PATHTOSERVOY/ with the path where servoy is installed.

[a.mariottini]

What is LD_LIBRARY_PATH=/Applications/Servoy/sybase_db?
What is /Applications?
I'm on Linux not on Mac....

[Jan Aleman]

sorry, it should be the path to the servoy/sybase_db directory

[dealfirst]

I get that same message and when i try

sybase_db/dbsrv9 @sybase_db/sybase.config

i get

-bash: sybase_db/dbsrv9: cannot execute binary file

i think i have permissions wrong?

Bo

[dealfirst]

I installed the server on OSX and just moved the servoy file to my redhat enterprise 3 server colo'd.

i get the same error as above when i try and start ./servoy_server.sh
so i try and start dbserv9 and get this.

[root@localhost sybase_db]# file dbsrv9
dbsrv9: Mach-O executable powerPC

so does this mean i have to have another linux box set up with enterprise 3 on it. then i install servoy on to that box, then i can move over my databases and the servoy file to my box downtown?

when my servoy server is downtown on my box what happens if i need to make some quick changes to the layout or add a field or something? do i have to shut down the server, pull my servoy folder back to my machine locally, then start up developer, then move the folder back to the server downtown and then start up the server again?

please help i am going nuts.

[Odysseus]

when my servoy server is downtown on my box what happens if i need to make some quick changes to the layout or add a field or something? do i have to shut down the server, pull my servoy folder back to my machine locally, then start up developer, then move the folder back to the server downtown and then start up the server again?

When servoy server is running on your machine "downtown", you can connect to it using http://downtown_machines_ip:8080/servoy-admin/

In the administration pages you can practicly do anything you need except create new dbconnections. So a quick change to a layout or modification to a backend db ( as long as the connection is already defined) is very simple.

Regarding your other problems I can only say that we are running a SUSE 9.1 machine remotely that we can control through VNC. I guess this is no option for you ?

We use it to create new dbconnections in the Servoy Developper installed on the remote machine and to install the updates.

HTH