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

[javier rojas]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.balabit.hu/pipermail/syslog-ng/attachments/20050728/8f2af1fa/attachment.html