[Bug 262321] New: mysql user privileges

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

[Bug 262321] New: mysql user privileges

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

           Summary: mysql user privileges
           Product: digikam
           Version: 2.0.0
          Platform: openSUSE RPMs
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: wishlist
          Priority: NOR
         Component: Database
        AssignedTo: [hidden email]
        ReportedBy: [hidden email]


Version:           2.0.0 (using Devel)
OS:                Linux

Hi,

digikam needs a user with super privileges in order to access the mysql
database....
see more here
http://scribblesandsnaps.wordpress.com/2010/10/15/using-digikam-with-mysql/
alin's comment.

However I find this excessive... other kde apps use mysql databases
(amarok/akonadi) without the need for super privileges...

wouldbe nice if the mysql would work without the super,,,

Alin


Reproducible: Didn't try




OS: Linux (x86_64) release 2.6.37-rc8-desktop
Compiler: gcc

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=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
|

[Bug 262321] mysql user privileges

Bugzilla from brunofr@ioda.net
https://bugs.kde.org/show_bug.cgi?id=262321


Bruno Friedmann <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]




--- Comment #1 from Bruno Friedmann <brunofr ioda net>  2011-01-08 21:22:32 ---
Reproductible always with 2.0dev

In fact after creating a user database, and giving him full rights ( GRANT ALL
on )
this instruction doesn't work in dbconfig


 702             <dbaction name="CheckPriv_CREATE_TRIGGER"><statement
mode="plain">
 703                 CREATE TRIGGER privcheck_trigger AFTER DELETE ON PrivCheck
 704                  FOR EACH ROW BEGIN
 705                 END;
 706             </statement>
 707             </dbaction>

mysql> CREATE TRIGGER privcheck_trigger AFTER DELETE ON PrivCheck
    -> FOR EACH ROW BEGIN
    -> END;
ERROR 1419 (HY000): You do not have the SUPER privilege and binary logging is
enabled (you *might* want to use the less safe log_bin_trust_function_creators
variable)
mysql>

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=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
|

[Bug 262321] mysql user privileges

Bugzilla from Hamsi2k@freenet.de
In reply to this post by Alin M Elena
https://bugs.kde.org/show_bug.cgi?id=262321





--- Comment #5 from Quallenauge <Hamsi2k freenet de>  2011-03-31 20:43:00 ---
From my point of view it is possible to avoid using triggers and move the
functionality to the concrete sql statements - I've done that once for the tags
tree.

Maybe one can extend the affected statements (and move some more statements to
the dbconfig.xml file). I'm running out of free time to do that in near future
:-(
(But I will give some help to do that).

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=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
|

[Bug 262321] mysql user privileges

Bugzilla from felix.leif@keppmann.de
In reply to this post by Alin M Elena
https://bugs.kde.org/show_bug.cgi?id=262321


Felix Leif Keppmann <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]




--- Comment #6 from Felix Leif Keppmann <felix leif keppmann de>  2011-05-16 20:21:42 ---
Same issue... but appears not only in digiKam context. You can find a lot of
threads about it. I also found:

"The TRIGGER privilege enables trigger operations. You must have this privilege
for a table to create, drop, or execute triggers for that table. This privilege
was added in MySQL 5.1.6. (Prior to MySQL 5.1.6, trigger operations required
the SUPER privilege.)" (
http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html#priv_trigger ).

Ok, current stable in the 5.1 branch is 5.1.57 and 5.1.6 never got stable
status?

Somebody on MySQL 5.5.x should check if a database level privilege "TRIGGER" is
available because it would probably fix this issue.

Is somebody with this issue not on MySQL 5.1.x?

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=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
|

[Bug 262321] mysql user privileges

Bugzilla from regi.hops@gmx.net
In reply to this post by Alin M Elena
https://bugs.kde.org/show_bug.cgi?id=262321


[hidden email] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]




--- 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.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel
Reply | Threaded
Open this post in threaded view
|

[Bug 262321] mysql user privileges

Bugzilla from Flu_Ger@web.de
In reply to this post by Alin M Elena
https://bugs.kde.org/show_bug.cgi?id=262321


Flu87 <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
     Ever Confirmed|0                           |1




--- Comment #8 from Flu87 <Flu_Ger web de>  2011-08-04 09:34:59 ---
*** This bug has been confirmed by popular vote. ***

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=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
|

[Bug 262321] mysql user privileges

Francesco Riosa-2
In reply to this post by Alin M Elena
https://bugs.kde.org/show_bug.cgi?id=262321


Francesco Riosa <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]




--- 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.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel
Reply | Threaded
Open this post in threaded view
|

[Bug 262321] mysql user privileges

Bugzilla from alexander.stein@informatik.tu-chemnitz.de
In reply to this post by Alin M Elena
https://bugs.kde.org/show_bug.cgi?id=262321


Alexander Stein <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |alexander.stein@informatik.
                   |                            |tu-chemnitz.de




--- Comment #10 from Alexander Stein <alexander stein informatik tu-chemnitz de>  2011-08-06 15:47:29 ---
(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.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel
Reply | Threaded
Open this post in threaded view
|

[Bug 262321] mysql user privileges

Bugzilla from marsicanbear@gmail.com
In reply to this post by Alin M Elena
https://bugs.kde.org/show_bug.cgi?id=262321


davidebasilio <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]




--- 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.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel
Reply | Threaded
Open this post in threaded view
|

[Bug 262321] mysql user privileges

Bugzilla from alexxy@gentoo.org
In reply to this post by Alin M Elena
https://bugs.kde.org/show_bug.cgi?id=262321


