mysql56: Cannot find appropriate system libraries for WITH_SSL

[dbl001 (dbl)]

I get this error installing mysql56 on Monterery and Catalina.

Run Build Command(s):/usr/bin/make -f Makefile cmTC_82a8e/fast && /Library/Developer/CommandLineTools/usr/bin/make  -f CMakeFiles/cmTC_82a8e.dir/build.make CMakeFiles/cmTC_82a8e.dir/build
Building C object CMakeFiles/cmTC_82a8e.dir/HAVE_NUMAIF_H.c.o
/usr/bin/clang -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -D_LARGE_FILES -D__STDC_CONSTANT_MACROS -D__STDC_FORMAT_MACROS -D__STDC_LIMIT_MACROS  -pipe -Os -isysroot/Library/Developer/CommandLineTools/SDKs/MacOSX12.sdk  -arch x86_64 -isysroot /Library/Developer/CommandLineTools/SDKs/MacOSX12.sdk -mmacosx-version-min=12.0 -MD -MT CMakeFiles/cmTC_82a8e.dir/HAVE_NUMAIF_H.c.o -MF CMakeFiles/cmTC_82a8e.dir/HAVE_NUMAIF_H.c.o.d -o CMakeFiles/cmTC_82a8e.dir/HAVE_NUMAIF_H.c.o -c /opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_macports_release_tarballs_ports_databases_mysql56/mysql56/work/build/CMakeFiles/CheckIncludeFiles/HAVE_NUMAIF_H.c
/opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_macports_release_tarballs_ports_databases_mysql56/mysql56/work/build/CMakeFiles/CheckIncludeFiles/HAVE_NUMAIF_H.c:2:10: fatal error: 'numaif.h' file not found
#include <numaif.h>
         ^~~~~~~~~~
1 error generated.
make[1]: *** [CMakeFiles/cmTC_82a8e.dir/HAVE_NUMAIF_H.c.o] Error 1

[ryandesign (Ryan Carsten Schmidt)]

While we should fix this, do you really need mysql56? It is ancient. Try mysql8 instead.

[dbl001 (dbl)]

mysql8 build successfully on OS X Monterey 12.1 beta but failed on OS X Catalina. On Catalina it had the error: numaif.h file not found.

[chrstphrchvz (Christopher Chavez)]

MySQL ports have previously built successfully without finding numaif.h, so I don’t think that is an issue here (even though it is the last thing mentioned in CMakeError.log). The fatal error in main.log is:

:info:configure Cannot find appropriate system libraries for WITH_SSL=/opt/local.
:info:configure Make sure you have specified a supported SSL version.
:info:configure Valid options are :
:info:configure system (use the OS openssl library),
:info:configure yes (synonym for system),
:info:configure </path/to/custom/openssl/installation>
:info:configure CMake Error at cmake/ssl.cmake:66 (MESSAGE):
:info:configure   Please install the appropriate openssl developer package.
:info:configure Call Stack (most recent call first):
:info:configure   cmake/ssl.cmake:260 (FATAL_SSL_NOT_FOUND_ERROR)
:info:configure   CMakeLists.txt:483 (MYSQL_CHECK_SSL)
:info:configure -- Configuring incomplete, errors occurred!

[chrstphrchvz (Christopher Chavez)]

Note that openssl and openssl3 have been updated to openssl @3_1 and openssl3 @3.0.0_5 since the reporter attempted their build:

:debug:main openssl 3_0 exists in the ports tree
:debug:main openssl 3_0  is the latest installed
:debug:main openssl 3_0  is active
…
:debug:main No need to upgrade! openssl 3_0 >= openssl 3_0
:debug:main epoch: in tree: 0 installed: 0
:debug:main openssl3 3.0.0_2 exists in the ports tree
:debug:main openssl3 3.0.0_2 +universal is the latest installed
:debug:main openssl3 3.0.0_2 +universal is active
…
:debug:main No need to upgrade! openssl3 3.0.0_2 >= openssl3 3.0.0_2
:debug:main epoch: in tree: 0 installed: 0

[chrstphrchvz (Christopher Chavez)]

Possibly fixed by mysql56 @5.6.51_2 in [f6e61fe512/macports-ports]

[chrstphrchvz (Christopher Chavez)]

mysql56 @5.6.51_4 reportedly builds fine on 10.15. Can this ticket be closed?

[dbl001 (dbl)]

$ sudo port install mysql56
Portfile changed since last build; discarding previous state.
--->  Computing dependencies for mysql56
--->  Fetching archive for mysql56
--->  Attempting to fetch mysql56-5.6.51_4.darwin_19.x86_64.tbz2 from https://packages.macports.org/mysql56
--->  Attempting to fetch mysql56-5.6.51_4.darwin_19.x86_64.tbz2.rmd160 from https://packages.macports.org/mysql56
--->  Installing mysql56 @5.6.51_4
The mysql56 client has been installed.
To install the mysql56 server, install the mysql56-server port.
--->  Activating mysql56 @5.6.51_4
--->  Cleaning mysql56
--->  Scanning binaries for linking errors
--->  No broken files found.                             
--->  No broken ports found.
--->  Some of the ports you installed have notes:
  mysql56 has the following notes:
    This port is deprecated since the project is no longer maintained
    upstream. It is likely to be removed from MacPorts at some point in the
    future. If you find this port useful and would like to see it continue,
    please consider posting to the macports-users mailing list. See
    https://trac.macports.org/wiki/MailingLists for more details.

    On activation if no /opt/local/etc/mysql56/my.cnf file exists one
    will be created which loads
    /opt/local/etc/mysql56/macports-default.cnf.
    
    If a /opt/local/etc/mysql56/my.cnf file exists MacPorts does not
    touch it and any changes you make to /opt/local/etc/mysql56/my.cnf
    will be preserved (e.g., during port upgrades, deactivations or
    activations). /opt/local/etc/mysql56/my.cnf is a good place to
    customize your mysql56 installation.
    
    Any changes made to /opt/local/etc/mysql56/macports-default.cnf
    will be lost during port upgrades, deactivations or activations so you
    are advised to not make changes here. Currently
    /opt/local/etc/mysql56/macports-default.cnf contains only one
    directive; to disable networking. With disabled networking it is
    possible to install and have running all the MacPorts mysql ports
    simultaneously.