Bug #77013 [NEW]: MySQLnd: auth_plugin_caching_sha2_password is missing again

From: Date: Mon, 15 Oct 2018 14:16:28 +0000
Subject: Bug #77013 [NEW]: MySQLnd: auth_plugin_caching_sha2_password is missing again
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-217569@lists.php.net to get a copy of this message
From:             ademybiz at gmail dot com
Operating system: CentOS7(Dockerized)
PHP version:      7.2.11
Package:          MySQL related
Bug Type:         Bug
Bug description:MySQLnd: auth_plugin_caching_sha2_password is missing again

Description:
------------
I maintain my own docker image and recently update for 7.2.9 to 11 then
it fails to connect a MySQL8 server.

Found difference of loaded plugins of MySQLnd, see below,
"auth_plugin_caching_sha2_password" is missing.

Test script:
---------------
./configure --prefix=/usr --with-config-file-path=/usr/etc
--with-mysqli=mysqlnd --with-pdo-mysql=mysqlnd
--with-iconv-dir=/usr/local --with-freetype-dir --with-jpeg-dir
--with-png-dir --with-zlib --with-libxml-dir=/usr --enable-xml
--disable-rpath --enable-bcmath --enable-shmop --enable-sysvsem
--enable-sysvshm --enable-inline-optimization --with-curl=/usr
--enable-mbregex --enable-fpm --enable-mbstring --with-gd --with-openssl
--enable-pcntl --enable-sockets --with-xmlrpc --with-libzip
--enable-soap --with-bz2 --with-gmp --with-gettext --with-readline
--enable-sockets --enable-calendar --enable-opcache --with-sodium
(...build it)
php -i|grep "Loaded plugins"

Expected result:
----------------
Loaded plugins =>
mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password,auth_plugin_caching_sha2_password,auth_plugin_sha256_password

Actual result:
--------------
Loaded plugins =>
mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password,auth_plugin_sha256_password

-- 
Edit bug report at https://bugs.php.net/bug.php?id=77013&edit=1
-- 
Try a snapshot (PHP 5.4):   https://bugs.php.net/fix.php?id=77013&r=trysnapshot54
Try a snapshot (PHP 5.5):   https://bugs.php.net/fix.php?id=77013&r=trysnapshot55
Try a snapshot (trunk):     https://bugs.php.net/fix.php?id=77013&r=trysnapshottrunk
Fixed in SVN:               https://bugs.php.net/fix.php?id=77013&r=fixed
Fixed in release:           https://bugs.php.net/fix.php?id=77013&r=alreadyfixed
Need backtrace:             https://bugs.php.net/fix.php?id=77013&r=needtrace
Need Reproduce Script:      https://bugs.php.net/fix.php?id=77013&r=needscript
Try newer version:          https://bugs.php.net/fix.php?id=77013&r=oldversion
Not developer issue:        https://bugs.php.net/fix.php?id=77013&r=support
Expected behavior:          https://bugs.php.net/fix.php?id=77013&r=notwrong
Not enough info:            https://bugs.php.net/fix.php?id=77013&r=notenoughinfo
Submitted twice:            https://bugs.php.net/fix.php?id=77013&r=submittedtwice
register_globals:           https://bugs.php.net/fix.php?id=77013&r=globals
PHP 4 support discontinued: https://bugs.php.net/fix.php?id=77013&r=php4
Daylight Savings:           https://bugs.php.net/fix.php?id=77013&r=dst
IIS Stability:              https://bugs.php.net/fix.php?id=77013&r=isapi
Install GNU Sed:            https://bugs.php.net/fix.php?id=77013&r=gnused
Floating point limitations: https://bugs.php.net/fix.php?id=77013&r=float
No Zend Extensions:         https://bugs.php.net/fix.php?id=77013&r=nozend
MySQL Configuration Error:  https://bugs.php.net/fix.php?id=77013&r=mysqlcfg



Thread (4 messages)

« previous php.bugs (#217569) next »