Bug 480382

Summary: digiKam not opening to change settings - MySQL access rights missing CREATE table
Product: [Applications] digikam Reporter: Joerg <roaringforties>
Component: Database-MysqlAssignee: Digikam Developers <digikam-bugs-null>
Status: RESOLVED FIXED    
Severity: normal CC: metzpinguin, roaringforties
Priority: NOR    
Version First Reported In: 8.3.0   
Target Milestone: ---   
Platform: Microsoft Windows   
OS: Microsoft Windows   
Latest Commit: https://invent.kde.org/graphics/digikam/-/commit/2e7d2ce9e838eacbd89252ee623956735cf9520f Version Fixed/Implemented In: 8.3.0
Sentry Crash Report:

Description Joerg 2024-01-27 05:06:39 UTC 
SUMMARY
***
I have migrated to MySQL on a MyCloud Ex2 Ultra NAS approx. 1 week ago.
Digikam was running stable for about 1 week on version 8.3.0 (if I remember right).
Problem is, that I get - even before upcoming loading image - a fault message

"You do not have the necessary rights for the database.
You do not have the following rights: CREATE TABLE
Check your rights for the database and restart digiKam."
(Translated from German)

I cannot even enter the setup dialogue in digikam, because it does not start.
Actually a window opened from digiKam, that it is trying to open the database automatically....
***


SOFTWARE/OS VERSIONS
Windows: Windows 11
NAS:  MyCloud Ex2 Ultra, Version Update recently 5.27.161 (might be the root cause)


ADDITIONAL INFORMATION
Comment 1 Maik Qualmann 2024-01-27 07:02:49 UTC 
This is a basic test at the start, an attempt is made to create a test table. If this is not possible, digiKam has no authorization. In fact, there is nothing we can do at this point, you have to use appropriate tools to find out why the database is no longer writable.

Please create a DebugView Log from the start of digiKam, as described here for Windows:

https://www.digikam.org/contribute/

Maik
Comment 2 Maik Qualmann 2024-01-27 07:07:37 UTC 
Another note, there is no problem logging into the database, it was successful. But your database user may no longer have permission for your digiKam database. You have to check this manually, e.g. with HeidiSQL

Maik
Comment 3 Maik Qualmann 2024-01-28 11:04:02 UTC 
Git commit 2e7d2ce9e838eacbd89252ee623956735cf9520f by Maik Qualmann.
Committed on 28/01/2024 at 11:03.
Pushed by mqualmann into branch 'master'.

show database settings page even in case of initialization error
FIXED-IN: 8.3.0

M  +1    -1    NEWS
M  +10   -11   core/libs/album/manager/albummanager_database.cpp

https://invent.kde.org/graphics/digikam/-/commit/2e7d2ce9e838eacbd89252ee623956735cf9520f
Comment 4 Maik Qualmann 2024-01-28 12:12:06 UTC 
Git commit c73ded2e8e5553950074aa137434d8a99ec82c1a by Maik Qualmann.
Committed on 28/01/2024 at 12:10.
Pushed by mqualmann into branch 'master'.

show error message directly in database settings page

M  +12   -8    core/libs/album/manager/albummanager_database.cpp

https://invent.kde.org/graphics/digikam/-/commit/c73ded2e8e5553950074aa137434d8a99ec82c1a