MySQL 8.0: Supported?

Tue Jan 15 23:56:17 EET 2019

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://dovecot.org/pipermail/dovecot/attachments/20190115/6ddf316b/attachment.html>