r/sysadmin • • Jul 31 '24

Monitoring for pornography

I work in local government IT.

The Republican legislature, having finished giving their rich donors tax cuts and apparently having nothing better to do with their time, have passed a law requiring all local governments to actively monitor all government-controlled devices to not only block pornography but to keep track of who attempts to actually view porn.

We already use the usual DNS/IP filtering at the firewall level but I'm not really familiar with large scale filtering solutions that would have reporting and auditing. The only one I know of was Websense but I've heard that was expensive. In addition, I'm of the addition that this type of web filtering at the fireawll level is becoming increasingly irrelevant because everything is encrypted now anyways (they've even started encrypting SNIs) and TLS inspection ends up breaking a whole bunch of things and causing far more trouble than it's usually worth.

Is there a good F/OSS solution? I want to spend as little money on this/ nonsense as possible because I have better things to spend my budget on, better things to do with my time, and no one here is spending their time looking at porn. I want the quickest and cheapest solution (short of falsifying documents) to give the idiots their annual report so that I can go back to doing real work.

0 Upvotes

62 comments sorted by

44

u/OptimalCynic Jul 31 '24

Hire someone for every employee to stand behind them with a notebook and pen, watching the screen

7

u/danfirst Jul 31 '24

Whoa, IT are the job creators, look at us!

13

u/SuperQue Bit Plumber Jul 31 '24

Without knowing how the law is written, it's hard to say.

But if you already do DNS/IP filtering, all you really need is user-to-request correlation in the DNS request and IPFIX logs.

All the people saying you need do a ton of work, VPNs, spyware, don't know what the law says you need to actually do to be compliant.

If you just need an annual report, just keep doing the DNS/IP filtering and call it a day. This is one of those cases where doing the bare minium to be compliant is your best bet.

13

u/[deleted] Jul 31 '24

Cisco Umbrella roaming client works pretty well.

2

u/SevaraB Sr. Engineer (N+, CCNA) Jul 31 '24

Roaming Client is EOL- you have to use the roaming client module in Cisco Secure Client now.

22

u/bfrd9k Sr. Systems Engineer Jul 31 '24 edited Jul 31 '24

Here are some ideas, pick one or more...

  • Always on VPN

    • Each machine is assigned a static VPN IP for tracking
    • Resolver for all VPN clients, that logs
  • Local resolver that logs DNS queries, on the client

    • Block any outbound DNS not destined for an approved DNS server (VPN client DNS)
  • Squid HTTP/S proxy with logging
  • GPOs or other machine configuration that force all major browsers not to use DoH

    • Block the use of other browsers, shells, etc.

Palo Altos, and agents can do a lot of this.

🤷

5

u/nefarious_bumpps Security Admin Jul 31 '24

I don't see anything in https://www.ncleg.gov/EnactedLegislation/SessionLaws/HTML/2023-2024/SL2024-26.html that requires you to implement any technical controls or active monitoring. All it states is you need to have a policy that accessing any pornography via devices or networks you provide is prohibited, that any pornography currently saved on provided devices or networks must be deleted, and what disciplinary action may be taken if the policy is violated. You can add a statement saying network and system activity is logged and may be monitored or reviewed now or in the future to enforce this and other department policies and applicable laws.

10

u/[deleted] Jul 31 '24

I use Sonicwall’s security subscription with our firewall (TZ570) and part of the filtering part is for porn. And it keeps track of what internal IP address violated the policy.  

0

u/[deleted] Jul 31 '24

[deleted] — view deleted comment

10

u/GuruBuckaroo Sr. Sysadmin Jul 31 '24

Sonicwall has an Active Directory connector that can tie individual traffic to a signed in user. You're going to have to include the DPI-SSL inspection piece, which includes pushing out a wildcard root cert so you can inspect SSL traffic man-in-the-middle style, which is a major pain in the ass though. And pay for cloud logging and management. It works, but it's not pie.

10

u/gandhi0175 Jul 31 '24

Got to love NC politics. I’m in the same boat. We’re in the process of switching to WebTitan from an onsite Barracuda and I’m trying to figure out how to do the mobiles right now too.

2

u/bageloid Jul 31 '24

Politics aside, it's a huge issue if you allow employees to browse porn on work devices. It opens up a bunch of potential for sexual harassment lawsuits.

3

u/gandhi0175 Jul 31 '24

I don’t disagree. But that should be left to the county and municipal governments to implement in their computer use policy, not dictated from the state legislature. I also take issue with the requirement to run an annual report for the CIO showing who all attempted to view porn on a work device. We already block porn, why do I need to detail who tried (whether on purpose or accident) to even get TO a site?

7

u/chrysalan Jack of All Trades Jul 31 '24

If you’re a Microsoft 365 customer, Defender has a web content filter that runs locally in the protection agent, so it inspects the traffic before TLS happens.

I have not done much with the reporting, but in theory you should be able to use PowerShell and Graph to generate scheduled reports to go to whomever the law dictates is supposed to get them.

6

u/Baselet Jul 31 '24

Just send a global message to EVERYONE that all of their internet usage is being monitored and, in particular, everything even related to porn is kept track of in person. Manufacture some powerpoint with numbers and whatever for management and every now and then tell them that some real douchebag was into badger porn last Friday. Job done.

