Templating possible?

tekbot · Post by **tekbot** » Wed May 31, 2006 1:42 pm

I saw many references to "the last two links", but honestly, I don't see any links in any of your posts. Would you mind linking me directly in a reply post? The Cacti Manual covers this topic with a bit of brevity, but provides no real examples.

Ironmike, what counters kind of templates did you create? Did you clone an existing template?

lvm -- A walkthrough would be *much* appreciated!

Thanks for the quick reply.

--tekbot

Post by **gandalf** » Wed May 31, 2006 1:50 pm

Please see http://forums.cacti.net/viewtopic.php?t=11647 and http://forums.cacti.net/viewtopic.php?t=11288
Reinhard

rcaston · Post by **rcaston** » Thu Jul 06, 2006 1:06 pm

Mike, I used your snmp data query xml; but it seems to not work for me, I get the same results as the original poster where each value is returned as it's own row rather then correlated corrected. (as below)

When I go to graph a host it places each value on it's own line such as;

svcServiceName svcIPAddress svcPort svcServiceType svcState
cc_web_1
cc_web_2
--------------------------------12.22.201.170
--------------------------------12.22.201.170
-----------------------------------------------------------80
----------------------------------------------------------80
---------------------------------------------------------------------------------------0
---------------------------------------------------------------------------------------0

ironmike · Post by **ironmike** » Thu Jul 06, 2006 10:35 pm

First off, my apologies for not responding earlier... been busy with many other things...

Tekbot, I created the template from scratch, pulling the counters that I needed. I have not finished adding everything I want to monitor, but hope to soon (if I can get some free time

)

rcaston, do a "verbose" query dump and post the results here. I bet when I see that, I will get a good idea as to what is going wrong.

thanks,
Mike

rcaston · Post by **rcaston** » Fri Jul 07, 2006 9:43 am

the organization is the issue.

chevelle · Post by **chevelle** » Mon Jul 10, 2006 3:32 am

ironmike, any chance of an export (with depend.) of your netscaler to get us (read: me) started with something proven to be complete and functional? Dyslexia and RegEx do NOT go well together. Thanks in Advance!

rcaston: visit your netscaler at http://yournetscaler(may need :8080)/support/docs/snmp/WhatsUpGold/mib.txt
Look towards the bottom for
vsvrTotalRequestsHigh,1.3.6.1.4.1.5951.4.1.3.1.1.12
vsvrTotalRequestBytesLow,1.3.6.1.4.1.5951.4.1.3.1.1.13
vsvrTotalResponseBytesLow,1.3.6.1.4.1.5951.4.1.3.1.1.17
vsvrTotalResponseBytesHigh,1.3.6.1.4.1.5951.4.1.3.1.1.18
I used those to differentiate the numbers for CacheRedirection and Origin servers.

tekbot · Post by **tekbot** » Tue Jul 18, 2006 8:07 pm

Weird and Wild Stuff.

I created a template to graph Memory and CPU utilization for my Netscaler using LVMs walk through here. I want to say, THANK YOU, that is absolutely awesome. I used it to create Netscreen Load Average / Mem utilization and Netscaler CPU and session trends, and it worked perfectly. Until...

I went through the walk through to create new graphs for each of the Netscaler "Virtual Servers" - the services that are routed through the Netscaler for Load Balancing and SSL Offloading. What I found is if I have active Data Sources for these services, all of my other data sources for that particular device Fail (the log shows SNMP timeouts, but that is definitely not the case. SNMP queries from the CLI work fine, as do the "verbose queries" from the Devices screen). Here are some attachments.

Output from log with active Data sources:

Code: Select all

tail -f ../../log/cacti.log |grep 10.20.11.25

07/18/2006 08:20:02 PM - CACTID: Poller[0] Host[93] DS[1535] WARNING: SNMP timeout detected [1500 ms], ignoring host '10.20.11.251'
07/18/2006 08:20:02 PM - CACTID: Poller[0] Host[93] DS[1535] SNMP: v2: 10.20.11.251, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.1, value: U
07/18/2006 08:20:02 PM - CACTID: Poller[0] Host[93] DS[1536] WARNING: SNMP timeout detected [1500 ms], ignoring host '10.20.11.251'
07/18/2006 08:20:02 PM - CACTID: Poller[0] Host[93] DS[1536] SNMP: v2: 10.20.11.251, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.2, value: U
07/18/2006 08:20:02 PM - CACTID: Poller[0] Host[93] DS[1537] WARNING: SNMP timeout detected [1500 ms], ignoring host '10.20.11.251'
07/18/2006 08:20:02 PM - CACTID: Poller[0] Host[93] DS[1537] SNMP: v2: 10.20.11.251, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.3, value: U
07/18/2006 08:20:02 PM - CACTID: Poller[0] Host[93] DS[1538] WARNING: SNMP timeout detected [1500 ms], ignoring host '10.20.11.251'
07/18/2006 08:20:02 PM - CACTID: Poller[0] Host[93] DS[1538] SNMP: v2: 10.20.11.251, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.4, value: U
07/18/2006 08:20:02 PM - CACTID: Poller[0] Host[93] DS[1535] WARNING: SNMP timeout detected [1500 ms], ignoring host '10.20.11.251'
07/18/2006 08:20:02 PM - CACTID: Poller[0] Host[93] DS[1535] SNMP: v2: 10.20.11.251, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.1, value: U
07/18/2006 08:20:02 PM - CACTID: Poller[0] Host[93] DS[1536] WARNING: SNMP timeout detected [1500 ms], ignoring host '10.20.11.251'
07/18/2006 08:20:02 PM - CACTID: Poller[0] Host[93] DS[1536] SNMP: v2: 10.20.11.251, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.2, value: U
07/18/2006 08:20:02 PM - CACTID: Poller[0] Host[93] DS[1537] WARNING: SNMP timeout detected [1500 ms], ignoring host '10.20.11.251'
07/18/2006 08:20:02 PM - CACTID: Poller[0] Host[93] DS[1537] SNMP: v2: 10.20.11.251, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.3, value: U
07/18/2006 08:20:02 PM - CACTID: Poller[0] Host[93] DS[1538] WARNING: SNMP timeout detected [1500 ms], ignoring host '10.20.11.251'
07/18/2006 08:20:02 PM - CACTID: Poller[0] Host[93] DS[1538] SNMP: v2: 10.20.11.251, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.4, value: U
07/18/2006 08:20:02 PM - CACTID: Poller[0] Host[93] DS[1842] WARNING: SNMP timeout detected [1500 ms], ignoring host '10.20.11.251'
07/18/2006 08:20:02 PM - CACTID: Poller[0] Host[93] DS[1842] SNMP: v2: 10.20.11.251, dsname: resCpuUsage, oid: .1.3.6.1.4.1.5951.4.1.1.41.1.0, value: U
07/18/2006 08:20:02 PM - CACTID: Poller[0] Host[93] DS[1842] WARNING: SNMP timeout detected [1500 ms], ignoring host '10.20.11.251'
07/18/2006 08:20:02 PM - CACTID: Poller[0] Host[93] DS[1842] SNMP: v2: 10.20.11.251, dsname: resMemUsage, oid: .1.3.6.1.4.1.5951.4.1.1.41.4.0, value: U
07/18/2006 08:20:02 PM - CACTID: Poller[0] Host[93] DS[1874] WARNING: SNMP timeout detected [1500 ms], ignoring host '10.20.11.251'

And, with Inactive Data Sources

