[Help] with fixing templates/xml for Cisco ONS Devices

potissimus · Post by **potissimus** » Mon Jul 24, 2006 3:35 pm

Specifically, I am trying to collect and graph data from a couple Cisco ONS 15454's. Somewhere at the end of the road, the plan is to collect data for different types of errors as well as traffic data, but I've scaled back my intentions for now to just trying to graph data on one type of error.

Right now, I'm running the latest, pached version of Cacti on Windows 2000 using the cmd.php poller. My file permissions and versions of php/msql/etc. seem to be all in order as I'm graphing just fine on a few other devices; they were fairly easy to set up and work great.

In regard to the 15454, I've created my own xml snmp query, data and graph templates (following the fantastic guide at http://forums.cacti.net/viewtopic.php?t=11647) and am using the "Generic SNMP-enabled Host" Host Template, but when I view the graph, there doesn't seem to be any data reflected on it (see attached picture).

I know that the stuff I created is doing something right as I see the value that I'm trying to graph under "Data Queries->[Query Name]->[Associated Graph Template Name]->Data Source" where it is enumerated correctly as "sonetSectionCurrentESs - Errored Seconds."

A graph debug of the graph in question yields a "RRDTool says: OK" and the debug output of the poller is also attached (one warning). Also attached is the xml snmp data query (I realize my xml is probably overdone, but going straight to the table gave the same result).

