Last active
February 14, 2018 09:21
-
-
Save wagura-maurice/45931b04df536d3434f2cadb567fe011 to your computer and use it in GitHub Desktop.
How to set up drivers for connecting php 7.1 to MsSQL server on Ubuntu 16.04
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
sudo su | |
add-apt-repository ppa:ondrej/php | |
apt-get update | |
apt-get -y install php7.1 mcrypt php7.1-mcrypt php-mbstring php-pear php7.1-dev php7.1-xml | |
sudo su | |
curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add - | |
curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list > /etc/apt/sources.list.d/mssql-release.list | |
exit | |
sudo apt-get update | |
sudo ACCEPT_EULA=Y apt-get install msodbcsql=13.1.4.0-1 mssql-tools=14.0.3.0-1 unixodbc-dev | |
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile | |
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc | |
source ~/.bashrc | |
sudo pear config-set php_ini `php --ini | grep "Loaded Configuration" | sed -e "s|.*:\s*||"` system | |
sudo pecl install sqlsrv | |
sudo pecl install pdo_sqlsrv | |
sudo su | |
apt-get install libapache2-mod-php7.1 apache2 | |
a2dismod mpm_event | |
a2enmod mpm_prefork | |
a2enmod php7.1 | |
echo "extension=sqlsrv.so" >> /etc/php/7.1/apache2/php.ini | |
echo "extension=pdo_sqlsrv.so" >> /etc/php/7.1/apache2/php.ini | |
sudo systemctl restart apache2 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment