LinuxGateway

<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisjJQdLQPvuc44b7JgfD8pBMov3rKNxJZFvsG9bxIWKtN2FN5rDw-ilmaRIk5aBSLf5Whs8Naek-06ENbhS0KQ_ofkasds7ktLXFRqItgfVHWyvye651Z4Oj2_iZ0UnGmX1BPnksZSysfk/s1600/SARG-700x454%255BFeatured%255D.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisjJQdLQPvuc44b7JgfD8pBMov3rKNxJZFvsG9bxIWKtN2FN5rDw-ilmaRIk5aBSLf5Whs8Naek-06ENbhS0KQ_ofkasds7ktLXFRqItgfVHWyvye651Z4Oj2_iZ0UnGmX1BPnksZSysfk/s1600/SARG-700x454%255BFeatured%255D.jpg" /> </a></div>
<div class="separator" style="clear: both; text-align: center;">
 </div>
 
SARG is a Open Source Tool, FREE and under GPL , It creates Squid Log
 Reports in HTML formats, looks beautiful, Variety of option given in 
the tool for Daily, Weekly, Monthly Report . helps us to view how much 
bandwidth is utilized by individual machines on the network. 
 
This article is tested on centOS 5.4 
 
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZZQWoqwgBWkKPyxK0RnlNO-_LL_PbIVfUyKAIIrgBaZLVSgYYV_qAQfTYR1Lr6pkB8p2hp_5_y036wCEj5tFUCXvEOU0UrZugb_2tSRZ5goDpTnzEi0nIRfiyA5mkgzBryZ8VK8wDlJKT/s1600/Sarg+pic+2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhZZQWoqwgBWkKPyxK0RnlNO-_LL_PbIVfUyKAIIrgBaZLVSgYYV_qAQfTYR1Lr6pkB8p2hp_5_y036wCEj5tFUCXvEOU0UrZugb_2tSRZ5goDpTnzEi0nIRfiyA5mkgzBryZ8VK8wDlJKT/s320/Sarg+pic+2.png" width="320" /></a></div>
<h2 class="block-title" style="text-align: left;">
Step by step Installation of SARG </h2>
Step 1:  Install required packages
# yum install –y gcc 
# yum install –y gd 
# yum install –y gd-devel 
# yum install –y make 
# yum install –y perl-GD 
# yum install –y wget 
# yum install –y httpd 
 
Step 2: Download and Install SARG 
# wget http://garr.dl.sourceforge.net/project/sarg/sarg/sarg-2.3.7/sarg-2.3.7.tar.gz 
# tar -xvzf sarg-2.3.7.tar.gz 
# cd sarg-2.3.7 
# ./configure 
# make 
# make install 
 
Step3: Configure SARG 
Edit Sarg Configuration File for Access Log Path,Output Directory,Date Format, Overwrite report for same date 
# vi /usr/local/etc/sarg.conf 
Search 
#access_log /usr/local/squid/var/logs/access.log 
Put actual log location 
access_log /usr/local/squid/var/logs/access.log 
un comment 
output_dir /var/www/html/squid-reports 
un comment date format, to view correct date format modify 
#date_format u      <—–change this 
date_format e 
Note : ‘date_format e‘ will display reports in ‘dd/mm/yy‘ format. 
Un comment 
#overwrite_report no 
overwrite_report yes  <–change this means report date already exist then will be overwritten 
now save the config file, modification is over 
 
