Passwords failing to Save

[A-Matt]

Please answer the questions below, it helps us to track the issue.

1. Which driver are you using and version of it (Ex: PostgreSQL 10.0): MySQL 5.7

2. Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81): Build 210

3. The steps to reproduce this issue:

• Go into a Connection edit screen.
• Place a new password in
• Test to confirm connection is working
• Hit Save
• Select the connection to open
• Fails to connect as no password is provided.

This has started to occur since about a week after using 210. Noticed that one of the connections failed for myself and a colleague on iOS device. However every week or so now my Password is entirely forgotten without even editing the connection. I can reset my reset my password for the server and paste in the randomly generated password (which I don't want to know or remember for safety):

• Test works fine
• Hitting Connect works fine (but doesn't save in the connection)
• Hitting save, fails almost every time and editing or connecting confirms no password.

All other connections have lost their password, but this one is the one I use actively and has caused me the most problems.

[samhotchkiss]

This started happening for me around the same time

[A-Matt]

Noticed that this seems to have fixed itself for myself. 😕 Presume something behind the scenes (OTA Update or something) has fixed it.

[huyphams]

We haven't released any updates for the past 30 days. I'm not sure where is the root cause of this issue. Let me explain.

1. TablePlus will generate a long random password (we called the master password) when you run the app for the first time and it saves this password in the windows credential manager.

2. TablePlus will use the master password to encrypt the database credentials you enter in the connections (database password and ssh password).

By using a unique password for each device, we can make sure that your credentials are safe. No one can decrypt the credentials file without the master password, which is protected by Windows Credentials Manager - a standard for storing passwords in Windows (similar to Apple Keychain).

The issue could be:

1. TablePlus has failed to save the master password into the windows credential manager.
2. TablePlus has failed to save the encrypted file or the encrypted file was swiped by some cleaner apps.

What do we do now to fix 1 ad 2:

1. We will make a better error report that tells the user whenever the app failed to read/write credentials manager, at least we will have a clue.

2. We're using plist format (before encrypted) for the encrypted database credentials file which is not supported by windows. We use it as TablePlus supports sync connection between devices (via the private cloud). We will move away from plist, but we need to do it on both macOS and Windows at the same time - working on it.

[A-Matt]

For a better understanding? Is Windows currently all local towards it's storage of Passwords? I.E. there's no network required for Saving & Backing up ETC.

Still confused as to how this would have been caused in the first place and how it seems to have solved itself.

Luckily I'm familiar with a lot of these processes as I have used these in a few of the projects I use on my normal GitHub Account (This is my Work / Business focused one)

[huyphams]

Is Windows currently all local towards it's storage of Passwords? I.E. there's no network required for Saving & Backing up ETC.

Yep, all passwords are stored locally. The app works offline.

Still confused as to how this would have been caused in the first place and how it seems to have solved itself.

Could be 1 or 2 (above).

[A-Matt]

So this has occurred yet again for me. 😢

I've even gone and deleted the Credential Manager for TablePlus. Re-opened TablePlus, it notices it's gone, and requires all passwords be reset and I though that this would ideally solve the issue again temporarily. However even upon saving a password again it fails to store it and gives the same warning message of no password provided.

Considering this is basically entirely breaking the functionality of using the software having to reset my Password each time I open it up, is there any chance this could be raised or if I could provide any more assistance with getting this solved.

Looking at the suggested reasons: Fails to save master password:

• I can see the new entry inside of Credential Manager (which provides less suggestion to this being an issue)

Failed to save Encypted file or swiped by a cleaner app

• We run Bit Defender and have done for a while.
• No warnings are given from it for removal of a file etc.

Thanks!

[huyphams]

Hi @A-Matt we've fix a bug that could lead to this issue, if you have a chance, please install this patch: https://www.dropbox.com/s/ujf66ftbcc587o1/TablePlusUpdate.exe?dl=0

Please let me know if you're still seeing the issue.

[YoranBosman]

I installed the updated (windows 11) and it is indeed saving the passwords now

[A-Matt]

Downloaded and upon first testing of putting my password in and using the Save button instead of connect it's working 😄 Will give it a go throughout today, and be back later today / tomorrow with how it's gone.

Just to confirm it does still register as version 220?

---

After closing my connection and trying to re-open it, the password has already been lost 😅 Retrying it seems to have worked fine, but strange to this occurring at least the first time.

[A-Matt]

Sadly this update appears to have not solved my problem. 😢 Had a connection open, slept laptop and connection stayed open over night, coming back in the morning and It's able to reload the login after a CTRL + SHIFT + R. But after closed the window and re-opening the connection provides no password saved.

Edit: Seems to have improved the consistency of it, but there's def been the odd moment of it failing, as mentioned before. Continuing throughout the day has been fine closing and re-opening the connection / software.

[A-Matt]

After the week of usage, this has greatly reduced the issues I have had with passwords not saving! ♥ There's been the one or two hiccups which I can't specifically correlate to anything besides possibly sleeping my laptop with connection open (reloading the space works fine) to cause the issue of it forgetting.

This is def an improvement over what had happened previously! 🙌

[A-Matt]

Noticed that we now have build 224, Does this include the changes made in the Update above?

[huyphams]

Yes, it does @A-Matt

[YoranBosman]

226 build here but now it has come back, anyone else?

[TheHKF]

having the same issue

[A-Matt]

:) Given that no one else has had this issue in over 2 years and the issue appears to have been relatively cleaned up from my experience, I'll be closing this issue finally. 🎉