<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#0050d0">
<font size="-1"><font face="Helvetica, Arial, sans-serif">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>
</font></font><br>
Sent: Fri Dec 03 2010 11:25:37 GMT-0700 (Mountain Standard Time)<br>
From: Girish-Agarwal (Contractor) <a class="moz-txt-link-rfc2396E" href="mailto:Girish.Agarwal@OfficeDepot.com"><Girish.Agarwal@OfficeDepot.com></a><br>
To: Syslog-ng users' and developers' mailing list
<a class="moz-txt-link-rfc2396E" href="mailto:syslog-ng@lists.balabit.hu"><syslog-ng@lists.balabit.hu></a> <br>
Subject: Re: [syslog-ng] Syslog-ng and Mysql Not working
<blockquote
cite="mid:3B351952C8FD214EBC5B4B779B56EEA1051A9F1D@USCHMSX84.na.odcorp.net"
type="cite">
<pre wrap="">Thanks Again Matthew, I have put in the option but when I restart
syslog-ng it gives syntax Error. I have version 3.0.6-SuSE and do you
think I require 3.2.x. There should be something in the program where I
can just turn off Automatic table creation right without upgrading
syslog-ng????.
destination d_mysql {
sql(type(mysql)
host("dbhost") port("4406") username("syslog")
password("syslog")
database("testdb")
table("logs")
columns("host", "facility", "priority", "tag", "datetime",
"program", "server", "msg" )
values("$HOST_FROM", "$FACILITY", "$PRIORITY", "$TAG",
"$YEAR-$MONTH-$DAY $HOUR:$MIN:$SEC", "$PROGRAM", "testbox", "$MSG" )
indexes(),flags("dont-create-tables"));
};
Regards,
Girish
-----Original Message-----
From: <a class="moz-txt-link-abbreviated" href="mailto:syslog-ng-bounces@lists.balabit.hu">syslog-ng-bounces@lists.balabit.hu</a>
[<a class="moz-txt-link-freetext" href="mailto:syslog-ng-bounces@lists.balabit.hu">mailto:syslog-ng-bounces@lists.balabit.hu</a>] On Behalf Of Matthew Hall
Sent: Thursday, December 02, 2010 4:10 PM
To: Syslog-ng users' and developers' mailing list
Subject: Re: [syslog-ng] Syslog-ng and Mysql Not working
On Thu, Dec 02, 2010 at 10:12:03AM -0500, Girish-Agarwal (Contractor)
wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Thanks Matthew for all your help in trying to get this resolved.
</pre>
</blockquote>
<pre wrap=""><!---->However
</pre>
<blockquote type="cite">
<pre wrap="">can you kindly let me know where should I add this flag or option, or
can you pass a working example :-
</pre>
</blockquote>
<pre wrap=""><!---->
Put flags("dont-create-tables") (or however it's spelled) in the args to
sql(..., flags(...));
Matthew.
________________________________________________________________________
____
__
Member info: <a class="moz-txt-link-freetext" href="https://lists.balabit.hu/mailman/listinfo/syslog-ng">https://lists.balabit.hu/mailman/listinfo/syslog-ng</a>
Documentation:
<a class="moz-txt-link-freetext" href="http://www.balabit.com/support/documentation/?product=syslog-ng">http://www.balabit.com/support/documentation/?product=syslog-ng</a>
FAQ: <a class="moz-txt-link-freetext" href="http://www.campin.net/syslog-ng/faq.html">http://www.campin.net/syslog-ng/faq.html</a>
______________________________________________________________________________
Member info: <a class="moz-txt-link-freetext" href="https://lists.balabit.hu/mailman/listinfo/syslog-ng">https://lists.balabit.hu/mailman/listinfo/syslog-ng</a>
Documentation: <a class="moz-txt-link-freetext" href="http://www.balabit.com/support/documentation/?product=syslog-ng">http://www.balabit.com/support/documentation/?product=syslog-ng</a>
FAQ: <a class="moz-txt-link-freetext" href="http://www.campin.net/syslog-ng/faq.html">http://www.campin.net/syslog-ng/faq.html</a>
</pre>
</blockquote>
</body>
</html>