Am 20.03.20 um 00:09 schrieb Simon Lees:
On 3/17/20 8:52 PM, Stefan Seyfried wrote:
Am 16.03.20 um 14:44 schrieb Stefan Seyfried:
Am 16.03.20 um 14:05 schrieb Stefan Seyfried:
Am 16.03.20 um 13:56 schrieb Cristian Rodríguez:
JFTR, this is https://bugzilla.opensuse.org/show_bug.cgi?id=1166781
bugzilla (or the microfocus login site) is semui-down, so let's report here.
I could reproduce this, by restoring the 15.1 filesystem into a VM and running the 15.2 update again.
opensuse-test:~ # mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
So I have a test system available in broken state ready for examination :-)
I have database backups, yeah, but I 'll prefer not to restore them and fix the authentication issue instead.
I am very far from an expert in this area but from what I was reading the other day I believe that the change here is security related which is to follow upstream in no longer allowing the root user access to databases. I believe there are plans to include a post install message with this information but we should also make sure the change is well documented in the release notes. I hope this helps.
Look in the "resolved, it's a feature not a bug" bugzilla 1166781. It's a known regression in mariadb-upgrade when upgrading databases with a long history. https://jira.mariadb.org/browse/MDEV-21244 I also found a workaround that fixes the issue for me, not sure if that works for everyone, but my databse is upgraded now and still running. I still think it is pretty cynical to: a) get an message after update telling me that I should now back up /var/lib/mysql before restarting mariadb. b) having mariadb restarted automatically nevertheless (and the database is already broken now) => remove tat %service_del_postun from the spec file! c) the most impressive thing is, that this is considered a feature, not a bug I have resolved it for me now, but just out of interest, I'll check how debian handles this issue once they offer a stable distribution that had mariadb-10.4. -- Stefan Seyfried "For a successful technology, reality must take precedence over public relations, for nature cannot be fooled." -- Richard Feynman -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-factory+owner@opensuse.org