How to configure cassandra for remote connection

cassandra cqlsh cassandra-cli nosql
Obama picture Obama · Mar 21, 2016 · Viewed 41.8k times · Source

I am trying to configure Cassandra Datastax Community Edition for remote connection on windows,

Cassandra Server is installed on a Windows 7 PC, With the local CQLSH it connects perfectly to the local server.

But when i try to connect with CQLSH from another PC in the same Network, i get this error message:

Connection error: ('Unable to connect to any servers', {'MYHOST': error(10061, "Tried connecting to [('HOST_IP', 9042)]. Last error: No connection could be made because the target machine actively refused it")})

So i am wondering how to configure correctly (what changes should i make on cassandra.yaml config file) the Cassandra server to allow remote connections.

Thank you in advance!

Answer

ahll picture ahll · May 9, 2018

How about this:

Make these changes in the cassandra.yaml config file:

start_rpc: true

rpc_address: 0.0.0.0

broadcast_rpc_address: [node-ip]

listen_address: [node-ip]

seed_provider:
  - class_name: ...
    - seeds: "[node-ip]"

reference: https://gist.github.com/andykuszyk/7644f334586e8ce29eaf8b93ec6418c4

Related questions

How to select data from a table and insert into another table?

I want to select specific fields of a table in cassandra and insert them into another table. I do this in sql server like this: INSERT INTO Users(name,family) SELECT name,family FROM Users How to to this in …

Read More
Run cassandra queries from command line

I want to execute cql queries from bash command. [cqlsh 3.1.8 | Cassandra 1.2.19 | CQL spec 3.0.5 | Thrift protocol 19.36.2] [root@hostname ~]# /opt/apache-cassandra-1.2.19/bin/cqlsh -k "some_keyspace" -e "SELECT column FROM Users where key=value" I got: cqlsh: error: no such option: -e …

Read More
Alter cassandra column family primary key using cassandra-cli or CQL

I am using Cassandra 1.2.5. After creating a column family in Cassandra using cassandra-cli, is it possible to modify the primary key on the column family using either cassandra-cli or CQL? Specifically, I currently have the following table (from CQL): CREATE …

Read More