[syslog-ng]Syslog-Mysql-error ( ATTN: Asif Iqbal)
Venkata Phani Kiran Achanta
syslog-ng@lists.balabit.hu
Thu, 1 Jul 2004 15:37:26 -0700
This is a multi-part message in MIME format.
------_=_NextPart_001_01C45FBB.F60B7C8C
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Greetings all,
=20
Everything was going well until I got this error while loading the Mysql
tables....
=20
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.
=20
And my line 1 in mysql.pipe looks like this=20
=20
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=3DDNS_NS25 [No Name]system-notification-00257(traffic):
start_time=3D\"2004-07-01 15:30:26\" duration=3D2 policy_id=3D0 =
service=3Ddns
proto=3D17 src zone=3DTrust dst zone=3DUntrust action=3DPermit sent=3D99 =
rcvd=3D274
src=3D192.168.254.2 dst=3D63.209.70.231 src_port=3D1116 dst_port=3D53 =
src-xlated
ip=3D12.28.143.203 port=3D1116
=20
Any ideas....let me know if you need more info to get me out of this
error. Thanks in advance.
=20
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.=20
=20
Hey Asif,=20
=20
If you are still subscribing to this list and see this message please
respond ASAP explaining how you worked around this problem.
=20
=20
Thanks much,
=20
Venkata Achanta
=20
--Open source Rocks.........
=20
=20
------_=_NextPart_001_01C45FBB.F60B7C8C
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
pre
{margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Greetings all,<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Everything was going well until I got this error =
while
loading the Mysql tables….<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>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.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>And my line 1 in mysql.pipe looks like this =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>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=3DDNS_NS25 [No Name]system-notification-00257(traffic):
start_time=3D\"2004-07-01 15:30:26\" duration=3D2 =
policy_id=3D0 service=3Ddns
proto=3D17 src zone=3DTrust dst zone=3DUntrust action=3DPermit sent=3D99 =
rcvd=3D274
src=3D192.168.254.2 dst=3D63.209.70.231 src_port=3D1116 dst_port=3D53 =
src-xlated
ip=3D12.28.143.203 port=3D1116<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Any ideas….let me know if you need more info to =
get me
out of this error. Thanks in advance.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>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.
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Hey Asif, <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> If you are still subscribing to this list and =
see
this message please respond ASAP explaining how you worked around this =
problem.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Thanks much,<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Venkata Achanta<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>--Open source =
Rocks………<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
</div>
</body>
</html>
------_=_NextPart_001_01C45FBB.F60B7C8C--