ansible-playbook [core 2.17.12]
  config file = None
  configured module search path = ['/root/.ansible/plugins/modules', '/usr/share/ansible/plugins/modules']
  ansible python module location = /usr/local/lib/python3.12/site-packages/ansible
  ansible collection location = /tmp/collections-jIa
  executable location = /usr/local/bin/ansible-playbook
  python version = 3.12.10 (main, Apr 22 2025, 00:00:00) [GCC 11.5.0 20240719 (Red Hat 11.5.0-5)] (/usr/bin/python3.12)
  jinja version = 3.1.6
  libyaml = True
No config file found; using defaults
running playbook inside collection fedora.linux_system_roles
redirecting (type: callback) ansible.builtin.debug to ansible.posix.debug
redirecting (type: callback) ansible.builtin.debug to ansible.posix.debug
redirecting (type: callback) ansible.builtin.profile_tasks to ansible.posix.profile_tasks
Skipping callback 'default', as we already have a stdout callback.
Skipping callback 'minimal', as we already have a stdout callback.
Skipping callback 'oneline', as we already have a stdout callback.

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

PLAY [all] *********************************************************************

TASK [Include vault variables] *************************************************
task path: /tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_accept_eula.yml:5
Tuesday 20 May 2025  05:49:21 -0400 (0:00:00.011)       0:00:00.011 *********** 
ok: [managed-node3] => {
    "ansible_facts": {
        "mssql_password": {
            "__ansible_vault": "$ANSIBLE_VAULT;1.1;AES256\n66336361663164656232326461653662643537386337346563613939356466313835383235313234\n3634333565616161316639666662613564353237653663610a616639306439653033386664303839\n30663030636161326137656235636230356162373234386461363632353863393161353035316162\n3664353366373231360a343334326337353861366233656330363634353164316434616561333161\n3234\n"
        }
    },
    "ansible_included_var_files": [
        "/tmp/mssql-sNR/tests/vars/vault-variables.yml"
    ],
    "changed": false
}

PLAY [Ensure that the role runs when EULA are accepted] ************************

TASK [Gathering Facts] *********************************************************
task path: /tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_accept_eula.yml:9
Tuesday 20 May 2025  05:49:21 -0400 (0:00:00.026)       0:00:00.038 *********** 
[WARNING]: Platform linux on host managed-node3 is using the discovered Python
interpreter at /usr/bin/python3.9, but future installation of another Python
interpreter could change the meaning of that path. See
https://docs.ansible.com/ansible-
core/2.17/reference_appendices/interpreter_discovery.html for more information.
ok: [managed-node3]

TASK [Run the role with default parameters] ************************************
task path: /tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_accept_eula.yml:25
Tuesday 20 May 2025  05:49:24 -0400 (0:00:02.707)       0:00:02.746 *********** 
included: fedora.linux_system_roles.mssql for managed-node3

TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role] ***
task path: /tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3
Tuesday 20 May 2025  05:49:24 -0400 (0:00:00.225)       0:00:02.971 *********** 
included: /tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml for managed-node3

TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts used by role] *****
task path: /tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3
Tuesday 20 May 2025  05:49:24 -0400 (0:00:00.019)       0:00:02.991 *********** 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_required_facts | difference(ansible_facts.keys() | list) | length > 0",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Set platform/version specific variables] ***
task path: /tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8
Tuesday 20 May 2025  05:49:24 -0400 (0:00:00.034)       0:00:03.025 *********** 
ok: [managed-node3] => (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-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/RedHat.yml"
    ],
    "ansible_loop_var": "item",
    "changed": false,
    "item": "RedHat.yml"
}
skipping: [managed-node3] => (item=CentOS.yml)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "__mssql_vars_file is file",
    "item": "CentOS.yml",
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node3] => (item=CentOS_9.yml)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "__mssql_vars_file is file",
    "item": "CentOS_9.yml",
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node3] => (item=CentOS_9.yml)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "__mssql_vars_file is file",
    "item": "CentOS_9.yml",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ***
