X-Git-Url: https://git.pld-linux.org/?a=blobdiff_plain;f=mysql.init;h=6b1da9b8dbfe151e9f52cd1a8c3dc2f1088aad8e;hb=874af6dea26c9ea8027718dfb18a711c037a6028;hp=c0db326b37ead010c76e6202e8379bb45b008732;hpb=62edb21ba122b18807449a265b5315fd068da810;p=packages%2Fmysql.git diff --git a/mysql.init b/mysql.init old mode 100644 new mode 100755 index c0db326..6b1da9b --- a/mysql.init +++ b/mysql.init @@ -1,11 +1,10 @@ #!/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 @@ -18,7 +17,7 @@ if [ -f /etc/sysconfig/mysql ]; then . /etc/sysconfig/mysql else nls "Error: %s not found" /etc/sysconfig/mysql - nls " MySQL can't be run." + nls "%s can't be run." MySQL exit 1 fi @@ -26,15 +25,22 @@ if [ -n "$MYSQL_DB_CLUSTERS" ]; then nls "Warning: MYSQL_DB_CLUSTERS is set. It's obsolete. Use %s instead." /etc/mysql/clusters.conf fi -[ -f /etc/mysql/clusters.conf ]&& MYSQL_DB_CLUSTERS=$(grep -v '^#' /etc/mysql/clusters.conf | cut -s -f 2 -d '=') +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 -if [ -z "$MYSQL_DB_CLUSTERS" ]; then +else nls "Warning: Missing clusters config file %s" /etc/mysql/clusters.conf - nls "Warning: or there is no configured clusters in it." - nls "Using default cluster /var/lib/mysql (compatibility mode)" - MYSQL_DB_CLUSTERS=/var/lib/mysql + 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 @@ -45,18 +51,37 @@ else exit 0 fi +sharedir=/usr/share/mysql + action="$1" # any db cluster as command line argument? if [ $# -gt 1 ]; then shift # perform action for specified clusters only - DB_CLUSTERS="$@" + 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 -MYSQL_ERRLOG=/var/log/mysql/err +# 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. @@ -67,108 +92,181 @@ MYSQL_ERRLOG=/var/log/mysql/err # # arguments: # $1 - db cluster +# $2 - start|stop # # sets variables: -# MYSQL_STATUS = running | not running +# MYSQL_STATUS = starting | running | not running | died # MYSQL_PID = pid of mysqld process # mysqlstatus() { clusterdir="$1" - mysqlgetconfig "$clusterdir" + mode="$2" + mysqlgetconfig "$clusterdir" status + MYSQL_STATUS="not running" MYSQL_PID="unknown" + MYSQL_PIDFILE_PID="" + MYSQL_GREP_PID="" - [ -f "$MYSQL_PIDFILE" ] && MYSQL_PID=$(cat "$MYSQL_PIDFILE") + 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 [ ! -d "/proc/$MYSQL_PID" -a "$MYSQL_PID" != "unknown" ]; then - MYSQL_STATUS="died" - elif [ -d "/proc/$MYSQL_PID" ]; then - grep -qa "$MYSQL_PIDFILE" /proc/$MYSQL_PID/cmdline && MYSQL_STATUS="running" || MYSQL_STATUS="not running" + if [ "$mode" = "start" ]; then + 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 + 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 +# 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; export MYSQL_RA_COMPAT + MYSQL_RA_COMPAT=yes config_file=/etc/mysqld.conf else - # TODO: convert this piece of crap to awk - config=`grep -v "^#" /etc/mysql/clusters.conf | grep "${clusterdir}$" | cut -s -f 1 -d '='` - if echo "$config" | grep -q '^/'; then + 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 - config_file=/etc/mysql/$config + config_file="/etc/mysql/$config" else config_file="$clusterdir/mysqld.conf" fi fi - MYSQL_CLUSTER_DIR="$clusterdir"; export MYSQL_CLUSTER_DIR - + MYSQL_CLUSTER_DIR="$clusterdir" + 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"; export MYSQL_CONFIG + 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 + 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); } -} -END { - print "export MYSQL_DATA_DIR MYSQL_USER MYSQL_PIDFILE MYSQL_SOCKET" -} -' $config_file` + # skip comments and empty lines + /^[;#]|^ *$/ { next } + + /^[ \t]*\[.*\][ \t]*$/ { + match($0, /\[.*\]/); + section = substr($0, RSTART + 1, RSTART + RLENGTH - 3); + next; + } + + 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="" 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 + if [ -z "$MYSQL_USER" ]; then echo "$(nls 'MySQL user not configured properly')"'!' >&2 nls "Edit %s and configure it." "$config_file" >&2 exit 6 @@ -177,7 +275,7 @@ END { # start mysql mysqlstart() { - clusterdir="$1" + local clusterdir="$1" mysqlgetconfig "$clusterdir" if [ ! -d "$MYSQL_DATA_DIR/mysql" ]; then nls "MySQL cluster %s not initialized." "$clusterdir" @@ -185,12 +283,39 @@ 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 - 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_ERRLOG 2>&1 & - sleep 2 - mysqlstatus "$clusterdir" + 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_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 + 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 @@ -204,24 +329,92 @@ mysqlstart() { # stop mysql mysqlstop() { - clusterdir="$1" - mysqlstatus "$clusterdir" + local clusterdir="$1" + mysqlstatus "$clusterdir" stop msg_stopping "MySQL $clusterdir" busy - [ "$MYSQL_PID" != "unknown" ] && kill -TERM "$MYSQL_PID" 2> /dev/null - # 3 seconds - for nr in 1 2 3; do - [ -d "/proc/$MYSQL_PID" ] && sleep 1 - done - mysqlstatus "$clusterdir" + + # 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" ]; then + elif [ "$MYSQL_STATUS" = "running" -o "$MYSQL_STATUS" = "starting" ]; then fail else ok fi - rm -f "$MYSQL_PIDFILE" +} + +# 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" } # @@ -241,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." @@ -257,285 +450,128 @@ mysqlinit() { 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 - 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/mysqldb/mysql" + 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 - - - # Install this in the user table, too - hostname="`hostname --fqdn 2> /dev/null | tr -d '[:space:]'`" - [ -z "$hostname" ] && hostname="localhost-unknown" - - # Check if hostname is valid - if [ -z "$hostname" ]; then - deltext - fail - nls "Sorry, the host name is not configured." - nls "Please configure the 'hostname' command to return a hostname." - exit 1 - elif ! hostname -i >/dev/null 2>&1; then - deltext - fail - nls "Sorry, the host '%s' could not be looked up." "$hostname" - nls "Please configure the 'hostname' command to return a correct hostname." - exit 1 - fi - - # Initialize variables - c_d="" i_d="" - c_h="" i_h="" - c_u="" i_u="" - c_f="" i_f="" - c_t="" c_c="" - - # Check for old tables - if test ! -f $MYSQL_DATA_DIR/mysqldb/mysql/db.frm - then - # mysqld --bootstrap wants one command/line - c_d="$c_d CREATE TABLE db (" - c_d="$c_d Host char(60) DEFAULT '' NOT NULL," - c_d="$c_d Db char(64) DEFAULT '' NOT NULL," - c_d="$c_d User char(16) DEFAULT '' NOT NULL," - c_d="$c_d Select_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_d="$c_d Insert_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_d="$c_d Update_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_d="$c_d Delete_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_d="$c_d Create_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_d="$c_d Drop_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_d="$c_d Grant_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_d="$c_d References_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_d="$c_d Index_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_d="$c_d Alter_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_d="$c_d Create_tmp_table_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_d="$c_d Lock_tables_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_d="$c_d PRIMARY KEY Host (Host,Db,User)," - c_d="$c_d KEY User (User)" - c_d="$c_d )" - c_d="$c_d CHARACTER SET utf8 COLLATE utf8_bin" - c_d="$c_d comment='Database privileges';" - - i_d="INSERT INTO db VALUES ('%','test','','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y'); - INSERT INTO db VALUES ('%','test\_%','','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y');" - - fi - - if test ! -f $MYSQL_DATA_DIR/mysqldb/mysql/host.frm - then - c_h="$c_h CREATE TABLE host (" - c_h="$c_h Host char(60) DEFAULT '' NOT NULL," - c_h="$c_h Db char(64) DEFAULT '' NOT NULL," - c_h="$c_h Select_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_h="$c_h Insert_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_h="$c_h Update_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_h="$c_h Delete_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_h="$c_h Create_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_h="$c_h Drop_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_h="$c_h Grant_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_h="$c_h References_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_h="$c_h Index_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_h="$c_h Alter_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_h="$c_h Create_tmp_table_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_h="$c_h Lock_tables_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_h="$c_h PRIMARY KEY Host (Host,Db)" - c_h="$c_h )" - c_h="$c_h CHARACTER SET utf8 COLLATE utf8_bin" - c_h="$c_h comment='Host privileges; Merged with database privileges';" - fi - - if test ! -f $MYSQL_DATA_DIR/mysqldb/mysql/user.frm - then - c_u="$c_u CREATE TABLE user (" - c_u="$c_u Host char(60) DEFAULT '' NOT NULL," - c_u="$c_u User char(16) DEFAULT '' NOT NULL," - c_u="$c_u Password char(41) DEFAULT '' NOT NULL," - c_u="$c_u Select_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_u="$c_u Insert_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_u="$c_u Update_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_u="$c_u Delete_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_u="$c_u Create_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_u="$c_u Drop_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_u="$c_u Reload_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_u="$c_u Shutdown_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_u="$c_u Process_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_u="$c_u File_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_u="$c_u Grant_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_u="$c_u References_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_u="$c_u Index_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_u="$c_u Alter_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_u="$c_u Show_db_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_u="$c_u Super_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_u="$c_u Create_tmp_table_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_u="$c_u Lock_tables_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_u="$c_u Execute_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_u="$c_u Repl_slave_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_u="$c_u Repl_client_priv enum('N','Y') DEFAULT 'N' NOT NULL," - c_u="$c_u ssl_type enum('','ANY','X509', 'SPECIFIED') DEFAULT '' NOT NULL," - c_u="$c_u ssl_cipher BLOB NOT NULL," - c_u="$c_u x509_issuer BLOB NOT NULL," - c_u="$c_u x509_subject BLOB NOT NULL," - c_u="$c_u max_questions int(11) unsigned DEFAULT 0 NOT NULL," - c_u="$c_u max_updates int(11) unsigned DEFAULT 0 NOT NULL," - c_u="$c_u max_connections int(11) unsigned DEFAULT 0 NOT NULL," - c_u="$c_u PRIMARY KEY Host (Host,User)" - c_u="$c_u )" - c_u="$c_u CHARACTER SET utf8 COLLATE utf8_bin" - c_u="$c_u comment='Users and global privileges';" - - i_u="INSERT INTO user VALUES ('localhost','mysql','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0); - INSERT INTO user VALUES ('$hostname','mysql','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0); - - REPLACE INTO user VALUES ('localhost','mysql','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0); - REPLACE INTO user VALUES ('$hostname','mysql','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0); - - INSERT INTO user VALUES ('localhost','mysql_logrotate','','N','N','N','N','N','N','Y','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','',0,0,0);" - fi - - if test ! -f $MYSQL_DATA_DIR/mysqldb/mysql/func.frm - then - c_f="$c_f CREATE TABLE func (" - c_f="$c_f name char(64) DEFAULT '' NOT NULL," - c_f="$c_f ret tinyint(1) DEFAULT '0' NOT NULL," - c_f="$c_f dl char(128) DEFAULT '' NOT NULL," - c_f="$c_f type enum ('function','aggregate') NOT NULL," - c_f="$c_f PRIMARY KEY (name)" - c_f="$c_f )" - c_f="$c_f CHARACTER SET utf8 COLLATE utf8_bin" - c_f="$c_f comment='User defined functions';" - fi - - if test ! -f $MYSQL_DATA_DIR/mysqldb/mysql/tables_priv.frm - then - c_t="$c_t CREATE TABLE tables_priv (" - c_t="$c_t Host char(60) DEFAULT '' NOT NULL," - c_t="$c_t Db char(64) DEFAULT '' NOT NULL," - c_t="$c_t User char(16) DEFAULT '' NOT NULL," - c_t="$c_t Table_name char(60) DEFAULT '' NOT NULL," - c_t="$c_t Grantor char(77) DEFAULT '' NOT NULL," - c_t="$c_t Timestamp timestamp(14)," - c_t="$c_t Table_priv set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter') DEFAULT '' NOT NULL," - c_t="$c_t Column_priv set('Select','Insert','Update','References') DEFAULT '' NOT NULL," - c_t="$c_t PRIMARY KEY (Host,Db,User,Table_name)," - c_t="$c_t KEY Grantor (Grantor)" - c_t="$c_t )" - c_t="$c_t CHARACTER SET utf8 COLLATE utf8_bin" - c_t="$c_t comment='Table privileges';" - fi - - if test ! -f $MYSQL_DATA_DIR/mysqldb/mysql/columns_priv.frm - then - c_c="$c_c CREATE TABLE columns_priv (" - c_c="$c_c Host char(60) DEFAULT '' NOT NULL," - c_c="$c_c Db char(64) DEFAULT '' NOT NULL," - c_c="$c_c User char(16) DEFAULT '' NOT NULL," - c_c="$c_c Table_name char(64) DEFAULT '' NOT NULL," - c_c="$c_c Column_name char(64) DEFAULT '' NOT NULL," - c_c="$c_c Timestamp timestamp(14)," - c_c="$c_c Column_priv set('Select','Insert','Update','References') DEFAULT '' NOT NULL," - c_c="$c_c PRIMARY KEY (Host,Db,User,Table_name,Column_name)" - c_c="$c_c )" - c_c="$c_c CHARACTER SET utf8 COLLATE utf8_bin" - c_c="$c_c comment='Column privileges';" - fi + 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 + 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.*=.*#datadir = $MYSQL_DATA_DIR#g" \ - -e "s#pid-file.*=.*#pid-file = $MYSQL_PIDFILE#g" \ - -e "s#socket.*=.*#socket = $MYSQL_SOCKET#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 ]; then - ln -s "$MYSQL_SOCKET" /var/lib/mysql/mysql.sock - fi + 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 + ok + cat << END_OF_MSG + +PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL USERS! - if /usr/sbin/mysqld --bootstrap --skip-grant-tables \ - --datadir=$MYSQL_DATA_DIR --user=$MYSQL_USER << END_OF_DATA -CREATE DATABASE mysql; -use mysql; -$c_d -$i_d +CURRENT TEMPORARY ROOT PASSWORD CAN BE FOUND IN LOG +(grep for "A temporary password is generated" string): +$MYSQL_ERRLOG -$c_h -$i_h -$c_u -$i_u +Start database: +$ service mysql start -$c_f -$i_f +and set passwords: -$c_t -$c_c -END_OF_DATA - then - ok - cat << END_OF_MSG +FIXME FIXME: 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 -PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL USERS! -This is done (after starting database) with: +For 'root' user (ALL privileges, DB admin), paste command with new password: +ALTER USER 'root'@'localhost' IDENTIFIED BY 'newpassword'; FLUSH PRIVILEGES; -/usr/bin/mysqladmin -u mysql -S $MYSQL_SOCKET password 'password' -/usr/bin/mysqladmin -h $hostname -u mysql -S $MYSQL_SOCKET password 'password' -/usr/bin/mysqladmin -u mysql_logrotate -S $MYSQL_SOCKET password 'password' +into command: +$ mysql -u root -p -S $MYSQL_SOCKET -NOTE: mysql_logrotate password should be placed to $MYSQL_CONFIG in +NOTE: mysql_sysadmin password should be placed to $MYSQL_CONFIG in mysqladmin section. See the manual for more instructions. - -IMPORTANT: The configuration file is mysqld.conf in MYSQ_DB_CLUSTERS directories. +(This user is used at logs rotation and server shutdown) END_OF_MSG - else - fail - cat << END_OF_MSG -Installation of grant tables FAILED! + else + fail + cat << END_OF_MSG +ERROR: +ERROR: +ERROR: Installation FAILED! +ERROR: +ERROR: -Examine the logs in $MYSQL_DATA_DIR for more information. You can -also try to start the mysqld demon with: +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/. -Please check PLD ftp site for newer versions of this package. +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 } @@ -543,17 +579,10 @@ END_OF_MSG # End of useful functions. # -RETVAL=0 -case "$action" in - start) - if [ ! -f $MYSQL_ERRLOG ]; then - touch $MYSQL_ERRLOG - fi - chown mysql:mysql $MYSQL_ERRLOG - chmod 640 $MYSQL_ERRLOG - +start() { + local mysqldir for mysqldir in $DB_CLUSTERS; do - mysqlstatus "$mysqldir" + mysqlstatus "$mysqldir" start if [ "$MYSQL_STATUS" = "running" ]; then msg_already_running "MySQL $mysqldir" else @@ -561,10 +590,12 @@ case "$action" in fi done mysqlsubsys - ;; - stop) +} + +stop() { + local mysqldir for mysqldir in $DB_CLUSTERS; do - mysqlstatus "$mysqldir" + mysqlstatus "$mysqldir" stop if [ "$MYSQL_STATUS" = "not running" ]; then msg_not_running "MySQL $mysqldir" else @@ -572,19 +603,96 @@ case "$action" in fi done mysqlsubsys - ;; - status) - status mysqld +} + +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" - echo "MySQL cluster $mysqldir: $MYSQL_STATUS" + if [ "$MYSQL_STATUS" = "running" ]; then + 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" + progress "$MYSQL_STATUS" "$CFAIL" + 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 ;; - restart|force-reload) - $0 stop - $0 start - exit $? + stop) + stop + ;; + restart) + stop + start + ;; + try-restart) + condrestart 0 + ;; + force-reload) + condrestart 7 ;; init) for mysqldir in $DB_CLUSTERS; do @@ -593,16 +701,20 @@ case "$action" in exit $? ;; flush-logs) - for mysqldir in $DB_CLUSTERS; do - mysqlgetconfig "$mysqldir" - /usr/bin/mysqladmin --defaults-file="$MYSQL_CONFIG" --socket="$MYSQL_SOCKET" 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 ;; + 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