Squid Log Analysers

W3Perl  is a Web log analyzer that can also read  Squid   log files. It allows to output a lot of statistical data in graphical or text format. An administration interface is available to manage the package.

SQUID Frequently Asked Questions Squid Log Files

access.log

Most log file analysis program are based on the entries in access.log. Currently, there are two file formats possible for the log file, depending on your configuration for the emulate_httpd_log option. By default, Squid will log in its native log file format. If the above option is enabled, Squid will log in the common log file format as defined by the CERN web daemon.

The common log file format contains other information than the native log file, and less. The native format contains more information for the admin interested in cache evaluation.

AWStats Documentation - FAQs

FAQ-ABO100 : WHICH SERVER LOG FILES OR OS ARE SUPPORTED ?
AWStats can works with :
 

All web server able to write log file with a combined log format (XLF/ELF) like Apache, a common log format (CLF) like Apache or Squid, a W3C log format like IIS 5.0 or higher, or any other log format that contains all information AWStats expect to find.
 

NEWS CONTENTS

• 20120413 : Squidalyser – Freecode ( Squidalyser – Freecode, Apr 13, 2012 )
• 20120413 : proxy-report.pl – Freecode ( proxy-report.pl – Freecode, Apr 13, 2012 )
• 20120105 : W3Perl 3.135 ( W3Perl 3.135, Jan 05, 2012 )
• 20110727 : SAWstats vitki.net ( SAWstats vitki.net, Jul 27, 2011 )

Old News ;-)

[Apr 13, 2012] Squidalyser – Freecode

Written in Perl

Squidalyser is a Squid log file analyzer that is designed to allow per-user scrutiny. It allows a non-technical user to extract information about Web usage patterns including the type of information downloaded, the sites visited, the graphics downloaded, and the amount of information (per-byte or per-file) accessed. All functions are accessed through a Web interface.

[Apr 13, 2012] proxy-report.pl – Freecode

Written in Perl

proxy-report.pl generates a list of requested server addresses (simplified URLs) from your Squid proxy server log files. Requests for each URL are summarized on a per day basis. This script can generate reports based on the IP of the user. It also automatically handles gzipped files. URL exclusion patterns are supported. A sample report is available on the home page.

[Jan 05, 2012] W3Perl 3.135

W3Perl is a Web logfile analyzer. But it can also read FTP/Squid or mail logfiles. It allows most statistical data to be ouput with graphical and textual information. An administration interface is available ... to manage the package.

[Jul 27, 2011] SAWstats vitki.net

SAWstats is an improved version of AWstats with the following additional features:

• Native Nginx log format support (%codequot)
• Native Squid logs support (%codesquid %timesquid %otherblanks)
• Seamless support of monthly and daily views
• Easy navigation between monthly and daily weekly views
• Filtering of Drupal users (using DRUPAL_UID, see Apache recipe, Nginx can log this cookie as $cookie_DRUPAL_UID).

AWstats is a great tool for parsing and analysis of web logs with nice web interface, but after years it still lacks Squid support, so I decided to fork. The name "SAWstats" stands for "Severely Advanced Web Statistics".

Planned features:

• Per-host and per-user analytics
• Squid hits/miss analysis

Similar projects:

CNstats is a flexible and versatile system for accumulation and analysis of the site attendance statistics. See demo site and nulled version.

Recommended Links

Squid Logfile Analysis

Calamaris Calamaris is a Perl script that parses the logfiles of a wide variety of Web proxy servers and generates reports about peak-usage, request-methods, status-report of incoming and outgoing requests, second and top-level destinations, content-types, and performance.

parses logfiles from Squid, NetCache, Inktomi Traffic Server, Oops! proxy server, Novell Internet Caching System, Compaq Tasksmart or Netscape/iplanet Web Proxy Server and generates a report. Written in perl5.

About: Calamaris parses the logfiles of a wide variety of Web proxy servers and generates reports about peak-usage, request-methods, status-report of incoming and outgoing requests, second and top-level destinations, content-types, and performance.

Changes: There are bugfixes regarding %-URLs and syntactically wrong HTML output. A function to use Calamaris' output in server side includes has been added.

