Forward Mysql logs to Syslog-ng

Posted by Mbeale on Ask Ubuntu See other posts from Ask Ubuntu or by Mbeale
Published on 2012-06-10T16:33:04Z Indexed on 2012/06/10 16:47 UTC
Read the original article Hit count: 445

Filed under:
|

Ubuntu 10.04

I have set MySQL to log slow queries and a general mysql log. How can I pipe those files in syslog to forward to centralized logging service (which is working)? Tried:

source s_mysql_instance_1 {
    pipe("/var/log/mysql/mysql.log" );
};
log { 
     source(s_mysql_instance_1); destination(d_loggly); 
}; 

Get:

Error opening file for reading; filename='/var/log/mysql/mysql.log', error='Permission denied (13)'
Error initializing source driver; source='s_mysql_instance_1', id='s_mysql_instance_1#0'
Error initializing message pipeline;

I have also disabled apparmor and still get the same results

© Ask Ubuntu or respective owner

Related posts about mysql

Related posts about syslog