Your message dated Sun, 28 Dec 2008 14:48:08 +0100
with message-id <[email protected]>
and subject line Not a bug
has caused the Debian Bug report #421269,
regarding mysql-server-5.0: Need separate logs for different databases / users
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.)
--
421269: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=421269
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
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...@euro, lc_ctype=fr...@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
--- End Message ---
--- Begin Message ---
Not a bug
--- End Message ---
