Graph templates for Squid

[yeahgood]

`

[VaSh1]

Please try attached Host Template. Requires at least cacti-0.8.6i
Reinhard

After importing the template i've got the following errors

Data Query [WebCache - Squid Statistics - Core]
Error in data query.

Data Query [WebCache - Squid Statistics - Median Based]
Error in data query.

I'm using cacti 0.8.7b

Tnx for any help

[paulom]

Hi.

I have also the same problem with squid http-data. Like Hassan1, Bantutin, Lalsacien:

If I Go to "Graph templates" -> "Squid - HTTP Data " and clear the "Unit Grid Value".
ERROR: invalid rpn expression in: ,TIME,1232385129,GT,a,a,UN,0,a,IF,IF,TIME,1232385129,GT,b,b,UN,0,b,IF,IF,TIME,1232385129,GT,c,c,UN,0,c,IF,IF,+,+,*,1024,*

If If I Go to "Graph templates" -> "Squid - HTTP Data " and put "KB/s" in the "Unit Grid Value", the error is:

invalid y-grid format

Can you help me?

Thks,

Paulo

[myha]

Hi guys,

just wanted to share smth... I also had a problem with invalid y-axis whatever, and the "Unit Grid Value" was empty...

What heleped - I entered smth in that field (like KB/s), saved, and then removed it again. After that it worked perfectly.

brm

[n.chavoshi]

thanks for your template
I want to change unit in squid data template to bit per second,can anyone guide me for this ??because the default is byte per second
thanks in advanced

[borja.arranz]

Hi

I'm just having the same problem that VaSh1, i can see that the snmp works beetwen my Cacti Server and my Squid Server, and if i ask with snmpwalk source Cacti server to the Squid server i have the correct answer. I added the templates from this topic but i can see that:

Data Query WebCache - Squid Statistics - Core
Error in data query.

Data Query WebCache - Squid Statistics - Median Based
Error in data query.

When i run "verbose query" on the WebCaches i get this:

+ Running data query [15].
+ Found type = '3' [snmp query].
+ Could not find data query XML file at '/var/www/cacti/resource/snmp_queries/webcache_squid_core.xml'
+ Error parsing XML file into an array.
+ Could not find data query XML file at '/var/www/cacti/resource/snmp_queries/webcache_squid_core.xml'
+ Could not find data query XML file at '/var/www/cacti/resource/snmp_queries/webcache_squid_core.xml'
+ Could not find data query XML file at '/var/www/cacti/resource/snmp_queries/webcache_squid_core.xml'

And this:

+ Running data query [16].
+ Found type = '3' [snmp query].
+ Could not find data query XML file at '/var/www/cacti/resource/snmp_queries/webcache_squid_median.xml'
+ Error parsing XML file into an array.
+ Could not find data query XML file at '/var/www/cacti/resource/snmp_queries/webcache_squid_median.xml'
+ Could not find data query XML file at '/var/www/cacti/resource/snmp_queries/webcache_squid_median.xml'
+ Could not find data query XML file at '/var/www/cacti/resource/snmp_queries/webcache_squid_median.xml'

And if i create the nexts Graph Cacti don't take any data graph from squid:

Squid - All Service Times
Squid - Cache
Squid - File Descriptors
Squid - File Descriptors :: current
Squid - HTTP errors
Squid - HTTP Requests in
Squid - HTTP Service Times
Squid - HTTP Traffic Data
Squid - Memory usage
Squid - Number of clients
Squid - Server requests out

i have my squid.conf perfectly configured:

acl acl-snmp snmp_community public
snmp_port 3401
snmp_access allow acl-snmp snmp
snmp_access deny all

and the snmpd.conf:

proxy -v 1 -c public squid-ip:3401 .1.3.6.1.4.1.3495.1

When i configure the squid Device on Cacti only works snmp if i enter the port 161 to SNMP Port, here is my first question, why if i configure the port 3401 on the squid.conf and snmpd.conf y have to enter the port 161 in Cacti side?

Is something that i'm doing wrong?

Please some advise.

Thanks a lot

[borja.arranz]

I fix the problem with the "Verbose query" of WebCaches adding the .xml manually, Cacti don't import the template by himself.

Now i can see a better answer to the "Verbose query":

+ Running data query [15].
+ Found type = '3' [snmp query].
+ Found data query XML file at '/var/www/cacti/resource/snmp_queries/webcache_squid_core.xml'
+ XML file parsed ok.
+ Executing SNMP walk for list of indexes @ '.1.3.6.1.4.1.3495.1.3.2.1.11'
+ No SNMP data returned
+ Found data query XML file at '/var/www/cacti/resource/snmp_queries/webcache_squid_core.xml'
+ Found data query XML file at '/var/www/cacti/resource/snmp_queries/webcache_squid_core.xml'
+ Found data query XML file at '/var/www/cacti/resource/snmp_queries/webcache_squid_core.xml'


But in "Create Graphs for this Host" i can see this:

Data Query [WebCache - Squid Statistics - Core] Reload Associated Query
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.

Data Query [WebCache - Squid Statistics - Median Based] Reload Associated Query
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.

[Kini]

I added the five graph template from the third page of this thread to my cacti.

After setting up the graphs on my two squid proxies there isn't anything graphed.

So I tested if I am able to ask SNMP on the SQUID Proxy this way:

snmpwalk -m /usr/share/squid/mib.txt -v2c -Cc -c communitystring hostname:3401 .1.3.6.1.4.1.3495.1.1

and I got an answer like this

SNMPv2-SMI::enterprises.3495.1.1.1.0 = INTEGER: 460
SNMPv2-SMI::enterprises.3495.1.1.2.0 = INTEGER: 1566452
SNMPv2-SMI::enterprises.3495.1.1.3.0 = Timeticks: (584627) 1:37:26.27

Why is Cacti not graphing something?

[Kini]

Further informations to my problem:

I queried all those MIBs listed in this Thread:

OID ClientHttpRequests 1.3.6.1.4.1.3495.1.3.2.1.1
OID HttpHits 1.3.6.1.4.1.3495.1.3.2.1.2
OID HttpErrors 1.3.6.1.4.1.3495.1.3.2.1.3
OID HttpInKb 1.3.6.1.4.1.3495.1.3.2.1.4
OID HttpOutKb 1.3.6.1.4.1.3495.1.3.2.1.5
OID ICPpktsSent 1.3.6.1.4.1.3495.1.3.2.1.6
OID ICPpktsRecv 1.3.6.1.4.1.3495.1.3.2.1.7
OID ICPkbSent 1.3.6.1.4.1.3495.1.3.2.1.8
OID ICPkbRecv 1.3.6.1.4.1.3495.1.3.2.1.9
OID ServerRequests 1.3.6.1.4.1.3495.1.3.2.1.10
OID ServerErrors 1.3.6.1.4.1.3495.1.3.2.1.11
OID ServerInKb 1.3.6.1.4.1.3495.1.3.2.1.12
OID ServerOutKb 1.3.6.1.4.1.3495.1.3.2.1.13
OID CurrentSwapSize 1.3.6.1.4.1.3495.1.3.2.1.14
OID SysPageFaults 1.3.6.1.4.1.3495.1.3.1.1
OID MemUsage 1.3.6.1.4.1.3495.1.3.1.4
OID CpuUsage 1.3.6.1.4.1.3495.1.3.1.5
OID MaxResSize 1.3.6.1.4.1.3495.1.3.1.6
OID NumObjCount 1.3.6.1.4.1.3495.1.3.1.7
OID CurrentLRUExpiration 1.3.6.1.4.1.3495.1.3.1.8
OID CurrentUnlinkRequests 1.3.6.1.4.1.3495.1.3.1.9
OID CurrentUnusedFileDescrCount 1.3.6.1.4.1.3495.1.3.1.10
OID CurrentReservedFileDescrCount 1.3.6.1.4.1.3495.1.3.1.11
OID HttpAllSvcTimeFiveMin 1.3.6.1.4.1.3495.1.3.2.2.1.2.5
OID HttpMissSvcTimeFiveMin 1.3.6.1.4.1.3495.1.3.2.2.1.3.5
OID HttpNmSvcTimeFiveMin 1.3.6.1.4.1.3495.1.3.2.2.1.4.5
OID HttpHitSvcTimeFiveMin 1.3.6.1.4.1.3495.1.3.2.2.1.5.5
OID IcpQuerySvcTimeFiveMin 1.3.6.1.4.1.3495.1.3.2.2.1.6.5
OID IcpReplySvcTimeFiveMin 1.3.6.1.4.1.3495.1.3.2.2.1.7.5
OID DnsSvcTimeFiveMin 1.3.6.1.4.1.3495.1.3.2.2.1.8.5
OID HttpAllSvcTimeHourly 1.3.6.1.4.1.3495.1.3.2.2.1.2.60
OID HttpMissSvcTimeHourly 1.3.6.1.4.1.3495.1.3.2.2.1.3.60
OID HttpNmSvcTimeHourly 1.3.6.1.4.1.3495.1.3.2.2.1.4.60
OID HttpHitSvcTimeHourly 1.3.6.1.4.1.3495.1.3.2.2.1.5.60
OID IcpQuerySvcTimeHourly 1.3.6.1.4.1.3495.1.3.2.2.1.6.60
OID IcpReplySvcTimeHourly 1.3.6.1.4.1.3495.1.3.2.2.1.7.60
OID DnsSvcTimeHourly 1.3.6.1.4.1.3495.1.3.2.2.1.8.60
OID HttpAllSvcTimeOneMin 1.3.6.1.4.1.3495.1.3.2.2.1.2.1
OID HttpMissSvcTimeOneMin 1.3.6.1.4.1.3495.1.3.2.2.1.3.1
OID HttpHitSvcTimeOneMin 1.3.6.1.4.1.3495.1.3.2.2.1.5.1

Both SQUID-Proxies are answering with Data on every single MIB.

After this I checked the MIB locations of the XML-files on page 3 of this Thread and I am also getting an answer for every MIB.
So I am in the opinion that Cacti is getting data but doesn`t graph it. So far everything should be set up correctly on my SQUIDs.

Further on I added the WebCache - SQUID - XMLs from Gandalf this morning. No Rows and no Items found. Verbose Query:

+ Running data query [29].
+ Found type = '3' [snmp query].
+ Could not find data query XML file at 'path_cacti/resource/snmp_queries/webcache_squid_core.xml'
+ Error parsing XML file into an array.
+ Could not find data query XML file at 'path_cacti/resource/snmp_queries/webcache_squid_core.xml'
+ Could not find data query XML file at 'path_cacti/resource/snmp_queries/webcache_squid_core.xml'
+ Could not find data query XML file at 'path_cacti/resource/snmp_queries/webcache_squid_core.xml'

path/cacti should be srv/www/htdocs/cacti

I added all graph templates by importing them via import tool in cacti console.

What did I do wrong? What did I forget? Can anyone help me?

[alexus]

so is this working or non-working templates?

i wish to add squid to my cacti

[argon0]

OK, this LOOKS like it works but:


1) you must first download the Squidstats-0.1.zip file from the Squidstats thread - getting you the webcache_squid_core.xml and webcache_squid_median.xml files,

2) copy these into the correct path for your implementation (for EZCacti this is /var/www/html/resource/snmp_queries), make sure user is same as the user your Cacti is running as (for EZCacti this is Apache)

3) import the host template from Reinhard, mentioned above.

