this post was submitted on 20 Aug 2023
19 points (95.2% liked)

Lemmy Support

4655 readers
28 users here now

Support / questions about Lemmy.

Matrix Space: #lemmy-space

founded 5 years ago
MODERATORS
dessalines@lemmy.ml
19
How to connect to the database if Lemmy is in a docker container? (lemmy.ml)
submitted 1 year ago by utopify_org@lemmy.ml to c/lemmy_support@lemmy.ml
18 comments fedilink hide all child comments
 

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.

you are viewing a single comment's thread
view the rest of the comments
[–] utopify_org@lemmy.ml 1 points 1 year ago (1 children)

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 2 points 1 year ago (1 children)

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

[–] utopify_org@lemmy.ml 2 points 1 year ago

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

That's such a sloppy craftsmanship.