If you search for SQL Server you will see batch script to install. This will install mssql requirement on php-fpm and workspace containers.ĭocker files can be found on /php-fpm and /workspace env file on laradoc folder and set this 2 variables to true: mysql container was irrelevant for this case.Īssuming that you have laradoc setup (follow docs or videos on Youtube). It happens that my Laravel web application connects to mysql and mssql.

On this case it is nginx container that leverages also php-fpm and workspace containers (where docker file has the mssql script). Laradock is very complex project with a lot of diferent container setup mainly for Laravel developers. & docker-php-ext-enable pdo_sqlsrv sqlsrv Pecl install pdo_sqlsrv-5.3.0 sqlsrv-5.3.0 Replace pdo_sqlsrv-4.1.8preview with preferred version. # Install pdo_sqlsrv and sqlsrv from PECL. & ln -sfn /etc/locale.alias /usr/share/locale/locale.alias & echo 'en_US.UTF-8 UTF-8' > /etc/locale.gen & echo 'en_US.UTF-8 zh_CN.UTF-8 UTF-8' > /etc/locale.gen & ACCEPT_EULA=Y apt-get install -y unixodbc unixodbc-dev libgss3 odbcinst msodbcsql17 locales # Add Microsoft repo for Microsoft ODBC Driver 13 for LinuxĪpt-get install -y apt-transport-https gnupg & ln -s /usr/lib/x86_64-linux-gnu/libsybdb.so /usr/lib/libsybdb.so

This is the DockerFile script to install SQL Server driver on PHP-FPM container I am using laradoc project to setup my needed docker containers. Expected behavior and actual behaviorĬonnection to SQL Server successfully Repro code or steps to reproduce Please take in account I am trying to connect to an SQL Server 2008 R2 and upgrade server is not an option. I am not able to setup SQL Server driver on PHP-FPM container. I am start using Docker for PHP development, and I want to connect to SQL Server from Laravel Project.

Ubuntu 16.04.6 LTS (Docker container) PHP version

Odbc driver for sql server 2008