Cacti not retrieving some fields of the ifXTable and ifTable for one device

[jmmcg]

I have encountered an issue where my instance of Cacti is not collecting ifDescr and ifName values for a single host. This host is like several others that I have which seem to work correctly(same model, same firmware version). When I perform a Verbose Query, I get the following output for ifName:

Code: Select all

Total: 2.340000, Delta: 0.000000, Located input field 'ifName' [walk]
Total: 4.340000, Delta: 2.000000, Executing SNMP walk for data @ '.1.3.6.1.2.1.31.1.1.1.1'

and there it stops. ifDescr looks similar.

I am able to walk the table using snmpwalk from the CLI on the server and see values for these fields. I have tried what I can think of (see below), but nothing appears to have made a difference. Does anyone have any thoughts on what I could check or try next?

Thank you


Details:
Cacti Version: 1.2.27
Has been running for about 3 months
OS: Rocky 9.4
PHP: 8.0.30
Device: Calix AXOS E7


What I have tried:
1. Removing the query and adding it again
2. Running the Data Query in debug mode
3. Re-Indexing the device
4. Repopulating the poller cache
5. Adding another "device" pointed at the same host

[macan]

enable debug for that device and show relevant part of the log

[jmmcg]

Hello macan.

Here are the parts I think are relevant. I didn't do the full output as there are over 500 entries in the table for this device.

Code: Select all

Data Query Debug Information 
Total: 0.000000, Delta: 0.000000, Found data query XML file at '/usr/share/cacti/resource/snmp_queries/interface.xml'
Total: 0.000000, Delta: 0.000000, Running Data Query [1].
Total: 0.000000, Delta: 0.000000, Found Type = '3' [SNMP Query].
Total: 0.000000, Delta: 0.000000, XML file parsed ok.
Total: 0.000000, Delta: 0.000000, Bulk Walk Size is fixed at 60.
Total: 0.090000, Delta: 0.090000, Executing SNMP get for num of indexes @ '.1.3.6.1.2.1.2.1.0' Index Count: 523
Total: 0.090000, Delta: 0.000000, Executing SNMP walk for list of indexes @ '.1.3.6.1.2.1.2.2.1.1' Index Count: 523
Total: 0.090000, Delta: 0.000000, Index found at OID: '.1.3.6.1.2.1.2.2.1.1.1000065' value: '1000065'
Total: 0.090000, Delta: 0.000000, Index found at OID: '.1.3.6.1.2.1.2.2.1.1.1000097' value: '1000097'
Total: 0.090000, Delta: 0.000000, Index found at OID: '.1.3.6.1.2.1.2.2.1.1.1000129' value: '1000129'
Total: 0.090000, Delta: 0.000000, Index found at OID: '.1.3.6.1.2.1.2.2.1.1.1000161' value: '1000161'
Total: 0.090000, Delta: 0.000000, Index found at OID: '.1.3.6.1.2.1.2.2.1.1.1000193' value: '1000193'
Total: 0.090000, Delta: 0.000000, Index found at OID: '.1.3.6.1.2.1.2.2.1.1.1000194' value: '1000194'
Total: 0.090000, Delta: 0.000000, Index found at OID: '.1.3.6.1.2.1.2.2.1.1.1000195' value: '1000195'
Total: 0.090000, Delta: 0.000000, Index found at OID: '.1.3.6.1.2.1.2.2.1.1.1000196' value: '1000196'
Total: 0.090000, Delta: 0.000000, Index found at OID: '.1.3.6.1.2.1.2.2.1.1.1000257' value: '1000257'
...
Click to show Data Query output for field 'ifDescr'
Total: 0.370000, Delta: 0.010000, Located input field 'ifDescr' [walk]
Total: 2.370000, Delta: 2.000000, Executing SNMP walk for data @ '.1.3.6.1.2.1.2.2.1.2'
Click to show Data Query output for field 'ifName'
Total: 2.370000, Delta: 0.000000, Located input field 'ifName' [walk]
Total: 4.370000, Delta: 2.000000, Executing SNMP walk for data @ '.1.3.6.1.2.1.31.1.1.1.1'
Click to show Data Query output for field 'ifAlias'
Total: 4.370000, Delta: 0.000000, Located input field 'ifAlias' [walk]
Total: 4.760000, Delta: 0.390000, Executing SNMP walk for data @ '.1.3.6.1.2.1.31.1.1.1.18'
Found item [ifAlias=''] index: 1000065 [from value]
Found item [ifAlias=''] index: 1000097 [from value]
Found item [ifAlias=''] index: 1000129 [from value]
Found item [ifAlias=''] index: 1000161 [from value]
Found item [ifAlias=''] index: 1000193 [from value]
Found item [ifAlias=''] index: 1000194 [from value]
Found item [ifAlias=''] index: 1000195 [from value]
Found item [ifAlias=''] index: 1000196 [from value]
Found item [ifAlias=''] index: 1000257 [from value]
Found item [ifAlias=''] index: 1000289 [from value]
Found item [ifAlias=''] index: 1000321 [from value]
Found item [ifAlias=''] index: 1000353 [from value]
Found item [ifAlias=''] index: 1000385 [from value]
Found item [ifAlias=''] index: 1000417 [from value]
Found item [ifAlias=''] index: 1000449 [from value]
Found item [ifAlias=''] index: 1000481 [from value]
Found item [ifAlias=''] index: 1000513 [from value]
Found item [ifAlias=''] index: 1000545 [from value]
Found item [ifAlias=''] index: 1000577 [from value]
...

