MySQL Insert Errors

[emrecio]

I am getting the following errors:

Code: Select all

10/25/2007 09:00:03 AM - CMDPHP: Poller[0] Host[8] SNMP: Host responded to SNMP
10/25/2007 09:00:03 AM - CMDPHP: Poller[0] Host[8] DS[87] CMD: /usr/share/cacti/scripts/random2.pl, output: 0
10/25/2007 09:00:03 AM - CMDPHP: Poller[0] Host[8] DS[87] CMD: /usr/share/cacti/scripts/random2.pl, output: 5
10/25/2007 09:00:03 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (87, 'ElmoRandomDSI', '2007-10-25 09:00:03', '5')"
10/25/2007 09:00:03 AM - CMDPHP: Poller[0] Host[8] DS[88] CMD: /usr/local/bin/cacti_parse_wscol1.sh wscol1, output: 5404
10/25/2007 09:00:03 AM - CMDPHP: Poller[0] Time: 0.0718 s, Theads: N/A, Hosts: 1
10/25/2007 09:00:03 AM - CMDPHP: Poller[0] Host[8] DS[88] CMD: /usr/local/bin/cacti_parse_wscol1.sh wscol1, output: 5404
10/25/2007 09:00:03 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (88, 'WS_LIC', '2007-10-25 09:00:03', '5404')"
10/25/2007 09:00:03 AM - CMDPHP: Poller[0] Time: 0.1078 s, Theads: N/A, Hosts: 1

I cannot find why the MySQL is failing because when I login as the cacti db user to the cacti db via the mysql cli, I can insert correctly the statements the log says are failing. I have confirmed that I can login as 127.0.0.1:3306, localhost:3306, and even via the socket... so the grant statements are correct. What's going on here?

[rony]

Cacti Version?

How many rows are in the poller_output table when the poller isn't running?