[GNC-dev] USAA Aqbanking Account Import

Tue May 4 23:04:01 EDT 2021

Hello,

I'm saddened by the changes around USAA's system recently... it's pretty
frustrating...

I've run through the wiki updates (
https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings#USAA) and
appear to have gotten the initial aqbanking parts working as it reports a
list of my accounts in the report output from "Retrieve Account List".
However, those accounts never persist anywhere as they don't show up in the
account tab afterward.  The OFX debug output shows what appears to be valid
OFX (? I don't know OFX...) returned with the accounts as well. (BTW the
docs on
https://wiki.gnucash.org/wiki/Setting_up_OFXDirectConnect#Enabling_the_OFX_Log
are wrong as the debug file is named "ofx.log" in the current working
directory, not "1" when env var AQOFX_LOG_COMM=1)

I was wondering if anyone else has seen this behavior. I tried this on
multiple restarts.  Docs suggest the account tab refresh does need an app
restart, but that didn't do anything (
https://wiki.gnucash.org/wiki/Setting_up_OFXDirectConnect - "The account(s)
information you downloaded won't be visible in the AqBanking setup wizard
until the next time you open the wizard (the Accounts tab does not refresh
automatically), but the data is on your machine and available to GnuCash's
HBCI setup.")

I was able to manually enter in my account information in the accounts tab
and get it working.

└─$ flatpak run --command=sh org.gnucash.GnuCash
                                                       127 ⨯
[📦 org.gnucash.GnuCash ~]$ gnucash --version
GnuCash 4.5
Build ID: Flathub 4.5
[📦 org.gnucash.GnuCash ~]$ aqbanking-cli versions
Versions:
 AqBanking-CLI: 6.2.9
 Gwenhywfar   : 5.6.0.0
 AqBanking    : 6.2.9.0
[📦 org.gnucash.GnuCash ~]$ export GWEN_LOGLEVEL=info
[📦 org.gnucash.GnuCash ~]$ export AQBANKING_LOGLEVEL=info
[📦 org.gnucash.GnuCash ~]$ export AQOFX_LOG_COMM=1
[📦 org.gnucash.GnuCash ~]$ export AQOFXCONNECT_LOGLEVEL=info
[📦 org.gnucash.GnuCash ~]$ gnucash
6:2021/05/04 21-33-42:gwen(5):gwenhywfar.c:  110: Error on br_init: 119
6:2021/05/04 21-33-42:gwen(5):i18n.c:  205: Real locale is [en_US.UTF-8]
6:2021/05/04 21-33-42:gwen(5):plugin.c:  587: Plugin type "dbio" registered
6:2021/05/04 21-33-42:gwen(5):dbio.c:  106: Adding plugin path
[/app/lib/gwenhywfar/plugins/79/dbio]
6:2021/05/04 21-33-42:gwen(5):plugin.c:  587: Plugin type "configmgr"
registered
6:2021/05/04 21-33-42:gwen(5):configmgr.c:   80: Adding plugin path
[/app/lib/gwenhywfar/plugins/79/configmgr]
6:2021/05/04 21-33-42:gwen(5):plugin.c:  587: Plugin type "ct" registered
6:2021/05/04 21-33-42:gwen(5):ctplugin.c:   65: Adding plugin path
[/app/lib/gwenhywfar/plugins/79/ct]
6:2021/05/04 21-33-42:gwen(5):gui_dialogs.c:   32: Using own callbacks in
gui 0x5562d2530c00
Found Finance::Quote version 1.49.
6:2021/05/04 21-40-27:gwen(5):plugin.c:  618: Plugin type "ct" unregistered
6:2021/05/04 21-40-27:gwen(5):plugin.c:  618: Plugin type "configmgr"
unregistered
6:2021/05/04 21-40-27:gwen(5):plugin.c:  618: Plugin type "dbio"
unregistered

21:34:26 Saving communication log to /tmp/ofx.log
21:34:26 Sending request...
21:34:26 Using GnuTLS default ciphers.
21:34:26 TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-128-GCM:AEAD
21:34:26 Waiting for response...
21:34:29 Saving communication log to /tmp/ofx.log
21:34:29 Parsing response...
21:34:29 Status for signon request: Success (Code 0, severity "INFO")
The server successfully processed the request.
21:34:29 Status for account info request: Success (Code 0, severity "INFO")
The server successfully processed the request.
21:34:29 Received account 314074269/XXXXXXXXXXXXX ((no bank name)/ACCOUNT
NICKNAME)
21:34:29 Operation finished, you can now close this window.

$ cat /tmp/ofx-debug.log

Sending:
-------------------------------------
OFXHEADER:100
DATA:OFXSGML
VERSION:103
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

<OFX>
<SIGNONMSGSRQV1>
<SONRQ>
<DTCLIENT>20210504215352.000
<USERID>REDACTED
<USERPASS>REDACTED
<LANGUAGE>ENG
<FI>
<ORG>USAA Federal Savings Bank
<FID>67811
</FI>
<APPID>QMOFX
<APPVER>2300
<CLIENTUID>REDACTED
</SONRQ>
</SIGNONMSGSRQV1>
<SIGNUPMSGSRQV1>
<ACCTINFOTRNRQ>
<TRNUID>REDACTED
<ACCTINFORQ>
<DTACCTUP>19900101
</ACCTINFORQ>
</ACCTINFOTRNRQ>
</SIGNUPMSGSRQV1>
</OFX>

Received:
-------------------------------------
OFXHEADER:100
DATA:OFXSGML
VERSION:103
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

<OFX><SIGNONMSGSRSV1><SONRS><STATUS><CODE>0<SEVERITY>INFO<MESSAGE>SUCCESS</STATUS><DTSERVER>20210504205247.134[-4:EDT]<LANGUAGE>ENG<FI><ORG>USAA
Federal Savings
Bank<FID>67811</FI></SONRS></SIGNONMSGSRSV1><SIGNUPMSGSRSV1><ACCTINFOTRNRS><TRNUID>REDACTED<STATUS><CODE>0<SEVERITY>INFO<MESSAGE>SUCCESS</STATUS><ACCTINFORS><DTACCTUP>20210504205249.647[-4:EDT]<ACCTINFO><DESC>REDACTED<BANKACCTINFO><BANKACCTFROM><BANKID>314074269<ACCTID>REDACTED<ACCTTYPE>CHECKING</BANKACCTFROM><SUPTXDL>Y<XFERSRC>N<XFERDEST>N<SVCSTATUS>ACTIVE</BANKACCTINFO></ACCTINFO></ACCTINFORS></ACCTINFOTRNRS></SIGNUPMSGSRSV1></OFX>

Note that there were multiple accounts that I removed from these logs.

Thanks,
Brian