msodbcsql17: Don't require user to create /usr/local/opt/openssl/lib

[ryandesign (Ryan Carsten Schmidt)]

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?

[ryandesign (Ryan Carsten Schmidt)]

Replying to ryandesign:

replacing that string with ${prefix}

Or more precisely ${prefix}/lib/ or rather what that expands to. And as a sanity check we would need to confirm first that the length of the new string is not greater than the length of the old string.

[roederja]

Already discussed here: #60560