[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
53a28f77	1	#!/bin/sh
53a28f77	2	#
7429b124	3	# mysql A very fast and reliable SQL database engine
53a28f77	4	#
7429b124	5	# chkconfig: 2345 84 25
53a28f77	6	#
350d9d8c	7	# description: A very fast and reliable SQL database engine.
53a28f77	8	#
0b079830 ER	9	# $Id$
0b079830 ER	10
53a28f77	11	# Source function library
	12	. /etc/rc.d/init.d/functions
	13
	14	# Get network config
	15	. /etc/sysconfig/network
	16
aac2c31f AM	17	# Get service config
aac2c31f AM	18	if [ -f /etc/sysconfig/mysql ]; then
350d9d8c	19	. /etc/sysconfig/mysql
aac2c31f	20	else
350d9d8c	21	nls "Error: %s not found" /etc/sysconfig/mysql
95b0575d	22	nls "%s can't be run." MySQL
350d9d8c PG	23	exit 1
	24	fi
	25
0146fae1	26	if [ -n "$MYSQL_DB_CLUSTERS" ]; then
350d9d8c	27	nls "Warning: MYSQL_DB_CLUSTERS is set. It's obsolete. Use %s instead." /etc/mysql/clusters.conf
aac2c31f AM	28	fi
aac2c31f AM	29
95b0575d	30	if [ -f /etc/mysql/clusters.conf ]; then
0ca65658	31	MYSQL_DB_CLUSTERS=$(awk -F= '!/^#/{print $2}' /etc/mysql/clusters.conf)
95b0575d ER	32	if [ -z "$MYSQL_DB_CLUSTERS" ]; then
	33	nls "Warning: there are no configured clusters."
	34	fi
0146fae1	35
95b0575d	36	else
0146fae1	37	nls "Warning: Missing clusters config file %s" /etc/mysql/clusters.conf
95b0575d ER	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
aac2c31f AM	43	fi
aac2c31f AM	44
95b0575d	45
ac28c610	46	# Check that networking is up
8eb71226	47	if is_yes "${NETWORKING}"; then
213fc2f2	48	if [ ! -f /var/lock/subsys/network -a "$1" != stop -a "$1" != status -a "$1" != init ]; then
8eb71226	49	msg_network_down MySQL
	50	exit 1
	51	fi
	52	else
	53	exit 0
e9ca44ab	54	fi
e9ca44ab	55
aac2c31f AM	56	action="$1"
	57
	58	# any db cluster as command line argument?
521444a9	59	if [ $# -gt 1 ]; then
350d9d8c PG	60	shift
350d9d8c PG	61	# perform action for specified clusters only
30b2aa9a ER	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
aac2c31f	78	else
350d9d8c	79	DB_CLUSTERS="$MYSQL_DB_CLUSTERS"
53a28f77	80	fi
53a28f77	81
7c1478d5 ER	82	# global error log, if mysqld.conf hasn't migrated to log-error style
7c1478d5 ER	83	MYSQL_ERRLOG=/var/log/mysql/mysqld.log
c85758f0	84	MYSQL_STOP_WAIT_TIME=${MYSQL_STOP_WAIT_TIME:-900}
aac2c31f AM	85
	86	#
	87	# Useful functions.
	88	#
	89
	90	#
	91	# check for mysql status
	92	#
	93	# arguments:
	94	# $1 - db cluster
c85758f0	95	# $2 - start\|stop
aac2c31f AM	96	#
aac2c31f AM	97	# sets variables:
c85758f0	98	# MYSQL_STATUS = starting \| running \| not running \| died
aac2c31f AM	99	# MYSQL_PID = pid of mysqld process
	100	#
	101	mysqlstatus() {
	102	clusterdir="$1"
c85758f0 AM	103	mode="$2"
c85758f0 AM	104
aac2c31f	105	mysqlgetconfig "$clusterdir"
d405c4eb	106
350d9d8c PG	107	MYSQL_STATUS="not running"
350d9d8c PG	108	MYSQL_PID="unknown"
c85758f0 AM	109	MYSQL_PIDFILE_PID=""
c85758f0 AM	110	MYSQL_GREP_PID=""
aac2c31f	111
c85758f0 AM	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
376ffa12	121	elif (grep -qa "$MYSQL_PIDFILE" /proc/$MYSQL_PID/cmdline 2> /dev/null); then
c85758f0 AM	122	MYSQL_STATUS="running"
	123	return
	124	fi
	125	fi
6d3c5db5	126
c85758f0	127	if [ "$mode" = "start" ]; then
376ffa12	128	MYSQL_GREP_PID=$(grep -lE "^/usr/sbin/mysqld.${MYSQL_PIDFILE}" /proc/[0-9]/cmdline 2> /dev/null \| awk -F "/" '{ print $3; exit; }')
c85758f0 AM	129	if [ -n "$MYSQL_GREP_PID" ]; then
c85758f0 AM	130	MYSQL_PID=$MYSQL_GREP_PID
0ca65658	131	if grep -qa "$MYSQL_PIDFILE" /proc/$MYSQL_PID/cmdline 2> /dev/null; then
c85758f0 AM	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
6d3c5db5	145	fi
c85758f0 AM	146
c85758f0 AM	147	# else default, "not running"
aac2c31f AM	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"
aac2c31f AM	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
0ca65658	161	MYSQL_RA_COMPAT=yes
aac2c31f	162	config_file=/etc/mysqld.conf
521444a9	163	else
0ca65658 ER	164	config=$(awk -F= -vclusterdir="$clusterdir" '!/^#/{ if (clusterdir == $2) print $1}' /etc/mysql/clusters.conf)
0ca65658 ER	165	if [[ $config = /* ]]; then
d54e166d	166	config_file="$config"
fe2f6e01	167	elif [ -f "/etc/mysql/$config" ]; then
0ca65658	168	config_file="/etc/mysql/$config"
d54e166d AM	169	else
	170	config_file="$clusterdir/mysqld.conf"
	171	fi
350d9d8c	172	fi
aac2c31f	173
0ca65658	174	MYSQL_CLUSTER_DIR="$clusterdir"
d405c4eb	175
521444a9	176	if [ -z "$config_file" ]; then
f9ad67df PG	177	nls "Error: Can't find config file for %s cluster" "$clusterdir"
	178	exit 6
	179	else
0ca65658	180	MYSQL_CONFIG="$config_file"
f9ad67df	181	fi
d405c4eb	182
aac2c31f AM	183	if [ ! -f "$config_file" ]; then
aac2c31f AM	184	nls "Error: config file %s not found" "$config_file"
350d9d8c PG	185	nls "MySQL can't be run. Did you initialize DB by doing \`$0 init'?"
350d9d8c PG	186	exit 6
aac2c31f AM	187	fi
	188
	189	eval `awk '
823c13f7 SZ	190	/^[ \t]\[.\][ \t]*$/ {
823c13f7 SZ	191	match($0,/\[.*\]/)
0ca65658	192	section=substr($0, RSTART + 1, RSTART + RLENGTH - 3)
823c13f7	193	}
0ca65658 ER	194	section == "mysqld" && $2 ~ "=" {
0ca65658 ER	195	if ($1 == "datadir") {
823c13f7	196	printf("MYSQL_DATA_DIR=%s;", $3)
0ca65658	197	} else if ($1 == "user") {
823c13f7	198	printf("MYSQL_USER=%s;", $3)
0ca65658	199	} else if ($1 == "pid-file") {
823c13f7	200	printf("MYSQL_PIDFILE=%s;", $3)
0ca65658	201	} else if ($1 == "socket") {
aac2c31f	202	printf("MYSQL_SOCKET=%s;", $3)
823c13f7 SZ	203	}
823c13f7 SZ	204	}
aac2c31f	205	' $config_file`
e9ca44ab	206
e9ca44ab	207
d54e166d	208	if is_yes "$MYSQL_RA_COMPAT"; then
350d9d8c	209	MYSQL_DATA_DIR_SUB=""
8ee1d59c	210	else
350d9d8c	211	MYSQL_DATA_DIR_SUB="/mysqldb"
8ee1d59c	212	fi
d405c4eb	213
8ee1d59c	214	if [ -z "$MYSQL_DATA_DIR" -o "$MYSQL_DATA_DIR" != "${clusterdir}${MYSQL_DATA_DIR_SUB}/db" ]; then
350d9d8c PG	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
8ee1d59c	218	fi
d405c4eb	219
8ee1d59c AM	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
e9ca44ab	225
aac2c31f	226	if [ -z $MYSQL_USER ]; then
350d9d8c PG	227	echo "$(nls 'MySQL user not configured properly')"'!' >&2
	228	nls "Edit %s and configure it." "$config_file" >&2
	229	exit 6
860cd80c	230	fi
aac2c31f	231	}
e9ca44ab	232
aac2c31f AM	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"
350d9d8c PG	240	exit 6
350d9d8c PG	241	fi
02e96f2e	242
aac2c31f AM	243	msg_starting "MySQL $clusterdir"
	244	busy
	245	[ -z "$DEFAULT_SERVICE_RUN_NICE_LEVEL" ] && DEFAULT_SERVICE_RUN_NICE_LEVEL=0
c85758f0	246	rm -f "$MYSQL_PIDFILE"
c4fbabf1	247
7c1478d5 ER	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
c4fbabf1	253	TMPDIR=/tmp nice -n ${SERVICE_RUN_NICE_LEVEL:-$DEFAULT_SERVICE_RUN_NICE_LEVEL} \
7429b124	254	/usr/bin/setsid /usr/sbin/mysqld \
c4fbabf1 ER	255	--defaults-file=$MYSQL_CONFIG \
c4fbabf1 ER	256	--datadir=$MYSQL_DATA_DIR \
7c1478d5 ER	257	--pid-file=$MYSQL_PIDFILE \
7c1478d5 ER	258	$MYSQL_OPTIONS &
c4fbabf1 ER	259	pid=$!
	260
	261	sleep 0.1
c85758f0 AM	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
c4fbabf1 ER	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
c85758f0	274	[ -f "$MYSQL_PIDFILE" ] && break
c4fbabf1	275	sleep 0.2
c85758f0 AM	276	done
	277	fi
	278
	279	mysqlstatus "$clusterdir" start
6d3c5db5	280	if [ "$MYSQL_STATUS" = "running" -a "$MYSQL_PID" != "unknown" ]; then
aac2c31f	281	ok
47fd5a6a	282	elif [ "$MYSQL_STATUS" = "died" ]; then
350d9d8c	283	RETVAL=1
47fd5a6a	284	died
aac2c31f AM	285	else
	286	RETVAL=1
	287	fail
53a28f77	288	fi
aac2c31f AM	289	}
	290
	291	# stop mysql
	292	mysqlstop() {
	293	clusterdir="$1"
c85758f0	294	mysqlstatus "$clusterdir" stop
aac2c31f AM	295	msg_stopping "MySQL $clusterdir"
aac2c31f AM	296	busy
95b0575d	297
95b0575d	298	# try graceful shutdown -- send shutdown command
566e62bb	299	# requires mysql_sysadmin user proper privs
465c110e	300	/usr/bin/mysqladmin --defaults-file=$MYSQL_CONFIG ${MYSQL_SOCKET:+--socket=$MYSQL_SOCKET} shutdown >/dev/null 2>&1
c85758f0	301	mysqlstatus "$clusterdir" stop
95b0575d	302
c85758f0 AM	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
47fd5a6a	312	if [ "$MYSQL_STATUS" = "died" ]; then
350d9d8c	313	died
c85758f0	314	elif [ "$MYSQL_STATUS" = "running" -o "$MYSQL_STATUS" = "starting" ]; then
aac2c31f	315	fail
b92e5cd1	316	else
aac2c31f	317	ok
b92e5cd1	318	fi
aac2c31f AM	319	}
	320
	321	#
	322	# check for running mysql instances; if any instance is running then
	323	# create subsys lock file
	324	#
	325	mysqlsubsys() {
350d9d8c PG	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
aac2c31f AM	335	}
	336
	337	mysqlinit() {
	338	clusterdir="$1"
8ee1d59c AM	339
8ee1d59c AM	340	if [ -f /etc/mysqld.conf ]; then
350d9d8c PG	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
8ee1d59c AM	344	fi
8ee1d59c AM	345
521444a9 AM	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"
fe98cc4a ER	354
	355	# this $MYSQL_CONFIG will be created later
	356	MYSQL_CONFIG="$MYSQL_CLUSTER_DIR/mysqld.conf"
521444a9	357	fi
aac2c31f	358
d460d24d	359	show "Initializing cluster %s" "$clusterdir"; echo
aac2c31f	360
573e1dcc	361	# Check if not exist init database
e9ca44ab	362	if [ -d "$MYSQL_DATA_DIR/mysql" ]; then
c70c8930	363	nls "Seems that database is initialized now. Remove by hand %s" "$MYSQL_DATA_DIR/mysql"
b92e5cd1	364	nls "before initializing database."
aac2c31f AM	365	nls "For now skipping cluster %s." "$clusterdir"
aac2c31f AM	366	return
e9ca44ab	367	fi
e9ca44ab	368
5f961775	369	show "Installing MySQL system tables for $MYSQL_DATA_DIR"
e9ca44ab	370	busy
d405c4eb JB	371	TMP=/tmp TMPDIR=/tmp
d405c4eb JB	372
c4fbabf1	373	mkdir -p "$MYSQL_DATA_DIR" > /dev/null 2>&1
f5d63301 AM	374	# Using mysql:mysql for MYSQL_CLUSTER_DIR is creating SECURITY hole, root:root is proper
f5d63301 AM	375	chown root:root "$MYSQL_CLUSTER_DIR"
5f961775	376	chown mysql:mysql "$MYSQL_CLUSTER_DIR/mysqldb" "$MYSQL_DATA_DIR" > /dev/null 2>&1
653cf157	377	chmod 751 "$MYSQL_CLUSTER_DIR" "$MYSQL_CLUSTER_DIR/mysqldb"
444f9f3c AM	378
444f9f3c AM	379	if [ -f /usr/share/mysql/mysqld.conf -a ! -f "$MYSQL_CLUSTER_DIR/mysqld.conf" ]; then
b6369c60 ER	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"
54a1f368	386	chown root:root "$MYSQL_CLUSTER_DIR/mysqld.conf"
444f9f3c AM	387	chmod 640 "$MYSQL_CLUSTER_DIR/mysqld.conf"
444f9f3c AM	388	fi
cc4d3f78	389
a08fc1eb	390	if [ ! -e /var/lib/mysql/mysql.sock ] \|\| [ -L /var/lib/mysql/mysql.sock ] && [ -z "$(readlink /var/lib/mysql/mysql.sock)" ]; then
0ca65658	391	sock=${MYSQL_SOCKET#/var/lib/mysql/} # make it relative if possible
5fe13e55	392	ln -s "$sock" /var/lib/mysql/mysql.sock
cc4d3f78	393	fi
aac2c31f	394
b9c4f95d	395	cat > $MYSQL_DATA_DIR/mysql-init.sql <<-EOF
bb39d376	396	CREATE DATABASE mysql;
4444725f	397	use mysql;
ac02fcd5	398	$(cat /usr/share/mysql/mysql_system_tables.sql)
5f961775	399	$(sed -e "/@current_hostname/d" /usr/share/mysql/mysql_system_tables_data.sql)
b9c4f95d ER	400	EOF
	401
	402	ok=0
	403	/usr/sbin/mysqld --bootstrap --skip-grant-tables \
c4fbabf1	404	--datadir=$MYSQL_DATA_DIR --user=$MYSQL_USER \
da87c30d ER	405	--slave-load-tmpdir=$MYSQL_DATA_DIR --tmpdir=$MYSQL_DATA_DIR --log-error=$MYSQL_ERRLOG \
da87c30d ER	406	< $MYSQL_DATA_DIR/mysql-init.sql && ok=1
5062ac41	407	[ -f $MYSQL_DATA_DIR/mysql/host.frm ] \|\| ok=0
c4fbabf1	408
b9c4f95d ER	409	if [ "$ok" = 1 ]; then
b9c4f95d ER	410	rm -f $MYSQL_DATA_DIR/mysql-init.sql
5f961775 JR	411	ok
5f961775 JR	412	cat << END_OF_MSG
6a46c354	413
6a46c354	414	PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL USERS!
5f961775 JR	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
6a46c354	420
5f961775 JR	421	For 'mysql' user (ALL privileges, DB admin):
5f961775 JR	422	echo "update mysql.user set password=password('newpassword') where user='mysql'; FLUSH PRIVILEGES;" \| mysql -u mysql -S $MYSQL_SOCKET
6a46c354	423
566e62bb	424	NOTE: mysql_sysadmin password should be placed to $MYSQL_CONFIG in
6a46c354	425	mysqladmin section. See the manual for more instructions.
566e62bb	426	(This user is used at logs rotation and server shutdown)
e9ca44ab	427
5f961775 JR	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 \
da87c30d ER	434	--slave-load-tmpdir=$MYSQL_DATA_DIR --tmpdir=$MYSQL_DATA_DIR --log-error=$MYSQL_ERRLOG \
da87c30d ER	435	&& ok=1
5f961775 JR	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.
16bf26ff	443
e9ca44ab	444	END_OF_MSG
5f961775 JR	445	fi
	446	else
	447	fail
	448	cat << END_OF_MSG
e9ca44ab	449	Installation of grant tables FAILED!
e9ca44ab	450
6df74636 ER	451	The initialization SQL script was preserved at $MYSQL_DATA_DIR/mysql-init.sql
6df74636 ER	452
b9c4f95d ER	453	Examine the logs in /var/log/mysql for more information. You can
b9c4f95d ER	454	also try to start the mysqld daemon with:
e9ca44ab	455
	456	/usr/sbin/mysqld --skip-grant &
	457
dc7a177f	458	You can use the command line tool mysql to connect to the mysql
e9ca44ab	459	database and look at the grant tables:
e9ca44ab	460
dc7a177f	461	shell> mysql -u mysql mysql
e9ca44ab	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
78b16243	467	web at http://www.mysql.com/.
e9ca44ab	468
a3eb9e7b	469	Please check PLD Linux ftp site for newer versions of this package.
e9ca44ab	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
dc7a177f	475	us, you MUST use the mysqlbug script!
e9ca44ab	476
e9ca44ab	477	END_OF_MSG
5f961775	478	exit 1
aac2c31f AM	479	fi
	480	}
	481
	482	#
	483	# End of useful functions.
	484	#
	485
323256af	486	start() {
aac2c31f	487	for mysqldir in $DB_CLUSTERS; do
c85758f0	488	mysqlstatus "$mysqldir" start
aac2c31f AM	489	if [ "$MYSQL_STATUS" = "running" ]; then
	490	msg_already_running "MySQL $mysqldir"
	491	else
	492	mysqlstart "$mysqldir"
	493	fi
	494	done
	495	mysqlsubsys
323256af ER	496	}
	497
	498	stop() {
aac2c31f	499	for mysqldir in $DB_CLUSTERS; do
c85758f0	500	mysqlstatus "$mysqldir" stop
aac2c31f AM	501	if [ "$MYSQL_STATUS" = "not running" ]; then
	502	msg_not_running "MySQL $mysqldir"
	503	else
	504	mysqlstop "$mysqldir"
	505	fi
	506	done
	507	mysqlsubsys
323256af ER	508	}
323256af ER	509
7429b124 JB	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
323256af ER	520	RETVAL=0
	521	case "$action" in
	522	start)
	523	start
	524	;;
	525	stop)
	526	stop
aac2c31f	527	;;
7429b124 JB	528	restart)
	529	stop
	530	start
	531	;;
	532	try-restart)
	533	condrestart 0
	534	;;
	535	force-reload)
	536	condrestart 7
	537	;;
aac2c31f AM	538	status)
	539	for mysqldir in $DB_CLUSTERS; do
	540	mysqlstatus "$mysqldir"
2bac5c2d	541	if [ "$MYSQL_STATUS" = "running" ]; then
27698ac1	542	show "MySQL cluster %s, PID %s" "$mysqldir" "$MYSQL_PID"
b2bb6a82	543	pids="$pids/$MYSQL_PID/"
2bac5c2d ER	544	progress "$MYSQL_STATUS"
2bac5c2d ER	545	else
27698ac1	546	show "MySQL cluster %s" "$mysqldir"
2bac5c2d ER	547	progress "$MYSQL_STATUS" "$CFAIL"
	548	fi
	549	echo
aac2c31f	550	done
b2bb6a82 ER	551
	552	for pid in $(/sbin/pidof mysqld); do
	553	if [[ $pids != /$pid/ ]]; then
	554	running="$running $pid"
	555	fi
	556	done
b7d0a657 ER	557
b7d0a657 ER	558	if [ $# -gt 1 -a "$running" ]; then
b2bb6a82 ER	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
b7d0a657	562	datadir=$(cat /proc/$pid/cmdline \| tr '\0' '\n' \| fgrep -- --datadir=)
b2bb6a82 ER	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
aac2c31f	576	;;
aac2c31f AM	577	init)
	578	for mysqldir in $DB_CLUSTERS; do
	579	mysqlinit "$mysqldir"
	580	done
60bd204c	581	exit $?
573e1dcc	582	;;
6fb7a89b AM	583	flush-logs)
	584	for mysqldir in $DB_CLUSTERS; do
	585	mysqlgetconfig "$mysqldir"
7c37979d ER	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
6fb7a89b	590	done
6fb7a89b	591	;;
53a28f77	592	*)
7429b124	593	msg_usage "$0 {start\|stop\|init\|restart\|try-restart\|force-reload\|status}"
02e96f2e	594	exit 3
53a28f77	595	esac
40c36bca	596
ee9b6a50	597	exit $RETVAL