Want package for squidanalyzer. INSTRUCTIONS AND FILES TO INSTALL

[Topper727]

https://github.com/darold/squidanalyzer

wonder if we can see this in a package?  I want to see stats from hits and misses and how much to each site and alll

It shows all kinds of good information.. If you find useful I will help set it up manually on your box just https://db.tt/tr4phPVW Dropbox and join this to help me to be able to put a some stuff for you all in my box

[Topper727]

No interest in this being a package?

[KOM]

I'm sure lots are interested but don't have the technical skill to make a package or contribute other than to test and suggest.  If you have the time, perhaps you could write up a quickie post on how to do it so that it can be referenced.  Personally something like this would be a 'nice to have' and not a 'need to have'.  I'd be happy to play around with it though.

[Topper727]

Quickie post?  Not following what you mean.. I did manual install and got it running works good..

[KOM]

Quickie post?  Not following what you mean.

As in a quick guide or list of steps to describe how to get it installed and working.

[Topper727]

Will write one on my day off ok..

[Topper727]

Ok Tools needed.

WINSCP (for your computer) http://winscp.net/download/winscp556setup.exe (windows version)
PUTTY (for your computer) http://the.earth.li/~sgtatham/putty/latest/x86/putty.exe (windows version)
CRON (in PFsense from Packages)

Enabled shell connections in your advanced tab in Pfsense

And these files I compiled. I did them because I don't want to break your firewall
Sorry my data is in them not sure how to clean out yet.

Download https://www.dropbox.com/s/86mgj9yfc7g1f8u/squidanalyzer.rar?dl=0
this file will upload to  into /usr/local/www from your PC where you downloaded them using WINSCP

In putty go to /usr/local/www and run tar -xzf squidanalyzer.rar

This should make a folder in your directory called squidanalyzer.  From this you can go to https://yourfirewallip/squidanalyzer and see data that came from me but not your data yet.  So next steps will provide your data

Download https://www.dropbox.com/s/bjgu1ijzsknlx6t/temp.rar?dl=0
this file will upload to  into / directory (root) from your PC where you downloaded them using WINSCP

In putty go to / and run tar -xzf temp.rar

next install perl
pkg install perl5.16-5.16.3_18 using putty.. If you never used pkg command it will say you have to download and install it.. answer yes and you then run the command again

Now in your browser with the firewall.. go to services and CRON

Add this to a cron job .

cd /temp/squidanalyzer/ && perl squid-analyzer -r -c /etc/squidanalyzer/squidanalyzer.conf /var/squid/logs/access.log

I put it for each hour ..

If this helps you please click the thanks button.
and https://db.tt/tr4phPVW sign up for dropbox so I have more room to put more helpful things

[Cino]

thanks Topper!  I didn't follow your write up, but was able to use the files that you compiled to get it working on my box…

I dont see a FreeBSD port for it :-(  But it's basically a Perl script with a Perl module and a few config files...

[Topper727]

Well hope it works good for you.  I know what you mean.. I will try clean up the install later.. I just finished making virtualbox work on my system so I can run snorby

Give me thanks :)

[Topper727]

And I had to compile it using Make to get those perl files and all that in the download you got. If not done that then you would not have all those files to be able to work.  You can try it right from Github in link in older posts and make your own if you want to try that also.

Glad my work on figuring out how to get it working has given you some help and you have it going

[Cino]

There wasn't anything that needed be compiled. All the files are ready to use right from github. You just have to put them in the right place and have perl working. but thanks again for sharing

[Topper727]

Well for some reason for me when I did it it did not work right out of box.  I had to run make on install file to get it to compile.. Maybe they updated it or something now.  That is cool that just need to move files in and that would work. Make easier to make a package for it.

if someone would make a package

[Cino]

I keep telling myself one of these days i'll make a package… lol...  with this one, perl would have to be added so there would be a pbi instead of just dropping files into pfsense... pbi are like a jail setup for pfSense... keeps the binaries away from the core files.

[Topper727]

So tell me how you like this software?

[Cino]

Dont know yet… need at least a week data to see if its worth it or not.  I like the fact I can have it break out my networks based on subnet... One issue which maybe a show stopped for me, it doesn't like IPv6 addresses... but still need to investigate if its my config or the software

[Topper727]

Well they do good at updating it so maybe they will address that ipv6 issue sometime soon.. I will let you know if I see that
I don't have ipv6 yet here to test with sorry.  I really not like Ipv6 wish it was not so long of length so I could remember them like ipv4

[Cino]

i hear ya on the address length but hostname/dns solves that problem

[Topper727]

Anyone else try this yet?

[xtrgeo]

me, but i do get error when uncompressing temp.rar

Parsing filters is unsupported…

[Topper727]

Sounds like the download was not complete on the file you got.  That would make it not unzip .. maybe try redownloading it