[XML] SquidStats version 0.1 (cacti 0.8.5 only!!!)

[Frodoger]

a tip in: http://forums.cacti.net/viewtopic.php?t ... hs_new.php
helps:

copy webcache_squid_core.xml and webcache_squid_median.xml to resource/snmp_queries


greetings
Frodoger

[Setarcos]

I just set this up to support a new Squid box and have everything but the Average Stored Object Size and Storage Utilisation graphs working.

When I turn on graph debugging, it looks like something is amiss with these:

RRDTool Command:

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="ICTSAVSC5xPXx02 Prod Proxy (Squid) - Squid Average Stored Object Size" \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bytes / object" \
--slope-mode \
DEF:a="/var/www/html/cacti-0.8.6j/rra/ictsavsc5xpxx02_prod_proxy_squid_squid_sysstorage_5653.rrd":squid_swapMaxSize:AVERAGE \
DEF:b="/var/www/html/cacti-0.8.6j/rra/ictsavsc5xpxx02_prod_proxy_squid_squid_numobjcount_5652.rrd":squid_numObjCount:AVERAGE \
CDEF:cdefa=a,UN,0,a,10000000000,GT,0,a,IF,IF \
CDEF:cdefb=b,UN,0,b,10000000000,GT,0,b,IF,IF \
CDEF:cdefc=cdefb,0,EQ,0,cdefa,1024,*,1024,*,cdefb,/,IF \
CDEF:cdefh=a,0,0,LIMIT \
CDEF:cdefi=b,0,0,LIMIT \
COMMENT:"" \
COMMENT:"" \
AREA:cdefc#DE0056:"Size (Bytes) \:" \
GPRINT:cdefc:LAST:"Current\:%8.2lf %s" \
GPRINT:cdefc:MIN:"Minimum\:%8.2lf %s" \
GPRINT:cdefc:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefc:MAX:"Maximum\:%8.2lf %s\n" \
LINE1:cdefh:"" \
LINE1:cdefi:"" \
COMMENT:" Represents the average size of objects stored in the cache\n" \
COMMENT:" SquidStats v0.1 - Rolf Poser\n"

RRDTool Says:

ERROR: Expected some arguments after 'COMMENT:'

and

RRDTool Command:

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="ICTSAVSC5xPXx02 Prod Proxy (Squid) - Squid Storage Utilisation" \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="% Full" \
--slope-mode \
DEF:a="/var/www/html/cacti-0.8.6j/rra/ictsavsc5xpxx02_prod_proxy_squid_squid_sysstorage_5665.rrd":squid_sysStorage:AVERAGE \
DEF:b="/var/www/html/cacti-0.8.6j/rra/ictsavsc5xpxx02_prod_proxy_squid_squid_sysstorage_5665.rrd":squid_swapMaxSize:AVERAGE \
CDEF:cdefa=a,UN,0,a,10000000000,GT,0,a,IF,IF \
CDEF:cdefb=b,UN,0,b,10000000000,GT,0,b,IF,IF \
CDEF:cdefc=cdefa,0,EQ,0,cdefb,100,*,cdefa,/,1024,/,IF,0,110,LIMIT \
CDEF:cdefh=a,1024,* \
CDEF:cdefi=b,0,0,LIMIT \
CDEF:cdefj=a,0,0,LIMIT \
COMMENT:"" \
COMMENT:"" \
AREA:cdefc#FF7D00:"Util. (%) \:" \
GPRINT:cdefc:LAST:"Current\:%8.2lf %s" \
GPRINT:cdefc:MIN:"Minimum\:%8.2lf %s" \
GPRINT:cdefc:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefc:MAX:"Maximum\:%8.2lf %s\n" \
GPRINT:cdefh:LAST:" Current Storage (bytes) \:%8.2lf %s\n" \
LINE1:cdefi:"" \
LINE1:cdefj:"" \
COMMENT:" Represents the percentage of storage space used\n" \
COMMENT:" SquidStats v0.1 - Rolf Poser\n"

RRDTool Says:

ERROR: Expected some arguments after 'COMMENT:'

Anyone have an idea what is going on with these two? It looks like something with the Graph Template got hosted when the templates were imported (Item #1, #2 on both of the images below), but it's not clear to me how to fix it this late in the day

[Setarcos]

I just set this up to support a new Squid box and have everything but the Average Stored Object Size and Storage Utilisation graphs working.

Anyone have an idea what is going on with these two? It looks like something with the Graph Template got hosted when the templates were imported (Item #1, #2 on both of the images below), but it's not clear to me how to fix it this late in the day

Answered my own question... The Text Format field needed to have a space added for the two Comment lines in the Graph Template or RRDTool complains...

[nexther0]

in original graph Squid Storage Utilisation

Code: Select all

CDEF:cdefc=cdefa,0,EQ,0,cdefb,100,*,cdefa,/,1024,/,IF,0,110,LIMIT \

give wrong results
right results can be obtain if change that CDEF to:

Code: Select all

CDEF:cdefc=cdefa,0,EQ,0,cdefa,100,*,cdefb,/,1024,/,IF,0,110,LIMIT \

[cynicismic]

FYI pretty much all of these templates work out of the box on cacti 0.8.7b with squid 2.5STABLE14 and SNMP proxying

nice one

[incognito]

Hey guys, im using this with Cacti 0.8.7b, RRDTool 1.2 using the snmp proxy method.
All works however ive come across a few weird behalviors...
Looks like some of the CDEF's calculate a bit funky as u go to larger time periods....

Has anyone seen this sorta thing? The blue section is not shown in Hourly (5min) however when you get to Monthly graphs the blue suddenly spikes way out the skope of graph, this gets alot bigger for the year long graph. This happens for Data In/Out/Saved, DNS Stats and as you can see Client request rate.

Ive had a bit of a look at the CDEF's but had no luck. Any suggestions on how to fix this?

Thanks

[TrilceAC]

For those of you (http://forums.cacti.net/viewtopic.php?p=21885#p21885, http://forums.cacti.net/viewtopic.php?p=22187#p22187, http://forums.cacti.net/viewtopic.php?p=24196#p24196, http://forums.cacti.net/viewtopic.php?p=25350#p25350, http://forums.cacti.net/viewtopic.php?p=29984#p29984, http://forums.cacti.net/viewtopic.php?p=55858#p55858) who have problems using cactid as poller and get a device status down error I have found another way to get squid stats working that doesn't require to change snmpd.conf. It's simple, you only have to say cacte that you don't want to to check Availability / Reachability on the device:

Go to the Device page of your squid server. There is a fieldn called Downed Device Detection, set its value to None and save the device configuration.

My explanation about it is the following: It seems to me that the poller ignores the snmp port configuration, thus asking for availability on port 161, which is the snmp standard but not the one used by squid. Hence, it gets host unreachable. I also believe that if the host is unreachable, then the poller doesn't perform the data queries that it had to. In the end, you don't get any rrd file written, since no query has been performed. Avoiding to check availability on the squid host makes cactid not to believe that the host is unreachable, and finally the data queries are performed.

This works for me using cactid and cacti v0.8.7b

I have also posted it here: http://forums.cacti.net/viewtopic.php?p=218003#p218003

Hope it helps,
Carlos

[achoopani]

hi dear
can i install this templates on > Version 0.8.7g ??

help ,me please