[MacPorts] #62086: p5.28-dbd-mysql +mysql8: Error: Failed to configure p5.28-dbd-mysql: configure failure: command execution failed

[MacPorts]

#62086: p5.28-dbd-mysql +mysql8: Error: Failed to configure p5.28-dbd-mysql:
configure failure: command execution failed
---------------------------+--------------------
  Reporter:  jhoyt4        |      Owner:  (none)
      Type:  defect        |     Status:  new
  Priority:  Normal        |  Milestone:
 Component:  ports         |    Version:
Resolution:                |   Keywords:
      Port:  p5-dbd-mysql  |
---------------------------+--------------------

Comment (by ryandesign):

 I wish perl wrote something like a config.log that would tell us ''why''
 it `Can't link/include C library 'mysqlclient'` but I don't think perl
 does that.

 We know that perl remembers the compiler and the flags that were used to
 configure perl and uses that compiler and those flags again when building
 modules, unless told otherwise. The MacPorts perl5 portgroup does tell it
 otherwise, telling it to use the currently-chosen compiler and flags,
 which may be different from the compiler or flags that were chosen when
 perl5.x was built. Specifically, perl5.28 was built on our server with the
 macOS 11.0 SDK, so the
 `-isysroot/Library/Developer/CommandLineTools/SDKs/MacOSX11.0.sdk` flag
 was used and recorded. There are some modules that ignore what we tell
 them and try to build using the old perl-remembered compiler and flags.
 Maybe p5-dbd-myql is one of those. If so, and if you got a binary of
 perl5.28 from our server rather than building it from source, then it
 might by trying to build p5-dbd-mysql using the 11.0 SDK, which exists on
 our build system but does not exist on your system.

 To test this theory, you could try rebuilding perl5.28 from source on your
 system using `sudo port -ns upgrade --force perl5.28`. It will then record
 the fact that it was built with the 11.1 SDK. After that, `sudo port clean
 p5.28-dbd-mysql` and `sudo port install p5.28-dbd-mysql +mysql8` again. If
 that works, great, we can investigate why p5-dbd-mysql is ignoring the
 flags we're sending it.

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