Add MS SQL to Enhance

Modified on Mon, 10 Aug at 2:03 PM
curl -fsSL https://packages.microsoft.com/keys/microsoft.asc | gpg --dearmor -o /usr/share/keyrings/microsoft-prod.gpg
curl -fsSL https://packages.microsoft.com/config/ubuntu/$(lsb_release -rs)/prod.list | tee /etc/apt/sources.list.d/mssql-release.list
apt update
ACCEPT_EULA=Y apt install -y msodbcsql18 mssql-tools18 unixodbc-dev make gcc g++ autoconf

# 1. Install for PHP 8.3
/opt/ecp-php83/bin/pecl install sqlsrv
/opt/ecp-php83/bin/pecl install pdo_sqlsrv

# 2. Install for PHP 8.4
/opt/ecp-php84/bin/pecl install sqlsrv
/opt/ecp-php84/bin/pecl install pdo_sqlsrv

# 3. Install for PHP 8.5
/opt/ecp-php85/bin/pecl install sqlsrv
/opt/ecp-php85/bin/pecl install pdo_sqlsrv

# Enable on PHP 8.3
echo "extension=sqlsrv.so" >> /opt/ecp-php83/etc/php.ini
echo "extension=pdo_sqlsrv.so" >> /opt/ecp-php83/etc/php.ini

# Enable on PHP 8.4
echo "extension=sqlsrv.so" >> /opt/ecp-php84/etc/php.ini
echo "extension=pdo_sqlsrv.so" >> /opt/ecp-php84/etc/php.ini

# Enable on PHP 8.5
echo "extension=sqlsrv.so" >> /opt/ecp-php85/etc/php.ini
echo "extension=pdo_sqlsrv.so" >> /opt/ecp-php85/etc/php.ini