File rc.mysql-multi of Package mysql

#!/bin/bash
# Copyright (c) 1995-2002 SuSE Linux AG Nuernberg, Germany.
#
# Author: Lenz Grimmer <feedback@suse.de>
#
# mysqld_multi extension added by Richard Bos, 2008
#
# /etc/init.d/mysql
#
#   and its symbolic link
#
# /usr/sbin/rcmysql
#
### BEGIN INIT INFO
# Provides:       mysql
# Required-Start: $network $remote_fs
# Required-Stop: $network $remote_fs
# Default-Start:  2 3 5
# Default-Stop:
# Description:    Start the MySQL database server
### END INIT INFO

# Shell functions sourced from /etc/rc.status:
#      rc_check         check and set local and overall rc status
#      rc_status        check and set local and overall rc status
#      rc_status -v     ditto but be verbose in local rc status
#      rc_status -v -r  ditto and clear the local rc status
#      rc_failed        set local and overall rc status to failed
#      rc_failed <num>  set local and overall rc status to <num>
#      rc_reset         clear local rc status (overall remains)
#      rc_exit          exit appropriate to overall rc status
. /etc/rc.status

# First reset status of this service
rc_reset

# Return values acc. to LSB for all commands but status:
# 0 - success
# 1 - generic or unspecified error
# 2 - invalid or excess argument(s)
# 3 - unimplemented feature (e.g. "reload")
# 4 - insufficient privilege
# 5 - program is not installed
# 6 - program is not configured
# 7 - program is not running
# 
# Note that starting an already running service, stopping
# or restarting a not-running service as well as the restart
# with force-reload (in case signalling is not supported) are
# considered a success.

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

wait_for_socket()
{
	local i
	for((i=0; i<150; i++)); do
		sleep 0.2
		test -S $1 && i='' && break
	done
	test -z "$i" || return 1
	return 0
}

# Don't run killproc -TERM, as it could send a SIGKILL as well, possibly
# resulting in database corruption. Run kill -TERM manually instead,  wait
# approximately 300 seconds and fail if mysql doesn't respond. This will at
# least prevent the SIGKILL when doing 'rcmysql stop' manually. During system
# shutdown, we are out of luck...
# See https://bugzilla.novell.com/show_bug.cgi?id=223209
kill_mysql ()
{
	local pid exe
	test -e "$pid_file" || return 7  # not running
	pid=`cat "$pid_file"` || return 4  # insufficient privileges
	if ! test -e /proc/version; then
		mount -n -t proc proc /proc
		test -e /proc/version || return 100
	fi
	test -L "/proc/$pid/exe" || return 7
	exe=`readlink "/proc/$pid/exe"` || return 4
	test "$exe" = "$MYSQLD" || return 7
	kill -STOP "$pid"
	kill -TERM "$pid" || return 4 # suboptimal
	kill -CONT "$pid"
	for i in `seq 3000`; do
		# mysqld removes its pid file
		test -e "$pid_file" || return 0
		LC_ALL=C sleep 0.1
	done
	test -e "$pid_file" || return 0
	return 1
}

# Read the value of:
# MYSQLD_MULTI
[[ -f /etc/sysconfig/mysql ]] && . /etc/sysconfig/mysql

if [[ "$MYSQLD_MULTI" == "yes" ]]; then

[[ -x /usr/bin/mysqld_multi ]] || {
    echo -n "MySQL: /usr/bin/mysqld_multi not found" 
    rc_failed 5; rc_status -v; rc_exit;
  }

case "$1" in
      start)

# FIXME:
  	# We assume a fresh install if the directory $datadir/mysql
  	# does not exist and create the privilege database
        # if ! test -d $datadir/mysql; then
        #   echo -n "Creating MySQL privilege database... "
        #   mysql_install_db --user=$mysql_daemon_user --datadir=$datadir || {
        #     rc_failed;  rc_status -v; rc_exit
        #   }
        # fi
  	echo -n "Starting service multi MySQL "
        mysqld_multi start

# Remember status and be verbose
  	rc_status -v
  	;;

stop)
  	echo -n "Shutting down service multi MySQL "
        mysqld_multi stop

# Remember status and be verbose
  	rc_status -v
  	;;

try-restart)
  	## Stop the service and if this succeeds (i.e. the 
  	## service was running before), start it again.
  	## Note: try-restart is not (yet) part of LSB (as of 0.7.5)
  	$0 status >/dev/null &&  $0 restart

