3 weeks later: mssql still not working

[tarreislam]

Is this project dead? Can anyone recomend something else?

FYI: mssql still not working. Similar to #3449

2.998 Setting up lsb-release (12.0-1) ...
3.018 + + curl https://packages.microsoft.com/keys/microsoft.ascapt-key
3.018 add -
3.026 % Total % Received % Xferd Average Speed Time Time Time Current
3.027 Dload Upload Total Spent Left Speed
0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0Warning: apt-key is deprecated. Manage keyring files in trusted.gpg.d instead (see apt-key(8)).
100 983 100 983 0 0 3477 0 --:--:-- --:--:-- --:--:-- 3485
3.855 OK
3.866 + lsb_release -rs
3.877 + curl https://packages.microsoft.com/config/debian/12/prod.list
3.884 % Total % Received % Xferd Average Speed Time Time Time Current
3.884 Dload Upload Total Spent Left Speed
100 138 100 138 0 0 1118 0 --:--:-- --:--:-- --:--:-- 1121
4.011 + apt-get update -yqq
4.950 W: GPG error: https://packages.microsoft.com/debian/12/prod bookworm InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY EB3E94ADBE1229CF
4.950 E: The repository 'https://packages.microsoft.com/debian/12/prod bookworm InRelease' is not signed.

failed to solve: process "/bin/sh -c set -eux; if [ ${INSTALL_MSSQL} = true ]; then if [ $(php -r "echo PHP_MAJOR_VERSION;") = "5" ]; then apt-get -yqq install freetds-dev libsybdb5 && ln -s /usr/lib/x86_64-linux-gnu/libsybdb.so /usr/lib/libsybdb.so && docker-php-ext-install mssq
l pdo_dblib && php -m | grep -oiE '^mssql$' && php -m | grep -oiE '^pdo_dblib$' ;else apt-get update && apt-get install -yqq apt-transport-https gnupg lsb-release && curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add - && curl https://packages.micros
oft.com/config/debian/$(lsb_release -rs)/prod.list > /etc/apt/sources.list.d/mssql-release.list && apt-get update -yqq && ACCEPT_EULA=Y apt-get install -yqq unixodbc unixodbc-dev libgss3 odbcinst msodbcsql17 locales && echo "en_US.UTF-8 UTF-8" > /etc/locale.gen && ln -sfn /etc/loca
le.alias /usr/share/locale/locale.alias && locale-gen && if [ $(php -r "echo PHP_VERSION_ID - PHP_RELEASE_VERSION;") = "70000" ]; then pecl install pdo_sqlsrv-5.3.0 sqlsrv-5.3.0 ;elif [ $(php -r "echo PHP_VERSION_ID - PHP_RELEASE_VERSION;") = "70100" ]; then pecl in
stall pdo_sqlsrv-5.6.1 sqlsrv-5.6.1 ;elif [ $(php -r "echo PHP_VERSION_ID - PHP_RELEASE_VERSION;") = "70200" ]; then pecl install pdo_sqlsrv-5.8.1 sqlsrv-5.8.1 ;else pecl install pdo_sqlsrv sqlsrv ;fi && docker-php-ext-enable pdo_sqlsrv sqlsrv && php -m | gr
ep -oiE '^pdo_sqlsrv$' && php -m | grep -oiE '^sqlsrv$' ;fi ;fi" did not complete successfully: exit code: 100

[parallels999]

Duplicate of #3449

Is this project dead?

Can anyone recomend something else?

Make a PR with a fix for the problem, or make your own DockerFile
Also try other solutions learn.microsoft.com/debian-12-public-key-is-not-available

[oneCentral]

This can be resolved by adjusting the packages. msodbcsql18 instead of msodbcsql17 and mssql-tools18 instead of mssql-tools:

workspace/Dockerfile:1119:
ACCEPT_EULA=Y apt-get install -yqq msodbcsql18 mssql-tools18 unixodbc unixodbc-dev libgss3 odbcinst locales && \

and php-fpm/Dockerfile:775:
&& ACCEPT_EULA=Y apt-get install -yqq unixodbc unixodbc-dev libgss3 odbcinst msodbcsql18 locales \

I'll try to make a pull request.

[oneCentral]

See: #3466