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

[vymaker]

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]

Hi @vymaker, thanks for your feedback.

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

[popcornylu]

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'})