Re: [GNC-dev] USAA Aqbanking Account Import

2021-05-06 Thread Brian Ward
Pshh... well, after I added one account manually I called it a night.  Now
when I went in to replicate it again, it works fine and it pulls all the
rest of my accounts in.  Maybe there was an issue with adding accounts to
an empty account list.  I'll have to test that out on a fresh gnucash
file.  Another time maybe.

Thanks for pointing out that gnucash.trace file

Brian

On Wed, May 5, 2021 at 12:27 PM Martin Preuss  wrote:

> Hi,
>
> Am 05.05.21 um 05:04 schrieb Brian Ward:
> [...]
> >  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
> [...]
>
> Would be nice to see what happens in the log (I believe the log is written
> to "gnucash.trace" or something like that). If you like you can send me a
> redacted version of the log file, maybe I can find out whats going on
> here...
>
>
> Regards
> Martin (AqBanking Team)
>
>
> --
> "Things are only impossible until they're not"
>
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel


Re: [GNC-dev] USAA Aqbanking Account Import

2021-05-05 Thread Martin Preuss
Hi,

Am 05.05.21 um 05:04 schrieb Brian Ward:
[...]
>  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
[...]

Would be nice to see what happens in the log (I believe the log is written to 
"gnucash.trace" or something like that). If you like you can send me a redacted 
version of the log file, maybe I can find out whats going on here...


Regards
Martin (AqBanking Team)


-- 
"Things are only impossible until they're not"
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel


[GNC-dev] USAA Aqbanking Account Import

2021-05-04 Thread Brian Ward
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/X ((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




20210504215352.000
REDACTED
REDACTED
ENG

USAA Federal Savings Bank
67811

QMOFX
2300
REDACTED




REDACTED

19900101






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

0INFOSUCCESS20210504205247.134[-4:EDT]ENGUSAA
Federal Savings
Bank67811REDACTED0INFOSUCCESS20210504205249.647[-4:EDT]REDACTED314074269REDACTEDCHECKINGYNNACTIVE

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


Thanks,
Brian
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel