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