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 :- Here are my options from syslog-ng.conf file. options { stats_freq(3600); keep_hostname(yes); flush_lines(16); log_fifo_size(16384); }; And here is the destination mysql directive 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()); }; Regards, Girish -----Original Message----- From: syslog-ng-bounces@lists.balabit.hu [mailto:syslog-ng-bounces@lists.balabit.hu] On Behalf Of Matthew Hall Sent: Wednesday, December 01, 2010 5:57 PM To: Syslog-ng users' and developers' mailing list Subject: Re: [syslog-ng] Syslog-ng and Mysql Not working See this: http://www.engardelinux.org/modules/index/list_archives.cgi?list=syslog- ng-users&page=0102.html&month=2010-11 You need the dont-create-tables flag. Which for some weird reason is still not in the 3.2 manual. Matthew. On Wed, Dec 01, 2010 at 02:57:59PM -0500, Girish-Agarwal (Contractor) wrote:
Hi, We are trying to setup syslog-ng to directly log messages to mysql but I get the following Error in the client messages file:-
Dec 1 14:45:27 testbox syslog-ng[15637]: Error running SQL query; type='mysql', host='10.10.10.10', port='4406', user='syslog', database='testdb', error='1142: create command denied to user: \'syslog@10.20.30.40\' for table \'logs\'', query='CREATE TABLE logs (host text, facility text, priority text, tag text, datetime text, program text, server text, msg text)' Dec 1 14:45:27 testbox syslog-ng[15637]: Error checking table, disconnecting from database, trying again shortly; time_reopen='60'
I am really confused as to why it is trying to create Table into the database. I already have the table created and I have verified successful connection from this box to the database server. It needs to insert the entries into the database and should not try to CREATE TABLE.
I am using syslog-ng 3.0.6 version .
Regards, Girish
________________________________________________________________________ ______
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