Netgate Discussion Forum
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Search
    • Register
    • Login

    Want package for squidanalyzer. INSTRUCTIONS AND FILES TO INSTALL

    Scheduled Pinned Locked Moved Cache/Proxy
    94 Posts 18 Posters 29.0k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • S
      sacaman
      last edited by

      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)

      1 Reply Last reply Reply Quote 0
      • Z
        zass
        last edited by

        Tq Topper727 and sacaman !

        1 Reply Last reply Reply Quote 0
        • T
          Topper727
          last edited by

          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

          Dell 2950 g3 server
          Intel(R) Xeon(R) CPU E5430 @ 2.66GHz
          Current: 2000 MHz, Max: 2667 MHz
          8 CPUs: 2 package(s) x 4 core(s)
          8152 MiB and 600meg 10k drive
          Pfsense 2.4 .. Hoping to get the phpvirtualbox going again.

          1 Reply Last reply Reply Quote 0
          • KOMK
            KOM
            last edited by

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

            1 Reply Last reply Reply Quote 0
            • T
              Topper727
              last edited by

              @zass:

              Tq Topper727 and sacaman !

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

              Dell 2950 g3 server
              Intel(R) Xeon(R) CPU E5430 @ 2.66GHz
              Current: 2000 MHz, Max: 2667 MHz
              8 CPUs: 2 package(s) x 4 core(s)
              8152 MiB and 600meg 10k drive
              Pfsense 2.4 .. Hoping to get the phpvirtualbox going again.

              1 Reply Last reply Reply Quote 0
              • T
                Topper727
                last edited by

                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

                Dell 2950 g3 server
                Intel(R) Xeon(R) CPU E5430 @ 2.66GHz
                Current: 2000 MHz, Max: 2667 MHz
                8 CPUs: 2 package(s) x 4 core(s)
                8152 MiB and 600meg 10k drive
                Pfsense 2.4 .. Hoping to get the phpvirtualbox going again.

                1 Reply Last reply Reply Quote 0
                • T
                  Topper727
                  last edited by

                  @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

                  Dell 2950 g3 server
                  Intel(R) Xeon(R) CPU E5430 @ 2.66GHz
                  Current: 2000 MHz, Max: 2667 MHz
                  8 CPUs: 2 package(s) x 4 core(s)
                  8152 MiB and 600meg 10k drive
                  Pfsense 2.4 .. Hoping to get the phpvirtualbox going again.

                  1 Reply Last reply Reply Quote 0
                  • S
                    sacaman
                    last edited by

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

                    1 Reply Last reply Reply Quote 0
                    • KOMK
                      KOM
                      last edited by

                      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.

                      1 Reply Last reply Reply Quote 0
                      • S
                        sacaman
                        last edited by

                        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

                        1 Reply Last reply Reply Quote 0
                        • KOMK
                          KOM
                          last edited by

                          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.

                          1 Reply Last reply Reply Quote 0
                          • S
                            sacaman
                            last edited by

                            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

                            1 Reply Last reply Reply Quote 0
                            • KOMK
                              KOM
                              last edited by

                              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.

                              1 Reply Last reply Reply Quote 0
                              • KOMK
                                KOM
                                last edited by

                                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?

                                1 Reply Last reply Reply Quote 0
                                • S
                                  sacaman
                                  last edited by

                                  try only this command in terminal

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

                                  1 Reply Last reply Reply Quote 0
                                  • KOMK
                                    KOM
                                    last edited by

                                    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)

                                    1 Reply Last reply Reply Quote 0
                                    • KOMK
                                      KOM
                                      last edited by

                                      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.

                                      1 Reply Last reply Reply Quote 0
                                      • T
                                        Topper727
                                        last edited by

                                        Sorry been busy and not around to help

                                        Dell 2950 g3 server
                                        Intel(R) Xeon(R) CPU E5430 @ 2.66GHz
                                        Current: 2000 MHz, Max: 2667 MHz
                                        8 CPUs: 2 package(s) x 4 core(s)
                                        8152 MiB and 600meg 10k drive
                                        Pfsense 2.4 .. Hoping to get the phpvirtualbox going again.

                                        1 Reply Last reply Reply Quote 0
                                        • KOMK
                                          KOM
                                          last edited by

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

                                          1 Reply Last reply Reply Quote 0
                                          • A
                                            acc4ever
                                            last edited by

                                            Guys, thank you very much for this How-To … I was able to install SquidAnalyzer v6.1, It works really good ...

                                            Topper727, can you compile/port the new version ?

                                            Thanx in advance

                                            1 Reply Last reply Reply Quote 0
                                            • First post
                                              Last post
                                            Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.