Yes that is actually what I have in my script is INSERT just a typo in the messages. Toby

...

...

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