[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 #26 from Jeffery Telford <echoxxzz at gmail.com> ---
(In reply to Torsten Zuehlsdorff from comment #25)

I edited the PHP80 Makefile and changed this:

.if ${PORT_OPTIONS:MMYSQLND}
CONFIGURE_ARGS+=--enable-mysqlnd
.endif

to this (taken from the php80-openssl Makefile):

.if ${PORT_OPTIONS:MMYSQLND}
CONFIGURE_ARGS+=--enable-mysqlnd \
                --with-openssl
CONFIGURE_ENV+= OPENSSL_CFLAGS="-I${OPENSSLINC}" \
                OPENSSL_LIBS="-L${OPENSSLLIB} -lssl -lcrypto"
.endif

And don't enable the OPENSSL extension as I guess it's now statically linked
(due to the --disable-all earlier in the Makefile) or else you'll get this
error message when you do a phpinfo():

'Warning: Module "openssl" is already loaded in Unknown on line 0'

Once I did this when I do a phpinfo() I see two additional plugins under
MYSQLND called auth_plugin_caching_sha2_password and
auth_plugin_sha256_password and I connect to MySQL 8.0 without changing
anything back to mysql_native.

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