Your message dated Mon, 11 Jul 2005 06:47:48 -0400 with message-id <[EMAIL PROTECTED]> and subject line Bug#312243: fixed in roxen4 4.0.325-4 has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what I am talking about this indicates a serious mail system misconfiguration somewhere. Please contact me immediately.) Debian bug tracking system administrator (administrator, Debian Bugs database) -------------------------------------- Received: (at submit) by bugs.debian.org; 6 Jun 2005 16:10:19 +0000 >From [EMAIL PROTECTED] Mon Jun 06 09:10:19 2005 Return-path: <[EMAIL PROTECTED]> Received: from www.feichtinger.priv.at (haldir.wsr.ac.at) [143.130.16.71] by spohr.debian.org with esmtp (Exim 3.35 1 (Debian)) id 1DfKB9-0003Ol-00; Mon, 06 Jun 2005 09:10:19 -0700 Received: by haldir.wsr.ac.at (Postfix, from userid 1000) id 41B0017009; Mon, 6 Jun 2005 18:10:17 +0200 (CEST) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: "Peter J. Holzer" <[EMAIL PROTECTED]> To: Debian Bug Tracking System <[EMAIL PROTECTED]> Subject: roxen4: Roxen4 shutdown kills independent mysql instance X-Mailer: reportbug 3.8 Date: Mon, 06 Jun 2005 18:10:17 +0200 Message-Id: <[EMAIL PROTECTED]> Delivered-To: [EMAIL PROTECTED] X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02 (1.212-2003-09-23-exp) on spohr.debian.org X-Spam-Status: No, hits=-8.0 required=4.0 tests=BAYES_00,HAS_PACKAGE autolearn=no version=2.60-bugs.debian.org_2005_01_02 X-Spam-Level: Package: roxen4 Version: 4.0.325-1 Severity: critical Tags: patch Justification: breaks unrelated software The roxen startup script /usr/share/roxen4/start incorrectly uses the file /var/run/mysqld/mysqld.pid instead of /var/run/roxen4/mysqld.pid to determine the pid of its mysql instance. Thus when roxen is stopped, the normal mysql server is stopped, too! The problem is exacerbated by the cron job /etc/cron.weekly/roxen4, which restarts roxen, thus shutting down mysql once per week. This patch fixes the problem: --- start.2005-06-06T17:47:48 2005-03-21 12:35:30.000000000 +0100 +++ start 2005-06-06 17:48:08.000000000 +0200 @@ -678,13 +678,13 @@ # FIXME: Consider exiting here. fi if [ "x$keep_mysql" = "x" ] ; then - if [ -f /var/run/mysqld/mysqld.pid ] ; then - mysql_pid="`cat /var/run/mysqld/mysqld.pid 2>/dev/null`" + if [ -f /var/run/roxen4/mysqld.pid ] ; then + mysql_pid="`cat /var/run/roxen4/mysqld.pid 2>/dev/null`" dp_no_nl "Shutting down MySQL." kill "$mysql_pid" 2>/dev/null # Give mysql 5 minutes to shut down. timer="" - while [ -f "/var/run/mysqld/mysqld.pid" -a \ + while [ -f "/var/run/roxen4/mysqld.pid" -a \ "$timer" != "mmmmm" ] && \ kill -0 "$mysql_pid" 2>/dev/null; do sleep 2 @@ -702,9 +702,9 @@ dp "Shutting down MySQL the hard way." kill -9 "$mysql_pid" 2>/dev/null fi - if [ -f "/var/run/mysqld/mysqld.pid" ] && \ - [ "$mysql_pid" = "`cat /var/run/mysqld/mysqld.pid`" ]; then - rm -f "/var/run/mysqld/mysqld.pid" 2>/dev/null + if [ -f "/var/run/roxen4/mysqld.pid" ] && \ + [ "$mysql_pid" = "`cat /var/run/roxen4/mysqld.pid`" ]; then + rm -f "/var/run/roxen4/mysqld.pid" 2>/dev/null fi fi fi -- System Information: Debian Release: 3.1 APT prefers testing APT policy: (500, 'testing') Architecture: i386 (i686) Kernel: Linux 2.4.27-2-386 Locale: LANG=en_US, LC_CTYPE=en_US (charmap=ISO-8859-1) Versions of packages roxen4 depends on: ii debconf 1.4.30.13 Debian configuration management sy ii hostname 2.13 A utility to set/show the host nam ii mysql-server 4.0.24-5 mysql database server binaries ii pike7.4-image 7.4.117-1 Image module for Pike ii pike7.4-mysql 7.4.117-1 Mysql module for Pike ii procps 1:3.2.1-2 The /proc file system utilities -- debconf information excluded --------------------------------------- Received: (at 312243-close) by bugs.debian.org; 11 Jul 2005 10:53:17 +0000 >From [EMAIL PROTECTED] Mon Jul 11 03:53:17 2005 Return-path: <[EMAIL PROTECTED]> Received: from newraff.debian.org [208.185.25.31] (mail) by spohr.debian.org with esmtp (Exim 3.35 1 (Debian)) id 1DrvuX-0002TE-00; Mon, 11 Jul 2005 03:53:17 -0700 Received: from katie by newraff.debian.org with local (Exim 3.35 1 (Debian)) id 1DrvpE-0005hS-00; Mon, 11 Jul 2005 06:47:48 -0400 From: Turbo Fredriksson <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] X-Katie: $Revision: 1.56 $ Subject: Bug#312243: fixed in roxen4 4.0.325-4 Message-Id: <[EMAIL PROTECTED]> Sender: Archive Administrator <[EMAIL PROTECTED]> Date: Mon, 11 Jul 2005 06:47:48 -0400 Delivered-To: [EMAIL PROTECTED] X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02 (1.212-2003-09-23-exp) on spohr.debian.org X-Spam-Status: No, hits=-6.0 required=4.0 tests=BAYES_00,HAS_BUG_NUMBER autolearn=no version=2.60-bugs.debian.org_2005_01_02 X-Spam-Level: Source: roxen4 Source-Version: 4.0.325-4 We believe that the bug you reported is fixed in the latest version of roxen4, which is due to be installed in the Debian FTP archive: roxen4-doc_4.0.325-4_all.deb to pool/main/r/roxen4/roxen4-doc_4.0.325-4_all.deb roxen4_4.0.325-4.diff.gz to pool/main/r/roxen4/roxen4_4.0.325-4.diff.gz roxen4_4.0.325-4.dsc to pool/main/r/roxen4/roxen4_4.0.325-4.dsc roxen4_4.0.325-4_i386.deb to pool/main/r/roxen4/roxen4_4.0.325-4_i386.deb A summary of the changes between this version and the previous one is attached. Thank you for reporting the bug, which will now be closed. If you have further comments please address them to [EMAIL PROTECTED], and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Turbo Fredriksson <[EMAIL PROTECTED]> (supplier of updated roxen4 package) (This message was generated automatically at their request; if you believe that there is a problem with it please contact the archive administrators by mailing [EMAIL PROTECTED]) -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Format: 1.7 Date: Mon, 11 Jul 2005 12:06:35 +0200 Source: roxen4 Binary: roxen4-doc roxen4 Architecture: source i386 all Version: 4.0.325-4 Distribution: unstable Urgency: low Maintainer: Turbo Fredriksson <[EMAIL PROTECTED]> Changed-By: Turbo Fredriksson <[EMAIL PROTECTED]> Description: roxen4 - The Roxen Challenger Webserver roxen4-doc - Roxen 4.0 documentation Closes: 312243 Changes: roxen4 (4.0.325-4) unstable; urgency=low . * Fix roxen4-doc postinst: Include '--password=...' in commandline to 'mysqladmin ... ping' if we have a username. * Fix broken shutdown of MySQL server. Patch by Peter J. Holzer. Closes: #312243 Files: 06a520de994240364151994d4daac509 581 web optional roxen4_4.0.325-4.dsc fb1c307c311b5350a2c74522b6fc717c 48727 web optional roxen4_4.0.325-4.diff.gz fee34809f883b9e9c2cb924db3ae53c2 3600428 doc optional roxen4-doc_4.0.325-4_all.deb 1ef8193aa27a6e86e00a307c406bccd8 7700644 web optional roxen4_4.0.325-4_i386.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (GNU/Linux) iD8DBQFC0kuNmlWzPKccHgARAoBqAJ41xwqf7tdJDaxg/zSFxHEwxUze/gCdG9Ad U2wCCYPbhjGY2abymxCJL/U= =gPqX -----END PGP SIGNATURE----- -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]