07/18/2006 08:25:02 PM - CACTID: Poller[0] Host[92] DS[1528] SNMP: v2: 10.20.11.250, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.1, value: 29845323
07/18/2006 08:25:02 PM - CACTID: Poller[0] Host[92] DS[1529] SNMP: v2: 10.20.11.250, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.2, value: 0
07/18/2006 08:25:02 PM - CACTID: Poller[0] Host[92] DS[1530] SNMP: v2: 10.20.11.250, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.3, value: 18063080
07/18/2006 08:25:02 PM - CACTID: Poller[0] Host[92] DS[1531] SNMP: v2: 10.20.11.250, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.4, value: 0
07/18/2006 08:25:02 PM - CACTID: Poller[0] Host[92] DS[1528] SNMP: v2: 10.20.11.250, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.1, value: 15324342
07/18/2006 08:25:02 PM - CACTID: Poller[0] Host[92] DS[1529] SNMP: v2: 10.20.11.250, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.2, value: 0
07/18/2006 08:25:02 PM - CACTID: Poller[0] Host[92] DS[1530] SNMP: v2: 10.20.11.250, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.3, value: 21799530
07/18/2006 08:25:02 PM - CACTID: Poller[0] Host[92] DS[1531] SNMP: v2: 10.20.11.250, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.4, value: 0
07/18/2006 08:25:02 PM - CACTID: Poller[0] Host[92] DS[1841] SNMP: v2: 10.20.11.250, dsname: resCpuUsage, oid: .1.3.6.1.4.1.5951.4.1.1.41.1.0, value: 0
07/18/2006 08:25:02 PM - CACTID: Poller[0] Host[92] DS[1841] SNMP: v2: 10.20.11.250, dsname: resMemUsage, oid: .1.3.6.1.4.1.5951.4.1.1.41.4.0, value: 3471
07/18/2006 08:25:02 PM - CACTID: Poller[0] Host[93] DS[1535] SNMP: v2: 10.20.11.251, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.1, value: 2476666579
07/18/2006 08:25:02 PM - CACTID: Poller[0] Host[93] DS[1536] SNMP: v2: 10.20.11.251, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.2, value: 0
07/18/2006 08:25:02 PM - CACTID: Poller[0] Host[93] DS[1537] SNMP: v2: 10.20.11.251, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.3, value: 2124034487
07/18/2006 08:25:02 PM - CACTID: Poller[0] Host[93] DS[1538] SNMP: v2: 10.20.11.251, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.4, value: 0
07/18/2006 08:25:02 PM - CACTID: Poller[0] Host[93] DS[1535] SNMP: v2: 10.20.11.251, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.1, value: 3291988831
07/18/2006 08:25:02 PM - CACTID: Poller[0] Host[93] DS[1536] SNMP: v2: 10.20.11.251, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.2, value: 0
07/18/2006 08:25:02 PM - CACTID: Poller[0] Host[93] DS[1537] SNMP: v2: 10.20.11.251, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.3, value: 3916012419
07/18/2006 08:25:02 PM - CACTID: Poller[0] Host[93] DS[1538] SNMP: v2: 10.20.11.251, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.4, value: 0
07/18/2006 08:25:02 PM - CACTID: Poller[0] Host[93] DS[1842] SNMP: v2: 10.20.11.251, dsname: resCpuUsage, oid: .1.3.6.1.4.1.5951.4.1.1.41.1.0, value: 20

Output from Verbose Query on Devices Screen

This is the Good query that worked until I created DS's for the Virtual Servers

+ Running data query [15].
+ Found type = '3' [snmp query].
+ Found data query XML file at '/usr/local/cacti-0.8.6g/resource/snmp_queries/NetScalerEstablishedConn.xml'
+ XML file parsed ok.
+ Executing SNMP walk for list of indexes @ '1.3.6.1.4.1.5951.1.2.1.16'
+ Located input field 'ESTConn' [walk]
+ Executing SNMP walk for data @ '1.3.6.1.4.1.5951.1.2.1.16'
+ Found item [ESTConn='8134'] index: 0 [from value]
+ Found data query XML file at '/usr/local/cacti-0.8.6g/resource/snmp_queries/NetScalerEstablishedConn.xml'
+ Found data query XML file at '/usr/local/cacti-0.8.6g/resource/snmp_queries/NetScalerEstablishedConn.xml'
+ Found data query XML file at '/usr/local/cacti-0.8.6g/resource/snmp_queries/NetScalerEstablishedConn.xml'
+ Found data query XML file at '/usr/local/cacti-0.8.6g/resource/snmp_queries/NetScalerEstablishedConn.xml'

And the Verbose Output of the "Bad Query" (appears to run fine, but fails to graph *AND* kills the other graphs for this host!)

+ Running data query [17].
+ Found type = '3' [snmp query].
+ Found data query XML file at '/usr/local/cacti-0.8.6g/resource/snmp_queries/NetScalerVSConn.xml'
+ XML file parsed ok.
+ Executing SNMP walk for list of indexes @ '.1.3.6.1.4.1.5951.4.1.2.1.1.1'
+ Located input field 'svcServiceName' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.4.1.5951.4.1.2.1.1.1'
+ Found item [svcServiceName='Service-Public00'] index: 117.98.108.105.99.48.48 [from value]
+ Found item [svcServiceName='Service-Public01'] index: 117.98.108.105.99.48.49 [from value]
+ Found item [svcServiceName='Service-Public02'] index: 117.98.108.105.99.48.50 [from value]
+ Found item [svcServiceName='Service-Public03'] index: 117.98.108.105.99.48.51 [from value]
+ Found item [svcServiceName='Service-Public04'] index: 117.98.108.105.99.48.52 [from value]
+ Found item [svcServiceName='Service-Public10'] index: 117.98.108.105.99.49.48 [from value]
+ Found item [svcServiceName='Service-Public11'] index: 117.98.108.105.99.49.49 [from value]
+ Found item [svcServiceName='Service-Public12'] index: 117.98.108.105.99.49.50 [from value]
+ Found item [svcServiceName='Service-Public13'] index: 117.98.108.105.99.49.51 [from value]
+ Found item [svcServiceName='Service-http2-00'] index: 116.116.112.50.45.48.48 [from value]
+ Found item [svcServiceName='Service-http2-01'] index: 116.116.112.50.45.48.49 [from value]
+ Found item [svcServiceName='Service-http2-02'] index: 116.116.112.50.45.48.50 [from value]
+ Found item [svcServiceName='Service-WebAdmin00'] index: 65.100.109.105.110.48.48 [from value]
+ Found item [svcServiceName='Service-WebAdmin01'] index: 65.100.109.105.110.48.49 [from value]
+ Found item [svcServiceName='Service-WebAdmin02'] index: 65.100.109.105.110.48.50 [from value]
+ Located input field 'svcIPAddress' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.4.1.5951.4.1.2.1.1.2'
+ Found item [svcIPAddress='10.20.4.10'] index: 117.98.108.105.99.48.48 [from value]
+ Found item [svcIPAddress='10.20.4.11'] index: 117.98.108.105.99.48.49 [from value]
+ Found item [svcIPAddress='10.20.4.12'] index: 117.98.108.105.99.48.50 [from value]
+ Found item [svcIPAddress='10.20.4.13'] index: 117.98.108.105.99.48.51 [from value]
+ Found item [svcIPAddress='10.20.4.14'] index: 117.98.108.105.99.48.52 [from value]
+ Found item [svcIPAddress='10.20.4.20'] index: 117.98.108.105.99.49.48 [from value]
+ Found item [svcIPAddress='10.20.4.21'] index: 117.98.108.105.99.49.49 [from value]
+ Found item [svcIPAddress='10.20.4.22'] index: 117.98.108.105.99.49.50 [from value]
+ Found item [svcIPAddress='10.20.4.23'] index: 117.98.108.105.99.49.51 [from value]
+ Found item [svcIPAddress='10.20.33.200'] index: 116.116.112.50.45.48.48 [from value]
+ Found item [svcIPAddress='10.20.33.201'] index: 116.116.112.50.45.48.49 [from value]
+ Found item [svcIPAddress='10.20.33.202'] index: 116.116.112.50.45.48.50 [from value]
+ Found item [svcIPAddress='10.20.33.200'] index: 65.100.109.105.110.48.48 [from value]
+ Found item [svcIPAddress='10.20.33.201'] index: 65.100.109.105.110.48.49 [from value]
+ Found item [svcIPAddress='10.20.33.202'] index: 65.100.109.105.110.48.50 [from value]
+ Located input field 'svcPort' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.4.1.5951.4.1.2.1.1.3'
+ Found item [svcPort='443'] index: 117.98.108.105.99.48.48 [from value]
+ Found item [svcPort='443'] index: 117.98.108.105.99.48.49 [from value]
+ Found item [svcPort='443'] index: 117.98.108.105.99.48.50 [from value]
+ Found item [svcPort='443'] index: 117.98.108.105.99.48.51 [from value]
+ Found item [svcPort='443'] index: 117.98.108.105.99.48.52 [from value]
+ Found item [svcPort='443'] index: 117.98.108.105.99.49.48 [from value]
+ Found item [svcPort='443'] index: 117.98.108.105.99.49.49 [from value]
+ Found item [svcPort='443'] index: 117.98.108.105.99.49.50 [from value]
+ Found item [svcPort='443'] index: 117.98.108.105.99.49.51 [from value]
+ Found item [svcPort='90'] index: 116.116.112.50.45.48.48 [from value]
+ Found item [svcPort='90'] index: 116.116.112.50.45.48.49 [from value]
+ Found item [svcPort='90'] index: 116.116.112.50.45.48.50 [from value]
+ Found item [svcPort='443'] index: 65.100.109.105.110.48.48 [from value]
+ Found item [svcPort='443'] index: 65.100.109.105.110.48.49 [from value]
+ Found item [svcPort='443'] index: 65.100.109.105.110.48.50 [from value]
+ Located input field 'svcServiceType' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.4.1.5951.4.1.2.1.1.4'
+ Found item [svcServiceType='2'] index: 117.98.108.105.99.48.48 [from value]
+ Found item [svcServiceType='2'] index: 117.98.108.105.99.48.49 [from value]
+ Found item [svcServiceType='2'] index: 117.98.108.105.99.48.50 [from value]
+ Found item [svcServiceType='2'] index: 117.98.108.105.99.48.51 [from value]
+ Found item [svcServiceType='2'] index: 117.98.108.105.99.48.52 [from value]
+ Found item [svcServiceType='2'] index: 117.98.108.105.99.49.48 [from value]
+ Found item [svcServiceType='2'] index: 117.98.108.105.99.49.49 [from value]
+ Found item [svcServiceType='2'] index: 117.98.108.105.99.49.50 [from value]
+ Found item [svcServiceType='2'] index: 117.98.108.105.99.49.51 [from value]
+ Found item [svcServiceType='0'] index: 116.116.112.50.45.48.48 [from value]
+ Found item [svcServiceType='0'] index: 116.116.112.50.45.48.49 [from value]
+ Found item [svcServiceType='2'] index: 116.116.112.50.45.48.50 [from value]
+ Found item [svcServiceType='4'] index: 65.100.109.105.110.48.48 [from value]
+ Found item [svcServiceType='4'] index: 65.100.109.105.110.48.49 [from value]
+ Found item [svcServiceType='4'] index: 65.100.109.105.110.48.50 [from value]
+ Located input field 'svcState' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.4.1.5951.4.1.2.1.1.5'
+ Found item [svcState='7'] index: 117.98.108.105.99.48.48 [from value]
+ Found item [svcState='7'] index: 117.98.108.105.99.48.49 [from value]
+ Found item [svcState='7'] index: 117.98.108.105.99.48.50 [from value]
+ Found item [svcState='7'] index: 117.98.108.105.99.48.51 [from value]
+ Found item [svcState='7'] index: 117.98.108.105.99.48.52 [from value]
+ Found item [svcState='7'] index: 117.98.108.105.99.49.48 [from value]
+ Found item [svcState='7'] index: 117.98.108.105.99.49.49 [from value]
+ Found item [svcState='7'] index: 117.98.108.105.99.49.50 [from value]
+ Found item [svcState='7'] index: 117.98.108.105.99.49.51 [from value]
+ Found item [svcState='4'] index: 116.116.112.50.45.48.48 [from value]
+ Found item [svcState='1'] index: 116.116.112.50.45.48.49 [from value]
+ Found item [svcState='7'] index: 116.116.112.50.45.48.50 [from value]
+ Found item [svcState='7'] index: 65.100.109.105.110.48.48 [from value]
+ Found item [svcState='7'] index: 65.100.109.105.110.48.49 [from value]
+ Found item [svcState='7'] index: 65.100.109.105.110.48.50 [from value]
+ Found data query XML file at '/usr/local/cacti-0.8.6g/resource/snmp_queries/NetScalerVSConn.xml'
+ Found data query XML file at '/usr/local/cacti-0.8.6g/resource/snmp_queries/NetScalerVSConn.xml'
+ Found data query XML file at '/usr/local/cacti-0.8.6g/resource/snmp_queries/NetScalerVSConn.xml'

