Java with Cassandra connection problem

[t.ramesh Kumar]

log4j:WARN No appenders could be found for logger (com.datastax.driver.core.Cluster).

log4j:WARN Please initialize the log4j system properly.

log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.

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

at com.datastax.driver.core.ControlConnection.reconnectInternal(ControlConnection.java:196)

at com.datastax.driver.core.ControlConnection.connect(ControlConnection.java:79)

at com.datastax.driver.core.Cluster$Manager.init(Cluster.java:1104)

at com.datastax.driver.core.Cluster.init(Cluster.java:121)

at com.datastax.driver.core.Cluster.connect(Cluster.java:198)

at com.datastax.driver.core.Cluster.connect(Cluster.java:226)

at sample1.sample.main(sample.java:19)

on vmware installed cassandra 3.4 on ubuntu 14.04 .It's working fine with putty and able to create tables,get the data.But getting problem as above i mentioned..

Any Help Appreciated.. 

This is my class

public class sample {

public static void main(String[] args) {

Cluster cluster;

Session session;

   cluster = Cluster.builder().addContactPoint("127.0.0.1").build();

session = cluster.connect("demo");

ResultSet results = session.execute("SELECT * FROM test WHERE id=1");

for (Row row : results) {

System.out.format("%s %d\n", row.getString("name"), row.getInt("id"));

cluster.close();

}

}

}

[Markus Geiß]

Hey,

maybe a silly point, but did you make sure that calls to the local loopback device (127.0.0.1) are correctly forwarded to your VM?

Best wishes,

Markus Geiss

Chief Architect

RɅĐɅЯ, The Mifos Initiative

mge...@mifos.org | Skype: mgeiss.mifos.org | Mobil: +49.152.295.05306 | http://mifos.org  

--
You received this message because you are subscribed to the Google Groups "DataStax Java Driver for Apache Cassandra User Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to java-driver-us...@lists.datastax.com.

[t.ramesh Kumar]

i attached my putty connect to remote cassandra..

I need to use it in java class ..How to connect cassandra in ubuntu remote from windows java with eclipse..

any help .appreciated.

[Markus Geiß]

If I understand you correctly, you've installed Ubuntu and Cassandra on a virtual machine using VMWare.

You use putty to ssh into the virtual machine and then you are able to connect to cassandra using localhost.

If you want to access Cassandra running in the VM you need to map the port used by cassandra to the exposed VM IP, and this IP needs to be used for connecting Cassandra from your host machine.

Best wishes,

Markus Geiss

Chief Architect

RɅĐɅЯ, The Mifos Initiative

mge...@mifos.org | Skype: mgeiss.mifos.org | Mobil: +49.152.295.05306 | http://mifos.org  

[t.ramesh Kumar]

Yes,You are Right !

this is my class,and my port and host of cassandra   127.0.0.1:9042

and host 192.168.34.101 of vm

please can let me know how to configuare in java class 

[Markus Geiß]

you can try to use the IP address the VM is using (the one you may also use for putty) instead of 127.0.0.1 ... just make sure the port 9042 is available via the VMs IP

Best wishes,

Markus Geiss

Chief Architect

RɅĐɅЯ, The Mifos Initiative

mge...@mifos.org | Skype: mgeiss.mifos.org | Mobil: +49.152.295.05306 | http://mifos.org  

[t.ramesh Kumar]

Sir,   

 cluster = Cluster.builder().addContactPoint(" 192.168.34.101").build();

result like

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

when i mention like 

 cluster = Cluster.builder().addContactPoint(" 192.168.34.101:9042").build();

result like

invalid IPv6 address

can you please let me know how to include in class the host of vm ip and port..?to cassandra database.

[Markus Geiß]

I'm not sure how to confiuger your VM correctly ... maybe this is of some help ...

http://stackoverflow.com/questions/27555691/connecting-to-cassandra-sandbox-from-windows

If not simply google it. ; o)

Best wishes,

Markus Geiss

Chief Architect

RɅĐɅЯ, The Mifos Initiative

mge...@mifos.org | Skype: mgeiss.mifos.org | Mobil: +49.152.295.05306 | http://mifos.org  

[t.ramesh Kumar]

Hi All,

          My VM ware working fine,Connected using putty operation are working fine on cassandra.

What exactly i need to connect java class and curd operations on cassandra.But it can't..any help?

[Alex Popescu]

Markus's reply above:

"If you want to access Cassandra running in the VM you need to map the port used by cassandra to the exposed VM IP, and this IP needs to be used for connecting Cassandra from your host machine."

Basically right now your vm is not allowing external connections to the port 9042 from the host os.

--
You received this message because you are subscribed to the Google Groups "DataStax Java Driver for Apache Cassandra User Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to java-driver-us...@lists.datastax.com.

--

Bests,

Alex Popescu | @al3xandru

Sen. Product Manager @ DataStax

» DataStax Enterprise - the database for cloud applications. «

[t.ramesh Kumar]

I changed the rpc_address and localhost(the one have used for the ssh connection),start_rpc: false ,rpc_port: 9160

All changes on Cassandra.yaml ,after all, changes restarted nodes as $CCM STOP...CCM START Still have Same as above mentioned Problem.Please let me know Any one how to connect Vmware Cassandra from eclipse local.Mean How to configure the ports and host in class.

It's Great Help !