As far as the OID information is concerned, I am using RFC2558 (ftp://ftp.rfc-editor.org/in-notes/rfc2558.txt), which contains SONET interface specific information that I want to use, and Cisco provides a translation tool to get the numeric OID (http://tools.cisco.com/Support/SNMP/do/BrowseOID.do).

Poller debug:

Code: Select all

07/24/2006 02:50:00 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_item"
07/24/2006 02:50:00 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id from host where disabled = '' order by id"
07/24/2006 02:50:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('path_webroot','c:/inetpub/wwwroot/cacti')"
07/24/2006 02:50:00 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "truncate table poller_time"
07/24/2006 02:50:00 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: c:/php/php.exe, ARGS: -q c:/inetpub/wwwroot/cacti/cmd.php 0 4]
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from host where (disabled = '' and id >= 0 and id <= 4) ORDER by id"
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * from poller_item WHERE (host_id >= 0 and host_id <= 4) ORDER by host_id"
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "SELECT count(*) from poller_item WHERE (action=2 AND (host_id >= 0 and host_id <= 4))"
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] Host[1] SNMP: Host responded to SNMP
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update host set  status = '3',  status_event_count = '0',  status_fail_date = '0000-00-00 00:00:00',  status_rec_date = '0000-00-00 00:00:00',  status_last_error = '',  min_time = '2.11000',  max_time = '204.38000',  cur_time = '2.58',  avg_time = '3.42160385345',  total_polls = '1160',  failed_polls = '0',  availability = '100'  where hostname = '127.0.0.1'"
07/24/2006 02:50:01 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=1"
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] Host[1] RECACHE: Processing 1 items in the auto reindex cache for '127.0.0.1'.
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='47944159' where host_id='1' and data_query_id='1' and arg1='.1.3.6.1.2.1.1.3.0'"
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] Host[1] DS[16] SNMP: v1: 127.0.0.1, dsname: users, oid: .1.3.6.1.2.1.25.1.5.0, output: 25
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (16,'users','2006-07-24 14:50:01','25')"
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] Host[1] DS[17] SNMP: v1: 127.0.0.1, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.16777220, output: 649377693
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (17,'traffic_in','2006-07-24 14:50:01','649377693')"
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] Host[1] DS[17] SNMP: v1: 127.0.0.1, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.16777220, output: 573991498
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (17,'traffic_out','2006-07-24 14:50:01','573991498')"
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] Host[3] SNMP: Host responded to SNMP
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update host set  status = '3',  status_event_count = '0',  status_fail_date = '0000-00-00 00:00:00',  status_rec_date = '0000-00-00 00:00:00',  status_last_error = '',  min_time = '4.25000',  max_time = '207.21000',  cur_time = '15.02',  avg_time = '7.38583375617',  total_polls = '1419',  failed_polls = '0',  availability = '100'  where hostname = 'xxx.xxx.xxx.xxx'"
07/24/2006 02:50:01 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=3"
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] Host[3] RECACHE: Processing 1 items in the auto reindex cache for 'xxx.xxx.xxx.xxx'.
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='2299471665' where host_id='3' and data_query_id='1' and arg1='.1.3.6.1.2.1.1.3.0'"
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] Host[3] DS[11] SNMP: v1: xxx.xxx.xxx.xxx, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.67, output: 3920900364
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (11,'traffic_in','2006-07-24 14:50:01','3920900364')"
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] Host[3] DS[11] SNMP: v1: xxx.xxx.xxx.xxx, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.67, output: 3411029946
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (11,'traffic_out','2006-07-24 14:50:01','3411029946')"
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] Host[4] SNMP: Host responded to SNMP
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update host set  status = '3',  status_event_count = '0',  status_fail_date = '2006-07-19 06:16:03',  status_rec_date = '0000-00-00 00:00:00',  status_last_error = 'Host did not respond to SNMP',  min_time = '7.16000',  max_time = '1376.43000',  cur_time = '7.38',  avg_time = '34.5705940957',  total_polls = '565',  failed_polls = '1',  availability = '99.8230088496'  where hostname = 'xxx.xxx.xxx.xxx'"
07/24/2006 02:50:01 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=4"
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] Host[4] RECACHE: Processing 1 items in the auto reindex cache for 'xxx.xxx.xxx.xxx'.
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "update poller_reindex set assert_value='1593106562' where host_id='4' and data_query_id='1' and arg1='.1.3.6.1.2.1.1.3.0'"
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] Host[4] DS[26] WARNING: Result from SNMP not valid.  Partial Result: 
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] Host[4] DS[26] SNMP: v1: xxx.xxx.xxx.xxx, dsname: SONET_Statistics, oid: .1.3.6.1.2.1.10.39.1.2.1.1.2.4099, output: U
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id,rrd_name,time,output) values (26,'SONET_Statistics','2006-07-24 14:50:01','U')"
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] Time: 0.2367 s, Theads: N/A, Hosts: 3
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('date',NOW())"
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select poller_id,end_time from poller_time where poller_id = 0"
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select  poller_output.output,  poller_output.time,  poller_output.local_data_id,  poller_item.rrd_path,  poller_item.rrd_name,  poller_item.rrd_num  from (poller_output,poller_item)  where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)"
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='16' and rrd_name='users' and time='2006-07-24 14:50:01'"
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='17' and rrd_name='traffic_in' and time='2006-07-24 14:50:01'"
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='17' and rrd_name='traffic_out' and time='2006-07-24 14:50:01'"
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='11' and rrd_name='traffic_in' and time='2006-07-24 14:50:01'"
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='11' and rrd_name='traffic_out' and time='2006-07-24 14:50:01'"
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "delete from poller_output where local_data_id='26' and rrd_name='SONET_Statistics' and time='2006-07-24 14:50:01'"
07/24/2006 02:50:01 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update c:\inetpub\wwwroot\cacti\rra\localhost_users_16.rrd --template users 1153770601:25
07/24/2006 02:50:01 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update c:\inetpub\wwwroot\cacti\rra\localhost_traffic_in_17.rrd --template traffic_in:traffic_out 1153770601:649377693:573991498
07/24/2006 02:50:01 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update c:\inetpub\wwwroot\cacti\rra\xxxxx_traffic_in_11.rrd --template traffic_in:traffic_out 1153770601:3920900364:3411029946
07/24/2006 02:50:01 PM - POLLER: Poller[0] CACTI2RRD: c:/rrdtool/rrdtool.exe update c:\inetpub\wwwroot\cacti\rra\xxxxx_sonet_statistics_26.rrd --template SONET_Statistics 1153770601:U
07/24/2006 02:50:01 PM - SYSTEM STATS: Time:1.1094 Method:cmd.php Processes:1 Threads:N/A Hosts:4 HostsPerProcess:4 DataSources:6 RRDsProcessed:4
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "replace into settings (name,value) values ('stats_poller','Time:1.1094 Method:cmd.php Processes:1 Threads:N/A Hosts:4 HostsPerProcess:4 DataSources:6 RRDsProcessed:4')"
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] DEBUG: SQL Exec: "truncate table poller_output"
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select count(*) from poller_command"
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "show tables from `cacti`"
07/24/2006 02:50:01 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: c:/php/php.exe, ARGS: -q c:\inetpub\wwwroot\cacti\plugins\thold/check-thold.php]
07/24/2006 02:50:01 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from reports"
07/24/2006 02:50:02 PM - THOLD: Poller[0] Checking Thresholds
07/24/2006 02:50:02 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id,data_source_name from data_template_rrd where id = 109"
07/24/2006 02:50:02 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id,data_source_name from data_template_rrd where id = 110"
07/24/2006 02:50:02 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "SELECT * FROM thold"
07/24/2006 02:50:02 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select id,name,name_cache from data_template_data where local_data_id=17 order by id LIMIT 1"
07/24/2006 02:50:02 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from thold_data where thold_enabled='on' AND rra_id = 17"

