How to specify the database name?

[Etren-zz]

When deploying odoo 15 with docker, I want to connect to an external database. How do I specify the database name when setting the variables of odoo docker? Is the variable NAME used to define the database name?

[arabkhemar]

What do you mean by "external database"? Your postgres server/container is in the same server (where Docker is installed) or in a separate one?

[Etren-zz]

What do you mean by "external database"? Your postgres server/container is in the same server (where Docker is installed) or in a separate one?

Thank you for your reply! I want the odoo container to connect to the external postgreSQL. PostgreSQL is not run in the container, but directly on the host.

[arabkhemar]

Hi @Etren, For connecting to your Postgres Server:

...
odoo:
    image: odoo:15
    environment:
      - HOST=XX.XX.XX.XX
      - PORT=5432 #default
      - USER=odoo
      - PASSWORD=odoo 
...

For database, you have to mount/edit "odoo.conf" and specify it in "db_name"

If it is not clear enough, let me now ;)

[Etren-zz]

Hi @Etren, For connecting to your Postgres Server:

...
odoo:
    image: odoo:15
    environment:
      - HOST=XX.XX.XX.XX
      - PORT=5432 #default
      - USER=odoo
      - PASSWORD=odoo 
...

For database, you have to mount/edit "odoo.conf" and specify it in "db_name"

If it is not clear enough, let me now ;)

Thank you for your reply! I have just started working with Linux systems and postgreSQL. I am using a postgreSQL auxiliary program. When creating a database through a graphical interface, I need to enter the database name, database user name and database password, and database listening address. The host address is 172.17.0.1/16 in the Docker network. My database settings are:

Database_name = my-erp
Database_user = erp-admin
Database_password = password
Listening_address = 172.17.0.0/16

postgreSQL runs directly on the host, and the firewall has released port 5432.

My command to create the odoo container is: docker run -e HOST=172.17.0.1 -e PORT=5432 -e USER=erp-admin -e PASSWORD=password -v /usr/odoo/extra-addons:/mnt/extra-addons -v /usr/odoo/odoo-files:/var/lib/odoo -d -p 8069:8069 --name odoo-15 -t odoo Is there an error in my operation?

[Etren-zz]

”#343 How to connect to the host database？“ It's the same problem.

[panha-gms]

Same problem here for me. I'm trying to connect my odoo container to rds / localhost Postgres but received connection refused. please help me.

[stavros-k]

Hi @Etren, For connecting to your Postgres Server:

...
odoo:
    image: odoo:15
    environment:
      - HOST=XX.XX.XX.XX
      - PORT=5432 #default
      - USER=odoo
      - PASSWORD=odoo 
...

For database, you have to mount/edit "odoo.conf" and specify it in "db_name"

If it is not clear enough, let me now ;)

It would be nice, to be able to specify database name with a variable, just like HOST, USER etc.

[kobeumut]

@arabkhemar How can add database name into odoo.conf before to run docker?

[barart]

same question here... does any one has already do it?

[AriesT]

docker run --name odoo -p 8069:8069 --link postgreSQL:db -e POSTGRES_USER=odoo -e POSTGRES_PASSWORD=odoo
-e POSTGRES_DB=odoo -v /mnt/odoo/data:/var/lib/odoo --restart=always -t -d odoo:15

---

docker logs -f odoo odoo: Odoo version 15.0-20220902 odoo: Using configuration file at /etc/odoo/odoo.conf odoo: addons paths: ['/usr/lib/python3/dist-packages/odoo/addons', '/mnt/extra-addons'] odoo: database: [email protected]:5432 odoo.addons.base.models.ir_actions_report: Will use the Wkhtmltopdf binary at /usr/local/bin/wkhtmltopdf odoo.service.server: HTTP service (werkzeug) running on afcf79edbe04:8069

[deyanira87]

@arabkhemar How can add database name into odoo.conf before to run docker?

You can set the db_host parameter in your odoo.conf. For example:

In your compose you can set it like this: version: '3' services: odoo: container_name: ${ODOO_HOST} image: ${ODOO_IMAGE} ports: - "${ODOO_PORT}:8069" - "${LONGPOLLING_PORT}:8072" volumes: - odoo-data:/var/lib/odoo - ./config:/etc/odoo - ./addons:/mnt/extra-addons networks: default: external: name: net-odoo volumes: odoo-data:

and in your odoo.conf (preferable inside the folder ./config) with the other necessary parameters, you just set: db_host = 63.45.12.34 db_user = <DB_USER> db_password = <DB_PASSWORD> db_port = 5432 db_name = dbfilter =

I hope it helps you.

[imp1sh]

I think this needs adjustment. The least you can do is to use a decent database name like "odoo". "postgres"? Imagine having a huge DB cluster an in between all the postgresql databases there is one called "postgres". Other than that I believe the best solution would be to make the database name configurable through a variable.

[lathama]

Something like:

version: '3.1'
services:
  testweb:
    image: odoo:17.0
    depends_on:
      - otherdb
    ports:
      - "8069:8069"
    environment:
      - HOST=otherdb
      - USER=odoo
      - PASSWORD=myodoo
    command: odoo -d customdb
  otherdb:
    image: postgres:15
    environment:
      - POSTGRES_DB=postgres
      - POSTGRES_PASSWORD=myodoo
      - POSTGRES_USER=odoo

Hope this helps. @Etren-zz if this answers your question please close this issue.

Special note, the postgresql image needs to be set to db of postgres and then odoo will create and populate the db.