ansible-playbook 2.9.27
  config file = None
  configured module search path = ['/root/.ansible/plugins/modules', '/usr/share/ansible/plugins/modules']
  ansible python module location = /usr/local/lib/python3.9/site-packages/ansible
  executable location = /usr/local/bin/ansible-playbook
  python version = 3.9.19 (main, May 16 2024, 11:40:09) [GCC 8.5.0 20210514 (Red Hat 8.5.0-22)]
No config file found; using defaults
[WARNING]: running playbook inside collection fedora.linux_system_roles
Skipping callback 'actionable', as we already have a stdout callback.
Skipping callback 'counter_enabled', as we already have a stdout callback.
Skipping callback 'debug', as we already have a stdout callback.
Skipping callback 'dense', as we already have a stdout callback.
Skipping callback 'dense', as we already have a stdout callback.
Skipping callback 'full_skip', as we already have a stdout callback.
Skipping callback 'json', as we already have a stdout callback.
Skipping callback 'minimal', as we already have a stdout callback.
Skipping callback 'null', as we already have a stdout callback.
Skipping callback 'oneline', as we already have a stdout callback.
Skipping callback 'selective', as we already have a stdout callback.
Skipping callback 'skippy', as we already have a stdout callback.
Skipping callback 'stderr', as we already have a stdout callback.
Skipping callback 'unixy', as we already have a stdout callback.
Skipping callback 'yaml', as we already have a stdout callback.

PLAYBOOK: tests_tls_2019.yml ***************************************************
2 plays in /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_tls_2019.yml

PLAY [all] *********************************************************************
META: ran handlers

TASK [Include vault variables] *************************************************
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_tls_2019.yml:5
Wednesday 20 November 2024  08:15:56 -0500 (0:00:00.031)       0:00:00.031 **** 
ok: [managed-node2] => {
    "ansible_facts": {
        "mssql_password": {
            "__ansible_vault": "$ANSIBLE_VAULT;1.1;AES256\n66336361663164656232326461653662643537386337346563613939356466313835383235313234\n3634333565616161316639666662613564353237653663610a616639306439653033386664303839\n30663030636161326137656235636230356162373234386461363632353863393161353035316162\n3664353366373231360a343334326337353861366233656330363634353164316434616561333161\n3234\n"
        }
    },
    "ansible_included_var_files": [
        "/tmp/mssql-Xba/tests/vars/vault-variables.yml"
    ],
    "changed": false
}
META: ran handlers
META: ran handlers

PLAY [Ensure that tls encryption configuration works] **************************

TASK [Gathering Facts] *********************************************************
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_tls_2019.yml:9
Wednesday 20 November 2024  08:15:56 -0500 (0:00:00.032)       0:00:00.064 **** 
ok: [managed-node2]
META: ran handlers

TASK [Run tests_tls with SQL Server 2019] **************************************
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_tls_2019.yml:24
Wednesday 20 November 2024  08:15:57 -0500 (0:00:01.116)       0:00:01.180 **** 
included: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml for managed-node2

TASK [Assert fail on EL 7 with version = 2022 and EL 9 with version != 2022] ***
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:2
Wednesday 20 November 2024  08:15:57 -0500 (0:00:00.049)       0:00:01.229 **** 
included: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml for managed-node2

TASK [Ensure ansible_facts to get ansible_distribution] ************************
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:2
Wednesday 20 November 2024  08:15:57 -0500 (0:00:00.041)       0:00:01.271 **** 
ok: [managed-node2]

TASK [Run the role] ************************************************************
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:17
Wednesday 20 November 2024  08:15:58 -0500 (0:00:00.539)       0:00:01.810 **** 
skipping: [managed-node2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [Unreachable task] ********************************************************
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:24
Wednesday 20 November 2024  08:15:58 -0500 (0:00:00.026)       0:00:01.836 **** 
skipping: [managed-node2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [Ensure the openssl package] **********************************************
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:5
Wednesday 20 November 2024  08:15:58 -0500 (0:00:00.020)       0:00:01.857 **** 
ok: [managed-node2] => {
    "changed": false,
    "rc": 0,
    "results": []
}

MSG:

Nothing to do

TASK [Create a tempfile for a certificate on hosts] ****************************
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:11
Wednesday 20 November 2024  08:16:01 -0500 (0:00:03.258)       0:00:05.115 **** 
changed: [managed-node2] => {
    "changed": true,
    "gid": 0,
    "group": "root",
    "mode": "0600",
    "owner": "root",
    "path": "/tmp/ansible.sgzipt1f",
    "secontext": "unconfined_u:object_r:user_tmp_t:s0",
    "size": 0,
    "state": "file",
    "uid": 0
}

TASK [Create a tempfile for a private key on hosts] ****************************
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:17
Wednesday 20 November 2024  08:16:02 -0500 (0:00:00.537)       0:00:05.652 **** 
changed: [managed-node2] => {
    "changed": true,
    "gid": 0,
    "group": "root",
    "mode": "0600",
    "owner": "root",
    "path": "/tmp/ansible.5bani76m",
    "secontext": "unconfined_u:object_r:user_tmp_t:s0",
    "size": 0,
    "state": "file",
    "uid": 0
}

TASK [Generate a self-signed certificate and public key] ***********************
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:23
Wednesday 20 November 2024  08:16:02 -0500 (0:00:00.419)       0:00:06.071 **** 
changed: [managed-node2] => {
    "changed": true,
    "cmd": [
        "openssl",
        "req",
        "-x509",
        "-nodes",
        "-newkey",
        "rsa:2048",
        "-subj",
        "/CN=10.31.47.163",
        "-out",
        "/tmp/ansible.sgzipt1f",
        "-keyout",
        "/tmp/ansible.5bani76m",
        "-days",
        "365"
    ],
    "delta": "0:00:00.080353",
    "end": "2024-11-20 08:16:03.177997",
    "rc": 0,
    "start": "2024-11-20 08:16:03.097644"
}

STDERR:

Generating a RSA private key
........................+++++
.................................+++++
writing new private key to '/tmp/ansible.5bani76m'
-----

TASK [Copy certificate files to local tmp] *************************************
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:32
Wednesday 20 November 2024  08:16:03 -0500 (0:00:00.632)       0:00:06.704 **** 
changed: [managed-node2] => (item=/tmp/ansible.sgzipt1f) => {
    "ansible_loop_var": "item",
    "changed": true,
    "checksum": "8e7e4b92e1613b757614bbbdfea36b64c51ecd1e",
    "dest": "/tmp/ansible.sgzipt1f",
    "item": "/tmp/ansible.sgzipt1f",
    "md5sum": "6fd1c3627cb5e22dcc00393558e46e10",
    "remote_checksum": "8e7e4b92e1613b757614bbbdfea36b64c51ecd1e",
    "remote_md5sum": null
}
changed: [managed-node2] => (item=/tmp/ansible.5bani76m) => {
    "ansible_loop_var": "item",
    "changed": true,
    "checksum": "70e391b1c1479a8557ce64f54e99c23d5527fd59",
    "dest": "/tmp/ansible.5bani76m",
    "item": "/tmp/ansible.5bani76m",
    "md5sum": "3ccfbc7224e07f7596f14445a10feb5d",
    "remote_checksum": "70e391b1c1479a8557ce64f54e99c23d5527fd59",
    "remote_md5sum": null
}

TASK [Copy a private key to the playbook directory to test a relative path] ****
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:44
Wednesday 20 November 2024  08:16:04 -0500 (0:00:01.194)       0:00:07.898 **** 
changed: [managed-node2 -> localhost] => {
    "changed": true,
    "checksum": "70e391b1c1479a8557ce64f54e99c23d5527fd59",
    "dest": "./ansible.5bani76m",
    "gid": 0,
    "group": "root",
    "md5sum": "3ccfbc7224e07f7596f14445a10feb5d",
    "mode": "0600",
    "owner": "root",
    "size": 1708,
    "src": "/root/.ansible/tmp/ansible-tmp-1732108564.4784577-68390-11357383796467/source",
    "state": "file",
    "uid": 0
}

TASK [Set mssql_tls_cert and mssql_tls_private_key for the following test] *****
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:52
Wednesday 20 November 2024  08:16:05 -0500 (0:00:00.752)       0:00:08.651 **** 
ok: [managed-node2] => {
    "ansible_facts": {
        "mssql_tls_cert": "/tmp/ansible.sgzipt1f",
        "mssql_tls_private_key": "ansible.5bani76m"
    },
    "changed": false
}

TASK [Run role] ****************************************************************
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:59
Wednesday 20 November 2024  08:16:05 -0500 (0:00:00.025)       0:00:08.676 **** 

TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role] ***
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3
Wednesday 20 November 2024  08:16:05 -0500 (0:00:00.252)       0:00:08.929 **** 
included: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml for managed-node2

TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts used by role] *****
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3
Wednesday 20 November 2024  08:16:05 -0500 (0:00:00.022)       0:00:08.951 **** 
skipping: [managed-node2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Set platform/version specific variables] ***
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8
Wednesday 20 November 2024  08:16:05 -0500 (0:00:00.024)       0:00:08.975 **** 
ok: [managed-node2] => (item=RedHat.yml) => {
    "ansible_facts": {
        "__mssql_client_repository": "https://packages.microsoft.com/rhel/9/prod/",
        "__mssql_confined_supported": true,
        "__mssql_server_repository": "https://packages.microsoft.com/rhel/9/mssql-server-{{ mssql_version | int }}/",
        "__mssql_supported_versions": [
            2022
        ],
        "__mssql_tuned_supported": true
    },
    "ansible_included_var_files": [
        "/tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/RedHat.yml"
    ],
    "ansible_loop_var": "item",
    "changed": false,
    "item": "RedHat.yml"
}
skipping: [managed-node2] => (item=CentOS.yml)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": "CentOS.yml",
    "skip_reason": "Conditional result was False"
}
ok: [managed-node2] => (item=CentOS_8.yml) => {
    "ansible_facts": {
        "__mssql_client_repository": "https://packages.microsoft.com/rhel/8/prod/",
        "__mssql_confined_supported": false,
        "__mssql_server_repository": "https://packages.microsoft.com/rhel/8/mssql-server-{{ mssql_version | int }}/",
        "__mssql_supported_versions": [
            2017,
            2019,
            2022
        ]
    },
    "ansible_included_var_files": [
        "/tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/CentOS_8.yml"
    ],
    "ansible_loop_var": "item",
    "changed": false,
    "item": "CentOS_8.yml"
}
ok: [managed-node2] => (item=CentOS_8.yml) => {
    "ansible_facts": {
        "__mssql_client_repository": "https://packages.microsoft.com/rhel/8/prod/",
        "__mssql_confined_supported": false,
        "__mssql_server_repository": "https://packages.microsoft.com/rhel/8/mssql-server-{{ mssql_version | int }}/",
        "__mssql_supported_versions": [
            2017,
            2019,
            2022
        ]
    },
    "ansible_included_var_files": [
        "/tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/CentOS_8.yml"
    ],
    "ansible_loop_var": "item",
    "changed": false,
    "item": "CentOS_8.yml"
}

