![]() Vim ~/.local/lib/python3.10/site-packages/mssqlcli/jsonrpc/contracts/connectionservice.py To resolve this we need to remove references to ownerUri on lines 22 and 93 in the connectionservice.py file: – Mssql-cli -S localhost -U sa -P Testing1122 -Q "SELECT new error! Progress □ From looking at the open issues on the mssql-cli issues page on Github…we need to force upgrade the cli-helpers python module: – Mssql-cli -S localhost -U sa -P Testing1122 -Q "SELECT – if you’re on Ubuntu 20.04 the mssql-cli should now be workingīut on Ubuntu 22.04 we get a new error. Test connecting to SQL container again: – Sed -i 's/python/python3/g' ~/.local/bin/mssql-cli The issue is that the reference to python here needs to be updated to python3: – Mssql-cli -S localhost -U sa -P Testing1122 -Q "SELECT gives us this error: – Ok, now we have the mssql-cli we can test connecting to SQL in our container: – Once docker is installed, run a SQL container: – The instructions on how to install Docker on Ubuntu are here: – In order to test the mssql-cli we’ll need to spin up a SQL container and to do that we’ll need Docker installed. This is pretty hacky tbh so should only be done on development and test servers.Īlso, if you’re running Ubuntu 20.04 only the first steps are required to get the mssql-cli working (as that has python 3.8 installed by default). The steps that follow are how I worked out how to get the mssql-cli installed on an Azure Ubuntu 22.04 fresh install. ![]() I did try installing previous versions of python (3.8 and 3.9) but had no luck so kept the default version. The issue with Ubuntu 22.04 is that it has python 3.10 installed by default which the current mssql-cli is not compatible with. I use it pretty much everyday however it seems like it’s not being maintained anymore and as such, there are issues when trying to install it on Ubuntu 22.04.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |