starting mysql server automatically

[Paul Keyes]

--- Chris Hodgins <christopher.hodgins at gmail.com>
wrote:
> On 5/6/05, Paul Keyes <paul_s_keyes at yahoo.ca> wrote:
> > Hi All,
> > 
> > I'm setting up a server running Freebsd 5.3  I
> have
> > mysql running well but I can't seem to get it to
> start
> > automatically at boot time.  I can only start it
> as
> > root with the command:
> > mysqld_safe --user=mysql &
> > 
> > (when I do this everything works fine)
> > 
> > I tried installing the mysql.server sript as:
> > /usr/local/etc/rc.d/mysql.server.sh
> > but when I try to run it manually I get this:
> > ./mysql.server.sh: 102: Syntax error: Bad for loop
> > variable
> > 
> > What is the best way to get the mysql server
> running
> > automatically when the computer boots?
> > 
> > Thanks,
> > Paul
> > 
> 
> Make sure this line appears in /etc/rc.conf:
> mysql_enable="YES"
> 
> Then reboot and you should be able to see it in
> sockstat:
> 
> $ sockstat -4 | grep mysql
> mysql    mysqld     529   3  tcp4   *:3306          
>      *:*
> 
> If that still does not work then you might want to
> post you
> mysql-server.sh file so we can see if you have any
> obvious problems
> with it.
> 
> Chris
> 

I tried adding mysql_enable="YES" to /etc/rc.conf and
rebooted but sockstat -4 | grep mysql showed nothing
and mysql server wasn't running.

Some information about my system:

$uname -r
5.3-RELEASE

$pkg_info | grep mysql
mysql-client-5.0.3_1 Multithreaded SQL
database(client)
mysql-server-5.0.3_1 Multithreaded SQL
database(server)
p5-DBD-mysql50-2.9006 MySQL 5.0 driver for the Perl5
Database Interface (DBI)
php5-mysql-5.0.4_1  The mysql shared extension for php


Here is my mysql-server.sh file:
(located in /usr/local/etc/rc.d/)

#!/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 daemon 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 and
/etc/rc0.d/K01mysql.
# When this is done the mysql server will be started
when the machine is
# started and shut down when the systems goes down.

# Comments to support chkconfig on RedHat Linux
# chkconfig: 2345 90 20
# description: A very fast and reliable SQL database
engine.

# Comments to support LSB init script conventions
### BEGIN INIT INFO
# Provides: mysql
# Required-Start: $local_fs $network $remote_fs
# Required-Stop: $local_fs $network $remote_fs
# Default-Start:  2 3 4 5
# Default-Stop: 0 1 6
# Short-Description: start and stop MySQL
# Description: MySQL is a very fast and reliable SQL
database engine.
### END INIT INFO
 
# If you install MySQL on some other places than
@prefix@, then you
# have to do one of the following things for this
script to work:
#
# - Run this script from within the MySQL installation
directory
# - Create a /etc/my.cnf file with the following
information:
#   [mysqld]
#   basedir=<path-to-mysql-installation-directory>
# - Add the above to any other configuration file (for
example ~/.my.ini)
#   and copy my_print_defaults to /usr/bin
# - Add the path to the mysql-installation-directory
to the basedir variable
#   below.
#
# If you want to affect other MySQL variables, you
should make your changes
# in the /etc/my.cnf, ~/.my.cnf or other MySQL
configuration files.

# If you change base dir, you must also change datadir

basedir=
datadir=

# The following variables are only set for letting
mysql.server find things.

# Set some defaults
pid_file=
if test -z "$basedir"
then
  basedir=@prefix@
  bindir=@bindir@
  datadir=@localstatedir@
  sbindir=@sbindir@
else
  bindir="$basedir/bin"
  sbindir="$basedir/sbin"
fi

#
# Use LSB init script functions for printing messages,
if possible
#
lsb_functions="/lib/lsb/init-functions"
if test -f $lsb_functions ; then
  source $lsb_functions
else
  alias log_success_msg="echo \ SUCCESS! "
  alias log_failure_msg="echo \ ERROR! "
fi

PATH=/sbin:/usr/sbin:/bin:/usr/bin:$basedir/bin
export PATH

mode=$1    # start or stop

case `echo "testing\c"`,`echo -n testing` in
    *c*,-n*) echo_n=   echo_c=     ;;
    *c*,*)   echo_n=-n echo_c=     ;;
    *)       echo_n=   echo_c='\c' ;;
