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

  • Wander@yiffit.net
    link
    fedilink
    English
    arrow-up
    4
    ·
    edit-2
    1 year ago

    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.coffeeOP
      link
      fedilink
      English
      arrow-up
      1
      ·
      1 year ago

      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