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

    Monitoring proxy server squid pfsense 2.0.1 ? how to

    Scheduled Pinned Locked Moved pfSense Packages
    26 Posts 7 Posters 44.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 package has a real-time report viewer for squid.
      squid built in cachemanager.cgi could be an option too.

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

      Help a community developer! ;D

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

        Hi,
        Thanks for your reply.
        I installed package…but it's not working right now i get this:

        Error: Could not find report index file.
        Check sarg settings and try to force sarg schedule.

        I have to create in /var/squid/logs/access.log but i don't know how

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

          Enable squid logs on gui first.

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

          Help a community developer! ;D

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

            Done, it' enable.
            But i still get this Error: Could not find report index file.
                                            Check sarg settings and try to force sarg schedule.
            I add a schedule for one hour i also tryed a real time report…
            I mention that right now proxy is not in use ! service is started but it's not use...(it's a proxy on wan)

            Thanks

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

              what you got on realtime tab?

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

              Help a community developer! ;D

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

                See picture i pusshed show log
                I think is not working because proxy is not use what should be in report if is not use….
                But i don't know why i m getting index eror from above:( still after enable like you said ?

                /var/squid/logs/access.log is there empty now but still...index error

                Thanks ! I just saw that package is created by you and how is working in some posts....i didn't thought that will be so detailed

                untitled1.JPG
                untitled1.JPG_thumb

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

                  From other posts sarg is not using the right path…wich one is the good one /var/squid/log/access.log or /var/squid/logs/access.log ? i copied from /var/squid/logs/access.log in /var/squid/logs/access.log but still nothing...the same error with index

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

                    The path on squid.conf by default is /var/squid/logs/access.log.

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

                    Help a community developer! ;D

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

                      realtime report is working :D i test it when proxy is in use is working fine :D but in view report i still get index error

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

                        @bmironb:

                        realtime report is working :D i test it when proxy is in use is working fine :D but in view report i still get index error

                        good news!

                        now, try to run sarg on console/ssh to see if it return erros.

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

                        Help a community developer! ;D

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

                          Result :

                          SARG: Records in file: 102, reading: 100.00%
                          SARG: Successful report generated on /usr/local/www/sarg-reports/2012/05/07

                          I checked and sites are there in report :D checked manually …with edit file/browse

                          In system logs :

                          May 7 22:00:01 php: : Sarg: force refresh now with '' args and none action after sarg finish.
                          May 7 22:00:01 php: : The command '/usr/local/bin/sarg ' returned exit code '1', the output was 'SARG: Records in file: 103, reading: 0.00%^MSARG: cannot open /usr/local/www/sarg-reports/2012/05/07/sarg-date for writing SARG:: No such file or directory SARG: Records in file: 103, reading: 100.00%'

                          1 Reply Last reply Reply Quote 0
                          • L
                            linuxmaniac
                            last edited by

                            Hai Guys,
                            I found why this error is happening. the sarg_reports.php is looking for the index.html file in sarg-reports/index.html, which is not there. Basically the default installation of sarg in Fedora and Centos is giving us a "report" directory format like the following. /var/www/html/reports/index.html.  This index.html is generated when using  "sarg -x " command ,which contains all the report details.

                            But in PfSense Sarg ,the  directory structure is little-bit different. I dont know why and how to solve this.If you are placing one index.html file in "/usr/local/www/sarg-reports/" ,the webconfigurator will show that "index.html" while taking "Status->sarg Reports-> View Reports".

                            The directory structure of Sarg in Pfsense is as this "sarg-reports/"year"/"month"/"date"/index.html"( Actual Sarg directory structure "sarg-reports/index.html" + lot of directory in "yyyy-mm-dd"). The configuration of this sarg_reports.php is given in sarg_frame.php,where the path of report file is given.

                            I am struck with this error ..Can any one give further tips in the topic….........!!!

                            Thanks
                            Pramod

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

                              fyi the lightsquid package also has realtime monitoring now

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

                                linuxmaniac,

                                What options did you selected on sarg config page? did you created the schedules to run sarg?

                                I have reports working with these report options selected:

                                user graphics
                                remove temporary files
                                generate the main index
                                generate the index tree
                                overwrite report
                                use comma instead pint in reports
                                show de downloaded volume ond date/time reports

                                and all report to generate selected

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

                                Help a community developer! ;D

                                1 Reply Last reply Reply Quote 0
                                • L
                                  linuxmaniac
                                  last edited by

                                  Hai Marcelloc,

                                  I got that  ;D. Your information was very helpful…Its solved my problem....Many thanks..... :D

                                  1 Reply Last reply Reply Quote 0
                                  • E
                                    Eleander
                                    last edited by

                                    Great post, solved my "problem" (=wrong configuration) to!

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

                                      Guys,

                                      Those settings mentioned by marceloc are resolving index error ?
                                      If yes how exactly can be changed ? (yes) (no) from report settings ?

                                      Thanks !

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

                                        Just select them using ctrl + click. The (yes) and (no) are there just to show you what values are default on sarg configuration.

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

                                        Help a community developer! ;D

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

                                          Now is working finally, thanks a lot !!

                                          1 Reply Last reply Reply Quote 0
                                          • M
                                            miles267
                                            last edited by

                                            @marcelloc:

                                            linuxmaniac,

                                            What options did you selected on sarg config page? did you created the schedules to run sarg?

                                            I have reports working with these report options selected:

                                            user graphics
                                            remove temporary files
                                            generate the main index
                                            generate the index tree
                                            overwrite report
                                            use comma instead pint in reports
                                            show de downloaded volume ond date/time reports

                                            and all report to generate selected

                                            Hi - I've followed this approach it seems to work.  However, I seem to get "gaps" in the report.  If I attempt to click on any of the day hyperlinks under the FILE/PERIOD column where there are '0' values under USERS, BYTES or AVERAGE, Sarg immediately returns:

                                            Error: Could not find report index file.
                                            Check and save sarg settings and try to force sarg schedule.

                                            My schedule is set as follows (no Additional Args defined)

                                            Status Update Frequency Aditional Args Post Action Description
                                            on 1d both Rotate Logs Restart Daemon
                                            on 1h none No Rotate No Restart

                                            FILE/PERIOD CREATION DATE USERS BYTES AVERAGE
                                            2012Jun17-2012Jun26 Tue Jun 26 11:00:09 2012 12 3,776,071,500 314,672,625
                                            2012Jun17-2012Jun25 Tue Jun 26 00:00:11 2012 0 0 0
                                            2012Jun17-2012Jun24 Mon Jun 25 00:00:10 2012 0 0 0
                                            2012Jun17-2012Jun23 Sun Jun 24 00:00:08 2012 0 0 0
                                            2012Jun17-2012Jun22 Fri Jun 22 23:00:07 2012 12 2,368,777,123 197,398,093
                                            2012Jun17-2012Jun21 Fri Jun 22 00:00:06 2012 0 0 0
                                            2012Jun17-2012Jun20 Thu Jun 21 00:00:18 2012 12 1,685,088,876 140,424,073
                                            2012Jun17-2012Jun19 Wed Jun 20 00:00:04 2012 12 1,423,723,046 118,643,587

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