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> To: Syslog-ng users' and developers' mailing list <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