And, here's some XML. First off, there's the xml I used for the Netscaler Stats CPU and Memory Graphing. I think a lot of people will find it useful, however, sparse (no descriptive columns, just raw, graphable output).

Code: Select all

<interface>
        <name>Get NetScaler CPU Information</name>
        <description>Get NetScaler CPU Information</description>
        <index_order_type>numeric</index_order_type>
        <oid_index>.1.3.6.1.4.1.5951.4.1.1</oid_index>
        <fields>
                <NSIndex>
                        <name>Index</name>
                        <method>walk</method>
                        <source>value</source>
                        <direction>input</direction>
                        <oid>.1.3.6.1.4.1.5951.4.1.1.41</oid>
                </NSIndex>
                <NSCPU>
                        <name>CPU Util Percent</name>
                        <method>walk</method>
                        <source>value</source>
                        <direction>input</direction>
                        <oid>.1.3.6.1.4.1.5951.4.1.1.41.1</oid>
                </NSCPU>
                <NSMEM>
                        <name>MEM Util MB</name>
                        <method>walk</method>
                        <source>value</source>
                        <direction>input</direction>
                        <oid>.1.3.6.1.4.1.5951.4.1.1.41.2</oid>
                </NSMEM>
                <NSCPUUsed>
                        <name>CPU Util Percent</name>
                        <method>walk</method>
                        <source>value</source>
                        <direction>output</direction>
                        <oid>.1.3.6.1.4.1.5951.4.1.1.41.1</oid>
                </NSCPUUsed>
                <NSMEMAvail>
                        <name>MEM Util MB</name>
                        <method>walk</method>
                        <source>value</source>
                        <direction>output</direction>
                        <oid>.1.3.6.1.4.1.5951.4.1.1.41.4</oid>
                </NSMEMAvail>

        </fields>
