[MacPorts] #65579: mysql8 - latest update to 8.0.30 broke openssl links

[MacPorts]

#65579: mysql8 - latest update to 8.0.30 broke openssl links
---------------------+-------------------------
  Reporter:  jhoyt4  |      Owner:  herbygillot
      Type:  defect  |     Status:  closed
  Priority:  Normal  |  Milestone:
 Component:  ports   |    Version:
Resolution:  fixed   |   Keywords:
      Port:  mysql8  |
---------------------+-------------------------

Comment (by herbygillot):

 > ... but also snuck in an edit to "databases/mysql8/files/patch-cmake-
 ssl-include.diff" which I believe removes the generation of the openssl
 paths.

 No one here is trying to "sneak" anything in.

 The lines removed from the SSL patch in the commit you're referencing
 (https://github.com/macports/macports-
 ports/commit/67c25ed1f7749637fde72edb42b30accc748778d) were removed
 because they are no longer valid or necessary.  The upstream 8.0.30 source
 already contains a fix for the issue those lines were intended to address,
 so they were cleaned up.

 The fix for this turns out to be preventing MySQL from building its own
 custom version of OpenSSL, which includes the tool `my_openssl`, and which
 is also building those broken libraries
 (`/opt/local/lib/mysql8/bin/../lib/libcrypto.1.1.dylib`,
 `/opt/local/lib/mysql8/bin/../lib/libssl.1.1.dylib`). Doing this forces it
 to correctly use MacPorts OpenSSL.

 As part of this fix, I also removed reference to the Trac ticket that the
 deleted lines were addressing.  This is just further cleanup that I missed
 prior.

 This fix is now available in ports, so you can update your ports tree and
 try upgrading `mysql8` once again to verify whether it works or not before
 slinging further allegations.

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