Pipx: Cannot install mssql-cli

[petobens]

I don't know if this is something with my setup or what but if I run

pip install mssql-cli

and then run mssql-cli --version then everything is fine. On the other hand if i run

pip uninstall mssql-cli
pipx install mssql-cli

and re-run mssql-cli --version I get

/usr/bin/python: Error while finding module specification for 'mssqlcli.main' (ModuleNotFoundError: No module named 'mssqlcli')

I'm using python 3.7. Thanks in advance for looking into this.

[petobens]

The referenced commit doesn't fix my issue. It should've?

[cs01]

It turns out the issue is with the mssqli-cli library itself. I created an issue and a pull request to fix it.

If you want to install now with the fix, you can install from my branch with the fix.

pipx install --spec git+https://github.com/cs01/mssql-cli@593d7f6516 mssql-cli

Note that this method does a git clone of the repository, which unfortunately takes a while, but I did confirm that it works.

mssql-cli.bat from package mssql-cli is now available globally
mssql-cli from package mssql-cli is now available globally
done! ✨ 🌟 ✨
>> mssql-cli
Username (press enter for sa):

[petobens]

Wowwww, that's an awesome and unseen level of support! Thank you so much :)

[cs01]

Tell your friends!

[shawnohare]

I just wanted to note for others coming across this issue that the aforementioned PR has been merged, but the current mssql-cli v0.15.0 does not include them, so one should still install from @cs01's branch or master.

[petobens]

@shawnohare does installing from master work for you? See https://github.com/dbcli/mssql-cli/issues/247

[shawnohare]

No, for the exact reason listed in your link. I suppose I was a bit hasty in suggesting the master branch worked, sorry for the confusion!

Moreover, installing with pipx from the merged PR leads to the same issue as https://github.com/dbcli/mssql-cli/issues/247

[nickolay]

The fix to mssql-cli has been reverted, and the original problem is back: https://github.com/dbcli/mssql-cli/issues/496