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) configure:28310: $? =1

Odd that it is using the old version mysql.

Would someone be able to help me get it to find libmysqlclient?

In /opt/homebrew/Cellar/mysql/8.0.32/lib/ I have:

libmysqlclient.21.dylib libmysqlclient.a libmysqlclient.dylib

Thanks,

James.

Maybe https://github.com/PyMySQL/mysqlclient/issues/496#issuecomment-1614688099

-- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 In an Internet failure case, the #1 suspect is a constant: DNS. "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-) [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html]

Thanks Odhiambo, that looked promising.

I used:

export MYSQLCLIENT_LDFLAGS="-L/opt/homebrew/opt/mysql/lib -lmysqlclient -rpath /opt/homebrew/opt/mysql/lib"

Before the env and CPPFLAGS lines.

But I still get:

checking for mysql_init in -lmysqlclient... no

configure: error: Can't build with MySQL support: libmysqlclient not found

And config.log still has in the ‘Output variables’ section:

MYSQL_CONFIG='mysql_config' MYSQL_LIBS='-L/opt/homebrew/Cellar/mysql/8.3.0_1/lib -lmysqlclient -lz -lzstd -lssl -lcrypto -lresolv'

I’m sure it’s something like what you suggested.

Thanks, James.

 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> 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)
      configure:28310: $? =1


      Odd that it is using the old version mysql.

      Would someone be able to help me get it to find
      libmysqlclient?

      In /opt/homebrew/Cellar/mysql/8.0.32/lib/ I have:

      libmysqlclient.21.dylib
      libmysqlclient.a
      libmysqlclient.dylib

      Thanks,

      James.


 Maybe https://github.com/PyMySQL/mysqlclient/issues/496#issuecomment-
 1614688099
  
 --
 Best regards,
 Odhiambo WASHINGTON,
 Nairobi,KE
 +254 7 3200 0004/+254 7 2274 3223
  In an Internet failure case, the #1 suspect is a constant: DNS.
 "Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
 [How to ask smart questions: http://www.catb.org/~esr/faqs/smart-
 questions.html]

Thanks Odhiambo, that looked promising.

I used:

export MYSQLCLIENT_LDFLAGS="-L/opt/homebrew/opt/mysql/lib -lmysqlclient -rpath /opt/homebrew/opt/mysql/lib" 

Before the env and CPPFLAGS lines.

But I still get:

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

And config.log still has in the ‘Output variables’ section:

MYSQL_CONFIG='mysql_config' MYSQL_LIBS='-L/opt/homebrew/Cellar/mysql/8.3.0_1/lib -lmysqlclient -lz  -lzstd -lssl  -lcrypto -lresolv'

I’m sure it’s something like what you suggested.

Thanks, 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.

 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.