[Pkg-cacti-maint] Bug#933683: [Bug 1972833] Re: Merge cacti from Debian unstable for kinetic

[Athos Ribeiro]

On Thu, 14 Jul 2022 17:01:12 +0200 Paul Gevers <elbrus at debian.org> wrote:
> Hi,

Hi Paul,

> 
> On Thu, 12 May 2022 09:00:49 +0200 Paul Gevers <elbrus at 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 at mulciber ~/packages/cacti/cacti $ sudo mysql -e "create user 
> 'bla'@'localhost';"
> paul at 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