Step 4: Generation Sarg Report 
# sarg –x 
SARG: Init 
SARG: Loading configuration from /usr/local/etc/sarg.conf 
SARG: Parameters: 
SARG:           Hostname or IP address (-a) = 
SARG:                   Useragent log (-b) = 
SARG:                     Exclude file (-c) = 
SARG:                 Date from-until (-d) = 
SARG:   Email address to send reports (-e) = 
SARG:                     Config file (-f) =  /usr/local/etc/sarg.conf 
SARG:                     Date format (-g) =  Europe (dd/mm/yyyy) 
SARG:                       IP report (-i) = No 
SARG:             Keep temporary files (-k) = No 
SARG:                        Input log (-l) = /var/log/squid/access.log 
SARG:               Resolve IP Address (-n) = No 
SARG:                       Output dir (-o) = /var/www/html/squid-reports/ 
SARG: Use Ip Address instead of userid (-p) = No 
SARG:                  Accessed site (-s) = 
SARG:                             Time (-t) = 
SARG:                             User (-u) = 
SARG:                   Temporary dir (-w) = /tmp/sarg 
SARG:                   Debug messages (-x) = Yes 
SARG:                 Process messages (-z) = No 
SARG: Previous reports to keep (–lastlog) = 0 
SARG: 
SARG: sarg version: 2.3.7 May-30-2013 
SARG: Reading access log file: /var/log/squid/access.log 
SARG: Records in file: 624, reading: 100.00% 
SARG:   Records read: 624, written: 624, excluded: 0 
SARG: Squid log format 
SARG: Period: 12 Jun 2015 
SARG: Sorting log /tmp/sarg/192_168_0_155.user_unsort 
SARG: Making file: /tmp/sarg/192_168_0_155 
SARG: Sorting file: /tmp/sarg/192_168_0_155.utmp 
SARG: Making report: 192.168.0.155 
SARG: Making index.html 
SARG: Successful report generated on /var/www/html/squid-reports/12Jun2015-12Jun2015 
SARG: Purging temporary file sarg-general 
SARG: End 
 
Step 5: Assessing SARG Report 
Sarg will generate reports in ‘/var/www/html/squid-reports directory, Which can be accessed from the web browser using the address. 
<a href="http://192.168.0.65/squid-reports/">http://192.168.0.65/squid-reports/</a> 
 
   Figure 1 
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuaX8vwFj0EzB0Y4srY3j1UN7f0FdpsUBbcX4_60S9SEZ2Q3lJqxUKkencNLH3WI8yBOvW6StQYl4jaqpDGWrgCqEt87HD1qVrB81SiXbQ_Ti1B5m2jzDE5Ng4rCZO6CHQRpPhcRCskFWb/s1600/Sarg+figure+1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuaX8vwFj0EzB0Y4srY3j1UN7f0FdpsUBbcX4_60S9SEZ2Q3lJqxUKkencNLH3WI8yBOvW6StQYl4jaqpDGWrgCqEt87HD1qVrB81SiXbQ_Ti1B5m2jzDE5Ng4rCZO6CHQRpPhcRCskFWb/s1600/Sarg+figure+1.png" /> </a></div>
<div class="separator" style="clear: both; text-align: center;">
 </div>
 Figure 2  
 
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjy0IRVsxb4rmRwIBdi6CtuwQbLdQSeVALm6F5dXgqB6ULxm6skJ-tF0AvhMuNHYLe7_yUJ_5ZjbhaeM-I6UdB8blOhlgPvmP8-ptRK4Qsxm4ScRGzmAljyv5gVgvHZ4lGzCikOr06yvsPK/s1600/sarg+figure+2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjy0IRVsxb4rmRwIBdi6CtuwQbLdQSeVALm6F5dXgqB6ULxm6skJ-tF0AvhMuNHYLe7_yUJ_5ZjbhaeM-I6UdB8blOhlgPvmP8-ptRK4Qsxm4ScRGzmAljyv5gVgvHZ4lGzCikOr06yvsPK/s1600/sarg+figure+2.png" /></a></div>
 
 Figure 3 
 
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgoqWO0I7uwDp1E15ztMieJn8Fip0tn8zyaukjNNRFcZlJFmkeTNippBpBmL5-d-YIkMh1tewIfkvnjTQeBhnUcXM8qCp7Obv2_V4EWp3Sf_C5TJzkTQeMLJtBnq1k9WkAX7t0dHT0LEw-v/s1600/sarg+figure+3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgoqWO0I7uwDp1E15ztMieJn8Fip0tn8zyaukjNNRFcZlJFmkeTNippBpBmL5-d-YIkMh1tewIfkvnjTQeBhnUcXM8qCp7Obv2_V4EWp3Sf_C5TJzkTQeMLJtBnq1k9WkAX7t0dHT0LEw-v/s1600/sarg+figure+3.png" /></a></div>
 
 
Step 6:  Scheduling for Generate SARG Report 
 
# crontab –e 
*/2   * * * * /usr/local/bin/sarg –x   
 
Above cron will generate report evry two hours, modify as per your need 
That’s it  !! 
 </div>

SARG Report Generator :: Squid Log Analysis

SARG is a Open Source Tool, FREE and under GPL , It creates Squid Log Reports in HTML formats, looks beautiful, Variety of option...

LinuxGateway

SARG Report Generator :: Squid Log Analysis

Twitter

Facebook

Google+

Contact Form