Cassandra cqlsh "unable to connect to any servers"

python cassandra
cdn picture cdn · Oct 7, 2015 · Viewed 25k times · Source

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.

Answer

Eric Walsh picture Eric Walsh · Apr 3, 2016

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)

Related questions

What causes "no viable alternative at input 'None'" error with Cassandra CQL

I'm attempting to insert a modified document back to Cassandra DB with a new key. I'm having hard time figuring out what is the issue the error message is pointing at. When looking for others that have had similar problems …

Read More
How to insert a datetime into a Cassandra 1.2 timestamp column

IMPORTANT If you are dealing with this problem today, use the new cassandra-driver from datastax (i.e. import cassandra) since it solves most of this common problems and don't use the old cql driver anymore, it is obsolete! This question …

Read More
Cassandra: File "cqlsh", line 95 except ImportError, e:

I am having trouble getting Cassandra up and running. I have downloaded Cassandra 2.0.1 and Python 3.3.2. Upon starting the CLI for cassandra I get an error: C:\Dev\ApacheCassandra\apache-cassandra-2.0.1\bin>python cqlsh File "cqlsh", line 95 except ImportError, e: ^ SyntaxError: …

Read More