Re: Backup help
Just to point out that database replication might not be considered a good form of backup. It copes with something like a disc crash but if, for example, a user or bug were accidentally to delete large sections of the db then that deletion would be copied to the slave database. Unless I misunderstand how replication works. Colin On 20 September 2017 at 04:27, 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
Colin, You've got that correct. Replication, just like e.g. RAID protects against some forms of data loss but it is not a full backup solution. It could be part of it though, e.g. if running a more permanent backup from the slave is easier than running it on the master. MySQL/MariaDB have specific commands to create backups, look at mysqldump for details. As with all backups: it is important to test not only the backup part but also the part of restoring it. Depending on the options you set with mysqldump the recovery part differs. E.g. You may need to make sure you have a backup of the mysql user's passwords, which is a separate task. Regards Bram On Wed, Sep 20, 2017 at 9:59 AM Colin Law wrote: > Just to point out that database replication might not be considered a > good form of backup. It copes with something like a disc crash but if, > for example, a user or bug were accidentally to delete large sections > of the db then that deletion would be copied to the slave database. > Unless I misunderstand how replication works. > > Colin > > On 20 September 2017 at 04:27, 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. > ___ 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
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. David - 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.
Re: GnuCash on ArchLinux
Hey John Do you know when is it going to happen when 2.8 is released? Problem is that none of the tips other guys suggested worked and in the meanwhile i found some other free accounting software but i still would like to test gnucash at some point. B.wishes Andres -- Securely sent with Tutanota. Claim your encrypted mailbox today! https://tutanota.com 16. Sep 2017 02:47 by jra...@ceridwen.us: > > >> On Sep 13, 2017, at 2:16 PM, >> ala...@tuta.io>> wrote: >> >> I have installed all the other programs with just this one command - sudo >> pacman -S xxx and seems like you are telling me that everything is fine with >> gnucash :) It even works on my Android tablet with no problem, but I find is >> easier to work with real keyboard. >> >> Is it not possible to fix it so that people can install it on Linux just >> with this one command? Seems like it is getting complicated.. > > Sure, if the Linux distribution you use supports GnuCash. Arch has decided > not to, so you can either jump through the extra hoops they require, switch > to a distro that does, or switch to an accounting package that Arch does > support. > > Distros dropping GnuCash is due to our use of the WebKit1 API long after its > best-by date. GnuCash 2.8 will use WebKit2 and we expect that the distros > that have dropped support will restore it when 2.8 is released. > > 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.
Re: Backup help
> 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.
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 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: Deleting an invoice or credit
John Morris writes: >> But you can edit it, including changing the customer involved and the >> invoice number. So the next time you need an invoice or credit note, you >> can just reuse this practice one instead of generating a new one. > > The only problem with this idea is that some ways of finding an > invoice do not notice the change in the invoice number. Therefore, > when I reuse an invoice like this, I have to remember that I won't > always be able to find the new invoice by invoice number. What doesn't notice it? That would be a bug. > Best, > John > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory Member, MIT Student Information Processing Board (SIPB) URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH warl...@mit.eduPGP key available ___ 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: Deleting an invoice or credit
writes: > Got it. Thanks. Being able to delete an invoice/credit note would be a > nice feature to see someday. > > > > Is there a register where you can see all the invoices or do you have > to look for them one at a time? There is no register, but you can search for "all" of them: Business -> Customer -> Find Invoice [InvoiceID] [Matches Regex] . Yes, that is a regex of a single period. That will bring up a list of all invoices. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory Member, MIT Student Information Processing Board (SIPB) URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH warl...@mit.eduPGP key available ___ 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: Deleting an invoice or credit
Hi Derek, I'm noticed the problem in the Easy Invoice report in the past. I don't have time right now to confirm the problem still exists. Given the current state of development, I have no confidence that the problem has been eliminated. Best, John > On Sep 20, 2017, at 10:33 AM, Derek Atkins wrote: > > John Morris writes: > >>> But you can edit it, including changing the customer involved and the >>> invoice number. So the next time you need an invoice or credit note, you >>> can just reuse this practice one instead of generating a new one. >> >> The only problem with this idea is that some ways of finding an >> invoice do not notice the change in the invoice number. Therefore, >> when I reuse an invoice like this, I have to remember that I won't >> always be able to find the new invoice by invoice number. > > What doesn't notice it? That would be a bug. > >> Best, >> John > >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > > -derek ___ 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.
budget
I'm trying to wrap my head around the budget. I'm stuck on the carry over each month. Does this value go in the 'budget available' the next month AND the income to be spent the next month. Or, just in the income the next month. I don't think gnucash accounts for any of this, was trying to work it out on a spreadsheet and then once I figure it out, was going to see how I can add it into the budget. D ___ 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: Multiple Views Of Data
Switching from QuickBooks to GnuCash. Q: Is there any facility in GnuCash that allows you to create multiple views (reports, etc) of your financial data? In QuickBooks you can use what they call a "Class" to provide an alternate grouping of records that can be used in reports. What would be even better would be the ability to assign a set of keywords to data items (transaction, etc) that could then be used in reports to look at the same item from multiple viewpoints (jobs, projects, localities, financing streams, material lots, etc). Does anything like this exist in GnuCash or is anything along these lines in the works? Regards, -- -chaz Charles Sliger c...@bctonline.com "No matter where you go... There you are... Buckaroo Banzai" ___ 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
On Wed, 2017-09-20 at 06:31 -0700, 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? John, It is easier for the general use case where the two computers remain internet connected at all times to just use a server. Like Art I set it up half to explore database replication and half to solve a problem of being able to just pick up my laptop and go. I prefer to develop in a desktop environment but had the need to demo app development to clients away from home without easy internet access and sometimes continue development while I was away from home. I did not have my desktop setup as a server and for various reasons didn't want to. Using replication to sync the databases meant I could just pickup the laptop and go without having to copy database files from one machine to the other specifically. I also keep my home directories synced across the two machine. With the development of mobile apps with in built databases with a need to be synced with a central database but where internet access is not continuous but database access is required when not connected there is a perfect use case. There are collision problems with multiple users particularly and as replication is asynchronous the database copy can get out of sync. I can't claim any great expertise but there are people addressing those problems. The main beauty of it is that it runs totally independently of any app accessing the database. The distributed database aspect is also interesting as any failed copy can be restored from any still working copies giving the RAID like redundancy mentioned earlier in the thread > > 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.
Re: Backup help
I use gnucash on linux with postgres as the database. Usually, I shutdown/switch-off my PC during night time. I have a shutdown script that a) dumps all databases do a second harddrive and then b) copies them to an USB stick attached to a raspberrypi in the network. If someone doesn't switch off her/his computer often a cron script running at night could do the same. For other data I sync certain directories to an encrypted file system on Dropbox. But don't want to do that for the gnucash database (37 MB). Cheers, Klaus On Wed, 20 Sep 2017 08:58:24 +0100 Colin Law wrote: > Just to point out that database replication might not be considered a > good form of backup. It copes with something like a disc crash but if, > for example, a user or bug were accidentally to delete large sections > of the db then that deletion would be copied to the slave database. > Unless I misunderstand how replication works. > > 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.
Re: GnuCash: Multiple Views Of Data
Hi Charles, Take a look at report options and customization. https://www.gnucash.org/docs/v2.6/C/gnucash-guide/ch_reports.html You can setup specific options for a report and then save it for future use. David - 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.
Re: budget
The budget for an account for a specific month is simply an estimate of the amount of money you expect to receive or spend in that account. Let's assume it's an expense account. If you don't spend as much as you expect, you can reduce it and increase another account's budget, so that the total budget for the month is unchanged. If you want, you can reduce it and increase a later month's budget. That would reduce the budget for one month and increase it for another. There is no automatic carry over. On Wed, Sep 20, 2017 at 1:00 PM, Dennis Powless wrote: > I'm trying to wrap my head around the budget. I'm stuck on the carry over > each month. Does this value go in the 'budget available' the next month > AND the income to be spent the next month. Or, just in the income the next > month. I don't think gnucash accounts for any of this, was trying to work > it out on a spreadsheet and then once I figure it out, was going to see how > I can add it into the budget. > > D > ___ > 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.
