syslog-ng

[steveburton]

I have yet to be sucessful in getting syslog-ng to log entries into my mysql database.

I am running version 0.8.7a, and the latest plugin arch.

I just can't seem to get the syslog-ng to write to the pipe, and have the db pick it up.

If someone could post there config, that would be great.

[steagu]

I haven't used syslog-ng but I did use Kiwi on Windows which, I believe, is very similar to syslog-ng.

Doing a quck read on syslog-ng it appears that only the premium version support database logging. Are you using the premium version?

If you are using the premium version, you may have to modify the sql script (syslog.sql) that creates the initial Syslog Databases for you. I had to change the following line:
priority varchar(10) default NULL

to

priority varchar(20) default NULL

for all the databases that get created.

If you've already created that database, you can use mysql commands to change the value on all databases.

Hope that helps