[syslog-ng]Problems....

[carloscar]

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]#




 Mvh // Carloscar Andreasson
***********************************
Volvo Information Technology
Dept 8320 : Wide Area Network Solutions
Tel nat : 031-3220665
Tel int : +46 31-3220665
Location : Da 2s 40805 göteborg Sweden