PHP Warning: PHP Startup: Unable to load dynamic library 'sqlsrv.so' & 'pdo_sqlsrv.so'

[conandrum]

Hi,
I wanted to be able to access SQL Server from Ubuntu 18.04, so I followed this procedure:

sudo su
curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -

#Download appropriate package for the OS version - Ubuntu 18.04
curl https://packages.microsoft.com/config/ubuntu/18.04/prod.list > /etc/apt/sources.list.d/mssql-release.list
exit
sudo apt-get update
sudo ACCEPT_EULA=Y apt-get install msodbcsql17

# optional: for bcp and sqlcmd
sudo ACCEPT_EULA=Y apt-get install mssql-tools
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc
# optional: for unixODBC development headers
sudo apt-get install unixodbc-dev

# I did not run the following line
# sudo apt-get -y install php-pear php7.2-dev

sudo pecl install sqlsrv
sudo pecl install pdo_sqlsrv
sudo su
printf "; priority=20\nextension=sqlsrv.so\n" > /etc/php/7.2/mods-available/sqlsrv.ini
printf "; priority=30\nextension=pdo_sqlsrv.so\n" > /etc/php/7.2/mods-available/pdo_sqlsrv.ini
printf "; priority=20\nextension=sqlsrv.so\n" > /etc/php/7.3/mods-available/sqlsrv.ini
printf "; priority=30\nextension=pdo_sqlsrv.so\n" > /etc/php/7.3/mods-available/pdo_sqlsrv.ini
printf "; priority=20\nextension=sqlsrv.so\n" > /etc/php/7.4/mods-available/sqlsrv.ini
printf "; priority=30\nextension=pdo_sqlsrv.so\n" > /etc/php/7.4/mods-available/pdo_sqlsrv.ini
exit

sudo phpenmod sqlsrv pdo_sqlsrv
sudo service apache2 restart

I got only warnings with sudo pecl install pdo_sqlsrv & pdo_sqlsrv :

Notice: Trying to access array offset on value of type bool in PEAR/REST.php on line 187
PHP Notice:  Trying to access array offset on value of type bool in /usr/share/php/PEAR/REST.php on line 187

Notice: Trying to access array offset on value of type bool in PEAR/REST.php on line 187
PHP Notice:  Trying to access array offset on value of type bool in /usr/share/php/PEAR/REST.php on line 187

Notice: Trying to access array offset on value of type bool in PEAR/REST.php on line 187
PHP Notice:  Trying to access array offset on value of type bool in /usr/share/php/PEAR/REST.php on line 187

Notice: Trying to access array offset on value of type bool in PEAR/REST.php on line 187
PHP Notice:  Trying to access array offset on value of type bool in /usr/share/php/PEAR/REST.php on line 187
WARNING: channel "pecl.php.net" has updated its protocols, use "pecl channel-update pecl.php.net" to update

I did not try to rectify the above notices....
No errors were reported, so I thought all was ok, until I ran 'php -v' which gives me:

