No Data In Graphs after Syslog 1.20 Install

[rdbrock]

Has anyone encountered this before?

I'm running Cacti Version 0.8.7g on CentOS 5.5 x86 Plugin Architecture Version: 2.9, w/ Monitor 1.2, Settings 0.7 and thold0.4.1.
It seems like everything is running ok, but my graphs data are nan(empty).

I do have rsyslog rsyslog-mysql installed, and I also edited '/etc/rsyslog.conf' and added the

following lines to the top:

Code: Select all

$ModLoad ommysql
$template cacti_syslog,"INSERT INTO syslog_incoming(facility, priority, date, time, host, 

message) values (%syslogfacility%, %syslogpriority%,  '%timereported:::date-mysql%', 

'%timereported:::date-mysql%', '%HOSTNAME%', '%msg%')", SQL
*.*             >{mysql_server},{db_name},{db_users},{db_pass};cacti_syslog

Replaced all {info} with my machine's info.

Not sure why I stopped getting data, I can pool snmp and see it's working, but not data. ????