NETGEAR is aware of a growing number of phone and online scams. To learn how to stay safe click here.
Forum Discussion
Syslog database running
Hi, I've a ReadyNAS RN104. 4x2TB WD Red drives. I've noticed it's got a MySQL database running on it, with one database called Syslog. There are two tables, one called SystemEvents and System...
So I've learned it's the rsyslog service that's default on debian systems since version 5.
So my question narrows. Having looked at /Volume/rsyslog/ it's logging things in there, but all the logs are of modest size (kbs).
The /etc/rsyslog.conf file includes /etc/rsyslog.d/mysql.conf which has connection details for this mysql database "Syslog" it's logging to.
The problem is, while proper log rotation is clearly happening in the directories, there's nothing keeping the database in check.
Any advice?
It seems to be a problem with rsyslog, not specific to ReadyNAS.
Maybe this should be considered a bug to be fixed via a cron, or simply not logging to the DB at all.
See http://www.rsyslog.com/article50/
I've taken a backup of the data and am going to truncate the database. I've also commented out the line in /etc/rsyslog.conf where it includes the /etc/rsyslog.d/mysql.conf, so hopefully after a restart of rsyslog via systemctl it won't try to log to the DB.
Any ill effects, and I can reverse all this of course...
NETGEAR Academy
Boost your skills with the Netgear Academy - Get trained, certified and stay ahead with the latest Netgear technology!
Join Us!
