My problem is that when I go to the web interface of syslog plugin, I don't see any logs.
Context :
I have installed the syslog plugin an I've chosen to redirect logs into a separate dababase.
Distro : CentOS 7
Database : MariaDB
When I do the following :
use syslog;
select * from syslog_incoming;
I see rows.
Here is my config files :
1°) /etc/rsyslog.conf
$ModLoad ommysql
$template cacti_syslog,"INSERT INTO syslog_incoming(host, facility, priority, date, time, message) values ('%HOSTNAME%', '%syslogfacility-text%', '%sysnlogpriority-text%', '%timereported:::date-rfc3339%', '%timereported:::date-mysql%', '%msg%')",SQL
*.* >localhost,syslog,cactiuser,password;cacti_syslog
2°) /usr/share/cacti/plugins/syslog/config.php
/* revert if you dont use the Cacti database */
$use_cacti_db = false;
if (!$use_cacti_db) {
$syslogdb_type = 'mysql';
$syslogdb_default = 'syslog';
$syslogdb_hostname = 'localhost';
$syslogdb_username = 'cactiuser';
$syslogdb_password = 'password';
$syslogdb_port = 3306;
}else{
$syslogdb_type = 'mysql';
$syslogdb_default = 'syslog';
$syslogdb_hostname = 'localhost';
$syslogdb_username = 'cactiuser';
$syslogdb_password = 'password';
$syslogdb_port = 3306;
Thank you for your help
