Cacti not creating Cisco Router interface graphs

[mattgoli]

Greetings,

Been using Cacti 0.8.6c for a little over a month now running on Mac OS 10.3.6 and everything is working very well. I've started setting up all my border internet routers in our organization, and I'm struggling with two Cisco 1721 routers getting their interface graphs to be created. I am polling the data with SNMP using the "SNMP - Interface Statistics" data query which works on a number of other routers. I can successfully do an snmpwalk of the router from my cacti server, however it seems a little sluggish. Also, when I setup the device within Cacti, I had to set the SNMP timeout to 1500 in order for Cacti to poll the "SNMP Information" section at the top of the device configuration page. To make this shorter, I can succesfully create the graphs within Cacti, but the graphs only show a broken image on the graph view. And then within Graph Management on that host, debug reports "ERROR: opening '/usr/local/cacti-0.8.6c/rra/ma2_border_router_traffic_in_499.rrd': No such file or directory" So I feel that it's not writing the rrd file, which it isn't. How can I go about determining why Cacti is not writing the rrd file? Any feedback is appreciated.

Thanks,

Matt.

[aliencoder]

I am having the same problem, I would like to add that when I try to add the interface, I get the following error
ERROR: invalid rpn expression 'a,8,*'
Could it be that the router has old software?

When selecting this for graph template:
Interface - (Traffi ....... )

Hope that helps with finding out the problem

[mattgoli]

Actually, I'm not seeing that problem with adding the interface. I can successfully add the interface if I bump up the SNMP timeout, and the router is running version 12.3(13), which I recently upgraded to current version.

[TheWitness]

aliencoder,

Your issue is likely a missing DS in your RRD Graph syntax. You should goto Data Sources and edit the Data Source in question and perform a Debug. Post the results.

TheWitness

[aliencoder]

Hi TheWitness & everyone
The problem is that this file doesn't exist, it was not creted?

/usr/bin/rrdtool create \
/var/www/adm.sohonet.hu/pana/cacti/site/rra/cisco_1720_traffic_in_27.rrd \
--step 300 \
DS:traffic_out:COUNTER:600:0:100000000 \
DS:traffic_in:COUNTER:600:0:100000000 \
DS:traffic_out:COUNTER:600:0:100000000 \
DS:traffic_in:COUNTER:600:0:100000000 \
RRA:AVERAGE:0.5:1:600 \
RRA:AVERAGE:0.5:6:700 \
RRA:AVERAGE:0.5:24:775 \
RRA:AVERAGE:0.5:288:797 \
RRA:MAX:0.5:1:600 \
RRA:MAX:0.5:6:700 \
RRA:MAX:0.5:24:775 \
RRA:MAX:0.5:288:797 \

mattgoli: I am new to Cisco routers, and I would like to know how to perform the upgrade, I am running Version 12 now Thanks

[rony]

You have the famious cacti bug, Duplicate DS.

Check out http://forums.cacti.net/viewtopic.php?t=6773, it has you answers to fix it.

[aliencoder]

Ok, even after applying the fix, I get this when trying to graph

RRDTool Says:

ERROR: opening '/var/www/adm.sohonet.hu/pana/cacti/site/rra/cisco_1720_traffic_in_47.rrd': No such file or directory

There seems to be some kind of permissions problem, I just can't ping point where, I followed all the directions. And on local host things seem to be working fine, and I get the CPU usage from the Cisco too.

[mattgoli]

I checked for the duplicate data source within the Interface - Traffic template and the DS issue was not there. The thing that I'm seeing is this is only happening with a couple of routers on our network, so it wouldn't make sense to me that it was an issue with the template.

Below is my DS Debug for one of the interfaces in question:

Data Source Debug
/usr/local/bin/rrdtool create \
/usr/local/cacti-0.8.6c/rra/ma2_border_router_traffic_in_500.rrd \
--step 300 \
DS:traffic_out:COUNTER:600:0:100000000 \
DS:traffic_in:COUNTER:600:0:100000000 \
RRA:AVERAGE:0.5:1:600 \
RRA:AVERAGE:0.5:6:700 \
RRA:AVERAGE:0.5:24:775 \
RRA:AVERAGE:0.5:288:797 \
RRA:MAX:0.5:1:600 \
RRA:MAX:0.5:6:700 \
RRA:MAX:0.5:24:775 \
RRA:MAX:0.5:288:797 \
RRA:LAST:0.5:1:600 \
RRA:LAST:0.5:6:700 \
RRA:LAST:0.5:24:775 \
RRA:LAST:0.5:288:797 \
[/img]

