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

[davidebasilio]

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


davidebasilio <marsicanbear at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |marsicanbear at gmail.com




--- Comment #11 from davidebasilio <marsicanbear gmail com>  2011-09-10 14:45:42 ---
I have exactly the same privileges granted with digikam 2.1 and I still get the
error message abount the missing "CREATE TRIGGER" privilege.

Note that the "TRIGGER" privilege is granted for the digikam user.

This bug is VERY anoying and prevents me to use digikam at all.
Are there any news about this?
Thanks.

davide

(In reply to comment #10)
> (In reply to comment #9)
> > It should work with privileges only on the database, try a "FLUSH PRIVILEGES;"
> > command.
> > 
> > [MySQL privileges]
> 
> Are these your actual privileges digikam runs without problems?
> I have the following privileges, but I still do get the error message.
> 
> mysql> SELECT * FROM INFORMATION_SCHEMA.USER_PRIVILEGES WHERE GRANTEE LIKE
> '%alex%';
> +------------+---------------+----------------+--------------+
> | GRANTEE    | TABLE_CATALOG | PRIVILEGE_TYPE | IS_GRANTABLE |
> +------------+---------------+----------------+--------------+
> | 'alex'@'%' | NULL          | USAGE          | NO           |
> +------------+---------------+----------------+--------------+
> 1 row in set (0.00 sec)
> 
> mysql> SELECT * FROM INFORMATION_SCHEMA.SCHEMA_PRIVILEGES WHERE GRANTEE LIKE
> '%alex%' AND TABLE_SCHEMA LIKE 'digikam';
> +------------+---------------+--------------+-------------------------+--------------+
> | GRANTEE    | TABLE_CATALOG | TABLE_SCHEMA | PRIVILEGE_TYPE          |
> IS_GRANTABLE |
> +------------+---------------+--------------+-------------------------+--------------+
> | 'alex'@'%' | NULL          | digikam      | SELECT                  | YES    
>      |
> | 'alex'@'%' | NULL          | digikam      | INSERT                  | YES    
>      |
> | 'alex'@'%' | NULL          | digikam      | UPDATE                  | YES    
>      |
> | 'alex'@'%' | NULL          | digikam      | DELETE                  | YES    
>      |
> | 'alex'@'%' | NULL          | digikam      | CREATE                  | YES    
>      |
> | 'alex'@'%' | NULL          | digikam      | DROP                    | YES    
>      |
> | 'alex'@'%' | NULL          | digikam      | REFERENCES              | YES    
>      |
> | 'alex'@'%' | NULL          | digikam      | INDEX                   | YES    
>      |
> | 'alex'@'%' | NULL          | digikam      | ALTER                   | YES    
>      |
> | 'alex'@'%' | NULL          | digikam      | CREATE TEMPORARY TABLES | YES    
>      |
> | 'alex'@'%' | NULL          | digikam      | LOCK TABLES             | YES    
>      |
> | 'alex'@'%' | NULL          | digikam      | EXECUTE                 | YES    
>      |
> | 'alex'@'%' | NULL          | digikam      | CREATE VIEW             | YES    
>      |
> | 'alex'@'%' | NULL          | digikam      | SHOW VIEW               | YES    
>      |
> | 'alex'@'%' | NULL          | digikam      | CREATE ROUTINE          | YES    
>      |
> | 'alex'@'%' | NULL          | digikam      | ALTER ROUTINE           | YES    
>      |
> | 'alex'@'%' | NULL          | digikam      | EVENT                   | YES    
>      |
> | 'alex'@'%' | NULL          | digikam      | TRIGGER                 | YES    
>      |
> +------------+---------------+--------------+-------------------------+--------------+
> 18 rows in set (0.00 sec)
> 
> Note: This is digikam 2.0.0

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