On Thu, 14 Jul 2022 17:01:12 +0200 Paul Gevers <elb...@debian.org> wrote:
Hi,
Hi Paul,
On Thu, 12 May 2022 09:00:49 +0200 Paul Gevers <elb...@debian.org> wrote:
> As Debian has MySQL 8+ for some time now, wouldn't it make sense to
> merge this back into Debian now. Are these changes compatible with
> MariaDB, and if not, what would it take to make them compatible?
I guess the required changes are not compatible with MariaDB? Can you
confirm?
paul@mulciber ~/packages/cacti/cacti $ sudo mysql -e "create user
'bla'@'localhost';"
paul@mulciber ~/packages/cacti/cacti $ sudo mysql -e "alter user
'bla'@'localhost' identified with 'sha256_password';"
ERROR 1396 (HY000) at line 1: Operation ALTER USER failed for
'bla'@'localhost'
Paul
Maria DB does not seem to support 'sha256_password' [1]. Still, MySQL
default seems to use sha2 instead of sha1. It seems that removing the
line changing the auth method would be enough to support both DBs. Would
that be enough for us to merge the changes? If so, I can rebase the
latest Rafael's changes and prepare a MR in salsa.
Sorry for the delay on replying on this one :)
[1] https://mariadb.com/kb/en/authentication-plugin-sha-256/
[2]
https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html#upgrade-caching-sha2-password
--
Athos Ribeiro
