List:General Discussion« Previous MessageNext Message »
From:spameden Date:April 2 2013 10:20pm
Subject:Re: All client commands to syslog?
View as plain text  
2013/3/28 Rafał Radecki <radecki.rafal@stripped>

> 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.
>

Take a look at general  query log it's exactly what you need.

http://dev.mysql.com/doc/refman/5.5/en/query-log.html


>
> 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