Sybase on linux-distro matrix

From SybaseWiki
Revision as of 16:51, 4 June 2006 by Luc (Talk | contribs) (→‎Redhat x86-32 version)

Jump to: navigation, search

Adaptive Server Enterprice (ASE)

Always configure more shared-memory before starting srvbuild(res). For example: 

[root@saito]# echo 335544320 > /proc/sys/kernel/shmmax
[sybase@saito]$ cat /proc/sys/kernel/shmmax 
335544320

To make this permanent after reboot's, append to /etc/sysctl.conf Debian/Ubuntu: 

############# Sys-V shared mem:
#/proc/sys/kernel/shmmax
kernel/shmmax=335544320

Redhat/CentOS: 

############# Sys-V shared mem:
#/proc/sys/kernel/shmmax
kernel.shmmax = 335544320

Version 12.5.x (x86-32)

Used version 12.5.3-ebf12339

Redhat EL-Linux-4.0

(CentOS-4.x and Xos-Linux-4 use binaries similar to Redhat EL-Linux-4 )

Fedora Core-5

First tests seemed problematic because of the new libc version of core5

Debian 3.1 (sarge)

Ubuntu 6.06(dapper)

Expect test-results here in a few days.

Version 12.5.x (x86-64)

Software not yet delivered.


Version 15.0.x (x86-32)

Used version 15.0.0-ebf13194

Create a ase1500.rs 

SYBASE=/opt/sybase
#
SYBROOT=${SYBASE}
SYBASE_ASE=ASE-15_0
SYBASE_OCS=OCS-15_0
INCLUDE=${SYBASE}/${SYBASE_OCS}/include":$INCLUDE
LIB=${SYBASE}/${SYBASE_OCS}/lib:$LIB
SYBASE_JRE=${SYBASE}/shared/jre142
SYBASE_SYSAM=SYSAM-2_0
SYBASE_UA=${SYBASE}/ua
SCROOT=${SYBASE}/shared/sybcentral43
SYBASE_WS=WS-15_0
export SYBASE SYBROOT SYBASE_ASE SYBASE_OCS INCLUDE LIB SYBASE_JRE SYBASE_SYSAM SYBASE_UA SCROOT SYBASE_WS
#
PATH=${SYBASE}/ua/bin:$PATH
PATH=/opt/sybase/ASE-15_0/jobscheduler/bin:${SYBASE}/${SYBASE_ASE}/bin:${SYBASE}/${SYBASE_OCS}/bin:${SYBASE}/RPL-15_0/bin:$PATH
export PATH
#
LD_LIBRARY_PATH=${SYBASE}/${SYBASE_ASE}/lib:${SYBASE}/{SYBASE_OCS}/lib:${SYBASE}/{SYBASE_OCS}/lib3p:$LD_LIBRARY_PATH
LD_LIBRARY_PATH=${SYBASE}/DataAccess/ODBC/lib:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH

Redhat EL-Linux-4.0

Redhat x86-32 version

Choose "server install".

Some caveat's: Without the compat-rpm's, dataserver does not work. 

[sybase@avondster ~]$ dataserver -v
dataserver: error while loading shared libraries: libstdc++.so.5: cannot open shared object file: No such file or directory

This is the problem: 

[sybase@avondster ~]$ ldd ~/ASE-15_0/bin/dataserver
       libdl.so.2 => /lib/libdl.so.2 (0x006c4000)
       librt.so.1 => /lib/tls/librt.so.1 (0x00c86000)
       libm.so.6 => /lib/tls/libm.so.6 (0x006ca000)
       libnsl.so.1 => /lib/libnsl.so.1 (0x0089d000)
 ->    libstdc++.so.5 => not found                            <-
       libpam.so.0 => /lib/libpam.so.0 (0x00701000)
       libpthread.so.0 => /lib/tls/libpthread.so.0 (0x00111000)
       libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x00a40000)
       libc.so.6 => /lib/tls/libc.so.6 (0x00598000)
       /lib/ld-linux.so.2 (0x0057f000)
       libaudit.so.0 => /lib/libaudit.so.0 (0x00745000)

Redhat x86-64 version

works out of the box, when you choose a server install and also select the compat-packages. 

[sybase@avondster ~]$ rpm -qa|grep compat
compat-openldap-2.1.30-4
compat-db-4.1.25-9
compat-libgcc-296-2.96-132.7.2
compat-libstdc++-296-2.96-132.7.2
compat-libstdc++-33-3.2.3-47.3
compat-libcom_err-1.0-5

Because of the mixed-library (32 and 64 bits) architecture of this distro, there are no problems with the 32-bit sybase binaries. 

[sybase@avondster LUCSY03P]$ uname -a
Linux avondster 2.6.9-34.ELsmp #1 SMP Thu Mar 9 06:23:23 GMT 2006 x86_64 x86_64 x86_64 GNU/Linux

[sybase@avondster LUCSY03P]$ file ~/ASE-15_0/bin/dataserver
/opt/sybase/ASE-15_0/bin/dataserver: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), for GNU/Linux 2.2.5, 
dynamically linked (uses shared libs), not stripped

[sybase@avondster LUCSY03P]$ ldd ~/ASE-15_0/bin/dataserver
       linux-gate.so.1 =>  (0xffffe000)
       libdl.so.2 => /lib/libdl.so.2 (0xf7fcc000)
       librt.so.1 => /lib/tls/librt.so.1 (0xf7fb8000)
       libm.so.6 => /lib/tls/libm.so.6 (0xf7f95000)
       libnsl.so.1 => /lib/libnsl.so.1 (0xf7f7f000)
       libstdc++.so.5 => /usr/lib/libstdc++.so.5 (0xf7ec6000)
       libpam.so.0 => /lib/libpam.so.0 (0xf7ebe000)
       libpthread.so.0 => /lib/tls/libpthread.so.0 (0xf7eab000)
       libgcc_s.so.1 => /lib/libgcc_s.so.1 (0xf7ea3000)
       libc.so.6 => /lib/tls/libc.so.6 (0xf7d79000)
       /lib/ld-linux.so.2 (0xf7fe9000)
       libaudit.so.0 => /lib/libaudit.so.0 (0xf7d6b000)

[sybase@avondster LUCSY03P]$ ls -ald /lib*
drwxr-xr-x  10 root root 4096 Jun  4 14:12 /lib
drwxr-xr-x   6 root root 4096 Jun  4 14:10 /lib64

Debian 3.1 (sarge)

Ubuntu 6.06(dapper)

Ubuntu x86-32 version

works out of the box. Just give the box some extra System-V shared memory before starting srvbuild(res). 

sybase@saito:~$ file /opt/sybase/ASE-15_0/bin/dataserver
/opt/sybase/ASE-15_0/bin/dataserver: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), for GNU/Linux 2.2.5, dynamically linked (uses shared libs), for GNU/Linux 2.2.5, not stripped

sybase@saito:~$ ldd /opt/sybase/ASE-15_0/bin/dataserver
       linux-gate.so.1 =>  (0xffffe000)
       libdl.so.2 => /lib/tls/i686/cmov/libdl.so.2 (0xb7f07000)
       librt.so.1 => /lib/tls/i686/cmov/librt.so.1 (0xb7efe000)
       libm.so.6 => /lib/tls/i686/cmov/libm.so.6 (0xb7edc000)
       libnsl.so.1 => /lib/tls/i686/cmov/libnsl.so.1 (0xb7ec7000)
       libstdc++.so.5 => /usr/lib/libstdc++.so.5 (0xb7e0d000)
       libpam.so.0 => /lib/libpam.so.0 (0xb7e05000)
       libpthread.so.0 => /lib/tls/i686/cmov/libpthread.so.0 (0xb7df3000)
       libgcc_s.so.1 => /lib/libgcc_s.so.1 (0xb7de8000)
       libc.so.6 => /lib/tls/i686/cmov/libc.so.6 (0xb7cb9000)
       /lib/ld-linux.so.2 (0xb7f19000)


Ubuntu x86-64 version

Does not work at all. This is probably because the Ubuntu/Debian distribution is a pure-64 distribution. The 32-bit library's are not there at all.

It looks like this: 

sybase@hercules:~$ which dataserver
/opt/sybase/ASE-15_0/bin/dataserver

sybase@hercules:~$ file /opt/sybase/ASE-15_0/bin/dataserver
/opt/sybase/ASE-15_0/bin/dataserver: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), for GNU/Linux 2.2.5, dynamically linked (uses shared libs), for GNU/Linux 2.2.5, not stripped

sybase@hercules:~$ ldd /opt/sybase/ASE-15_0/bin/dataserver
/usr/bin/ldd: line 171: /lib/ld-linux.so.2: No such file or directory ldd: /lib/ld-linux.so.2 exited with unknown exit code (127)

sybase@hercules:~$ /opt/sybase/ASE-15_0/bin/dataserver -v
-su: /opt/sybase/ASE-15_0/bin/dataserver: No such file or directory

Version 15.0.x (x86-64)

Software not yet delivered.

ReplicationServer

Version 12.6.x (x86-32)

Redhat EL-Linux-4.0

(CentOS-4.x and Xos-Linux-4 use binaries similar to Redhat EL-Linux-4 )

Debian 3.1 (sarge)

Ubuntu 6.06(dapper)

Retrieved from "http://petersap.nl/SybaseWiki/index.php?title=Sybase_on_linux-distro_matrix&oldid=1513"