Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 24 Feb 2021 11:31:16 +0000
From:      bugzilla-noreply@freebsd.org
To:        ports-bugs@FreeBSD.org
Subject:   [Bug 252420] 'caching_sha2_password' support missing in PHP port, limits MySQL 8 compatibility
Message-ID:  <bug-252420-7788-EQtEtKroCt@https.bugs.freebsd.org/bugzilla/>
In-Reply-To: <bug-252420-7788@https.bugs.freebsd.org/bugzilla/>
References:  <bug-252420-7788@https.bugs.freebsd.org/bugzilla/>

next in thread | previous in thread | raw e-mail | index | archive | help
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D252420

--- Comment #19 from Markus Kohlmeyer <rootservice@gmail.com> ---
OK, possibly we both misunderstood eaachother a bit, sorry for that.


This gives me ldd on my system now:

[root@devgate:~] # ldd /usr/local/bin/php
/usr/local/bin/php:
        libcrypt.so.5 =3D> /lib/libcrypt.so.5 (0x80075b000)
        libargon2.so.0 =3D> /usr/local/lib/libargon2.so.0 (0x80077c000)
        libutil.so.9 =3D> /lib/libutil.so.9 (0x80078a000)
        libm.so.5 =3D> /lib/libm.so.5 (0x8007a2000)
        libthr.so.3 =3D> /lib/libthr.so.3 (0x8007d4000)
        libxml2.so.2 =3D> /usr/local/lib/libxml2.so.2 (0x800801000)
        libc.so.7 =3D> /lib/libc.so.7 (0x80099a000)
        libz.so.6 =3D> /lib/libz.so.6 (0x800d86000)
        liblzma.so.5 =3D> /usr/lib/liblzma.so.5 (0x800da2000)
        libmd.so.6 =3D> /lib/libmd.so.6 (0x800dce000)
[root@devgate:~] # ldd /usr/local/lib/php/20200930-zts/mysqli.so
/usr/local/lib/php/20200930-zts/mysqli.so:
        libmysqlclient.so.21 =3D> /usr/local/lib/mysql/libmysqlclient.so.21
(0x801c00000)
        libz.so.6 =3D> /lib/libz.so.6 (0x8014b2000)
        libzstd.so.1 =3D> /usr/local/lib/libzstd.so.1 (0x8014ce000)
        libm.so.5 =3D> /lib/libm.so.5 (0x8015c4000)
        librt.so.1 =3D> /usr/lib/librt.so.1 (0x8015f6000)
        libexecinfo.so.1 =3D> /usr/lib/libexecinfo.so.1 (0x8022b2000)
        libunwind.so.8 =3D> /usr/local/lib/libunwind.so.8 (0x8022b8000)
        libssl.so.11 =3D> /usr/local/lib/libssl.so.11 (0x8022d2000)
        libcrypto.so.11 =3D> /usr/local/lib/libcrypto.so.11 (0x802368000)
        libthr.so.3 =3D> /lib/libthr.so.3 (0x80265b000)
        libc.so.7 =3D> /lib/libc.so.7 (0x80106f000)
        libc++.so.1 =3D> /usr/lib/libc++.so.1 (0x802688000)
        libcxxrt.so.1 =3D> /lib/libcxxrt.so.1 (0x802756000)
        libgcc_s.so.1 =3D> /lib/libgcc_s.so.1 (0x802778000)
        libelf.so.2 =3D> /lib/libelf.so.2 (0x802792000)
        liblzma.so.5 =3D> /usr/lib/liblzma.so.5 (0x8027ae000)
        libmd.so.6 =3D> /lib/libmd.so.6 (0x8027da000)
[root@devgate:~] # ldd /usr/local/lib/php/20200930-zts/pdo_mysql.so
/usr/local/lib/php/20200930-zts/pdo_mysql.so:
        libmysqlclient.so.21 =3D> /usr/local/lib/mysql/libmysqlclient.so.21
(0x801c00000)
        libz.so.6 =3D> /lib/libz.so.6 (0x801498000)
        libzstd.so.1 =3D> /usr/local/lib/libzstd.so.1 (0x8014b4000)
        libm.so.5 =3D> /lib/libm.so.5 (0x8015aa000)
        librt.so.1 =3D> /usr/lib/librt.so.1 (0x8015dc000)
        libexecinfo.so.1 =3D> /usr/lib/libexecinfo.so.1 (0x8015e5000)
        libunwind.so.8 =3D> /usr/local/lib/libunwind.so.8 (0x8022b2000)
        libssl.so.11 =3D> /usr/local/lib/libssl.so.11 (0x8022cc000)
        libcrypto.so.11 =3D> /usr/local/lib/libcrypto.so.11 (0x802362000)
        libthr.so.3 =3D> /lib/libthr.so.3 (0x802655000)
        libc.so.7 =3D> /lib/libc.so.7 (0x80106f000)
        libc++.so.1 =3D> /usr/lib/libc++.so.1 (0x802682000)
        libcxxrt.so.1 =3D> /lib/libcxxrt.so.1 (0x802750000)
        libgcc_s.so.1 =3D> /lib/libgcc_s.so.1 (0x802772000)
        libelf.so.2 =3D> /lib/libelf.so.2 (0x80278c000)
        liblzma.so.5 =3D> /usr/lib/liblzma.so.5 (0x8027a8000)
        libmd.so.6 =3D> /lib/libmd.so.6 (0x8027d4000)
[root@devgate:~] #


So, if i understand it correct, it means that only the mysqli/pdo_mysql
extensions need the OpenSSL and not lang/php[74|80] itself.

As you said, that would not be problem, so i suggest to add OpenSSL as a
run/build-dependency to only the two extensions, but not php itself.


I'm unsure if that also helps for MYSQLND, that should be tested by someone
else, but for libmysql it works.
Maybe MYSQLND should be switched to non-default by now and libmysql from
databases/mysql[57|80]-client should be another run/build-dependency for the
mysqli/pdo_mysql extensions instead.


HTH

--=20
You are receiving this mail because:
You are the assignee for the bug.=



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-252420-7788-EQtEtKroCt>