[Digikam-users] Sharing database between Windows and Linux

[Michael Klitgaard]

Hello James,

I'm sorry to say that I stopped trying to get it to work. So I'm still
not tagging our family pictures.
It seemed like windows port I used was not very robust, but perhaps
the newer versions is getting better.
I agree on the UTF-8/System thing is annoying and troubling. The
entries in the database didn't seem to mind though.

Did you experience any problems with displaying pictures/thumbs in
both the windows and linux version when using the mysql db? And did
the tags update nicely on both machine, when editing from either one?


Sincerely
Michael

On Fri, Jul 13, 2012 at 9:26 PM, James R. Shipman <JimShip at sbcglobal.net> wrote:
> Has there been any progress on this front?  I also would like to get digikam
> working from both linux and windows clients.
>
> The other problem I have is that linux systems are pretty much all UTF-8,
> but windows is "system" (whatever that is).  Every time I start digikam from
> one to the other I get a notification that the locale has changed and do I
> want to continue.  Both windows and linux machines are actually in the same
> region (for me at least) and so there should be no problem with code pages
> between the two, but it is still confusing to the casual user (the windows
> user).  It would be nice if I could disable that notification in the
> settings for digikam.
>
> Jim Shipman
>
> 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
>
>
>
> _______________________________________________
> Digikam-users mailing list
> Digikam-users at kde.org
> https://mail.kde.org/mailman/listinfo/digikam-users
>