Can't connect to cassandra node from different

问题:

I have a cassandra node at a machine. When I access cqlsh from the same machne it works properly.

But when I tried to connect to it's cqlsh using "192.x.x.x" from another machine, I'm getting an error saying

Connection error: ('Unable to connect to any servers', {'192.x.x.x': error(111, "Tried connecting to [('192.x.x.x', 9042)]. Last error: Connection refused")})

What is the reason for this? How can I fix it?

回答1:

Probably the remote Cassandra node is not bound to the external network interface but to the loopback one (this is the default configuration). You can ensure this by using "telnet thecassandrahost 9042" from the remote machine, it should not work.

In order to bind Cassandra to the external network interface you need to edit the cassandra.yaml configuration file and set the properties "listen_address" and "rpc_address" to your remote IP or "0.0.0.0" (not all versions of Cassandra support wildcard addresses).

Check also that the firewall is properly configured or disabled (sudo service iptables stop).

回答2:

Set the config parameter where this file is located. Possibly /etc/cassandra/cassandra.yaml.

cassandra.yaml

listen_address: 192.x.x.x
rpc_address: 192.x.x.x

Then, restart the service.

回答3:

1.Update：./conf/cassandra.yaml

rpc_address: 0.0.0.0 ("0.0.0.0" allow anywhere IP,but you can appoint an IP)

\# broadcast_rpc_address: 1.2.3.4 (Delete comment if pc_address=0.0.0.0)

2.restart

./bin/cassandra

Case: I met a problem that I can't remote access cassandra When I using java access cassandra

回答4:

I got the same issue. And I am following answer in this post. Unfortunately, I have no luck to make it work. I did some research. And it works now. Here is my change.

• Environment Ubuntu Server 16.04.3 LTS on VirtualBox, DSE version 5.1

• Install DSE

I am installing DSE follow this page https://docs.datastax.com/en/dse/5.1/dse-dev/datastax_enterprise/install/installGUIdse.html

• Go to /etc/dse/cassandra/cassandra.yaml
• Change 'seeds' from 127.0.0.1 to {seriver ip} exp. mine is 172.20.10.9
• listen_address In DSE 5.1 official document says 'Never specify 0.0.0.0; it is always wrong.' What I did is comment out 'listen_address' setting
• 'rpc_address' change from localhost to 0.0.0.0
• 'broadcast_address' change to server IP. Mine is 172.20.10.9
• 'broadcast_rpc_address' change to server ip
• restart dse wait for couple minute,it is changing. If still not work, restart machine.

This is my log in 15 seconds. `ubuntu08@ubuntu08:~$ nodetool status nodetool: Failed to connect to '127.0.0.1:7199' - ConnectException: 'Connection refused (Connection refused)'. ubuntu08@ubuntu08:~$ nodetool status

Error: The node does not have system_traces yet, probably still bootstrapping ubuntu08@ubuntu08:~$ nodetool status

Datacenter: SearchGraphAnalytics

Status=Up/Down |/ State=Normal/Leaving/Joining/Moving -- Address Load Tokens Owns Host ID Rack UN 10.0.0.44 278.51 KiB 32 ? 19db0016-df63-4470-9921-f3b5fe4e9341 rack1 `

• I can access by run 'cqlsh 172.20.10.9' from local or another machine.

This is another document for Cassandra https://docs.datastax.com/en/developer/java-driver/3.3/manual/address_resolution/

回答5:

Even after I set the RPC_ADDRESS, it didn't work for me , until I set the -e CASSANDRA_START_RPC=true option.

It was always set to false in my case. I have tried this with Ubuntu, Docker and Cassandra.

回答6:

Set the following config parameter in cassandra.yaml file (For CentOS it is located in /etc/cassandra/default.conf)

rpc_address: 0.0.0.0

Verify that following values are same as below(usually they are default)

start_native_transport:true

native_transport_port:9042

Last step for CentOS , Update the firewall configuration and allow port 9042 through for incoming connections

1. Access the firewall from “System / Administration / Firewall” in the CentOS menu
2. Add the port under “Other Ports”

回答7:

I have the same question I edit cassandra.yaml set listen_address and roc_address as ip address resolve the problem.