TASK [fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ***
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8
Wednesday 20 November 2024  08:16:05 -0500 (0:00:00.059)       0:00:09.034 **** 
ok: [managed-node2] => {
    "ansible_facts": {
        "__mssql_sqlcmd_login_cmd": null
    },
    "changed": false
}

TASK [fedora.linux_system_roles.mssql : Print that the mssql_input_sql_file variable is deprecated] ***
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:15
Wednesday 20 November 2024  08:16:05 -0500 (0:00:00.023)       0:00:09.058 **** 
skipping: [managed-node2] => {}

TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_input_sql_file fact] ***
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:23
Wednesday 20 November 2024  08:16:05 -0500 (0:00:00.036)       0:00:09.095 **** 
skipping: [managed-node2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Print that the variable is deprecated] ***
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:30
Wednesday 20 November 2024  08:16:05 -0500 (0:00:00.023)       0:00:09.118 **** 
skipping: [managed-node2] => {}

TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_ha_listener_port fact] ***
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:37
Wednesday 20 November 2024  08:16:05 -0500 (0:00:00.023)       0:00:09.142 **** 
skipping: [managed-node2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Print that the mssql_ad_sql_user_name variable is deprecated] ***
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:44
Wednesday 20 November 2024  08:16:05 -0500 (0:00:00.023)       0:00:09.166 **** 
skipping: [managed-node2] => {}

TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_ad_sql_user_name fact] ***
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:51
Wednesday 20 November 2024  08:16:05 -0500 (0:00:00.023)       0:00:09.189 **** 
skipping: [managed-node2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Print that the mssql_ha_cluster_run_role variable is deprecated] ***
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:58
Wednesday 20 November 2024  08:16:05 -0500 (0:00:00.024)       0:00:09.214 **** 
skipping: [managed-node2] => {}

TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_ha_cluster_run_role fact] ***
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:65
Wednesday 20 November 2024  08:16:05 -0500 (0:00:00.020)       0:00:09.234 **** 
skipping: [managed-node2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Fail on RHEL or CentOS 10 because it's not supported] ***
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:69
Wednesday 20 November 2024  08:16:05 -0500 (0:00:00.026)       0:00:09.261 **** 
skipping: [managed-node2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Verify that the user accepts EULA variables] ***
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:76
Wednesday 20 November 2024  08:16:05 -0500 (0:00:00.026)       0:00:09.288 **** 
ok: [managed-node2] => {
    "changed": false
}

MSG:

All assertions passed

TASK [fedora.linux_system_roles.mssql : Verify that EL < 8 is not used with mssql_ha_configure=true] ***
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:88
Wednesday 20 November 2024  08:16:05 -0500 (0:00:00.032)       0:00:09.321 **** 
skipping: [managed-node2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Verify if the mssql_ha_replica_type variable is provided correctly] ***
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:96
Wednesday 20 November 2024  08:16:05 -0500 (0:00:00.026)       0:00:09.347 **** 
skipping: [managed-node2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Verify that 'mssql_ha_replica_type = primary' is provided once] ***
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:105
Wednesday 20 November 2024  08:16:05 -0500 (0:00:00.024)       0:00:09.372 **** 
skipping: [managed-node2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Verify that mssql_ha_prep_for_pacemaker is provided correctly] ***
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:114
Wednesday 20 November 2024  08:16:05 -0500 (0:00:00.022)       0:00:09.394 **** 
skipping: [managed-node2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Verify that selinux variables are used on supported platforms] ***
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:124
Wednesday 20 November 2024  08:16:05 -0500 (0:00:00.017)       0:00:09.412 **** 
skipping: [managed-node2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Verify that mssql_manage_selinux is set properly] ***
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:133
Wednesday 20 November 2024  08:16:05 -0500 (0:00:00.024)       0:00:09.436 **** 
skipping: [managed-node2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Gather package facts] ******************
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:144
Wednesday 20 November 2024  08:16:05 -0500 (0:00:00.016)       0:00:09.452 **** 
ok: [managed-node2] => {
    "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result",
    "changed": false
}

TASK [fedora.linux_system_roles.mssql : Set fact with the currently installed SQL Server version if any] ***
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:148
Wednesday 20 November 2024  08:16:07 -0500 (0:00:01.765)       0:00:11.218 **** 
skipping: [managed-node2] => (item={'key': 2017, 'value': 14})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": {
        "key": 2017,
        "value": 14
    },
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node2] => (item={'key': 2019, 'value': 15})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": {
        "key": 2019,
        "value": 15
    },
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node2] => (item={'key': 2022, 'value': 16})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": {
        "key": 2022,
        "value": 16
    },
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Set mssql_version variable if user does not define it] ***
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:156
Wednesday 20 November 2024  08:16:07 -0500 (0:00:00.097)       0:00:11.315 **** 
skipping: [managed-node2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Verify if the mssql_version variable is provided correctly] ***
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:163
Wednesday 20 November 2024  08:16:07 -0500 (0:00:00.048)       0:00:11.363 **** 
ok: [managed-node2] => {
    "changed": false
}

MSG:

All assertions passed

TASK [fedora.linux_system_roles.mssql : Verify if mssql_version is not smaller then the existing SQL Server version] ***
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:170
Wednesday 20 November 2024  08:16:07 -0500 (0:00:00.053)       0:00:11.417 **** 
skipping: [managed-node2] => (item={'key': 2017, 'value': 14})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": {
        "key": 2017,
        "value": 14
    },
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node2] => (item={'key': 2019, 'value': 15})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": {
        "key": 2019,
        "value": 15
    },
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node2] => (item={'key': 2022, 'value': 16})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": {
        "key": 2022,
        "value": 16
    },
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories] ***
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:184
Wednesday 20 November 2024  08:16:08 -0500 (0:00:00.080)       0:00:11.497 **** 
ok: [managed-node2] => {
    "attempts": 1,
    "changed": false
}

TASK [fedora.linux_system_roles.mssql : Update all packages from SQL Server repo version {{ __mssql_current_version }}] ***
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:198
Wednesday 20 November 2024  08:16:08 -0500 (0:00:00.786)       0:00:12.284 **** 
skipping: [managed-node2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Get yum repositories] ******************
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:208
Wednesday 20 November 2024  08:16:08 -0500 (0:00:00.050)       0:00:12.334 **** 
skipping: [managed-node2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Remove the current Microsoft SQL Server repository to upgrade to 2019] ***
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:219
Wednesday 20 November 2024  08:16:08 -0500 (0:00:00.053)       0:00:12.387 **** 
skipping: [managed-node2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Update all packages from SQL Server repo version {{ __mssql_current_version }}] ***
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:233
Wednesday 20 November 2024  08:16:08 -0500 (0:00:00.057)       0:00:12.445 **** 
skipping: [managed-node2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Get zypper repositories] ***************
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:242
Wednesday 20 November 2024  08:16:09 -0500 (0:00:00.047)       0:00:12.492 **** 
skipping: [managed-node2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Remove the current Microsoft SQL Server repository to upgrade to 2019] ***
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:254
Wednesday 20 November 2024  08:16:09 -0500 (0:00:00.048)       0:00:12.541 **** 
skipping: [managed-node2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server repo version 2019] ***
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:261
Wednesday 20 November 2024  08:16:09 -0500 (0:00:00.036)       0:00:12.578 **** 
changed: [managed-node2] => {
    "changed": true,
    "repo": "packages-microsoft-com-mssql-server-2019",
    "state": "present"
}

