Web lists-archives.com

Mysql Syslog client.




Hello guys.

Im using MySQL 5.7.6 for testing some new features, including syslog
support for client.
Its working great and Im getting the following lines when using localhost:

Mar 12 12:36:34 server1 MysqlClient[17854]: SYSTEM_USER:'user1',
MYSQL_USER:'userdb', CONNECTION_ID:5, DB_SERVER:'--', DB:'mysql',
QUERY:'use mysql'
Mar 12 12:36:36 server1 MysqlClient[17854]: SYSTEM_USER:'user1',
MYSQL_USER:'userdb', CONNECTION_ID:5, DB_SERVER:'--', DB:'mysql',
QUERY:'show tables;'
Mar 12 12:36:55 server1 MysqlClient[17856]: SYSTEM_USER:'user1',
MYSQL_USER:'userdb', CONNECTION_ID:6, DB_SERVER:'--', DB:'mysql',
QUERY:'use mysql '

However, if I try to access MySQL in any other server, for example "mysql
-uuser -ppasswd -hserver2", it doesn't log in syslog.
My client section config is:

[client]
#password   = [your_password]
port        = 3306
socket      = /var/lib/mysql/mysql.sock
syslog

Have any of you tried this?

Thank you in advance.

Stephan