cactid SNMP ERROR

[rafael]

I was usind cmd.php for a one year without problems, but last weekend i moved from cdm.php to cactid version 0.8.6d and now all snmp query`s fail with this error:

04/14/2005 05:48:20 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_command (poller_id,time,action,command) values (0,NOW(),1,'59:8')
04/14/2005 05:48:20 PM - CACTID: Poller[0] ASSERT: 'SNMP ERROR
04/14/2005 05:48:20 PM - CACTID: Poller[0] Host[59] RECACHE: Processing 2 items in the auto reindex cache for '10.36.16.15'

04/14/2005 05:48:20 PM - CACTID: Poller[0] DEBUG: SQLCMD: update host set status='3',status_event_count='0', status_fail_date='2005-04-14 03:50:00',status_rec_date='0000-00-00 00:00:00',status_last_error='Host did not respond to SNMP, ICMP: Host is Alive',min_time='3.068960',max_time='999.999990',cur_time='23.371040',avg_time='118.332579',total_polls='5459',failed_polls='4',availability='99.0000' where id='59'
04/14/2005 05:48:20 PM - CACTID: Poller[0] Host[59] PING: Result ICMP: Host is Alive
04/14/2005 05:48:20 PM - CACTID: Poller[0] DEBUG: The Value of Active Threads is 3
04/14/2005 05:48:20 PM - CACTID: Poller[0] DEBUG: Valid Thread to be Created
04/14/2005 05:48:20 PM - CACTID: Poller[0] MYSQL: Connecting to MySQL database 'cactidb' on 'localhost'...
04/14/2005 05:48:20 PM - CACTID: Poller[0] DEBUG: In Poller, About to Start Polling of Host
04/14/2005 05:48:20 PM - CACTID: Poller[0] Host[56] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
04/14/2005 05:48:20 PM - CACTID: Poller[0] DEBUG: SQLCMD: update poller_reindex set assert_value='SNMP ERROR' where host_id='56' and data_query_id='1' and arg1='.1.3.6.1.2.1.1.3.0'
04/14/2005 05:48:20 PM - CACTID: Poller[0] ERROR: Problem with MySQL: Duplicate entry '0-1-56:1' for key 1
04/14/2005 05:48:20 PM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_command (poller_id,time,action,command) values (0,NOW(),1,'56:1')
04/14/2005 05:48:20 PM - CACTID: Poller[0] ASSERT: 'SNMP ERROR
04/14/2005 05:48:20 PM - CACTID: Poller[0] Host[56] RECACHE: Processing 1 items in the auto reindex cache for '10.36.14.1'

04/14/2005 05:48:20 PM - CACTID: Poller[0] DEBUG: SQLCMD: update host set status='3',status_event_count='0', status_fail_date='2005-04-14 03:50:00',status_rec_date='2005-04-05 03:36:50',status_last_error='Host did not respond to SNMP, ICMP: Host is Alive',min_time='0.261020',max_time='999.999990',cur_time='71.245980',avg_time='936.147145',total_polls='12878',failed_polls='183',availability='98.0000' where id='56'
04/14/2005 05:48:20 PM - CACTID: Poller[0] Host[56] PING: Result ICMP: Host is Alive


OBS: I can query this OID (.1.3.6.1.2.1.1.3.0) using snmpget to all hosts without problem.

Could anyone help me to solve this issue?

Thanks in advance...

[rony]

Strange....

Run the following in my mysql client against your cacti database:

Code: Select all

delete from poller_output;

[rafael]

Tony, here is the output:

mysql> delete from poller_output;
Query OK, 0 rows affected (0.00 sec)

mysql>


but the problem continue only for snmp query`s...

Any idea ?

Thanks in advance...

[rony]

What version of NET-SNMP development libaries do you have installed?

[rafael]

I am using net-snmp 5.2.1

Thanks....

[rony]

Um....

I don't know, TheWitness can answer better, but I would ask you to go back to 5.1.2 or the latest 5.1.x series, not 5.2.x.

[rafael]

Guys....thanks for all. I solved the problem.....I had a old version of net-snmp that I think was not removed property....

Now everithing is work fine.....

Thanks...

[TheWitness]

Good to know! We'll add it to the knowledge base.

TheWitness