[BUG] using cqlsh on Mac M3

[sylvain-blot-sp]

Hello Datastax,

I'm unable to connect to Astra DB from a Mac m3 using homebrew or docker.

Using docker:

[INFO]  Downloading Cqlshell, please wait...
[INFO]  Installing  archive, please wait...
[INFO]  Cqlsh is starting, please wait for connection establishment...
No appropriate python interpreter found.

Using homebrew:

[INFO]  Cqlsh is starting, please wait for connection establishment...
Traceback (most recent call last):
  File "/Users/XXXXX/.astra/cqlsh-astra/bin/dsecqlsh.py", line 95, in <module>
    import cqlsh  # nopep8
    ^^^^^^^^^^^^
  File "/Users/XXXXX/.astra/cqlsh-astra/bin/cqlsh.py", line 153, in <module>
    from six.moves import configparser, input
ModuleNotFoundError: No module named 'six.moves'

Thanks for the support

[clun]

Hi Sylvain,

Thank you for your message.

Installation

The recommended way to install the CLI on a MAC silicon is homebrew as explained here

brew install datastax/astra-cli/astra-cli

As it is designed binary the first time you use it you might need to go back to system preference to allow its execution
https://support.apple.com/en-us/102445#openanyway

Once you can do you are on.

astra --version

The CQLSH problem

The CLI implements a lot of operations on its own but can also leverage existing tools on the shelf like CQLSH.
When you run the command astra db cqlsh my-db the CLI will actually download the latest cqlsh binary into ~/.astra/ and start using it with the python install on your machine.

This is where the issue lies. In MAC M3 the default python is 3.12+ but the cqlsh is not yet compatible with 3.12. The solution is to download your python to 3.11.

brew uninstall --ignore-dependencies python
brew install python@3.11

Tell us if this operation unlock you.
Best Regards

[sylvain-blot-sp]

Thank you @clun its working fine with the macOS builtin python interpreter.

On the other end the docker container is not embedind python.

[clun]

Thank you for letting me know, would change the dockerbuild file to add this.