[syslog-ng]syslog-ng mysql syntax error

Asif Iqbal syslog-ng@lists.balabit.hu
Wed, 31 Dec 2003 17:50:56 -0500


Hi All

Since yesterday I am getting this syntax errors while pushing the log to
the mysql database

I followed the instruction exactly how it was said in
http://vermeer.org/syslog/ and it was working fine until today it
started complaining

ERROR 1064 at line 841: You have an error in your SQL syntax.  Check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'level, tag, date,
time, program, msg) VALUES ( '63.152.4.63', '
ERROR 1064 at line 1: You have an error in your SQL syntax.  Check the
manual that corresponds to your MySQL server version for the right
syntax to use near '/22/3 session 4612f4 Session End' );
INSERT INTO logs (host, fa
ERROR 1064 at line 424: You have an error in your SQL syntax.  Check the
manual that corresponds to your MySQL server version for the right
syntax to use near '63.152.0.100', 'local4', 'err', 'err', 'a3',
'2003-12-31', '17:


Any suggestion/hint would be greatly appreciated
-- 
Asif Iqbal
http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08
There's no place like 127.0.0.1