@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 uh ok follows dont seem to be pulling properly????? that's kinda frigging weird

@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

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

Sign in to participate in the conversation
Awoo Space

Awoo.space is a Mastodon instance where members can rely on a team of moderators to help resolve conflict, and limits federation with other instances using a specific access list to minimize abuse.

While mature content is allowed here, we strongly believe in being able to choose to engage with content on your own terms, so please make sure to put mature and potentially sensitive content behind the CW feature with enough description that people know what it's about.

Before signing up, please read our community guidelines. While it's a very broad swath of topics it covers, please do your best! We believe that as long as you're putting forth genuine effort to limit harm you might cause – even if you haven't read the document – you'll be okay!