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



  • 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?



  • 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.



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


  • LAYER 8 Global Moderator

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



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



  • 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.



  • @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?


  • Banned

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



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


  • LAYER 8 Global Moderator

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




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



  • 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.



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



  • 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
    

Log in to reply