Backend problem

David Carlson david.carlson.417 at gmail.com
Mon Jan 23 21:36:01 EST 2017 

I am still a little confused.  I think part of the trouble is that you are
not the person who has the problem.  First you talk about opening a file
that resides on a Windows 10 machine from a Ubuntu machine then you turn it
around and talk about opening a file that resides on an unknown machine
from a windows 10 machine and you still have not stated what file format
the data is stored in, which could be crucial to solving the problem
because AFIK Gnucash only throws a backend error when failing to open a
database file.

I can (and do) run GnuCash on a Windows 10 machine or on a Windows 7
machine or on a Ubuntu machine or on a Debian machine all working on the
same data file that is stored on yet another machine on my network which
has a different OS on it.

Chris is also trying to help, but neither of us is getting to the root of
your client's problem.

David C

On Mon, Jan 23, 2017 at 6:57 PM, GatwickDP <gatwickdp at britmail.net> wrote:

> might be as I do not use gnucash. The user will mount the drive (win 10)
> from Ubuntu and set permissions and log in. All the folders show and are an
> exact mirror from what is on the Ubuntu machine. There are other files-
> such as excel, word and from the Ubuntu machine they all open fine from the
> win 10 machine. Since he has used this on the ubuntu machine in normal
> operation, I assume he must have the database  engine on the ubuntu machine
> or it would not work? He is doing pretty much what you are doing except
> trying to open files from a win 10 machine. This is clearly experimental
> for him to see what he has to do for the future as well as the present.
>
> --- david.carlson.417 at gmail.com wrote:
>
> From: David Carlson <david.carlson.417 at gmail.com>
> To: gatwickdp at britmail.net
> Cc: Colin Law <clanlaw at gmail.com>, "gnucash-user at gnucash.org" <
> gnucash-user at gnucash.org>, ml-node+s1415818n4689095h13 at n4.nabble.com
> Subject: Re: Backend problem
> Date: Mon, 23 Jan 2017 18:01:52 -0600
>
> GatwickDP, Your answer is too vague for people here to help you.
>
> If the client is running GnuCash 2.6.11 in 32 bit Ubuntu 12.04 like I am,
> and the data file(s) are on a different machine on the LAN like mine are,
> it might be necessary to use the file browser to navigate to the LAN
> resource to log in to and mount that resource to find the desired file.
> Then double-clicking on that file will open it.  In my case, I use data
> files in the compressed XML format which has the file suffix .gnucash.  I
> think that it would work the same way if your client uses one of the
> database formats, but I am not sure because I do not use any of them.  The
> only other requirement would be to have the database engine installed in
> the Ubuntu computer.  If it does not work for your client, the problem may
> be in user technique rather than program capability.
>
> By the way, I am currently testing 64 bit Ubuntu 16.04 to see if it will
> work on the computer that currently has the 32 bit release 12.04 on it.  So
> far, the newer Ubuntu will run the programs that I use most frequently,
> albeit newer releases of many of them.  I doubt that the OS being 32 bit or
> 64 bit makes any difference to the vast majority of users.
>
> David C
>
> On Mon, Jan 23, 2017 at 5:31 PM, GatwickDP <gatwickdp at britmail.net> wrote:
>
> any of the files that contain the data of accounts.
>
> --- clanlaw at gmail.com wrote:
>
> From: Colin Law <clanlaw at gmail.com>
> To: gatwickdp at britmail.net
> Cc: "David T." <sunfish62 at yahoo.com>,   "gnucash-user at gnucash.org" <
> gnucash-user at gnucash.org>, ml-node+s1415818n4689095h13 at n4.nabble.com
> Subject: Re: Backend problem
> Date: Mon, 23 Jan 2017 20:23:03 +0000
>
> On 23 January 2017 at 14:16, GatwickDP <gatwickdp at britmail.net> wrote:
> > This is for a client. His office is currently using ubantu. He would
> have liked to continue with ubantu, but with a 4 yr. lifespan that creates
> a problem that he does not want to deal with. Since he makes use of Power
> Term as well and powerterm along with tiny term is not creating future
> access for their product via the Linux or Mac route, that leaves him in a
> position to do a turnover to the horrid windows platform. This is the first
> of these machines that he is testing on what he normally does. In this case
> he wants to create a backup to a machine and if another one goes down then
> he can simply mount this one and go on as if nothing has happened. I
> understand this may be convoluted- however in his filed he has the largest
> medical practice in DFW and makes the most of any MD in his specialty in
> DFW and has about 55 computers spread over 3 offices and home. So since he
> will be moving slowly to Win 10 architecture- this is what he wants. So
> back to the question- the only scenario th
>  at
> >   Gnucash is not working correctly is when from a ubantu machine- you
> open gnucash and pull the files from the mounted win10 machine and get the
> the backend error message.
>
> Which files are you pulling from the windows machine?
>
> It is Ubuntu by the way.
>
> Colin
>
> >
> > --- sunfish62 at yahoo.com wrote:
> >
> > From: "David T." <sunfish62 at yahoo.com>
> > To: gatwickdp at britmail.net
> > Cc: "David Carlson-4 [via GnuCash]" <ml-node+s1415818n4689095h13@
> n4.nabble.com>, gnucash-user at gnucash.org
> > Subject: Re: Backend problem
>
> > Date: Mon, 23 Jan 2017 07:52:49 +0500
> >
> > Since it sounds as if you are trying to use your Win10 machine as a
> glorified backup storage location, as long as the file can be moved to a
> new machine and loaded, what does it matter if you can run it remotely from
> an ubuntu machine?
> >
> >
> >> On Jan 23, 2017, at 4:35 AM, GatwickDP <gatwickdp at britmail.net> wrote:
> >>
> >>   I must be missing something in your suggestion. The original ubantu
> >>   computers that are being used have zero problems with opening any of
> >>   the gnucasf files on them, so apparently the database engine has to be
> >>   correct. Take any of the ubantu machines that have gnucah app on them
> >>   and they can open the files that are local to that machine or on
> >>   another networked ubantu or win xp machine. The exact same files are
> on
> >>   the win 10 machine and only on that machine does the attempt from a
> >>   networked ubantu trying to open the files on the win10  do we get the
> >>   backend error. The files have to be fine when as a test i open then
> >>   with an app native to win 10 and the win 10 app can open any of the
> >>   data files of gnucash on any of the other networked ubantu or winp
> >>   machines . The only problem is that I open gnucash on a ubanu computer
> >>   and by the network try to open the data files that are on win 10.
> Other
> >>   machines See everything fine on win 10 - any other file from any other
> >>   program will open. Only problem is the gnucash. We are trying to use
> >>   win10 as a mirror so that if one of the machines holding a number of
> >>   files and gnucash being only one set, we can just mount the drive from
> >>   win 10 and go down the road.
> >>   --- ml-node+s1415818n4689095h13 at n4.nabble.com wrote:
> >>   From: "David Carlson-4 [via GnuCash]"
> >>   <ml-node+s1415818n4689095h13 at n4.nabble.com>
> >>   To: Jazzwineman <gatwickdp at britmail.net>
> >>   Subject: Re: Backend problem
>
> >>   Date: Sun, 22 Jan 2017 15:11:41 -0800 (PST)
> >>   It sounds like you are keeping your data files in one of the database
> >>   formats but you did not install the database engine in the Ubuntu box
> >>   that
> >>   gives you the error message.
> >>   There is more than one way to solve that problem.  The easiest is to
> >>   switch
> >>   to the default compressed XML data format (.gnucash).   The other is
> to
> >>   install the correct database engine for your data type.  I have never
> >>   done
> >>   the latter myself and the wiki was just reorganized so I cannot find
> >>   the
> >>   reference to look at for instructions.  Hopefully someone who uses a
> >>   database format in Linux will tell us how to do that.
> >>   David C
> >
> >
> >
> >
> >
> > _____________________________________________________________
> > http://www.britmail.net - The easy to remember, truly British email
> address
> > http://www.britstuff.net - your one stop portal for all things British
> > _______________________________________________
> > 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.
>
>
>
>
> _____________________________________________________________
> http://www.britmail.net - The easy to remember, truly British email
> address
> http://www.britstuff.net - your one stop portal for all things British
> _______________________________________________
> 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.
>
>
>
>
> ------------------------------
> http://www.britmail.net - The easy to remember, truly British email
> address
> http://www.britstuff.net - your one stop portal for all things British
>

More information about the gnucash-user mailing list