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-OFW executable location = /usr/local/bin/ansible-playbook python version = 3.12.10 (main, May 9 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 Skipping callback 'debug', as we already have a stdout callback. Skipping callback 'json', as we already have a stdout callback. Skipping callback 'jsonl', as we already have a stdout callback. 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_tls_2019.yml *************************************************** 2 plays in /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_tls_2019.yml PLAY [all] ********************************************************************* TASK [Include vault variables] ************************************************* task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_tls_2019.yml:5 Friday 23 May 2025 21:23:45 -0400 (0:00:00.034) 0:00:00.034 ************ 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-eQx/tests/vars/vault-variables.yml" ], "changed": false } PLAY [Ensure that tls encryption configuration works] ************************** TASK [Gathering Facts] ********************************************************* task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_tls_2019.yml:9 Friday 23 May 2025 21:23:45 -0400 (0:00:00.024) 0:00:00.059 ************ [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 tests_tls with SQL Server 2019] ************************************** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_tls_2019.yml:24 Friday 23 May 2025 21:23:47 -0400 (0:00:01.296) 0:00:01.356 ************ included: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml for managed-node3 TASK [Assert fail on EL 7 with version = 2022 and EL 9 with version != 2022] *** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:2 Friday 23 May 2025 21:23:47 -0400 (0:00:00.044) 0:00:01.401 ************ included: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml for managed-node3 TASK [Ensure ansible_facts to get ansible_distribution] ************************ task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:2 Friday 23 May 2025 21:23:47 -0400 (0:00:00.020) 0:00:01.421 ************ ok: [managed-node3] TASK [Run the role] ************************************************************ task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:17 Friday 23 May 2025 21:23:47 -0400 (0:00:00.474) 0:00:01.895 ************ 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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3 Friday 23 May 2025 21:23:47 -0400 (0:00:00.243) 0:00:02.139 ************ included: /tmp/collections-OFW/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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 Friday 23 May 2025 21:23:48 -0400 (0:00:00.073) 0:00:02.213 ************ 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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8 Friday 23 May 2025 21:23:48 -0400 (0:00:00.083) 0:00:02.296 ************ 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-OFW/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 : Run systemctl] ************************* task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:22 Friday 23 May 2025 21:23:48 -0400 (0:00:00.089) 0:00:02.385 ************ ok: [managed-node3] => { "changed": false, "cmd": [ "systemctl", "is-system-running" ], "delta": "0:00:00.007917", "end": "2025-05-23 21:23:48.673157", "failed_when_result": false, "rc": 0, "start": "2025-05-23 21:23:48.665240" } STDOUT: running TASK [fedora.linux_system_roles.mssql : Require installed systemd] ************* task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:29 Friday 23 May 2025 21:23:48 -0400 (0:00:00.486) 0:00:02.871 ************ skipping: [managed-node3] => { "changed": false, "false_condition": "\"No such file or directory\" in __is_system_running.msg | d(\"\")", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Set flag to indicate that systemd runtime operations are available] *** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:34 Friday 23 May 2025 21:23:48 -0400 (0:00:00.041) 0:00:02.912 ************ ok: [managed-node3] => { "ansible_facts": { "__mssql_is_booted": true }, "changed": false } TASK [fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] *** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8 Friday 23 May 2025 21:23:48 -0400 (0:00:00.041) 0:00:02.954 ************ 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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:15 Friday 23 May 2025 21:23:48 -0400 (0:00:00.039) 0:00:02.993 ************ 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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:23 Friday 23 May 2025 21:23:48 -0400 (0:00:00.037) 0:00:03.030 ************ 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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:30 Friday 23 May 2025 21:23:48 -0400 (0:00:00.037) 0:00:03.068 ************ 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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:37 Friday 23 May 2025 21:23:48 -0400 (0:00:00.037) 0:00:03.105 ************ 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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:44 Friday 23 May 2025 21:23:48 -0400 (0:00:00.037) 0:00:03.143 ************ 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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:51 Friday 23 May 2025 21:23:49 -0400 (0:00:00.037) 0:00:03.180 ************ 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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:58 Friday 23 May 2025 21:23:49 -0400 (0:00:00.037) 0:00:03.218 ************ 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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:65 Friday 23 May 2025 21:23:49 -0400 (0:00:00.038) 0:00:03.256 ************ 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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:74 Friday 23 May 2025 21:23:49 -0400 (0:00:00.042) 0:00:03.299 ************ 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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:83 Friday 23 May 2025 21:23:49 -0400 (0:00:00.045) 0:00:03.344 ************ 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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:87 Friday 23 May 2025 21:23:49 -0400 (0:00:00.037) 0:00:03.382 ************ 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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:94 Friday 23 May 2025 21:23:49 -0400 (0:00:00.038) 0:00:03.420 ************ 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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:106 Friday 23 May 2025 21:23:49 -0400 (0:00:00.041) 0:00:03.462 ************ 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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:114 Friday 23 May 2025 21:23:49 -0400 (0:00:00.038) 0:00:03.500 ************ 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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:123 Friday 23 May 2025 21:23:49 -0400 (0:00:00.039) 0:00:03.539 ************ 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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:132 Friday 23 May 2025 21:23:49 -0400 (0:00:00.037) 0:00:03.577 ************ 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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:142 Friday 23 May 2025 21:23:49 -0400 (0:00:00.039) 0:00:03.616 ************ 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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:151 Friday 23 May 2025 21:23:49 -0400 (0:00:00.041) 0:00:03.658 ************ skipping: [managed-node3] => { "changed": false, "false_condition": "mssql_manage_selinux | bool", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Gather package facts] ****************** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:162 Friday 23 May 2025 21:23:49 -0400 (0:00:00.039) 0:00:03.697 ************ 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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:166 Friday 23 May 2025 21:23:50 -0400 (0:00:01.003) 0:00:04.701 ************ 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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:174 Friday 23 May 2025 21:23:50 -0400 (0:00:00.081) 0:00:04.783 ************ 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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:181 Friday 23 May 2025 21:23:50 -0400 (0:00:00.052) 0:00:04.835 ************ fatal: [managed-node3]: FAILED! => { "assertion": "mssql_version | int in __mssql_supported_versions", "changed": false, "evaluated_to": false } MSG: You must set the mssql_version variable to one of 2022 TASK [Assert that the role failed with EL < 8 not supported] ******************* task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:28 Friday 23 May 2025 21:23:50 -0400 (0:00:00.059) 0:00:04.895 ************ ok: [managed-node3] => { "changed": false } MSG: All assertions passed TASK [Clean up after the role invocation] ************************************** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:34 Friday 23 May 2025 21:23:50 -0400 (0:00:00.053) 0:00:04.948 ************ included: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml for managed-node3 TASK [Gather package facts] **************************************************** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:2 Friday 23 May 2025 21:23:50 -0400 (0:00:00.163) 0:00:05.112 ************ 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 [Set role variables needed for cleanup] *********************************** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:6 Friday 23 May 2025 21:23:51 -0400 (0:00:00.828) 0:00:05.940 ************ included: fedora.linux_system_roles.mssql for managed-node3 TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts used by role] ***** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 Friday 23 May 2025 21:23:51 -0400 (0:00:00.089) 0:00:06.030 ************ 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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8 Friday 23 May 2025 21:23:51 -0400 (0:00:00.069) 0:00:06.099 ************ 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-OFW/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 : Run systemctl] ************************* task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:22 Friday 23 May 2025 21:23:52 -0400 (0:00:00.090) 0:00:06.190 ************ skipping: [managed-node3] => { "changed": false, "false_condition": "__mssql_is_booted is not defined", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Require installed systemd] ************* task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:29 Friday 23 May 2025 21:23:52 -0400 (0:00:00.057) 0:00:06.248 ************ skipping: [managed-node3] => { "changed": false, "false_condition": "__mssql_is_booted is not defined", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Set flag to indicate that systemd runtime operations are available] *** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:34 Friday 23 May 2025 21:23:52 -0400 (0:00:00.052) 0:00:06.300 ************ skipping: [managed-node3] => { "changed": false, "false_condition": "__mssql_is_booted is not defined", "skip_reason": "Conditional result was False" } TASK [Purge cluster configuration] ********************************************* task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:12 Friday 23 May 2025 21:23:52 -0400 (0:00:00.065) 0:00:06.366 ************ skipping: [managed-node3] => { "changed": false, "false_condition": "ansible_facts.packages.pcs is defined", "skip_reason": "Conditional result was False" } TASK [Debug ansible_python_version] ******************************************** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:20 Friday 23 May 2025 21:23:52 -0400 (0:00:00.102) 0:00:06.469 ************ ok: [managed-node3] => { "ansible_python_version": "3.9.21" } TASK [Purge firewall configuration] ******************************************** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:24 Friday 23 May 2025 21:23:52 -0400 (0:00:00.093) 0:00:06.562 ************ included: fedora.linux_system_roles.firewall for managed-node3 TASK [fedora.linux_system_roles.firewall : Setup firewalld] ******************** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:2 Friday 23 May 2025 21:23:52 -0400 (0:00:00.210) 0:00:06.773 ************ included: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml for managed-node3 TASK [fedora.linux_system_roles.firewall : Ensure ansible_facts used by role] *** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:2 Friday 23 May 2025 21:23:52 -0400 (0:00:00.256) 0:00:07.030 ************ skipping: [managed-node3] => { "changed": false, "false_condition": "__firewall_required_facts | difference(ansible_facts.keys() | list) | length > 0", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.firewall : Check if system is ostree] ********** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:10 Friday 23 May 2025 21:23:52 -0400 (0:00:00.118) 0:00:07.148 ************ ok: [managed-node3] => { "changed": false, "stat": { "exists": false } } TASK [fedora.linux_system_roles.firewall : Set flag to indicate system is ostree] *** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:15 Friday 23 May 2025 21:23:53 -0400 (0:00:00.622) 0:00:07.771 ************ ok: [managed-node3] => { "ansible_facts": { "__firewall_is_ostree": false }, "changed": false } TASK [fedora.linux_system_roles.firewall : Check if transactional-update exists in /sbin] *** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:22 Friday 23 May 2025 21:23:53 -0400 (0:00:00.077) 0:00:07.848 ************ ok: [managed-node3] => { "changed": false, "stat": { "exists": false } } TASK [fedora.linux_system_roles.firewall : Set flag if transactional-update exists] *** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:27 Friday 23 May 2025 21:23:54 -0400 (0:00:00.521) 0:00:08.370 ************ ok: [managed-node3] => { "ansible_facts": { "__firewall_is_transactional": false }, "changed": false } TASK [fedora.linux_system_roles.firewall : Run systemctl] ********************** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:34 Friday 23 May 2025 21:23:54 -0400 (0:00:00.160) 0:00:08.530 ************ ok: [managed-node3] => { "changed": false, "cmd": [ "systemctl", "is-system-running" ], "delta": "0:00:00.007462", "end": "2025-05-23 21:23:54.761960", "failed_when_result": false, "rc": 0, "start": "2025-05-23 21:23:54.754498" } STDOUT: running TASK [fedora.linux_system_roles.firewall : Require installed systemd] ********** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:41 Friday 23 May 2025 21:23:54 -0400 (0:00:00.463) 0:00:08.993 ************ skipping: [managed-node3] => { "changed": false, "false_condition": "\"No such file or directory\" in __is_system_running.msg | d(\"\")", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.firewall : Set flag to indicate that systemd runtime operations are available] *** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:46 Friday 23 May 2025 21:23:54 -0400 (0:00:00.111) 0:00:09.105 ************ ok: [managed-node3] => { "ansible_facts": { "__firewall_is_booted": true }, "changed": false } TASK [fedora.linux_system_roles.firewall : Install firewalld] ****************** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:51 Friday 23 May 2025 21:23:55 -0400 (0:00:00.113) 0:00:09.219 ************ fatal: [managed-node3]: FAILED! => { "changed": false, "rc": 1, "results": [] } MSG: Failed to download metadata for repo 'highavailability': Cannot download repomd.xml: Cannot download repodata/repomd.xml: All mirrors were tried TASK [Clean up after the role invocation] ************************************** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_tls_2019.yml:27 Friday 23 May 2025 21:23:59 -0400 (0:00:04.295) 0:00:13.514 ************ included: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml for managed-node3 TASK [Gather package facts] **************************************************** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:2 Friday 23 May 2025 21:23:59 -0400 (0:00:00.072) 0:00:13.587 ************ 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 [Set role variables needed for cleanup] *********************************** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:6 Friday 23 May 2025 21:24:00 -0400 (0:00:00.752) 0:00:14.340 ************ included: fedora.linux_system_roles.mssql for managed-node3 TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts used by role] ***** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 Friday 23 May 2025 21:24:00 -0400 (0:00:00.056) 0:00:14.396 ************ 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-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8 Friday 23 May 2025 21:24:00 -0400 (0:00:00.067) 0:00:14.464 ************ 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-OFW/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 : Run systemctl] ************************* task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:22 Friday 23 May 2025 21:24:00 -0400 (0:00:00.077) 0:00:14.541 ************ skipping: [managed-node3] => { "changed": false, "false_condition": "__mssql_is_booted is not defined", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Require installed systemd] ************* task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:29 Friday 23 May 2025 21:24:00 -0400 (0:00:00.036) 0:00:14.578 ************ skipping: [managed-node3] => { "changed": false, "false_condition": "__mssql_is_booted is not defined", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Set flag to indicate that systemd runtime operations are available] *** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:34 Friday 23 May 2025 21:24:00 -0400 (0:00:00.040) 0:00:14.618 ************ skipping: [managed-node3] => { "changed": false, "false_condition": "__mssql_is_booted is not defined", "skip_reason": "Conditional result was False" } TASK [Purge cluster configuration] ********************************************* task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:12 Friday 23 May 2025 21:24:00 -0400 (0:00:00.079) 0:00:14.698 ************ skipping: [managed-node3] => { "changed": false, "false_condition": "ansible_facts.packages.pcs is defined", "skip_reason": "Conditional result was False" } TASK [Debug ansible_python_version] ******************************************** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:20 Friday 23 May 2025 21:24:00 -0400 (0:00:00.063) 0:00:14.762 ************ ok: [managed-node3] => { "ansible_python_version": "3.9.21" } TASK [Purge firewall configuration] ******************************************** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:24 Friday 23 May 2025 21:24:00 -0400 (0:00:00.052) 0:00:14.815 ************ included: fedora.linux_system_roles.firewall for managed-node3 TASK [fedora.linux_system_roles.firewall : Setup firewalld] ******************** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:2 Friday 23 May 2025 21:24:00 -0400 (0:00:00.169) 0:00:14.984 ************ included: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml for managed-node3 TASK [fedora.linux_system_roles.firewall : Ensure ansible_facts used by role] *** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:2 Friday 23 May 2025 21:24:00 -0400 (0:00:00.058) 0:00:15.043 ************ skipping: [managed-node3] => { "changed": false, "false_condition": "__firewall_required_facts | difference(ansible_facts.keys() | list) | length > 0", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.firewall : Check if system is ostree] ********** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:10 Friday 23 May 2025 21:24:00 -0400 (0:00:00.051) 0:00:15.094 ************ skipping: [managed-node3] => { "changed": false, "false_condition": "__firewall_is_ostree is not defined", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.firewall : Set flag to indicate system is ostree] *** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:15 Friday 23 May 2025 21:24:00 -0400 (0:00:00.031) 0:00:15.126 ************ skipping: [managed-node3] => { "changed": false, "false_condition": "__firewall_is_ostree is not defined", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.firewall : Check if transactional-update exists in /sbin] *** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:22 Friday 23 May 2025 21:24:01 -0400 (0:00:00.030) 0:00:15.157 ************ skipping: [managed-node3] => { "changed": false, "false_condition": "not __firewall_is_transactional is defined", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.firewall : Set flag if transactional-update exists] *** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:27 Friday 23 May 2025 21:24:01 -0400 (0:00:00.030) 0:00:15.188 ************ skipping: [managed-node3] => { "changed": false, "false_condition": "not __firewall_is_transactional is defined", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.firewall : Run systemctl] ********************** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:34 Friday 23 May 2025 21:24:01 -0400 (0:00:00.029) 0:00:15.218 ************ skipping: [managed-node3] => { "changed": false, "false_condition": "__firewall_is_booted is not defined", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.firewall : Require installed systemd] ********** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:41 Friday 23 May 2025 21:24:01 -0400 (0:00:00.029) 0:00:15.248 ************ skipping: [managed-node3] => { "changed": false, "false_condition": "__firewall_is_booted is not defined", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.firewall : Set flag to indicate that systemd runtime operations are available] *** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:46 Friday 23 May 2025 21:24:01 -0400 (0:00:00.030) 0:00:15.278 ************ skipping: [managed-node3] => { "changed": false, "false_condition": "__firewall_is_booted is not defined", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.firewall : Install firewalld] ****************** task path: /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:51 Friday 23 May 2025 21:24:01 -0400 (0:00:00.032) 0:00:15.311 ************ fatal: [managed-node3]: FAILED! => { "changed": false, "rc": 1, "results": [] } MSG: Failed to download metadata for repo 'highavailability': Cannot download repomd.xml: Cannot download repodata/repomd.xml: All mirrors were tried PLAY RECAP ********************************************************************* managed-node3 : ok=34 changed=0 unreachable=0 failed=2 skipped=41 rescued=1 ignored=0 SYSTEM ROLES ERRORS BEGIN v1 [ { "ansible_version": "2.17.12", "end_time": "2025-05-24T01:23:50.729314+00:00Z", "host": "managed-node3", "message": "You must set the mssql_version variable to one of 2022", "start_time": "2025-05-24T01:23:50.687899+00:00Z", "task_name": "Verify if the mssql_version variable is provided correctly", "task_path": "/tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:181" }, { "ansible_version": "2.17.12", "end_time": "2025-05-24T01:23:59.349564+00:00Z", "host": "managed-node3", "message": "Failed to download metadata for repo 'highavailability': Cannot download repomd.xml: Cannot download repodata/repomd.xml: All mirrors were tried", "rc": 1, "start_time": "2025-05-24T01:23:55.071619+00:00Z", "task_name": "Install firewalld", "task_path": "/tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:51" }, { "ansible_version": "2.17.12", "end_time": "2025-05-24T01:24:06.130286+00:00Z", "host": "managed-node3", "message": "Failed to download metadata for repo 'highavailability': Cannot download repomd.xml: Cannot download repodata/repomd.xml: All mirrors were tried", "rc": 1, "start_time": "2025-05-24T01:24:01.163637+00:00Z", "task_name": "Install firewalld", "task_path": "/tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:51" } ] SYSTEM ROLES ERRORS END v1 TASKS RECAP ******************************************************************** Friday 23 May 2025 21:24:06 -0400 (0:00:04.968) 0:00:20.280 ************ =============================================================================== fedora.linux_system_roles.firewall : Install firewalld ------------------ 4.97s /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:51 fedora.linux_system_roles.firewall : Install firewalld ------------------ 4.30s /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:51 Gathering Facts --------------------------------------------------------- 1.30s /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_tls_2019.yml:9 fedora.linux_system_roles.mssql : Gather package facts ------------------ 1.00s /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:162 Gather package facts ---------------------------------------------------- 0.83s /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:2 Gather package facts ---------------------------------------------------- 0.75s /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:2 fedora.linux_system_roles.firewall : Check if system is ostree ---------- 0.62s /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:10 fedora.linux_system_roles.firewall : Check if transactional-update exists in /sbin --- 0.52s /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:22 fedora.linux_system_roles.mssql : Run systemctl ------------------------- 0.49s /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:22 Ensure ansible_facts to get ansible_distribution ------------------------ 0.47s /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:2 fedora.linux_system_roles.firewall : Run systemctl ---------------------- 0.46s /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:34 fedora.linux_system_roles.firewall : Setup firewalld -------------------- 0.26s /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:2 Run the role ------------------------------------------------------------ 0.24s /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:17 Purge firewall configuration -------------------------------------------- 0.21s /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:24 Purge firewall configuration -------------------------------------------- 0.17s /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:24 Clean up after the role invocation -------------------------------------- 0.16s /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:34 fedora.linux_system_roles.firewall : Set flag if transactional-update exists --- 0.16s /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:27 fedora.linux_system_roles.firewall : Ensure ansible_facts used by role --- 0.12s /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:2 fedora.linux_system_roles.firewall : Set flag to indicate that systemd runtime operations are available --- 0.11s /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:46 fedora.linux_system_roles.firewall : Require installed systemd ---------- 0.11s /tmp/collections-OFW/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:41