>>> sander@sanderscorner.com 05/04/02 04:39AM >>>
(Response to message from Toby Nelson, nelsotob@ohsu.edu)

Hello Toby,

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

--

Regards,
Sander

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));
> };


_______________________________________________
syslog-ng maillist  -  syslog-ng@lists.balabit.hu
https://lists.balabit.hu/mailman/listinfo/syslog-ng