@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
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
@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?
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 /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
@vahnj Oh thank god
You have the patience of a saint
@spiderrobotpig perhaps my only redeeming quality is i am patient with people who don't get angry about things not working haha
That's a good thing.
Also it's still breaking >^<
Traceback (most recent call last):
1: from (irb):1
NameError (uninitialized constant DomainWhitelistService)
@spiderrobotpig agh! me again
do WhitelistDomainService, instead of the one there
@vahnj Okay, I think that worked? It just printed the number 4, but no errors, so that's prolly good
@spiderrobotpig It prints the number of users you've whitelisted!
@vahnj Okay, I'll try that :3