[MacPorts] #60642: msodbcsql17: Don't require user to create /usr/local/opt/openssl/lib

[MacPorts]

#60642: msodbcsql17: Don't require user to create /usr/local/opt/openssl/lib
------------------------+-------------------------
 Reporter:  ryandesign  |      Owner:  roederja
     Type:  defect      |     Status:  assigned
 Priority:  Normal      |  Milestone:
Component:  ports       |    Version:
 Keywords:              |       Port:  msodbcsql17
------------------------+-------------------------
 msodbcsql17 now has these notes:

 {{{
 $ port notes msodbcsql17
 msodbcsql17 has the following notes:
   To make this work with SSL you need to create a symbolic link as
 follows:
    sudo mkdir -p /usr/local/opt/openssl/
    sudo ln -s /opt/local/lib /usr/local/opt/openssl/lib

    This is because this port installs binaries meant to be used with
 Homebrew.
 }}}

 It's terrible to make the user do this. Can the binary be fixed to look at
 the MacPorts location? For example, I see the string
 `/usr/local/opt/openssl/lib/` in the library. Would replacing that string
 with ${prefix} (followed by a null byte) allow the library to find the
 MacPorts openssl library without needing the symlink?

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