[HOWTO] Using Data Queries and Data Input Methods

[gandalf]

This is due to the way rrdtool works (see main rrd site at http://oss.oetiker.ch/rrdtool/tut/rrdtutorial.en.html, Section: Data Resampling. You may find http://www.vandenbogaerdt.nl/rrdtool/process.php useful, too). Not all updates occur at exactly a 300 sec interval. So rrdtool provides a way dealing with those slight deviations and back-calculating them to exactly 300 sec. On COUNTERS, you will as well see the result of normalizing from 300 sec (data gathering interval) to 1 sec (so: division by 300 which will change integers to non-integers).
You may use the GPRINT Preset "Exact Numbers" in your Graph Template to suppress decimals.
Reinhard

[Sandhya]

Hi
I have recently started using CACTI to monitor squid server.
I followed the above mentioned steps , created my own xml file

<interface>
<name>Get Squid Cache Network</name>
<description>Queries Squid SNMPserver </description>
<oid_index>1.3.6.1.4.1.3495.1.4.1.7</oid_index>
<oid_num_indexes>1.3.6.1.4.1.3495.1.4.1.0</oid_num_indexes>

<fields>
<cacheBlockingGetHostByName>
<name>cacheBlocking</name>
<method>walk</method>
<source>value</source>
<direction>input</direction>
<oid>1.3.6.1.4.1.3495.1.4.1.7</oid>
</cacheBlockingGetHostByName>
<cacheIpHits>
<name>cache hits </name>
<method>walk</method>
<source>value</source>
<direction>output</direction>
<oid>1.3.6.1.4.1.3495.1.4.1.3</oid>
</cacheIpHits>
<cacheIpMisses>
<name>cache Miss </name>
<method>walk</method>
<source>value</source>
<direction>output</direction>
<oid>1.3.6.1.4.1.3495.1.4.1.6</oid>
</cacheIpMisses>
</fields>
</interface>

The Debug query information shows

+ Running data query [14].
+ Found type = '3' [snmp query].
+ Found data query XML file at '/usr/share/cacti/resource/snmp_queries/testsquid.xml'
+ XML file parsed ok.
+ Executing SNMP walk for list of indexes @ '1.3.6.1.4.1.3495.1.4.1.7'
+ Located input field 'cacheBlockingGetHostByName' [walk]
+ Executing SNMP walk for data @ '1.3.6.1.4.1.3495.1.4.1.7'
+ Found item [cacheBlockingGetHostByName='0'] index: 0 [from value]
+ Found data query XML file at '/usr/share/cacti/resource/snmp_queries/testsquid.xml'
+ Found data query XML file at '/usr/share/cacti/resource/snmp_queries/testsquid.xml'
+ Found data query XML file at '/usr/share/cacti/resource/snmp_queries/testsquid.xml'
+ Found data query XML file at '/usr/share/cacti/resource/snmp_queries/testsquid.xml'

However , my graphs are empty!! I have included cacheIpHits and cacheIpMisses as datasources for my graph.
Also i created the .rrd file for the graph manually using "rrdtool create" since it gave an error .

Could anyone plz let me know, why am I not getting any plots on my graph? what am I missing out??
Also ,manual snmpwalk for cacheIpHits and cacheIpMisses returns valid values.

Any help regarding this is deeply appreciated.
Thanx!

[gandalf]

Squid usually listens on a non-standard snmp port
Reinhard

[Sandhya]

Hi
Yes, Squid normally listens for incoming SNMP requests on port 3401.
When I do a snmpwalk on port 3401 for a particular SNMP OID , i get the correct values.

But there is no output on the graphs !!

Plz help. Could there be some issue with some settings in CACTI ??

[melcon]

How can I get a SNMP Data from an OID that returns 2 fields, like in:

snmpwalk -On -v1 -ccommunity host UCD-SNMP-MIB::extOutput

...
.1.3.6.1.4.1.2021.8.1.101.4 = STRING: Duration:105 count:8
...

Is my DIM correct(see attachment)?

[mgriffin]

The images on the main HOWTO have broken. Is there any way to get an update to this guide for 0.8.7b?

[gandalf]

[devel]

I have a question about Data Input Methods->InputType.
I can't find description for "SNMP Query" anywhere. I was supposed to find there a possibility to build a list of name:oid values instead of writing own script.... but it seems servers different needs. What are they ?

[gandalf]

Please refer to the 1st link of my sig for complete walkthroughs. IF your question is still valid, please post again, but create a new topic because this thread is closed
Reinhard