dse-driver connection refused

Question

I am trying to connect to my Datastax enterprise Cassandra install on a server. When I try to connect I receive an error:

Cassandra connection error  { [Error: All host(s) tried for query failed. First host tried, XX.XX.XX.XX:9042: Error: connect ECONNREFUSED XX.XX.XX.XX:9042. See innerErrors.]
  innerErrors:
   { 'XX.XX.XX.XX:9042':
      { Error: connect ECONNREFUSED XX.XX.XX.XX:9042
          at Object.exports._errnoException (util.js:896:11)
          at exports._exceptionWithHostPort (util.js:919:20)
          at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1073:14)
        code: 'ECONNREFUSED',
        errno: 'ECONNREFUSED',
        syscall: 'connect',
        address: 'XX.XX.XX.XX',
        port: 9042 } },
  info: 'Represents an error when a query cannot be performed because no host is available or could be reached by the driver.',
  message: 'All host(s) tried for query failed. First host tried, XX.XX.XX.XX:9042: Error: connect ECONNREFUSED XX.XX.XX.XX:9042. See innerErrors.' }

I am guessing something in cassandra.yaml is restricting connection to localhost?

Any help would be super appreciated! My cassandra.yaml is a bit too long to post, if needed I can publish a link

Answer 1

The answer was in /etc/dse/cassandra/cassandra.yaml

broadcast_rpc_address: <node_address (ex: 127.0.0.1)>
rpc_port: 9160 # <-- Probably, unless you changed it
listen_address: localhost # <-- Cassandra to cassandra communication