Sybase ASE Express edition

[lakshman_ab]

Here is the solution for the xterm issue:

1. Login as the ubuntu user created during system installation
2. At the shell prompt enter: xhost + so that clients can connect from any host

To carry on with the SYBASE installation:
1) su - sybase
2) sudo rm -rf /opt/sybase # Delete ASE installation done as root
3) sudo mkdir /opt/sybase
4) chown sybase /opt/sybase
5) chgrp sybase /opt/sybase
6) ./setup # Run ASE installation without sudo logged in as 'sybase'
7) . /opt/sybase/SYBASE.sh # set the env for ksh
8) export LANG=en_GB # reset LANG so that isql doesn't whinge

isql -U sa -S UBUNTU -P ""
1>select db_name()
go


ASE 15.0.3 on Karmic Koala (9.10) now sorted!

[lakshman_ab]

Duplicate post and hence, deleted

[sthaupt]

To carry on with the SYBASE installation:
1) su - sybase
2) sudo rm -rf /opt/sybase # Delete ASE installation done as root
3) sudo mkdir /opt/sybase
4) chown sybase /opt/sybase
5) chgrp sybase /opt/sybase
6) ./setup # Run ASE installation without sudo logged in as 'sybase'
!

Hi, as a long-time-with-sybase-dealing guy let me comment these steps:
- you don't need to have an extra user/group ("sybase") for running ASE
- if ase was already installed, leave it on disk; just take steps 4 and 5. They also can be done in one command: chown -R sybase:sybase /opt/sybase

chown -R \ # for recursion on subdirectories
<yourUser>:<yourGroup> \ # telling user AND group to the command
<yourInstDir>

Good luck

[WitchCraft]

See here:

http://ubuntuforums.org/showthread.p...4#post10255354

[gochilla]

I managed to install sybase on Ubuntu server 11.10... maybe it helps. Install ubuntu server (no extra packages selected).

Setting up ASE 15.7 on Ubuntu Server 11.10 (64it)

Preparing the Linux System

    sudo su
    #adjust shared mem space (as documented in install requirements)
    echo "kernel.shmmax=1073741824" >> /etc/sysctl.conf
    sysctl -w kernel.shmmax=1073741824
    cd
    apt-get install libxp-dev
    apt-get install libxt-dev
    apt-get install libxtst-dev
    apt-get install libxmu-dev
    apt-get install libxext-dev
    apt-get install libsm-dev
    apt-get install libice-dev
    apt-get install libx11-dev
    apt-get install libaio-dev
    apt-get install dkms build-essential alien
    apt-get install openjdk-6-jdk
    apt-get install ia32-libs
    #pull openmotif RPM http://www.openmotif.org/files/public_downloads/openmotif/2.3/2.3.0/openmotif-2.3.0-1.rhel4.x86_64.rpm
    alien -d openmotif-2.1.30-1.rhel4.x86_64.rpm
    #this generates openmotif_2.3.0-2_amd64.deb on my system... now install with dpkg -i
    dpkg -i openmotif_2.3.0-2_amd64.deb
    #create sybase install user + directories
    mkdir /opt/sybase
    mkdir /opt/sybasesetup
    useradd -s /bin/bash -M -d /opt/sybase sybase
    chown sybase.sybase /opt/sybase*
    
    su sybase
    cd /opt/sybasesetup
    #pull http://download.sybase.com/eval/157/ase157_linuxx86-64.tgz and copy to sybasesetup
    tar xzf ase157_linuxx86-64.tgz
    ./setup.bin

[gochilla]

I struggled to get ASE and PAM auth running on Ubuntu. In hope this might help other users:

1) Prepare PAM. Create a the file /etc/pam.d/ase with the following contents

auth required pam_unix.so

2) Assuming your sybase process user is called sybase, you must add this user to the shadow group in order to get PAM going. Do so by issuing

root@sybase# usermod -a -G shadow sybase

3) Enable PAM authentication in sybase. I assume sybase is installed in /opt/sybase

sybase@sybase:~$ cd /opt/sybase
sybase@sybase:/opt/sybase$ . SYBASE.sh
sybase@sybase:/opt/sybase$ isql -U sa
Password:
1> sp_configure "enable pam user auth",2
2> go
...
1> quit

This should get PAM up and running... now we can test it.
1) create a system user

sybase@sybase:~# useradd -MN sybtest
sybase@sybase:~# passwd sybtest
Enter new UNIX password:
Retype new UNIX password:
passwd: password updated successfully
sybase@sybase:~#

2) create a sybase login (login as sybase user)

sybase@sybase:~$ cd /opt/sybase
sybase@sybase:/opt/sybase$ . SYBASE.sh
sybase@sybase:/opt/sybase$ isql -U sa
Password:
1>create login sybtest with password anypass
2>go
1>quit

3) tryout the new login (login as sybase user) use the unix password for the isql login!

sybase@sybase:~$ cd /opt/sybase
sybase@sybase:/opt/sybase$ . SYBASE.sh
 sybase@sybase:/opt/sybase$ isql -U sybtest
Password:
1>

AAAAAAAAAAAAaaaaand we are done! have fun!