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

12 Mar 2024


      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)
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.