Problems with interface stats graphs (no .rrd file created)

[linuxchris]

I am using Cacti to monitor CPU usage on several Cisco routers and it is working fin. I want to replace MRTG with Cacti but I CAN NOT get Cacti to create the graphs for the interface statistics. I have read through several similar issues here on the forum and have already tried all of the fixes (changing permissions, modifying code, etc.). I know SNMP is working ok on the box because the graphs for the CPU's are working just fine. When I click on one of the missing graphs and select the source link I get (with IP's masked to xxx.xxx.xxx.xxx):

/usr/local/rrdtool-1.0.42/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--title="xxx.xxx.xxx.xxx - Traffic - |query_ifName|" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bits per second" \
DEF:a="/var/www/ucm/cacti/rra/xxx_xxx_xxx_xxx_traffic_in_117.rrd":traffic_in:AVERAGE \
DEF:b="/var/www/ucm/cacti/rra/xxx_xxx_xxx_xxx_traffic_in_117.rrd":traffic_out:AVERAGE \
CDEF:cdefa=a,8,* \
CDEF:cdefe=b,8,* \
AREA:cdefa#00CF00:"Inbound" \
GPRINT:cdefa:LAST:" Current\:%8.2lf %s" \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf %s\n" \
LINE1:cdefe#002A97:"Outbound" \
GPRINT:cdefe:LAST:"Current\:%8.2lf %s" \
GPRINT:cdefe:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefe:MAX:"Maximum\:%8.2lf %s"

I have tried to run cmd.php manualy and it seems to run fine but still no graphs. I have tried to run the command above manualy but I get the following error:

ERROR: opening '/var/www/ucm/cacti/rra/xxx_xxx_xxx_xxx_traffic_in_117.rrd': No such file or directory

I have no idea why the file is not created or why rrd does not just create one. The permisions to the directory are set to rwx for all users (until I get this figured out... then Ill try to properly set the permisions).

PLEASE LET ME KNOW IF YOU HAVE ANY IDEAS.

Thank You

[linuxchris]

Dont know if this will help but I have noticed when running cmd.php manually that the IP address of the interface is not being passed:

/var/www/ucm/cacti/cmd.php
command: perl /var/www/ucm/cacti/scripts/linux_memory.pl MemFree:, output: 78452
command: perl /var/www/ucm/cacti/scripts/linux_memory.pl SwapFree:, output: 496636
MUTLI command: perl /var/www/ucm/cacti/scripts/loadavg_multi.pl, output: 1min:0.04 5min:0.07 10min:0.02
MULTI expansion: found fieldid: 17, found rrdname: load_1min, value: 0.04
MULTI expansion: found fieldid: 18, found rrdname: load_5min, value: 0.07
MULTI expansion: found fieldid: 19, found rrdname: load_15min, value: 0.02
command: perl /var/www/ucm/cacti/scripts/unix_users.pl, output: 1
command: perl /var/www/ucm/cacti/scripts/unix_processes.pl, output: 58
snmp: , dsname: sessions, oid: .1.3.6.1.4.1.6213.2.4.1.1.1.0, value:
snmp: xxx.xx.x.xx, dsname: 5min_cpu, oid: .1.3.6.1.4.1.9.9.109.1.1.1.1.5.1, value: 0
snmp: xxx.xxx.xxx.x, dsname: 5min_cpu, oid: .1.3.6.1.4.1.9.9.109.1.1.1.1.5.1, value: 8
snmp: xxx.xxx.xxx.x, dsname: 5min_cpu, oid: .1.3.6.1.4.1.9.9.109.1.1.1.1.5.1, value: 4
snmp: xxx.xx.x.xx, dsname: 5min_cpu, oid: .1.3.6.1.4.1.9.9.109.1.1.1.1.5.1, value: 48
update /var/www/ucm/cacti/rra/localhost_mem_buffers_3.rrd --template mem_buffers N:78452
update /var/www/ucm/cacti/rra/localhost_mem_swap_4.rrd --template mem_swap N:496636
update /var/www/ucm/cacti/rra/localhost_load_1min_5.rrd --template load_1min:load_5min:load_15min N:0.04:0.07:0.02
update /var/www/ucm/cacti/rra/localhost_users_6.rrd --template users N:1
update /var/www/ucm/cacti/rra/localhost_proc_7.rrd --template proc N:58
update /var/www/ucm/cacti/rra/redline_sessions_22.rrd --template sessions N:U
update /var/www/ucm/cacti/rra/cisco_router_5min_cpu_26.rrd --template 5min_cpu N:0
update /var/www/ucm/cacti/rra/att_5min_cpu_31.rrd --template 5min_cpu N:8
update /var/www/ucm/cacti/rra/broadwing_router_5min_cpu_35.rrd --template 5min_cpu N:4
update /var/www/ucm/cacti/rra/172_20_2_16_5min_cpu_91.rrd --template 5min_cpu N:48
time: 2

I hope someone will be able to help me out.

[Coeus]

Hmm...

mysql -u root -p cacti
select management_ip,rrd_name,arg1 from data_input_data_cache where rrd_name like 'traffic_in';

Does this list the rrd name and not the ip address?

Carl

[linuxchris]

Here is what I get:

mysql> select management_ip,rrd_name,arg1 from data_input_data_cache where rrd_name like 'traffic_in';
Empty set (0.00 sec)

mysql>