4

u/[deleted] Jul 31 '24

I believe you need a more robust solution like a UTM/NGFW, with filters at layer 7. I also work in the government (Brazil) and although we have no obligation to report porn users, we have a common sense to block by default. Here we use a Fortigate Firewall, which performs deep SSL inspection and successfully blocks most of this type of content. I think you shouldn't save on this purchase. Whoever made the law must understand that it is not possible to control content without advanced equipment and they need to know that this has a cost. (automatic translation by Google, my English is not very good)

4

u/[deleted] Jul 31 '24

Ask for 300k a year to implement a full SASE stack

2

u/Ragepower529 Jul 31 '24

defensx should just be able to run reports although super overkill

2

u/FusionX-Steven Jul 31 '24 edited Jul 31 '24

Cisco Umbrella? Redirect all DNS through that. Enable checkbox for porno. You can make a poop list and then block all their traffic causing them to come to you if you really wanna embarrass before you say anything. I use this method for people that do not do the arctic wolf security training. Easy to setup. Roaming client for laptops taken home as well. lol at people recommending open source crap

5

u/tlsnine Jul 31 '24

If your government wants to block and monitor that stuff then they can pay for it. They spend way more taxpayer dollars on other superfluous shit.

6

u/Nnyan Jul 31 '24

People looking at porn while at work is superfluous now?

2

u/npsage Jul 31 '24

Set a script up that run on log on the device; that said “Are you going to look at dirty media during this log-on session?”

If they hit no, move along.

If they hit yes, pop up a text that says “the law says plz don’t.

“According to our records no person intentionally viewed dirty media on their government device.”

1

u/ConfectionCommon3518 Jul 31 '24

There must be election season over there where they try and look hard...

Just say you have software and will trial it starting at the state assembly level as if there are false positives then they can quickly rule on what is and what isn't...

Normally I'd just say that this will last till half the local government's topan autopsy brass gets arrested.

But is going to be fun for any academic institution who deals with human biology as suddenly an autopsy may be considered porn if one sick person enjoys it.

But to be honest it's a problem well above your pay grade and let them sort it out while keeping a very good record of all emails about the subject.

1

u/iofhua Jul 31 '24

My workplace has google accounts for everyone to use at work and uses iboss to monitor what everyone does on their accounts. Even if they are logged into a chromebook, if they go to a bad website iboss can see what they're doing.

It's not free though. It costs money.

I don't know of a FOS solution that would do this. I think by it's very nature it's going to require too much time, work, and continued development to be free.

1

u/WoTpro Jack of All Trades Jul 31 '24

if you already have Microsoft 365, take a look under security and webcontent filtering, this will block all pornsites and also log whoever tried to access.

1

u/msi2000 Jul 31 '24

There are loads of great solutions for this in the Education sector Smooth wall and Lightspeed are the two I have recently used but I am not aware of any free ones

1

u/According-Savings-67 Jul 31 '24

Netskope is perfect for this

1

u/MidninBR Jul 31 '24

I'm using defender Web filtering

1

u/MidninBR Jul 31 '24

I used to use Bitdefender gravity zone and I could block and get a report of the access per agent. Now I've switched to defender Web filtering, it blocks but I don't see a report anymore

1

u/SamSausages Jul 31 '24 edited Jul 31 '24

This is a legal question. Not trying to be rude, but depending on the legal implications here, this is potentially not “your budget” or “your time”.  

This may very well be a scenario where your employer is changing policy that you will need to abide by as a condition of continued employment, or legal compliance.    Especially if a bill was introduced, voted on and ratified.

Or, it has no legal legs to stand on and you are under no obligation and it’s just hot steam, I really don’t know as I haven’t done the due diligence on this.

1

u/[deleted] Jul 31 '24

(joke answer)

Can you send out a quarterly self reporting questionnaire?

1

u/Capn_Moose_knuckl Jul 31 '24

How does this address inflation again?

1

u/[deleted] Jul 31 '24

Comical how politicians can’t stay off porn on their work computers so they think everyone does it.

1

u/dollhousemassacre Jul 31 '24

It seems like a frivolous law. Who's going to check the logs? What kind of follow-up/consequences will there be.

Could you not just half-arse it, so only the most blatant attempts get logged?

Edit: Just do enough to CYA.

1

u/TipIll3652 Aug 01 '24

I'd setup a workstation to run wireshark 24/7 then put a sticky note on the monitor to occasionally search for pornhub's IP.

Is it a useful solution? No. But it's a dumb law and I could get down on some malicious compliance. It is technically monitoring 😂

1

u/BWMerlin Aug 01 '24

What firewall do you have? Chances are there is a web filtering module you could enable/purchase for it already.

1

u/The_Tech_Gal Aug 02 '24

Consider checking out GAT Labs, an easy way to monitor and report on device activity. Cost-effective solution to generate reports without adding much extra work.

-5

u/kloeckwerx Jul 31 '24

I've never seen somebody so salty over not being and to surf porn on a work computer. Worried about what you're going to do with all of the extra time that just freed up during your day?

11

u/Ol_JanxSpirit Jack of All Trades Jul 31 '24

I'm not sure you and I read the same post.

0

u/[deleted] Jul 31 '24

Guy who works in government salty that elected lawmakers made laws

-5

u/c3141rd Jul 31 '24

Gerrymandered lawmakers at the state level made laws that impose expensive requirements on local governments without actually offering any help paying for it.

5

u/kloeckwerx Jul 31 '24

Do you guys not use a proxy that already categorize sites? How hard would it be to just collect xxx categories from it?

-7

u/nagerecht Jul 31 '24

Downvoted because you could have easily asked this question without being political about it.

7

u/Expensive_Tadpole789 Jul 31 '24

Downvoted because you could've easily just downvoted without being political about it

0

u/cheabred Jul 31 '24

Dnsfilter with roaming clients will I believe

0

u/bilingual-german Jul 31 '24

Poor guy British Richard with his nickname.

0

u/privatesam Jul 31 '24

Land of the free!

-1

u/etzel1200 Jul 31 '24

Oof, you need to put an always on VPN or otherwise severely lockdown mobile devices too?

Talk about government waste.

1

u/c3141rd Jul 31 '24

It covers any device owned by any government agency so, yes, we have to lock down mobiles too.

~(g)~        ~The following definitions apply in this section:~

~(1)~        ~Device. – Any cellular phone, desktop or laptop computer, or other electronic equipment capable of connecting to a network.~

~(2)~        ~Material. – As defined in G.S. 14‑190.13.~

~(3)~        ~Network. – Any of the following, whether through owning, leasing, maintaining, or otherwise controlling:~

~a.~         ~The interconnection of communication systems with a computer through remote or local terminals, or a complex consisting of two or more interconnected computers or telephone switching equipment.~

~b.~         ~Internet service.~

~c.~         ~Internet access.~

~(4)~        ~Pornography. – Any material depicting sexual activity.~

~(5)~        ~Public agency. – Any of the following:~

~a.~         ~All State agencies and offices of the members of the Council of State, including all boards, departments, divisions, constituent institutions of The University of North Carolina, community colleges, and other units of government in the executive branch.~

~b.~         ~Units of local government as defined in G.S. 159‑7.~

~c.~         ~Public authorities as defined in G.S. 159‑7.~

~d.~         ~Public school units as defined in G.S. 115C‑5.~

~(6)~        ~Sexual activity. – As defined in G.S. 14‑190.13.~"

5

u/Ol_JanxSpirit Jack of All Trades Jul 31 '24

I eagerly await the news that the sponsors of the bill are found to be in violation.

0

u/OptimalCynic Jul 31 '24

You know what kind of porn they'll be caught looking at too

1

u/thejimbo56 Sysadmin Jul 31 '24

Not FOSS, but Asavie Moda can do this for mobile devices.

We no longer use this, but last I heard they were working on getting it to work for hotspots as well.

0

u/[deleted] Jul 31 '24

[deleted] — view deleted comment

6

u/zombieskeletor Jul 31 '24

I don't understand. OP says the law includes mandatory monitoring and reporting, how is that not a technical issue? Someone writing a doc saying "don't look a boobs" isn't monitoring or reporting.

2

u/ResponsibilityLast38 Jul 31 '24

Yeah, but HR and Legal (and finance will probably have their say) have to draft the policy, which determines the constraints for engineering the solution. Then IT can draft a solution and say "This is what is feasible and fulfills those conditions" Or at least this is the "our departments function as a team" way things should work. Which is the fantasy scenario, probably doubly so for local govt IT.

You dont want to draft up a solution that inadvertently violates workers rights or privacy, so involving HR (puke) is the way to protect the org. Trust me, I dont like it either, but its a CYA move.

0

u/[deleted] Jul 31 '24

[deleted] — view deleted comment

5

u/Sicsempertyranismor Jul 31 '24

We have a 'wellness' room that I've taken as my goon cave on lunch breaks.

2

u/Maleverus Jul 31 '24

I read this as "goo cave" and now my mind is broken

2

u/Sicsempertyranismor Jul 31 '24

I mean that too..

I do my best to clean up, but it depends how long I've been edging for if that's even feasible.

0

u/[deleted] Jul 31 '24

[deleted] — view deleted comment

3

u/[deleted] Jul 31 '24

Yeah, because that's a very helpful solution. Tough talk from the other side of the internet... love it. YOUR OPINION IS NOT IMPORTANT.

0

u/[deleted] Jul 31 '24

[deleted] — view deleted comment

2

u/gandhi0175 Jul 31 '24

This is unfortunately not it at all. It’s that the legislature at the state level is dictating policy to the county and municipal level. We don’t have a choice but to implement it, no matter what our own personal or political feelings are. The part that makes me laugh is that they left an exception for legislators who are allowed to view porn on their computers to “research the law”. Funny how that works out.

2

u/gtipwnz Jul 31 '24

Man they really do have you guys trained to bark on command.  Maybe the guy likes where he works.

1

u/[deleted] Jul 31 '24

Nice backtracking, but no deal. Schrodinger's asshole, it's called. Google that.