How to connect Cassandra to localhost using cqlsh?

cassandra cqlsh
Albert Lim picture Albert Lim · Jun 1, 2014 · Viewed 83.5k times · Source

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

LeGeekDOzoZoo picture LeGeekDOzoZoo · Sep 9, 2014
  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

Related questions

Cassandra cqlsh - connection refused

I've just started working with Cassandra (datastax), version 2.1.3 and cqlsh version 5.0.1. Cassandra starts up fine and the cluster is operational instantly. Cqlsh is not working (on any of the nodes) and emits the following error: Connection error: ('Unable to connect …

Read More
Cassandra cqlsh Unable to connect to any servers - 127.0.0.1:9160 (closed)> is already closed

I installed Cassandra on OSX. When trying to run cqlsh from /bin/, I get the following error: > Connection error: ('Unable to connect to any servers', {'127.0.0.1': > ConnectionShutdown('Connection <AsyncoreConnection(4522252560) > 127.0.0.1:9160 (closed)> is already closed',)}) I …

Read More
Export cassandra query result to a csv file

I'm new in cassandra, and I have to export the result of a specific query to a csv file. I found the COPY command, but (from what I understand) it allows you only to copy an already existing table to …

Read More