Crom, Kobold King @vahnj@awoo.space

@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

@spiderrobotpig would it be ok to ask for ssh permissions at this point? im not sure how to help without being able to poke around at this point

did anything output from your db:migrate command?

@spiderrobotpig any errors in your logs?

@squirrel yes pls

@spiderrobotpig yea i think once you do that after the db:migrate it should be good to go

@spiderrobotpig you probably need to do that

@spiderrobotpig did you run assets:precompile too?

@spiderrobotpig so yea just run the db:migrate command and then restart :)

@spiderrobotpig all it means is your site will fail to work and throw errors, nbd

@spiderrobotpig Nope!

Make sure you run the db:migrate command

There's an extra db migrate that you need to do for whitelists

@spiderrobotpig it's unreasonable to expect anyone to know git imo