Lemmy

12524 readers

19 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

18 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

you are viewing a single comment's thread
view the rest of the comments

[–] Wander@yiffit.net 5 points 1 year ago* (last edited 1 year ago) (1 children)

Hey there! Thank you for reaching out. I'll definitely not block your instance then. Regarding postgres, first login to the postgres container with docker exec -it containername busybox /bin/sh

You can get the container name by running docker ps. Once inside login to psql console with psql -U lemmy

I've written this from memory, but it should be very similar if not the same.

EDIT: Consider saving the usernames and details of the bots that signed up. We might be able to use that for some analysis.

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

Yup I've got them, luckily 5 or more repeating numbers in their email pretty much identified 99% of them. Would you like me to send the CSV somewhere? 27k+ bots

[–] tgxn@lemmy.tgxn.net 1 points 1 year ago (1 children)

It's be interesting to see where they are coming from, do you have up and user agents in the logs at all?

[–] coffeeisnotlatte@latte.isnot.coffee 2 points 1 year ago

I don't unfortunately, I deliberately don't log that due to some of the sensitive stuff on my own instance (we're China based)