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

[Patrick H.]

Verify you can run that select query (SELECT * FROM <TABLE> WHERE 0=1) 
from the user syslog-ng is using. If that query fails for any reason it 
will try to create the table (empty results are expected, just as long 
as there is no error). (afsql.c:383 & :409 of the 3.1.0 source).

You might also try increasing the verbosity of mysql's logging so that 
it dumps out every single query that gets executed. Maybe see if there's 
anything fishy looking in it.

-Patrick



Sent: Mon Dec 06 2010 10:06:59 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
>
> It still has the same problem Patrick. Again I have verified that the 
> mysql user ( syslog ) from the host has the Select, insert permissions 
> on the database but it still tries to create the table. This is the 
> version of syslog-ng I am using syslog-ng-3.1.3-1.suse10.
>
>  
>
>  
>
> --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:46 PM
> *To:* Syslog-ng users' and developers' mailing list
> *Subject:* Re: [syslog-ng] Syslog-ng and Mysql Not working
>
>  
>
> 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> 
> <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 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> 
> [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
>  
>   
> ------------------------------------------------------------------------
>
> ______________________________________________________________________________
> 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/20101206/50e6434a/attachment-0001.htm