https://bugs.kde.org/show_bug.cgi?id=459702
Bug ID: 459702
Summary: Digikam git Mariadb issue
Classification: Applications
Product: digikam
Version: 8.0.0
Platform: Compiled Sources
OS: Linux
Status: REPORTED
Severity: normal
Priority: NOR
Component: Database-Mysql
Assignee: digikam-bugs-n...@kde.org
Reporter: leoutat...@gmx.fr
Target Milestone: ---
Hi
I use Digikam git version on two computers, PC1 and PC2
Digikam images collection and Mariadb are installed on PC1 (Local address is
192.168.2.21)
Same/mirrored Digikam collection is copied from PC1 is to PC2, local address
192.168.2.2 that can access to Mariadb on PC1 through local network
Issue: when i want to delete or add tag, Digikam doesn't see user
'dkmn2'@'192.168.2.2' but ''@'192.168.2.2
PC1 Error messages in console
digikam.dbengine: Failure executing query:
"DELETE FROM Tags WHERE id=?;"
Error messages: "QMYSQL3: Unable to execute statement" "The user specified as a
definer (''@'192.168.2.2') does not exist" "1449" 2
Bound values: (QVariant(int, 571))
digikam.dbengine: Error while executing DBAction [ "DeleteTag" ] Statement [
"DELETE FROM Tags WHERE id=:tagID;" ]
digikam.general: Delete Shortcut assigned to tag 571
digikam.general: ("test-tag")
digikam.general: "test-tag" :: "/test-tag"
digikam.dbengine: Failure executing query:
"INSERT INTO Tags (pid, name) VALUES( ?, ?);"
Error messages: "QMYSQL3: Unable to execute statement" "The user specified as a
definer (''@'192.168.2.2') does not exist" "1449" 2
Bound values: (QVariant(int, 0), QVariant(QString, "test-tag"))
digikam.dbengine: Error while executing DBAction [ "InsertTag" ] Statement [
"INSERT INTO Tags (pid, name) VALUES( :tagPID, :tagname);" ]
(I get same kind of errors on PC2 when I try to delete or create tags)
PC1: local adress is 192.168.2.21 where Mariadb is installed. I tried to
replace 'localhost' with '192.168.2.21' but i get same issue
digikam.general: Database Parameters:
Type: "QMYSQL"
DB Core Name: "dkmn"
DB Thumbs Name: "dkmn"
DB Face Name: "dkmn"
DB Similarity Name: "dkmn"
Connect Options: ""
Host Name: "localhost"
Host Port: 3306
WAL Mode: false
Internal Server: false
Internal Server Path: ""
Internal Server Admin Cmd: ""
Internal Server Serv Cmd: ""
Internal Server Init Cmd: ""
Username: "dkmn"
Password: "XXXXXXXXXXXXXXXX"
PC2 : local adress is 192.168.2.2 that can access to Mariadb on PC1 through
local network
digikam.general: Database Parameters:
Type: "QMYSQL"
DB Core Name: "dkmn"
DB Thumbs Name: "dkmn"
DB Face Name: "dkmn"
DB Similarity Name: "dkmn"
Connect Options: ""
Host Name: "192.168.2.21"
Host Port: 3306
WAL Mode: false
Internal Server: false
Internal Server Path: ""
Internal Server Admin Cmd: ""
Internal Server Serv Cmd: ""
Internal Server Init Cmd: ""
Username: "dkmn2"
Password: "XXXXXXXXXXXXXXXX"
When I check Mariadb, user 'dkmn2' is present:
MariaDB [(none)]> SHOW GRANTS FOR 'dkmn2'@'192.168.2.2';
+-------------------------------------------------------------------------------------------------------------------------------------------+
| Grants for dkmn2@192.168.2.2
|
+-------------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO `dkmn2`@`192.168.2.2` IDENTIFIED BY PASSWORD
'*xxxxxxxxxxx' WITH GRANT OPTION |
| GRANT ALL PRIVILEGES ON `dkmn`.* TO `dkmn2`@`192.168.2.2` WITH GRANT OPTION
|
+-------------------------------------------------------------------------------------------------------------------------------------------+
--
You are receiving this mail because:
You are watching all bug changes.
