Want package for squidanalyzer. INSTRUCTIONS AND FILES TO INSTALL

felda

Had a few issues getting this installed, but got it all figured out after a little bit of tinkering on pfSense 2.3.3 and SquidAnalyzer 6.5

My biggest problem was cron not running the task for some reason.
I adjusted the cron command to:

/usr/local/bin/perl /usr/local/bin/squid-analyzer

The second issue I ran into was this error being thrown at me when I visited specific pages in the report.

Mar 16 15:02:07 pfSense pfsense.rrm.local nginx: 2017/03/16 15:02:07 [error] 30129#100219: *234503 open() "/usr/local/www/squidreport/images/up-arrow.png" failed (2: No such file or directory), client: 192.168.16.101, server: , request: "GET /squidreport/images/up-arrow.png HTTP/1.1", host: "192.168.16.1", referrer: "http://192.168.16.1/squidreport/squidanalyzer.css"

My install of SquidAnalyzer didn't come with up-arrow.png for some reason.
To fix this you just need to put a 16x16 .PNG picture inside of /usr/local/www/squidreport/images folder
You can remotely connect using WinSCP and manually put your own file or you can just copy an icon already in that directory.
Run the following command from shell to copy the back arrow image and use it as the up arrow image.

cd /usr/local/www/squidreport/images
cp back-arrow.png up-arrow.png

If you want Squid Analyzer to include SquidGuard blocked / denied pages you can modify the log files it pulls in the config file at /usr/local/etc/squidreports/squidanalyzer.conf
Using a comma to separate the list.

# Set the path to the Squid, squidGuard and/or ufdbGuard log files
LogFile	/var/squid/logs/access.log,/var/squidGuard/log/block.log

The full SquidAnalyzer readme that can help you fully customize the reports to your needs. https://github.com/darold/squidanalyzer/blob/master/README

andyschmid

@felda:

My biggest problem was cron not running the task for some reason.
I adjusted the cron command to:
/usr/local/bin/perl /usr/local/bin/squid-analyzer

I had the same issue and just to add the problem is the shebang in the first line of /usr/local/bin/squid-analyzer file:

#!/usr/bin/env perl

This tries to read environment variable for perl and depending from where you execute it they might exist or not. If executing via cron the environment variables for perl don't exist hence the script fails.

To fix you can change the first line of /usr/local/bin/squid-analyzer to:

#!/usr/local/bin/perl

This makes the script less pflexible but will ensure you can just execute "/usr/local/bin/squid-analyzer" instead of doing the "cd /usr/local/bin/ && perl squid-analyzer" or "/usr/local/bin/perl /usr/local/bin/squid-analyzer"

marcelloc

The package options looks similar to sarg package.

Do you think it's a good idea to create a gui for it on it on Unofficial pfSense package repo?

https://github.com/marcelloc/Unofficial-pfSense-packages

marcelloc

I've included the squidanalyzer package on my Unofficial repo. It includes all steps I found on english and portuguese forum and added a php file to protect report files using pfSense authetication.

more screenshots form the project on github

http://freecode.com/projects/squidanalyzer/screenshots

report_permissions.PNG_thumb

squidanalyzer.png_thumb

squidanalyzer_php.PNG_thumb

Cino

Thank you Marcelloc!!

Works pretty good. I do have a thought, would it be better to use location: '/var/squidreport' instead of '/usr/local/squidreport' ?

marcelloc

@Cino:

Thank you Marcelloc!!

Works pretty good. I do have a thought, would it be better to use location: '/var/squidreport' instead of '/usr/local/squidreport' ?

I'll see. Is there any pfSense version that cleans /var on boot?

Cino

idk the answer to that.. but lightsquid reports are stored at '/var/lightsquid' (define('LS_REPORTPATH', '/var/lightsquid/report');)

jetberrocal

@marcelloc:

I've included the squidanalyzer package on my Unofficial repo. It includes all steps I found on english and portuguese forum and added a php file to protect report files using pfSense authetication.

more screenshots form the project on github

http://freecode.com/projects/squidanalyzer/screenshots

I see the screen shots with some beautiful graphs, but I do not see the list of users nor the denied sites tables, nor the accessed sites tables.

And if used with e2guardian squid format logs the reason for blocking table.

Topper727

In trying to setup this in my new pfsense 2.4 .. will work on 2.4 but not on 2.3.4 please note. Easy setup..

https://forum.pfsense.org/index.php?topic=127299.0

kasalencar

@marcelloc Instalei o squidanalyzer após ativar o seu repositórios não oficial. Após instalação ainda apresenta as seguintes recomendações:

Modify your httpd.conf to allow access to HTML output like follow:
Alias /squidreport /usr/local/www/squidreport
<Directory /usr/local/www/squidreport>
Options -Indexes FollowSymLinks MultiViews
AllowOverride None
Order deny,allow
Deny from all
Allow from 127.0.0.1
</Directory>
If necessary, give additional host access to SquidAnalyzer in httpd.conf.
Restart and ensure that httpd is running.
Browse to http://my.host.dom/squidreport/ to ensure that things are working
properly.
Setup a cronjob to run squid-analyzer daily:

SquidAnalyzer log reporting daily

0 2 * * * /usr/local/bin/squid-analyzer > /dev/null 2>&1

or run it manually.
For more information, see /usr/local/share/doc/squidanalyzer/README file.

Cleaning up cache... done.

Poderia ajduar?

Want package for squidanalyzer. INSTRUCTIONS AND FILES TO INSTALL

SquidAnalyzer log reporting daily