[digikam] [Bug 330168] New: allow read only mysql database

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 330168] New: allow read only mysql database

Kusi
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
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 330168] allow read only mysql database

Kusi
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
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 330168] MySQL : allow read only database

Gilles Caulier-4
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
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 330168] MYSQL : allow read only database

Gilles Caulier-4
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
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 330168] MYSQL : allow read only database

Gilles Caulier-4
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
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 330168] MYSQL : allow read only database

bugzilla_noreply
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