Difference between revisions of "Sybase on linux-distro matrix"

From SybaseWiki
Jump to: navigation, search
(→‎Fedora Core-5)
(→‎Ubuntu-6.06 LTS (dapper))
 
(12 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
=Adaptive Server Enterprice (ASE)=
+
Content contributed by Luc Nieland
 +
 
 +
=Adaptive Server Enterprise (ASE)=
  
  
 
{| border="1"
 
{| border="1"
 
|+ The ASE on Linux-distro working matrix:
 
|+ The ASE on Linux-distro working matrix:
−
! \ !! 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
+
! \ !! 11.0.3.3_x86-32 !! 12.5.3_x86-32!!12.5.3_x86-64!!15.0.x_x86-32 !! 15.0.0-x86-64
 
|-
 
|-
 
! RedHat-EL-4 x86-32
 
! RedHat-EL-4 x86-32
Line 13: Line 15:
 
|-
 
|-
 
! Fedora-core5 x86-32
 
! Fedora-core5 x86-32
−
| ? || ? || n.a. || ? || n.a.
+
| no || no || n.a. || no || n.a.
 
|-
 
|-
 
! Fedora-core5 x86-64
 
! Fedora-core5 x86-64
−
| ? || ? || ? || ? || ?
+
| no || no || no || no || no
 
|-
 
|-
 
! Debian-3.1_x86-32
 
! Debian-3.1_x86-32
Line 23: Line 25:
 
! Debian-3.1_x86-64
 
! Debian-3.1_x86-64
 
| ? || ?  || ? || ? || ?
 
| ? || ?  || ? || ? || ?
 +
|-
 +
! Debian-4.0_x86-32
 +
| ? || yes  || n.a. || yes || n.a.
 
|-
 
|-
 
! Ubuntu-6.06_x86-32
 
! Ubuntu-6.06_x86-32
Line 28: Line 33:
 
|-
 
|-
 
! Ubuntu-6.06_x86-64
 
! Ubuntu-6.06_x86-64
−
| ? || no  || yes || no || yes
+
| ? || no  || yes || yes (with a trick) || [[Ubuntu 64 bit ASE installation]]
 +
|-
 +
! Ubuntu-7.10_x86-32
 +
| ? || no || n.a. || no || n.a.
 
|}
 
|}
  
−
 
+
For detailed information how to install ASE go here: [[Installation guidelines ASE]]
−
==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)==
 
==Version 11.0.x (x86-32)==
Line 56: Line 54:
 
This release of the RedHat development-line is based on NPTL (The Native POSIX Threading Library) that has replaced Linux Threads completely.
 
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)===
+
===Debian-4.0 (etch)===
−
===Ubuntu 6.06(dapper)===
+
Add the extra package:
−
Expect test-results here in a few days.
+
apt-get install libaio.1
  
−
==Version 12.5.x (x86-64)==
+
And manually:
−
Software not yet delivered.
+
wget http://ftp.debian.org/debian/pool/main/g/gcc-2.95/libstdc%2B%2B2.10-glibc2.2_2.95.4-27_i386.deb
 +
dpkg -i libstdc++2.10-glibc2.2_2.95.4-27_i386.deb
  
 +
===Ubuntu-6.06 LTS (dapper)===
 +
Like Debian-4.0
 +
 +
wget http://archive.ubuntu.com/ubuntu/pool/universe/g/gcc-2.95/libstdc++2.10-glibc2.2_2.95.4-24_i386.deb
 +
dpkg -i libstdc++2.10-glibc2.2_2.95.4-24_i386.deb
 +
 +
===Ubuntu-7.10 (gutsy)===
 +
Not working...
  
 
==Version 15.0.x (x86-32)==
 
==Version 15.0.x (x86-32)==
 
Used version 15.0.0-ebf13194
 
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 EL-Linux-4.0===
Line 115: Line 99:
 
         libaudit.so.0 => /lib/libaudit.so.0 (0x00745000)
 
         libaudit.so.0 => /lib/libaudit.so.0 (0x00745000)
  
 +
===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)
 +
 +
 +
===Debian 4.0 (etch)===
 +
Tested with 15.0.2.
 +
Install the extra packages:
 +
apt-get install  libaio.1  libstdc++5
 +
http://ftp.debian.org/debian/pool/main/g/gcc-2.95/libstdc++2.10-glibc2.2_2.95.4-27_i386.deb
 +
dpkg -i libstdc++2.10-glibc2.2_2.95.4-27_i386.deb
 +
 +
==Version 15.0.x (x86-64)==
 +
Sybase has now also released a 64 bit version for this distro.
 +
 +
You can access get a copy here http://www.sybase.com/linuxpromo.
 +
 +
===Redhat EL-Linux-4.0===
 
====Redhat x86-64 version====
 
====Redhat x86-64 version====
 
works out of the box, when you choose a server install and also select the compat-packages.
 
works out of the box, when you choose a server install and also select the compat-packages.
Line 151: Line 170:
 
  drwxr-xr-x  6 root root 4096 Jun  4 14:10 /lib64
 
  drwxr-xr-x  6 root root 4096 Jun  4 14:10 /lib64
  
−
===Debian 3.1 (sarge)===
+
===Debian / Ubuntu===
−
===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====
 
====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.
+
See this page for detailed instructions: [[Ubuntu 64 bit ASE installation]]
−
 
+
−
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=
 
=ReplicationServer=
Line 272: Line 254:
  
  
−
=Page maintainer=
+
[[category:ASE]]
−
Luc Nieland
+
[[category:RepServer]]
 +
[[category:OpenSwitch]]

Latest revision as of 12:22, 21 February 2008

Content contributed by Luc Nieland

Adaptive Server Enterprise (ASE)

The ASE on Linux-distro working matrix:
\ 11.0.3.3_x86-32 12.5.3_x86-32 12.5.3_x86-64 15.0.x_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  ?  ?  ?  ?  ?
Debian-4.0_x86-32  ? yes n.a. yes n.a.
Ubuntu-6.06_x86-32  ? yes n.a. yes n.a.
Ubuntu-6.06_x86-64  ? no yes yes (with a trick) Ubuntu 64 bit ASE installation
Ubuntu-7.10_x86-32  ? no n.a. no n.a.

For detailed information how to install ASE go here: Installation guidelines ASE

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-4.0 (etch)

Add the extra package: 

apt-get install libaio.1

And manually: 

wget http://ftp.debian.org/debian/pool/main/g/gcc-2.95/libstdc%2B%2B2.10-glibc2.2_2.95.4-27_i386.deb
dpkg -i libstdc++2.10-glibc2.2_2.95.4-27_i386.deb

Ubuntu-6.06 LTS (dapper)

Like Debian-4.0 

wget http://archive.ubuntu.com/ubuntu/pool/universe/g/gcc-2.95/libstdc++2.10-glibc2.2_2.95.4-24_i386.deb
dpkg -i libstdc++2.10-glibc2.2_2.95.4-24_i386.deb

Ubuntu-7.10 (gutsy)

Not working...

Version 15.0.x (x86-32)

Used version 15.0.0-ebf13194

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)

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)


Debian 4.0 (etch)

Tested with 15.0.2. Install the extra packages: 

apt-get install  libaio.1  libstdc++5
http://ftp.debian.org/debian/pool/main/g/gcc-2.95/libstdc++2.10-glibc2.2_2.95.4-27_i386.deb
dpkg -i libstdc++2.10-glibc2.2_2.95.4-27_i386.deb

Version 15.0.x (x86-64)

Sybase has now also released a 64 bit version for this distro.

You can access get a copy here http://www.sybase.com/linuxpromo.

Redhat EL-Linux-4.0

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 / Ubuntu

Ubuntu x86-64 version

See this page for detailed instructions: Ubuntu 64 bit ASE installation

ReplicationServer

The ReplicationServer on Linux-distro working matrix:
\ 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

The Openswitch on Linux-distro working matrix:
\ 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)

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