driver not loading in Mamp pro and can run PHP 8.1.13 or PHP 8.2.

[Ravenna]

PHP version 8.1 or 8.2
PHP SQLSRV or PDO_SQLSRV version Not sure
Microsoft ODBC Driver version 18
SQL Server version 17
Client operating system OSX Ventura 13.2

Table schema

Problem description
Running my mac m1 on the latest osx. I have Mamp pro and can run PHP 8.1.13 or PHP 8.2.

I followed this: https://learn.microsoft.com/en-us/answers/questions/705302/sql-server-on-mamp?orderby=oldest but replaced everything with my PHP version and odbc v18.

Everything appears to be installed but I have a few issues:

1. Nothing is added to php.ini with the extension
2. If I try sudo pecl install sqlsrv
   Password: MYPW
   PHP Warning: Module "sqlsrv" is already loaded in Unknown on line 0

Warning: Module "sqlsrv" is already loaded in Unknown on line 0
PHP Warning: Module "pdo_sqlsrv" is already loaded in Unknown on line 0

Warning: Module "pdo_sqlsrv" is already loaded in Unknown on line 0
PHP Warning: Module "pdo_sqlsrv" is already loaded in Unknown on line 0

Warning: Module "pdo_sqlsrv" is already loaded in Unknown on line 0
pecl/sqlsrv is already installed and is the same as the released version 5.10.1
install failed

--

Been looking through Google, Git, stack. Any ideas?

Expected behavior and actual behavior

Repro code or steps to reproduce

[andremartinez]

Some recent issues mentioned a problem with unixodbc (or so it seems)

The comment here (#1436 (comment)) suggests installing the version 2.3.7 of unixodbc (and some other dependencies) is a workaround for the problem

See if that helps

[Ravenna]

Thanks @andremartinez. I am on OSX and can't seem it install unixodbc version 2.3.7. Gonna keep digging.