this post was submitted on 22 Jun 2023
12 points (100.0% liked)

Lemmy

13479 readers
20 users here now

Everything about Lemmy; bugs, gripes, praises, and advocacy.

For discussion about the lemmy.ml instance, go to [email protected].

founded 5 years ago
MODERATORS
[email protected]
12
Can you help me deal with the bots? (latte.isnot.coffee)
submitted 2 years ago* (last edited 2 years ago) by [email protected] to c/[email protected]
19 comments fedilink hide all child comments
 

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 are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 2 points 2 years ago (3 children)

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.

[–] [email protected] 2 points 2 years ago (2 children)

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?

[–] [email protected] 2 points 2 years ago* (last edited 2 years ago) (1 children)

Yeah, I really just did a very basic setup:

adminer: image: adminer restart: always ports: - 8080:8080

When entering the database host, just enter "postgres" since that's the host name it will have in the virtual network.

[–] [email protected] 2 points 2 years ago

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!