[syslog-ng] syslog - sql error

[vijay]

HI All,

  Iam using syslog-ng3.2.5  rpm in centos x86_64 environment.Past days it
is  working well.Suddenly iam seeing a problem in writing to mysql

Error running SQL query; type='mysql', host='192.168.9.68', port='3306',
user='cygnet', database='CygNetDB', error='1072: Key column \'date\'
doesn\'t exist in table', query='CREATE INDEX SYSLOGS_20131130_date_idx ON
SYSLOGS_20131130 (date)'

Error adding missing index; table='SYSLOGS_20131130', column='date'

Error running SQL query; type='mysql', host='192.168.9.68', port='3306',
user='cygnet', database='CygNetDB', error='1170: BLOB/TEXT column
\'facility\' used in key specification without a key length', query='CREATE
INDEX SYSLOGS_20131130_facility_idx ON SYSLOGS_20131130 (facility)'

Error adding missing index; table='SYSLOGS_20131130', column='facility'


vijay
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.balabit.hu/pipermail/syslog-ng/attachments/20131130/ec28cb36/attachment.htm