https://bugs.kde.org/show_bug.cgi?id=330168
Bug ID: 330168 Summary: allow read only mysql database Classification: Unclassified Product: digikam Version: 3.5.0 Platform: unspecified OS: Linux Status: UNCONFIRMED Severity: wishlist Priority: NOR Component: Database Assignee: [hidden email] Reporter: [hidden email] 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 -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Digikam-devel mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-devel |
https://bugs.kde.org/show_bug.cgi?id=330168
Kusi <[hidden email]> changed: What |Removed |Added ---------------------------------------------------------------------------- Platform|unspecified |openSUSE RPMs -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Digikam-devel mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-devel |
In reply to this post by Kusi
https://bugs.kde.org/show_bug.cgi?id=330168
Gilles Caulier <[hidden email]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[hidden email] Summary|allow read only mysql |MySQL : allow read only |database |database -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Digikam-devel mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-devel |
In reply to this post by Kusi
https://bugs.kde.org/show_bug.cgi?id=330168
Gilles Caulier <[hidden email]> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|MySQL : allow read only |MYSQL : allow read only |database |database -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Digikam-devel mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-devel |
In reply to this post by Kusi
https://bugs.kde.org/show_bug.cgi?id=330168
Gilles Caulier <[hidden email]> changed: What |Removed |Added ---------------------------------------------------------------------------- Component|Database |Database-Mysql -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Digikam-devel mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-devel |
In reply to this post by Kusi
https://bugs.kde.org/show_bug.cgi?id=330168
[hidden email] changed: What |Removed |Added ---------------------------------------------------------------------------- Component|Database-Mysql |Database-Multiusers -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Digikam-devel mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-devel |
Free forum by Nabble | Edit this page |