[Digikam-devel] [Bug 310106] New: Access to MySQL-database from two computers / collections get lost

[Messie]

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

            Bug ID: 310106
          Severity: normal
           Version: 2.8.0
          Priority: NOR
          Assignee: digikam-devel at kde.org
           Summary: Access to MySQL-database from two computers /
                    collections get lost
    Classification: Unclassified
                OS: Linux
          Reporter: roggen.dorf at freenet.de
          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.