MySQL查询记录到Syslog-ng服务器-MySQLQueryLoggingtoSyslog-ngserver

This answer don't solved the problem. The log appear in syslog-ng server for few time and stops without show any error in cliente or server.

这个答案没有解决问题。日志在syslog-ng服务器中显示几次,并且在客户端或服务器中没有显示任何错误时停止。

It can be a wrong timeout parameter in syslog-ng of client or server, but I could not find anything :(

它可能是客户端或服务器的syslog-ng中的错误超时参数,但我找不到任何东西:(

I have this configuration on a syslog-ng client :

我在syslog-ng客户端上有这个配置:

source s_mysql_instance_1 {
        pipe("mysqld-1.error.log" log_prefix("mysqlsrv-instance_1"));
        unix-stream ("/dev/log");
        internal();
};

source s_mysql_instance_2 {
        pipe("mysqld-2.error.log" log_prefix("mysqlsrv-instance_2"));
        unix-stream ("/dev/log");
        internal();
};