#SQLSRV PHP 8.1 INSTALL#
#SQLSRV PHP 8.1 DRIVER#

#SQLSRV PHP 8.1 DRIVER#

Installing the Microsoft ODBC Driver for SQL Server on Linux and macOS Instructions are taken from the Microsoft documentation page and adapted to Plesk PHP:

Restart the PHP-FPM master process to apply changes to FPM sites.

# /opt/plesk/php/ X.X/bin/php -m | grep sqlsrv Note: ' X.X' is to be replaced with the PHP version. # echo 'extension=sqlsrv.so' > /opt/plesk/php/X.X/etc/php.d/sqlsrv.ini

#SQLSRV PHP 8.1 INSTALL#

# /opt/plesk/php/X.X/bin/pecl install sqlsrv # echo 'extension=pdo_sqlsrv.so' > /opt/plesk/php/X.X/etc/php.d/pdo_sqlsrv.ini # /opt/plesk/php/7.X/bin/pecl install pdo_sqlsrv # echo 'extension=sqlsrv.so' > /opt/plesk/php/7.2/etc/php.d/sqlsrv.iniįor later PHP 7.X and PHP 8.X versions provided by Plesk: # /opt/plesk/php/7.2/bin/pecl install sqlsrv-5.8.1 # echo 'extension=pdo_sqlsrv.so' > /opt/plesk/php/7.2/etc/php.d/pdo_sqlsrv.ini

# /opt/plesk/php/7.2/bin/pecl install pdo_sqlsrv-5.8.1 For example, ' 74' for PHP 7.4 or ' 80' for PHP 8.0Īdd the pdo_sqlsrv and sqlsrv-5.8.1 modules: Note: ' XX' is to be replaced with the PHP version. # yum install unixODBC-devel make gcc-c++ gcc autoconf automake plesk-php XX-devel libtool-ltdl.x86_64 libtool-ltdl-devel.x86_64 # yum remove unixODBC-utf16 unixODBC-utf16-devel # curl debian/11/prod.list > /etc/apt//mssql-release.list # /opt/plesk/php/ 8.X/bin/php -m | grep sqlsrv # echo 'extension=sqlsrv.so' > /opt/plesk/php/ 8.1/etc/php.d/sqlsrv.ini # /opt/plesk/php/ 8.1/bin/pecl install sqlsrv # echo 'extension=pdo_sqlsrv.so' > /opt/plesk/php/ 8.1/etc/php.d/pdo_sqlsrv.ini # /opt/plesk/php/ 8.1/bin/pecl install pdo_sqlsrv # curl ubuntu/22.04/prod.list > /etc/apt//mssql-release.list Note: ' 8X' is to be replaced with the PHP version. # apt-get install apt-transport-https make gcc g++ unixodbc unixodbc-dev plesk-php 8X-dev

Restart the PHP-FPM master process to apply changes to FPM sites # /opt/plesk/php/ 7.X/bin/php -m | grep sqlsrv Make sure that the required modules are enabled: Reread the components properties to make modules visible in GUI:.# echo 'extension=sqlsrv.so' > /opt/plesk/php/ 7.X/etc/php.d/sqlsrv.ini # /opt/plesk/php/ 7.X/bin/pecl install sqlsrv # echo 'extension=pdo_sqlsrv.so' > /opt/plesk/php/ 7.X/etc/php.d/pdo_sqlsrv.ini # /opt/plesk/php/ 7.X/bin/pecl install pdo_sqlsrv # echo 'extension=sqlsrv.so' > /opt/plesk/php/ 8.0/etc/php.d/sqlsrv.ini # /opt/plesk/php/ 8.0/bin/pecl install sqlsrv # echo 'extension=pdo_sqlsrv.so' > /opt/plesk/php/ 8.0/etc/php.d/pdo_sqlsrv.ini # /opt/plesk/php/ 8.0/bin/pecl install pdo_sqlsrv # ACCEPT_EULA=Y apt-get install msodbcsql18Īdd the pdo_sqlsrv and sqlsrv-5.8.1 modules: # curl ubuntu/18.04/prod.list > /etc/apt//mssql-release.list If Debian is used, replaced the URL accordingly (for ie: ' /debian/10/' or ' /ubuntu/20.04/') The following example is for Ubuntu 18.04. Note: ' 7X' is to be replaced with the PHP version. # apt-get install apt-transport-https make gcc g++ unixodbc unixodbc-dev plesk-php 7X-dev

Sqlsrv php 8.1