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

Templates, scripts for templates, scripts and requests for templates.

Moderators: Developers, Moderators

Post Reply
flok
Posts: 8
Joined: Mon Jan 23, 2006 7:46 am
Contact:
Contact flok

Post by flok »

lvm wrote:Oh, sorry, you're quite right. I've missed something from your previous posting. It was so obvious! The graph statement does not contain any data source! This would be a line with a DEF= statement on it. And the AREA/LINEx statements would contain a reference to those DEFs (or to CDEFs which in turn would reference the DEFs). Did you got any errors while importing the templates? They seem to be broken ...
Reinhard
Nope, all went well. And where the description told me I should see something green, it was green :-)
Top
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Contact gandalf

Post by gandalf »

Would it matter to re-import and post the output?
If nothing changes, please goto the Graph Template and post a screenshot. There's definitively sth wrong with that Template.
Thought about mysql repair?
Reinhard
Top
Steve Ollis
Posts: 26
Joined: Thu Jan 19, 2006 10:07 pm

Post by Steve Ollis »

Hi,
--insert newbie question here--

Has anyone got this working under 0.8.6h?

--insert newbie question here--

Steve
Top
flok
Posts: 8
Joined: Mon Jan 23, 2006 7:46 am
Contact:
Contact flok

Post by flok »

lvm wrote:Would it matter to re-import and post the output?
If nothing changes, please goto the Graph Template and post a screenshot. There's definitively sth wrong with that Template.
Thought about mysql repair?
Reinhard
Re-imported the template:

Code: Select all

Import Results

Cacti has imported the following items:

Round Robin Archive
[success] Daily (5 Minute Average) [update]
[success] Weekly (30 Minute Average) [update]
[success] Monthly (2 Hour Average) [update]
[success] Yearly (1 Day Average) [update]

CDEF
[success] Multiply by 1024 [update]
[success] Squid - Calculate Percentage of Storage [update]
[success] Squid - Clean value for DEF a [update]
[success] Squid - Clean value for DEF b [update]
[success] Squid - Limit output to zero min and max [update]
[success] Squid - Multiply by 1024 and turn into bits [update]
[success] Squid - Calculate Traffic Savings Rate [update]
[success] Squid - Deduct DEF b fom DEF a [update]
[success] Squid - Calculate Stored Object Size [update]

GPRINT Preset
[success] Normal [update]
[success] Exact Numbers [update]

Data Input Method
[success] Get SNMP Data (Indexed) [update]

Data Template
[success] WebCache - Squid - CPU Usage [update]
[success] WebCache - Squid - Error Rate [update]
[success] WebCache - Squid - Storage Utilisation [update]
[success] WebCache - Squid - Objects in Cache [update]
[success] WebCache - Squid - Traffic In/Out [update]
[success] WebCache - Squid - Client Request Rate [update]
[success] WebCache - Squid - Storage Activity [update]
[success] WebCache - Squid - Available File Descriptors [update]
[success] WebCache - Squid - Number of Clients [update]
[success] WebCache - Squid - DNS Statistics [update]
[success] WebCache - Squid - Page Faults [update]
[success] WebCache - Squid - Cache Hit Rate [update]
[success] WebCache - Squid - Service Timers [update]

Graph Template
[success] WebCache - Squid - CPU Usage [new]
[success] WebCache - Squid - Error Rate [new]
[success] WebCache - Squid - Storage Utilisation [new]
[success] WebCache - Squid - Objects in Cache [new]
[success] WebCache - Squid - Traffic In/Out/Saved [new]
[success] WebCache - Squid - Client Request Rate [new]
[success] WebCache - Squid - Storage Activity [new]
[success] WebCache - Squid - Available File Descriptors [new]
[success] WebCache - Squid - Number of Clients [new]
[success] WebCache - Squid - DNS Statistics [new]
[success] WebCache - Squid - Average Stored Object Size [new]
[success] WebCache - Squid - Page Faults [new]
[success] WebCache - Squid - Cache Hit Rate [new]
[success] WebCache - Squid - Service Timers [new]

Data Query
[success] WebCache - Squid Statistics - Core [update]
[success] WebCache - Squid Statistics - Median Based [update]

Host Template
[success] WebCache - Squid Server (SNMP) [update]
Top
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Contact gandalf

Post by gandalf »

flok wrote:

Code: Select all

