Debian 12 public key is not available

Question

Trying to install mssql-tools, after registering the repository for Debian 12 (Docker image):

  RUN curl https://packages.microsoft.com/keys/microsoft.asc | tee /etc/apt/trusted.gpg.d/microsoft.asc 	&& \
curl https://packages.microsoft.com/config/debian/12/prod.list | tee /etc/apt/sources.list.d/msprod.list && \
# install SQL Server drivers
apt-get update && \
ACCEPT_EULA=Y apt-get install -y msodbcsql17 \
unixodbc-dev \
mssql-tools

I get the following errors:

49.02 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

49.02 E: The repository 'https://packages.microsoft.com/debian/12/prod bookworm InRelease' is not signed.

I've been following this guide:

https://learn.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-ver16#tools

Also, it does work for Debian 11 (Also, it does work for Debian 11 (https://packages.microsoft.com/config/debian/11/prod.list))

Answer 1

The problem here is apt changed the way it verified signatures. And MS has not updated the process for Debian 12.

I found the solution on another article with Ubuntu. Use this command to properly import the signature:

curl -fsSL https://packages.microsoft.com/keys/microsoft.asc | sudo gpg --dearmor -o /usr/share/keyrings/microsoft-prod.gpg

Now, to figure out where mssql-tools are for Debian 12! Apparently mssql-tools18 nor msodbcsql18 exist. :/

Answer 2

Is it possible that the correct solution is "Use Version for Debian 11"?

I tried to fix the problem.

"sudo apt-key adv" as suggested in Aniya's link, to set a key, is deprecated. The proper solution seems to be to store the key in something like "/etc/apt/keyrings/microsoft.asc" (could be any location) and refer to it in the respective sources.list (See verbose solution: https://askubuntu.com/a/1307181)

I applied this for my issue. Using Debian 12, I can install the driver msodbcsql17 and mssql-tools from https://packages.microsoft.com/config/debian/11/prod.list. Querying a MSSQL DB from docker works.

However for 12 I only get:
E: Unable to locate package msodbcsql17

I am not sure what the implications or risks are mixing up the versions. For me it looks like this is the only functioning way. I am open for other suggestions.

Answer 3

Hi @Pablo Burgos

Please refer to this link: https://unix.stackexchange.com/questions/75807/no-public-key-available-on-apt-get-update.

Hope this helps you.

Best regards,

Aniya

Answer 4

I don't see anymore the documentation for Debian. Did MS dropped the support for Debian since its 12 version release?

Answer 5

Following this page worked for me: https://learn.microsoft.com/en-us/linux/packages#command-examples-for-using-the-linux-repository-service

mssql-tools 17 & 18 are now available to install