[debian-mysql] Bug#535493: mysql-dfsg-5.1: Clearly indicate that running multiple instances of mysqld is not supported

[Mathias Gug]

Package: mysql-dfsg-5.1
Version: 5.1.34-1
Severity: normal
Tags: patch
User: ubuntu-devel at lists.ubuntu.com
Usertags: origin-ubuntu karmic ubuntu-patch


In Ubuntu, we've applied the attached patch to achieve the following:

    - debian/mysql-server-5.1.mysql.init:
      + Clearly indicate that we do not support running multiple instances
        of mysqld by duplicating the init script.
        (closes: #314785, #324834, #435165, #444216)
      + Properly parameterize all existing references to the mysql config
        file (/etc/mysql/my.cnf).

This is a patch that is actually coming from the 5.0 mysql init script
and hasn't been included in the 5.1 init script. We thought you might be
interested in doing the same. 


-- System Information:
Debian Release: lenny/sid
  APT prefers hardy-updates
  APT policy: (500, 'hardy-updates'), (500, 'hardy-security'), (500, 'hardy')
Architecture: amd64 (x86_64)

Kernel: Linux 2.6.24-24-server (SMP w/2 CPU cores)
Locale: LANG=en_CA.UTF-8, LC_CTYPE=en_CA.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
-------------- next part --------------
diff -u mysql-dfsg-5.1-5.1.34/debian/mysql-server-5.1.mysql.init mysql-dfsg-5.1-5.1.34/debian/mysql-server-5.1.mysql.init
--- mysql-dfsg-5.1-5.1.34/debian/mysql-server-5.1.mysql.init
+++ mysql-dfsg-5.1-5.1.34/debian/mysql-server-5.1.mysql.init
@@ -21,8 +21,11 @@
 
 . /lib/lsb/init-functions
 
-SELF=$(cd $(dirname $0); pwd -P)/$(basename $0)
+# NOTE: Copying this script and changing the CONF variable here isn't
+# enough to run multiple instances of mysqld. Debian/Ubuntu doesn't 
+# currently support such a configuration out of the box.
 CONF=/etc/mysql/my.cnf
+SELF=$(cd $(dirname $0); pwd -P)/$(basename $0)
 MYADMIN="/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf"
 
 # priority can be overriden and "-s" adds output to stderr
@@ -51,9 +54,9 @@
 ## Do some sanity checks before even trying to start mysqld.
 sanity_checks() {
   # check for config file
-  if [ ! -r /etc/mysql/my.cnf ]; then
-    log_warning_msg "$0: WARNING: /etc/mysql/my.cnf cannot be read. See README.Debian.gz"
-    echo                "WARNING: /etc/mysql/my.cnf cannot be read. See README.Debian.gz" | $ERR_LOGGER
+  if [ ! -r "$CONF" ]; then
+    log_warning_msg "$0: WARNING: $CONF cannot be read. See README.Debian.gz"
+    echo                "WARNING: $CONF cannot be read. See README.Debian.gz" | $ERR_LOGGER
   fi
 
   # check for diskspace shortage