SNMP ifName query for Netgear GSM7224 Gb Switch

[bluesk1d]

I apologize ahead of time for my scripting n00bness!

I am trying to monitor the ports on our Netgear switches however the graphing query can't resolve the interface name as the datasource so no graphs get generated (I am only guessing this is the problem from my deductions below).

When creating the graphs, the Data Query (SNMP - Interface Statistics) successfully IDs the ports on the switch:

Index Status Description Name (IF-MIB) Type Speed Hardware Address

1 Up Unit: 0 Slot: 0 Port: 1 Gigabit - Level 0x72240000 Unit - 0 Slot - 0 Port - 1 gigabitEthernet(117) 1000000000 00:00:0F:B5:4B:A0:65
2 Up Unit: 0 Slot: 0 Port: 2 Gigabit - Level 0x72240000 Unit - 0 Slot - 0 Port - 2 gigabitEthernet(117) 1000000000 00:00:0F:B5:4B:A0:66
Etc.
Etc.

Once the graphs are created and if I look at the properties of them, the inbound and outbound data sources are listed as "Netgear L2 Switch - Traffic - |query_ifName| (traffic_in)" and "Netgear L2 Switch - Traffic - |query_ifName| (traffic_out)" respectively. The datasources of my other devices are specific to the query results of those devices which leads me to believe there is an issue here with the interface query used by the graphing template.

The graph description query is "|host_description| - Traffic - |query_ifName|" and as you can tell from the data source name, it correctly identifies host_description as "Netgear L2 Switch" but for some reason doesnt like query_ifName.

I'm pulling my hair out over this because I don't know enough to be able to fix it!

[gandalf]

Naming for Data Queries is governed by the "Suggested Names" Section.
Please visit the Data Query, select your Graph Template and change the sequence of the object in that very section (or create a new one). The values are checked top to bottom for matches
Don't forget to "Reapply suggested names" from Graph Management
Reinhard

[bluesk1d]

Ah, there it is! Pardon the dumb question but how do I determine what to edit/add to allow the graphing system to see the correct interfaces without messing up anything else that's already working that also uses "SNMP - Interface Statistics" (which is basically everything)? Will it be something specific to Netgear? I tried to make the Suggested values for the graph template match those of the data template (since that works) but it had no effect. I must be missing something simple...

[gandalf]

Did you "Re-apply Suggested Names" for this Graph (visit Graph Management)?
Reinhard

[bluesk1d]

I sure did. I tried that as well as deleting all the graphs and starting over. When I re-apply, no matter what I do, it still applies "|host_description| - Traffic - |query_ifName|" even if I completely remove that graph template. Driving me nuts!

[bluesk1d]

I mean even if I completely remove that graph template from the Suggested values area, not the template itself. I just cant seem to figure out how to tell the graphing system to query the device in the same way that the data query does because that has no problem seeing and distinguishing all the interfaces.

[bluesk1d]

Additionally, WhatsUp Pro has no problem pulling snmp data from all the interfaces of the switch so it isnt something funky with the hardware. Id really rather use Cacti for traffic graphing and analysis though. WhatsUp leaves something to be desired for reporting on such things.

[gandalf]

Well, I'm not sure to understand you perfectly. May you please post some screenshots or elaborate in more detail, how you tried to apply the correct titles?
Basically, the "static" data fetched by the Data Query is shown up in the Data Query Table seen when "Generating Graphs for this Host". Those data is fetched ONLY when re-indexing. The data is stored in MySQL tables.
Next, when generating Graphs, cacti will parse the rules defined under "Suggested Values". While doing so, it will use the CURRENTLY stored MySQL data from above until it finds a full match. If there is no full match, cacti will NOT replace those |query_*| variables. This is done ONLY at creation time (or when Re-apply Suggested Names is chosen).
Find some more hints at the first link of my signature
Reinhard

[bluesk1d]

Do you need more detail/screenshots than I have posted above? If so, what would you like to see? From your last post, it would seem the question is this: If the data query results displayed in the "creating graphs for host" step, are complete and obtained with no problem, why do none of the suggested names properly "resolve" the variables? The issue isnt old data in the DB either. I can create a new device and immediately attempt to create graphs for it using the data query results obtained from the device when it was added and it yeilds the same results.