I’ve installed Lemmy via ansible, but I figured out that there are problems with emails and after I’ve created a user, no verification email came, no login is possible and now I have a ghost account I want to delete.

Because I couldn’t find an UI element to purge users in the admin panel, I want to do it over postgresql, but I have no idea how to connect to the Lemmy database over a docker container, only thing I’ve found is to backup/restore the whole database:

docker-compose exec postgres pg_dumpall -c -U lemmy | gzip > lemmy_dump_date +%Y-%m-%d""%H%M_%S.sql.gz

Thank you for your help.

  • Lugh@futurology.today
    link
    fedilink
    English
    arrow-up
    1
    ·
    1 year ago

    I hope the Lemmy devs sort out email verification soon. We had so many problems we switched it off at futurology.today & went with limiting new sign-ups to a set amount per hour to combat bots instead.

    • maxmoon@lemmy.mlOP
      link
      fedilink
      arrow-up
      1
      ·
      1 year ago

      What exactly was the issue with your verification system?

      Currently the emails get out. At least I can see people creating accounts and posting stuff.

      • Lugh@futurology.today
        link
        fedilink
        English
        arrow-up
        1
        ·
        1 year ago

        What exactly was the issue with your verification system?

        Numerous issues the site dev couldn’t fully understand after hours of investigating. We’ve switched off email verification until the Lemmy devs fix this in an update. Additionally 2FA is often broken too & awaiting a fix.

        https://ani.social/post/46684

        • maxmoon@lemmy.mlOP
          link
          fedilink
          English
          arrow-up
          2
          ·
          1 year ago

          What a big no-go, if you could lock out yourself as an admin.

          That’s such a sloppy craftsmanship.