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