Using digikam in pure NFS environment

I would greatly appreciate if someone could point me towards information on
how to get digikam to work in a multi-user environment where all drives are
NFS mounts from a central server.

I've come across the dreaded sqlite-bug and applied the patch recommended to
circumvent this, but as even /home is automounted from a central server, I
still have problems, and now all users must have their own digikam database,
instead of working on the same one.

So if anyone could kindly post some advise on where to find a webpage/document
that describes how I should properly handle this, I would _greatly_
appreciate it!

Thanks again for a magnificent program!
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Gilles Caulier-2]

Le Dimanche 4 Juin 2006 14:17, Halim Issa a écrit :

> I would greatly appreciate if someone could point me towards information on
> how to get digikam to work in a multi-user environment where all drives are
> NFS mounts from a central server.
>
> I've come across the dreaded sqlite-bug and applied the patch recommended
> to circumvent this, but as even /home is automounted from a central server,
> I still have problems, and now all users must have their own digikam
> database, instead of working on the same one.
>
> So if anyone could kindly post some advise on where to find a
> webpage/document that describes how I should properly handle this, I would
> _greatly_ appreciate it!
>
> Thanks again for a magnificent program!

Yes this is a main sqlite problem. Look here :

http://bugs.kde.org/show_bug.cgi?id=116252
http://article.gmane.org/gmane.comp.kde.digikam.devel/2166/

Gilles
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

Hi Gilles, and thanks for the quick reply. I understand that this is an SQLite
problem, but the workaround proposed in the two links is somewhat problematic
as it seems to assume that the users local ~/.kde/ directory is not
NFS-mounted, which it is in our case.

Does this mean that we will have to wait with DigiKam until SQLite has been
fixed, or could there be another solution we can try?

I've tried googling for this bug number in SQLite without success - do you
have a bug request number for this to check progress with the SQLite
developers?

Thanks again!

On Sunday 04 June 2006 18:33, [hidden email] wrote:

> > So if anyone could kindly post some advise on where to find a
> > webpage/document that describes how I should properly handle this, I
> > would _greatly_ appreciate it!
> >
> > Thanks again for a magnificent program!
>
> Yes this is a main sqlite problem. Look here :
>
> http://bugs.kde.org/show_bug.cgi?id=116252
> http://article.gmane.org/gmane.comp.kde.digikam.devel/2166/

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

On Sunday 04 June 2006 18:47, Halim Issa wrote:
> Hi Gilles, and thanks for the quick reply. I understand that this is an
> SQLite problem, but the workaround proposed in the two links is somewhat
> problematic as it seems to assume that the users local ~/.kde/ directory is
> not NFS-mounted, which it is in our case.
>
> Does this mean that we will have to wait with DigiKam until SQLite has been
> fixed, or could there be another solution we can try?
>


perhaps digikam should use a generic interface, such as libdbi
<http://libdbi.sourceforge.net>, which would allow the use of a proper
multi-user, shared database, such as firebird or postgresql.

libdbi implements a database-independent abstraction layer in C, similar to
the DBI/DBD layer in Perl. Writing one generic set of code, programmers can
leverage the power of multiple databases and multiple simultaneous database
connections by using this framework.

> I've tried googling for this bug number in SQLite without success - do you
> have a bug request number for this to check progress with the SQLite
> developers?
>
> Thanks again!
>
> On Sunday 04 June 2006 18:33, [hidden email] wrote:
> > > So if anyone could kindly post some advise on where to find a
> > > webpage/document that describes how I should properly handle this, I
> > > would _greatly_ appreciate it!
> > >
> > > Thanks again for a magnificent program!
> >
> > Yes this is a main sqlite problem. Look here :
> >
> > http://bugs.kde.org/show_bug.cgi?id=116252
> > http://article.gmane.org/gmane.comp.kde.digikam.devel/2166/
>
> _______________________________________________
> Digikam-users mailing list
> [hidden email]
> https://mail.kde.org/mailman/listinfo/digikam-users

--
Regards, Treeve

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Gilles Caulier-2]

Le Dimanche 04 Juin 2006 07:05 PM, Treeve Jelbert a écrit :

> On Sunday 04 June 2006 18:47, Halim Issa wrote:
> > Hi Gilles, and thanks for the quick reply. I understand that this is an
> > SQLite problem, but the workaround proposed in the two links is somewhat
> > problematic as it seems to assume that the users local ~/.kde/ directory
> > is not NFS-mounted, which it is in our case.
> >
> > Does this mean that we will have to wait with DigiKam until SQLite has
> > been fixed, or could there be another solution we can try?
>
> perhaps digikam should use a generic interface, such as libdbi
> <http://libdbi.sourceforge.net>, which would allow the use of a proper
> multi-user, shared database, such as firebird or postgresql.
>
> libdbi implements a database-independent abstraction layer in C, similar to
> the DBI/DBD layer in Perl. Writing one generic set of code, programmers can
> leverage the power of multiple databases and multiple simultaneous database
> connections by using this framework.
>
> > I've tried googling for this bug number in SQLite without success - do
> > you have a bug request number for this to check progress with the SQLite
> > developers?
> >

No. The only link about this point is on sqlite website :

http://www.sqlite.org/faq.html#q7

I recommend you to contact sqlite team using mailling list.

Gilles
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

Halim Issa wrote:

> I would greatly appreciate if someone could point me towards information on
> how to get digikam to work in a multi-user environment where all drives are
> NFS mounts from a central server.
>
> I've come across the dreaded sqlite-bug and applied the patch recommended to
> circumvent this, but as even /home is automounted from a central server, I
> still have problems, and now all users must have their own digikam database,
> instead of working on the same one.
>
> So if anyone could kindly post some advise on where to find a webpage/document
> that describes how I should properly handle this, I would _greatly_
> appreciate it!
>
> Thanks again for a magnificent program!

What kernel are you using?

The reason I ask is that I have a pure NFS network boot system we use
for our PBX machine in the office and I had serious problems relating to
DB locking when using DB4 files (the RPM database in that case).

Upgrading to a newer kernel solved the problems for me and allowed me to
lock the files properly.

So perhaps if you try the latest kernel the locking wont be a problem
for you?

Col.

--

+------------------------+
|     Colin Guthrie      |
+------------------------+
| kde(at)colin.guthr.ie  |
| http://colin.guthr.ie/ |
+------------------------+

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users