Trouble with Haloe syslog

[kazuyuba]

Hi,

I am building cacti haloe with syslog-ng currently. I am facing some trouble that cacti-syslog can not retrieve some data from logs of some devices.

I refer to http://www.openmaniak.com/cacti_plugins.php for creating cacti-syslog on my server.

syslog-ng.conf on my server is here.

####################
# sources
####################
source net {
udp( ip(0.0.0.0) port(514) ); internal();
####################
# destination
####################
##For Cacti-Syslog
destination d_mysql {
pipe("/var/log/mysql.pipe"
template("INSERT INTO syslog_incoming
(facility, priority, date, time, host, message, seq, status)
VALUES ( '$FACILITY', '$PRIORITY', '$YEAR-$MONTH-$DAY', '$HOUR:$MIN:$SEC', '$HOST', '$MSG', '$SEQ',
'$STATUS' );\n") template-escape(yes));

};
####################
# log
####################
log { source(net); destination(d_mysql); };

Also create /var/log/mysql.pipe and database of mysql.

I am eager to have someone who provides some advice of this problem.

Thanks in advance.

[N3NCY]

Did you create a FIFO file?

Here is how I got this hard to configure plugin going:
http://www.nmsworld.com/UNIX/Syslog-NG.htm

[kazuyuba]

Did you create a FIFO file?

Here is how I got this hard to configure plugin going:
http://www.nmsworld.com/UNIX/Syslog-NG.htm

Hi,

Many thanks for your comment.
I created /var/log/mysql.pipe and associated into mysql database with some user and it's password.

As you advised me about nmsworld.com
I followed the instruction on that web site.
But I could not find any counting up mysql of syslog_incoming.

Looks like the problem that it can not communicate between syslog-ng and mysql...

I am using fedora 5 as OS , cacti0.8.6i and syslog-ng 1.6.12.

Appreciate if you would provide me other comment.

Thanks in advance, again.

[nahun]

Are there any errors from the script that pipes syslog-ng to mysql?