-1

I need some help in trying to connect to my redshift cluster from a rackspace box.

I can connect just fine from my ec2 instances and also from my local machines. I have checked (and double checked) and verified all connection parameters and they turn out fine in my code, the only difference is of the environment, i.e when I try to connect from my ec2 instances, it works fine, but when trying to connect from my rackspace boxes, I get the following error

Connection to DB failed
could not connect to server: Connection timed out
    Is the server running on host "my_redshift_cluster_host_name" (cluster_ip) and accepting
    TCP/IP connections on port <cluster_port>?
Qantas 94 Heavy
  • 15,750
  • 31
  • 68
  • 83
Saif Asif
  • 5,516
  • 3
  • 31
  • 48

1 Answers1

1

In amazon console, For your redshift cluster , under security, in your security group could you check if you have added public IP under ( CIDR/IP) for backspace box ?.

You need to authorise public IP for rackspace box.

Sandesh Deshmane
  • 2,247
  • 1
  • 22
  • 25
  • I have a security group that is of `CIDR/IP` connection type with details `CIDR/IP:0.0.0.0/0`. Is this for a public setting? – Saif Asif Nov 04 '14 at 15:01
  • 1
    You need put public ip 123.123.123.123/32 in CIDR/IP in redshift security group. Put public IP of your Rackspace box here. – Sandesh Deshmane Nov 04 '14 at 18:06
  • 1
    Turns out it was just the iptables restricting the port on my rackspace box. Resolved it by adding an excrption for the particular port. – Saif Asif Nov 07 '14 at 20:48