Issue Extension PHP mssql PHP7

[Marcio Nunes]

Hi!
My custommer need load mssql.so to connect with SQL Server, but cannot active this extension.
How load in my PHP 7.0/7.1 mssql?

This is old server, with FreeTDS, not found any docs
mssql
MSSQL Support enabled
Active Persistent Links 0
Active Links 0
Library version FreeTDS

This link step by step is done, but dont work, the PHP show error Call to undefined function mssql_connect()
https://talk.plesk.com/threads/cant-install-php7-pecl-oauth-on-plesk-12-5-30.336791/#post-803386

 

[IgorG]

# /opt/plesk/php/7.1/bin/php -m | grep mysql
mysqli
mysqlnd
pdo_mysql

Why is it not enough for you?

 

[Marcio Nunes]

Important! I need MSSQL (conect with external Microsoft SQL Server)

 

[IgorG]

Oh, MSSQL! Sorry.

Look at this thread, maybe it will help - https://talk.plesk.com/threads/mssql-in-plesk-12-5.335069/

 

[Marcio Nunes]

All my servers is distro Ubuntu.. this link dont work:
https://devblog.plesk.com/2015/08/adding-custom-php-modules-in-plesk/

 

[Marcio Nunes]

Could anyone help?

 

[IgorG]

Main idea - to find the appropriate package with mssql.so for Ubuntu and your PHP version, extract it from the package and put to correct place with adding mssql.ini php config.
Try to find it at least.

 

[Marcio Nunes]

Yes! Good idea, but this file (mssql.so) dont exist for Ubuntu 14 or PHP 7.x

 

[IgorG]

Hint - FreeTDS, try to find instruction for Ubuntu, adapt it for Plesk and share your results here!

 

[Marcio Nunes]

Hi!
FreeTDS dont work with PHP 7.x