[syslog-ng]php-syslog-ng

Eduardo Oliveira Scricco (Service) syslog-ng@lists.balabit.hu
Tue, 30 Nov 2004 14:54:12 -0200


Hi all,

Using syslog-ng 1.4.14 at Suse Linux 8.1

I'm trying to run php-syslog-ng (a syslog webviewer), but it does not
work. For it works, is needed to log to a database, as MySQL.
PHP-Syslog-ng website have on step-by-step script, that I used.

When I try to run syslog-ng, it complains about this line (in
syslog-ng.conf is at one line):

destination d_mysql {

pipe("/tmp/mysql.pipe"

template("INSERT INTO logs (host, facility, priority, level, tag, date,=20

time, program, msg) VALUES ( '$HOST', '$FACILITY', '$PRIORITY',
'$LEVEL',=20
'$TAG',=20

'$YEAR-$MONTH-$DAY', '$HOUR:$MIN:$SEC', '$PROGRAM', '$MSG' );\n")
template-escape(yes));

};

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

};

I believe this "template" isn't supported in this syslog version. Is
that true?
The problem is I couldn't upgrade it to version 1.5 or higher, because
of libs dependencies...

Have one of you logged to mySQL using syslog-ng 1.4.14?

Thanks a lot,
Eddie