X-Git-Url: https://git.pld-linux.org/?a=blobdiff_plain;f=mysql.init;h=120f67bb233805a6455f255432c1aeea540da90d;hb=54634a334ae345b5954110cfda7aa32228063798;hp=32f19ff1f8ec40375bc2dfbd09640ff6402e3c9d;hpb=7e0cfabcf3b4db504368aaf2ab776ab9444ed95f;p=packages%2Fmysql.git diff --git a/mysql.init b/mysql.init old mode 100644 new mode 100755 index 32f19ff..120f67b --- a/mysql.init +++ b/mysql.init @@ -1,11 +1,11 @@ #!/bin/sh # -# mysql A very fast and reliable SQL database engine +# mysql A very fast and reliable SQL database engine # -# chkconfig: 2345 84 25 +# chkconfig: 2345 84 25 # # description: A very fast and reliable SQL database engine. -# + # Source function library . /etc/rc.d/init.d/functions @@ -26,14 +26,14 @@ if [ -n "$MYSQL_DB_CLUSTERS" ]; then 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 + 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 + 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 @@ -51,6 +51,8 @@ else exit 0 fi +sharedir=/usr/share/mysql + action="$1" # any db cluster as command line argument? @@ -77,8 +79,8 @@ else DB_CLUSTERS="$MYSQL_DB_CLUSTERS" fi -MYSQL_ERRLOG=/var/log/mysql/err -MYSQL_START_WAIT_TIME=${MYSQL_START_WAIT_TIME:-15} +# 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} # @@ -100,7 +102,7 @@ mysqlstatus() { clusterdir="$1" mode="$2" - mysqlgetconfig "$clusterdir" + mysqlgetconfig "$clusterdir" status MYSQL_STATUS="not running" MYSQL_PID="unknown" @@ -123,7 +125,7 @@ mysqlstatus() { 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; }') + MYSQL_GREP_PID=$(grep -alE "^/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 @@ -146,20 +148,23 @@ mysqlstatus() { } # get mysql configuration in variables -# MYSQL_CONFIG MYSQL_DATA_DIR MYSQL_USER MYSQL_PIDFILE +# MYSQL_CONFIG MYSQL_CLUSTER_DIR +# MYSQL_DATA_DIR MYSQL_USER MYSQL_PIDFILE MYSQL_SOCKET MYSQL_PORT MYSQL_BIND_ADDRESS MYSQL_SKIP_NETWORKING MYSQL_LOG_ERROR # # arguments # $1 - db cluster +# $2 - status | other mysqlgetconfig() { - clusterdir="$1" + local clusterdir="$1" config_file + local mode="$2" # 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) + local 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 @@ -173,7 +178,11 @@ mysqlgetconfig() { if [ -z "$config_file" ]; then nls "Error: Can't find config file for %s cluster" "$clusterdir" - exit 6 + if [ "$mode" = "status" ]; then + exit 3 + else + exit 6 + fi else MYSQL_CONFIG="$config_file" fi @@ -181,27 +190,63 @@ mysqlgetconfig() { 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 + if [ "$mode" = "status" ]; then + exit 3 + else + exit 6 + fi 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) + # reset to initial state + MYSQL_DATA_DIR= MYSQL_USER= MYSQL_PIDFILE= MYSQL_SOCKET= MYSQL_PORT= MYSQL_BIND_ADDRESS= MYSQL_SKIP_NETWORKING= MYSQL_LOG_ERROR= + + eval `awk -F= ' + { + # undos + gsub(/\r$/, ""); + + # trim spaces + gsub(/^[\t ]+|[\t ]+$/, "", $1); + gsub(/^[\t ]+|[\t ]+$/, "", $2); + } + + # skip comments and empty lines + /^[;#]|^ *$/ { next } + + /^[ \t]*\[.*\][ \t]*$/ { + match($0, /\[.*\]/); + section = substr($0, RSTART + 1, RSTART + RLENGTH - 3); + next; } -} -' $config_file` + section == "mysqld" { + if ($1 == "datadir") { + printf("MYSQL_DATA_DIR=%s;", $2); + } else if ($1 == "user") { + printf("MYSQL_USER=%s;", $2); + } else if ($1 == "pid-file") { + printf("MYSQL_PIDFILE=%s;", $2); + } else if ($1 == "socket") { + printf("MYSQL_SOCKET=%s;", $2); + } else if ($1 == "port") { + printf("MYSQL_PORT=%s;", $2); + } else if ($1 == "bind-address") { + printf("MYSQL_BIND_ADDRESS=%s;", $2); + } else if ($1 == "skip-networking") { + printf("MYSQL_SKIP_NETWORKING=1;"); + } else if ($1 == "log-error") { + printf("MYSQL_LOG_ERROR=%s;", $2); + } + } + ' $config_file` + + # error log not defined in config file. add one + if [ -z "$MYSQL_LOG_ERROR" ]; then + MYSQL_LOG_ERROR=$MYSQL_ERRLOG + else + # unset, so mysqld would use value from config itself + unset MYSQL_LOG_ERROR + fi if is_yes "$MYSQL_RA_COMPAT"; then MYSQL_DATA_DIR_SUB="" @@ -221,7 +266,7 @@ section == "mysqld" && $2 ~ "=" { exit 6 fi - if [ -z $MYSQL_USER ]; then + if [ -z "$MYSQL_USER" ]; then echo "$(nls 'MySQL user not configured properly')"'!' >&2 nls "Edit %s and configure it." "$config_file" >&2 exit 6 @@ -230,7 +275,7 @@ section == "mysqld" && $2 ~ "=" { # start mysql mysqlstart() { - clusterdir="$1" + local clusterdir="$1" mysqlgetconfig "$clusterdir" if [ ! -d "$MYSQL_DATA_DIR/mysql" ]; then nls "MySQL cluster %s not initialized." "$clusterdir" @@ -238,18 +283,35 @@ mysqlstart() { exit 6 fi - msg_starting "MySQL $clusterdir" - busy + msg_starting "MySQL $clusterdir"; busy [ -z "$DEFAULT_SERVICE_RUN_NICE_LEVEL" ] && DEFAULT_SERVICE_RUN_NICE_LEVEL=0 rm -f "$MYSQL_PIDFILE" - 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 >> $MYSQL_ERRLOG 2>&1 & - sleep 0.2 + + + 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_LOG_ERROR:+--log-error="$MYSQL_LOG_ERROR"} \ + $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 - for nr in $(seq 1 $(($MYSQL_START_WAIT_TIME*10))); do + 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.1 + sleep 0.2 done fi @@ -267,13 +329,13 @@ mysqlstart() { # stop mysql mysqlstop() { - clusterdir="$1" + local clusterdir="$1" mysqlstatus "$clusterdir" stop msg_stopping "MySQL $clusterdir" busy # try graceful shutdown -- send shutdown command - # requires mysql_logrotate user proper privs + # 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 @@ -295,6 +357,66 @@ mysqlstop() { fi } +# report slave status +# uses MYSQL_SOCKET - path to mysql socket +slave_status() { + if [ ! -x /usr/bin/mysql ]; then + echo >&2 "Slave status not available: 'mysql' program not installed." + return + fi + + # see if slave status can be reported + local err=0 slave_status=$(mysql --defaults-file="$MYSQL_CONFIG" --socket="$MYSQL_SOCKET" -e 'show slave status\G') + if [ -z "$slave_status" ]; then + # slave not setup + return + fi + + printf "Slave Status:\n" + + set -f + eval $(echo "$slave_status" | awk -F': ' '/^ *[A-Za-z_]+:/{ + k = tolower($1); + v = substr($0, length($1) + 3); + gsub(/\\/, "\\\\\\", v); + gsub(/"/, "\\\"", v); + gsub(/`/, "\\`", v); + gsub(/\$/, "\\$", v); + gsub(/\$/, "\\$", v); + printf("%s=\"%s\";\n", k, v); + }') + set +f + + if [ "$slave_io_running" != "Yes" ]; then + printf "\tSlave IO not running\n" + err=1 + fi + if [ "$slave_sql_running" != "Yes" ]; then + printf "\tSlave SQL not running\n" + err=1 + fi + + if [ "$err" = 1 -a "$last_errno" -gt 0 ]; then + printf "\tERROR %s: %s\n" "$last_errno" "$last_error" + fi + + if [ "$master_log_file" != "$relay_master_log_file" ]; then + printf "\tERROR logfile mismatch (%s)\n" "$relay_master_log_file" + err=1 + fi + + if [ -z "$read_master_log_pos" -o -z "$exec_master_log_pos" ]; then + printf "\tERROR No info about master\n" + err=1 + return + fi + + diff=$(($read_master_log_pos - $exec_master_log_pos)) + printf "\tread pos: %s (%s) (host: %s:%d)\n" "$read_master_log_pos" "$master_log_file" "$master_host" "$master_port" + printf "\texec pos: %s\n" "$exec_master_log_pos" + printf "\tdiff: %s\n" "$diff" +} + # # check for running mysql instances; if any instance is running then # create subsys lock file @@ -312,7 +434,7 @@ mysqlsubsys() { } mysqlinit() { - clusterdir="$1" + local clusterdir="$1" if [ -f /etc/mysqld.conf ]; then nls "Running in \`no cluster compat' mode: can't initialize database." @@ -323,7 +445,7 @@ mysqlinit() { if [ -f "$clusterdir/mysqld.conf" ]; then mysqlgetconfig "$clusterdir" else - MYSQL_USER="mysql" + MYSQL_USER="root" MYSQL_CLUSTER_DIR="$clusterdir" MYSQL_DATA_DIR="$clusterdir/mysqldb/db" MYSQL_PIDFILE="$clusterdir/mysqldb/mysql.pid" @@ -333,89 +455,108 @@ mysqlinit() { MYSQL_CONFIG="$MYSQL_CLUSTER_DIR/mysqld.conf" fi - nls "Initializing cluster %s" "$clusterdir" + show "Initializing cluster %s" "$clusterdir"; started # 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 + exit 6 fi - show "Creating privilege mysql tables for $MYSQL_DATA_DIR" + show "Initializing MySQL database for $MYSQL_DATA_DIR" busy TMP=/tmp TMPDIR=/tmp - mkdir -p "$MYSQL_DATA_DIR" + 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 + 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" + if [ -f $sharedir/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; + " $sharedir/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; - $(/usr/sbin/mysql_create_system_tables real $MYSQL_DATA_DIR/mysql) -EOF - ok=0 - /usr/sbin/mysqld --bootstrap --skip-grant-tables \ - --datadir=$MYSQL_DATA_DIR --user=$MYSQL_USER < $MYSQL_DATA_DIR/mysql-init.sql && ok=1 - [ -f $MYSQL_DATA_DIR/mysql/host.frm ] || ok=0 + /usr/sbin/mysqld \ + --defaults-file=$MYSQL_CLUSTER_DIR/mysqld.conf \ + --initialize \ + --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 + [ -f $MYSQL_DATA_DIR/mysql/user.frm ] || ok=0 + if [ "$ok" = 1 ]; then - rm -f $MYSQL_DATA_DIR/mysql-init.sql - ok - cat << END_OF_MSG + ok + cat << END_OF_MSG PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL USERS! -This is done (after starting database; press enter when asked for password) with: -/usr/bin/mysqladmin -u mysql -S $MYSQL_SOCKET password 'password' -/usr/bin/mysqladmin -u mysql_logrotate -S $MYSQL_SOCKET password 'password' +Start database: +$ service mysql start -NOTE: mysql_logrotate password should be placed to $MYSQL_CONFIG in -mysqladmin section. See the manual for more instructions. +and set passwords: -If you want to use new help tables in MySQL 4.1.x then you'll need to import the help data: -/usr/bin/mysql -u mysql -p -S $MYSQL_SOCKET mysql < /usr/share/mysql/fill_help_tables.sql +For 'root' user (ALL privileges, DB admin), paste command with new password: +ALTER USER 'root'@'localhost' IDENTIFIED BY 'newpassword'; +FLUSH PRIVILEGES; + +For 'mysql_sysadmin' (RELOAD and SHUTDOWN privileges): +CREATE USER 'mysql_sysadmin'@'localhost' IDENTIFIED BY 'sysnewpassword' PASSWORD EXPIRE NEVER; +GRANT RELOAD, SHUTDOWN ON *.* TO 'mysql_sysadmin'@'localhost'; +FLUSH PRIVILEGES; + + +Both into command: +$ mysql -u root -p --ssl-mode=disabled -S $MYSQL_SOCKET + +NOTE 1: +CURRENT TEMPORARY ROOT PASSWORD CAN BE FOUND IN LOG +(grep for "A temporary password is generated" string): +$MYSQL_ERRLOG -END_OF_MSG - else - fail - cat << END_OF_MSG -Installation of grant tables FAILED! -The initialization SQL script was preserved at $MYSQL_DATA_DIR/mysql-init.sql +NOTE 2: +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) -Examine the logs in /var/log/mysql for more information. You can +END_OF_MSG + else + fail + cat << END_OF_MSG +ERROR: +ERROR: +ERROR: Installation FAILED! +ERROR: +ERROR: + +Examine the logs in $MYSQL_ERRLOG 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 /usr/bin/mysql to connect to the mysql +You can use the command line tool mysql to connect to the mysql database and look at the grant tables: -shell> /usr/bin/mysql -u mysql mysql +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 +logging in $MYSQL_DATA_DIR/mysqld.conf gives you a log in /var/log/mysql/query.log that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com/. @@ -423,13 +564,20 @@ 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 /usr/bin/mysqlbug script! +your OS. Another information source is the MySQL email archive. END_OF_MSG + exit 1 + fi - exit 1 + # if it's first server, register as default + 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 + # same for config, move to /etc + if [ ! -e /etc/mysql/mysqld.conf ]; then + mv "$MYSQL_CLUSTER_DIR/mysqld.conf" /etc/mysql/mysqld.conf fi } @@ -438,12 +586,7 @@ END_OF_MSG # start() { - if [ ! -f $MYSQL_ERRLOG ]; then - touch $MYSQL_ERRLOG - fi - chown mysql:mysql $MYSQL_ERRLOG - chmod 640 $MYSQL_ERRLOG - + local mysqldir for mysqldir in $DB_CLUSTERS; do mysqlstatus "$mysqldir" start if [ "$MYSQL_STATUS" = "running" ]; then @@ -456,6 +599,7 @@ start() { } stop() { + local mysqldir for mysqldir in $DB_CLUSTERS; do mysqlstatus "$mysqldir" stop if [ "$MYSQL_STATUS" = "not running" ]; then @@ -467,19 +611,35 @@ stop() { mysqlsubsys } -RETVAL=0 -case "$action" in - start) - start - ;; - stop) - stop - ;; - status) +condrestart() { + if [ ! -f /var/lock/subsys/mysql ]; then + msg_not_running "MySQL" + RETVAL=$1 + return + fi + + stop + start +} + +status() { + local mysqldir addr port socket pid pids running datadir + RETVAL=3 for mysqldir in $DB_CLUSTERS; do mysqlstatus "$mysqldir" if [ "$MYSQL_STATUS" = "running" ]; then - show "MySQL cluster %s, PID %s" "$mysqldir" "$MYSQL_PID" + RETVAL=0 + addr=${MYSQL_BIND_ADDRESS:-0.0.0.0} + port=${MYSQL_PORT:-3306} + socket=${MYSQL_SOCKET:-/var/lib/mysql/mysql.sock} + pid=$MYSQL_PID + nls "MySQL cluster %s, pid %s\n" "$mysqldir" "$pid" + [ -z "$MYSQL_SKIP_NETWORKING" ] && nls "\ttcp:%s:%s\n" "$addr" "$port" + nls "\tunix: %s\n" "$socket" + + MYSQL_SOCKET=$socket slave_status + + pids="$pids/$MYSQL_PID/" progress "$MYSQL_STATUS" else show "MySQL cluster %s" "$mysqldir" @@ -487,12 +647,59 @@ case "$action" in fi echo done - exit $? + + for pid in $(/sbin/pidof mysqld); do + if [[ $pids != */$pid/* ]]; then + running="$running $pid" + fi + done + + if [ $# = 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 + addr=${MYSQL_BIND_ADDRESS:-0.0.0.0} + port=${MYSQL_PORT:-3306} + socket=${MYSQL_SOCKET:-/var/lib/mysql/mysql.sock} + nls "MySQL cluster %s, pid %s\n" "$mysqldir" "$pid" + [ -z "$MYSQL_SKIP_NETWORKING" ] && nls "\ttcp:%s:%s\n" "$addr" "$port" + nls "\tunix: %s\n" "$socket" + + MYSQL_SOCKET=$socket slave_status + + progress "$MYSQL_STATUS" + else + show "MySQL cluster %s" "$mysqldir" + progress "$MYSQL_STATUS" "$CFAIL" + fi + echo + done + fi +} + +RETVAL=0 +case "$action" in + start) + start + ;; + stop) + stop ;; - restart|force-reload) + restart) stop start ;; + try-restart) + condrestart 0 + ;; + force-reload) + condrestart 7 + ;; init) for mysqldir in $DB_CLUSTERS; do mysqlinit "$mysqldir" @@ -500,19 +707,20 @@ case "$action" in exit $? ;; flush-logs) - for mysqldir in $DB_CLUSTERS; do - mysqlgetconfig "$mysqldir" + 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 ;; + status) + status + ;; *) - msg_usage "$0 {start|stop|init|restart|force-reload|status}" + msg_usage "$0 {start|stop|restart|try-restart|force-reload|init|flush-logs|status}" exit 3 esac exit $RETVAL - -# vi: shiftwidth=4 tabstop=4