Syslog Shows no Log Messages

[gregvellozo]

Hello guys,

I need help with Cacti Syslog Plugin.
I followed all installation instructions, and it worked fine from the start. A few weeks ago it just stopped and I coudn't find the cause.

I checked syslog daemon and mySQL, and I found out that:
- The syslog messages are being received normally, and are being stored on /var/log/messages
- The incoming messages are being inserted successfully on cacti database. I executed a select on syslog_incoming table, and everything looks fine.

My problem is, when I access the syslog tab and try to search for records, I got the message
"No Rows Found".

Does anyone have any clue?

[gregvellozo]

Hello folks,

I have an update. I noticed that the table syslog_incoming is populated but looks like it's not being transferred to syslog table.
As far as I know, the cacti web interface query from syslog table right?

Can anyone please help me?


mysql> select count(*) from syslog;
+----------+
| count(*) |
+----------+
| 0 |
+----------+
1 row in set (0.00 sec)

mysql> select count(*) from syslog_incoming;
+----------+
| count(*) |
+----------+
| 39895003 |
+----------+
1 row in set (0.00 sec)