I do agree that the SaaS products should be there as a source of revenue for the company, but it should be in the side like backups and remote expert support etc...
Setting up lightsquid is very easy as follows (largely taken from its docs)
Step 1 : Required software - Perl, http server (Apache, lighthttpd, etc), Squid, Cron (most of which are already installed, so no need to do anything)
Step 2 : download lightsquid from
http://lightsquid.sourceforge.netStep 3 :Extract lightsquid.tgz into any folder (handle the version number added to the file name)
#cd /var/www/htdocs/
#mkdir lightsquid
#cd lightsquid
#tar -xzf lightsquid.tgz
Step 4 : set 'executable' flag for scrip
#chmod +x *.cgi
#chmod +x *.pl
Step 5 : change owner (this step may not be required)
#chown -R root:root *
#(where apache = httpd user)
Step 6 : Configure your Apache server
Edit Apache configuration file, at the end of the configuration file add the following code .cgi files must execute as CGI scrip
/etc/apache2/apache2.conf
<Directory "/var/www/lightsquid">
Options +ExecCGI
AddHandler cgi-script .cgi
AllowOverride All
</Directory>
Step 7 : Edit lightsquid.cfg (file is self explanatory )
Step 8 :#run check-setup.pl
if all done try next step
else check config file.
Step 9 :Try run lightparser.pl
if everything is ok no messages will be produced
parse old statistic (to generate report from old log)
./lightparser.pl access.log.1.{gz|bz2}
./lightparser.pl access.log.2.{gz|bz2}
./lightparser.pl access.log.3.{gz|bz2}
Step 10 : All done, now check the report
Using your favorite browser enter http://<ip address where we live>/lightsquid/
Optional :Step 11 : Edit following file for better reports
If you want GROUP reports - edit group.cfg
format:
esl 01 SysAdmin
karlos 01 SysAdmin
Ivanov 02 Developer
Ivanov2 02 Developer
Petrov 03 Commerial
If you want use REALNAME - edit realname.cfg
format:
arun Arun Shrimali
esl Sergey Erokhin
karlos Super User1
Step 12 : Automate the process
Setup crontab to run lightparser once per hour, add the following line
#crontab -e
This example will execute parser every 20 minutes
*/20 * * * * /var/www/htdocs/lightsquid/lightparser.pl today
if you have small log and fast machine, you may run lightparser with smaller delay
warning not set interval less 10 min
That's all,
Best wishes
Arun