PVC query broken

[Dragos]

Hi,
I have made an xml script to query snmp index for pvc values. It worked fine in cacti v8.6.c. After upgrading to v8.6.g anf then to 8.6.f, the query was messed up.
Here is the script that worked before:

Code: Select all

<interface> 
        <name>Get Harris Usage per VCC</name> 
        <description>Queries a Harris Base Station for ATM usage per terminal</description> 
        <oid_index>.1.3.6.1.4.1.290.3.3.600.3.4.3.1</oid_index>
        <oid_index_parse>OID/REGEXP:.*\.([0-9]{1,4}\.[0-9]{1,4}\.[0-9]{1,4})$</oid_index_parse> 
        <fields> 
                <VCCin> 
                        <name>PVCin</name> 
                        <method>walk</method> 
                        <source>OID/REGEXP:.*\.([0-9]{1,4}\.[0-9]{1,4})$</source> 
                        <direction>input</direction> 
                        <oid>.1.3.6.1.4.1.290.3.3.600.3.4.3.1.5</oid> 
                </VCCin>
                <usageup>
                        <name>PVCup</name> 
                        <method>walk</method> 
                        <source>value</source> 
                        <direction>output</direction> 
                        <oid>.1.3.6.1.4.1.290.3.3.600.3.4.3.1.5</oid> 
                </usageup>
				<VCCout> 
                        <name>PVCout</name> 
                        <method>walk</method>
						<source>OID/REGEXP:.*\.([0-9]{1,4}\.[0-9]{1,4})$</source> 
                        <direction>input</direction> 
                        <oid>.1.3.6.1.4.1.290.3.3.600.3.4.3.1.8</oid> 
                </VCCout>
				<usagedown> 
                        <name>PVCdown</name> 
                        <method>walk</method> 
                        <source>value</source> 
                        <direction>output</direction> 
                        <oid>.1.3.6.1.4.1.290.3.3.600.3.4.3.1.8</oid> 
                </usagedown>
        </fields> 
</interface>

[TheWitness]

Please try the lib/snmp.php in BRANCH_0_8_6 of SVN. The link is below:

http://svn.cacti.net/cgi-bin/viewcvs.cg ... p?rev=3375

After the new file is applied, reindex the host.

TheWitness

[Dragos]

I have reindexed the host and the values for input and output for the pvcs found are splited between in and out values(there is no associaton).

[TheWitness]

Are you using php_snmp or net-snmp binaries?

TheWitness

[Dragos]

I am using net-snmp package, or at least I think I am.
/usr/local/net-snmp/bin/snmpwalk, snmpget, and so on are the path.

But I have no problems with cisco interface graphs, and I have alot of them.

[TheWitness]

What output do you get with a "Verbose Query". Click the link.

TheWitness

[Dragos]

Here it is:

Code: Select all

Data Query Debug Information 
 
+ Running data query [23].
+ Found type = '3' [snmp query].
+ Found data query XML file at '/usr/local/apache2/htdocs/graph/resource/snmp_queries/harris.xml'
+ XML file parsed ok.
+ Executing SNMP walk for list of indexes @ '.1.3.6.1.4.1.290.3.3.600.3.4.3.1'
+ Located input field 'VCCin' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.4.1.290.3.3.600.3.4.3.1.5'
+ Found item [VCCin='0.32'] index: 532144 [from regexp oid parse]
+ Found item [VCCin='0.33'] index: 22099146 [from regexp oid parse]
+ Found item [VCCin='0.34'] index: 6988007 [from regexp oid parse]
+ Found item [VCCin='0.35'] index: 4184431 [from regexp oid parse]
+ Found item [VCCin='0.36'] index: 12494344 [from regexp oid parse]
+ Found item [VCCin='0.37'] index: 3436195 [from regexp oid parse]
+ Found item [VCCin='0.38'] index: 2750175 [from regexp oid parse]
+ Found item [VCCin='0.39'] index: 2987961 [from regexp oid parse]
+ Found item [VCCin='0.40'] index: 16155325 [from regexp oid parse]
+ Found item [VCCin='0.41'] index: 5883381 [from regexp oid parse]
+ Found item [VCCin='0.42'] index: 2953499 [from regexp oid parse]
+ Found item [VCCin='0.43'] index: 3739232 [from regexp oid parse]
+ Located input field 'VCCout' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.4.1.290.3.3.600.3.4.3.1.8'
+ Found item [VCCout='0.32'] index: 1 [from regexp oid parse]
+ Found item [VCCout='0.33'] index: 56564654 [from regexp oid parse]
+ Found item [VCCout='0.34'] index: 39827146 [from regexp oid parse]
+ Found item [VCCout='0.35'] index: 3750231 [from regexp oid parse]
+ Found item [VCCout='0.36'] index: 52234479 [from regexp oid parse]
+ Found item [VCCout='0.37'] index: 9127021 [from regexp oid parse]
+ Found item [VCCout='0.38'] index: 8855601 [from regexp oid parse]
+ Found item [VCCout='0.39'] index: 8781148 [from regexp oid parse]
+ Found item [VCCout='0.40'] index: 13509701 [from regexp oid parse]
+ Found item [VCCout='0.41'] index: 11942044 [from regexp oid parse]
+ Found item [VCCout='0.42'] index: 8714091 [from regexp oid parse]
+ Found item [VCCout='0.43'] index: 9779455 [from regexp oid parse]
+ Found data query XML file at '/usr/local/apache2/htdocs/graph/resource/snmp_queries/harris.xml'
+ Found data query XML file at '/usr/local/apache2/htdocs/graph/resource/snmp_queries/harris.xml'
+ Found data query XML file at '/usr/local/apache2/htdocs/graph/resource/snmp_queries/harris.xml' 

[TheWitness]

Did you say that this was working before. Because the indexes are the values to the right of "0.32", etc. and they do not align between In and Out. Seems to me that the OID_INDEX_PARSE is working correctly.

TheWitness

[Dragos]

I do not have the harris mib files, I only found this to oid's to represent traffic: 1.3.6.1.4.1.290.3.3.600.3.4.3.1.5 and 1.3.6.1.4.1.290.3.3.600.3.4.3.1.8, the pvcs looking like: 1.3.6.1.4.1.290.3.3.600.3.4.3.1.5.0.35 & 1.3.6.1.4.1.290.3.3.600.3.4.3.1.8.0.35, 0/35 being the vci/vpi values set on equipement

[TheWitness]

Dragos, getting the harris mib files can be a challange. It has been done though. I seem to remember having worked with a user on this. Without additional information, it will be impossible to help you further.

TheWitness

[Dragos]

Hi TheWitness,
I have sent you the mib files by email.