[MacPorts] #66992: mssql-tools @17.7.1.1: OpenSSL library could not be loaded, make sure OpenSSL 1.0 or 1.1 is installed

[MacPorts]

#66992: mssql-tools @17.7.1.1: OpenSSL library could not be loaded, make sure
OpenSSL 1.0 or 1.1 is installed
--------------------------+----------------------
  Reporter:  zoonman      |      Owner:  roederja
      Type:  defect       |     Status:  assigned
  Priority:  Normal       |  Milestone:
 Component:  ports        |    Version:  2.8.1
Resolution:               |   Keywords:  bigsur
      Port:  mssql-tools  |
--------------------------+----------------------

Comment (by kiwiroy):

 roederja for version 17.7.1.1 the path is hardcoded AFAICT. The
 environment variable only worked for isql and not when using ODBC from my
 program.

 The latest version from Microsoft in the 17 series is 17.10.2.1. From
 opensnoop logging appears to use openssl3, though still searches
 /usr/local/opt/openssl/lib first

 {{{
 2023 Mar 29 10:45:56 695855688  13398 perl          -1
 /usr/local/opt/openssl/lib/libcrypto.3.dylib
 2023 Mar 29 10:45:56 695855688  13398 perl          -1
 /usr/local/opt/openssl/lib
 2023 Mar 29 10:45:56 695855688  13398 perl          -1
 /usr/local/opt/openssl/lib/libcrypto.3.dylib
 2023 Mar 29 10:45:56 695855688  13398 perl          -1
 /usr/local/opt/openssl/lib
 2023 Mar 29 10:45:56 695855688  13398 perl          -1
 /usr/local/opt/openssl/lib/libcrypto.1.0.0.dylib
 2023 Mar 29 10:45:56 695855688  13398 perl          -1
 /usr/local/opt/openssl/lib
 2023 Mar 29 10:45:56 695855688  13398 perl          -1
 /usr/local/opt/openssl/lib/libcrypto.1.0.0.dylib
 2023 Mar 29 10:45:56 695855688  13398 perl          -1
 /usr/local/opt/openssl/lib
 2023 Mar 29 10:45:56 695855688  13398 perl          -1
 /usr/local/opt/openssl/lib/libcrypto.dylib
 2023 Mar 29 10:45:56 695855688  13398 perl          -1
 /usr/local/opt/openssl/lib
 2023 Mar 29 10:45:56 695855688  13398 perl          -1
 /usr/local/opt/openssl/lib/libcrypto.dylib
 2023 Mar 29 10:45:56 695855688  13398 perl          -1
 /usr/local/opt/openssl/lib
 2023 Mar 29 10:45:56 695855688  13398 perl          11
 /opt/local/lib/libcrypto.3.dylib
 2023 Mar 29 10:45:56 695855688  13398 perl          11
 /opt/local/libexec/openssl3/lib/libcrypto.3.dylib
  }}}

 I'll augment that PR.

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