@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
@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
And by figure it out, i mean I'll ask you
@vahnj Also, I put this directly into mysql right?
@spiderrobotpig postgres, yes.
@vahnj ooop I'm in mysql haha
KK lemmie fix that
@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
@vahnj Yeah it didn't give me anything that I can see
@spiderrobotpig oh make sure you end the statement with a semicolon.
Thank you for your patience >^<
@vahnj Also, is this like 5 lines, or just one?
@spiderrobotpig copy paste all the lines and add a semicolon at the end. use up and down arrow keys to naviagte the list
@vahnj Okay, I'll try that :3
@vahnj Okay that worked.
So, could you give me the whitelist command again, because I can't get back into occult.camp in a web browser because there's something going on with the DM thing probably and I can't fix it right now
@spiderrobotpig DomainWhitelistService.call('domain.name', <status>)
where status is:
:enable
or
:silence
I'm gonna guess you just want :enable
@spiderrobotpig (this is in the rails console, again)
@vahnj Yeah, enable should work for what I want.
Also thanks haha
@spiderrobotpig sure thing!
@vahnj Actually one last thing.
Rails console, is that the RAILS_ENV=production thing or something else?
@vahnj
Nah, what you said sounds good?
If I need more, I'll figure that out haha