List:General Discussion« Previous MessageNext Message »
From:<Guy_Lichtman Date:March 28 2013 9:06am
Subject:RE: All client commands to syslog?
View as plain text  
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.rafal@stripped] 
Sent: Thursday, March 28, 2013 9:52 AM
To: mysql@stripped
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

Thread
All client commands to syslog?Rafał Radecki28 Mar
  • RE: All client commands to syslog?Guy_Lichtman28 Mar
  • Re: All client commands to syslog?yoku ts.28 Mar
  • Re: All client commands to syslog?spameden2 Apr