[rony]

Aliencoder hijacked you thread... Sorry.....

Um, can you perform and post or email me a walk of a router that is not working?

[aliencoder]

Ok, it's working now, even though in the begining it said it can't find the file, then I removed and re added the device and it worked fine. What data should I post to help mattgoli So I hand him back his post

This is the verbose query for snmp-interface statistics of the Cisco Router:

+ Running data query [1].
+ Found type = '3' [snmp query].
+ Found data query XML file at '/usr/share/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]
+ 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='Up'] index: 2 [from value]
+ Found item [ifOperStatus='Up'] index: 3 [from value]
+ Found item [ifOperStatus='Up'] index: 4 [from value]
+ Found item [ifOperStatus='Up'] index: 5 [from value]
+ Found item [ifOperStatus='Up'] index: 6 [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='FastEthernet0'] index: 1 [from value]
+ Found item [ifDescr='Serial0'] index: 2 [from value]
+ Found item [ifDescr='Serial1'] index: 3 [from value]
+ Found item [ifDescr='Serial2'] index: 4 [from value]
+ Found item [ifDescr='Serial3'] index: 5 [from value]
+ Found item [ifDescr='Null0'] index: 6 [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='Fa0'] index: 1 [from value]
+ Found item [ifName='Se0'] index: 2 [from value]
+ Found item [ifName='Se1'] index: 3 [from value]
+ Found item [ifName='Se2'] index: 4 [from value]
+ Found item [ifName='Se3'] index: 5 [from value]
+ Found item [ifName='Nu0'] index: 6 [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='AH_I_2Mb_Internet'] index: 4 [from value]
+ Found item [ifAlias='AH_II_2Mb_Internet'] index: 5 [from value]
+ Found item [ifAlias=''] index: 6 [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='propPointToPointSerial(22)'] index: 2 [from value]
+ Found item [ifType='propPointToPointSerial(22)'] index: 3 [from value]
+ Found item [ifType='propPointToPointSerial(22)'] index: 4 [from value]
+ Found item [ifType='propPointToPointSerial(22)'] index: 5 [from value]
+ Found item [ifType='other(1)'] index: 6 [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='100000000'] index: 1 [from value]
+ Found item [ifSpeed='2400000'] index: 2 [from value]
+ Found item [ifSpeed='1544000'] index: 3 [from value]
+ Found item [ifSpeed='1544000'] index: 4 [from value]
+ Found item [ifSpeed='1544000'] index: 5 [from value]
+ Found item [ifSpeed='4294967295'] index: 6 [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:02:B9:A5:AD:4D'] index: 1 [from value]
+ Found item [ifHwAddr=''] index: 2 [from value]
+ Found item [ifHwAddr=''] index: 3 [from value]
+ Found item [ifHwAddr=''] index: 4 [from value]
+ Found item [ifHwAddr=''] index: 5 [from value]
+ Found item [ifHwAddr=''] index: 6 [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='82.150.37.1'] index: 1 [from regexp oid parse]
+ Found item [ifIP='82.150.45.206'] index: 4 [from regexp oid parse]
+ Found item [ifIP='82.150.45.210'] index: 5 [from regexp oid parse]
+ Found item [ifIP='212.92.1.185'] index: 3 [from regexp oid parse]
+ Found item [ifIP='212.92.1.189'] index: 2 [from regexp oid parse]
+ Found data query XML file at '/usr/share/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at '/usr/share/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at '/usr/share/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at '/usr/share/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at '/usr/share/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at '/usr/share/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at '/usr/share/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at '/usr/share/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at '/usr/share/cacti/resource/snmp_queries/interface.xml'

[mattgoli]

Ok, well this is what I've found so far and you can tell me if this makes sense. After I began getting page load timeouts when I tried to do a verbose query, I though to resolve that timeout issue that I'd bump the server timeout value in Apache to 60 seconds instead of 30. After I bumped that up, I was able to do a verbose query, and then went in to try and re-create the graphs and I was able to successfully create the graphs and write the rrd files.

[aliencoder]

It's me again, I am still having trouble with other devices I add, I stil get:
No such file or directory

Thought the Cisco now graphs nicely. One thing I noticed the values are a little differnt from what mrtg gets.

What else can I do to try to fix this??