#!/bin/sh

#

# @DAEMON_NAME@	This shell script takes care of starting and stopping

#		the MySQL subsystem (mysqld).

#

# chkconfig: - 64 36

# description:	MySQL database server.

# processname: mysqld

# config: @sysconfdir@/my.cnf

# pidfile: /var/run/@DAEMON_NAME@/@DAEMON_NO_PREFIX@.pid

### BEGIN INIT INFO

# Provides: mysqld

# Required-Start: $local_fs $remote_fs $network $named $syslog $time

# Required-Stop: $local_fs $remote_fs $network $named $syslog $time

# Short-Description: start and stop MySQL server

# Description: MySQL database server

### END INIT INFO

# Source function library.

. /etc/rc.d/init.d/functions

# Source networking configuration.

. /etc/sysconfig/network

exec="@bindir@/mysqld_safe"

prog="@DAEMON_NAME@"

# Set timeouts here so they can be overridden from @sysconfdir@/sysconfig/@DAEMON_NO_PREFIX@

STARTTIMEOUT=300

STOPTIMEOUT=60

# User and group the daemon will run under

MYUSER=mysql

MYGROUP=mysql

# Edit the following file in order to re-write some of the environment

# variables defined above, like $STARTTIMEOUT, $STOPTIMEOUT, $exec

[ -e @sysconfdir@/sysconfig/@DAEMON_NO_PREFIX@ ] && . @sysconfdir@/sysconfig/@DAEMON_NO_PREFIX@

lockfile=/var/lock/subsys/$prog

# get options from my.cnf

source "@libexecdir@/mysql-scripts-common"

start(){

    [ -x $exec ] || exit 5

    # check permissions

    if ! touch $(dirname $socketfile) &>/dev/null ; then

        action $"Starting $prog: " /bin/false

        return 4

    fi

    # Check if PID file exists (which should indicate, the daemon is already running)

    MYSQLDRUNNING=0

    if [ -f "$pidfile" ]; then

	MYSQLPID=`su - $MYUSER -s /bin/bash -c "cat $pidfile 2>/dev/null"`

	if [ -n "$MYSQLPID" ] && [ -d "/proc/$MYSQLPID" ] ; then

	    # Test that the read data is an integer

	    if [ 1 -ne `echo $MYSQLPID | grep -c -E "^[0-9]+$"` ] ; then

	        # Set an error value

	        MYSQLDRUNNING=2

	    else

	        MYSQLDRUNNING=1

	    fi

	fi

    fi

    # Ping the socket to check, if there's already a running server on that socket

    RESPONSE=`@bindir@/mysqladmin --no-defaults --socket="$socketfile" --user=UNKNOWN_MYSQL_USER ping 2>&1`

    if [ $? = 0 ] || echo "$RESPONSE" | grep -q "Access denied for user"

        then

        if [ $MYSQLDRUNNING = 0 ]; then

            # PID file does not exist, but the server is responsive = different server, or server with different configuration, is running, fail to prevent damage

            echo "Socket already in use by a different, responding server" >&2

	    action $"Starting $prog: " /bin/false

	    return 1

        elif [ $MYSQLDRUNNING = 1 ]; then

            # PID file is valid and server is responsive = already running, do nothing

	    action $"Starting $prog: " /bin/true

	    ret=0

        elif [ $MYSQLDRUNNING = 2 ]; then

            # PID file contains garbage, but the server is responsive. Notify admin and fail.

            echo "Socket already in use by a different, responding server" >&2

            echo "PID file does not contain an integer. Please investigate." >&2

	    action $"Starting $prog: " /bin/false

	    return 1

        fi

    else

        if [ $MYSQLDRUNNING = 1 ]; then

            # If the PID file exist by any reason, but there is no response on the socket, notify the admin and fail.

            # The PID might be in use by a server which configured different socket

            echo "PID file already exists. It might belong to a living process. Please investigate." >&2

	    action $"Starting $prog: " /bin/false

	    return 1

        elif [ $MYSQLDRUNNING = 2 ]; then

            # If the PID file exist, but contains garbage, and there is no response on the socket, notify the admin and fail.

            echo "PID file already exists. However it does not contain an integer. Please investigate." >&2

	    action $"Starting $prog: " /bin/false

	    return 1

        fi

        @libexecdir@/mysql-check-socket || return 1

        # KNOWN ISSUE: Per standard, following line should return '1' on error

        #              Leaving '4' for behaviour compatibility with released versions of this script

        su - $MYUSER -s /bin/bash -c "@libexecdir@/mysql-prepare-db-dir $MYUSER $MYGROUP" || return 4

	# Pass all the options determined above, to ensure consistent behavior.

	# In many cases mysqld_safe would arrive at the same conclusions anyway

	# but we need to be sure.  (An exception is that we don't force the

	# log-error setting, since this script doesn't really depend on that,

	# and some users might prefer to configure logging to syslog.)

	# Note: set --basedir to prevent probes that might trigger SELinux

	# alarms, per bug #547485

	su - $MYUSER -s /bin/bash -c "$exec   --datadir='$datadir' --socket='$socketfile' \

		--pid-file='$pidfile' $MYSQLD_OPTS $_WSREP_NEW_CLUSTER \

		--basedir=@prefix@ --user=$MYUSER" >/dev/null 2>&1 &

	safe_pid=$!

	# Wait until the daemon is up

	su - $MYUSER -s /bin/bash -c "@libexecdir@/mysql-wait-ready '$safe_pid'"

	ret=$?

	if [ $ret -eq 0 ]; then

	    action $"Starting $prog: " /bin/true

	    chmod o+r $pidfile >/dev/null 2>&1

	    touch $lockfile

	else

	    action $"Starting $prog: " /bin/false

	fi

    fi

    return $ret

}

stop(){

	if [ ! -f "$pidfile" ]; then

	    # not running; per LSB standards this is "ok"

	    action $"Stopping $prog: " /bin/true

	    return 0

	fi

	MYSQLPID=`su - $MYUSER -s /bin/bash -c "cat $pidfile 2>/dev/null"`

	# Test that the read data is an integer

	if [ 1 -ne `echo $MYSQLPID | grep -c -E "^[0-9]+$"` ] ; then

	    echo "PIDfile does not contain a number. Please investigate." >&2

	    action $"Stopping $prog: " /bin/false

	    return 1

	fi

	if [ -n "$MYSQLPID" ]; then

	    if ! [ -d "/proc/$MYSQLPID" ] ; then

		# process doesn't run anymore

		action $"Stopping $prog: " /bin/true

		return 0

	    fi

	    # Drop priviledges before calling kill

	    su - $MYUSER -s /bin/bash -c "/bin/kill $MYSQLPID" >/dev/null 2>&1

	    ret=$?

	    if [ $ret -eq 0 ]; then

		TIMEOUT="$STOPTIMEOUT"

		while [ $TIMEOUT -gt 0 ]; do

		    # Drop priviledges before calling kill

		    su - $MYUSER -s /bin/bash -c "/bin/kill -0 $MYSQLPID" >/dev/null 2>&1 || break

		    sleep 1

		    let TIMEOUT=${TIMEOUT}-1

		done

		if [ $TIMEOUT -eq 0 ]; then

		    echo "Timeout error occurred trying to stop MySQL Daemon."

		    ret=1

		    action $"Stopping $prog: " /bin/false

		else

		    rm -f $lockfile

		    rm -f "$socketfile"

		    action $"Stopping $prog: " /bin/true

		fi

	    else

		# kill command failed, probably insufficient permissions

		action $"Stopping $prog: " /bin/false

		ret=4

	    fi

	else

	    # failed to read pidfile, probably insufficient permissions

	    action $"Stopping $prog: " /bin/false

	    ret=4

	fi

	return $ret

}

restart(){

    stop

    start

}

condrestart(){

    [ -e $lockfile ] && restart || :

}

# See how we were called.

case "$1" in

  start)

    start

    ;;

  stop)

    stop

    ;;

  status)

    status -p "$pidfile" $prog

    ;;

  restart)

    restart

    ;;

  condrestart|try-restart)

    condrestart

    ;;

  reload)

    exit 3

    ;;

  force-reload)

    restart

    ;;

  *)

    echo $"Usage: $0 {start|stop|status|restart|condrestart|try-restart|reload|force-reload}"

    exit 2

esac

exit $?