Tutorial: How to Install SquidAnalyzer 6.5 on pfSense 2.4

doktornotor

SquidAnalyzer is in marcello's unofficial repo, whole lot better way to install than this manual messing.

For 2.4, use


fetch -q -o /usr/local/etc/pkg/repos/Unofficial.conf https://raw.githubusercontent.com/marcelloc/Unofficial-pfSense-packages/master/Unofficial.24.conf

KOM

SquidAnalyzer is in marcello's unofficial repo, whole lot better way to install than this manual messing.
fetch -q -o /usr/local/etc/pkg/repos/Unofficial.conf https://github.com/marcelloc/Unofficial-pfSense-packages/blob/master/Unofficial.24.conf

Hmm. The command succeeds without error but there is nothing in the Package Manager when you check it afterwards.

doktornotor

You need to go to the installed packages tab (or otherwise trigger pkg update).

KOM

You need to go to the installed packages tab (or otherwise trigger pkg update).

Already did that and it didn't make any difference but it did give me a clue. Shelling in and running pkg update manually gave this:

pkg: Error parsing: '/usr/local/etc/pkg/repos//Unofficial.conf': error while parsing <unknown>: line: 7, column: 0 - 'key must begin with a letter', character: '<'</unknown>

Edit: OK, it appears that when you run

fetch -q -o /usr/local/etc/pkg/repos/Unofficial.conf https://github.com/marcelloc/Unofficial-pfSense-packages/blob/master/Unofficial.24.conf

You are getting the HTML of that particular Github webpage and not the file contents. My Unofficial.conf was stuffed with bogus HTML.

When I visited the page and saw the actual 6 lines of code, I made my own config and it's now showing E2Guardian4 as expected.

KOM

Read my edit.

doktornotor

Fixed the link.

Topper727

Just about looking close enough to a real package to install now.. If I had knowledge on how I would make official.

Biscuitsntea

Thank you everyone for showing me a more concise way. I appreciate the help. Glad to see package moving forward.

Ximulate

Followed the instructions here to fetch marcello's unofficial repo and installed squidanalyzer, which went fine. However, report isn't loading. Getting:

Error: Could not find report index file.
Check and save Squid Analyzer settings.

Edit: My settings:
Squid Log Analyzer > General Settings > Squid Log : /var/squid/logs/access.log
Services > Proxy Server > General > Enable Access Logging: Enabled
Services > Proxy Server > General > Log Store Directory: /var/squid/logs

Using Putty to SSH to shell, as Admin, I can access the /var/squid/logs and verify the log files are there. If I SSH as a User, I can't access the /var/squid directory. I assume all this has to do with permissions. I also assume the permissions are set this way for a reason.

Ximulate

Any suggestions about how to get the Squidanalyser reports to work?

maikcat

after installing & enable squidanalyzer you do need to run /usr/local/bin/squid-analyzer manually

at least this worked for me…

Michael.

Ximulate

That worked. Thank you!

blaze1119

This post is deleted!

blaze1119

This post is deleted!

kasalencar

@doktornotor mesmo instalando o repositório não oficial, e buscando o pacote, ele gera essa recomendações de conf mesmo:

Após instalar o pacote temos a seguinte recomendação. Você consegue executar?

Modify your httpd.conf to allow access to HTML output like follow:
Alias /squidreport /usr/local/www/squidreport

Options -Indexes FollowSymLinks MultiViews
AllowOverride None
Order deny,allow
Deny from all
Allow from 127.0.0.1

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.