I'm having trouble running my services in the docker-compose.yml file

Docker Engine Compose
1 
services:
  web:
    image: odoo:17.0
    container_name: odoo_conteiner
    depends_on:
      - db
    ports:
      - "8069:8069"
    volumes:
      - odoo-web-data:/var/lib/odoo
      - ./addons:/mnt/extra-addons
    environment:
      - HOST=db
      - DB_NAME=organizacao power
      - DB_USER=florest
      - DB_PASSWORD=mosic
    command: -- --dev=all -i base

  db:
    image: postgres:15
    container_name: db_conteiner
    environment:
      - POSTGRES_DB=organizacao power
      - POSTGRES_USER=florest
      - POSTGRES_PASSWORD=mosic
    volumes:
      - odoo-db-data:/var/lib/postgresql/data

volumes:
  odoo-web-data:
  odoo-db-data:

domingos-domingos-HP-ProBook-650-G2:/Odoo_Novo$ docker compose logs -f web
odoo_conteiner | Database connection failure: connection to server at "db" (172.19.0.2), port 5432 failed: FATAL: password authentication failed for user "odoo"
2

Please translate you post to English, and replace you initial post with it.

I will hide your post until the translation is posted.

5

I listed the topic again, since I just visited the forum and I saw it as a new topic, but it is better to write a new message if you want to notify users about an edited previous post as we only get notifications about new posts.

I also added code formatting and I am going to move the topic to another category, because you somehow created the topic in the “Archive” category. I will check our settings too, but if you really want answers, make sure you spend time on finding the right category.

I also deleted a duplicate in the “Support” category.

6

So the error message says password authentication failed. That means you have to use the correct username and password. I could be wrong, but I believe you would have a different message if it was a network issue. I’m not sure, but either way, if you expect the compose project work immediately after running docker compose up -d the first time, that might not happen since the database server could need more time to be initialized then the web container to try to connect to the DB. So when the web container tries, the database is not ready yet.

If it is the case, you can try again later. Check the database logs too. If that is failing, it will never work until you fix it. The space in the database name seems to be unusual to me, but the error message is not about accessing the database, but authenticating, so it is probably not becuse of the database name.

7

Something is not adding up. The error message says password authentication failed for user "odoo". Though, the environment variable is set to DB_USER=florent

According https://hub.docker.com/_/odoo/ the DB_USER variable is not correct, the right environment variables are these:

Environment Variables

Tweak these environment variables to easily connect to a postgres server:

  • HOST: The address of the postgres server. If you used a postgres container, set to the name of the container. Defaults to db.
  • PORT: The port the postgres server is listening to. Defaults to 5432.
  • USER: The postgres role with which Odoo will connect. If you used a postgres container, set to the same value as POSTGRES_USER. Defaults to odoo.
  • PASSWORD: The password of the postgres role with which Odoo will connect. If you used a postgres container, set to the same value as POSTGRES_PASSWORD. Defaults to odoo.
8

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.