Mailinglist Archive: opensuse-factory (355 mails)

< Previous Next >
Re: [opensuse-factory] 15.2 beta update / mariadb problem


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:

Ditto, I still have a server with hosed mysql authentication..
happended in tumblweed too.. unfortunately I have not been able to
completely shut it down for a few hours to do a full restore.. so it
is running with skip-grant-tables and no networking whatsoever.
apparently the mysql authentication tables ends with no users in, not
even root..

OK, I'll open a bug to get this started.

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.

--

Simon Lees (Simotek) http://simotek.net

Emergency Update Team keybase.io/simotek
SUSE Linux Adelaide Australia, UTC+10:30
GPG Fingerprint: 5B87 DB9D 88DC F606 E489 CEC5 0922 C246 02F0 014B

< Previous Next >
Follow Ups