Cant reach Redshift cluster from outside, or kinesis

Question

(technically I really want to make kinesis talk to redshift, but I'm debugging redshift permissions via my outside IP address)

I have enabled external access in the redshift configs.
I'm using the redshift endpoint url, which resolves to a public IP
I have added a inbound rule to the security group specified in the "Network and security settings" to allow ping.
Also for port 5439

But I still cant ping or connect to the JDBC port. What am I missing??

Answer

Hello,

Please follow the below document link for further troubleshooting and let me know if the steps helped you.

Link- https://aws.amazon.com/premiumsupport/knowledge-center/cannot-connect-redshift-cluster/

Answer

Hi.

Try the following things:
1. select your Redshift cluster and go to `Actions -> Modify publicly accessible setting` and select `Turn on Publicly accessible`
2. go to `Properties` tab
  2.1 in `Network and security settings` section you should have `Publicly accessible: Enabled `
  2.2 find `VPC security group` sections and click the security group link and check the `Inbound rules`. You should allow all traffic to port 5439
  2.3 if you want allow access only from your IP address, in `Edit inbound rules Info` select `My IP` in `Source` section

**Security groups Inbound rules**
![Enter image description here](/media/postImages/original/IM7SXBPrALTj-PC4TwZvCGrQ)

In general, it should not be a problem: make sure you have a cluster publicly accessible and in security groups you allow traffic to the Redshift port.

Cant reach Redshift cluster from outside, or kinesis

Relevant content