Unable to open cqlsh Apache cassandra - ImportError: No module named cqlshlib

Question

I am new to cassandra ! Have downloaded the apacahe cassandra 2.1.2 package and initialy was able to connect to cqlsh but then after installing CCM i am unable to connect , will get the following error

Traceback (most recent call last):
File "bin/cqlsh", line 124, in <module>
from cqlshlib import cql3handling, cqlhandling, pylexotron,sslhandling, copy
ImportError: No module named cqlshlib

Thanks in advance !

Can you give the command line you used for creating and starting your CCM cluster please. — mikea, Feb 04 '16 at 15:15
In addition, how are you executing cqlsh?, after you create a cluster with ccm are you running it stand alone or via ccm. Does cqlsh work when run through via ccm? You should be able to connect using ccm and cqlsh by running the "ccm cqlsh" — Greg Bestland, Feb 04 '16 at 17:19
I just downloaded a new cassandra package from apache and started with that ! worked al fine ! thanks guys — Shreesha N, Feb 05 '16 at 07:14

score 21 · Answer 1 · answered Nov 28 '16 at 09:22

21

Spent a couple of days, scouring the net moving renaming copying packages .

Easiest workaround for this error that worked :

pip install cqlsh

answered Nov 28 '16 at 09:22

Saleem Ahmed

2,719
2
18
31

getting ccm to work on windows is taking time. but using pip is helping. Thnx. – ininprsr Mar 26 '17 at 08:27
This should be included in Cassandra installation itself, or at least instruction. – Manh Tai Apr 26 '17 at 15:13
You saved my day! – Felipe Cruz Jan 27 '18 at 17:37
3

I would not suggest using pip to install cqlsh. You might face issue specified in https://stackoverflow.com/questions/40289324/cqlsh-client-module-object-has-no-attribute-parse-options – jwen Nov 19 '19 at 15:29
Hence the answer says it is a "workaround", not the solution :) – Saleem Ahmed Nov 25 '19 at 19:42
For those using this workaround, be aware that the pip install is. not supported by apache and lacks some standard cqlsh features such as copy – Jake May 04 '20 at 14:29

score 13 · Answer 2 · answered Jun 28 '17 at 04:57

13

You could export PYTHONPATH, to include site package folder where cqlshlib exists

First find the path where cqlshlib exists

find /usr/lib/ -name cqlshlib

Export the path using below variable name

export PYTHONPATH=/usr/lib/python2.7/site-packages/

answered Jun 28 '17 at 04:57

faizan

680
1
6
15

2

Worked like a charm. – Yusuf Hassan Dec 22 '17 at 07:04
1

This worked for me, super helpful! Be sure to set the path to the one identified by the "find" command. In my case its python3.6. – Lucy Oct 21 '21 at 12:30

score 5 · Answer 3 · edited Nov 01 '16 at 07:05

I have tried their ways, but failed. And I think cqlsh just cannot find the exact path to cqlshlib.so;

I solved it this way:

Centos6.7 ,
datastax3.9,
my cqlshlib path:/usr/local/lib/python2.7/site-packages/

vim /usr/bin/cqlsh.py

and add the path of cqlshlib after import sys, the file looks like:

...
import sys
...
from uuid import UUID
sys.path.append("/usr/local/lib/python2.7/site-packages") #add this sentence`

Then I execute cqlsh, it works.

score 3 · Answer 4 · answered Apr 01 '16 at 16:43

3

If you're in the cassandra directory, run:

bin/cqlsh

If you check the cqlsh you're running with which cqlsh i suspect you're hitting the ccm one and missing something in your path.

answered Apr 01 '16 at 16:43

Jon Haddad

766
6
17

score 2 · Answer 5 · answered Sep 25 '19 at 04:39

2

Just start cqlsh with root,

  sudo cqlsh <ipaddress>

answered Sep 25 '19 at 04:39

Ashok v

77
1
8

Jake · Answer 6 · 2020-05-04T14:30:07.840

The other answers correctly diagnose the problem. You need to find the correct cqlshlib. I had installed cassandra with apt get to Ubuntu, so the correct path for me was /usr/local/apache-cassandra-3.11.3/pylib

I had also messed things up by previously doing pip install cqlsh This is NOT supported by the apache team!

Like another answer here, I hacked the cqlsh.py file in /usr/bin

My successful hack was to replace the commented out line with the line below it.

#cqlshlibdir = os.path.join(CASSANDRA_PATH, 'pylib')
cqlshlibdir = "/usr/local/apache-cassandra-3.11.3/pylib"

score 1 · Answer 7 · answered Oct 03 '16 at 15:57

I have spent nearly 1 day to solve this problem. The reason is that there is a mismatch between /usr/lib/python2.7/site-packages/ and /usr/local/lib/python2.7/site-packages/ (for my specific folder tree).

The command to use is as the following:

mv /usr/lib/python2.7/site-packages/* /usr/local/lib/python2.7/site-packages/
rmdir /usr/lib/python2.7/site-packages
ln -s /usr/local/lib/python2.7/site-packages /usr/lib/python2.7/site-packages

I guess you will find 2 /site-packages/ also.

Just for reference for others.

amn · Answer 8 · 2017-06-03T20:24:53.570

Workaround:

I assume that you have already installed Cassandra and cqlshlib has been installed in /usr/lib/python2.7/site-packages/

`ln -s /usr/lib/python2.7/site-packages/cqlshlib /usr/local/lib/python2.7/site-packages/cqlshlib`

(replace /usr/lib/python2.7/site-packages with your python directory).

More Detail:

One possibility is that your default python is not in /usr/bin/. Say it has been installed in /usr/local/bin/. However, Cassandra seems to install cqlshlib in /usr/lib/python2.7/site-packages for some reason. As a result, the default python cannot find cqlshlib package when you run cqlsh command.

Ajay Kolipaka · Answer 9 · 2021-01-31T04:38:22.350

As Cassandra supports python2 and you are on python3 and don't wanna mix both follow the below trick worked for me.

Install python2 but don't add it to the environmental path variable
navigate to the bin folder and start the Cassandra server .\cassandra -f
open another terminal and create virtual env in Cassandra home directory using below command virtualenv -p C:\Python27\python.exe .\venv
activate the virtual env with cmd .\venv\Scripts\activate.ps1
start the cqlsh using the cmd .\cqlsh.bat in virtual env

Unable to open cqlsh Apache cassandra - ImportError: No module named cqlshlib

9 Answers9

Linked