SNMP - Interface Statistics - Will not list them.

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

Post Reply
alcedema
Posts: 8
Joined: Mon Nov 05, 2007 6:25 am

SNMP - Interface Statistics - Will not list them.

Post by alcedema »

Hi, weird problem and cannot yet find the solution. I have been searching the forums and have tried different things to no avail.

When a device is set as a ucd/net snmp host all is well when you edit the host. All data queries are successful and debugging them shows all of the correct snmp info.

But when I go to create a new graph for that device, the SNMp interface data query comes back with:

Code: Select all

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.
I run it in debug mode and as I said before, it shows everything:

Code: Select all

Data Query Debug Information 
 
+ Running data query [1].
+ Found type = '3' [snmp query].
+ Found data query XML file at '/var/www/cacti/resource/snmp_queries/interface.xml'
+ XML file parsed ok.
+ Executing SNMP walk for list of indexes @ '.1.3.6.1.2.1.2.2.1.1'
+ 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]
+ Found item [ifIndex='5'] index: 5 [from value]
+ Found item [ifIndex='6'] index: 6 [from value]
+ Found item [ifIndex='7'] index: 7 [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='Up'] index: 1 [from value]
+ Found item [ifOperStatus='Down'] index: 2 [from value]
+ Found item [ifOperStatus='Up'] index: 3 [from value]
+ Found item [ifOperStatus='Up'] index: 4 [from value]
+ Found item [ifOperStatus='Down'] index: 5 [from value]
+ Found item [ifOperStatus='Up'] index: 6 [from value]
+ Found item [ifOperStatus='Up'] index: 7 [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='lo'] index: 1 [from value]
+ Found item [ifDescr='__tmp2063704620'] index: 2 [from value]
+ Found item [ifDescr='eth1'] index: 3 [from value]
+ Found item [ifDescr='eth0'] index: 4 [from value]
+ Found item [ifDescr='sit0'] index: 5 [from value]
+ Found item [ifDescr='bond0'] index: 6 [from value]
+ Found item [ifDescr='ham0'] index: 7 [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='lo'] index: 1 [from value]
+ Found item [ifName='__tmp2063704620'] index: 2 [from value]
+ Found item [ifName='eth1'] index: 3 [from value]
+ Found item [ifName='eth0'] index: 4 [from value]
+ Found item [ifName='sit0'] index: 5 [from value]
+ Found item [ifName='bond0'] index: 6 [from value]
+ Found item [ifName='ham0'] index: 7 [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=''] index: 2 [from value]
+ Found item [ifAlias=''] index: 3 [from value]
+ Found item [ifAlias=''] index: 4 [from value]
+ Found item [ifAlias=''] index: 5 [from value]
+ Found item [ifAlias=''] index: 6 [from value]
+ Found item [ifAlias=''] index: 7 [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='softwareLoopback(24)'] 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='ethernetCsmacd(6)'] index: 4 [from value]
+ Found item [ifType='tunnel(131)'] index: 5 [from value]
+ Found item [ifType='ethernetCsmacd(6)'] index: 6 [from value]
+ Found item [ifType='ethernetCsmacd(6)'] index: 7 [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='100000000'] index: 2 [from value]
+ Found item [ifSpeed='100000000'] index: 3 [from value]
+ Found item [ifSpeed='100000000'] index: 4 [from value]
+ Found item [ifSpeed='0'] index: 5 [from value]
+ Found item [ifSpeed='10000000'] index: 6 [from value]
+ Found item [ifSpeed='10000000'] index: 7 [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=''] index: 1 [from value]
+ Found item [ifHwAddr='00:00:E0:81:xx:07:E6'] index: 2 [from value]
+ Found item [ifHwAddr='00:00:E0:81:xx:07:E7'] index: 3 [from value]
+ Found item [ifHwAddr='00:00:E0:81:xx:07:E8'] index: 4 [from value]
+ Found item [ifHwAddr=''] index: 5 [from value]
+ Found item [ifHwAddr='00:00:E0:81:xx:07:E7'] index: 6 [from value]
+ Found item [ifHwAddr='00:36:F7:28:xx:65:CA'] index: 7 [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='xx.xx.xx.xx'] index: 7 [from regexp oid parse]
+ Found item [ifIP='xx.xx.xx.xx'] index: 4 [from regexp oid parse]
+ Found item [ifIP='xx.xx.xx.xx' index: 1 [from regexp oid parse]
+ Found item [ifIP='xx.xx.xx.xx'] index: 6 [from regexp oid parse]
+ Found data query XML file at '/var/www/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at '/var/www/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at '/var/www/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at '/var/www/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at '/var/www/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at '/var/www/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at '/var/www/cacti/resource/snmp_queries/interface.xml'
This is happening to all devices. After I installed cacti, I was able to get the list of interfaces and it is currently graphing without problems the interfaces that I had selected. But I am now unable to see any interfaces.
Last edited by alcedema on Mon Nov 05, 2007 6:38 am, edited 1 time in total.
Top
alcedema
Posts: 8
Joined: Mon Nov 05, 2007 6:25 am

Post by alcedema »

I have tried re-building the poller cache (using spine). I have tried going to the mysql directory and running 'myisamchk -r host_snmp_cache' but also nothing.

I am using cacti 0.8.7 with the same spine version. I did install the plugin architecture, but the problem was apparent before that.

All other queries are running and showing up fine.
Top
alcedema
Posts: 8
Joined: Mon Nov 05, 2007 6:25 am

Post by alcedema »

Just to clarify, when editing the host and even without running them in debug mode, the data queries seem fine:

Code: Select all

1) SNMP - Interface Statistics  (Verbose Query)  Uptime Goes Backwards  Success [60 Items, 7 Rows]      
2) ucd/net - Get Monitored Partitions  (Verbose Query)  Uptime Goes Backwards  Success [3 Items, 1 Row]
But when you click to create graphs for that host, the data query (only for interfaces) says that there were 0 rows returned.
Top
User avatar
TheWitness
Developer
Posts: 17007
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:
Contact TheWitness

