First of all the mysql howto was not written by me, second template() destinations are only supported by the 1.5.x releases. please ask these kind of questions on the mailing list. Thanks. On Fri, Jun 21, 2002 at 02:38:05PM +0800, shan tenorio wrote:
i follwed the step-step procedures on the mysql-log but i do get a parse error when starting syslog-ng.
this is the line where i get the parsing error...
## Log syslog-ng to mysql database ## destination d_mysql { pipe("/tmp/mysql.pipe" this line ----> template("INSERT 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(net); destination(d_mysql); };
-- Bazsi PGP info: KeyID 9AF8D0A9 Fingerprint CD27 CFB0 802C 0944 9CFD 804E C82C 8EB1