Extension seem to be missing in container when using Rosetta on Mac

[gertvdb]

Not quite sure what is causing this, but to make our setup work on apple with M1 chip we needed to enable rosetta else our mssql container (mcr.microsoft.com/mssql/server:2019-latest) did not work.

But now we are getting this error :
SQLSTATE[01000]: [unixODBC][Driver Manager]Can't open lib '/opt/microsoft/msodbcsql17/lib64/libmsodbcsql  -17.6.so.1.1' : file not found

[csandanov]

what's your php image version?

[gertvdb]

wodby/php:8.1-dev-macos
Thanks for looking into this!

[csandanov]

your image without a stability tag, so it gets updated all the time, do you have the latest version?

I'm not sure why it doesn't see the version 18 of the library, we have /opt/microsoft/msodbcsql18/lib64/.... We've recently upgraded the sqlsrv pecl extension, maybe you just need to pull the image to get the latest version

[gertvdb]

it's the latest version, since it was a fresh install on a new laptop.
He's looking for version 'msodbcsql17' it seems somehow

[csandanov]

I've tested the latest php image with mcr.microsoft.com/mssql/server:2022-latest, works fine. Docker macOS 4.16.2

$conn = sqlsrv_connect("sqlsrv", ["Database" => "msdb", "UID"=>"sa", "PWD"=>"my-password", "trustServerCertific
ate" => true]);
var_dump($conn);

resource(4) of type (SQL Server Connection)

[gertvdb]

We are using mcr.microsoft.com/mssql/server:2019-latest so I guess the issue has something to do with the version.
I will check if we can update to the latest version.