4) Prepare your host - as mentioned above:

Code: Select all

acl acl-snmp snmp_community public 
snmp_port 3401 
snmp_access allow acl-snmp snmp 
snmp_access deny all 

5) create a new host with the template WebCache - Squid Server (SNMP)

6) Set the SNMP version to 1, and the SNMP port to 3401 on the host

Do the verbose queries, and then you should be able to create graphs!!!

[twin]

Please try attached Host Template. Requires at least cacti-0.8.6i
Reinhard

I know, it's been a while, but i would like to use the above host-template.
But the data-queries are missing (core and meridian).
Where can i find them ?


Or are there newer Squid Templates for 0.8.7e ? I haven't found some.


Thank you !

[argon0]

See my post just above yours, works very well.

Important thing to notice though is it uses SNMP version 1. And you may need to graph the host separately to the SQUID engine... (I had to create two devices to get this to work).

[twin]

See my post just above yours, works very well.

Important thing to notice though is it uses SNMP version 1. And you may need to graph the host separately to the SQUID engine... (I had to create two devices to get this to work).

Oh no ! Sorry i had to be blind. Thank you !


By the way. I got it working with just one device. I just put the snmp port 3401 directly into the Data Source. To do so i had to check the "Use-per Data Source" Options in the Data templates and so i could use a different SNMP Port for the Squid Graphs.

Does this work too with Reinhards Template ?

[alexus]

after importing this template my other template for apache stop working, how can I fix it?