No usable version of the libssl was found

[waghsk]

after installing it on python:2 docker container i get error.
I have openssl (1.1.1d-0+deb10u3) on the docker

[bpaterni]

Just writing to say "me too"

$ pipenv run mssql-scripter [OPTIONS] 
No usable version of the libssl was found
Scripting request: 1 encountered error: Scripting request encountered a exception
Error details: ('End of stream reached, no output.',)

This is running from a debian testing system (openssl 1.1.1g-1) with the following installed in the venv:

$ pipenv run pip list
Package        Version
-------------- --------
enum34         1.1.10
future         0.18.2
mssql-scripter 1.0.0a23
pip            20.1.1
setuptools     46.4.0
wheel          0.34.2

[stitetsati]

same

[duscheln]

Same here

[stitetsati]

ok i got it working... here's the dockerfile

FROM python:3.7-slim 
RUN echo "deb http://ftp.us.debian.org/debian/ jessie main" >>/etc/apt/sources.list
RUN apt-get update && apt-get install -y libicu63 libssl1.0.0 libffi-dev libunwind8 python3-dev && pip install --upgrade pip && pip install mssql-scripter

pls note that newer version of libssl won't work. seems to be only working with 1.0.0

[c4s4]

I would complete your Dockerfile with an entrypoint:

FROM python:3.7-slim 
RUN echo "deb http://ftp.us.debian.org/debian/ jessie main" >>/etc/apt/sources.list
RUN apt-get update && apt-get install -y libicu63 libssl1.0.0 libffi-dev libunwind8 python3-dev && pip install --upgrade pip && pip install mssql-scripter
ENTRYPOINT ["mssql-scripter"]

You should build the image with docker build -t mssql-scripter ., and you can run command with script mssql-scripter:

#!/bin/sh

set -e

docker run --rm -it mssql-scripter "$@"

[add1989]

$  mssql-scripter -S ServerName -d DatabaseName -U sa --include-objects ObjectName -f ./Result.sql
No usable version of the libssl was found
Scripting request: 1 encountered error: Scripting request encountered a exception
Error details: ('End of stream reached, no output.',)

I get this problem using any seemingly newer distro (which doesn't come with the older version of OpenSSL).

I managed to downgrade the system version of libssl (to 1.0.0) on a personal Arch VM and then mssql-scripter worked, but I wouldn't really want to do that on a real machine - plus I'm restricted to using WSL (so Ubuntu 20.04 with OpenSSL 1.1.1f 31 Mar 2020) at work and so can't do the same steps.

I have tried copying libssl.so.1.0.0 into my lib directory on Ubuntu/WSL and running ldconfig (wondering whether, if I have the lib, wouldjust mssql-scripter will use it and not the whole system), but I still get the same problem.

Is it an actual incompatibility or do we just need a new release which is aware of the newer SSL library?

UPDATE
The libssl1.0.0 package was removed from Ubuntu's repos in version 18, so if I add the xenial source to my sources.list and then run apt install libssl1.0.0 this makes mssql-scripter work. Would still be good to get a fix to the issue though.

[c4s4]

Why don't you use docker image? This would be much simpler than messing up you distro with old libssl. Nevertheless, in my own experience this tool doesn't work well to extract real world SQL schema, and fail miserably with an error and some random SQL statements.

[ianthetechie]

Boo! Seems everything from MS is completely dysfunctional on anything remotely modern. I can confirm the above fix (adding the jessie repo and installing the old version) works.

[jbzcooper]

Having same issue. Using dockerfile as prescribed above also didn't work. BUMP!

[brendanlong]

Adding the Jessie repo to the latest python:3.7-slim doesn't work anymore due to some sort of key signing issue (as in #236 (comment)), so I ended up downloading the .deb file from https://packages.debian.org/jessie/amd64/libssl1.0.0/download and then copying it into Docker:

FROM python:3.7-slim
ENV TERM dumb
RUN apt-get update && apt-get install -y libicu63 libffi-dev libunwind8 multiarch-support
COPY libssl1.0.0_1.0.1t-1+deb8u12_amd64.deb .
RUN dpkg -i libssl1.0.0_1.0.1t-1+deb8u12_amd64.deb
RUN pip install --upgrade pip && pip install mssql-scripter==1.0.0a23
ENTRYPOINT ["mssql-scripter"]

[ianthetechie]

Bump? Anyone from Microsoft actually using this? This is BROKEN and the library you forcibly reference is ancient.

[ianthetechie]

Update for anyone still reading this a year later: if you're dockerizing your usage of this, you can do the following. Note the python tag. This is two years old so this is unacceptable as a long-term hack, but should hold us over short term. Note that you have to install an ancient version of libicu as well since this is, well, oldoldstable in Debian land.

# Terrible hack required to get MS's tools to work.
FROM python:3.6-slim-jessie AS sqlgen

RUN apt-get update && apt-get install -y --no-install-recommends freetds-bin sed libunwind8 libicu52 libssl1.0.0
RUN pip install --upgrade pip
RUN pip install mssql-scripter

...

[rbrok]

Thanks for your help and suggestions.
I have created a container with Debian Stretch and libssl1.0.2
Libssl1.0.0 is very old and isn't updated since 2016. (libssl1.0.2 is out of support since January 2020)
PRs are welcome, if you like to improve my container or share something