Error when trying to insert data from MySQL to Cassandra

[Anonymous]

Hi I am trying to insert data from MySQL to Cassandra but getting below error:-

Starting job mysql_to_cassandra at 04:11 09/03/2017.

[left][statistics] connecting to socket on port 3975[/left]
[left][statistics] connected[/left]

SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".

SLF4J: Defaulting to no-operation (NOP) logger implementation

SLF4J: See for further details.

Exception in component tCassandraOutput_1

[left]com.datastax.driver.core.exceptions.NoHostAvailableException: All host(s) tried for query failed (tried: /192.168.96.145:9042 (com.datastax.driver.core.exceptions.TransportException: [/192.168.96.145] Cannot connect))[/left]

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

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

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

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

at com.datastax.driver.core.Cluster.connectAsync(Cluster.java:333)

at com.datastax.driver.core.Cluster.connectAsync(Cluster.java:308)

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

at test_project.mysql_to_cassandra_0_1.mysql_to_cassandra.tMysqlInput_1Process(mysql_to_cassandra.java:644)

at test_project.mysql_to_cassandra_0_1.mysql_to_cassandra.runJobInTOS(mysql_to_cassandra.java:1281)

at test_project.mysql_to_cassandra_0_1.mysql_to_cassandra.main(mysql_to_cassandra.java:1138)

[left][statistics] disconnected[/left]
[left]Job mysql_to_cassandra ended at 04:11 09/03/2017. [exit code=1][/left]

I am using tcassandraoutput component.

Any help would be really appreciated. Thanks in advance !!

[vapukov]

double check the host

(tried: /192.168.96.145:9042 

look like error in host - what is it / at begin?

[Anonymous]

Hi,
My Talend client is installed in local machine i.e. Windows 7 and my Cassandra is installed in Ubuntu VM. I am able to ping VM IP address from windows.
9042 is the native_transport_port  for cassandra.
Not sure what is / at begin ? In talend I have defined host and port in double quotes "" as per standards.
As per one given post I have 
Thanks,
Mohit

[vapukov]

attach the pictures please, because error log show - it not as You describe

[Anonymous]

I have attached the pictures of talend studio.
Also, I am trying to create NoSQL connection for cassandra. It is failing and giving me error. I have pasted error in attached Connection_Error.txt.txt file. 

Please let me know of anything, that would be needed to solve this issue. Thanks !!!

[Anonymous]

pictures

[Anonymous]

Pictures

[vapukov]

nothing attached

[Anonymous]

Hi,
Screenshots works only if you drag&drop the image directly in the editor window. 
Best regards
Sabrina