<div dir="ltr">It appears the issue is MySQL 8.0.13 apparently(?) removed the mysql_init symbol.<div><br></div><div><span style="color:rgb(51,51,51);font-family:monospace;font-size:12px;white-space:nowrap">poudriere logs:</span><br style="color:rgb(51,51,51);font-family:monospace;font-size:12px"><span style="color:rgb(51,51,51);font-family:monospace;font-size:12px;white-space:nowrap"><a rel="noreferrer" target="_blank" href="http://home.lerctr.org:8888/jail.html?mastername=p120amd64-host-ports" style="color:rgb(1,134,186)">http://home.lerctr.org:8888/jail.html?mastername=p120amd64-host-ports</a></span><br style="color:rgb(51,51,51);font-family:monospace;font-size:12px"><br style="color:rgb(51,51,51);font-family:monospace;font-size:12px"><span style="color:rgb(51,51,51);font-family:monospace;font-size:12px;white-space:nowrap">the first build is 8.0.12, the 2nd is 8.0.13.</span><br></div><div><span style="color:rgb(51,51,51);font-family:monospace;font-size:12px;white-space:nowrap"><br></span></div><div><span style="color:rgb(51,51,51);font-family:monospace;font-size:12px;white-space:nowrap">Can the dovecot guys look as well? I've sent a note to the MySQL maintainer for FreeBSD as well.</span></div><div><span style="color:rgb(51,51,51);font-family:monospace;font-size:12px;white-space:nowrap"><br></span></div><div><font color="#333333" face="monospace"><span style="font-size:12px;white-space:nowrap">Thanks.</span></font></div></div><br><div class="gmail_quote"><div dir="ltr">On Tue, Jan 15, 2019 at 1:15 AM Odhiambo Washington <<a href="mailto:odhiambo@gmail.com">odhiambo@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr">On Tue, 15 Jan 2019 at 04:57, Larry Rosenman <<a href="mailto:larryrtx@gmail.com" target="_blank">larryrtx@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">I got a complaint from a FreeBSD user that they couldn't compile dovecot against MySQL 8.0.<div><br></div><div>Is MySQL 8.0 support with 2.3.4?</div><div><br></div><div>they receive: </div><div><span style="color:rgb(51,51,51);font-family:monospace;font-size:12px">checking for mysql_init in -lmysqlclient... no</span><br style="color:rgb(51,51,51);font-family:monospace;font-size:12px"><span style="color:rgb(51,51,51);font-family:monospace;font-size:12px">configure: error: Can't build with MySQL support: libmysqlclient not</span><br style="color:rgb(51,51,51);font-family:monospace;font-size:12px"><span style="color:rgb(51,51,51);font-family:monospace;font-size:12px"> found ===> Script "configure" failed unexpectedly.</span><br style="color:rgb(51,51,51);font-family:monospace;font-size:12px"><span style="color:rgb(51,51,51);font-family:monospace;font-size:12px">Please report the problem to </span><a href="mailto:ler@FreeBSD.org" style="color:rgb(1,134,186);font-family:monospace;font-size:12px" target="_blank">ler@FreeBSD.org</a><span style="color:rgb(51,51,51);font-family:monospace;font-size:12px"> [maintainer] and attach the</span><br style="color:rgb(51,51,51);font-family:monospace;font-size:12px"><span style="color:rgb(51,51,51);font-family:monospace;font-size:12px">"/wrkdirs/usr/ports/mail/dovecot/work/dovecot-2.3.4/config.log"</span><br style="color:rgb(51,51,51);font-family:monospace;font-size:12px"><span style="color:rgb(51,51,51);font-family:monospace;font-size:12px"> including the output of the failure of your make command. Also, it</span><br style="color:rgb(51,51,51);font-family:monospace;font-size:12px"><span style="color:rgb(51,51,51);font-family:monospace;font-size:12px"> might be a good idea to provide an overview of all packages installed</span><br style="color:rgb(51,51,51);font-family:monospace;font-size:12px"><span style="color:rgb(51,51,51);font-family:monospace;font-size:12px"> on your system (e.g. a /usr/local/sbin/pkg-static info -g -Ea).</span><br style="color:rgb(51,51,51);font-family:monospace;font-size:12px"><span style="color:rgb(51,51,51);font-family:monospace;font-size:12px">*** Error code 1</span></div><div><font color="#333333" face="monospace"><span style="font-size:12px"><br></span></font></div><div><font color="#333333" face="monospace"><span style="font-size:12px">thanks!</span></font></div></div></blockquote><div><br></div><div>I recently installed FreeBSD-12 and installed MySQL-8.0 and build dovecot-2.3.4 against it.</div><div>Well, I tried to do ldd /usr/local/sbin/dovecot to see what it's build against, but it shows different</div><div>output than what I see when I do the same against my Exim. Maybe it's a gcc vs clang issue, but</div><div><br></div><div><div><div>root@gw:/usr/home/wash # uname -msrsv</div><div>FreeBSD 12.0-RELEASE FreeBSD 12.0-RELEASE r341666 GENERIC amd64</div></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><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>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..</div><div><br></div><div>I have just extracted dovecot-2.3.4 into a directory and did:</div><div> ./configure --with-mysql=yes<br></div><div><br></div><div>The output is:</div><div><br></div><div>-----------8<------------</div><div><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><div>----------8<--------------</div></div><div dir="ltr">Install prefix . : /usr/local</div><div dir="ltr">File offsets ... : 64bit</div><div dir="ltr">I/O polling .... : kqueue</div><div dir="ltr">I/O notifys .... : kqueue</div><div dir="ltr">SSL ............ : yes (OpenSSL)</div><div dir="ltr">GSSAPI ......... : no</div><div dir="ltr">passdbs ........ : static passwd passwd-file pam checkpassword sql</div><div dir="ltr">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</div><div dir="ltr"> : -shadow -bsdauth -sia -ldap -vpopmail</div><div dir="ltr">userdbs ........ : static prefetch passwd passwd-file checkpassword sql</div><div dir="ltr"> : -ldap -vpopmail</div><div dir="ltr"><b>SQL drivers .... : mysql</b></div><div dir="ltr"> : -pgsql -sqlite -cassandra</div><div dir="ltr">Full text search : squat</div><div dir="ltr"> : -lucene -solr</div><div dir="ltr">root@gw:/usr/local/SRC/dovecot-2.3.4 #</div><div dir="ltr"><br></div><div dir="ltr"><br></div><div>So, yes, it's supported!</div><div><br></div><div><br></div>-- <br><div dir="ltr" class="gmail-m_6644231720588308160gmail_signature"><div dir="ltr"><div><div dir="ltr"><div>Best regards,<br>Odhiambo WASHINGTON,<br>Nairobi,KE<br>+254 7 3200 0004/+254 7 2274 3223<br>"<span style="font-size:12.8px">Oh, the cruft.</span><span style="font-size:12.8px">", </span><span style="font-size:12.8px">grep ^[^#] :-)</span></div></div></div></div></div></div></div></div></div></div></div></div></div>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr">Larry Rosenman <a href="http://www.lerctr.org/~ler" target="_blank">http://www.lerctr.org/~ler</a><br><span>Phone: <span title="Call with Google Voice"><span title="Call with Google Voice"><span title="Call with Google Voice">+1 214-642-9640</span></span></span> (c) E-Mail: </span><a href="mailto:larryrtx@gmail.com" target="_blank">larryrtx@gmail.com</a><br>US Mail: 5708 Sabbia Dr, Round Rock, TX 78665-2106</div></div></div></div></div></div></div></div>