Graph Template
[success] WebCache - Squid - CPU Usage [new]
[success] WebCache - Squid - Error Rate [new]
[success] WebCache - Squid - Storage Utilisation [new]
[success] WebCache - Squid - Objects in Cache [new]
[success] WebCache - Squid - Traffic In/Out/Saved [new]
[success] WebCache - Squid - Client Request Rate [new]
[success] WebCache - Squid - Storage Activity [new]
[success] WebCache - Squid - Available File Descriptors [new]
[success] WebCache - Squid - Number of Clients [new]
[success] WebCache - Squid - DNS Statistics [new]
[success] WebCache - Squid - Average Stored Object Size [new]
[success] WebCache - Squid - Page Faults [new]
[success] WebCache - Squid - Cache Hit Rate [new]
[success] WebCache - Squid - Service Timers [new]
So the Graph Templates were missing before? And how's this now?
Reinhard
Top
flok
Posts: 8
Joined: Mon Jan 23, 2006 7:46 am
Contact:
Contact flok

Post by flok »

lvm wrote:
flok wrote:

Code: Select all

Graph Template
[success] WebCache - Squid - CPU Usage [new]
...
[success] WebCache - Squid - Service Timers [new]
So the Graph Templates were missing before? And how's this now?
Reinhard
Still no luck:

Code: Select all

RRDTool Command:

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="draco - Squid Objects in Cache" \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="clients" \
AREA:#96E78A:"Clients\:"  \
GPRINT::LAST:"Current\:%8.2lf%s"  \
GPRINT::AVERAGE:"Average\:%8.2lf%s"  \
GPRINT::MAX:"Maximum\:%8.2lf%s\n"  \
COMMENT:"      Represents the unique number of IP addresses from which clients have accessed squid\n"  \
COMMENT:"                  NOTE: This metric is set to 0 whenever squid is restarted  !!!!\n"  \
COMMENT:"                                 SquidStats v0.1 - Rolf Poser\n" 

RRDTool Says:

ERROR: can't parse '#96E78A:Clients\:'
Top
irishpadres
Posts: 9
Joined: Sat Sep 13, 2003 3:46 pm
Location: Los Angeles, CA

Post by irishpadres »

Steve Ollis wrote:Hi,
--insert newbie question here--

Has anyone got this working under 0.8.6h?

--insert newbie question here--

Steve
Could someone please help us out with exports that we can use with current versions of cacti?
Top
Steve Ollis
Posts: 26
Joined: Thu Jan 19, 2006 10:07 pm

Post by Steve Ollis »

I think my issue reverts from the decision to use cactid as the poller. It appears to NOT support SNMP ports other than 161

Steve
Top
User avatar
TheWitness
Developer
Posts: 16997
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:
Contact TheWitness

Post by TheWitness »

If you are using Cactid 0.8.6g, it does. Well, to make it work, you will have to use Availability SNMP/ICMP ping because SNMP will fail.

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages

For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Top
Tomeq
Posts: 24
Joined: Thu Dec 05, 2002 2:22 pm

Post by Tomeq »

TheWitness wrote:If you are using Cactid 0.8.6g, it does. Well, to make it work, you will have to use Availability SNMP/ICMP ping because SNMP will fail.

TheWitness
It doesn't work well for me. Changing the availability setting make some hosts down but no squid becomes up.

Is it possible to implement a feature to set availabilty check method for each host independently with possibility to disable those checks at all? Should be easy... but probably, will solve the problem.

Greets,
Tomek
Top
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Contact gandalf

Post by gandalf »

flok wrote:
lvm wrote:
flok wrote:

Code: Select all

Graph Template
[success] WebCache - Squid - CPU Usage [new]
...
[success] WebCache - Squid - Service Timers [new]
So the Graph Templates were missing before? And how's this now?
Reinhard
Still no luck:

Code: Select all

RRDTool Command:

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="draco - Squid Objects in Cache" \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="clients" \
AREA:#96E78A:"Clients\:"  \
GPRINT::LAST:"Current\:%8.2lf%s"  \
GPRINT::AVERAGE:"Average\:%8.2lf%s"  \
GPRINT::MAX:"Maximum\:%8.2lf%s\n"  \
COMMENT:"      Represents the unique number of IP addresses from which clients have accessed squid\n"  \
COMMENT:"                  NOTE: This metric is set to 0 whenever squid is restarted  !!!!\n"  \
COMMENT:"                                 SquidStats v0.1 - Rolf Poser\n" 

RRDTool Says:

ERROR: can't parse '#96E78A:Clients\:'
This is weird, cause ALL graph items are missing. Please delete all Graphs (and perhaps Data Templates) of that host and re-create. Please show us the the rrdtool graph statements of the new graphs.
Reinhard
Top
jmeyerdo
Posts: 26
Joined: Mon May 02, 2005 7:11 am
Location: Dortmund, Germany

Post by jmeyerdo »

Hello!

I have a similar problem like already described in posts in this thread - but I can't find any solution for me.

I installed SquidStats with help from the great and detailed installation-guide - fine, no problems.
But no graphs are shown - because no rrd-files are created. Permissions should be fine - other graphs are working well.
Try changing the snmp_access from localhost to all, and see if that works.
Done.
snmpwalk -v 1 -c snmppublic localhost:3401 1.3.6.1.4.1.3495.1
Works without problems.
The debug output from data-template:

Code: Select all

/usr/bin/rrdtool create \
/usr/share/cacti/rra/server_hooge_ejeb_de_squid_squid_serverinkb_64.rrd \
--step 300  \
DS:squid_httpOutKb:COUNTER:600:0:1000000000 \
DS:squid_serverInKb:COUNTER:600:0:1000000000 \
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:MIN:0.5:1:600 \
RRA:MIN:0.5:6:700 \
RRA:MIN:0.5:24:775 \
RRA:MIN: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 \
The only part of installation where I can assume a mistake from me should be the creation of graphs. Could anybody see any errors?

Thank you for your help!
Kind regards, Jens
Top
paulbeard206
Cacti User
Posts: 150
Joined: Sat Jul 30, 2005 2:15 pm

cactid 0.8.6g and SquidStats

Post by paulbeard206 »

I have the templates and all loaded, looks good, I can create graphs. But nothing shows up.

Code: Select all

