search

mediacms-io / mediacms

MediaCMS is a modern, fully featured open source video and media CMS, written in Python/Django and React, featuring a REST API.
https://mediacms.io
GNU Affero General Public License v3.0
2.74k stars 507 forks source link

[119] FATAL: role "root" does not exist #1002

Closed Futureganteng closed 1 week ago

Futureganteng commented 5 months ago

Hello, sorry i was not familiar with postgre

i get these error when i run the docker-compose up db_1 | 2024-04-17 22:51:02.375 BST [119] FATAL: role "root" does not exist i logged on as root on the console

then i've logged on as admin on the website but i get these message and the mediacms website goes down celery_worker_1 | 2024-04-17 21:51:14,234 INFO reaped unknown pid 54 (terminated by SIGKILL)

redouane-nouri commented 5 months ago

I got the same message, and i solved that by adding the following arguments to the "pg_isready" command in docker-compose.yaml file: image because the pg_isready command without -U is going to use the system user as the database user (in my case "root" because i executed docker-compose using sudo) i got that from: https://stackoverflow.com/questions/70205657/postgres-docker-role-root-does-not-exist

mgogoulos commented 1 week ago

Pr was merged and this is fixed now!