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

[Girish-Agarwal (Contractor)]

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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.balabit.hu/pipermail/syslog-ng/attachments/20101201/98291c5a/attachment.htm