# Remember status and be quiet
  	rc_status
  	;;

restart|force-reload)
  	echo "Restarting service multi MySQL "
  	$0 stop
  	$0 start

rc_status
  	;;

reload)
  	echo -n "Reloading service multi MySQL "
  	# FIXME:
        # Don't know what to do in this case
        # killproc -p $pid_file -HUP $MYSQLD
  	# touch $pid_file
  	rc_status -v
  	;;
  	
      status)
	STATUS=$(mysqld_multi report)
        echo -n "$STATUS"
	# Set the status for rc_status
	echo "$STATUS" | grep -q "is running"
  	rc_status -v
  	;;

*)
  	echo "Usage: $0 {start|stop|status|reload|restart|try-restart|force-reload}"
  	exit 1
  	;;
  esac

else
	# Test, if mysqld or mysql-max actually exist
	unset MYSQLD

# use mysqld-debug only if explicitly requested (TODO: sysconfig variable?)
	if test "$MYSQLD_DEBUG" = yes -a -x /usr/sbin/mysqld-debug
	then
		MYSQLD=/usr/sbin/mysqld-debug
	elif test -x /usr/sbin/mysqld-max
	then
	        MYSQLD=/usr/sbin/mysqld-max
	elif test -x /usr/sbin/mysqld
	then
	        MYSQLD=/usr/sbin/mysqld
	fi
		test "$MYSQLD" || {
		echo -n "Nor /usr/sbin/mysqld nor /usr/sbin/mysqld-max exists";
		rc_failed 5; rc_status -v; rc_exit;
	}

# The following section has been taken from
	# the original MySQL init script
	# Note: If you want to change these variables, you'll make your life easier
	# if you do so in /etc/my.cnf, which is preserved during upgrades
	basedir=/usr
	datadir=/var/lib/mysql
	mysql_daemon_user=mysql
	mysql_daemon_group=mysql
	pid_file=/var/lib/mysql/mysqld.pid
	socket=/var/lib/mysql/mysql.sock
	print_defaults=/usr/bin/my_print_defaults

mode=$1 # start or stop

parse_arguments `$print_defaults $defaults mysqld mysql_server`
	export TMPDIR=/var/tmp/mysql
	if ! test -d "$TMPDIR"; then
		mkdir "$TMPDIR"
		chown mysql:mysql "$TMPDIR"
		chmod 755 "$TMPDIR"
	fi

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

case "$1" in
	    start)
		# exit gracefully, if we are already running
		$0 status >/dev/null && echo -n "Starting service MySQL " && \
		rc_status -v && rc_exit

# Test, if safe_mysqld actually exists
		SAFE_MYSQLD=/usr/bin/mysqld_safe
		test -x $SAFE_MYSQLD || {
			echo "$SAFE_MYSQLD does not exist ";
			rc_failed 5; rc_status -v; rc_exit;
		}
		debug_flags=""
		if test "$MYSQLD_DEBUG" = yes; then
			# add --log, --core-file and --debug
			# but only if not already set in my.cnf
			if ! $print_defaults mysqld | \
				grep -q -e '--log$' -e '--log[[:blank:]=]'
			then
				debug_flags="--log=$datadir/mysqld-query.log"
			fi
			if ! $print_defaults mysqld | grep -q -e '^--debug\>' &&
				test "$MYSQLD" = /usr/sbin/mysqld-debug
			then
				debug_flags="$debug_flags --debug=d:t:F:L:o,$datadir/mysqld.trace"
			fi
			if ! $print_defaults mysqld | grep -q -e '^--core-file\>'
			then
				debug_flags="$debug_flags --core-file"
			fi
		fi

# check for ISAM tables
		tables=`find $datadir -name '*.ISM' | sed "s@$datadir/*@@; s@.ISM@@; s@/@.@;"`
		if test "$tables" ; then
			echo
			echo "Some tables still use ISAM format, which is NO LONGER SUPPORTED"
			echo "since mysql 5.0. To use these tables, you would need to open them"
			echo "from an older mysql server and convert to something better (eg. MyISAM)."
			echo
			echo "Tables using ISAM are: "
			echo "  $tables "
			echo
		fi
		# check for bdb tables
		tables=`find $datadir -name '*.db' | sed "s@$datadir/*@@; s@.db@@; s@/@.@;"`
		if test -n "$tables" ; then
			echo
			echo "Some tables still use BerkeleyDB format, please convert them to something "
			echo "else. BerkeleyDB support will be dropped in future releases. "
			echo "You can use mysql_convert_table_format script to do this conversion. "
			echo
			echo "Tables using BerkeleyDB are: "
			echo "  $tables "
			echo
		fi

