Your message dated Thu, 04 Apr 2013 09:43:57 -0700
with message-id <[email protected]>
and subject line This is not a bug or has been addressed upstream
has caused the Debian Bug report #585014,
regarding mysql-server: wait_timeout not being observed after security update
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 [email protected]
immediately.)
--
585014: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=585014
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: mysql-server
Version: 5.0.51a-24+lenny4
Severity: normal
In mysql.conf I have:
[mysqld]
wait_timeout = 3600
However, mysql does not appear to be respecting this since lenny4, and also not
when using the set global syntax:
mysql> show variables like 'wait_timeout';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| wait_timeout | 28800 |
+---------------+-------+
1 row in set (0.00 sec)
mysql> set global wait_timeout = 30;
Query OK, 0 rows affected (0.00 sec)
mysql> show variables like 'wait_timeout';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| wait_timeout | 28800 |
+---------------+-------+
1 row in set (0.00 sec)
-- System Information:
Debian Release: 5.0.4
APT prefers stable
APT policy: (500, 'stable')
Architecture: i386 (i686)
Kernel: Linux 2.6.26-2-686 (SMP w/4 CPU cores)
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
Shell: /bin/sh linked to /bin/bash
Versions of packages mysql-server depends on:
ii mysql-server-5.0 5.0.51a-24+lenny4 MySQL database server binaries
mysql-server recommends no packages.
mysql-server suggests no packages.
-- debconf information:
mysql-server/nis_warning:
* mysql-server/really_downgrade_from_41: true
mysql-server/mysql_update_hints1:
mysql-server/start_on_boot: true
mysql-server/postrm_remove_databases: false
* mysql-server/mysql_install_db_notes:
--- End Message ---
--- Begin Message ---
I suspect the reporter was confused by the fact that there are actually
two wait timeout settings for MySQL. interactive_timeout is copied into
the session's wait_timeout variable when the mysql command line client
is used interactively.
This functions properly, as does normal wait_timeout, on 5.5.30+dfsg-1
and on the Ubuntu 12.10 packages for 5.5.29 as well.
--- End Message ---