[syslog-ng] Syslog file to Mysql

[Nick Carstensen]

Hello All,

Have a question I hope someone can help with.

Currently I have Syslog-ng running logging to a mysql db along with
keeping files.  This is working well.  I have a situation where I can
not log to the box directly.  I need to "pull" the logs to the central
log server and import them into the db.  As syslogd and syslog-ng do
not log all the needed fields by default like facility:level and year,
when they are writing them local I need a way to add that to the file.

The second problems is how to import them to the db.  Is there any
tool that will do this for me automatically?

Thanks for the assistance.