<!doctype html>
<html>
<head>
<meta charset="UTF-8">
</head>
<body>
<div>
https://dev.mysql.com/doc/refman/8.0/en/mysql-init.html does not support intentional removal of mysql_init
</div>
<div>
<br>
</div>
<div>
Aki
</div>
<blockquote type="cite">
<div>
On 15 January 2019 at 22:28 Aki Tuomi <
<a href="mailto:aki.tuomi@open-xchange.com">aki.tuomi@open-xchange.com</a>> wrote:
</div>
<div>
<br>
</div>
<div>
<br>
</div>
<div>
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.
</div>
<div>
<br>
</div>
<div>
Aki
</div>
<div>
<br>
</div>
<blockquote type="cite">
<div>
On 15 January 2019 at 22:02 Larry Rosenman <
<a href="mailto:larryrtx@gmail.com">larryrtx@gmail.com</a>> wrote:
</div>
<div>
<br>
</div>
<div>
<br>
</div>
<div>
It appears the issue is MySQL 8.0.13 apparently(?) removed the mysql_init
</div>
<div>
symbol.
</div>
<div>
<br>
</div>
<div>
poudriere logs:
</div>
<div>
<a href="http://home.lerctr.org:8888/jail.html?mastername=p120amd64-host-ports" rel="noopener" target="_blank">http://home.lerctr.org:8888/jail.html?mastername=p120amd64-host-ports</a>
</div>
<div>
<br>
</div>
<div>
the first build is 8.0.12, the 2nd is 8.0.13.
</div>
<div>
<br>
</div>
<div>
Can the dovecot guys look as well? I've sent a note to the MySQL
</div>
<div>
maintainer for FreeBSD as well.
</div>
<div>
<br>
</div>
<div>
Thanks.
</div>
<div>
<br>
</div>
<div>
On Tue, Jan 15, 2019 at 1:15 AM Odhiambo Washington <
<a href="mailto:odhiambo@gmail.com">odhiambo@gmail.com</a>>
</div>
<div>
wrote:
</div>
<div>
<br>
</div>
<div>
>
</div>
<div>
>
</div>
<div>
<br>
</div>
<div>
> > On Tue, 15 Jan 2019 at 04:57, Larry Rosenman <
<a href="mailto:larryrtx@gmail.com">larryrtx@gmail.com</a>> wrote:
</div>
<blockquote type="cite">
<div>
> >> I got a complaint from a FreeBSD user that they couldn't compile dovecot
</div>
</blockquote>
<div>
>> against MySQL 8.0.
</div>
<div>
>>
</div>
<div>
>> Is MySQL 8.0 support with 2.3.4?
</div>
<div>
>>
</div>
<div>
>> they receive:
</div>
<div>
>> checking for mysql_init in -lmysqlclient... no
</div>
<div>
>> configure: error: Can't build with MySQL support: libmysqlclient not
</div>
<div>
>> found ===> Script "configure" failed unexpectedly.
</div>
<div>
>> Please report the problem to
<a href="mailto:ler@FreeBSD.org">ler@FreeBSD.org</a> [maintainer] and attach the
</div>
<div>
>> "/wrkdirs/usr/ports/mail/dovecot/work/dovecot-2.3.4/config.log"
</div>
<div>
>> including the output of the failure of your make command. Also, it
</div>
<div>
>> might be a good idea to provide an overview of all packages installed
</div>
<div>
>> on your system (e.g. a /usr/local/sbin/pkg-static info -g -Ea).
</div>
<div>
>> *** Error code 1
</div>
<div>
>>
</div>
<div>
>> thanks!
</div>
<div>
>>
</div>
<div>
>
</div>
<div>
<br>
</div>
<div>
> > I recently installed FreeBSD-12 and installed MySQL-8.0 and build
</div>
<blockquote type="cite">
<div>
dovecot-2.3.4 against it.
</div>
<div>
Well, I tried to do ldd /usr/local/sbin/dovecot to see what it's build
</div>
<div>
against, but it shows different
</div>
<div>
output than what I see when I do the same against my Exim. Maybe it's a
</div>
<div>
gcc vs clang issue, but
</div>
<div>
<br>
</div>
<div>
>
</div>
</blockquote>
<div>
> > root@gw:/usr/home/wash # uname -msrsv
</div>
<blockquote type="cite">
<div>
FreeBSD 12.0-RELEASE FreeBSD 12.0-RELEASE r341666 GENERIC amd64
</div>
<div>
root@gw:/usr/home/wash # mysql --version
</div>
<div>
mysql Ver 8.0.12 for FreeBSD12.0 on amd64 (Source distribution)
</div>
<div>
root@gw:/usr/home/wash # strings /usr/local/sbin/dovecot | grep SQL
</div>
<div>
SQL drivers: mysql postgresql sqlite
</div>
<div>
<br>
</div>
<div>
>
</div>
</blockquote>
<div>
> > In the output you've given, let's just say the issue is that there is
</div>
<blockquote type="cite">
<div>
no libmysqlclient.so.21 in the standard INCLUDE path..
</div>
<div>
<br>
</div>
<div>
>
</div>
</blockquote>
<div>
> > I have just extracted dovecot-2.3.4 into a directory and did:
</div>
<blockquote type="cite">
<div>
./configure --with-mysql=yes
</div>
<div>
<br>
</div>
<div>
>
</div>
</blockquote>
<div>
> > The output is:
</div>
<blockquote type="cite">
<div>
>
</div>
</blockquote>
<div>
> > -----------8<------------
</div>
<blockquote type="cite">
<div>
checking for mysql_config... mysql_config
</div>
<div>
checking for mysql_init in -lmysqlclient... yes
</div>
<div>
checking mysql.h usability... yes
</div>
<div>
checking mysql.h presence... yes
</div>
<div>
checking for mysql.h... yes
</div>
<div>
checking for mysql_ssl_set in -lmysqlclient... yes
</div>
<div>
----------8<--------------
</div>
<div>
Install prefix . : /usr/local
</div>
<div>
File offsets ... : 64bit
</div>
<div>
I/O polling .... : kqueue
</div>
<div>
I/O notifys .... : kqueue
</div>
<div>
SSL ............ : yes (OpenSSL)
</div>
<div>
GSSAPI ......... : no
</div>
<div>
passdbs ........ : static passwd passwd-file pam checkpassword sql
</div>
<div>
CFLAGS ......... : -std=gnu99 -g -O2 -fstack-protector-strong
</div>
<div>
-U_FORTIFY_SOURCE -D_FORTIFY_SOURCE=2 -Wall -W -Wmissing-prototypes
</div>
<div>
-Wmissing-declarations -Wpointer-arith -Wchar-subscripts -Wformat=2
</div>
<div>
-Wbad-function-cast -Wno-duplicate-decl-specifier -Wstrict-aliasing=2
</div>
<div>
: -shadow -bsdauth -sia -ldap -vpopmail
</div>
<div>
userdbs ........ : static prefetch passwd passwd-file checkpassword sql
</div>
<div>
: -ldap -vpopmail
</div>
<div>
*SQL drivers .... : mysql*
</div>
<div>
: -pgsql -sqlite -cassandra
</div>
<div>
Full text search : squat
</div>
<div>
: -lucene -solr
</div>
<div>
<a href="mailto:root@gw:/usr/local/SRC/dovecot-2.3.4">root@gw:/usr/local/SRC/dovecot-2.3.4</a> #
</div>
<div>
<br>
</div>
<div>
> >
</div>
</blockquote>
<div>
> > So, yes, it's supported!
</div>
<blockquote type="cite">
<div>
> >
</div>
</blockquote>
<div>
> > --
</div>
<blockquote type="cite">
<div>
Best regards,
</div>
<div>
Odhiambo WASHINGTON,
</div>
<div>
Nairobi,KE
</div>
<div>
+254 7 3200 0004/+254 7 2274 3223
</div>
<div>
"Oh, the cruft.", grep ^[^#] :-)
</div>
<div>
<br>
</div>
<div>
>
</div>
</blockquote>
<div>
--
</div>
<div>
Larry Rosenman
<a href="http://www.lerctr.org/~ler" rel="noopener" target="_blank">http://www.lerctr.org/~ler</a>
</div>
<div>
Phone: +1 214-642-9640 (c) E-Mail:
<a href="mailto:larryrtx@gmail.com">larryrtx@gmail.com</a>
</div>
<div>
US Mail: 5708 Sabbia Dr, Round Rock, TX 78665-2106
</div>
<div>
<br>
</div>
</blockquote>
<div>
---
</div>
<div>
Aki Tuomi
</div>
</blockquote>
<div>
<br>
</div>
<div class="io-ox-signature">
---
<br>Aki Tuomi
</div>
</body>
</html>