# cactid --verbosity=5 10 10 
CACTID: Using cactid config file [/usr/local/etc/cactid.conf]
CACTID: DEBUG: MySQL Query ID '0': 'SELECT value FROM settings WHERE name = 'path_webroot''
CACTID: DEBUG: MySQL Query ID '0': OK
CACTID: DEBUG: MySQL Query ID '1': 'SELECT value FROM settings WHERE name = 'path_cactilog''
CACTID: DEBUG: MySQL Query ID '1': OK
CACTID: DEBUG: The path_php_server variable is /usr/local/share/cacti/script_server.php
CACTID: DEBUG: The path_cactilog variable is /usr/local/share/cacti/log/cacti.log
CACTID: DEBUG: MySQL Query ID '2': 'SELECT value FROM settings WHERE name = 'log_destination''
CACTID: DEBUG: MySQL Query ID '2': OK
CACTID: DEBUG: The log_destination variable is 1 (FILE)
CACTID: DEBUG: MySQL Query ID '3': 'SELECT value FROM settings WHERE name = 'path_php_binary''
CACTID: DEBUG: MySQL Query ID '3': OK
CACTID: DEBUG: The path_php variable is /usr/local/bin/php
CACTID: DEBUG: MySQL Query ID '4': 'SELECT value FROM settings WHERE name = 'availability_method''
CACTID: DEBUG: MySQL Query ID '4': OK
CACTID: DEBUG: The availability_method variable is 2
CACTID: DEBUG: MySQL Query ID '5': 'SELECT value FROM settings WHERE name = 'ping_recovery_count''
CACTID: DEBUG: MySQL Query ID '5': OK
CACTID: DEBUG: The ping_recovery_count variable is 3
CACTID: DEBUG: MySQL Query ID '6': 'SELECT value FROM settings WHERE name = 'ping_failure_count''
CACTID: DEBUG: MySQL Query ID '6': OK
CACTID: DEBUG: The ping_failure_count variable is 2
CACTID: DEBUG: MySQL Query ID '7': 'SELECT value FROM settings WHERE name = 'ping_method''
CACTID: DEBUG: MySQL Query ID '7': OK
CACTID: DEBUG: The ping_method variable is 2
CACTID: DEBUG: MySQL Query ID '8': 'SELECT value FROM settings WHERE name = 'ping_retries''
CACTID: DEBUG: MySQL Query ID '8': OK
CACTID: DEBUG: The ping_retries variable is 1
CACTID: DEBUG: MySQL Query ID '9': 'SELECT value FROM settings WHERE name = 'ping_timeout''
CACTID: DEBUG: MySQL Query ID '9': OK
CACTID: DEBUG: The ping_timeout variable is 400
CACTID: DEBUG: MySQL Query ID '10': 'SELECT value FROM settings WHERE name = 'log_perror''
CACTID: DEBUG: MySQL Query ID '10': OK
CACTID: DEBUG: The log_perror variable is 1
CACTID: DEBUG: MySQL Query ID '11': 'SELECT value FROM settings WHERE name = 'log_pwarn''
CACTID: DEBUG: MySQL Query ID '11': OK
CACTID: DEBUG: The log_pwarn variable is 0
CACTID: DEBUG: MySQL Query ID '12': 'SELECT value FROM settings WHERE name = 'log_pstats''
CACTID: DEBUG: MySQL Query ID '12': OK
CACTID: DEBUG: The log_pstats variable is 0
CACTID: DEBUG: MySQL Query ID '13': 'SELECT value FROM settings WHERE name = 'max_threads''
CACTID: DEBUG: MySQL Query ID '13': OK
CACTID: DEBUG: The threads variable is 16
CACTID: DEBUG: MySQL Query ID '14': 'SELECT value FROM settings WHERE name = 'poller_interval''
CACTID: DEBUG: MySQL Query ID '14': OK
CACTID: DEBUG: The polling interval is the system default
CACTID: DEBUG: MySQL Query ID '15': 'SELECT value FROM settings WHERE name = 'concurrent_processes''
CACTID: DEBUG: MySQL Query ID '15': OK
CACTID: DEBUG: The number of concurrent processes is 4
CACTID: DEBUG: MySQL Query ID '16': 'SELECT value FROM settings WHERE name = 'script_timeout''
CACTID: DEBUG: MySQL Query ID '16': OK
CACTID: DEBUG: The script timeout is 25
CACTID: DEBUG: MySQL Query ID '17': 'SELECT value FROM settings WHERE name = 'php_servers''
CACTID: DEBUG: MySQL Query ID '17': OK
CACTID: DEBUG: The number of php script servers to run is 1
CACTID: DEBUG: MySQL Query ID '18': 'SELECT action FROM poller_item WHERE action=2 AND host_id BETWEEN 10 AND 10 LIMIT 1'
CACTID: DEBUG: MySQL Query ID '18': OK
CACTID: DEBUG: StartHost='10', EndHost='10', TotalPHPScripts='0'
CACTID: DEBUG: The PHP Script Server is Not Required
CACTID: DEBUG: MySQL Query ID '19': 'SELECT value FROM settings WHERE name = 'max_get_size''
CACTID: DEBUG: MySQL Query ID '19': OK
CACTID: DEBUG: The Maximum SNMP OID Get Size is 60
CACTID: CACTID: Version 0.8.6f starting
CACTID: MYSQL: Connecting to MySQL database 'cacti' on 'localhost'...
CACTID: MYSQL: Connected to MySQL database 'cacti' on 'localhost'...
CACTID: CACTID: Initializing Net-SNMP API
CACTID: CACTID: Initializing PHP Script Server
CACTID: DEBUG: MySQL Query ID '20': 'SELECT id FROM host WHERE disabled='' AND id BETWEEN 10 AND 10 ORDER BY id'
CACTID: DEBUG: MySQL Query ID '20': OK
CACTID: DEBUG: Initial Value of Active Threads is 0
CACTID: DEBUG: Valid Thread to be Created
CACTID: DEBUG: The Value of Active Threads is 1
CACTID: DEBUG: In Poller, About to Start Polling of Host
CACTID: MYSQL: Connecting to MySQL database 'cacti' on 'localhost'...
CACTID: MYSQL: Connected to MySQL database 'cacti' on 'localhost'...
CACTID: DEBUG: MySQL Query ID '21': 'SELECT action,hostname,snmp_community,snmp_version,snmp_username,snmp_password,rrd_name,rrd_path,arg1,arg2,arg3,local_data_id,rrd_num,snmp_port,snmp_timeout FROM poller_item WHERE host_id=0 ORDER BY arg1'
CACTID: DEBUG: MySQL Query ID '21': OK
CACTID: Host[0] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
CACTID: DEBUG: Valid Thread to be Created
CACTID: DEBUG: The Value of Active Threads is 2
CACTID: DEBUG: In Poller, About to Start Polling of Host
CACTID: MYSQL: Connecting to MySQL database 'cacti' on 'localhost'...
CACTID: MYSQL: Connected to MySQL database 'cacti' on 'localhost'...
CACTID: DEBUG: MySQL Query ID '22': 'SELECT id, hostname,snmp_community,snmp_username,snmp_password,snmp_version,snmp_port,snmp_timeout,status,status_event_count,status_fail_date,status_rec_date,status_last_error,min_time,max_time,cur_time,avg_time,total_polls,failed_polls,availability FROM host WHERE id=10'
CACTID: DEBUG: MySQL Query ID '22': OK
CACTID: Host[10] SNMP Result: Host responded to SNMP
CACTID: DEBUG: MySQL Insert ID '0': 'update host set status='3',status_event_count='0', status_fail_date='0000-00-00 00:00:00',status_rec_date='0000-00-00 00:00:00',status_last_error='',min_time='1.188990',max_time='49.180030',cur_time='49.180030',avg_time='8.717896',total_polls='12',failed_polls='0',availability='100.0000' where id='10''
CACTID: DEBUG: MySQL Insert ID '0': OK
CACTID: DEBUG: MySQL Query ID '23': 'SELECT data_query_id,action,op,assert_value,arg1 FROM poller_reindex WHERE host_id=10'
CACTID: DEBUG: MySQL Query ID '23': OK
CACTID: Host[10] RECACHE: Processing 2 items in the auto reindex cache for 'red.paulbeard.org'
CACTID: DEBUG: MySQL Insert ID '1': 'update poller_reindex set assert_value='20289833' where host_id='10' and data_query_id='14' and arg1='.1.3.6.1.2.1.1.3.0''
CACTID: DEBUG: MySQL Insert ID '1': OK
CACTID: DEBUG: MySQL Insert ID '2': 'update poller_reindex set assert_value='20289833' where host_id='10' and data_query_id='15' and arg1='.1.3.6.1.2.1.1.3.0''
CACTID: DEBUG: MySQL Insert ID '2': OK
CACTID: DEBUG: MySQL Query ID '24': 'SELECT action,hostname,snmp_community,snmp_version,snmp_username,snmp_password,rrd_name,rrd_path,arg1,arg2,arg3,local_data_id,rrd_num,snmp_port,snmp_timeout FROM poller_item WHERE host_id=10 ORDER BY arg1'
CACTID: DEBUG: MySQL Query ID '24': OK
CACTID: Host[10] DEBUG: HOST COMPLETE: About to Exit Host Polling Thread Function
CACTID: DEBUG: The Value of Active Threads is 1
CACTID: DEBUG: The Value of Active Threads is 0
CACTID: DEBUG: MySQL Insert ID '3': 'replace into settings (name,value) values ('date',NOW())'
CACTID: DEBUG: MySQL Insert ID '3': OK
CACTID: DEBUG: MySQL Insert ID '4': 'insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())'
CACTID: DEBUG: MySQL Insert ID '4': OK
CACTID: DEBUG: Thread Cleanup Complete
CACTID: DEBUG: PHP Script Server Pipes Closed
CACTID: DEBUG: Allocated Variable Memory Freed
CACTID: CACTID: Net-SNMP API Shutdown Completed
CACTID: DEBUG: MYSQL Free & Close Completed
CACTID: Time: 2.4708 s, Threads: 16, Hosts: 2
(And cactid identifies itself as 0.8.6f when you run it but it's 0.8.6g in the code.)

Code: Select all

(21:18:20 <~>) 0 # cactid --version
CACTID 0.8.6f  Copyright 2002-2005 by The Cacti Group

Code: Select all


configure.ac:AC_INIT(Cactid Poller, 0.8.6g, http://bugs.cacti.net)
Top
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Contact gandalf

Post by gandalf »

jmeyerdo wrote:Could anybody see any errors?

Thank you for your help!
Kind regards, Jens
Please post parts of cacti.log when running in DEBUG mode for one interval
Reinhard
Top
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Contact gandalf

Re: cactid 0.8.6g and SquidStats

Post by gandalf »

paulbeard206 wrote:I have the templates and all loaded, looks good, I can create graphs. But nothing shows up.
I can't find anything about the squid queries in the log. Am I missing something?
Reinhard
Top
Post Reply

Return to “Scripts and Templates”

Who is online

Users browsing this forum: No registered users and 2 guests