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

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.

 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.