ansible-playbook [core 2.16.14] 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-3u7 executable location = /usr/local/bin/ansible-playbook python version = 3.12.1 (main, Feb 21 2024, 14:18:26) [GCC 8.5.0 20210514 (Red Hat 8.5.0-21)] (/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_idempotency_2019.yml ******************************************* 1 plays in /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_idempotency_2019.yml PLAY [Ensure that the role is idempotent] ************************************** TASK [Run tests_idempotency with SQL Server 2019] ****************************** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_idempotency_2019.yml:15 Wednesday 06 August 2025 10:42:20 -0400 (0:00:00.049) 0:00:00.049 ****** included: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_idempotency.yml for managed-node1 TASK [Assert fail on EL 7 with version = 2022 and EL 9 with version != 2022] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_idempotency.yml:2 Wednesday 06 August 2025 10:42:20 -0400 (0:00:00.019) 0:00:00.069 ****** included: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml for managed-node1 TASK [Ensure ansible_facts to get ansible_distribution] ************************ task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:2 Wednesday 06 August 2025 10:42:20 -0400 (0:00:00.016) 0:00:00.085 ****** ok: [managed-node1] TASK [Run the role] ************************************************************ task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:16 Wednesday 06 August 2025 10:42:20 -0400 (0:00:00.775) 0:00:00.861 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "(ansible_distribution in ['CentOS', 'RedHat'] and ansible_distribution_major_version is version('7', '=') and mssql_version | int == 2022) or (((ansible_distribution in ['CentOS', 'RedHat'] and ansible_distribution_major_version is version('9', '=')) or (ansible_distribution in ['Fedora'])) and mssql_version | int != 2022)", "skip_reason": "Conditional result was False" } TASK [Unreachable task] ******************************************************** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:23 Wednesday 06 August 2025 10:42:20 -0400 (0:00:00.055) 0:00:00.917 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "(ansible_distribution in ['CentOS', 'RedHat'] and ansible_distribution_major_version is version('7', '=') and mssql_version | int == 2022) or (((ansible_distribution in ['CentOS', 'RedHat'] and ansible_distribution_major_version is version('9', '=')) or (ansible_distribution in ['Fedora'])) and mssql_version | int != 2022)", "skip_reason": "Conditional result was False" } TASK [Run on a fresh host and set all parameters] ****************************** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_idempotency.yml:5 Wednesday 06 August 2025 10:42:20 -0400 (0:00:00.057) 0:00:00.974 ****** TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3 Wednesday 06 August 2025 10:42:21 -0400 (0:00:00.223) 0:00:01.198 ****** included: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml for managed-node1 TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts used by role] ***** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 Wednesday 06 August 2025 10:42:21 -0400 (0:00:00.017) 0:00:01.215 ****** skipping: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8 Wednesday 06 August 2025 10:42:21 -0400 (0:00:00.032) 0:00:01.247 ****** ok: [managed-node1] => (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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } skipping: [managed-node1] => (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" } ok: [managed-node1] => (item=CentOS_8.yml) => { "ansible_facts": { "__mssql_client_repository": "https://packages.microsoft.com/rhel/8/prod/", "__mssql_confined_supported": false, "__mssql_server_repository": "https://packages.microsoft.com/rhel/8/mssql-server-{{ mssql_version | int }}/", "__mssql_supported_versions": [ 2017, 2019, 2022 ] }, "ansible_included_var_files": [ "/tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/CentOS_8.yml" ], "ansible_loop_var": "item", "changed": false, "item": "CentOS_8.yml" } ok: [managed-node1] => (item=CentOS_8.yml) => { "ansible_facts": { "__mssql_client_repository": "https://packages.microsoft.com/rhel/8/prod/", "__mssql_confined_supported": false, "__mssql_server_repository": "https://packages.microsoft.com/rhel/8/mssql-server-{{ mssql_version | int }}/", "__mssql_supported_versions": [ 2017, 2019, 2022 ] }, "ansible_included_var_files": [ "/tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/CentOS_8.yml" ], "ansible_loop_var": "item", "changed": false, "item": "CentOS_8.yml" } TASK [fedora.linux_system_roles.mssql : Run systemctl] ************************* task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:22 Wednesday 06 August 2025 10:42:21 -0400 (0:00:00.039) 0:00:01.287 ****** ok: [managed-node1] => { "changed": false, "cmd": [ "systemctl", "is-system-running" ], "delta": "0:00:01.008476", "end": "2025-08-06 10:42:22.645298", "failed_when_result": false, "rc": 0, "start": "2025-08-06 10:42:21.636822" } STDOUT: running TASK [fedora.linux_system_roles.mssql : Require installed systemd] ************* task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:29 Wednesday 06 August 2025 10:42:22 -0400 (0:00:01.428) 0:00:02.716 ****** skipping: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:34 Wednesday 06 August 2025 10:42:22 -0400 (0:00:00.041) 0:00:02.757 ****** ok: [managed-node1] => { "ansible_facts": { "__mssql_is_booted": true }, "changed": false } TASK [fedora.linux_system_roles.mssql : Unset internal role facts] ************* task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8 Wednesday 06 August 2025 10:42:22 -0400 (0:00:00.023) 0:00:02.781 ****** ok: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:16 Wednesday 06 August 2025 10:42:22 -0400 (0:00:00.014) 0:00:02.796 ****** skipping: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:24 Wednesday 06 August 2025 10:42:22 -0400 (0:00:00.019) 0:00:02.815 ****** skipping: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:31 Wednesday 06 August 2025 10:42:22 -0400 (0:00:00.019) 0:00:02.834 ****** skipping: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:38 Wednesday 06 August 2025 10:42:22 -0400 (0:00:00.019) 0:00:02.854 ****** skipping: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:45 Wednesday 06 August 2025 10:42:22 -0400 (0:00:00.016) 0:00:02.870 ****** skipping: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:52 Wednesday 06 August 2025 10:42:22 -0400 (0:00:00.016) 0:00:02.887 ****** skipping: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:59 Wednesday 06 August 2025 10:42:22 -0400 (0:00:00.015) 0:00:02.903 ****** skipping: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:66 Wednesday 06 August 2025 10:42:22 -0400 (0:00:00.015) 0:00:02.918 ****** skipping: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:75 Wednesday 06 August 2025 10:42:22 -0400 (0:00:00.015) 0:00:02.934 ****** skipping: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:84 Wednesday 06 August 2025 10:42:22 -0400 (0:00:00.016) 0:00:02.950 ****** skipping: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:88 Wednesday 06 August 2025 10:42:22 -0400 (0:00:00.015) 0:00:02.966 ****** skipping: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:95 Wednesday 06 August 2025 10:42:22 -0400 (0:00:00.016) 0:00:02.982 ****** ok: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:107 Wednesday 06 August 2025 10:42:22 -0400 (0:00:00.035) 0:00:03.018 ****** skipping: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:115 Wednesday 06 August 2025 10:42:23 -0400 (0:00:00.033) 0:00:03.052 ****** skipping: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:124 Wednesday 06 August 2025 10:42:23 -0400 (0:00:00.043) 0:00:03.096 ****** skipping: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:133 Wednesday 06 August 2025 10:42:23 -0400 (0:00:00.039) 0:00:03.136 ****** skipping: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:143 Wednesday 06 August 2025 10:42:23 -0400 (0:00:00.037) 0:00:03.173 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "(mssql_manage_selinux | bool) or (mssql_run_selinux_confined | bool)", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify that mssql_manage_selinux is set properly] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:152 Wednesday 06 August 2025 10:42:23 -0400 (0:00:00.035) 0:00:03.209 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "mssql_manage_selinux | bool", "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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:163 Wednesday 06 August 2025 10:42:23 -0400 (0:00:00.036) 0:00:03.246 ****** skipping: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:174 Wednesday 06 August 2025 10:42:23 -0400 (0:00:00.031) 0:00:03.277 ****** skipping: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:185 Wednesday 06 August 2025 10:42:23 -0400 (0:00:00.032) 0:00:03.309 ****** ok: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:189 Wednesday 06 August 2025 10:42:24 -0400 (0:00:01.688) 0:00:04.997 ****** skipping: [managed-node1] => (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-node1] => (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-node1] => (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-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:197 Wednesday 06 August 2025 10:42:25 -0400 (0:00:00.049) 0:00:05.047 ****** skipping: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:210 Wednesday 06 August 2025 10:42:25 -0400 (0:00:00.034) 0:00:05.081 ****** skipping: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:217 Wednesday 06 August 2025 10:42:25 -0400 (0:00:00.045) 0:00:05.127 ****** ok: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:224 Wednesday 06 August 2025 10:42:25 -0400 (0:00:00.071) 0:00:05.198 ****** skipping: [managed-node1] => (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-node1] => (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-node1] => (item={'key': 2022, 'value': 16}) => { "ansible_loop_var": "item", "changed": false, "false_condition": "mssql_version | int == item.key", "item": { "key": 2022, "value": 16 }, "skip_reason": "Conditional result was False" } skipping: [managed-node1] => { "changed": false } MSG: All items skipped TASK [fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:238 Wednesday 06 August 2025 10:42:25 -0400 (0:00:00.071) 0:00:05.269 ****** ok: [managed-node1] => { "attempts": 1, "changed": false } TASK [fedora.linux_system_roles.mssql : Update all packages from SQL Server repo version {{ __mssql_current_version }}] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:252 Wednesday 06 August 2025 10:42:25 -0400 (0:00:00.696) 0:00:05.965 ****** skipping: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:262 Wednesday 06 August 2025 10:42:25 -0400 (0:00:00.037) 0:00:06.003 ****** skipping: [managed-node1] => { "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 2019] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:273 Wednesday 06 August 2025 10:42:26 -0400 (0:00:00.036) 0:00:06.039 ****** skipping: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:287 Wednesday 06 August 2025 10:42:26 -0400 (0:00:00.033) 0:00:06.073 ****** skipping: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:296 Wednesday 06 August 2025 10:42:26 -0400 (0:00:00.064) 0:00:06.137 ****** skipping: [managed-node1] => { "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 2019] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:308 Wednesday 06 August 2025 10:42:26 -0400 (0:00:00.049) 0:00:06.186 ****** skipping: [managed-node1] => { "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 2019] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:315 Wednesday 06 August 2025 10:42:26 -0400 (0:00:00.038) 0:00:06.225 ****** changed: [managed-node1] => { "changed": true, "repo": "packages-microsoft-com-mssql-server-2019", "state": "present" } TASK [fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server repo version 2019] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:327 Wednesday 06 August 2025 10:42:26 -0400 (0:00:00.554) 0:00:06.779 ****** skipping: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:340 Wednesday 06 August 2025 10:42:26 -0400 (0:00:00.042) 0:00:06.821 ****** ok: [managed-node1] => { "changed": false, "rc": 0, "results": [] } MSG: Nothing to do TASK [fedora.linux_system_roles.mssql : Ensure the package mssql-server] ******* task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:345 Wednesday 06 August 2025 10:42:30 -0400 (0:00:03.416) 0:00:10.238 ****** changed: [managed-node1] => { "changed": true, "rc": 0, "results": [ "Installed: gcc-gdb-plugin-8.5.0-22.el8.x86_64", "Installed: gdb-headless-8.2-20.el8.x86_64", "Installed: libatomic_ops-7.6.2-3.el8.x86_64", "Installed: gc-7.6.4-3.el8.x86_64", "Installed: cyrus-sasl-2.1.27-6.el8_5.x86_64", "Installed: gdb-8.2-20.el8.x86_64", "Installed: libatomic-8.5.0-22.el8.x86_64", "Installed: libipt-1.6.1-8.el8.x86_64", "Installed: libbabeltrace-1.5.4-4.el8.x86_64", "Installed: libtool-ltdl-2.4.6-25.el8.x86_64", "Installed: bzip2-1.0.6-26.el8.x86_64", "Installed: mssql-server-15.0.4435.7-2.x86_64", "Installed: lsof-4.93.2-1.el8.x86_64", "Installed: cyrus-sasl-gssapi-2.1.27-6.el8_5.x86_64", "Installed: guile-5:2.0.14-7.el8.x86_64" ] } TASK [fedora.linux_system_roles.mssql : Check if the errorlog file exists and its location] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:350 Wednesday 06 August 2025 10:43:14 -0400 (0:00:44.620) 0:00:54.858 ****** ok: [managed-node1] => { "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.004894", "end": "2025-08-06 10:43:15.146577", "rc": 0, "start": "2025-08-06 10:43:15.141683" } TASK [fedora.linux_system_roles.mssql : Check if mssql-server.service is enabled] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:367 Wednesday 06 August 2025 10:43:15 -0400 (0:00:00.405) 0:00:55.263 ****** ok: [managed-node1] => { "changed": false, "cmd": [ "systemctl", "is-enabled", "mssql-server.service" ], "delta": "0:00:00.010540", "end": "2025-08-06 10:43:15.544824", "failed_when_result": false, "rc": 1, "start": "2025-08-06 10:43:15.534284" } STDOUT: disabled MSG: non-zero return code TASK [fedora.linux_system_roles.mssql : Check if mssql-server.service is running] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:374 Wednesday 06 August 2025 10:43:15 -0400 (0:00:00.366) 0:00:55.630 ****** ok: [managed-node1] => { "changed": false, "cmd": [ "systemctl", "is-active", "mssql-server.service" ], "delta": "0:00:00.008162", "end": "2025-08-06 10:43:15.930394", "failed_when_result": false, "rc": 3, "start": "2025-08-06 10:43:15.922232" } STDOUT: inactive MSG: non-zero return code TASK [fedora.linux_system_roles.mssql : Set the __mssql_is_setup variable] ***** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:381 Wednesday 06 August 2025 10:43:15 -0400 (0:00:00.381) 0:00:56.012 ****** ok: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:388 Wednesday 06 August 2025 10:43:16 -0400 (0:00:00.052) 0:00:56.064 ****** ok: [managed-node1] => { "changed": false } MSG: All assertions passed TASK [fedora.linux_system_roles.mssql : Set up MSSQL] ************************** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:404 Wednesday 06 August 2025 10:43:16 -0400 (0:00:00.050) 0:00:56.114 ****** changed: [managed-node1] => { "attempts": 1, "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": true } TASK [fedora.linux_system_roles.mssql : Ensure the directory and permissions for datadir and logdir] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:430 Wednesday 06 August 2025 10:43:21 -0400 (0:00:05.076) 0:01:01.190 ****** included: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/configure_storage_paths.yml for managed-node1 => (item={'path': '/tmp/mssql_data', 'mode': '755', 'setting': 'defaultdatadir'}) included: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/configure_storage_paths.yml for managed-node1 => (item={'path': '/tmp/mssql_log', 'mode': '755', 'setting': 'defaultlogdir'}) TASK [fedora.linux_system_roles.mssql : Ensure the directory and permissions /tmp/mssql_data] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/configure_storage_paths.yml:3 Wednesday 06 August 2025 10:43:21 -0400 (0:00:00.103) 0:01:01.293 ****** changed: [managed-node1] => { "changed": true, "gid": 989, "group": "mssql", "mode": "0755", "owner": "mssql", "path": "/tmp/mssql_data", "secontext": "unconfined_u:object_r:user_tmp_t:s0", "size": 6, "state": "directory", "uid": 993 } TASK [fedora.linux_system_roles.mssql : Append facts for the selinux role] ***** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/configure_storage_paths.yml:12 Wednesday 06 August 2025 10:43:21 -0400 (0:00:00.565) 0:01:01.859 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "mssql_manage_selinux | bool", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Configure the setting defaultdatadir] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/configure_storage_paths.yml:28 Wednesday 06 August 2025 10:43:21 -0400 (0:00:00.051) 0:01:01.911 ****** included: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml for managed-node1 TASK [fedora.linux_system_roles.mssql : Get the setting filelocation defaultdatadir] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:3 Wednesday 06 August 2025 10:43:21 -0400 (0:00:00.075) 0:01:01.987 ****** ok: [managed-node1] => { "changed": false, "cmd": [ "grep", "^defaultdatadir = ", "/var/opt/mssql/mssql.conf" ], "delta": "0:00:00.004083", "end": "2025-08-06 10:43:22.357379", "failed_when_result": false, "rc": 1, "start": "2025-08-06 10:43:22.353296" } MSG: non-zero return code TASK [fedora.linux_system_roles.mssql : Configure the setting filelocation defaultdatadir] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:12 Wednesday 06 August 2025 10:43:22 -0400 (0:00:00.463) 0:01:02.451 ****** Notification for handler Restart the mssql-server service has been saved. changed: [managed-node1] => { "changed": true, "cmd": [ "/opt/mssql/bin/mssql-conf", "set", "filelocation.defaultdatadir", "/tmp/mssql_data" ], "delta": "0:00:00.105142", "end": "2025-08-06 10:43:22.884249", "failed_when_result": false, "rc": 0, "start": "2025-08-06 10:43:22.779107" } STDOUT: SQL Server needs to be restarted in order to apply this setting. Please run 'systemctl restart mssql-server.service'. TASK [fedora.linux_system_roles.mssql : Unset the setting filelocation defaultdatadir] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:42 Wednesday 06 August 2025 10:43:22 -0400 (0:00:00.524) 0:01:02.975 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "__mssql_conf_setting_value == \"unset\"", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Ensure the directory and permissions /tmp/mssql_log] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/configure_storage_paths.yml:3 Wednesday 06 August 2025 10:43:22 -0400 (0:00:00.027) 0:01:03.002 ****** changed: [managed-node1] => { "changed": true, "gid": 989, "group": "mssql", "mode": "0755", "owner": "mssql", "path": "/tmp/mssql_log", "secontext": "unconfined_u:object_r:user_tmp_t:s0", "size": 6, "state": "directory", "uid": 993 } TASK [fedora.linux_system_roles.mssql : Append facts for the selinux role] ***** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/configure_storage_paths.yml:12 Wednesday 06 August 2025 10:43:23 -0400 (0:00:00.632) 0:01:03.635 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "mssql_manage_selinux | bool", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Configure the setting defaultlogdir] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/configure_storage_paths.yml:28 Wednesday 06 August 2025 10:43:23 -0400 (0:00:00.077) 0:01:03.713 ****** included: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml for managed-node1 TASK [fedora.linux_system_roles.mssql : Get the setting filelocation defaultlogdir] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:3 Wednesday 06 August 2025 10:43:23 -0400 (0:00:00.139) 0:01:03.852 ****** ok: [managed-node1] => { "changed": false, "cmd": [ "grep", "^defaultlogdir = ", "/var/opt/mssql/mssql.conf" ], "delta": "0:00:00.002863", "end": "2025-08-06 10:43:24.261965", "failed_when_result": false, "rc": 1, "start": "2025-08-06 10:43:24.259102" } MSG: non-zero return code TASK [fedora.linux_system_roles.mssql : Configure the setting filelocation defaultlogdir] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:12 Wednesday 06 August 2025 10:43:24 -0400 (0:00:00.539) 0:01:04.392 ****** Notification for handler Restart the mssql-server service has been saved. changed: [managed-node1] => { "changed": true, "cmd": [ "/opt/mssql/bin/mssql-conf", "set", "filelocation.defaultlogdir", "/tmp/mssql_log" ], "delta": "0:00:00.102208", "end": "2025-08-06 10:43:24.830957", "failed_when_result": false, "rc": 0, "start": "2025-08-06 10:43:24.728749" } STDOUT: SQL Server needs to be restarted in order to apply this setting. Please run 'systemctl restart mssql-server.service'. TASK [fedora.linux_system_roles.mssql : Unset the setting filelocation defaultlogdir] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:42 Wednesday 06 August 2025 10:43:24 -0400 (0:00:00.548) 0:01:04.940 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "__mssql_conf_setting_value == \"unset\"", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Set selinux role facts for ports] ****** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:445 Wednesday 06 August 2025 10:43:24 -0400 (0:00:00.048) 0:01:04.989 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "mssql_manage_selinux | bool", "skip_reason": "Conditional result was False" } TASK [Ensure correct SELinux context for storage paths and ports] ************** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:459 Wednesday 06 August 2025 10:43:25 -0400 (0:00:00.069) 0:01:05.058 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "mssql_manage_selinux | bool", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Ensure that the tuned-profiles-mssql package is installed] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:470 Wednesday 06 August 2025 10:43:25 -0400 (0:00:00.077) 0:01:05.136 ****** ok: [managed-node1] => { "changed": false, "rc": 0, "results": [] } MSG: Nothing to do TASK [fedora.linux_system_roles.mssql : Ensure that the tuned service is started and enabled] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:476 Wednesday 06 August 2025 10:43:28 -0400 (0:00:03.002) 0:01:08.139 ****** ok: [managed-node1] => { "changed": false, "enabled": true, "name": "tuned", "state": "started", "status": { "ActiveEnterTimestamp": "Wed 2025-08-06 10:28:50 EDT", "ActiveEnterTimestampMonotonic": "13197109", "ActiveExitTimestampMonotonic": "0", "ActiveState": "active", "After": "basic.target system.slice dbus.socket sysinit.target systemd-sysctl.service network.target polkit.service systemd-journald.socket dbus.service", "AllowIsolate": "no", "AllowedCPUs": "", "AllowedMemoryNodes": "", "AmbientCapabilities": "", "AssertResult": "yes", "AssertTimestamp": "Wed 2025-08-06 10:28:49 EDT", "AssertTimestampMonotonic": "12600314", "Before": "shutdown.target multi-user.target", "BlockIOAccounting": "no", "BlockIOWeight": "[not set]", "BusName": "com.redhat.tuned", "CPUAccounting": "no", "CPUAffinity": "", "CPUAffinityFromNUMA": "no", "CPUQuotaPerSecUSec": "infinity", "CPUQuotaPeriodUSec": "infinity", "CPUSchedulingPolicy": "0", "CPUSchedulingPriority": "0", "CPUSchedulingResetOnFork": "no", "CPUShares": "[not set]", "CPUUsageNSec": "[not set]", "CPUWeight": "[not set]", "CacheDirectoryMode": "0755", "CanFreeze": "yes", "CanIsolate": "no", "CanReload": "no", "CanStart": "yes", "CanStop": "yes", "CapabilityBoundingSet": "cap_chown cap_dac_override cap_dac_read_search cap_fowner cap_fsetid cap_kill cap_setgid cap_setuid cap_setpcap cap_linux_immutable cap_net_bind_service cap_net_broadcast cap_net_admin cap_net_raw cap_ipc_lock cap_ipc_owner cap_sys_module cap_sys_rawio cap_sys_chroot cap_sys_ptrace cap_sys_pacct cap_sys_admin cap_sys_boot cap_sys_nice cap_sys_resource cap_sys_time cap_sys_tty_config cap_mknod cap_lease cap_audit_write cap_audit_control cap_setfcap cap_mac_override cap_mac_admin cap_syslog cap_wake_alarm cap_block_suspend cap_audit_read cap_perfmon cap_bpf", "CollectMode": "inactive", "ConditionResult": "yes", "ConditionTimestamp": "Wed 2025-08-06 10:28:49 EDT", "ConditionTimestampMonotonic": "12600313", "ConfigurationDirectoryMode": "0755", "Conflicts": "auto-cpufreq.service cpupower.service shutdown.target tlp.service power-profiles-daemon.service", "ControlGroup": "/system.slice/tuned.service", "ControlPID": "0", "DefaultDependencies": "yes", "DefaultMemoryLow": "0", "DefaultMemoryMin": "0", "Delegate": "no", "Description": "Dynamic System Tuning Daemon", "DevicePolicy": "auto", "Documentation": "man:tuned(8) man:tuned.conf(5) man:tuned-adm(8)", "DynamicUser": "no", "EffectiveCPUs": "", "EffectiveMemoryNodes": "", "ExecMainCode": "0", "ExecMainExitTimestampMonotonic": "0", "ExecMainPID": "692", "ExecMainStartTimestamp": "Wed 2025-08-06 10:28:49 EDT", "ExecMainStartTimestampMonotonic": "12601087", "ExecMainStatus": "0", "ExecStart": "{ path=/usr/sbin/tuned ; argv[]=/usr/sbin/tuned -l -P ; ignore_errors=no ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }", "FailureAction": "none", "FileDescriptorStoreMax": "0", "FragmentPath": "/usr/lib/systemd/system/tuned.service", "FreezerState": "running", "GID": "[not set]", "GuessMainPID": "yes", "IOAccounting": "no", "IOSchedulingClass": "0", "IOSchedulingPriority": "0", "IOWeight": "[not set]", "IPAccounting": "no", "IPEgressBytes": "18446744073709551615", "IPEgressPackets": "18446744073709551615", "IPIngressBytes": "18446744073709551615", "IPIngressPackets": "18446744073709551615", "Id": "tuned.service", "IgnoreOnIsolate": "no", "IgnoreSIGPIPE": "yes", "InactiveEnterTimestampMonotonic": "0", "InactiveExitTimestamp": "Wed 2025-08-06 10:28:49 EDT", "InactiveExitTimestampMonotonic": "12601137", "InvocationID": "2676b4066247477988e4bf2d9fe62bf4", "JobRunningTimeoutUSec": "infinity", "JobTimeoutAction": "none", "JobTimeoutUSec": "infinity", "KeyringMode": "private", "KillMode": "control-group", "KillSignal": "15", "LimitAS": "infinity", "LimitASSoft": "infinity", "LimitCORE": "infinity", "LimitCORESoft": "0", "LimitCPU": "infinity", "LimitCPUSoft": "infinity", "LimitDATA": "infinity", "LimitDATASoft": "infinity", "LimitFSIZE": "infinity", "LimitFSIZESoft": "infinity", "LimitLOCKS": "infinity", "LimitLOCKSSoft": "infinity", "LimitMEMLOCK": "65536", "LimitMEMLOCKSoft": "65536", "LimitMSGQUEUE": "819200", "LimitMSGQUEUESoft": "819200", "LimitNICE": "0", "LimitNICESoft": "0", "LimitNOFILE": "262144", "LimitNOFILESoft": "1024", "LimitNPROC": "28608", "LimitNPROCSoft": "28608", "LimitRSS": "infinity", "LimitRSSSoft": "infinity", "LimitRTPRIO": "0", "LimitRTPRIOSoft": "0", "LimitRTTIME": "infinity", "LimitRTTIMESoft": "infinity", "LimitSIGPENDING": "28608", "LimitSIGPENDINGSoft": "28608", "LimitSTACK": "infinity", "LimitSTACKSoft": "8388608", "LoadState": "loaded", "LockPersonality": "no", "LogLevelMax": "-1", "LogRateLimitBurst": "0", "LogRateLimitIntervalUSec": "0", "LogsDirectoryMode": "0755", "MainPID": "692", "MemoryAccounting": "yes", "MemoryCurrent": "19292160", "MemoryDenyWriteExecute": "no", "MemoryHigh": "infinity", "MemoryLimit": "infinity", "MemoryLow": "0", "MemoryMax": "infinity", "MemoryMin": "0", "MemorySwapMax": "infinity", "MountAPIVFS": "no", "MountFlags": "", "NFileDescriptorStore": "0", "NRestarts": "0", "NUMAMask": "", "NUMAPolicy": "n/a", "Names": "tuned.service", "NeedDaemonReload": "no", "Nice": "0", "NoNewPrivileges": "no", "NonBlocking": "no", "NotifyAccess": "none", "OOMScoreAdjust": "0", "OnFailureJobMode": "replace", "PIDFile": "/run/tuned/tuned.pid", "PermissionsStartOnly": "no", "Perpetual": "no", "PrivateDevices": "no", "PrivateMounts": "no", "PrivateNetwork": "no", "PrivateTmp": "no", "PrivateUsers": "no", "ProtectControlGroups": "no", "ProtectHome": "no", "ProtectKernelModules": "no", "ProtectKernelTunables": "no", "ProtectSystem": "no", "RefuseManualStart": "no", "RefuseManualStop": "no", "RemainAfterExit": "no", "RemoveIPC": "no", "Requires": "dbus.service sysinit.target dbus.socket system.slice", "Restart": "no", "RestartUSec": "100ms", "RestrictNamespaces": "no", "RestrictRealtime": "no", "RestrictSUIDSGID": "no", "Result": "success", "RootDirectoryStartOnly": "no", "RuntimeDirectoryMode": "0755", "RuntimeDirectoryPreserve": "no", "RuntimeMaxUSec": "infinity", "SameProcessGroup": "no", "SecureBits": "0", "SendSIGHUP": "no", "SendSIGKILL": "yes", "Slice": "system.slice", "StandardError": "inherit", "StandardInput": "null", "StandardInputData": "", "StandardOutput": "journal", "StartLimitAction": "none", "StartLimitBurst": "5", "StartLimitIntervalUSec": "10s", "StartupBlockIOWeight": "[not set]", "StartupCPUShares": "[not set]", "StartupCPUWeight": "[not set]", "StartupIOWeight": "[not set]", "StateChangeTimestamp": "Wed 2025-08-06 10:28:50 EDT", "StateChangeTimestampMonotonic": "13197109", "StateDirectoryMode": "0755", "StatusErrno": "0", "StopWhenUnneeded": "no", "SubState": "running", "SuccessAction": "none", "SyslogFacility": "3", "SyslogLevel": "6", "SyslogLevelPrefix": "yes", "SyslogPriority": "30", "SystemCallErrorNumber": "0", "TTYReset": "no", "TTYVHangup": "no", "TTYVTDisallocate": "no", "TasksAccounting": "yes", "TasksCurrent": "4", "TasksMax": "45773", "TimeoutStartUSec": "1min 30s", "TimeoutStopUSec": "1min 30s", "TimerSlackNSec": "50000", "Transient": "no", "Type": "dbus", "UID": "[not set]", "UMask": "0022", "UnitFilePreset": "enabled", "UnitFileState": "enabled", "UtmpMode": "init", "WantedBy": "multi-user.target", "WatchdogTimestamp": "Wed 2025-08-06 10:28:50 EDT", "WatchdogTimestampMonotonic": "13197106", "WatchdogUSec": "0" } } TASK [fedora.linux_system_roles.mssql : Get the active Tuned profiles] ********* task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:483 Wednesday 06 August 2025 10:43:29 -0400 (0:00:01.771) 0:01:09.910 ****** ok: [managed-node1] => { "changed": false, "content": "dmlydHVhbC1ndWVzdCBtc3NxbAo=", "encoding": "base64", "source": "/etc/tuned/active_profile" } TASK [fedora.linux_system_roles.mssql : Decode the active Tuned profiles] ****** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:489 Wednesday 06 August 2025 10:43:30 -0400 (0:00:00.452) 0:01:10.363 ****** ok: [managed-node1] => { "ansible_facts": { "__mssql_tuned_active_profiles": "virtual-guest mssql" }, "changed": false } TASK [fedora.linux_system_roles.mssql : Attempt to add mssql to the list of Tuned profiles] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:502 Wednesday 06 August 2025 10:43:30 -0400 (0:00:00.053) 0:01:10.416 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "\"mssql\" not in __mssql_tuned_active_profiles", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Remove troublemaking include from the mssql profile] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:514 Wednesday 06 August 2025 10:43:30 -0400 (0:00:00.045) 0:01:10.462 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "\"mssql\" not in __mssql_tuned_active_profiles", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Add the fixed mssql profile to the list of Tuned profiles] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:523 Wednesday 06 August 2025 10:43:30 -0400 (0:00:00.046) 0:01:10.508 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "\"mssql\" not in __mssql_tuned_active_profiles", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Attempt to add mssql to the list of Tuned profiles] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:540 Wednesday 06 August 2025 10:43:30 -0400 (0:00:00.046) 0:01:10.555 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "not __mssql_is_booted | bool", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server Tools repository] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:548 Wednesday 06 August 2025 10:43:30 -0400 (0:00:00.045) 0:01:10.601 ****** changed: [managed-node1] => { "changed": true, "repo": "packages-microsoft-com-prod", "state": "present" } TASK [fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server Tools repository] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:556 Wednesday 06 August 2025 10:43:30 -0400 (0:00:00.347) 0:01:10.949 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "ansible_pkg_mgr == \"zypper\"", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Ensure that SQL Server client tools are installed] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:565 Wednesday 06 August 2025 10:43:30 -0400 (0:00:00.026) 0:01:10.976 ****** changed: [managed-node1] => { "changed": true, "rc": 0, "results": [ "Installed: unixODBC-devel-2.3.11-1.rh.x86_64", "Installed: mssql-tools18-18.4.1.1-1.x86_64", "Installed: unixODBC-2.3.11-1.rh.x86_64", "Installed: msodbcsql18-18.5.1.1-1.x86_64" ] } TASK [fedora.linux_system_roles.mssql : Reset certificate_requests] ************ task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:582 Wednesday 06 August 2025 10:43:35 -0400 (0:00:04.963) 0:01:15.939 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "mssql_tls_enable is not none", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Set certificate_requests] ************** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:586 Wednesday 06 August 2025 10:43:35 -0400 (0:00:00.051) 0:01:15.990 ****** skipping: [managed-node1] => { "changed": false, "skipped_reason": "No items in the list" } TASK [Create certificates using the certificate role] ************************** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:597 Wednesday 06 August 2025 10:43:36 -0400 (0:00:00.043) 0:01:16.034 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "mssql_tls_enable is not none", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Set mssql_tls_cert and _private_key based on the cert name] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:603 Wednesday 06 August 2025 10:43:36 -0400 (0:00:00.089) 0:01:16.123 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "mssql_tls_enable is not none", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Copy certificate and private_key files to the host] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:608 Wednesday 06 August 2025 10:43:36 -0400 (0:00:00.050) 0:01:16.174 ****** skipping: [managed-node1] => (item=None) => { "ansible_loop_var": "item", "changed": false, "false_condition": "mssql_tls_enable is not none", "item": null, "skip_reason": "Conditional result was False" } skipping: [managed-node1] => (item=None) => { "ansible_loop_var": "item", "changed": false, "false_condition": "mssql_tls_enable is not none", "item": null, "skip_reason": "Conditional result was False" } skipping: [managed-node1] => { "changed": false } MSG: All items skipped TASK [fedora.linux_system_roles.mssql : Configure the tlscert setting] ********* task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:626 Wednesday 06 August 2025 10:43:36 -0400 (0:00:00.058) 0:01:16.232 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "mssql_tls_enable is not none", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Configure the tlskey setting] ********** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:635 Wednesday 06 August 2025 10:43:36 -0400 (0:00:00.049) 0:01:16.281 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "mssql_tls_enable is not none", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Configure the tlsprotocols setting] **** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:644 Wednesday 06 August 2025 10:43:36 -0400 (0:00:00.050) 0:01:16.332 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "mssql_tls_enable is not none", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Configure the forceencryption setting] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:651 Wednesday 06 August 2025 10:43:36 -0400 (0:00:00.048) 0:01:16.381 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "mssql_tls_enable is not none", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Get the setting forceencryption] ******* task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:660 Wednesday 06 August 2025 10:43:36 -0400 (0:00:00.049) 0:01:16.430 ****** ok: [managed-node1] => { "changed": false, "cmd": "set -euo pipefail; grep '^forceencryption' /var/opt/mssql/mssql.conf | sed 's/forceencryption = //g'", "delta": "0:00:00.004752", "end": "2025-08-06 10:43:36.737135", "failed_when_result": false, "rc": 1, "start": "2025-08-06 10:43:36.732383" } MSG: non-zero return code TASK [fedora.linux_system_roles.mssql : Append -No to sqlcmd when TLS is not configured] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:669 Wednesday 06 August 2025 10:43:36 -0400 (0:00:00.404) 0:01:16.835 ****** ok: [managed-node1] => { "ansible_facts": { "__sqlcmd_cli": "/opt/mssql-tools18/bin/sqlcmd -No" }, "changed": false } TASK [fedora.linux_system_roles.mssql : Append -C to sqlcmd when TLS is configured but certs are self-signed] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:676 Wednesday 06 August 2025 10:43:36 -0400 (0:00:00.097) 0:01:16.933 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "__mssql_forceencryption_val.stdout == '1'", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Prepare MSSQL and facts for logging in] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:689 Wednesday 06 August 2025 10:43:37 -0400 (0:00:00.114) 0:01:17.047 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "__mssql_conf_setup is skipped", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Wait for mssql-server to prepare for client connections] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:693 Wednesday 06 August 2025 10:43:37 -0400 (0:00:00.040) 0:01:17.087 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "__mssql_conf_setup is skipped", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Check if the set password matches the existing password] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:699 Wednesday 06 August 2025 10:43:37 -0400 (0:00:00.036) 0:01:17.124 ****** skipping: [managed-node1] => { "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 : Ensure that the mssql-server service is stopped] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:708 Wednesday 06 August 2025 10:43:37 -0400 (0:00:00.037) 0:01:17.161 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "__mssql_conf_setup is skipped", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Gather package facts] ****************** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:717 Wednesday 06 August 2025 10:43:37 -0400 (0:00:00.031) 0:01:17.193 ****** skipping: [managed-node1] => { "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 : Change the password of sa user] ******** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:725 Wednesday 06 August 2025 10:43:37 -0400 (0:00:00.050) 0:01:17.244 ****** skipping: [managed-node1] => { "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 : Pre-input SQL script files to SQL Server] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:746 Wednesday 06 August 2025 10:43:37 -0400 (0:00:00.029) 0:01:17.273 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "mssql_pre_input_sql_file != []", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Pre-input SQL script contents to SQL Server] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:755 Wednesday 06 August 2025 10:43:37 -0400 (0:00:00.049) 0:01:17.322 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "mssql_pre_input_sql_content != []", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Check if the set edition matches the existing edition] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:768 Wednesday 06 August 2025 10:43:37 -0400 (0:00:00.049) 0:01:17.372 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "__mssql_conf_setup is skipped", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Ensure that the mssql-server service is stopped] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:783 Wednesday 06 August 2025 10:43:37 -0400 (0:00:00.040) 0:01:17.412 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "__mssql_conf_setup is skipped", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Gather package facts] ****************** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:792 Wednesday 06 August 2025 10:43:37 -0400 (0:00:00.050) 0:01:17.463 ****** skipping: [managed-node1] => { "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 : Change the edition of MSSQL] *********** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:798 Wednesday 06 August 2025 10:43:37 -0400 (0:00:00.078) 0:01:17.541 ****** skipping: [managed-node1] => { "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 : Configure the IP address setting] ****** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:817 Wednesday 06 August 2025 10:43:37 -0400 (0:00:00.032) 0:01:17.574 ****** included: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml for managed-node1 TASK [fedora.linux_system_roles.mssql : Get the setting network ipaddress] ***** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:3 Wednesday 06 August 2025 10:43:37 -0400 (0:00:00.113) 0:01:17.688 ****** ok: [managed-node1] => { "changed": false, "cmd": [ "grep", "^ipaddress = ", "/var/opt/mssql/mssql.conf" ], "delta": "0:00:00.003054", "end": "2025-08-06 10:43:37.966645", "failed_when_result": false, "rc": 1, "start": "2025-08-06 10:43:37.963591" } MSG: non-zero return code TASK [fedora.linux_system_roles.mssql : Configure the setting network ipaddress] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:12 Wednesday 06 August 2025 10:43:38 -0400 (0:00:00.365) 0:01:18.053 ****** Notification for handler Restart the mssql-server service has been saved. changed: [managed-node1] => { "changed": true, "cmd": [ "/opt/mssql/bin/mssql-conf", "set", "network.ipaddress", "0.0.0.0" ], "delta": "0:00:00.102389", "end": "2025-08-06 10:43:38.438740", "failed_when_result": false, "rc": 0, "start": "2025-08-06 10:43:38.336351" } STDOUT: SQL Server needs to be restarted in order to apply this setting. Please run 'systemctl restart mssql-server.service'. TASK [fedora.linux_system_roles.mssql : Unset the setting network ipaddress] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:42 Wednesday 06 August 2025 10:43:38 -0400 (0:00:00.503) 0:01:18.557 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "__mssql_conf_setting_value == \"unset\"", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Register the previous tcpport setting] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:824 Wednesday 06 August 2025 10:43:38 -0400 (0:00:00.046) 0:01:18.603 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "mssql_manage_firewall | bool", "skip_reason": "Conditional result was False" } TASK [Open the TCP port 1433] ************************************************** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:831 Wednesday 06 August 2025 10:43:38 -0400 (0:00:00.074) 0:01:18.677 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "mssql_manage_firewall | bool", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Configure the TCP port setting to 1433] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:843 Wednesday 06 August 2025 10:43:38 -0400 (0:00:00.093) 0:01:18.770 ****** included: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml for managed-node1 TASK [fedora.linux_system_roles.mssql : Get the setting network tcpport] ******* task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:3 Wednesday 06 August 2025 10:43:38 -0400 (0:00:00.115) 0:01:18.885 ****** ok: [managed-node1] => { "changed": false, "cmd": [ "grep", "^tcpport = ", "/var/opt/mssql/mssql.conf" ], "delta": "0:00:00.002578", "end": "2025-08-06 10:43:39.244336", "failed_when_result": false, "rc": 1, "start": "2025-08-06 10:43:39.241758" } MSG: non-zero return code TASK [fedora.linux_system_roles.mssql : Configure the setting network tcpport] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:12 Wednesday 06 August 2025 10:43:39 -0400 (0:00:00.441) 0:01:19.326 ****** ok: [managed-node1] => { "changed": false, "cmd": [ "/opt/mssql/bin/mssql-conf", "set", "network.tcpport", "1433" ], "delta": "0:00:00.103340", "end": "2025-08-06 10:43:39.705738", "failed_when_result": false, "rc": 0, "start": "2025-08-06 10:43:39.602398" } STDOUT: Validation error on setting 'network.tcpport' Port '1433' is already in use. Please use another port TASK [fedora.linux_system_roles.mssql : Unset the setting network tcpport] ***** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:42 Wednesday 06 August 2025 10:43:39 -0400 (0:00:00.469) 0:01:19.796 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "__mssql_conf_setting_value == \"unset\"", "skip_reason": "Conditional result was False" } TASK [Close the previously set SQL Server TCP port if it changed] ************** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:849 Wednesday 06 August 2025 10:43:39 -0400 (0:00:00.025) 0:01:19.821 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "mssql_manage_firewall | bool", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Configure the sqlagent setting] ******** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:869 Wednesday 06 August 2025 10:43:39 -0400 (0:00:00.045) 0:01:19.867 ****** included: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml for managed-node1 TASK [fedora.linux_system_roles.mssql : Get the setting sqlagent enabled] ****** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:3 Wednesday 06 August 2025 10:43:39 -0400 (0:00:00.054) 0:01:19.921 ****** ok: [managed-node1] => { "changed": false, "cmd": [ "grep", "^enabled = ", "/var/opt/mssql/mssql.conf" ], "delta": "0:00:00.002530", "end": "2025-08-06 10:43:40.196537", "failed_when_result": false, "rc": 0, "start": "2025-08-06 10:43:40.194007" } STDOUT: enabled = false TASK [fedora.linux_system_roles.mssql : Configure the setting sqlagent enabled] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:12 Wednesday 06 August 2025 10:43:40 -0400 (0:00:00.359) 0:01:20.280 ****** Notification for handler Restart the mssql-server service has been saved. changed: [managed-node1] => { "changed": true, "cmd": [ "/opt/mssql/bin/mssql-conf", "set", "sqlagent.enabled", "True" ], "delta": "0:00:00.101345", "end": "2025-08-06 10:43:40.660435", "failed_when_result": false, "rc": 0, "start": "2025-08-06 10:43:40.559090" } STDOUT: SQL Server needs to be restarted in order to apply this setting. Please run 'systemctl restart mssql-server.service'. TASK [fedora.linux_system_roles.mssql : Unset the setting sqlagent enabled] **** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:42 Wednesday 06 August 2025 10:43:40 -0400 (0:00:00.472) 0:01:20.753 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "__mssql_conf_setting_value == \"unset\"", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Ensure the package mssql-server-fts] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:876 Wednesday 06 August 2025 10:43:40 -0400 (0:00:00.034) 0:01:20.787 ****** fatal: [managed-node1]: FAILED! => { "changed": false, "results": [] } MSG: Failed to download packages: mssql-server-fts-15.0.4435.7-2.x86_64: Cannot download, all mirrors were already tried without success TASK [Clean up after the role invocation] ************************************** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_idempotency_2019.yml:18 Wednesday 06 August 2025 10:43:43 -0400 (0:00:03.018) 0:01:23.806 ****** included: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml for managed-node1 TASK [Gather package facts] **************************************************** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:3 Wednesday 06 August 2025 10:43:43 -0400 (0:00:00.052) 0:01:23.859 ****** ok: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:7 Wednesday 06 August 2025 10:43:45 -0400 (0:00:01.549) 0:01:25.408 ****** TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts used by role] ***** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 Wednesday 06 August 2025 10:43:45 -0400 (0:00:00.094) 0:01:25.502 ****** skipping: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8 Wednesday 06 August 2025 10:43:45 -0400 (0:00:00.082) 0:01:25.584 ****** ok: [managed-node1] => (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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } skipping: [managed-node1] => (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" } ok: [managed-node1] => (item=CentOS_8.yml) => { "ansible_facts": { "__mssql_client_repository": "https://packages.microsoft.com/rhel/8/prod/", "__mssql_confined_supported": false, "__mssql_server_repository": "https://packages.microsoft.com/rhel/8/mssql-server-{{ mssql_version | int }}/", "__mssql_supported_versions": [ 2017, 2019, 2022 ] }, "ansible_included_var_files": [ "/tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/CentOS_8.yml" ], "ansible_loop_var": "item", "changed": false, "item": "CentOS_8.yml" } ok: [managed-node1] => (item=CentOS_8.yml) => { "ansible_facts": { "__mssql_client_repository": "https://packages.microsoft.com/rhel/8/prod/", "__mssql_confined_supported": false, "__mssql_server_repository": "https://packages.microsoft.com/rhel/8/mssql-server-{{ mssql_version | int }}/", "__mssql_supported_versions": [ 2017, 2019, 2022 ] }, "ansible_included_var_files": [ "/tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/CentOS_8.yml" ], "ansible_loop_var": "item", "changed": false, "item": "CentOS_8.yml" } TASK [fedora.linux_system_roles.mssql : Run systemctl] ************************* task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:22 Wednesday 06 August 2025 10:43:45 -0400 (0:00:00.085) 0:01:25.670 ****** skipping: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:29 Wednesday 06 August 2025 10:43:45 -0400 (0:00:00.050) 0:01:25.721 ****** skipping: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:34 Wednesday 06 August 2025 10:43:45 -0400 (0:00:00.047) 0:01:25.769 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "__mssql_is_booted is not defined", "skip_reason": "Conditional result was False" } TASK [Purge cluster configuration] ********************************************* task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:13 Wednesday 06 August 2025 10:43:45 -0400 (0:00:00.076) 0:01:25.845 ****** skipping: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:21 Wednesday 06 August 2025 10:43:45 -0400 (0:00:00.064) 0:01:25.910 ****** ok: [managed-node1] => { "ansible_python_version": "3.6.8" } TASK [Purge firewall configuration] ******************************************** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:25 Wednesday 06 August 2025 10:43:45 -0400 (0:00:00.050) 0:01:25.960 ****** TASK [fedora.linux_system_roles.firewall : Setup firewalld] ******************** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:2 Wednesday 06 August 2025 10:43:46 -0400 (0:00:00.136) 0:01:26.097 ****** included: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml for managed-node1 TASK [fedora.linux_system_roles.firewall : Ensure ansible_facts used by role] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:2 Wednesday 06 August 2025 10:43:46 -0400 (0:00:00.090) 0:01:26.188 ****** skipping: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:10 Wednesday 06 August 2025 10:43:46 -0400 (0:00:00.117) 0:01:26.305 ****** ok: [managed-node1] => { "changed": false, "stat": { "exists": false } } TASK [fedora.linux_system_roles.firewall : Set flag to indicate system is ostree] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:15 Wednesday 06 August 2025 10:43:47 -0400 (0:00:00.899) 0:01:27.204 ****** ok: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:22 Wednesday 06 August 2025 10:43:47 -0400 (0:00:00.056) 0:01:27.261 ****** ok: [managed-node1] => { "changed": false, "stat": { "exists": false } } TASK [fedora.linux_system_roles.firewall : Set flag if transactional-update exists] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:27 Wednesday 06 August 2025 10:43:47 -0400 (0:00:00.631) 0:01:27.893 ****** ok: [managed-node1] => { "ansible_facts": { "__firewall_is_transactional": false }, "changed": false } TASK [fedora.linux_system_roles.firewall : Run systemctl] ********************** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:34 Wednesday 06 August 2025 10:43:47 -0400 (0:00:00.056) 0:01:27.949 ****** ok: [managed-node1] => { "changed": false, "cmd": [ "systemctl", "is-system-running" ], "delta": "0:00:00.007854", "end": "2025-08-06 10:43:48.241838", "failed_when_result": false, "rc": 0, "start": "2025-08-06 10:43:48.233984" } STDOUT: running TASK [fedora.linux_system_roles.firewall : Require installed systemd] ********** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:41 Wednesday 06 August 2025 10:43:48 -0400 (0:00:00.395) 0:01:28.345 ****** skipping: [managed-node1] => { "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-3u7/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:46 Wednesday 06 August 2025 10:43:48 -0400 (0:00:00.081) 0:01:28.426 ****** ok: [managed-node1] => { "ansible_facts": { "__firewall_is_booted": true }, "changed": false } TASK [fedora.linux_system_roles.firewall : Install firewalld] ****************** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:51 Wednesday 06 August 2025 10:43:48 -0400 (0:00:00.058) 0:01:28.484 ****** ok: [managed-node1] => { "changed": false, "rc": 0, "results": [] } MSG: Nothing to do TASK [fedora.linux_system_roles.firewall : Notify user that reboot is needed to apply changes] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:63 Wednesday 06 August 2025 10:43:51 -0400 (0:00:02.874) 0:01:31.359 ****** skipping: [managed-node1] => { "false_condition": "__firewall_is_transactional | d(false)" } TASK [fedora.linux_system_roles.firewall : Reboot transactional update systems] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:68 Wednesday 06 August 2025 10:43:51 -0400 (0:00:00.057) 0:01:31.417 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "__firewall_is_transactional | d(false)", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.firewall : Fail if reboot is needed and not set] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:73 Wednesday 06 August 2025 10:43:51 -0400 (0:00:00.049) 0:01:31.467 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "__firewall_is_transactional | d(false)", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.firewall : Check which conflicting services are enabled] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:5 Wednesday 06 August 2025 10:43:51 -0400 (0:00:00.049) 0:01:31.516 ****** skipping: [managed-node1] => (item=nftables) => { "ansible_loop_var": "item", "changed": false, "false_condition": "firewall_disable_conflicting_services | bool", "item": "nftables", "skip_reason": "Conditional result was False" } skipping: [managed-node1] => (item=iptables) => { "ansible_loop_var": "item", "changed": false, "false_condition": "firewall_disable_conflicting_services | bool", "item": "iptables", "skip_reason": "Conditional result was False" } skipping: [managed-node1] => (item=ufw) => { "ansible_loop_var": "item", "changed": false, "false_condition": "firewall_disable_conflicting_services | bool", "item": "ufw", "skip_reason": "Conditional result was False" } skipping: [managed-node1] => { "changed": false } MSG: All items skipped TASK [fedora.linux_system_roles.firewall : Attempt to stop and disable conflicting services] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:14 Wednesday 06 August 2025 10:43:51 -0400 (0:00:00.052) 0:01:31.569 ****** skipping: [managed-node1] => (item={'changed': False, 'skipped': True, 'skip_reason': 'Conditional result was False', 'false_condition': 'firewall_disable_conflicting_services | bool', 'item': 'nftables', 'ansible_loop_var': 'item'}) => { "ansible_loop_var": "item", "changed": false, "false_condition": "firewall_disable_conflicting_services | bool", "item": { "ansible_loop_var": "item", "changed": false, "false_condition": "firewall_disable_conflicting_services | bool", "item": "nftables", "skip_reason": "Conditional result was False", "skipped": true }, "skip_reason": "Conditional result was False" } skipping: [managed-node1] => (item={'changed': False, 'skipped': True, 'skip_reason': 'Conditional result was False', 'false_condition': 'firewall_disable_conflicting_services | bool', 'item': 'iptables', 'ansible_loop_var': 'item'}) => { "ansible_loop_var": "item", "changed": false, "false_condition": "firewall_disable_conflicting_services | bool", "item": { "ansible_loop_var": "item", "changed": false, "false_condition": "firewall_disable_conflicting_services | bool", "item": "iptables", "skip_reason": "Conditional result was False", "skipped": true }, "skip_reason": "Conditional result was False" } skipping: [managed-node1] => (item={'changed': False, 'skipped': True, 'skip_reason': 'Conditional result was False', 'false_condition': 'firewall_disable_conflicting_services | bool', 'item': 'ufw', 'ansible_loop_var': 'item'}) => { "ansible_loop_var": "item", "changed": false, "false_condition": "firewall_disable_conflicting_services | bool", "item": { "ansible_loop_var": "item", "changed": false, "false_condition": "firewall_disable_conflicting_services | bool", "item": "ufw", "skip_reason": "Conditional result was False", "skipped": true }, "skip_reason": "Conditional result was False" } skipping: [managed-node1] => { "changed": false } MSG: All items skipped TASK [fedora.linux_system_roles.firewall : Unmask firewalld service] *********** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:24 Wednesday 06 August 2025 10:43:51 -0400 (0:00:00.055) 0:01:31.625 ****** ok: [managed-node1] => { "changed": false, "name": "firewalld", "status": { "ActiveEnterTimestamp": "Wed 2025-08-06 10:36:11 EDT", "ActiveEnterTimestampMonotonic": "454252272", "ActiveExitTimestampMonotonic": "0", "ActiveState": "active", "After": "basic.target sysinit.target dbus.service dbus.socket system.slice polkit.service", "AllowIsolate": "no", "AllowedCPUs": "", "AllowedMemoryNodes": "", "AmbientCapabilities": "", "AssertResult": "yes", "AssertTimestamp": "Wed 2025-08-06 10:36:10 EDT", "AssertTimestampMonotonic": "453966475", "Before": "network-pre.target multi-user.target shutdown.target", "BlockIOAccounting": "no", "BlockIOWeight": "[not set]", "BusName": "org.fedoraproject.FirewallD1", "CPUAccounting": "no", "CPUAffinity": "", "CPUAffinityFromNUMA": "no", "CPUQuotaPerSecUSec": "infinity", "CPUQuotaPeriodUSec": "infinity", "CPUSchedulingPolicy": "0", "CPUSchedulingPriority": "0", "CPUSchedulingResetOnFork": "no", "CPUShares": "[not set]", "CPUUsageNSec": "[not set]", "CPUWeight": "[not set]", "CacheDirectoryMode": "0755", "CanFreeze": "yes", "CanIsolate": "no", "CanReload": "yes", "CanStart": "yes", "CanStop": "yes", "CapabilityBoundingSet": "cap_chown cap_dac_override cap_dac_read_search cap_fowner cap_fsetid cap_kill cap_setgid cap_setuid cap_setpcap cap_linux_immutable cap_net_bind_service cap_net_broadcast cap_net_admin cap_net_raw cap_ipc_lock cap_ipc_owner cap_sys_module cap_sys_rawio cap_sys_chroot cap_sys_ptrace cap_sys_pacct cap_sys_admin cap_sys_boot cap_sys_nice cap_sys_resource cap_sys_time cap_sys_tty_config cap_mknod cap_lease cap_audit_write cap_audit_control cap_setfcap cap_mac_override cap_mac_admin cap_syslog cap_wake_alarm cap_block_suspend cap_audit_read cap_perfmon cap_bpf", "CollectMode": "inactive", "ConditionResult": "yes", "ConditionTimestamp": "Wed 2025-08-06 10:36:10 EDT", "ConditionTimestampMonotonic": "453966473", "ConfigurationDirectoryMode": "0755", "Conflicts": "shutdown.target ebtables.service iptables.service ip6tables.service nftables.service ipset.service", "ControlGroup": "/system.slice/firewalld.service", "ControlPID": "0", "DefaultDependencies": "yes", "DefaultMemoryLow": "0", "DefaultMemoryMin": "0", "Delegate": "no", "Description": "firewalld - dynamic firewall daemon", "DevicePolicy": "auto", "Documentation": "man:firewalld(1)", "DynamicUser": "no", "EffectiveCPUs": "", "EffectiveMemoryNodes": "", "EnvironmentFiles": "/etc/sysconfig/firewalld (ignore_errors=yes)", "ExecMainCode": "0", "ExecMainExitTimestampMonotonic": "0", "ExecMainPID": "20001", "ExecMainStartTimestamp": "Wed 2025-08-06 10:36:10 EDT", "ExecMainStartTimestampMonotonic": "453967648", "ExecMainStatus": "0", "ExecReload": "{ path=/bin/kill ; argv[]=/bin/kill -HUP $MAINPID ; ignore_errors=no ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }", "ExecStart": "{ path=/usr/sbin/firewalld ; argv[]=/usr/sbin/firewalld --nofork --nopid $FIREWALLD_ARGS ; ignore_errors=no ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }", "FailureAction": "none", "FileDescriptorStoreMax": "0", "FragmentPath": "/usr/lib/systemd/system/firewalld.service", "FreezerState": "running", "GID": "[not set]", "GuessMainPID": "yes", "IOAccounting": "no", "IOSchedulingClass": "0", "IOSchedulingPriority": "0", "IOWeight": "[not set]", "IPAccounting": "no", "IPEgressBytes": "18446744073709551615", "IPEgressPackets": "18446744073709551615", "IPIngressBytes": "18446744073709551615", "IPIngressPackets": "18446744073709551615", "Id": "firewalld.service", "IgnoreOnIsolate": "no", "IgnoreSIGPIPE": "yes", "InactiveEnterTimestampMonotonic": "0", "InactiveExitTimestamp": "Wed 2025-08-06 10:36:10 EDT", "InactiveExitTimestampMonotonic": "453967688", "InvocationID": "9c2dbf50237f47fa84109c781fbdc4b0", "JobRunningTimeoutUSec": "infinity", "JobTimeoutAction": "none", "JobTimeoutUSec": "infinity", "KeyringMode": "private", "KillMode": "mixed", "KillSignal": "15", "LimitAS": "infinity", "LimitASSoft": "infinity", "LimitCORE": "infinity", "LimitCORESoft": "0", "LimitCPU": "infinity", "LimitCPUSoft": "infinity", "LimitDATA": "infinity", "LimitDATASoft": "infinity", "LimitFSIZE": "infinity", "LimitFSIZESoft": "infinity", "LimitLOCKS": "infinity", "LimitLOCKSSoft": "infinity", "LimitMEMLOCK": "65536", "LimitMEMLOCKSoft": "65536", "LimitMSGQUEUE": "819200", "LimitMSGQUEUESoft": "819200", "LimitNICE": "0", "LimitNICESoft": "0", "LimitNOFILE": "262144", "LimitNOFILESoft": "1024", "LimitNPROC": "28608", "LimitNPROCSoft": "28608", "LimitRSS": "infinity", "LimitRSSSoft": "infinity", "LimitRTPRIO": "0", "LimitRTPRIOSoft": "0", "LimitRTTIME": "infinity", "LimitRTTIMESoft": "infinity", "LimitSIGPENDING": "28608", "LimitSIGPENDINGSoft": "28608", "LimitSTACK": "infinity", "LimitSTACKSoft": "8388608", "LoadState": "loaded", "LockPersonality": "no", "LogLevelMax": "-1", "LogRateLimitBurst": "0", "LogRateLimitIntervalUSec": "0", "LogsDirectoryMode": "0755", "MainPID": "20001", "MemoryAccounting": "yes", "MemoryCurrent": "42721280", "MemoryDenyWriteExecute": "no", "MemoryHigh": "infinity", "MemoryLimit": "infinity", "MemoryLow": "0", "MemoryMax": "infinity", "MemoryMin": "0", "MemorySwapMax": "infinity", "MountAPIVFS": "no", "MountFlags": "", "NFileDescriptorStore": "0", "NRestarts": "0", "NUMAMask": "", "NUMAPolicy": "n/a", "Names": "firewalld.service", "NeedDaemonReload": "no", "Nice": "0", "NoNewPrivileges": "no", "NonBlocking": "no", "NotifyAccess": "none", "OOMScoreAdjust": "0", "OnFailureJobMode": "replace", "PermissionsStartOnly": "no", "Perpetual": "no", "PrivateDevices": "no", "PrivateMounts": "no", "PrivateNetwork": "no", "PrivateTmp": "no", "PrivateUsers": "no", "ProtectControlGroups": "no", "ProtectHome": "no", "ProtectKernelModules": "no", "ProtectKernelTunables": "no", "ProtectSystem": "no", "RefuseManualStart": "no", "RefuseManualStop": "no", "RemainAfterExit": "no", "RemoveIPC": "no", "Requires": "dbus.socket system.slice sysinit.target", "Restart": "no", "RestartUSec": "100ms", "RestrictNamespaces": "no", "RestrictRealtime": "no", "RestrictSUIDSGID": "no", "Result": "success", "RootDirectoryStartOnly": "no", "RuntimeDirectoryMode": "0755", "RuntimeDirectoryPreserve": "no", "RuntimeMaxUSec": "infinity", "SameProcessGroup": "no", "SecureBits": "0", "SendSIGHUP": "no", "SendSIGKILL": "yes", "Slice": "system.slice", "StandardError": "null", "StandardInput": "null", "StandardInputData": "", "StandardOutput": "null", "StartLimitAction": "none", "StartLimitBurst": "5", "StartLimitIntervalUSec": "10s", "StartupBlockIOWeight": "[not set]", "StartupCPUShares": "[not set]", "StartupCPUWeight": "[not set]", "StartupIOWeight": "[not set]", "StateChangeTimestamp": "Wed 2025-08-06 10:36:11 EDT", "StateChangeTimestampMonotonic": "454252272", "StateDirectoryMode": "0755", "StatusErrno": "0", "StopWhenUnneeded": "no", "SubState": "running", "SuccessAction": "none", "SyslogFacility": "3", "SyslogLevel": "6", "SyslogLevelPrefix": "yes", "SyslogPriority": "30", "SystemCallErrorNumber": "0", "TTYReset": "no", "TTYVHangup": "no", "TTYVTDisallocate": "no", "TasksAccounting": "yes", "TasksCurrent": "3", "TasksMax": "45773", "TimeoutStartUSec": "1min 30s", "TimeoutStopUSec": "1min 30s", "TimerSlackNSec": "50000", "Transient": "no", "Type": "dbus", "UID": "[not set]", "UMask": "0022", "UnitFilePreset": "enabled", "UnitFileState": "enabled", "UtmpMode": "init", "WantedBy": "multi-user.target", "Wants": "network-pre.target", "WatchdogTimestamp": "Wed 2025-08-06 10:36:11 EDT", "WatchdogTimestampMonotonic": "454252268", "WatchdogUSec": "0" } } TASK [fedora.linux_system_roles.firewall : Enable and start firewalld service] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:30 Wednesday 06 August 2025 10:43:52 -0400 (0:00:00.504) 0:01:32.130 ****** ok: [managed-node1] => { "changed": false, "enabled": true, "name": "firewalld", "state": "started", "status": { "ActiveEnterTimestamp": "Wed 2025-08-06 10:36:11 EDT", "ActiveEnterTimestampMonotonic": "454252272", "ActiveExitTimestampMonotonic": "0", "ActiveState": "active", "After": "basic.target sysinit.target dbus.service dbus.socket system.slice polkit.service", "AllowIsolate": "no", "AllowedCPUs": "", "AllowedMemoryNodes": "", "AmbientCapabilities": "", "AssertResult": "yes", "AssertTimestamp": "Wed 2025-08-06 10:36:10 EDT", "AssertTimestampMonotonic": "453966475", "Before": "network-pre.target multi-user.target shutdown.target", "BlockIOAccounting": "no", "BlockIOWeight": "[not set]", "BusName": "org.fedoraproject.FirewallD1", "CPUAccounting": "no", "CPUAffinity": "", "CPUAffinityFromNUMA": "no", "CPUQuotaPerSecUSec": "infinity", "CPUQuotaPeriodUSec": "infinity", "CPUSchedulingPolicy": "0", "CPUSchedulingPriority": "0", "CPUSchedulingResetOnFork": "no", "CPUShares": "[not set]", "CPUUsageNSec": "[not set]", "CPUWeight": "[not set]", "CacheDirectoryMode": "0755", "CanFreeze": "yes", "CanIsolate": "no", "CanReload": "yes", "CanStart": "yes", "CanStop": "yes", "CapabilityBoundingSet": "cap_chown cap_dac_override cap_dac_read_search cap_fowner cap_fsetid cap_kill cap_setgid cap_setuid cap_setpcap cap_linux_immutable cap_net_bind_service cap_net_broadcast cap_net_admin cap_net_raw cap_ipc_lock cap_ipc_owner cap_sys_module cap_sys_rawio cap_sys_chroot cap_sys_ptrace cap_sys_pacct cap_sys_admin cap_sys_boot cap_sys_nice cap_sys_resource cap_sys_time cap_sys_tty_config cap_mknod cap_lease cap_audit_write cap_audit_control cap_setfcap cap_mac_override cap_mac_admin cap_syslog cap_wake_alarm cap_block_suspend cap_audit_read cap_perfmon cap_bpf", "CollectMode": "inactive", "ConditionResult": "yes", "ConditionTimestamp": "Wed 2025-08-06 10:36:10 EDT", "ConditionTimestampMonotonic": "453966473", "ConfigurationDirectoryMode": "0755", "Conflicts": "shutdown.target ebtables.service iptables.service ip6tables.service nftables.service ipset.service", "ControlGroup": "/system.slice/firewalld.service", "ControlPID": "0", "DefaultDependencies": "yes", "DefaultMemoryLow": "0", "DefaultMemoryMin": "0", "Delegate": "no", "Description": "firewalld - dynamic firewall daemon", "DevicePolicy": "auto", "Documentation": "man:firewalld(1)", "DynamicUser": "no", "EffectiveCPUs": "", "EffectiveMemoryNodes": "", "EnvironmentFiles": "/etc/sysconfig/firewalld (ignore_errors=yes)", "ExecMainCode": "0", "ExecMainExitTimestampMonotonic": "0", "ExecMainPID": "20001", "ExecMainStartTimestamp": "Wed 2025-08-06 10:36:10 EDT", "ExecMainStartTimestampMonotonic": "453967648", "ExecMainStatus": "0", "ExecReload": "{ path=/bin/kill ; argv[]=/bin/kill -HUP $MAINPID ; ignore_errors=no ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }", "ExecStart": "{ path=/usr/sbin/firewalld ; argv[]=/usr/sbin/firewalld --nofork --nopid $FIREWALLD_ARGS ; ignore_errors=no ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }", "FailureAction": "none", "FileDescriptorStoreMax": "0", "FragmentPath": "/usr/lib/systemd/system/firewalld.service", "FreezerState": "running", "GID": "[not set]", "GuessMainPID": "yes", "IOAccounting": "no", "IOSchedulingClass": "0", "IOSchedulingPriority": "0", "IOWeight": "[not set]", "IPAccounting": "no", "IPEgressBytes": "18446744073709551615", "IPEgressPackets": "18446744073709551615", "IPIngressBytes": "18446744073709551615", "IPIngressPackets": "18446744073709551615", "Id": "firewalld.service", "IgnoreOnIsolate": "no", "IgnoreSIGPIPE": "yes", "InactiveEnterTimestampMonotonic": "0", "InactiveExitTimestamp": "Wed 2025-08-06 10:36:10 EDT", "InactiveExitTimestampMonotonic": "453967688", "InvocationID": "9c2dbf50237f47fa84109c781fbdc4b0", "JobRunningTimeoutUSec": "infinity", "JobTimeoutAction": "none", "JobTimeoutUSec": "infinity", "KeyringMode": "private", "KillMode": "mixed", "KillSignal": "15", "LimitAS": "infinity", "LimitASSoft": "infinity", "LimitCORE": "infinity", "LimitCORESoft": "0", "LimitCPU": "infinity", "LimitCPUSoft": "infinity", "LimitDATA": "infinity", "LimitDATASoft": "infinity", "LimitFSIZE": "infinity", "LimitFSIZESoft": "infinity", "LimitLOCKS": "infinity", "LimitLOCKSSoft": "infinity", "LimitMEMLOCK": "65536", "LimitMEMLOCKSoft": "65536", "LimitMSGQUEUE": "819200", "LimitMSGQUEUESoft": "819200", "LimitNICE": "0", "LimitNICESoft": "0", "LimitNOFILE": "262144", "LimitNOFILESoft": "1024", "LimitNPROC": "28608", "LimitNPROCSoft": "28608", "LimitRSS": "infinity", "LimitRSSSoft": "infinity", "LimitRTPRIO": "0", "LimitRTPRIOSoft": "0", "LimitRTTIME": "infinity", "LimitRTTIMESoft": "infinity", "LimitSIGPENDING": "28608", "LimitSIGPENDINGSoft": "28608", "LimitSTACK": "infinity", "LimitSTACKSoft": "8388608", "LoadState": "loaded", "LockPersonality": "no", "LogLevelMax": "-1", "LogRateLimitBurst": "0", "LogRateLimitIntervalUSec": "0", "LogsDirectoryMode": "0755", "MainPID": "20001", "MemoryAccounting": "yes", "MemoryCurrent": "42721280", "MemoryDenyWriteExecute": "no", "MemoryHigh": "infinity", "MemoryLimit": "infinity", "MemoryLow": "0", "MemoryMax": "infinity", "MemoryMin": "0", "MemorySwapMax": "infinity", "MountAPIVFS": "no", "MountFlags": "", "NFileDescriptorStore": "0", "NRestarts": "0", "NUMAMask": "", "NUMAPolicy": "n/a", "Names": "firewalld.service", "NeedDaemonReload": "no", "Nice": "0", "NoNewPrivileges": "no", "NonBlocking": "no", "NotifyAccess": "none", "OOMScoreAdjust": "0", "OnFailureJobMode": "replace", "PermissionsStartOnly": "no", "Perpetual": "no", "PrivateDevices": "no", "PrivateMounts": "no", "PrivateNetwork": "no", "PrivateTmp": "no", "PrivateUsers": "no", "ProtectControlGroups": "no", "ProtectHome": "no", "ProtectKernelModules": "no", "ProtectKernelTunables": "no", "ProtectSystem": "no", "RefuseManualStart": "no", "RefuseManualStop": "no", "RemainAfterExit": "no", "RemoveIPC": "no", "Requires": "dbus.socket system.slice sysinit.target", "Restart": "no", "RestartUSec": "100ms", "RestrictNamespaces": "no", "RestrictRealtime": "no", "RestrictSUIDSGID": "no", "Result": "success", "RootDirectoryStartOnly": "no", "RuntimeDirectoryMode": "0755", "RuntimeDirectoryPreserve": "no", "RuntimeMaxUSec": "infinity", "SameProcessGroup": "no", "SecureBits": "0", "SendSIGHUP": "no", "SendSIGKILL": "yes", "Slice": "system.slice", "StandardError": "null", "StandardInput": "null", "StandardInputData": "", "StandardOutput": "null", "StartLimitAction": "none", "StartLimitBurst": "5", "StartLimitIntervalUSec": "10s", "StartupBlockIOWeight": "[not set]", "StartupCPUShares": "[not set]", "StartupCPUWeight": "[not set]", "StartupIOWeight": "[not set]", "StateChangeTimestamp": "Wed 2025-08-06 10:36:11 EDT", "StateChangeTimestampMonotonic": "454252272", "StateDirectoryMode": "0755", "StatusErrno": "0", "StopWhenUnneeded": "no", "SubState": "running", "SuccessAction": "none", "SyslogFacility": "3", "SyslogLevel": "6", "SyslogLevelPrefix": "yes", "SyslogPriority": "30", "SystemCallErrorNumber": "0", "TTYReset": "no", "TTYVHangup": "no", "TTYVTDisallocate": "no", "TasksAccounting": "yes", "TasksCurrent": "3", "TasksMax": "45773", "TimeoutStartUSec": "1min 30s", "TimeoutStopUSec": "1min 30s", "TimerSlackNSec": "50000", "Transient": "no", "Type": "dbus", "UID": "[not set]", "UMask": "0022", "UnitFilePreset": "enabled", "UnitFileState": "enabled", "UtmpMode": "init", "WantedBy": "multi-user.target", "Wants": "network-pre.target", "WatchdogTimestamp": "Wed 2025-08-06 10:36:11 EDT", "WatchdogTimestampMonotonic": "454252268", "WatchdogUSec": "0" } } TASK [fedora.linux_system_roles.firewall : Check if previous replaced is defined] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:36 Wednesday 06 August 2025 10:43:52 -0400 (0:00:00.535) 0:01:32.665 ****** ok: [managed-node1] => { "ansible_facts": { "__firewall_previous_replaced": true, "__firewall_python_cmd": "/usr/libexec/platform-python", "__firewall_report_changed": true }, "changed": false } TASK [fedora.linux_system_roles.firewall : Get config files, checksums before and remove] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:45 Wednesday 06 August 2025 10:43:52 -0400 (0:00:00.063) 0:01:32.729 ****** ok: [managed-node1] => { "changed": false, "rc": 0 } STDERR: Shared connection to 10.31.44.74 closed. TASK [fedora.linux_system_roles.firewall : Tell firewall module it is able to report changed] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:58 Wednesday 06 August 2025 10:43:53 -0400 (0:00:00.328) 0:01:33.057 ****** ok: [managed-node1] => { "ansible_facts": { "__firewall_report_changed": true }, "changed": false } TASK [fedora.linux_system_roles.firewall : Configure firewall] ***************** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:74 Wednesday 06 August 2025 10:43:53 -0400 (0:00:00.074) 0:01:33.131 ****** skipping: [managed-node1] => { "changed": false, "skipped_reason": "No items in the list" } TASK [fedora.linux_system_roles.firewall : Gather firewall config information] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:126 Wednesday 06 August 2025 10:43:53 -0400 (0:00:00.085) 0:01:33.217 ****** skipping: [managed-node1] => { "changed": false, "skipped_reason": "No items in the list" } TASK [fedora.linux_system_roles.firewall : Update firewalld_config fact] ******* task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:137 Wednesday 06 August 2025 10:43:53 -0400 (0:00:00.081) 0:01:33.299 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "'detailed' in fw[0]", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.firewall : Gather firewall config if no arguments] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:146 Wednesday 06 August 2025 10:43:53 -0400 (0:00:00.103) 0:01:33.402 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "firewall == None or firewall | length == 0", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.firewall : Update firewalld_config fact] ******* task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:152 Wednesday 06 August 2025 10:43:53 -0400 (0:00:00.059) 0:01:33.461 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "firewall == None or firewall | length == 0", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.firewall : Get config files, checksums after] *** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:161 Wednesday 06 August 2025 10:43:53 -0400 (0:00:00.058) 0:01:33.520 ****** ok: [managed-node1] => { "changed": false, "rc": 0 } STDERR: Shared connection to 10.31.44.74 closed. TASK [fedora.linux_system_roles.firewall : Calculate what has changed] ********* task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:172 Wednesday 06 August 2025 10:43:53 -0400 (0:00:00.277) 0:01:33.797 ****** ok: [managed-node1] => { "ansible_facts": { "firewall_lib_result": { "changed": false } }, "changed": false } TASK [fedora.linux_system_roles.firewall : Show diffs] ************************* task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:178 Wednesday 06 August 2025 10:43:53 -0400 (0:00:00.127) 0:01:33.925 ****** skipping: [managed-node1] => { "false_condition": "__firewall_debug | d(false)" } TASK [Purge selinux configuration] ********************************************* task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:33 Wednesday 06 August 2025 10:43:53 -0400 (0:00:00.062) 0:01:33.987 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "mssql_manage_selinux | d(false) | bool", "skip_reason": "Conditional result was False" } TASK [Leave realm] ************************************************************* task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:40 Wednesday 06 August 2025 10:43:54 -0400 (0:00:00.055) 0:01:34.042 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "ansible_facts.packages.realmd is defined", "skip_reason": "Conditional result was False" } TASK [Destroy Kerberos tickets] ************************************************ task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:48 Wednesday 06 August 2025 10:43:54 -0400 (0:00:00.058) 0:01:34.101 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "ansible_facts.packages[\"krb5-workstation\"] is defined", "skip_reason": "Conditional result was False" } TASK [Remove related packages] ************************************************* task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:52 Wednesday 06 August 2025 10:43:54 -0400 (0:00:00.038) 0:01:34.139 ****** changed: [managed-node1] => { "changed": true, "rc": 0, "results": [ "Removed: unixODBC-2.3.11-1.rh.x86_64", "Removed: unixODBC-devel-2.3.11-1.rh.x86_64", "Removed: libtool-ltdl-2.4.6-25.el8.x86_64", "Removed: gc-7.6.4-3.el8.x86_64", "Removed: msodbcsql18-18.5.1.1-1.x86_64", "Removed: gcc-gdb-plugin-8.5.0-22.el8.x86_64", "Removed: gdb-8.2-20.el8.x86_64", "Removed: gdb-headless-8.2-20.el8.x86_64", "Removed: libatomic-8.5.0-22.el8.x86_64", "Removed: libatomic_ops-7.6.2-3.el8.x86_64", "Removed: guile-5:2.0.14-7.el8.x86_64", "Removed: libbabeltrace-1.5.4-4.el8.x86_64", "Removed: libipt-1.6.1-8.el8.x86_64", "Removed: mssql-server-15.0.4435.7-2.x86_64", "Removed: mssql-tools18-18.4.1.1-1.x86_64", "Removed: cyrus-sasl-2.1.27-6.el8_5.x86_64", "Removed: cyrus-sasl-gssapi-2.1.27-6.el8_5.x86_64", "Removed: lsof-4.93.2-1.el8.x86_64", "Removed: bzip2-1.0.6-26.el8.x86_64" ] } TASK [Remove related files] **************************************************** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:65 Wednesday 06 August 2025 10:43:59 -0400 (0:00:05.655) 0:01:39.795 ****** changed: [managed-node1] => { "changed": true, "cmd": "rm -rfv /var/opt/mssql* /opt/mssql* /var/log/pacemaker/pacemaker.log /etc/yum.repos.d/packages-microsoft-com-* /tmp/*.j2_* /tmp/mssql_data /tmp/mssql_log /etc/systemd/system/mssql-server.service.d /etc/systemd/system/multi-user.target.wants/mssql-server.service", "delta": "0:00:00.009724", "end": "2025-08-06 10:44:00.065223", "rc": 0, "start": "2025-08-06 10:44:00.055499" } STDOUT: removed directory '/var/opt/mssql/.system/system/Temp' removed '/var/opt/mssql/.system/system/lsasetup.log' removed '/var/opt/mssql/.system/system/debug/PASSWD.LOG' removed directory '/var/opt/mssql/.system/system/debug' removed '/var/opt/mssql/.system/system/system32/Microsoft/Protect/S-1-5-18/User/875bb28f-90c8-4291-85ff-84e2dc9a453f' removed '/var/opt/mssql/.system/system/system32/Microsoft/Protect/S-1-5-18/User/Preferred' removed directory '/var/opt/mssql/.system/system/system32/Microsoft/Protect/S-1-5-18/User' removed directory '/var/opt/mssql/.system/system/system32/Microsoft/Protect/S-1-5-18' removed directory '/var/opt/mssql/.system/system/system32/Microsoft/Protect' removed directory '/var/opt/mssql/.system/system/system32/Microsoft' removed directory '/var/opt/mssql/.system/system/system32/LogFiles/Scm' removed directory '/var/opt/mssql/.system/system/system32/LogFiles' removed directory '/var/opt/mssql/.system/system/system32' removed '/var/opt/mssql/.system/system/licensing.hiv' removed '/var/opt/mssql/.system/system/security.hiv' removed '/var/opt/mssql/.system/system/lsa.hiv' removed directory '/var/opt/mssql/.system/system' removed directory '/var/opt/mssql/.system/profiles/Client/Desktop' removed directory '/var/opt/mssql/.system/profiles/Client/Documents' removed directory '/var/opt/mssql/.system/profiles/Client/Temp' removed directory '/var/opt/mssql/.system/profiles/Client/AppData/Local/Microsoft/Windows/Temporary Internet Files' removed directory '/var/opt/mssql/.system/profiles/Client/AppData/Local/Microsoft/Windows' removed directory '/var/opt/mssql/.system/profiles/Client/AppData/Local/Microsoft' removed directory '/var/opt/mssql/.system/profiles/Client/AppData/Local' removed directory '/var/opt/mssql/.system/profiles/Client/AppData/Roaming/Microsoft/SystemCertificates/My/Certificates' removed directory '/var/opt/mssql/.system/profiles/Client/AppData/Roaming/Microsoft/SystemCertificates/My/CRLs' removed directory '/var/opt/mssql/.system/profiles/Client/AppData/Roaming/Microsoft/SystemCertificates/My/CTLs' removed '/var/opt/mssql/.system/profiles/Client/AppData/Roaming/Microsoft/SystemCertificates/My/AppContainerUserCertRead' removed directory '/var/opt/mssql/.system/profiles/Client/AppData/Roaming/Microsoft/SystemCertificates/My' removed directory '/var/opt/mssql/.system/profiles/Client/AppData/Roaming/Microsoft/SystemCertificates' removed directory '/var/opt/mssql/.system/profiles/Client/AppData/Roaming/Microsoft' removed directory '/var/opt/mssql/.system/profiles/Client/AppData/Roaming' removed directory '/var/opt/mssql/.system/profiles/Client/AppData/LocalLow' removed directory '/var/opt/mssql/.system/profiles/Client/AppData' removed directory '/var/opt/mssql/.system/profiles/Client' removed directory '/var/opt/mssql/.system/profiles' removed '/var/opt/mssql/.system/programdata/Microsoft/NetFramework/BreadcrumbStore/Microsoft.Diagnostics.Tracing.EventSource, Version=1.1.26.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' removed '/var/opt/mssql/.system/programdata/Microsoft/NetFramework/BreadcrumbStore/Microsoft.Diagnostics.Tracing.EventSource, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' removed directory '/var/opt/mssql/.system/programdata/Microsoft/NetFramework/BreadcrumbStore' removed directory '/var/opt/mssql/.system/programdata/Microsoft/NetFramework' removed directory '/var/opt/mssql/.system/programdata/Microsoft' removed directory '/var/opt/mssql/.system/programdata' removed '/var/opt/mssql/.system/instance_id' removed directory '/var/opt/mssql/.system' removed '/var/opt/mssql/data/master.mdf' removed '/var/opt/mssql/data/mastlog.ldf' removed '/var/opt/mssql/data/model.mdf' removed '/var/opt/mssql/data/modellog.ldf' removed '/var/opt/mssql/data/msdbdata.mdf' removed '/var/opt/mssql/data/msdblog.ldf' removed '/var/opt/mssql/data/model_replicatedmaster.mdf' removed '/var/opt/mssql/data/model_replicatedmaster.ldf' removed '/var/opt/mssql/data/model_msdbdata.mdf' removed '/var/opt/mssql/data/model_msdblog.ldf' removed '/var/opt/mssql/data/Entropy.bin' removed '/var/opt/mssql/data/tempdb.mdf' removed '/var/opt/mssql/data/templog.ldf' removed '/var/opt/mssql/data/tempdb2.ndf' removed '/var/opt/mssql/data/tempdb3.ndf' removed '/var/opt/mssql/data/tempdb4.ndf' removed directory '/var/opt/mssql/data' removed '/var/opt/mssql/log/mssql-conf/mssql-conf.log' removed directory '/var/opt/mssql/log/mssql-conf' removed '/var/opt/mssql/log/sqlagentstartup.log' removed '/var/opt/mssql/log/HkEngineEventFile_0_133989649991310000.xel' removed '/var/opt/mssql/log/system_health_0_133989649997400000.xel' removed '/var/opt/mssql/log/log.trc' removed '/var/opt/mssql/log/errorlog.2' removed '/var/opt/mssql/log/errorlog.1' removed '/var/opt/mssql/log/errorlog' removed '/var/opt/mssql/log/HkEngineEventFile_0_133989650032330000.xel' removed '/var/opt/mssql/log/system_health_0_133989650036790000.xel' removed '/var/opt/mssql/log/log_1.trc' removed directory '/var/opt/mssql/log' removed '/var/opt/mssql/mssql.conf' removed '/var/opt/mssql/secrets/machine-key' removed directory '/var/opt/mssql/secrets' removed directory '/var/opt/mssql' removed directory '/opt/mssql' removed directory '/opt/mssql-tools18' removed '/etc/yum.repos.d/packages-microsoft-com-mssql-server-2019.repo' removed '/etc/yum.repos.d/packages-microsoft-com-prod.repo' removed directory '/tmp/mssql_data' removed directory '/tmp/mssql_log' TASK [Stop the mssql-server service] ******************************************* task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:80 Wednesday 06 August 2025 10:44:00 -0400 (0:00:00.376) 0:01:40.171 ****** ok: [managed-node1] => { "changed": false, "cmd": "systemctl stop mssql-server || true", "delta": "0:00:00.012251", "end": "2025-08-06 10:44:00.495338", "rc": 0, "start": "2025-08-06 10:44:00.483087" } STDERR: Failed to stop mssql-server.service: Unit mssql-server.service not loaded. TASK [Get SELinux policy modules] ********************************************** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:85 Wednesday 06 August 2025 10:44:00 -0400 (0:00:00.414) 0:01:40.586 ****** ok: [managed-node1] => { "changed": false, "cmd": [ "semodule", "-l" ], "delta": "0:00:00.008520", "end": "2025-08-06 10:44:00.850807", "rc": 0, "start": "2025-08-06 10:44:00.842287" } STDOUT: abrt accountsd acct afs aiccu aide ajaxterm alsa amanda amtu anaconda antivirus apache apcupsd apm application arpwatch asterisk auditadm authconfig authlogin automount avahi awstats bacula base bcfg2 bind bitlbee blkmapd blueman bluetooth boinc boltd bootloader brctl brltty bugzilla bumblebee cachefilesd calamaris callweaver canna ccs cdrecord certmaster certmonger certwatch cfengine cgdcbxd cgroup chrome chronyd cinder cipe clock clogd cloudform cmirrord cobbler cockpit collectd colord comsat condor conman conntrackd consolekit couchdb courier cpucontrol cpufreqselector cpuplug cron ctdb cups cvs cyphesis cyrus daemontools dbadm dbskk dbus dcc ddclient denyhosts devicekit dhcp dictd dirsrv dirsrv-admin dmesg dmidecode dnsmasq dnssec dovecot drbd dspam entropyd exim fail2ban fcoe fetchmail finger firewalld firewallgui firstboot fprintd freeipmi freqset fstools ftp fwupd games gdomap geoclue getty git gitosis glance gnome gpg gpm gpsd gssproxy guest hddtemp hostapd hostname hsqldb hwloc hypervkvp ibacm icecast inetd init inn insights_client iodine iotop ipmievd ipsec iptables irc irqbalance iscsi isns jabber jetty jockey journalctl kdbus kdump kdumpgui keepalived kerberos keyboardd keystone kismet kmscon kpatch ksmtuned ktalk l2tp ldap libraries likewise linuxptp lircd livecd lldpad loadkeys locallogin lockdev logadm logging logrotate logwatch lpd lsm lttng-tools lvm mailman mailscanner man2html mandb mcelog mediawiki memcached milter minidlna minissdpd mip6d mirrormanager miscfiles mock modemmanager modutils mojomojo mon_statd mongodb motion mount mozilla mpd mplayer mrtg mta munin mysql mythtv naemon nagios namespace ncftool netlabel netutils networkmanager ninfod nis nova nscd nsd nslcd ntop ntp numad nut nx obex oddjob opafm openct opendnssec openfortivpn openhpid openshift openshift-origin opensm openvpn openvswitch openwsman oracleasm osad pads passenger pcmcia pcp pcscd pdns pegasus permissivedomains pesign pingd piranha pkcs pkcs11proxyd pki plymouthd podsleuth policykit polipo portmap portreserve postfix postgresql postgrey ppp prelink prelude privoxy procmail prosody psad ptchown publicfile pulseaudio puppet pwauth qmail qpid quantum quota rabbitmq radius radvd raid rasdaemon rdisc readahead realmd redis remotelogin restraint rhcs rhev rhgb rhnsd rhsmcertd rhts ricci rkhunter rkt rlogin rngd rolekit roundup rpc rpcbind rpm rrdcached rshd rssh rsync rtas rtkit rwho samba sambagui sandboxX sanlock sasl sbd sblim screen secadm sectoolm selinuxutil sendmail sensord setrans setroubleshoot seunshare sge shorewall slocate slpd smartmon smokeping smoltclient smsd snapper snmp snort sosreport soundserver spamassassin speech-dispatcher squid ssh sslh sssd staff stapserver stratisd stunnel su sudo svnserve swift sysadm sysadm_secadm sysnetwork sysstat systemd tangd targetd tcpd tcsd telepathy telnet tftp tgtd thin thumb timedatex tlp tmpreaper tomcat tor tuned tvtime udev ulogd uml unconfined unconfineduser unlabelednet unprivuser updfstab usbmodules usbmuxd userdomain userhelper usermanage usernetctl uucp uuidd varnishd vdagent vhostmd virt vlock vmtools vmware vnstatd vpn w3c watchdog wdmd webadm webalizer wine wireshark xen xguest xserver zabbix zarafa zebra zoneminder zosremote TASK [Ensure that semanage command is available] ******************************* task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:91 Wednesday 06 August 2025 10:44:00 -0400 (0:00:00.350) 0:01:40.937 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "'mssql' in __mssql_policy_loaded.stdout_lines", "skip_reason": "Conditional result was False" } TASK [Hack around broken mssql SELinux profile and actually remove it] ********* task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:99 Wednesday 06 August 2025 10:44:00 -0400 (0:00:00.027) 0:01:40.964 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "'mssql' in __mssql_policy_loaded.stdout_lines", "skip_reason": "Conditional result was False" } TASK [Check for leftover mssql processes] ************************************** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:108 Wednesday 06 August 2025 10:44:00 -0400 (0:00:00.027) 0:01:40.991 ****** ok: [managed-node1] => { "changed": false, "cmd": [ "pgrep", "-au", "mssql" ], "delta": "0:00:00.005768", "end": "2025-08-06 10:44:01.254497", "failed_when_result": false, "rc": 1, "start": "2025-08-06 10:44:01.248729" } MSG: non-zero return code TASK [Kill leftover mssql processes] ******************************************* task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:115 Wednesday 06 August 2025 10:44:01 -0400 (0:00:00.348) 0:01:41.340 ****** skipping: [managed-node1] => { "changed": false, "false_condition": "__mssql_processes.rc == 0", "skip_reason": "Conditional result was False" } TASK [Remove system user] ****************************************************** task path: /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:120 Wednesday 06 August 2025 10:44:01 -0400 (0:00:00.027) 0:01:41.367 ****** changed: [managed-node1] => { "changed": true, "force": false, "name": "mssql", "remove": true, "state": "absent" } STDERR: userdel: mssql mail spool (/var/spool/mail/mssql) not found userdel: mssql home directory (/var/opt/mssql) not found PLAY RECAP ********************************************************************* managed-node1 : ok=73 changed=14 unreachable=0 failed=1 skipped=97 rescued=0 ignored=0 SYSTEM ROLES ERRORS BEGIN v1 [ { "ansible_version": "2.16.14", "end_time": "2025-08-06T14:43:43.764614+00:00Z", "host": "managed-node1", "message": "Failed to download packages: mssql-server-fts-15.0.4435.7-2.x86_64: Cannot download, all mirrors were already tried without success", "start_time": "2025-08-06T14:43:40.763701+00:00Z", "task_name": "Ensure the package mssql-server-fts", "task_path": "/tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:876" } ] SYSTEM ROLES ERRORS END v1 TASKS RECAP ******************************************************************** Wednesday 06 August 2025 10:44:01 -0400 (0:00:00.552) 0:01:41.920 ****** =============================================================================== fedora.linux_system_roles.mssql : Ensure the package mssql-server ------ 44.62s /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:345 Remove related packages ------------------------------------------------- 5.66s /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:52 fedora.linux_system_roles.mssql : Set up MSSQL -------------------------- 5.08s /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:404 fedora.linux_system_roles.mssql : Ensure that SQL Server client tools are installed --- 4.96s /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:565 fedora.linux_system_roles.mssql : Configure to run as a confined application with SELinux --- 3.42s /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:340 fedora.linux_system_roles.mssql : Ensure the package mssql-server-fts --- 3.02s /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:876 fedora.linux_system_roles.mssql : Ensure that the tuned-profiles-mssql package is installed --- 3.00s /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:470 fedora.linux_system_roles.firewall : Install firewalld ------------------ 2.87s /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:51 fedora.linux_system_roles.mssql : Ensure that the tuned service is started and enabled --- 1.77s /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:476 fedora.linux_system_roles.mssql : Gather package facts ------------------ 1.69s /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:185 Gather package facts ---------------------------------------------------- 1.55s /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:3 fedora.linux_system_roles.mssql : Run systemctl ------------------------- 1.43s /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:22 fedora.linux_system_roles.firewall : Check if system is ostree ---------- 0.90s /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:10 Ensure ansible_facts to get ansible_distribution ------------------------ 0.78s /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:2 fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories --- 0.70s /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:238 fedora.linux_system_roles.mssql : Ensure the directory and permissions /tmp/mssql_log --- 0.63s /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/configure_storage_paths.yml:3 fedora.linux_system_roles.firewall : Check if transactional-update exists in /sbin --- 0.63s /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:22 fedora.linux_system_roles.mssql : Ensure the directory and permissions /tmp/mssql_data --- 0.57s /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/configure_storage_paths.yml:3 fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server repo version 2019 --- 0.55s /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:315 Remove system user ------------------------------------------------------ 0.55s /tmp/collections-3u7/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:120 -- Logs begin at Wed 2025-08-06 10:28:37 EDT, end at Wed 2025-08-06 10:44:02 EDT. -- Aug 06 10:42:19 managed-node1 sshd[62836]: Accepted publickey for root from 10.31.44.245 port 35082 ssh2: RSA SHA256:9j1blwt3wcrRiGYZQ7ZGu9axm3cDklH6/z4c+Ee8CzE Aug 06 10:42:19 managed-node1 systemd-logind[615]: New session 9 of user root. -- Subject: A new session 9 has been created for user root -- Defined-By: systemd -- Support: https://access.redhat.com/support -- Documentation: https://www.freedesktop.org/wiki/Software/systemd/multiseat -- -- A new session with the ID 9 has been created for the user root. -- -- The leading process of the session is 62836. Aug 06 10:42:19 managed-node1 systemd[1]: Started Session 9 of user root. -- Subject: Unit session-9.scope has finished start-up -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- Unit session-9.scope has finished starting up. -- -- The start-up result is done. Aug 06 10:42:19 managed-node1 sshd[62836]: pam_unix(sshd:session): session opened for user root by (uid=0) Aug 06 10:42:19 managed-node1 sshd[62839]: Received disconnect from 10.31.44.245 port 35082:11: disconnected by user Aug 06 10:42:19 managed-node1 sshd[62839]: Disconnected from user root 10.31.44.245 port 35082 Aug 06 10:42:19 managed-node1 sshd[62836]: pam_unix(sshd:session): session closed for user root Aug 06 10:42:19 managed-node1 systemd-logind[615]: Session 9 logged out. Waiting for processes to exit. Aug 06 10:42:19 managed-node1 systemd[1]: session-9.scope: Succeeded. -- Subject: Unit succeeded -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- The unit session-9.scope has successfully entered the 'dead' state. Aug 06 10:42:19 managed-node1 systemd-logind[615]: Removed session 9. -- Subject: Session 9 has been terminated -- Defined-By: systemd -- Support: https://access.redhat.com/support -- Documentation: https://www.freedesktop.org/wiki/Software/systemd/multiseat -- -- A session with the ID 9 has been terminated. Aug 06 10:42:20 managed-node1 platform-python[63001]: ansible-setup Invoked with gather_subset=['min'] gather_timeout=10 filter=[] fact_path=/etc/ansible/facts.d Aug 06 10:42:21 managed-node1 platform-python[63130]: ansible-ansible.legacy.command Invoked with _raw_params=systemctl is-system-running _uses_shell=False expand_argument_vars=True stdin_add_newline=True strip_empty_ends=True argv=None chdir=None executable=None creates=None removes=None stdin=None Aug 06 10:42:25 managed-node1 platform-python[63379]: ansible-rpm_key Invoked with key=https://packages.microsoft.com/keys/microsoft.asc state=present validate_certs=True fingerprint=None Aug 06 10:42:26 managed-node1 platform-python[63509]: ansible-yum_repository Invoked with name=packages-microsoft-com-mssql-server-2019 description=Microsoft SQL Server 2019 baseurl=['https://packages.microsoft.com/rhel/8/mssql-server-2019/'] gpgcheck=True reposdir=/etc/yum.repos.d state=present unsafe_writes=False bandwidth=None cost=None deltarpm_metadata_percentage=None deltarpm_percentage=None enabled=None enablegroups=None exclude=None failovermethod=None file=None gpgcakey=None gpgkey=None module_hotfixes=None http_caching=None include=None includepkgs=None ip_resolve=None keepalive=None keepcache=None metadata_expire=None metadata_expire_filter=None metalink=None mirrorlist=None mirrorlist_expire=None password=NOT_LOGGING_PARAMETER priority=None protect=None proxy=None proxy_password=NOT_LOGGING_PARAMETER proxy_username=None repo_gpgcheck=None retries=None s3_enabled=None skip_if_unavailable=None sslcacert=None ssl_check_cert_permissions=None sslclientcert=None sslclientkey=None sslverify=None throttle=None timeout=None ui_repoid_vars=None username=None async=None mode=None owner=None group=None seuser=None serole=None selevel=None setype=None attributes=None Aug 06 10:42:27 managed-node1 platform-python[63632]: ansible-ansible.legacy.dnf Invoked with name=['mssql-server-selinux'] state=absent allow_downgrade=False autoremove=False bugfix=False cacheonly=False disable_gpg_check=False disable_plugin=[] disablerepo=[] download_only=False enable_plugin=[] enablerepo=[] exclude=[] installroot=/ install_repoquery=True install_weak_deps=True security=False skip_broken=False update_cache=False update_only=False validate_certs=True sslverify=True lock_timeout=30 allowerasing=False nobest=False use_backend=auto conf_file=None disable_excludes=None download_dir=None list=None releasever=None Aug 06 10:42:30 managed-node1 platform-python[63757]: ansible-ansible.legacy.dnf Invoked with name=['mssql-server'] state=present allow_downgrade=False autoremove=False bugfix=False cacheonly=False disable_gpg_check=False disable_plugin=[] disablerepo=[] download_only=False enable_plugin=[] enablerepo=[] exclude=[] installroot=/ install_repoquery=True install_weak_deps=True security=False skip_broken=False update_cache=False update_only=False validate_certs=True sslverify=True lock_timeout=30 allowerasing=False nobest=False use_backend=auto conf_file=None disable_excludes=None download_dir=None list=None releasever=None Aug 06 10:42:49 managed-node1 systemd[1]: Reloading. Aug 06 10:43:13 managed-node1 useradd[63824]: new group: name=mssql, GID=989 Aug 06 10:43:13 managed-node1 useradd[63824]: new user: name=mssql, UID=993, GID=989, home=/var/opt/mssql, shell=/bin/bash Aug 06 10:43:13 managed-node1 systemd[1]: Reloading. Aug 06 10:43:14 managed-node1 systemd[1]: Started /usr/bin/systemctl start man-db-cache-update. -- Subject: Unit run-r1487068d24dd406d9bce10f4efa89a52.service has finished start-up -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- Unit run-r1487068d24dd406d9bce10f4efa89a52.service has finished starting up. -- -- The start-up result is done. Aug 06 10:43:14 managed-node1 systemd[1]: Starting man-db-cache-update.service... -- Subject: Unit man-db-cache-update.service has begun start-up -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- Unit man-db-cache-update.service has begun starting up. Aug 06 10:43:14 managed-node1 systemd[1]: Reloading. Aug 06 10:43:14 managed-node1 systemd[1]: man-db-cache-update.service: Succeeded. -- Subject: Unit succeeded -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- The unit man-db-cache-update.service has successfully entered the 'dead' state. Aug 06 10:43:14 managed-node1 systemd[1]: Started man-db-cache-update.service. -- Subject: Unit man-db-cache-update.service has finished start-up -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- Unit man-db-cache-update.service has finished starting up. -- -- The start-up result is done. Aug 06 10:43:14 managed-node1 systemd[1]: run-r1487068d24dd406d9bce10f4efa89a52.service: Succeeded. -- Subject: Unit succeeded -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- The unit run-r1487068d24dd406d9bce10f4efa89a52.service has successfully entered the 'dead' state. Aug 06 10:43:15 managed-node1 platform-python[64440]: ansible-ansible.legacy.command Invoked with _raw_params=set -euo pipefail errorlog="$(grep '^errorlogfile = ' /var/opt/mssql/mssql.conf \ | sed 's/errorlogfile : //')" || : if [ -s "${errorlog}" ]; then echo "${errorlog}" elif [ -s /var/opt/mssql/log/errorlog ]; then echo /var/opt/mssql/log/errorlog else echo "" fi _uses_shell=True expand_argument_vars=True stdin_add_newline=True strip_empty_ends=True argv=None chdir=None executable=None creates=None removes=None stdin=None Aug 06 10:43:15 managed-node1 platform-python[64567]: ansible-ansible.legacy.command Invoked with _raw_params=systemctl is-enabled mssql-server.service _uses_shell=False expand_argument_vars=True stdin_add_newline=True strip_empty_ends=True argv=None chdir=None executable=None creates=None removes=None stdin=None Aug 06 10:43:15 managed-node1 platform-python[64691]: ansible-ansible.legacy.command Invoked with _raw_params=systemctl is-active mssql-server.service _uses_shell=False expand_argument_vars=True stdin_add_newline=True strip_empty_ends=True argv=None chdir=None executable=None creates=None removes=None stdin=None Aug 06 10:43:16 managed-node1 su[64835]: (to mssql) root on pts/0 Aug 06 10:43:16 managed-node1 su[64835]: pam_unix(su:session): session opened for user mssql by root(uid=0) Aug 06 10:43:20 managed-node1 su[64835]: pam_unix(su:session): session closed for user mssql Aug 06 10:43:20 managed-node1 systemd[1]: Started Microsoft SQL Server Database Engine. -- Subject: Unit mssql-server.service has finished start-up -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- Unit mssql-server.service has finished starting up. -- -- The start-up result is done. Aug 06 10:43:20 managed-node1 systemd[1]: Reloading. Aug 06 10:43:21 managed-node1 platform-python[65209]: ansible-file Invoked with path=/tmp/mssql_data state=directory owner=mssql group=mssql mode=755 recurse=False force=False follow=True modification_time_format=%Y%m%d%H%M.%S access_time_format=%Y%m%d%H%M.%S unsafe_writes=False _original_basename=None _diff_peek=None src=None modification_time=None access_time=None seuser=None serole=None selevel=None setype=None attributes=None Aug 06 10:43:22 managed-node1 platform-python[65383]: ansible-ansible.legacy.command Invoked with _raw_params=grep '^defaultdatadir = ' /var/opt/mssql/mssql.conf _uses_shell=False expand_argument_vars=True stdin_add_newline=True strip_empty_ends=True argv=None chdir=None executable=None creates=None removes=None stdin=None Aug 06 10:43:22 managed-node1 sqlservr[65109]: 2025-08-06 10:43:22.73 Server Setup step is FORCE copying system data file 'C:\templatedata\model_replicatedmaster.mdf' to '/var/opt/mssql/data/model_replicatedmaster.mdf'. Aug 06 10:43:22 managed-node1 sqlservr[65109]: [178B blob data] Aug 06 10:43:22 managed-node1 sqlservr[65109]: [162B blob data] Aug 06 10:43:22 managed-node1 platform-python[65520]: ansible-ansible.legacy.command Invoked with _raw_params=/opt/mssql/bin/mssql-conf set filelocation.defaultdatadir /tmp/mssql_data _uses_shell=False expand_argument_vars=True stdin_add_newline=True strip_empty_ends=True argv=None chdir=None executable=None creates=None removes=None stdin=None Aug 06 10:43:22 managed-node1 sqlservr[65109]: [160B blob data] Aug 06 10:43:22 managed-node1 sqlservr[65109]: [108B blob data] Aug 06 10:43:22 managed-node1 sqlservr[65109]: [29B blob data] Aug 06 10:43:22 managed-node1 sqlservr[65109]: [49B blob data] Aug 06 10:43:22 managed-node1 sqlservr[65109]: [80B blob data] Aug 06 10:43:22 managed-node1 sqlservr[65109]: [57B blob data] Aug 06 10:43:22 managed-node1 sqlservr[65109]: [62B blob data] Aug 06 10:43:22 managed-node1 sqlservr[65109]: [56B blob data] Aug 06 10:43:22 managed-node1 sqlservr[65109]: [61B blob data] Aug 06 10:43:22 managed-node1 sqlservr[65109]: [102B blob data] Aug 06 10:43:22 managed-node1 sqlservr[65109]: [64B blob data] Aug 06 10:43:22 managed-node1 sqlservr[65109]: [43B blob data] Aug 06 10:43:22 managed-node1 sqlservr[65109]: [44B blob data] Aug 06 10:43:22 managed-node1 sqlservr[65109]: [40B blob data] Aug 06 10:43:22 managed-node1 sqlservr[65109]: [274B blob data] Aug 06 10:43:22 managed-node1 sqlservr[65109]: [155B blob data] Aug 06 10:43:22 managed-node1 sqlservr[65109]: [122B blob data] Aug 06 10:43:22 managed-node1 sqlservr[65109]: [84B blob data] Aug 06 10:43:22 managed-node1 sqlservr[65109]: [69B blob data] Aug 06 10:43:22 managed-node1 sqlservr[65109]: [93B blob data] Aug 06 10:43:22 managed-node1 sqlservr[65109]: [95B blob data] Aug 06 10:43:22 managed-node1 sqlservr[65109]: [102B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [557B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [86B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [118B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [281B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [212B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [81B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [94B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [274B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [41B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [126B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [81B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [71B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [96B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [66B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [50B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [161B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [66B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [157B blob data] Aug 06 10:43:23 managed-node1 platform-python[65672]: ansible-file Invoked with path=/tmp/mssql_log state=directory owner=mssql group=mssql mode=755 recurse=False force=False follow=True modification_time_format=%Y%m%d%H%M.%S access_time_format=%Y%m%d%H%M.%S unsafe_writes=False _original_basename=None _diff_peek=None src=None modification_time=None access_time=None seuser=None serole=None selevel=None setype=None attributes=None Aug 06 10:43:23 managed-node1 sqlservr[65109]: [161B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [92B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [80B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [138B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [138B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [77B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [134B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [96B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [100B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [159B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [217B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [64B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [79B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [153B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [96B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [65B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [158B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [155B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [61B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [104B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [80B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [80B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [78B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [84B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [122B blob data] Aug 06 10:43:23 managed-node1 sqlservr[65109]: [78B blob data] Aug 06 10:43:24 managed-node1 sqlservr[65109]: [84B blob data] Aug 06 10:43:24 managed-node1 sqlservr[65109]: [145B blob data] Aug 06 10:43:24 managed-node1 sqlservr[65109]: [96B blob data] Aug 06 10:43:24 managed-node1 sqlservr[65109]: [66B blob data] Aug 06 10:43:24 managed-node1 platform-python[65842]: ansible-ansible.legacy.command Invoked with _raw_params=grep '^defaultlogdir = ' /var/opt/mssql/mssql.conf _uses_shell=False expand_argument_vars=True stdin_add_newline=True strip_empty_ends=True argv=None chdir=None executable=None creates=None removes=None stdin=None Aug 06 10:43:24 managed-node1 sqlservr[65109]: [75B blob data] Aug 06 10:43:24 managed-node1 sqlservr[65109]: [96B blob data] Aug 06 10:43:24 managed-node1 sqlservr[65109]: [100B blob data] Aug 06 10:43:24 managed-node1 sqlservr[65109]: [71B blob data] Aug 06 10:43:24 managed-node1 sqlservr[65109]: [124B blob data] Aug 06 10:43:24 managed-node1 platform-python[65981]: ansible-ansible.legacy.command Invoked with _raw_params=/opt/mssql/bin/mssql-conf set filelocation.defaultlogdir /tmp/mssql_log _uses_shell=False expand_argument_vars=True stdin_add_newline=True strip_empty_ends=True argv=None chdir=None executable=None creates=None removes=None stdin=None Aug 06 10:43:25 managed-node1 platform-python[66111]: ansible-ansible.legacy.dnf Invoked with name=['tuned-profiles-mssql'] state=present allow_downgrade=False autoremove=False bugfix=False cacheonly=False disable_gpg_check=False disable_plugin=[] disablerepo=[] download_only=False enable_plugin=[] enablerepo=[] exclude=[] installroot=/ install_repoquery=True install_weak_deps=True security=False skip_broken=False update_cache=False update_only=False validate_certs=True sslverify=True lock_timeout=30 allowerasing=False nobest=False use_backend=auto conf_file=None disable_excludes=None download_dir=None list=None releasever=None Aug 06 10:43:28 managed-node1 platform-python[66235]: ansible-ansible.legacy.systemd Invoked with name=tuned state=started enabled=True daemon_reload=False daemon_reexec=False scope=system no_block=False force=None masked=None Aug 06 10:43:30 managed-node1 platform-python[66366]: ansible-slurp Invoked with path=/etc/tuned/active_profile src=/etc/tuned/active_profile Aug 06 10:43:30 managed-node1 platform-python[66489]: ansible-yum_repository Invoked with name=packages-microsoft-com-prod description=Microsoft SQL Server Tools baseurl=['https://packages.microsoft.com/rhel/8/prod/'] gpgcheck=True reposdir=/etc/yum.repos.d state=present unsafe_writes=False bandwidth=None cost=None deltarpm_metadata_percentage=None deltarpm_percentage=None enabled=None enablegroups=None exclude=None failovermethod=None file=None gpgcakey=None gpgkey=None module_hotfixes=None http_caching=None include=None includepkgs=None ip_resolve=None keepalive=None keepcache=None metadata_expire=None metadata_expire_filter=None metalink=None mirrorlist=None mirrorlist_expire=None password=NOT_LOGGING_PARAMETER priority=None protect=None proxy=None proxy_password=NOT_LOGGING_PARAMETER proxy_username=None repo_gpgcheck=None retries=None s3_enabled=None skip_if_unavailable=None sslcacert=None ssl_check_cert_permissions=None sslclientcert=None sslclientkey=None sslverify=None throttle=None timeout=None ui_repoid_vars=None username=None async=None mode=None owner=None group=None seuser=None serole=None selevel=None setype=None attributes=None Aug 06 10:43:31 managed-node1 platform-python[66612]: ansible-ansible.legacy.dnf Invoked with name=['mssql-tools18', 'unixODBC-devel'] state=present allow_downgrade=False autoremove=False bugfix=False cacheonly=False disable_gpg_check=False disable_plugin=[] disablerepo=[] download_only=False enable_plugin=[] enablerepo=[] exclude=[] installroot=/ install_repoquery=True install_weak_deps=True security=False skip_broken=False update_cache=False update_only=False validate_certs=True sslverify=True lock_timeout=30 allowerasing=False nobest=False use_backend=auto conf_file=None disable_excludes=None download_dir=None list=None releasever=None Aug 06 10:43:35 managed-node1 systemd[1]: Started /usr/bin/systemctl start man-db-cache-update. -- Subject: Unit run-reca970fcd767453980fa6d1df91596c0.service has finished start-up -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- Unit run-reca970fcd767453980fa6d1df91596c0.service has finished starting up. -- -- The start-up result is done. Aug 06 10:43:35 managed-node1 systemd[1]: Starting man-db-cache-update.service... -- Subject: Unit man-db-cache-update.service has begun start-up -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- Unit man-db-cache-update.service has begun starting up. Aug 06 10:43:35 managed-node1 systemd[1]: man-db-cache-update.service: Succeeded. -- Subject: Unit succeeded -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- The unit man-db-cache-update.service has successfully entered the 'dead' state. Aug 06 10:43:35 managed-node1 systemd[1]: Started man-db-cache-update.service. -- Subject: Unit man-db-cache-update.service has finished start-up -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- Unit man-db-cache-update.service has finished starting up. -- -- The start-up result is done. Aug 06 10:43:35 managed-node1 systemd[1]: run-reca970fcd767453980fa6d1df91596c0.service: Succeeded. -- Subject: Unit succeeded -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- The unit run-reca970fcd767453980fa6d1df91596c0.service has successfully entered the 'dead' state. Aug 06 10:43:36 managed-node1 platform-python[67115]: ansible-ansible.legacy.command Invoked with _raw_params=set -euo pipefail; grep '^forceencryption' /var/opt/mssql/mssql.conf | sed 's/forceencryption = //g' _uses_shell=True expand_argument_vars=True stdin_add_newline=True strip_empty_ends=True argv=None chdir=None executable=None creates=None removes=None stdin=None Aug 06 10:43:37 managed-node1 platform-python[67241]: ansible-ansible.legacy.command Invoked with _raw_params=grep '^ipaddress = ' /var/opt/mssql/mssql.conf _uses_shell=False expand_argument_vars=True stdin_add_newline=True strip_empty_ends=True argv=None chdir=None executable=None creates=None removes=None stdin=None Aug 06 10:43:38 managed-node1 platform-python[67365]: ansible-ansible.legacy.command Invoked with _raw_params=/opt/mssql/bin/mssql-conf set network.ipaddress 0.0.0.0 _uses_shell=False expand_argument_vars=True stdin_add_newline=True strip_empty_ends=True argv=None chdir=None executable=None creates=None removes=None stdin=None Aug 06 10:43:39 managed-node1 platform-python[67495]: ansible-ansible.legacy.command Invoked with _raw_params=grep '^tcpport = ' /var/opt/mssql/mssql.conf _uses_shell=False expand_argument_vars=True stdin_add_newline=True strip_empty_ends=True argv=None chdir=None executable=None creates=None removes=None stdin=None Aug 06 10:43:39 managed-node1 platform-python[67619]: ansible-ansible.legacy.command Invoked with _raw_params=/opt/mssql/bin/mssql-conf set network.tcpport 1433 _uses_shell=False expand_argument_vars=True stdin_add_newline=True strip_empty_ends=True argv=None chdir=None executable=None creates=None removes=None stdin=None Aug 06 10:43:40 managed-node1 platform-python[67749]: ansible-ansible.legacy.command Invoked with _raw_params=grep '^enabled = ' /var/opt/mssql/mssql.conf _uses_shell=False expand_argument_vars=True stdin_add_newline=True strip_empty_ends=True argv=None chdir=None executable=None creates=None removes=None stdin=None Aug 06 10:43:40 managed-node1 platform-python[67873]: ansible-ansible.legacy.command Invoked with _raw_params=/opt/mssql/bin/mssql-conf set sqlagent.enabled True _uses_shell=False expand_argument_vars=True stdin_add_newline=True strip_empty_ends=True argv=None chdir=None executable=None creates=None removes=None stdin=None Aug 06 10:43:41 managed-node1 platform-python[68003]: ansible-ansible.legacy.dnf Invoked with name=['mssql-server-fts'] state=present allow_downgrade=False autoremove=False bugfix=False cacheonly=False disable_gpg_check=False disable_plugin=[] disablerepo=[] download_only=False enable_plugin=[] enablerepo=[] exclude=[] installroot=/ install_repoquery=True install_weak_deps=True security=False skip_broken=False update_cache=False update_only=False validate_certs=True sslverify=True lock_timeout=30 allowerasing=False nobest=False use_backend=auto conf_file=None disable_excludes=None download_dir=None list=None releasever=None Aug 06 10:43:47 managed-node1 platform-python[68254]: ansible-stat Invoked with path=/run/ostree-booted follow=False get_checksum=True get_mime=True get_attributes=True checksum_algorithm=sha1 Aug 06 10:43:47 managed-node1 systemd[1]: Starting Cleanup of Temporary Directories... -- Subject: Unit systemd-tmpfiles-clean.service has begun start-up -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- Unit systemd-tmpfiles-clean.service has begun starting up. Aug 06 10:43:47 managed-node1 systemd[1]: systemd-tmpfiles-clean.service: Succeeded. -- Subject: Unit succeeded -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- The unit systemd-tmpfiles-clean.service has successfully entered the 'dead' state. Aug 06 10:43:47 managed-node1 systemd[1]: Started Cleanup of Temporary Directories. -- Subject: Unit systemd-tmpfiles-clean.service has finished start-up -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- Unit systemd-tmpfiles-clean.service has finished starting up. -- -- The start-up result is done. Aug 06 10:43:47 managed-node1 platform-python[68379]: ansible-stat Invoked with path=/sbin/transactional-update follow=False get_checksum=True get_mime=True get_attributes=True checksum_algorithm=sha1 Aug 06 10:43:48 managed-node1 platform-python[68502]: ansible-ansible.legacy.command Invoked with _raw_params=systemctl is-system-running _uses_shell=False expand_argument_vars=True stdin_add_newline=True strip_empty_ends=True argv=None chdir=None executable=None creates=None removes=None stdin=None Aug 06 10:43:48 managed-node1 platform-python[68626]: ansible-ansible.legacy.dnf Invoked with name=['firewalld'] state=present allow_downgrade=False autoremove=False bugfix=False cacheonly=False disable_gpg_check=False disable_plugin=[] disablerepo=[] download_only=False enable_plugin=[] enablerepo=[] exclude=[] installroot=/ install_repoquery=True install_weak_deps=True security=False skip_broken=False update_cache=False update_only=False validate_certs=True sslverify=True lock_timeout=30 allowerasing=False nobest=False use_backend=auto conf_file=None disable_excludes=None download_dir=None list=None releasever=None Aug 06 10:43:52 managed-node1 platform-python[68750]: ansible-systemd Invoked with name=firewalld masked=False daemon_reload=False daemon_reexec=False scope=system no_block=False state=None enabled=None force=None Aug 06 10:43:52 managed-node1 platform-python[68880]: ansible-ansible.legacy.systemd Invoked with name=firewalld enabled=True state=started daemon_reload=False daemon_reexec=False scope=system no_block=False force=None masked=None Aug 06 10:43:54 managed-node1 platform-python[69270]: ansible-ansible.legacy.dnf Invoked with name=['adutil', 'mssql-server*', 'mssql-tools*', 'unixODBC-devel', 'mssql-server-fts', 'mssql-server-ha', 'powershell'] state=absent autoremove=True allow_downgrade=False bugfix=False cacheonly=False disable_gpg_check=False disable_plugin=[] disablerepo=[] download_only=False enable_plugin=[] enablerepo=[] exclude=[] installroot=/ install_repoquery=True install_weak_deps=True security=False skip_broken=False update_cache=False update_only=False validate_certs=True sslverify=True lock_timeout=30 allowerasing=False nobest=False use_backend=auto conf_file=None disable_excludes=None download_dir=None list=None releasever=None Aug 06 10:43:57 managed-node1 systemd[1]: Reloading. Aug 06 10:43:57 managed-node1 systemd[1]: mssql-server.service: Current command vanished from the unit file, execution of the command list won't be resumed. Aug 06 10:43:57 managed-node1 systemd[1]: Stopping mssql-server.service... -- Subject: Unit mssql-server.service has begun shutting down -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- Unit mssql-server.service has begun shutting down. Aug 06 10:43:57 managed-node1 sqlservr[65109]: [200B blob data] Aug 06 10:43:57 managed-node1 sqlservr[65109]: [190B blob data] Aug 06 10:43:58 managed-node1 sqlservr[65109]: [73B blob data] Aug 06 10:43:58 managed-node1 sqlservr[65109]: [76B blob data] Aug 06 10:43:58 managed-node1 sqlservr[65109]: [164B blob data] Aug 06 10:43:58 managed-node1 sqlservr[65109]: [1B blob data] Aug 06 10:43:58 managed-node1 systemd[1]: mssql-server.service: Succeeded. -- Subject: Unit succeeded -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- The unit mssql-server.service has successfully entered the 'dead' state. Aug 06 10:43:58 managed-node1 systemd[1]: Stopped mssql-server.service. -- Subject: Unit mssql-server.service has finished shutting down -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- Unit mssql-server.service has finished shutting down. Aug 06 10:43:58 managed-node1 systemd[1]: Reloading. Aug 06 10:43:58 managed-node1 systemd[1]: Starting dnf makecache... -- Subject: Unit dnf-makecache.service has begun start-up -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- Unit dnf-makecache.service has begun starting up. Aug 06 10:43:58 managed-node1 systemd[1]: Reloading. Aug 06 10:43:58 managed-node1 dnf[69330]: Failed determining last makecache time. Aug 06 10:43:58 managed-node1 dnf[69330]: CentOS Stream 8 - AppStream 115 kB/s | 4.4 kB 00:00 Aug 06 10:43:58 managed-node1 dnf[69330]: CentOS Stream 8 - BaseOS 128 kB/s | 3.9 kB 00:00 Aug 06 10:43:59 managed-node1 dnf[69330]: CentOS Stream 8 - Extras 98 kB/s | 2.9 kB 00:00 Aug 06 10:43:59 managed-node1 dnf[69330]: CentOS Stream 8 - Extras common packages 99 kB/s | 3.0 kB 00:00 Aug 06 10:43:59 managed-node1 dnf[69330]: CentOS Stream 8 - HighAvailability 139 kB/s | 3.9 kB 00:00 Aug 06 10:43:59 managed-node1 dnf[69330]: Beaker Client - RedHatEnterpriseLinux8 73 kB/s | 1.5 kB 00:00 Aug 06 10:43:59 managed-node1 dnf[69330]: Beaker harness 251 kB/s | 1.3 kB 00:00 Aug 06 10:43:59 managed-node1 systemd[1]: Started /usr/bin/systemctl start man-db-cache-update. -- Subject: Unit run-r0cf23f5e328c438087ca3e32cc96e06e.service has finished start-up -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- Unit run-r0cf23f5e328c438087ca3e32cc96e06e.service has finished starting up. -- -- The start-up result is done. Aug 06 10:43:59 managed-node1 systemd[1]: Starting man-db-cache-update.service... -- Subject: Unit man-db-cache-update.service has begun start-up -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- Unit man-db-cache-update.service has begun starting up. Aug 06 10:43:59 managed-node1 dnf[69330]: Copr repo for beakerlib-libraries owned by bgon 12 kB/s | 1.8 kB 00:00 Aug 06 10:43:59 managed-node1 dnf[69330]: Extra Packages for Enterprise Linux 8 - x86_64 471 kB/s | 35 kB 00:00 Aug 06 10:43:59 managed-node1 systemd[1]: man-db-cache-update.service: Succeeded. -- Subject: Unit succeeded -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- The unit man-db-cache-update.service has successfully entered the 'dead' state. Aug 06 10:43:59 managed-node1 systemd[1]: Started man-db-cache-update.service. -- Subject: Unit man-db-cache-update.service has finished start-up -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- Unit man-db-cache-update.service has finished starting up. -- -- The start-up result is done. Aug 06 10:43:59 managed-node1 systemd[1]: run-r0cf23f5e328c438087ca3e32cc96e06e.service: Succeeded. -- Subject: Unit succeeded -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- The unit run-r0cf23f5e328c438087ca3e32cc96e06e.service has successfully entered the 'dead' state. Aug 06 10:43:59 managed-node1 dnf[69330]: Extra Packages for Enterprise Linux 8 - x86_64 270 kB/s | 20 kB 00:00 Aug 06 10:43:59 managed-node1 dnf[69330]: Extra Packages for Enterprise Linux 8 - x86_64 81 kB/s | 23 kB 00:00 Aug 06 10:44:00 managed-node1 platform-python[69865]: ansible-ansible.legacy.command Invoked with _raw_params=rm -rfv /var/opt/mssql* /opt/mssql* /var/log/pacemaker/pacemaker.log /etc/yum.repos.d/packages-microsoft-com-* /tmp/*.j2_* /tmp/mssql_data /tmp/mssql_log /etc/systemd/system/mssql-server.service.d /etc/systemd/system/multi-user.target.wants/mssql-server.service _uses_shell=True expand_argument_vars=True stdin_add_newline=True strip_empty_ends=True argv=None chdir=None executable=None creates=None removes=None stdin=None Aug 06 10:44:00 managed-node1 dnf[69330]: Microsoft SQL Server 2019 18 kB/s | 1.5 kB 00:00 Aug 06 10:44:00 managed-node1 dnf[69330]: Microsoft SQL Server Tools 33 kB/s | 1.5 kB 00:00 Aug 06 10:44:00 managed-node1 dnf[69330]: Copr repo for qa-tools owned by lpol 35 kB/s | 1.8 kB 00:00 Aug 06 10:44:00 managed-node1 platform-python[69992]: ansible-ansible.legacy.command Invoked with _raw_params=systemctl stop mssql-server || true _uses_shell=True expand_argument_vars=True stdin_add_newline=True strip_empty_ends=True argv=None chdir=None executable=None creates=None removes=None stdin=None Aug 06 10:44:00 managed-node1 platform-python[70118]: ansible-ansible.legacy.command Invoked with _raw_params=semodule -l _uses_shell=False expand_argument_vars=True stdin_add_newline=True strip_empty_ends=True argv=None chdir=None executable=None creates=None removes=None stdin=None Aug 06 10:44:01 managed-node1 platform-python[70242]: ansible-ansible.legacy.command Invoked with _raw_params=pgrep -au mssql _uses_shell=False expand_argument_vars=True stdin_add_newline=True strip_empty_ends=True argv=None chdir=None executable=None creates=None removes=None stdin=None Aug 06 10:44:01 managed-node1 platform-python[70366]: ansible-user Invoked with name=mssql state=absent remove=True non_unique=False force=False create_home=True system=False move_home=False append=False ssh_key_bits=0 ssh_key_type=rsa ssh_key_comment=ansible-generated on managed-node1 update_password=always uid=None group=None groups=None comment=None home=None shell=None password=NOT_LOGGING_PARAMETER login_class=None password_expire_max=None password_expire_min=None password_expire_warn=None hidden=None seuser=None skeleton=None generate_ssh_key=None ssh_key_file=None ssh_key_passphrase=NOT_LOGGING_PARAMETER expires=None password_lock=None local=None profile=None authorization=None role=None umask=None Aug 06 10:44:01 managed-node1 userdel[70371]: delete user 'mssql' Aug 06 10:44:01 managed-node1 userdel[70371]: removed group 'mssql' owned by 'mssql' Aug 06 10:44:01 managed-node1 userdel[70371]: removed shadow group 'mssql' owned by 'mssql' Aug 06 10:44:01 managed-node1 dnf[69330]: Metadata cache created. Aug 06 10:44:01 managed-node1 systemd[1]: dnf-makecache.service: Succeeded. -- Subject: Unit succeeded -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- The unit dnf-makecache.service has successfully entered the 'dead' state. Aug 06 10:44:01 managed-node1 systemd[1]: Started dnf makecache. -- Subject: Unit dnf-makecache.service has finished start-up -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- Unit dnf-makecache.service has finished starting up. -- -- The start-up result is done. Aug 06 10:44:02 managed-node1 sshd[70398]: Accepted publickey for root from 10.31.44.245 port 48216 ssh2: RSA SHA256:9j1blwt3wcrRiGYZQ7ZGu9axm3cDklH6/z4c+Ee8CzE Aug 06 10:44:02 managed-node1 systemd-logind[615]: New session 10 of user root. -- Subject: A new session 10 has been created for user root -- Defined-By: systemd -- Support: https://access.redhat.com/support -- Documentation: https://www.freedesktop.org/wiki/Software/systemd/multiseat -- -- A new session with the ID 10 has been created for the user root. -- -- The leading process of the session is 70398. Aug 06 10:44:02 managed-node1 systemd[1]: Started Session 10 of user root. -- Subject: Unit session-10.scope has finished start-up -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- Unit session-10.scope has finished starting up. -- -- The start-up result is done. Aug 06 10:44:02 managed-node1 sshd[70398]: pam_unix(sshd:session): session opened for user root by (uid=0) Aug 06 10:44:02 managed-node1 sshd[70401]: Received disconnect from 10.31.44.245 port 48216:11: disconnected by user Aug 06 10:44:02 managed-node1 sshd[70401]: Disconnected from user root 10.31.44.245 port 48216 Aug 06 10:44:02 managed-node1 sshd[70398]: pam_unix(sshd:session): session closed for user root Aug 06 10:44:02 managed-node1 systemd-logind[615]: Session 10 logged out. Waiting for processes to exit. Aug 06 10:44:02 managed-node1 systemd[1]: session-10.scope: Succeeded. -- Subject: Unit succeeded -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- The unit session-10.scope has successfully entered the 'dead' state. Aug 06 10:44:02 managed-node1 systemd-logind[615]: Removed session 10. -- Subject: Session 10 has been terminated -- Defined-By: systemd -- Support: https://access.redhat.com/support -- Documentation: https://www.freedesktop.org/wiki/Software/systemd/multiseat -- -- A session with the ID 10 has been terminated. Aug 06 10:44:02 managed-node1 sshd[70422]: Accepted publickey for root from 10.31.44.245 port 48222 ssh2: RSA SHA256:9j1blwt3wcrRiGYZQ7ZGu9axm3cDklH6/z4c+Ee8CzE Aug 06 10:44:02 managed-node1 systemd-logind[615]: New session 11 of user root. -- Subject: A new session 11 has been created for user root -- Defined-By: systemd -- Support: https://access.redhat.com/support -- Documentation: https://www.freedesktop.org/wiki/Software/systemd/multiseat -- -- A new session with the ID 11 has been created for the user root. -- -- The leading process of the session is 70422. Aug 06 10:44:02 managed-node1 systemd[1]: Started Session 11 of user root. -- Subject: Unit session-11.scope has finished start-up -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- Unit session-11.scope has finished starting up. -- -- The start-up result is done. Aug 06 10:44:02 managed-node1 sshd[70422]: pam_unix(sshd:session): session opened for user root by (uid=0)