PHP Warning:  PHP Startup: Unable to load dynamic library 'sqlsrv.so' (tried: /usr/lib/php/20190902/sqlsrv.so (/usr/lib/php/20190902/sqlsrv.so: cannot open shared object file: No such file or directory), /usr/lib/php/20190902/sqlsrv.so.so (/usr/lib/php/20190902/sqlsrv.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'pdo_sqlsrv.so' (tried: /usr/lib/php/20190902/pdo_sqlsrv.so (/usr/lib/php/20190902/pdo_sqlsrv.so: cannot open shared object file: No such file or directory), /usr/lib/php/20190902/pdo_sqlsrv.so.so (/usr/lib/php/20190902/pdo_sqlsrv.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP 7.4.7 (cli) (built: Jun 12 2020 07:44:05) ( NTS )
Copyright (c) The PHP Group
Zend Engine v3.4.0, Copyright (c) Zend Technologies
    with Zend OPcache v7.4.7, Copyright (c), by Zend Technologies

I have checked '/usr/lib/php/20190902/' which indeed does not contain these files.
They are actually in '/usr/lib/php/20170718/'

What did I do wrong in the installation? How do I fix this?

Thanks for your help people.

[yitam]

@conandrum you're using multiple php versions, and which php version do you want?

If you want php 7.4 only, please uninstall the others and follow the online instructions

If you want to keep more than one php version, please check how to switch between multiple php versions in Ubuntu

This related issue #1142 might give you some ideas, or please check this WIKI entry

[conandrum]

This is a development server, multiple PHP versions are required to test various software. I want all versions.
I can switch easily between versions using virtualmin.

My issue has to do with the linkage of the plugins sqlsrv.so & pdo_sqlsrv.so.
They have been installed in the wrong folder, or are being referenced wrongly.
Can someone shed some light ?

[conandrum]

Thanks for your link... I am reading it.

[conandrum]

Hi Yitam,
I have checked the article but still not sure what exactly is wrong in my install procedure.
I assume that the 7.2 version of the driver has been installed due to the path where the pdo_sqlsrv.so & sqlsrv.so files have been placed.
I assume that there is an entry somewhere pointing to the 7.4 version of the path where the files are expected to be (but are not found).
What I do not understand is this:

1. How should I have correctly installed these drivers for MULTIPLE PHP versions?

[yitam]

Yes @conandrum the key is to use update-alternatives as explained in how to switch between multiple php versions in Ubuntu. Every time you use pecl install sqlsrv drivers please do the following first, for each php version. For example, for php 7.4, just replace 7.3 with 7.4

sudo update-alternatives --set php /usr/bin/php7.3
sudo update-alternatives --set phar /usr/bin/phar7.3
sudo update-alternatives --set phar.phar /usr/bin/phar.phar7.3
sudo update-alternatives --set phpize /usr/bin/phpize7.3
sudo update-alternatives --set php-config /usr/bin/php-config7.3

Also, with sudo phpenmod and a2enmod you have to specify the php version too, like this sudo phpenmod -v 7.4 sqlsrv pdo_sqlsrv.

For details please follow the online instructions

[conandrum]

@yitam what would you suggest I do to remedy the situation now?
Should I try to completely uninstall everything and start over, or try something else?

[yitam]

@conandrum I suppose you don't have to uninstall the php versions, and you probably have php 7.2 set up already.

Make sure you use update-alternatives as mentioned above before sudo pecl install sqlsrv and sudo pecl install pdo_sqlsrv. Please follow our online instructions for php 7.4 (see above).

If it works for php 7.4 then you can try 7.3 etc. Whenever you switch php version from one to another, just use update-alternatives again.

[conandrum]

@yitam I just started with the mods you suggested. I started with this:

php -v
PHP 7.4.7 (cli) (built: Jun 12 2020 07:44:05) ( NTS )
Copyright (c) The PHP Group
Zend Engine v3.4.0, Copyright (c) Zend Technologies
with Zend OPcache v7.4.7, Copyright (c), by Zend Technologies

sudo update-alternatives --set php /usr/bin/php7.4
sudo update-alternatives --set phar /usr/bin/phar7.4
sudo update-alternatives --set phar.phar /usr/bin/phar.phar7.4
sudo update-alternatives --set phpize /usr/bin/phpize7.4
sudo update-alternatives --set php-config /usr/bin/php-config7.4
sudo pecl install sqlsrv

This is the weird part.
Towards the end of the output of the last command I see this "20170718":

running: make INSTALL_ROOT="/tmp/pear/temp/pear-build-rootRBWguk/install-sqlsrv-5.8.1" install
Installing shared extensions:     /tmp/pear/temp/pear-build-rootRBWguk/install-sqlsrv-5.8.1/usr/lib/php/20170718/
running: find "/tmp/pear/temp/pear-build-rootRBWguk/install-sqlsrv-5.8.1" | xargs ls -dils
147596   4 drwxr-xr-x 3 root root   4096 Jun 24 06:17 /tmp/pear/temp/pear-build-rootRBWguk/install-sqlsrv-5.8.1
147602   4 drwxr-xr-x 3 root root   4096 Jun 24 06:17 /tmp/pear/temp/pear-build-rootRBWguk/install-sqlsrv-5.8.1/usr
147603   4 drwxr-xr-x 3 root root   4096 Jun 24 06:17 /tmp/pear/temp/pear-build-rootRBWguk/install-sqlsrv-5.8.1/usr/lib
147604   4 drwxr-xr-x 3 root root   4096 Jun 24 06:17 /tmp/pear/temp/pear-build-rootRBWguk/install-sqlsrv-5.8.1/usr/lib/php
147605   4 drwxr-xr-x 2 root root   4096 Jun 24 06:17 /tmp/pear/temp/pear-build-rootRBWguk/install-sqlsrv-5.8.1/usr/lib/php/20170718
 25431 380 -rwxr-xr-x 1 root root 386336 Jun 24 06:17 /tmp/pear/temp/pear-build-rootRBWguk/install-sqlsrv-5.8.1/usr/lib/php/20170718/sqlsrv.so

Build process completed successfully
Installing '/usr/lib/php/20170718/sqlsrv.so'
install ok: channel://pecl.php.net/sqlsrv-5.8.1
configuration option "php_ini" is not set to php.ini location
You should add "extension=sqlsrv.so" to php.ini

Shouldn't it pick up the right folder for php7.4 automatically?
I did not proceed any further until I had spoken with you about it.

[conandrum]

@yitam I did one more test. I run
sudo pecl uninstall sqlsrv
This time, I installed also the
sudo apt-get -y install php7.4-dev
Then again:
sudo pecl install sqlsrv

Success with paths showing 20190902:

Installing shared extensions:     /tmp/pear/temp/pear-build-root6qqGUU/install-sqlsrv-5.8.1/usr/lib/php/20190902/
running: find "/tmp/pear/temp/pear-build-root6qqGUU/install-sqlsrv-5.8.1" | xargs ls -dils
147600   4 drwxr-xr-x 3 root root   4096 Jun 24 06:42 /tmp/pear/temp/pear-build-root6qqGUU/install-sqlsrv-5.8.1
147606   4 drwxr-xr-x 3 root root   4096 Jun 24 06:42 /tmp/pear/temp/pear-build-root6qqGUU/install-sqlsrv-5.8.1/usr
147607   4 drwxr-xr-x 3 root root   4096 Jun 24 06:42 /tmp/pear/temp/pear-build-root6qqGUU/install-sqlsrv-5.8.1/usr/lib
147608   4 drwxr-xr-x 3 root root   4096 Jun 24 06:42 /tmp/pear/temp/pear-build-root6qqGUU/install-sqlsrv-5.8.1/usr/lib/php
147609   4 drwxr-xr-x 2 root root   4096 Jun 24 06:42 /tmp/pear/temp/pear-build-root6qqGUU/install-sqlsrv-5.8.1/usr/lib/php/20190902
 49484 380 -rwxr-xr-x 1 root root 385528 Jun 24 06:42 /tmp/pear/temp/pear-build-root6qqGUU/install-sqlsrv-5.8.1/usr/lib/php/20190902/sqlsrv.so

Build process completed successfully
Installing '/usr/lib/php/20190902/sqlsrv.so'
install ok: channel://pecl.php.net/sqlsrv-5.8.1
configuration option "php_ini" is not set to php.ini location
You should add "extension=sqlsrv.so" to php.ini

I will continue and report back

[conandrum]

@yitam After completing all the steps below specific to 7.4, I can confirm that no errors are being reported when running php -v

sudo apt-get -y install php-pear php7.4-dev

sudo update-alternatives --set php /usr/bin/php7.4
sudo update-alternatives --set phar /usr/bin/phar7.4
sudo update-alternatives --set phar.phar /usr/bin/phar.phar7.4
sudo update-alternatives --set phpize /usr/bin/phpize7.4
sudo update-alternatives --set php-config /usr/bin/php-config7.4

sudo pecl install sqlsrv
sudo pecl install pdo_sqlsrv
sudo su
printf "; priority=20\nextension=sqlsrv.so\n" > /etc/php/7.4/mods-available/sqlsrv.ini
printf "; priority=30\nextension=pdo_sqlsrv.so\n" > /etc/php/7.4/mods-available/pdo_sqlsrv.ini
exit
sudo phpenmod -v 7.4 sqlsrv pdo_sqlsrv
sudo service apache2 restart

[conandrum]

@yitam Then I went on to install the plugins onto 7.3 & 7.2
Problem:
When I switch to other versions and do php -v I get the usual notices as in initial post:

PHP Warning:  PHP Startup: Unable to load dynamic library 'sqlsrv.so' (tried: /usr/lib/php/xxxxxxxx/sqlsrv.so (/usr/lib/php/xxxxxxxx/sqlsrv.so: cannot open shared object file: No such file or directory), /usr/lib/php/xxxxxxxx/sqlsrv.so.so (/usr/lib/php/xxxxxxxx/sqlsrv.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'pdo_sqlsrv.so' (tried: /usr/lib/php/xxxxxxxx/pdo_sqlsrv.so (/usr/lib/php/xxxxxxxx/pdo_sqlsrv.so: cannot open shared object file: No such file or directory), /usr/lib/php/xxxxxxxx/pdo_sqlsrv.so.so (/usr/lib/php/xxxxxxxx/pdo_sqlsrv.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0

If I then just try to install with:
sudo pecl install sqlsrv
I get:

 sudo pecl install sqlsrv
PHP Warning:  PHP Startup: Unable to load dynamic library 'sqlsrv.so' (tried: /usr/lib/php/xxxxxxxx/sqlsrv.so (/usr/lib/php/xxxxxxxx/sqlsrv.so: cannot open shared object file: No such file or directory), /usr/lib/php/xxxxxxxx/sqlsrv.so.so (/usr/lib/php/xxxxxxxx/sqlsrv.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'pdo_sqlsrv.so' (tried: /usr/lib/php/xxxxxxxx/pdo_sqlsrv.so (/usr/lib/php/xxxxxxxx/pdo_sqlsrv.so: cannot open shared object file: No such file or directory), /usr/lib/php/xxxxxxxx/pdo_sqlsrv.so.so (/usr/lib/php/xxxxxxxx/pdo_sqlsrv.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
pecl/sqlsrv is already installed and is the same as the released version 5.8.1
install failed

If I uninstall first using:

sudo pecl uninstall sqlsrv
sudo pecl install sqlsrv

then all goes well, but the previous 7.4 installation is now broken.
Catch 22.

How do I install this on multiple php versions? Do I just manually copy the files from their location to /usr/lib/php/xxxxxxxx ???

[yitam]

@conandrum did you do update-alternatives before installing drivers for 7.3 or 7.2?

Have you read the FAQ entry I sent you earlier on using pecl or php-config? Before you install make sure you're using the right php version. You also need php7.3-dev and php7.2-dev too

[conandrum]

@yitam
did you do update-alternatives before installing drivers for 7.3 or 7.2?
Yes! as seen here: #1145 (comment)

Have you read the FAQ entry I sent you earlier on using pecl or php-config?
Yes!

Before you install make sure you're using the right php version.
Yes. I always do update-alternatives before installing drivers.

You also need php7.3-dev and php7.2-dev too
Yes. I did install those too before installing drivers.

This is the problem:
I install the drivers for 7.4 (for example) and all is OK.
Then I switch version to 7.3 with update-alternatives.
Then I try to install sudo pecl install sqlsrv
I get this:

PHP Warning:  PHP Startup: Unable to load dynamic library 'sqlsrv.so' (tried: /usr/lib/php/xxxxxxxx/sqlsrv.so (/usr/lib/php/xxxxxxxx/sqlsrv.so: cannot open shared object file: No such file or directory), /usr/lib/php/xxxxxxxx/sqlsrv.so.so (/usr/lib/php/xxxxxxxx/sqlsrv.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'pdo_sqlsrv.so' (tried: /usr/lib/php/xxxxxxxx/pdo_sqlsrv.so (/usr/lib/php/xxxxxxxx/pdo_sqlsrv.so: cannot open shared object file: No such file or directory), /usr/lib/php/xxxxxxxx/pdo_sqlsrv.so.so (/usr/lib/php/xxxxxxxx/pdo_sqlsrv.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
pecl/sqlsrv is already installed and is the same as the released version 5.8.1
install failed

The driver does not understand that I need the 7.3 version ON TOP of the 7.4 already installed !!!!!
It's all in my last post #1145 (comment)