Bringing together the Apache Cassandra experts from the community and DataStax.

Want to learn? Have a question? Want to share your expertise? You are in the right place!

Not sure where to begin? Getting Started

 

question

aravinth_chakravarthyr_173918 avatar image
aravinth_chakravarthyr_173918 asked ·

What could cause "ConnectionShutdown('Connection to remoteip was closed')"?

Hi

we are trying to connect to a remote host with cqlsh with the following command

cqlsh remotehostip remotehostport -u username

we are getting the following error

Connection error: ('Unable to connect to any servers', {'remoteip': ConnectionShutdown('Connection to remoteip was closed',)})

Telnet of hostname and port number ( remote host )is working fine from my local machine

Can you please help us to resolve this issue . what would be the cause for issue?

NOTE:I have a doubt if we have ssl enabled in that cluster and if we are not passing them with cqlsh command , do we get the above error for that

dse
1 comment
10 |1000 characters needed characters left characters exceeded

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

hi,


1) Make sure the service is running:

$ ps aux | grep cassandra

2) Make sure you are using the correct IP by checking the server config:

$ run this command on the cassandra node:

ifconfig

3) Ensure you can connect to that IP from the server you are on:

$ ssh user@xxx.xxx.xx.xx

4) Check the node's status and also confirm it shows the same IP:

$nodetool status

5) run the command to connect with the IP (only specify port if you are not using the default):

$ cqlsh xxx.xxx.xx.xx


Best regards,


Dieudonne

0 Likes 0 · ·

1 Answer

Erick Ramirez avatar image
Erick Ramirez answered ·

@aravinth_chakravarthyr_173918 The error you posted is unfortunately too generic to speculate on what the problem is. If re-run the command with the --debug flag, it would generate additional information that would hopefully give us clues.

We recommend doing an isolation test by running the same command locally on the node itself:

  • If it's working -- we know that it's some network connectivity between your laptop/PC and the node.
  • If it's not working -- we know that it's a problem with either the IP address or port you're trying to connect to.

Also when you attempt to connect again, check the logs on the node to see what warnings/errors/debug messages get logged which will also give you clues. Cheers!

Share
10 |1000 characters needed characters left characters exceeded

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