The one I have been using to test GnuCash is Chase.
I may not have mentioned before: I am using a script I wrote using the ofxtools library to download from a few different financial institutions. I am aware of Chase's clientuid connection requirement and have a valid clientuid. Also, I successfully connect to Chase and see my account numbers in the log window when setting up a aqbanking user in GnuCash. If you mean clientuid when you say customer id, I have the right one. I also specifically picked the appid and appver to be the same as my script. I haven't tried debugging again yet. Hopefully the query being sent will show up on the /tmp/ofx.log file. thanks, fleur -- Fleur Dragan / fl...@obscure.org > On Jul 7, 2020, at 3:56 AM, John Ralls <jra...@ceridwen.us> wrote: > > That is progress. 104 is an internal server error, meaning that the bank's > server didn't like what you sent it. It may need a different QWIN, a customer > ID, or you might have to set up online banking at their end first. Tell us > the bank name, maybe someone else here has experience with them. > > Regards, > John Ralls > > >> On Jul 6, 2020, at 9:41 AM, Fleur Dragan <fl...@obscure.org> wrote: >> >> >> It didn't even occur to me I couldn't send an attachment to the list. I >> facepalm. I'll go through it again with debugging and send you the output >> directly tomorrow. Thanks. >> >> And of course, before I wrote this, I was so excited I forgot to set up >> debugging and I went and tried setting up an account with just the routing >> and account numbers. When I clicked ok, it threw up an error dialog saying >> "unable to update account spec." When I clicked dismiss, the account was >> actually there. >> >> I was able to advance to the window to associate the account with a GnuCash >> account, and did so. Then I went to the register, selected Actions > Online >> Actions > Get Transactions..., chose to download from yesterday, and got >> this: >> >> AqBanking v6.2.1.0stable >> Sending jobs to the bank(s) >> Sorting commands by account >> Sorting commands by account >> Sorting commands by provider >> Send commands to providers >> Send commands to provider "aqofxconnect" >> Error Sending commands to provider "aqofxconnect":-104 >> >> So...progress? >> >> (Also, the "Select Backend" window just sticks around no matter what I do, >> until quit.) >> >> >> fleur >> -- >> Fleur Dragan / fl...@obscure.org >> >> >> >> >>> On Jul 6, 2020, at 5:09 PM, John Ralls <jra...@ceridwen.us> wrote: >>> >>> Unfortunately the stderr/stdout capture didn't make it through the list. >>> You may send them directly to me if you like, but please first go through >>> them and remove any identifying information, especially the bank routing >>> id, account numbers, and any PINs or passwords. >>> >>> All that you need for an OFX account setup is the Routing ID and Account >>> number. The former goes in the Bank Code field, the latter in the Account >>> Number field. Both should have been in the log window output; you can edit >>> the user and retrieve accounts again if you need to. The Bank and Account >>> names are used to identify the account in the UI so you can enter whatever >>> you like. The other fields are for HBCI/FinTS and can safely be left blank. >>> >>> Regards, >>> John Ralls >>> >>> >>>> On Jul 6, 2020, at 4:33 AM, Fleur Dragan <fl...@obscure.org> wrote: >>>> >>>> >>>> First I set: >>>> >>>> export GWEN_LOGLEVEL=debug >>>> export AQBANKING_LOGLEVEL=debug >>>> export AQOFX_LOG_COMM=1 >>>> export AQOFXCONNECT_LOGLEVEL=debug >>>> >>>> >>>> Then I ran, just to be safe: >>>> >>>> rm -rf ~/.aqbanking/ >>>> >>>> >>>> Then I ran: >>>> >>>> /Applications/Gnucash.app/Contents/MacOS/Gnucash --debug 2>&1 | tee gnc.out >>>> >>>> >>>> Once GnuCash started up, I tried to set up a user, which was successful. >>>> Then I tried to retrieve accounts, which was also successful, but no >>>> accounts were created in the aqbanking window. I tried to create an >>>> account, but it's not clear what information each field wants, especially >>>> since it's designed to be country agnostic. Is BIC SWIFT the routing >>>> number for my US account? Is country "US" or "United States" or something >>>> else? Bank Name? The one in www.ofxhome.com? The one on their website? >>>> Can't get much more ambiguous than bank name. The look up bank code >>>> doesn't appear to do anything, so I have no idea if the bank code is the >>>> OFX FI, the routing number, or something else. There are enough ambiguous >>>> fields, trying various combinations is prohibitive. If there is >>>> documentation, in English (google translate will not understand subtleties >>>> of BIC/IBAN/SWIFT/routing number), for setting up OFX accounts, I will >>>> happily try again. >>>> >>>> There were no errors in /tmp/ofx.log. >>>> >>>> There don't seem to be any errors in the output, and nothing was in the >>>> trace file, so I guess I read how to turn that on wrong. I've attached >>>> the stdout/stderr output. Will the trace be helpful? If so, I'll go back >>>> and to that. What else have I missed? >>>> >>>> >>>> >>>> thanks, >>>> fleur >>>> -- >>>> Fleur Dragan / fl...@obscure.org >>>> >>>> >>>> >>>> >>>>> On Jul 5, 2020, at 1:14 AM, Frank H. Ellenberger >>>>> <frank.h.ellenber...@gmail.com> wrote: >>>>> >>>>> Hi, >>>>> >>>>> Am 05.07.20 um 00:51 schrieb peterb: >>>>>> Fleur Dragan said: >>>>>> >>>>>>> So when I try to set up OFX connectivity, the user is created >>>>>>> successfully. Then I try to retrieve accounts, which do show up in the >>>>>>> log >>>>>>> window, and the log window says I may now close, but when I do, nothing >>>>>>> happens. This was the same behavior I saw with aqbanking 6.1.4. >>>>>>> >>>>>> >>>>>> This was the exact same behavior I saw in 3.10. I haven't tried it with >>>>>> 4.0 yet. The overall user impression was "Your login has succeeded! >>>>>> Nothing happens." >>>>>> >>>>>> -P >>>>> >>>>> just in case the one or other wants to dig deeper: >>>>> * https://wiki.gnucash.org/wiki/AqBanking#Debugging >>>>> * https://wiki.gnucash.org/wiki/Tracefile >>>>> Flatpak users only: >>>>> https://wiki.gnucash.org/wiki/Flatpak#Getting_Console_Output >>>>> >>>>> HTH >>>>> Frank >>>>> >>>> >>>> >>>> _______________________________________________ >>>> 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. > > _______________________________________________ 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.
