Cassandra cqlsh - connection refused

cassandra cqlsh
Chros picture Chros · Mar 18, 2015 · Viewed 101k times · Source

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 to any servers', {'127.0.0.1': error(111, "Tried connecting to [('127.0.0.1', 9042)]. Last error: Connection refused")})

I have tried starting cqlsh up with the hosts own ip, other hosts ip, different ports yet the result remains the same - always connection refused.

Answer

jny picture jny · Mar 18, 2015

You need to edit cassandra.yaml on the node you are trying to connect to and set the node ip address for rpc_address and listen_address and restart Cassandra.

rpc_address is the address on which Cassandra listens to the client calls.

listen_address is the address on which Cassandra listens to the other Cassandra nodes.

Related questions

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
How to connect Cassandra to localhost using cqlsh?

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: …

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