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

Realtime Stats (SQStat) error

Scheduled Pinned Locked Moved Cache/Proxy
19 Posts 3 Posters 1.2k 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.
  • M
    makazo
    last edited by Sep 13, 2024, 9:01 PM

    Hello, I have been dealing with this problem for days. Does anyone know the solution 😠 Ekran Alıntısı.JPG

    I would be very happy if anyone could help me with this issue. I wish everyone a good forum.

    1 Reply Last reply Reply Quote 0
    • S stephenw10 moved this topic from Problems Installing or Upgrading pfSense Software on Sep 14, 2024, 12:05 AM
    • S
      stephenw10 Netgate Administrator
      last edited by Sep 14, 2024, 12:06 AM

      You probably need to allow access to Squid from localhost.

      M 1 Reply Last reply Sep 14, 2024, 7:43 AM Reply Quote 0
      • M
        makazo @stephenw10
        last edited by Sep 14, 2024, 7:43 AM

        @stephenw10 I read many articles on the web about this but I couldn't find a solution. Can you help me figure out how to do this?

        1 Reply Last reply Reply Quote 0
        • S
          stephenw10 Netgate Administrator
          last edited by Sep 14, 2024, 1:51 PM

          You must have loopback selected as one of the proxy interfaces like:
          Screenshot from 2024-09-14 14-50-21.png

          M 3 Replies Last reply Sep 14, 2024, 4:19 PM Reply Quote 0
          • M
            makazo @stephenw10
            last edited by Sep 14, 2024, 4:19 PM

            @stephenw10 1.JPG 2.JPG 3.JPG 4.JPG

            First of all, thank you for your reply. I have all the settings you mentioned, but they are not working.😢

            1 Reply Last reply Reply Quote 0
            • M
              makazo @stephenw10
              last edited by Sep 14, 2024, 4:23 PM

              @stephenw10 I've done a clean installation several times for this, but it doesn't work. I watched a lot of videos on the internet, but I still can't get it to work, :(

              1 Reply Last reply Reply Quote 0
              • M
                makazo @stephenw10
                last edited by makazo Sep 14, 2024, 4:33 PM Sep 14, 2024, 4:31 PM

                @stephenw10 5.JPG 6.JPG7.JPG

                Likewise, this package does not keep any records. I have been browsing the internet for 2 days, but no site information is recorded.

                1 Reply Last reply Reply Quote 0
                • S
                  stephenw10 Netgate Administrator
                  last edited by Sep 14, 2024, 7:44 PM

                  Hmm lightsquid definitely requires loopback/localhost access. That looks like it does have some info though, are those sites not current?

                  M 1 Reply Last reply Sep 14, 2024, 8:48 PM Reply Quote 0
                  • M
                    makazo @stephenw10
                    last edited by Sep 14, 2024, 8:48 PM

                    @stephenw10 What should I do for this? I'm a little new to these topics :) I would appreciate it if you could explain a little more.

                    1 Reply Last reply Reply Quote 0
                    • S
                      stephenw10 Netgate Administrator
                      last edited by Sep 14, 2024, 9:48 PM

                      I'm asking if that site data shown by lightsquid is current? If it is then it's able to see the data.

                      What you're seeing is a permissions issue. Are you logged in as the admin user?

                      M 2 Replies Last reply Sep 14, 2024, 9:52 PM Reply Quote 0
                      • M
                        makazo @stephenw10
                        last edited by Sep 14, 2024, 9:52 PM

                        @stephenw10 The site data shown by Lightsquid is not up to date. I browsed the internet for 2 days, but it does not keep any logs. Yes, I log in to the pfsense panel as admin. How can I create permissions for /loopback on localhost?

                        By the way, while waiting for your answer, I reinstalled pfsense, my version is 2.7.2, but it still didn't work, I'm stubborn to do it, but the system is more stubborn than me.

                        1 Reply Last reply Reply Quote 0
                        • M
                          makazo @stephenw10
                          last edited by Sep 15, 2024, 2:54 PM

                          @stephenw10 rules.JPG

                          1 Reply Last reply Reply Quote 0
                          • S
                            stephenw10 Netgate Administrator
                            last edited by Sep 15, 2024, 11:24 PM

                            What version of the Squid and Lightsquid packages are shown in the package manager?

                            1 Reply Last reply Reply Quote 0
                            • J
                              JonathanLee
                              last edited by Sep 16, 2024, 12:20 AM

                              Did you password lock cachemgr?? If you did it also password locks status pages

                              Make sure to upvote

                              1 Reply Last reply Reply Quote 0
                              • M
                                makazo
                                last edited by makazo Sep 16, 2024, 1:16 PM Sep 16, 2024, 1:15 PM

                                I solved the error with the help of a friend. Friends who get an error regarding this can watch this video. We solve the problem with a simple certificate. The system keeps very clean logs.

                                Only Realtime Stats (SQStat) does not work instantly. Should I allow this as localhost?

                                I hope those who have log problems watch this video and enjoy sharing information.

                                Again, I would like to thank those who took the time to respond to my messages.

                                https://www.youtube.com/watch?v=DTD5lYPjLns

                                J 1 Reply Last reply Sep 17, 2024, 1:24 AM Reply Quote 0
                                • S
                                  stephenw10 Netgate Administrator
                                  last edited by Sep 16, 2024, 1:44 PM

                                  So the page works but there is a delay?

                                  1 Reply Last reply Reply Quote 0
                                  • J
                                    JonathanLee @makazo
                                    last edited by Sep 17, 2024, 1:24 AM

                                    @makazo that page is only updated per set schedule, mine is once a day

                                    Make sure to upvote

                                    1 Reply Last reply Reply Quote 0
                                    • M
                                      makazo
                                      last edited by Sep 19, 2024, 6:29 PM

                                      Hello friends, squid is working very stably. Only Realtime Stats (SQStat) does not work instantly.

                                      Previously, I was having problems with WhatsApp, web, apple store and many similar things. I wrote a certificate, changed my mode to "splice all" instead of "custom" and then I made the permissions that our friend @JonathanLee answered in a topic, my system works a little more stable now.

                                      I share my pictures
                                      1.JPG 2.JPG 3.JPG 4.JPG 5.JPG 6.JPG

                                      1 Reply Last reply Reply Quote 0
                                      • M
                                        makazo
                                        last edited by Sep 19, 2024, 6:31 PM

                                        I'm wondering, I changed my mode from "custom" mode to "splice all" mode and added these codes as you can see in the photo, the system and many blocked programs and applications started to work. What exactly is the logic behind this?

                                        @JonathanLee
                                        @stephenw10

                                        Custom Options (SSL/MITM) =

                                        acl splice_it ssl::server_name .microsoft.com
                                        acl splice_it ssl::server_name .windowsupdate.com
                                        acl splice_it ssl::server_name .akamaitechnologies.com
                                        acl splice_it ssl::server_name .akadns.net
                                        acl step1 at_step SslBump1
                                        ssl_bump peek step1
                                        ssl_bump splice splice_it
                                        ssl_bump bump all
                                        ssl_bump peek step1
                                        ssl_bump splice all

                                        My custom refresh_options on the Local Cache tab

                                        refresh_pattern -i windowsupdate.com/..(cab|exe|ms[i|u|f|p]|[ap]sf|wm[v|a]|dat|zip|psf) 43200 80% 129600 reload-into-ims
                                        refresh_pattern -i microsoft.com/.
                                        .(cab|exe|ms[i|u|f|p]|[ap]sf|wm[v|a]|dat|zip|psf) 43200 80% 129600 reload-into-ims
                                        refresh_pattern -i windows.com/..(cab|exe|ms[i|u|f|p]|[ap]sf|wm[v|a]|dat|zip|psf) 43200 80% 129600 reload-into-ims
                                        refresh_pattern -i microsoft.com.akadns.net/.
                                        .(cab|exe|ms[i|u|f|p]|[ap]sf|wm[v|a]|dat|zip|psf) 43200 80% 129600 reload-into-ims
                                        refresh_pattern -i deploy.akamaitechnologies.com/.*.(cab|exe|ms[i|u|f|p]|[ap]sf|wm[v|a]|dat|zip|psf) 43200 80% 129600 reload-into-ims

                                        If you want to restrict (bypass) ip addresses of your local Network :-
                                        acl splice_it ssl::server_name .microsoft.com
                                        acl splice_it ssl::server_name .windowsupdate.com
                                        acl splice_it ssl::server_name .akamaitechnologies.com
                                        acl splice_it ssl::server_name .akadns.net
                                        acl localnet src 10.0.0.0/8 #local network
                                        acl localnet src 192.168.0.0/16 #local network
                                        acl localnet src 172.16.0.0/12 #local network
                                        acl localnet src 2.2.2.2/32 #just for example
                                        acl step1 at_step SslBump1
                                        ssl_bump peek step1
                                        ssl_bump splice splice_it
                                        ssl_bump splice localnet # splice one more time
                                        ssl_bump bump all

                                        1 Reply Last reply Reply Quote 0
                                        19 out of 19
                                        • First post
                                          19/19
                                          Last post
                                        Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.
                                          This community forum collects and processes your personal information.
                                          consent.not_received