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

[Stefan Mueller]

hey thx for the input.
I will start a separate discussion to discuss details.
I've jsut started collecting documentation about user accounts handling in
mariadb.
found only this so far:
Grant user access to limited number of tables in MySQL
<https://stackoverflow.com/questions/8369253/grant-user-access-to-limited-number-of-tables-in-mysql>
would be nice to get a central authentication service, such as an LDAP
server involved, what runs anyway for the cloud etc.


Le lun. 22 oct. 2018 à 18:59, <digikam at 911networks.com> a écrit :

> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20181025/302506e8/attachment.html>