Calamaris parses the Squid Native Log and generates reports about Peak-usage, Request-Methods, Status-report of incoming and outgoing requests, second and Top-level destinations, content-types and performance.

• Download:
  • http://www.Cord.de

  Squij

Squij Squij analyses Squid 1.x and 2.x logfiles to provide information about how your refresh_patterns are performing, enabling you to tune them for better efficiency (both in traffic and freshness).

• Download:
  • http://www.pobox.com/~mnot/squij/squij-0.60.tar.gz

Squid2MySQL

Squid2MySQL

Squid2MySQL is an accounting system for squid. It includes monthly, daily, and timed detail levels, and uses MySQL for log storage.

Eugene V. Chernyshev <evc (at) chat (dot) ru> [contact developer]

Squid-Log-Analyzer

At first, you have to download the package. (6 KB) After downloading the package place it in a warm dry place in your PC, unzip and untar it (e.g. with: tar -xzf squid-log-analyzer-0.6.tar.gz) cd into the directory (cd squid-log-analyzer-0.6) and execute the program with ./run
A file called squidlog.htm is generated, you may open it with your favourite web-browser.
Propably you like to change some options: just edit the squid-log-analyzer.conf file. It is well commented. You should be able to edit it with any texteditor. If there are any problems with the problem look at the Help-section.

Help

