[MacPorts] #66992: mssql-tools 17.7 has broken link to openssl

[MacPorts]

#66992: mssql-tools 17.7 has broken link to openssl
---------------------------------+-------------------------
 Reporter:  zoonman              |      Owner:  (none)
     Type:  defect               |     Status:  new
 Priority:  Normal               |  Milestone:
Component:  ports                |    Version:  2.8.1
 Keywords:  mssql, odbc, bigsur  |       Port:  mssql-tools
---------------------------------+-------------------------
 Hi guys, the port seems to be installed correctly but it doesn't work.

 Initially I started with python odbc but I ended up with isql as python
 issues is a mere reflection of a real problem under the hood:

 {{{
 isql -v -k 'DRIVER={ODBC Driver 17 for SQL
 Server};SERVER=127.0.0.1,1433;trusted_connection=no;UID=sa;PWD=password'

 [08001][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]
 [08001][Microsoft][ODBC Driver 17 for SQL Server]Client unable to
 establish connection
 [ISQL]ERROR: Could not SQLDriverConnect
 }}}

 It seems like it depends on openssl but it is not marked as directly
 relevant.

 Versions:

 - macports @ 2.8.1
 - msodbcsql17 @ 17.7.1.1_1
 - mssql-tools @ 17.7.1.1_0
 - unixODBC @ 2.3.9_0

 I tired installing openssl but it didn't address the issue. It seems like
 it is inside msodbcsql17 but I cannot speak for sure. I need help here.


 Maybe this will help:
 {{{
 port installed openssl*

 The following ports are currently installed:
   openssl @3_9 (active)
   openssl3 @3.0.8_1+legacy (active)
   openssl10 @1.0.2u_4 (active)
   openssl11 @1.1.1t_0 (active)
 }}}

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