RRD file not being created

[fdh]

Hello,

I'm trying to set up SquidStats, basically SNMP is working correctly, the only problem I have: The RR Database is not being created. It's not a permission problem, the poller script just doesn't mention the graph I'm trying to create in any way:

--------------
06/24/2006 01:32:05 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /var/www/localhost/htdocs/cacti/cmd.php 0 6]
Waiting on 1/1 pollers.
06/24/2006 01:32:06 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/localhost/htdocs/cacti/rra/localhost_mem_buffers_3.rrd --template mem_buffers 1151148726:88300
06/24/2006 01:32:06 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/localhost/htdocs/cacti/rra/localhost_mem_swap_4.rrd --template mem_swap 1151148726:1424724
OK u:0.01 s:0.00 r:0.01
OK u:0.01 s:0.00 r:0.01
Waiting on 1/1 pollers.
06/24/2006 01:32:07 PM - POLLER: Poller[0] Parsed MULTI output field '1min:2.14' [map 1min->load_1min]
06/24/2006 01:32:07 PM - POLLER: Poller[0] Parsed MULTI output field '5min:2.25' [map 5min->load_5min]
06/24/2006 01:32:07 PM - POLLER: Poller[0] Parsed MULTI output field '10min:2.20' [map 10min->load_15min]
06/24/2006 01:32:07 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/localhost/htdocs/cacti/rra/localhost_load_1min_5.rrd --template load_1min:load_5min:load_15min 1151148726:2.14:2.25:2.20
06/24/2006 01:32:07 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/localhost/htdocs/cacti/rra/localhost_users_6.rrd --template users 1151148726:8
06/24/2006 01:32:07 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/localhost/htdocs/cacti/rra/localhost_proc_7.rrd --template proc 1151148726:182
06/24/2006 01:32:07 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/localhost/htdocs/cacti/rra/localhost_ping_8.rrd --template ping 1151148726:0.133
06/24/2006 01:32:07 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/localhost/htdocs/cacti/rra/localhost_snmp_snmp_oid_9.rrd --template snmp_oid 1151148726:U
06/24/2006 01:32:07 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/localhost/htdocs/cacti/rra/localhost_snmp_traffic_in_10.rrd --template traffic_out:traffic_in 1151148726:3228827:2772254
06/24/2006 01:32:07 PM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/localhost/htdocs/cacti/rra/localhost_snmp_traffic_in_11.rrd --template traffic_out:traffic_in 1151148726:4650005:68567989
OK u:0.01 s:0.01 r:1.04
OK u:0.01 s:0.01 r:1.04
OK u:0.01 s:0.01 r:1.04
OK u:0.01 s:0.01 r:1.04
OK u:0.01 s:0.01 r:1.04
OK u:0.01 s:0.01 r:1.04
OK u:0.01 s:0.01 r:1.05
06/24/2006 01:32:08 PM - SYSTEM STATS: Time:3.0953 Method:cmd.php Processes:1 Threads:N/A Hosts:4 HostsPerProcess:4 DataSources:11 RRDsProcessed:9
06/24/2006 01:32:08 PM - POLLER: Poller[0] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: -q /var/www/localhost/htdocs/cacti/poller_export.php]
--------------

The graph management window says: "ERROR: opening '/var/www/localhost/htdocs/cacti/rra/squid_squid_httpoutkb_23.rrd': No such file or directory".

I think it's because the device I set up says "SNMP error" but the snmp data is still being gathered correctly from my squid.

Is there any way to convince the poller script to take care of the creation of the rrd file even with an "SNMP error" in the device?

Thanks in advance,
fdh

[rony]

If the device is considered down, no data will be collected, so, no file will be created. Figure out why you are having SNMP issues and everything will work fine.

Btw, if you have an SNMP problem, even if the files where created, you wouldn't have any data.

[fdh]

Hi,

As I said, I don't have an SNMP problem, the squid SNMP just doesn't offer the general SNMP data, but the squid statistic counters itself work. The SNMP error is even mentioned in the SquidStats readme, so again, how can I convince the poller script to take care of the creation of the rrd file even with an "SNMP error" in the device?

Update:

Ok, I proxied my SNMP Daemon through squid and I get no more SNMP errors, but the file is still not being created:

----
RRDTool Command:

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Obelix - Squid - Squid Traffic In / Out / Saved" \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=-100 \
--vertical-label="bits / s" \
--slope-mode \
DEF:a="/var/www/localhost/htdocs/cacti/rra/obelix_squid_squid_httpoutkb_28.rrd":squid_serverInKb:AVERAGE \
DEF:b="/var/www/localhost/htdocs/cacti/rra/obelix_squid_squid_httpoutkb_28.rrd":squid_httpOutKb:AVERAGE \
CDEF:cdefa=a,1024,*,8,* \
CDEF:cdefe=b,1024,*,8,* \
CDEF:cdefi=b,a,LT,0,a,b,-,IF,1024,*,8,* \
AREA:cdefa#00CF00:"Traffic In\:" \
GPRINT:cdefa:LAST:" Current\:%8.2lf %s" \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf %s\n" \
LINE1:cdefe#4444FF:"Traffic Out\:" \
GPRINT:cdefe:LAST:" Current\:%8.2lf %s" \
GPRINT:cdefe:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefe:MAX:"Maximum\:%8.2lf %s\n" \
AREA:cdefi#FF0000:"Traffic Savings\:" \
GPRINT:cdefi:LAST:"Current\:%8.2lf %s" \
GPRINT:cdefi:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefi:MIN:"Maximum\:%8.2lf %s\n" \
COMMENT:" Represents the traffic incoming and outgoing in bits per second\n" \
COMMENT:" with the red area (negative) showing the bits/s savings through caching\n" \
COMMENT:" SquidStats v0.1 - Rolf Poser\n"

RRDTool Says:

ERROR: opening '/var/www/localhost/htdocs/cacti/rra/obelix_squid_squid_httpoutkb_28.rrd': No such file or directory

----

Thanks in advance

[gandalf]

The squid thingy is a bit tricky because of port 3401 for squid snmp. So please report
1. snmp port defined within cacti used for the target host (e.g. 161 or 3401)
2. snmpd.conf of the target host, only the part related to snmp port proxying for squid (NO security info, please)
3. an snmpwalk performed from cacti host's command line against the squid OID using the snmp port defined in step 1
Reinhard