Bug 330168

Summary: MYSQL : allow read only database
Product: [Applications] digikam Reporter: Kusi <kusi>
Component: Database-MultiusersAssignee: Digikam Developers <digikam-bugs-null>
Status: RESOLVED FIXED    
Severity: wishlist CC: caulier.gilles
Priority: NOR    
Version First Reported In: 3.5.0   
Target Milestone: ---   
Platform: openSUSE   
OS: Linux   
Latest Commit: https://invent.kde.org/kde/digikam/commit/314dda12f798baf64a139ddcf875a8e843fdbbe6 Version Fixed/Implemented In: 6.4.0
Sentry Crash Report:

Description Kusi 2014-01-19 18:44:21 UTC 
Please allow accessing the digikam schema (mysql) with a user who only has "select" privileges.

Whenever you start digikam, it errors with the following message: 

"You have insufficient privileges on the database. Following privileges are not assigned to you: ALTER TABLE Check your privileges on the database and restart digiKam."

The same error message appears with "CREATE TABLE"

The previously entered collection is gone. Once re-entered in the settings, everything works fine. You see all the tags, but cannot modify the tags. You restart digikam and the error message pops up and the collection is gone, again





Reproducible: Always

Steps to Reproduce:
1. create a mysql user with SELECT privileges only
2. use digikam in mysql-mode with previously generated read only user
3. 
Actual Results:  
collection in settings disappeared

Expected Results:  
1) When starting with a read-only mysql-user, maybe a warning or indication that digikam db is in read only mode.
2) don't kill my collection from settings every time I launch digikam
Comment 1 Maik Qualmann 2019-09-16 20:49:58 UTC 
Git commit 314dda12f798baf64a139ddcf875a8e843fdbbe6 by Maik Qualmann.
Committed on 16/09/2019 at 20:48.
Pushed by mqualmann into branch 'master'.

cleanup the table for the rights check at startup
FIXED-IN: 6.4.0

M  +2    -1    NEWS
M  +11   -7    core/libs/database/coredb/coredbchecker.cpp

https://invent.kde.org/kde/digikam/commit/314dda12f798baf64a139ddcf875a8e843fdbbe6