Want package for squidanalyzer. INSTRUCTIONS AND FILES TO INSTALL

Topper727

Anyone else try this or using it?

sacaman

hi ,

first thank you for this amazing reporting program

i get a problem that the report is not updated the script is well executed but the report is not showing the daily update

i try it and make it working i a different way

i download your temp file only no need for the www or perl

inside the temp file i execute the file

sh install_all.sh

it will create all the files and path needed

install -m 755 squid-analyzer /usr/local/bin/
install -m 644 resources/sorttable.js /var/www/squidanalyzer/
install -m 644 resources/squidanalyzer.css /var/www/squidanalyzer/
install -m 644 resources/flotr2.js /var/www/squidanalyzer/
install -m 644 resources/images/logo-squidanalyzer.png /var/www/squidanalyzer/images/
install -m 644 resources/images/cursor.png /var/www/squidanalyzer/images/
install -m 644 resources/images/domain.png /var/www/squidanalyzer/images/
install -m 644 resources/images/back-arrow.png /var/www/squidanalyzer/images/
install -m 644 resources/images/info.png /var/www/squidanalyzer/images/
install -m 644 resources/images/network.png /var/www/squidanalyzer/images/
install -m 644 resources/images/user.png /var/www/squidanalyzer/images/
install -m 644 lang/* /etc/squidanalyzer/lang/
pod2text doc/SquidAnalyzer.pod README
pod2man doc/SquidAnalyzer.pod squid-analyzer.3

i make a symlink /var/www/squidanalyzer/ to /usr/local/www/squidanalyzer/

ln /var/www/squidanalyzer/ /usr/local/www/squidanalyzer/

i modify the file /etc/squidanalyzer/squidanalyzer.conf

to meet the real path on pfsense

change this area

Output /usr/local/www/squidanalyzer
WebUrl /squidanalyzer
LogFile /var/squid/logs/access.log

on the cron i need now only

cd /temp/squidanalyzer/ && perl squid-analyzer

and it create a daily report at 9:01 morning

i hope that it help someone to get it working

sacaman

![Screen Shot 2015-02-21 at 2.23.41 PM.png](/public/imported_attachments/1/Screen Shot 2015-02-21 at 2.23.41 PM.png)
![Screen Shot 2015-02-21 at 2.23.41 PM.png_thumb](/public/imported_attachments/1/Screen Shot 2015-02-21 at 2.23.41 PM.png_thumb)

zass

Tq Topper727 and sacaman !

Topper727

That is another way yes. Please note the cron I setup and documented in the first install of this needs to be

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

I have done it with cd /temp/squidanalyzer/ && perl squid-analyzer also if your using my method. good luck to all and message me if need some help

KOM

Wow, this looks really nice. Any idea yet how to clear the previous data?

Topper727

@zass:

Tq Topper727 and sacaman !

Hope everyone gets to try and if likes hits the thanks button help me here on this forum

Topper727

I have found a way. in the /usr/local/www/squidanalyzer folder you will see a 2015 folder if you delete that then run cd /temp/squidanalyzer/ && perl squid-analyzer -c -r /etc/squidanalyzer/squidanalyzer.conf /var/squid/logs/access.log this should erase all data and rebuild it

Topper727

@sacaman:

hi ,

first thank you for this amazing reporting program

i get a problem that the report is not updated the script is well executed but the report is not showing the daily update

i try it and make it working i a different way

i download your temp file only no need for the www or perl

inside the temp file i execute the file

sh install_all.sh

it will create all the files and path needed

install -m 755 squid-analyzer /usr/local/bin/
install -m 644 resources/sorttable.js /var/www/squidanalyzer/
install -m 644 resources/squidanalyzer.css /var/www/squidanalyzer/
install -m 644 resources/flotr2.js /var/www/squidanalyzer/
install -m 644 resources/images/logo-squidanalyzer.png /var/www/squidanalyzer/images/
install -m 644 resources/images/cursor.png /var/www/squidanalyzer/images/
install -m 644 resources/images/domain.png /var/www/squidanalyzer/images/
install -m 644 resources/images/back-arrow.png /var/www/squidanalyzer/images/
install -m 644 resources/images/info.png /var/www/squidanalyzer/images/
install -m 644 resources/images/network.png /var/www/squidanalyzer/images/
install -m 644 resources/images/user.png /var/www/squidanalyzer/images/
install -m 644 lang/* /etc/squidanalyzer/lang/
pod2text doc/SquidAnalyzer.pod README
pod2man doc/SquidAnalyzer.pod squid-analyzer.3

i make a symlink /var/www/squidanalyzer/ to /usr/local/www/squidanalyzer/

ln /var/www/squidanalyzer/ /usr/local/www/squidanalyzer/

i modify the file /etc/squidanalyzer/squidanalyzer.conf

to meet the real path on pfsense

change this area

Output /usr/local/www/squidanalyzer
WebUrl /squidanalyzer
LogFile /var/squid/logs/access.log

on the cron i need now only

cd /temp/squidanalyzer/ && perl squid-analyzer

and it create a daily report at 9:01 morning

i hope that it help someone to get it working

sacaman

Really glad someone did some work to making it more like a package install and maybe someone will turn this into a package

sacaman

Thanks Topper727 it's your discovery i try only to make it working on my system and i share my how to ;)

KOM

When I run the Perl command, I get:

FATAL: No configuration file!

Perl works and I can get to Squidanalyzer's web page without any problem.

sacaman

what method did you try ?

if mine check this path if the file exist
/etc/squidanalyzer/squidanalyzer.conf

and modify this area :

Output /usr/local/www/squidanalyzer
WebUrl /squidanalyzer
LogFile /var/squid/logs/access.log

then run the perl script

KOM

OK, I was doing this on a test server so I rolled it back to default to try again. I got everything in place, but when I installed Perl I got this error:

[1/1] Installing perl5.16-5.16.3_18…
[1/1] Extracting perl5.16-5.16.3_18: 100%
makewhatis: not found
makewhatis: not found
pkg: POST-INSTALL script failed

This seems to be a known problem with FreeBSD 10 with some people saying that Perl is a mess in early 10 release builds, but has been subsequently fixed.

Now perl -v doesn't do anything. I don't know how I had it working before.

Update: It still works via /usr/local/bin/perl. I still get the fatal error though. The command:

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

can't possibly work since there is no /etc/squidanalyzer/squidanalyzer.conf file. The folder /etc/squidanalyzer only gets created if you run the install.sh installer, and at no point does this tutorial mention that.

sacaman

Dear KOM

i get the same problem with other that i can't get the updated report chowing on the man page

and i post my method to get it working on my system

@sacaman:

hi ,

first thank you for this amazing reporting program

i get a problem that the report is not updated the script is well executed but the report is not showing the daily update

i try it and make it working i a different way

i download your temp file only no need for the www or perl

inside the temp file i execute the file

sh install_all.sh

it will create all the files and path needed

install -m 755 squid-analyzer /usr/local/bin/
install -m 644 resources/sorttable.js /var/www/squidanalyzer/
install -m 644 resources/squidanalyzer.css /var/www/squidanalyzer/
install -m 644 resources/flotr2.js /var/www/squidanalyzer/
install -m 644 resources/images/logo-squidanalyzer.png /var/www/squidanalyzer/images/
install -m 644 resources/images/cursor.png /var/www/squidanalyzer/images/
install -m 644 resources/images/domain.png /var/www/squidanalyzer/images/
install -m 644 resources/images/back-arrow.png /var/www/squidanalyzer/images/
install -m 644 resources/images/info.png /var/www/squidanalyzer/images/
install -m 644 resources/images/network.png /var/www/squidanalyzer/images/
install -m 644 resources/images/user.png /var/www/squidanalyzer/images/
install -m 644 lang/* /etc/squidanalyzer/lang/
pod2text doc/SquidAnalyzer.pod README
pod2man doc/SquidAnalyzer.pod squid-analyzer.3

i make a symlink /var/www/squidanalyzer/ to /usr/local/www/squidanalyzer/

ln /var/www/squidanalyzer/ /usr/local/www/squidanalyzer/

i modify the file /etc/squidanalyzer/squidanalyzer.conf

to meet the real path on pfsense

change this area

Output /usr/local/www/squidanalyzer
WebUrl /squidanalyzer
LogFile /var/squid/logs/access.log

on the cron i need now only

cd /temp/squidanalyzer/ && perl squid-analyzer

and it create a daily report at 9:01 morning

i hope that it help someone to get it working

sacaman

please try it as bellow and let me know if it work with you
also you don't need to install perl if you follow my how to

Br

sacaman

KOM

perl: Command not found.

which is to be expected since Perl isn't installed. You must have installed it at some point in the past.

KOM

After manually installing perl and clearing up stupid typos that I insist on making, I got it working on my 2.2-x64 test box. I'm trying to make it work on a 2.1.5-i386 box and it does everything except write the report into the output folder. NO errors, but no output. Hmmm.

Does anyone know if this script will handle archived logs, like access.log.0, access.log.1 etc?

sacaman

try only this command in terminal

cd /temp/squidanalyzer/ && perl squid-analyzer

KOM

The script runs, but it doesn't create any files and there is no error log or anything. Here is the output:

[2.1.5-RELEASE][admin@pfsense.MyDomain.local]/etc/squidanalyzer(137): perl /usr/local/bin/squidanalyzer -d -r -c /etc/squidanalyzer/squidanalyzer.conf /var/squid/logs/access.log
No new log registered…
DEBUG: the log statistics gathering took: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
Building HTML output into /usr/local/www/squidanalyzer
DEBUG: generating HTML output took: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)
DEBUG: total execution time: 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU)

KOM

OK, I managed to get it working by running just this command:

perl /usr/local/bin/squidanalyzer /var/squid/logs/access.log

Just that by itself generated the reports.

Topper727

Sorry been busy and not around to help

KOM

No problem. I've long since given up on it and moved on.