<html>
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";
color:#0050D0;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
pre
{margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:#0050D0;}
span.EmailStyle18
{font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body bgcolor=white lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Thanks Patrick. Is there any Pointer you
can provide as to why it would think it needs to create the table. I have used
the credentials supplied to syslog-ng and used mysql client to execute the
login and it works fine. The only thing is that the mysql user(syslog) only has
INSERT right to the table to which it is supposed to write logs. It does not
even have SELECT right to the table.</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Regards,</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Girish</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
color=black face="Times New Roman"><span style='font-size:12.0pt;color:windowtext'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 color=black face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma;color:windowtext;font-weight:bold'>From:</span></font></b><font
size=2 color=black face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;
color:windowtext'> syslog-ng-bounces@lists.balabit.hu
[mailto:syslog-ng-bounces@lists.balabit.hu] <b><span style='font-weight:bold'>On
Behalf Of </span></b>Patrick H.<br>
<b><span style='font-weight:bold'>Sent:</span></b> Friday, December 03, 2010
2:03 PM<br>
<b><span style='font-weight:bold'>To:</span></b> Syslog-ng users' and
developers' mailing list<br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [syslog-ng] Syslog-ng
and Mysql Not working</span></font></p>
</div>
<p class=MsoNormal><font size=3 color="#0050d0" face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal><font size=2 color="#0050d0" face=Helvetica><span
style='font-size:10.0pt;font-family:Helvetica'>It will only try to create the
table if the table does not already exist.<br>
The dont-create-tables flag requires you to use syslog-ng >= 3.2<br>
<br>
Even if you upgrade to 3.2 and turn this option on, it will still be broken as
it wont have anything to insert into. You should investigate why syslog-ng
thinks the table doesnt exist.<br>
<br>
-Patrick<br>
</span></font><br>
Sent: Fri Dec 03 2010 11:25:37 GMT-0700 (Mountain Standard Time)<br>
From: Girish-Agarwal (Contractor) <a
href="mailto:Girish.Agarwal@OfficeDepot.com"><Girish.Agarwal@OfficeDepot.com></a><br>
To: Syslog-ng users' and developers' mailing list <a
href="mailto:syslog-ng@lists.balabit.hu"><syslog-ng@lists.balabit.hu></a>
<br>
Subject: Re: [syslog-ng] Syslog-ng and Mysql Not working </p>
<pre wrap=""><font size=2 color="#0050d0" face="Courier New"><span
style='font-size:10.0pt'>Thanks Again Matthew, I have put in the option but when I restart</span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'>syslog-ng it gives syntax Error. I have version 3.0.6-SuSE and do you</span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'>think I require 3.2.x. There should be something in the program where I</span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'>can just turn off Automatic table creation right without upgrading</span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'>syslog-ng????. </span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'> </span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'>destination d_mysql {</span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'> sql(type(mysql)</span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'> host("dbhost") port("4406") username("syslog")</span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'>password("syslog")</span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'> database("testdb")</span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'> table("logs")</span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'> columns("host", "facility", "priority", "tag", "datetime",</span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'>"program", "server", "msg" )</span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'> values("$HOST_FROM", "$FACILITY", "$PRIORITY", "$TAG",</span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'>"$YEAR-$MONTH-$DAY $HOUR:$MIN:$SEC", "$PROGRAM", "testbox", "$MSG" )</span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'> </span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'> indexes(),flags("dont-create-tables"));</span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'>};</span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'> </span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'>Regards,</span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'>Girish</span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'>-----Original Message-----</span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'>From: <a
href="mailto:syslog-ng-bounces@lists.balabit.hu">syslog-ng-bounces@lists.balabit.hu</a></span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'>[<a
href="mailto:syslog-ng-bounces@lists.balabit.hu">mailto:syslog-ng-bounces@lists.balabit.hu</a>] On Behalf Of Matthew Hall</span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'>Sent: Thursday, December 02, 2010 4:10 PM</span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'>To: Syslog-ng users' and developers' mailing list</span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'>Subject: Re: [syslog-ng] Syslog-ng and Mysql Not working</span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'> </span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'>On Thu, Dec 02, 2010 at 10:12:03AM -0500, Girish-Agarwal (Contractor)</span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'>wrote:</span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'> </span></font></pre>
<blockquote style='margin-top:5.0pt;margin-bottom:5.0pt' type=cite><pre wrap=""><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'>Thanks Matthew for all your help in trying to get this resolved.</span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'> </span></font></pre></blockquote>
<pre wrap=""><font size=2 color="#0050d0" face="Courier New"><span
style='font-size:10.0pt'>However</span></font></pre><pre><font size=2
color="#0050d0" face="Courier New"><span style='font-size:10.0pt'> </span></font></pre>
<blockquote style='margin-top:5.0pt;margin-bottom:5.0pt' type=cite><pre wrap=""><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'>can you kindly let me know where should I add this flag or option, or</span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'>can you pass a working example :-</span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'> </span></font></pre></blockquote>
<pre wrap=""><font size=2 color="#0050d0" face="Courier New"><span
style='font-size:10.0pt'> </span></font></pre><pre><font size=2
color="#0050d0" face="Courier New"><span style='font-size:10.0pt'>Put flags("dont-create-tables") (or however it's spelled) in the args to</span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'> </span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'>sql(..., flags(...));</span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'> </span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'> </span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'> </span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'> </span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'> </span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'>Matthew.</span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'>________________________________________________________________________</span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'>____</span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'> </span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'> </span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'>__</span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'>Member info: <a
href="https://lists.balabit.hu/mailman/listinfo/syslog-ng">https://lists.balabit.hu/mailman/listinfo/syslog-ng</a></span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'>Documentation:</span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'><a
href="http://www.balabit.com/support/documentation/?product=syslog-ng">http://www.balabit.com/support/documentation/?product=syslog-ng</a></span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'>FAQ: <a
href="http://www.campin.net/syslog-ng/faq.html">http://www.campin.net/syslog-ng/faq.html</a></span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'> </span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'>______________________________________________________________________________</span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'>Member info: <a
href="https://lists.balabit.hu/mailman/listinfo/syslog-ng">https://lists.balabit.hu/mailman/listinfo/syslog-ng</a></span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'>Documentation: <a
href="http://www.balabit.com/support/documentation/?product=syslog-ng">http://www.balabit.com/support/documentation/?product=syslog-ng</a></span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'>FAQ: <a
href="http://www.campin.net/syslog-ng/faq.html">http://www.campin.net/syslog-ng/faq.html</a></span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'> </span></font></pre><pre><font
size=2 color="#0050d0" face="Courier New"><span style='font-size:10.0pt'> </span></font></pre></div>
</body>
</html>