search

kj-9 / sqltools-redshift-driver

redshift driver for vscode sqltools extention
MIT License
4 stars 1 forks source link

Connecting to AWS Redshift #7

Closed ginokhumz closed 10 months ago

ginokhumz commented 1 year ago

Hi So when I try connect to Redshift with SSL off I get the following error

no pg_hba.conf entry for host "::ffff:10.81.0.71", user "tes_dev", database "dev", SSL off

When I turn on SSL I get the following error

Hostname/IP does not match certificate's altnames: Host: localhost. is not in the cert's altnames: DNS:*.cunpqpffnysy.eu-west-1.redshift.amazonaws.com

I'm using

How do I solve this issue?

Thank you

focused commented 10 months ago

+1 I have the same issue, but I did not try an SSL connection.

finalgrrrl commented 10 months ago

having this same issue (including with SSL).

finalgrrrl commented 10 months ago

fyi @ginokhumz @focused i checked requestCert and was able to connect.

ginokhumz commented 10 months ago

@finalgrrrl Can you please elaborate a bit on what you mean.

Thanks

finalgrrrl commented 10 months ago

@finalgrrrl Can you please elaborate a bit on what you mean.

i was seeing the same errors. when you enable SSL, several configuration options for SSL appear. enabling the requestCert option in that UI allowed me to connect.

ginokhumz commented 10 months ago

@finalgrrrl You are a Godsend. That fixed my issue. I also toggled rejectUnauthorized on and off and it ended up connecting.