[GNC] GC keeps prompting me to create an account and it just won't away
I must've hit the wrong button somewhere because I keep getting this pop-up, Account ExpenseAccounts:Food:fruits:bananasHot dog 1.99*2 does not exist, would you like to create it, Yes/No?To which I answer, "No" but the pop-up just shows up again!I finally said, "Yes", then canceled the thing. That seems to have fixed the problem. I'm running GC 3.0 Build 2.6.17b-2765-g70e636646+(2018-04-01) under Ubuntu 17.10.This version has sticky fields. I.e., whenever I duplicate transactions, I have to click on the original so I can overwrite the text. Thanks,Art ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Backup help
I just read your message after I sent my previous one. I was using MYSQL master-slave replication with my desktop servers and only running a client my laptop, but after realizing how quick the dump & restore was and how rarely I actually "go mobile", it was easier for me to just do the restore from the dump. However, your point is well taken. Since I already have the MySQL server running on my laptop, I can do a MYSQL master-slave replication. I just didn't think about it. Thanks! - Art On Tuesday, September 19, 2017, 11:28:30 PM EDT, DaveC49 wrote: Hi Art, Roger Just a quick comment. If you are using the MYSQL backend you can sync databases on different machines reasonably easily using MYSQL master-slave replication (https://dev.mysql.com/doc/refman/5.7/en/replication.html) as an alternative to maintaining a mobile copy. There is a bit of a learning curve in setting it up and some maintenance if the databases do get out of sync. I use it on a Linux desktop and my Linux laptop to keep a number of application databases synced using SSL over my LAN. It syncs automatically whenever the laptop is connected to the LAN. I haven't tried syncing from a Linux box to a Windows box but it shouldn't be too much of a problem as it is all done in MYSQL configuration as long as the basic underlying network connectivity is there. There can be timing issues if the databases on different machines are updated at the same time which are not generally a problem for a single user. You can use the TinyCA (https://tinyca.alioth.debian.org/) to generate the necessary SSL certificates. I set MySQL both machines up as master-master servers so that no matter which machine I make changes to the database they are duplicated to the other machine. David Cousens - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@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@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.
Re: Backup help
Yes, a client-server architecture would be simpler and easier for this purpose; however, you wouldn't have the redundancy of a cluster or a mirror (MySQL Master Slave Replication). I did it to learn how to do it, but now I just do a dump and restore of my MySQL db. And I found the transaction logs to be excellent journal files making GC robust enough to not worry about hardware or corruption issues. It only takes a few minutes to restore my database, so I use the dump to sync my laptop (though its just so slow when it's self-serving, but it's standalone so there are no concurrency issues!). - Art On Wednesday, September 20, 2017, 9:40:57 AM EDT, John Ralls wrote: > On Sep 20, 2017, at 1:35 AM, DaveC49 wrote: > > Hi Colin, > > i agree with both you and Bram there. It is not a reliable backup of the > database but really only useful for sharing a database across several > machines and worked well for the use case where my laptop was generally > connected to my LAN and I worked away from home occasionally. haven't had > any experience with how it copes with simultaneous access and locking > issues. There is also the MYSQL Cluster as another approach. You also need > to check that the replication is up to date and completed before assuming > the databases are identical. I use a cron job and mysqldump to dump the > databases to an NAS for backup. Um, wouldn’t it be easier to just use one of the machines as a server and connect to it with GnuCash from the other machines? Regards, John Ralls ___ gnucash-user mailing list gnucash-user@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@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.
Re: Backup help
I'm not familiar with "WinDrive". My 5TB USB drive is Seagate Backup Plus formatted to NTFS with a GPT (to handle drives larger than 2TB). Since you said you could see the files from the first machine, the data was likely there. If you cannot see any files on the same drive from the second machine, I'd get another Windows 10 machine to see if it can read any files on the same drive. If not,the "WinDrive" is suspect. BTW, I also have a 2TB drive powered by the USB port - that device occasionally fails if the host cannot power the drive, i.e., the port can't handle the 500 mA peak demand from the drive, so it disconnects and the data corrupts. It's a nuisance, but it works most of the time. I generate checksums for my critical files so I can just destroy corrupt files and get another copy (I keep three copies of all my critical stuff). - Art On Friday, September 15, 2017, 7:21:13 PM EDT, Roger Oliver wrote: Windows 7 and 10. Mostly interested in a backup copy off the main computer in case it crashes. Mine did, the Windows 10 machine. All my GC data was restored from the Carbonite backup. Grateful it worked. The 7 machine is at the school dedicated to accounting. I think there is something wrong with the WinDrive external hard drive. Thanks! On Sep 15, 2017 6:08 PM, "Art" wrote: What are the OSes on the source and target computers?What is the external hard disk filesystem and how do you know it's compatible with both computers? I assume you are able to run GC on both computers, hence the point of copying the db to the second one. E.g., I routinely archive my db from my Ubuntu 17.04 machine to a 5TB USB drive so I can restore it to my Windows 10 laptop when I'm on the road and vice versa to sync my backup repository. - Art On Friday, September 15, 2017, 6:13:36 PM EDT, Roger Oliver wrote: I can't seem to get the GnuCash files to back up to an external hard disk. The files show that they are there but when I try to find them on another computer to have a copy off site, the files are not there. What am I doing wrong? Thanks, Roger Oliver __ _ gnucash-user mailing list gnucash-user@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@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.
Re: Backup help
What are the OSes on the source and target computers?What is the external hard disk filesystem and how do you know it's compatible with both computers? I assume you are able to run GC on both computers, hence the point of copying the db to the second one. E.g., I routinely archive my db from my Ubuntu 17.04 machine to a 5TB USB drive so I can restore it to my Windows 10 laptop when I'm on the road and vice versa to sync my backup repository. - Art On Friday, September 15, 2017, 6:13:36 PM EDT, Roger Oliver wrote: I can't seem to get the GnuCash files to back up to an external hard disk. The files show that they are there but when I try to find them on another computer to have a copy off site, the files are not there. What am I doing wrong? Thanks, Roger Oliver ___ gnucash-user mailing list gnucash-user@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@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.
Re: Re: GC 2.6.99 built from git rev d96bb3ebd+ corrupts MySQL db
It reports that it's corrupt when I attempt to save a valid XML db to MySQL and in fact it is, as verfied through the MySQL workbench. However, I just downloaded 2.6.17 source from the GC web site and it works perfectly! Somehow git cloning 2.6.99 is not the right thing to do. Oops. Thank you, though I was looking forward to some down and dirty source code and API troubleshooting. - Art On Wednesday, September 6, 2017, 5:11:45 PM EDT, Colin Law wrote: On 6 September 2017 at 22:04, Art via gnucash-user wrote: > ... > ...So I assumed it should be working, but as soon as I do a file open on my > db, I get a pop-up, The server at URL mysql://root@localhost/gc2017 > experienced an error or encountered bad or corrupt data. > When I look at the db with the workbench I notice that the "accounts" table > has been backed up to "accounts_back" and the "accounts" table now has two > records with field name "Root Account", account_type="ROOT" with a guid > field. At this point, the db is corrupt. I don't want to revert to GC 2.6.15 > if I can fix this. I want to keep using MySQL and I can't just save an XML to > MySQL because it also reports that the db is corrupt. So, I must be making a > fundamental mistake or series thereof because I haven't heard anyone else > complain about any issues with the MySQL backend. Maybe I'm pulling the wrong > version? I am only using git at this point to get the source code. What happens if you save to a mysql db of a different name (or delete the current db first)? Colin ___ gnucash-user mailing list gnucash-user@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.
GC 2.6.99 built from git rev d96bb3ebd+ corrupts MySQL db
I built it under Ubuntu 17.04 after a git download with, ./configure --enable-dbi --prefix=/opt/gnucash-devel --enable-compile-warnings --with-html-engine=webkit --enable-ofx Options detected/selected - gnucash version .. : 2.6.99 Build for host ... : x86_64-pc-linux-gnu Optional components... : dbi ofx Extra Warnings ... : -Werror -Wdeclaration-after-statement -Wno-pointer-sign -D_FORTIFY_SOURCE=2 CPPFLAGS . : CFLAGS ... : -g -O2 -std=gnu11 CXXFLAGS . : -g -O2 LDFLAGS .. : prefix : /opt/gnucash-devel XML works fine, but the MySQL db now gets corrupted. It was working fine with GC v2.6.15.I am not familiar enough with the backend dbi to troubleshoot, but I see that,/tmp/gnucash.trace:* 16:51:34 INFO [gnc_hook_lookup] no hook lists * 16:51:35 INFO [gnc_module_init_backend_dbi] GNC_DBD_DIR not set: using libdbi built-in default * 16:51:35 INFO [gnc_module_init_backend_dbi] 1 DBD drivers found * 16:51:35 INFO [gnc_module_init_backend_dbi] Driver: mysql * 16:51:36 MESSG Could not locate optional module gnucash/import-export/aqbanking interface v.0 * 16:51:40 MESSG Could not locate optional module gnucash/python interface v.0 * 16:51:40 MESSG loading system configuration ...So I assumed it should be working, but as soon as I do a file open on my db, I get a pop-up, The server at URL mysql://root@localhost/gc2017 experienced an error or encountered bad or corrupt data. When I look at the db with the workbench I notice that the "accounts" table has been backed up to "accounts_back" and the "accounts" table now has two records with field name "Root Account", account_type="ROOT" with a guid field. At this point, the db is corrupt. I don't want to revert to GC 2.6.15 if I can fix this. I want to keep using MySQL and I can't just save an XML to MySQL because it also reports that the db is corrupt. So, I must be making a fundamental mistake or series thereof because I haven't heard anyone else complain about any issues with the MySQL backend. Maybe I'm pulling the wrong version? I am only using git at this point to get the source code. Thanks,Art ___ gnucash-user mailing list gnucash-user@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.