[SOLVED] How To Connect PHP7.3, sql server & Nginx Debian10

Issue

Please help me....

I've created a web server using OS Debian 10, Nginx and PHP7.3 and everything is running well. but when it will connect to the sql server, it cannot connect.

I've done several tutorials such as:

1. pecl install sqlsrv pdo_sqlsrv

2. Follow steps mentioned on https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver15

3. File .ini driver root@debian:~# ls /etc/php/7.3/fpm/conf.d/*sqlsrv.ini /etc/php/7.3/fpm/conf.d/20-sqlsrv.ini /etc/php/7.3/fpm/conf.d/30-pdo_sqlsrv.ini root@debian:~#

4. my php info:

5. my script and result in browser like :

so please help me to solve this problem, Thank you Very Much

Solution

If you are having issues with the client on Debian 10 with OpenSSL1.1.1 the fix is to revert to the previously default weaker key length. To do so:

Modify

/etc/ssl/openssl.cnf 

config file as follows

Change the last line from

CipherString = DEFAULT@SECLEVEL=2 

to

CipherString = DEFAULT@SECLEVEL=1

(fyi see known issues with OpenSSL 1.1.1 in Debian 10 below):

https://github.com/microsoft/msphpsql/issues/1021

https://wiki.debian.org/ContinuousIntegration/TriagingTips/openssl-1.1.1

Answered By - emadelbieh

Answer Checked By - Terry (WPSolving Volunteer)