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

Add variable for installing different versions of mssql_tools

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

      None

      Show
      None
    • Yes
    • None
    • Enhancement
    • Hide
      .New variables in the `microsoft.sql.server` system role: `mssql_tools_versions` and `mssql_tls_self_sign`

      A new package `mssql-tools18` brings some functionality, which is not backwards-compatible with the previous versions of the `mssql-tools` package. Therefore the following variables have been introduced to the `microsoft.sql.server` system role to adapt to the changes:

      * `mssql_tools_versions` (list, defaults to version 18): Enables you to install different versions of `mssql-tools`.

      * `mssql_tls_self_sign` (boolean): Enables you to specify whether the certificates that you use are self-signed or not. Applicable when you also set the `mssql_tls_enable: true` variable.

      [IMPORTANT]
      ====
      With `mssql-tools18`, if you use self-signed TLS certificates, you have to set `mssql_tls_self_sign: true` and set the `-C` flag in the `sqlcmd` command-line utility so that you certificates can be trusted.
      ====

      As a result, you can use these configurations to install `mssql_tools` version 17; 18; or both in parallel.

      For more details, see the resources in the `/usr/share/ansible/roles/microsoft.sql-server/` directory.
      Show
      .New variables in the `microsoft.sql.server` system role: `mssql_tools_versions` and `mssql_tls_self_sign` A new package `mssql-tools18` brings some functionality, which is not backwards-compatible with the previous versions of the `mssql-tools` package. Therefore the following variables have been introduced to the `microsoft.sql.server` system role to adapt to the changes: * `mssql_tools_versions` (list, defaults to version 18): Enables you to install different versions of `mssql-tools`. * `mssql_tls_self_sign` (boolean): Enables you to specify whether the certificates that you use are self-signed or not. Applicable when you also set the `mssql_tls_enable: true` variable. [IMPORTANT] ==== With `mssql-tools18`, if you use self-signed TLS certificates, you have to set `mssql_tls_self_sign: true` and set the `-C` flag in the `sqlcmd` command-line utility so that you certificates can be trusted. ==== As a result, you can use these configurations to install `mssql_tools` version 17; 18; or both in parallel. For more details, see the resources in the `/usr/share/ansible/roles/microsoft.sql-server/` directory.
    • In Progress
    • 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
              Daniel Yeisley Daniel Yeisley
              Jaroslav Klech Jaroslav Klech
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated: