Microsoft SQL Server driver installer for Local by Flywheel

install-mssql.sh

#! /bin/bash

_DEB_VER=8
_MSSQL_VER=5.6.1
_PHP_VER=7.2

# Grab dependencies, then add Microsoft repo and grab further dependencies.
apt-get -q update
apt-get install -qy curl apt-transport-https wget gnupg build-essential autoconf pkg-config
curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -
curl https://packages.microsoft.com/config/debian/$_DEB_VER/prod.list | tee --append /etc/apt/sources.list.d/mssql-release.list
apt-get -q update
ACCEPT_EULA=Y apt-get install msodbcsql17 -qy
apt-get install -qy unixodbc unixodbc-dev

# Grab and unpack the PECL SQL Server extensions.
mkdir app/sql /app/sql/sqlsrv /app/sql/pdo_sqlsrv
curl https://pecl.php.net/get/sqlsrv-$_MSSQL_VER.tgz -o /app/sql/sqlsrv.tgz
curl https://pecl.php.net/get/pdo_sqlsrv-$_MSSQL_VER.tgz -o /app/sql/pdo_sqlsrv.tgz
tar -zxf /app/sql/sqlsrv.tgz  -C /app/sql/sqlsrv
tar -zxf /app/sql/pdo_sqlsrv.tgz  -C /app/sql/pdo_sqlsrv

# Install into the current PHP installation.
cd app/sql/sqlsrv/*/
/opt/php/$_PHP_VER*/bin/phpize
./configure --with-php-config=/opt/php/$_PHP_VER*/bin/php-config
make -s
make install

cd app/sql/pdo_sqlsrv/*/
/opt/php/$_PHP_VER*/bin/phpize
./configure --with-php-config=/opt/php/$_PHP_VER*/bin/php-config
make -s
make install

# Clean up
rm -r /app/sql

# Add to php.ini if desired, and restart Apache.
if [[ $1 = '--append' ]]; then
	printf '\nextension = sqlsrv.so\nextension = pdo_sqlsrv.so\n' >> /conf/php/$_PHP_VER*/php.ini
else
	echo ''
	echo 'Add the following to your conf/php/X.X.X/php.ini file:'
	echo '[sqlsrv]'
	echo 'extension = sqlsrv.so'
	echo '[pdo_sqlsrv]'
	echo 'extension = pdo_sqlsrv.so'
	echo ''
	echo 'Afterwards, run php -m to see if they have been enabled.'
fi

echo 'Installation completed. Please restart the container.'

More info:

• Do not consider this stable.
• Change top variables if issues occur with build.
• add --append to automatically modify your php.ini file and enable it.
  • If sharing environments, this script will need to be run on each share, but without the append argument.
• Store in site/app, and execute by opening SSH and running /app/install-mssql.sh.