mysql.init

   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         # reset to initial state
 190         MYSQL_DATA_DIR= MYSQL_USER= MYSQL_PIDFILE= MYSQL_SOCKET= MYSQL_PORT= MYSQL_BIND_ADDRESS=
 191
 192         eval `awk -F= '
 193         # skip comments and empty lines
 194         /^[;#]|^ *$/ { next }
 195
 196         /^[ \t]*\[.*\][ \t]*$/ {
 197                 match($0, /\[.*\]/);
 198                 section = substr($0, RSTART + 1, RSTART + RLENGTH - 3);
 199                 next;
 200         }
 201
 202         # trim spaces
 203         {
 204                 gsub(/^[\t ]*|[\t ]*$/, "", $1);
 205                 gsub(/^[\t ]*|[\t ]*$/, "", $2);
 206         }
 207
 208         section == "mysqld" {
 209                 if ($1 == "datadir") {
 210                         printf("MYSQL_DATA_DIR=%s;", $2);
 211                 } else if ($1 == "user") {
 212                         printf("MYSQL_USER=%s;", $2);
 213                 } else if ($1 == "pid-file") {
 214                         printf("MYSQL_PIDFILE=%s;", $2);
 215                 } else if ($1 == "socket") {
 216                         printf("MYSQL_SOCKET=%s;", $2);
 217                 } else if ($1 == "port") {
 218                         printf("MYSQL_PORT=%s;", $2);
 219                 } else if ($1 == "bind-address") {
 220                         printf("MYSQL_BIND_ADDRESS=%s;", $2);
 221                 }
 222         }
 223         ' $config_file`
 224
 225         if is_yes "$MYSQL_RA_COMPAT"; then
 226                 MYSQL_DATA_DIR_SUB=""
 227         else
 228                 MYSQL_DATA_DIR_SUB="/mysqldb"
 229         fi
 230
 231         if [ -z "$MYSQL_DATA_DIR" -o "$MYSQL_DATA_DIR" != "${clusterdir}${MYSQL_DATA_DIR_SUB}/db" ]; then
 232                 nls "Error: datadir specified in %s should be %s" "$config_file" "$clusterdir${MYSQL_DATA_DIR_SUB}/db"
 233                 nls " MySQL can't be run."
 234                 exit 6
 235         fi
 236
 237         if [ -z "$MYSQL_PIDFILE" -o "$MYSQL_PIDFILE" != "$clusterdir${MYSQL_DATA_DIR_SUB}/mysql.pid" ]; then
 238                 nls "Error: pid-file specified in %s should be %s" "$config_file" "$clusterdir${MYSQL_DATA_DIR_SUB}/mysql.pid"
 239                 nls " MySQL can't be run."
 240                 exit 6
 241         fi
 242
 243         if [ -z $MYSQL_USER ]; then
 244                 echo "$(nls 'MySQL user not configured properly')"'!' >&2
 245                 nls "Edit %s and configure it." "$config_file" >&2
 246                 exit 6
 247         fi
 248 }
 249
 250 # start mysql
 251 mysqlstart() {
 252         clusterdir="$1"
 253         mysqlgetconfig "$clusterdir"
 254         if [ ! -d "$MYSQL_DATA_DIR/mysql" ]; then
 255                 nls "MySQL cluster %s not initialized." "$clusterdir"
 256                 nls "Try \`%s init %s' before start." "$0" "$clusterdir"
 257                 exit 6
 258         fi
 259
 260         msg_starting "MySQL $clusterdir"
 261         busy
 262         [ -z "$DEFAULT_SERVICE_RUN_NICE_LEVEL" ] && DEFAULT_SERVICE_RUN_NICE_LEVEL=0
 263         rm -f "$MYSQL_PIDFILE"
 264
 265         if [ "$(grep -c ^log-error $MYSQL_CONFIG)" -lt 1 ]; then
 266                 # error log not defined in config file. add one
 267                 MYSQL_OPTIONS="$MYSQL_OPTIONS --log-error=$MYSQL_ERRLOG"
 268         fi
 269
 270         TMPDIR=/tmp nice -n ${SERVICE_RUN_NICE_LEVEL:-$DEFAULT_SERVICE_RUN_NICE_LEVEL} \
 271                 /usr/bin/setsid /usr/sbin/mysqld \
 272                         --defaults-file=$MYSQL_CONFIG \
 273                         --datadir=$MYSQL_DATA_DIR \
 274                         --pid-file=$MYSQL_PIDFILE \
 275                         $MYSQL_OPTIONS &
 276         pid=$!
 277
 278         sleep 0.1
 279         mysqlstatus "$clusterdir" start
 280         # it takes longer for mysqld to start and create pidfile if it has to recover innodb transactions
 281         if [ "$MYSQL_STATUS" = "starting" ]; then
 282                 echo ""
 283                 show "Waiting for MySQL to start"
 284                 busy
 285
 286                 # while the pid is running, mysql is starting up
 287                 # if the pidfile was created, it started up successfully
 288                 # if either case fails we break and report status
 289                 while true; do
 290                         [ -d /proc/$pid ] || break
 291                         [ -f "$MYSQL_PIDFILE" ] && break
 292                         sleep 0.2
 293                 done
 294         fi
 295
 296         mysqlstatus "$clusterdir" start
 297         if [ "$MYSQL_STATUS" = "running" -a "$MYSQL_PID" != "unknown" ]; then
 298                 ok
 299         elif [ "$MYSQL_STATUS" = "died" ]; then
 300                 RETVAL=1
 301                 died
 302         else
 303                 RETVAL=1
 304                 fail
 305         fi
 306 }
 307
 308 # stop mysql
 309 mysqlstop() {
 310         clusterdir="$1"
 311         mysqlstatus "$clusterdir" stop
 312         msg_stopping "MySQL $clusterdir"
 313         busy
 314
 315         # try graceful shutdown -- send shutdown command
 316         # requires mysql_sysadmin user proper privs
 317         /usr/bin/mysqladmin --defaults-file=$MYSQL_CONFIG ${MYSQL_SOCKET:+--socket=$MYSQL_SOCKET} shutdown >/dev/null 2>&1
 318         mysqlstatus "$clusterdir" stop
 319
 320         if [ "$MYSQL_PID" != "unknown" ]; then
 321                 kill -TERM "$MYSQL_PID" 2> /dev/null
 322                 for nr in $(seq 1 $(($MYSQL_STOP_WAIT_TIME*10))); do
 323                         [ -d "/proc/$MYSQL_PID" ] || break
 324                         sleep 0.1
 325                 done
 326         fi
 327
 328         mysqlstatus "$clusterdir" stop
 329         if [ "$MYSQL_STATUS" = "died" ]; then
 330                 died
 331         elif [ "$MYSQL_STATUS" = "running" -o "$MYSQL_STATUS" = "starting" ]; then
 332                 fail
 333         else
 334                 ok
 335         fi
 336 }
 337
 338 #
 339 # check for running mysql instances; if any instance is running then
 340 # create subsys lock file
 341 #
 342 mysqlsubsys() {
 343         # check for every defined db cluster in sysconfig file
 344         for mysqldir in $DB_CLUSTERS; do
 345                 mysqlstatus "$mysqldir"
 346                 if [ "$MYSQL_STATUS" = "running" ]; then
 347                         touch /var/lock/subsys/mysql
 348                         return
 349                 fi
 350         done
 351         rm -f /var/lock/subsys/mysql
 352 }
 353
 354 mysqlinit() {
 355         clusterdir="$1"
 356
 357         if [ -f /etc/mysqld.conf ]; then
 358                 nls "Running in \`no cluster compat' mode: can't initialize database."
 359                 nls "Move /etc/mysqld.conf away and rerun \`$0 init' (new config will be in $clusterdir)."
 360                 exit 1
 361         fi
 362
 363         if [ -f "$clusterdir/mysqld.conf" ]; then
 364                 mysqlgetconfig "$clusterdir"
 365         else
 366                 MYSQL_USER="mysql"
 367                 MYSQL_CLUSTER_DIR="$clusterdir"
 368                 MYSQL_DATA_DIR="$clusterdir/mysqldb/db"
 369                 MYSQL_PIDFILE="$clusterdir/mysqldb/mysql.pid"
 370                 MYSQL_SOCKET="$clusterdir/mysqldb/mysql.sock"
 371
 372                 # this $MYSQL_CONFIG will be created later
 373                 MYSQL_CONFIG="$MYSQL_CLUSTER_DIR/mysqld.conf"
 374         fi
 375
 376         show "Initializing cluster %s" "$clusterdir"; echo
 377
 378         # Check if not exist init database
 379         if [ -d "$MYSQL_DATA_DIR/mysql" ]; then
 380                 nls "Seems that database is initialized now. Remove by hand %s" "$MYSQL_DATA_DIR/mysql"
 381                 nls "before initializing database."
 382                 nls "For now skipping cluster %s." "$clusterdir"
 383                 return
 384         fi
 385
 386         show "Installing MySQL system tables for $MYSQL_DATA_DIR"
 387         busy
 388         TMP=/tmp TMPDIR=/tmp
 389
 390         mkdir -p "$MYSQL_DATA_DIR" > /dev/null 2>&1
 391         # Using mysql:mysql for MYSQL_CLUSTER_DIR is creating SECURITY hole, root:root is proper
 392         chown root:root "$MYSQL_CLUSTER_DIR"
 393         chown mysql:mysql "$MYSQL_CLUSTER_DIR/mysqldb" "$MYSQL_DATA_DIR" > /dev/null 2>&1
 394         chmod 751 "$MYSQL_CLUSTER_DIR" "$MYSQL_CLUSTER_DIR/mysqldb"
 395
 396         if [ -f /usr/share/mysql/mysqld.conf -a ! -f "$MYSQL_CLUSTER_DIR/mysqld.conf" ]; then
 397             sed -e "
 398                 s#\(datadir.*\)=.*#\1= $MYSQL_DATA_DIR#g;
 399                 s#\(pid-file.*\)=.*#\1= $MYSQL_PIDFILE#g;
 400                 s#\(socket.*\)=.*#\1= $MYSQL_SOCKET#g;
 401                 s#@clusterdir@#$MYSQL_CLUSTER_DIR#g;
 402                 " /usr/share/mysql/mysqld.conf > "$MYSQL_CLUSTER_DIR/mysqld.conf"
 403             chown root:root "$MYSQL_CLUSTER_DIR/mysqld.conf"
 404             chmod 640 "$MYSQL_CLUSTER_DIR/mysqld.conf"
 405         fi
 406
 407         if [ ! -e /var/lib/mysql/mysql.sock ] || [ -L /var/lib/mysql/mysql.sock ] && [ -z "$(readlink /var/lib/mysql/mysql.sock)" ]; then
 408                 sock=${MYSQL_SOCKET#/var/lib/mysql/} # make it relative if possible
 409             ln -s "$sock" /var/lib/mysql/mysql.sock
 410         fi
 411
 412         cat > $MYSQL_DATA_DIR/mysql-init.sql <<-EOF
 413                 CREATE DATABASE mysql;
 414                 use mysql;
 415                 $(cat /usr/share/mysql/mysql_system_tables.sql)
 416                 $(sed -e "/@current_hostname/d" /usr/share/mysql/mysql_system_tables_data.sql)
 417 EOF
 418
 419         ok=0
 420         /usr/sbin/mysqld \
 421                 --defaults-file=$MYSQL_CLUSTER_DIR/mysqld.conf \
 422                 --bootstrap \
 423                 --skip-grant-tables \
 424                 --datadir=$MYSQL_DATA_DIR \
 425                 --user=$MYSQL_USER \
 426                 --slave-load-tmpdir=$MYSQL_DATA_DIR \
 427                 --tmpdir=$MYSQL_DATA_DIR \
 428                 --log-error=$MYSQL_ERRLOG \
 429                 < $MYSQL_DATA_DIR/mysql-init.sql && ok=1
 430         [ -f $MYSQL_DATA_DIR/mysql/host.frm ] || ok=0
 431
 432         if [ "$ok" = 1 ]; then
 433                 rm -f $MYSQL_DATA_DIR/mysql-init.sql
 434                 ok
 435                 cat << END_OF_MSG
 436
 437 PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL USERS!
 438 This is done, after starting database, in the order shown,
 439 with:
 440
 441 For 'mysql_sysadmin' (RELOAD and SHUTDOWN privileges):
 442 echo "update mysql.user set password=password('newpassword') where user='mysql_sysadmin'; FLUSH PRIVILEGES;" | mysql -u mysql -S $MYSQL_SOCKET
 443
 444 For 'mysql' user (ALL privileges, DB admin):
 445 echo "update mysql.user set password=password('newpassword') where user='mysql'; FLUSH PRIVILEGES;" | mysql -u mysql -S $MYSQL_SOCKET
 446
 447 NOTE: mysql_sysadmin password should be placed to $MYSQL_CONFIG in
 448 mysqladmin section. See the manual for more instructions.
 449 (This user is used at logs rotation and server shutdown)
 450
 451 END_OF_MSG
 452                 show "Filling help tables..."
 453                 ok=0
 454                 ( echo "use mysql;"; cat /usr/share/mysql/fill_help_tables.sql ) | \
 455                         /usr/sbin/mysqld --bootstrap --skip-grant-tables \
 456                         --datadir=$MYSQL_DATA_DIR --user=$MYSQL_USER \
 457                         --slave-load-tmpdir=$MYSQL_DATA_DIR --tmpdir=$MYSQL_DATA_DIR --log-error=$MYSQL_ERRLOG \
 458                         && ok=1
 459                 if [ "$ok" = 1 ]; then
 460                         ok
 461                 else
 462                         cat << END_OF_MSG
 463
 464 WARNING: HELP FILES ARE NOT COMPLETELY INSTALLED!
 465 The "HELP" command might not work properly.
 466
 467 END_OF_MSG
 468                 fi
 469         else
 470                 fail
 471                 cat << END_OF_MSG
 472 Installation of grant tables FAILED!
 473
 474 The initialization SQL script was preserved at $MYSQL_DATA_DIR/mysql-init.sql
 475
 476 Examine the logs in /var/log/mysql for more information.  You can
 477 also try to start the mysqld daemon with:
 478
 479 /usr/sbin/mysqld --skip-grant &
 480
 481 You can use the command line tool mysql to connect to the mysql
 482 database and look at the grant tables:
 483
 484 shell> mysql -u mysql mysql
 485 mysql> show tables
 486
 487 Try 'mysqld --help' if you have problems with paths. Setting on
 488 logging in $MYSQL_DATA_DIR/mysqld.conf gives you a log in /var/log/mysql/query.log that
 489 may be helpful. The latest information about MySQL is available on the
 490 web at http://www.mysql.com/.
 491
 492 Please check PLD Linux ftp site for newer versions of this package.
 493
 494 Please consult the MySQL manual section: 'Problems running
 495 mysql_install_db', and the manual section that describes problems on
 496 your OS.  Another information source is the MySQL email archive.
 497
 498 END_OF_MSG
 499                 exit 1
 500         fi
 501 }
 502
 503 #
 504 # End of useful functions.
 505 #
 506
 507 start() {
 508         for mysqldir in $DB_CLUSTERS; do
 509                 mysqlstatus "$mysqldir" start
 510                 if [ "$MYSQL_STATUS" = "running" ]; then
 511                         msg_already_running "MySQL $mysqldir"
 512                 else
 513                         mysqlstart "$mysqldir"
 514                 fi
 515         done
 516         mysqlsubsys
 517 }
 518
 519 stop() {
 520         for mysqldir in $DB_CLUSTERS; do
 521                 mysqlstatus "$mysqldir" stop
 522                 if [ "$MYSQL_STATUS" = "not running" ]; then
 523                         msg_not_running "MySQL $mysqldir"
 524                 else
 525                         mysqlstop "$mysqldir"
 526                 fi
 527         done
 528         mysqlsubsys
 529 }
 530
 531 condrestart() {
 532         if [ -f /var/lock/subsys/mysql ]; then
 533                 stop
 534                 start
 535         else
 536                 msg_not_running "MySQL"
 537                 RETVAL=$1
 538         fi
 539 }
 540
 541 RETVAL=0
 542 case "$action" in
 543   start)
 544         start
 545         ;;
 546   stop)
 547         stop
 548         ;;
 549   restart)
 550         stop
 551         start
 552         ;;
 553   try-restart)
 554         condrestart 0
 555         ;;
 556   force-reload)
 557         condrestart 7
 558         ;;
 559   status)
 560         for mysqldir in $DB_CLUSTERS; do
 561                 mysqlstatus "$mysqldir"
 562                 if [ "$MYSQL_STATUS" = "running" ]; then
 563                         addr=${MYSQL_BIND_ADDRESS:-0.0.0.0}
 564                         port=${MYSQL_PORT:-3306}
 565                         socket=${MYSQL_SOCKET:-/var/lib/mysql/mysql.sock}
 566                         pid=$MYSQL_PID
 567                         show "MySQL cluster %s, pid %s\n\ttcp:%s:%s\n\tunix:%s" "$mysqldir" "$pid" "$addr" "$port" "$socket"
 568                         pids="$pids/$MYSQL_PID/"
 569                         progress "$MYSQL_STATUS"
 570                 else
 571                         show "MySQL cluster %s" "$mysqldir"
 572                         progress "$MYSQL_STATUS" "$CFAIL"
 573                 fi
 574                 echo
 575         done
 576
 577         for pid in $(/sbin/pidof mysqld); do
 578                 if [[ $pids != */$pid/* ]]; then
 579                         running="$running $pid"
 580                 fi
 581         done
 582
 583         if [ $# = 1 -a "$running" ]; then
 584                 nls "Warning: MySQL Daemon processes not under clusters.conf control:"
 585                 # see if we can display their status
 586                 for pid in $running; do
 587                         datadir=$(cat /proc/$pid/cmdline | tr '\0' '\n' | fgrep -- --datadir=)
 588                         datadir=${datadir#--datadir=} # strip --datadir
 589                         mysqldir=${datadir%/mysqldb/db} # strip /mysqldb/db
 590                         mysqlstatus "$mysqldir"
 591                         if [ "$MYSQL_STATUS" = "running" ]; then
 592                                 addr=${MYSQL_BIND_ADDRESS:-0.0.0.0}
 593                                 port=${MYSQL_PORT:-3306}
 594                                 socket=${MYSQL_SOCKET:-/var/lib/mysql/mysql.sock}
 595                                 show "MySQL cluster %s, pid %s\n\ttcp:%s:%s\n\tunix:%s" "$mysqldir" "$pid" "$addr" "$port" "$socket"
 596                                 progress "$MYSQL_STATUS"
 597                         else
 598                                 show "MySQL cluster %s" "$mysqldir"
 599                                 progress "$MYSQL_STATUS" "$CFAIL"
 600                         fi
 601                         echo
 602                 done
 603         fi
 604         ;;
 605   init)
 606         for mysqldir in $DB_CLUSTERS; do
 607                 mysqlinit "$mysqldir"
 608         done
 609         exit $?
 610         ;;
 611   flush-logs)
 612         for mysqldir in $DB_CLUSTERS; do
 613             mysqlgetconfig "$mysqldir"
 614                 # just if mysqld is really running
 615                 if /usr/bin/mysqladmin --defaults-file="$MYSQL_CONFIG" --socket="$MYSQL_SOCKET" ping >/dev/null 2>&1; then
 616                         /usr/bin/mysqladmin --defaults-file="$MYSQL_CONFIG" --socket="$MYSQL_SOCKET" flush-logs
 617                 fi
 618         done
 619         ;;
 620   *)
 621         msg_usage "$0 {start|stop|init|restart|try-restart|force-reload|status}"
 622         exit 3
 623 esac
 624
 625 exit $RETVAL