Lemmy Support

4633 readers

1 users here now

Support / questions about Lemmy.

Matrix Space: #lemmy-space

founded 5 years ago

MODERATORS

dessalines@lemmy.ml

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

[–] FuckyWucky@hexbear.net 2 points 1 year ago (1 children)

if you already have the container up you can run "docker exec -it postgres bash". this will open the shell of the postgres container

in that i think you can run postgres commands with "psql"

[–] utopify_org@lemmy.ml 1 points 1 year ago (1 children)

docker exec -it postgres bash

After executing this command and executing psql, I got this error:

psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: role "root" does not exist

[–] FuckyWucky@hexbear.net 1 points 1 year ago (1 children)

psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: role "root" does not exist

try

psql -U postgres

[–] utopify_org@lemmy.ml 1 points 1 year ago (1 children)

psql -U postgres

No luck with this comman :(

psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: role "postgres" does not exist

But is it the right docker container? The name of the container I try to connect is lemmymydomaintld_postgres_1

Seems pretty hard to delete a user this way. Do you know an easier way by any chance?

[–] FuckyWucky@hexbear.net 2 points 1 year ago (1 children)

yea im p sure cuz otherwise psql wont work

try

psql -U lemmy

i havent used lemmy, just know a bit of docker

[–] utopify_org@lemmy.ml 3 points 1 year ago* (last edited 1 year ago)

I found a solution here

A warning to people who have the same problem:

On the website there is a command, which will purge all unverified account. If your admin account wasn't verified, it will be purged, too.

Thanks a lot for your help :)