PDO-SQlSRV drivers is not found after update of php 7.4 to 8.1 on Azure App service

Question

PDO-SQlSRV drivers is not found after update of php 7.4 to 8.1 on Azure App service

Mohammad Zaeri Amirani 36

Hi,
After upgrading laravel app from 8 to 9, everything worked ok on local debian server, but when deployed on Azure, could see that there is no more connection to Azure db, and could see further that it is due to missing pdp sqlsrv drivers .They are not installed.
They were in version 8 and therefore everything was OK on Azure also until version 9. to upgrade to Laravel9, was need to change php 7.4 to 8.1 both on our local server and Azure App.

Output from php after update:
root@9dcf7762daa9:/home# php -i | grep sqlsrv
Cannot load Zend OPcache - it was already loaded
root@9dcf7762daa9:/home# odbcinst -j
unixODBC 2.3.7
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES..: /etc/ODBCDataSources
USER DATA SOURCES..: /root/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8
root@9dcf7762daa9:/home# php -v
Cannot load Zend OPcache - it was already loaded
PHP 8.1.6 (cli) (built: Aug 17 2022 07:43:32) (NTS)
Copyright (c) The PHP Group
Zend Engine v4.1.6, Copyright (c) Zend Technologies
with Zend OPcache v8.1.6, Copyright (c), by Zend Technologies
root@9dcf7762daa9:/home#

many thanks in advance

Mohammad Zaeri Amirani 36 Reputation points

2022-10-26T07:47:20.857+00:00

After some researche and googling I come to this page: https://learn.microsoft.com/en-us/answers/questions/1063154/pdo-sqlsrv-drivers-is-not-found-after-update-of-ph.html
PRE_BUILD_COMMAND and POST_BUILD_COMMAND
I think most to Post-build_command (scripts/postbuild.sh) , is it the script, that f.ex. I can put all command that used to install pdp sqlsrv driver on our local server, here too, to install pdo-sqlsrv driver here on Azure App service too?

Answer accepted by question author

0 additional answers

Your answer

Mohammad Zaeri Amirani 36 Reputation points

2022-10-26T07:47:20.857+00:00

After some researche and googling I come to this page: https://learn.microsoft.com/en-us/answers/questions/1063154/pdo-sqlsrv-drivers-is-not-found-after-update-of-ph.html
PRE_BUILD_COMMAND and POST_BUILD_COMMAND
I think most to Post-build_command (scripts/postbuild.sh) , is it the script, that f.ex. I can put all command that used to install pdp sqlsrv driver on our local server, here too, to install pdo-sqlsrv driver here on Azure App service too?

Answer 1

VenkateshDodda-MSFT 25,251 Microsoft Employee Moderator

@Mohammad Zaeri Amirani Thank you for reaching out Apologize for the inconvenience caused on this.

i have deployed web app with php8.1 running on linux operating system. You can run the below cmdlet in the SSH console to check the list of extensions installed by default.

 php -m | grep pdo

Post running the above cmdlet we have observed that pdo_sqlsrv extension is missing and I have shared this feedback to the internal team as well, will post back as soon as I hear from them.

Follow below steps to manually install the pdo_sqlsrv extension in your web app

Add a bin directory to the root directory of your app and put the .so extension files in it
Download the Debian11-8.1.tar file from here extract the .tar file and copy the .so file to the bin folder.
Create a directory in /home/site called ini, then create an .ini file in the /home/site/ini directory (for example, settings.ini) with the directives you want to customize. and add the below line of code into that .ini file. extension=<path_of_the_.sofile>/php_pdo_sqlsrv_81_nts.so
Add the application settings PHP_INI_SCAN_DIR under configuration tab from the portal PHP_INI_SCAN_DIR="/usr/local/etc/php/conf.d:/home/site/ini"
Once the above steps were completed, Stop and start the web app.

You can follow these documentation steps to enable php extension in your linux webapps.

Feel free to reach back to me if you have any further queries on this.

Mohammad Zaeri Amirani 36 Reputation points

2022-10-26T09:27:32.887+00:00

Hi Venkatesh Dodda,
Many thanks for answer, and I followed it and it should work. But just one question.
I need to 2 extensions, one to sqlsrv and one to pdo_sqlsrv.
How should I add them. Both of them in the same settings.ini file
f.ex.:
extension1=/home/site/wwwroot/bin/php_pdo_sqlsrv_81_nts.so
extension2=/home/site/wwwroot/bin/php_sqlsrv_81_nts.so

or maybe:

