How to connect Cassandra to localhost using cqlsh?

Question

I set rpc_port to the public IP address, and now I can connect to Cassandra just fine from an outside server.

However, I cannot connect from the Cassandra server itself, using cqlsh

I am getting an error.Thar are:

 Connection error: Could not connect to localhost:9160 

Is there a configuration, I can change to be able to connect from the server itself ?

Answer 1

1. Check the cassandra.yaml file on the line with rpc_port : normally by default = 9160
2. Login to the machine hosting cassandra
3. Try cqlsh 127.0.0.1 9160 : should be ok in any case
4. try cqlsh [IP of host] 9160 : if ok then cassandra reachable from lan, if ok then cassandra is not reachable from lan but only localhost 127.0.0.1

Answer 2

You need to connect to cassandra through the rpc_address defined in cassandra.yaml. For example, I use cqlsh 10.0.80.49 9160.