[macan]

try snmpwalk from your cacti host
snmpwalk -v2c -c your_community de.vi.ce.ip .1.3.6.1.2.1.2.2.1.2

snmpwalk -v2c -c your_community de.vi.ce.ip .1.3.6.1.2.1.31.1.1.1.1

Show several lines that are returned.

[jmmcg]

Here we are:

Code: Select all

snmpwalk -v2c -cCOMMUNITY DEVICE_ADDRESS .1.3.6.1.2.1.2.2.1.2
IF-MIB::ifDescr.1000065 = STRING: 6329/g1
IF-MIB::ifDescr.1000097 = STRING: 6293/g1
IF-MIB::ifDescr.1000129 = STRING: 6292/g1
IF-MIB::ifDescr.1000161 = STRING: 6294/g1
IF-MIB::ifDescr.1000193 = STRING: 6311/g1
IF-MIB::ifDescr.1000194 = STRING: 6311/g2
IF-MIB::ifDescr.1000195 = STRING: 6311/g3
IF-MIB::ifDescr.1000196 = STRING: 6311/g4
IF-MIB::ifDescr.1000257 = STRING: 6312/g1
IF-MIB::ifDescr.1000289 = STRING: 5288/g1
IF-MIB::ifDescr.1000321 = STRING: 6296/g1
IF-MIB::ifDescr.1000353 = STRING: 6297/g1
IF-MIB::ifDescr.1000385 = STRING: 6313/g1
IF-MIB::ifDescr.1000417 = STRING: 6316/g1
IF-MIB::ifDescr.1000449 = STRING: 6343/g1
IF-MIB::ifDescr.1000481 = STRING: 6314/g1
IF-MIB::ifDescr.1000513 = STRING: 6364/g1
IF-MIB::ifDescr.1000545 = STRING: 6359/g1
IF-MIB::ifDescr.1000577 = STRING: 6356/g1
IF-MIB::ifDescr.1000609 = STRING: 6358/g1

Code: Select all

snmpwalk -v2c -cCOMMUNITY DEVICE_ADDRESS .1.3.6.1.2.1.31.1.1.1.1
IF-MIB::ifName.1000065 = STRING: 6329/g1
IF-MIB::ifName.1000097 = STRING: 6293/g1
IF-MIB::ifName.1000129 = STRING: 6292/g1
IF-MIB::ifName.1000161 = STRING: 6294/g1
IF-MIB::ifName.1000193 = STRING: 6311/g1
IF-MIB::ifName.1000194 = STRING: 6311/g2
IF-MIB::ifName.1000195 = STRING: 6311/g3
IF-MIB::ifName.1000196 = STRING: 6311/g4
IF-MIB::ifName.1000257 = STRING: 6312/g1
IF-MIB::ifName.1000289 = STRING: 5288/g1
IF-MIB::ifName.1000321 = STRING: 6296/g1
IF-MIB::ifName.1000353 = STRING: 6297/g1
IF-MIB::ifName.1000385 = STRING: 6313/g1
IF-MIB::ifName.1000417 = STRING: 6316/g1
IF-MIB::ifName.1000449 = STRING: 6343/g1
IF-MIB::ifName.1000481 = STRING: 6314/g1

[macan]

ok, device returns correct data.
Console -> Management -> Devices -> your_problematic_device -> Create graphs for this device -> Data Query [SNMP - Interface Statistics] is without descriptions and names?

Other devices have similar description with char "/"?

Try:
Management -> data sources -> choose your problematic device -> select all -> Reapply suggested names
The same for management -> graphs

[jmmcg]

That is correct. The columns do not even show up on the Create Graphs page. The other devices like this have the / char in both their names and descriptions.

Doing a reapply suggested names gives all graphs the name "nwt00ts02 - Traffic (traffic_in)"

Do you know of any characters that would cause problems for Cacti if they were to appear in the alias or name fields?

[macan]

There was any problem with problematic chars in description but it was solved few version before. I will not your problem.

[jmmcg]

Thank you for taking the time to look into this. Do you have any thoughts on where I might go for help or possible workarounds?

[macan]

you can try change Max. OIDs per request and bulk walk maximum repetitions. Both are on device edit page
Try again Verbose query and show ifDescr. Have you here something like:
Total: 1.010000, Delta: 0.000000, Located input field 'ifDescr' [walk]
Total: 1.250000, Delta: 0.240000, Executing SNMP walk for data @ '.1.3.6.1.2.1.2.2.1.2'
Found item [ifDescr='GigabitEthernet1/0/1'] index: 1 [from value]
Found item [ifDescr='GigabitEthernet1/0/2'] index: 2 [from value]
Found item [ifDescr='GigabitEthernet1/0/3'] index: 3 [from value]
Found item [ifDescr='GigabitEthernet1/0/4'] index: 4 [from value]
Found item [ifDescr='GigabitEthernet1/0/5'] index: 5 [from value]
Found item [ifDescr='GigabitEthernet1/0/6'] index: 6 [from value]

[jmmcg]

Changing the Bulk Walk Max Repetitions from Auto-Detect on re-index to 10 caused the data to populate. Data sources and graphs now get the appropriate names. I selected 10 randomly.

I appreciate the time you took to help me with this.