task path: /tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8
Tuesday 20 May 2025  05:49:25 -0400 (0:00:00.037)       0:00:03.063 *********** 
ok: [managed-node3] => {
    "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-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:15
Tuesday 20 May 2025  05:49:25 -0400 (0:00:00.016)       0:00:03.080 *********** 
skipping: [managed-node3] => {
    "false_condition": "mssql_input_sql_file is defined"
}

TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_input_sql_file fact] ***
task path: /tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:23
Tuesday 20 May 2025  05:49:25 -0400 (0:00:00.027)       0:00:03.107 *********** 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_input_sql_file is defined",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Print that the variable is deprecated] ***
task path: /tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:30
Tuesday 20 May 2025  05:49:25 -0400 (0:00:00.019)       0:00:03.127 *********** 
skipping: [managed-node3] => {
    "false_condition": "mssql_ha_listener_port is defined"
}

TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_ha_listener_port fact] ***
task path: /tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:37
Tuesday 20 May 2025  05:49:25 -0400 (0:00:00.025)       0:00:03.152 *********** 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_listener_port is defined",
    "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-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:44
Tuesday 20 May 2025  05:49:25 -0400 (0:00:00.029)       0:00:03.181 *********** 
skipping: [managed-node3] => {
    "false_condition": "mssql_ad_sql_user_name is defined"
}

TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_ad_sql_user_name fact] ***
task path: /tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:51
Tuesday 20 May 2025  05:49:25 -0400 (0:00:00.029)       0:00:03.210 *********** 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ad_sql_user_name is defined",
    "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-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:58
Tuesday 20 May 2025  05:49:25 -0400 (0:00:00.029)       0:00:03.240 *********** 
skipping: [managed-node3] => {
    "false_condition": "mssql_ha_cluster_run_role is defined"
}

TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_ha_cluster_run_role fact] ***
task path: /tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:65
Tuesday 20 May 2025  05:49:25 -0400 (0:00:00.032)       0:00:03.273 *********** 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_cluster_run_role is defined",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Print that variable is deprecated] *****
task path: /tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:74
Tuesday 20 May 2025  05:49:25 -0400 (0:00:00.031)       0:00:03.304 *********** 
skipping: [managed-node3] => {
    "false_condition": "mssql_accept_microsoft_odbc_driver_17_for_sql_server_eula is defined"
}

TASK [fedora.linux_system_roles.mssql : Link the deprecated fact] **************
task path: /tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:83
Tuesday 20 May 2025  05:49:25 -0400 (0:00:00.026)       0:00:03.331 *********** 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_accept_microsoft_odbc_driver_17_for_sql_server_eula is defined",
    "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-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:87
Tuesday 20 May 2025  05:49:25 -0400 (0:00:00.031)       0:00:03.362 *********** 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "ansible_distribution_major_version is version('10', '=')",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Verify that the user accepts EULA variables] ***
task path: /tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:94
Tuesday 20 May 2025  05:49:25 -0400 (0:00:00.047)       0:00:03.409 *********** 
ok: [managed-node3] => {
    "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-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:106
Tuesday 20 May 2025  05:49:25 -0400 (0:00:00.069)       0:00:03.479 *********** 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "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-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:114
Tuesday 20 May 2025  05:49:25 -0400 (0:00:00.058)       0:00:03.537 *********** 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "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-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:123
Tuesday 20 May 2025  05:49:25 -0400 (0:00:00.067)       0:00:03.605 *********** 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "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-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:132
Tuesday 20 May 2025  05:49:25 -0400 (0:00:00.076)       0:00:03.682 *********** 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_ag_cluster_type | lower == 'none'",
    "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-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:142
Tuesday 20 May 2025  05:49:25 -0400 (0:00:00.097)       0:00:03.779 *********** 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "not __mssql_confined_supported",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Verify that mssql_manage_selinux is set properly] ***
task path: /tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:151
Tuesday 20 May 2025  05:49:25 -0400 (0:00:00.075)       0:00:03.855 *********** 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "not mssql_run_selinux_confined",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Gather package facts] ******************
task path: /tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:162
Tuesday 20 May 2025  05:49:25 -0400 (0:00:00.131)       0:00:03.987 *********** 
ok: [managed-node3] => {
    "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-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:166
Tuesday 20 May 2025  05:49:27 -0400 (0:00:01.498)       0:00:05.485 *********** 
skipping: [managed-node3] => (item={'key': 2017, 'value': 14})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "ansible_facts.packages[\"mssql-server\"][0][\"version\"] is defined",
    "item": {
        "key": 2017,
        "value": 14
    },
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node3] => (item={'key': 2019, 'value': 15})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "ansible_facts.packages[\"mssql-server\"][0][\"version\"] is defined",
    "item": {
        "key": 2019,
        "value": 15
    },
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node3] => (item={'key': 2022, 'value': 16})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "ansible_facts.packages[\"mssql-server\"][0][\"version\"] is defined",
    "item": {
        "key": 2022,
        "value": 16
    },
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node3] => {
    "changed": false
}

