#!/bin/sh
### BEGIN INIT INFO
# Provides:          Mysql_Enterprise_Architect
# Required-Start:    $local_fs $network $named $time $syslog
# Required-Stop:     $local_fs $network $named $time $syslog
# Default-Start:     2 3 4 5
# Default-Stop:      0 1 6
# Description:       Mysql Enterprise Architect
### END INIT INFO

SCRIPT=mysqld_safe
BASEDIR=/usr

DATADIR=/var/lib/mysql_ea
SOCKET=/var/run/mysqld/mysql_ea.sock
PORT=3310
BINDADDRESS="0.0.0.0"
PIDFILE=/var/run/mysqld/mysql_ea.pid
LOGFILE=/var/log/mysql_ea.log

ADMINFILE=/etc/mysql/debian_ea.cnf
PIDNUMBER=0

start() {
        if [ -f "$PIDFILE" ]; then
                PIDNUMBER=$(cat "$PIDFILE")
                if  kill -0 $PIDNUMBER ; then
                        echo "Process is running under: $PIDNUMBER"
                        return 1
                fi
        fi
        mysqld_safe --basedir=$BASEDIR --datadir=$DATADIR --socket=$SOCKET --port=$PORT --bind-address=$BINDADDRESS --log-error=$LOGFILE --pid-file=$PIDFILE >/dev/null 2>&1 &
}

stop() {
        echo "shutdown process is running ...."
        if [ ! -f "$PIDFILE" ] || ! kill -0 $(cat "$PIDFILE"); then
                echo "Processis not running"
                return 1
        fi
        mysqladmin --defaults-file=$ADMINFILE shutdown
        echo "shutdown process completed"
}

case "$1" in
  start)
    start
    ;;
  stop)
    stop
    ;;
  retart)
    stop
    start
    ;;
  *)
    echo "Usage: $0 {start|stop|restart}"
esac