Author Topic: mysql 8 new authentication plugin  (Read 4030 times)

Offline amsm

  • Newbie
  • *
  • Posts: 2
mysql 8 new authentication plugin
« on: February 22, 2019, 06:08:57 AM »
hi,
does Roundcube currently support new default authentication plugin "caching_sha2_password" in mysql 8.0 ?
if not, is this support planned in future version ?
Adam.

Offline JohnDoh

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 2,845
Re: mysql 8 new authentication plugin
« Reply #1 on: February 22, 2019, 06:29:53 AM »
It looks like there is no support for this in PHP yet. See https://bugs.php.net/bug.php?id=76243
Roundcube Plugins: Contextmenu, SpamAssassin Prefs, and more…

Offline amsm

  • Newbie
  • *
  • Posts: 2
Re: mysql 8 new authentication plugin
« Reply #2 on: February 22, 2019, 04:02:02 PM »
mysql 8 documentation says that:
Quote
PHP: the X DevAPI PHP extension (mysql_xdevapi) supports caching_sha2_password.
(https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html#upgrade-caching-sha2-password)

It seems that this php extension Mysql_xdevapi works pretty well.
http://docs.php.net/mysql_xdevapi

Offline Devinney

  • Newbie
  • *
  • Posts: 1
Re: mysql 8 new authentication plugin
« Reply #3 on: March 02, 2019, 08:01:09 AM »
It looks like payday loans success story and there is no support for this in PHP yet. See https://bugs.php.net/bug.php?id=76243

Are you expecting much more support and info in the future, John?
« Last Edit: September 13, 2023, 08:33:35 AM by Devinney »

Offline JohnDoh

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 2,845
Re: mysql 8 new authentication plugin
« Reply #4 on: March 03, 2019, 04:52:27 AM »
I found that PHP bug report with a quick search I don't know any more than that. For it to work in Roundcube I think support would need to be added into PDO.
Roundcube Plugins: Contextmenu, SpamAssassin Prefs, and more…