The extension 'SQLTools PostgreSQL/Cockroach Driver' wants to sign in using SQLTools Driver Credentials.

[Yahud100]

While programmatically connecting to the database using the method:

conn = await this._setConnection(conn as IConnection).catch(e => this.errorHandler('Error opening connection', e));

a pop-up frequently appears:
'The extension "SQLTools PostgreSQL/Cockroach Driver" wants to sign in using SQLTools Driver Credentials.'

After allowing, another prompt requests the password:
"Optionally use the key button to store the password securely until you sign out using the 'Accounts' menu."

Although the connection to the database succeeds, this behavior is inconsistent.
Key Questions to Address:

1. What triggers the pop-up sporadically despite prior connections?
2. How can this behavior be disabled for smoother automated connections?
3. Is it related to credential storage or session handling issues?
   Clear insights and resolution steps are required to eliminate these disruptions.

[gjsjohnmurray]

While programmatically connecting to the database using the method:

conn = await this._setConnection(conn as IConnection).catch(e => this.errorHandler('Error opening connection', e));

I'm not clear whether you are doing this is code of your own, or if your comment refers to this line in the source of the SQLTools extension:

vscode-sqltools/packages/plugins/connection-manager/extension.ts

Line 205 in 91fa2b9

conn = await this._setConnection(conn as IConnection).catch(e => this.errorHandler('Error opening connection', e));

a pop-up frequently appears:

I assume when you use the Edit Connection option from the context menu of your connection definition in the SQLTools Connections tree. then the Use password field is set to SQLTools Driver Credentials

Does your VS Code Accounts menu (from the person icon near the bottom of Activity Bar) show any entries ending in (SQLTools Driver Credentials)?

The first popup is informing you that the PostgeSQL/Cockroach driver wants to use the authentication provider that the main SQLTools extension implements.

When you enter your password at the second prompt are you clicking the key icon in order to save the password? Or are you simply pressing Enter?

If you do not use the key icon at this point then I would expect you to get both prompts again if you close/reopen your VS Code window, or run the Developer: Reload Window command from Command Palette (F1).

If you do use the key icon I wouldn't expect either prompt to reappear unless you use the Sign Out option from the corresponding entry on the Accounts menu of VS Code.

[Yahud100]

Thank you for your detailed response. I would like to address your points and provide additional context about my use case and observations.

1.Using a Connection Object from Connection List

I am programmatically connecting to the database using the following line:
conn = await this._setConnection(conn as IConnection).catch(e => this.errorHandler('Error opening connection', e));
Instead of following the complete selectConnection method flow, I am bypassing certain validations (e.g., dependencies and connIdOrNode checks).

I fetch the IConnection object directly using:
const connList = this.getConnectionList(ConfigurationTarget[writeTo] || undefined); and pass one of the connection objects as a parameter to _setConnection.
Is this approach valid for establishing a connection programmatically?

2. Account Sign-In and Credential Storage

• I am not signed in to any VS Code accounts (Accounts menu shows: "You are not signed in to any accounts"). Due to restrictions, I cannot sign in.
• When prompted to allow the extension to sign in using SQLTools Driver Credentials, I noticed that the key icon does not work for saving the password. Additionally, there is no indication or error message stating that account sign-in is required to enable this functionality.

Is it possible to bypass these popups and provide the password programmatically, ensuring a seamless connection without requiring account sign-in?

3. Behavior of the "Use Password" Field

• I have observed that whenever the popup appears, the Use Password field is already set to SQLTools Driver Credentials, even though I have not explicitly configured it to do so.
• My Accounts menu does not display any entry for SQLTools Driver Credentials.

What could be causing the Use Password field to default to SQLTools Driver Credentials?

4. Insights from Code Investigation

• Upon reviewing the source code, I noticed that during the connection process, the resolveConnection method validates whether the password is defined. If the password is undefined, the popup prompts the user for credentials.
• However, I encounter the popup even when the connection is already established successfully, which seems redundant. Despite the popup, I can execute queries, so the password prompt appears unnecessary in this scenario.

Could you provide insights on why the password is being flagged as undefined or why the popup appears despite a successful connection?

My Use Case

I am working within a Theia-based environment (not VS Code) and executing SQLTools commands programmatically. My workflow is as follows:

1. Fetch an IConnection object from the connection list (which includes connectionName, server, username, password, database, etc.).
2. Establish a connection using _setConnection.
3. Execute queries using executeQuery and retrieve results.

While this workflow functions, the repeated password prompt disrupts automation. Suggestions to streamline this process and eliminate the popups would be greatly appreciated.

Thank you in advance for your guidance and recommendations!