[syslog-ng]Syslog-ng and Mysql

Sander sander@sanderscorner.com
Sat, 4 May 2002 13:39:39 +0200

(Response to message from Toby Nelson, nelsotob@ohsu.edu)

Hello Toby,

Should'nt it be 'template("INSERT INTO...'?



Saturday, May 04, 2002, 1:14:08 AM, you wrote:

> Can someone help me? 
> I have syslog-ng running perfectly getting all info from all of my hosts. I would like to take this one step farther and start adding it to a mysql data base. I have made the mysql.pipe using
> mkfifo and add the following lines to my syslog-ng.conf:

> destination d_mysql {
>                  pipe("/etc/mysql.pipe" template("INSET INTO logs(host, facility, priority, level, tag, date, time, program, msg) VALUES('$HOST', '$FACILILITY', '$PRIORITY', '$LEVEL', '$TAG',
> '$YEAR-$MONTH-$DAY', $HOUR:$MIN:$SEC', '$PROGRAM', $MSG');\n") template-escape(yes));
> };