MSG:

All items skipped

TASK [fedora.linux_system_roles.mssql : Set mssql_version variable if user does not define it] ***
task path: /tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:174
Tuesday 20 May 2025  05:49:27 -0400 (0:00:00.080)       0:00:05.565 *********** 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_version is none",
    "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-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:181
Tuesday 20 May 2025  05:49:27 -0400 (0:00:00.049)       0:00:05.615 *********** 
ok: [managed-node3] => {
    "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-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:188
Tuesday 20 May 2025  05:49:27 -0400 (0:00:00.134)       0:00:05.750 *********** 
skipping: [managed-node3] => (item={'key': 2017, 'value': 14})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "mssql_version | int == item.key",
    "item": {
        "key": 2017,
        "value": 14
    },
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node3] => (item={'key': 2019, 'value': 15})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "mssql_version | int == item.key",
    "item": {
        "key": 2019,
        "value": 15
    },
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node3] => (item={'key': 2022, 'value': 16})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "ansible_facts.packages[\"mssql-server\"][0][\"version\"] is defined",
    "item": {
        "key": 2022,
        "value": 16
    },
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node3] => {
    "changed": false
}

MSG:

All items skipped

TASK [fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories] ***
task path: /tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:202
Tuesday 20 May 2025  05:49:27 -0400 (0:00:00.158)       0:00:05.908 *********** 
changed: [managed-node3] => {
    "attempts": 1,
    "changed": true
}

TASK [fedora.linux_system_roles.mssql : Update all packages from SQL Server repo version {{ __mssql_current_version }}] ***
task path: /tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:216
Tuesday 20 May 2025  05:49:28 -0400 (0:00:00.877)       0:00:06.786 *********** 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_current_version is defined",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Get yum repositories] ******************
task path: /tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:226
Tuesday 20 May 2025  05:49:28 -0400 (0:00:00.055)       0:00:06.842 *********** 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_current_version is defined",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Remove the current Microsoft SQL Server repository to upgrade to 2022] ***
task path: /tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:237
Tuesday 20 May 2025  05:49:28 -0400 (0:00:00.064)       0:00:06.906 *********** 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_current_version is defined",
    "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-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:251
Tuesday 20 May 2025  05:49:28 -0400 (0:00:00.041)       0:00:06.948 *********** 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_current_version is defined",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Get zypper repositories] ***************
task path: /tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:260
Tuesday 20 May 2025  05:49:28 -0400 (0:00:00.033)       0:00:06.982 *********** 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_current_version is defined",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Remove the current Microsoft SQL Server repository to upgrade to 2022] ***
task path: /tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:272
Tuesday 20 May 2025  05:49:28 -0400 (0:00:00.054)       0:00:07.037 *********** 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_current_version is defined",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server repo version 2022] ***
task path: /tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:279
Tuesday 20 May 2025  05:49:29 -0400 (0:00:00.098)       0:00:07.135 *********** 
redirecting (type: action) ansible.builtin.yum to ansible.builtin.dnf
changed: [managed-node3] => {
    "changed": true,
    "repo": "packages-microsoft-com-mssql-server-2022",
    "state": "present"
}

TASK [fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server repo version 2022] ***
task path: /tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:291
Tuesday 20 May 2025  05:49:29 -0400 (0:00:00.520)       0:00:07.655 *********** 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "ansible_pkg_mgr == \"zypper\"",
    "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-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:304
Tuesday 20 May 2025  05:49:29 -0400 (0:00:00.034)       0:00:07.690 *********** 
fatal: [managed-node3]: FAILED! => {}

MSG:

Failed to connect to the host via ssh: OpenSSH_8.7p1, OpenSSL 3.5.0 8 Apr 2025
debug1: Reading configuration data /root/.ssh/config
debug1: Reading configuration data /etc/ssh/ssh_config
debug1: Reading configuration data /etc/ssh/ssh_config.d/50-redhat.conf
debug2: checking match for 'final all' host 10.31.47.49 originally 10.31.47.49
debug2: match not found
debug1: Reading configuration data /etc/crypto-policies/back-ends/openssh.config
debug1: configuration requests final Match pass
debug2: resolve_canonicalize: hostname 10.31.47.49 is address
debug1: re-parsing configuration
debug1: Reading configuration data /root/.ssh/config
debug1: Reading configuration data /etc/ssh/ssh_config
debug1: Reading configuration data /etc/ssh/ssh_config.d/50-redhat.conf
debug2: checking match for 'final all' host 10.31.47.49 originally 10.31.47.49
debug2: match found
debug1: Reading configuration data /etc/crypto-policies/back-ends/openssh.config
debug1: auto-mux: Trying existing master
debug1: Control socket "/root/.ansible/cp/3c856d89df" does not exist
debug1: Connecting to 10.31.47.49 [10.31.47.49] port 22.
debug2: fd 3 setting O_NONBLOCK
debug1: connect to address 10.31.47.49 port 22: Connection refused
ssh: connect to host 10.31.47.49 port 22: Connection refused

TASK [Assert that the role failed with variables undefined] ********************
task path: /tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_accept_eula.yml:34
Tuesday 20 May 2025  05:49:41 -0400 (0:00:11.674)       0:00:19.364 *********** 
fatal: [managed-node3]: FAILED! => {
    "assertion": "'You must define the following variables to set up MSSQL' in ansible_failed_result.msg.0",
    "changed": false,
    "evaluated_to": false
}

MSG:

Assertion failed

TASK [Clean up after the role invocation] **************************************
task path: /tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_accept_eula.yml:40
Tuesday 20 May 2025  05:49:41 -0400 (0:00:00.033)       0:00:19.397 *********** 
included: /tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml for managed-node3

TASK [Gather package facts] ****************************************************
task path: /tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:2
Tuesday 20 May 2025  05:49:41 -0400 (0:00:00.052)       0:00:19.450 *********** 
fatal: [managed-node3]: 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-node3              : ok=12   changed=2    unreachable=1    failed=1    skipped=28   rescued=1    ignored=0   


TASKS RECAP ********************************************************************
Tuesday 20 May 2025  05:49:41 -0400 (0:00:00.020)       0:00:19.471 *********** 
=============================================================================== 
fedora.linux_system_roles.mssql : Configure to run as a confined application with SELinux -- 11.67s
/tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:304 
Gathering Facts --------------------------------------------------------- 2.71s
/tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_accept_eula.yml:9 
fedora.linux_system_roles.mssql : Gather package facts ------------------ 1.50s
/tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:162 
fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories --- 0.88s
/tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:202 
fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server repo version 2022 --- 0.52s
/tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:279 
Run the role with default parameters ------------------------------------ 0.23s
/tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_accept_eula.yml:25 
fedora.linux_system_roles.mssql : Verify if mssql_version is not smaller then the existing SQL Server version --- 0.16s
/tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:188 
fedora.linux_system_roles.mssql : Verify if the mssql_version variable is provided correctly --- 0.13s
/tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:181 
fedora.linux_system_roles.mssql : Verify that mssql_manage_selinux is set properly --- 0.13s
/tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:151 
fedora.linux_system_roles.mssql : Remove the current Microsoft SQL Server repository to upgrade to 2022 --- 0.10s
/tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:272 
fedora.linux_system_roles.mssql : Verify that mssql_ha_prep_for_pacemaker is provided correctly --- 0.10s
/tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:132 
fedora.linux_system_roles.mssql : Set fact with the currently installed SQL Server version if any --- 0.08s
/tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:166 
fedora.linux_system_roles.mssql : Verify that 'mssql_ha_replica_type = primary' is provided once --- 0.08s
/tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:123 
fedora.linux_system_roles.mssql : Verify that selinux variables are used on supported platforms --- 0.08s
/tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:142 
fedora.linux_system_roles.mssql : Verify that the user accepts EULA variables --- 0.07s
/tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:94 
fedora.linux_system_roles.mssql : Verify if the mssql_ha_replica_type variable is provided correctly --- 0.07s
/tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:114 
fedora.linux_system_roles.mssql : Get yum repositories ------------------ 0.06s
/tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:226 
fedora.linux_system_roles.mssql : Verify that EL < 8 is not used with mssql_ha_configure=true --- 0.06s
/tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:106 
fedora.linux_system_roles.mssql : Update all packages from SQL Server repo version {{ __mssql_current_version }} --- 0.06s
/tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:216 
fedora.linux_system_roles.mssql : Get zypper repositories --------------- 0.05s
/tmp/collections-jIa/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:260