</interface>

And the XML I'm using (with descriptive column goodness) for the Virtual Servers (This is what's killing my graphs). Also, this was borrowed and only slightly modified from the ironmike / lvm Netscaler thread. Thanks to the original author.

Code: Select all

<query>
        <name>Netscaler services</name>
        <description>Collect information on netscaler services</description>
        <oid_index>.1.3.6.1.4.1.5951.4.1.2.1.1.1</oid_index>
        <oid_index_parse>OID/REGEXP:.*\.([0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3})$</oid_index_parse>

        <fields>
                <svcServiceName>
                        <name>svcServiceName</name>
                        <method>walk</method>
                        <source>value</source>
                        <direction>input</direction>
                        <oid>.1.3.6.1.4.1.5951.4.1.2.1.1.1</oid>
                </svcServiceName>
                <svcIPAddress>
                        <name>svcIPAddress</name>
                        <method>walk</method>
                        <source>value</source>
                        <direction>input</direction>
                        <oid>.1.3.6.1.4.1.5951.4.1.2.1.1.2</oid>
                </svcIPAddress>
                <svcPort>
                        <name>svcPort</name>
                        <method>walk</method>
                        <source>value</source>
                        <direction>input</direction>
                        <oid>.1.3.6.1.4.1.5951.4.1.2.1.1.3</oid>
                </svcPort>
                <svcServiceType>
                        <name>svcServiceType</name>
                        <method>walk</method>
                        <source>value</source>
                        <direction>input</direction>
                        <oid>.1.3.6.1.4.1.5951.4.1.2.1.1.4</oid>
                </svcServiceType>
                <svcState>
                        <name>svcState</name>
                        <method>walk</method>
                        <source>value</source>
                        <direction>input</direction>
                        <oid>.1.3.6.1.4.1.5951.4.1.2.1.1.5</oid>
                </svcState>
                <svcAvgTransactionTime>
                        <name>svcAvgTransactionTime</name>
                        <method>walk</method>
                        <source>value</source>
                        <direction>output</direction>
                        <oid>.1.3.6.1.4.1.5951.4.1.2.1.1.7</oid>
                </svcAvgTransactionTime>
                <svcEstablishedConn>
                        <name>svcEstablishedConn</name>
                        <method>walk</method>
                        <source>value</source>
                        <direction>output</direction>
                        <oid>.1.3.6.1.4.1.5951.4.1.2.1.1.8</oid>
                </svcEstablishedConn>
                <svcActiveConn>
                        <name>svcActiveConn</name>
                        <method>walk</method>
                        <source>value</source>
                        <direction>output</direction>
                        <oid>.1.3.6.1.4.1.5951.4.1.2.1.1.9</oid>
                </svcActiveConn>
                <svcTotalRequests>
                        <name>svcTotalRequests</name>
                        <method>walk</method>
                        <source>value</source>
                        <direction>output</direction>
                        <oid>.1.3.6.1.4.1.5951.4.1.2.1.1.30</oid>
                </svcTotalRequests>
        </fields>
</query>

