Uploaded image for project: 'RHEL'
  1. RHEL
  2. RHEL-68468

Add variable for installing different versions of mssql_tools [el10]

    • ansible-collection-microsoft-sql-2.5.2-1.el10
    • None
    • rhel-sst-system-roles
    • 5
    • QE ack, Dev ack
    • False
    • Hide

      None

      Show
      None
    • Yes
    • None
    • Enhancement
    • Hide
      Enhancement: Add mssql_tools_versions variable to allow installing different versions of mssql-tools package.
      Add mssql_tls_self_sign variable for specifying whether self-signed certificates are used, applicable when users set mssql_tls_enable: true.

      Reason: Microsoft added a new version of the mssql-tools package - mssql-tools18. This package adds some new functionality, which is not backward-compatible with the previous versions, hence Microsoft added a new package mssql-tools18 instead of just bumping the version of mssql-tools.
      With mssql-tools18, when self-signed TLS certificates are used, it is required to set -C flag with sqlcmd to trust certificates.

      Result: You can set mssql_tools_versions to install version 17, 18, or both version in parallel. By default, the role now installs the newer mssql-tools18.
      With mssql-tools18, when you use self-signed TLS certificates, you must set mssql_tls_self_sign: true to make sqlcmd trust your certificates.
      Show
      Enhancement: Add mssql_tools_versions variable to allow installing different versions of mssql-tools package. Add mssql_tls_self_sign variable for specifying whether self-signed certificates are used, applicable when users set mssql_tls_enable: true. Reason: Microsoft added a new version of the mssql-tools package - mssql-tools18. This package adds some new functionality, which is not backward-compatible with the previous versions, hence Microsoft added a new package mssql-tools18 instead of just bumping the version of mssql-tools. With mssql-tools18, when self-signed TLS certificates are used, it is required to set -C flag with sqlcmd to trust certificates. Result: You can set mssql_tools_versions to install version 17, 18, or both version in parallel. By default, the role now installs the newer mssql-tools18. With mssql-tools18, when you use self-signed TLS certificates, you must set mssql_tls_self_sign: true to make sqlcmd trust your certificates.
    • Proposed
    • None

      Enhancement: Add mssql_tools_versions variable to allow installing different versions of mssql-tools package.
      Add mssql_tls_self_sign variable for specifying whether self-signed certificates are used, applicable when users set mssql_tls_enable: true.

      Reason: Microsoft added a new version of the mssql-tools package - mssql-tools18. This package adds some new functionality, which is not backward-compatible with the previous versions, hence Microsoft added a new package mssql-tools18 instead of just bumping the version of mssql-tools.
      With mssql-tools18, when self-signed TLS certificates are used, it is required to set -C flag with sqlcmd to trust certificates.

      Result: You can set mssql_tools_versions to install version 17, 18, or both version in parallel. By default, the role now installs the newer mssql-tools18.
      With mssql-tools18, when you use self-signed TLS certificates, you must set mssql_tls_self_sign: true to make sqlcmd trust your certificates.

       

      More details in Microsoft blog: https://techcommunity.microsoft.com/blog/sqlserver/odbc-driver-18-0-for-sql-server-released/3169228

              spetros@redhat.com Sergei Petrosian
              spetros@redhat.com Sergei Petrosian
              Sergei Petrosian Sergei Petrosian
              Daniel Yeisley Daniel Yeisley
              Jaroslav Klech Jaroslav Klech
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated: