https://bugs.kde.org/show_bug.cgi?id=451153

--- Comment #4 from bugskde...@goland.org ---
(In reply to Maik Qualmann from comment #3)
> If the database rights check reports an error, you do not have the
> appropriate rights. The tables would be automatically deleted at the next
> start if the rights were correct. Nothing must and should not be deleted by
> hand here. There is no password in the internal MySQL database, it is empty.
> What are Ubuntu packages? Does it mean you are using digiKam's snap package?
> Snap uses a sandbox and these packages from Ubuntu are useless to use
> digiKam. Download our AppImage and give it a try.
> 
> Maik

I'm using AppImage (digiKam-7.6.0-x86-64) with MariaDB. When I set up MariaDB
digiKam asked me to set up a password and I saved that password. When I look in
~/.config/digitkamrc inside the Database Settings section it has a Database
Encrypted Password value set.

When I was looking around I found a mysql.err file that contains entries from
today. Apparently MariaDB crashed. It said to look at:
https://mariadb.com/kb/en/library/innodb-recovery-modes/.

I got innodb_force_recovery=1 in /etc/my.cnf and restarted MariaDB with
systemctl restart mariadb. But this doesn't seem to have fixed anything. I even
tried 2 and that didn't work.

So at this point I've given up hope. I'm going to try to restore a backup but I
suspect I'll have to tear everything down and start over again.

The real question I care about is - what happened to cause the corruption in
the first place? I have never touched any of the DBs directly. I just use
digiKam.

-- 
You are receiving this mail because:
You are watching all bug changes.

Reply via email to