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

    Sarg package for pfsense

    pfSense Packages
    99
    467
    493.4k
    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

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

                @bitskiller:

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

                What version of firefox? I'm using it on firefox11 and chrome without issues.

                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:

                  @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/.

                  I'll try to include this javascript to enable sort change on reports but did you saw user sort field on sarg settings?

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

                  Help a community developer! ;D

                  1 Reply Last reply Reply Quote 0
                  • ExolonE
                    Exolon
                    last edited by

                    I've managed to get Sarg Realtime working but when I try and "View Reports", I get a blank page:

                    Sarg_Realtime.png
                    Sarg_Realtime.png_thumb
                    Sarg_ViewReports.png
                    Sarg_ViewReports.png_thumb

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

                      Try to generate another report after selecting indextree on sarg settings.

                      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.3 is out with date report format ,sortable reports and squidguard.  :)

                        Thanks to cino and ccesario.

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

                        Help a community developer! ;D

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

                          @marcelloc:

                          @bitskiller:

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

                          What version of firefox? I'm using it on firefox11 and chrome without issues.

                          I'm using firefox 11 and does not display my report, if it works well with chrome

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

                            bitskiller,

                            did you tried to refresh the report frame using right-click -> this frame -> reload?

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

                            Help a community developer! ;D

                            1 Reply Last reply Reply Quote 0
                            • ExolonE
                              Exolon
                              last edited by

                              @marcelloc:

                              Try to generate another report after selecting indextree on sarg settings.

                              Thanks, that did it, I now have reports showing.

                              1 Reply Last reply Reply Quote 0
                              • DonnyD
                                Donny
                                last edited by

                                I really interesting SARG but until now I could not find any e-mail option to use it for system log report.

                                Thank u

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

                                  It's not implemented yet.

                                  Mail option will need a mailer daemon running on pfsense like postfix forwarder.

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

                                  Help a community developer! ;D

                                  1 Reply Last reply Reply Quote 0
                                  • DonnyD
                                    Donny
                                    last edited by

                                    @marcelloc:

                                    It's not implemented yet.

                                    Mail option will need a mailer daemon running on pfsense like postfix forwarder.

                                    I have tested SARG many time with Squid-reverse. This is my step
                                    1. I have installed Squid-reverse.
                                    2. I have installed SARG and after that I got some error: Sarg config error:log file () does not exits. I want to know what is wrong?.
                                    3. I tried to change the "userid" or the "ip address" to be a real user name on the reports like this: "172.31.21.22 Donny Van Cooper" but in the "View report and realtime"tab it does not show a real user name. Where can I resolve any ip address on pfSense or I have to resolve any ip address on Domain Controller (Windows Server 2008)
                                    4. I use Firefox web browser also Google Chrome for config SARG and at the "view report" tab dat you said to do is "This frame > reload frame" but some time it does not work I have to do again and again or I have to wait a few second and then report appear.
                                    5. Do I have only to select interface "LAN" or I have to select both "LAN and loopback on Squid-reverse.

                                    Thank u very much

                                    SargError1.png
                                    SargError1.png_thumb
                                    RealName.png
                                    RealName.png_thumb
                                    ViewReport.png
                                    ViewReport.png_thumb

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

                                      @Donny:

                                      2. I have installed SARG and after that I got some error: Sarg config error:log file () does not exits. I want to know what is wrong?.

                                      This maybe a first install bug, I'll check it.

                                      @Donny:

                                      3. I tries to change the "userid" or the "ip address" to be a real user name on the reports like this: "172.31.21.22 Donny Van Cooper" but in the "View report and realtime"tab it does not show a real user name. Where can I resolve any ip address on pfSense or I have to resolve any ip address on Domain Controller (Windows Server 2008)
                                      4. I use Firefox web browser also Google Chrome for config SARG and at the "view report" tab dat you said to do is "This frame > reload frame" but some time it does not work I have to do again and again or I have to wait a few second and then report appear.

                                      did you created any schedule on sarg to create reports?

                                      @Donny:

                                      5. Do I have only to select interface "LAN" or I have to select both "LAN and loopback on Squid-reverse.

                                      Just lan for normal use.

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

                                      Help a community developer! ;D

                                      1 Reply Last reply Reply Quote 0
                                      • DonnyD
                                        Donny
                                        last edited by

                                        @marcelloc:

                                        @Donny:

                                        2. I have installed SARG and after that I got some error: Sarg config error:log file () does not exits. I want to know what is wrong?.

                                        This maybe a first install bug, I'll check it.

                                        @Donny:

                                        3. I tries to change the "userid" or the "ip address" to be a real user name on the reports like this: "172.31.21.22 Donny Van Cooper" but in the "View report and realtime"tab it does not show a real user name. Where can I resolve any ip address on pfSense or I have to resolve any ip address on Domain Controller (Windows Server 2008)
                                        4. I use Firefox web browser also Google Chrome for config SARG and at the "view report" tab dat you said to do is "This frame > reload frame" but some time it does not work I have to do again and again or I have to wait a few second and then report appear.

                                        did you created any schedule on sarg to create reports?

                                        @Donny:

                                        5. Do I have only to select interface "LAN" or I have to select both "LAN and loopback on Squid-reverse.

                                        Just lan for normal use.

                                        Yes, Marcelloc. I have created schedule on sarg to create reports. you can see my screenshot pictures that I post its here but a real user name is still not work.
                                        Thank a lot for your help

                                        ScheduleSarg.png_thumb
                                        ScheduleSarg.png
                                        SargSettings.png_thumb
                                        SargSettings.png

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

                                          check create index tree by file too onsarg config and force a report update.

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

                                          Help a community developer! ;D

                                          1 Reply Last reply Reply Quote 0
                                          • DonnyD
                                            Donny
                                            last edited by

                                            @marcelloc:

                                            check create index tree by file too on sarg config and force a report update.

                                            Hello Marcelloc, I have done what you say but a real user name still not work. as the screenshot below.

                                            Thank u very much. I am tired, I go to bed now.

                                            Users.png
                                            Users.png_thumb

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