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