ansible-playbook [core 2.16.13] config file = None configured module search path = ['/root/.ansible/plugins/modules', '/usr/share/ansible/plugins/modules'] ansible python module location = /usr/local/lib/python3.12/site-packages/ansible ansible collection location = /tmp/collections-Qs1 executable location = /usr/local/bin/ansible-playbook python version = 3.12.1 (main, Feb 21 2024, 14:18:26) [GCC 8.5.0 20210514 (Red Hat 8.5.0-21)] (/usr/bin/python3.12) jinja version = 3.1.4 libyaml = True No config file found; using defaults running playbook inside collection fedora.linux_system_roles redirecting (type: callback) ansible.builtin.debug to ansible.posix.debug redirecting (type: callback) ansible.builtin.debug to ansible.posix.debug redirecting (type: callback) ansible.builtin.profile_tasks to ansible.posix.profile_tasks Skipping callback 'default', as we already have a stdout callback. Skipping callback 'minimal', as we already have a stdout callback. Skipping callback 'oneline', as we already have a stdout callback. PLAYBOOK: tests_tls_2017.yml *************************************************** 2 plays in /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_tls_2017.yml PLAY [all] ********************************************************************* TASK [Include vault variables] ************************************************* task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_tls_2017.yml:5 Wednesday 20 November 2024 08:15:10 -0500 (0:00:00.007) 0:00:00.007 **** ok: [managed-node2] => { "ansible_facts": { "mssql_password": { "__ansible_vault": "$ANSIBLE_VAULT;1.1;AES256\n66336361663164656232326461653662643537386337346563613939356466313835383235313234\n3634333565616161316639666662613564353237653663610a616639306439653033386664303839\n30663030636161326137656235636230356162373234386461363632353863393161353035316162\n3664353366373231360a343334326337353861366233656330363634353164316434616561333161\n3234\n" } }, "ansible_included_var_files": [ "/tmp/mssql-I7o/tests/vars/vault-variables.yml" ], "changed": false } PLAY [Ensure that tls encryption configuration works] ************************** TASK [Gathering Facts] ********************************************************* task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_tls_2017.yml:9 Wednesday 20 November 2024 08:15:10 -0500 (0:00:00.016) 0:00:00.023 **** ok: [managed-node2] TASK [Run tests_tls with SQL Server 2017] ************************************** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_tls_2017.yml:24 Wednesday 20 November 2024 08:15:11 -0500 (0:00:01.261) 0:00:01.285 **** included: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml for managed-node2 TASK [Assert fail on EL 7 with version = 2022 and EL 9 with version != 2022] *** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:2 Wednesday 20 November 2024 08:15:11 -0500 (0:00:00.046) 0:00:01.331 **** included: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml for managed-node2 TASK [Ensure ansible_facts to get ansible_distribution] ************************ task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:2 Wednesday 20 November 2024 08:15:11 -0500 (0:00:00.019) 0:00:01.351 **** ok: [managed-node2] TASK [Run the role] ************************************************************ task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:17 Wednesday 20 November 2024 08:15:12 -0500 (0:00:00.493) 0:00:01.845 **** skipping: [managed-node2] => { "changed": false, "false_condition": "(ansible_distribution in ['CentOS', 'RedHat'] and ansible_distribution_major_version is version('7', '=') and mssql_version | int == 2022) or (((ansible_distribution in ['CentOS', 'RedHat'] and ansible_distribution_major_version is version('9', '=')) or (ansible_distribution in ['Fedora'])) and mssql_version | int != 2022)", "skip_reason": "Conditional result was False" } TASK [Unreachable task] ******************************************************** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:24 Wednesday 20 November 2024 08:15:12 -0500 (0:00:00.036) 0:00:01.881 **** skipping: [managed-node2] => { "changed": false, "false_condition": "(ansible_distribution in ['CentOS', 'RedHat'] and ansible_distribution_major_version is version('7', '=') and mssql_version | int == 2022) or (((ansible_distribution in ['CentOS', 'RedHat'] and ansible_distribution_major_version is version('9', '=')) or (ansible_distribution in ['Fedora'])) and mssql_version | int != 2022)", "skip_reason": "Conditional result was False" } TASK [Ensure the openssl package] ********************************************** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:5 Wednesday 20 November 2024 08:15:12 -0500 (0:00:00.036) 0:00:01.917 **** ok: [managed-node2] => { "changed": false, "rc": 0, "results": [] } MSG: Nothing to do TASK [Create a tempfile for a certificate on hosts] **************************** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:11 Wednesday 20 November 2024 08:15:15 -0500 (0:00:03.157) 0:00:05.075 **** changed: [managed-node2] => { "changed": true, "gid": 0, "group": "root", "mode": "0600", "owner": "root", "path": "/tmp/ansible.5e7eq51k", "secontext": "unconfined_u:object_r:user_tmp_t:s0", "size": 0, "state": "file", "uid": 0 } TASK [Create a tempfile for a private key on hosts] **************************** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:17 Wednesday 20 November 2024 08:15:15 -0500 (0:00:00.437) 0:00:05.513 **** changed: [managed-node2] => { "changed": true, "gid": 0, "group": "root", "mode": "0600", "owner": "root", "path": "/tmp/ansible.zw64ttyw", "secontext": "unconfined_u:object_r:user_tmp_t:s0", "size": 0, "state": "file", "uid": 0 } TASK [Generate a self-signed certificate and public key] *********************** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:23 Wednesday 20 November 2024 08:15:16 -0500 (0:00:00.352) 0:00:05.865 **** changed: [managed-node2] => { "changed": true, "cmd": [ "openssl", "req", "-x509", "-nodes", "-newkey", "rsa:2048", "-subj", "/CN=10.31.46.8", "-out", "/tmp/ansible.5e7eq51k", "-keyout", "/tmp/ansible.zw64ttyw", "-days", "365" ], "delta": "0:00:00.069004", "end": "2024-11-20 08:15:16.613374", "rc": 0, "start": "2024-11-20 08:15:16.544370" } STDERR: Generating a RSA private key .................+++++ ..............................+++++ writing new private key to '/tmp/ansible.zw64ttyw' ----- TASK [Copy certificate files to local tmp] ************************************* task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:32 Wednesday 20 November 2024 08:15:16 -0500 (0:00:00.511) 0:00:06.377 **** changed: [managed-node2] => (item=/tmp/ansible.5e7eq51k) => { "ansible_loop_var": "item", "changed": true, "checksum": "f6475dd7aa7ab4b8df12cacee8aa3d5b42d4c08a", "dest": "/tmp/ansible.5e7eq51k", "item": "/tmp/ansible.5e7eq51k", "md5sum": "c226a21e96d113f5ba1b39e88f0bdc0b", "remote_checksum": "f6475dd7aa7ab4b8df12cacee8aa3d5b42d4c08a", "remote_md5sum": null } changed: [managed-node2] => (item=/tmp/ansible.zw64ttyw) => { "ansible_loop_var": "item", "changed": true, "checksum": "6ca11a539f2845f87218ef95f76fddc29cd93fab", "dest": "/tmp/ansible.zw64ttyw", "item": "/tmp/ansible.zw64ttyw", "md5sum": "decf57e84b2de961fbbab4ce2ee7912c", "remote_checksum": "6ca11a539f2845f87218ef95f76fddc29cd93fab", "remote_md5sum": null } TASK [Copy a private key to the playbook directory to test a relative path] **** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:44 Wednesday 20 November 2024 08:15:17 -0500 (0:00:00.900) 0:00:07.277 **** changed: [managed-node2 -> localhost] => { "changed": true, "checksum": "6ca11a539f2845f87218ef95f76fddc29cd93fab", "dest": "./ansible.zw64ttyw", "gid": 0, "group": "root", "md5sum": "decf57e84b2de961fbbab4ce2ee7912c", "mode": "0600", "owner": "root", "secontext": "unconfined_u:object_r:admin_home_t:s0", "size": 1704, "src": "/root/.ansible/tmp/ansible-tmp-1732108517.5982308-53361-25029146757444/source", "state": "file", "uid": 0 } TASK [Set mssql_tls_cert and mssql_tls_private_key for the following test] ***** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:52 Wednesday 20 November 2024 08:15:18 -0500 (0:00:00.575) 0:00:07.853 **** ok: [managed-node2] => { "ansible_facts": { "mssql_tls_cert": "/tmp/ansible.5e7eq51k", "mssql_tls_private_key": "ansible.zw64ttyw" }, "changed": false } TASK [Run role] **************************************************************** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:59 Wednesday 20 November 2024 08:15:18 -0500 (0:00:00.054) 0:00:07.907 **** TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role] *** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3 Wednesday 20 November 2024 08:15:18 -0500 (0:00:00.229) 0:00:08.137 **** included: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml for managed-node2 TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts used by role] ***** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 Wednesday 20 November 2024 08:15:18 -0500 (0:00:00.029) 0:00:08.166 **** skipping: [managed-node2] => { "changed": false, "false_condition": "__mssql_required_facts | difference(ansible_facts.keys() | list) | length > 0", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Set platform/version specific variables] *** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8 Wednesday 20 November 2024 08:15:18 -0500 (0:00:00.049) 0:00:08.216 **** ok: [managed-node2] => (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-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } skipping: [managed-node2] => (item=CentOS.yml) => { "ansible_loop_var": "item", "changed": false, "false_condition": "__mssql_vars_file is file", "item": "CentOS.yml", "skip_reason": "Conditional result was False" } ok: [managed-node2] => (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-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/CentOS_8.yml" ], "ansible_loop_var": "item", "changed": false, "item": "CentOS_8.yml" } ok: [managed-node2] => (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-Qs1/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 : Unset the __mssql_sqlcmd_login_cmd fact] *** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8 Wednesday 20 November 2024 08:15:18 -0500 (0:00:00.043) 0:00:08.259 **** ok: [managed-node2] => { "ansible_facts": { "__mssql_sqlcmd_login_cmd": null }, "changed": false } TASK [fedora.linux_system_roles.mssql : Print that the mssql_input_sql_file variable is deprecated] *** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:15 Wednesday 20 November 2024 08:15:18 -0500 (0:00:00.014) 0:00:08.273 **** skipping: [managed-node2] => { "false_condition": "mssql_input_sql_file is defined" } TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_input_sql_file fact] *** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:23 Wednesday 20 November 2024 08:15:18 -0500 (0:00:00.017) 0:00:08.291 **** skipping: [managed-node2] => { "changed": false, "false_condition": "mssql_input_sql_file is defined", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Print that the variable is deprecated] *** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:30 Wednesday 20 November 2024 08:15:18 -0500 (0:00:00.017) 0:00:08.308 **** skipping: [managed-node2] => { "false_condition": "mssql_ha_listener_port is defined" } TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_ha_listener_port fact] *** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:37 Wednesday 20 November 2024 08:15:18 -0500 (0:00:00.017) 0:00:08.326 **** skipping: [managed-node2] => { "changed": false, "false_condition": "mssql_ha_listener_port is defined", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Print that the mssql_ad_sql_user_name variable is deprecated] *** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:44 Wednesday 20 November 2024 08:15:18 -0500 (0:00:00.015) 0:00:08.342 **** skipping: [managed-node2] => { "false_condition": "mssql_ad_sql_user_name is defined" } TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_ad_sql_user_name fact] *** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:51 Wednesday 20 November 2024 08:15:18 -0500 (0:00:00.016) 0:00:08.358 **** skipping: [managed-node2] => { "changed": false, "false_condition": "mssql_ad_sql_user_name is defined", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Print that the mssql_ha_cluster_run_role variable is deprecated] *** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:58 Wednesday 20 November 2024 08:15:18 -0500 (0:00:00.017) 0:00:08.376 **** skipping: [managed-node2] => { "false_condition": "mssql_ha_cluster_run_role is defined" } TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_ha_cluster_run_role fact] *** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:65 Wednesday 20 November 2024 08:15:18 -0500 (0:00:00.017) 0:00:08.393 **** skipping: [managed-node2] => { "changed": false, "false_condition": "mssql_ha_cluster_run_role is defined", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Fail on RHEL or CentOS 10 because it's not supported] *** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:69 Wednesday 20 November 2024 08:15:18 -0500 (0:00:00.017) 0:00:08.410 **** skipping: [managed-node2] => { "changed": false, "false_condition": "ansible_distribution_major_version is version('10', '=')", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify that the user accepts EULA variables] *** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:76 Wednesday 20 November 2024 08:15:18 -0500 (0:00:00.017) 0:00:08.428 **** ok: [managed-node2] => { "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-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:88 Wednesday 20 November 2024 08:15:18 -0500 (0:00:00.036) 0:00:08.465 **** skipping: [managed-node2] => { "changed": false, "false_condition": "mssql_ha_configure | bool", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify if the mssql_ha_replica_type variable is provided correctly] *** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:96 Wednesday 20 November 2024 08:15:18 -0500 (0:00:00.031) 0:00:08.496 **** skipping: [managed-node2] => { "changed": false, "false_condition": "mssql_ha_configure | bool", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify that 'mssql_ha_replica_type = primary' is provided once] *** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:105 Wednesday 20 November 2024 08:15:18 -0500 (0:00:00.030) 0:00:08.526 **** skipping: [managed-node2] => { "changed": false, "false_condition": "mssql_ha_configure | bool", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify that mssql_ha_prep_for_pacemaker is provided correctly] *** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:114 Wednesday 20 November 2024 08:15:18 -0500 (0:00:00.031) 0:00:08.558 **** skipping: [managed-node2] => { "changed": false, "false_condition": "mssql_ha_ag_cluster_type | lower == 'none'", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify that selinux variables are used on supported platforms] *** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:124 Wednesday 20 November 2024 08:15:18 -0500 (0:00:00.033) 0:00:08.592 **** skipping: [managed-node2] => { "changed": false, "false_condition": "(mssql_manage_selinux | bool) or (mssql_run_selinux_confined | bool)", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify that mssql_manage_selinux is set properly] *** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:133 Wednesday 20 November 2024 08:15:18 -0500 (0:00:00.034) 0:00:08.627 **** skipping: [managed-node2] => { "changed": false, "false_condition": "mssql_manage_selinux | bool", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Gather package facts] ****************** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:144 Wednesday 20 November 2024 08:15:18 -0500 (0:00:00.031) 0:00:08.658 **** ok: [managed-node2] => { "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-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:148 Wednesday 20 November 2024 08:15:20 -0500 (0:00:02.006) 0:00:10.665 **** skipping: [managed-node2] => (item={'key': 2017, 'value': 14}) => { "ansible_loop_var": "item", "changed": false, "false_condition": "ansible_facts.packages[\"mssql-server\"][0][\"version\"] is defined", "item": { "key": 2017, "value": 14 }, "skip_reason": "Conditional result was False" } skipping: [managed-node2] => (item={'key': 2019, 'value': 15}) => { "ansible_loop_var": "item", "changed": false, "false_condition": "ansible_facts.packages[\"mssql-server\"][0][\"version\"] is defined", "item": { "key": 2019, "value": 15 }, "skip_reason": "Conditional result was False" } skipping: [managed-node2] => (item={'key': 2022, 'value': 16}) => { "ansible_loop_var": "item", "changed": false, "false_condition": "ansible_facts.packages[\"mssql-server\"][0][\"version\"] is defined", "item": { "key": 2022, "value": 16 }, "skip_reason": "Conditional result was False" } skipping: [managed-node2] => { "changed": false } MSG: All items skipped TASK [fedora.linux_system_roles.mssql : Set mssql_version variable if user does not define it] *** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:156 Wednesday 20 November 2024 08:15:21 -0500 (0:00:00.066) 0:00:10.731 **** skipping: [managed-node2] => { "changed": false, "false_condition": "mssql_version is none", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify if the mssql_version variable is provided correctly] *** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:163 Wednesday 20 November 2024 08:15:21 -0500 (0:00:00.035) 0:00:10.766 **** ok: [managed-node2] => { "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-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:170 Wednesday 20 November 2024 08:15:21 -0500 (0:00:00.051) 0:00:10.818 **** skipping: [managed-node2] => (item={'key': 2017, 'value': 14}) => { "ansible_loop_var": "item", "changed": false, "false_condition": "ansible_facts.packages[\"mssql-server\"][0][\"version\"] is defined", "item": { "key": 2017, "value": 14 }, "skip_reason": "Conditional result was False" } skipping: [managed-node2] => (item={'key': 2019, 'value': 15}) => { "ansible_loop_var": "item", "changed": false, "false_condition": "mssql_version | int == item.key", "item": { "key": 2019, "value": 15 }, "skip_reason": "Conditional result was False" } skipping: [managed-node2] => (item={'key': 2022, 'value': 16}) => { "ansible_loop_var": "item", "changed": false, "false_condition": "mssql_version | int == item.key", "item": { "key": 2022, "value": 16 }, "skip_reason": "Conditional result was False" } skipping: [managed-node2] => { "changed": false } MSG: All items skipped TASK [fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories] *** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:184 Wednesday 20 November 2024 08:15:21 -0500 (0:00:00.068) 0:00:10.886 **** ok: [managed-node2] => { "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-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:198 Wednesday 20 November 2024 08:15:21 -0500 (0:00:00.769) 0:00:11.655 **** skipping: [managed-node2] => { "changed": false, "false_condition": "__mssql_current_version is defined", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Get yum repositories] ****************** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:208 Wednesday 20 November 2024 08:15:21 -0500 (0:00:00.032) 0:00:11.687 **** skipping: [managed-node2] => { "changed": false, "false_condition": "__mssql_current_version is defined", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Remove the current Microsoft SQL Server repository to upgrade to 2017] *** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:219 Wednesday 20 November 2024 08:15:22 -0500 (0:00:00.031) 0:00:11.719 **** skipping: [managed-node2] => { "changed": false, "false_condition": "__mssql_current_version is defined", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Update all packages from SQL Server repo version {{ __mssql_current_version }}] *** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:233 Wednesday 20 November 2024 08:15:22 -0500 (0:00:00.063) 0:00:11.783 **** skipping: [managed-node2] => { "changed": false, "false_condition": "__mssql_current_version is defined", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Get zypper repositories] *************** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:242 Wednesday 20 November 2024 08:15:22 -0500 (0:00:00.031) 0:00:11.814 **** skipping: [managed-node2] => { "changed": false, "false_condition": "__mssql_current_version is defined", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Remove the current Microsoft SQL Server repository to upgrade to 2017] *** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:254 Wednesday 20 November 2024 08:15:22 -0500 (0:00:00.032) 0:00:11.846 **** skipping: [managed-node2] => { "changed": false, "false_condition": "__mssql_current_version is defined", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server repo version 2017] *** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:261 Wednesday 20 November 2024 08:15:22 -0500 (0:00:00.032) 0:00:11.878 **** changed: [managed-node2] => { "changed": true, "repo": "packages-microsoft-com-mssql-server-2017", "state": "present" } TASK [fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server repo version 2017] *** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:273 Wednesday 20 November 2024 08:15:22 -0500 (0:00:00.502) 0:00:12.381 **** skipping: [managed-node2] => { "changed": false, "false_condition": "ansible_pkg_mgr == \"zypper\"", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Configure to run as a confined application with SELinux] *** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:286 Wednesday 20 November 2024 08:15:22 -0500 (0:00:00.026) 0:00:12.407 **** ok: [managed-node2] => { "changed": false, "rc": 0, "results": [] } MSG: Nothing to do TASK [fedora.linux_system_roles.mssql : Ensure the package mssql-server] ******* task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:291 Wednesday 20 November 2024 08:15:27 -0500 (0:00:04.439) 0:00:16.846 **** changed: [managed-node2] => { "changed": true, "rc": 0, "results": [ "Installed: gcc-gdb-plugin-8.5.0-22.el8.x86_64", "Installed: gdb-8.2-20.el8.x86_64", "Installed: libipt-1.6.1-8.el8.x86_64", "Installed: guile-5:2.0.14-7.el8.x86_64", "Installed: gdb-headless-8.2-20.el8.x86_64", "Installed: python2-setuptools-39.0.1-14.module_el8+733+876ccfdb.noarch", "Installed: libtool-ltdl-2.4.6-25.el8.x86_64", "Installed: python2-libs-2.7.18-17.module_el8+770+d35395c9.x86_64", "Installed: bzip2-1.0.6-26.el8.x86_64", "Installed: python2-setuptools-wheel-39.0.1-14.module_el8+733+876ccfdb.noarch", "Installed: python2-2.7.18-17.module_el8+770+d35395c9.x86_64", "Installed: mssql-server-14.0.3485.1-1.x86_64", "Installed: lsof-4.93.2-1.el8.x86_64", "Installed: python2-pip-9.0.3-19.module_el8+570+db61b4f9.noarch", "Installed: libatomic-8.5.0-22.el8.x86_64", "Installed: libatomic_ops-7.6.2-3.el8.x86_64", "Installed: python2-pip-wheel-9.0.3-19.module_el8+570+db61b4f9.noarch", "Installed: gc-7.6.4-3.el8.x86_64", "Installed: cyrus-sasl-2.1.27-6.el8_5.x86_64", "Installed: libbabeltrace-1.5.4-4.el8.x86_64", "Installed: cyrus-sasl-gssapi-2.1.27-6.el8_5.x86_64" ] } TASK [fedora.linux_system_roles.mssql : Check if the errorlog file exists and its location] *** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:296 Wednesday 20 November 2024 08:16:09 -0500 (0:00:42.833) 0:00:59.680 **** ok: [managed-node2] => { "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.005972", "end": "2024-11-20 08:16:10.271466", "rc": 0, "start": "2024-11-20 08:16:10.265494" } TASK [fedora.linux_system_roles.mssql : Gather system services facts] ********** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:312 Wednesday 20 November 2024 08:16:10 -0500 (0:00:00.369) 0:01:00.049 **** ok: [managed-node2] => { "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 the __mssql_is_setup variable] ***** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:316 Wednesday 20 November 2024 08:16:12 -0500 (0:00:01.731) 0:01:01.781 **** ok: [managed-node2] => { "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-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:325 Wednesday 20 November 2024 08:16:12 -0500 (0:00:00.058) 0:01:01.839 **** ok: [managed-node2] => { "changed": false } MSG: All assertions passed TASK [fedora.linux_system_roles.mssql : Set up MSSQL] ************************** task path: /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:341 Wednesday 20 November 2024 08:16:12 -0500 (0:00:00.041) 0:01:01.881 **** fatal: [managed-node2]: UNREACHABLE! => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false } PLAY RECAP ********************************************************************* managed-node2 : ok=26 changed=7 unreachable=1 failed=0 skipped=28 rescued=0 ignored=0 Wednesday 20 November 2024 08:16:15 -0500 (0:00:02.866) 0:01:04.747 **** =============================================================================== fedora.linux_system_roles.mssql : Ensure the package mssql-server ------ 42.83s /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:291 fedora.linux_system_roles.mssql : Configure to run as a confined application with SELinux --- 4.44s /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:286 Ensure the openssl package ---------------------------------------------- 3.16s /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:5 fedora.linux_system_roles.mssql : Set up MSSQL -------------------------- 2.87s /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:341 fedora.linux_system_roles.mssql : Gather package facts ------------------ 2.01s /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:144 fedora.linux_system_roles.mssql : Gather system services facts ---------- 1.73s /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:312 Gathering Facts --------------------------------------------------------- 1.26s /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_tls_2017.yml:9 Copy certificate files to local tmp ------------------------------------- 0.90s /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:32 fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories --- 0.77s /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:184 Copy a private key to the playbook directory to test a relative path ---- 0.58s /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:44 Generate a self-signed certificate and public key ----------------------- 0.51s /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:23 fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server repo version 2017 --- 0.50s /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:261 Ensure ansible_facts to get ansible_distribution ------------------------ 0.49s /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:2 Create a tempfile for a certificate on hosts ---------------------------- 0.44s /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:11 fedora.linux_system_roles.mssql : Check if the errorlog file exists and its location --- 0.37s /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:296 Create a tempfile for a private key on hosts ---------------------------- 0.35s /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:17 Run role ---------------------------------------------------------------- 0.23s /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:59 fedora.linux_system_roles.mssql : Verify if mssql_version is not smaller then the existing SQL Server version --- 0.07s /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:170 fedora.linux_system_roles.mssql : Set fact with the currently installed SQL Server version if any --- 0.07s /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:148 fedora.linux_system_roles.mssql : Remove the current Microsoft SQL Server repository to upgrade to 2017 --- 0.06s /tmp/collections-Qs1/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:219