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

vintech

0 readers
0 users here now

This is a place for people residing in Vietnam to discuss technology -- because sometimes the local optimum for a problem is a little bit different here.

No ads, political content, NSFW, and so on. Be helpful, kind, and patient.

founded 2 years ago
MODERATORS
[email protected]
1
User registration temporarily closed -- Removing bot accounts (voltage.vn)
submitted 2 years ago* (last edited 2 years ago) by [email protected] to c/[email protected]
0 comments fedilink hide all child comments
 

I was hoping that I could leave open registration here for a few days, but apparently there are a ton of lemmy bots. I got 18k within 2 days.

So I logged in to my server, and did this:

  1. Run docker ps to get the name of the container running postgres.
  2. docker exec -it /bin/bash
  3. psql -h localhost -p 5432 -U lemmy -d lemmy
  4. The bot users in my case were all users where id>=3 in my case.
  5. So I ran DELETE FROM TABLE local_user where id>=3
  6. Done

To anyone else with this problem, this approach will only work if the bots are within a certain range of user ids. Still, it worked in my very simple case so I'll leave it here.

User registration is no longer open. My VPS provider tends to block outbound 485, so until I sort that out, user registration is temporarily closed.

no comments (yet)
sorted by: hot top controversial new old
there doesn't seem to be anything here