Sharing database between Windows and Linux

id | label | status | type | identifier

Hello everyone,

First of, thanks for digikam! It seems like it is the product I have
been searching for!
I really really like the ability to use a standard database server
such as mysql and sqlite. I have looked at Picasa, and it seems great
and all, but just didn't like all of the .ini files and some strange
database, which I could not alter in (or at least don't know how to),
and also the multi-user ability of digikam is just what I need to
share the work tagging everything with my spouse. And it is mostly
because of her Im writing now, I really like Linux, and she really
doesn't. So I need to be able to get it working on Windows and Linux.
It seems I'm half ways there, put now I'm having trouble.

It have seen this has been discussed here before, and it was suggested
the poster look into:
https://bugs.kde.org/show_bug.cgi?id=261277

So I read it, and tried to figure out what to do. I have a mysql
server running on the linux machine, which host the pictures also over
samba.
I have set the AlbumRoots in the digikam database to two different
mount points for the different OS'es, and this seems to work great.
Heres the entry:

mysql> select * from AlbumRoots;
+----+----------+--------+------+----------------------------------------------------------------------+--------------+
| id | label    | status | type | identifier
                                | specificPath |
+----+----------+--------+------+----------------------------------------------------------------------+--------------+
|  1 | pictures |      0 |    3 |
networkshareid:?mountpath=P%3A&&mountpath=%2Fdata%2Fdisc1%2Fpictures |
/pictures    |
+----+----------+--------+------+----------------------------------------------------------------------+--------------+

 So I can tag a photo on the Windows machine and almost instantly see
it on the Linux machine. But when I delete (permanently delete) an
image from the windows machine, it stops to show the whole album. I
have looked at the file server, and it does actually delete the image
and not any of the rest in the album (phew). So perhaps it just stops
to draw the thumbnails?
Well I opened the the digikam_thumbnails db, I found that the table
FilePaths, looks like this

mysql> select * from FilePaths limit 875,15; (worst part I could find)
+--------------------------------------------+---------+
| path                                       | thumbId |
+--------------------------------------------+---------+
| P:/2005/05/15/213846.JPG                   |    1115 |
| P:/2005/05/15/213927.JPG                   |    1116 |
| /data/disc1/pictures/2006/01/14/214906.JPG |    1117 |
| /data/disc1/pictures/2006/01/14/214915.JPG |    1119 |
| P:/2005/05/15/214011.JPG                   |    1120 |
| /data/disc1/pictures/2006/01/14/214952.JPG |    1121 |
| /data/disc1/pictures/2006/01/14/215002.JPG |    1122 |
| /data/disc1/pictures/2006/01/14/220525.JPG |    1123 |
| /data/disc1/pictures/2006/01/14/220534.JPG |    1124 |
| P:/2005/05/15/214015.JPG                   |    1125 |
| /data/disc1/pictures/2006/01/14/222257.JPG |    1126 |
| P:/2005/05/15/214019.JPG                   |    1127 |
| /data/disc1/pictures/2006/01/14/222308.JPG |    1128 |
| P:/2005/05/15/214023.JPG                   |    1129 |
| /data/disc1/pictures/2005/05/15/214023.JPG |    8095 |
+--------------------------------------------+---------+

So if it possible to make a mount point in the thumbnails database, or
is this perhaps not my problem at all?

===== snip ======

I'm really keen on getting digikam to work and will do everything
possible to get it working. So please, any suggestions will do :)

Sincerely
Michael

Sharing database between Windows and Linux

Sharing database between Windows and Linux

Re: Sharing database between Windows and Linux

Re: Sharing database between Windows and Linux

Re: Sharing database between Windows and Linux

Re: Sharing database between Windows and Linux