[syslog-ng]Config file error?

[carl andreasson]

Hello, im quite a newbie to syslog-ng but what i basicly want to do
is to log syslog messages from routers in to a mysql database, and
i have some problems with the configuration file so please help me.

The config file:
***********************************************

options { long_hostnames(on); sync(0); };

source src_udp {udp(131.97.91.56) port(514); internal; };

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") 
templa
te-escape(yes));};

log {   source(src_udp);
        destination(d_mysql); };

***********************************************

and i get this when i try to run it,
***********************************************
[root@guardian-angel syslog-ng]# syslog-ng start
parse error at 3
Parse error reading configuration file, exiting. (line 3)
[root@guardian-angel syslog-ng]#

_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*. 
http://join.msn.com/?page=features/featuredemail