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

[Patrick H.]

That would be the problem then, it does a select to see if the table 
exists. `select * from <TABLE> where 0=1`

-Patrick

Sent: Fri Dec 03 2010 12:16:41 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 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.
>
>  
>
> Regards,
>
> Girish
>
>  
>
> ------------------------------------------------------------------------
>
> *From:* syslog-ng-bounces at lists.balabit.hu 
> [mailto:syslog-ng-bounces at lists.balabit.hu] *On Behalf Of *Patrick H.
> *Sent:* Friday, December 03, 2010 2:03 PM
> *To:* Syslog-ng users' and developers' mailing list
> *Subject:* Re: [syslog-ng] Syslog-ng and Mysql Not working
>
>  
>
> 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> 
> <mailto:Girish.Agarwal at OfficeDepot.com>
> To: Syslog-ng users' and developers' mailing list 
> <syslog-ng at lists.balabit.hu> <mailto: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>
> [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
>  
>   
> ------------------------------------------------------------------------
>
> ______________________________________________________________________________
> 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/60cc7168/attachment.htm