mssql-cli
mssql-cli copied to clipboard
not working on debian buster 10
The following packages have unmet dependencies: mssql-cli : Depends: libicu52 but it is not installable or libicu55 but it is not installable or libicu57 but it is not installable or libicu60 but it is not installable
These dependencies arent available and there no documentaton covering debian buster 10, just 8 and 9.
On Debian 10 with python :
install
root@zzzz:~# pip3 install mssql-cli ... Successfully installed mssql-cli-1.0.0 root@zzzz:
After modify last line of /usr/local/bin/mssql-ci with "python3.7" : ... python3.7 -m mssqlcli.main "$@" ...
Test :
root@zzzz:~# mssql-cli -S 192.x.x.x -d babxxx -U xxx -P Babxxxx Error message: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 35 - An internal exception was caught)
But
Edit /etc/ssl/opennssl.cnf and modify : [system_default_sect] #MinProtocol = TLSv1.2 MinProtocol = TLSv1.0 #CipherString = DEFAULT@SECLEVEL=2 CipherString = DEFAULT@SECLEVEL=1
And Re TEST :
root@zzzz:~# mssql-cli -S 192.x.x.x -d babxxx -U xxx -P Babxxxx
babxxx>
babxxx> select top 10 [CardNo] from "dbo"."TableXXX"
Time: 1.007s (a second)
+----------+
| CardNo |
|---|
| 000001 |
| 000002 |
| 000003 |
| 000004 |
| 000005 |
| 000006 |
| 000007 |
| 000008 |
| 000009 |
| 000010 |
| +----------+ |
| (10 rows affected) |
| babyxxx> |
It's ok i think for Sql Server 2012 without update