am unable to to the database using cqlsh

Question

I have a cassandra db 1.21 installed on windows 2019, am unable to to the database using cqlsh

enter image description here

Able to start the cassandra db enter image description here

when i run cqslh as below am seeing cqlsh is not recognized enter image description here

All the environment variables are set, Can anyone let me know if anything is missing?

Answer 1

First of all, that's an 11-year-old version of Cassandra (1.2) running on a 19-year-old JDK (1.6), on an unsupported operating system (Windows Server 2019). And trying to access that with an unsupported version of Python (2.7) adds to the problems at-hand. Just pointing this all out, because it ultimately makes what you're trying to do more difficult.

The age of the underlying libraries make this even more problematic, because there just aren't many resources available anymore to help troubleshoot issues for those software versions. However, this was pretty much my exact development environment in 2012, so I do have some thoughts (other than to just say "upgrade").

First, cqlsh probably won't run on its own on Windows the same way that that it does on Linux. If Python is properly pathed to that directory, try: python cqlsh

Otherwise, the standard way people used to work with Cassandra on Windows was with a Cygwin terminal. If I remember right, Cygwin should allow you to just type cqlsh at the prompt.

Summary:

• Try python cqlsh
• Run cqlsh inside of Cygwin
• Upgrade all the things! (Cassandra, JDK, Python)
• Run Cassandra on Linux (highly recommended)