Hi all,
I am facing the following issue when trying to set up Odoo on my Debian server.
Log file on de database docker mention the following
2023-11-10 09:17:04.692 UTC [499] DETAIL: Role "odoo" does not exist.
Connection matched file "/var/lib/postgresql/data/pgdata/pg_hba.conf" line 128: "host all all all scram-sha-256"
This is my docker-compose.yml
version: '3.3'
networks:
internal:
external: false
# backend:
# external: false
########################### SECRETS
secrets:
postgres_sql_password:
file: ${APP_DATA_DIR}/secrets/postgresql_password
services:
#
#
#
# ODOO APP
odoo:
image: odoo:16.0
container_name: odoo
restart: unless-stopped
depends_on:
- db
ports:
- 8069:8069
volumes:
- ${APP_DATA_DIR}/odoo/app:/var/lib/odoo
- ${APP_DATA_DIR}/odoo/addons:/mnt/extra-addons
environment:
- TZ=$TZ
- PASSWORD_FILE=/run/secrets/postgresql_password
- HOST=db
- USER=odoo
secrets:
- postgresql_password
networks:
- internal
links:
- db
#
#
#
# ODOO APP TRAEFIK OK
db:
image: postgres:latest
container_name: db
volumes:
- ${APP_DATA_DIR}/odoo/db:/var/lib/postgresql/data/pgdata
restart: unless-stopped
networks:
- internal
environment:
- POSTGRES_DB=postgres
- POSTGRES_PASSWORD=/run/secrets/postgresql_password
- POSTGRES_USER=odoo
- PGDATA=/var/lib/postgresql/data/pgdata
secrets:
- postgresql_password
