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

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

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

Roggen.Dorf
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
Reply | Threaded
Open this post in threaded view
|

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

eldk
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
Reply | Threaded
Open this post in threaded view
|

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

Roggen.Dorf
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
Reply | Threaded
Open this post in threaded view
|

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

eldk
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
Reply | Threaded
Open this post in threaded view
|

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

eldk
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
Reply | Threaded
Open this post in threaded view
|

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

eldk
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
Reply | Threaded
Open this post in threaded view
|

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

eldk
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
Reply | Threaded
Open this post in threaded view
|

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

eldk
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
Reply | Threaded
Open this post in threaded view
|

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

Roggen.Dorf
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
Reply | Threaded
Open this post in threaded view
|

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

Roggen.Dorf
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
Reply | Threaded
Open this post in threaded view
|

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

Roggen.Dorf
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
Reply | Threaded
Open this post in threaded view
|

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

Roggen.Dorf
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
Reply | Threaded
Open this post in threaded view
|

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

eldk
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
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 310106] MySQL : Access to database from two computers / collections get lost

Gilles Caulier-4
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
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 310106] MYSQL : try to access to database from two computers and collections get lost

Gilles Caulier-4
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
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 310106] MYSQL : try to access to database from two computers and collections get lost

Gilles Caulier-4
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
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 310106] MYSQL : try to access to database from two computers and collections get lost

bugzilla_noreply
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