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

[James L. Brown via dovecot]

     On 12 Mar 2024, at 10:06 PM, Odhiambo Washington <odhia...@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.

_______________________________________________
dovecot mailing list -- dovecot@dovecot.org
To unsubscribe send an email to dovecot-le...@dovecot.org