Bundled Sybase SQL Anyw. 11 not starting on Debian 7

Questions and answers regarding general SQL and backend databases

Bundled Sybase SQL Anyw. 11 not starting on Debian 7

Postby tgs » Wed Dec 04, 2013 12:38 pm

Hi,
I have installed Servoy 5.1 with the bundled Sybase SQL Anywhere 11 on a Debian 7 (64 bit) Server with Java 1.7.0_45.
My customers solution is still on Servoy 5.2 and the data in Sybase SQL. For that I updated Servoy to 5.2.16 and would like to use the Sybase SQL Anywhere 11 Server (Servoy/application_server/sybase_db, ../database).
But I don't get the Sybase Server running!?
To start Sybase SQL I use this script:
Code: Select all
#!/bin/sh

cd /home/user/servoy/application_server; export LD_LIBRARY_PATH=/home/user/servoy/application_server/sybase_db; /user/servoy/application_server/sybase_db/dbsrv11 -n dbsrv11_88 @/home/user/servoy/application_server/sybase.config &


I always get the error: ..sybase_db/dbsrv11: not found

The path is definitely correct and the "dbsrv11" exists in the direction.
Code: Select all
~/servoy/application_server/sybase_db$ ls -la
total 22476
drwxr-xr-x  4 admin admin    4096 Dec  2 16:46 .
drwxr-xr-x 13 admin admin    4096 Dec  2 19:32 ..
drwxr-xr-x  3 admin admin    4096 Dec  2 16:46 charsets
-rwxr-xr-x  1 admin admin  336532 Feb  4  2010 dbbackup
-rwxr-xr-x  1 admin admin   58040 Feb  4  2010 dbeng11
-rw-r--r--  1 admin admin     503 Feb  4  2010 dbeng11.lic
-rwxr-xr-x  1 admin admin  340868 Feb  4  2010 dbinit
-rw-r--r--  1 admin admin  364042 Feb  4  2010 dblgen11.res
-rwxr-xr-x  1 admin admin  364460 Feb  4  2010 dblocate
-rwxr-xr-x  1 admin admin  348024 Feb  4  2010 dbspawn
-rwxr-xr-x  1 admin admin   58040 Feb  4  2010 dbsrv11
-rw-r--r--  1 admin admin     502 Feb  4  2010 dbsrv11.lic
-rwxr-xr-x  1 admin admin  373716 Feb  4  2010 dbstop
-rwxr-xr-x  1 admin admin  337984 Feb  4  2010 dbunload
-rwxr-xr-x  1 admin admin  336500 Feb  4  2010 dbvalid
-rw-r--r--  1 admin admin 1311592 Feb  4  2010 libdbicu11_r.so
-rw-r--r--  1 admin admin 4205440 Feb  4  2010 libdbicudt11.so
-rw-r--r--  1 admin admin  998172 Feb  4  2010 libdblib11_r.so
-rw-r--r--  1 admin admin  973852 Feb  4  2010 libdblib11.so
-rw-r--r--  1 admin admin  728180 Feb  4  2010 libdbscript11_r.so
-rw-r--r--  1 admin admin 9860300 Feb  4  2010 libdbserv11_r.so
-rw-r--r--  1 admin admin   80568 Feb  4  2010 libdbtasks11_r.so
-rw-r--r--  1 admin admin   72140 Feb  4  2010 libdbtasks11.so
-rw-r--r--  1 admin admin 1577960 Feb  4  2010 libdbtool11_r.so
drwxr-xr-x  3 admin admin    4096 Dec  2 16:46 scripts
-rw-r--r--  1 admin admin  217121 Feb  4  2010 sqlany.cvf
-rw-r--r--  1 admin admin     233 Feb  4  2010 sybase.config


What could be wrong and how to fix this?

Regards
Thomas
Thomas Schnaus
SAN Developer
yomotec GmbH
User avatar
tgs
 
Posts: 886
Joined: Wed Oct 04, 2006 12:05 pm
Location: Germany

Re: Bundled Sybase SQL Anyw. 11 not starting on Debian 7

Postby tgs » Wed Dec 11, 2013 2:06 pm

If I execute "~$ file dbsrv11" I get the output:
Code: Select all
dbsrv11: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), dynamically linked (uses shared libs), for GNU/Linux 2.2.5, stripped


This tells me that the bundled SQL Anywhere 11 is a 32 bit installation and won't run on the 64 bit Debian 7, or?

Is there perhaps a way to get this running because of the Licenses?
I won't install a stand alone SQL Anywhere 64 bit version and buy licenses. Also a migration to PostgreSQL is not an option, because of the effort and costs.

Any help is very appreciated. Regards Thomas
Thomas Schnaus
SAN Developer
yomotec GmbH
User avatar
tgs
 
Posts: 886
Joined: Wed Oct 04, 2006 12:05 pm
Location: Germany

Re: Bundled Sybase SQL Anyw. 11 not starting on Debian 7

Postby Jan Aleman » Thu Dec 12, 2013 11:05 am

if migrating is not an option perhaps install it on a different os that still works with that combo?
Jan Aleman
Servoy
Jan Aleman
 
Posts: 2083
Joined: Wed Apr 23, 2003 9:49 pm
Location: Planet Earth

Re: Bundled Sybase SQL Anyw. 11 not starting on Debian 7

Postby tgs » Fri Dec 13, 2013 11:00 pm

Hello Jan,
thank you for the reply.

I could fix the problem by installing an i386 architecture and the 32bit libraries on the 64bit Debian 7.
The Servoy and Sybase Server now running.

Thomas
Thomas Schnaus
SAN Developer
yomotec GmbH
User avatar
tgs
 
Posts: 886
Joined: Wed Oct 04, 2006 12:05 pm
Location: Germany


Return to SQL Databases

Who is online

Users browsing this forum: No registered users and 7 guests