Cannot graph interface statistics

[vnkhwazi]

Hello guys.

I installed Cacti on red hat enterprise, and it was working ok, then i noticed that whenever i want to add new devices or need to add more graphs for a certain device am unable to because Cacti does not show the Interfaces instead i get the following message

"This data query returned 0 rows, perhaps there was a problem executing this data query. You can run this data query in debug mode to get more information."

When i run the data query in debug mode, every thing looks ok, below is the output of debug mode

+ Running data query [1].
+ Found type = '3' [SNMP Query].
+ Found data query XML file at '/var/www/html/cacti/resource/snmp_queries/interface.xml'
+ XML file parsed ok.
+ Executing SNMP get for num of indexes @ '.1.3.6.1.2.1.2.1.0' Index Count: 4
+ Executing SNMP walk for list of indexes @ '.1.3.6.1.2.1.2.2.1.1' Index Count: 4
+ Index found at OID: '1.3.6.1.2.1.2.2.1.1.1' value: '1'
+ Index found at OID: '1.3.6.1.2.1.2.2.1.1.2' value: '2'
+ Index found at OID: '1.3.6.1.2.1.2.2.1.1.3' value: '3'
+ Index found at OID: '1.3.6.1.2.1.2.2.1.1.4' value: '4'
+ Located input field 'ifIndex' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.2.2.1.1'
+ Found item [ifIndex='1'] index: 1 [from value]
+ Found item [ifIndex='2'] index: 2 [from value]
+ Found item [ifIndex='3'] index: 3 [from value]
+ Found item [ifIndex='4'] index: 4 [from value]
+ Located input field 'ifOperStatus' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.2.2.1.8'
+ Found item [ifOperStatus='Down'] index: 1 [from value]
+ Found item [ifOperStatus='Up'] index: 2 [from value]
+ Found item [ifOperStatus='Up'] index: 3 [from value]
+ Found item [ifOperStatus='Up'] index: 4 [from value]
+ Located input field 'ifDescr' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.2.2.1.2'
+ Found item [ifDescr='Embedded-Service-Engine0/0'] index: 1 [from value]
+ Found item [ifDescr='GigabitEthernet0/0'] index: 2 [from value]
+ Found item [ifDescr='GigabitEthernet0/1'] index: 3 [from value]
+ Found item [ifDescr='Null0'] index: 4 [from value]
+ Located input field 'ifName' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.31.1.1.1.1'
+ Found item [ifName='Em0/0'] index: 1 [from value]
+ Found item [ifName='Gi0/0'] index: 2 [from value]
+ Found item [ifName='Gi0/1'] index: 3 [from value]
+ Found item [ifName='Nu0'] index: 4 [from value]
+ Located input field 'ifAlias' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.31.1.1.1.18'
+ Found item [ifAlias=''] index: 1 [from value]
+ Found item [ifAlias='CONNECTED TO BLANTYRE PEOPLES SHOP LAN'] index: 2 [from value]
+ Found item [ifAlias='CONNECTING TO BLANTYRE TEC'] index: 3 [from value]
+ Found item [ifAlias=''] index: 4 [from value]
+ Located input field 'ifType' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.2.2.1.3'
+ Found item [ifType='ethernetCsmacd(6)'] index: 1 [from value]
+ Found item [ifType='ethernetCsmacd(6)'] index: 2 [from value]
+ Found item [ifType='ethernetCsmacd(6)'] index: 3 [from value]
+ Found item [ifType='other(1)'] index: 4 [from value]
+ Located input field 'ifSpeed' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.2.2.1.5'
+ Found item [ifSpeed='10000000'] index: 1 [from value]
+ Found item [ifSpeed='1000000000'] index: 2 [from value]
+ Found item [ifSpeed='2000000'] index: 3 [from value]
+ Found item [ifSpeed='4294967295'] index: 4 [from value]
+ Located input field 'ifHighSpeed' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.31.1.1.1.15'
+ Found item [ifHighSpeed='10'] index: 1 [from value]
+ Found item [ifHighSpeed='1000'] index: 2 [from value]
+ Found item [ifHighSpeed='2'] index: 3 [from value]
+ Found item [ifHighSpeed='10000'] index: 4 [from value]
+ Located input field 'ifHwAddr' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.2.2.1.6'
+ Found item [ifHwAddr='00:00:00:00:00:00'] index: 1 [from value]
+ Found item [ifHwAddr='B8:38:61:83:EC:80'] index: 2 [from value]
+ Found item [ifHwAddr='B8:38:61:83:EC:81'] index: 3 [from value]
+ Found item [ifHwAddr=''] index: 4 [from value]
+ Located input field 'ifIP' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.2.1.4.20.1.2'
+ Found item [ifIP='172.16.254.5'] index: 3 [from regexp oid parse]
+ Found item [ifIP='192.168.129.99'] index: 2 [from regexp oid parse]


Under "Associated Data queries" it gives me a status of "Success [0 Items, 0 Rows]"

what is happening here, can someone please help?

[sg8]

Is this the case for all devices or just some type?? For example when i try to add some Ericsson/Alcatel/Siemens devices due to vendor restrictions Cacti (or any other monitoring software) cannot get interface list

[vnkhwazi]

This is happening for all device types, i have Cisco routers, Cisco Switches, Windows machines, and AXIS IP cameras, all are doing the same thing.

[sg8]

Hi,

so it's every device..i have the same scenario but with Cisco Env script. I just click on the reload icon and everything is working fine (reload on the create new graphs page). If this doesnt help you try to replace some cacti files with older versions and see if that would help