Docker error with mysql connexion when docker-up

Question

I have a problem with docker and mysql (i am pretty new with docker) I am trying to use symfony 3.4 with docker.

I have this error :

In AbstractMySQLDriver.php line 103:

An exception occured in driver: SQLSTATE[HY000] [2002] php_network_getaddre
sses: getaddrinfo failed: Name does not resolve

In PDOConnection.php line 47:

SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name d
oes not resolve

In PDOConnection.php line 43:

SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name d
oes not resolve

In PDOConnection.php line 43:

PDO::__construct(): php_network_getaddresses: getaddrinfo failed: Name does
not resolve

And i really don't know what to do ...

Here is my docker-compose :

version: "3"

services:
  apache:
    build: ./docker/apache/
    ports:
      - "80:80"
    depends_on:
      - php
  php:
    build: .
    ports:
      - "8080:8000"
  db:
    image: mysql:8.0.0
    ports:
      - "3306:3306"
    volumes:
      - /docker/database:/etc/mysql/conf.d
    restart: always
    environment:
      - MYSQL_ROOT_PASSWORD=toor
      - MYSQL_USER=me
      - MYSQL_PASSWORD=pwd
      - MYSQL_DATABASE=name
  phpmyadmin:
    image: phpmyadmin/phpmyadmin
    environment:
      - PMA_HOST=db
      - PMA_PORT=3306
    ports:
      - "80:80"
    links:
      - db

My docker file :

FROM php:7.3-rc-zts-alpine

RUN curl -sS https://getcomposer.org/installer | \
php -- --install-dir=/usr/bin/ --filename=composer

WORKDIR /app

COPY . .

RUN COMPOSER_MEMORY_LIMIT=-1 composer install

RUN docker-php-ext-install pdo_mysql

RUN php bin/console doctrine:schema:update --force

COPY . .

EXPOSE 8080 8000

CMD ["php",  "bin/console", "server:run", "0.0.0.0:8000"]

And my config for symfony :

parameters:
   database_host: db
   database_port: 3306
   ...

Not sure but in your docker-compose, your php container doesn't have a link to the db container (have a look at the phpmyadmin which has links:... - db. — Nigel Ren
links is obsoleted ( docs.docker.com/compose/compose-file/#links ) — EchoMike444
yes .... even with link is not working (i also tried in php to do a depends_on : db) — Someone

EchoMike444 EchoMike444 · Accepted Answer · 2019-11-16T03:40:57

When you run docker-compose up , all containers will start , the issue you have is that your php container start too quickly .

And after , the database server will take a long time to start 1 sec or more.

You php is not patient , and does not retry .

You must do a loop to check if you db is up , in my example i use nc -z db 3306 to see if i connect to the port 3306 of the host db

A example of a setup with a Docker-compose.yml

version: "3"

services:
  php:
    build: .
    ports:
      - "8080:8000"
  db:
    image: mysql:8.0.0
    ports:
      - "3306:3306"
    restart: always
    environment:
      - MYSQL_ROOT_PASSWORD=toor
      - MYSQL_USER=me
      - MYSQL_PASSWORD=pwd
      - MYSQL_DATABASE=name

and a docker file

FROM php:7.3-rc-zts-alpine

RUN apk update && apk add netcat-openbsd && apk add mariadb-client

CMD ["/bin/sh","-c", \
     "( while ( ! nc -z db 3306 >/dev/null 2>&1 ) ; do \
           date ; sleep 4 ; \
        done ;  \
        mysql -h db -u me -ppwd name -e \"show databases\"; sleep 3600 ; ) " ]

Docker error with mysql connexion when docker-up

2 Answers