Custom Data Query and Graphs for Foundry ServerIron

[ratza2k]

Hello all,

I've struggling for some time now to graphs useful data for my Foundry ServerIron Load Balancer. I'm trying to graph all the useful data for each Real Server but I'm stuck at creating the xml for the data query. It contains several fields but it only returns 2 values.

The snmp oid that I want to walk are the following:

1.3.6.1.4.1.1991.1.1.4.23.1.1.1 - Real Server IP
1.3.6.1.4.1.1991.1.1.4.23.1.1.2 - Real Server Name
1.3.6.1.4.1.1991.1.1.4.23.1.1.3 - Total Received Pkts per real server
1.3.6.1.4.1.1991.1.1.4.23.1.1.4 - Total Transmited Pkts per real server
1.3.6.1.4.1.1991.1.1.4.23.1.1.5 - Current Connections per real server
1.3.6.1.4.1.1991.1.1.4.23.1.1.6 - Total Connections since last reboot per real server
1.3.6.1.4.1.1991.1.1.4.23.1.1.13 - Total Peak Connections since last reboot per real server
1.3.6.1.4.1.1991.1.1.4.23.1.1.15 - Current Sessions per real server

Let's take an oid, 1.3.6.1.4.1.1991.1.1.4.23.1.1.3 for example. The manual pooling looks like this:

#snmpwalk -v2c -c XXXXX 10.16.33.77 .1.3.6.1.4.1.1991.1.1.4.23.1.1.3
SNMPv2-SMI::enterprises.1991.1.1.4.23.1.1.3.10.16.32.67 = Counter32: 4463380
SNMPv2-SMI::enterprises.1991.1.1.4.23.1.1.3.10.16.32.69 = Counter32: 4
SNMPv2-SMI::enterprises.1991.1.1.4.23.1.1.3.10.16.32.73 = Counter32: 0
SNMPv2-SMI::enterprises.1991.1.1.4.23.1.1.3.10.16.32.75 = Counter32: 0
SNMPv2-SMI::enterprises.1991.1.1.4.23.1.1.3.10.16.34.66 = Counter32: 136606
SNMPv2-SMI::enterprises.1991.1.1.4.23.1.1.3.10.16.34.72 = Counter32: 0
SNMPv2-SMI::enterprises.1991.1.1.4.23.1.1.3.XXX.XXX.XXX.99 = Counter32: 0

Below is the actual xml that I'm using:

<interface>
<name>Get snL4RealServerStatisticTable Information</name>
<description>Get SNMP based server statistic Information out of snL4RealServerStatisticTable</description>
<index_order_type>numeric</index_order_type>
<oid_index>.1.3.6.1.4.1.1991.1.1.4.23.1</oid_index>

<fields>
<snL4RealServerStatisticName>
<name>Real Server Name</name>
<method>walk</method>
<source>value</source>
<direction>input</direction>
<oid>1.3.6.1.4.1.1991.1.1.4.23.1.1.2</oid>
</snL4RealServerStatisticName>
<snL4RealServerStatisticRealIP>
<name>Real Server IP</name>
<method>walk</method>
<source>value</source>
<direction>input</direction>
<oid>1.3.6.1.4.1.1991.1.1.4.23.1.1.1</oid>
</snL4RealServerStatisticRealIP>
<snL4RealServerStatisticReceivePkts>
<name>Total Received Pkts</name>
<method>walk</method>
<source>value</source>
<direction>output</direction>
<oid>1.3.6.1.4.1.1991.1.1.4.23.1.1.3</oid>
</snL4RealServerStatisticReceivePkts>
<snL4RealServerStatisticTransmitPkts>
<name>Total Transmited Pkts</name>
<method>walk</method>
<source>value</source>
<direction>output</direction>
<oid>1.3.6.1.4.1.1991.1.1.4.23.1.1.4</oid>
</snL4RealServerStatisticTransmitPkts>
<snL4RealServerStatisticCurConnections>
<name>Current Connections</name>
<method>walk</method>
<source>value</source>
<direction>output</direction>
<oid>1.3.6.1.4.1.1991.1.1.4.23.1.1.5</oid>
</snL4RealServerStatisticCurConnections>
<snL4RealServerStatisticTotalConnections>
<name>Total Connections since last reboot</name>
<method>walk</method>
<source>value</source>
<direction>output</direction>
<oid>1.3.6.1.4.1.1991.1.1.4.23.1.1.6</oid>
</snL4RealServerStatisticTotalConnections>
<snL4RealServerStatisticPeakConnections>
<name>Total Peak Connections since last reboot</name>
<method>walk</method>
<source>value</source>
<direction>output</direction>
<oid>1.3.6.1.4.1.1991.1.1.4.23.1.1.13</oid>
</snL4RealServerStatisticPeakConnections>
<snL4RealServerStatisticCurrentSessions>
<name>Current Sessions</name>
<method>walk</method>
<source>value</source>
<direction>output</direction>
<oid>1.3.6.1.4.1.1991.1.1.4.23.1.1.15</oid>
</snL4RealServerStatisticCurrentSessions>

