I got a complaint from a FreeBSD user that they couldn't compile dovecot against MySQL 8.0. Is MySQL 8.0 support with 2.3.4? they receive: checking for mysql_init in -lmysqlclient... no configure: error: Can't build with MySQL support: libmysqlclient not found ===> Script "configure" failed unexpectedly. Please report the problem to ler at FreeBSD.org [maintainer] and attach the "/wrkdirs/usr/ports/mail/dovecot/work/dovecot-2.3.4/config.log" including the output of the failure of your make command. Also, it might be a good idea to provide an overview of all packages installed on your system (e.g. a /usr/local/sbin/pkg-static info -g -Ea). *** Error code 1 thanks! -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 214-642-9640 (c) E-Mail: larryrtx at gmail.com US Mail: 5708 Sabbia Dr, Round Rock, TX 78665-2106 -------------- next part -------------- An HTML attachment was scrubbed... URL: <https://dovecot.org/pipermail/dovecot/attachments/20190114/ebfed122/attachment.html>
On Tue, 15 Jan 2019 at 04:57, Larry Rosenman <larryrtx at gmail.com> wrote:> I got a complaint from a FreeBSD user that they couldn't compile dovecot > against MySQL 8.0. > > Is MySQL 8.0 support with 2.3.4? > > they receive: > checking for mysql_init in -lmysqlclient... no > configure: error: Can't build with MySQL support: libmysqlclient not > found ===> Script "configure" failed unexpectedly. > Please report the problem to ler at FreeBSD.org [maintainer] and attach the > "/wrkdirs/usr/ports/mail/dovecot/work/dovecot-2.3.4/config.log" > including the output of the failure of your make command. Also, it > might be a good idea to provide an overview of all packages installed > on your system (e.g. a /usr/local/sbin/pkg-static info -g -Ea). > *** Error code 1 > > thanks! >I recently installed FreeBSD-12 and installed MySQL-8.0 and build dovecot-2.3.4 against it. Well, I tried to do ldd /usr/local/sbin/dovecot to see what it's build against, but it shows different output than what I see when I do the same against my Exim. Maybe it's a gcc vs clang issue, but root at gw:/usr/home/wash # uname -msrsv FreeBSD 12.0-RELEASE FreeBSD 12.0-RELEASE r341666 GENERIC amd64 root at gw:/usr/home/wash # mysql --version mysql Ver 8.0.12 for FreeBSD12.0 on amd64 (Source distribution) root at gw:/usr/home/wash # strings /usr/local/sbin/dovecot | grep SQL SQL drivers: mysql postgresql sqlite In the output you've given, let's just say the issue is that there is no libmysqlclient.so.21 in the standard INCLUDE path.. I have just extracted dovecot-2.3.4 into a directory and did: ./configure --with-mysql=yes The output is: -----------8<------------ checking for mysql_config... mysql_config checking for mysql_init in -lmysqlclient... yes checking mysql.h usability... yes checking mysql.h presence... yes checking for mysql.h... yes checking for mysql_ssl_set in -lmysqlclient... yes ----------8<-------------- Install prefix . : /usr/local File offsets ... : 64bit I/O polling .... : kqueue I/O notifys .... : kqueue SSL ............ : yes (OpenSSL) GSSAPI ......... : no passdbs ........ : static passwd passwd-file pam checkpassword sql CFLAGS ......... : -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 : -shadow -bsdauth -sia -ldap -vpopmail userdbs ........ : static prefetch passwd passwd-file checkpassword sql : -ldap -vpopmail *SQL drivers .... : mysql* : -pgsql -sqlite -cassandra Full text search : squat : -lucene -solr root at gw:/usr/local/SRC/dovecot-2.3.4 # So, yes, it's supported! -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft.", grep ^[^#] :-) -------------- next part -------------- An HTML attachment was scrubbed... URL: <https://dovecot.org/pipermail/dovecot/attachments/20190115/5a5540c2/attachment.html>
It appears the issue is MySQL 8.0.13 apparently(?) removed the mysql_init symbol. poudriere logs: http://home.lerctr.org:8888/jail.html?mastername=p120amd64-host-ports the first build is 8.0.12, the 2nd is 8.0.13. Can the dovecot guys look as well? I've sent a note to the MySQL maintainer for FreeBSD as well. Thanks. On Tue, Jan 15, 2019 at 1:15 AM Odhiambo Washington <odhiambo at gmail.com> wrote:> > > On Tue, 15 Jan 2019 at 04:57, Larry Rosenman <larryrtx at gmail.com> wrote: > >> I got a complaint from a FreeBSD user that they couldn't compile dovecot >> against MySQL 8.0. >> >> Is MySQL 8.0 support with 2.3.4? >> >> they receive: >> checking for mysql_init in -lmysqlclient... no >> configure: error: Can't build with MySQL support: libmysqlclient not >> found ===> Script "configure" failed unexpectedly. >> Please report the problem to ler at FreeBSD.org [maintainer] and attach the >> "/wrkdirs/usr/ports/mail/dovecot/work/dovecot-2.3.4/config.log" >> including the output of the failure of your make command. Also, it >> might be a good idea to provide an overview of all packages installed >> on your system (e.g. a /usr/local/sbin/pkg-static info -g -Ea). >> *** Error code 1 >> >> thanks! >> > > I recently installed FreeBSD-12 and installed MySQL-8.0 and build > dovecot-2.3.4 against it. > Well, I tried to do ldd /usr/local/sbin/dovecot to see what it's build > against, but it shows different > output than what I see when I do the same against my Exim. Maybe it's a > gcc vs clang issue, but > > root at gw:/usr/home/wash # uname -msrsv > FreeBSD 12.0-RELEASE FreeBSD 12.0-RELEASE r341666 GENERIC amd64 > root at gw:/usr/home/wash # mysql --version > mysql Ver 8.0.12 for FreeBSD12.0 on amd64 (Source distribution) > root at gw:/usr/home/wash # strings /usr/local/sbin/dovecot | grep SQL > SQL drivers: mysql postgresql sqlite > > In the output you've given, let's just say the issue is that there is > no libmysqlclient.so.21 in the standard INCLUDE path.. > > I have just extracted dovecot-2.3.4 into a directory and did: > ./configure --with-mysql=yes > > The output is: > > -----------8<------------ > checking for mysql_config... mysql_config > checking for mysql_init in -lmysqlclient... yes > checking mysql.h usability... yes > checking mysql.h presence... yes > checking for mysql.h... yes > checking for mysql_ssl_set in -lmysqlclient... yes > ----------8<-------------- > Install prefix . : /usr/local > File offsets ... : 64bit > I/O polling .... : kqueue > I/O notifys .... : kqueue > SSL ............ : yes (OpenSSL) > GSSAPI ......... : no > passdbs ........ : static passwd passwd-file pam checkpassword sql > CFLAGS ......... : -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 > : -shadow -bsdauth -sia -ldap -vpopmail > userdbs ........ : static prefetch passwd passwd-file checkpassword sql > : -ldap -vpopmail > *SQL drivers .... : mysql* > : -pgsql -sqlite -cassandra > Full text search : squat > : -lucene -solr > root at gw:/usr/local/SRC/dovecot-2.3.4 # > > > So, yes, it's supported! > > > -- > Best regards, > Odhiambo WASHINGTON, > Nairobi,KE > +254 7 3200 0004/+254 7 2274 3223 > "Oh, the cruft.", grep ^[^#] :-) >-- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 214-642-9640 (c) E-Mail: larryrtx at gmail.com US Mail: 5708 Sabbia Dr, Round Rock, TX 78665-2106 -------------- next part -------------- An HTML attachment was scrubbed... URL: <https://dovecot.org/pipermail/dovecot/attachments/20190115/7c5f17d4/attachment.html>