[Bug 252420] 'caching_sha2_password' support missing in PHP port, limits MySQL 8 compatibility

[bugzilla-noreply at freebsd.org]

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=252420

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


This gives me ldd on my system now:

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

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