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

[Dmitri Popov-2]

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

[PackElend]

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 

Le ven. 19 oct. 2018 à 09:40, Dmitri Popov <[hidden email]> 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

Le 19/10/2018 à 16:23, Stefan Mueller a écrit :

> 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.
>

isn't that more the goal of a gallery? (I use piwigo)

jdd

--
http://dodin.org

[PackElend]

The gallery is the and step downstream the picture management and processing process.

Any user has its home folder on a network drive for its own media. There is a shared network drive  for  shared / common medias.
We are going to switch to Nextcloud for improved sharing soon.

I'm wondering how to setup the database and digiKam that I can use it on any machine and it shows me only the pictures I'm supposed to see, without endless re-scanning of the source folder or database.

In digikam any user can do the tagging and per-selection and may do some post processing with digiKam or external applications.

Afterwards, the selected pictures a put in a media gallery and/or social or sharing  platform.

Is there are proper workflow meeting my requirements?

thx

Stefan

Le ven. 19 oct. 2018 à 16:28, [hidden email] <[hidden email]> a écrit :

Le 19/10/2018 à 16:23, Stefan Mueller a écrit :
> 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.
>

isn't that more the goal of a gallery? (I use piwigo)

jdd

--
http://dodin.org

[Dmitri Popov-2]

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
<[hidden email]> 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 <[hidden email]> 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

[digikam-2]

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 <[hidden email]> 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
> <[hidden email]> 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 <[hidden email]> 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

[PackElend]

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

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, <[hidden email]> 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 <[hidden email]> 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
> <[hidden email]> 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 <[hidden email]> 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

[digikam-2]

On Thu, 25 Oct 2018 12:50:15 +0200
Stefan Mueller <[hidden email]> wrote:

> 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.

This will not work because all the photos (and I imagine also the
videos) are in one table: "images" so all users need to have access
to that table if you want to share the database.

--
sknahT

vyS

[J Albrecht]

I seem to recall that at one point digiKam displayed an indicator to show the progress of Maintenance activities. Previously I've disliked such visual distractions. However, I’ve now realised that this is a good way to troubleshoot lethargic computer response.

I can’t see any such indications on my current version (5.9.0 running on Fedora 28). Has this functionality been removed? If it’s still available, would somebody please tell me how I can make it visible?

[Gilles Caulier-4]

Hi,

The progress indicator is located on status bar, on the right bottom side. It's a widget that you can rise with a button to show all details.

Best

Gilles Caulier

Le mar. 6 nov. 2018 à 00:11, J Albrecht <[hidden email]> a écrit :

I seem to recall that at one point digiKam displayed an indicator to show the progress of Maintenance activities. Previously I've disliked such visual distractions. However, I’ve now realised that this is a good way to troubleshoot lethargic computer response.

I can’t see any such indications on my current version (5.9.0 running on Fedora 28). Has this functionality been removed? If it’s still available, would somebody please tell me how I can make it visible?

[J Albrecht]

Thank-you, Giles.

On 6 Nov 2018, at 00:35, Gilles Caulier <[hidden email]> wrote:

Hi,

The progress indicator is located on status bar, on the right bottom side. It's a widget that you can rise with a button to show all details.

Best

Gilles Caulier

Le mar. 6 nov. 2018 à 00:11, J Albrecht <[hidden email]> a écrit :

I seem to recall that at one point digiKam displayed an indicator to show the progress of Maintenance activities. Previously I've disliked such visual distractions. However, I’ve now realised that this is a good way to troubleshoot lethargic computer response.

I can’t see any such indications on my current version (5.9.0 running on Fedora 28). Has this functionality been removed? If it’s still available, would somebody please tell me how I can make it visible?

[PackElend]

Hi there,

it looks like it is feasible:

1. MySQL: can I implement row-level AND column level security?
2. Protect Your Data: Row-level Security in MariaDB 10.0

and some supporting documentation:

1. Ten Tips on How to Achieve MySQL and MariaDB Security
2. MySQL Table and Column Level Permissions.
3. Dynamic Columns Tutorial – Part 1: Introduction

I'll keep on searching. Anyone else interested?

Stefan

Am 25.10.2018 um 17:37 schrieb [hidden email]:

On Thu, 25 Oct 2018 12:50:15 +0200
Stefan Mueller [hidden email] wrote:

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.

This will not work because all the photos (and I imagine also the
videos) are in one table: "images" so all users need to have access
to that table if you want to share the database.

[digikam-2]

On Sun, 18 Nov 2018 21:12:31 +0100
"Stefan Müller" <[hidden email]> wrote:

> Hi there,
> it looks like it is feasible:
> • MySQL: can I implement row-level AND column level security?
> • Protect Your Data: Row-level Security in MariaDB 10.0

Sorry (I'm Canadian and we try to be polite), but I still don't think
that it's possible under the current conditions.

DK doesn't track the users, therefore DK doesn't know which photo
belong to who.

If you can add the user information to the database then it might be
possible, with something like: userid-filename.extension, then create
views that are for each user, but in the end, you would still have to
modify the DK code to take count of that info.

Gilles is the "boss"...

>
> and some supporting documentation:
> • Ten Tips on How to Achieve MySQL and MariaDB Security
> • MySQL Table and Column Level Permissions.
> • Dynamic Columns Tutorial – Part 1: Introduction
>
> I'll keep on searching. Anyone else interested?
>
> Stefan
>
> Am 25.10.2018 um 17:37 schrieb [hidden email]:
> On Thu, 25 Oct 2018 12:50:15 +0200
> > Stefan Mueller <[hidden email]> wrote:
> >
> > 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.
> >>
> > This will not work because all the photos (and I imagine also the
> > videos) are in one table: "images" so all users need to have
> > access to that table if you want to share the database.
> >
> >

--
sknahT

vyS