Hello, Everyone, I just installed syslog-ng on my mandrake-9.2 with the rpm package: syslog-ng-1.4.17-3mdk.src.rpm For generly log, it works fine. However, I would like to forward my logs to MySql database. So I tried to follow the tutorials of Michael Earls ( ohttp://vermeer.org/display_doc.php?doc_id=1). However, after I added the following line to my syslog-ng.conf, each time when I tried to restart syslog-ng, it tells sth is wrong. The following is what I have done: 1. Add the following to my syslog-ng.conf so that I can log to mysql database: ## Log syslog-ng to mysql database ## 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); }; 2. stop syslog-ng [root@localhost tmp]# service syslog-ng stop Shutting down kernel logger: [ OK ] Shutting down system logger: [ OK ] 3. restart syslog-ng [root@localhost tmp]# service syslog-ng start Starting system logger: parse error at 27 Parse error reading configuration file, exiting. [FAILED] starting kernel logger: [ OK ] NOTE: line 27 is where "template ("INSERT INTO logs (host, facility, priority, level, tag, " showing the first step. I wonder to know what's wrong with this configuration? I tried to read the source code. I cannot find any thing related to "template". Does syslog-ng 1.4.17 support "template"? How could I fix the problem? THanks a lot Yours Ch Zhang _______________________________________________ Join Excite! - http://www.excite.com The most personalized portal on the Web!