SNMP Query XML:

Code: Select all

<interface>
   <name>Get SONET Information</name>
   <description>Get SNMP based SONET Information</description>
   <index_order_type>numeric</index_order_type>
   <oid_index>.1.3.6.1.2.1.2.2.1.1</oid_index>

   <fields>
      <ifIndex>
         <name>Index</name>
         <method>walk</method>
         <source>value</source>
         <direction>input</direction>
         <oid>.1.3.6.1.2.1.2.2.1.1</oid>
      </ifIndex>
      <ifType>
         <name>Type</name>
         <method>walk</method>
         <source>value</source>
         <direction>input</direction>
         <oid>.1.3.6.1.2.1.2.2.1.3</oid>
      </ifType>
      <IfDescr>
         <name>Description</name>
         <method>walk</method>
         <source>value</source>
         <direction>input</direction>
         <oid>.1.3.6.1.2.1.2.2.1.2</oid>
      </IfDescr>
      <sonetMIB>
         <name>SONET MIB</name>
         <method>walk</method>
         <source>value</source>
         <direction>input</direction>
         <oid>.1.3.6.1.2.1.10.39</oid>
      </sonetMIB>
      <sonetObjects>
         <name>SONET Objects</name>
         <method>walk</method>
         <source>value</source>
         <direction>input</direction>
         <oid>.1.3.6.1.2.1.10.39.1</oid>
      </sonetObjects>
      <sonetSection>
         <name>SONET Section</name>
         <method>walk</method>
         <source>value</source>
         <direction>input</direction>
         <oid>.1.3.6.1.2.1.10.39.1.2</oid>
      </sonetSection>
      <sonetSectionCurrentTable>
         <name>Current Table</name>
         <method>walk</method>
         <source>value</source>
         <direction>input</direction>
         <oid>.1.3.6.1.2.1.10.39.1.2.1</oid>
      </sonetSectionCurrentTable>
      <sonetSectionCurrentEntry>
         <name>Current Entry</name>
         <method>walk</method>
         <source>value</source>
         <direction>input</direction>
         <oid>.1.3.6.1.2.1.10.39.1.2.1.1</oid>
      </sonetSectionCurrentEntry>
      <sonetSectionCurrentESs>
         <name>Errored Seconds</name>
         <method>walk</method>
         <source>value</source>
         <direction>output</direction>
         <oid>.1.3.6.1.2.1.10.39.1.2.1.1.2</oid>
      </sonetSectionCurrentESs>
   </fields>
</interface>

If anyone has any Cacti&Cisco ONS experience or can point me in the right direction so I can get this thing working, I'd greatly appreciate it. I apologize in advance if the problem is glaringly obvious as I'm relatively new to Cacti.

Post by **rony** » Wed Jul 26, 2006 2:01 pm

In your Console -> Data Queries -> (Edit) -> Associated Graph Templates make sure you have the check boxes checked. The nice unlabeled ones.

potissimus · Post by **potissimus** » Thu Jul 27, 2006 9:57 am

Yes, the box next to the data source is checked. Thanks for the idea though; it is an easy step to miss.

Attached are some pictures of various configuration pages. Perhaps something can be spotted there that I've missed.

0.o · Post by **0.o** » Mon Nov 26, 2007 2:01 pm

I am sorry to resurrect this old post, but i was wondering if anyone has gotten this working?

vneutral · Post by **vneutral** » Wed Feb 20, 2008 9:37 am

Has anyone got this working?

chris.landegent · Post by **chris.landegent** » Wed Dec 17, 2008 11:32 am

vneutral wrote:Has anyone got this working?

I'd like to know that too.

[Help] with fixing templates/xml for Cisco ONS Devices

[Help] with fixing templates/xml for Cisco ONS Devices

Who is online