[MacPorts] #69359: p5-dbd-mysql: Most MariaDB variants build with wrong MariaDB versions

[MacPorts]

#69359: p5-dbd-mysql: Most MariaDB variants build with wrong MariaDB versions
-----------------------------+--------------------
  Reporter:  joostdekeijzer  |      Owner:  jhoyt4
      Type:  defect          |     Status:  closed
  Priority:  Normal          |  Milestone:
 Component:  ports           |    Version:
Resolution:  fixed           |   Keywords:
      Port:  p5-dbd-mysql    |
-----------------------------+--------------------

Comment (by joostdekeijzer):

 Maybe MariaDB versions > 10.5 just aren't supported by the DBD::mysql
 code?

 When I run `port install -vvv p5.34-dbd-mysql +mariadb10_6` the build
 fails with:

 {{{
 DBD::mysql requires MySQL 8.x for building. Version reported by
 /opt/local/lib/mariadb-10.6/bin/mysql_config --version: 10.6.11 at
 Makefile.PL line 451, <PIPE> line 3.
 Command failed:  cd
 "/opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_macports_release_tarballs_ports_perl_p5
 -dbd-mysql/p5.34-dbd-mysql/work/DBD-mysql-5.003" &&
 /opt/local/bin/perl5.34 Makefile.PL INSTALLDIRS=vendor CC="/usr/bin/clang"
 LD="/usr/bin/clang"
 --mysql_config=/opt/local/lib/mariadb-10.6/bin/mysql_config
 Exit code: 255
 Error: Failed to configure p5.34-dbd-mysql: configure failure: command
 execution failed
 Error: See
 /opt/local/var/macports/logs/_opt_local_var_macports_sources_rsync.macports.org_macports_release_tarballs_ports_perl_p5
 -dbd-mysql/p5.34-dbd-mysql/main.log for details.
 Error: Follow https://guide.macports.org/#project.tickets if you believe
 there is a bug.
 Error: Processing of port p5.34-dbd-mysql failed
 }}}

 In DBD::mysql Makefile.PL line 451 there is a check forcing MySQL 8.x.
 When I disable that line (no version check at all) and try to build I get
 many compile errors :(

 {{{
 dbdimp.c:1244:31: error: use of undeclared identifier
 'MYSQL_OPT_COMPRESSION_ALGORITHMS'
           mysql_options(sock, MYSQL_OPT_COMPRESSION_ALGORITHMS, calg);
                               ^
 dbdimp.c:1415:31: error: use of undeclared identifier
 'MYSQL_OPT_GET_SERVER_PUBLIC_KEY'; did you mean 'MYSQL_SERVER_PUBLIC_KEY'?
           mysql_options(sock, MYSQL_OPT_GET_SERVER_PUBLIC_KEY,
 &server_get_pubkey);

 <snip>

 dbdimp.c:1479:22: error: use of undeclared identifier 'SSL_MODE_PREFERRED'
           ssl_mode = SSL_MODE_PREFERRED;
                      ^
 dbdimp.c:1481:19: error: use of undeclared identifier
 'SSL_MODE_VERIFY_IDENTITY'
               ssl_mode = SSL_MODE_VERIFY_IDENTITY;
                          ^
 dbdimp.c:1483:19: error: use of undeclared identifier 'SSL_MODE_VERIFY_CA'
               ssl_mode = SSL_MODE_VERIFY_CA;
                          ^
 dbdimp.c:1485:19: error: use of undeclared identifier 'SSL_MODE_REQUIRED'
               ssl_mode = SSL_MODE_REQUIRED;
                          ^
 dbdimp.c:1486:30: error: use of undeclared identifier 'MYSQL_OPT_SSL_MODE'
             if (mysql_options(sock, MYSQL_OPT_SSL_MODE, &ssl_mode) != 0) {
                                     ^
 dbdimp.c:1495:30: error: use of undeclared identifier 'SSL_MODE_DISABLED'
             unsigned int ssl_mode = SSL_MODE_DISABLED;
                                     ^
 dbdimp.c:1496:26: error: use of undeclared identifier 'MYSQL_OPT_SSL_MODE'
             mysql_options(sock, MYSQL_OPT_SSL_MODE, &ssl_mode);

 }}}

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