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 563.8k 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.
    • marcellocM
      marcelloc
      last edited by

      Sarg service will only show as running only on report updates, It's run by cron.

      Better if I remove it from service list.

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

      Help a community developer! ;D

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

        Dlawley,

        Can you try to run sarg on console/ssh and post the response?

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

        Help a community developer! ;D

        1 Reply Last reply Reply Quote 0
        • D
          dlawley
          last edited by

          @marcelloc:

          Dlawley,

          Can you try to run sarg on console/ssh and post the response?

          
          [2.0.1-RELEASE][root@pfsense.localdomain]/root(3): sarg
          SARG: Records in file: 10434, reading: 100.00%
          SARG: Successful report generated on /usr/local/www/sarg-reports/2012/03/31
          [2.0.1-RELEASE][root@pfsense.localdomain]/root(4): 
          
          

          Had to make the "after action" command to rotate and restart to get more data..

          Since I seem to be getting some data of various degrees I think I may flush out sarg report directory and let things restart.  I can't say for sure what I'm seeing is results from any of my changed settings.

          
          [2.0.1-RELEASE][root@pfsense.localdomain]/root(6): sarg -z
          SARG: TAG: access_log /var/squid/logs/access.log
          SARG: TAG: graphs yes
          SARG: TAG: output_dir /usr/local/www/sarg-reports
          SARG: TAG: anonymous_output_files no
          SARG: TAG: resolve_ip no
          SARG: TAG: user_ip no
          SARG: TAG: topuser_sort_field BYTES NORMAL
          SARG: TAG: user_sort_field BYTES NORMAL
          SARG: TAG: exclude_users /usr/local/etc/sarg/exclude_users.conf
          SARG: TAG: exclude_hosts /usr/local/etc/sarg/exclude_hosts.conf
          SARG: TAG: remove_temp_files yes
          SARG: TAG: index yes
          SARG: TAG: index_tree date
          SARG: TAG: overwrite_report no
          SARG: TAG: use_comma yes
          SARG: TAG: exclude_codes /usr/local/etc/sarg/exclude_codes
          SARG: TAG: report_type topusers topsites sites_users users_sites date_time denied auth_failures site_user_time_date downloads
          SARG: TAG: usertab
          SARG: TAG: long_url no
          SARG: TAG: charset UTF-8
          SARG: TAG: privacy no
          SARG: TAG: dansguardian_conf
          SARG: TAG: squidguard_conf
          SARG: TAG: show_sarg_info no
          SARG: TAG: show_sarg_logo no
          SARG: TAG: www_document_root /usr/local/www
          SARG: TAG: realtime_refresh_time 0
          SARG: TAG: realtime_types GET,PUT,CONNECT
          SARG: TAG: realtime_unauthenticated_records show
          SARG: Records in file: 10490, reading: 100.00%
          SARG: (info) date=31/03/2012
          SARG: (info) period=2012 Mar 31
          SARG: (info) outdirname=/usr/local/www/sarg-reports/2012/03/31
          SARG: (info) Dansguardian report not produced because no dansguardian configuration file was provided
          SARG: (info) No redirector logs provided to produce that kind of report
          SARG: (info) Denied report not produced because it is empty
          SARG: (info) Authentication failures report not produced because it is empty
          SARG: (info) Redirector report not generated because it is empty
          SARG: Successful report generated on /usr/local/www/sarg-reports/2012/03/31
          [2.0.1-RELEASE][root@pfsense.localdomain]/root(7): 
          
          
          1 Reply Last reply Reply Quote 0
          • D
            dlawley
            last edited by

            Clear out the sarg report folder, flush out firefox cache.  I might be ok now..  I think all links are working now.

            See what tomorrow brings

            tx

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

              Get this error on reports tab

              Warning: file_get_contents(/usr/local/www/sarg-reports/index.html): failed to open stream: No such file or directory in /usr/local/www/sarg_frame.php on line 41

              And this in system logs

              php: /pkg_edit.php: The command '/usr/local/bin/sarg ' returned exit code '1', the output was 'SARG: Records in file: 100, reading: 0.00%^MSARG: cannot open /usr/local/www/sarg-reports/2012/03/31/sarg-date for writing SARG:: No such file or directory SARG: Records in file: 100, reading: 100.00%'

              1 Reply Last reply Reply Quote 0
              • D
                dlawley
                last edited by

                firefox and chrome show different pages/reports

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

                  @asterix:

                  Warning: file_get_contents(/usr/local/www/sarg-reports/index.html): failed to open stream: No such file or directory in /usr/local/www/sarg_frame.php on line 41

                  And this in system logs

                  php: /pkg_edit.php: The command '/usr/local/bin/sarg ' returned exit code '1', the output was 'SARG: Records in file: 100, reading: 0.00%^MSARG: cannot open /usr/local/www/sarg-reports/2012/03/31/sarg-date for writing SARG:: No such file or directory SARG: Records in file: 100, reading: 100.00%'

                  I've included a file check in report page. I'll do more tests before commit.

                  You may need to change folder permissions or empty sarg-reports folder before trying to run sarg again.

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

                  Help a community developer! ;D

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

                    @Cino:

                    nothing is shown… I click on the button, it changes to running but nothing is displayed

                    Can you try to run this realtime page using firefox with firebug(network tab) enabled to see if there is any error on it.

                    I'm using current code on a test machine and it's showing realtime log without issues.

                    sarg_realtime.png
                    sarg_realtime.png_thumb

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

                    Help a community developer! ;D

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

                      Hi Marcello,

                      Just wanted to report the latest update is working as expected on our system.  Thanks again for your efforts.

                      I'll be watching for the email reports option.  8)

                      take care and have a great day,
                      greg

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

                        everything looks good, no errors and the page refreshes based on update frequency…. I'll keep testing..... Its probably just my box, begging for a fresh install of pfsense....lol

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

                          Hi.

                          Does someone have test on nanobsd?

                          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:

                            Does someone have test on nanobsd?

                            Not yet.

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

                            Help a community developer! ;D

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

                              Went the nanobsd arrive I will help testing, 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:

                                Went the nanobsd arrive I will help testing, thanks  :)

                                squid 2.x does not log on nanobsd installs.

                                Are you running dansguardian?

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

                                Help a community developer! ;D

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

                                  I enable logs in nanobsd and have been using sarg for a while with success, 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

                                    great!  :)

                                    I'll commit squidguard functions to sarg until friday.

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

                                    Help a community developer! ;D

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

                                      Hi Marcello,

                                      will you (or is there) include a method to sort the reports?  For example,  when viewing "top sites",  it sorts the list by amount of 'hits' by default,  I'd like to sort by amount of data transferred if possible.

                                      with the proliferation of web apps,  hits don't really mean as much as they once did in these types of reports.  as an example I've seen one user generate over 20k hits on teamviewer.com in one day.

                                      thanks again,
                                      greg

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

                                        @gwhynott:

                                        Hi Marcello,

                                        will you (or is there) include a method to sort the reports?   For example,  when viewing "top sites",  it sorts the list by amount of 'hits' by default,   I'd like to sort by amount of data transferred if possible.

                                        with the proliferation of web apps,  hits don't really mean as much as they once did in these types of reports.  as an example I've seen one user generate over 20k hits on teamviewer.com in one day.

                                        thanks again,
                                        greg

                                        @marcelloc there is a way to sort that is built in, kinda… check the default conf file for 'TAG: sorttable path'. Javascript sorttable.js would need to be added, from http://www.kryogenix.org/code/browser/sorttable/.

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

                                          Thanks cino.

                                          I'm merging a contribution for squidguard reports from ccesario and then I'll take a look on it.

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

                                          Help a community developer! ;D

                                          1 Reply Last reply Reply Quote 0
                                          • B
                                            bitskiller
                                            last edited by

                                            report on firefox no work!!!  ??? fine on google chrome  ;D

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