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.
You can ensure this by using "telnet thecassandrahost 9042" from the remote machine, it should not work. In order to bind Cassandra to the external network interface you need to edit the cassandra. yaml configuration file and set the properties " listen_address " and " rpc_address " to your remote IP or "0.0.
cqlsh is implemented with the Python native protocol driver, and connects to the single specified node.
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)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With