Crom, Kobold King @vahnj@awoo.space

@spiderrobotpig sure thing!

@spiderrobotpig (this is in the rails console, again)

@spiderrobotpig DomainWhitelistService.call('domain.name', <status>)

where status is:

:enable
or
:silence

I'm gonna guess you just want :enable

@spiderrobotpig copy paste all the lines and add a semicolon at the end. use up and down arrow keys to naviagte the list

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

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

@noelle holy shit

@spiderrobotpig nah just see my hammer analogy again lol

@spiderrobotpig run "psql mastodon_production"

@spiderrobotpig postgres, yes.

ok real talk why doesn't the compile rake task preserve compiled files that haven't changed or is there something about how stuff hooks together that makes it not able to detect whether or not it can do that

cuz this is just unreasonably slow

@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

@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 gimme a bit...

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

@spiderrobotpig oops this is wrong one sec

@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

@thefishcrow@cybre.space i need to watch all the thors

@squirrel your child is adorable

@maplebot17@botsin.space she's over here ya wee sweety: @squirrel