OFX Connection GNUCash to Vanuard and Capital One 360

[Tony Likhite]

On Mon, Mar 17, 2014 at 1:27 AM, Yury Perzov <yury.perzov at gmail.com> wrote:
> To get around the "400 bad request" error, you need to change aqbanking
> account type  setting.
...
> I ended up compiling aqbanking-5.3.5beta from a tarball and it worked.

The latest AqBanking library doesn't resolve the problem for me. I'm
getting the same "400 (Bad Request)" error trying to get transactions
for a Vanguard account. I'm running gnucash from git
(67d90c90cc14292181a64b5a68cf52979960c052) built against the latest
aqbanking (5.4.1beta) and gwenhyfwar (4.11.0beta). All other
dependencies handled by Ubuntu 13.10. Account type is set to to
"Investment Account" in the AqBanking wizard.

The log window says:
-----
AqBanking v5.4.1.0beta
Sending jobs to the bank(s)
Locking user xxx
Sending request...
Connecting to server...
Resolving hostname "vesnc.vanguard.com" ...
IP address is "192.175.191.161"
Connecting to "vesnc.vanguard.com"
Connected to "vesnc.vanguard.com"
Using old SSL preparation code.
TLS: SSL-Ciphers negotiated: TLS1.2:RSA-ARCFOUR-128:SHA1
TLS: Warning - The server has chosen unsafe SSL-Ciphers!
Connected.
Sending message...
Message sent.
Waiting for response...
Receiving response...
HTTP-Status: 400 (Bad Request)
Error parsing server response
Unlocking user xxx
Postprocessing jobs
Job Get Transactions: finished
Resetting provider queues

And the aqbanking debug log (/tmp/ofx.log) says:
-----
Sending:
-------------------------------------
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:20140317204529.000

<OFX><SIGNONMSGSRQV1><SONRQ><DTCLIENT>20140317204529.000<USERID>xxx
<USERPASS>xxx
<LANGUAGE>ENG<FI><ORG>The Vanguard
Group<FID>1358</FI><APPID>QWIN<APPVER>2200</SONRQ></SIGNONMSGSRQV1><INVSTMTMSGSRQV1><INVSTMTTRNRQ><TRNUID>20140317204529.000<CLTCOOKIE>1<INVSTMTRQ><INVACCTFROM><ACCTID>111111111111</INVACCTFROM><INCTRAN><DTSTART>20140301<DTEND>20140317<INCLUDE>Y</INCTRAN><INCOO>Y<INCPOS><DTASOF>20140317204529.000<INCLUDE>Y</INCPOS><INCBAL>Y</INVSTMTRQ></INVSTMTTRNRQ></INVSTMTMSGSRQV1></OFX>

(the response would normally be here in the log, but there isn't one)
-----

-- 
Tony Likhite