darold / squidanalyzer

Squid Analyzer parses Squid proxy access log and reports general statistics about hits, bytes, users, networks, top URLs, and top second level domains. Statistic reports are oriented toward user and bandwidth control.
http://squidanalyzer.darold.net/
125 stars 36 forks source link

Customize user report #190

Closed neok7 closed 5 years ago

neok7 commented 5 years ago

Hello Darold, first of all congratulations for this excellent piece of software.

I'm using squidanalyzer 6.6 and my squid authenticates users against my AD. I would like to know if I can customize the output of user.html so that it doesn't show in the report the PC or IP names as I show in the screenshot. In the cases that appear the names of PC or IP is because the user was not logged in his session but the windows PC made a connection that was rejected by squid. I would like to know what options I have to "clean" the report and only show me the user name. Thank you very much for any help! Best regards

Gabriel

captura

darold commented 5 years ago

I have patched SquidAnalyzer.pm to skip report of users when there is no hits in commit 2680b33. That should do what you are requiring. Can you test last development code and let me know?

neok7 commented 5 years ago

Of course! I will return with the results later.

neok7 commented 5 years ago

Hello Darold, I've added the 4 lines of the commit to the files: /opt/squidanalyzer/SquidAnalyzer.pm and /opt/squidanalyzer/blib/lib/SquidAnalyzer.pm Then I deleted the files index.html, SquidAnalyzer.current and the entire 2018 folder from /var/www/squidanalyzer I ran again /usr/local/bin/squid-analyzer When entering Users there are still present registers with IP or PC Name values of 0.

Is there something I did wrong? Any information you need I'm here.

P.S.: I made sure twice to copy the 4 lines in the correct order.

darold commented 5 years ago

The problem here is that you have removed file SquidAnalyzer.current and rerun squid-analyzer. Your statistics should be false now. To restore the right statistics you should remove everything in /var/www/squidanalyzer and rerun squid-analyzer.

To apply a code update you should proceed as follow :

wget https://github.com/darold/squidanalyzer/archive/master.zip
unzip master.zip
cd squidanalyzer-master/
perl Makefile.PL
make
sudo make install

then rebuild all the reports using:

squid-analyser --rebuild
darold commented 5 years ago

Forgot to said that if you have installed SquidAnalyzer in /opt/squidanalyzer/ you should adapt the command perl Makefile.PL or if you have simply unzip/untar SquidAnalyzer code into /opt/squidanalyzer/ just override the files.

neok7 commented 5 years ago

Excellent Darold, I did as you told me and now I have a clean and clear report. Thank you very much! Best regards Gabriel

darold commented 5 years ago

Thanks for the feedback, I have added an Upgrade section to documentation with the explanation above.