Hi, osx user here.
I have installed a simple Cassandra db on my laptop and I would like to query it outside the Lan.
So I set port forwarding and port triggering on my router (vodafone station) to link external 9042 to internal 9042.

Moreover I set on cassandra.yaml the broadcast_rpc_address to my router ip.

Unfortunately, when I try to connect using java api I obtain:

Exception in thread "main" com.datastax.driver.core.exceptions.NoHostAvailableException: All host(s) tried for query failed (tried: /HERE_THERE_IS_ROUTER_IP:9042 (com.datastax.driver.core.exceptions.TransportException: [/HERE_THERE_IS_ROUTER_IP:9042] Cannot connect))

I noted that without setting broadcast_rpc_address I can reach Cassandra trough 127.0.0.1 so the database is active and running.

I’ve also tried  

lsof -n -i4TCP:9042 | grep LISTEN

and I obtain 

java    7555 giordano  184u  IPv4 0x513195612572e265      0t0  TCP 127.0.0.1:9042 (LISTEN)

when I unset broadcast_rpc_address
and no output when I set broadcast_rpc_address.
Is the problem in the yaml settings on in the router settings?


P.S.: I have also modifying listen_address in the same way, without good news.
P.P.S: clearly each time I edited the yaml file I restarted cassandra