X-Git-Url: http://ftp.carnet.hr/carnet-debian/scm?a=blobdiff_plain;ds=sidebyside;f=files%2Fetc%2Finit.d%2Fmysql;fp=files%2Fetc%2Finit.d%2Fmysql;h=3f411188e2a26aa58a6d56e060f8d6af5f0e7cbc;hb=d76524eb23710a7326e9633ab4df800d65449c5d;hp=0000000000000000000000000000000000000000;hpb=a26fded43562e80021ad20d6066a6667fa78e0e8;p=carnet-upgrade.git

diff --git a/files/etc/init.d/mysql b/files/etc/init.d/mysql
new file mode 100755
index 0000000..3f41118
--- /dev/null
+++ b/files/etc/init.d/mysql
@@ -0,0 +1,163 @@
+#!/bin/bash
+#
+# MySQL daemon start/stop script.
+#
+# Debian version. Based on the original by TcX.
+#
+set -e
+set -u
+${DEBIAN_SCRIPT_DEBUG:+ set -v -x}
+
+test -x /usr/sbin/mysqld || exit 0
+
+SELF=$(cd $(dirname $0); pwd -P)/$(basename $0)
+CONF=/etc/mysql/my.cnf
+MYADMIN="/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf"
+RUNDIR=/var/run/mysqld/
+
+# priority can be overriden and "-s" adds output to stderr
+ERR_LOGGER="logger -p daemon.err -t /etc/init.d/mysql -i"
+
+# Safeguard (relative paths, core dumps..)
+cd /
+umask 077
+export PATH=/bin:/usr/bin
+
+# mysqladmin likes to read /root/.my.cnf. This is usually not what I want
+# as many admins e.g. only store a password without a username there and
+# so break my scripts.
+export HOME=/etc/mysql/
+
+## fetch a particular option from mysql's invocation
+#
+# usage: void mysqld_get_param option
+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" ]; then
+        if ps `cat $pidfile` >/dev/null 2>&1; then ps_alive=1; fi
+    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
+  	    /bin/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
+}
+
+#
+# main()
+#
+
+case "${1:-''}" in
+  'start')
+	# check for config file
+	if [ ! -r $CONF ]; then
+	  /bin/echo -e "\nWARNING: $CONF cannot be read. See README.Debian."
+        fi 
+	# check for /var/run/mysqld/ which maybe have only been on a tempfs
+	if [ ! -d $RUNDIR ]; then
+	  install --directory --owner=mysql --mode=755 $RUNDIR
+	fi
+	# Start daemon
+	echo -n "Starting MySQL database server: mysqld"
+	if mysqld_status check_alive nowarn; then
+	   echo "...already running."
+	else
+  	    /usr/bin/mysqld_safe > /dev/null 2>&1 &
+	    for i in 1 2 3 4 5 6; do
+                sleep 1
+	        if mysqld_status check_alive nowarn ; then break; fi
+            done
+	    if mysqld_status check_alive warn; then
+                echo "."
+	        # Now start mysqlcheck or whatever the admin wants.
+	        /etc/mysql/debian-start
+	    else
+	        echo "...failed."
+	        /bin/echo -e "\tPlease take a look at the syslog."
+	    fi
+	fi
+
+	if $MYADMIN variables | egrep -q have_bdb.*YES; then
+	    /bin/echo "BerkeleyDB is obsolete, see /usr/share/doc/mysql-server/README.Debian.gz" | $ERR_LOGGER -p daemon.info
+	fi
+
+	;;
+
+  'stop')
+	# * As a passwordless mysqladmin (e.g. via ~/.my.cnf) must be possible
+	# at least for cron, we can rely on it here, too. (although we have 
+	# to specify it explicit as e.g. sudo environments points to the normal
+	# users home and not /root)
+	echo -n "Stopping MySQL database server: mysqld"	
+	if ! mysqld_status check_dead nowarn; then
+	  set +e
+	  shutdown_out=`$MYADMIN shutdown 2>&1`; r=$?
+	  set -e
+	  if [ "$r" -ne 0 ]; then
+	    /bin/echo -e -n "...failed.\n$shutdown_out\nKilling MySQL database server by signal: mysqld"
+	    killall -15 mysqld
+            server_down=
+	    for i in 1 2 3 4 5 6 7 8 9 10; do
+              sleep 1
+              if mysqld_status check_dead nowarn; then server_down=1; break; fi
+            done
+          if test -z "$server_down"; then killall -9 mysqld; fi
+	  fi
+        fi
+
+        if ! mysqld_status check_dead warn; then
+	  echo "...failed."
+	  echo "Please stop MySQL manually and read /usr/share/doc/mysql-server/README.Debian!"
+	  exit -1
+	else
+	  echo "."
+        fi
+	;;
+
+  'restart')
+	set +e; $SELF stop; set -e
+	$SELF start 
+	;;
+
+  'reload'|'force-reload')
+  	echo -n "Reloading MySQL database server: mysqld"
+	$MYADMIN reload
+	echo "."
+	;;
+
+  'status')
+	if mysqld_status check_alive nowarn; then
+	  $MYADMIN version
+	else
+	  echo "MySQL is stopped."
+	fi
+  	;;
+
+  *)
+	echo "Usage: $SELF start|stop|restart|reload|force-reload"
+	exit 1
+	;;
+esac
+