Alexey Shvetsov <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]




--- Comment #12 from Alexey Shvetsov <alexxy gentoo org>  2011-09-10 19:37:20 ---
Same here on gentoo with digika 2.1.0 and mysql 5.1.58

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=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
|

[Bug 262321] mysql user privileges

Bugzilla from marsicanbear@gmail.com
In reply to this post by Alin M Elena
https://bugs.kde.org/show_bug.cgi?id=262321





--- Comment #13 from davidebasilio <marsicanbear gmail com>  2011-09-10 19:39:43 ---
I'm on gentoo too, and I'm using mysql 5.5.14.

(In reply to comment #12)
> Same here on gentoo with digika 2.1.0 and mysql 5.1.58

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=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
|

[Bug 262321] mysql user privileges

Bugzilla from marsicanbear@gmail.com
In reply to this post by Alin M Elena
https://bugs.kde.org/show_bug.cgi?id=262321





--- Comment #14 from davidebasilio <marsicanbear gmail com>  2011-10-11 15:44:15 ---
Any news on this?

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=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
|

[Bug 262321] mysql user privileges

Bugzilla from marsicanbear@gmail.com
In reply to this post by Alin M Elena
https://bugs.kde.org/show_bug.cgi?id=262321





--- Comment #15 from davidebasilio <marsicanbear gmail com>  2011-11-07 16:12:55 ---
Digikam 2.3.0 is out http://www.digikam.org/drupal/node/632
But it looks like noone took care of this bug since 2.0.0
Will it ever be fixed?
BTW, this is tagged as wishlist, but I do not really think that's correct. This
is a bug.

(In reply to comment #14)
> Any news on this?

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=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
|

[Bug 262321] mysql user privileges

Gilles Caulier-4
In reply to this post by Alin M Elena
https://bugs.kde.org/show_bug.cgi?id=262321


Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]




--- Comment #16 from Gilles Caulier <caulier gilles gmail com>  2011-11-07 16:19:24 ---
Francesco work in it, but in a separate branch until code is stabilized... DB
interface is tedious code. Please wait...

Gilles Caulier

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=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
|

[Bug 262321] mysql user privileges

Bugzilla from marsicanbear@gmail.com
In reply to this post by Alin M Elena
https://bugs.kde.org/show_bug.cgi?id=262321





--- Comment #17 from davidebasilio <marsicanbear gmail com>  2011-11-07 16:53:02 ---
Ok, thanks.. It's nice to see that someone is taking care of this bug.
Sorry for bothering, but it looked like it had been forgotten..
If you require someone to test te fix before release, let me know: I will be
glad to help!

davide

(In reply to comment #16)
> Francesco work in it, but in a separate branch until code is stabilized... DB
> interface is tedious code. Please wait...
>
> Gilles Caulier

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=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
|

[Bug 262321] MYSQL : user privileges management

Gilles Caulier-4
In reply to this post by Alin M Elena
https://bugs.kde.org/show_bug.cgi?id=262321


Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|mysql user privileges       |MYSQL : user privileges
                   |                            |management




--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=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
|

[Bug 262321] MYSQL : user privileges management

Bugzilla from marsicanbear@gmail.com
In reply to this post by Alin M Elena
https://bugs.kde.org/show_bug.cgi?id=262321





--- Comment #18 from davidebasilio <marsicanbear gmail com>  2012-02-21 09:37:29 ---
I finally achieved to work around this issue by starting mysql (version 5.1.61)
with the --log-bin-trust-function-creators=1 option.
As far as I understood, this makes the server trust unprivileged users with the
TRIGGER privilege and lets them actually create triggers, without the need of
the SUPER privilege.
More details here:

http://stackoverflow.com/questions/1627383/cant-create-mysql-trigger-with-trigger-privilege-on-5-1-32
http://dev.mysql.com/doc/refman/5.1/en/stored-programs-logging.html

Hope it helps someone.

davide

--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=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
|

[Bug 262321] MYSQL : user privileges management

Bugzilla from regi.hops@gmx.net
In reply to this post by Alin M Elena
https://bugs.kde.org/show_bug.cgi?id=262321





--- Comment #19 from  <regi hops gmx net>  2012-02-21 23:16:12 ---
Hi Davide,

thanks for that, just tried it on MySQL 5.5.20 with DigiKan 2.5.0.

So the error of this task seems to be gone cause DigiKam doesn't complain about
trigger privileges anymore.

But now I get some other errors - may I run into other bugs.

So at this point I'm giving up trying to use MySQL as the back-end and stay
with SQLite.

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.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel
Reply | Threaded
Open this post in threaded view
|

[Bug 262321] MYSQL : user privileges management

flammenflitzer
In reply to this post by Alin M Elena
https://bugs.kde.org/show_bug.cgi?id=262321

[hidden email] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]
                   |                            |rf.de

--- Comment #20 from [hidden email] ---
digikam 2.9.0!!! mysql 5.1.62 on Gentoo Linux
http://scribblesandsnaps.com/2010/10/15/using-digikam-with-mysql/
[code]Sie besitzen nicht die benötigten Rechte für die Datenbank.
Sie besitzen folgende Rechte nicht:
CREATE TRIGGER
Überprüfen Sie Ihre Rechte für die Datenbank und starten Sie digiKam
neu.[/code]

2011-01-06 17:19:13 !!!

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

[Bug 262321] MYSQL : user privileges management

Gilles Caulier-4
In reply to this post by Alin M Elena
https://bugs.kde.org/show_bug.cgi?id=262321

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Version|2.0.0                       |2.9.0

--
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
12