Connection error 61 for cassandra

[ankita therese]

Hello,

I set up a single node on localhost, and it was working fine
I connected cassandra with a apache spark, and was able to access the
keyspaces

After this, i connected to pyspark using the datastax spark-cassandra
connector

Ever since then, when i try to access spark via cqlsh, all i get is

>

Connection error: ('Unable to connect to any servers', {'127.0.0.1':
> error(61, "Tried connecting to [('127.0.0.1', 9042)]. Last error:
> Connection refused")})



when i try to connect via spark shell, i get

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




Any idea what i should do?

OS: OSX Yosemite 10.10.5

Re: Connection error 61 for cassandra

[Carlos Alonso]

I ran through those issues a while ago.

It was on Ubuntu rather than OSX but probably the same.

I compiled my steps here:
http://mrcalonso.com/fitting-ipython-notebooks-spark-and-cassandra-all-together/

Cheers!

Carlos Alonso | Software Engineer | @calonso 

On 19 January 2016 at 14:01, ankita therese  wrote:

> Hello,
>
> I set up a single node on localhost, and it was working fine
> I connected cassandra with a apache spark, and was able to access the
> keyspaces
>
> After this, i connected to pyspark using the datastax spark-cassandra
> connector
>
> Ever since then, when i try to access spark via cqlsh, all i get is
>
>>
>
> Connection error: ('Unable to connect to any servers', {'127.0.0.1':
>> error(61, "Tried connecting to [('127.0.0.1', 9042)]. Last error:
>> Connection refused")})
>
>
>
> when i try to connect via spark shell, i get
>
>>
>> Caused by: com.datastax.driver.core.exceptions.NoHostAvailableException:
>> All host(s) tried for query failed (tried: /192.168.1.2:9042 
>> (com.datastax.driver.core.exceptions.TransportException:
>> [/192.168.1.2] Cannot connect))
>
>
>
>
> Any idea what i should do?
>
> OS: OSX Yosemite 10.10.5
>