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