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

[Matthew Hall]

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 at 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
>