MySQL 8.0: Supported?

Wed Jan 16 02:31:40 EET 2019

So, I have upgraded all my ports and that came with mysql-8.0.13.
Now I am unable to build dovecot from the FreeBSD-12 ports:

checking for mysql_config... mysql_config
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
"/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

On Wed, 16 Jan 2019 at 00:56, Larry Rosenman <larryrtx at gmail.com> wrote:

> Thanks, Aki.  I've passed that information along to the FreeBSD port
> maintainer for MySQL.
>
> I'll be back if I need more help or when it's solved.
>
>
>
> On Tue, Jan 15, 2019 at 2:54 PM Aki Tuomi <aki.tuomi at open-xchange.com>
> wrote:
>
>> Apologies for earlier empty email, butterfingers me...
>>
>> anyways, found this in the logs which seems to explain problems:
>>
>>
>> /usr/bin/ld: error: unable to find library -limported_openssl
>> /usr/bin/ld: error: unable to find library -limported_crypto
>> cc: error: linker command failed with exit code 1 (use -v to see invocation)
>>
>> Aki
>>
>> On 15 January 2019 at 22:50 Larry Rosenman < larryrtx at gmail.com> wrote:
>>
>>
>> config.log at:
>> https://www.lerctr.org/~ler/dovecot/config.log
>>
>>
>>
>> On Tue, Jan 15, 2019 at 2:40 PM Aki Tuomi < aki.tuomi at open-xchange.com>
>> wrote:
>>
>> Any way you could check config.log ?
>>
>> Aki
>>
>> On 15 January 2019 at 22:32 Larry Rosenman < larryrtx at gmail.com> wrote:
>>
>> >
>>
>> Not sure what ELSE could be causing this failure. Full build logs are at
>> the home.lerctr.org:8888 link.
>>
>> >
>>
>> On Tue, Jan 15, 2019 at 2:30 PM Aki Tuomi < aki.tuomi at open-xchange.com>
>> wrote:
>>
>> https://dev.mysql.com/doc/refman/8.0/en/mysql-init.html does not support
>> intentional removal of mysql_init
>>
>> Aki
>>
>> On 15 January 2019 at 22:28 Aki Tuomi < aki.tuomi at open-xchange.com>
>> wrote:
>>
>> I tried earlier today using latest version offered in Oracle repos for
>> 8.0, and was able to compile dovecot. I can revisit the issue though.
>>
>> Aki
>>
>> On 15 January 2019 at 22:02 Larry Rosenman < larryrtx at gmail.com> wrote:
>>
>> 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
>>
>> ---
>> Aki Tuomi
>>
>> ---
>> Aki Tuomi
>>
>> >
>> >
>>
>> --
>> 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
>>
>> >
>>
>> ---
>> Aki Tuomi
>>
>>
>>
>> --
>> 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
>>
>>
>> ---
>> Aki Tuomi
>>
>
>
> --
> 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
>

-- 
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/20190116/607c3a41/attachment-0001.html>