Applicable to:
- Plesk Onyx for Linux
Question
It is required to connect to SQLServer(MSSQL) databases via PHP script on Linux systems.
What extension should be installed and how it can be done?
Answer
Note: These extensions were not officially tested with Plesk and they are not officially supported. Perform all operations at your own risk.
Modules
sqlsrv
and
pdo_sqlsrv
should be enabled for PHP engine. Check the Microsoft documentation to find installation steps for Linux-distributions - Installing the Microsoft ODBC Driver for SQL Server on Linux and macOS
As an example, here are instructions for PHP 7.0:
-
Connect to the server using SSH
-
Once connected perform the following steps:
An example for Ubuntu 16.04:
# apt-get install apt-transport-https gcc plesk-php70-dev g++ unixodbc unixodbc-dev
# 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
# apt-get update
# ACCEPT_EULA=Y apt-get install msodbcsql
# /opt/plesk/php/7.0/bin/pecl install pdo_sqlsrv
# echo "extension=pdo_sqlsrv.so" > /opt/plesk/php/7.0/etc/php.d/pdo_sqlsrv.ini
# /opt/plesk/php/7.0/bin/pecl install sqlsrv
# echo "extension=sqlsrv.so" > /opt/plesk/php/7.0/etc/php.d/sqlsrv.ini
# plesk bin php_handler --rereadAn example for CentOS 7:
# curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/mssql-release.repo
# yum remove unixODBC-utf16 unixODBC-utf16-devel
# ACCEPT_EULA=Y yum install msodbcsql
# yum install unixODBC-devel gcc-c++ gcc plesk-php70-devel autoconf automake
# /opt/plesk/php/7.0/bin/pecl install pdo_sqlsrv
# echo "extension=pdo_sqlsrv.so" > /opt/plesk/php/7.0/etc/php.d/pdo_sqlsrv.ini
# /opt/plesk/php/7.0/bin/pecl install sqlsrv
# echo "extension=sqlsrv.so" > /opt/plesk/php/7.0/etc/php.d/sqlsrv.ini
# plesk bin php_handler --reread -
Check that modules are enabled:
# /opt/plesk/php/7.0/bin/php -m | grep sqlsrv
pdo_sqlsrv
sqlsrv
Comments
8 comments
Note in case someone stumbles across this article: I had to run the reread command for them to show up: https://www.danhendricks.com/2017/11/installing-microsoft-sql-server-php-extensions-plesk-onyx/
@Daniel, Thank you for your input! You are right, that command is necessary indeed. The article has been modified accordingly.
Hi,
can you make the same proccess for CENTOS?
i followed this: https://www.danhendricks.com/2017/11/installing-microsoft-sql-server-php-extensions-plesk-onyx/
and got some errors
Noam
@Noam, Hi!
The article was updated with the corresponding steps for CentOS 7.
Good morning,
I've installed sqlsrv extension for php 7.0 but I still have PDO Exception driver not found.
@Federica Della Monica
Hi!
Make sure pdo_mysql is also installed and enabled.
In case you will have difficulties, feel free to contact Plesk Support.
Hi!
pdo_mysql is installed and enabled.
See image below
@Federica Della Monica
Hi!
Due to issue complexity, I would suggest contacting Plesk Technical Support for deeper investigation.
Please sign in to leave a comment.