@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?

@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 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

@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?

@spiderrobotpig

RAILS_ENV=product bundle exec rails c

@vahnj -su: syntax error near unexpected token `('

Shrugggg

@spiderrobotpig copy and paste me the exact command you put in

@vahnj RAILS_ENV=product bundle exec rails c DomainWhitelistService.call('scalie.club', :enable>)

@spiderrobotpig ok so the only thing you want to do is this:

RAILS_ENV=product bundle exec rails c

once that loads, *then* you run that DomainWhitelistService command

@vahnj Ooooooooooh

@vahnj /home/mastodon/live/vendor/bundle/ruby/2.5.0/gems/activerecord-5.1.4/lib/active_record/connection_adapters/connection_specification.rb:246:in `resolve_symbol_connection': 'product' database is not configured. Available: ["default", "development", "test", "production"] (ActiveRecord::AdapterNotSpecified)

I'M SORRY EVERYTHING IS BREAKING

@spiderrobotpig RAILS_ENV=product

should be

RAILS_ENV=production

@vahnj Oh thank god

You have the patience of a saint