Lemmy

12531 readers

11 users here now

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

For discussion about the lemmy.ml instance, go to !meta@lemmy.ml.

founded 4 years ago

MODERATORS

nutomic@lemmy.ml

Can you help me deal with the bots? (latte.isnot.coffee)

submitted 1 year ago* (last edited 1 year ago) by coffeeisnotlatte@latte.isnot.coffee to c/lemmy@lemmy.ml

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

[–] bilb@lem.monster 2 points 1 year ago (4 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.

[–] coffeeisnotlatte@latte.isnot.coffee 2 points 1 year ago (3 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?

[–] bilb@lem.monster 2 points 1 year ago* (last edited 1 year ago) (2 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.

[–] coffeeisnotlatte@latte.isnot.coffee 3 points 1 year ago (1 children)

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!

[–] bilb@lem.monster 1 points 1 year ago

Great!

For me, psql at the command line is great in a pinch but not great for any kind of complex task. I'll probably add adminer as a permanent option, but only served locally + add a VPN to the server, or figure out how to get my preferred DB tool (DataGrip) to connect via SSH.

There should be some management tools available via the GUI to lemmy admins, though. I'm so tempted to try to add it but I'm (generously) a rust novice.