Hi there, Been running my own little Lemmy instance basically to see how it runs with federation and stuff like that. I have had open (email validation) for the odd person or 2 that might want to use it.

Early this morning (my time 4:43am) I had about 15 new users all at the exact same time registering as users with same structure names (random words) followed by 4 numbers. Being all within 1 minute of each other they are obvious bots.

Going through the UI I have not been able to find a way to remove them. I have since changed my registration policy to make the person fill in an application, captcha, email validation etc. to help stop polluting the ecosystem with bots.

Any help would be appreciated. I am running it all under docker

  • Wander@yiffit.netEnglish
    1·
    1 year ago

    Did you find a solution. The above comment with the database query should work. You can access the docker container where the database is running with docker exec -it instancedomain_postgres_1 busybox /bin/sh and then run psql -U databaseuser which by default is ‘lemmy’.

    Check docker ps to know the exact name of the postgres container which in your case likely is lemmytalungorg_postgres_1

    • talung@lemmy.talung.orgOPEnglish
      3·
      1 year ago

      Thanks, I have gone through and identified the REAL accounts gathered the ID’s and deleted the rest from local_user and person tables.

      Haven’t really played much with Postgress so took some time to look up all the functionality with that.

      EDIT: yup, made sure the person one was local only :)