Syslog Plugin issue about classification

[zshwww9187]

I installd syslog 1.22 plugin at cacti 0.8.7h，but I found it have no classification

the Facility and Priority is number,and didn't have colour
the next picture is ok

what I do?

[TheWitness]

Reconfigure rsyslog/syslog-ng to push Text values into the syslog_incoming table and not numeric values.

[Chaosratt]

Reconfigure rsyslog/syslog-ng to push Text values into the syslog_incoming table and not numeric values.

Would you mind explaining this a little more?
I followed the instructions to install the plugin and everything works OK, but just like OP I only get numerical values for priority and facility.
Current /etc/rsyslog.d/mysql.conf:

Code: Select all

### Configuration file for rsyslog-mysql
### Changes are preserved

$ModLoad ommysql
#*.* :ommysql:localhost,Syslog,rsyslog,<snip>
$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
*.* >localhost,Syslog,rsyslog,<snip>;cacti_syslog

If I change it to this:

Code: Select all

### Configuration file for rsyslog-mysql
### Changes are preserved

$ModLoad ommysql
#*.* :ommysql:localhost,Syslog,rsyslog,<snip>
$template cacti_syslog,"INSERT INTO syslog_incoming(facility, priority, date, time, host, message) values (%syslogfacility-text%, %syslogpriority-text%,  '%timereported:::date-mysql%', '%timereported:::date-mysql%', '%HOSTNAME%', '%msg%')", SQL
*.* >localhost,Syslog,rsyslog,<snip>;cacti_syslog

Then I stop getting any new data into the database, and syslog seems to stop working completly with this as the final message:

Code: Select all

Dec  7 03:22:51 <hostname> rsyslogd: db error (1054): Unknown column 'info' in 'field list'

[TheWitness]

You need to put quotes around the facility-text and the priority-text.

[zshwww9187]

You need to put quotes around the facility-text and the priority-text.

thank you very much! Now,it works!But the event background colorsis gray,what I do?