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

Girish-Agarwal (Contractor) Girish.Agarwal at OfficeDepot.com
Wed Dec 1 20:57:59 CET 2010

    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='', port='4406', user='syslog',
database='testdb', error='1142: create command denied to user:
\'syslog at\' 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 .


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

More information about the syslog-ng mailing list