An exception occurred in the driver: SQLSTATE[08001]: [Microsoft][ODBC Driver 18 for SQL Server]SSL
Am using macOs and using docker to run microsoft sql server the connection with the server is well established but when am trying to run migration i get errors
php vendor/bin/doctrine-migrations migrations:migrate
In ExceptionConverter.php line 67:
An exception occurred in the driver: SQLSTATE[08001]: [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: [error:80000002:system library::No such file or directory:calling stat(/usr/local/
etc/openssl@3/certs)][error:80000002:system library::No such file or directory:calling stat(/usr/local/etc/openssl@3/certs)]
In Exception.php line 28:
SQLSTATE[08001]: [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: [error:80000002:system library::No such file or directory:calling stat(/usr/local/etc/openssl@3/certs)][error:80000002:
system library::No such file or directory:calling stat(/usr/local/etc/openssl@3/certs)]
In Driver.php line 47:
SQLSTATE[08001]: [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: [error:80000002:system library::No such file or directory:calling stat(/usr/local/etc/openssl@3/certs)][error:80000002:
system library::No such file or directory:calling stat(/usr/local/etc/openssl@3/certs)]
migrations:migrate [--write-sql [WRITE-SQL]] [--dry-run] [--query-time] [--allow-no-migration] [--all-or-nothing [ALL-OR-NOTHING]] [--configuration CONFIGURATION] [--em EM] [--conn CONN] [--db-configuration DB-CONFIGURATION] [--] [<version>]๐ซ
5 Replies
first things I'm noticing is that there's newlines here:
and that (on second reading, there is a
/usr/local/etc/openssl@3/certs is a bit of a weird path./usr/local/etc as well as /etc) Are you missing a starting / from the path to /etc/openssl@3/certs maybe?
either way, you should check if that path exists (either the /usr/local/etc or /etc one, whichever is the correct one)I have checked it doesnot exist and still i cannot fix the issue
if it does not exist, then that is the issue. It's expecting a folder of certificates in that location, so you either need to put that there or point it where they do live
I'm not familiar enough with the setup you're using to tell you how, though if you're using a premade container it probably has documentation that'll walk you through that
Okay thanks, am using docker to run mssql server
Still can't find the possible solution on mssql server documentation and everywhere
why are you trying to use mssql in macos?
also, your mssql server is probably misconfigured and the certificates weren't created at some step
by the way, why are you even trying to use ssl to communicate with something that will probably use a loopback or a file socket?