[MacPorts] #59014: msodbcsql linked against old openssl and is broken

[MacPorts]

#59014: msodbcsql linked against old openssl and is broken
------------------------+----------------------
  Reporter:  breiter    |      Owner:  roederja
      Type:  defect     |     Status:  assigned
  Priority:  Normal     |  Milestone:
 Component:  ports      |    Version:  2.5.4
Resolution:             |   Keywords:
      Port:  msodbcsql  |
------------------------+----------------------

Comment (by GreggGreen):

 It installs but it's missing the ODBC Driver.


 {{{
         [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 was able to circumvent by using brew installation just for the sqlsrv.so
 extension (overriding macports).

 [https://docs.microsoft.com/en-us/sql/connect/php/installation-tutorial-
 linux-mac?view=sql-server-2017]


 {{{
 added to php.ini
 extension=/usr/local/lib/php/pecl/20180731/sqlsrv.so
 }}}





 {{{
 /usr/bin/ruby -e "$(curl -fsSL
 https://raw.githubusercontent.com/Homebrew/install/master/install)"
 brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-
 mssql-release
 brew update
 brew install msodbcsql17 mssql-tools

 }}}


 So I don't why it doesn't work. I have


 {{{
 msodbcsql @17.4.1.1_0 (active)
 mssql-tools @17.4.1.1_0 (active)
 }}}

 So, it's close to working native with macports.

 PS: Would be cool if Microsoft added macports to their instructions.

-- 
Ticket URL: <https://trac.macports.org/ticket/59014#comment:7>
MacPorts <https://www.macports.org/>
Ports system for macOS