mysql8 @8.4.0_4: ld: symbol(s) not found for architecture x86_64

[BjarneDMat]

$=> system_profiler -detailLevel mini SPHardwareDataType SPSoftwareDataType 
Hardware:
    Hardware Overview:
      Model Name: Mac Pro
      Model Identifier: MacPro5,1
      Hyper-Threading Technology: Enabled
      Boot ROM Version: 9144.0.9.2.0
      SMC Version (system): 1.39f11
Software:
    System Software Overview:
      System Version: macOS 10.15.7 (19H1519)
      Kernel Version: Darwin 19.6.0

:debug:main Starting logging for mysql8 @8.4.0_4
:debug:sysinfo macOS 10.15.7 (darwin/19.6.0) arch i386
:debug:sysinfo MacPorts 2.9.3
:debug:sysinfo Xcode 12.4, CLT 12.4.0.0.1.1610135815
:debug:sysinfo SDK 10.15
:debug:sysinfo MACOSX_DEPLOYMENT_TARGET: 10.15

:info:build [ 22%] Built target ndbportlib
:info:build Undefined symbols for architecture x86_64:
:info:build   "_EVP_CIPHER_get_block_size", referenced from:
:info:build       my_aes_get_size(unsigned int, my_aes_opmode) in libmysys.a(my_aes_openssl.cc.o)
:info:build   "_EVP_CIPHER_get_iv_length", referenced from:
:info:build       my_aes_encrypt(unsigned char const*, unsigned int, unsigned char*, unsigned char const*, unsigned int, my_aes_opmode, unsigned char const*, bool, std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > > >*) in libmysys.a(my_aes_openssl.cc.o)
:info:build       my_aes_decrypt(unsigned char const*, unsigned int, unsigned char*, unsigned char const*, unsigned int, my_aes_opmode, unsigned char const*, bool, std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > > >*) in libmysys.a(my_aes_openssl.cc.o)
:info:build       my_aes_needs_iv(my_aes_opmode) in libmysys.a(my_aes_openssl.cc.o)
:info:build   "_EVP_PKEY_CTX_add1_hkdf_info", referenced from:
:info:build       Key_hkdf_function::derive_key(unsigned char const*, unsigned int, unsigned char*, unsigned int) in libmysys.a(my_kdf.cc.o)
:info:build   "_EVP_PKEY_CTX_set1_hkdf_key", referenced from:
:info:build       Key_hkdf_function::derive_key(unsigned char const*, unsigned int, unsigned char*, unsigned int) in libmysys.a(my_kdf.cc.o)
:info:build   "_EVP_PKEY_CTX_set1_hkdf_salt", referenced from:
:info:build       Key_hkdf_function::derive_key(unsigned char const*, unsigned int, unsigned char*, unsigned int) in libmysys.a(my_kdf.cc.o)
:info:build   "_EVP_PKEY_CTX_set_hkdf_md", referenced from:
:info:build       Key_hkdf_function::derive_key(unsigned char const*, unsigned int, unsigned char*, unsigned int) in libmysys.a(my_kdf.cc.o)
:info:build ld: symbol(s) not found for architecture x86_64

It looks as if the changes jhoyt4 made in ​https://github.com/macports/macports-ports/pull/24615 has introduced some new errors for architecture x86_64.
mysql8 @8.4.0_3 does compile & install and works correctly w/ my PR ​https://github.com/macports/macports-ports/pull/24232
I have de-activated boost178 as described in #70061

[jhoyt4]

Actually, you're trying to build against the update pushed in PR24696 ​https://github.com/macports/macports-ports/pull/24696

That's a newer PR that removes the cmake patches I hacked up and performs the install using the "system" mechanism that mysql8 devs said we should be using (not trying to be pendantic, just trying to help triage which mod).

":debug:main Starting logging for mysql8 @8.4.0_4" tells me that much.

Also 8.4.0_4 should be the version your report in the bug report.

Have you tested against 8.4.1? @herbygillot just pushed an update to that version [c0c4e0b8f9d7466a5ac3198fba11b22adf9f6f08/macports-ports]

I'm not claiming 8.4.1 will solve the problem - just trying to get a better baseline.

Very curious how this got through the CI chain and the builders without erroring on the OS 12 and OS 13 runners which run x86_64.

[jhoyt4]

Just built successfully on:

macOS 14.5 23F79 x86_64
Xcode 15.3 15E204a

No issues

Perhaps this is isolated to Catalina and other "older" OSes?

[jhoyt4]

Have you upgraded openssl3 lately?