From: Date: August 27 1999 5:54pm
Subject: Re: ld_library_path
List-Archive: http://lists.mysql.com/mysql/11512
Message-Id: <Pine.SC5.4.10.9908270942290.25606-100000@xenau>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

On Fri, 27 Aug 1999, Julien CHATELLIER wrote:
> I am using mysql-3.22.25-pc-sco3.2v5.0.5-i386 on a SCO OpenServer 5.0.5. 
> Like expected, I have to do LD_LIBRARY_PATH=/usr/local/mysql/lib and then 
> export LD_LIBRARY_PATH due to the FSU-thread problem.

You may need all of these below.

PATH=:/bin:/etc:/usr/bin:/usr/local/bin:/tcb/bin:/usr/ccs/bin:/usr/local/ubin:/usr/progressive/bin:/usr/progressive/elf/bin:/usr/skunk/bin:
LD_LIBRARY_PATH=/usr/lib:/lib:/usr/local/lib:/usr/ccs/lib:/usr/progressive/lib:/usr/skunk/lib:/usr/local/mysql/lib
LIBPATH=/usr/lib:/lib:/usr/local/lib:/usr/ccs/lib:/usr/progressive/lib:/usr/skunk/lib
MANPATH=scohelp:/usr/man:/usr/local1/man:/usr/local/man:/usr/skunk/man:

export PATH LD_LIBRARY_PATH LIBPATH MANPATH


> I want to start mysql automatically when the unix starts. So I put these 
> two line in the mysql.server script, under the "PATH" and "export PATH" 
> lines. But this doesn't work. mysql starts well, but I still have to type 
> LD_LIBR.... before using it.
> What's the problem ?

I have the following in /etc/rc2.d/S99mysql.  This starts MySQL when I
boot the machine...

#!/bin/sh
# Copyright Abandoned 1996 TCX DataKonsult AB & Monty Program KB & Detron HB
# This file is public domain and comes with NO WARRANTY of any kind

# Mysql deamon start/stop script.

# Usually this is put in /etc/init.d (at least on machines SYSV R4
# based systems) and linked to /etc/rc3.d/S99mysql. When this is done
# the mysql server will be started when the machine is started.

-----------------------------S99mysql------------------------------------
PATH=:/sbin:/usr/sbin:/bin:/etc:/usr/bin:/usr/local/bin:/tcb/bin:/usr/ccs/bin:/usr/local/ubin:/usr/progressive/bin:/usr/progressive/elf/bin:/usr/skunk/bin:
LD_LIBRARY_PATH=/usr/lib:/lib:/usr/local/lib:/usr/ccs/lib:/usr/progressive/lib:/usr/skunk/lib:/usr/local/mysql/lib
LIBPATH=/usr/lib:/lib:/usr/local/lib:/usr/ccs/lib:/usr/progressive/lib:/usr/skunk/lib
MANPATH=scohelp:/usr/man:/usr/local1/man:/usr/local/man:/usr/skunk/man:

export PATH LD_LIBRARY_PATH LIBPATH MANPATH
basedir=/usr/local
bindir=/usr/local/bin

mode=$1

# The following test may be removed if mysqld isn't to be run as root.
if test ! -w /
then
  echo "$0: this script must be run as root ... fatal error"
  exit 1
fi

# Safeguard (relative paths, core dumps..)
cd $basedir

case "$mode" in
  'start')
    # Start deamon

    if test -x $bindir/safe_mysqld
    then
      # -l means start with log.
      $bindir/safe_mysqld -l &
    else
      echo "Can't execute $bindir/safe_mysqld"
    fi
    ;;

  'stop')
    # Stop deamon
    $bindir/mysqladmin shutdown
    ;;

  *)
    # usage
    echo "usage: $0 start|stop"
    exit 1
    ;;
esac

---------------------------------------------------------------------

Good Luck,

Boyd Gerber
gerberb@stripped