New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

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

Open

vymaker opened this issue Nov 24, 2023 · 2 comments

vymaker commented Nov 24, 2023

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

The text was updated successfully, but these errors were encountered:

Contributor

popcornylu commented Nov 28, 2023

Hi @vymaker, thanks for your feedback.

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

Contributor

popcornylu commented Nov 28, 2023

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment