Latest Docker image for MSSQL 2019 is missing /opt/mssql-tools directory

[mwasowski]

Hi,

This is an issue linked to #892.

Note in the Docker Hub page for Microsoft SQL Server says that the change related to mssql-tools18 should affect versions SQL Server 2022 CU 14 and up:

Starting with SQL Server 2022 CU 14, we are updating SQL Server 2022 container images to include the new mssql-tools18 package. With the introduction of SQL Server 2022 CU 14, and in all future container images, the previous directory /opt/mssql-tools/bin will be phased out. The new directory for Microsoft ODBC 18 tools will be '/opt/mssql-tools18/bin', aligning with the latest tools offering.

This is not the case. When using 2019-latest image I get the same error. When I tried to build the image using 2019-CU27-ubuntu-20.04, I'm not experiencing this issue.

When looking at tag listing, it is actually 2019-latest tag that was updated most recently and that is weird.

This looks like an unintended change? If it was intended than the page should clearly state that this change is also affecting 2019-latest image.

Kind regards,
Michal

[mwasowski]

New 2019-CU28-ubuntu-20.04 is also broken. 2019-CU27-ubuntu-20.04 remains the last working version.

[zapodot]

The sqlcmd folder has been moved from /opt/mssql-tools to /opt/mssql-tools18 also for latest-2022 which broke our entrypoint script. The example at the docker hub page is now invalid https://hub.docker.com/r/microsoft/mssql-server.
Could you please change it back or at least document it properly on the docker hub page?

[mwasowski]

The sqlcmd folder has been moved from /opt/mssql-tools to /opt/mssql-tools18 also for latest-2022 which broke our entrypoint script. The example at the docker hub page is now invalid https://hub.docker.com/r/microsoft/mssql-server. Could you please change it back or at least document it properly on the docker hub page?

Well, that they did say on the Docker Hub page:

Note Starting with SQL Server 2022 CU 14, we are updating SQL Server 2022 container images to include the new mssql-tools18 package.

[cezarlamann]

@mwasowski @zapodot if you'd like, as a workaround, you can add sqlcmd (and bcp as well, if needed) manually to your images to /usr/bin using something like this: ln -sf "$(find / -iname "sqlcmd" -exec realpath {} \; -quit)" /usr/bin/sqlcmd

I'm doing something similar here.