Date: Fri, 07 Apr 2000 00:55:27 -0400 From: "Thomas M. Sommers" <tms2@mail.ptd.net> To: antti@mysql.com Cc: freebsd-questions@FreeBSD.ORG Subject: Re: mysqld exits immediately Message-ID: <38ED6A3F.EEE0B01D@mail.ptd.net> References: <38ECB9CC.6E5D7AB9@mail.ptd.net> <14572.48317.262724.627884@anttish.pp.saunalahti.fi>
next in thread | previous in thread | raw e-mail | index | archive | help
Antti S Halonen wrote:
>
> Thomas M. Sommers writes:
> > When started at boot time, mysql exits immediately. There are no error
> > messages or log entries. This used to happen occasionally, but now
> > happens every time. When started manually (using safe_mysqld), however,
> > there has been no problem. Does anyone have any ideas about why this is
> > happening?
>
> What have you done exactly? Are you using the mysql.server script?
>
I just installed the package without any modifications. It installs a
shell script in /usr/local/etc/rc.d, which in turn runs safe_mysqld.
I should have mentioned that I use FreeBSD 3.2-RELEASE, and mysql
3.22.22,
Here are my files. The comment starting with '###' is where the problem
occurs.
----- /usr/local/etc/rc.d/mysql.sh -----
#!/bin/sh
#
/sbin/ldconfig -m /usr/local/lib/mysql
if [ -x /usr/local/bin/safe_mysqld ]
then
/usr/local/bin/safe_mysqld > /dev/null & && echo -n ' mysql'
fi
----- /usr/local/bin/safe_mysqld -----
#!/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
#
# scripts to start the MySQL daemon and restart it if it dies unexpectedly
#
# This should be executed in the MySQL base directory if you are using a
# binary installation that has other paths than you are using.
#
# mysql.server works by first doing a cd to the base directory and from there
# executing safe_mysqld
trap '' 1 2 3 15 # we shouldn't let anyone kill us
MY_BASEDIR_VERSION=/usr/local
DATADIR=/var/db/mysql
ledir=/usr/local/libexec
pid_file=$DATADIR/`/bin/hostname`.pid
log=$DATADIR/`/bin/hostname`.log
err_log=$DATADIR/`/bin/hostname`.err
# Parse arguments to see if caller wants the pid_file somewhere else.
for arg
do
case $arg
in
--pid-file=*)
pid_file=`echo "$arg" | sed -e "s;--pid-file=;;"`
;;
esac
done
#
# If there exists an old pid file, check if the daemon is already running
# Note: The switches to 'ps' may depend on your operating system
if test -f $pid_file
then
PID=`cat $pid_file`
if /bin/kill -0 $PID
then
if /bin/ps -uaxww | grep mysqld | grep " $PID " > /dev/null
then # The pid contains a mysqld process
echo "A mysqld process already exists"
echo "A mysqld process already exists at " `date` >> $err_log
exit 1;
fi
fi
rm -f $pid_file
if test -f $pid_file
then
echo "Fatal error: Can't remove the pid file: $pid_file"
echo "Fatal error: Can't remove the pid file: $pid_file at " `date` >> $err_log
echo "Please remove it manually and start $0 again"
echo "mysqld daemon not started"
exit 1;
fi
fi
echo "Starting mysqld daemon with databases from $DATADIR"
#Default communication ports
#MYSQL_TCP_PORT=3306
if test -z "$MYSQL_UNIX_PORT"
then
MYSQL_UNIX_PORT="/tmp/mysql.sock"
export MYSQL_UNIX_PORT
fi
#export MYSQL_TCP_PORT
# Does this work on all systems?
#if type ulimit | grep "shell builtin" > /dev/null
#then
# ulimit -n 256 > /dev/null 2>&1 # Fix for BSD and FreeBSD systems
#fi
echo "mysqld started on " `date` >> $err_log
while true
do
rm -f $MYSQL_UNIX_PORT $pid_file # Some extra safety
if test "$#" -eq 0
then
### This is the line that executes mysqld, which exits immediately.
nohup $ledir/mysqld --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR \
>> $err_log 2>&1
else
nohup $ledir/mysqld --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR \
"$@" >> $err_log 2>&1
fi
if test ! -f $pid_file # This is removed if normal shutdown
then
break;
fi
echo "mysqld restarted on " `date` | tee -a $err_log
done
echo "mysqld ended on " `date` >> $err_log
echo "mysqld daemon ended"
To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-questions" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?38ED6A3F.EEE0B01D>