Re: [GNC] Using Quicken direct connect with USAA
Not only does the first account download not take, no account download takes until I have created a dummy account. It's as if creating the dummy account is creating some container, perhaps the directory, to store the downloaded account information. However the download doesn't create that container. On Mon, 2020-05-25 at 19:46 -0700, John Ralls wrote: > Ah, that would explain why the Next button was disabled: You had no > accounts to assign. > > So the issue would seem to be that the first account download didn't > take, though the > AQBanking dialog box indicated that it should have. > > Regards, > John Ralls > > > > On May 25, 2020, at 4:41 PM, Jon Schewe wrote: > > Yes, I checked the Accounts tab after downloading the accounts the > first time and the tab was empty. I even tried backing all the way > out > of the wizard and restarting GnuCash and the tab was still empty. > > On Mon, 2020-05-25 at 16:33 -0700, John Ralls wrote: > > When you first set up the User in the AQBanking Wizard did you check > the Accounts tab after downloading the accounts the first time? > > Regards, > John Ralls > > > > On May 25, 2020, at 11:47 AM, Jon Schewe wrote: > > It just started working "magically". I tried manually creating an > account and associating it with a GnuCash account. Then tried getting > the balance and got an error that I had the account number wrong. So > I > went back into the AQBanking Wizard and executed Retrieve Account > List > to get the full account number. Now when I went over to the accounts > tab my accounts are there! I was able to associate them with the > right > GnuCash accounts and it seems to be working. > > I went back through my setup and deleted my aqbanking user and wrote > up > the steps that worked. It seems there is something about needing a > dummy account created, otherwise aqbanking won't save the account > information that it retrieved. > > Here are the steps, note the bit about a dummy account. > > * Tools -> Online Banking Setup... > * Create User > * Next > * OFX-DirectConnect backend > * Run > * Next > * Select > * USAA > * Select bank and click OK > * Next > * Enter USAA number with zeros on the left to make the number 9 > digits for the User Name and the User Id > * Next > * Next > * Next > * Retrieve Account List > * Enter PIN > * Finish > * Click on the Accounts tab > * If it's empty, create a dummy account using the aqofxconnect > backend > * OK > * Leave everything blank > * OK > * Dismiss message about unable to update > * Users > * Edit User > * Bank Settings > * Retrieve Account List > * Close > * Click on Accounts tab and see the new accounts, delete the dummy > account > * Close > * Next > * Associate to GnuCash accounts, looking at the account number works > well > * Next > * Apply > * Test by opening a GnuCash account that was associated with USAA > * Actions -> Online Actions -> Get Balance > * See the balance show up in a dialog > > On Mon, 2020-05-25 at 13:21 -0500, Jon Schewe wrote: > > Thank you for your help thus far. > > I noticed that I had AQBanking and GnuCash installed both inside and > outside flatpak. I've removed the version outside flatpak, but that > didn't help. > > If there are some additional debugging steps that are suggested for > checking aqbanking, let me know and I can see where the integration > with GnuCash is breaking. > > On Mon, 2020-05-25 at 09:47 -0700, John Ralls wrote: > > Well, that's progress. The communication with USAA is clearly > working. > > Maybe the flatpak sandbox isn't letting GnuCash see the results from > AQBanking. Unfortunately I don't have time to investigate this > further today. > > Regards, > John Ralls > > > > On May 25, 2020, at 9:29 AM, Jon Schewe wrote: > > John, > > Using those settings got me different information in the dialog. > However I still don't have an option to associate the accounts. When > I close the dialogs I'm back to "Start Online Banking Wizard" and the > match step is still grey. > > 11:24:16 Saving communication log to 1 > 11:24:16 Sending request... > 11:24:16 Using GnuTLS default ciphers. > 11:24:16 TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-256- > GCM:AEAD > 11:24:16 Waiting for response... > 11:24:17 Saving communication log to 1 > 11:24:17 Parsing response... > 11:24:17 Status for signon request: Success (Code 0, severity "INFO") > The server successfully processed the request. > 11:24:17 Status for account info request: Success (Code 0, severity > "INFO") > The server successfully processed the request. > 11:24:17 Received account X/XX ((no bank > name)/ACCOUNT) > 11:24:17 Received account X/XX ((no bank > name)/ACCOUNT) > 11:24:17 Received account (no bank code)/ ((no bank > name)/ACCOUNT) > 11:24:17 Operation finished, you can now close this window. > > Jon > > On Mon, 2020-05-25 at 09:09 -0700, John Ralls wrote: > > Jon, > > The Application Settings I use for USAA
Re: [GNC] Using Quicken direct connect with USAA
Ah, that would explain why the Next button was disabled: You had no accounts to assign. So the issue would seem to be that the first account download didn't take, though the AQBanking dialog box indicated that it should have. Regards, John Ralls > On May 25, 2020, at 4:41 PM, Jon Schewe wrote: > > Yes, I checked the Accounts tab after downloading the accounts the > first time and the tab was empty. I even tried backing all the way out > of the wizard and restarting GnuCash and the tab was still empty. > > On Mon, 2020-05-25 at 16:33 -0700, John Ralls wrote: >> When you first set up the User in the AQBanking Wizard did you check >> the Accounts tab after downloading the accounts the first time? >> >> Regards, >> John Ralls >> >> >> >> On May 25, 2020, at 11:47 AM, Jon Schewe wrote: >> >> It just started working "magically". I tried manually creating an >> account and associating it with a GnuCash account. Then tried getting >> the balance and got an error that I had the account number wrong. So >> I >> went back into the AQBanking Wizard and executed Retrieve Account >> List >> to get the full account number. Now when I went over to the accounts >> tab my accounts are there! I was able to associate them with the >> right >> GnuCash accounts and it seems to be working. >> >> I went back through my setup and deleted my aqbanking user and wrote >> up >> the steps that worked. It seems there is something about needing a >> dummy account created, otherwise aqbanking won't save the account >> information that it retrieved. >> >> Here are the steps, note the bit about a dummy account. >> >> * Tools -> Online Banking Setup... >> * Create User >> * Next >> * OFX-DirectConnect backend >> * Run >> * Next >> * Select >> * USAA >> * Select bank and click OK >> * Next >> * Enter USAA number with zeros on the left to make the number 9 >> digits for the User Name and the User Id >> * Next >> * Next >> * Next >> * Retrieve Account List >> * Enter PIN >> * Finish >> * Click on the Accounts tab >> * If it's empty, create a dummy account using the aqofxconnect >> backend >> * OK >> * Leave everything blank >> * OK >> * Dismiss message about unable to update >> * Users >> * Edit User >> * Bank Settings >> * Retrieve Account List >> * Close >> * Click on Accounts tab and see the new accounts, delete the dummy >> account >> * Close >> * Next >> * Associate to GnuCash accounts, looking at the account number works >> well >> * Next >> * Apply >> * Test by opening a GnuCash account that was associated with USAA >> * Actions -> Online Actions -> Get Balance >> * See the balance show up in a dialog >> >> On Mon, 2020-05-25 at 13:21 -0500, Jon Schewe wrote: >> >> Thank you for your help thus far. >> >> I noticed that I had AQBanking and GnuCash installed both inside and >> outside flatpak. I've removed the version outside flatpak, but that >> didn't help. >> >> If there are some additional debugging steps that are suggested for >> checking aqbanking, let me know and I can see where the integration >> with GnuCash is breaking. >> >> On Mon, 2020-05-25 at 09:47 -0700, John Ralls wrote: >> >> Well, that's progress. The communication with USAA is clearly >> working. >> >> Maybe the flatpak sandbox isn't letting GnuCash see the results from >> AQBanking. Unfortunately I don't have time to investigate this >> further today. >> >> Regards, >> John Ralls >> >> >> >> On May 25, 2020, at 9:29 AM, Jon Schewe wrote: >> >> John, >> >> Using those settings got me different information in the dialog. >> However I still don't have an option to associate the accounts. When >> I close the dialogs I'm back to "Start Online Banking Wizard" and the >> match step is still grey. >> >> 11:24:16 Saving communication log to 1 >> 11:24:16 Sending request... >> 11:24:16 Using GnuTLS default ciphers. >> 11:24:16 TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-256- >> GCM:AEAD >> 11:24:16 Waiting for response... >> 11:24:17 Saving communication log to 1 >> 11:24:17 Parsing response... >> 11:24:17 Status for signon request: Success (Code 0, severity "INFO") >> The server successfully processed the request. >> 11:24:17 Status for account info request: Success (Code 0, severity >> "INFO") >> The server successfully processed the request. >> 11:24:17 Received account X/XX ((no bank >> name)/ACCOUNT) >> 11:24:17 Received account X/XX ((no bank >> name)/ACCOUNT) >> 11:24:17 Received account (no bank code)/ ((no bank >> name)/ACCOUNT) >> 11:24:17 Operation finished, you can now close this window. >> >> Jon >> >> On Mon, 2020-05-25 at 09:09 -0700, John Ralls wrote: >> >> Jon, >> >> The Application Settings I use for USAA are >> Application ID: QWIN >> Application Version: 2200 >> Header Version: 102 >> >> In Special Settings: >> HTTP Version, Client UID, and Security Type are blank, Force SSLv3 >> and Send Short Date are checked, and Send Empty Bank ID and Send >>
Re: [GNC] Using Quicken direct connect with USAA
Yes, I checked the Accounts tab after downloading the accounts the first time and the tab was empty. I even tried backing all the way out of the wizard and restarting GnuCash and the tab was still empty. On Mon, 2020-05-25 at 16:33 -0700, John Ralls wrote: > When you first set up the User in the AQBanking Wizard did you check > the Accounts tab after downloading the accounts the first time? > > Regards, > John Ralls > > > > On May 25, 2020, at 11:47 AM, Jon Schewe wrote: > > It just started working "magically". I tried manually creating an > account and associating it with a GnuCash account. Then tried getting > the balance and got an error that I had the account number wrong. So > I > went back into the AQBanking Wizard and executed Retrieve Account > List > to get the full account number. Now when I went over to the accounts > tab my accounts are there! I was able to associate them with the > right > GnuCash accounts and it seems to be working. > > I went back through my setup and deleted my aqbanking user and wrote > up > the steps that worked. It seems there is something about needing a > dummy account created, otherwise aqbanking won't save the account > information that it retrieved. > > Here are the steps, note the bit about a dummy account. > > * Tools -> Online Banking Setup... > * Create User > * Next > * OFX-DirectConnect backend > * Run > * Next > * Select > * USAA > * Select bank and click OK > * Next > * Enter USAA number with zeros on the left to make the number 9 > digits for the User Name and the User Id > * Next > * Next > * Next > * Retrieve Account List > * Enter PIN > * Finish > * Click on the Accounts tab > * If it's empty, create a dummy account using the aqofxconnect > backend >* OK >* Leave everything blank >* OK >* Dismiss message about unable to update >* Users >* Edit User >* Bank Settings >* Retrieve Account List >* Close > * Click on Accounts tab and see the new accounts, delete the dummy > account > * Close > * Next > * Associate to GnuCash accounts, looking at the account number works > well > * Next > * Apply > * Test by opening a GnuCash account that was associated with USAA >* Actions -> Online Actions -> Get Balance >* See the balance show up in a dialog > > On Mon, 2020-05-25 at 13:21 -0500, Jon Schewe wrote: > > Thank you for your help thus far. > > I noticed that I had AQBanking and GnuCash installed both inside and > outside flatpak. I've removed the version outside flatpak, but that > didn't help. > > If there are some additional debugging steps that are suggested for > checking aqbanking, let me know and I can see where the integration > with GnuCash is breaking. > > On Mon, 2020-05-25 at 09:47 -0700, John Ralls wrote: > > Well, that's progress. The communication with USAA is clearly > working. > > Maybe the flatpak sandbox isn't letting GnuCash see the results from > AQBanking. Unfortunately I don't have time to investigate this > further today. > > Regards, > John Ralls > > > > On May 25, 2020, at 9:29 AM, Jon Schewe wrote: > > John, > > Using those settings got me different information in the dialog. > However I still don't have an option to associate the accounts. When > I close the dialogs I'm back to "Start Online Banking Wizard" and the > match step is still grey. > > 11:24:16 Saving communication log to 1 > 11:24:16 Sending request... > 11:24:16 Using GnuTLS default ciphers. > 11:24:16 TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-256- > GCM:AEAD > 11:24:16 Waiting for response... > 11:24:17 Saving communication log to 1 > 11:24:17 Parsing response... > 11:24:17 Status for signon request: Success (Code 0, severity "INFO") > The server successfully processed the request. > 11:24:17 Status for account info request: Success (Code 0, severity > "INFO") > The server successfully processed the request. > 11:24:17 Received account X/XX ((no bank > name)/ACCOUNT) > 11:24:17 Received account X/XX ((no bank > name)/ACCOUNT) > 11:24:17 Received account (no bank code)/ ((no bank > name)/ACCOUNT) > 11:24:17 Operation finished, you can now close this window. > > Jon > > On Mon, 2020-05-25 at 09:09 -0700, John Ralls wrote: > > Jon, > > The Application Settings I use for USAA are > Application ID: QWIN > Application Version: 2200 > Header Version: 102 > > In Special Settings: > HTTP Version, Client UID, and Security Type are blank, Force SSLv3 > and Send Short Date are checked, and Send Empty Bank ID and Send > Empty FID are unchecked. > > Another user had trouble with USAA because he had entered a Client > UID on the User Settings page, so make sure that's blank too. > > Yes, SSL v3 is less secure than TLS, but it's better than sending the > data in the clear, and yes, the authentication that USAA uses on OFX > DirectConnect is less than ideal. > > Regards, > John Ralls > > > On May 25, 2020, at 8:59 AM, Jon Schewe
Re: [GNC] Using Quicken direct connect with USAA
When you first set up the User in the AQBanking Wizard did you check the Accounts tab after downloading the accounts the first time? Regards, John Ralls > On May 25, 2020, at 11:47 AM, Jon Schewe wrote: > > It just started working "magically". I tried manually creating an > account and associating it with a GnuCash account. Then tried getting > the balance and got an error that I had the account number wrong. So I > went back into the AQBanking Wizard and executed Retrieve Account List > to get the full account number. Now when I went over to the accounts > tab my accounts are there! I was able to associate them with the right > GnuCash accounts and it seems to be working. > > I went back through my setup and deleted my aqbanking user and wrote up > the steps that worked. It seems there is something about needing a > dummy account created, otherwise aqbanking won't save the account > information that it retrieved. > > Here are the steps, note the bit about a dummy account. > > * Tools -> Online Banking Setup... > * Create User > * Next > * OFX-DirectConnect backend > * Run > * Next > * Select > * USAA > * Select bank and click OK > * Next > * Enter USAA number with zeros on the left to make the number 9 > digits for the User Name and the User Id > * Next > * Next > * Next > * Retrieve Account List > * Enter PIN > * Finish > * Click on the Accounts tab > * If it's empty, create a dummy account using the aqofxconnect > backend >* OK >* Leave everything blank >* OK >* Dismiss message about unable to update >* Users >* Edit User >* Bank Settings >* Retrieve Account List >* Close > * Click on Accounts tab and see the new accounts, delete the dummy > account > * Close > * Next > * Associate to GnuCash accounts, looking at the account number works > well > * Next > * Apply > * Test by opening a GnuCash account that was associated with USAA >* Actions -> Online Actions -> Get Balance >* See the balance show up in a dialog > > On Mon, 2020-05-25 at 13:21 -0500, Jon Schewe wrote: >> Thank you for your help thus far. >> >> I noticed that I had AQBanking and GnuCash installed both inside and >> outside flatpak. I've removed the version outside flatpak, but that >> didn't help. >> >> If there are some additional debugging steps that are suggested for >> checking aqbanking, let me know and I can see where the integration >> with GnuCash is breaking. >> >> On Mon, 2020-05-25 at 09:47 -0700, John Ralls wrote: >> >> Well, that's progress. The communication with USAA is clearly >> working. >> >> Maybe the flatpak sandbox isn't letting GnuCash see the results from >> AQBanking. Unfortunately I don't have time to investigate this >> further today. >> >> Regards, >> John Ralls >> >> >> >> On May 25, 2020, at 9:29 AM, Jon Schewe wrote: >> >> John, >> >> Using those settings got me different information in the dialog. >> However I still don't have an option to associate the accounts. When >> I close the dialogs I'm back to "Start Online Banking Wizard" and the >> match step is still grey. >> >> 11:24:16 Saving communication log to 1 >> 11:24:16 Sending request... >> 11:24:16 Using GnuTLS default ciphers. >> 11:24:16 TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-256- >> GCM:AEAD >> 11:24:16 Waiting for response... >> 11:24:17 Saving communication log to 1 >> 11:24:17 Parsing response... >> 11:24:17 Status for signon request: Success (Code 0, severity "INFO") >> The server successfully processed the request. >> 11:24:17 Status for account info request: Success (Code 0, severity >> "INFO") >> The server successfully processed the request. >> 11:24:17 Received account X/XX ((no bank >> name)/ACCOUNT) >> 11:24:17 Received account X/XX ((no bank >> name)/ACCOUNT) >> 11:24:17 Received account (no bank code)/ ((no bank >> name)/ACCOUNT) >> 11:24:17 Operation finished, you can now close this window. >> >> Jon >> >> On Mon, 2020-05-25 at 09:09 -0700, John Ralls wrote: >> >> Jon, >> >> The Application Settings I use for USAA are >> Application ID: QWIN >> Application Version: 2200 >> Header Version: 102 >> >> In Special Settings: >> HTTP Version, Client UID, and Security Type are blank, Force SSLv3 >> and Send Short Date are checked, and Send Empty Bank ID and Send >> Empty FID are unchecked. >> >> Another user had trouble with USAA because he had entered a Client >> UID on the User Settings page, so make sure that's blank too. >> >> Yes, SSL v3 is less secure than TLS, but it's better than sending the >> data in the clear, and yes, the authentication that USAA uses on OFX >> DirectConnect is less than ideal. >> >> Regards, >> John Ralls >> >> >> On May 25, 2020, at 8:59 AM, Jon Schewe wrote: >> >> Alan, >> >> Thanks for the suggestion. I tried not setting any special settings >> and >> make sure the SSL v3 is unchecked. Still no change. >> >> As far as security goes, this method fo
Re: [GNC] Using Quicken direct connect with USAA; Aqbanking versions
Sorry about that. I am using the stable release. GnuCash 3.10 Build ID: Flathub 3.10-1 Versions: AqBanking-CLI: 6.1.4 Gwenhywfar : 5.2.0.0 AqBanking: 6.1.4.0 On Mon, 2020-05-25 at 23:57 +0200, Frank H. Ellenberger wrote: > Jon, > > you did not write, which Flatpak you are using. > The nightlies > * Flatpak: https://code.gnucash.org/builds/flatpak/maint/?C=M;O=D > * Windows: https://code.gnucash.org/builds/win32/master/?C=M;O=D > are since last friday bundled with AqBanking 6.2.1 while previous > versions were shipping AqBanking 6.2.0beta. > > I don't know, if the dummy step is still required with the new > version- > > Regards > Frank > > Am 25.05.20 um 20:47 schrieb Jon Schewe: > > It just started working "magically". I tried manually creating an > account and associating it with a GnuCash account. Then tried getting > the balance and got an error that I had the account number wrong. So > I > went back into the AQBanking Wizard and executed Retrieve Account > List > to get the full account number. Now when I went over to the accounts > tab my accounts are there! I was able to associate them with the > right > GnuCash accounts and it seems to be working. > > I went back through my setup and deleted my aqbanking user and wrote > up > the steps that worked. It seems there is something about needing a > dummy account created, otherwise aqbanking won't save the account > information that it retrieved. > > Here are the steps, note the bit about a dummy account. > > * Tools -> Online Banking Setup... > * Create User > * Next > * OFX-DirectConnect backend > * Run > * Next > * Select > * USAA > * Select bank and click OK > * Next > * Enter USAA number with zeros on the left to make the number 9 > digits for the User Name and the User Id > * Next > * Next > * Next > * Retrieve Account List > * Enter PIN > * Finish > * Click on the Accounts tab > * If it's empty, create a dummy account using the aqofxconnect > backend > * OK > * Leave everything blank > * OK > * Dismiss message about unable to update > * Users > * Edit User > * Bank Settings > * Retrieve Account List > * Close > * Click on Accounts tab and see the new accounts, delete the dummy > account > * Close > * Next > * Associate to GnuCash accounts, looking at the account number > works > well > * Next > * Apply > * Test by opening a GnuCash account that was associated with USAA > * Actions -> Online Actions -> Get Balance > * See the balance show up in a dialog > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Using Quicken direct connect with USAA; Aqbanking versions
Jon, you did not write, which Flatpak you are using. The nightlies * Flatpak: https://code.gnucash.org/builds/flatpak/maint/?C=M;O=D * Windows: https://code.gnucash.org/builds/win32/master/?C=M;O=D are since last friday bundled with AqBanking 6.2.1 while previous versions were shipping AqBanking 6.2.0beta. I don't know, if the dummy step is still required with the new version- Regards Frank Am 25.05.20 um 20:47 schrieb Jon Schewe: > It just started working "magically". I tried manually creating an > account and associating it with a GnuCash account. Then tried getting > the balance and got an error that I had the account number wrong. So I > went back into the AQBanking Wizard and executed Retrieve Account List > to get the full account number. Now when I went over to the accounts > tab my accounts are there! I was able to associate them with the right > GnuCash accounts and it seems to be working. > > I went back through my setup and deleted my aqbanking user and wrote up > the steps that worked. It seems there is something about needing a > dummy account created, otherwise aqbanking won't save the account > information that it retrieved. > > Here are the steps, note the bit about a dummy account. > > * Tools -> Online Banking Setup... > * Create User > * Next > * OFX-DirectConnect backend > * Run > * Next > * Select > * USAA > * Select bank and click OK > * Next > * Enter USAA number with zeros on the left to make the number 9 > digits for the User Name and the User Id > * Next > * Next > * Next > * Retrieve Account List > * Enter PIN > * Finish > * Click on the Accounts tab > * If it's empty, create a dummy account using the aqofxconnect > backend > * OK > * Leave everything blank > * OK > * Dismiss message about unable to update > * Users > * Edit User > * Bank Settings > * Retrieve Account List > * Close > * Click on Accounts tab and see the new accounts, delete the dummy > account > * Close > * Next > * Associate to GnuCash accounts, looking at the account number works > well > * Next > * Apply > * Test by opening a GnuCash account that was associated with USAA > * Actions -> Online Actions -> Get Balance > * See the balance show up in a dialog > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Using Quicken direct connect with USAA
It just started working "magically". I tried manually creating an account and associating it with a GnuCash account. Then tried getting the balance and got an error that I had the account number wrong. So I went back into the AQBanking Wizard and executed Retrieve Account List to get the full account number. Now when I went over to the accounts tab my accounts are there! I was able to associate them with the right GnuCash accounts and it seems to be working. I went back through my setup and deleted my aqbanking user and wrote up the steps that worked. It seems there is something about needing a dummy account created, otherwise aqbanking won't save the account information that it retrieved. Here are the steps, note the bit about a dummy account. * Tools -> Online Banking Setup... * Create User * Next * OFX-DirectConnect backend * Run * Next * Select * USAA * Select bank and click OK * Next * Enter USAA number with zeros on the left to make the number 9 digits for the User Name and the User Id * Next * Next * Next * Retrieve Account List * Enter PIN * Finish * Click on the Accounts tab * If it's empty, create a dummy account using the aqofxconnect backend * OK * Leave everything blank * OK * Dismiss message about unable to update * Users * Edit User * Bank Settings * Retrieve Account List * Close * Click on Accounts tab and see the new accounts, delete the dummy account * Close * Next * Associate to GnuCash accounts, looking at the account number works well * Next * Apply * Test by opening a GnuCash account that was associated with USAA * Actions -> Online Actions -> Get Balance * See the balance show up in a dialog On Mon, 2020-05-25 at 13:21 -0500, Jon Schewe wrote: > Thank you for your help thus far. > > I noticed that I had AQBanking and GnuCash installed both inside and > outside flatpak. I've removed the version outside flatpak, but that > didn't help. > > If there are some additional debugging steps that are suggested for > checking aqbanking, let me know and I can see where the integration > with GnuCash is breaking. > > On Mon, 2020-05-25 at 09:47 -0700, John Ralls wrote: > > Well, that's progress. The communication with USAA is clearly > working. > > Maybe the flatpak sandbox isn't letting GnuCash see the results from > AQBanking. Unfortunately I don't have time to investigate this > further today. > > Regards, > John Ralls > > > > On May 25, 2020, at 9:29 AM, Jon Schewe wrote: > > John, > > Using those settings got me different information in the dialog. > However I still don't have an option to associate the accounts. When > I close the dialogs I'm back to "Start Online Banking Wizard" and the > match step is still grey. > > 11:24:16 Saving communication log to 1 > 11:24:16 Sending request... > 11:24:16 Using GnuTLS default ciphers. > 11:24:16 TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-256- > GCM:AEAD > 11:24:16 Waiting for response... > 11:24:17 Saving communication log to 1 > 11:24:17 Parsing response... > 11:24:17 Status for signon request: Success (Code 0, severity "INFO") > The server successfully processed the request. > 11:24:17 Status for account info request: Success (Code 0, severity > "INFO") > The server successfully processed the request. > 11:24:17 Received account X/XX ((no bank > name)/ACCOUNT) > 11:24:17 Received account X/XX ((no bank > name)/ACCOUNT) > 11:24:17 Received account (no bank code)/ ((no bank > name)/ACCOUNT) > 11:24:17 Operation finished, you can now close this window. > > Jon > > On Mon, 2020-05-25 at 09:09 -0700, John Ralls wrote: > > Jon, > > The Application Settings I use for USAA are > Application ID: QWIN > Application Version: 2200 > Header Version: 102 > > In Special Settings: > HTTP Version, Client UID, and Security Type are blank, Force SSLv3 > and Send Short Date are checked, and Send Empty Bank ID and Send > Empty FID are unchecked. > > Another user had trouble with USAA because he had entered a Client > UID on the User Settings page, so make sure that's blank too. > > Yes, SSL v3 is less secure than TLS, but it's better than sending the > data in the clear, and yes, the authentication that USAA uses on OFX > DirectConnect is less than ideal. > > Regards, > John Ralls > > > On May 25, 2020, at 8:59 AM, Jon Schewe wrote: > > Alan, > > Thanks for the suggestion. I tried not setting any special settings > and > make sure the SSL v3 is unchecked. Still no change. > > As far as security goes, this method for getting my transactions > appears less secure than using Web Connect. When I login to get to > the > Web Connect download I need to enter a one time password from my > phone, > but for Direct Connect I only need my PIN. > > Jon > > On Mon, 2020-05-25 at 11:48 -0400, Alan wrote: > Jon, > > Disable SSL v3. Info at wiki.gnucash.org is wrong. It's not secure, > and no > reputa
Re: [GNC] Using Quicken direct connect with USAA
Thank you for your help thus far. I noticed that I had AQBanking and GnuCash installed both inside and outside flatpak. I've removed the version outside flatpak, but that didn't help. If there are some additional debugging steps that are suggested for checking aqbanking, let me know and I can see where the integration with GnuCash is breaking. On Mon, 2020-05-25 at 09:47 -0700, John Ralls wrote: > Well, that's progress. The communication with USAA is clearly > working. > > Maybe the flatpak sandbox isn't letting GnuCash see the results from > AQBanking. Unfortunately I don't have time to investigate this > further today. > > Regards, > John Ralls > > > > On May 25, 2020, at 9:29 AM, Jon Schewe wrote: > > John, > > Using those settings got me different information in the dialog. > However I still don't have an option to associate the accounts. When > I close the dialogs I'm back to "Start Online Banking Wizard" and the > match step is still grey. > > 11:24:16 Saving communication log to 1 > 11:24:16 Sending request... > 11:24:16 Using GnuTLS default ciphers. > 11:24:16 TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-256- > GCM:AEAD > 11:24:16 Waiting for response... > 11:24:17 Saving communication log to 1 > 11:24:17 Parsing response... > 11:24:17 Status for signon request: Success (Code 0, severity "INFO") > The server successfully processed the request. > 11:24:17 Status for account info request: Success (Code 0, severity > "INFO") > The server successfully processed the request. > 11:24:17 Received account X/XX ((no bank > name)/ACCOUNT) > 11:24:17 Received account X/XX ((no bank > name)/ACCOUNT) > 11:24:17 Received account (no bank code)/ ((no bank > name)/ACCOUNT) > 11:24:17 Operation finished, you can now close this window. > > Jon > > On Mon, 2020-05-25 at 09:09 -0700, John Ralls wrote: > > Jon, > > The Application Settings I use for USAA are > Application ID: QWIN > Application Version: 2200 > Header Version: 102 > > In Special Settings: > HTTP Version, Client UID, and Security Type are blank, Force SSLv3 > and Send Short Date are checked, and Send Empty Bank ID and Send > Empty FID are unchecked. > > Another user had trouble with USAA because he had entered a Client > UID on the User Settings page, so make sure that's blank too. > > Yes, SSL v3 is less secure than TLS, but it's better than sending the > data in the clear, and yes, the authentication that USAA uses on OFX > DirectConnect is less than ideal. > > Regards, > John Ralls > > > On May 25, 2020, at 8:59 AM, Jon Schewe wrote: > > Alan, > > Thanks for the suggestion. I tried not setting any special settings > and > make sure the SSL v3 is unchecked. Still no change. > > As far as security goes, this method for getting my transactions > appears less secure than using Web Connect. When I login to get to > the > Web Connect download I need to enter a one time password from my > phone, > but for Direct Connect I only need my PIN. > > Jon > > On Mon, 2020-05-25 at 11:48 -0400, Alan wrote: > Jon, > > Disable SSL v3. Info at wiki.gnucash.org is wrong. It's not secure, > and no > reputable financial institution should be supporting it for financial > transactions. > > As of this moment, USAA is only supporting TLS 1.2 and 1.3, which are > secure. > Suggest not setting any of the "special settings" options, and never > enable SSL > v2 or v3 for any program, except for testing with non-sensitive data. > > -Original Message- > From: gnucash-user > [mailto:gnucash-user-bounces+alangnuc=bigtowers@gnucash.org] On > Behalf Of > Jon Schewe > Sent: Monday, May 25, 2020 10:36 AM > To: gnucash-user > Subject: [GNC] Using Quicken direct connect with USAA > > I have been using the Web Connect with USAA for years and that's > worked great. > However now I see that they are discontinuing support for this > feature. So I'm > trying to setup Direct Connect. I found the instructions for setting > up USAA at > https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings#USAA, > however I'm not seeing the "Server Capabilities" tab to select the > account list > download options. > > I'm using GnuCash 3.10 from flatpak. > I'm on Linux. > > I have the following Settings: > "User Settings" > User Name, User id and Client UID all set to my USAA number. I have > tried both > with the 00 prefix and without. > > "Bank Settings" > Broker ID: 5874 > FID: 24591 > ORG: USAA > Server URL: https://service2.usaa.com/ofx/OFXServlet > > "Application Settings" > I've tried the default application settings and the settings that > should be for > Quicken 2017: > Application ID: QWIN > Application Version: 2600 > Header Version: 102 > > Under "Special Settings" I've tried HTTP Version blank, 1.0 and 1.1. > I've checked "Force SSLv3". > > When I go back to the "Bank Settings" tab I see the following after > clicking on > "Retrieve Account List". > > 09:26:37 Sending request... > 09:26:37
Re: [GNC] How do I get back the cursor highlight for rows on the account page using CSS file on Windows 10?
I listed my gtk.css file in a previous topic about formatting the register header (something you can't do with CSS). Here's a link to that: http://gnucash.1415818.n4.nabble.com/GNC-Formatting-the-Register-header-td4715551.html#a471 The Wiki is just what I found using a typical search with "Gnucash gtk" or something like that: https://wiki.gnucash.org/wiki/GTK3 - Ken Farley -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How do I get back the cursor highlight for rows on the account page using CSS file on Windows 10?
Farleykj, Could you provide links to that section of the wiki and to your css file if it is posted elsewhere? Thanks! On Mon, May 25, 2020 at 9:49 AM farleykj wrote: > You e-mailed me directly about more stuff, but I don't generally check that > stuff. You should always use Reply All so further messages come here. > Anyway, I somewhat recently posted my full gtk.css file that I use for > GnuCash, which has all my "discoveries" about different formatting that are > available. Some things you might want to address may not be modifiable with > a simple CSS entry. > Here's the code I use to set the cursor entry line: > > cursor entry > { > background-color: goldenrod ; > color:black ; > } > > This one, I believe, is supplied in the GnuCash Wiki that discusses GTK 3.0 > stuff. > > > > - > Ken Farley > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Using Quicken direct connect with USAA
Well, that's progress. The communication with USAA is clearly working. Maybe the flatpak sandbox isn't letting GnuCash see the results from AQBanking. Unfortunately I don't have time to investigate this further today. Regards, John Ralls > On May 25, 2020, at 9:29 AM, Jon Schewe wrote: > > John, > > Using those settings got me different information in the dialog. However I > still don't have an option to associate the accounts. When I close the > dialogs I'm back to "Start Online Banking Wizard" and the match step is still > grey. > > 11:24:16 Saving communication log to 1 > 11:24:16 Sending request... > 11:24:16 Using GnuTLS default ciphers. > 11:24:16 TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-256-GCM:AEAD > 11:24:16 Waiting for response... > 11:24:17 Saving communication log to 1 > 11:24:17 Parsing response... > 11:24:17 Status for signon request: Success (Code 0, severity "INFO") > The server successfully processed the request. > 11:24:17 Status for account info request: Success (Code 0, severity "INFO") > The server successfully processed the request. > 11:24:17 Received account X/XX ((no bank name)/ACCOUNT) > 11:24:17 Received account X/XX ((no bank name)/ACCOUNT) > 11:24:17 Received account (no bank code)/ ((no bank > name)/ACCOUNT) > 11:24:17 Operation finished, you can now close this window. > > Jon > > On Mon, 2020-05-25 at 09:09 -0700, John Ralls wrote: >> Jon, >> >> The Application Settings I use for USAA are >> Application ID: QWIN >> Application Version: 2200 >> Header Version: 102 >> >> In Special Settings: >> HTTP Version, Client UID, and Security Type are blank, Force SSLv3 and Send >> Short Date are checked, and Send Empty Bank ID and Send Empty FID are >> unchecked. >> >> Another user had trouble with USAA because he had entered a Client UID on >> the User Settings page, so make sure that's blank too. >> >> Yes, SSL v3 is less secure than TLS, but it's better than sending the data >> in the clear, and yes, the authentication that USAA uses on OFX >> DirectConnect is less than ideal. >> >> Regards, >> John Ralls >> >> >> On May 25, 2020, at 8:59 AM, Jon Schewe wrote: >> >> Alan, >> >> Thanks for the suggestion. I tried not setting any special settings and >> make sure the SSL v3 is unchecked. Still no change. >> >> As far as security goes, this method for getting my transactions >> appears less secure than using Web Connect. When I login to get to the >> Web Connect download I need to enter a one time password from my phone, >> but for Direct Connect I only need my PIN. >> >> Jon >> >> On Mon, 2020-05-25 at 11:48 -0400, Alan wrote: >> Jon, >> >> Disable SSL v3. Info at wiki.gnucash.org is wrong. It's not secure, and no >> reputable financial institution should be supporting it for financial >> transactions. >> >> As of this moment, USAA is only supporting TLS 1.2 and 1.3, which are secure. >> Suggest not setting any of the "special settings" options, and never enable >> SSL >> v2 or v3 for any program, except for testing with non-sensitive data. >> >> -Original Message- >> From: gnucash-user >> [mailto:gnucash-user-bounces+alangnuc=bigtowers@gnucash.org] On Behalf Of >> Jon Schewe >> Sent: Monday, May 25, 2020 10:36 AM >> To: gnucash-user >> Subject: [GNC] Using Quicken direct connect with USAA >> >> I have been using the Web Connect with USAA for years and that's worked >> great. >> However now I see that they are discontinuing support for this feature. So >> I'm >> trying to setup Direct Connect. I found the instructions for setting up USAA >> at >> https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings#USAA, >> however I'm not seeing the "Server Capabilities" tab to select the account >> list >> download options. >> >> I'm using GnuCash 3.10 from flatpak. >> I'm on Linux. >> >> I have the following Settings: >> "User Settings" >> User Name, User id and Client UID all set to my USAA number. I have tried >> both >> with the 00 prefix and without. >> >> "Bank Settings" >> Broker ID: 5874 >> FID: 24591 >> ORG: USAA >> Server URL: https://service2.usaa.com/ofx/OFXServlet >> >> "Application Settings" >> I've tried the default application settings and the settings that should be >> for >> Quicken 2017: >> Application ID: QWIN >> Application Version: 2600 >> Header Version: 102 >> >> Under "Special Settings" I've tried HTTP Version blank, 1.0 and 1.1. >> I've checked "Force SSLv3". >> >> When I go back to the "Bank Settings" tab I see the following after clicking >> on >> "Retrieve Account List". >> >> 09:26:37 Sending request... >> 09:26:37 Using GnuTLS default ciphers. >> 09:26:37 TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-256-GCM:AEAD >> 09:26:37 Waiting for response... >> 09:26:37 Operation finished, you can now close this window. >> >> The AqBanking Setup never lets me get to the point of associating USAA >> accounts >> with GnuCash accounts. Can someone
Re: [GNC] Using Quicken direct connect with USAA
John, Using those settings got me different information in the dialog. However I still don't have an option to associate the accounts. When I close the dialogs I'm back to "Start Online Banking Wizard" and the match step is still grey. 11:24:16 Saving communication log to 1 11:24:16 Sending request... 11:24:16 Using GnuTLS default ciphers. 11:24:16 TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-256-GCM:AEAD 11:24:16 Waiting for response... 11:24:17 Saving communication log to 1 11:24:17 Parsing response... 11:24:17 Status for signon request: Success (Code 0, severity "INFO") The server successfully processed the request. 11:24:17 Status for account info request: Success (Code 0, severity "INFO") The server successfully processed the request. 11:24:17 Received account X/XX ((no bank name)/ACCOUNT) 11:24:17 Received account X/XX ((no bank name)/ACCOUNT) 11:24:17 Received account (no bank code)/ ((no bank name)/ACCOUNT) 11:24:17 Operation finished, you can now close this window. Jon On Mon, 2020-05-25 at 09:09 -0700, John Ralls wrote: > Jon, > > The Application Settings I use for USAA are > Application ID: QWIN > Application Version: 2200 > Header Version: 102 > > In Special Settings: > HTTP Version, Client UID, and Security Type are blank, Force SSLv3 and Send > Short Date are checked, and Send Empty Bank ID and Send Empty FID are > unchecked. > > Another user had trouble with USAA because he had entered a Client UID on the > User Settings page, so make sure that's blank too. > > Yes, SSL v3 is less secure than TLS, but it's better than sending the data in > the clear, and yes, the authentication that USAA uses on OFX DirectConnect is > less than ideal. > > Regards, > John Ralls > > > > On May 25, 2020, at 8:59 AM, Jon Schewe wrote: > > Alan, > > Thanks for the suggestion. I tried not setting any special settings and > make sure the SSL v3 is unchecked. Still no change. > > As far as security goes, this method for getting my transactions > appears less secure than using Web Connect. When I login to get to the > Web Connect download I need to enter a one time password from my phone, > but for Direct Connect I only need my PIN. > > Jon > > On Mon, 2020-05-25 at 11:48 -0400, Alan wrote: > > Jon, > > Disable SSL v3. Info at wiki.gnucash.org is wrong. It's not secure, and no > reputable financial institution should be supporting it for financial > transactions. > > As of this moment, USAA is only supporting TLS 1.2 and 1.3, which are secure. > Suggest not setting any of the "special settings" options, and never enable > SSL > v2 or v3 for any program, except for testing with non-sensitive data. > > -Original Message- > From: gnucash-user > [mailto:gnucash-user-bounces+alangnuc=bigtowers@gnucash.org] On Behalf Of > Jon Schewe > Sent: Monday, May 25, 2020 10:36 AM > To: gnucash-user > Subject: [GNC] Using Quicken direct connect with USAA > > I have been using the Web Connect with USAA for years and that's worked great. > However now I see that they are discontinuing support for this feature. So I'm > trying to setup Direct Connect. I found the instructions for setting up USAA > at > https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings#USAA, > however I'm not seeing the "Server Capabilities" tab to select the account > list > download options. > > I'm using GnuCash 3.10 from flatpak. > I'm on Linux. > > I have the following Settings: > "User Settings" > User Name, User id and Client UID all set to my USAA number. I have tried both > with the 00 prefix and without. > > "Bank Settings" > Broker ID: 5874 > FID: 24591 > ORG: USAA > Server URL: https://service2.usaa.com/ofx/OFXServlet > > "Application Settings" > I've tried the default application settings and the settings that should be > for > Quicken 2017: > Application ID: QWIN > Application Version: 2600 > Header Version: 102 > > Under "Special Settings" I've tried HTTP Version blank, 1.0 and 1.1. > I've checked "Force SSLv3". > > When I go back to the "Bank Settings" tab I see the following after clicking > on > "Retrieve Account List". > > 09:26:37 Sending request... > 09:26:37 Using GnuTLS default ciphers. > 09:26:37 TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-256-GCM:AEAD > 09:26:37 Waiting for response... > 09:26:37 Operation finished, you can now close this window. > > The AqBanking Setup never lets me get to the point of associating USAA > accounts > with GnuCash accounts. Can someone give me some pointers on what is wrong > here? > > Thank you, > Jon > > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on
Re: [GNC] Using Quicken direct connect with USAA
Jon, The Application Settings I use for USAA are Application ID: QWIN Application Version: 2200 Header Version: 102 In Special Settings: HTTP Version, Client UID, and Security Type are blank, Force SSLv3 and Send Short Date are checked, and Send Empty Bank ID and Send Empty FID are unchecked. Another user had trouble with USAA because he had entered a Client UID on the User Settings page, so make sure that's blank too. Yes, SSL v3 is less secure than TLS, but it's better than sending the data in the clear, and yes, the authentication that USAA uses on OFX DirectConnect is less than ideal. Regards, John Ralls > On May 25, 2020, at 8:59 AM, Jon Schewe wrote: > > Alan, > > Thanks for the suggestion. I tried not setting any special settings and > make sure the SSL v3 is unchecked. Still no change. > > As far as security goes, this method for getting my transactions > appears less secure than using Web Connect. When I login to get to the > Web Connect download I need to enter a one time password from my phone, > but for Direct Connect I only need my PIN. > > Jon > > On Mon, 2020-05-25 at 11:48 -0400, Alan wrote: >> Jon, >> >> Disable SSL v3. Info at wiki.gnucash.org is wrong. It's not secure, and no >> reputable financial institution should be supporting it for financial >> transactions. >> >> As of this moment, USAA is only supporting TLS 1.2 and 1.3, which are secure. >> Suggest not setting any of the "special settings" options, and never enable >> SSL >> v2 or v3 for any program, except for testing with non-sensitive data. >> >> -Original Message- >> From: gnucash-user >> [mailto:gnucash-user-bounces+alangnuc=bigtowers@gnucash.org] On Behalf Of >> Jon Schewe >> Sent: Monday, May 25, 2020 10:36 AM >> To: gnucash-user >> Subject: [GNC] Using Quicken direct connect with USAA >> >> I have been using the Web Connect with USAA for years and that's worked >> great. >> However now I see that they are discontinuing support for this feature. So >> I'm >> trying to setup Direct Connect. I found the instructions for setting up USAA >> at >> https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings#USAA, >> however I'm not seeing the "Server Capabilities" tab to select the account >> list >> download options. >> >> I'm using GnuCash 3.10 from flatpak. >> I'm on Linux. >> >> I have the following Settings: >> "User Settings" >> User Name, User id and Client UID all set to my USAA number. I have tried >> both >> with the 00 prefix and without. >> >> "Bank Settings" >> Broker ID: 5874 >> FID: 24591 >> ORG: USAA >> Server URL: https://service2.usaa.com/ofx/OFXServlet >> >> "Application Settings" >> I've tried the default application settings and the settings that should be >> for >> Quicken 2017: >> Application ID: QWIN >> Application Version: 2600 >> Header Version: 102 >> >> Under "Special Settings" I've tried HTTP Version blank, 1.0 and 1.1. >> I've checked "Force SSLv3". >> >> When I go back to the "Bank Settings" tab I see the following after clicking >> on >> "Retrieve Account List". >> >> 09:26:37 Sending request... >> 09:26:37 Using GnuTLS default ciphers. >> 09:26:37 TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-256-GCM:AEAD >> 09:26:37 Waiting for response... >> 09:26:37 Operation finished, you can now close this window. >> >> The AqBanking Setup never lets me get to the point of associating USAA >> accounts >> with GnuCash accounts. Can someone give me some pointers on what is wrong >> here? >> >> Thank you, >> Jon >> >> > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Using Quicken direct connect with USAA
Alan, Thanks for the suggestion. I tried not setting any special settings and make sure the SSL v3 is unchecked. Still no change. As far as security goes, this method for getting my transactions appears less secure than using Web Connect. When I login to get to the Web Connect download I need to enter a one time password from my phone, but for Direct Connect I only need my PIN. Jon On Mon, 2020-05-25 at 11:48 -0400, Alan wrote: > Jon, > > Disable SSL v3. Info at wiki.gnucash.org is wrong. It's not secure, and no > reputable financial institution should be supporting it for financial > transactions. > > As of this moment, USAA is only supporting TLS 1.2 and 1.3, which are secure. > Suggest not setting any of the "special settings" options, and never enable > SSL > v2 or v3 for any program, except for testing with non-sensitive data. > > -Original Message- > From: gnucash-user > [mailto:gnucash-user-bounces+alangnuc=bigtowers@gnucash.org] On Behalf Of > Jon Schewe > Sent: Monday, May 25, 2020 10:36 AM > To: gnucash-user > Subject: [GNC] Using Quicken direct connect with USAA > > I have been using the Web Connect with USAA for years and that's worked great. > However now I see that they are discontinuing support for this feature. So I'm > trying to setup Direct Connect. I found the instructions for setting up USAA > at > https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings#USAA, > however I'm not seeing the "Server Capabilities" tab to select the account > list > download options. > > I'm using GnuCash 3.10 from flatpak. > I'm on Linux. > > I have the following Settings: > "User Settings" > User Name, User id and Client UID all set to my USAA number. I have tried both > with the 00 prefix and without. > > "Bank Settings" > Broker ID: 5874 > FID: 24591 > ORG: USAA > Server URL: https://service2.usaa.com/ofx/OFXServlet > > "Application Settings" > I've tried the default application settings and the settings that should be > for > Quicken 2017: > Application ID: QWIN > Application Version: 2600 > Header Version: 102 > > Under "Special Settings" I've tried HTTP Version blank, 1.0 and 1.1. > I've checked "Force SSLv3". > > When I go back to the "Bank Settings" tab I see the following after clicking > on > "Retrieve Account List". > > 09:26:37 Sending request... > 09:26:37 Using GnuTLS default ciphers. > 09:26:37 TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-256-GCM:AEAD > 09:26:37 Waiting for response... > 09:26:37 Operation finished, you can now close this window. > > The AqBanking Setup never lets me get to the point of associating USAA > accounts > with GnuCash accounts. Can someone give me some pointers on what is wrong > here? > > Thank you, > Jon > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Using Quicken direct connect with USAA
Jon, Disable SSL v3. Info at wiki.gnucash.org is wrong. It's not secure, and no reputable financial institution should be supporting it for financial transactions. As of this moment, USAA is only supporting TLS 1.2 and 1.3, which are secure. Suggest not setting any of the "special settings" options, and never enable SSL v2 or v3 for any program, except for testing with non-sensitive data. -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+alangnuc=bigtowers@gnucash.org] On Behalf Of Jon Schewe Sent: Monday, May 25, 2020 10:36 AM To: gnucash-user Subject: [GNC] Using Quicken direct connect with USAA I have been using the Web Connect with USAA for years and that's worked great. However now I see that they are discontinuing support for this feature. So I'm trying to setup Direct Connect. I found the instructions for setting up USAA at https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings#USAA, however I'm not seeing the "Server Capabilities" tab to select the account list download options. I'm using GnuCash 3.10 from flatpak. I'm on Linux. I have the following Settings: "User Settings" User Name, User id and Client UID all set to my USAA number. I have tried both with the 00 prefix and without. "Bank Settings" Broker ID: 5874 FID: 24591 ORG: USAA Server URL: https://service2.usaa.com/ofx/OFXServlet "Application Settings" I've tried the default application settings and the settings that should be for Quicken 2017: Application ID: QWIN Application Version: 2600 Header Version: 102 Under "Special Settings" I've tried HTTP Version blank, 1.0 and 1.1. I've checked "Force SSLv3". When I go back to the "Bank Settings" tab I see the following after clicking on "Retrieve Account List". 09:26:37 Sending request... 09:26:37 Using GnuTLS default ciphers. 09:26:37 TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-256-GCM:AEAD 09:26:37 Waiting for response... 09:26:37 Operation finished, you can now close this window. The AqBanking Setup never lets me get to the point of associating USAA accounts with GnuCash accounts. Can someone give me some pointers on what is wrong here? Thank you, Jon ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How do I get back the cursor highlight for rows on the account page using CSS file on Windows 10?
You e-mailed me directly about more stuff, but I don't generally check that stuff. You should always use Reply All so further messages come here. Anyway, I somewhat recently posted my full gtk.css file that I use for GnuCash, which has all my "discoveries" about different formatting that are available. Some things you might want to address may not be modifiable with a simple CSS entry. Here's the code I use to set the cursor entry line: cursor entry { background-color: goldenrod ; color:black ; } This one, I believe, is supplied in the GnuCash Wiki that discusses GTK 3.0 stuff. - Ken Farley -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] is there a transaction limit on converting xml to mysql
> On May 25, 2020, at 2:43 AM, Jeff wrote: > > With the help of another member of the GNC users group I was able to get > MySQL (on Windoze 10) to work with book files that contain a couple of years > worth of records and basically a default checkbook register setup. I need to > convert a set of books that contains 20+ years of transactions in the > neighborhood of 100 accounts and goodness knows ow many transactions. > > But every time I try to save as a MySQL file the "save as MySql" errors out > and locks up GNC after about 15 minutes (have to kill it with task manager). > The message is encountered corrupt data, and I cannot find an error log > anywhere. > > I tried exporting as a GNC CSV file and importing it into a MySQL file. Same > problem. Also tried 5 year exports, same problem. (note could not get > PostgreSQL to work either). > > Is there a maximum number of transactions that GNC will convert to MySQL? Or > is there a setting somewhere I am missing? > > Once I can get MySQL on Windoze working I will need to get it working on a > network with Windoze and Ubuntu but that is a question for later. > > Using: Version: 3.8 Build ID: 3.8b+(2019-12-29) Finance::Quote: - on Windoze > 10 Pro and Windoze 10. Also the last stable release of Ubuntu (sorry don't > remember the version, 18.04lts I think). There's no limit programmed in, though it's possible that there might be a memory leak. However if I understand correctly that it crashed importing CSV data without GnuCash in the middle it would seem to be a problem either with the data or with your MySQL installation. We're not able to provide support for database servers, it's way beyond our competence. Administering a database server is harder than it looks so we have a simple rule: In order to use one with GnuCash you must be a competent database admin for the server you choose or must have one working for you. Anything short of that puts your data at risk. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Using Quicken direct connect with USAA
I have been using the Web Connect with USAA for years and that's worked great. However now I see that they are discontinuing support for this feature. So I'm trying to setup Direct Connect. I found the instructions for setting up USAA at https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings#USAA, however I'm not seeing the "Server Capabilities" tab to select the account list download options. I'm using GnuCash 3.10 from flatpak. I'm on Linux. I have the following Settings: "User Settings" User Name, User id and Client UID all set to my USAA number. I have tried both with the 00 prefix and without. "Bank Settings" Broker ID: 5874 FID: 24591 ORG: USAA Server URL: https://service2.usaa.com/ofx/OFXServlet "Application Settings" I've tried the default application settings and the settings that should be for Quicken 2017: Application ID: QWIN Application Version: 2600 Header Version: 102 Under "Special Settings" I've tried HTTP Version blank, 1.0 and 1.1. I've checked "Force SSLv3". When I go back to the "Bank Settings" tab I see the following after clicking on "Retrieve Account List". 09:26:37 Sending request... 09:26:37 Using GnuTLS default ciphers. 09:26:37 TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-256-GCM:AEAD 09:26:37 Waiting for response... 09:26:37 Operation finished, you can now close this window. The AqBanking Setup never lets me get to the point of associating USAA accounts with GnuCash accounts. Can someone give me some pointers on what is wrong here? Thank you, Jon ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] is there a transaction limit on converting xml to mysql
This is just a guess, based upon other things I've seen in the past, but I seem to recall that in some versions of GnuCash there was a problem with the format of dates? Maybe the large file you're trying to process has some dates that are in a format that conflicts with what MySQL is expecting. You might search the archives of this forum for discussions pertaining to MySQL. Perhaps someone else has had similar problems. If my date format guess (it's a huge guess, actually) is right, you might try opening the file in question and changing the date format to something else, like ISO. I don't know if that causes any sort of "fixing", but it's a shot. I'm surprised there isn't some sort of log file being generated, but probably when you kill the process it never gets the chance to write any such output. You might have to search a bit to find out what to do to turn on debugging before you make another attempt. I believe that will provide lots of data as to what is going on. Here's the Wiki bit about that: https://wiki.gnucash.org/wiki/Tracefile My guesses are feeble, but maybe they'll help at least a bit? Good luck. - Ken Farley -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] is there a transaction limit on converting xml to mysql
With the help of another member of the GNC users group I was able to get MySQL (on Windoze 10) to work with book files that contain a couple of years worth of records and basically a default checkbook register setup. I need to convert a set of books that contains 20+ years of transactions in the neighborhood of 100 accounts and goodness knows ow many transactions. But every time I try to save as a MySQL file the "save as MySql" errors out and locks up GNC after about 15 minutes (have to kill it with task manager). The message is encountered corrupt data, and I cannot find an error log anywhere. I tried exporting as a GNC CSV file and importing it into a MySQL file. Same problem. Also tried 5 year exports, same problem. (note could not get PostgreSQL to work either). Is there a maximum number of transactions that GNC will convert to MySQL? Or is there a setting somewhere I am missing? Once I can get MySQL on Windoze working I will need to get it working on a network with Windoze and Ubuntu but that is a question for later. Using: Version: 3.8 Build ID: 3.8b+(2019-12-29) Finance::Quote: - on Windoze 10 Pro and Windoze 10. Also the last stable release of Ubuntu (sorry don't remember the version, 18.04lts I think). -- --JEffrey Black M.B.A. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Gnucash Mention
Came across this writeup on Gnucash. Guy uses it to track his personal finances and gets graphy with it. https://www.csun.io/2020/05/17/gnucash-finance.html P. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.