Failure to install mssql-tools18 due to lack of secure connection on pmc-geofence.trafficmanager.net

[nbarton915]

Describe the issue https://pmc-geofence.trafficmanager.net appears to not have a certificate.

I install mssql-tools18 as a part of a CI process regularly. Today, the CI processes is failing with the following output from the image build during the installation of the package.

15.84   Could not handshake: A TLS fatal alert has been received. [IP: 4.155.111.140 443]
15.85 E: Failed to fetch https://pmc-geofence.trafficmanager.net/ubuntu/22.04/prod/pool/main/m/mssql-tools18/mssql-tools18_18.4.1.1-1_amd64.deb?geofence=true  Could not handshake: A TLS fatal alert has been received. [IP: 4.155.111.140 443]
15.85 E: Unable to fetch some archives, maybe run apt-get update or try with --fix-missing?

I get the same error locally and regardless of what path I go to.

When did the issue occur? Noticed failing CI on September 11th 2024

If applicable, what package did you attempt to install, and from which repo?

mssql-tools18 for ubuntu 22.04

Steps to Reproduce Image build step we use:

# https://learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver15&tabs=ubuntu18-install%2Calpine17-install%2Cdebian8-install%2Credhat7-13-install%2Crhel7-offline
RUN     curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add - && \
    curl https://packages.microsoft.com/config/ubuntu/$(lsb_release -rs)/prod.list > /etc/apt/sources.list.d/mssql-release.list && \
    apt-get update && \
    ACCEPT_EULA=Y apt-get install -y --no-install-recommends msodbcsql18 && \
    ACCEPT_EULA=Y apt-get install -y --no-install-recommends mssql-tools18 && \
    echo 'export PATH="$PATH:/opt/mssql-tools18/bin"' >> ~/.bashrc && \
    /bin/bash -c "source ~/.bashrc" && \
    apt-get install -y unixodbc-dev && \
    apt-get -y clean && \
    apt-get -y autoremove && \
    rm -rf /var/lib/apt/lists/*

Actual Result

15.84   Could not handshake: A TLS fatal alert has been received. [IP: 4.155.111.140 443]
15.85 E: Failed to fetch https://pmc-geofence.trafficmanager.net/ubuntu/22.04/prod/pool/main/m/mssql-tools18/mssql-tools18_18.4.1.1-1_amd64.deb?geofence=true  Could not handshake: A TLS fatal alert has been received. [IP: 4.155.111.140 443]
15.85 E: Unable to fetch some archives, maybe run apt-get update or try with --fix-missing?

Expected Result Installation of mssql-tools18

Additional context CI running in Github Actions to build a container image and was also tested locally

[huliang-microsoft]

Same problem here

[sharpone74]

Also have this problem, please fix.

[zcharlesallen]

Same problem here, as well.

[yalamarthisr]

same problem here as well. Facing similar issue locally and in CI.

[jurcyk]

Gross bodge but will get you going until it's fixed Works without HTTPS, just use the HTTP url

RUN curl -s <HTTP URL> -o mssql-tools18.deb && \
    ACCEPT_EULA=Y dpkg -i mssql-tools18.deb && \
    rm -rf mssql-tools18.deb

[daviddavis]

Thanks for raising this issue. We've deployed a fix to mitigate it.