Can't list tags for various repos on MCR about containerregistry

[alyssadecasa]

Hi @vilmosnagy, for more guided help on this please reach out for support through one of the SQL support channels detailed here.

[alyssadecasa]

@rcowsill The catalog list https://mcr.microsoft.com/v2/_catalog has been updated. Invalid repos such as the ones you reported have been removed.

Of the ones reported, four are currently valid repos with valid tags list pages:

• azuredefender/stable/pod-collector
• azuredefender/stage/pod-collector
• azure-cognitive-services/form-recognizer/layout
• mir/mir-base-image-win1809

We are currently looking into removing these invalid repos and their tag lists from DockerHub. Thank you for reporting this issue to us.

[alyssadecasa]

There is a bug related to the mssql-tools image on the SQL team side. In our records, it is set to mssql/tools, but this image does not exist whereas mssql-tools does. I have reached out to the SQL team about this.

Thank you for bringing this to our attention.

[bariscaglar]

@rcowsill is there any tag that you can actually pull in any of those images? My guess is these images have no tags and somehow they are not removed from the catalog. Or it's quite possible that these images have manifests but only accessible by SHA (untagged).

[rcowsill]

is there any tag that you can actually pull in any of those images? My guess is these images have no tags and somehow they are not removed from the catalog. Or it's quite possible that these images have manifests but only accessible by SHA (untagged).

It's hard to prove otherwise without being able to list the tags 😉

That said, I was able to pull mcr.microsoft.com/mssql-tools:latest, which is listed at https://hub.docker.com/_/microsoft-mssql-tools. That Docker Hub page links to https://mcr.microsoft.com/v2/mssql/tools/tags/list (BlobNotFound).

For most of the other repos I had no luck finding their corresponding Docker Hub page.

The few I did find gave "manifest unknown" errors when I tried to pull any of the tags listed:

Repo	Docker Hub URL	Docker Hub tag list
https://hub.docker.com/_/microsoft-iot-industrial-iot-auth-service	iot/industrial-iot-auth-service	latest, preview
https://hub.docker.com/_/microsoft-iot-industrial-iot-users-service	iot/industrial-iot-users-service	latest, preview
https://hub.docker.com/_/microsoft-terraform-on-azure-shell	terraform-on-azure/shell	latest

[rcowsill]

Reported the missing IOT images here: Azure/Industrial-IoT#1226

The GitHub repo linked from https://hub.docker.com/_/microsoft-terraform-on-azure-shell (azure/terraform-cli) is 404, so I guess that needs cleaning up on Docker Hub.

[gldraphael]

https://mcr.microsoft.com/v2/_catalog lists powershell and dotnet/sdk

But the following do not work:

• https://mcr.microsoft.com/v2/mcr/powershell/tags/list
• https://mcr.microsoft.com/v2/mcr/dotnet/sdk/tags/list

They both have tags. Corresponding dockerhub links:

• https://hub.docker.com/_/microsoft-powershell
• https://hub.docker.com/_/microsoft-dotnet-sdk

[mthalman]

https://mcr.microsoft.com/v2/_catalog lists powershell and dotnet/sdk

But the following do not work:

• https://mcr.microsoft.com/v2/mcr/powershell/tags/list
• https://mcr.microsoft.com/v2/mcr/dotnet/sdk/tags/list

They both have tags. Corresponding dockerhub links:

• https://hub.docker.com/_/microsoft-powershell
• https://hub.docker.com/_/microsoft-dotnet-sdk

@gldraphael - You need to remove the mcr portion from the URL. Example: https://mcr.microsoft.com/v2/dotnet/sdk/tags/list

[gldraphael]

Oh right! silly me. Thank you!

[paule96]

@alyssadecasa I guess the cleaning goes here in the wrong direction at least for some images.

For example, the image mcr.microsoft.com/mssql-tools can be pulled as an image but is now not anymore in the catalog. And it would be really helpful to get the tags to the image.

Edit:

The SQL Team should be maybe also pinged to this issue: microsoft/mssql-docker#650
The community tries to reach them 🤷‍♀️

[vilmosnagy]

@alyssadecasa any news on this? What docker image should I use to access an SQL Server? Thanks,

[gldraphael]

@vilmosnagy - mcr.microsoft.com/mssql/server:2022-latest

See: https://mcr.microsoft.com/en-us/product/mssql/server/about

[vilmosnagy]

@gldraphael thanks. I'd like to use sqlcmd, and it's not in mcr.microsoft.com/mssql/server:2022-latest, see:

❯ podman run -it --rm --entrypoint bash mcr.microsoft.com/mssql/server:2022-latest 
mssql@09ab3b3440e0:/$ sqlcmd
bash: sqlcmd: command not found
mssql@09ab3b3440e0:/$ 

but:

❯ podman run -it --rm --entrypoint bash mcr.microsoft.com/mssql-tools 
root@baacba0c5e31:/# sqlcmd
Microsoft (R) SQL Server Command Line Tool
Version 13.1.0007.0 Linux
Copyright (c) 2012 Microsoft. All rights reserved.

usage: sqlcmd            [-U login id]          [-P password]
  [-S server or Dsn if -D is provided] 
  [-H hostname]          [-E trusted connection]
  [-N Encrypt Connection][-C Trust Server Certificate]
  [-d use database name] [-l login timeout]     [-t query timeout]
  [-h headers]           [-s colseparator]      [-w screen width]
  [-a packetsize]        [-e echo input]        [-I Enable Quoted Identifiers]
  [-c cmdend]
  [-q "cmdline query"]   [-Q "cmdline query" and exit]
  [-m errorlevel]        [-V severitylevel]     [-W remove trailing spaces]
  [-u unicode output]    [-r[0|1] msgs to stderr]
  [-i inputfile]         [-o outputfile]
  [-k[1|2] remove[replace] control characters]
  [-y variable length type display width]
  [-Y fixed length type display width]
  [-p[1] print statistics[colon format]]
  [-R use client regional setting]
  [-K application intent]
  [-M multisubnet failover]
  [-b On error batch abort]
  [-D Dsn flag, indicate -S is Dsn] 
  [-X[1] disable commands, startup script, environment variables [and exit]]
  [-x disable variable substitution]
  [-? show syntax summary]
root@baacba0c5e31:/# exit