4. Configure Environment

After installing Sybase, you need to setup the Linux environment in order to allow clients to connect to the dataserver.

The first thing we need to do is to set certain environment variables in /etc/profile. Open /etc/profile as super user and insert the following lines:

    export SYBASE=/opt/sybase
    export SYBPLATFORM=linux
    export LD_LIBRARY_PATH=$SYBASE/lib
    export LC_ALL=default
    export PATH="$SYBASE/bin:$PATH"
    export DSQUERY=SYBASE

Next you need to change to permissions of the Sybase directory. This fixes some problems where PHP is unable to connect to the Sybase server. Run the following command as super user:

chown -R sybase:sybase /opt/sybase

To test whether your Sybase environment works, type the following:

    # su - nobody
    $ isql -Usa -P
    1> sp_helpdb
    2> go

You should see a list of databases. To test whether you can use the sample datebase, now type:

    1> use pubs2
    2> go
    1> select * from titles
    2> go

If you a list, you have sucessfully set up Sybase.

You may also want to add sybase to the list of services to run at boot time. To do this execute the following commands:

    # ln -s /opt/sybase/install/rc.sybase /etc/rc.d/init.d/sybase
    # ln -s /etc/rc.d/init.d/sybase /etc/rc.d/rc3.d/S15sybase
    # ln -s /etc/rc.d/init.d/sybase /etc/rc.d/rc3.d/K15sybase

Now Sybase will start whenever you boot into runlevel 3.

    # ./configure --prefix=/usr/local/apache