[GNC] AQBanking OFX DirectConnect

[chris graves]

Yeah, and perhaps I wasn't following your advice of:

It actually requires make uninstall && make clean && make && make install to ensure that the changed code is used.

> On Mar 18, 2020, at 5:32 PM, John Ralls <jralls at ceridwen.us> wrote:
> 
> Chris,
> 
> I guess in your case it was having OFXHEADER:100 and VERSION:102. I think that's all that changed between your last failed run and the successful one.
> 
> Regards,
> John Ralls
> 
>> On Mar 18, 2020, at 5:21 PM, Chris Graves <mohavebaked at gmail.com> wrote:
>> 
>> John,
>> 
>> You are probably right, but here is an excerpt from the working ofx.log file, so I guess I'm not sure what enabled this progress:
>> Sending:
>> -------------------------------------
>> OFXHEADER:100
>> DATA:OFXSGML
>> VERSION:102
>> SECURITY:NONE
>> ENCODING:USASCII
>> CHARSET:1252
>> COMPRESSION:NONE
>> OLDFILEUID:NONE
>> NEWFILEUID:20200318152018.000
>> 
>> <OFX>
>> <SIGNONMSGSRQV1>
>> <SONRQ>
>> <DTCLIENT>20200318152011.000
>> <USERID>xxxxxxx
>> <USERPASS>xxxxxxxxxx
>> <LANG>ENG
>> <FI>
>> <ORG>KINECTA
>> <FID>322278073
>> </FI>
>> 
>> On Wed, Mar 18, 2020 at 5:10 PM John Ralls <jralls at ceridwen.us> wrote:
>> Chris,
>> 
>> You have it backwards: Martin changed LANG -> LANGUAGE because that's what AQB5 used.
>> 
>> However, I just tested on a bank account at USAA and that worked, except that it crashed GnuCash when trying to process the new transactions. That's probably not AQBanking's doing and I'll look into that separately.
>> 
>> Next I'll try Martin's command-line test.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>>> On Mar 18, 2020, at 4:57 PM, Chris Graves <mohavebaked at gmail.com> wrote:
>>> 
>>> John,
>>> 
>>> In your ofx.log file it still says LANGUAGE instead of LANG.  Mine says LANG, which is what Martin just fixed.
>>> 
>>> On Wed, Mar 18, 2020 at 4:54 PM John Ralls <jralls at ceridwen.us> wrote:
>>> Progress indeed, though still not enough for USAA. :-(
>>> 
>>> Regards,
>>> John Ralls
>>> 
>>> 
>>>> On Mar 18, 2020, at 4:48 PM, Chris Graves <mohavebaked at gmail.com> wrote:
>>>> 
>>>> Wow! making serious progress now.  I was requesting transactions from my checking account.  Looking at the ofx.log file, they were returned!!!
>>>> 
>>>> However the import process indicated that there were no transactions to be imported.
>>>> 
>>>> On Wed, Mar 18, 2020 at 4:32 PM Martin Preuss <martin at aqbanking.de> wrote:
>>>> Hi,
>>>> 
>>>> I just checked in another change... While comparing your logs I found
>>>> that aqb6 uses "LANG" while aqb5 used the correct name "LANGUAGE".
>>>> 
>>>> Also, added "CLTCOOKIE" (was set by aqb5 but missing in aqb6).
>>>> 
>>>> Also, I noticed that aqb5 included "BANKID" which you log from aqb6
>>>> didn't contain that line...
>>>> 
>>>> However, I think the unexpected element "LANG" (instead of "LANGUAGE")
>>>> was what made the server reject the request due to syntax error...
>>>> 
>>>> Fixed in git.
>>>> 
>>>> 
>>>> Regards
>>>> Martin
>>>> 
>>>> 
>>>> Am 19.03.20 um 00:26 schrieb John Ralls:
>>>>> That's what mine says:
>>>>>    char flags="forceSsl3", "sendShortDate"
>>>>>    char bankName="USAA Federal Savings Bank"
>>>>>    char org="USAA"
>>>>>    char fid="24591"
>>>>>    char serverAddr="https%3A%2F%2Fservice2.usaa.com%2Fofx%2FOFXServlet"
>>>>>    char appId="QWIN"
>>>>>    char appVer="2300"
>>>>>    char headerVer="102"
>>>>>    int  httpVMajor="0"
>>>>>    int  httpVMinor="0"
>>>>>  }
>>>>> 
>>>>> Regards,
>>>>> John Ralls
>>>>> 
>>>>> 
>>>>>> On Mar 18, 2020, at 4:15 PM, Martin Preuss <martin at aqbanking.de> wrote:
>>>>>> 
>>>>>> Hmm, maybe the server is picky about the HTTP version? Some servers
>>>>>> are... That can currently only be changed directly in the configuration
>>>>>> file:
>>>>>> 
>>>>>> $HOME/.aqbanking/settings6/users/*.conf
>>>>>> 
>>>>>> Some servers only accept httpVMinor="0"...
>>>>>> 
>>>>>> 
>>>>>> Regards
>>>>>> Martin
>>>>>> 
>>>>>> 
>>>>>> 
>>>>>> Am 18.03.20 um 23:20 schrieb John Ralls:
>>>>>>> Sigh, that's not it either:
>>>>>>> Sending:
>>>>>>> -------------------------------------
>>>>>>> OFXHEADER:100
>>>>>>> DATA:OFXSGML
>>>>>>> VERSION:102
>>>>>>> SECURITY:NONE
>>>>>>> ENCODING:USASCII
>>>>>>> CHARSET:1252
>>>>>>> COMPRESSION:NONE
>>>>>>> OLDFILEUID:NONE
>>>>>>> NEWFILEUID:20200318151247.000
>>>>>> [...]
>>>>>> 
>>>>>> -- 
>>>>>> "Things are only impossible until they're not"
>>>>> 
>>>> 
>>>> 
>>>> -- 
>>>> "Things are only impossible until they're not"
>>> 
>> 
>