Package: mysql-server-5.0
Version: 5.0.45-1
Severity: minor
This is the result of the bug reported in Ubuntu. Raised here to pass
the debdiff upstream to Debian.
https://bugs.launchpad.net/ubuntu/+source/mysql-dfsg-5.0/+bug/106244
A user reported that they were trying to run multiple instances of
mysqld by duplicating the init script and changing the value of the CONF
variable within it to point to another configuration file. They raised
the bug in Ubuntu because the /etc/mysql/my.cnf is hard coded in a lot
of the startup scripts, and prevented them from easily running
multi-instances in this way.
After some analysis and discussion with mathiaz and infinity from the
ubuntu-server team it was agreed that we cannot properly support
multi-instances in this way because the maintainer scripts are not
designed to deal with this situation and could therefore lead to
problems on package upgrade/removal. Instead the proper way to do things
would seem to be to use mysqld_multi.
A patch has been prepared which clearly comments the CONF variable
stating that multi-instances are not supported in this way, and removes
some of the hard-coded instances of '/etc/mysql/my.cnf' for the sake of
tidyness.
(This is my first bug report to the Debian BTS sorry if there are any
slip-ups).
-- System Information:
Debian Release: 4.0
APT prefers feisty-updates
APT policy: (500, 'feisty-updates'), (500, 'feisty-security'), (500,
'feisty-backports'), (500, 'feisty')
Architecture: i386 (i686)
Shell: /bin/sh linked to /bin/dash
Kernel: Linux 2.6.20-16-generic
Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8)
diff -u mysql-dfsg-5.0-5.0.45/debian/changelog
mysql-dfsg-5.0-5.0.45/debian/changelog
--- mysql-dfsg-5.0-5.0.45/debian/changelog
+++ mysql-dfsg-5.0-5.0.45/debian/changelog
@@ -1,3 +1,14 @@
+mysql-dfsg-5.0 (5.0.45-1ubuntu1) gutsy; urgency=low
+
+ * debian/mysql-server-5.0.mysql.init: modified to
+ - Clearly indicate that we do not support running multiple instances
+ of mysqld by duplicating the init script.
+ - Properly parameterized all existing references to the mysql config
+ file (/etc/mysql/my.cnf).
+ (Fixes LP: #106244)
+
+ -- Dan Munckton <[EMAIL PROTECTED]> Fri, 27 Jul 2007 23:58:20 +0100
+
mysql-dfsg-5.0 (5.0.45-1) unstable; urgency=low
* New upstream release.
diff -u mysql-dfsg-5.0-5.0.45/debian/mysql-server-5.0.mysql.init
mysql-dfsg-5.0-5.0.45/debian/mysql-server-5.0.mysql.init
--- mysql-dfsg-5.0-5.0.45/debian/mysql-server-5.0.mysql.init
+++ mysql-dfsg-5.0-5.0.45/debian/mysql-server-5.0.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 buggy options
diff -u mysql-dfsg-5.0-5.0.45/debian/control
mysql-dfsg-5.0-5.0.45/debian/control
--- mysql-dfsg-5.0-5.0.45/debian/control
+++ mysql-dfsg-5.0-5.0.45/debian/control
@@ -1,7 +1,8 @@
Source: mysql-dfsg-5.0
Section: misc
Priority: optional
-Maintainer: Debian MySQL Maintainers <[EMAIL PROTECTED]>
+Maintainer: Ubuntu Core Developers <[EMAIL PROTECTED]>
+XSBC-Original-Maintainer: Debian MySQL Maintainers <[EMAIL PROTECTED]>
Uploaders: Christian Hammers <[EMAIL PROTECTED]>, Sean Finney <[EMAIL
PROTECTED]>, Adam Conrad <[EMAIL PROTECTED]>
Build-Depends: libtool (>= 1.4.2-7), procps | hurd, debhelper (>= 4.1.16),
file (>= 3.28-1), libncurses5-dev (>= 5.0-6), perl (>= 5.6.0), libwrap0-dev (>=
7.6-8.3), zlib1g-dev (>= 1:1.1.3-5), libreadline5-dev | libreadline-dev,
psmisc, po-debconf, chrpath, automake1.9, doxygen, texlive-latex-base, gs,
dpatch, gawk, bison, linux-libc-dev [!hurd-i386 !kfreebsd-i386 !kfreebsd-amd64]
Standards-Version: 3.7.2
