https://bugs.kde.org/show_bug.cgi?id=351245
Bug ID: 351245 Summary: Unable to connect to mysql database, due to missing 'create trigger' while user has ALL privileges on digikam DBs Product: digikam Version: 4.12.0 Platform: openSUSE RPMs OS: Linux Status: UNCONFIRMED Severity: grave Priority: NOR Component: Database Assignee: [hidden email] Reporter: [hidden email] When starting digikam, it complains that user has no CREATE TRIGGER privileges and doesnt connect to database (see attachment 1). Show grants for this user shows it has ALL priviledges on this database: MariaDB [(none)]> show grants for 'digikam'@'%'; +-----------------------------------------------------------------------------------------------------------------------+ | Grants for digikam@% | +-----------------------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'digikam'@'%' IDENTIFIED BY PASSWORD '*04E1D6' | | GRANT ALL PRIVILEGES ON `digikam`.* TO 'digikam'@'%' WITH GRANT OPTION | | GRANT ALL PRIVILEGES ON `digikam_thumbs`.* TO 'digikam'@'%' WITH GRANT OPTION | +-----------------------------------------------------------------------------------------------------------------------+ 3 rows in set (0.01 sec) Reproducible: Always Steps to Reproduce: 1. Start digikam 2. 3. Actual Results: Refer to attachment 1, no contents Expected Results: Show current libraries of fotos -- 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=351245
Gerard Dirkse <[hidden email]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[hidden email] --- Comment #1 from Gerard Dirkse <[hidden email]> --- Created attachment 94013 --> https://bugs.kde.org/attachment.cgi?id=94013&action=edit Attachment 1, error message Error message when starting up 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 |
In reply to this post by Gerard Dirkse
https://bugs.kde.org/show_bug.cgi?id=351245
Gerard Dirkse <[hidden email]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |FIXED --- Comment #2 from Gerard Dirkse <[hidden email]> --- Problem fixed, due to binary-logging of database, SUPER privilege was required. After adding SUPER privilege to user problem was gone. -- 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 Gerard Dirkse
https://bugs.kde.org/show_bug.cgi?id=351245
Gilles Caulier <[hidden email]> changed: What |Removed |Added ---------------------------------------------------------------------------- Version Fixed In| |4.13.0 CC| |[hidden email] -- 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 Gerard Dirkse
https://bugs.kde.org/show_bug.cgi?id=351245
[hidden email] changed: What |Removed |Added ---------------------------------------------------------------------------- Component|Database |Database-Mysql -- You are receiving this mail because: You are the assignee for the bug. |
Free forum by Nabble | Edit this page |