Problem to connect to AWS Redshift with the AWS Redshift connector

[webfacto]

Hello,

I have some issues to use the Amazon Redshift connector to reach my Serverless Redshift instance.

My instance is well reachable through a database client (ex dbeaver), but not with the connector.

When I try to connect it, I have the following error:

Sorry, we encountered an error and were unable to complete your request.

The request returns an 400 HTTP error with the following reason error: JDBC_HOST_NOT_REACHABLE

Has anyone ever had the same problem?

Thanks for advance for your help and support 🙂

[webfacto · Accepted solution]

Ok we found a solution. We must enable the SSL and use the file downloaded here https://docs.aws.amazon.com/redshift/latest/mgmt/connecting-ssl-support.html

The connector asks for a .pem file, but you have to fill out with the .crt downloaded on the above link

[Roderick]

Thanks @webfacto for coming through with a solution! 

[Tudor]

@webfacto thanks! you saved me hours!