I am trying to configure syslog-ng to write to mysql. I have already installed mysql and created the database and tables.

When I am enabling the syslog-ng to mysql using the following script in syslog-ng.conf , I get a parse error when staring syslog-ng

destination d_mysql {

pipe("/tmp/mysql.pipe"

template ("INSERT INTO logs (host, facility, priority, level, tag, date, time, program, msg) VALUES ( '$HOST','$FACILITY','$PRIORITY','$LEVEL','$TAG','$YEAR-$MONTH-$DAY', '$HOUR:$MIN:$SEC', '$PROGRAM', '$MSG' );\n")template-escape(yes));

};

log { source(net); destination(d_mysql);

};

Best regards

Deepu