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

db_1 FATAL: role "root" does not exist #894

Closed urza closed 1 week ago

urza commented 12 months ago

I installed mediacms via docker compose on ubuntu server 22.04. I see a lot of these in output:

db_1 | 2023-10-04 18:53:50.517 BST [61499] FATAL: role "root" does not exist

Is this something I need to fix somehow or is it ok to ignore?

mgogoulos commented 12 months ago

This is a message that can be ignored, but since it's spamming logs should be removed (fix has to be trivial)

vijaykumar1710 commented 9 months ago

@mgogoulos is there way we can get rid of this and use the app locally on macbook? serving locally also from docker only.

joon612 commented 6 months ago

Same issue here, is there any update?

makerduck commented 4 months ago

As mentioned in #1002 there's a fix from @Nouri-redouane to suppress the output: in the docker-compose.yaml got to "db: healthcheck:" and edit "pg_isready" to

"pg_isready -d $${POSTGRES_DB} -U $${POSTGRES_USER}"

worked fine for me

working-name commented 3 months ago

@makerduck that might work with the defaults but not if you actually bothered to change the env vars. Now getting unknown role for whatever I called the POSTGRES_USER which is poopoo:

mediacms-db-1             | 2024-06-10 04:08:03.095 BST [107] FATAL:  role "poopoo" does not exist

So I think this points to an issue in the setup process as well.

EDIT: confirmed, if I switch the user to the default of mediacms the error message stops. Definitely an issue with the docker compose files.

mgogoulos commented 1 week ago

Pr was merged and this is fixed now!