ansible-playbook 2.9.27 config file = None configured module search path = ['/root/.ansible/plugins/modules', '/usr/share/ansible/plugins/modules'] ansible python module location = /usr/local/lib/python3.9/site-packages/ansible executable location = /usr/local/bin/ansible-playbook python version = 3.9.19 (main, May 16 2024, 11:40:09) [GCC 8.5.0 20210514 (Red Hat 8.5.0-22)] No config file found; using defaults [WARNING]: running playbook inside collection fedora.linux_system_roles Skipping callback 'actionable', as we already have a stdout callback. Skipping callback 'counter_enabled', as we already have a stdout callback. Skipping callback 'debug', as we already have a stdout callback. Skipping callback 'dense', as we already have a stdout callback. Skipping callback 'dense', as we already have a stdout callback. Skipping callback 'full_skip', as we already have a stdout callback. Skipping callback 'json', as we already have a stdout callback. Skipping callback 'jsonl', as we already have a stdout callback. Skipping callback 'minimal', as we already have a stdout callback. Skipping callback 'null', as we already have a stdout callback. Skipping callback 'oneline', as we already have a stdout callback. Skipping callback 'selective', as we already have a stdout callback. Skipping callback 'skippy', as we already have a stdout callback. Skipping callback 'stderr', as we already have a stdout callback. Skipping callback 'unixy', as we already have a stdout callback. Skipping callback 'yaml', as we already have a stdout callback. PLAYBOOK: tests_idempotency_2019.yml ******************************************* 1 plays in /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_idempotency_2019.yml PLAY [Ensure that the role is idempotent] ************************************** META: ran handlers TASK [Run tests_idempotency with SQL Server 2019] ****************************** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_idempotency_2019.yml:15 Wednesday 06 August 2025 10:42:56 -0400 (0:00:00.074) 0:00:00.074 ****** included: /tmp/collections-bPe/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-bPe/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_idempotency.yml:2 Wednesday 06 August 2025 10:42:56 -0400 (0:00:00.030) 0:00:00.104 ****** included: /tmp/collections-bPe/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-bPe/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:2 Wednesday 06 August 2025 10:42:56 -0400 (0:00:00.055) 0:00:00.159 ****** ok: [managed-node1] TASK [Run the role] ************************************************************ task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:16 Wednesday 06 August 2025 10:42:57 -0400 (0:00:00.940) 0:00:01.100 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [Unreachable task] ******************************************************** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:23 Wednesday 06 August 2025 10:42:57 -0400 (0:00:00.017) 0:00:01.118 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [Run on a fresh host and set all parameters] ****************************** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_idempotency.yml:5 Wednesday 06 August 2025 10:42:57 -0400 (0:00:00.021) 0:00:01.139 ****** TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3 Wednesday 06 August 2025 10:42:57 -0400 (0:00:00.343) 0:00:01.483 ****** included: /tmp/collections-bPe/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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 Wednesday 06 August 2025 10:42:57 -0400 (0:00:00.030) 0:00:01.513 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Set platform/version specific variables] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8 Wednesday 06 August 2025 10:42:57 -0400 (0:00:00.033) 0:00:01.546 ****** 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-bPe/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, "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-bPe/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-bPe/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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:22 Wednesday 06 August 2025 10:42:57 -0400 (0:00:00.065) 0:00:01.612 ****** ok: [managed-node1] => { "changed": false, "cmd": [ "systemctl", "is-system-running" ], "delta": "0:00:00.007892", "end": "2025-08-06 10:42:58.323912", "failed_when_result": false, "rc": 0, "start": "2025-08-06 10:42:58.316020" } STDOUT: running TASK [fedora.linux_system_roles.mssql : Require installed systemd] ************* task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:29 Wednesday 06 August 2025 10:42:58 -0400 (0:00:00.781) 0:00:02.394 ****** skipping: [managed-node1] => { "changed": false, "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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:34 Wednesday 06 August 2025 10:42:58 -0400 (0:00:00.048) 0:00:02.443 ****** 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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8 Wednesday 06 August 2025 10:42:58 -0400 (0:00:00.029) 0:00:02.472 ****** 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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:16 Wednesday 06 August 2025 10:42:58 -0400 (0:00:00.020) 0:00:02.492 ****** skipping: [managed-node1] => {} TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_input_sql_file fact] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:24 Wednesday 06 August 2025 10:42:58 -0400 (0:00:00.029) 0:00:02.522 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Print that the variable is deprecated] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:31 Wednesday 06 August 2025 10:42:58 -0400 (0:00:00.024) 0:00:02.547 ****** skipping: [managed-node1] => {} TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_ha_listener_port fact] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:38 Wednesday 06 August 2025 10:42:58 -0400 (0:00:00.023) 0:00:02.570 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Print that the mssql_ad_sql_user_name variable is deprecated] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:45 Wednesday 06 August 2025 10:42:58 -0400 (0:00:00.022) 0:00:02.593 ****** skipping: [managed-node1] => {} TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_ad_sql_user_name fact] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:52 Wednesday 06 August 2025 10:42:58 -0400 (0:00:00.023) 0:00:02.616 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Print that the mssql_ha_cluster_run_role variable is deprecated] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:59 Wednesday 06 August 2025 10:42:58 -0400 (0:00:00.022) 0:00:02.638 ****** skipping: [managed-node1] => {} TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_ha_cluster_run_role fact] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:66 Wednesday 06 August 2025 10:42:58 -0400 (0:00:00.020) 0:00:02.659 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Print that variable is deprecated] ***** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:75 Wednesday 06 August 2025 10:42:58 -0400 (0:00:00.030) 0:00:02.689 ****** skipping: [managed-node1] => {} TASK [fedora.linux_system_roles.mssql : Link the deprecated fact] ************** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:84 Wednesday 06 August 2025 10:42:58 -0400 (0:00:00.034) 0:00:02.724 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Fail on RHEL or CentOS 10 because it's not supported] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:88 Wednesday 06 August 2025 10:42:58 -0400 (0:00:00.022) 0:00:02.747 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify that the user accepts EULA variables] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:95 Wednesday 06 August 2025 10:42:58 -0400 (0:00:00.025) 0:00:02.773 ****** 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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:107 Wednesday 06 August 2025 10:42:58 -0400 (0:00:00.031) 0:00:02.804 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify if the mssql_ha_replica_type variable is provided correctly] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:115 Wednesday 06 August 2025 10:42:58 -0400 (0:00:00.020) 0:00:02.825 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify that 'mssql_ha_replica_type = primary' is provided once] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:124 Wednesday 06 August 2025 10:42:58 -0400 (0:00:00.021) 0:00:02.847 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify that mssql_ha_prep_for_pacemaker is provided correctly] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:133 Wednesday 06 August 2025 10:42:58 -0400 (0:00:00.021) 0:00:02.868 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify that selinux variables are used on supported platforms] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:143 Wednesday 06 August 2025 10:42:58 -0400 (0:00:00.018) 0:00:02.887 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify that mssql_manage_selinux is set properly] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:152 Wednesday 06 August 2025 10:42:58 -0400 (0:00:00.031) 0:00:02.918 ****** skipping: [managed-node1] => { "changed": false, "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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:163 Wednesday 06 August 2025 10:42:58 -0400 (0:00:00.028) 0:00:02.947 ****** skipping: [managed-node1] => { "changed": false, "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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:174 Wednesday 06 August 2025 10:42:59 -0400 (0:00:00.022) 0:00:02.969 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Gather package facts] ****************** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:185 Wednesday 06 August 2025 10:42:59 -0400 (0:00:00.023) 0:00:02.993 ****** 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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:189 Wednesday 06 August 2025 10:43:00 -0400 (0:00:01.869) 0:00:04.862 ****** skipping: [managed-node1] => (item={'key': 2017, 'value': 14}) => { "ansible_loop_var": "item", "changed": false, "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, "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, "item": { "key": 2022, "value": 16 }, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify if mssql_version is not bigger then the existing SQL Server version] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:197 Wednesday 06 August 2025 10:43:00 -0400 (0:00:00.094) 0:00:04.957 ****** skipping: [managed-node1] => { "changed": false, "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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:210 Wednesday 06 August 2025 10:43:01 -0400 (0:00:00.062) 0:00:05.020 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify if the mssql_version variable is provided correctly] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:217 Wednesday 06 August 2025 10:43:01 -0400 (0:00:00.046) 0:00:05.066 ****** 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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:224 Wednesday 06 August 2025 10:43:01 -0400 (0:00:00.056) 0:00:05.122 ****** skipping: [managed-node1] => (item={'key': 2017, 'value': 14}) => { "ansible_loop_var": "item", "changed": false, "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, "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, "item": { "key": 2022, "value": 16 }, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:238 Wednesday 06 August 2025 10:43:01 -0400 (0:00:00.101) 0:00:05.223 ****** 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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:252 Wednesday 06 August 2025 10:43:02 -0400 (0:00:00.786) 0:00:06.010 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Get yum repositories] ****************** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:262 Wednesday 06 August 2025 10:43:02 -0400 (0:00:00.032) 0:00:06.042 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Remove the current Microsoft SQL Server repository to upgrade to 2019] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:273 Wednesday 06 August 2025 10:43:02 -0400 (0:00:00.033) 0:00:06.075 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Update all packages from SQL Server repo version {{ __mssql_current_version }}] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:287 Wednesday 06 August 2025 10:43:02 -0400 (0:00:00.036) 0:00:06.112 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Get zypper repositories] *************** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:296 Wednesday 06 August 2025 10:43:02 -0400 (0:00:00.053) 0:00:06.166 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Remove the current Microsoft SQL Server repository to upgrade to 2019] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:308 Wednesday 06 August 2025 10:43:02 -0400 (0:00:00.053) 0:00:06.219 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server repo version 2019] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:315 Wednesday 06 August 2025 10:43:02 -0400 (0:00:00.048) 0:00:06.268 ****** 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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:327 Wednesday 06 August 2025 10:43:02 -0400 (0:00:00.511) 0:00:06.779 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Configure to run as a confined application with SELinux] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:340 Wednesday 06 August 2025 10:43:02 -0400 (0:00:00.039) 0:00:06.819 ****** 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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:345 Wednesday 06 August 2025 10:43:06 -0400 (0:00:03.245) 0:00:10.064 ****** 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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:350 Wednesday 06 August 2025 10:43:40 -0400 (0:00:34.312) 0:00:44.377 ****** 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.005272", "end": "2025-08-06 10:43:40.720983", "rc": 0, "start": "2025-08-06 10:43:40.715711" } TASK [fedora.linux_system_roles.mssql : Check if mssql-server.service is enabled] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:367 Wednesday 06 August 2025 10:43:40 -0400 (0:00:00.371) 0:00:44.749 ****** ok: [managed-node1] => { "changed": false, "cmd": [ "systemctl", "is-enabled", "mssql-server.service" ], "delta": "0:00:00.010264", "end": "2025-08-06 10:43:41.093659", "failed_when_result": false, "rc": 1, "start": "2025-08-06 10:43:41.083395" } STDOUT: disabled MSG: non-zero return code TASK [fedora.linux_system_roles.mssql : Check if mssql-server.service is running] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:374 Wednesday 06 August 2025 10:43:41 -0400 (0:00:00.364) 0:00:45.113 ****** ok: [managed-node1] => { "changed": false, "cmd": [ "systemctl", "is-active", "mssql-server.service" ], "delta": "0:00:00.008981", "end": "2025-08-06 10:43:41.458034", "failed_when_result": false, "rc": 3, "start": "2025-08-06 10:43:41.449053" } STDOUT: inactive MSG: non-zero return code TASK [fedora.linux_system_roles.mssql : Set the __mssql_is_setup variable] ***** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:381 Wednesday 06 August 2025 10:43:41 -0400 (0:00:00.370) 0:00:45.483 ****** 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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:388 Wednesday 06 August 2025 10:43:41 -0400 (0:00:00.054) 0:00:45.537 ****** ok: [managed-node1] => { "changed": false } MSG: All assertions passed TASK [fedora.linux_system_roles.mssql : Set up MSSQL] ************************** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:404 Wednesday 06 August 2025 10:43:41 -0400 (0:00:00.077) 0:00:45.614 ****** 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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:430 Wednesday 06 August 2025 10:43:46 -0400 (0:00:05.151) 0:00:50.766 ****** included: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/configure_storage_paths.yml for managed-node1 included: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/configure_storage_paths.yml for managed-node1 TASK [fedora.linux_system_roles.mssql : Ensure the directory and permissions /tmp/mssql_data] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/configure_storage_paths.yml:3 Wednesday 06 August 2025 10:43:46 -0400 (0:00:00.077) 0:00:50.843 ****** 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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/configure_storage_paths.yml:12 Wednesday 06 August 2025 10:43:47 -0400 (0:00:00.542) 0:00:51.386 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Configure the setting defaultdatadir] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/configure_storage_paths.yml:28 Wednesday 06 August 2025 10:43:47 -0400 (0:00:00.040) 0:00:51.427 ****** included: /tmp/collections-bPe/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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:3 Wednesday 06 August 2025 10:43:47 -0400 (0:00:00.057) 0:00:51.484 ****** ok: [managed-node1] => { "changed": false, "cmd": [ "grep", "^defaultdatadir = ", "/var/opt/mssql/mssql.conf" ], "delta": "0:00:00.002537", "end": "2025-08-06 10:43:47.886231", "failed_when_result": false, "rc": 1, "start": "2025-08-06 10:43:47.883694" } MSG: non-zero return code TASK [fedora.linux_system_roles.mssql : Configure the setting filelocation defaultdatadir] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:12 Wednesday 06 August 2025 10:43:47 -0400 (0:00:00.434) 0:00:51.919 ****** NOTIFIED HANDLER fedora.linux_system_roles.mssql : Restart the mssql-server service for managed-node1 changed: [managed-node1] => { "changed": true, "cmd": [ "/opt/mssql/bin/mssql-conf", "set", "filelocation.defaultdatadir", "/tmp/mssql_data" ], "delta": "0:00:00.118722", "end": "2025-08-06 10:43:48.461640", "failed_when_result": false, "rc": 0, "start": "2025-08-06 10:43:48.342918" } 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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:42 Wednesday 06 August 2025 10:43:48 -0400 (0:00:00.579) 0:00:52.499 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Ensure the directory and permissions /tmp/mssql_log] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/configure_storage_paths.yml:3 Wednesday 06 August 2025 10:43:48 -0400 (0:00:00.034) 0:00:52.534 ****** 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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/configure_storage_paths.yml:12 Wednesday 06 August 2025 10:43:49 -0400 (0:00:00.427) 0:00:52.962 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Configure the setting defaultlogdir] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/configure_storage_paths.yml:28 Wednesday 06 August 2025 10:43:49 -0400 (0:00:00.054) 0:00:53.016 ****** included: /tmp/collections-bPe/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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:3 Wednesday 06 August 2025 10:43:49 -0400 (0:00:00.090) 0:00:53.107 ****** ok: [managed-node1] => { "changed": false, "cmd": [ "grep", "^defaultlogdir = ", "/var/opt/mssql/mssql.conf" ], "delta": "0:00:00.002678", "end": "2025-08-06 10:43:49.698253", "failed_when_result": false, "rc": 1, "start": "2025-08-06 10:43:49.695575" } MSG: non-zero return code TASK [fedora.linux_system_roles.mssql : Configure the setting filelocation defaultlogdir] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:12 Wednesday 06 August 2025 10:43:49 -0400 (0:00:00.626) 0:00:53.734 ****** changed: [managed-node1] => { "changed": true, "cmd": [ "/opt/mssql/bin/mssql-conf", "set", "filelocation.defaultlogdir", "/tmp/mssql_log" ], "delta": "0:00:00.105067", "end": "2025-08-06 10:43:50.234423", "failed_when_result": false, "rc": 0, "start": "2025-08-06 10:43:50.129356" } 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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:42 Wednesday 06 August 2025 10:43:50 -0400 (0:00:00.530) 0:00:54.264 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Set selinux role facts for ports] ****** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:445 Wednesday 06 August 2025 10:43:50 -0400 (0:00:00.032) 0:00:54.297 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [Ensure correct SELinux context for storage paths and ports] ************** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:459 Wednesday 06 August 2025 10:43:50 -0400 (0:00:00.030) 0:00:54.328 ****** skipping: [managed-node1] => { "changed": false, "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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:470 Wednesday 06 August 2025 10:43:50 -0400 (0:00:00.062) 0:00:54.390 ****** 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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:476 Wednesday 06 August 2025 10:43:53 -0400 (0:00:02.823) 0:00:57.214 ****** ok: [managed-node1] => { "changed": false, "enabled": true, "name": "tuned", "state": "started", "status": { "ActiveEnterTimestamp": "Wed 2025-08-06 10:29:00 EDT", "ActiveEnterTimestampMonotonic": "10573816", "ActiveExitTimestampMonotonic": "0", "ActiveState": "active", "After": "dbus.service network.target sysinit.target dbus.socket basic.target polkit.service systemd-journald.socket systemd-sysctl.service system.slice", "AllowIsolate": "no", "AllowedCPUs": "", "AllowedMemoryNodes": "", "AmbientCapabilities": "", "AssertResult": "yes", "AssertTimestamp": "Wed 2025-08-06 10:29:00 EDT", "AssertTimestampMonotonic": "10049535", "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:29:00 EDT", "ConditionTimestampMonotonic": "10049534", "ConfigurationDirectoryMode": "0755", "Conflicts": "cpupower.service auto-cpufreq.service shutdown.target power-profiles-daemon.service tlp.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": "721", "ExecMainStartTimestamp": "Wed 2025-08-06 10:29:00 EDT", "ExecMainStartTimestampMonotonic": "10050282", "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:29:00 EDT", "InactiveExitTimestampMonotonic": "10050325", "InvocationID": "2f90d839caaa462b8da92587b434b2b3", "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": "721", "MemoryAccounting": "yes", "MemoryCurrent": "21164032", "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": "system.slice sysinit.target dbus.socket dbus.service", "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:29:00 EDT", "StateChangeTimestampMonotonic": "10573816", "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:29:00 EDT", "WatchdogTimestampMonotonic": "10573813", "WatchdogUSec": "0" } } TASK [fedora.linux_system_roles.mssql : Get the active Tuned profiles] ********* task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:483 Wednesday 06 August 2025 10:43:54 -0400 (0:00:00.744) 0:00:57.958 ****** 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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:489 Wednesday 06 August 2025 10:43:54 -0400 (0:00:00.488) 0:00:58.447 ****** 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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:502 Wednesday 06 August 2025 10:43:54 -0400 (0:00:00.036) 0:00:58.483 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Remove troublemaking include from the mssql profile] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:514 Wednesday 06 August 2025 10:43:54 -0400 (0:00:00.033) 0:00:58.517 ****** skipping: [managed-node1] => { "changed": false, "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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:523 Wednesday 06 August 2025 10:43:54 -0400 (0:00:00.036) 0:00:58.554 ****** skipping: [managed-node1] => { "changed": false, "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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:540 Wednesday 06 August 2025 10:43:54 -0400 (0:00:00.035) 0:00:58.589 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server Tools repository] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:548 Wednesday 06 August 2025 10:43:54 -0400 (0:00:00.064) 0:00:58.654 ****** 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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:556 Wednesday 06 August 2025 10:43:55 -0400 (0:00:00.421) 0:00:59.075 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Ensure that SQL Server client tools are installed] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:565 Wednesday 06 August 2025 10:43:55 -0400 (0:00:00.039) 0:00:59.115 ****** 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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:582 Wednesday 06 August 2025 10:43:58 -0400 (0:00:03.779) 0:01:02.895 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Set certificate_requests] ************** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:586 Wednesday 06 August 2025 10:43:58 -0400 (0:00:00.047) 0:01:02.942 ****** TASK [Create certificates using the certificate role] ************************** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:597 Wednesday 06 August 2025 10:43:59 -0400 (0:00:00.043) 0:01:02.986 ****** skipping: [managed-node1] => { "changed": false, "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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:603 Wednesday 06 August 2025 10:43:59 -0400 (0:00:00.048) 0:01:03.034 ****** skipping: [managed-node1] => { "changed": false, "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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:608 Wednesday 06 August 2025 10:43:59 -0400 (0:00:00.048) 0:01:03.082 ****** skipping: [managed-node1] => (item=None) => { "ansible_loop_var": "item", "changed": false, "item": null, "skip_reason": "Conditional result was False" } skipping: [managed-node1] => (item=None) => { "ansible_loop_var": "item", "changed": false, "item": null, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Configure the tlscert setting] ********* task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:626 Wednesday 06 August 2025 10:43:59 -0400 (0:00:00.095) 0:01:03.178 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Configure the tlskey setting] ********** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:635 Wednesday 06 August 2025 10:43:59 -0400 (0:00:00.049) 0:01:03.227 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Configure the tlsprotocols setting] **** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:644 Wednesday 06 August 2025 10:43:59 -0400 (0:00:00.050) 0:01:03.277 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Configure the forceencryption setting] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:651 Wednesday 06 August 2025 10:43:59 -0400 (0:00:00.049) 0:01:03.327 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Get the setting forceencryption] ******* task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:660 Wednesday 06 August 2025 10:43:59 -0400 (0:00:00.064) 0:01:03.391 ****** ok: [managed-node1] => { "changed": false, "cmd": "set -euo pipefail; grep '^forceencryption' /var/opt/mssql/mssql.conf | sed 's/forceencryption = //g'", "delta": "0:00:00.004084", "end": "2025-08-06 10:43:59.792820", "failed_when_result": false, "rc": 1, "start": "2025-08-06 10:43:59.788736" } MSG: non-zero return code TASK [fedora.linux_system_roles.mssql : Append -No to sqlcmd when TLS is not configured] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:669 Wednesday 06 August 2025 10:43:59 -0400 (0:00:00.444) 0:01:03.836 ****** 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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:676 Wednesday 06 August 2025 10:43:59 -0400 (0:00:00.070) 0:01:03.906 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Prepare MSSQL and facts for logging in] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:689 Wednesday 06 August 2025 10:44:00 -0400 (0:00:00.056) 0:01:03.963 ****** skipping: [managed-node1] => { "changed": false, "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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:693 Wednesday 06 August 2025 10:44:00 -0400 (0:00:00.048) 0:01:04.012 ****** skipping: [managed-node1] => { "changed": false, "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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:699 Wednesday 06 August 2025 10:44:00 -0400 (0:00:00.050) 0:01:04.062 ****** 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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:708 Wednesday 06 August 2025 10:44:00 -0400 (0:00:00.048) 0:01:04.111 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Gather package facts] ****************** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:717 Wednesday 06 August 2025 10:44:00 -0400 (0:00:00.051) 0:01:04.162 ****** 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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:725 Wednesday 06 August 2025 10:44:00 -0400 (0:00:00.051) 0:01:04.214 ****** 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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:746 Wednesday 06 August 2025 10:44:00 -0400 (0:00:00.047) 0:01:04.261 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Pre-input SQL script contents to SQL Server] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:755 Wednesday 06 August 2025 10:44:00 -0400 (0:00:00.049) 0:01:04.311 ****** skipping: [managed-node1] => { "changed": false, "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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:768 Wednesday 06 August 2025 10:44:00 -0400 (0:00:00.037) 0:01:04.348 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Ensure that the mssql-server service is stopped] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:783 Wednesday 06 August 2025 10:44:00 -0400 (0:00:00.032) 0:01:04.380 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Gather package facts] ****************** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:792 Wednesday 06 August 2025 10:44:00 -0400 (0:00:00.037) 0:01:04.418 ****** 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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:798 Wednesday 06 August 2025 10:44:00 -0400 (0:00:00.049) 0:01:04.468 ****** 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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:817 Wednesday 06 August 2025 10:44:00 -0400 (0:00:00.046) 0:01:04.514 ****** included: /tmp/collections-bPe/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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:3 Wednesday 06 August 2025 10:44:00 -0400 (0:00:00.087) 0:01:04.602 ****** ok: [managed-node1] => { "changed": false, "cmd": [ "grep", "^ipaddress = ", "/var/opt/mssql/mssql.conf" ], "delta": "0:00:00.002385", "end": "2025-08-06 10:44:00.945859", "failed_when_result": false, "rc": 1, "start": "2025-08-06 10:44:00.943474" } MSG: non-zero return code TASK [fedora.linux_system_roles.mssql : Configure the setting network ipaddress] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:12 Wednesday 06 August 2025 10:44:01 -0400 (0:00:00.365) 0:01:04.968 ****** changed: [managed-node1] => { "changed": true, "cmd": [ "/opt/mssql/bin/mssql-conf", "set", "network.ipaddress", "0.0.0.0" ], "delta": "0:00:00.107804", "end": "2025-08-06 10:44:01.424719", "failed_when_result": false, "rc": 0, "start": "2025-08-06 10:44:01.316915" } 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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:42 Wednesday 06 August 2025 10:44:01 -0400 (0:00:00.485) 0:01:05.453 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Register the previous tcpport setting] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:824 Wednesday 06 August 2025 10:44:01 -0400 (0:00:00.032) 0:01:05.485 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [Open the TCP port 1433] ************************************************** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:831 Wednesday 06 August 2025 10:44:01 -0400 (0:00:00.042) 0:01:05.528 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Configure the TCP port setting to 1433] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:843 Wednesday 06 August 2025 10:44:01 -0400 (0:00:00.035) 0:01:05.564 ****** included: /tmp/collections-bPe/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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:3 Wednesday 06 August 2025 10:44:01 -0400 (0:00:00.051) 0:01:05.615 ****** ok: [managed-node1] => { "changed": false, "cmd": [ "grep", "^tcpport = ", "/var/opt/mssql/mssql.conf" ], "delta": "0:00:00.002835", "end": "2025-08-06 10:44:01.990713", "failed_when_result": false, "rc": 1, "start": "2025-08-06 10:44:01.987878" } MSG: non-zero return code TASK [fedora.linux_system_roles.mssql : Configure the setting network tcpport] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:12 Wednesday 06 August 2025 10:44:02 -0400 (0:00:00.428) 0:01:06.043 ****** ok: [managed-node1] => { "changed": false, "cmd": [ "/opt/mssql/bin/mssql-conf", "set", "network.tcpport", "1433" ], "delta": "0:00:00.102092", "end": "2025-08-06 10:44:02.522660", "failed_when_result": false, "rc": 0, "start": "2025-08-06 10:44:02.420568" } 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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:42 Wednesday 06 August 2025 10:44:02 -0400 (0:00:00.529) 0:01:06.573 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [Close the previously set SQL Server TCP port if it changed] ************** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:849 Wednesday 06 August 2025 10:44:02 -0400 (0:00:00.039) 0:01:06.612 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Configure the sqlagent setting] ******** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:869 Wednesday 06 August 2025 10:44:02 -0400 (0:00:00.047) 0:01:06.660 ****** included: /tmp/collections-bPe/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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:3 Wednesday 06 August 2025 10:44:02 -0400 (0:00:00.141) 0:01:06.801 ****** ok: [managed-node1] => { "changed": false, "cmd": [ "grep", "^enabled = ", "/var/opt/mssql/mssql.conf" ], "delta": "0:00:00.002394", "end": "2025-08-06 10:44:03.196778", "failed_when_result": false, "rc": 0, "start": "2025-08-06 10:44:03.194384" } STDOUT: enabled = false TASK [fedora.linux_system_roles.mssql : Configure the setting sqlagent enabled] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:12 Wednesday 06 August 2025 10:44:03 -0400 (0:00:00.425) 0:01:07.226 ****** changed: [managed-node1] => { "changed": true, "cmd": [ "/opt/mssql/bin/mssql-conf", "set", "sqlagent.enabled", "True" ], "delta": "0:00:00.099904", "end": "2025-08-06 10:44:03.678534", "failed_when_result": false, "rc": 0, "start": "2025-08-06 10:44:03.578630" } 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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:42 Wednesday 06 August 2025 10:44:03 -0400 (0:00:00.481) 0:01:07.707 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Ensure the package mssql-server-fts] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:876 Wednesday 06 August 2025 10:44:03 -0400 (0:00:00.032) 0:01:07.739 ****** 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-bPe/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_idempotency_2019.yml:18 Wednesday 06 August 2025 10:44:06 -0400 (0:00:02.950) 0:01:10.690 ****** included: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml for managed-node1 TASK [Gather package facts] **************************************************** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:3 Wednesday 06 August 2025 10:44:06 -0400 (0:00:00.054) 0:01:10.745 ****** 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-bPe/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:7 Wednesday 06 August 2025 10:44:08 -0400 (0:00:01.459) 0:01:12.205 ****** TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts used by role] ***** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 Wednesday 06 August 2025 10:44:08 -0400 (0:00:00.059) 0:01:12.264 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Set platform/version specific variables] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8 Wednesday 06 August 2025 10:44:08 -0400 (0:00:00.038) 0:01:12.302 ****** 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-bPe/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, "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-bPe/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-bPe/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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:22 Wednesday 06 August 2025 10:44:08 -0400 (0:00:00.061) 0:01:12.364 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Require installed systemd] ************* task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:29 Wednesday 06 August 2025 10:44:08 -0400 (0:00:00.029) 0:01:12.394 ****** skipping: [managed-node1] => { "changed": false, "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-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:34 Wednesday 06 August 2025 10:44:08 -0400 (0:00:00.031) 0:01:12.425 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [Purge cluster configuration] ********************************************* task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:13 Wednesday 06 August 2025 10:44:08 -0400 (0:00:00.030) 0:01:12.455 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [Debug ansible_python_version] ******************************************** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:21 Wednesday 06 August 2025 10:44:08 -0400 (0:00:00.037) 0:01:12.492 ****** ok: [managed-node1] => { "ansible_python_version": "3.6.8" } TASK [Purge firewall configuration] ******************************************** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:25 Wednesday 06 August 2025 10:44:08 -0400 (0:00:00.031) 0:01:12.523 ****** TASK [fedora.linux_system_roles.firewall : Setup firewalld] ******************** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:2 Wednesday 06 August 2025 10:44:08 -0400 (0:00:00.119) 0:01:12.643 ****** included: /tmp/collections-bPe/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-bPe/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:2 Wednesday 06 August 2025 10:44:08 -0400 (0:00:00.081) 0:01:12.724 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.firewall : Check if system is ostree] ********** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:10 Wednesday 06 August 2025 10:44:08 -0400 (0:00:00.059) 0:01:12.784 ****** 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-bPe/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:15 Wednesday 06 August 2025 10:44:09 -0400 (0:00:00.450) 0:01:13.234 ****** 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-bPe/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:22 Wednesday 06 August 2025 10:44:09 -0400 (0:00:00.042) 0:01:13.277 ****** ok: [managed-node1] => { "changed": false, "stat": { "exists": false } } TASK [fedora.linux_system_roles.firewall : Set flag if transactional-update exists] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:27 Wednesday 06 August 2025 10:44:09 -0400 (0:00:00.371) 0:01:13.648 ****** ok: [managed-node1] => { "ansible_facts": { "__firewall_is_transactional": false }, "changed": false } TASK [fedora.linux_system_roles.firewall : Run systemctl] ********************** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:34 Wednesday 06 August 2025 10:44:09 -0400 (0:00:00.039) 0:01:13.687 ****** ok: [managed-node1] => { "changed": false, "cmd": [ "systemctl", "is-system-running" ], "delta": "0:00:00.007710", "end": "2025-08-06 10:44:10.035269", "failed_when_result": false, "rc": 0, "start": "2025-08-06 10:44:10.027559" } STDOUT: running TASK [fedora.linux_system_roles.firewall : Require installed systemd] ********** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:41 Wednesday 06 August 2025 10:44:10 -0400 (0:00:00.393) 0:01:14.080 ****** skipping: [managed-node1] => { "changed": false, "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-bPe/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:46 Wednesday 06 August 2025 10:44:10 -0400 (0:00:00.043) 0:01:14.124 ****** ok: [managed-node1] => { "ansible_facts": { "__firewall_is_booted": true }, "changed": false } TASK [fedora.linux_system_roles.firewall : Install firewalld] ****************** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:51 Wednesday 06 August 2025 10:44:10 -0400 (0:00:00.041) 0:01:14.165 ****** 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-bPe/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:63 Wednesday 06 August 2025 10:44:13 -0400 (0:00:02.835) 0:01:17.001 ****** skipping: [managed-node1] => {} TASK [fedora.linux_system_roles.firewall : Reboot transactional update systems] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:68 Wednesday 06 August 2025 10:44:13 -0400 (0:00:00.033) 0:01:17.035 ****** skipping: [managed-node1] => { "changed": 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-bPe/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:73 Wednesday 06 August 2025 10:44:13 -0400 (0:00:00.032) 0:01:17.068 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.firewall : Check which conflicting services are enabled] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:5 Wednesday 06 August 2025 10:44:13 -0400 (0:00:00.033) 0:01:17.101 ****** skipping: [managed-node1] => (item=nftables) => { "ansible_loop_var": "item", "changed": false, "item": "nftables", "skip_reason": "Conditional result was False" } skipping: [managed-node1] => (item=iptables) => { "ansible_loop_var": "item", "changed": false, "item": "iptables", "skip_reason": "Conditional result was False" } skipping: [managed-node1] => (item=ufw) => { "ansible_loop_var": "item", "changed": false, "item": "ufw", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.firewall : Attempt to stop and disable conflicting services] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:14 Wednesday 06 August 2025 10:44:13 -0400 (0:00:00.042) 0:01:17.144 ****** skipping: [managed-node1] => (item={'changed': False, 'skipped': True, 'skip_reason': 'Conditional result was False', 'item': 'nftables', 'ansible_loop_var': 'item'}) => { "ansible_loop_var": "item", "changed": false, "item": { "ansible_loop_var": "item", "changed": false, "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', 'item': 'iptables', 'ansible_loop_var': 'item'}) => { "ansible_loop_var": "item", "changed": false, "item": { "ansible_loop_var": "item", "changed": false, "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', 'item': 'ufw', 'ansible_loop_var': 'item'}) => { "ansible_loop_var": "item", "changed": false, "item": { "ansible_loop_var": "item", "changed": false, "item": "ufw", "skip_reason": "Conditional result was False", "skipped": true }, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.firewall : Unmask firewalld service] *********** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:24 Wednesday 06 August 2025 10:44:13 -0400 (0:00:00.043) 0:01:17.188 ****** ok: [managed-node1] => { "changed": false, "name": "firewalld", "status": { "ActiveEnterTimestamp": "Wed 2025-08-06 10:36:41 EDT", "ActiveEnterTimestampMonotonic": "471615905", "ActiveExitTimestampMonotonic": "0", "ActiveState": "active", "After": "polkit.service dbus.service basic.target sysinit.target dbus.socket system.slice", "AllowIsolate": "no", "AllowedCPUs": "", "AllowedMemoryNodes": "", "AmbientCapabilities": "", "AssertResult": "yes", "AssertTimestamp": "Wed 2025-08-06 10:36:41 EDT", "AssertTimestampMonotonic": "471329289", "Before": "multi-user.target network-pre.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:41 EDT", "ConditionTimestampMonotonic": "471329288", "ConfigurationDirectoryMode": "0755", "Conflicts": "ip6tables.service ebtables.service nftables.service iptables.service ipset.service shutdown.target", "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": "19999", "ExecMainStartTimestamp": "Wed 2025-08-06 10:36:41 EDT", "ExecMainStartTimestampMonotonic": "471330457", "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:41 EDT", "InactiveExitTimestampMonotonic": "471330503", "InvocationID": "fa002f2787e4467bbefbc2f3afd60235", "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": "19999", "MemoryAccounting": "yes", "MemoryCurrent": "43126784", "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:41 EDT", "StateChangeTimestampMonotonic": "471615905", "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:41 EDT", "WatchdogTimestampMonotonic": "471615902", "WatchdogUSec": "0" } } TASK [fedora.linux_system_roles.firewall : Enable and start firewalld service] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:30 Wednesday 06 August 2025 10:44:13 -0400 (0:00:00.496) 0:01:17.684 ****** ok: [managed-node1] => { "changed": false, "enabled": true, "name": "firewalld", "state": "started", "status": { "ActiveEnterTimestamp": "Wed 2025-08-06 10:36:41 EDT", "ActiveEnterTimestampMonotonic": "471615905", "ActiveExitTimestampMonotonic": "0", "ActiveState": "active", "After": "polkit.service dbus.service basic.target sysinit.target dbus.socket system.slice", "AllowIsolate": "no", "AllowedCPUs": "", "AllowedMemoryNodes": "", "AmbientCapabilities": "", "AssertResult": "yes", "AssertTimestamp": "Wed 2025-08-06 10:36:41 EDT", "AssertTimestampMonotonic": "471329289", "Before": "multi-user.target network-pre.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:41 EDT", "ConditionTimestampMonotonic": "471329288", "ConfigurationDirectoryMode": "0755", "Conflicts": "ip6tables.service ebtables.service nftables.service iptables.service ipset.service shutdown.target", "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": "19999", "ExecMainStartTimestamp": "Wed 2025-08-06 10:36:41 EDT", "ExecMainStartTimestampMonotonic": "471330457", "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:41 EDT", "InactiveExitTimestampMonotonic": "471330503", "InvocationID": "fa002f2787e4467bbefbc2f3afd60235", "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": "19999", "MemoryAccounting": "yes", "MemoryCurrent": "43126784", "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:41 EDT", "StateChangeTimestampMonotonic": "471615905", "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:41 EDT", "WatchdogTimestampMonotonic": "471615902", "WatchdogUSec": "0" } } TASK [fedora.linux_system_roles.firewall : Check if previous replaced is defined] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:36 Wednesday 06 August 2025 10:44:14 -0400 (0:00:00.503) 0:01:18.187 ****** 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-bPe/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:45 Wednesday 06 August 2025 10:44:14 -0400 (0:00:00.055) 0:01:18.243 ****** ok: [managed-node1] => { "changed": false, "rc": 0 } STDERR: Shared connection to 10.31.46.150 closed. TASK [fedora.linux_system_roles.firewall : Tell firewall module it is able to report changed] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:58 Wednesday 06 August 2025 10:44:14 -0400 (0:00:00.311) 0:01:18.555 ****** ok: [managed-node1] => { "ansible_facts": { "__firewall_report_changed": true }, "changed": false } TASK [fedora.linux_system_roles.firewall : Configure firewall] ***************** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:74 Wednesday 06 August 2025 10:44:14 -0400 (0:00:00.036) 0:01:18.591 ****** TASK [fedora.linux_system_roles.firewall : Gather firewall config information] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:126 Wednesday 06 August 2025 10:44:14 -0400 (0:00:00.037) 0:01:18.628 ****** TASK [fedora.linux_system_roles.firewall : Update firewalld_config fact] ******* task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:137 Wednesday 06 August 2025 10:44:14 -0400 (0:00:00.044) 0:01:18.673 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.firewall : Gather firewall config if no arguments] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:146 Wednesday 06 August 2025 10:44:14 -0400 (0:00:00.055) 0:01:18.729 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.firewall : Update firewalld_config fact] ******* task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:152 Wednesday 06 August 2025 10:44:14 -0400 (0:00:00.049) 0:01:18.779 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.firewall : Get config files, checksums after] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:161 Wednesday 06 August 2025 10:44:14 -0400 (0:00:00.048) 0:01:18.827 ****** ok: [managed-node1] => { "changed": false, "rc": 0 } STDERR: Shared connection to 10.31.46.150 closed. TASK [fedora.linux_system_roles.firewall : Calculate what has changed] ********* task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:172 Wednesday 06 August 2025 10:44:15 -0400 (0:00:00.298) 0:01:19.125 ****** ok: [managed-node1] => { "ansible_facts": { "firewall_lib_result": { "changed": false } }, "changed": false } TASK [fedora.linux_system_roles.firewall : Show diffs] ************************* task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:178 Wednesday 06 August 2025 10:44:15 -0400 (0:00:00.039) 0:01:19.165 ****** skipping: [managed-node1] => {} TASK [Purge selinux configuration] ********************************************* task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:33 Wednesday 06 August 2025 10:44:15 -0400 (0:00:00.043) 0:01:19.208 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [Leave realm] ************************************************************* task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:40 Wednesday 06 August 2025 10:44:15 -0400 (0:00:00.041) 0:01:19.250 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [Destroy Kerberos tickets] ************************************************ task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:48 Wednesday 06 August 2025 10:44:15 -0400 (0:00:00.047) 0:01:19.298 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [Remove related packages] ************************************************* task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:52 Wednesday 06 August 2025 10:44:15 -0400 (0:00:00.058) 0:01:19.356 ****** 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-bPe/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:65 Wednesday 06 August 2025 10:44:20 -0400 (0:00:04.714) 0:01:24.071 ****** [WARNING]: Consider using the file module with state=absent rather than running 'rm'. If you need to use command because file is insufficient you can add 'warn: false' to this command task or set 'command_warnings=False' in ansible.cfg to get rid of this message. 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.010036", "end": "2025-08-06 10:44:20.476438", "rc": 0, "start": "2025-08-06 10:44:20.466402" } 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/aeae14b9-dfac-49b7-8d11-c29cae861248' 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_133989650247380000.xel' removed '/var/opt/mssql/log/system_health_0_133989650253750000.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_133989650289080000.xel' removed '/var/opt/mssql/log/system_health_0_133989650292980000.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-bPe/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:80 Wednesday 06 August 2025 10:44:20 -0400 (0:00:00.444) 0:01:24.516 ****** ok: [managed-node1] => { "changed": false, "cmd": "systemctl stop mssql-server || true", "delta": "0:00:00.010145", "end": "2025-08-06 10:44:20.863002", "rc": 0, "start": "2025-08-06 10:44:20.852857" } STDERR: Failed to stop mssql-server.service: Unit mssql-server.service not loaded. TASK [Get SELinux policy modules] ********************************************** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:85 Wednesday 06 August 2025 10:44:20 -0400 (0:00:00.377) 0:01:24.893 ****** ok: [managed-node1] => { "changed": false, "cmd": [ "semodule", "-l" ], "delta": "0:00:00.007842", "end": "2025-08-06 10:44:21.256756", "rc": 0, "start": "2025-08-06 10:44:21.248914" } 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-bPe/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:91 Wednesday 06 August 2025 10:44:21 -0400 (0:00:00.396) 0:01:25.290 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [Hack around broken mssql SELinux profile and actually remove it] ********* task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:99 Wednesday 06 August 2025 10:44:21 -0400 (0:00:00.048) 0:01:25.338 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [Check for leftover mssql processes] ************************************** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:108 Wednesday 06 August 2025 10:44:21 -0400 (0:00:00.051) 0:01:25.390 ****** ok: [managed-node1] => { "changed": false, "cmd": [ "pgrep", "-au", "mssql" ], "delta": "0:00:00.005555", "end": "2025-08-06 10:44:21.839797", "failed_when_result": false, "rc": 1, "start": "2025-08-06 10:44:21.834242" } MSG: non-zero return code TASK [Kill leftover mssql processes] ******************************************* task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:115 Wednesday 06 August 2025 10:44:21 -0400 (0:00:00.489) 0:01:25.879 ****** skipping: [managed-node1] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [Remove system user] ****************************************************** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:120 Wednesday 06 August 2025 10:44:22 -0400 (0:00:00.088) 0:01:25.967 ****** 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 RUNNING HANDLER [fedora.linux_system_roles.mssql : Restart the mssql-server service] *** task path: /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/handlers/main.yml:3 Wednesday 06 August 2025 10:44:22 -0400 (0:00:00.640) 0:01:26.607 ****** 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.9.27", "end_time": "2025-08-06T14:44:06.716009+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:44:03.783100+00:00Z", "task_name": "Ensure the package mssql-server-fts", "task_path": "/tmp/collections-bPe/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:22 -0400 (0:00:00.003) 0:01:26.611 ****** =============================================================================== fedora.linux_system_roles.mssql : Ensure the package mssql-server ------ 34.31s /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:345 fedora.linux_system_roles.mssql : Set up MSSQL -------------------------- 5.15s /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:404 Remove related packages ------------------------------------------------- 4.71s /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:52 fedora.linux_system_roles.mssql : Ensure that SQL Server client tools are installed --- 3.78s /tmp/collections-bPe/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.25s /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:340 fedora.linux_system_roles.mssql : Ensure the package mssql-server-fts --- 2.95s /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:876 fedora.linux_system_roles.firewall : Install firewalld ------------------ 2.84s /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:51 fedora.linux_system_roles.mssql : Ensure that the tuned-profiles-mssql package is installed --- 2.82s /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:470 fedora.linux_system_roles.mssql : Gather package facts ------------------ 1.87s /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:185 Gather package facts ---------------------------------------------------- 1.46s /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:3 Ensure ansible_facts to get ansible_distribution ------------------------ 0.94s /tmp/collections-bPe/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.79s /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:238 fedora.linux_system_roles.mssql : Run systemctl ------------------------- 0.78s /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:22 fedora.linux_system_roles.mssql : Ensure that the tuned service is started and enabled --- 0.74s /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:476 Remove system user ------------------------------------------------------ 0.64s /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:120 fedora.linux_system_roles.mssql : Get the setting filelocation defaultlogdir --- 0.63s /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:3 fedora.linux_system_roles.mssql : Configure the setting filelocation defaultdatadir --- 0.58s /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:12 fedora.linux_system_roles.mssql : Ensure the directory and permissions /tmp/mssql_data --- 0.54s /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/configure_storage_paths.yml:3 fedora.linux_system_roles.mssql : Configure the setting filelocation defaultlogdir --- 0.53s /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:12 fedora.linux_system_roles.mssql : Configure the setting network tcpport --- 0.53s /tmp/collections-bPe/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:12 -- Logs begin at Wed 2025-08-06 10:28:50 EDT, end at Wed 2025-08-06 10:44:23 EDT. -- Aug 06 10:42:55 managed-node1 sshd[62829]: Accepted publickey for root from 10.31.41.35 port 36950 ssh2: RSA SHA256:9j1blwt3wcrRiGYZQ7ZGu9axm3cDklH6/z4c+Ee8CzE Aug 06 10:42:55 managed-node1 systemd-logind[644]: 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 62829. Aug 06 10:42:55 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:55 managed-node1 sshd[62829]: pam_unix(sshd:session): session opened for user root by (uid=0) Aug 06 10:42:55 managed-node1 sshd[62832]: Received disconnect from 10.31.41.35 port 36950:11: disconnected by user Aug 06 10:42:55 managed-node1 sshd[62832]: Disconnected from user root 10.31.41.35 port 36950 Aug 06 10:42:55 managed-node1 sshd[62829]: pam_unix(sshd:session): session closed for user root Aug 06 10:42:55 managed-node1 systemd-logind[644]: Session 9 logged out. Waiting for processes to exit. Aug 06 10:42:55 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:55 managed-node1 systemd-logind[644]: 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:57 managed-node1 platform-python[62994]: ansible-setup Invoked with gather_subset=['min'] gather_timeout=10 filter=* fact_path=/etc/ansible/facts.d Aug 06 10:42:58 managed-node1 platform-python[63123]: ansible-command Invoked with _raw_params=systemctl is-system-running warn=True _uses_shell=False stdin_add_newline=True strip_empty_ends=True argv=None chdir=None executable=None creates=None removes=None stdin=None Aug 06 10:43:01 managed-node1 platform-python[63372]: ansible-rpm_key Invoked with key=https://packages.microsoft.com/keys/microsoft.asc state=present validate_certs=True fingerprint=None Aug 06 10:43:02 managed-node1 platform-python[63502]: 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 follow=False 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 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 params=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 src=None force=None content=NOT_LOGGING_PARAMETER backup=None remote_src=None regexp=None delimiter=None directory_mode=None Aug 06 10:43:03 managed-node1 platform-python[63625]: ansible-dnf Invoked with name=['mssql-server-selinux'] state=absent allow_downgrade=False autoremove=False bugfix=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 lock_timeout=30 conf_file=None disable_excludes=None download_dir=None list=None releasever=None Aug 06 10:43:06 managed-node1 platform-python[63749]: ansible-dnf Invoked with name=['mssql-server'] state=present allow_downgrade=False autoremove=False bugfix=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 lock_timeout=30 conf_file=None disable_excludes=None download_dir=None list=None releasever=None Aug 06 10:43:15 managed-node1 systemd[1]: Reloading. Aug 06 10:43:39 managed-node1 useradd[63807]: new group: name=mssql, GID=989 Aug 06 10:43:39 managed-node1 useradd[63807]: new user: name=mssql, UID=993, GID=989, home=/var/opt/mssql, shell=/bin/bash Aug 06 10:43:39 managed-node1 systemd[1]: Reloading. Aug 06 10:43:39 managed-node1 systemd[1]: Started /usr/bin/systemctl start man-db-cache-update. -- Subject: Unit run-r06e8393b10ad4f50b981abe0c9a04aed.service has finished start-up -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- Unit run-r06e8393b10ad4f50b981abe0c9a04aed.service has finished starting up. -- -- The start-up result is done. Aug 06 10:43:39 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:39 managed-node1 systemd[1]: Reloading. Aug 06 10:43:40 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:40 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:40 managed-node1 systemd[1]: run-r06e8393b10ad4f50b981abe0c9a04aed.service: Succeeded. -- Subject: Unit succeeded -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- The unit run-r06e8393b10ad4f50b981abe0c9a04aed.service has successfully entered the 'dead' state. Aug 06 10:43:40 managed-node1 platform-python[64424]: ansible-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 warn=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[64551]: ansible-command Invoked with _raw_params=systemctl is-enabled mssql-server.service warn=True _uses_shell=False 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[64675]: ansible-command Invoked with _raw_params=systemctl is-active mssql-server.service warn=True _uses_shell=False stdin_add_newline=True strip_empty_ends=True argv=None chdir=None executable=None creates=None removes=None stdin=None Aug 06 10:43:42 managed-node1 su[64819]: (to mssql) root on pts/0 Aug 06 10:43:42 managed-node1 su[64819]: pam_unix(su:session): session opened for user mssql by root(uid=0) Aug 06 10:43:46 managed-node1 su[64819]: pam_unix(su:session): session closed for user mssql Aug 06 10:43:46 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:46 managed-node1 systemd[1]: Reloading. Aug 06 10:43:47 managed-node1 platform-python[65179]: 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 content=NOT_LOGGING_PARAMETER backup=None remote_src=None regexp=None delimiter=None directory_mode=None Aug 06 10:43:47 managed-node1 platform-python[65365]: ansible-command Invoked with _raw_params=grep '^defaultdatadir = ' /var/opt/mssql/mssql.conf warn=True _uses_shell=False 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[65499]: ansible-command Invoked with _raw_params=/opt/mssql/bin/mssql-conf set filelocation.defaultdatadir /tmp/mssql_data warn=True _uses_shell=False 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 sqlservr[65094]: 2025-08-06 10:43:48.40 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:48 managed-node1 sqlservr[65094]: [178B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [162B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [160B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [108B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [29B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [49B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [80B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [57B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [62B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [56B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [61B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [102B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [64B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [43B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [44B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [40B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [274B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [155B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [122B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [84B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [69B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [93B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [95B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [102B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [557B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [86B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [118B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [281B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [212B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [81B blob data] Aug 06 10:43:48 managed-node1 platform-python[65651]: 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 content=NOT_LOGGING_PARAMETER backup=None remote_src=None regexp=None delimiter=None directory_mode=None Aug 06 10:43:48 managed-node1 sqlservr[65094]: [94B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [274B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [41B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [126B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [81B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [71B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [96B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [66B blob data] Aug 06 10:43:48 managed-node1 sqlservr[65094]: [50B blob data] Aug 06 10:43:49 managed-node1 sqlservr[65094]: [161B blob data] Aug 06 10:43:49 managed-node1 sqlservr[65094]: [66B blob data] Aug 06 10:43:49 managed-node1 sqlservr[65094]: [157B blob data] Aug 06 10:43:49 managed-node1 sqlservr[65094]: [161B blob data] Aug 06 10:43:49 managed-node1 sqlservr[65094]: [80B blob data] Aug 06 10:43:49 managed-node1 sqlservr[65094]: [138B blob data] Aug 06 10:43:49 managed-node1 sqlservr[65094]: [138B blob data] Aug 06 10:43:49 managed-node1 sqlservr[65094]: [77B blob data] Aug 06 10:43:49 managed-node1 sqlservr[65094]: [134B blob data] Aug 06 10:43:49 managed-node1 sqlservr[65094]: [159B blob data] Aug 06 10:43:49 managed-node1 sqlservr[65094]: [217B blob data] Aug 06 10:43:49 managed-node1 sqlservr[65094]: [100B blob data] Aug 06 10:43:49 managed-node1 sqlservr[65094]: [96B blob data] Aug 06 10:43:49 managed-node1 sqlservr[65094]: [79B blob data] Aug 06 10:43:49 managed-node1 sqlservr[65094]: [64B blob data] Aug 06 10:43:49 managed-node1 sqlservr[65094]: [153B blob data] Aug 06 10:43:49 managed-node1 sqlservr[65094]: [92B blob data] Aug 06 10:43:49 managed-node1 sqlservr[65094]: [96B blob data] Aug 06 10:43:49 managed-node1 sqlservr[65094]: [65B blob data] Aug 06 10:43:49 managed-node1 sqlservr[65094]: [158B blob data] Aug 06 10:43:49 managed-node1 sqlservr[65094]: [155B blob data] Aug 06 10:43:49 managed-node1 sqlservr[65094]: [61B blob data] Aug 06 10:43:49 managed-node1 sqlservr[65094]: [104B blob data] Aug 06 10:43:49 managed-node1 sqlservr[65094]: [80B blob data] Aug 06 10:43:49 managed-node1 sqlservr[65094]: [80B blob data] Aug 06 10:43:49 managed-node1 sqlservr[65094]: [78B blob data] Aug 06 10:43:49 managed-node1 sqlservr[65094]: [84B blob data] Aug 06 10:43:49 managed-node1 sqlservr[65094]: [122B blob data] Aug 06 10:43:49 managed-node1 sqlservr[65094]: [78B blob data] Aug 06 10:43:49 managed-node1 sqlservr[65094]: [84B blob data] Aug 06 10:43:49 managed-node1 sqlservr[65094]: [145B blob data] Aug 06 10:43:49 managed-node1 platform-python[65809]: ansible-command Invoked with _raw_params=grep '^defaultlogdir = ' /var/opt/mssql/mssql.conf warn=True _uses_shell=False stdin_add_newline=True strip_empty_ends=True argv=None chdir=None executable=None creates=None removes=None stdin=None Aug 06 10:43:49 managed-node1 sqlservr[65094]: [96B blob data] Aug 06 10:43:49 managed-node1 sqlservr[65094]: [66B blob data] Aug 06 10:43:50 managed-node1 sqlservr[65094]: [75B blob data] Aug 06 10:43:50 managed-node1 sqlservr[65094]: [96B blob data] Aug 06 10:43:50 managed-node1 sqlservr[65094]: [100B blob data] Aug 06 10:43:50 managed-node1 sqlservr[65094]: [71B blob data] Aug 06 10:43:50 managed-node1 sqlservr[65094]: [124B blob data] Aug 06 10:43:50 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:50 managed-node1 platform-python[65949]: ansible-command Invoked with _raw_params=/opt/mssql/bin/mssql-conf set filelocation.defaultlogdir /tmp/mssql_log warn=True _uses_shell=False stdin_add_newline=True strip_empty_ends=True argv=None chdir=None executable=None creates=None removes=None stdin=None Aug 06 10:43:50 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:50 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:50 managed-node1 platform-python[66090]: ansible-dnf Invoked with name=['tuned-profiles-mssql'] state=present allow_downgrade=False autoremove=False bugfix=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 lock_timeout=30 conf_file=None disable_excludes=None download_dir=None list=None releasever=None Aug 06 10:43:53 managed-node1 platform-python[66213]: ansible-systemd Invoked with name=tuned state=started enabled=True daemon_reload=False daemon_reexec=False no_block=False force=None masked=None user=None scope=None Aug 06 10:43:54 managed-node1 platform-python[66343]: ansible-slurp Invoked with path=/etc/tuned/active_profile src=/etc/tuned/active_profile Aug 06 10:43:55 managed-node1 platform-python[66466]: 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 follow=False 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 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 params=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 src=None force=None content=NOT_LOGGING_PARAMETER backup=None remote_src=None regexp=None delimiter=None directory_mode=None Aug 06 10:43:55 managed-node1 platform-python[66589]: ansible-dnf Invoked with name=['mssql-tools18', 'unixODBC-devel'] state=present allow_downgrade=False autoremove=False bugfix=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 lock_timeout=30 conf_file=None disable_excludes=None download_dir=None list=None releasever=None Aug 06 10:43:58 managed-node1 systemd[1]: Started /usr/bin/systemctl start man-db-cache-update. -- Subject: Unit run-r134fe152012341798f24bde7804c7cb6.service has finished start-up -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- Unit run-r134fe152012341798f24bde7804c7cb6.service has finished starting up. -- -- The start-up result is done. Aug 06 10:43:58 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:58 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:58 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:58 managed-node1 systemd[1]: run-r134fe152012341798f24bde7804c7cb6.service: Succeeded. -- Subject: Unit succeeded -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- The unit run-r134fe152012341798f24bde7804c7cb6.service has successfully entered the 'dead' state. Aug 06 10:43:59 managed-node1 platform-python[67088]: ansible-command Invoked with _raw_params=set -euo pipefail; grep '^forceencryption' /var/opt/mssql/mssql.conf | sed 's/forceencryption = //g' _uses_shell=True warn=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[67214]: ansible-command Invoked with _raw_params=grep '^ipaddress = ' /var/opt/mssql/mssql.conf warn=True _uses_shell=False 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[67338]: ansible-command Invoked with _raw_params=/opt/mssql/bin/mssql-conf set network.ipaddress 0.0.0.0 warn=True _uses_shell=False 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[67468]: ansible-command Invoked with _raw_params=grep '^tcpport = ' /var/opt/mssql/mssql.conf warn=True _uses_shell=False stdin_add_newline=True strip_empty_ends=True argv=None chdir=None executable=None creates=None removes=None stdin=None Aug 06 10:44:02 managed-node1 platform-python[67592]: ansible-command Invoked with _raw_params=/opt/mssql/bin/mssql-conf set network.tcpport 1433 warn=True _uses_shell=False stdin_add_newline=True strip_empty_ends=True argv=None chdir=None executable=None creates=None removes=None stdin=None Aug 06 10:44:03 managed-node1 platform-python[67722]: ansible-command Invoked with _raw_params=grep '^enabled = ' /var/opt/mssql/mssql.conf warn=True _uses_shell=False stdin_add_newline=True strip_empty_ends=True argv=None chdir=None executable=None creates=None removes=None stdin=None Aug 06 10:44:03 managed-node1 platform-python[67846]: ansible-command Invoked with _raw_params=/opt/mssql/bin/mssql-conf set sqlagent.enabled True warn=True _uses_shell=False stdin_add_newline=True strip_empty_ends=True argv=None chdir=None executable=None creates=None removes=None stdin=None Aug 06 10:44:04 managed-node1 platform-python[67976]: ansible-dnf Invoked with name=['mssql-server-fts'] state=present allow_downgrade=False autoremove=False bugfix=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 lock_timeout=30 conf_file=None disable_excludes=None download_dir=None list=None releasever=None Aug 06 10:44:09 managed-node1 platform-python[68226]: ansible-stat Invoked with path=/run/ostree-booted follow=False get_md5=False get_checksum=True get_mime=True get_attributes=True checksum_algorithm=sha1 Aug 06 10:44:09 managed-node1 platform-python[68349]: ansible-stat Invoked with path=/sbin/transactional-update follow=False get_md5=False get_checksum=True get_mime=True get_attributes=True checksum_algorithm=sha1 Aug 06 10:44:10 managed-node1 platform-python[68472]: ansible-command Invoked with _raw_params=systemctl is-system-running warn=True _uses_shell=False stdin_add_newline=True strip_empty_ends=True argv=None chdir=None executable=None creates=None removes=None stdin=None Aug 06 10:44:10 managed-node1 platform-python[68596]: ansible-dnf Invoked with name=['firewalld'] state=present allow_downgrade=False autoremove=False bugfix=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 lock_timeout=30 conf_file=None disable_excludes=None download_dir=None list=None releasever=None Aug 06 10:44:13 managed-node1 platform-python[68719]: ansible-systemd Invoked with name=firewalld masked=False daemon_reload=False daemon_reexec=False no_block=False state=None enabled=None force=None user=None scope=None Aug 06 10:44:14 managed-node1 platform-python[68846]: ansible-systemd Invoked with name=firewalld enabled=True state=started daemon_reload=False daemon_reexec=False no_block=False force=None masked=None user=None scope=None Aug 06 10:44:15 managed-node1 platform-python[69234]: ansible-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 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 lock_timeout=30 conf_file=None disable_excludes=None download_dir=None list=None releasever=None Aug 06 10:44:18 managed-node1 systemd[1]: Reloading. Aug 06 10:44:18 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:44:18 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:44:18 managed-node1 sqlservr[65094]: [200B blob data] Aug 06 10:44:18 managed-node1 sqlservr[65094]: [190B blob data] Aug 06 10:44:18 managed-node1 sqlservr[65094]: [73B blob data] Aug 06 10:44:18 managed-node1 sqlservr[65094]: [76B blob data] Aug 06 10:44:18 managed-node1 sqlservr[65094]: [164B blob data] Aug 06 10:44:18 managed-node1 sqlservr[65094]: [1B blob data] Aug 06 10:44:18 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:44:18 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:44:18 managed-node1 systemd[1]: Reloading. Aug 06 10:44:18 managed-node1 systemd[1]: Reloading. Aug 06 10:44:19 managed-node1 systemd[1]: Started /usr/bin/systemctl start man-db-cache-update. -- Subject: Unit run-re50030b29c284c49b92cb2e4e403877c.service has finished start-up -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- Unit run-re50030b29c284c49b92cb2e4e403877c.service has finished starting up. -- -- The start-up result is done. Aug 06 10:44:19 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:44:19 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:44:19 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:44:19 managed-node1 systemd[1]: run-re50030b29c284c49b92cb2e4e403877c.service: Succeeded. -- Subject: Unit succeeded -- Defined-By: systemd -- Support: https://access.redhat.com/support -- -- The unit run-re50030b29c284c49b92cb2e4e403877c.service has successfully entered the 'dead' state. Aug 06 10:44:20 managed-node1 platform-python[69814]: ansible-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 warn=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:20 managed-node1 platform-python[69814]: ansible-command [WARNING] Consider using the file module with state=absent rather than running 'rm'. If you need to use command because file is insufficient you can add 'warn: false' to this command task or set 'command_warnings=False' in ansible.cfg to get rid of this message. Aug 06 10:44:20 managed-node1 platform-python[69938]: ansible-command Invoked with _raw_params=systemctl stop mssql-server || true _uses_shell=True warn=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:21 managed-node1 platform-python[70064]: ansible-command Invoked with _raw_params=semodule -l warn=True _uses_shell=False stdin_add_newline=True strip_empty_ends=True argv=None chdir=None executable=None creates=None removes=None stdin=None Aug 06 10:44:21 managed-node1 platform-python[70188]: ansible-command Invoked with _raw_params=pgrep -au mssql warn=True _uses_shell=False stdin_add_newline=True strip_empty_ends=True argv=None chdir=None executable=None creates=None removes=None stdin=None Aug 06 10:44:22 managed-node1 platform-python[70312]: 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 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 Aug 06 10:44:22 managed-node1 userdel[70316]: delete user 'mssql' Aug 06 10:44:22 managed-node1 userdel[70316]: removed group 'mssql' owned by 'mssql' Aug 06 10:44:22 managed-node1 userdel[70316]: removed shadow group 'mssql' owned by 'mssql' Aug 06 10:44:22 managed-node1 sshd[70342]: Accepted publickey for root from 10.31.41.35 port 58674 ssh2: RSA SHA256:9j1blwt3wcrRiGYZQ7ZGu9axm3cDklH6/z4c+Ee8CzE Aug 06 10:44:22 managed-node1 systemd-logind[644]: 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 70342. Aug 06 10:44:22 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:22 managed-node1 sshd[70342]: pam_unix(sshd:session): session opened for user root by (uid=0) Aug 06 10:44:22 managed-node1 sshd[70345]: Received disconnect from 10.31.41.35 port 58674:11: disconnected by user Aug 06 10:44:22 managed-node1 sshd[70345]: Disconnected from user root 10.31.41.35 port 58674 Aug 06 10:44:22 managed-node1 sshd[70342]: pam_unix(sshd:session): session closed for user root Aug 06 10:44:22 managed-node1 systemd-logind[644]: Session 10 logged out. Waiting for processes to exit. Aug 06 10:44:22 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:22 managed-node1 systemd-logind[644]: 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:23 managed-node1 sshd[70366]: Accepted publickey for root from 10.31.41.35 port 58678 ssh2: RSA SHA256:9j1blwt3wcrRiGYZQ7ZGu9axm3cDklH6/z4c+Ee8CzE Aug 06 10:44:23 managed-node1 systemd-logind[644]: 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 70366. Aug 06 10:44:23 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:23 managed-node1 sshd[70366]: pam_unix(sshd:session): session opened for user root by (uid=0)