[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Bug#420010: marked as done (libapache2-mod-auth-mysql: Automatic reconnect on lost MySQL connections)

Your message dated Tue, 12 Feb 2008 15:17:02 +0000
with message-id <E1JOwsY-0006FK-MM@ries.debian.org>
and subject line Bug#420010: fixed in libapache-mod-auth-mysql 4.3.9-5
has caused the Debian Bug report #420010,
regarding libapache2-mod-auth-mysql: Automatic reconnect on lost MySQL connections
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 this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact owner@bugs.debian.org
immediately.)


-- 
420010: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=420010
Debian Bug Tracking System
Contact owner@bugs.debian.org with problems
--- Begin Message --- 
Package: libapache2-mod-auth-mysql
Version: 4.3.9-3
Severity: normal

Debian Etch uses MySQL 5.0.32. When upgrading from 4.1 (which was used by
Debian Sarge) several things have to be considered as mentioned at
  http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html

There is stated quite at the bottom (before the user comments):
--- snip ---
The reconnect flag in the MYSQL structure is set to 0 by
mysql_real_connect(). Only those client programs which did not explicitly
set this flag to 0 or 1 after mysql_real_connect() experience a change.
Having automatic reconnection enabled by default was considered too
dangerous (due to the fact that table locks, temporary tables, user
variables, and session variables are lost after reconnection).
--- snip ---

libapache2-mod-auth-mysql doesn't set the "reconnect" flag so it is
definitely affected by the change.

We've experienced many Apache authentication errors due to lost connections
to the MySQL server. The log file (with high Apache log level) says
  [debug] mod_auth_mysql.c(1223): Query maybe-failed: MySQL server has gone away (2006), lastchance=1

Please set the reconnect flag to 1 before mysql_real_connect() which will
hopefully resolve the problem.

-- System Information:
Debian Release: 4.0
  APT prefers stable
  APT policy: (700, 'stable')
Architecture: i386 (i686)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.16
Locale: LANG=en_US, LC_CTYPE=en_US (charmap=ISO-8859-1)

Versions of packages libapache2-mod-auth-mysql depends on:
ii  apache2.2-common           2.2.3-4       Next generation, scalable, extenda
ii  libc6                      2.3.6.ds1-13  GNU C Library: Shared libraries
ii  libmysqlclient15off        5.0.32-7etch1 mysql database client library

libapache2-mod-auth-mysql recommends no packages.

-- no debconf information

--- End Message ---
--- Begin Message --- 
Source: libapache-mod-auth-mysql
Source-Version: 4.3.9-5

We believe that the bug you reported is fixed in the latest version of
libapache-mod-auth-mysql, which is due to be installed in the Debian FTP archive:

libapache-mod-auth-mysql_4.3.9-5.diff.gz
  to pool/main/liba/libapache-mod-auth-mysql/libapache-mod-auth-mysql_4.3.9-5.diff.gz
libapache-mod-auth-mysql_4.3.9-5.dsc
  to pool/main/liba/libapache-mod-auth-mysql/libapache-mod-auth-mysql_4.3.9-5.dsc
libapache2-mod-auth-mysql_4.3.9-5_i386.deb
  to pool/main/liba/libapache-mod-auth-mysql/libapache2-mod-auth-mysql_4.3.9-5_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 420010@bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.

Debian distribution maintenance software
pp.
Matej Vela <vela@debian.org> (supplier of updated libapache-mod-auth-mysql 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 ftpmaster@debian.org)


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Format: 1.7
Date: Tue, 12 Feb 2008 15:55:39 +0100
Source: libapache-mod-auth-mysql
Binary: libapache2-mod-auth-mysql
Architecture: source i386
Version: 4.3.9-5
Distribution: unstable
Urgency: low
Maintainer: Debian QA Group <packages@qa.debian.org>
Changed-By: Matej Vela <vela@debian.org>
Description: 
 libapache2-mod-auth-mysql - Apache 2 module for MySQL authentication
Closes: 420010 437310
Changes: 
 libapache-mod-auth-mysql (4.3.9-5) unstable; urgency=low
 .
   * QA upload.
   * debian/patches/004-reconnect.dpatch: Automatically re-establish
     connections with MySQL 5.0.3+.  Thanks to Johann Glaser for the patch.
     Closes: #420010.
   * debian/rules: Let dh_strip handle DEB_BUILD_OPTIONS=nostrip.
     Closes: #437310.
   * debian/rules: Remove support for DEB_BUILD_OPTIONS=debug.
   * debian/rules: Don't ignore errors from `make distclean'.
   * Conforms to Standards version 3.7.3.
Files: 
 e35df6b38d669f9bdf8a6d726d96efb2 703 web optional libapache-mod-auth-mysql_4.3.9-5.dsc
 fc5e16316fda7f26bbbe19bea045e280 9106 web optional libapache-mod-auth-mysql_4.3.9-5.diff.gz
 0752c00b77ec463dbf73b953b6787a15 22442 web optional libapache2-mod-auth-mysql_4.3.9-5_i386.deb

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHsbPYqbYs6sQrY8oRArQNAJoC3UGbZiTf+auCqXX+RgJ8dEGqbACeOnJM
mLXYuCGpWG/b3PyxAgvqXD8=
=0z/p
-----END PGP SIGNATURE-----

--- End Message ---
Reply to: