Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 24 Mar 2021 23:06:23 +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-bqj5d4oopz@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 #26 from Jeffery Telford <echoxxzz@gmail.com> ---
(In reply to Torsten Zuehlsdorff from comment #25)

I edited the PHP80 Makefile and changed this:

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

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

.if ${PORT_OPTIONS:MMYSQLND}
CONFIGURE_ARGS+=3D--enable-mysqlnd \
                --with-openssl
CONFIGURE_ENV+=3D OPENSSL_CFLAGS=3D"-I${OPENSSLINC}" \
                OPENSSL_LIBS=3D"-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.

--=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-bqj5d4oopz>