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