# We assume a fresh install if the directory $datadir/mysql
		# does not exist and create the privilege database
		if ! test -d $datadir/mysql; then
			echo "Creating MySQL privilege database... "
			mysql_install_db --user=$mysql_daemon_user --datadir=$datadir ||{
				rc_failed;  rc_status -v; rc_exit
			}
		fi
		# Run mysql_upgrade on every package install/upgrade. Not allways
		# necessary, but doesn't do any harm.
		if test -f $datadir/.run-mysql_upgrade ; then
			echo "Updating MySQL privilege database... "
			# instead of running mysqld --bootstrap, which wouldn't allow
			# us to run mysql_upgrade, we start a full-featured server with
			# --skip-grant-tables and restict access to it by unix
			# permissions of the named socket
			protected=$datadir/.protected
			chown $mysql_daemon_user:$mysql_daemon_group $protected
			chmod 700 $protected
			$SAFE_MYSQLD \
				--mysqld=${MYSQLD#/usr/sbin/} \
				$debug_flags \
				--skip-grant-tables \
				--skip-networking \
				--user=$mysql_daemon_user \
				--pid-file=$protected/mysqld.pid \
				--socket=$protected/mysql.sock \
				--group=$mysql_daemon_group &>/dev/null &
			wait_for_socket $protected/mysql.sock || {
				rc_failed; rc_status -v; rc_exit;
			}
			/usr/bin/mysql_upgrade \
				--basedir=$basedir \
				--socket=$protected/mysql.sock || {
				rc_failed; rc_status -v;
				killproc -p $protected/mysqld.pid -TERM $MYSQLD
				rc_exit;
			}
			killproc -p $protected/mysqld.pid -TERM $MYSQLD
			# Fix ownerships and permissions for $datadir
			chmod 755 $datadir
			chown -R $mysql_daemon_user:$mysql_daemon_group $datadir
			rm -f $datadir/.run-mysql_upgrade \
			$datadir/{update-stamp-*,mysql/stamp-4.1} # used in the past
		if test -f $datadir/mysql/stamp-4.1 ; then
			rm $datadir/mysql/stamp-4.1
		fi

echo -n "Starting service MySQL "

$SAFE_MYSQLD \
			--mysqld=${MYSQLD#/usr/sbin/} \
			$debug_flags \
			--user=$mysql_daemon_user \
			--pid-file=$pid_file \
			--socket=$socket \
			--datadir=$datadir &>/dev/null &

wait_for_socket $socket || {
			# let's not treat this as a fatal error
			echo "warning: $socket didn't appear within 30 seconds"
		}

# Rmember status and be verbose
		rc_status -v
		;;

stop)
		echo -n "Shutting down service MySQL "
		kill_mysql

# Remember status and be verbose
		rc_status -v
		;;

try-restart)
		## Stop the service and if this succeeds (i.e. the 
		## service was running before), start it again.
		## Note: try-restart is not (yet) part of LSB (as of 0.7.5)
		$0 status >/dev/null &&  $0 restart

# Remember status and be quiet
		rc_status
		;;

restart|force-reload)
		echo "Restarting service MySQL "
		$0 stop
		$0 start

rc_status
		;;

reload)
		echo -n "Reloading service MySQL "
		killproc -p $pid_file -HUP $MYSQLD
		touch $pid_file
		rc_status -v
		;;
		
	    check|status)
		echo -n "Checking for service MySQL: "
		## Check status with checkproc(8), if process is running
		## checkproc will return with exit status 0.

# Status has a slightly different for the status command:
		# 0 - service running
		# 1 - service dead, but /var/run/  pid  file exists
		# 2 - service dead, but /var/lock/ lock file exists
		# 3 - service not running

# NOTE: checkproc returns LSB compliant status values.
		checkproc -p $pid_file $MYSQLD
		rc_status -v
		;;

*)
		echo "Usage: $0 {start|stop|status|reload|restart|try-restart|force-reload}"
		exit 1
		;;
	esac
fi

rc_exit

# vim: ft=sh