[digiKam-users] Use digiKam with a NAS and MariaDB

[digikam at 911networks.com]

Hi,

I think that's it's "kind of possible" with some admin work.

Lets assume that all the photos are in the /photos/ directory and
each user is /photos/user1, /photos/user2.

1. You will need to set the directories to be private.
2. User master-digikam has to be to access them all.
3. Set the "master-dk" to read all the photos/userX for all
users and set the mySQL to external
4. Set each user with their own digikam database, sqlite would be OK.
5. Make sure that each dk-user writes the XMPs that would be read by
master-dk.

That way each user cannot see the other images, only their own, but
master-dk could see everything.

The other alternative would be everybody uses mysql/mariadb and sets
the replication into master-dk with the "replicate-do-table". I have
never done this in mysql but it works extremely well in SQL Server.

Thanks

Syv

On Mon, 22 Oct 2018 11:25:10 +0200
Dmitri Popov <lazylegs at gmail.com> wrote:

> Hi Stefan,
> 
> Thank you for your kind words!
> 
> > So I'm wondering if it is possible to show pictures and their
> > thumbnails depending on the user account of the logged in local
> > user? If possible without a rescan of the entire library.  
> 
> If I understand you correctly, then I don't think it's possible.
> 
> Best,
> Dmitri
> 
> On Fri, Oct 19, 2018 at 4:23 PM Stefan Mueller
> <stefan.mueller.83 at gmail.com> wrote:
> >
> > Hoi Dimitri,
> > Thanks for your efforts, it's highly appreciated as I am
> > intending to do the same thing, as digiKam would run on different
> > machines.
> >
> > Doing all this, have thought about setting up a multiple user
> > environment? Most of the pictures I take care of are common ones
> > but some private ones of each user. So I'm wondering if it is
> > possible to show pictures and their thumbnails depending on the
> > user account of the logged in local user? If possible without a
> > rescan of the entire library.
> >
> > Thank you
> > Stefan
> >
> >
> >
> > Sent from a fair mobile
> >
> >
> > Le ven. 19 oct. 2018 à 09:40, Dmitri Popov <lazylegs at gmail.com> a
> > écrit :  
> >>
> >> Hello,
> >>
> >> I've finally moved my digiKam photo library to a NAS and migrated
> >> digiKam's SQLite databases to MariaDB. I documented the entire
> >> process here:
> >>
> >> https://scribblesandsnaps.com/2018/10/19/use-digikam-with-a-nas-and-mariadb/
> >>
> >> Hope you'll find this useful.
> >>
> >> Kind regards,
> >> Dmitri  


-- 
sknahT

vyS