I've also attached a picture of what happens to my graphs if the above data source is active during the day.

Sorry about the length and verbosity of this post, I just want to make sure I'm clear and descriptive, and give you all the necessary information to assist me here. Thanks in advance!

I should also mention, as you can see in the attachments, that it is not only the custom query that fails when I have the Data Source active. The Traffic is being graphed from the standard Interface Template for the Generic SNMP-enabled host.

ironmike · Post by **ironmike** » Wed Jul 19, 2006 5:31 pm

I have been extremely busy and unable to devote much time to cacti until today. I hope to have something by the end of this week for others to look at/pick apart. I have created a data/graph templates for the lbStatisticsTable. This will show connections, Latency, and service hits. I just have a few more tweaks before I am comfortable posting it...

Once I get that done, I will finish up my unfinished serviceTable template.

Mike

Post by **gandalf** » Thu Jul 20, 2006 6:52 am

tekbot wrote:Weird and Wild Stuff.

I created a template to graph Memory and CPU utilization for my Netscaler using LVMs walk through here. I want to say, THANK YOU, that is absolutely awesome. I used it to create Netscreen Load Average / Mem utilization and Netscaler CPU and session trends, and it worked perfectly. Until...

I went through the walk through to create new graphs for each of the Netscaler "Virtual Servers" - the services that are routed through the Netscaler for Load Balancing and SSL Offloading. What I found is if I have active Data Sources for these services, all of my other data sources for that particular device Fail (the log shows SNMP timeouts, but that is definitely not the case. SNMP queries from the CLI work fine, as do the "verbose queries" from the Devices screen). Here are some attachments.

To me, it sounds like some snmpd issue on that netscaler device. Personally, we were using some other device that got too busy when querying for loads of data via snmp. The snmpd was not that highly in priority (which, normally, is not a too bad idea). You may want to check CPU usage on the netscaler. But it may occur that you won't see anything, e.g. if there's a OS defined boundary for snmpd usage ...
Reinhard

tekbot · Post by **tekbot** » Thu Jul 20, 2006 2:17 pm

lvm -- I appreciate the quick response. I do not believe this to be a resources issue with SNMP, however. You can see from the attached graphs that the device has plenty of CPU available to service the request (it's maxing at ~30%, this problem even exists on the idle High Availability slave unit), and they both respond with immediacy when running the same queries from the CLI. In addition, the verbose queries run optimally from the cacti Devices page. I even tripled the SNMP timeout value (from 500 to 1500) on the off-chance that the devices were taking too long to respond.

I personally think the issue to be with the Regular Expressions I'm using to properly index the Virtual Servers. Please, someone on the board, take a very close look at the code I'm using to parse the OID string to format the indecies properly. If more details are necessary, post your questions, and I'll respond as soon as I can.

Thanks again!
tekbot

Post by **gandalf** » Fri Jul 21, 2006 5:42 am

Would it be ppossible to post an snmpwalk of the index? I was wondering, why your XML regexp catches 7-tupel IP addresses. I would have expected 8-tupels (peer to peer IP addr)? Weird is the fact, that it sometimes seem to work, or did I misunderstood? Would it be possible to tcpdump/ethereal the snmp packets between cacti and the traget in failing situations?
Reinhard

rcaston · Post by **rcaston** » Tue Aug 08, 2006 10:30 am

I hope something can be made to easily graph all the vlans bandwidth soon; we're dying out here for a solutuon.

Post by **gandalf** » Tue Aug 08, 2006 11:21 am

rcaston wrote:I hope something can be made to easily graph all the vlans bandwidth soon; we're dying out here for a solutuon.

This may be worth a seperate post but would need more information about your goals (sorry, personally I don't have access to a netscaler or stuff) and of course about the corresponding OIDs. A quick read at the last link of my signature may help as well.
Reinhard

rcaston · Post by **rcaston** » Fri Aug 18, 2006 1:40 pm

Gotcha... We'll continue to work on it then.

scotdmcd · Post by **scotdmcd** » Mon Nov 06, 2006 2:38 pm

Could someone post a graph of the completed serviceTable? Thanks.

Cacti

Templating possible?

mike...

Solution

New Issues with Custom Templates

Re: New Issues with Custom Templates

Iron Mike - I'll pay ya :)

Re: Iron Mike - I'll pay ya :)

lvm;

Who is online