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

Please execute the below query to resolve the issue

#!/bin/bash
export CASSANDRA_HOME=/opt/apache-cassandra-2.1.8
export CQLSH_HOST=192.168.1.200
export CQLSH_PORT=9042
echo $@
$CASSANDRA_HOME/bin/cqlsh $@'    

Make sure to change the IP and location of cassandra Home Directory

Answer 2

If you are on OSX

brew install cassandra

First start the Cassandra

cassandra

Connect via CQL shell

cqlsh 127.0.0.1