#!/bin/bash

MYADMIN="/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf"

export HOME=/etc/mysql
cd /
umask 077

mysqld_get_param() {
	/usr/sbin/mysqld --print-defaults \
		| tr " " "\n" \
		| grep -- "--$1" \
		| tail -n 1 \
		| cut -d= -f2
}

## Checks if there is a server running and if so if it is accessible.
#
# check_alive insists on a pingable server
# check_dead also fails if there is a lost mysqld in the process list
#
# Usage: boolean mysqld_status [check_alive|check_dead] [warn|nowarn]
mysqld_status () {
    ping_output=`$MYADMIN ping 2>&1`; ping_alive=$(( ! $? ))

    ps_alive=0
    pidfile=`mysqld_get_param pid-file`
    if [ -f "$pidfile" ] && ps `cat $pidfile` >/dev/null 2>&1; then ps_alive=1; fi
    
    if [ "$1" = "check_alive"  -a  $ping_alive = 1 ] ||
       [ "$1" = "check_dead"   -a  $ping_alive = 0  -a  $ps_alive = 0 ]; then
	return 0 # EXIT_SUCCESS
    else
  	if [ "$2" = "warn" ]; then
  	    echo -e "$ps_alive processes alive and '$MYADMIN ping' resulted in\n$ping_output\n" | $ERR_LOGGER -p daemon.debug
	fi
  	return 1 # EXIT_FAILURE
    fi
}

start() {
    test -e /var/run/mysqld || install -m 755 -o mysql -g root -d /var/run/mysqld
    /usr/bin/mysqld_safe > /dev/null 2>&1 &
    for i in 1 2 3 4 5 6 7 8 9 10 11 12 13 14; do
        sleep 1
        if mysqld_status check_alive nowarn ; then break; fi
    done
    if mysqld_status check_alive warn; then
        output=$(/etc/mysql/debian-start)
        [ -n "$output" ] && echo "$output"
    else
        echo "Please take a look at the syslog"
    fi
}

stop() {
    shutdown_out=`$MYADMIN shutdown 2>&1`; r=$?
    if [ "$r" -ne 0 ]; then
        echo "mysqld shutdown failed: $shutdown_out"
        echo "killing by signal"
        pidfile=`mysqld_get_param pid-file`
        if [ -f "$pidfile" ]; then
            pkill mysqld
        fi
    fi
}

refresh() {
    $MYADMIN reload
}

case "$1" in
    start) start;;
    stop) stop;;
    refresh) refresh;;
esac