@spiderrobotpig here's a real quick way to find a distinct list of instances you need to whitelist based on all the sites people are following:

1. sudo into the mastodon user
2. as the mastodon user, run "psql mastodon_production"
2. run this query:

select distinct followed.domain from accounts local
join follows
on local.id
join accounts followed
on follows.target_account_id = followed.id
where local.domain is null

@spiderrobotpig oops this is wrong one sec

@spiderrobotpig uh ok follows dont seem to be pulling properly????? that's kinda frigging weird

@vahnj Oh?

@spiderrobotpig gimme a bit...

@vahnj KK, I will not goof with anything so I don't mess you up

@spiderrobotpig you wouldn't mess anything up. also it was pebkac, i was on kobold.space so my list was much smaller lmao

here's the query:

select distinct followed.domain from accounts local
join follows
on local.id = follows.account_id
join accounts followed
on follows.target_account_id = followed.id
where local.domain is null

@spiderrobotpig this will get you a distinct list of follows from local users. this won't be everyone who follows you though, which i can give you a query for that if you like

@vahnj
Nah, what you said sounds good?

If I need more, I'll figure that out haha

@vahnj
And by figure it out, i mean I'll ask you

@vahnj Also, I put this directly into mysql right?

@spiderrobotpig postgres, yes.

@vahnj Oh I don't have postgres apparently

I guess I'm using mysql?

@spiderrobotpig run "psql mastodon_production"

@vahnj YOU ARE A GENIUS

@spiderrobotpig nah just see my hammer analogy again lol

@vahnj I don't know that it did anything?

@spiderrobotpig it doesn't change anything, it gets you a list of sites that you can use to whitelist

@vahnj Yeah but I didn't get a list.

Gonna try again real quick

@spiderrobotpig oh make sure you end the statement with a semicolon.

@vahnj Also, is this like 5 lines, or just one?