[debian-mysql] Bug#421269: closed by Norbert Tretkowski <norbert at tretkowski.de> (Not a bug)

[tech at mediaforest.net]

Hello,

Of course it's not a bug :
 > Severity: wishlist

Debian Bug Tracking System a écrit :
> This is an automatic notification regarding your Bug report
> which was filed against the mysql-server-5.0 package:
> 
> #421269: mysql-server-5.0: Need separate logs for different databases / users
> 
> It has been closed by Norbert Tretkowski <norbert at tretkowski.de>.
> 
> Their explanation is attached below along with your original report.
> If this explanation is unsatisfactory and you have not received a
> better one in a separate message then please contact Norbert Tretkowski <norbert at tretkowski.de> by
> replying to this email.
> 
> 
> 
> 
> ------------------------------------------------------------------------
> 
> Sujet:
> Not a bug
> Expéditeur:
> Norbert Tretkowski <norbert at tretkowski.de>
> Date:
> Sun, 28 Dec 2008 14:48:08 +0100
> Destinataire:
> 421269-done at bugs.debian.org
> 
> Destinataire:
> 421269-done at bugs.debian.org
> 
> 
> Not a bug
> 
> 
> 
> 
> ------------------------------------------------------------------------
> 
> Sujet:
> mysql-server-5.0: Need separate logs for different databases / users
> Expéditeur:
> "tech at mediaforest.net" <tech at mediaforest.net>
> Date:
> Fri, 27 Apr 2007 15:59:32 +0200
> Destinataire:
> Debian Bug Tracking System <submit at bugs.debian.org>
> 
> Destinataire:
> Debian Bug Tracking System <submit at bugs.debian.org>
> 
> 
> 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
>