[packages/percona-server.git] / mysql.init

#!/bin/sh
#
# mysql		A very fast and reliable SQL database engine
#
# chkconfig:	2345 84 25
#
# description:  A very fast and reliable SQL database engine.
#
# $Id$

# Source function library
. /etc/rc.d/init.d/functions

# Get network config
. /etc/sysconfig/network

# Get service config
if [ -f /etc/sysconfig/mysql ]; then
	. /etc/sysconfig/mysql
else
	nls "Error: %s not found" /etc/sysconfig/mysql
	nls "%s can't be run." MySQL
	exit 1
fi

if [ -n "$MYSQL_DB_CLUSTERS" ]; then
	nls "Warning: MYSQL_DB_CLUSTERS is set. It's obsolete. Use %s instead." /etc/mysql/clusters.conf
fi

if [ -f /etc/mysql/clusters.conf ]; then
	MYSQL_DB_CLUSTERS=$(awk -F= '!/^#/{print $2}' /etc/mysql/clusters.conf)
	if [ -z "$MYSQL_DB_CLUSTERS"  ]; then
		nls "Warning: there are no configured clusters."
	fi

else
	nls "Warning: Missing clusters config file %s" /etc/mysql/clusters.conf
	if [ -z "$MYSQL_DB_CLUSTERS"  ]; then
		nls "Warning: there are no configured clusters."
		nls "Using default cluster /var/lib/mysql (compatibility mode)"
		MYSQL_DB_CLUSTERS=/var/lib/mysql
	fi
fi


# Check that networking is up
if is_yes "${NETWORKING}"; then
	if [ ! -f /var/lock/subsys/network -a "$1" != stop -a "$1" != status -a "$1" != init ]; then
		msg_network_down MySQL
		exit 1
	fi
else
	exit 0
fi

action="$1"

# any db cluster as command line argument?
if [ $# -gt 1 ]; then
	shift
	# perform action for specified clusters only
	for a in "$@"; do
		# try auto resolving from /etc/mysql/clusters.conf
		if [[ "$a" != /* ]]; then
			m=$(awk -va="$a" -F= 'substr($0, 1, length(a)) == a {print $1}' /etc/mysql/clusters.conf)
			if [ -z "$m" ]; then
				echo >&2 "Cluster name '$a' did not match anything!"
				exit 1
			fi
			if [ $(echo "$m" | wc -l) -gt 1 ]; then
				echo >&2 "Cluster name '$a' ambiguous:" $m
				exit 1
			fi
			a=$(awk -va="$a" -F= 'substr($0, 1, length(a)) == a {print $2}' /etc/mysql/clusters.conf)
		fi
		DB_CLUSTERS="$DB_CLUSTERS $a"
	done
else
	DB_CLUSTERS="$MYSQL_DB_CLUSTERS"
fi

# global error log, if mysqld.conf hasn't migrated to log-error style
MYSQL_ERRLOG=/var/log/mysql/mysqld.log
MYSQL_STOP_WAIT_TIME=${MYSQL_STOP_WAIT_TIME:-900}

#
# Useful functions.
#

#
# check for mysql status
#
# arguments:
# $1 - db cluster
# $2 - start|stop
#
# sets variables:
# MYSQL_STATUS = starting | running | not running | died
# MYSQL_PID    = pid of mysqld process
#
mysqlstatus() {
	clusterdir="$1"
	mode="$2"
	
	mysqlgetconfig "$clusterdir"

	MYSQL_STATUS="not running"
	MYSQL_PID="unknown"
	MYSQL_PIDFILE_PID=""
	MYSQL_GREP_PID=""

	if [ -f "$MYSQL_PIDFILE" ]; then
		MYSQL_PIDFILE_PID=$(cat "$MYSQL_PIDFILE")
	fi
	
	if [ -n "$MYSQL_PIDFILE_PID" ]; then
		MYSQL_PID=$MYSQL_PIDFILE_PID
		if [ ! -d "/proc/$MYSQL_PID" ]; then
			MYSQL_STATUS="died"
			return
		elif (grep -qa "$MYSQL_PIDFILE" /proc/$MYSQL_PID/cmdline 2> /dev/null); then
			MYSQL_STATUS="running"
			return
		fi
	fi

	if [ "$mode" = "start" ]; then
		MYSQL_GREP_PID=$(grep -lE "^/usr/sbin/mysqld.*${MYSQL_PIDFILE}" /proc/[0-9]*/cmdline 2> /dev/null | awk -F "/" '{ print $3; exit; }')
		if [ -n "$MYSQL_GREP_PID" ]; then
			MYSQL_PID=$MYSQL_GREP_PID
			if grep -qa "$MYSQL_PIDFILE" /proc/$MYSQL_PID/cmdline 2> /dev/null; then
				if [ -f "$MYSQL_PIDFILE" ]; then
					MYSQL_PIDFILE_PID=$(cat "$MYSQL_PIDFILE")
				fi
				if [ -n "$MYSQL_PIDFILE_PID" ]; then
					MYSQL_PID=$MYSQL_PIDFILE_PID
					MYSQL_STATUS="running"
					return
				else
					MYSQL_STATUS="starting"
					return
				fi
			fi
		fi
	fi

	# else default, "not running"
}

# get mysql configuration in variables
# MYSQL_CONFIG MYSQL_DATA_DIR MYSQL_USER MYSQL_PIDFILE
#
# arguments
# $1 - db cluster

mysqlgetconfig() {
	clusterdir="$1"

	# emulate old behaviour if only one cluster specified
	if [ "$clusterdir" = "$MYSQL_DB_CLUSTERS" -a "$clusterdir" = "/var/lib/mysql" -a -f /etc/mysqld.conf ]; then
		MYSQL_RA_COMPAT=yes
		config_file=/etc/mysqld.conf
	else
		config=$(awk -F= -vclusterdir="$clusterdir" '!/^#/{ if (clusterdir == $2) print $1}' /etc/mysql/clusters.conf)
		if [[ $config = /* ]]; then
			config_file="$config"
		elif [ -f "/etc/mysql/$config" ]; then
			config_file="/etc/mysql/$config"
		else
			config_file="$clusterdir/mysqld.conf"
		fi
	fi

	MYSQL_CLUSTER_DIR="$clusterdir"

	if [ -z "$config_file" ]; then
		nls "Error: Can't find config file for %s cluster" "$clusterdir"
		exit 6
	else
		MYSQL_CONFIG="$config_file"
	fi

	if [ ! -f "$config_file" ]; then
		nls "Error: config file %s not found" "$config_file"
		nls "MySQL can't be run. Did you initialize DB by doing \`$0 init'?"
		exit 6
	fi

	eval `awk '
/^[ \t]*\[.*\][ \t]*$/ {
	match($0,/\[.*\]/)
	section=substr($0, RSTART + 1, RSTART + RLENGTH - 3)
}
section == "mysqld" && $2 ~ "=" {
	if ($1 == "datadir") {
		printf("MYSQL_DATA_DIR=%s;", $3)
	} else if ($1 == "user") {
		printf("MYSQL_USER=%s;", $3)
	} else if ($1 == "pid-file") {
		printf("MYSQL_PIDFILE=%s;", $3)
	} else if ($1 == "socket") {
		printf("MYSQL_SOCKET=%s;", $3)
	}
}
' $config_file`


	if is_yes "$MYSQL_RA_COMPAT"; then
		MYSQL_DATA_DIR_SUB=""
	else
		MYSQL_DATA_DIR_SUB="/mysqldb"
	fi

	if [ -z "$MYSQL_DATA_DIR" -o "$MYSQL_DATA_DIR" != "${clusterdir}${MYSQL_DATA_DIR_SUB}/db" ]; then
		nls "Error: datadir specified in %s should be %s" "$config_file" "$clusterdir${MYSQL_DATA_DIR_SUB}/db"
		nls " MySQL can't be run."
		exit 6
	fi

	if [ -z "$MYSQL_PIDFILE" -o "$MYSQL_PIDFILE" != "$clusterdir${MYSQL_DATA_DIR_SUB}/mysql.pid" ]; then
		nls "Error: pid-file specified in %s should be %s" "$config_file" "$clusterdir${MYSQL_DATA_DIR_SUB}/mysql.pid"
		nls " MySQL can't be run."
		exit 6
	fi

	if [ -z $MYSQL_USER ]; then
		echo "$(nls 'MySQL user not configured properly')"'!' >&2
		nls "Edit %s and configure it." "$config_file" >&2
		exit 6
	fi
}

# start mysql
mysqlstart() {
	clusterdir="$1"
	mysqlgetconfig "$clusterdir"
	if [ ! -d "$MYSQL_DATA_DIR/mysql" ]; then
		nls "MySQL cluster %s not initialized." "$clusterdir"
		nls "Try \`%s init %s' before start." "$0" "$clusterdir"
		exit 6
	fi

	msg_starting "MySQL $clusterdir"
	busy
	[ -z "$DEFAULT_SERVICE_RUN_NICE_LEVEL" ] && DEFAULT_SERVICE_RUN_NICE_LEVEL=0
	rm -f "$MYSQL_PIDFILE"

	if [ "$(grep -c ^log-error $MYSQL_CONFIG)" -lt 1 ]; then
		# error log not defined in config file. add one
		MYSQL_OPTIONS="$MYSQL_OPTIONS --log-error=$MYSQL_ERRLOG"
	fi

	TMPDIR=/tmp nice -n ${SERVICE_RUN_NICE_LEVEL:-$DEFAULT_SERVICE_RUN_NICE_LEVEL} \
		/usr/bin/setsid /usr/sbin/mysqld \
			--defaults-file=$MYSQL_CONFIG \
			--datadir=$MYSQL_DATA_DIR \
			--pid-file=$MYSQL_PIDFILE \
			$MYSQL_OPTIONS &
	pid=$!

	sleep 0.1
	mysqlstatus "$clusterdir" start
	# it takes longer for mysqld to start and create pidfile if it has to recover innodb transactions
	if [ "$MYSQL_STATUS" = "starting" ]; then
		echo ""
		show "Waiting for MySQL to start"
		busy

		# while the pid is running, mysql is starting up
		# if the pidfile was created, it started up successfully
		# if either case fails we break and report status
		while true; do
			[ -d /proc/$pid ] || break
			[ -f "$MYSQL_PIDFILE" ] && break
			sleep 0.2
		done
	fi

	mysqlstatus "$clusterdir" start
	if [ "$MYSQL_STATUS" = "running" -a "$MYSQL_PID" != "unknown" ]; then
		ok
	elif [ "$MYSQL_STATUS" = "died" ]; then
		RETVAL=1
		died
	else
		RETVAL=1
		fail
	fi
}

# stop mysql
mysqlstop() {
	clusterdir="$1"
	mysqlstatus "$clusterdir" stop
	msg_stopping "MySQL $clusterdir"
	busy

	# try graceful shutdown -- send shutdown command
	# requires mysql_sysadmin user proper privs
	/usr/bin/mysqladmin --defaults-file=$MYSQL_CONFIG ${MYSQL_SOCKET:+--socket=$MYSQL_SOCKET} shutdown >/dev/null 2>&1
	mysqlstatus "$clusterdir" stop

	if [ "$MYSQL_PID" != "unknown" ]; then
		kill -TERM "$MYSQL_PID" 2> /dev/null
		for nr in $(seq 1 $(($MYSQL_STOP_WAIT_TIME*10))); do
			[ -d "/proc/$MYSQL_PID" ] || break
			sleep 0.1
		done
	fi
	
	mysqlstatus "$clusterdir" stop
	if [ "$MYSQL_STATUS" = "died" ]; then
		died
	elif [ "$MYSQL_STATUS" = "running" -o "$MYSQL_STATUS" = "starting" ]; then
		fail
	else
		ok
	fi
}

#
# check for running mysql instances; if any instance is running then
# create subsys lock file
#
mysqlsubsys() {
	# check for every defined db cluster in sysconfig file
	for mysqldir in $DB_CLUSTERS; do
		mysqlstatus "$mysqldir"
		if [ "$MYSQL_STATUS" = "running" ]; then
			touch /var/lock/subsys/mysql
			return
		fi
	done
	rm -f /var/lock/subsys/mysql
}

mysqlinit() {
	clusterdir="$1"

	if [ -f /etc/mysqld.conf ]; then
		nls "Running in \`no cluster compat' mode: can't initialize database."
		nls "Move /etc/mysqld.conf away and rerun \`$0 init' (new config will be in $clusterdir)."
		exit 1
	fi

	if [ -f "$clusterdir/mysqld.conf" ]; then
		mysqlgetconfig "$clusterdir"
	else
		MYSQL_USER="mysql"
		MYSQL_CLUSTER_DIR="$clusterdir"
		MYSQL_DATA_DIR="$clusterdir/mysqldb/db"
		MYSQL_PIDFILE="$clusterdir/mysqldb/mysql.pid"
		MYSQL_SOCKET="$clusterdir/mysqldb/mysql.sock"

		# this $MYSQL_CONFIG will be created later
		MYSQL_CONFIG="$MYSQL_CLUSTER_DIR/mysqld.conf"
	fi

	show "Initializing cluster %s" "$clusterdir"; echo

	# Check if not exist init database
	if [ -d "$MYSQL_DATA_DIR/mysql" ]; then
		nls "Seems that database is initialized now. Remove by hand %s" "$MYSQL_DATA_DIR/mysql"
		nls "before initializing database."
		nls "For now skipping cluster %s." "$clusterdir"
		return
	fi

	show "Installing MySQL system tables for $MYSQL_DATA_DIR"
	busy
	TMP=/tmp TMPDIR=/tmp

	mkdir -p "$MYSQL_DATA_DIR" > /dev/null 2>&1
	# Using mysql:mysql for MYSQL_CLUSTER_DIR is creating SECURITY hole, root:root is proper
	chown root:root "$MYSQL_CLUSTER_DIR"
	chown mysql:mysql "$MYSQL_CLUSTER_DIR/mysqldb" "$MYSQL_DATA_DIR" > /dev/null 2>&1
	chmod 751 "$MYSQL_CLUSTER_DIR" "$MYSQL_CLUSTER_DIR/mysqldb"

	if [ -f /usr/share/mysql/mysqld.conf -a ! -f "$MYSQL_CLUSTER_DIR/mysqld.conf" ]; then
	    sed -e "
		s#\(datadir.*\)=.*#\1= $MYSQL_DATA_DIR#g;
		s#\(pid-file.*\)=.*#\1= $MYSQL_PIDFILE#g;
		s#\(socket.*\)=.*#\1= $MYSQL_SOCKET#g;
		s#@clusterdir@#$MYSQL_CLUSTER_DIR#g;
		" /usr/share/mysql/mysqld.conf > "$MYSQL_CLUSTER_DIR/mysqld.conf"
	    chown root:root "$MYSQL_CLUSTER_DIR/mysqld.conf"
	    chmod 640 "$MYSQL_CLUSTER_DIR/mysqld.conf"
	fi

	if [ ! -e /var/lib/mysql/mysql.sock ] || [ -L /var/lib/mysql/mysql.sock ] && [ -z "$(readlink /var/lib/mysql/mysql.sock)" ]; then
		sock=${MYSQL_SOCKET#/var/lib/mysql/} # make it relative if possible
	    ln -s "$sock" /var/lib/mysql/mysql.sock
	fi

	cat > $MYSQL_DATA_DIR/mysql-init.sql <<-EOF
		CREATE DATABASE mysql;
		use mysql;
		$(cat /usr/share/mysql/mysql_system_tables.sql)
		$(sed -e "/@current_hostname/d" /usr/share/mysql/mysql_system_tables_data.sql)
EOF

	ok=0
	/usr/sbin/mysqld --bootstrap --skip-grant-tables \
		--datadir=$MYSQL_DATA_DIR --user=$MYSQL_USER \
		--slave-load-tmpdir=$MYSQL_DATA_DIR --tmpdir=$MYSQL_DATA_DIR --log-error=$MYSQL_ERRLOG \
		< $MYSQL_DATA_DIR/mysql-init.sql && ok=1
	[ -f $MYSQL_DATA_DIR/mysql/host.frm ] || ok=0

	if [ "$ok" = 1 ]; then
		rm -f $MYSQL_DATA_DIR/mysql-init.sql
		ok
		cat << END_OF_MSG

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL USERS!
This is done, after starting database, in the order shown,
with:

For 'mysql_sysadmin' (RELOAD and SHUTDOWN privileges):
echo "update mysql.user set password=password('newpassword') where user='mysql_sysadmin'; FLUSH PRIVILEGES;" | mysql -u mysql -S $MYSQL_SOCKET

For 'mysql' user (ALL privileges, DB admin):
echo "update mysql.user set password=password('newpassword') where user='mysql'; FLUSH PRIVILEGES;" | mysql -u mysql -S $MYSQL_SOCKET

NOTE: mysql_sysadmin password should be placed to $MYSQL_CONFIG in
mysqladmin section. See the manual for more instructions.
(This user is used at logs rotation and server shutdown)

END_OF_MSG
		show "Filling help tables..."
		ok=0
		( echo "use mysql;"; cat /usr/share/mysql/fill_help_tables.sql ) | \
			/usr/sbin/mysqld --bootstrap --skip-grant-tables \
			--datadir=$MYSQL_DATA_DIR --user=$MYSQL_USER \
			--slave-load-tmpdir=$MYSQL_DATA_DIR --tmpdir=$MYSQL_DATA_DIR --log-error=$MYSQL_ERRLOG \
			&& ok=1
		if [ "$ok" = 1 ]; then
			ok
		else
			cat << END_OF_MSG

WARNING: HELP FILES ARE NOT COMPLETELY INSTALLED!
The "HELP" command might not work properly.

END_OF_MSG
		fi
	else
		fail
		cat << END_OF_MSG
Installation of grant tables FAILED!

The initialization SQL script was preserved at $MYSQL_DATA_DIR/mysql-init.sql

Examine the logs in /var/log/mysql for more information.  You can
also try to start the mysqld daemon with:

/usr/sbin/mysqld --skip-grant &

You can use the command line tool mysql to connect to the mysql
database and look at the grant tables:

shell> mysql -u mysql mysql
mysql> show tables

Try 'mysqld --help' if you have problems with paths. Setting on
logging in /etc/mysqld.conf gives you a log in /var/log/mysql/log that
may be helpful. The latest information about MySQL is available on the
web at http://www.mysql.com/.

Please check PLD Linux ftp site for newer versions of this package.

Please consult the MySQL manual section: 'Problems running
mysql_install_db', and the manual section that describes problems on
your OS.  Another information source is the MySQL email archive.
Please check all of the above before mailing us!  And if you do mail
us, you MUST use the mysqlbug script!

END_OF_MSG
		exit 1
	fi
}

#
# End of useful functions.
#

start() {
	for mysqldir in $DB_CLUSTERS; do
		mysqlstatus "$mysqldir" start
		if [ "$MYSQL_STATUS" = "running" ]; then
			msg_already_running "MySQL $mysqldir"
		else
			mysqlstart "$mysqldir"
		fi
	done
	mysqlsubsys
}

stop() {
	for mysqldir in $DB_CLUSTERS; do
		mysqlstatus "$mysqldir" stop
		if [ "$MYSQL_STATUS" = "not running" ]; then
			msg_not_running "MySQL $mysqldir"
		else
			mysqlstop "$mysqldir"
		fi
	done
	mysqlsubsys
}

condrestart() {
	if [ -f /var/lock/subsys/mysql ]; then
		stop
		start
	else
		msg_not_running "MySQL"
		RETVAL=$1
	fi
}

RETVAL=0
case "$action" in
  start)
  	start
	;;
  stop)
  	stop
	;;
  restart)
	stop
	start
	;;
  try-restart)
	condrestart 0
	;;
  force-reload)
	condrestart 7
	;;
  status)
	for mysqldir in $DB_CLUSTERS; do
		mysqlstatus "$mysqldir"
		if [ "$MYSQL_STATUS" = "running" ]; then
			show "MySQL cluster %s, PID %s" "$mysqldir" "$MYSQL_PID"
			pids="$pids/$MYSQL_PID/"
			progress "$MYSQL_STATUS"
		else
			show "MySQL cluster %s" "$mysqldir"
			progress "$MYSQL_STATUS" "$CFAIL"
		fi
		echo
	done

	for pid in $(/sbin/pidof mysqld); do
		if [[ $pids != */$pid/* ]]; then
			running="$running $pid"
		fi
	done

	if [ $# -gt 1 -a "$running" ]; then
		nls "Warning: MySQL Daemon processes not under clusters.conf control:"
		# see if we can display their status
		for pid in $running; do
			datadir=$(cat /proc/$pid/cmdline | tr '\0' '\n' | fgrep -- --datadir=)
			datadir=${datadir#--datadir=} # strip --datadir
			mysqldir=${datadir%/mysqldb/db} # strip /mysqldb/db
			mysqlstatus "$mysqldir"
			if [ "$MYSQL_STATUS" = "running" ]; then
				show "MySQL cluster %s, PID %s" "$mysqldir" "$pid"
				progress "$MYSQL_STATUS"
			else
				show "MySQL cluster %s" "$mysqldir"
				progress "$MYSQL_STATUS" "$CFAIL"
			fi
			echo
		done
	fi
	;;
  init)
	for mysqldir in $DB_CLUSTERS; do
		mysqlinit "$mysqldir"
	done
	exit $?
	;;
  flush-logs)
  	for mysqldir in $DB_CLUSTERS; do
	    mysqlgetconfig "$mysqldir"
		# just if mysqld is really running
		if /usr/bin/mysqladmin --defaults-file="$MYSQL_CONFIG" --socket="$MYSQL_SOCKET" ping >/dev/null 2>&1; then
			/usr/bin/mysqladmin --defaults-file="$MYSQL_CONFIG" --socket="$MYSQL_SOCKET" flush-logs
		fi
	done
	;;
  *)
	msg_usage "$0 {start|stop|init|restart|try-restart|force-reload|status}"
	exit 3
esac

exit $RETVAL
Commit	Line	Data
	1	#!/bin/sh
	2	#
	3	# mysql A very fast and reliable SQL database engine
	4	#
	5	# chkconfig: 2345 84 25
	6	#
	7	# description: A very fast and reliable SQL database engine.
	8	#
	9	# $Id$
	10
	11	# Source function library
	12	. /etc/rc.d/init.d/functions
	13
	14	# Get network config
	15	. /etc/sysconfig/network
	16
	17	# Get service config
	18	if [ -f /etc/sysconfig/mysql ]; then
	19	. /etc/sysconfig/mysql
	20	else
	21	nls "Error: %s not found" /etc/sysconfig/mysql
	22	nls "%s can't be run." MySQL
	23	exit 1
	24	fi
	25
	26	if [ -n "$MYSQL_DB_CLUSTERS" ]; then
	27	nls "Warning: MYSQL_DB_CLUSTERS is set. It's obsolete. Use %s instead." /etc/mysql/clusters.conf
	28	fi
	29
	30	if [ -f /etc/mysql/clusters.conf ]; then
	31	MYSQL_DB_CLUSTERS=$(awk -F= '!/^#/{print $2}' /etc/mysql/clusters.conf)
	32	if [ -z "$MYSQL_DB_CLUSTERS" ]; then
	33	nls "Warning: there are no configured clusters."
	34	fi
	35
	36	else
	37	nls "Warning: Missing clusters config file %s" /etc/mysql/clusters.conf
	38	if [ -z "$MYSQL_DB_CLUSTERS" ]; then
	39	nls "Warning: there are no configured clusters."
	40	nls "Using default cluster /var/lib/mysql (compatibility mode)"
	41	MYSQL_DB_CLUSTERS=/var/lib/mysql
	42	fi
	43	fi
	44
	45
	46	# Check that networking is up
	47	if is_yes "${NETWORKING}"; then
	48	if [ ! -f /var/lock/subsys/network -a "$1" != stop -a "$1" != status -a "$1" != init ]; then
	49	msg_network_down MySQL
	50	exit 1
	51	fi
	52	else
	53	exit 0
	54	fi
	55
	56	action="$1"
	57
	58	# any db cluster as command line argument?
	59	if [ $# -gt 1 ]; then
	60	shift
	61	# perform action for specified clusters only
	62	for a in "$@"; do
	63	# try auto resolving from /etc/mysql/clusters.conf
	64	if [[ "$a" != /* ]]; then
	65	m=$(awk -va="$a" -F= 'substr($0, 1, length(a)) == a {print $1}' /etc/mysql/clusters.conf)
	66	if [ -z "$m" ]; then
	67	echo >&2 "Cluster name '$a' did not match anything!"
	68	exit 1
	69	fi
	70	if [ $(echo "$m" \| wc -l) -gt 1 ]; then
	71	echo >&2 "Cluster name '$a' ambiguous:" $m
	72	exit 1
	73	fi
	74	a=$(awk -va="$a" -F= 'substr($0, 1, length(a)) == a {print $2}' /etc/mysql/clusters.conf)
	75	fi
	76	DB_CLUSTERS="$DB_CLUSTERS $a"
	77	done
	78	else
	79	DB_CLUSTERS="$MYSQL_DB_CLUSTERS"
	80	fi
	81
	82	# global error log, if mysqld.conf hasn't migrated to log-error style
	83	MYSQL_ERRLOG=/var/log/mysql/mysqld.log
	84	MYSQL_STOP_WAIT_TIME=${MYSQL_STOP_WAIT_TIME:-900}
	85
	86	#
	87	# Useful functions.
	88	#
	89
	90	#
	91	# check for mysql status
	92	#
	93	# arguments:
	94	# $1 - db cluster
	95	# $2 - start\|stop
	96	#
	97	# sets variables:
	98	# MYSQL_STATUS = starting \| running \| not running \| died
	99	# MYSQL_PID = pid of mysqld process
	100	#
	101	mysqlstatus() {
	102	clusterdir="$1"
	103	mode="$2"
	104
	105	mysqlgetconfig "$clusterdir"
	106
	107	MYSQL_STATUS="not running"
	108	MYSQL_PID="unknown"
	109	MYSQL_PIDFILE_PID=""
	110	MYSQL_GREP_PID=""
	111
	112	if [ -f "$MYSQL_PIDFILE" ]; then
	113	MYSQL_PIDFILE_PID=$(cat "$MYSQL_PIDFILE")
	114	fi
	115
	116	if [ -n "$MYSQL_PIDFILE_PID" ]; then
	117	MYSQL_PID=$MYSQL_PIDFILE_PID
	118	if [ ! -d "/proc/$MYSQL_PID" ]; then
	119	MYSQL_STATUS="died"
	120	return
	121	elif (grep -qa "$MYSQL_PIDFILE" /proc/$MYSQL_PID/cmdline 2> /dev/null); then
	122	MYSQL_STATUS="running"
	123	return
	124	fi
	125	fi
	126
	127	if [ "$mode" = "start" ]; then
	128	MYSQL_GREP_PID=$(grep -lE "^/usr/sbin/mysqld.${MYSQL_PIDFILE}" /proc/[0-9]/cmdline 2> /dev/null \| awk -F "/" '{ print $3; exit; }')
	129	if [ -n "$MYSQL_GREP_PID" ]; then
	130	MYSQL_PID=$MYSQL_GREP_PID
	131	if grep -qa "$MYSQL_PIDFILE" /proc/$MYSQL_PID/cmdline 2> /dev/null; then
	132	if [ -f "$MYSQL_PIDFILE" ]; then
	133	MYSQL_PIDFILE_PID=$(cat "$MYSQL_PIDFILE")
	134	fi
	135	if [ -n "$MYSQL_PIDFILE_PID" ]; then
	136	MYSQL_PID=$MYSQL_PIDFILE_PID
	137	MYSQL_STATUS="running"
	138	return
	139	else
	140	MYSQL_STATUS="starting"
	141	return
	142	fi
	143	fi
	144	fi
	145	fi
	146
	147	# else default, "not running"
	148	}
	149
	150	# get mysql configuration in variables
	151	# MYSQL_CONFIG MYSQL_DATA_DIR MYSQL_USER MYSQL_PIDFILE
	152	#
	153	# arguments
	154	# $1 - db cluster
	155
	156	mysqlgetconfig() {
	157	clusterdir="$1"
	158
	159	# emulate old behaviour if only one cluster specified
	160	if [ "$clusterdir" = "$MYSQL_DB_CLUSTERS" -a "$clusterdir" = "/var/lib/mysql" -a -f /etc/mysqld.conf ]; then
	161	MYSQL_RA_COMPAT=yes
	162	config_file=/etc/mysqld.conf
	163	else
	164	config=$(awk -F= -vclusterdir="$clusterdir" '!/^#/{ if (clusterdir == $2) print $1}' /etc/mysql/clusters.conf)
	165	if [[ $config = /* ]]; then
	166	config_file="$config"
	167	elif [ -f "/etc/mysql/$config" ]; then
	168	config_file="/etc/mysql/$config"
	169	else
	170	config_file="$clusterdir/mysqld.conf"
	171	fi
	172	fi
	173
	174	MYSQL_CLUSTER_DIR="$clusterdir"
	175
	176	if [ -z "$config_file" ]; then
	177	nls "Error: Can't find config file for %s cluster" "$clusterdir"
	178	exit 6
	179	else
	180	MYSQL_CONFIG="$config_file"
	181	fi
	182
	183	if [ ! -f "$config_file" ]; then
	184	nls "Error: config file %s not found" "$config_file"
	185	nls "MySQL can't be run. Did you initialize DB by doing \`$0 init'?"
	186	exit 6
	187	fi
	188
	189	eval `awk '
	190	/^[ \t]\[.\][ \t]*$/ {
	191	match($0,/\[.*\]/)
	192	section=substr($0, RSTART + 1, RSTART + RLENGTH - 3)
	193	}
	194	section == "mysqld" && $2 ~ "=" {
	195	if ($1 == "datadir") {
	196	printf("MYSQL_DATA_DIR=%s;", $3)
	197	} else if ($1 == "user") {
	198	printf("MYSQL_USER=%s;", $3)
	199	} else if ($1 == "pid-file") {
	200	printf("MYSQL_PIDFILE=%s;", $3)
	201	} else if ($1 == "socket") {
	202	printf("MYSQL_SOCKET=%s;", $3)
	203	}
	204	}
	205	' $config_file`
	206
	207
	208	if is_yes "$MYSQL_RA_COMPAT"; then
	209	MYSQL_DATA_DIR_SUB=""
	210	else
	211	MYSQL_DATA_DIR_SUB="/mysqldb"
	212	fi
	213
	214	if [ -z "$MYSQL_DATA_DIR" -o "$MYSQL_DATA_DIR" != "${clusterdir}${MYSQL_DATA_DIR_SUB}/db" ]; then
	215	nls "Error: datadir specified in %s should be %s" "$config_file" "$clusterdir${MYSQL_DATA_DIR_SUB}/db"
	216	nls " MySQL can't be run."
	217	exit 6
	218	fi
	219
	220	if [ -z "$MYSQL_PIDFILE" -o "$MYSQL_PIDFILE" != "$clusterdir${MYSQL_DATA_DIR_SUB}/mysql.pid" ]; then
	221	nls "Error: pid-file specified in %s should be %s" "$config_file" "$clusterdir${MYSQL_DATA_DIR_SUB}/mysql.pid"
	222	nls " MySQL can't be run."
	223	exit 6
	224	fi
	225
	226	if [ -z $MYSQL_USER ]; then
	227	echo "$(nls 'MySQL user not configured properly')"'!' >&2
	228	nls "Edit %s and configure it." "$config_file" >&2
	229	exit 6
	230	fi
	231	}
	232
	233	# start mysql
	234	mysqlstart() {
	235	clusterdir="$1"
	236	mysqlgetconfig "$clusterdir"
	237	if [ ! -d "$MYSQL_DATA_DIR/mysql" ]; then
	238	nls "MySQL cluster %s not initialized." "$clusterdir"
	239	nls "Try \`%s init %s' before start." "$0" "$clusterdir"
	240	exit 6
	241	fi
	242
	243	msg_starting "MySQL $clusterdir"
	244	busy
	245	[ -z "$DEFAULT_SERVICE_RUN_NICE_LEVEL" ] && DEFAULT_SERVICE_RUN_NICE_LEVEL=0
	246	rm -f "$MYSQL_PIDFILE"
	247
	248	if [ "$(grep -c ^log-error $MYSQL_CONFIG)" -lt 1 ]; then
	249	# error log not defined in config file. add one
	250	MYSQL_OPTIONS="$MYSQL_OPTIONS --log-error=$MYSQL_ERRLOG"
	251	fi
	252
	253	TMPDIR=/tmp nice -n ${SERVICE_RUN_NICE_LEVEL:-$DEFAULT_SERVICE_RUN_NICE_LEVEL} \
	254	/usr/bin/setsid /usr/sbin/mysqld \
	255	--defaults-file=$MYSQL_CONFIG \
	256	--datadir=$MYSQL_DATA_DIR \
	257	--pid-file=$MYSQL_PIDFILE \
	258	$MYSQL_OPTIONS &
	259	pid=$!
	260
	261	sleep 0.1
	262	mysqlstatus "$clusterdir" start
	263	# it takes longer for mysqld to start and create pidfile if it has to recover innodb transactions
	264	if [ "$MYSQL_STATUS" = "starting" ]; then
	265	echo ""
	266	show "Waiting for MySQL to start"
	267	busy
	268
	269	# while the pid is running, mysql is starting up
	270	# if the pidfile was created, it started up successfully
	271	# if either case fails we break and report status
	272	while true; do
	273	[ -d /proc/$pid ] \|\| break
	274	[ -f "$MYSQL_PIDFILE" ] && break
	275	sleep 0.2
	276	done
	277	fi
	278
	279	mysqlstatus "$clusterdir" start
	280	if [ "$MYSQL_STATUS" = "running" -a "$MYSQL_PID" != "unknown" ]; then
	281	ok
	282	elif [ "$MYSQL_STATUS" = "died" ]; then
	283	RETVAL=1
	284	died
	285	else
	286	RETVAL=1
	287	fail
	288	fi
	289	}
	290
	291	# stop mysql
	292	mysqlstop() {
	293	clusterdir="$1"
	294	mysqlstatus "$clusterdir" stop
	295	msg_stopping "MySQL $clusterdir"
	296	busy
	297
	298	# try graceful shutdown -- send shutdown command
	299	# requires mysql_sysadmin user proper privs
	300	/usr/bin/mysqladmin --defaults-file=$MYSQL_CONFIG ${MYSQL_SOCKET:+--socket=$MYSQL_SOCKET} shutdown >/dev/null 2>&1
	301	mysqlstatus "$clusterdir" stop
	302
	303	if [ "$MYSQL_PID" != "unknown" ]; then
	304	kill -TERM "$MYSQL_PID" 2> /dev/null
	305	for nr in $(seq 1 $(($MYSQL_STOP_WAIT_TIME*10))); do
	306	[ -d "/proc/$MYSQL_PID" ] \|\| break
	307	sleep 0.1
	308	done
	309	fi
	310
	311	mysqlstatus "$clusterdir" stop
	312	if [ "$MYSQL_STATUS" = "died" ]; then
	313	died
	314	elif [ "$MYSQL_STATUS" = "running" -o "$MYSQL_STATUS" = "starting" ]; then
	315	fail
	316	else
	317	ok
	318	fi
	319	}
	320
	321	#
	322	# check for running mysql instances; if any instance is running then
	323	# create subsys lock file
	324	#
	325	mysqlsubsys() {
	326	# check for every defined db cluster in sysconfig file
	327	for mysqldir in $DB_CLUSTERS; do
	328	mysqlstatus "$mysqldir"
	329	if [ "$MYSQL_STATUS" = "running" ]; then
	330	touch /var/lock/subsys/mysql
	331	return
	332	fi
	333	done
	334	rm -f /var/lock/subsys/mysql
	335	}
	336
	337	mysqlinit() {
	338	clusterdir="$1"
	339
	340	if [ -f /etc/mysqld.conf ]; then
	341	nls "Running in \`no cluster compat' mode: can't initialize database."
	342	nls "Move /etc/mysqld.conf away and rerun \`$0 init' (new config will be in $clusterdir)."
	343	exit 1
	344	fi
	345
	346	if [ -f "$clusterdir/mysqld.conf" ]; then
	347	mysqlgetconfig "$clusterdir"
	348	else
	349	MYSQL_USER="mysql"
	350	MYSQL_CLUSTER_DIR="$clusterdir"
	351	MYSQL_DATA_DIR="$clusterdir/mysqldb/db"
	352	MYSQL_PIDFILE="$clusterdir/mysqldb/mysql.pid"
	353	MYSQL_SOCKET="$clusterdir/mysqldb/mysql.sock"
	354
	355	# this $MYSQL_CONFIG will be created later
	356	MYSQL_CONFIG="$MYSQL_CLUSTER_DIR/mysqld.conf"
	357	fi
	358
	359	show "Initializing cluster %s" "$clusterdir"; echo
	360
	361	# Check if not exist init database
	362	if [ -d "$MYSQL_DATA_DIR/mysql" ]; then
	363	nls "Seems that database is initialized now. Remove by hand %s" "$MYSQL_DATA_DIR/mysql"
	364	nls "before initializing database."
	365	nls "For now skipping cluster %s." "$clusterdir"
	366	return
	367	fi
	368
	369	show "Installing MySQL system tables for $MYSQL_DATA_DIR"
	370	busy
	371	TMP=/tmp TMPDIR=/tmp
	372
	373	mkdir -p "$MYSQL_DATA_DIR" > /dev/null 2>&1
	374	# Using mysql:mysql for MYSQL_CLUSTER_DIR is creating SECURITY hole, root:root is proper
	375	chown root:root "$MYSQL_CLUSTER_DIR"
	376	chown mysql:mysql "$MYSQL_CLUSTER_DIR/mysqldb" "$MYSQL_DATA_DIR" > /dev/null 2>&1
	377	chmod 751 "$MYSQL_CLUSTER_DIR" "$MYSQL_CLUSTER_DIR/mysqldb"
	378
	379	if [ -f /usr/share/mysql/mysqld.conf -a ! -f "$MYSQL_CLUSTER_DIR/mysqld.conf" ]; then
	380	sed -e "
	381	s#\(datadir.\)=.#\1= $MYSQL_DATA_DIR#g;
	382	s#\(pid-file.\)=.#\1= $MYSQL_PIDFILE#g;
	383	s#\(socket.\)=.#\1= $MYSQL_SOCKET#g;
	384	s#@clusterdir@#$MYSQL_CLUSTER_DIR#g;
	385	" /usr/share/mysql/mysqld.conf > "$MYSQL_CLUSTER_DIR/mysqld.conf"
	386	chown root:root "$MYSQL_CLUSTER_DIR/mysqld.conf"
	387	chmod 640 "$MYSQL_CLUSTER_DIR/mysqld.conf"
	388	fi
	389
	390	if [ ! -e /var/lib/mysql/mysql.sock ] \|\| [ -L /var/lib/mysql/mysql.sock ] && [ -z "$(readlink /var/lib/mysql/mysql.sock)" ]; then
	391	sock=${MYSQL_SOCKET#/var/lib/mysql/} # make it relative if possible
	392	ln -s "$sock" /var/lib/mysql/mysql.sock
	393	fi
	394
	395	cat > $MYSQL_DATA_DIR/mysql-init.sql <<-EOF
	396	CREATE DATABASE mysql;
	397	use mysql;
	398	$(cat /usr/share/mysql/mysql_system_tables.sql)
	399	$(sed -e "/@current_hostname/d" /usr/share/mysql/mysql_system_tables_data.sql)
	400	EOF
	401
	402	ok=0
	403	/usr/sbin/mysqld --bootstrap --skip-grant-tables \
	404	--datadir=$MYSQL_DATA_DIR --user=$MYSQL_USER \
	405	--slave-load-tmpdir=$MYSQL_DATA_DIR --tmpdir=$MYSQL_DATA_DIR --log-error=$MYSQL_ERRLOG \
	406	< $MYSQL_DATA_DIR/mysql-init.sql && ok=1
	407	[ -f $MYSQL_DATA_DIR/mysql/host.frm ] \|\| ok=0
	408
	409	if [ "$ok" = 1 ]; then
	410	rm -f $MYSQL_DATA_DIR/mysql-init.sql
	411	ok
	412	cat << END_OF_MSG
	413
	414	PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL USERS!
	415	This is done, after starting database, in the order shown,
	416	with:
	417
	418	For 'mysql_sysadmin' (RELOAD and SHUTDOWN privileges):
	419	echo "update mysql.user set password=password('newpassword') where user='mysql_sysadmin'; FLUSH PRIVILEGES;" \| mysql -u mysql -S $MYSQL_SOCKET
	420
	421	For 'mysql' user (ALL privileges, DB admin):
	422	echo "update mysql.user set password=password('newpassword') where user='mysql'; FLUSH PRIVILEGES;" \| mysql -u mysql -S $MYSQL_SOCKET
	423
	424	NOTE: mysql_sysadmin password should be placed to $MYSQL_CONFIG in
	425	mysqladmin section. See the manual for more instructions.
	426	(This user is used at logs rotation and server shutdown)
	427
	428	END_OF_MSG
	429	show "Filling help tables..."
	430	ok=0
	431	( echo "use mysql;"; cat /usr/share/mysql/fill_help_tables.sql ) \| \
	432	/usr/sbin/mysqld --bootstrap --skip-grant-tables \
	433	--datadir=$MYSQL_DATA_DIR --user=$MYSQL_USER \
	434	--slave-load-tmpdir=$MYSQL_DATA_DIR --tmpdir=$MYSQL_DATA_DIR --log-error=$MYSQL_ERRLOG \
	435	&& ok=1
	436	if [ "$ok" = 1 ]; then
	437	ok
	438	else
	439	cat << END_OF_MSG
	440
	441	WARNING: HELP FILES ARE NOT COMPLETELY INSTALLED!
	442	The "HELP" command might not work properly.
	443
	444	END_OF_MSG
	445	fi
	446	else
	447	fail
	448	cat << END_OF_MSG
	449	Installation of grant tables FAILED!
	450
	451	The initialization SQL script was preserved at $MYSQL_DATA_DIR/mysql-init.sql
	452
	453	Examine the logs in /var/log/mysql for more information. You can
	454	also try to start the mysqld daemon with:
	455
	456	/usr/sbin/mysqld --skip-grant &
	457
	458	You can use the command line tool mysql to connect to the mysql
	459	database and look at the grant tables:
	460
	461	shell> mysql -u mysql mysql
	462	mysql> show tables
	463
	464	Try 'mysqld --help' if you have problems with paths. Setting on
	465	logging in /etc/mysqld.conf gives you a log in /var/log/mysql/log that
	466	may be helpful. The latest information about MySQL is available on the
	467	web at http://www.mysql.com/.
	468
	469	Please check PLD Linux ftp site for newer versions of this package.
	470
	471	Please consult the MySQL manual section: 'Problems running
	472	mysql_install_db', and the manual section that describes problems on
	473	your OS. Another information source is the MySQL email archive.
	474	Please check all of the above before mailing us! And if you do mail
	475	us, you MUST use the mysqlbug script!
	476
	477	END_OF_MSG
	478	exit 1
	479	fi
	480	}
	481
	482	#
	483	# End of useful functions.
	484	#
	485
	486	start() {
	487	for mysqldir in $DB_CLUSTERS; do
	488	mysqlstatus "$mysqldir" start
	489	if [ "$MYSQL_STATUS" = "running" ]; then
	490	msg_already_running "MySQL $mysqldir"
	491	else
	492	mysqlstart "$mysqldir"
	493	fi
	494	done
	495	mysqlsubsys
	496	}
	497
	498	stop() {
	499	for mysqldir in $DB_CLUSTERS; do
	500	mysqlstatus "$mysqldir" stop
	501	if [ "$MYSQL_STATUS" = "not running" ]; then
	502	msg_not_running "MySQL $mysqldir"
	503	else
	504	mysqlstop "$mysqldir"
	505	fi
	506	done
	507	mysqlsubsys
	508	}
	509
	510	condrestart() {
	511	if [ -f /var/lock/subsys/mysql ]; then
	512	stop
	513	start
	514	else
	515	msg_not_running "MySQL"
	516	RETVAL=$1
	517	fi
	518	}
	519
	520	RETVAL=0
	521	case "$action" in
	522	start)
	523	start
	524	;;
	525	stop)
	526	stop
	527	;;
	528	restart)
	529	stop
	530	start
	531	;;
	532	try-restart)
	533	condrestart 0
	534	;;
	535	force-reload)
	536	condrestart 7
	537	;;
	538	status)
	539	for mysqldir in $DB_CLUSTERS; do
	540	mysqlstatus "$mysqldir"
	541	if [ "$MYSQL_STATUS" = "running" ]; then
	542	show "MySQL cluster %s, PID %s" "$mysqldir" "$MYSQL_PID"
	543	pids="$pids/$MYSQL_PID/"
	544	progress "$MYSQL_STATUS"
	545	else
	546	show "MySQL cluster %s" "$mysqldir"
	547	progress "$MYSQL_STATUS" "$CFAIL"
	548	fi
	549	echo
	550	done
	551
	552	for pid in $(/sbin/pidof mysqld); do
	553	if [[ $pids != /$pid/ ]]; then
	554	running="$running $pid"
	555	fi
	556	done
	557
	558	if [ $# -gt 1 -a "$running" ]; then
	559	nls "Warning: MySQL Daemon processes not under clusters.conf control:"
	560	# see if we can display their status
	561	for pid in $running; do
	562	datadir=$(cat /proc/$pid/cmdline \| tr '\0' '\n' \| fgrep -- --datadir=)
	563	datadir=${datadir#--datadir=} # strip --datadir
	564	mysqldir=${datadir%/mysqldb/db} # strip /mysqldb/db
	565	mysqlstatus "$mysqldir"
	566	if [ "$MYSQL_STATUS" = "running" ]; then
	567	show "MySQL cluster %s, PID %s" "$mysqldir" "$pid"
	568	progress "$MYSQL_STATUS"
	569	else
	570	show "MySQL cluster %s" "$mysqldir"
	571	progress "$MYSQL_STATUS" "$CFAIL"
	572	fi
	573	echo
	574	done
	575	fi
	576	;;
	577	init)
	578	for mysqldir in $DB_CLUSTERS; do
	579	mysqlinit "$mysqldir"
	580	done
	581	exit $?
	582	;;
	583	flush-logs)
	584	for mysqldir in $DB_CLUSTERS; do
	585	mysqlgetconfig "$mysqldir"
	586	# just if mysqld is really running
	587	if /usr/bin/mysqladmin --defaults-file="$MYSQL_CONFIG" --socket="$MYSQL_SOCKET" ping >/dev/null 2>&1; then
	588	/usr/bin/mysqladmin --defaults-file="$MYSQL_CONFIG" --socket="$MYSQL_SOCKET" flush-logs
	589	fi
	590	done
	591	;;
	592	*)
	593	msg_usage "$0 {start\|stop\|init\|restart\|try-restart\|force-reload\|status}"
	594	exit 3
	595	esac
	596
	597	exit $RETVAL