[digikam] [Bug 351245] New: Unable to connect to mysql database, due to missing 'create trigger' while user has ALL privileges on digikam DBs

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

[digikam] [Bug 351245] New: Unable to connect to mysql database, due to missing 'create trigger' while user has ALL privileges on digikam DBs

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

[digikam] [Bug 351245] Unable to connect to mysql database, due to missing 'create trigger' while user has ALL privileges on digikam DBs

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

[digikam] [Bug 351245] Unable to connect to mysql database, due to missing 'create trigger' while user has ALL privileges on digikam DBs

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

[digikam] [Bug 351245] Unable to connect to mysql database, due to missing 'create trigger' while user has ALL privileges on digikam DBs

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

[digikam] [Bug 351245] Unable to connect to mysql database, due to missing 'create trigger' while user has ALL privileges on digikam DBs

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