Greetings all,

Everything was going well until I got this error while loading the Mysql tables….

DBD::mysql::db do failed: 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 '192.168.254.250', 'auth', 'notice', 'notice', '25', '2004-07-01 at ./db-loader.pl line 19, <FH> line 1.

And my line 1 in mysql.pipe looks like this

INSERT INTO logs (host, facility, priority, level, tag, date, time, program, msg) VALUES ( '192.168.254.250', 'auth', 'notice', 'notice', '25', '2004-07-01', '15:26:28', 'DNS_NS25','DNS_NS25: NetScreen device_id=DNS_NS25  [No Name]system-notification-00257(traffic): start_time=\"2004-07-01 15:30:26\" duration=2 policy_id=0 service=dns proto=17 src zone=Trust dst zone=Untrust action=Permit sent=99 rcvd=274 src=192.168.254.2 dst=63.209.70.231 src_port=1116 dst_port=53 src-xlated ip=12.28.143.203 port=1116

Any ideas….let me know if you need more info to get me out of this error. Thanks in advance.

I have searched thru the archives and found Mr.Asif Iqbal had a similar problem but unfortunately he did not find an answer in this list.

Hey Asif,

  If you are still subscribing to this list and see this message please respond ASAP explaining how you worked around this problem.

Thanks much,

Venkata Achanta

--Open source Rocks………