Execution exception[[NoHostAvailableException: All host(s) tried for query failed

[getyesh@megam.io]

Anyone encountered this problem? I have scyllaDB setup on a VM and i try to connect to it, i get this error. I just set it up as per this http://www.scylladb.com/doc/getting-started-ubuntu/ and created tables and such with cqlsh, now trying to read from local. This seems to be a common issue, am I missing any step? Thanks in advance

play.api.Application$$anon$1: Execution exception[[NoHostAvailableException: All host(s) tried for query failed (tried: /ip:9042 (com.datastax.driver.core.TransportException: [/ip:9042] Cannot connect))]]
     at play.api.Application$class.handleError(Application.scala:296) ~[play_2.11-2.3.9.jar:2.3.9]
   at play.api.DefaultApplication.handleError(Application.scala:402) [play_2.11-2.3.9.jar:2.3.9]
   at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$14$$anonfun$apply$1.applyOrElse(PlayDefaultUpstreamHandler.scala:205) [play_2.11-2.3.9.jar:2.3.9]

[Avi Kivity]

Can you give the command line you used to connect?

"/ip:9042" in the error leads me to guess you did not substitute the server IP address bit instead wrote "ip", but it may be a badly formatted error message.

--
You received this message because you are subscribed to the Google Groups "ScyllaDB users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to scylladb-user...@googlegroups.com.
To post to this group, send email to scyllad...@googlegroups.com.
Visit this group at https://groups.google.com/group/scylladb-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/scylladb-users/0d9ffbb1-32db-4e42-9d63-bd754013d7db%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[getyesh@megam.io]

No no, I gave the right IP,.  when I do a nodetool status inside the VM, I get the node in UN mode(Up and Normal) with the public ip. Before it was 127.0.0.1, and I changed it. Still I get the same error. 

[Avi Kivity]

All right, but what command did you give that resulted in the error?

To view this discussion on the web visit https://groups.google.com/d/msgid/scylladb-users/17baeba2-21dc-40f9-981f-59b222227a3e%40googlegroups.com.

[getyesh@megam.io]

OKay, sorry for not clearly giving the picture before.

I followed the scyllaDB getting started and installed it, then nodetool status gives me a node in UN mode, but with 127.0.0.1, I changed in scylladb.yml and now it displays the public ip.

I ran this https://github.com/websudos/phantom-activator-template from local and it throws the above error

I run it inside the the VM and it works. 

FYI, I did change the ContactPoints.local to ContactPoints(hosts) and gave the public IP for the above template code when running from my local system, when trying to connect to the VM. 

[Avi Kivity]

Thanks.  Can you verify (with ss or netstat) that Scylla is indeed listening on the public IP?

If it is, then check firewalls etc.  If it is not, then the configuration change was not sufficient.

To view this discussion on the web visit https://groups.google.com/d/msgid/scylladb-users/1b615bd2-6224-432d-be45-6ecb3c4e62d5%40googlegroups.com.

[getyesh@megam.io]

Got it working.  Thanks for the support Avi,

http://devcenter.megam.io/2016/02/05/getting-more-native-welcome-scylladb/

[Dor Laor]

On Tue, Feb 9, 2016 at 10:50 AM, <get...@megam.io> wrote:

Got it working.  Thanks for the support Avi,

http://devcenter.megam.io/2016/02/05/getting-more-native-welcome-scylladb/

Great post! Thanks a lot

 

To view this discussion on the web visit https://groups.google.com/d/msgid/scylladb-users/558ecfce-f7e7-41b6-a72a-735a5f86e0de%40googlegroups.com.