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-5Zj 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 '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-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_accept_eula.yml PLAY [all] ********************************************************************* TASK [Include vault variables] ************************************************* task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_accept_eula.yml:5 Thursday 19 June 2025 12:09:06 -0400 (0:00:00.031) 0:00:00.031 ********* 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-RVG/tests/vars/vault-variables.yml" ], "changed": false } PLAY [Ensure that the role runs when EULA are accepted] ************************ TASK [Gathering Facts] ********************************************************* task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_accept_eula.yml:9 Thursday 19 June 2025 12:09:06 -0400 (0:00:00.025) 0:00:00.057 ********* [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-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_accept_eula.yml:25 Thursday 19 June 2025 12:09:09 -0400 (0:00:02.561) 0:00:02.618 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3 Thursday 19 June 2025 12:09:09 -0400 (0:00:00.554) 0:00:03.172 ********* included: /tmp/collections-5Zj/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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 Thursday 19 June 2025 12:09:10 -0400 (0:00:00.036) 0:00:03.208 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8 Thursday 19 June 2025 12:09:10 -0400 (0:00:00.077) 0:00:03.286 ********* 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-5Zj/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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:22 Thursday 19 June 2025 12:09:10 -0400 (0:00:00.073) 0:00:03.359 ********* ok: [managed-node3] => { "changed": false, "cmd": [ "systemctl", "is-system-running" ], "delta": "0:00:00.008230", "end": "2025-06-19 12:09:10.791448", "failed_when_result": false, "rc": 0, "start": "2025-06-19 12:09:10.783218" } STDOUT: running TASK [fedora.linux_system_roles.mssql : Require installed systemd] ************* task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:29 Thursday 19 June 2025 12:09:10 -0400 (0:00:00.677) 0:00:04.037 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:34 Thursday 19 June 2025 12:09:10 -0400 (0:00:00.052) 0:00:04.089 ********* ok: [managed-node3] => { "ansible_facts": { "__mssql_is_booted": true }, "changed": false } TASK [fedora.linux_system_roles.mssql : Unset internal role facts] ************* task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8 Thursday 19 June 2025 12:09:10 -0400 (0:00:00.036) 0:00:04.126 ********* ok: [managed-node3] => { "ansible_facts": { "__mssql_is_active": null, "__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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:16 Thursday 19 June 2025 12:09:10 -0400 (0:00:00.022) 0:00:04.148 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:24 Thursday 19 June 2025 12:09:10 -0400 (0:00:00.024) 0:00:04.173 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:31 Thursday 19 June 2025 12:09:11 -0400 (0:00:00.027) 0:00:04.200 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:38 Thursday 19 June 2025 12:09:11 -0400 (0:00:00.024) 0:00:04.225 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:45 Thursday 19 June 2025 12:09:11 -0400 (0:00:00.025) 0:00:04.250 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:52 Thursday 19 June 2025 12:09:11 -0400 (0:00:00.026) 0:00:04.277 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:59 Thursday 19 June 2025 12:09:11 -0400 (0:00:00.026) 0:00:04.303 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:66 Thursday 19 June 2025 12:09:11 -0400 (0:00:00.023) 0:00:04.327 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:75 Thursday 19 June 2025 12:09:11 -0400 (0:00:00.026) 0:00:04.353 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:84 Thursday 19 June 2025 12:09:11 -0400 (0:00:00.024) 0:00:04.378 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:88 Thursday 19 June 2025 12:09:11 -0400 (0:00:00.026) 0:00:04.405 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:95 Thursday 19 June 2025 12:09:11 -0400 (0:00:00.016) 0:00:04.421 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:107 Thursday 19 June 2025 12:09:11 -0400 (0:00:00.067) 0:00:04.489 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:115 Thursday 19 June 2025 12:09:11 -0400 (0:00:00.039) 0:00:04.529 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:124 Thursday 19 June 2025 12:09:11 -0400 (0:00:00.053) 0:00:04.583 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:133 Thursday 19 June 2025 12:09:11 -0400 (0:00:00.063) 0:00:04.646 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:143 Thursday 19 June 2025 12:09:11 -0400 (0:00:00.055) 0:00:04.701 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:152 Thursday 19 June 2025 12:09:11 -0400 (0:00:00.058) 0:00:04.759 ********* skipping: [managed-node3] => { "changed": false, "false_condition": "not mssql_run_selinux_confined", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify that mssql_ha_ag_is_contained is not provided with version 2017] *** task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:163 Thursday 19 June 2025 12:09:11 -0400 (0:00:00.060) 0:00:04.819 ********* skipping: [managed-node3] => { "changed": false, "false_condition": "mssql_ha_ag_is_contained | bool", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify fail reuse_system_db=true is not provided without ag_is_contained] *** task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:174 Thursday 19 June 2025 12:09:11 -0400 (0:00:00.046) 0:00:04.865 ********* skipping: [managed-node3] => { "changed": false, "false_condition": "mssql_ha_ag_reuse_system_db | bool", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Gather package facts] ****************** task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:185 Thursday 19 June 2025 12:09:11 -0400 (0:00:00.052) 0:00:04.918 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:189 Thursday 19 June 2025 12:09:12 -0400 (0:00:01.280) 0:00:06.198 ********* 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 : Verify if mssql_version is not bigger then the existing SQL Server version] *** task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:197 Thursday 19 June 2025 12:09:13 -0400 (0:00:00.055) 0:00:06.253 ********* skipping: [managed-node3] => { "changed": false, "false_condition": "__mssql_current_version is defined", "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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:210 Thursday 19 June 2025 12:09:13 -0400 (0:00:00.035) 0:00:06.289 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:217 Thursday 19 June 2025 12:09:13 -0400 (0:00:00.032) 0:00:06.322 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:224 Thursday 19 June 2025 12:09:13 -0400 (0:00:00.084) 0:00:06.406 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:238 Thursday 19 June 2025 12:09:13 -0400 (0:00:00.103) 0:00:06.510 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:252 Thursday 19 June 2025 12:09:14 -0400 (0:00:00.843) 0:00:07.354 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:262 Thursday 19 June 2025 12:09:14 -0400 (0:00:00.095) 0:00:07.449 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:273 Thursday 19 June 2025 12:09:14 -0400 (0:00:00.111) 0:00:07.561 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:287 Thursday 19 June 2025 12:09:14 -0400 (0:00:00.065) 0:00:07.626 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:296 Thursday 19 June 2025 12:09:14 -0400 (0:00:00.130) 0:00:07.756 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:308 Thursday 19 June 2025 12:09:14 -0400 (0:00:00.077) 0:00:07.834 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:315 Thursday 19 June 2025 12:09:14 -0400 (0:00:00.048) 0:00:07.883 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:327 Thursday 19 June 2025 12:09:15 -0400 (0:00:00.596) 0:00:08.479 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:340 Thursday 19 June 2025 12:09:15 -0400 (0:00:00.026) 0:00:08.505 ********* changed: [managed-node3] => { "changed": true, "rc": 0, "results": [ "Installed: libbabeltrace-1.5.8-10.el9.x86_64", "Installed: bzip2-1.0.8-10.el9.x86_64", "Installed: policycoreutils-python-utils-3.6-3.el9.noarch", "Installed: cyrus-sasl-2.1.27-21.el9.x86_64", "Installed: libicu-67.1-9.el9.x86_64", "Installed: gdb-headless-14.2-4.1.el9.x86_64", "Installed: cyrus-sasl-gssapi-2.1.27-21.el9.x86_64", "Installed: mssql-server-16.0.4195.2-4.x86_64", "Installed: libipt-2.0.4-3.el9.x86_64", "Installed: source-highlight-3.1.9-12.el9.x86_64", "Installed: mssql-server-selinux-16.0.4195.2-4.x86_64", "Installed: lsof-4.94.0-3.el9.x86_64", "Installed: libatomic-11.5.0-7.el9.x86_64", "Installed: gdb-14.2-4.1.el9.x86_64", "Installed: boost-regex-1.75.0-11.el9.x86_64" ] } TASK [fedora.linux_system_roles.mssql : Ensure the package mssql-server] ******* task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:345 Thursday 19 June 2025 12:11:03 -0400 (0:01:47.999) 0:01:56.505 ********* ok: [managed-node3] => { "changed": false, "rc": 0, "results": [] } MSG: Nothing to do TASK [fedora.linux_system_roles.mssql : Check if the errorlog file exists and its location] *** task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:350 Thursday 19 June 2025 12:11:04 -0400 (0:00:01.336) 0:01:57.841 ********* ok: [managed-node3] => { "changed": false, "cmd": "set -euo pipefail\nerrorlog=\"$(grep '^errorlogfile = ' /var/opt/mssql/mssql.conf \\\n| sed 's/errorlogfile : //')\" || :\nif [ -s \"${errorlog}\" ]; then\n echo \"${errorlog}\"\nelif [ -s /var/opt/mssql/log/errorlog ]; then\n echo /var/opt/mssql/log/errorlog\nelse\n echo \"\"\nfi\n", "delta": "0:00:00.005753", "end": "2025-06-19 12:11:04.932373", "rc": 0, "start": "2025-06-19 12:11:04.926620" } TASK [fedora.linux_system_roles.mssql : Check if mssql-server.service is enabled] *** task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:367 Thursday 19 June 2025 12:11:04 -0400 (0:00:00.350) 0:01:58.191 ********* ok: [managed-node3] => { "changed": false, "cmd": [ "systemctl", "is-enabled", "mssql-server.service" ], "delta": "0:00:00.010944", "end": "2025-06-19 12:11:05.283762", "failed_when_result": false, "rc": 1, "start": "2025-06-19 12:11:05.272818" } STDOUT: disabled MSG: non-zero return code TASK [fedora.linux_system_roles.mssql : Check if mssql-server.service is running] *** task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:374 Thursday 19 June 2025 12:11:05 -0400 (0:00:00.352) 0:01:58.544 ********* ok: [managed-node3] => { "changed": false, "cmd": [ "systemctl", "is-active", "mssql-server.service" ], "delta": "0:00:00.007951", "end": "2025-06-19 12:11:05.631725", "failed_when_result": false, "rc": 3, "start": "2025-06-19 12:11:05.623774" } STDOUT: inactive MSG: non-zero return code TASK [fedora.linux_system_roles.mssql : Set the __mssql_is_setup variable] ***** task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:381 Thursday 19 June 2025 12:11:05 -0400 (0:00:00.346) 0:01:58.890 ********* ok: [managed-node3] => { "ansible_facts": { "__mssql_is_setup": false }, "changed": false } TASK [fedora.linux_system_roles.mssql : Verify that the variables required for setting up MSSQL are defined] *** task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:388 Thursday 19 June 2025 12:11:05 -0400 (0:00:00.052) 0:01:58.942 ********* fatal: [managed-node3]: FAILED! => { "assertion": "mssql_edition is not none", "changed": false, "evaluated_to": false } MSG: ['You must define the following variables to set up MSSQL:', 'mssql_password', 'mssql_edition'] TASK [Assert that the role failed with variables undefined] ******************** task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_accept_eula.yml:34 Thursday 19 June 2025 12:11:05 -0400 (0:00:00.034) 0:01:58.977 ********* ok: [managed-node3] => { "changed": false } MSG: All assertions passed TASK [Clean up after the role invocation] ************************************** task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_accept_eula.yml:40 Thursday 19 June 2025 12:11:05 -0400 (0:00:00.030) 0:01:59.008 ********* included: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml for managed-node3 TASK [Gather package facts] **************************************************** task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:3 Thursday 19 June 2025 12:11:05 -0400 (0:00:00.051) 0:01:59.060 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:7 Thursday 19 June 2025 12:11:06 -0400 (0:00:00.762) 0:01:59.822 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 Thursday 19 June 2025 12:11:06 -0400 (0:00:00.057) 0:01:59.879 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8 Thursday 19 June 2025 12:11:06 -0400 (0:00:00.119) 0:01:59.999 ********* 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-5Zj/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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:22 Thursday 19 June 2025 12:11:06 -0400 (0:00:00.046) 0:02:00.046 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:29 Thursday 19 June 2025 12:11:06 -0400 (0:00:00.028) 0:02:00.074 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:34 Thursday 19 June 2025 12:11:06 -0400 (0:00:00.027) 0:02:00.102 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:13 Thursday 19 June 2025 12:11:06 -0400 (0:00:00.043) 0:02:00.145 ********* 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-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:21 Thursday 19 June 2025 12:11:06 -0400 (0:00:00.032) 0:02:00.177 ********* ok: [managed-node3] => { "ansible_python_version": "3.9.21" } TASK [Purge firewall configuration] ******************************************** task path: /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:25 Thursday 19 June 2025 12:11:07 -0400 (0:00:00.029) 0:02:00.206 ********* ERROR! the role 'fedora.linux_system_roles.firewall' was not found in fedora.linux_system_roles:ansible.legacy:/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/roles:/root/.ansible/roles:/usr/share/ansible/roles:/etc/ansible/roles:/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql The error appears to be in '/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml': line 30, column 11, but may be elsewhere in the file depending on the exact syntax problem. The offending line appears to be: include_role: name: fedora.linux_system_roles.firewall ^ here fatal: [managed-node3]: FAILED! => { "changed": false, "reason": "the role 'fedora.linux_system_roles.firewall' was not found in fedora.linux_system_roles:ansible.legacy:/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/roles:/root/.ansible/roles:/usr/share/ansible/roles:/etc/ansible/roles:/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql\n\nThe error appears to be in '/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml': line 30, column 11, but may\nbe elsewhere in the file depending on the exact syntax problem.\n\nThe offending line appears to be:\n\n include_role:\n name: fedora.linux_system_roles.firewall\n ^ here\n" } PLAY RECAP ********************************************************************* managed-node3 : ok=25 changed=3 unreachable=0 failed=1 skipped=37 rescued=1 ignored=0 SYSTEM ROLES ERRORS BEGIN v1 [ { "ansible_version": "2.17.12", "end_time": "2025-06-19T16:11:05.762539+00:00Z", "host": "managed-node3", "message": [ "You must define the following variables to set up MSSQL:", "mssql_password", "mssql_edition" ], "start_time": "2025-06-19T16:11:05.745481+00:00Z", "task_name": "Verify that the variables required for setting up MSSQL are defined", "task_path": "/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:388" }, { "ansible_version": "2.17.12", "end_time": "2025-06-19T16:11:07.050001+00:00Z", "host": "managed-node3", "message": "No message could be found", "start_time": "2025-06-19T16:11:07.008792+00:00Z", "task_name": "Purge firewall configuration", "task_path": "/tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:25" } ] SYSTEM ROLES ERRORS END v1 TASKS RECAP ******************************************************************** Thursday 19 June 2025 12:11:07 -0400 (0:00:00.042) 0:02:00.249 ********* =============================================================================== fedora.linux_system_roles.mssql : Configure to run as a confined application with SELinux - 108.00s /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:340 Gathering Facts --------------------------------------------------------- 2.56s /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_accept_eula.yml:9 fedora.linux_system_roles.mssql : Ensure the package mssql-server ------- 1.34s /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:345 fedora.linux_system_roles.mssql : Gather package facts ------------------ 1.28s /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:185 fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories --- 0.84s /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:238 Gather package facts ---------------------------------------------------- 0.76s /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:3 fedora.linux_system_roles.mssql : Run systemctl ------------------------- 0.68s /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:22 fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server repo version 2022 --- 0.60s /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:315 Run the role with default parameters ------------------------------------ 0.55s /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_accept_eula.yml:25 fedora.linux_system_roles.mssql : Check if mssql-server.service is enabled --- 0.35s /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:367 fedora.linux_system_roles.mssql : Check if the errorlog file exists and its location --- 0.35s /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:350 fedora.linux_system_roles.mssql : Check if mssql-server.service is running --- 0.35s /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:374 fedora.linux_system_roles.mssql : Update all packages from SQL Server repo version {{ __mssql_current_version }} --- 0.13s /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:287 fedora.linux_system_roles.mssql : Ensure ansible_facts used by role ----- 0.12s /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 fedora.linux_system_roles.mssql : Get yum repositories ------------------ 0.11s /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:262 fedora.linux_system_roles.mssql : Verify if mssql_version is not smaller then the existing SQL Server version --- 0.10s /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:224 fedora.linux_system_roles.mssql : Update all packages from SQL Server repo version {{ __mssql_current_version }} --- 0.10s /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:252 fedora.linux_system_roles.mssql : Verify if the mssql_version variable is provided correctly --- 0.08s /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:217 fedora.linux_system_roles.mssql : Ensure ansible_facts used by role ----- 0.08s /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 fedora.linux_system_roles.mssql : Get zypper repositories --------------- 0.08s /tmp/collections-5Zj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:296