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

[MacPorts]

#59014: msodbcsql linked against old openssl and is broken
---------------------+-----------------------
 Reporter:  breiter  |      Owner:  (none)
     Type:  defect   |     Status:  new
 Priority:  Normal   |  Milestone:
Component:  ports    |    Version:  2.5.4
 Keywords:           |       Port:  msodbcsql
---------------------+-----------------------
 It seems like msqodbsql is linked against openssl 1.0.0 but macports
 installs openssl 1.1.1c at this stage.

 {{{
 Could not open /opt/local/lib/libssl.1.0.0.dylib: Error opening or reading
 file (referenced from /opt/local/lib/libmsodbcsql.17.dylib)
 DEBUG: Marking /opt/local/lib/libmsodbcsql.17.dylib as broken
 Could not open /opt/local/lib/libcrypto.1.0.0.dylib: Error opening or
 reading file (referenced from /opt/local/lib/libmsodbcsql.17.dylib)
 DEBUG: Marking /opt/local/lib/libmsodbcsql.17.dylib as broken
 --->  Found 2 broken files, matching files to ports
 --->  Found 1 broken port, determining rebuild order
 DEBUG: Broken: msodbcsql
 DEBUG: Processing port msodbcsql @0:17.3.1.1_1
 DEBUG: Processing port mssql-tools @0:17.3.1.1_0
 }}}

 {{{
 $ ls /opt/local/lib/libcrypto.1*
 /opt/local/lib/libcrypto.1.1.dylib
 $ ls /opt/local/lib/libssl.1*
 /opt/local/lib/libssl.1.1.dylib
 }}}

 {{{
 $ port installed openssl
 The following ports are currently installed:
   openssl @1.1.1c_0 (active)
 }}}

 I think this patch fixes it:

 {{{
 --- Portfile.bak        2019-09-10 22:49:11.000000000 +0200
 +++ Portfile    2019-09-10 22:53:20.000000000 +0200
 @@ -2,7 +2,7 @@

  name                msodbcsql
  version             17.3.1.1
 -revision            1
 +revision            2
  categories          databases
  platforms           darwin
  supported_archs     x86_64
 @@ -30,8 +30,8 @@

  build {
      system "install_name_tool -change /usr/local/lib/libodbcinst.2.dylib
 ${prefix}/lib/libodbcinst.2.dylib
 ${worksrcpath}/lib/libmsodbcsql.17.dylib"
 -    system "install_name_tool -change
 /usr/local/opt/openssl/lib/libcrypto.1.0.0.dylib
 ${prefix}/lib/libcrypto.1.0.0.dylib
 ${worksrcpath}/lib/libmsodbcsql.17.dylib"
 -    system "install_name_tool -change
 /usr/local/opt/openssl/lib/libssl.1.0.0.dylib
 ${prefix}/lib/libssl.1.0.0.dylib ${worksrcpath}/lib/libmsodbcsql.17.dylib"
 +    system "install_name_tool -change
 /usr/local/opt/openssl/lib/libcrypto.1.0.0.dylib
 ${prefix}/lib/libcrypto.1.1.dylib
 ${worksrcpath}/lib/libmsodbcsql.17.dylib"
 +    system "install_name_tool -change
 /usr/local/opt/openssl/lib/libssl.1.0.0.dylib
 ${prefix}/lib/libssl.1.1.dylib ${worksrcpath}/lib/libmsodbcsql.17.dylib"
  }

  destroot {
 }}}

 Thanks!
 //brian reiter

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