Question: OS: CentOS 6.4 (server)

I have successfully installed (yum install dsc20) the cassandra database layer in my server and can connect to it using the CQL SHel (cqlsh). But I need to run queries remotely using the DataStax's DevCenter software. So I installed it (DevCenter) in a separate workstation. (CentOS 6.4 - desktop) and tried to add a new connection in order to connect to the cassandra db.

So I gave the IP of the "CentOS 6.4 - server" (in which cassandra database is running) for the host and the port as 9160. But when testing the connection it fails.

I also tried to turn off the firewall in the server, (/etc/init.d/iptables stop). But was no luck.

I'm sure this may be due to some misconfiguration which I cannot figure out. I'll be grateful, if someone can give me a solution for this as I was researching for this and found no answers. Thank you very much in advance.

Answer: 
Try this.. It worked for me!

Run the following command on your machine where you have DevCenter installed

```
$> ssh -L 9042:localhost:9042 <username>@<ip-address-cassandra-db> -N

```

*After running this command, it will prompt for password*

Now in your DevCenter > Contact Hosts, provide "127.0.0.1" and test connection. Bingo, you see the magic...
If there's somebody working with docker locally, it can run this command.

```
docker run --name cassandra -p 127.0.0.1:9042:9042 -p 127.0.0.1:9160:9160 
-e CASSANDRA_LISTEN_ADDRESS=localhost 
-e CASSANDRA_BROADCAST_ADDRESS=localhost
-e CASSANDRA_RPC_ADDRESS=localhost -d cassandra

```