</fields>
</interface>

The problem is that because maybe I miss understood how to create a data query like this one, after applying it in Cacti for the ServerIron the following result is given:


+ Running data query [16].
+ Found type = '3' [snmp query].
+ Found data query XML file at '/var/apache2/htdocs/cacti/resource/snmp_queries/snL4RealServerStatisticTable.xml'
+ XML file parsed ok.
+ Executing SNMP walk for list of indexes @ '.1.3.6.1.4.1.1991.1.1.4.23.1'
+ Located input field 'snL4RealServerStatisticName' [walk]
+ Executing SNMP walk for data @ '1.3.6.1.4.1.1991.1.1.4.23.1.1.2'
+ Found item [snL4RealServerStatisticName='svr003-dns'] index: 67 [from value]
+ Found item [snL4RealServerStatisticName='svr003-ntp'] index: 69 [from value]
+ Found item [snL4RealServerStatisticName='svr004-dns'] index: 73 [from value]
+ Found item [snL4RealServerStatisticName='svr004-ntp'] index: 75 [from value]
+ Found item [snL4RealServerStatisticName='svr023-32000'] index: 66 [from value]
+ Found item [snL4RealServerStatisticName='svr024-32000'] index: 72 [from value]
+ Found item [snL4RealServerStatisticName='int-hotline-es'] index: 99 [from value]
+ Located input field 'snL4RealServerStatisticRealIP' [walk]
+ Executing SNMP walk for data @ '1.3.6.1.4.1.1991.1.1.4.23.1.1.1'
+ Found item [snL4RealServerStatisticRealIP='10.16.32.67'] index: 67 [from value]
+ Found item [snL4RealServerStatisticRealIP='10.16.32.69'] index: 69 [from value]
+ Found item [snL4RealServerStatisticRealIP='10.16.32.73'] index: 73 [from value]
+ Found item [snL4RealServerStatisticRealIP='10.16.32.75'] index: 75 [from value]
+ Found item [snL4RealServerStatisticRealIP='10.16.34.66'] index: 66 [from value]
+ Found item [snL4RealServerStatisticRealIP='10.16.34.72'] index: 72 [from value]
+ Found item [snL4RealServerStatisticRealIP='XXX.XXX.XXX.99'] index: 99 [from value]
+ Found data query XML file at '/var/apache2/htdocs/cacti/resource/snmp_queries/snL4RealServerStatisticTable.xml'
+ Found data query XML file at '/var/apache2/htdocs/cacti/resource/snmp_queries/snL4RealServerStatisticTable.xml'
+ Found data query XML file at '/var/apache2/htdocs/cacti/resource/snmp_queries/snL4RealServerStatisticTable.xml'

As you can see from the full list of oids only 2 are being pooled. Can you please explain me what I'm doing wrong?

[BSOD2600]

All looks correct to me. You do realize that <direction>output</direction> values are not displayed in the verbose query, right?

Create the data and graph templates for the xml script. Then once that's all done, wait to see if the graph(s) are populated with data. If not, follow the cacti debugging guide (link in the documentation site) to find where the process is breaking down.

[ratza2k]

Thank you for your information. I didn't make any mistakes i just didn't knew that output values were not suppose to appear in the verbose query. All the graphs turned out ok but i have value 0 in all of them. I've located the problem in cacti pooller. Here is an example below:

The oid it must use is:

1.3.6.1.4.1.1991.1.1.4.23.1.1.3

If i walk this manually everything works great. Now here is how cacti added in in pooller cache:

1.3.6.1.4.1.1991.1.1.4.23.1.1.3.66

Another example:

Good oid: 1.3.6.1.4.1.1991.1.1.4.23.1.1.3
Cacti pooler cache oid: 1.3.6.1.4.1.1991.1.1.4.23.1.1.3.73

So the question is: How can i use an oid/regexp tune to get rid of the unwanted index that cacti adds?

I'm quite new to oid/regexp tuning so I'm kinda stuck here.

Best regards,

[BSOD2600]

The index and value of 0 appears correct to me based on: SNMPv2-SMI::enterprises.1991.1.1.4.23.1.1.3.10.16.32.73 = Counter32: 0

More info about scripts in http://docs.cacti.net/

[ratza2k]

Yes for that one is it the correct value but take a look at this one:

1.3.6.1.4.1.1991.1.1.4.23.1.1.3.67

The manual pooling gives:

SNMPv2-SMI::enterprises.1991.1.1.4.23.1.1.3.10.16.32.67 = Counter32: 462999

but in the graph the value is 0