esac

parse_server_arguments() {
  for arg do
    case "$arg" in
      --basedir=*)  basedir=`echo "$arg" | sed -e
's/^[^=]*=//'` ;;
      --datadir=*)  datadir=`echo "$arg" | sed -e
's/^[^=]*=//'` ;;
    esac
  done
}

parse_manager_arguments() {
  for arg do
    case "$arg" in
      --pid-file=*) pid_file=`echo "$arg" | sed -e
's/^[^=]*=//'` ;;
    esac
  done
}

wait_for_pid () {
  for((i=0; i<35; i++)); do
    sleep 1
    test -s $pid_file && i='' && break
    echo $echo_n ".$echo_c"
  done

  if test -z "$i" ; then
    log_success_msg
  else
    log_failure_msg
  fi
}

# Get arguments from the my.cnf file,
# the only group, which is read from now on is
[mysqld]
if test -x ./bin/my_print_defaults
then
  print_defaults="./bin/my_print_defaults"
elif test -x $bindir/my_print_defaults
then
  print_defaults="$bindir/my_print_defaults"
elif test -x $bindir/mysql_print_defaults
then
  print_defaults="$bindir/mysql_print_defaults"
else
  # Try to find basedir in /etc/my.cnf
  conf=/etc/my.cnf
  print_defaults=
  if test -r $conf
  then
    subpat='^[^=]*basedir[^=]*=\(.*\)$'
    dirs=`sed -e "/$subpat/!d" -e 's//\1/' $conf`
    for d in $dirs
    do
      d=`echo $d | sed -e 's/[ 	]//g'`
      if test -x "$d/bin/my_print_defaults"
      then
        print_defaults="$d/bin/my_print_defaults"
        break
      fi
      if test -x "$d/bin/mysql_print_defaults"
      then
        print_defaults="$d/bin/mysql_print_defaults"
        break
      fi
    done
  fi

  # Hope it's in the PATH ... but I doubt it
  test -z "$print_defaults" &&
print_defaults="my_print_defaults"
fi

#
# Test if someone changed datadir;  In this case we
should also read the
# default arguments from this directory
#

extra_args=""
if test "$datadir" != "@localstatedir@"
then
  extra_args="-e $datadir/my.cnf"
fi

parse_server_arguments `$print_defaults $extra_args
mysqld`

# Look for the pidfile 
parse_manager_arguments `$print_defaults $extra_args
manager`

#
# Set pid file if not given
#
if test -z "$pid_file"
then
  pid_file=$datadir/mysqlmanager-`@HOSTNAME@`.pid
else
  case "$pid_file" in
    /* ) ;;
    * )  pid_file="$datadir/$pid_file" ;;
  esac
fi

user=@MYSQLD_USER@
USER_OPTION="--user=$user"

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

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

    if test -x $sbindir/mysqlmanager
    then
      # Give extra arguments to mysqld with the my.cnf
file. This script may
      # be overwritten at next upgrade.
      echo $echo_n "Starting MySQL"
      $sbindir/mysqlmanager $USER_OPTION
--pid-file=$pid_file >/dev/null 2>&1 &
      wait_for_pid

      # Make lock for RedHat / SuSE
      if test -w /var/lock/subsys
      then
        touch /var/lock/subsys/mysqlmanager
      fi
    else
      log_failure_msg "Can't execute
$sbindir/mysqlmanager"
    fi
    ;;

  'stop')
    # Stop daemon. We use a signal here to avoid
having to know the
    # root password.
    if test -s "$pid_file"
    then
      mysqlmanager_pid=`cat $pid_file`
      echo $echo_n "Shutting down MySQL"
      kill $mysqlmanager_pid
      # mysqlmanager should remove the pid_file when
it exits, so wait for it.
      wait_for_pid

      # delete lock for RedHat / SuSE
      if test -f /var/lock/subsys/mysqlmanager
      then
        rm -f /var/lock/subsys/mysqlmanager
      fi
    else
      log_failure_msg "mysqlmanager PID file could not
be found!"
    fi
    ;;

  'restart')
    # Stop the service and regardless of whether it
was
    # running or not, start it again.
    $0 stop
    $0 start
    ;;

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


______________________________________________________________________ 
Post your free ad now! http://personals.yahoo.ca