server certificate for "XXXXX" does not match host name "localhost" - Githubissues

InfuseAI / piperider

Code review for data in dbt

https://www.piperider.io/

Apache License 2.0

478 stars 23 forks source link

server certificate for "XXXXX" does not match host name "localhost" #931

Open vymaker opened 9 months ago

vymaker commented 9 months ago

Describe the bug

New to piperider (looks promising!).

Connected to redshift in a private subnet via ssh tunneling.

piperider diagnose throws an error due to mismatching certificate name.

server certificate for "XXXXX" does not match host name "localhost"

Funny that piperider compare runs actually all dbt commands until throws another error

Tried to add sslmode:prefer in dbt-settings as it is recommended here. But no help.

Desktop (please complete the following information):

OS: macOS Sonoma 14.1.1
Python Version; 3.9.18

popcornylu commented 9 months ago

Hi @vymaker, thanks for your feedback.

It seems the settings is redshift specific settings sslmode. We will evaluate and prioritize it. Thanks.

popcornylu commented 9 months ago

Configure sslmode in the sqlalchemy.

https://stackoverflow.com/questions/46033456/error-when-connecting-to-redshift-server-certificate-does-not-match-host-name

create_engine(connection_string, connect_args={'sslmode': 'prefer'})