How to migrate to db on docker (Symfony)?

Question

version: '3'

services:
    db:
        image: mysql:8.0.20
        command: --default-authentication-plugin=mysql_native_password
        volumes:
            - "db_app:/var/lib/mysql"
        environment:
            MYSQL_ROOT_PASSWORD: ${MYSQL_ROOT_PASSWORD}
            MYSQL_DATABASE: ${MYSQL_DATABASE}
            MYSQL_USER: ${MYSQL_USER}
            MYSQL_PASSWORD: ${MYSQL_PASSWORD}
        ports:
            - 3306:3306
        networks:
            - symfony
    php:
        build:
            context: .
            dockerfile: docker/php/Dockerfile
            args:
                TIMEZONE: ${TIMEZONE}
        volumes:
            - ./symfony/:/Users/admin/Downloads/symfony-docker-master/symfony
        networks:
            - symfony
    nginx:
        build:
            context: .
            dockerfile: docker/nginx/Dockerfile
        volumes:
            - ./symfony/:/Users/admin/Downloads/symfony-docker-master/symfony
        ports:
            - 8050:8050
        networks:
            - symfony

volumes:
    db_app:

networks:
    symfony:

The application starts, connects to the database via

DATABASE_URL=mysql://user:123@db:3306/db

But when performing migrations through the console, I get the error

An exception occurred in driver: SQLSTATE[HY000] [2002] php_network_getaddr  
  esses: getaddrinfo failed: nodename nor servname provided, or not known

As I understand it, due to the fact that the address is specified in the connection db.

How to make migrations?

symfony network in your case is redundant, because compose by default creates a bridge network which joins all your services — pauk960
– pauk960, Commented Jul 31, 2020 at 14:54

pauk960 · Accepted Answer · 2020-07-31 15:00:57Z

1

You need to run console commands from inside of your php container

docker-compose exec php bin/console doctrine:migrations:migrate

answered Jul 31, 2020 at 15:00

pauk960

3002 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Alex Over a year ago

How can I execute this command automatically when running docker-compose up --build?

zedling Over a year ago

I would like an answer too

exepti0n · Accepted Answer · 2020-07-31 09:03:10Z

0

You should connect to the container name.

These can be found by running docker container ls on your console.

It's easier when you specify the name in your compose file like so:

services:
    db:
        container_name: db # This can be anything
        image: mysql:8.0.20

answered Jul 31, 2020 at 9:03

exepti0n

6115 silver badges17 bronze badges

Collectives™ on Stack Overflow

How to migrate to db on docker (Symfony)?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related