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@lists.balabit.hu [mailto:syslog-ng-bounces@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@OfficeDepot.com> <mailto:Girish.Agarwal@OfficeDepot.com> To: Syslog-ng users' and developers' mailing list <syslog-ng@lists.balabit.hu> <mailto:syslog-ng@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@lists.balabit.hu [mailto:syslog-ng-bounces@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