Hi, You can check out the McAfee MySQL Audit Plugin at: https://github.com/mcafee/mysql-audit
It is an open source plugin providing audit capabilities for MySQL. It can be used to log executing commands. It can log to a file or over a unix domain socket to syslog-ng. Best, Guy -----Original Message----- From: Rafał Radecki [mailto:radecki.ra...@gmail.com] Sent: Thursday, March 28, 2013 9:52 AM To: mysql@lists.mysql.com Subject: All client commands to syslog? Hi All. I have a production setup of four databases connected with replication. I would like to log every command that clients execute for auditing. I've read http://www.percona.com/doc/percona-server/5.5/diagnostics/mysql_syslog.html?id=percona-server:features:mysql_syslog&redirect=1#client-variables but despite the fact that I use percona Percona-Server-server-55-5.5.28-rel29.3.388.rhel6.x86_64 it does not seem to work. I've added "syslog"/"syslog ON" to my my.cnf server configuration file but no info about executed commands in logs. I've also read http://www.mysqlperformanceblog.com/2008/07/08/logging-your-mysql-command-line-client-sessions/. What is the best way to log all client commands? Best regards, Rafal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
