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