https://bugs.kde.org/show_bug.cgi?id=310106
Bug ID: 310106 Severity: normal Version: 2.8.0 Priority: NOR Assignee: [hidden email] Summary: Access to MySQL-database from two computers / collections get lost Classification: Unclassified OS: Linux Reporter: [hidden email] Hardware: Ubuntu Packages Status: UNCONFIRMED Component: Database Product: digikam (I'm new here, please apologize possible mistakes) I want to use digikam from two different computers, connected in a local network with nfs, with access to one database. So I migrated from SQLite to MySQL, worked fine. On Computer 1 I'm using Ubuntu 12.04.1 64-bit with two harddisks: /dev/sda1: UUID="29c8ca8a-a1ba-4c10-adc0-2538636f1c8a" TYPE="ext4" /dev/sda2: UUID="7e36c031-dd05-42d3-9eb2-c10afbdb26c6" TYPE="swap" /dev/sdb1: LABEL="Server2TB" UUID="5caa86b6-395e-42f8-bc50-41b1bf9b62eb" TYPE="ext4" Digikam and Mysql is installed on sda1, Fotos are on sdb1. On computer 2 I'm using Kubuntu 12.04.1 32-bit with one harddisk: /dev/sda1: UUID="423c3763-c693-4850-ba9f-8a6cad2aa45f" TYPE="ext4" /dev/sda5: UUID="6566d87f-7e8a-4dbd-9754-cc5f029e8636" TYPE="swap" /dev/sda6: UUID="e46888da-6ac1-4870-8365-dbc13a82942f" TYPE="ext4" On sda1 there is an old Ubuntu-installation, digikam is installed on sda6. sdb1 from computer 1 ist mounted to computer 2 in fstab with: xxx.xxx.xxx.xxx:/mnt/Server2TB/Daten /mnt/Server2TB nfs rw,hard,intr 0 0 Now I open digikam in computer 1 and add a local collection, path /mnt/Server2TB/Daten/Fotos, computer works for a while, everything is fine. I close digikam in computer 1, go to computer 2 and open digikam, add a local collection, path is the same /mnt/Server.... Computer works for a while, everything is fine, I close digikam. When I'm gonig back to computer 1, I receive an error-message: Die Sammlung Fotos (Ordner "mnt/Server2TB/Fotos" auf dem Laufwerk mit der ID "e4688da-...") kann zurzeit nicht auf Ihrem System gefunden werden. I try a translation: The collection Fotos (file "mnt/Server2TB/Fotos" on drive with the ID "e4688da-...") temporarily cannot be found on your system. I have to reenter the collection-settings, the computer ist reading the collection and then I can use it. Closing digikam on computer 1 and opening it on computer 2 again gives me an error-message: The collection Fotos (file "mnt/Server2TB/Fotos" on drive with the ID "5caa86b6-...") temporarily cannot be found on your system. These errormessages occur every time I used digikam on the other computer before. Additional to that I get another errormessage every time on both computers: Fehlermeldung: Die Datenbank ist ungültig: Die Einstellung "DBThumbnailsVersion" ist nicht vorhanden. Die aktuelle Version des Datenbankschemas kann daher nicht überprüft werden. Versuchen Sie bitte mit einer leeren Datenbank neu zu starten. In english: Errormessage: The databse is not valid: The setting "DBThumbnailVersion" is not existing. The current version of the database scheme cannot be checked. Try to start new with an empty database. Reproducible: Always Steps to Reproduce: 1. Open digikam on one computer 2. Open digikam on the other computer 3. Expected Results: Open the given collection with the shared MySQL-database -- 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 |
https://bugs.kde.org/show_bug.cgi?id=310106
[hidden email] changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[hidden email] --- Comment #1 from [hidden email] --- Hello, should you look at mysql what is in your AlbumRoots table: SELECT * FROM digikam.AlbumRoots; when you start from the first computer and after from the second. Greatings, Eric -- 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 |
In reply to this post by Roggen.Dorf
https://bugs.kde.org/show_bug.cgi?id=310106
--- Comment #2 from Messie <[hidden email]> --- Thank you for the quick response. Here ist is: first on computer 1: mysql> SELECT * FROM digikam.AlbumRoots; +----+-------+--------+------+-----------------------------------------------------+--------------+ | id | label | status | type | identifier | specificPath | +----+-------+--------+------+-----------------------------------------------------+--------------+ | 15 | Fotos | 0 | 1 | volumeid:?uuid=5caa86b6-395e-42f8-bc50-41b1bf9b62eb | /Daten/Fotos | +----+-------+--------+------+-----------------------------------------------------+--------------+ after starting digikam on computer 2: mysql> SELECT * FROM digikam.AlbumRoots; +----+-------+--------+------+-----------------------------------------------------+--------------+ | id | label | status | type | identifier | specificPath | +----+-------+--------+------+-----------------------------------------------------+--------------+ | 15 | Fotos | 0 | 1 | volumeid:?uuid=5caa86b6-395e-42f8-bc50-41b1bf9b62eb | /Daten/Fotos | +----+-------+--------+------+-----------------------------------------------------+--------------+ after settings / add new collection on computer 2: mysql> SELECT * FROM digikam.AlbumRoots; +----+-------+--------+------+-----------------------------------------------------+----------------------+ | id | label | status | type | identifier | specificPath | +----+-------+--------+------+-----------------------------------------------------+----------------------+ | 16 | Fotos | 0 | 1 | volumeid:?uuid=e46888da-6ac1-4870-8365-dbc13a82942f | /mnt/Server2TB/Fotos | +----+-------+--------+------+-----------------------------------------------------+----------------------+ again on computer 1 and after settings / add new collection: mysql> SELECT * FROM digikam.AlbumRoots; +----+-------+--------+------+-----------------------------------------------------+--------------+ | id | label | status | type | identifier | specificPath | +----+-------+--------+------+-----------------------------------------------------+--------------+ | 17 | Fotos | 0 | 1 | volumeid:?uuid=5caa86b6-395e-42f8-bc50-41b1bf9b62eb | /Daten/Fotos | +----+-------+--------+------+-----------------------------------------------------+--------------+ But the definition of the path is "/mnt/Server2TB/Daten/Fotos" and not like in specificPath. On computer 2 both are same. -- 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 |
In reply to this post by Roggen.Dorf
https://bugs.kde.org/show_bug.cgi?id=310106
--- Comment #3 from [hidden email] --- Hello, I think this not a bug. I use digikam 2.8.0 on a network share (Nas) without problem (except this : https://bugs.kde.org/show_bug.cgi?id=283323). I don't have the problem because my share is mounted the same way (I use Xubuntu 12.04 for my desktops). In your case the Id change, so digikam think that they are two different collections. Should you give /etc/fstab files from both computers ? Greatings, Eric -- 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 |
In reply to this post by Roggen.Dorf
https://bugs.kde.org/show_bug.cgi?id=310106
--- Comment #4 from [hidden email] --- I forget, Normally when you connect the 2 nd computer, you don't have to had a new collection. I think you should try to "bypass", cancel adding the collection in digikam, then configure your mysql in digikam option and restart. Greatings, Eric -- 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 |
In reply to this post by Roggen.Dorf
https://bugs.kde.org/show_bug.cgi?id=310106
--- Comment #5 from [hidden email] --- Here : The databse is not valid: The setting "DBThumbnailVersion" is not existing. The current version of the database scheme cannot be checked. Try to start new with an empty database It's another problem. -- 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 |
In reply to this post by Roggen.Dorf
https://bugs.kde.org/show_bug.cgi?id=310106
--- Comment #6 from [hidden email] --- Here is my config for the shared collection : > SELECT * FROM digikam.AlbumRoots + ------- + ---------- + ----------- + --------- + --------------- + ----------------- + | id | label | status | type | identifier | specificPath | + ------- + ---------- + ----------- + --------- + --------------- + ----------------- + | 1 | Diskphotos | 0 | 3 | networkshareid:?mountpath=%2Fmedia%2FDiskphotos | / | | NULL | NULL | NULL | NULL | NULL | NULL | + ------- + ---------- + ----------- + --------- + --------------- + ----------------- + 2 rows -- 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 |
In reply to this post by Roggen.Dorf
https://bugs.kde.org/show_bug.cgi?id=310106
--- Comment #7 from [hidden email] --- Here : after settings / add new collection on computer 2: mysql> SELECT * FROM digikam.AlbumRoots; +----+-------+--------+------+-----------------------------------------------------+----------------------+ | id | label | status | type | identifier | specificPath | +----+-------+--------+------+-----------------------------------------------------+----------------------+ | 16 | Fotos | 0 | 1 | volumeid:?uuid=e46888da-6ac1-4870-8365-dbc13a82942f | /mnt/Server2TB/Fotos | +----+-------+--------+------+-----------------------------------------------------+----------------------+ the uuis is the one of your sda6 on computer 2. Should you use /media/... for mounting your shared disk. -- 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 |
In reply to this post by Roggen.Dorf
https://bugs.kde.org/show_bug.cgi?id=310106
--- Comment #8 from Messie <[hidden email]> --- I montioned the errormessage "The databse is not valid: The setting "DBThumbnailVersion..." only for the possibility, that it could be related to the other problem. I'll give your proposals a try, but I can't do that tonight (there is a nice redwine from South Africa and some guests...) -- 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 |
In reply to this post by Roggen.Dorf
https://bugs.kde.org/show_bug.cgi?id=310106
--- Comment #9 from Messie <[hidden email]> --- Hi Eric, type and identifier are different at your computer. How is your nas mounted? Through fstab? Could you give me the line from fstab, so that I can find out differences? Thanks Matthias -- 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 |
In reply to this post by Roggen.Dorf
https://bugs.kde.org/show_bug.cgi?id=310106
--- Comment #10 from Messie <[hidden email]> --- Computer 1 is writing to AlbumRoots / identifier the UUID of sdb1, the second Harddisk on that machine. Computer 2 is writing the UUID from sda6, where the program digikam is installed. Maybe computer 2 cannot access or see or find out UUID from computer 1? How can I tell digikam to write the mountpath /mnt/Server2TB... to the identifier instead of the UUID? Greetings Matthias -- 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 |
In reply to this post by Roggen.Dorf
https://bugs.kde.org/show_bug.cgi?id=310106
--- Comment #11 from Messie <[hidden email]> --- I found a workaround: In "AlbumRoots" fill in the field "identifier" the path: "volumeid:?path=/mnt..." If the mounted path on all computers is the same (this is a matter of fstab) digikam works fine on all computers (see comment 32 in bug-report 175923). It's definitely a bug, that digikam takes a UUID, which is working on one coumputer and not on others. -- 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 |
In reply to this post by Roggen.Dorf
https://bugs.kde.org/show_bug.cgi?id=310106
--- Comment #12 from [hidden email] --- Hello, sorry, your mail was put in my spam folder. The link to the bug on uuid problem is here : https://bugs.kde.org/show_bug.cgi?id=175923 I think that when you use networkshare in add collection from digikam, the problem doesn't occure. I'm mounting the NAS in fstab with CIFS : this is my fstab line : //192.168.1.16/photos /media/Diskphotos cifs username=*********,password=*********,iocharset=utf8 0 0 Greatings, Eric -- 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 |
In reply to this post by Roggen.Dorf
https://bugs.kde.org/show_bug.cgi?id=310106
Gilles Caulier <[hidden email]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[hidden email] Summary|Access to MySQL-database |MySQL : Access to database |from two computers / |from two computers / |collections get lost |collections get lost -- 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 |
In reply to this post by Roggen.Dorf
https://bugs.kde.org/show_bug.cgi?id=310106
Gilles Caulier <[hidden email]> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|MySQL : Access to database |MYSQL : try to access to |from two computers / |database from two computers |collections get lost |and collections get lost -- 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 |
In reply to this post by Roggen.Dorf
https://bugs.kde.org/show_bug.cgi?id=310106
Gilles Caulier <[hidden email]> changed: What |Removed |Added ---------------------------------------------------------------------------- Component|Database |Database-Mysql -- 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 |
In reply to this post by Roggen.Dorf
https://bugs.kde.org/show_bug.cgi?id=310106
[hidden email] changed: What |Removed |Added ---------------------------------------------------------------------------- Component|Database-Mysql |Database-Multiusers -- 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 |
Free forum by Nabble | Edit this page |