extension=/home/site/wwwroot/bin/php_sqlsrv_81_nts.so
pdo_extension=/home/site/wwwroot/bin/php_pdo_sqlsrv_81_nts.so

or what?
Many thanks in advance
Mohammad
VenkateshDodda-MSFT 25,251 Reputation points Microsoft Employee Moderator

2022-10-26T10:48:34.933+00:00

@Mohammad Zaeri Amirani Thanks for your response. As mentioned here in this documentation your extension should be added in the below format in .ini file

extension=/home/site/wwwroot/bin/php_sqlsrv_81_nts.so
pdo_extension=/home/site/wwwroot/bin/php_pdo_sqlsrv_81_nts.so
Mohammad Zaeri Amirani 36 Reputation points

2022-10-28T08:32:21.37+00:00

Hi Venkatesh Dodda,
I have tried 2-3 times to write somthing here, but it does not go in someway.
I try again.
Ok this time go.
I tried your suggestion and wrote both extension and pdo_extension in one file (settings.ini), it doesn't work.
But when I wrote just every extension in one file. it works very well.
one file: pdo.ini: pdo_extension=/home/site/wwwroot/bin/php_pdo_sqlsrv_81_nts.so
and another file: sqlsrv.ini : extension=/home/site/wwwroot/bin/php_sqlsrv_81_nts.so
Thanks again
Mohammad
VenkateshDodda-MSFT 25,251 Reputation points Microsoft Employee Moderator

2022-10-28T10:05:07.927+00:00

@Mohammad Zaeri Amirani Thanks for sharing this. Glad to hear that your problem has resolved.
Steven Marshall 6 Reputation points

2022-11-02T18:27:28.003+00:00

The MS SQL server extensions should really be installed by default on Azure linux web apps...!!
This solution worked (thank you!), but not very helpful for an out of the box Azure based solution.
Mohammad Zaeri Amirani 36 Reputation points

2022-11-07T10:08:17.137+00:00

Hi again
I think StevenMarshall-4293 hase right, because even this solution works very well, but as I consider maybe it is therefore that our cronjobs now fails.
As I have wrote in a new case, after update and setup new drivers every yhings began to work very well, except cron jobs, that I can now consider fails. It seems that php couldn't find drivers in cron environment.
tthe new case that I wrote a few hours ago:
https://learn.microsoft.com/en-us/answers/questions/1078069/connection-to-microsoft-sql-fails-after-update-fro-1.html
Best regards
Mohammad
Steven Marshall 6 Reputation points

2022-11-07T10:19:54.317+00:00

I think it's likely this will become a much bigger issue as people start to migrate PHP solutions from Windows Server to Linux following the EOL support for 7.4 coming up and 8.0 not being officially supported under windows. Given we're on Azure, it's likely that a decent amount of people will be using MS SQL server rather than one of the competitor dbs. It should be a pretty easy solution for MS to include these drivers in the image.
VenkateshDodda-MSFT 25,251 Reputation points Microsoft Employee Moderator

2022-11-08T05:29:01.003+00:00

@Steven Marshall I have just tested by deploying php8.1 webapp in eastus & central us regions and i am able to see that pdo_sql_srv is now available instead of manually adding them.
VenkateshDodda-MSFT 25,251 Reputation points Microsoft Employee Moderator

2022-11-08T05:39:47.937+00:00

@Mohammad Zaeri Amirani I have just tested by deploying php8.1 webapp in eastus & central us regions and i am able to see that pdo_sql_srv and sqlsrv is now available instead of manually adding them.
Steven Marshall 6 Reputation points

2022-11-08T17:23:15.28+00:00

Just confirmed that this is working on UK South as well and all good. Thank you for the prompt response on this... Hopefully it will help out a lot of people who need to migrate.
Mohammad Zaeri Amirani 36 Reputation points

2022-11-09T12:10:40.213+00:00

Hi
Apologize me for this late reply, because out of office.
Yes I can confirm too that now we don’t need to extension. Sqlsrv and pdo_sqlsrv are installed after new deploy. Very good.
I go now after my cron jobs issue.
Best regards
Mohammad

atta khan 0

User's image

i have the thatt pdo_sqlsrv but i m still facing this error,

e": "SQLSTATE[28000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user 'atta'. (Connection: sqlsrv, SQL: select count(*) as aggregate from [users] where [email] = ******@gmailc.om)",
    "exception": "Illuminate\\Database\\QueryException",
    "file": "/home/site/wwwroot/vendor/laravel/framework/src/Illuminate/Database/Connection.php"

Share via

PDO-SQlSRV drivers is not found after update of php 7.4 to 8.1 on Azure App service

0 additional answers

Your answer