Sybase on linux-distro matrix
Contents
Adaptive Server Enterprice (ASE)
\ | 11.0.3.3_x86-32 | 12.5.3_x86-32 | 12.5.3_x86-64 | 15.0.0_x86-32 | 15.0.0-x86-64 |
---|---|---|---|---|---|
RedHat-EL-4 x86-32 | ? | yes | n.a. | yes | n.a. |
RedHat-EL-4 x86-64 | ? | yes | yes | yes | yes |
Fedora-core5 x86-32 | no | no | n.a. | no | n.a. |
Fedora-core5 x86-64 | no | no | no | no | no |
Debian-3.1_x86-32 | ? | ? | n.a. | ? | n.a. |
Debian-3.1_x86-64 | ? | ? | ? | ? | ? |
Ubuntu-6.06_x86-32 | ? | yes | n.a. | yes | n.a. |
Ubuntu-6.06_x86-64 | ? | no | yes | no | yes |
Generic configuration advisories:
Always configure more shared-memory before starting srvbuild(res). For 30G shared mem use for example:
[root]# echo 33554432000 > /proc/sys/kernel/shmmax
To make this permanent after reboot's, append to /etc/sysctl.conf
#Debian/Ubuntu: kernel/shmmax=335544320 #Redhat: kernel.shmmax = 335544320
Version 11.0.x (x86-32)
When used with a recent Linux-distro, use the faq on the link below to allocate more than 128M memory. http://www.peppler.org/FAQ/linux.html#q1.22
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
This release of the RedHat development-line is based on NPTL (The Native POSIX Threading Library) that has replaced Linux Threads completely.
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
For a compact install choose "server install". Some might also select the X-server binaries, but for a real server this is of not much extra use. After everything is running, instal the rpm's from the CDrom in /cdrom/CentOS/RPMS below:
compat-libstdc++-296-2.96-132.7.2.i386.rpm compat-libstdc++-33-3.2.3-47.3.i386.rpm
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
\ | 12.5_x86-32 | 12.6_x86-64 | 15.0.0_x86-32 | 15.0.0-x86-64(not yet released) |
---|---|---|---|---|
RedHat-EL-4 x86-32 | yes | yes | yes | n.a. |
RedHat-EL-4 x86-64 | yes | yes | yes | yes (expected) |
Fedora-core5 x86-32 | ? | ? | ? | n.a. |
Fedora-core5 x86-64 | ? | ? | ? | ? |
Debian-3.1_x86-32 | ? | ? | ? | n.a. |
Debian-3.1_x86-64 | no | ? | no | yes (expected) |
Ubuntu-6.06_x86-32 | ? | ? | ? | n.a. |
Ubuntu-6.06_x86-64 | no | ? | no | yes (expected) |
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)
Openswitch
\ | 12.5_x86-32 | 12.6_x86-64 | 15.0.0_x86-32 | 15.0.0-x86-64(not yet released) |
---|---|---|---|---|
RedHat-EL-4 x86-32 | yes | yes | yes | n.a. |
RedHat-EL-4 x86-64 | yes | yes | yes | yes (expected) |
Fedora-core5 x86-32 | ? | ? | ? | n.a. |
Fedora-core5 x86-64 | ? | ? | ? | ? |
Debian-3.1_x86-32 | ? | ? | ? | n.a. |
Debian-3.1_x86-64 | no | ? | no | yes (expected) |
Ubuntu-6.06_x86-32 | ? | ? | ? | n.a. |
Ubuntu-6.06_x86-64 | no | ? | no | yes (expected) |
Version 12.5.x (x86-32)
Redhat EL-Linux-4.0
Debian 3.1 (sarge)
Ubuntu 6.06(dapper)
Page maintainer
Luc Nieland