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

    Sarg package for pfsense

    Scheduled Pinned Locked Moved pfSense Packages
    467 Posts 99 Posters 564.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.
    • gwhynottG
      gwhynott
      last edited by

      @marcelloc:

      what log did you selected on sarg settings?

      squidguard features are not finished yet.  :(

      it is squid I'm using Marcello,  here is my config should it help you out.   anything else you would like to see/try let me know.

      [2.0.1-RELEASE][root@gw-master.foobar.com]/usr/local/etc/sarg(11): cat sarg.conf | sed -e '/^#/d' -e '/^$/d'
      access_log /var/squid/logs/access.log
      graphs yes
      output_dir /usr/local/www/sarg-reports
      anonymous_output_files no
      resolve_ip no
      user_ip no
      topuser_sort_field BYTES NORMAL
      user_sort_field BYTES NORMAL
      exclude_users /usr/local/etc/sarg/exclude_users.conf
      remove_temp_files yes
      index yes
      index_tree date
      overwrite_report yes
      use_comma yes
      report_type topusers topsites sites_users users_sites date_time denied auth_failures site_user_time_date downloads
      usertab
      long_url no
      charset UTF-8
      privacy no
      dansguardian_conf
      squidguard_conf
      www_document_root /usr/local/www
      realtime_refresh_time 0
      realtime_types GET,PUT,CONNECT
      realtime_unauthenticated_records show

      -g

      1 Reply Last reply Reply Quote 0
      • marcellocM
        marcelloc
        last edited by

        Thanks cino and gwhynott for your feedback.

        The realtime error is a missing file I've forgot to publish.

        I'll do it today and also check better squid log option.

        try to select both index options on sarg gui to see if it generate files correctly.

        Treinamentos de Elite: http://sys-squad.com

        Help a community developer! ;D

        1 Reply Last reply Reply Quote 0
        • gwhynottG
          gwhynott
          last edited by

          @Cino:

          1: squid on my box is use path /var/squid/log, not /var/squid/logs.. Not sure why…

          lightsquid did that.  I think the package maintainer for lightsquid has since corrected it.  I created a sym link so both locations work, try to keep everyone happy.  8)

          -g

          1 Reply Last reply Reply Quote 0
          • marcellocM
            marcelloc
            last edited by

            @gwhynott:

            lightsquid did that.  I think the package maintainer for lightsquid has since corrected it.   I created a sym link so both locations work, try to keep everyone happy.  8)

            Thanks for the note, I'll try to read it from squid xml info.

            Treinamentos de Elite: http://sys-squad.com

            Help a community developer! ;D

            1 Reply Last reply Reply Quote 0
            • C
              Cino
              last edited by

              @marcelloc:

              Thanks cino and gwhynott for your feedback.

              The realtime error is a missing file I've forgot to publish.

              I'll do it today and also check better squid log option.

              try to select both index options on sarg gui to see if it generate files correctly.

              thanks for quick reply!  I couldn't Force Update Now but manually running the cron job '/usr/local/bin/php /usr/local/www/sarg.php 0' seem to create the pages.. I'll wait an hour and see what happens

              Have to tweak some things now ;-) I like the idea you included commands to run after to rotate the logs… have to play around with this...

              1 Reply Last reply Reply Quote 0
              • C
                Cino
                last edited by

                @gwhynott:

                @Cino:

                1: squid on my box is use path /var/squid/log, not /var/squid/logs.. Not sure why…

                lightsquid did that.  I think the package maintainer for lightsquid has since corrected it.   I created a sym link so both locations work, try to keep everyone happy.  8)

                -g

                good to know! I may create a link myself

                1 Reply Last reply Reply Quote 0
                • marcellocM
                  marcelloc
                  last edited by

                  I've published missing file.  :)

                  Treinamentos de Elite: http://sys-squad.com

                  Help a community developer! ;D

                  1 Reply Last reply Reply Quote 0
                  • C
                    Cino
                    last edited by

                    I should had just copied the file over… Some reason now, sarg.conf isn't updating. File is blank about package re-install

                    I need to do more testing. remove package, reboot box and install it again

                    edit: i manually created the sarg.conf file.... the realtime page doesn't return data but 'sarg -r' from the cmdline does

                    1 Reply Last reply Reply Quote 0
                    • marcellocM
                      marcelloc
                      last edited by

                      I did package reinstall.

                      I'll do some tests too. :(

                      Treinamentos de Elite: http://sys-squad.com

                      Help a community developer! ;D

                      1 Reply Last reply Reply Quote 0
                      • marcellocM
                        marcelloc
                        last edited by

                        Sorry cino, I've updated an old file and now template file is missing  :P

                        Just wait the 15 minutes to reinstall.

                        Treinamentos de Elite: http://sys-squad.com

                        Help a community developer! ;D

                        1 Reply Last reply Reply Quote 0
                        • perikoP
                          periko
                          last edited by

                          yeaaaaa, thanks man I will tested, I have been use this package for a while but my install is manually, love it.
                            How difficult is to download the info in excel,cvs form?

                          One client ask about before.

                          Thanks!!!

                          Necesitan Soporte de Pfsense en México?/Need Pfsense Support in Mexico?
                          www.bajaopensolutions.com
                          https://www.facebook.com/BajaOpenSolutions
                          Quieres aprender PfSense, visita mi canal de youtube:
                          https://www.youtube.com/c/PedroMorenoBOS

                          1 Reply Last reply Reply Quote 0
                          • marcellocM
                            marcelloc
                            last edited by

                            @periko:

                            How difficult is to download the info in excel,cvs form?

                            If it's a built in sarg feature can be done but I saw only html, email or sql like reports.

                            Treinamentos de Elite: http://sys-squad.com

                            Help a community developer! ;D

                            1 Reply Last reply Reply Quote 0
                            • marcellocM
                              marcelloc
                              last edited by

                              Sarg 0.2 is out.

                              • Sarg exclude lists options

                              • bug fixes

                              • gui improvements

                              Treinamentos de Elite: http://sys-squad.com

                              Help a community developer! ;D

                              1 Reply Last reply Reply Quote 0
                              • jimpJ
                                jimp Rebel Alliance Developer Netgate
                                last edited by

                                You should add some screenshots of sample reports to the first post on the thread. Might help people decide if this is right for them (vs lightsquid).

                                Remember: Upvote with the 👍 button for any user/post you find to be helpful, informative, or deserving of recognition!

                                Need help fast? Netgate Global Support!

                                Do not Chat/PM for help!

                                1 Reply Last reply Reply Quote 0
                                • marcellocM
                                  marcelloc
                                  last edited by

                                  @jimp:

                                  You should add some screenshots of sample reports to the first post on the thread. Might help people decide if this is right for them (vs lightsquid).

                                  done  :) Thanks Jimp!

                                  Treinamentos de Elite: http://sys-squad.com

                                  Help a community developer! ;D

                                  1 Reply Last reply Reply Quote 0
                                  • jimpJ
                                    jimp Rebel Alliance Developer Netgate
                                    last edited by

                                    Nice :-)

                                    Is that in an iframe? I had problems trying to make lightsquid do that, it was cached very aggressively and the data would never update even when I refreshed, I had to clear the cache to get some pages to reload, so I abandoned doing it that way.

                                    Remember: Upvote with the 👍 button for any user/post you find to be helpful, informative, or deserving of recognition!

                                    Need help fast? Netgate Global Support!

                                    Do not Chat/PM for help!

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

                                      I was having problems to view the report page. Always I clicked View report tab i got a 404 error, as you can see in the next image.

                                      So I decided to look in the code of "sarg_reports.php" and I found this line:

                                      <iframe src="/sarg-reports/" frameborder="0" width="100%" height="600"></iframe>
                                      

                                      and I changed to

                                      <iframe src="/sarg-reports/index.html" frameborder="0" width="100%" height="600"></iframe>
                                      

                                      And now every works fine!

                                      Thank you for this excellent package!!

                                      1 Reply Last reply Reply Quote 0
                                      • marcellocM
                                        marcelloc
                                        last edited by

                                        @jimp:

                                        Is that in an iframe? I had problems trying to make lightsquid do that, it was cached very aggressively and the data would never update even when I refreshed, I had to clear the cache to get some pages to reload, so I abandoned doing it that way.

                                        The realtime is ajax but report is iframed. I'll check if this cache issue is happening, If so I'll do some ajax with replaces to keep it on gui.

                                        Treinamentos de Elite: http://sys-squad.com

                                        Help a community developer! ;D

                                        1 Reply Last reply Reply Quote 0
                                        • marcellocM
                                          marcelloc
                                          last edited by

                                          @saxonbeta:

                                          So I decided to look in the code of "sarg_reports.php" and I found this line:

                                          <iframe src="/sarg-reports/" frameborder="0" width="100%" height="600"></iframe>
                                          

                                          and I changed to

                                          <iframe src="/sarg-reports/index.html" frameborder="0" width="100%" height="600"></iframe>
                                          

                                          And now every works fine!

                                          Thanks saxonbeta for your feedback, I'll test it and also the cache issue today.

                                          Treinamentos de Elite: http://sys-squad.com

                                          Help a community developer! ;D

                                          1 Reply Last reply Reply Quote 0
                                          • marcellocM
                                            marcelloc
                                            last edited by

                                            updated sarg to 0.2.1 with report tab without cache(as well as I've tested). ;)

                                            Treinamentos de Elite: http://sys-squad.com

                                            Help a community developer! ;D

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