[Digikam-devel] [Bug 262321] mysql user privileges

[Francesco Riosa]

https://bugs.kde.org/show_bug.cgi?id=262321


Francesco Riosa <francesco+kde at pnpitalia.it> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |francesco+kde at pnpitalia.it




--- Comment #9 from Francesco Riosa <francesco+kde pnpitalia it>  2011-08-04 13:29:04 ---
(In reply to comment #7)
> Hi,
> 
> I've got the following message from digiKam after switching to my MySQL-Server:
> 
> "You have insufficient privileges on the database.
> Following privileges are not assigned to you:
>  CREATE TRIGGER
> Check your privileges on the database and restart digiKam."
> 
> digiKam version is: 2.0.0-rc
> openSUSE: 11.4 64Bit
> KDE: 4.7.00 release 6
> MySQL (on a different server): 5.5.15-log
> 
> The user I use for digiKam is in the mysql.user table with no privileges, but
> in the table mysql.db it is granted full access to the digiKam-DB, where it
> also has the privilege "TRIGGER_PRIV".
> 
> I tried to create a trigger by myself with the digiKam user and it worked.
> 
> Just for your information:
> Giving digiKam root access solves the trigger problem but then another problem
> pops up:
> "Failed to update the database schema from version 5 to version 6. Please read
> the error messages printed on the console and report this error as a bug at
> bugs.kde.org."
> But for this there is already a bug report.
> 
> If you need more information or help on this issue let me know.
> 
> Cheers
> Regi

It should work with privileges only on the database, try a "FLUSH PRIVILEGES;"
command.

A strong suggestion, for the moment do not use different databases for images
and thumbnails, there are known bugs that will be fixed (tentatively in 2.1
possibly in 2.2)

mysql> SELECT * FROM INFORMATION_SCHEMA.USER_PRIVILEGES WHERE GRANTEE LIKE
'%digikam%';
+---------------+---------------+----------------+--------------+
| GRANTEE       | TABLE_CATALOG | PRIVILEGE_TYPE | IS_GRANTABLE |
+---------------+---------------+----------------+--------------+
| 'digikam'@'%' | NULL          | USAGE          | NO           |
+---------------+---------------+----------------+--------------+
1 row in set (0.01 sec)


mysql> SELECT * FROM INFORMATION_SCHEMA.SCHEMA_PRIVILEGES WHERE GRANTEE LIKE
'%digikam%' AND TABLE_SCHEMA LIKE 'digikam19';
+---------------+---------------+--------------+-------------------------+--------------+
| GRANTEE       | TABLE_CATALOG | TABLE_SCHEMA | PRIVILEGE_TYPE          |
IS_GRANTABLE |
+---------------+---------------+--------------+-------------------------+--------------+
| 'digikam'@'%' | NULL          | digikam19    | SELECT                  | YES 
        |
| 'digikam'@'%' | NULL          | digikam19    | INSERT                  | YES 
        |
| 'digikam'@'%' | NULL          | digikam19    | UPDATE                  | YES 
        |
| 'digikam'@'%' | NULL          | digikam19    | DELETE                  | YES 
        |
| 'digikam'@'%' | NULL          | digikam19    | CREATE                  | YES 
        |
| 'digikam'@'%' | NULL          | digikam19    | DROP                    | YES 
        |
| 'digikam'@'%' | NULL          | digikam19    | REFERENCES              | YES 
        |
| 'digikam'@'%' | NULL          | digikam19    | INDEX                   | YES 
        |
| 'digikam'@'%' | NULL          | digikam19    | ALTER                   | YES 
        |
| 'digikam'@'%' | NULL          | digikam19    | CREATE TEMPORARY TABLES | YES 
        |
| 'digikam'@'%' | NULL          | digikam19    | LOCK TABLES             | YES 
        |
| 'digikam'@'%' | NULL          | digikam19    | EXECUTE                 | YES 
        |
| 'digikam'@'%' | NULL          | digikam19    | CREATE VIEW             | YES 
        |
| 'digikam'@'%' | NULL          | digikam19    | SHOW VIEW               | YES 
        |
| 'digikam'@'%' | NULL          | digikam19    | CREATE ROUTINE          | YES 
        |
| 'digikam'@'%' | NULL          | digikam19    | ALTER ROUTINE           | YES 
        |
| 'digikam'@'%' | NULL          | digikam19    | EVENT                   | YES 
        |
| 'digikam'@'%' | NULL          | digikam19    | TRIGGER                 | YES 
        |
+---------------+---------------+--------------+-------------------------+--------------+
18 rows in set (0.00 sec)

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.