Forward Mysql logs to Syslog-ng
- by Mbeale
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