Post by TheWitness »

There is a patch for this in SVN I am pretty sure. If you review your log, you will find the SQL error, or in your Apache error_log. Please confirm.

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages

For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Top
alcedema
Posts: 8
Joined: Mon Nov 05, 2007 6:25 am

Post by alcedema »

Can't find any error in apache or cacti logs. I restarted the mysql server and now *all* data queries on that page show 0 rows, not just the SNMP interface one.

At one point yesterday, the interface data quiery on that page started working again. For no apparent reason. Then after a while it went back to this.
Top
alcedema
Posts: 8
Joined: Mon Nov 05, 2007 6:25 am

Post by alcedema »

Added rev 4282 to graphs_new.php but still the same.
Top
alcedema
Posts: 8
Joined: Mon Nov 05, 2007 6:25 am

Post by alcedema »

Decided to reinstall Cacti and the Mysql tables. Was able to add a few machines and the interface graphs before it mucked up again.
Top
alcedema
Posts: 8
Joined: Mon Nov 05, 2007 6:25 am

Post by alcedema »

Reinstalled again, kept the poller disabled. Added machines one by one and the one that caused the problems was the Switch. After adding it (as Cisco Router template) and it's interfaces as bits/s in/out and some as 95th I can no longer see the data query for any machine except for that switch.
Top
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Contact gandalf

Post by gandalf »

Is the failing one the same you've sent the above DEBUG output from? Can you please post an snmpwalk for interfaces? The "___tmp*" interface is worrying me
Reinhard
Top
ddbrooks
Posts: 1
Joined: Fri May 19, 2006 11:19 am
Contact:
Contact ddbrooks

Post by ddbrooks »

I rolled my graphs_new.php back to version 8.6j to get my cacti install working. Same issue that was posted in this thread
Top
ashfieldm
Posts: 25
Joined: Tue Oct 11, 2005 8:47 am

Post by ashfieldm »

I'm having the same problem. Has there been any solution yet?
Top
Steve Ollis
Posts: 26
Joined: Thu Jan 19, 2006 10:07 pm

Post by Steve Ollis »

Hi,

I've just started having the same issue.

Steve
Last edited by Steve Ollis on Wed Dec 19, 2007 10:23 pm, edited 1 time in total.
Top
ashfieldm
Posts: 25
Joined: Tue Oct 11, 2005 8:47 am

Post by ashfieldm »

ddbrooks wrote:I rolled my graphs_new.php back to version 8.6j to get my cacti install working. Same issue that was posted in this thread
I did the same thing and got it working.
Top
nihkiruks
Posts: 4
Joined: Thu Nov 02, 2006 10:27 am
Contact:
Contact nihkiruks

Post by nihkiruks »

Reverted graph_new.php to 0.8.6k and it solved the issue, however, that's not the best way...
Top
nihkiruks
Posts: 4
Joined: Thu Nov 02, 2006 10:27 am
Contact:
Contact nihkiruks

Post by nihkiruks »

Well, it doesn't :(

It sees the interfaces, but when I'm creating graphs - no datasources created, and the graphs are not generated. Please advise...

Sergey
Top
Post Reply

Return to “Help: General”

Who is online

Users browsing this forum: No registered users and 1 guest