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

[regi.hops at gmx.net]

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


regi.hops at gmx.net changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |regi.hops at gmx.net




--- Comment #7 from  <regi hops gmx net>  2011-08-03 18:45:34 ---
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

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