Backend problem
Jazzwineman
gatwickdp at britmail.net
Tue Jan 24 00:25:16 EST 2017
as simply as I can make it- The program and files are on ubuntu. He is making a mirror to a win10 machine. On the ubuntu machine he mounts via terminal the networked drive from the win 10 machine that holds the exact same files as a mirror to the ubuntu machine. He attempts to open the data files from the win 10 machine with the gnucash program on a ubuntu machine- the backend error occurs. This does not happen if ubuntu machine opens files from its local drive. This does not happen if the ubantu machine attaches in the network to another ubuntu machine or the one win xp machine he has. I tried and this was only a test from my part and does not indicate anything he will do- but purely a reverse test on my part and if too much info or confusing- forget this part. The win 10 machine will open with a win 10 program the mirrored gnucah files that were backed up to the machine. The win 10 machine will open gnucash files from a mapped-mounted ubuntu machine. The only thing that does not work is the ubuntu machine trying to open the data files stored a a mirror on the win 10 machine. I do not know the format and will tomorrow, but in my humble view- if the files open under all other conditions, why would the format even make a difference. If giving you the name of the files somehow explains why the ubuntu machine gets a backend error from open the files on win 10 then I will get every file name and post. --- 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 20:36:01 -0600 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 at 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
http://www.britmail.net - The easy to remember, truly British email address http://www.britstuff.net - your one stop portal for all things British
--
View this message in context: http://gnucash.1415818.n4.nabble.com/Backend-problem-tp4689079p4689162.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
More information about the gnucash-user
mailing list