Connection to Technology Credit Union
Steve Kelem
steve at kelem.net
Tue Dec 26 22:30:48 EST 2017
In the OFX DirectConnect User Setup, I have:
AqBanking Setup:
Users:
Bank Settings:
Bank Name: Technology Credit Union
Broker Id: <blank>
FID: 121181976
ORG: TECHCUDC
Server URL [1]https://m.techcu.com/ofxserver/ofxsrvr.dll
Application Settings:
Emulated Application: Intuit Quicken Windows 2013
Application ID: QWIN
Application Version: 2200
Header Version: 102
Accounts:
Account Number: <ddddd>S:0000 for share
Account Name: SHARE SAVINGS
IBAN: <blank>
Owner Name: <your name>
Currency: US Dollar (USD)
Account Type: Savings Account
Country: United States of America
Bank Code: 121181976
Bank Name: 121181976
SWIFT BIC: <blank>
Selected User: <filled in when you Retrieve Account List, under Bank
Settings>
Steve
Carmelo Pagán wrote on 12/05/2017 12:06 PM:
Hello All,
I was wondering if anyone has successfully setup OFX direct connect for this
financial institution (Technology Credit Union)?
OS: Windows 10 64-bit
GnuCash version: 2.6.18
AqBanking version: v5.6.12.0 stable
This is what I am getting when setting up the user:
Settings/steps:
1. Click “Tools”->”Online Banking Setup”. Result: AqBanking Initial
assistant is displayed
2. Click “Forward”. Result: “Start AqBanking Wizard” button displayed
3. Click ”Start AqBanking Wizard” button. Result: AqBanking Setup
widow is displayed.
4. Click “Create User”. Result: New User Wizard dialog box displayed
5. Click “Next”. Result: Protocol choice dialog box displayed.
6. Click “OFX-DirectConnect backend” radial button.
7. Click “Next” Result: Message box displayed
8. Click “Run”. Result: Message: This dialog assists you….yada yada
9. Click “Next”. Result: OFX-DirectConnect Setup window displayed.
10. Click “Select”. Result: Select a Bank dialog box displayed
11. Type “Technology Credit Union” in “Bank Name” box. Click “Next”.
12. Select (Highlight) “Technology Credit Union (801). Click “Ok”. Result:
Return to “OFX-DirectConnect Setup” window with <FID> <ORG> and <Server URL>
fields filled in
13. Click “Next”. Result: dialog box asking for User name info.
14. Typed “(My_Name)” in “User Name” field.
15. Typed “(my_login_user_Id)” in “user Id field. Left “Client UID” field
blank. Clicked “Next” Result: Application Emulation dialog box displayed
with <Application ID>=QWIN, <Application Version:=2200, and <Header
Version>=102 (also tried with header version 103).
16. Click “Next”, then “Next” again. Resulting log messages:
14:00:11 Retrieving SSL certificate
14:00:11 Connecting to server...
14:00:11 Using GnuTLS default ciphers.
14:00:11 TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-CBC:SHA1
14:00:11 Signer not found
14:00:11 Certificate is not trusted
14:00:14 Connected.
14:00:14 Disconnected.
14:00:14 Connection ok, certificate probably received
14:00:14 Operation finished, you can now close this window.
14:05:50 Sending request
17. Close Box
18. Click “Next”. Result:
14:48:12 Sending request...
14:48:12 Using GnuTLS default ciphers.
14:48:12 TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-CBC:SHA1
14:48:12 Signer not found
14:48:12 Certificate is not trusted
14:48:12 Waiting for response...
14:48:12 Error on gnutls_bye: -24 (Decryption has failed.)
14:48:12 Parsing response...
14:48:12 Parsing response
14:48:12 Status for signon request: Signon invalid (Code 15500, severity
"ERROR")
The user cannot signon because he or she entered an invalid user ID or
password.
14:48:12 Status for account info request: Signon invalid (Code 15500,
severity "ERROR")
The user cannot signon because he or she entered an invalid user ID or
password.
14:48:12 Operation finished, you can now close this window.
19. Click “Finish”
20. Click “Accounts” tab.
21. Click “Create Account”. Result: Dialog box asking to confirm backend
22. Click “Ok” Result: “Edit Account” dialog box
23. Under Account Info section, Entered <Account Number>, <Account Name>,
<Owner Name>=(My name).
24. Selected “USD” for <Currency>
25. Under Bank Info section, selected “United States of America (US)”
under <Country>
26. Entered (ABA Transit Number) Under <Bank Code>
27. Entered “Technology Credit Union” under <Bank Name>
28. Selected previously setup user under <Selected Users>
29. Clicked “Ok”
30. Repeated steps 23 thru 31 to enter Savings account. Result: return to
“AqBanking Setup” box
31. Clicked “Close”. Result return to “AqBanking Initial Assistant”
32. Clicked “Close”. Result: “Match Online accounts with GnuCach accounts
33. Double clicked first account listed. Result: “Select account” window
displayed.
34. Selected previously created GnuCash Checking account. Clicked
“Forward”
35. Repeated steps 34 and 35 for GnuCash savings account. Clicked
“Forward”
36. Clicked “Apply”
37. Clicked GnuCash Checking account tab
38. Clicked “Actions”-->”Onliine Actions”-->”Get Transactions”. Result:
Selection box for date range displayed
39. Select/Enter Date range. Press “Ok”. Result: “Enter Password” box
displayed.
40. Entered password. Clicked “Ok”. Result:
AqBanking v5.6.12.0stable
Sending jobs to the bank(s)
Locking user pagan8858
Sending request...
Connecting to server...
Resolving hostname "m.techcu.com" ...
IP address is "66.126.188.93"
Connecting to "m.techcu.com"
Connected to "m.techcu.com"
Using GnuTLS default ciphers.
TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-CBC:SHA1
Signer not found
Certificate is not trusted
Connected.
Sending message...
Message sent.
Waiting for response...
Receiving response...
HTTP-Status: 200 (OK)
Response received.
Disconnecting from server...
Disconnected.
Parsing response...
Parsing response
Status for signon request: Signon invalid (Code 15500, severity "ERROR")
The user cannot signon because he or she entered an invalid user ID or
password.
Status for transaction statement request: Signon invalid (Code 15500,
severity "ERROR")
The user cannot signon because he or she entered an invalid user ID or
password.
Unlocking user pagan8858
Postprocessing jobs
Job Get Balance: finished
Resetting provider queues
It would seem that TechCU is not accepting the login. I have the header set
to 103 in order to accept Multi-Factor-Authentication from the Server. I
suspect it’s TechCu needing to “Flip a Switch” on their side. Sent email to
bank. No response yet. Any thoughts?? Any/all helpful comments welcome.
Thanks,
Carmelo Pagan
Sr. SQA Engineer (retired)
_______________________________________________
gnucash-user mailing list
[2]gnucash-user at gnucash.org
[3]https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
References
1. https://m.techcu.com/ofxserver/ofxsrvr.dll
2. mailto:gnucash-user at gnucash.org
3. https://lists.gnucash.org/mailman/listinfo/gnucash-user
More information about the gnucash-user
mailing list