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

    Trying to log when and where a particular user is using the internet by mac/ip

    Scheduled Pinned Locked Moved DHCP and DNS
    14 Posts 4 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.
    • E
      elementalwindx
      last edited by

      How can I log via our pfsense when and where a user is going? Log DNS in some manner sorted via IP/mac? How would I do this in pfsense?

      1 Reply Last reply Reply Quote 0
      • KOMK
        KOM
        last edited by

        How can I log via our pfsense when and where a user is going?

        Going where via what?  Are you specifically looking to track HTTP/S?  Squid proxy logs all web access.  Lightsquid gives you reports on squid activity.

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

          @KOM:

          How can I log via our pfsense when and where a user is going?

          Going where via what?  Are you specifically looking to track HTTP/S?  Squid proxy logs all web access.  Lightsquid gives you reports on squid activity.

          Web traffic from an ipad. Essentially just that. Making sure employees are not playing around on the guest network during company work time.

          Squid makes me nervous because every time I've ever used it, it always causes some form of an issue when a user goes to download a file like a flash update, or java update, or windows update.

          We have a interface dedicated just to wifi guest traffic with it's own subnet.

          1 Reply Last reply Reply Quote 0
          • johnpozJ
            johnpoz LAYER 8 Global Moderator
            last edited by

            And what keeps them form fooling around on their phones over their own connection..  Kind of pointless to track what happens on your GUEST network that is not tied to your production network.

            You might be nice and filter it for malware, etc..  But other than that - why should you care.  As to the users messing around on internet.. Why not just use their own phone, or fire up their own hotspot on their phone, etc. etc.

            Trying to track is a exercise in futility if you ask me when pretty much everyone carries around their own connection in their pocket..

            An intelligent man is sometimes forced to be drunk to spend time with his fools
            If you get confused: Listen to the Music Play
            Please don't Chat/PM me for help, unless mod related
            SG-4860 24.11 | Lab VMs 2.7.2, 24.11

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

              @johnpoz:

              And what keeps them form fooling around on their phones over their own connection..  Kind of pointless to track what happens on your GUEST network that is not tied to your production network.

              You might be nice and filter it for malware, etc..  But other than that - why should you care.  As to the users messing around on internet.. Why not just use their own phone, or fire up their own hotspot on their phone, etc. etc.

              Trying to track is a exercise in futility if you ask me when pretty much everyone carries around their own connection in their pocket..

              I agree with you except this is what the boss is asking of me. These users don't know how to setup their own hotspots either. Can we please stay on topic? Thanks.

              1 Reply Last reply Reply Quote 0
              • KOMK
                KOM
                last edited by

                You don't have to use Squid as a cache, just as a middle man.  Even with just squid, you will be doing a lot of report parsing.  Combine squid with squidguard and you can block URLs based on their category, including white & black lists.

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

                  @KOM:

                  You don't have to use Squid as a cache, just as a middle man.  Even with just squid, you will be doing a lot of report parsing.  Combine squid with squidguard and you can block URLs based on their category, including white & black lists.

                  I'll give that a try. Whats the difference between squid and squid3? First impression is squid3 is supposed to be the newest version but when I read the version numbers on the package page it seems "squid" is the newest version. Correct?

                  1 Reply Last reply Reply Quote 0
                  • D
                    doktornotor Banned
                    last edited by

                    @elementalwindx:

                    "squid" is the newest version. Correct?

                    No!!! "Squid" is 2.7 branch of Squid, abandoned ages ago upstream, abandoned at FreeBSD as well and completely unmaintained at pfSense as well… I made an attempt to at least mark that version as unsupported, but that didn't fly either.

                    Also note, the package version has nothing to do with the binaries version.

                    1 Reply Last reply Reply Quote 0
                    • KOMK
                      KOM
                      last edited by

                      Remember to set the hard disk cache size to 1 or 0 (the smallest it will allow), and set the filesystem type to Null.

                      1 Reply Last reply Reply Quote 0
                      • johnpozJ
                        johnpoz LAYER 8 Global Moderator
                        last edited by

                        you can turn on logging in the forwarder if you want to log queries..

                        your going to get a LOT of noise!!  You would be amazed at all the queries a box will do without the user actually doing anything..

                        logdnsquery.png
                        logdnsquery.png_thumb

                        An intelligent man is sometimes forced to be drunk to spend time with his fools
                        If you get confused: Listen to the Music Play
                        Please don't Chat/PM me for help, unless mod related
                        SG-4860 24.11 | Lab VMs 2.7.2, 24.11

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

                          @KOM:

                          Remember to set the hard disk cache size to 1 or 0 (the smallest it will allow), and set the filesystem type to Null.

                          I've got it set up and working. lightsquid reporting utility is nifty but certainly very basic looking.

                          Why would I set those sizes and types?

                          Which squid version should I have installed? I used regular squid.

                          1 Reply Last reply Reply Quote 0
                          • KOMK
                            KOM
                            last edited by

                            Why would I set those sizes and types?

                            Because you don't want it caching, just reporting.

                            Which squid version should I have installed?

                            Squid3 package 0.3.8.  Also look at Sarg (another reporter based on squid's access.log) and squidGuard 1.9.15 for URL filtering.

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

                              @KOM:

                              Why would I set those sizes and types?

                              Because you don't want it caching, just reporting.

                              Which squid version should I have installed?

                              Squid3 package 0.3.8.  Also look at Sarg (another reporter based on squid's access.log) and squidGuard 1.9.15 for URL filtering.

                              Tried Sarg but I just keep getting this under view report:

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

                              but the realtime report is working although thats not what we need.

                              1 Reply Last reply Reply Quote 0
                              • KOMK
                                KOM
                                last edited by

                                To fix Sarg, do this from console:

                                rm -r /usr/local/sarg-reports
                                ln -s /usr/pbi/sarg-amd64/local/sarg-reports /usr/local/sarg-reports
                                
                                1 Reply Last reply Reply Quote 0
                                • First post
                                  Last post
                                Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.