Skip to content

Ubuntu 24.04 repo: sqlcmd not available #532

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Open
scara opened this issue May 24, 2024 · 2 comments
Open

Ubuntu 24.04 repo: sqlcmd not available #532

scara opened this issue May 24, 2024 · 2 comments

Comments

@scara
Copy link

scara commented May 24, 2024

Hello @stuartpa ,
kind-of as in #528: sqlcmd is missing in 24.04 repo i.e no https://packages.microsoft.com/ubuntu/24.04/prod/pool/main/s/sqlcmd/ folder.

TIA,
Matteo

@perlun
Copy link

perlun commented Sep 13, 2024

I am seeing similar issues on Debian Bookworm; the sqlcmd package simply isn't there. For some use cases, apt-get install mssql-tools (the ODBC sqlcmd package) can be a replacement (but it is more restrictively licensed).

@jbauerrfid
Copy link

The sqlcmd is still missing in the repo.

I found this workaround:

wget https://packages.microsoft.com/ubuntu/22.04/prod/pool/main/s/sqlcmd/sqlcmd_1.5.0-1_jammy_all.deb
sudo dpkg -i sqlcmd_1.5.0-1_jammy_all.deb

It is not pretty because sideloading sqlcmd from a deb does not allow auto updates, but at least I got a working sqlcmd quickly. Apparently the sqlcmd tool for jammy works on noble as well.

tjementum added a commit to platformplatform/PlatformPlatform that referenced this issue Jan 9, 2025
…ng (#670)

### Summary & Motivation

Upgrade all GitHub runners to the latest stable version, Ubuntu 24.04,
for improved stability and predictability. Previously, runners used
`ubuntu:latest`, which posed risks due to breaking changes between
updates.

In Ubuntu 24.04, the classic Microsoft `sqlcmd` (ODBC) is no longer
installed by default, so the logic to uninstall it has been removed. The
new `sqlcmd` (Go) is still installed, but it relies on the older package
source from Ubuntu 22.04
(`https://packages.microsoft.com/config/ubuntu/22.04/prod.list`) due to
the lack of an updated package for 24.04. For more details, see:
microsoft/go-sqlcmd#532.

Additionally, Bicep output parsing has been improved. JSON extraction
now removes warnings about unneeded dependencies, preventing failures in
detecting valid JSON or errors. The unneeded Bicep dependencies that
were causing these warnings have also been removed.

### Downstream projects

Please update the GitHub runner for all GitHub actions to use Ubuntu
24.04. Do this by replacing `runs-on: ubuntu-latest` with `runs-on:
ubuntu-24.04` in all .yaml pipelines.

### Checklist

- [x] I have added tests, or done manual regression tests
- [x] I have updated the documentation, if necessary
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants