Vscode-sqltools: "self signed certificate" issue when creating new DB connections

[tchase56]

I noticed in v0.22.10 when I create a new connection I get a "self signed certificate" issue when testing the connection. This seems to be due to the "rejectUnauthorized" setting under "node-pg driver specific options". It says that the default behavior should be set to True but it should only have an effect if "requestCert" is set to True (requestCert is False by default).

When I check and uncheck the "rejectUnauthorized" setting my connection works as it did before the update (this forces that setting to be False. This seems like a bug since "rejectUnauthorized" should only have an effect if "requestCert" is set to True (it is not by default).

[malcolmvincent]

Tried installing for the first time running against a local pgsql instance and get the same error. Checking / unchecking makes the test work, but doesn't work to actually run any queries which give the same error message.

[gordonlau]

I also encountered this issue. I discovered that you can only work around the issues by check and uncheck both rejectUnauthorized and requestCert. Then everything works after this hack.

[bikeshedder]

You can manually edit the settings and remove the pgOptions.ssl stuff which also disables the use of SSL.

Remove this:

"pgOptions": {
    "ssl": {}
},

Or change it to:

"pgOptions": {
    "ssl": false
},

[pablo-evanson]

Quick note to get the fix above to work cause this had me confused, the "pgOptions" setting (I thought it must be a sqltools setting) is inside the connection settings so you fill everything with the gui, then select Open settings at the bottom and then Edit in settings.json there you'll find the part that needs to be modified, works like a charm.