db_1 FATAL: role "root" does not exist

[urza]

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]

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

[vijaykumar1710]

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

[joon612]

Same issue here, is there any update?

[makerduck]

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]

@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.