Docker symfony 4 and mysql

Question

I dockerised my project symfony it works well. I run command sudo docker-compose run php bin/console doctrine:schema:update --force.

And I have this error : An exception occurred in driver: could not find driver

docker-compose.yml

eversion: '2'
services:
nginx:
    build: nginx
    ports:
        - "8080:80"
    links:
        - php
    volumes_from:
        - php
    volumes:
        - ./logs/nginx/:/var/log/nginx
        - ./symfony:/var/www/symfony
db:
    image: mysql
    ports:
        - 3307:3307
    volumes:
        - "./.data/db:/var/lib/mysql"
    environment:
      MYSQL_ROOT_PASSWORD: nolan
      MYSQL_USER: nolan
      MYSQL_PASSWORD: nolan
    ports:
      - "8002:3307"
php:
    build: php7-fpm
    ports:
        - 9002:9000
    links:
        - db:mysql
    volumes:
        - ./symfony:/var/www/symfony
        - ./logs/symfony:/var/www/symfony/app/logs

.env symfony

DATABASE_URL=mysql://nolan:[email protected]:8002/musiques

To me it looks like the DATABASE_URL is wrong. I would expect it to be DATABASE_URL=mysql://nolan:nolan@db:3307/musiques. @db references the db-service from your docker-compose.yml. The port 8002 is the one being exposed to your host system, but is not the one used between the containers — dbrumann
– dbrumann, Commented Jan 21, 2019 at 16:18
As far as I know the default port for mysql is 3306 though. So it might be that there is nothing running on the port you are exposing? — dbrumann
– dbrumann, Commented Jan 21, 2019 at 16:18
The could not find driver could hint at a missing pdo_mysqldriver. Could you also add your Dockerfile for the php container to the question? — dbrumann
– dbrumann, Commented Jan 21, 2019 at 17:59

msphn · Accepted Answer · 2019-01-21 17:46:22Z

2

Install php pdo MySQL package inside your php container.

answered Jan 21, 2019 at 17:46

msphn

3092 silver badges9 bronze badges

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

3 Comments

Nono 45 Over a year ago

si i have an other error An exception occurred in driver: SQLSTATE[HY000] [2054] The server requeste d authentication method unknown to the client

msphn Over a year ago

Are you on mysql8?

msphn Over a year ago

If so I think they changed something with the hashes. But not sure. You should google it

Collectives™ on Stack Overflow

Docker symfony 4 and mysql

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related