[syslog-ng] Syslog-ng and Mysql Not working

[Patrick H.]

It will only try to create the table if the table does not already exist.
The dont-create-tables flag requires you to use syslog-ng >= 3.2

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.

-Patrick

Sent: Fri Dec 03 2010 11:25:37 GMT-0700 (Mountain Standard Time)
From: Girish-Agarwal (Contractor) <Girish.Agarwal at OfficeDepot.com>
To: Syslog-ng users' and developers' mailing list 
<syslog-ng at lists.balabit.hu>
Subject: Re: [syslog-ng] Syslog-ng and Mysql Not working
> 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: syslog-ng-bounces at lists.balabit.hu
> [mailto:syslog-ng-bounces at lists.balabit.hu] 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:
>   
>> Thanks Matthew for all your help in trying to get this resolved.
>>     
> However
>   
>> can you kindly let me know where should I add this flag or option, or
>> can you pass a working example  :-
>>     
>
> Put flags("dont-create-tables") (or however it's spelled) in the args to
>
> sql(..., flags(...));
>
>
>
>
>
> Matthew.
> ________________________________________________________________________
> ____
>
>
> __
> Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng
> Documentation:
> http://www.balabit.com/support/documentation/?product=syslog-ng
> FAQ: http://www.campin.net/syslog-ng/faq.html
>
> ______________________________________________________________________________
> Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng
> Documentation: http://www.balabit.com/support/documentation/?product=syslog-ng
> FAQ: http://www.campin.net/syslog-ng/faq.html
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.balabit.hu/pipermail/syslog-ng/attachments/20101203/6286afbd/attachment.htm