When I run docker-compose up
and do some composer
commands, I get error
In Connection.php line 664: could not find driver (SQL: select
id
,name
fromusers
In Connector.php line 68: could not find driver …
Why cant Laravel connect to mysql? I can do mysql -h db
in docker-compose exec web bash
and it works.
My setup
docker-compose.yml
version: '3'
services:
web:
build: ./webserver
ports:
- "80:80"
- "443:443"
volumes:
- //docker/dockertest/webserver/app:/var/www/vhosts/app
links:
- db
command:
- /usr/local/bin/apache2_install_composer_dependencies.sh
db:
image: mysql:8.0
container_name: db
ports:
- "3306:3306"
command: --default-authentication-plugin=mysql_native_password
environment:
MYSQL_DATABASE: myDb
MYSQL_USER: user
MYSQL_PASSWORD: test
MYSQL_ROOT_PASSWORD: test
volumes:
- //docker/dockertest/install/db_dump:/docker-entrypoint-initdb.d
- persistent:/var/lib/mysql
networks:
- default
phpmyadmin:
image: phpmyadmin/phpmyadmin
links:
- db:db
ports:
- 8000:80
environment:
MYSQL_USER: user
MYSQL_PASSWORD: test
MYSQL_ROOT_PASSWORD: test
volumes:
persistent:
Laravel .env
(I reference these values in config/database.php
)
...
DB_CONNECTION=mysql
#host points to Docker container
DB_HOST=db
DB_PORT=3306
DB_DATABASE=myDb
DB_USERNAME=user
DB_PASSWORD=test
....
webserver/Dockerfile
FROM php:7.2.19-apache-stretch
# Configure Apache server
COPY config_apache/sites-available /etc/apache2/sites-available
# Create symlink in sites-enabled
WORKDIR /etc/apache2/sites-enabled
RUN ln -s /etc/apache2/sites-available/app.conf app.conf
RUN mkdir -p /var/www/vhosts/app/logs
COPY /build_files/install_composer_dependencies.sh /usr/local/bin/apache2_install_composer_dependencies.sh
RUN apt-get update -y && apt-get install -y curl nano libapache2-mod-geoip git zip unzip mysql-client
# Install Composer
RUN curl -o /tmp/composer-setup.php https://getcomposer.org/installer
&& curl -o /tmp/composer-setup.sig https://composer.github.io/installer.sig
# Verify installer
&& php -r "if (hash('SHA384', file_get_contents('/tmp/composer-setup.php')) !== trim(file_get_contents('/tmp/composer-setup.sig'))) { unlink('/tmp/composer-setup.php'); echo 'Invalid installer' . PHP_EOL; exit(1); }"
&& php /tmp/composer-setup.php --no-ansi --install-dir=/usr/local/bin --filename=composer --snapshot
&& rm -f /tmp/composer-setup.*
RUN a2enmod rewrite
RUN a2enmod geoip
RUN service apache2 restart
2
Answers
Adding
RUN docker-php-ext-install mysqli pdo pdo_mysql
(withoutmysql
) to Dockerfile as @NigelRen suggested resolved this error.try to install php-mysql with following command
sudo apt-get install php-mysql
and restart your server