[debian-mysql] Bug#421269: mysql-server-5.0: Need separate logs for different databases / users

[tech at mediaforest.net]

Package: mysql-server-5.0
Version: 5.0.38-1
Severity: wishlist

Hello
I run a server with several virtual domains, several databases and several users.

For debugging and security purpose, I'd like to be able to log separately the queries sent to each database or sent by each user. 
I know that binlog permits to get separates datas for differents databases, but it's not possible to "tail" its output and furthermore it only logs the changes
to databases, not the SELECT queries. 
It's why for now I still use mysql.log but the use of :
tail -f /var/log/mysql/mysql.log
is a bit confused if there are many queries sent at the same time, and it's not possible to filter the output with grep 
as the database name is only written on the first line.

I've looked for a workaround on many forums, asked this question many times, but I never got any answer.


-- System Information:
Debian Release: lenny/sid
  APT prefers testing
  APT policy: (500, 'testing'), (500, 'stable')
Architecture: i386 (i686)

Kernel: Linux 2.6.18-4-686 (SMP w/1 CPU core)
Locale: LANG=fr_FR at euro, LC_CTYPE=fr_FR at euro (charmap=ISO-8859-15)
Shell: /bin/sh linked to /bin/bash

Versions of packages mysql-server-5.0 depends on:
ii  adduser                     3.102        Add and remove users and groups
ii  debconf [debconf-2.0]       1.5.13       Debian configuration management sy
ii  libc6                       2.3.6.ds1-13 GNU C Library: Shared libraries
ii  libdbi-perl                 1.53-1       Perl5 database interface by Tim Bu
ii  libgcc1                     1:4.1.1-21   GCC support library
ii  libmysqlclient15off         5.0.38-1     mysql database client library
ii  libncurses5                 5.5-5        Shared libraries for terminal hand
ii  libreadline5                5.2-2        GNU readline and history libraries
ii  libstdc++6                  4.1.1-21     The GNU Standard C++ Library v3
ii  libwrap0                    7.6.dbs-13   Wietse Venema's TCP wrappers libra
ii  lsb-base                    3.1-23.1     Linux Standard Base 3.1 init scrip
ii  mysql-client-5.0            5.0.38-1     mysql database client binaries
ii  mysql-common                5.0.38-1     mysql database common files (e.g. 
ii  passwd                      1:4.0.18.1-7 change and administer password and
ii  perl                        5.8.8-7      Larry Wall's Practical Extraction 
ii  psmisc                      22.3-1       Utilities that use the proc filesy
ii  zlib1g                      1:1.2.3-13   compression library - runtime

Versions of packages mysql-server-5.0 recommends:
ii  mailx            1:8.1.2-0.20050715cvs-1 A simple mail user agent

-- debconf information:
* mysql-server/root_password: (password omitted)
  mysql-server-5.0/really_downgrade: false
  mysql-server-5.0/start_on_boot: true
  mysql-server-5.0/nis_warning:
  mysql-server-5.0/postrm_remove_databases: false
  mysql-server-5.0/no_upgrade_with_isam_tables:
* mysql-server-5.0/mysql_install_db_notes:
  mysql-server-5.0/need_sarge_compat: false
  mysql-server/error_setting_password:
  mysql-server-5.0/mysql_update_hints1:
  mysql-server-5.0/need_sarge_compat_done: true