Created
February 5, 2020 20:26
-
-
Save jgaydos/a34f207a5ca39ae0b94b2529b4d3a9bb to your computer and use it in GitHub Desktop.
Ubuntu 18.04 + PHP7.4 + SQLSRV
This file contains 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
#!/bin/bash | |
#ubuntu 18.04 | |
#php7.4 | |
# install php ppa | |
apt -y install software-properties-common | |
add-apt-repository ppa:ondrej/php -y | |
apt update | |
# install php w/o apache | |
apt -y install php7.4-cli php7.4-mbstring php-pear php7.4-dev php7.4-gd php7.4-zip php7.4-xml | |
# install sqlcmd | |
curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add - | |
curl https://packages.microsoft.com/config/ubuntu/18.04/prod.list | tee /etc/apt/sources.list.d/mssql-tools.list | |
apt update | |
ACCEPT_EULA=Y apt -y install msodbcsql17 | |
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile | |
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc | |
source ~/.bashrc | |
apt -y install unixodbc-dev | |
# install sqlsrv driver | |
# if this fails install sqlsrv-5.5.0preview & pdo_sqlsrv-5.5.0preview | |
pecl install sqlsrv pdo_sqlsrv | |
printf "; priority=20\nextension=sqlsrv.so\n" > /etc/php/7.4/mods-available/sqlsrv.ini | |
printf "; priority=30\nextension=pdo_sqlsrv.so\n" > /etc/php/7.4/mods-available/pdo_sqlsrv.ini | |
phpenmod -v 7.4 sqlsrv pdo_sqlsrv |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment