Is it possible to connect wit the docker setup to a database on the same workstation ?

I have a docker setup on my workstation, and I was up to connect it to the localhost MySQL database. (like this :)

services:
  redmine:
    image: redmine:alpine
    restart: always
    ports:
      - 80:3000
    environment:
      REDMINE_DB_MYSQL: 127.0.0.1
      REDMINE_DB_PORT: 3306
      REDMINE_DB_USERNAME: redmine
      REDMINE_DB_PASSWORD: redmine
      REDMINE_DB_DATABASE: redmine
      REDMINE_SECRET_KEY_BASE: supersecretkey

I was not successful because the container was trying to connect inside to the 127.0.0.1, respectively to the socket.
what is the right setup for this?

Replies (2)

RE: Is it possible to connect wit the docker setup to a database on the same workstation ? - Added by Pav ata about 1 month ago

If by "same workstation" you mean the host system to your containers, then..
To container 127.0.0.1 is its own loopback device.
On Linux host I'd use a docker/podman network (default, I think, is of bridge type) which gives access to the host, then I'd connect Redmine to a newly created - for containers purposes - 'dummy' iface on the host(making sure relevant services, on the host, listen on it and also firewalls are taken into account)

RE: Is it possible to connect wit the docker setup to a database on the same workstation ? - Added by Lionel BAKALA about 10 hours ago

Hi Christian,

In bridge network mode, each container has a "Gateway" address that represents the host.

For a network named redmine_default, we have the following configuration:

docker network inspect redmine_default | grep -Ew "Gateway|Name|IPv4Address" | sed 's/^[[:space:]]*//'
"Name": "redmine_default",
"Gateway": "172.25.0.1" 
"Name": "redmine-mariadb-1",
"IPv4Address": "172.25.0.2/16",
"Name": "redmine-redmine-1",
"IPv4Address": "172.25.0.3/16",

172.25.0.1 is the host machine's address as seen from the containers within the redmine_default network.

And the question is: Which Docker network is my container using ?

Kind regards.

(1-2/2)

Project

General

Profile

Redmine