Can you help me deal with the bots?
Can you help me deal with the bots?
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
You're viewing a single thread.
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!