Haloe plugin and Syslog-ng pipe not werking in Suse 10.2

General discussion about Plugins for Cacti

Moderators: Developers, Moderators

Post Reply
Wedgie
Posts: 5
Joined: Mon Apr 30, 2007 2:03 pm

Haloe plugin and Syslog-ng pipe not werking in Suse 10.2

Post by Wedgie »

I have setup syslog-ng to pipe to the syslog database in MySQL following the example:
http://openmaniak.com/cacti_plugins.php#ancre-syslog

however; I am getting errors and no info is being piped to the database...
the logs contain this mysterious entry:

"Cannot open file /var/log/mysql.pipe for writing (Operation not permitted)"

Was hoping someone has figured this out? WTF?

system is suse 10.2

syslog-ng.conf:

source src { unix-dgram("/dev/log"); udp(ip("0.0.0.0") port(514)); tcp(); internal(); };

destination named_pipe { program("/usr/bin/mysql --user=cactiuser --password=not4them syslog < /var/log/mysql.pipe");
pipe("/var/log/mysql.pipe" template("INSERT INTO logs (host, facility, priority, level, tag, datetime, program, msg) VALUES ( '$HOST', '$FACILITY', '$PRIORITY', '$LEVEL', '$TAG', '$YEAR-$MONTH-$DAY $HOUR:$MIN:$SEC','$PROGRAM', '$MSG' );\n") template-escape(yes)); };

log { source(src); destination(named_pipe); };
Wedgie
Posts: 5
Joined: Mon Apr 30, 2007 2:03 pm

Solved: destination named_pipe for syslog-ng to MySQL

Post by Wedgie »

AppArmour was the culprit.

Disable and problem was resolved!
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest