Sharing Database - Windows/XP

Wed Apr 21 16:44:44 EDT 2010

At Wed, 21 Apr 2010 12:42:32 -0700 (PDT) Phil Longstaff <plongstaff at rogers.com> wrote:

> 
> I don't know if this is related to bug https://bugzilla.gnome.org/show_bug.cgi?id=352491 or not.

I just did some experiments on my Linux box.  GnuCash creates a single
file with *two* names (trivial to do under UNIX with a UNIX-flavored
file system -- just a matter of fun with the link(2) system service). 
The .LCK and .LNK files refer to the *same* inode.  Does MS-Windows let
you do that?  And does the NETBIOS protocol support such magic?

> 
>  Phil
> ---------
> 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
> 
> Mike,
> > ...Does the share directory have full read/write/create permissions on it?
> 
> Yes.
> 
> 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
> read-only.
> 
> 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.
> 
> Phil
> 
> 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:
> >> Mike,
> >>
> >> 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.
> >>
> >> Phil
> >>
> >>
> >> 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.
> >>>
> >>> Mike
> >>>
> >>>
> >>>
> >>> 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
> >>>> read-only.
> >>>>
> >>>> 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.
> >>>>
> >>>> TIA,
> >>>>
> >>>> Phil
> >>>> _______________________________________________
> >>>> gnucash-user mailing list
> >>>> gnucash-user at gnucash.org
> >>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>>> -----
> >>>> 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
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> 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
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 
>                                                                                            

-- 
Robert Heller             -- 978-544-6933
Deepwoods Software        -- Download the Model Railroad System
http://www.deepsoft.com/  -- Binaries for Linux and MS-Windows
heller at deepsoft.com       -- http://www.deepsoft.com/ModelRailroadSystem/