[GNC] [MAINT] Planned server reboot Monday, Dec 7, 8:00pm US/EST
TL;DR: Unless I hear major objections, I plan to reboot the VM server tomorrow, Monday, Dec 7, around 8pm US/EST (0100 UTC Dec 8), in order to refresh / update some certificates. Please let me know if this is an issue. Long Version: The GnuCash infrastructure uses a single-host OVirt VM platform for its production system. Unfortunately, this means that certain system maintenance efforts require system reboots, and, unfortunately, replacing the certificates is one of those. All the new certificates are in place so I should just need to reboot the system to allow it to take effect. The reason for the certificate update is two-fold: 1) Many of the certificates were set to expire next year (2021), so they would have to be renewed anyway. Granted, this date was November 1, so I had most of the year to do it, but still, it had to be done within the next 11 months. 2) More importantly, the certificates were all using SHA1, and this was causing problems with e.g. remote-viewer complaining that the certificates were not secure. This is JohnR and, after I update my own system this weekend, me. If I had a multi-server Ovirt setup (e.g. 3 hosts), then I could round-robin update them. I migrate all the running VMs to the other two hosts and then I can safely take the third host down and do whatever I needed. Then I bring it up again, let everything stabilize, and then move to the next one. Alas, with a single host, I can't do this so I need to reboot. total downtime should be no more than 30 minutes, assuming of course I got everything right. Also, I am *hoping* this will fix the remote-viewer issue, but I won't know for sure until after I reboot. If you all have any questions, concerns, or the timing is bad, please let me know. Thanks! -derek PS: For John, Frank, Geert, etc -- due to the certificate changes you will need to remove the old certificates from your browser trusted-cert cache first and then import the new ones. Search for IHTFP. If you don't remove it, it'll give you an error that the certificate changed but has the same Issuer/Serial#. I'm sorry, but there's nothing I can do about that. -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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: [GNC] Error with Asset Chart report
If I had to guess, the observed phenomena here result when the code is required to probe below this setting, so if you don't get to the seventh circle of accounting hell, you won't see it. What has me confused is that the setting is clearly, obviously available to me-- even on the stock Asset Chart report. And if I can select it, I shouldn't receive an error choosing it. (Never mind how remarkably cryptic this message is!) As I mentioned last year, I wonder whether Windows is using a 1-7 list, while *nix platforms (OsX is one of those) count them as 0-6. I can't imagine why else this error would crop up. It would be nice if someone else on Windows could try to replicate the error. Original Message From: Adrien Monteleone Sent: Sun Dec 06 15:22:14 EST 2020 To: gnucash-u...@lists.gnucash.org Subject: Re: [GNC] Error with Asset Chart report I have about a dozen or more level-6 asset accounts. I don't have anything greater than level-6. Can you reproduce if you try level-All? (there'd still be a bug in the level-6 option of course) Regards, Adrien On 12/6/20 2:17 PM, D. via gnucash-user wrote: > Adrien, > > Does your CoA have accounts deep enough to trigger level 6? I can trigger the > error consistently whenever I select a set of accounts that includes accounts > below the sixth, and then make it go away simply by selecting accounts that > don't range below that depth. ___ 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. ___ 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: [GNC] Error with Asset Chart report
I have about a dozen or more level-6 asset accounts. I don't have anything greater than level-6. Can you reproduce if you try level-All? (there'd still be a bug in the level-6 option of course) Regards, Adrien On 12/6/20 2:17 PM, D. via gnucash-user wrote: Adrien, Does your CoA have accounts deep enough to trigger level 6? I can trigger the error consistently whenever I select a set of accounts that includes accounts below the sixth, and then make it go away simply by selecting accounts that don't range below that depth. ___ 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: [GNC] Error with Asset Chart report
Adrien, Does your CoA have accounts deep enough to trigger level 6? I can trigger the error consistently whenever I select a set of accounts that includes accounts below the sixth, and then make it go away simply by selecting accounts that don't range below that depth. David Original Message From: Adrien Monteleone Sent: Sun Dec 06 14:00:54 EST 2020 To: gnucash-u...@lists.gnucash.org Subject: Re: [GNC] Error with Asset Chart report Still using 4.1 here (on MacOS), but sorry to say, I can't repeat the error. The Asset Chart works for me just fine with any accounts selected (all Assets are by default) and with any level selected. Regards, Adrien On 12/5/20 12:10 PM, David T. via gnucash-user wrote: > Hello, > > I am on Windows 10, using Version: 4.2 > Build ID: git 4.2-213-g562b4be22+(2020-11-21) > > Back in June 2019 > (https://lists.gnucash.org/pipermail/gnucash-user/2019-June/085636.html), I > reported a problem with an odd error in a saved report. After some back > and forth, I don't believe that any resolution occurred, and I have > re-encountered the error. > > This time, I am using the stock Asset Chart report, and again I > encounter the nonsensical error repeatedly: > > "This report was saved using a later version of GnuCash. One of the > newer multichoice options '7' is not available, fallback to the option > '2'." > > Testing reveals that this error is referring to the fact that I am > selecting the "Show Accounts until level" to use the provided value of > '6' (which is the seventh option in the list, which includes All and > 1-6). It pops up numerous times when I run the report, presumably > because it iterates through the accounts and barfs each time it gets to > a sixth-level account. > > This error is nonsensical because: > > 1) I am invoking the report from the Report menu for the first time in > THIS version of GnuCash; there are no saved versions of the report > > 2) There are no newer versions of GnuCash that I have run on my machine, > and > > 2) I am SELECTING THE VALUE THAT IS PROVIDED IN THE REPORT OPTIONS. > > This error can easily be replicated; just open the base GnuCash Asset > Chart (Report->Assets & Liabilities->Asset Chart), select some accounts, > and choose '6' in the "Show Accounts until level" drop down. The error > will then trigger. > > If there is a simple hack I can apply to remove this error, I'd > appreciate knowing it. As it stands, the result is annoying, and the > fact that it is embedded in the GnuCash-supplied report is problematic. > > David T. ___ 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. ___ 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: [GNC] Silly font question?
Are you using a custom CSS file? If so, your preferred font may not be present and is being substituted. If you are not using one, you can choose to do so. See the wiki FAQ about customizing fonts. Regards, Adrien On 12/5/20 12:27 PM, Carlo Pelandini wrote: I just upgraded to GnuCash v. 4.2 from v. 3.1 on Windows 10. In version 3.1, my Register font was bold (and I’m guessing) Arial 12 point. In version 4.2, it seems to have defaulted to some unknown 8 point font. I cannot find any Help manual or Wiki subject that describes how to change the Register fonts on Windows 10, other than referencing the Display settings under User Access. Since these settings do not tell you what the font is (Thanks Windows for making things so obtuse) – only the magnification, I do not know what my default settings really are. So, how do I set default Register fonts in GnuCash on my Windows 10 OS? Carlo ___ 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: [GNC] Error with Asset Chart report
Still using 4.1 here (on MacOS), but sorry to say, I can't repeat the error. The Asset Chart works for me just fine with any accounts selected (all Assets are by default) and with any level selected. Regards, Adrien On 12/5/20 12:10 PM, David T. via gnucash-user wrote: Hello, I am on Windows 10, using Version: 4.2 Build ID: git 4.2-213-g562b4be22+(2020-11-21) Back in June 2019 (https://lists.gnucash.org/pipermail/gnucash-user/2019-June/085636.html), I reported a problem with an odd error in a saved report. After some back and forth, I don't believe that any resolution occurred, and I have re-encountered the error. This time, I am using the stock Asset Chart report, and again I encounter the nonsensical error repeatedly: "This report was saved using a later version of GnuCash. One of the newer multichoice options '7' is not available, fallback to the option '2'." Testing reveals that this error is referring to the fact that I am selecting the "Show Accounts until level" to use the provided value of '6' (which is the seventh option in the list, which includes All and 1-6). It pops up numerous times when I run the report, presumably because it iterates through the accounts and barfs each time it gets to a sixth-level account. This error is nonsensical because: 1) I am invoking the report from the Report menu for the first time in THIS version of GnuCash; there are no saved versions of the report 2) There are no newer versions of GnuCash that I have run on my machine, and 2) I am SELECTING THE VALUE THAT IS PROVIDED IN THE REPORT OPTIONS. This error can easily be replicated; just open the base GnuCash Asset Chart (Report->Assets & Liabilities->Asset Chart), select some accounts, and choose '6' in the "Show Accounts until level" drop down. The error will then trigger. If there is a simple hack I can apply to remove this error, I'd appreciate knowing it. As it stands, the result is annoying, and the fact that it is embedded in the GnuCash-supplied report is problematic. David T. ___ 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: [GNC] GNU Cash on a Central Computer
While GnuCash can use MySQL (as well as Postgres and SQLite) as a backend, the entire db is read into memory at start-up, rather than separate records being accessed like a normal db-based app. Thus, it is not currently set up to do what you are looking for, but that is a (very) long term goal. There are some other answers in this thread that explain how to work around this, somewhat, for now. Regards, Adrien On 12/4/20 11:30 AM, Mike Brady. wrote: Good point. Can GnuCash work as a front end to a database that does record locking, such as MySQL? Otherwise, how would work done by multiple other users on their copies of the data be safely merged into a single master file? It's clear, though, that GnuCash is designed mainly for single users. A company big enough to have multiple bookkeepers and accountants, needing access to the data at the same time, may need different software. ___ 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: [GNC] Silly font question?
LMGTFY: font-weight: bold; The link worked fine for me just now. Regards, John Ralls > On Dec 6, 2020, at 8:24 AM, Carlo Pelandini wrote: > > John: > Thanks for info on gtk.css file. That seems to have worked, except I cannot > get a bold font to show up. Is there another line to include that makes it > bold? > I tried your link to issue 1774, but came up with “404 page not found error”. > Was it perhaps another issue number? > > Carlo > > From: John Ralls > Sent: Saturday, December 5, 2020 6:04 PM > To: Carlo Pelandini > Cc: gnucash-user@gnucash.org > Subject: Re: [GNC] Silly font question? > > F > > > > > This email has been checked for viruses by AVG antivirus software. > www.avg.com > > > ___ 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: [GNC] Silly font question?
John: Thanks for info on gtk.css file. That seems to have worked, except I cannot get a bold font to show up. Is there another line to include that makes it bold? I tried your link to issue 1774, but came up with “404 page not found error”. Was it perhaps another issue number? Carlo From: John Ralls Sent: Saturday, December 5, 2020 6:04 PM To: Carlo Pelandini Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Silly font question? F -- This email has been checked for viruses by AVG. https://www.avg.com ___ 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.
[GNC] Charts not showing up correctly for multicolumn view
Hello all, I've been using Gnucash for a few years now, but I've never been able to use the different stylesheets as it always messed up my line/bar/charts. Only the default one was able to plot them in the right aspect ratio. I took the plunge and upgraded from 3.5 to 4.2 on win10 yesterday and all my multicolumn dashboards are not non-visible even with the default stelysheet. The Default with show like this, overextending the columns: [image: image.png] While the Easy will look like this: [image: image.png] Any ideas what I might be doing wrong or how to fix this? Don't have this issue if I run it via ubuntu on wsl2, but I can't upgrade to 4.2 on it. I've spent a lot of time building these dashboards and i'd like to get them back to being functional. Thank a lot, Christos ___ 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: [GNC] GNU Cash on a Central Computer
Randix, Be careful here Your gnucash file should be named something along the lines of 2020-12-Dec.gnucash These files with date and time embedded in the name are backup files - it seems like you opened a backup file from Dec 5 and worked on it at some stage??? 2020-12-Dec.gnucash.20201205100356.gnucash 2020-12-Dec.gnucash.20201205073851.gnucash Liz, you beat me to it by about a minute. Regards David H. On Sun, 6 Dec 2020 at 17:21, randix wrote: > Nelson... although I have GnuCash installed on 2 separate laptops, I only > actively use GnuCash on one laptop (with the data regularly backed up on an > external drive). The other laptop installation is just in case my primary > laptop crashes (and I could then copy one of the backed up data files for > it). > > I have no need to regularly access the GnuCash data file from 2 different > sources, however, just out of curiosity as I've seen the dropbox usage > referenced not infrequently here... When I save my GnuCash it does not > write the same file name each time, eg > > 2020-12-Dec.gnucash.20201205100356.gnucash > 2020-12-Dec.gnucash.20201205073851.gnucash > etc. > > So, for example. > 1. I save GnuCash data on Laptop 1. The save goes to my dropbox directory. > 2. On Laptop 2, I open up the saved GnuCash data file from the dropbox > directory. > 3. All is good. > 4. Then on Laptop 1 I open up GnuCash, and it defaults to the last saved > file. I work on it. Then save it. > 5. All is good > 6. But when I later open up GnuCash on Laptop 2, it's going to > automatically > load the last saved file which will not be the latest file which has a > different name. > 7. So are you saying when you use dropbox in conjunction with GnuCash, the > user has to go to the dropbox directory, and manually load the last saved > file after looking at the saved dates, to make sure it's not loading an > older saved file? > > Hope that's clear. Thanks. As I say, just curious. > > > > > > > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > 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. > ___ 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: [GNC] GNU Cash on a Central Computer
On Sat, 5 Dec 2020 12:16:13 -0600 (CST) randix wrote: > When I save my GnuCash it does not > write the same file name each time, eg > > 2020-12-Dec.gnucash.20201205100356.gnucash > 2020-12-Dec.gnucash.20201205073851.gnucash > etc. You have a problem. You are working on backups. https://wiki.gnucash.org/wiki/FAQ#Q:_Why_is_my_file_name_getting_longer_and_longer.3F > 7. So are you saying when you use dropbox in conjunction with > GnuCash, the user has to go to the dropbox directory, and manually > load the last saved file after looking at the saved dates, to make > sure it's not loading an older saved file? > > Hope that's clear. Thanks. As I say, just curious. When you can work out why you are using backup files, this problem will "go away". Liz ___ 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.