TASK [fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server repo version 2019] ***
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:273
Wednesday 20 November 2024  08:16:09 -0500 (0:00:00.534)       0:00:13.113 **** 
skipping: [managed-node2] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Configure to run as a confined application with SELinux] ***
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:286
Wednesday 20 November 2024  08:16:09 -0500 (0:00:00.033)       0:00:13.146 **** 
ok: [managed-node2] => {
    "changed": false,
    "rc": 0,
    "results": []
}

MSG:

Nothing to do

TASK [fedora.linux_system_roles.mssql : Ensure the package mssql-server] *******
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:291
Wednesday 20 November 2024  08:16:12 -0500 (0:00:03.056)       0:00:16.202 **** 
fatal: [managed-node2]: FAILED! => {}

MSG:

Failed to connect to the host via ssh: ssh: connect to host 10.31.47.163 port 22: Connection refused

TASK [Remove a private key from the playbook directory] ************************
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:68
Wednesday 20 November 2024  08:16:32 -0500 (0:00:20.122)       0:00:36.325 **** 
changed: [managed-node2 -> localhost] => {
    "changed": true,
    "path": "ansible.5bani76m",
    "state": "absent"
}

TASK [Clean up after the role invocation] **************************************
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_tls_2019.yml:27
Wednesday 20 November 2024  08:16:33 -0500 (0:00:00.474)       0:00:36.799 **** 
included: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml for managed-node2

TASK [Gather package facts] ****************************************************
task path: /tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:2
Wednesday 20 November 2024  08:16:33 -0500 (0:00:00.057)       0:00:36.857 **** 
fatal: [managed-node2]: UNREACHABLE! => {
    "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result",
    "changed": false
}

PLAY RECAP *********************************************************************
managed-node2              : ok=23   changed=7    unreachable=1    failed=1    skipped=28   rescued=0    ignored=0   

Wednesday 20 November 2024  08:16:33 -0500 (0:00:00.022)       0:00:36.880 **** 
=============================================================================== 
fedora.linux_system_roles.mssql : Ensure the package mssql-server ------ 20.12s
/tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:291 
Ensure the openssl package ---------------------------------------------- 3.26s
/tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:5 
fedora.linux_system_roles.mssql : Configure to run as a confined application with SELinux --- 3.06s
/tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:286 
fedora.linux_system_roles.mssql : Gather package facts ------------------ 1.77s
/tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:144 
Copy certificate files to local tmp ------------------------------------- 1.19s
/tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:32 
Gathering Facts --------------------------------------------------------- 1.12s
/tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_tls_2019.yml:9 
fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories --- 0.79s
/tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:184 
Copy a private key to the playbook directory to test a relative path ---- 0.75s
/tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:44 
Generate a self-signed certificate and public key ----------------------- 0.63s
/tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:23 
Ensure ansible_facts to get ansible_distribution ------------------------ 0.54s
/tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:2 
Create a tempfile for a certificate on hosts ---------------------------- 0.54s
/tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:11 
fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server repo version 2019 --- 0.53s
/tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:261 
Remove a private key from the playbook directory ------------------------ 0.47s
/tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:68 
Create a tempfile for a private key on hosts ---------------------------- 0.42s
/tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:17 
Run role ---------------------------------------------------------------- 0.25s
/tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:59 
fedora.linux_system_roles.mssql : Set fact with the currently installed SQL Server version if any --- 0.10s
/tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:148 
fedora.linux_system_roles.mssql : Verify if mssql_version is not smaller then the existing SQL Server version --- 0.08s
/tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:170 
fedora.linux_system_roles.mssql : Set platform/version specific variables --- 0.06s
/tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8 
Clean up after the role invocation -------------------------------------- 0.06s
/tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_tls_2019.yml:27 
fedora.linux_system_roles.mssql : Remove the current Microsoft SQL Server repository to upgrade to 2019 --- 0.06s
/tmp/collections-DZc/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:219