Hello all, having issues getting this to work in my particular case. I am trying to get a table of information from a load balancer and graph the active connections and transfer rate information in cacti. I tried following the how to the best I could, the images are mostly gone and its possible I missed a setting somewhere in there if it was checked in the image but no mention of it was made in the text.
Anyway the other issue that exists is there is no nice and easy index like in the example. None of the table entries specify a real index number. I'll post the table/walk and my xml below and what I have done to try to get it to work.
Code: Select all
snmptable -v2c 10.7.2.190 -m ALL .1.3.6.1.4.1.12196.12.2
SNMP table: IPVS-MIB::ipvsRSTable
rSVSidx rSDesc rSConns rSInPkts rSOutPkts rSInBytes rSOutBytes rSActiveConns rSInactiveConns rSWeight
0 "10.7.3.24:80 0" 42891 4789869 6043401 884800570 7069382255 65 32 1000
0 "10.7.3.25:80 0" 51042 7284484 9007608 1634443622 10354617790 0 0 1000
0 "10.7.3.26:80 0" 10731 609168 663503 150607886 694458104 2 2 1000
0 "10.7.3.27:80 0" 8438 437582 466524 89117188 496339071 5 1 1000
0 "10.7.3.28:80 0" 14802 1548995 2305933 641205864 2721785469 6 0 1000
0 "10.7.3.29:80 0" 8884 439525 470757 99461755 514629001 9 11 1000
0 "10.7.3.30:80 0" 4677 280089 326477 48829737 365153253 0 0 1000
1 "10.7.3.24:80 0" 33 1655 2256 223604 2755637 0 0 1000
1 "10.7.3.25:80 0" 171 6773 9710 1257452 11818896 0 0 1000
2 "10.7.3.14:443 Masq 0" 516 5541178 7354382 266144096 2349993137 16 0 1000
2 "10.7.3.15:443 Masq 0" 455 4947440 6467919 236864381 1920543903 17 0 1000
2 "10.7.3.16:443 Masq 0" 511 5253701 7548277 244424731 2433626351 16 0 1000
3 "10.7.3.31:80 0" 21 1610 1941 421697 1865476 0 0 1000
4 "10.7.3.17:443 Masq 0" 3 77 90 4802 17251 0 0 1000
? ? ? ? ? ? ? ? ? ?
0 ? ? ? ? ? ? ? ? ?
0 ? ? ? ? ? ? ? ? ?
0 ? ? ? ? ? ? ? ? ?
0 ? ? ? ? ? ? ? ? ?
0 ? ? ? ? ? ? ? ? ?
0 ? ? ? ? ? ? ? ? ?
0 ? ? ? ? ? ? ? ? ?
0 ? ? ? ? ? ? ? ? ?
0 ? ? ? ? ? ? ? ? ?
0 ? ? ? ? ? ? ? ? ?
0 ? ? ? ? ? ? ? ? ?
0 ? ? ? ? ? ? ? ? ?
0 ? ? ? ? ? ? ? ? ?
Code: Select all
.1.3.6.1.4.1.12196.12.2.1.1.1 = INTEGER: 0
.1.3.6.1.4.1.12196.12.2.1.1.2 = INTEGER: 0
.1.3.6.1.4.1.12196.12.2.1.1.3 = INTEGER: 0
.1.3.6.1.4.1.12196.12.2.1.1.4 = INTEGER: 0
.1.3.6.1.4.1.12196.12.2.1.1.5 = INTEGER: 0
.1.3.6.1.4.1.12196.12.2.1.1.6 = INTEGER: 0
.1.3.6.1.4.1.12196.12.2.1.1.7 = INTEGER: 0
.1.3.6.1.4.1.12196.12.2.1.1.8 = INTEGER: 1
.1.3.6.1.4.1.12196.12.2.1.1.9 = INTEGER: 1
.1.3.6.1.4.1.12196.12.2.1.1.10 = INTEGER: 2
.1.3.6.1.4.1.12196.12.2.1.1.11 = INTEGER: 2
.1.3.6.1.4.1.12196.12.2.1.1.12 = INTEGER: 2
.1.3.6.1.4.1.12196.12.2.1.1.13 = INTEGER: 3
.1.3.6.1.4.1.12196.12.2.1.1.14 = INTEGER: 4
.1.3.6.1.4.1.12196.12.2.1.11.1 = STRING: "10.7.3.24:80 0"
.1.3.6.1.4.1.12196.12.2.1.11.2 = STRING: "10.7.3.25:80 0"
.1.3.6.1.4.1.12196.12.2.1.11.3 = STRING: "10.7.3.26:80 0"
.1.3.6.1.4.1.12196.12.2.1.11.4 = STRING: "10.7.3.27:80 0"
.1.3.6.1.4.1.12196.12.2.1.11.5 = STRING: "10.7.3.28:80 0"
.1.3.6.1.4.1.12196.12.2.1.11.6 = STRING: "10.7.3.29:80 0"
.1.3.6.1.4.1.12196.12.2.1.11.7 = STRING: "10.7.3.30:80 0"
.1.3.6.1.4.1.12196.12.2.1.11.8 = STRING: "10.7.3.24:80 0"
.1.3.6.1.4.1.12196.12.2.1.11.9 = STRING: "10.7.3.25:80 0"
.1.3.6.1.4.1.12196.12.2.1.11.10 = STRING: "10.7.3.14:443 Masq 0"
.1.3.6.1.4.1.12196.12.2.1.11.11 = STRING: "10.7.3.15:443 Masq 0"
.1.3.6.1.4.1.12196.12.2.1.11.12 = STRING: "10.7.3.16:443 Masq 0"
.1.3.6.1.4.1.12196.12.2.1.11.13 = STRING: "10.7.3.31:80 0"
.1.3.6.1.4.1.12196.12.2.1.11.14 = STRING: "10.7.3.17:443 Masq 0"
.1.3.6.1.4.1.12196.12.2.1.12.1 = Counter32: 43229
.1.3.6.1.4.1.12196.12.2.1.12.2 = Counter32: 51042
.1.3.6.1.4.1.12196.12.2.1.12.3 = Counter32: 10757
.1.3.6.1.4.1.12196.12.2.1.12.4 = Counter32: 8451
.1.3.6.1.4.1.12196.12.2.1.12.5 = Counter32: 14831
.1.3.6.1.4.1.12196.12.2.1.12.6 = Counter32: 8939
.1.3.6.1.4.1.12196.12.2.1.12.7 = Counter32: 4689
.1.3.6.1.4.1.12196.12.2.1.12.8 = Counter32: 33
.1.3.6.1.4.1.12196.12.2.1.12.9 = Counter32: 171
.1.3.6.1.4.1.12196.12.2.1.12.10 = Counter32: 517
.1.3.6.1.4.1.12196.12.2.1.12.11 = Counter32: 456
.1.3.6.1.4.1.12196.12.2.1.12.12 = Counter32: 512
.1.3.6.1.4.1.12196.12.2.1.12.13 = Counter32: 21
.1.3.6.1.4.1.12196.12.2.1.12.14 = Counter32: 3
.1.3.6.1.4.1.12196.12.2.1.13.1 = Counter32: 4866536
.1.3.6.1.4.1.12196.12.2.1.13.2 = Counter32: 7284484
.1.3.6.1.4.1.12196.12.2.1.13.3 = Counter32: 610483
.1.3.6.1.4.1.12196.12.2.1.13.4 = Counter32: 443944
.1.3.6.1.4.1.12196.12.2.1.13.5 = Counter32: 1552134
.1.3.6.1.4.1.12196.12.2.1.13.6 = Counter32: 443650
.1.3.6.1.4.1.12196.12.2.1.13.7 = Counter32: 280229
.1.3.6.1.4.1.12196.12.2.1.13.8 = Counter32: 1655
.1.3.6.1.4.1.12196.12.2.1.13.9 = Counter32: 6773
.1.3.6.1.4.1.12196.12.2.1.13.10 = Counter32: 5592156
.1.3.6.1.4.1.12196.12.2.1.13.11 = Counter32: 4997948
.1.3.6.1.4.1.12196.12.2.1.13.12 = Counter32: 5307843
.1.3.6.1.4.1.12196.12.2.1.13.13 = Counter32: 1610
.1.3.6.1.4.1.12196.12.2.1.13.14 = Counter32: 77
.1.3.6.1.4.1.12196.12.2.1.14.1 = Counter32: 6131167
.1.3.6.1.4.1.12196.12.2.1.14.2 = Counter32: 9007608
.1.3.6.1.4.1.12196.12.2.1.14.3 = Counter32: 664915
.1.3.6.1.4.1.12196.12.2.1.14.4 = Counter32: 473271
.1.3.6.1.4.1.12196.12.2.1.14.5 = Counter32: 2309328
.1.3.6.1.4.1.12196.12.2.1.14.6 = Counter32: 477211
.1.3.6.1.4.1.12196.12.2.1.14.7 = Counter32: 326587
.1.3.6.1.4.1.12196.12.2.1.14.8 = Counter32: 2256
.1.3.6.1.4.1.12196.12.2.1.14.9 = Counter32: 9710
.1.3.6.1.4.1.12196.12.2.1.14.10 = Counter32: 7422175
.1.3.6.1.4.1.12196.12.2.1.14.11 = Counter32: 6533056
.1.3.6.1.4.1.12196.12.2.1.14.12 = Counter32: 7624796
.1.3.6.1.4.1.12196.12.2.1.14.13 = Counter32: 1941
.1.3.6.1.4.1.12196.12.2.1.14.14 = Counter32: 90
.1.3.6.1.4.1.12196.12.2.1.15.1 = Counter64: 902093888
.1.3.6.1.4.1.12196.12.2.1.15.2 = Counter64: 1634443622
.1.3.6.1.4.1.12196.12.2.1.15.3 = Counter64: 150808778
.1.3.6.1.4.1.12196.12.2.1.15.4 = Counter64: 90494292
.1.3.6.1.4.1.12196.12.2.1.15.5 = Counter64: 641881532
.1.3.6.1.4.1.12196.12.2.1.15.6 = Counter64: 100015998
.1.3.6.1.4.1.12196.12.2.1.15.7 = Counter64: 48838776
.1.3.6.1.4.1.12196.12.2.1.15.8 = Counter64: 223604
.1.3.6.1.4.1.12196.12.2.1.15.9 = Counter64: 1257452
.1.3.6.1.4.1.12196.12.2.1.15.10 = Counter64: 268592355
.1.3.6.1.4.1.12196.12.2.1.15.11 = Counter64: 239307577
.1.3.6.1.4.1.12196.12.2.1.15.12 = Counter64: 246906059
.1.3.6.1.4.1.12196.12.2.1.15.13 = Counter64: 421697
.1.3.6.1.4.1.12196.12.2.1.15.14 = Counter64: 4802
.1.3.6.1.4.1.12196.12.2.1.16.1 = Counter64: 7165521933
.1.3.6.1.4.1.12196.12.2.1.16.2 = Counter64: 10354617790
.1.3.6.1.4.1.12196.12.2.1.16.3 = Counter64: 696001485
.1.3.6.1.4.1.12196.12.2.1.16.4 = Counter64: 503305947
.1.3.6.1.4.1.12196.12.2.1.16.5 = Counter64: 2725439457
.1.3.6.1.4.1.12196.12.2.1.16.6 = Counter64: 522587738
.1.3.6.1.4.1.12196.12.2.1.16.7 = Counter64: 365249512
.1.3.6.1.4.1.12196.12.2.1.16.8 = Counter64: 2755637
.1.3.6.1.4.1.12196.12.2.1.16.9 = Counter64: 11818896
.1.3.6.1.4.1.12196.12.2.1.16.10 = Counter64: 2370962364
.1.3.6.1.4.1.12196.12.2.1.16.11 = Counter64: 1939430160
.1.3.6.1.4.1.12196.12.2.1.16.12 = Counter64: 2457667713
.1.3.6.1.4.1.12196.12.2.1.16.13 = Counter64: 1865476
.1.3.6.1.4.1.12196.12.2.1.16.14 = Counter64: 17251
.1.3.6.1.4.1.12196.12.2.1.17.1 = Counter32: 71
.1.3.6.1.4.1.12196.12.2.1.17.2 = Counter32: 0
.1.3.6.1.4.1.12196.12.2.1.17.3 = Counter32: 2
.1.3.6.1.4.1.12196.12.2.1.17.4 = Counter32: 5
.1.3.6.1.4.1.12196.12.2.1.17.5 = Counter32: 5
.1.3.6.1.4.1.12196.12.2.1.17.6 = Counter32: 7
.1.3.6.1.4.1.12196.12.2.1.17.7 = Counter32: 1
.1.3.6.1.4.1.12196.12.2.1.17.8 = Counter32: 0
.1.3.6.1.4.1.12196.12.2.1.17.9 = Counter32: 0
.1.3.6.1.4.1.12196.12.2.1.17.10 = Counter32: 16
.1.3.6.1.4.1.12196.12.2.1.17.11 = Counter32: 16
.1.3.6.1.4.1.12196.12.2.1.17.12 = Counter32: 15
.1.3.6.1.4.1.12196.12.2.1.17.13 = Counter32: 0
.1.3.6.1.4.1.12196.12.2.1.17.14 = Counter32: 0
.1.3.6.1.4.1.12196.12.2.1.18.1 = Counter32: 35
.1.3.6.1.4.1.12196.12.2.1.18.2 = Counter32: 0
.1.3.6.1.4.1.12196.12.2.1.18.3 = Counter32: 0
.1.3.6.1.4.1.12196.12.2.1.18.4 = Counter32: 1
.1.3.6.1.4.1.12196.12.2.1.18.5 = Counter32: 1
.1.3.6.1.4.1.12196.12.2.1.18.6 = Counter32: 1
.1.3.6.1.4.1.12196.12.2.1.18.7 = Counter32: 0
.1.3.6.1.4.1.12196.12.2.1.18.8 = Counter32: 0
.1.3.6.1.4.1.12196.12.2.1.18.9 = Counter32: 0
.1.3.6.1.4.1.12196.12.2.1.18.10 = Counter32: 0
.1.3.6.1.4.1.12196.12.2.1.18.11 = Counter32: 0
.1.3.6.1.4.1.12196.12.2.1.18.12 = Counter32: 0
.1.3.6.1.4.1.12196.12.2.1.18.13 = Counter32: 0
.1.3.6.1.4.1.12196.12.2.1.18.14 = Counter32: 0
.1.3.6.1.4.1.12196.12.2.1.19.1 = Counter32: 1000
.1.3.6.1.4.1.12196.12.2.1.19.2 = Counter32: 1000
.1.3.6.1.4.1.12196.12.2.1.19.3 = Counter32: 1000
.1.3.6.1.4.1.12196.12.2.1.19.4 = Counter32: 1000
.1.3.6.1.4.1.12196.12.2.1.19.5 = Counter32: 1000
.1.3.6.1.4.1.12196.12.2.1.19.6 = Counter32: 1000
.1.3.6.1.4.1.12196.12.2.1.19.7 = Counter32: 1000
.1.3.6.1.4.1.12196.12.2.1.19.8 = Counter32: 1000
.1.3.6.1.4.1.12196.12.2.1.19.9 = Counter32: 1000
.1.3.6.1.4.1.12196.12.2.1.19.10 = Counter32: 1000
.1.3.6.1.4.1.12196.12.2.1.19.11 = Counter32: 1000
.1.3.6.1.4.1.12196.12.2.1.19.12 = Counter32: 1000
.1.3.6.1.4.1.12196.12.2.1.19.13 = Counter32: 1000
.1.3.6.1.4.1.12196.12.2.1.19.14 = Counter32: 1000
.1.3.6.1.4.1.12196.12.2.1.20.1 = Counter32: 0
.1.3.6.1.4.1.12196.12.2.1.20.2 = Counter32: 0
.1.3.6.1.4.1.12196.12.2.1.20.3 = Counter32: 0
.1.3.6.1.4.1.12196.12.2.1.20.4 = Counter32: 0
.1.3.6.1.4.1.12196.12.2.1.20.5 = Counter32: 0
.1.3.6.1.4.1.12196.12.2.1.20.6 = Counter32: 0
.1.3.6.1.4.1.12196.12.2.1.20.7 = Counter32: 0
.1.3.6.1.4.1.12196.12.2.1.20.8 = Counter32: 0
.1.3.6.1.4.1.12196.12.2.1.20.9 = Counter32: 0
.1.3.6.1.4.1.12196.12.2.1.20.10 = Counter32: 0
.1.3.6.1.4.1.12196.12.2.1.20.11 = Counter32: 0
.1.3.6.1.4.1.12196.12.2.1.20.12 = Counter32: 0
.1.3.6.1.4.1.12196.12.2.1.20.13 = Counter32: 0
.1.3.6.1.4.1.12196.12.2.1.20.14 = Counter32: 0
Code: Select all
<interface>
<name>Get ipvsRSTableh Information</name>
<description>Get SNMP based Real Server infomration from a Kemp Load Balancer</description>
<index_order_type>numeric</index_order_type>
<oid_index>.1.3.6.1.4.1.12196.12.2</oid_index>
<fields>
<rSDesc>
<name>Description</name>
<method>walk</method>
<source>value</source>
<direction>input</direction>
<oid>.1.3.6.1.4.1.12196.12.2.1.11</oid>
</rSDesc>
<rSVSidx>
<name>Virtual Server Index</name>
<method>walk</method>
<source>value</source>
<direction>input</direction>
<oid>.1.3.6.1.4.1.12196.12.2.1.1</oid>
</rSVSidx>
<rSConns>
<name>RS Total Connections</name>
<method>walk</method>
<source>value</source>
<direction>output</direction>
<oid>.1.3.6.1.4.1.12196.12.2.1.12</oid>
</rSConns>
</fields>
</interface>
Code: Select all
+ Running data query [13].
+ Found type = '3' [snmp query].
+ Found data query XML file at '/var/www/html/resource/snmp_queries/ipvsRSTable.xml'
+ XML file parsed ok.
+ Executing SNMP walk for list of indexes @ '.1.3.6.1.4.1.12196.12.2'
+ Located input field 'rSDesc' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.4.1.12196.12.2.1.11'
+ Found item [rSDesc='10.7.3.24:80 0'] index: 1 [from value]
+ Found item [rSDesc='10.7.3.25:80 0'] index: 2 [from value]
+ Found item [rSDesc='10.7.3.26:80 0'] index: 3 [from value]
+ Found item [rSDesc='10.7.3.27:80 0'] index: 4 [from value]
+ Found item [rSDesc='10.7.3.28:80 0'] index: 5 [from value]
+ Found item [rSDesc='10.7.3.29:80 0'] index: 6 [from value]
+ Found item [rSDesc='10.7.3.30:80 0'] index: 7 [from value]
+ Found item [rSDesc='10.7.3.24:80 0'] index: 8 [from value]
+ Found item [rSDesc='10.7.3.25:80 0'] index: 9 [from value]
+ Found item [rSDesc='10.7.3.14:443 Masq 0'] index: 10 [from value]
+ Found item [rSDesc='10.7.3.15:443 Masq 0'] index: 11 [from value]
+ Found item [rSDesc='10.7.3.16:443 Masq 0'] index: 12 [from value]
+ Found item [rSDesc='10.7.3.31:80 0'] index: 13 [from value]
+ Found item [rSDesc='10.7.3.17:443 Masq 0'] index: 14 [from value]
+ Located input field 'rSVSidx' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.4.1.12196.12.2.1.1'
+ Found item [rSVSidx='0'] index: 1 [from value]
+ Found item [rSVSidx='0'] index: 2 [from value]
+ Found item [rSVSidx='0'] index: 3 [from value]
+ Found item [rSVSidx='0'] index: 4 [from value]
+ Found item [rSVSidx='0'] index: 5 [from value]
+ Found item [rSVSidx='0'] index: 6 [from value]
+ Found item [rSVSidx='0'] index: 7 [from value]
+ Found item [rSVSidx='1'] index: 8 [from value]
+ Found item [rSVSidx='1'] index: 9 [from value]
+ Found item [rSVSidx='2'] index: 10 [from value]
+ Found item [rSVSidx='2'] index: 11 [from value]
+ Found item [rSVSidx='2'] index: 12 [from value]
+ Found item [rSVSidx='3'] index: 13 [from value]
+ Found item [rSVSidx='4'] index: 14 [from value]
+ Found data query XML file at '/var/www/html/resource/snmp_queries/ipvsRSTable.xml'
+ Found data query XML file at '/var/www/html/resource/snmp_queries/ipvsRSTable.xml'
+ Found data query XML file at '/var/www/html/resource/snmp_queries/ipvsRSTable.xml'
Data Template - Name: kemp - rsConns
Data Source - Name: (checked) kemp_rsConns
Data Input Method - Get SNMP Data (Indexed)
Associated RRA's - (All Selected)
Step - 300
Data Source Active - (Checked)
Data Source Item - Internal Data Source Name - rsConns
Minimum Value/Maximum Value - 0
Data Source Type - Counter
Heartbeat - 600
Custom Data - Index Type (checked)
Custom Data - Index Value (checked)
Custom Data - Output Type ID (checked)
I then made a simple graph, called it kemp - rsConns and added a line1 graph type, average consolidation function and linked it to the data source rsConns I defined above.
I proceded to add the graph template to the data query. I did not however put anything in suggested values.
And now I am at a point where I create the graph, but nothing is ever put into a RRD file. If I go to Data Sources and turn on debug mode I get the following:
Code: Select all
/usr/bin/rrdtool create \
/var/www/html/rra/kemp_lb1_rsconns_546.rrd \
--step 300 \
DS:rsConns:COUNTER:600:0:U \
RRA:AVERAGE:0.5:1:10080 \
RRA:AVERAGE:0.5:1:25920 \
RRA:AVERAGE:0.5:6:9000 \
RRA:AVERAGE:0.5:24:2250 \
RRA:AVERAGE:0.5:288:797 \
RRA:MIN:0.5:1:10080 \
RRA:MIN:0.5:1:25920 \
RRA:MIN:0.5:6:9000 \
RRA:MIN:0.5:24:2250 \
RRA:MIN:0.5:288:797 \
RRA:MAX:0.5:1:10080 \
RRA:MAX:0.5:1:25920 \
RRA:MAX:0.5:6:9000 \
RRA:MAX:0.5:24:2250 \
RRA:MAX:0.5:288:797 \
RRA:LAST:0.5:1:10080 \
RRA:LAST:0.5:1:25920 \
RRA:LAST:0.5:6:9000 \
RRA:LAST:0.5:24:2250 \
RRA:LAST:0.5:288:797 \