2020-07-03 GnuCash IRC logs
00:02:34 *** jralls_laptop has joined #gnucash
00:07:51 *** lmat has quit IRC
00:09:06 *** lmat has joined #gnucash
00:10:55 *** angel has joined #gnucash
00:11:46 *** jralls_laptop has quit IRC
00:11:50 *** jralls_laptop has joined #gnucash
00:12:13 *** jralls_laptop has joined #gnucash
00:12:35 *** jralls_laptop has joined #gnucash
00:12:58 *** jralls_laptop has joined #gnucash
00:13:16 *** jralls_laptop has quit IRC
00:13:20 *** jralls_laptop has joined #gnucash
00:13:43 *** jralls_laptop has joined #gnucash
00:14:05 *** jralls_laptop has joined #gnucash
00:14:28 *** jralls_laptop has joined #gnucash
00:14:33 *** Mechtilde has joined #gnucash
00:14:46 *** jralls_laptop has quit IRC
00:14:50 *** jralls_laptop has joined #gnucash
00:15:08 *** jralls_laptop has quit IRC
00:15:13 *** jralls_laptop has joined #gnucash
00:15:35 *** jralls_laptop has joined #gnucash
00:15:58 *** jralls_laptop has joined #gnucash
00:16:20 *** jralls_laptop has joined #gnucash
00:16:38 *** jralls_laptop has quit IRC
00:16:43 *** jralls_laptop has joined #gnucash
00:17:05 *** jralls_laptop has joined #gnucash
00:17:23 *** jralls_laptop has quit IRC
00:41:15 *** jralls_afk has joined #gnucash
00:41:15 *** ChanServ sets mode: +o jralls_afk
00:42:06 *** jralls has quit IRC
01:01:52 *** angel has quit IRC
01:02:11 *** sbluhm has joined #gnucash
01:02:11 *** ChanServ sets mode: +v sbluhm
01:11:57 *** sbluhm has quit IRC
01:28:20 *** sbluhm has joined #gnucash
01:28:20 *** ChanServ sets mode: +v sbluhm
01:30:46 *** Hirppa has joined #gnucash
01:31:08 *** sbluhm has quit IRC
01:34:39 *** lmat has quit IRC
01:35:35 *** sbluhm has joined #gnucash
01:35:36 *** ChanServ sets mode: +v sbluhm
01:36:21 *** lmat has joined #gnucash
01:38:09 *** sbluhm has quit IRC
01:41:35 *** sbluhm has joined #gnucash
01:41:36 *** ChanServ sets mode: +v sbluhm
01:42:15 *** fell has quit IRC
01:43:28 *** Hirppa has left #gnucash
01:43:35 *** fell has joined #gnucash
01:43:35 *** ChanServ sets mode: +o fell
02:00:09 *** Mechtilde has quit IRC
02:23:39 *** anandprabhu has joined #gnucash
02:24:46 *** jervin has joined #gnucash
02:37:46 *** suukim has joined #gnucash
02:55:48 *** lmat has quit IRC
02:58:15 *** lmat has joined #gnucash
03:18:49 *** Mechtilde has joined #gnucash
03:19:26 *** gjanssens has joined #gnucash
03:19:26 *** ChanServ sets mode: +o gjanssens
03:25:17 *** bertbob has quit IRC
03:25:41 *** Mechtilde has quit IRC
03:25:59 *** Mechtilde has joined #gnucash
03:31:59 *** bertbob has joined #gnucash
03:32:00 *** ChanServ sets mode: +v bertbob
03:34:00 *** lmat has quit IRC
03:35:15 *** lmat has joined #gnucash
03:39:28 *** lmat has quit IRC
03:40:46 *** lmat has joined #gnucash
03:45:41 *** Mechtilde has quit IRC
03:48:59 *** Mechtilde has joined #gnucash
04:01:15 *** lmat has quit IRC
04:01:58 *** lmat has joined #gnucash
04:05:41 *** Mechtilde has quit IRC
04:15:07 *** anandprabhu has quit IRC
04:52:47 *** User has joined #gnucash
04:55:00 *** lmat has quit IRC
04:58:05 *** lmat has joined #gnucash
05:01:55 *** Aussie_matt has quit IRC
05:15:11 *** Mechtilde has joined #gnucash
05:21:23 *** Mechtilde has quit IRC
06:04:22 *** ramontjunior has joined #gnucash
06:10:09 *** sbluhm has quit IRC
06:28:09 *** sbluhm has joined #gnucash
06:41:48 *** keiffer has quit IRC
06:42:58 *** keiffer has joined #gnucash
06:59:21 *** Mechtilde has joined #gnucash
07:03:26 *** Unhammer has quit IRC
07:23:54 *** User has quit IRC
07:30:33 *** Mechtilde has quit IRC
07:34:08 *** jralls_laptop has joined #gnucash
07:35:19 *** Mechtilde has joined #gnucash
07:36:38 *** David has quit IRC
07:36:44 *** David has joined #gnucash
07:37:08 *** jralls_laptop has quit IRC
07:51:20 *** Jimraehl1 has joined #gnucash
08:15:38 *** lmat has quit IRC
08:15:40 *** lmat has joined #gnucash
08:18:11 *** David has quit IRC
08:18:18 *** David has joined #gnucash
08:28:18 *** puck has quit IRC
08:29:46 *** hussam has quit IRC
08:35:13 *** Unhammer has joined #gnucash
08:35:25 *** puck has joined #gnucash
08:38:23 *** chris has quit IRC
08:56:59 *** chris has joined #gnucash
08:56:59 *** ChanServ sets mode: +v chris
08:59:30 *** David has quit IRC
08:59:37 *** David has joined #gnucash
09:20:39 *** hussam has joined #gnucash
09:20:39 *** ChanServ sets mode: +v hussam
09:31:42 *** jralls_laptop has joined #gnucash
09:37:28 *** jralls_laptop has quit IRC
09:37:32 *** jralls_laptop has joined #gnucash
10:21:59 *** Agfarmer18 has joined #gnucash
10:25:25 *** User has joined #gnucash
10:29:52 *** Agfarmer18 has quit IRC
10:30:06 *** storyjesse has joined #gnucash
10:33:45 *** storyjesse1 has joined #gnucash
10:34:37 *** storyjesse has quit IRC
10:34:37 *** storyjesse1 is now known as storyjesse
10:44:33 *** User has quit IRC
10:51:32 *** Mechtilde has quit IRC
11:17:37 *** sergiomiguelrp has joined #gnucash
11:36:10 *** jervin has quit IRC
12:01:16 *** Mechtilde has joined #gnucash
12:02:40 *** ramontjunior has quit IRC
12:09:24 *** sbluhm has quit IRC
12:11:04 *** angel has joined #gnucash
12:12:05 *** Mechtilde has quit IRC
12:18:03 *** Mechtilde has joined #gnucash
12:18:55 *** sergiomiguelrp has quit IRC
12:38:21 *** angel has quit IRC
12:45:40 *** Agfarmer18 has joined #gnucash
12:46:37 *** Agfarmer18 has quit IRC
13:11:43 *** gnu_fan has joined #gnucash
13:13:47 <gnu_fan> hello Actions > Online Actions > Get Transactions was working just fine. But now when I try to update one of my accounts it says "Error on Executing Job Status Enqueued (1)". I tried closing and restarting GNUCash, and logging off and logging back in to clear the error with no luck. How do I get it to work?
13:24:43 <jralls_laptop> That's not a perl or GnuCash message, so it must be coming from your OS. Google doesn't turn up anything helpful. What is the OS/Distro?
13:26:00 <gnu_fan> Ubuntu 20.04 LTS - Xubuntu (xfce desxtop)
13:26:36 *** phoenix has joined #gnucash
13:38:55 <gnu_fan> any idea what to do about the status enqueued(1) error?
13:40:34 <gnu_fan> oh and another detail is that it affects the accounts from just one institution, but accounts at the other institution work normally
13:43:04 *** David has quit IRC
13:43:10 *** David has joined #gnucash
13:51:26 <jralls_laptop> (gnu_fan), Oh, I messed up when I read your original. Not perl, it's AQBanking... not that it's one of their error messages either, unfortunately.
13:52:36 <jralls_laptop> Where in the connection process is the error occurring? Has AQBanking already connected with the bank?
14:03:23 *** sbluhm has joined #gnucash
14:03:23 *** ChanServ sets mode: +v sbluhm
14:05:04 *** suukim has quit IRC
14:18:13 *** sergiomiguelrp has joined #gnucash
14:32:33 *** storyjesse has quit IRC
14:47:46 *** Mechtilde has quit IRC
14:51:35 <gnu_fan> thx jrails_laptop, the message pops up immediately. If it matters I'm using a flatpak install of gnucash version 3.10 and the log messages from the attempt to get transactions is "AqBanking v6.1.4.0stable
14:51:35 <gnu_fan> Sending jobs to the bank(s)
14:51:35 <gnu_fan> Sorting commands by account
14:51:35 <gnu_fan> Sorting commands by account
14:51:35 <gnu_fan> Sorting commands by provider
14:51:35 <gnu_fan> Send commands to providers
14:51:35 <gnu_fan> Send commands to provider "aqofxconnect"
14:51:35 <gnu_fan> Error Sending commands to provider "aqofxconnect":-51"
14:55:31 *** KaiForce has quit IRC
15:01:40 *** phoenix has quit IRC
15:05:30 <fell> gnu_fan, can you test, if the error still appears in a recent version of Gnucash, e.g. 4.0 from flatpak?
15:05:35 <jralls_afk> Just did a download to compare. The next message is 'Locking customer "8"'. So I guess the first thing to check is ~/.aqbanking/settings6. Make sure that the directory is writable (probably is because the other bank works), that all of the files are readable, and that there's no users/00000008.conf.lck.XXXX.local-yyyyyy where XXXX is the hostname and yyyy is a pid.
15:05:36 <fell> see https://wiki.gnucash.org/wiki/Flatpak
15:05:57 *** jralls_afk is now known as jralls
15:08:31 <fell> In the hbci part we had IIRC up to 3.10 an error message, when the list was empty.
15:08:39 <jralls> If everything in ~/.aqbanking looks OK then follow the instructions at https://wiki.gnucash.org/wiki/AqBanking#Debugging.
15:09:11 <jralls> fell, was it that particular error message?
15:09:23 <fell> Not sure
15:11:29 <fell> jralls: https://www.aquamaniac.de/rdm/projects/aqbanking/repository/revision?utf8=%E2%9C%93&rev=10d866368de9a900403457a3d94a0e54a611ab5e
15:12:47 <jralls> fell, that's about empty transactions. It's a lot further along than gnu_fan is getting.
15:14:32 <gnu_fan> I verified that settings6 is read/write, found some lock files from a month ago and deleted them, opened gnucash to try again - same error
15:19:01 <gnu_fan> now I will try following the instructions at https://wiki.gnucash.org/wiki/AqBanking#Debugging.
15:31:07 <fell> jralls, IMHO the readme's ob sourceforge should have a header line, what kind of checksum it contains.
15:32:35 <jralls> fell, OK. Any particular reason, like did someone ask?
15:34:47 <fell> It tried to explain a security question on the german list.
15:35:18 <fell> we had it up to https://sourceforge.net/projects/gnucash/files/gnucash%20%28stable%29/2.6.21/
15:36:09 <jralls> It?
15:36:52 <fell> The header
15:57:23 *** gnu_fan has quit IRC
16:13:19 <fell> I tried to add the header in 3.11's readme.txt, but it is not displayed on the page.
16:21:22 *** sbluhm has quit IRC
16:49:17 <jralls> Yes it is. You probably just need to refresh.
16:53:19 *** gnu_fan has joined #gnucash
17:07:34 <gnu_fan> Hi I tried following the debugging instructions and they don't seem to do anything. Preferences > Online Banking > Verbose Debug Messages will not stay checked
17:11:21 <gnu_fan> and I tried setting the environment variable with and without the keyword export, it didn't make any difference
17:11:31 <gnu_fan> nn@mech:~$ AQOFX_LOG_COMM=1
17:11:32 <gnu_fan> nn@mech:~$ echo $AQOFX_LOG_COMM
17:11:32 <gnu_fan> 1
17:11:32 <gnu_fan> nn@mech:~$ flatpak run org.gnucash.GnuCash
17:11:32 <gnu_fan> 6:2020/07/03 16-08-36:gwen(2):gwenhywfar.c: 109: Error on br_init: 0
17:11:32 <gnu_fan> 6:2020/07/03 16-08-36:gwen(2):i18n.c: 205: Real locale is [en_US.UTF-8]
17:11:32 <gnu_fan> 6:2020/07/03 16-08-36:gwen(2):plugin.c: 587: Plugin type "dbio" registered
17:11:32 <gnu_fan> 6:2020/07/03 16-08-36:gwen(2):dbio.c: 106: Adding plugin path [/app/lib/gwenhywfar/plugins/79/dbio]
17:11:33 <gnu_fan> 6:2020/07/03 16-08-36:gwen(2):plugin.c: 587: Plugin type "configmgr" registered
17:11:35 <gnu_fan> 6:2020/07/03 16-08-36:gwen(2):configmgr.c: 80: Adding plugin path [/app/lib/gwenhywfar/plugins/79/configmgr]
17:11:37 <gnu_fan> 6:2020/07/03 16-08-36:gwen(2):plugin.c: 587: Plugin type "ct" registered
17:11:39 <gnu_fan> 6:2020/07/03 16-08-36:gwen(2):ctplugin.c: 65: Adding plugin path [/app/lib/gwenhywfar/plugins/79/ct]
17:11:41 <gnu_fan> 6:2020/07/03 16-08-38:gwen(2):gui.c: 133: Using own callbacks in gui 0x55e1c12a57f0
17:11:43 <gnu_fan> Found Finance::Quote version 1.49.
17:15:33 <gnu_fan> it never created any log files
17:15:47 <gnu_fan> so the next suggestion in here was to upgrade my flatpak to version 4
17:15:52 <gnu_fan> should I go ahead with that?
17:19:07 <fell> AQ* variables have an effect on the log files below $HOME/.aqbanking/
17:20:47 <fell> On the flatpak wiki page is explained how to redirect the log output.
17:21:58 *** gjanssens has quit IRC
17:24:29 <fell> you would better at first enter the flatpak shell.
17:30:44 <fell> gnu_fan on 2020-05-21 we have updated our flatpaks to AqBanking to 6.2.1
17:31:32 <jralls> gnu_fan, I found in the Gwenhywfar sources that error -51 is "not found", and it looks in this case that it applies to either the user or the bank account. Try running the AQBanking setup wizard in Tools>Setup Online Banking... and make sure that both the user and account are set up correctly and the online account is associated with the correct GnuCash account.
17:36:35 <gnu_fan> ok I will try redoing the users and accounts. That sounds a lot better than trying new version
17:37:49 *** gnu_fan1 has joined #gnucash
17:37:49 *** gnu_fan has quit IRC
17:38:10 <fell> Probably spending hours on alreeady fixed issues. ;-)
17:39:37 <fell> If you dislike 4.0, you can also choose https://code.gnucash.org/builds/flatpak/maint/gnucash-maint-C3.11-D3.11.flatpakref
17:43:23 <jralls> fell, You did see that AQB is working for one of his accounts and not for another, right?
17:45:07 <fell> Yes, at least for HBCI there was an in bbetween fixed issue, that one of the setup steps had to be done twice.
18:19:04 <gnu_fan1> guys I sincerely appreciate your help the reason i take so long in between things is because I'm trying to watch a sick 16 month old baby
18:22:22 <jralls> gnu_fan1, No problem, I'm just keeping an eye on the IRC window while I work on other stuff. I hope the kid is only a little bit sick.
18:24:26 <gnu_fan1> thanks she is playing now
18:25:26 <fell> My best wishes to the child!
18:30:36 <gnu_fan1> ok went into the AQBanking setup. I found that it was all messed up. One of my users was completely missing I have no idea how that happened. So I created a new user. And it logged in and it said "The server successfully processed the request" and then it had a list of accounts in the log, which matched my actual bank accounts, and then it said "Operation Finished, you can now close this window"
18:30:56 <gnu_fan1> So i clicked close, and then OK, then I went over to the
18:31:40 <gnu_fan1> accounts page, and none of the accounts it found showed up there? So how do I get the list of retrieved accounts to show up on the accounts tab so that I can progress through the wizard?
18:37:00 <fell> Isn't "Match online accounts with Gnucash accounts" (step3) in the online banking setup?
18:38:10 <gnu_fan1> The "Next" button is greyed out
18:39:44 <jralls> Because the accounts didn't transfer. Try going back to the AQBanking set up, edit the user, and on the bank settings tab click "retrieve account list" again.
18:40:27 <jralls> That's supposed to populate the accounts tab.
18:42:57 <gnu_fan1> 17:40:01 Sending request...
18:42:57 <gnu_fan1> 17:40:01 Using GnuTLS default ciphers.
18:42:57 <gnu_fan1> 17:40:01 TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-256-GCM:AEAD
18:42:57 <gnu_fan1> 17:40:01 Waiting for response...
18:42:57 <gnu_fan1> 17:40:02 Parsing response...
18:42:57 <gnu_fan1> 17:40:02 Status for signon request: Success (Code 0, severity "INFO")
18:42:57 <gnu_fan1> The server successfully processed the request.
18:42:57 <gnu_fan1> 17:40:02 Status for account info request: Success (Code 0, severity "INFO")
18:42:57 <gnu_fan1> The server successfully processed the request.
18:42:58 <gnu_fan1> 17:40:02 Received account [secret]/[secret] ((no bank name)/SAVINGS)
18:42:59 <gnu_fan1> 17:40:02 Received account [secret]/[secret] ((no bank name)/CHECKING)
18:43:00 <gnu_fan1> 17:40:02 Received account [secret]/[secret] ((no bank name)/CHECKING)
18:43:01 <gnu_fan1> 17:40:02 Received account [secret]/[secret] ((no bank name)/CHECKING)
18:43:02 <gnu_fan1> 17:40:02 Received account [secret]/[secret] ((no bank name)/CHECKING)
18:43:03 <gnu_fan1> 17:40:02 Received account [secret]/[secret] ((no bank name)/YOUTH)
18:43:04 <gnu_fan1> 17:40:02 Received account (no bank code)/[secret] ((no bank name)/Visa)
18:43:05 <gnu_fan1> 17:40:02 Operation finished, you can now close this window.
18:43:36 <gnu_fan1> I blanked out the confidential info to show that it did retrieve the list
18:43:47 <gnu_fan1> of account
18:43:49 <gnu_fan1> s
18:43:58 <jralls> Good, but did it fill in the accounts tab on the AQBanking Setup dialog?
18:44:19 <gnu_fan1> no it is still blank, I tried to upload a screenshot but it is definitely blank
18:46:18 <jralls> Do you have the information available to create at least one of the accounts by hand? For OFX you need the routing id and account number.
18:46:50 <gnu_fan1> oh yes Ihave all that how do I create one by hand? is that like making a text file? I just need a template
18:50:30 <jralls> On the accounts tab just click the create account button. The only thing I find non-obvious about the dialog is that the routing id goes in the bank code entry.
18:52:07 <gnu_fan1> doing it now
18:58:55 <gnu_fan1> it flashed a warning "unable to update account spec" but it let me click through and match it to a gnucash account. Then I went back to GNU Cash and tried to run. It cleared the original error message! This is progress! But I have a new error
18:59:37 <gnu_fan1> it says it didn't recognize the account number, but hold on I have an idea about that
19:03:41 <gnu_fan1> ok i had to prefix the account # in aqbanking account setup with a zero, I figured that out by looking at the log of retrieved accounts.
19:04:34 <gnu_fan1> Then I went to gnucash to try again, and it failed but I noticed it said user 52 and my account is actually 54! No idea why it switched, but I switched it back and it at least got the balance. So I'm trying on a different account now.
19:12:56 <gnu_fan1> ok after many different tries I was able to get one account working! this is tedious but it's progress!
19:19:23 <gnu_fan1> ok now I'm trying to figure out why I can get one account working but not the other one with what looks like the exact same settings?
19:20:29 <jralls> Do you have the same number of digits in the account number?
19:21:42 <jralls> And what is failing with the second account?
19:23:32 <gnu_fan1> yes it has the same number of digits, I prefixed it with a zero
19:24:00 <gnu_fan1> I got so frustrated I did mv .aqbanking/ .aqbanking_backup/ and am trying to start completely from scratch
19:24:31 <gnu_fan1> is this easier with newer versions of GNUcash or on different operating systems?
19:26:44 <jralls> No, it's only easier when the account retrieval populates the accounts. Sometimes the OFXHome info is out of date and it takes an insane amount of fiddling even to get the user to work.
19:27:27 <jralls> And of course the bank's support folks will only talk to you if you're using Quicken.
19:28:06 <gnu_fan1> what do you mean by ofx home info?
19:31:19 <jralls> The Select button on the OFX DirectConnect Setup Wizard uses data from https://ofxhome.com.
19:32:06 <jralls> If your bank isn't in there or if the data there is out of date then you have to fill out the wizard by hand.
19:32:31 <jralls> And finding the necessary information can be difficult.
19:44:21 <jralls> Time to go.
19:44:27 *** jralls is now known as jralls_afk
19:52:07 <gnu_fan1> ok I got it working! Here are the steps that finally worked. #1 with help of this forum, identified that my aqbanking setup had become corrupted. Possibly by accidently deleting a user account or some other mysterious problem #2 closed gnu cash and renamed my .aqbanking folder to .aqbanking_backup- this step essentially reset by aqbanking setup. #3 reopened gnu cash and very carefully followed the NEW instructions for USAA account setup
19:52:07 <gnu_fan1> someone had posted at https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings#USAA . After that, I was able to download transactions and balances for all my USAA accounts.
19:52:35 <gnu_fan1> This was extremely tedious and difficult but in my opinion it is worth it because there is no other app like GNUCASH that helps me really track my finances.
19:52:59 <gnu_fan1> I want to donate to GNUCASH team to express my grattitude for the project. How can i send you guys a donation?
20:07:04 *** Anubis169 has quit IRC
20:28:11 <fell> gnu_fan1, https://www.gnucash.org/donate.phtml
20:33:20 <fell> but probably more important: improve the wiki, if it not clear formulated.
20:39:38 <gnu_fan1> ok I dropped some beer money into your paypal account with IHTFP consulting. I will donate again in the future and if I get really rich I'll load you guys up! GNUCASH is awesome!
20:39:44 *** omnireq has joined #gnucash
20:39:44 *** ChanServ sets mode: +v omnireq
20:40:29 *** gnu_fan1 has left #gnucash
20:40:44 *** omnireq has quit IRC
20:40:54 *** greatest_fan_of_gnu has joined #gnucash
20:41:57 <greatest_fan_of_gnu> I had seen this https://www.gnucash.org/donate.phtml website for donations before but the way it's worded there it sounds like that is just for paying off server expenses, so that is why I asked in chat to be sure my donation goes to wherever you guys really want it
21:25:09 <warlord> greatest_fan_of_gnu, thank you. We use the tip-jar money for various things. We've done xmas bonuses for devs; we've bought server equipment; we're planning to buy a code-signing (OV) cert... but you're right that often times we don't know, as a team, how to spend the tip-jar money.
21:36:33 *** sergiomiguelrp has quit IRC
22:59:07 *** sayantan has joined #gnucash
23:01:22 *** sayantan has quit IRC
23:03:04 *** greatest_fan_of_gnu has left #gnucash
23:08:28 *** puck has quit IRC
23:10:34 *** puck has joined #gnucash
23:19:19 *** jralls_laptop has quit IRC
23:19:25 *** jralls_laptop has joined #gnucash
23:19:47 *** jralls_laptop has joined #gnucash
23:20:10 *** jralls_laptop has joined #gnucash
23:20:32 *** jralls_laptop has joined #gnucash
23:20:51 *** jralls_laptop has quit IRC
23:20:55 *** jralls_laptop has joined #gnucash
23:21:18 *** jralls_laptop has joined #gnucash
23:21:40 *** jralls_laptop has joined #gnucash
23:22:03 *** jralls_laptop has joined #gnucash
23:22:21 *** jralls_laptop has quit IRC
23:22:26 *** jralls_laptop has joined #gnucash
23:22:43 *** jralls_laptop has quit IRC
23:22:48 *** jralls_laptop has joined #gnucash
23:23:10 *** jralls_laptop has joined #gnucash
23:23:33 *** jralls_laptop has joined #gnucash
23:23:55 *** jralls_laptop has joined #gnucash
23:24:13 *** jralls_laptop has quit IRC