[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:  (none)
     Type:  defect  |     Status:  new
 Priority:  Normal  |  Milestone:
Component:  ports   |    Version:
 Keywords:          |       Port:  mysql8
--------------------+--------------------
 The latest update to 8.0.30[https://github.com/macports/macports-
 ports/commit/67c25ed1f7749637fde72edb42b30accc748778d] has me in an
 endless rev-upgrade loop with the following missing links being the
 culprit:


 {{{
 sudo port -v rev-upgrade
 --->  Scanning binaries for linking errors
 Could not open /opt/local/lib/mysql8/bin/../lib/libcrypto.1.1.dylib: Error
 opening or reading file (referenced from
 /opt/local/lib/mysql8/bin/my_openssl)
 Could not open /opt/local/lib/mysql8/bin/../lib/libssl.1.1.dylib: Error
 opening or reading file (referenced from
 /opt/local/lib/mysql8/bin/my_openssl)
 --->  Found 2 broken files, matching files to ports
 --->  Found 1 broken port, determining rebuild order
 You can always run 'port rev-upgrade' again to fix errors.
 The following ports will be rebuilt: mysql8 @8.0.30
 }}}

 This update not only updated the version, 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.

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