Unable to connect with cqlsh, "Tried connecting to [('127.0.0.1', 9042)]. Last error: Connection refused"

Question

question

igor.rmarinho_185445 asked · Feb 21 at 11:04 PM

Unable to connect with cqlsh, "Tried connecting to [('127.0.0.1', 9042)]. Last error: Connection refused"

Hi, I'm having this issue below, I'm using google cloud VM

$ cqlsh
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 set my hosts like this

127.0.0.1 localhost
10.14*.0.* vm-1
10.15*.0.* vm-2

I got the ip from ifconfig

vm-1 inet addr:10.14*.0.* Bcast:10.14*.0.* Mask:255.255.255.255
vm-2 inet addr:10.15*.0.* Bcast:10.15*.0.* Mask:255.255.255.255

I set in VM-2 in cassandra.yaml

listen_address: 10.15*.0.*
rpc_address: 10.15*.0.*

and in cassandra-env.sh

JVM_OPTS="$JVM_OPTS -Djava.rmi.server.hostname=10.15*.0.*"

I already tried everything I could But I cant fix it, please help.

cassandra cqlsh

1

10 |1000 characters needed characters left characters exceeded

Attachments: Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

Aleks Volochnev ♦ · Feb 25 at 02:34 PM

Where exactly do you run this `cqlsh` command, on one of these two VMs? Can you try to log in directly via ssh and try to execute the command? What's the `nodetool status`?

0 · ·

Answer 1 · 2020-02-21T23:18:41Z

Erick Ramirez answered · Feb 21 at 11:18 PM ACCEPTED ANSWER

@igor.rmarinho_185445 The reason you can't connect to the cluster is because you haven't specified an IP address to cqlsh so it defaults to localhost (127.0.0.1).

For example, if the node's listen_address is 10.150.0.1 then the command to connect is:

$ cqlsh 10.150.0.1

For more info, see the cqlsh startup options page on the DataStax Docs site. Cheers!

Share

10 |1000 characters needed characters left characters exceeded

Attachments: Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

Answer 2 · 2020-02-24T13:31:29Z

Cedrick Lunven answered · Feb 24 at 01:31 PM

Might be obvious but

you obfuscated the real values with * characters.

We don't use wild chars in cassandra.yaml

Share

10 |1000 characters needed characters left characters exceeded

Attachments: Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

question