Lost SNMP Interface query for All Routers

[guanno]

It appears all of our routers have lost their network interfaces template.
The data sources are there but under the templates it is blank and none are generating graphs.
Does anyone know a way to fix this.
Thanks in advance!

[gandalf]

Please post a screenshot (wipe out everything confidential)
Reinhard

[guanno]

I have attached the screenshots

[guanno]

It appears they were all using the SNMP -Interface Statistics data imput method but imput method is still there but it appears they are not linked to it somehow....sorry still a little new to Cacti.....using 8.7 patched

[guanno]

All Devices using the SNMP -Interface Statistics have stopped graphing?
Any Help?

[gandalf]

Are both the Data Template and the Graph Template still present? Did you run a repair on the MySQL tables?
Reinhard

[guanno]

Yes both graph and data templates exist ...checking DB tables

[guanno]

Which Tables would need to be checked?

[gandalf]

Code: Select all

 REPAIR TABLE `cdef` , `cdef_items` , `colors` , `data_input` , `data_input_data` , `data_input_fields` , `data_local` , `data_template` , `data_template_data` , `data_template_data_rra` , `data_template_rrd` , `graph_local` , `graph_templates` , `graph_templates_gprint` , `graph_templates_graph` , `graph_templates_item` , `graph_template_input` , `graph_template_input_defs` , `graph_tree` , `graph_tree_items` , `host` , `host_graph` , `host_snmp_cache` , `host_snmp_query` , `host_template` , `host_template_graph` , `host_template_snmp_query` , `poller` , `poller_command` , `poller_item` , `poller_output` , `poller_reindex` , `poller_time` , `rra` , `rra_cf` , `settings` , `settings_graphs` , `settings_tree` , `snmp_query` , `snmp_query_graph` , `snmp_query_graph_rrd` , `snmp_query_graph_rrd_sv` , `snmp_query_graph_sv` , `user_auth` , `user_auth_perms` , `user_auth_realm` , `user_log` , `version`
;

Reinhard

[guanno]

I ran the repair out put below
Table | Op | Msg_type | Msg_text
---------------------------------+--------+----------+----------
cacti.cdef | repair | status | OK
cacti.cdef_items | repair | status | OK
cacti.colors | repair | status | OK
cacti.data_input | repair | status | OK
cacti.data_input_data | repair | status | OK
cacti.data_input_fields | repair | status | OK
cacti.data_local | repair | status | OK
cacti.data_template | repair | status | OK
cacti.data_template_data | repair | status | OK
cacti.data_template_data_rra | repair | status | OK
cacti.data_template_rrd | repair | status | OK
cacti.graph_local | repair | status | OK
cacti.graph_templates | repair | status | OK
cacti.graph_templates_gprint | repair | status | OK
cacti.graph_templates_graph | repair | status | OK
cacti.graph_templates_item | repair | status | OK
cacti.graph_template_input | repair | status | OK
cacti.graph_template_input_defs | repair | status | OK
cacti.graph_tree | repair | status | OK
cacti.graph_tree_items | repair | status | OK
cacti.host | repair | status | OK
cacti.host_graph | repair | status | OK
cacti.host_snmp_cache | repair | status | OK
cacti.host_snmp_query | repair | status | OK
cacti.host_template | repair | status | OK
cacti.host_template_graph | repair | status | OK
cacti.host_template_snmp_query | repair | status | OK
cacti.poller | repair | status | OK
cacti.poller_command | repair | status | OK
cacti.poller_item | repair | status | OK
cacti.poller_output | repair | status | OK
cacti.poller_reindex | repair | status | OK
cacti.poller_time | repair | status | OK
cacti.rra | repair | status | OK
cacti.rra_cf | repair | status | OK
cacti.settings | repair | status | OK
cacti.settings_graphs | repair | status | OK
cacti.settings_tree | repair | status | OK
cacti.snmp_query | repair | status | OK
cacti.snmp_query_graph | repair | status | OK
cacti.snmp_query_graph_rrd | repair | status | OK
cacti.snmp_query_graph_rrd_sv | repair | status | OK
cacti.snmp_query_graph_sv | repair | status | OK
cacti.user_auth | repair | status | OK
cacti.user_auth_perms | repair | status | OK
cacti.user_auth_realm | repair | status | OK
cacti.user_log | repair | status | OK
cacti.version | repair | status | OK



If I delete the associated data query and re-add it and recreate graphs all is well but I lose my history???
I ran the php cmd.php id id

and this returns
11/13/2007 03:06:12 PM - CMDPHP: Poller[0] Host[76] PING: Host is alive
11/13/2007 03:06:12 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update host set status = '3', status_event_count = '0', status_fail_date = '2007-11-08 10:05:03', status_rec_date = '2007-10-18 03:55:08', status_last_error = 'ICMP ping Timed out', min_time = '0.00000', max_time = '525.88000', cur_time = '39.8', avg_time = '38.3102858949', total_polls = '11946', failed_polls = '112', availability = '99.0624476812' where hostname = '192.168.58.1'"
11/13/2007 03:06:12 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_reindex.data_query_id, poller_reindex.action, poller_reindex.op, poller_reindex.assert_value, poller_reindex.arg1 from poller_reindex where poller_reindex.host_id=76"
11/13/2007 03:06:12 PM - CMDPHP: Poller[0] Host[76] RECACHE: Processing 1 items in the auto reindex cache for '192.168.58.1'.
11/13/2007 03:06:12 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='821569258' where host_id='76' and data_query_id='1' and arg1='.1.3.6.1.2.1.1.3.0'"
11/13/2007 03:06:13 PM - CMDPHP: Poller[0] Host[76] DS[720] SNMP: v2: 192.168.58.1, dsname: 5min_cpu, oid: .1.3.6.1.4.1.9.2.1.58.0, output: 0
11/13/2007 03:06:13 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (720, '5min_cpu', '2007-11-13 15:06:12', '0')"
11/13/2007 03:06:13 PM - CMDPHP: Poller[0] Host[76] DS[1996] SNMP: v2: 192.168.58.1, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.1, output: 1230605957
11/13/2007 03:06:13 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (1996, 'traffic_out', '2007-11-13 15:06:12', '1230605957')"
11/13/2007 03:06:13 PM - CMDPHP: Poller[0] Host[76] DS[1996] SNMP: v2: 192.168.58.1, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.1, output: 850969783
11/13/2007 03:06:13 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (1996, 'traffic_in', '2007-11-13 15:06:12', '850969783')"
11/13/2007 03:06:13 PM - CMDPHP: Poller[0] Time: 0.2532 s, Theads: N/A, Hosts: 1
11/13/2007 03:06:13 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"


RRDTOOL says everything is OK also??

[guanno]

what I am not finding is the rrdtool update I will check NAN doc for rrdtool update issue?

[guanno]

The interface query for the hosts are not in the poller cache?
How can I re-add them without losing history?

[gandalf]

Re-building poller cache is done by

Code: Select all

php -q rebuild_poller_cache.php

But if the Data Template isn't associated any more, I suppose this will not help
Reinhard

[guanno]

That seems to be the issue?
I have rebuilt the poller cache but it seems the only way to recreate the association is to delete the query and graphs and re-add which causes the loss of history?

[guanno]

rebuild poller cache errors with
Fatal error: Call to undefined function db_execute() in C:\Inetpub\wwwroot\cacti\rebuild_poller_cache.php on line 78


Line 78 = db_execute("truncate table poller_item");