Re: Configure: "Can't build with MySQL support: libmysqlclient not found"

13 Mar 2024

      On 13 Mar 2024, at 12:14 AM, Aki Tuomi aki.tuomi@open-xchange.com wrote:
On 12/03/2024 14:46 EET James L. Brown via dovecot dovecot@dovecot.org wrote:
On 12 Mar 2024, at 10:06 PM, Odhiambo Washington odhiambo@gmail.com wrote:
On Tue, Mar 12, 2024 at 4:20 AM James L. Brown via dovecot mailto:dovecot@dovecot.org> wrote:
Hi all.
I’m getting errors when trying to configure make for version 2.3.21 on macOS
14.3.1 Sonoma.
It ends with:
checking for mysql_config... mysql_config
checking for mysql_init in -lmysqlclient... no
configure: error: Can't build with MySQL support: libmysqlclient not found
I’m using:
env PKG_CONFIG_PATH=/opt/homebrew/lib/pkgconfig pkg-config --libs libsodium
CPPFLAGS=-I/opt/homebrew/Cellar/openssl@3/3.2.1/include LDFLAGS=-L/opt/
homebrew/opt/openssl@3/lib ./configure --with-ssl=openssl --with-mysql --with-
sodium
Looking at config.log I see:
configure:28222: checking for mysql_config
configure:28238: found /opt/homebrew/bin/mysql_config
configure:28250: result: mysql_config
configure:28285: checking for mysql_init in -lmysqlclient
configure:28310: gcc -o conftest -std=gnu99 -g -O2 -fstack-protector-strong -
U_FORTIFY_SOURCE -D_FORTIFY_SOURCE=2 -Wall -W -Wmissing-prototypes -Wmissing-
declarations -Wpointer-arith -Wchar-subscripts -Wformat=2 -Wbad-function-cast -
Wno-duplicate-decl-specifier -Wstrict-aliasing=2 -I/opt/homebrew/Cellar/
openssl@3/3.2.1/include -I/opt/homebrew/Cellar/openssl@3/3.2.1/include -L/opt/
homebrew/opt/openssl@3/lib conftest.c -lmysqlclient   -L/opt/homebrew/Cellar/
mysql/8.3.0_1/lib -lmysqlclient -lz  -lzstd  -lssl  -lcrypto -lresolv -lz -lm
&5
ld: warning: ignoring duplicate libraries: '-lmysqlclient', '-lz'
ld: library 'zstd' not found
clang: error: linker command failed with exit code 1 (use -v to see invocation)
You are missing zstd library.
Aki
Thanks Aki.
zstd 1.5.5 is installed with the other Homebriew-installed stuff at /opt/homebrew/opt/
Not sure why it is not finding zest or libmysqlclient.
I’ve even just added /opt/homebrew/opt to my PATH:
% echo $PATH
/opt/homebrew/opt/openssl@3/bin:/opt/homebrew/sbin:/opt/homebrew/bin:/opt/homebrew/bin:/opt/homebrew/sbin:/usr/local/bin:/System/Cryptexes/App/usr/bin:/usr/bin:/bin:/usr/sbin:/sbin:/var/run/com.apple.security.cryptexd/codex.system/bootstrap/usr/local/bin:/var/run/com.apple.security.cryptexd/codex.system/bootstrap/usr/bin:/var/run/com.apple.security.cryptexd/codex.system/bootstrap/usr/appleinternal/bin:/Library/Apple/usr/bin:/opt/homebrew/opt
James.
 On 13 Mar 2024, at 12:14 AM, Aki Tuomi <aki.tuomi@open-xchange.com>
 wrote:

      On 12/03/2024 14:46 EET James L. Brown via dovecot
      <dovecot@dovecot.org> wrote:

      On 12 Mar 2024, at 10:06 PM, Odhiambo Washington
      <odhiambo@gmail.com> wrote:

      On Tue, Mar 12, 2024 at 4:20 AM James L. Brown via dovecot
      <dovecot@dovecot.org<mailto:dovecot@dovecot.org>> wrote:
      Hi all.

      I’m getting errors when trying to configure make for
      version 2.3.21 on macOS
      14.3.1 Sonoma.

      It ends with:

      checking for mysql_config... mysql_config
      checking for mysql_init in -lmysqlclient... no
      configure: error: Can't build with MySQL support:
      libmysqlclient not found

      I’m using:

      env PKG_CONFIG_PATH=/opt/homebrew/lib/pkgconfig pkg-config
      --libs libsodium

      CPPFLAGS=-I/opt/homebrew/Cellar/openssl@3/3.2.1/include
      LDFLAGS=-L/opt/
      homebrew/opt/openssl@3/lib ./configure --with-ssl=openssl -
      -with-mysql --with-
      sodium

      Looking at config.log I see:

      configure:28222: checking for mysql_config
      configure:28238: found /opt/homebrew/bin/mysql_config
      configure:28250: result: mysql_config
      configure:28285: checking for mysql_init in -lmysqlclient
      configure:28310: gcc -o conftest -std=gnu99 -g -O2 -fstack-
      protector-strong -
      U_FORTIFY_SOURCE -D_FORTIFY_SOURCE=2 -Wall -W -Wmissing-
      prototypes -Wmissing-
      declarations -Wpointer-arith -Wchar-subscripts -Wformat=2 -
      Wbad-function-cast -
      Wno-duplicate-decl-specifier -Wstrict-aliasing=2 -I/opt/
      homebrew/Cellar/
      openssl@3/3.2.1/include -I/opt/homebrew/Cellar/openssl@3/
      3.2.1/include -L/opt/
      homebrew/opt/openssl@3/lib conftest.c -lmysqlclient   -L/
      opt/homebrew/Cellar/
      mysql/8.3.0_1/lib -lmysqlclient -lz  -lzstd  -lssl  -
      lcrypto -lresolv -lz -lm
           &5
      ld: warning: ignoring duplicate libraries: '-lmysqlclient',
      '-lz'
      ld: library 'zstd' not found
      clang: error: linker command failed with exit code 1 (use -
      v to see invocation)

 You are missing zstd library.

 Aki
Thanks Aki.
zstd 1.5.5 is installed with the other Homebriew-installed stuff at /opt/
homebrew/opt/
Not sure why it is not finding zest or libmysqlclient.
I’ve even just added /opt/homebrew/opt to my PATH:
% echo $PATH                         
/opt/homebrew/opt/openssl@3/bin:/opt/homebrew/sbin:/opt/homebrew/bin:/opt/
homebrew/bin:/opt/homebrew/sbin:/usr/local/bin:/System/Cryptexes/App/usr/bin:/
usr/bin:/bin:/usr/sbin:/sbin:/var/run/com.apple.security.cryptexd/codex.system/
bootstrap/usr/local/bin:/var/run/com.apple.security.cryptexd/codex.system/
bootstrap/usr/bin:/var/run/com.apple.security.cryptexd/codex.system/bootstrap/
usr/appleinternal/bin:/Library/Apple/usr/bin:/opt/homebrew/opt
James.