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 <norb...@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
<norb...@tretkowski.de> by
replying to this email.
------------------------------------------------------------------------
Sujet:
Not a bug
Expéditeur:
Norbert Tretkowski <norb...@tretkowski.de>
Date:
Sun, 28 Dec 2008 14:48:08 +0100
Destinataire:
421269-d...@bugs.debian.org
Destinataire:
421269-d...@bugs.debian.org
Not a bug
------------------------------------------------------------------------
Sujet:
mysql-server-5.0: Need separate logs for different databases / users
Expéditeur:
"t...@mediaforest.net" <t...@mediaforest.net>
Date:
Fri, 27 Apr 2007 15:59:32 +0200
Destinataire:
Debian Bug Tracking System <sub...@bugs.debian.org>
Destinataire:
Debian Bug Tracking System <sub...@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...@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
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
