sqlpackage giving error ‘No usable version of the libssl was found’ on Linux

I’m trying to get sqlpackage running under Linux. I’m working in Docker.
I’ve tried several different Docker images and when I try to run a command in sqlpackage I always get ‘No usable version of the libssl was found’.

I published this on GitHub and I thought I had it working, but I didn’t 🙂
my repo is https://github.com/ormico/sqlpackage-docker
but I’ll copy the Dockerfile here

FROM mcr.microsoft.com/dotnet/core/runtime
USER root

RUN apt-get update && 
    apt-get install -y 
        curl 
        unzip 
        libunwind8 
        software-properties-common 
    && curl -Lq https://go.microsoft.com/fwlink/?linkid=873926 -o sqlpackage-linux-x64-latest.zip 
    && unzip sqlpackage-linux-x64-latest.zip -d /opt/sqlpackage 
    && chmod a+x /opt/sqlpackage/sqlpackage 
    && /bin/bash -c "source /root/.bashrc"
ENV PATH="$PATH:/opt/sqlpackage"

I’ve tried swapping out the image for mcr.microsoft.com/dotnet/core/runtime:3.1 ubuntu:latest. I tried building on ubuntu:18.04 but I get a 400 error on something in apt-get.

I’ve tried adding openssl and libssl-dev to my apt-get install list but doesn’t seem to help.

I tried doing

❯ docker run -it --rm ormico/sqlpackage /bin/bash
[email protected]:/# apt-get install openssl

but it just says openssl already up to date

Reading package lists... Done
Building dependency tree
Reading state information... Done
openssl is already the newest version (1.1.1d-0+deb10u3).
openssl set to manually installed.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.

I just can’t figure out how to get this working.

Source: Docker Questions