Q: There is no file called squidlog.htm generated./The program says: "./run: ./squid-log-analyzer.pl: File or directory not found".
A: You have to set the location of the perl interpreter. Open the file squid-log-analyzer.pl and edit the first line. (#!/usr/local/bin/perl should work) If you don't know where your perl editor is type: "whereis perl". If you don't have perl installed, get it from Perl.com

Q: Q: There is no file called squidlog.htm generated./ The program says: "tail: /var/log/squid/access.log: File or directory not found".
A: You have to set the location of your access.log file. Edit squid-log-analyzer.conf. If you don't know where you're access.log file is:
try: locate access.log
or: find / -name access.log
on rpm-based systems (RedHat, SuSE,...) you could also use: rpm -ql squid | grep access.log

If you have any other problem, please contact me. (see Info

This program is developed by Olaf Schubert.
If you've got any comments, suggestions, or you would like to help me please mail me.

Pwebstats

pwebstats Documentation Installation. By Martin Gleeson includes support for Squid's native log format. In particular squid2common.pl will convert it to the common httpd log format. Requires fly, to create the graphs. You can use one of the precompiled binaries by downloading one from the fly web page or compile it from the source code.

1. Requirements.
2. Obtaining the source.
3. Installing pwebstats.

pwebstats is available via anonymous ftp.\

Please choose the site closest to you.

in Unix compress format:

pwebstats-1.3.8.tar.Z (138k) [FTP/Australia] [FTP/USA] [HTTP/USA]

or in GNU zip format:

pwebstats-1.3.8.tar.gz (69k) [FTP/Australia] [FTP/USA] [HTTP/USA]

or in PK zip format:

pwebstats-1.3.8.zip (131k) [FTP/Australia] [FTP/USA] [HTTP/USA]

Etc

Society

Groupthink : Two Party System as Polyarchy : Corruption of Regulators : Bureaucracies : Understanding Micromanagers and Control Freaks : Toxic Managers :   Harvard Mafia : Diplomatic Communication : Surviving a Bad Performance Review : Insufficient Retirement Funds as Immanent Problem of Neoliberal Regime : PseudoScience : Who Rules America : Neoliberalism  : The Iron Law of Oligarchy : Libertarian Philosophy

Quotes

War and Peace : Skeptical Finance : John Kenneth Galbraith :Talleyrand : Oscar Wilde : Otto Von Bismarck : Keynes : George Carlin : Skeptics : Propaganda  : SE quotes : Language Design and Programming Quotes : Random IT-related quotes :  Somerset Maugham : Marcus Aurelius : Kurt Vonnegut : Eric Hoffer : Winston Churchill : Napoleon Bonaparte : Ambrose Bierce :  Bernard Shaw : Mark Twain Quotes

Bulletin:

Vol 25, No.12 (December, 2013) Rational Fools vs. Efficient Crooks The efficient markets hypothesis : Political Skeptic Bulletin, 2013 : Unemployment Bulletin, 2010 :  Vol 23, No.10 (October, 2011) An observation about corporate security departments : Slightly Skeptical Euromaydan Chronicles, June 2014 : Greenspan legacy bulletin, 2008 : Vol 25, No.10 (October, 2013) Cryptolocker Trojan (Win32/Crilock.A) : Vol 25, No.08 (August, 2013) Cloud providers as intelligence collection hubs : Financial Humor Bulletin, 2010 : Inequality Bulletin, 2009 : Financial Humor Bulletin, 2008 : Copyleft Problems Bulletin, 2004 : Financial Humor Bulletin, 2011 : Energy Bulletin, 2010 : Malware Protection Bulletin, 2010 : Vol 26, No.1 (January, 2013) Object-Oriented Cult : Political Skeptic Bulletin, 2011 : Vol 23, No.11 (November, 2011) Softpanorama classification of sysadmin horror stories : Vol 25, No.05 (May, 2013) Corporate bullshit as a communication method  : Vol 25, No.06 (June, 2013) A Note on the Relationship of Brooks Law and Conway Law

History:

Fifty glorious years (1950-2000): the triumph of the US computer engineering : Donald Knuth : TAoCP and its Influence of Computer Science : Richard Stallman : Linus Torvalds  : Larry Wall  : John K. Ousterhout : CTSS : Multix OS Unix History : Unix shell history : VI editor : History of pipes concept : Solaris : MS DOS :  Programming Languages History : PL/1 : Simula 67 : C : History of GCC development :  Scripting Languages : Perl history   : OS History : Mail : DNS : SSH : CPU Instruction Sets : SPARC systems 1987-2006 : Norton Commander : Norton Utilities : Norton Ghost : Frontpage history : Malware Defense History : GNU Screen : OSS early history

Classic books:

The Peter Principle : Parkinson Law : 1984 : The Mythical Man-Month :  How to Solve It by George Polya : The Art of Computer Programming : The Elements of Programming Style : The Unix Hater’s Handbook : The Jargon file : The True Believer : Programming Pearls : The Good Soldier Svejk : The Power Elite

Most popular humor pages:

Manifest of the Softpanorama IT Slacker Society : Ten Commandments of the IT Slackers Society : Computer Humor Collection : BSD Logo Story : The Cuckoo's Egg : IT Slang : C++ Humor : ARE YOU A BBS ADDICT? : The Perl Purity Test : Object oriented programmers of all nations : Financial Humor : Financial Humor Bulletin, 2008 : Financial Humor Bulletin, 2010 : The Most Comprehensive Collection of Editor-related Humor : Programming Language Humor : Goldman Sachs related humor : Greenspan humor : C Humor : Scripting Humor : Real Programmers Humor : Web Humor : GPL-related Humor : OFM Humor : Politically Incorrect Humor : IDS Humor : "Linux Sucks" Humor : Russian Musical Humor : Best Russian Programmer Humor : Microsoft plans to buy Catholic Church : Richard Stallman Related Humor : Admin Humor : Perl-related Humor : Linus Torvalds Related humor : PseudoScience Related Humor : Networking Humor : Shell Humor : Financial Humor Bulletin, 2011 : Financial Humor Bulletin, 2012 : Financial Humor Bulletin, 2013 : Java Humor : Software Engineering Humor : Sun Solaris Related Humor : Education Humor : IBM Humor : Assembler-related Humor : VIM Humor : Computer Viruses Humor : Bright tomorrow is rescheduled to a day after tomorrow : Classic Computer Humor

The Last but not Least Technology is dominated by two types of people: those who understand what they do not manage and those who manage what they do not understand ~Archibald Putt. Ph.D

The statements, views and opinions presented on this web page are those of the author (or referenced source) and are not endorsed by, nor do they necessarily reflect, the opinions of the Softpanorama society. We do not warrant the correctness of the information provided or its fitness for any purpose. The site uses AdSense so you need to be aware of Google privacy policy. You you do not want to be tracked by Google please disable Javascript for this site. This site is perfectly usable without Javascript.

Last modified: January 09, 2020