Req #75645 [Com]: The server requested authentication method unknown to the client [dialog]
Edit report at https://bugs.php.net/bug.php?id=75645&edit=1
ID: 75645
Comment by: geoff dot montee at gmail dot com
Reported by: michal at cihar dot com
Summary: The server requested authentication method unknown
to the client [dialog]
Status: Open
Type: Feature/Change Request
Package: MySQLi related
Operating System: any
PHP Version: 7.2.0
Block user comment: N
Private report: N
New Comment:
According to the code linked by cmb@php.net, PHP's mysqlnd supports the mysql_clear_password
client authentication plugin for PAM (which can be used by both MySQL Server and MariaDB Server),
but it probably does not currently support the dialog client authentication plugin for PAM (which
can only be used by MariaDB Server).
Users should be able to work around this issue by configuring the pam_use_cleartext_plugin system
variable on MariaDB Server to force it to use mysql_clear_password instead of dialog.
I would like to link to a documentation page that describes the problem and solution in more detail,
but PHP's bug tracker appears to prohibit links.
Previous Comments:
------------------------------------------------------------------------
[2021-04-06 21:42:01] cmb@php.net
Hmm, there is a PAM authentification plugin in mysqlnd[1] for
years â I wonder if it's just broken.
[1] <https://github.com/php/php-src/blob/php-7.4.16/ext/mysqlnd/mysqlnd_auth.c#L666>
------------------------------------------------------------------------
[2019-04-02 20:56:51] buphmin at gmail dot com
Thank kstan! I got your gist working in a docker container after a few modifications. I would still
prefer mysqlnd supporting PAM auth though.
------------------------------------------------------------------------
[2019-02-10 17:03:11] kstan at simitgroup dot com
I'm manage to recompile the using mariadb client in ubuntu. the gist as this link
https://gist.github.com/kstan79/028df3e715cac2b4d63e0b003b1233c7
------------------------------------------------------------------------
[2018-10-27 01:57:23] buphmin at gmail dot com
I have also been able to reproduce this using mysqlnd with PDO and mysqli on php versions 7.0, 7.1,
7.2. I have not yet got around to recompiling PHP to use libmysqlclient to see if that also fails.
------------------------------------------------------------------------
[2018-02-06 12:48:15] kstan at simitgroup dot com
Yes, wish mysqli support PAM authentication. I'm wish to use pam_krb.so
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
https://bugs.php.net/bug.php?id=75645
--
Edit this bug report at https://bugs.php.net/bug.php?id=75645&edit=1
Thread (7 messages)