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

[Girish-Agarwal (Contractor)]

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] 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] 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/20101206/a47b7819/attachment-0001.htm