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 504.1k 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

      The frame src should be a sarg_frame.php instead of sarg-reports.

      Can you check if you got these changes?

      What you mean by manual update? File edit or browser refresh?

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

      Help a community developer! ;D

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

        @marcelloc:

        The frame src should be a sarg_frame.php instead of sarg-reports.

        Can you check if you got these changes?

        That's right, the frame source is sarg_frame.php

        @marcelloc:

        What you mean by manual update? File edit or browser refresh?

        It is a browser refresh, using the context menu>reload frame

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

          On my tests everytime I click on report I get the latest index.html ???

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

          Help a community developer! ;D

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

            just a note, with the pkg that was available this am.  glad to see this one back.

            Looks like it can create the directory etc.  This is from the system log

            php: /pkg_edit.php: The command '/usr/local/bin/sarg ' returned exit code '1', the output was 'SARG: Records in file: 174, 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: 174, reading: 100.00%'

            Followup, access via gui give this;

            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

            Sarg Realtime appears to be working ok

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

              @dlawley:

              Sarg Realtime appears to be working ok

              i can't seem to get any data to show in realtime.. only when using the original sarg-realtime.php does it work for me..

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

                Cino,

                What do you get on realtime? Just the headers from sarg?

                The sarg-realtime.php is just a sarg -r frontend.

                Maybe a stupid question but it shows the running info on button?

                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:

                  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

                  Sarg Realtime appears to be working ok

                  Are you running full or nanobsd install?

                  I'll check folder creation code.

                  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:

                    Cino,

                    What do you get on realtime? Just the headers from sarg?

                    The sarg-realtime.php is just a sarg -r frontend.

                    Maybe a stupid question but it shows the running info on button?

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

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

                      @marcelloc:

                      @dlawley:

                      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

                      Sarg Realtime appears to be working ok

                      Are you running full or nanobsd install?

                      I'll check folder creation code.

                      Sorry not to mention that , but it is a full install (not nano)

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

                        @marcelloc:

                        @dlawley:

                        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

                        Sarg Realtime appears to be working ok

                        Are you running full or nanobsd install?

                        I'll check folder creation code.

                        I dunno.  Still not showing the service as "running" , but I am finally starting to see some data.  I just pulled another reinstall, not sure if that helped.

                        1 Reply Last reply Reply Quote 0
                        • 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
                                            • First post
                                              Last post
                                            Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.