Mac M1 SQL Server SQLSrv OpenSSL library could not be loaded, make sure OpenSSL 1.0 or 1.1 is installed
1
vote
0
answers
448
views
I just bought a M1 Mac mini running Big Sur 11.6, I've installed PHP 7.3, msodbcsql17, mssql-tools, sqlsrv and pdo_sqlsrv.
But when I try to connect using sqlsrv, the following error happens [Microsoft][ODBC Driver 17 for SQL Server]SSL Provider: [OpenSSL library could not be loaded, make sure OpenSSL 1.0 or 1.1 is installed]
I've installed openssl@1.1 via brew and my profile contains
export PATH="/opt/homebrew/opt/openssl@1.1/bin:$PATH"
It seems like PHP is using the correct version, when printing echo OPENSSL_VERSION_TEXT, it says OpenSSL 1.1.1l 24 Aug 2021
I'm not sure what else to try, to make it work?
Asked by Jamie B
(11 rep)
Sep 29, 2021, 04:41 PM