Mailinglist Archive: opensuse-factory (355 mails)

< Previous Next >
Re: [opensuse-factory] 15.2 beta update / mariadb problem
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@xxxxxxxxxxxx
To contact the owner, e-mail: opensuse-factory+owner@xxxxxxxxxxxx

< Previous Next >