[syslog-ng]Syslog-ng and Mysql

4 May 2002

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

log {
        source("src");
        destination("d_mysql");
};

With that in place I continue to get a parse error. Can any one help? 

Thanks,

Toby

[syslog-ng]Syslog-ng and Mysql

Toby Nelson