Sharing Database - Windows/XP
plongstaff at rogers.com
Wed Apr 21 15:42:32 EDT 2010
I don't know if this is related to bug https://bugzilla.gnome.org/show_bug.cgi?id=352491 or not.
I used to be a hypochondriac AND a kleptomaniac. So I took something for it.
From: Phillip Richcreek <pwrichcreek at gmail.com>
To: M Prindle <mprindle at pobox.com>
Cc: gnucash-user at gnucash.org
Sent: Wed, April 21, 2010 3:28:08 PM
Subject: Re: Sharing Database - Windows/XP
> ...Does the share directory have full read/write/create permissions on it?
For simplicity's sake, let's call the computer where the gnucash
database resides "DELL" and let's call the other computer "HP". HP is
the computer that is having the problem opening the database. I ran a
test using a text editor on computer HP and demonstrated that the
editor could indeed write a new file to the gnucash directory -- the
shared directory where the gnucash database resides.
I'm able to see the lock file, account database.LCK, from both DELL
and HP, when I have the database open on DELL. After I close the
database on DELL, I see that the LCK file is no longer present and I
can see that from both DELL and HP by listing the files in the
directory. Nevertheless, when I start gnucash from HP, even though no
other instance of gnucash is running on DELL, I get the unable to
obtain the lock message and the program opens the database for
It would appear the gnucash is doing something more than just looking
for the presence of the LCK file to determine whether another instance
of gnucash has the database open for write.
On Wed, Apr 21, 2010 at 2:13 PM, M Prindle <mprindle at pobox.com> wrote:
> Oh yes that is what I thought you ment. When GNUCash lauches and you
> open the database it creates a lock file in the database directory.
> If for some reason the network client don't have the privs to create
> the file you could get that error. Does the share directory have full
> read/write/create permissions on it?
> On Wed, Apr 21, 2010 at 1:03 PM, Phillip Richcreek
> <pwrichcreek at gmail.com> wrote:
>> Thanks for your reply.
>>> One one person can have the database open at at time.
>> In retrospect, I can see that my original message implied that I want
>> to have the database open for read/write by two users at the same
>> time. I don't expect that. But I do want either user/computer to be
>> capable of writing to the database, provided no other user has it open
>> for write access at the same time.
>> I failed to state that, when I received the gnucash unable to obtain
>> the lock message, no other user had the database open -- neither for
>> read-only nor for write. That's what makes me suspect that it's
>> something in my Windows configuration that is causing the problem.
>> I hope someone who is doing what I'm trying to do can help me
>> understand where I'm going wrong with my Windows sharing settings.
>> On Wed, Apr 21, 2010 at 1:39 PM, M Prindle <mprindle at pobox.com> wrote:
>>> GNUCash is a single user system only and it's not dependent on the OS.
>>> One one person can have the database open at at time. Both computers
>>> can access the database, but separately. As far as I know there is no
>>> way around this currently. The message unable to obtain lock is
>>> GNUCash's way of protecting the database while it's open.
>>> On Wed, Apr 21, 2010 at 12:08 PM, Phillip Richcreek
>>> <pwrichcreek at gmail.com> wrote:
>>>> I want to access gnucash accounts from two computers, with both
>>>> having read/write access. When I open the database I get message
>>>> "gnucash could not obtain the lock for \\Dell-8250-den\network shared
>>>> files\GnuCash\Account Database". I choose the option to "open the
>>>> database for read only" and the accounts show up as expected -- so I
>>>> know I'm able to access the desired file, but apparently for
>>>> I suspect that this is a Windows issue, but I wonder if anyone
>>>> subscribed here has experience with this configuration and if so, can
>>>> help me understand what I need to change in my Windows sharing setup?
>>>> I'm running Windows/XP SP3 with all patches up to date.
>>>> gnucash-user mailing list
>>>> gnucash-user at gnucash.org
>>>> Please remember to CC this list on all your replies.
>>>> You can do this by using Reply-To-List or Reply-All.
gnucash-user mailing list
gnucash-user at gnucash.org
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
More information about the gnucash-user