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