[syslog-ng] syslog-ng not logging in mysql

hello, i created the pipe file on /tmp (/tmp/mysql.pipe) but it doesn't write the logs into the mysql db, here's the extract from the syslog-ng.conf file: 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(20)); }; log { source(net); destination(d_mysql); }; it just doesn't work and i've followed the steps from the documentation on www.vermeer.org... so if anybody can help me... -- Ciao,Javier linux user #393724