Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

michalis's avatar

having trouble installing mssql with sail

I found a piece for the docker file here https://gist.github.com/Sirpyerre/1db05b2ca681ea680646259805aee293

#Add repository ODBC and Install the Microsoft ODBC driver for SQL Server
RUN curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add - \
    && curl https://packages.microsoft.com/config/ubuntu/21.10/prod.list > /etc/apt/sources.list.d/mssql-release.list \
    && apt-get update \
    && ACCEPT_EULA=Y apt-get install -y msodbcsql17 \
    && ACCEPT_EULA=Y apt-get install -y mssql-tools \
    && apt-get install -y gcc musl-dev make

# Install the PHP drivers for Microsoft SQL Server
RUN pecl channel-update https://pecl.php.net/channel.xml \
    && pecl install swoole \
    && pecl install sqlsrv pdo_sqlsrv \
    && pecl clear-cache \
    && rm -rf /tmp/* /var/tmp/*

RUN /bin/bash -c 'source ~/.bashrc'
RUN echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc

RUN printf "; priority=20\nextension=sqlsrv.so\n" > /etc/php/8.1/mods-available/sqlsrv.ini
RUN printf "; priority=30\nextension=pdo_sqlsrv.so\n" > /etc/php/8.1/mods-available/pdo_sqlsrv.ini
RUN phpenmod sqlsrv pdo_sqlsrv
# End install sql server

but getting this error that shows up in no searches in google

failed to solve: rpc error: code = Unknown desc = executor failed running [/bin/sh -c pecl channel-update https://pecl.php.net/channel.xml     && pecl inst
all swoole     && pecl install sqlsrv pdo_sqlsrv     && pecl clear-cache     && rm -rf /tmp/* /var/tmp/*]: exit code: 1

can anyone spot the issue?

0 likes
0 replies

Please or to participate in this conversation.