Roundcube Community Forum

News and Announcements => General Discussion => Topic started by: amsm on February 22, 2019, 06:08:57 AM

Title: mysql 8 new authentication plugin
Post by: amsm 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.

Title: Re: mysql 8 new authentication plugin
Post by: JohnDoh 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

Title: Re: mysql 8 new authentication plugin
Post by: amsm 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 (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 (http://docs.php.net/mysql_xdevapi)

Title: Re: mysql 8 new authentication plugin
Post by: Devinney on March 02, 2019, 08:01:09 AM

Quote from: JohnDoh on February 22, 2019, 06:29:53 AM

It looks like payday loans success story (https://www.mysanantonio.com/marketplace/article/best-payday-loans-18283009.php) 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?

Title: Re: mysql 8 new authentication plugin
Post by: JohnDoh 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.