Trying to purge them and set up with Lemmy Ansible, I’ve disabled signups without admin approval for now.
I see a postgres container and a password but I’m not very familiar with postgres, I tried psql but can’t get access
Edit: Also anyone who’s de-federated with us, please reconsider. We’re a small server with active admin and will get a handle on this, I promise! We had an easy process to sign up for a few days while I got my users over and forgot to turn it off
Edit2: Looking much more healthy now, I will put the commands I’ve used in a comment below
Turn on captchas too.
I think the easiest is login to the docker and run the postgres client to run sql to delete users. I dont know how to differentiate between your bot and normal
Yeah that’s the issue I’m having, someone sent me a postgres command in DM earlier but it does seem to be a bit of a nuke/picking up ordinary users…
I wound up adding adminer to the docker-compose file temporarily to help me look through the data. In my case, there were no legitimate users who hadn’t verified their email, so I deleted all from local_users where the email verified column was false.
Huh adminer would definitely be an easier way to do this, do you have the part of the docker-compose you used with the env vars etc?
Yeah, I really just did a very basic setup:
adminer:image: adminerrestart: alwaysports:- 8080:8080When entering the database host, just enter “postgres” since that’s the host name it will have in the virtual network.
That’s okay I found it, luckily there’s a pattern here too… I dug up 27k with repeating numbers on emails which is a good start!