Problem with Syslog 1.22 + cacti 0.8.7h

[pocobor]

Hi all!
I have installed cacti 0.8.7h + PA +spine. After it, i have installed Syslog 1.22... but in cacti logs i see errors:

• 10/09/2011 11:30:06 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1054', SQL:"DELETE FROM `cacti`.`syslog_incoming` WHERE status=127'
  10/09/2011 11:30:06 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1054', SQL:"INSERT INTO `cacti`.`syslog` (logtime, priority_id, facility_id, host_id, message) SELECT TIMESTAMP(`date`, `time`), priority_id, facility_id, host_id, message FROM (SELECT date, time, priority_id, facility_id, host_id, message FROM syslog_incoming AS si INNER JOIN syslog_facilities AS sf ON sf.facility=si.facility INNER JOIN syslog_priorities AS sp ON sp.priority=si.priority INNER JOIN syslog_hosts AS sh ON sh.host=si.host WHERE status=127) AS merge'
  10/09/2011 11:30:06 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1054', SQL:"SELECT count(*) FROM `cacti`.`syslog_incoming` WHERE status=127"
  10/09/2011 11:30:06 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1054', SQL:"INSERT INTO `cacti`.`syslog_statistics` (host_id, facility_id, priority_id, insert_time, records) SELECT host_id, facility_id, priority_id, NOW(), sum(records) AS records FROM (SELECT host_id, facility_id, priority_id, count(*) AS records FROM syslog_incoming AS si INNER JOIN syslog_facilities AS sf ON sf.facility=si.facility INNER JOIN syslog_priorities AS sp ON sp.priority=si.priority INNER JOIN syslog_hosts AS sh ON sh.host=si.host WHERE status=127 GROUP BY host_id, priority_id, facility_id) AS merge GROUP BY host_id, priority_id, facility_id'
  10/09/2011 11:30:06 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1054', SQL:"INSERT INTO `cacti`.`syslog_host_facilities` (host_id, facility_id) SELECT host_id, facility_id FROM ((SELECT DISTINCT host, facility FROM `cacti`.`syslog_incoming` WHERE status=127) AS s INNER JOIN `cacti`.`syslog_hosts` AS sh ON s.host=sh.host INNER JOIN `cacti`.`syslog_facilities` AS sf ON sf.facility=s.facility) ON DUPLICATE KEY UPDATE host_id=VALUES(host_id), last_updated=NOW()'
  10/09/2011 11:30:06 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1054', SQL:"INSERT INTO `cacti`.`syslog_hosts` (host) SELECT DISTINCT host FROM `cacti`.`syslog_incoming` WHERE status=127 ON DUPLICATE KEY UPDATE host=VALUES(host), last_updated=NOW()'
  10/09/2011 11:30:06 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1054', SQL:"UPDATE `cacti`.`syslog_incoming` SET status=127 WHERE status=0'
  10/09/2011 11:30:06 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1054', SQL:"SELECT count(*) FROM `cacti`.`syslog_incoming` WHERE status=127"

I tried to find a similar problem but found nothing
can anyone help me with this problem?

[TheWitness]

Looks like you may have upgraded from an old syslog version. My guess is that you have solved this already.

TheWitness

[shikima]

I have the same issue, but I already update the syslog plugin to 1.22, rsyslog too.

[shikima]

I solved with issue the next commands

In the file /etc/rsyslog.d/mysql.conf


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