search

mtxr / vscode-sqltools

Database management for VSCode
https://vscode-sqltools.mteixeira.dev?utm_source=github&utm_medium=homepage-link
MIT License
1.49k stars 300 forks source link

ERROR: Error opening connection Hostname/IP does not match certificate's #746

Open niraj8241 opened 3 years ago

niraj8241 commented 3 years ago

Describe the bug Trying to setup a Redshift Connection using a AWS Privatelink connection. The Privatelink URL is a completely separate URL than Redshift hostname. But I can connect to Redshift using standard SQL Client using JDBC/ODBC. When I try to use this privatelink URL in SQLTools. I get the certificate mismatch error. I tried adding "rejectUnauthorized": false but that doesn't help.

To Reproduce Steps to reproduce the behavior:

  1. Go to 'Connect to AWS Redshift using a PrivateLink URL'

Expected behavior Should work by ignoring the hostname certificate warning.

Desktop (please complete the following information):

leomatter commented 2 years ago

i have the same connecting with ssl to a GCP postgres server Error opening connection Hostname/IP does not match certificate's altnames: Host: localhost. is not cert's CN: hayry-332210:hayrydb connecting with psql or knex works..

i know it seems unrelated, but I think there could be a more general issue with ssl