Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Cannot update or remove passwords saved with SQLTools Driver Credentials #1429

Closed
4 tasks
don-sherwood-churchofjesuschrist opened this issue Jan 24, 2025 · 2 comments

Comments

@don-sherwood-churchofjesuschrist
Copy link

don-sherwood-churchofjesuschrist commented Jan 24, 2025

I created several PostgreSQL connections, using the option "SQLTools Driver Credentials", which is supposed to store the password securely using the mac keychain. Since then, the password for my server has been rotated, and there is no way to update or remove the password that SQLTools has stored. I have tried deleting the connection, but when I create a new connection with the same name, it still has the previously stored password.

Steps to reproduce the behavior:

  1. Create a new PostgreSQL connection, filling in the correct server, port, username and database for your data source, keeping the setting for "Use password" set to the default, "SQLTools Driver Credentials".
  2. Click "Test Connection"
  3. When prompted for the password, type in an incorrect password, and click the keychain icon to store it securely.
  4. See the error about password authentication failed (expected)
  5. Save the connection and try to connect again. Notice it does not prompt for a password, because it already has one stored.

Expected behavior
There should be a way to update and/or remove the password stored in the keychain

Desktop (please complete the following information):

  • SQLTools Version 0.28.3
  • VS Code Version: 1.96.4
  • OS: Mac
  • Driver:
    • [ X ] PostgreSQL/Redshift
    • MySQL/MariaDB
    • MSSQL/Azure
    • SQLite
    • Other? Which...

Additional context
Deleting and recreating the connection does not solve it. The stored password matches the connection name and user name, so the new connection finds and uses it.

@gjsjohnmurray
Copy link
Collaborator

The Accounts button (person icon) near the bottom of the Activity Bar should give you a way to sign out a connection and delete the stored password.

@gjsjohnmurray gjsjohnmurray added needs more info Awaiting response from reporter and removed triage labels Jan 27, 2025
@ansge88
Copy link

ansge88 commented Feb 4, 2025

The Accounts button (person icon) near the bottom of the Activity Bar should give you a way to sign out a connection and delete the stored password.

worked for me, ty

@gjsjohnmurray gjsjohnmurray removed the needs more info Awaiting response from reporter label Feb 4, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants