Provide Linux images with full-text search included

[MaxHorstmann]

None of the official Linux container images have full-text search installed. This came up in a number of issues already.

It seems like the only way to run SQL Server with full-text search in a Linux container is to define a new image based on one of the official ones. For example, this works:

FROM mcr.microsoft.com/mssql/server:2019-CU9-ubuntu-16.04
USER root
RUN apt-get -y update && \
    apt-get install -yq curl apt-transport-https && \
    curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add - && \
    curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2019.list | tee /etc/apt/sources.list.d/mssql-server.list && \
    apt-get update && \
    apt-get install -y mssql-server-fts && \
    apt-get clean && \ 
    rm -rf /var/lib/apt/lists

This is kinda brittle and requires ongoing maintenance. For example, the above already breaks when changing to FROM mcr.microsoft.com/mssql/server:2019-latest due to a missing dependency (gnupg).

Would it be possible to provide official images with full-text search already included? 2019-FTS-latest, 2019-FTS-CU9-ubuntu-16.04 etc..

[amvin87-zz]

Thanks for the feedback, for now this is not in our roadmap to provide official linux images with FTS. In case of installation on windows also it is not installed by default, during installation of SQL Server you need to check the Full text component or add it post the installation of SQL Server. For now, creating a custom dockerfile like you did is the best way to install for the issue you faced, let me know if you are still facing it and may be I can try help with that.

[cdhunt]

I'm trying to update the images and trying to install mssql-server-fts . Get:1 https://packages.microsoft.com/ubuntu/20.04/mssql-server-2019 focal/main amd64 mssql-server amd64 15.0.4236.7-1 [270 MB runs for over 30 minutes. On my desktop, I'm only receiving about 800Kbps. I'm not sure what the transfer rate is on our build server in AWS in another part of the country, but it times out after 30 minutes.

[Broderick890]

官方 Linux 容器映像均未安装全文搜索。这已经出现在许多问题中。

似乎在 Linux 容器中运行带有全文搜索的 SQL Server 的唯一方法是根据其中一个官方图像定义一个新图像。例如，这有效：

FROM mcr.microsoft.com/mssql/server:2019-CU9-ubuntu-16.04
USER root
RUN apt-get -y update && \
    apt-get install -yq curl apt-transport-https && \
    curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add - && \
    curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2019.list | tee /etc/apt/sources.list.d/mssql-server.list && \
    apt-get update && \
    apt-get install -y mssql-server-fts && \
    apt-get clean && \ 
    rm -rf /var/lib/apt/lists

这有点脆弱，需要持续维护。例如，FROM mcr.microsoft.com/mssql/server:2019-latest由于缺少依赖项 ( gnupg) 而更改为时，上述代码已经中断。

是否可以提供已经包含全文搜索的官方图片？2019-FTS-latest等等2019-FTS-CU9-ubuntu-16.04。

Very necessary