/opt/mssql-tools/bin/sqlcmd: not found in mcr.microsoft.com/mssql/server:2022-latest

[mchoma]

/opt/mssql-tools/bin/sqlcmd: not found in mcr.microsoft.com/mssql/server:2022-latest

[dosubot]

To resolve the readiness probe failure with the latest MSSQL Docker image, you need to update the getProbeSettings method in the MsSQL.java file to use the new path /opt/mssql-tools18/bin/sqlcmd and include the -C option. Here is the updated code:

@Override
protected ProbeSettings getProbeSettings() {
    return new ProbeSettings(30,
            String.valueOf(this.getPort()),
            5,
            "/opt/mssql-tools18/bin/sqlcmd -S localhost -d " + getDbName() + " -U " + getUsername() + " -P " + getPassword()
                    + " -C -Q \"Select 1\"",
            5,
            "/opt/mssql-tools18/bin/sqlcmd -S localhost -d " + getDbName() + " -U " + getUsername() + " -P " + getPassword()
                    + " -C -Q \"Select 1\"",
            10,
            10);
}

This change updates the readiness probe command to use the new path and includes the -C option for compatibility with the latest MSSQL Docker image ^[1].

To continue talking to Dosu, mention @dosu.

[mchoma]

@dosu any idea?