Cassandra cqlsh "unable to connect to any servers"

Question

I get the following message when executing cqlsh.bat on the command line

Connection error: ('Unable to connect to any servers', {'127.0.0.1': ProtocolError("cql_version '3.3.0' is not supported by remote (w/ native protocol). Supported versions: [u'3.2.0']",)})

I'm running Python version 2.7.10 along with Cassandra version 2.2.1. Not sure if it's related but when I start the Cassandra server I need to run "Set-ExecutionPolicy Unrestricted" on PowerShell or else it doesn't work.

score 93 · Accepted Answer · answered Apr 03 '16 at 01:28

You can force cqlsh to use a specific cql version using the flag

--cqlversion="#.#.#"

Example cqlsh usage (and key/values):

cqlsh 12.34.56.78 1234 -u username -p password --cqlversion="3.2.0"
cqlsh (IP ADDR)  (PORT)  (DB_USERN)  (DB_PASS)               (VER)

score 5 · Answer 2 · answered Jan 16 '18 at 04:55

5

edit cqlsh.py file (you can find it using which cqlsh) and change the value of DEFAULT_CQLVER = 'z.z.z' to the supported version.

answered Jan 16 '18 at 04:55

Dhairya Bhardwaj

81
2
10

this should be the accepted answer because it doesn't force you to pass additional parameters to cqlsh – AllenMoh Jun 13 '19 at 01:41

score 3 · Answer 3 · answered Oct 07 '15 at 22:49

3

ProtocolError("cql_version '3.3.0' is not supported by remote (w/ native protocol). Supported versions: [u'3.2.0']"

Indicates that there is a version mismatch between the C* version you are running and the python driver run by CQLSH. Make sure they are all out of the same release.

answered Oct 07 '15 at 22:49

RussS

16,476
1
34
62

How do I find out the version of C* that I'm running? – cdn Oct 12 '15 at 19:23
I'm running version 2.1.9 – cdn Oct 12 '15 at 20:44
And up above you said you are running 2.2.1 . My guess is you are using the cqlsh from 2.2.1 against 2.1.9 – RussS Oct 12 '15 at 22:23
No Solution derived from the answer – khush Jan 11 '22 at 13:22

score 0 · Answer 4 · answered Jan 29 '16 at 06:48

I was facing a similar issue when I was executing bin/cqlsh. I was seeing the below error:

Connection error: ('Unable to connect to any servers', {'cassandra-1.alpha.mimosacloud.co': ProtocolError("cql_version '3.2.0' is not supported by remote (w/ native protocol). Supported versions: [u'3.2.1']",)})

My remote server was using cassandra 2.1.12 and I was trying to connect to it using the cqlsh bundeled with apache-cassandra-2.1.7. My problem was resolved when I downloaded apache-cassandra-2.1.12 from this link and used the cqlsh bundled with it.

Details of my server are: [cqlsh 5.0.1 | Cassandra 2.1.12 | CQL spec 3.2.1 | Native protocol v3]

Cassandra cqlsh "unable to connect to any servers"

4 Answers4

Linked