Bug#933683: [Bug 1972833] Re: Merge cacti from Debian unstable for kinetic
On Sun, Nov 27, 2022 at 07:47:15AM +0100, Paul Gevers wrote: Hi, On 27-11-2022 00:46, Athos Ribeiro wrote: 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? I haven't checked recently, but I guess yes. If so, I can rebase the latest Rafael's changes and prepare a MR in salsa. I think it would be good for the Debian/Ubuntu ecosystem to reduce the diff between the two, so I'd be in favor of being in sync. I filed a MR here: https://salsa.debian.org/cacti-team/cacti/-/merge_requests/3 It just removes the sha2 changes, making it compatible with both DBs. I believe this should be enough to keep the packages in sync. Paul -- Athos Ribeiro
Bug#933683: [Bug 1972833] Re: Merge cacti from Debian unstable for kinetic
Hi, On 27-11-2022 00:46, Athos Ribeiro wrote: 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? I haven't checked recently, but I guess yes. If so, I can rebase the latest Rafael's changes and prepare a MR in salsa. I think it would be good for the Debian/Ubuntu ecosystem to reduce the diff between the two, so I'd be in favor of being in sync. Paul OpenPGP_signature Description: OpenPGP digital signature
Bug#933683: [Bug 1972833] Re: Merge cacti from Debian unstable for kinetic
On Thu, 14 Jul 2022 17:01:12 +0200 Paul Gevers wrote: Hi, Hi Paul, On Thu, 12 May 2022 09:00:49 +0200 Paul Gevers 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
Bug#933683: [Bug 1972833] Re: Merge cacti from Debian unstable for kinetic
Hi, On Thu, 12 May 2022 09:00:49 +0200 Paul Gevers 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 OpenPGP_signature Description: OpenPGP digital signature
Bug#933683: [Bug 1972833] Re: Merge cacti from Debian unstable for kinetic
Hi Athos, Rafael, On 12-05-2022 06:16, Launchpad Bug Tracker wrote: This bug was fixed in the package cacti - 1.2.20+ds1-2ubuntu1 --- cacti (1.2.20+ds1-2ubuntu1) kinetic; urgency=medium * Merge with Debian unstable (LP: #1972833). Remaining changes: - General installing instructions update for NO_AUTO_CREATE_USER. - Use new dbconfig "dbc_authplugin" variable to mitigate MySQL 8 issues. -- Athos Ribeiro Tue, 10 May 2022 10:03:33 -0300 ** Changed in: cacti (Ubuntu) Status: In Progress => Fix Released 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? Paul OpenPGP_signature Description: OpenPGP digital signature