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

[Girish-Agarwal (Contractor)]

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