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
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