# STDOUT: ---v---v---v---v---v--- ansible-playbook [core 2.17.2] config file = /etc/ansible/ansible.cfg configured module search path = ['/home/jenkins/.ansible/plugins/modules', '/usr/share/ansible/plugins/modules'] ansible python module location = /opt/ansible-2.17/lib/python3.11/site-packages/ansible ansible collection location = /WORKDIR/git-weekly-ciccybexkv/.collection executable location = /opt/ansible-2.17/bin/ansible-playbook python version = 3.11.5 (main, Sep 7 2023, 00:00:00) [GCC 11.4.1 20230605 (Red Hat 11.4.1-2)] (/opt/ansible-2.17/bin/python) jinja version = 3.1.4 libyaml = True Using /etc/ansible/ansible.cfg as config file Skipping callback 'debug', as we already have a stdout callback. Skipping callback 'default', as we already have a stdout callback. Skipping callback 'minimal', as we already have a stdout callback. Skipping callback 'oneline', as we already have a stdout callback. PLAYBOOK: tests_tls_2022.yml *************************************************** 2 plays in /WORKDIR/git-weekly-ciccybexkv/tests/tests_tls_2022.yml PLAY [all] ********************************************************************* TASK [Include vault variables] ************************************************* task path: /WORKDIR/git-weekly-ciccybexkv/tests/tests_tls_2022.yml:4 Saturday 03 August 2024 01:27:03 +0000 (0:00:00.012) 0:00:00.012 ******* ok: [sut] => { "ansible_facts": { "mssql_password": { "__ansible_vault": "$ANSIBLE_VAULT;1.1;AES256\n66336361663164656232326461653662643537386337346563613939356466313835383235313234\n3634333565616161316639666662613564353237653663610a616639306439653033386664303839\n30663030636161326137656235636230356162373234386461363632353863393161353035316162\n3664353366373231360a343334326337353861366233656330363634353164316434616561333161\n3234\n" } }, "ansible_included_var_files": [ "/WORKDIR/git-weekly-ciccybexkv/tests/vars/vault-variables.yml" ], "changed": false } PLAY [Ensure that tls encryption configuration works] ************************** TASK [Gathering Facts] ********************************************************* task path: /WORKDIR/git-weekly-ciccybexkv/tests/tests_tls_2022.yml:9 Saturday 03 August 2024 01:27:03 +0000 (0:00:00.033) 0:00:00.046 ******* ok: [sut] TASK [Run tests_tls with SQL Server 2022] ************************************** task path: /WORKDIR/git-weekly-ciccybexkv/tests/tests_tls_2022.yml:24 Saturday 03 August 2024 01:27:04 +0000 (0:00:00.840) 0:00:00.886 ******* included: /WORKDIR/git-weekly-ciccybexkv/tests/tasks/tests_tls.yml for sut TASK [Assert fail on EL 7 with version = 2022 and EL 9 with version != 2022] *** task path: /WORKDIR/git-weekly-ciccybexkv/tests/tasks/tests_tls.yml:2 Saturday 03 August 2024 01:27:04 +0000 (0:00:00.015) 0:00:00.902 ******* included: /WORKDIR/git-weekly-ciccybexkv/tests/tasks/assert_fail_on_unsupported_ver.yml for sut TASK [Ensure ansible_facts to get ansible_distribution] ************************ task path: /WORKDIR/git-weekly-ciccybexkv/tests/tasks/assert_fail_on_unsupported_ver.yml:2 Saturday 03 August 2024 01:27:04 +0000 (0:00:00.013) 0:00:00.916 ******* ok: [sut] TASK [Run the role] ************************************************************ task path: /WORKDIR/git-weekly-ciccybexkv/tests/tasks/assert_fail_on_unsupported_ver.yml:15 Saturday 03 August 2024 01:27:04 +0000 (0:00:00.344) 0:00:01.260 ******* skipping: [sut] => { "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', '=') and mssql_version | int != 2022)", "skip_reason": "Conditional result was False" } TASK [Unreachable task] ******************************************************** task path: /WORKDIR/git-weekly-ciccybexkv/tests/tasks/assert_fail_on_unsupported_ver.yml:22 Saturday 03 August 2024 01:27:04 +0000 (0:00:00.020) 0:00:01.281 ******* skipping: [sut] => { "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', '=') and mssql_version | int != 2022)", "skip_reason": "Conditional result was False" } TASK [Ensure the openssl package] ********************************************** task path: /WORKDIR/git-weekly-ciccybexkv/tests/tasks/tests_tls.yml:5 Saturday 03 August 2024 01:27:04 +0000 (0:00:00.028) 0:00:01.310 ******* ok: [sut] => { "changed": false, "rc": 0, "results": [] } MSG: Nothing to do lsrpackages: openssl TASK [Create a tempfile for a certificate on hosts] **************************** task path: /WORKDIR/git-weekly-ciccybexkv/tests/tasks/tests_tls.yml:11 Saturday 03 August 2024 01:27:05 +0000 (0:00:00.844) 0:00:02.155 ******* changed: [sut] => { "changed": true, "gid": 0, "group": "root", "mode": "0600", "owner": "root", "path": "/tmp/ansible.yy7fbqau", "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: /WORKDIR/git-weekly-ciccybexkv/tests/tasks/tests_tls.yml:17 Saturday 03 August 2024 01:27:05 +0000 (0:00:00.219) 0:00:02.374 ******* changed: [sut] => { "changed": true, "gid": 0, "group": "root", "mode": "0600", "owner": "root", "path": "/tmp/ansible.4mi8z4js", "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: /WORKDIR/git-weekly-ciccybexkv/tests/tasks/tests_tls.yml:23 Saturday 03 August 2024 01:27:05 +0000 (0:00:00.170) 0:00:02.545 ******* changed: [sut] => { "changed": true, "cmd": [ "openssl", "req", "-x509", "-nodes", "-newkey", "rsa:2048", "-subj", "/CN=10.31.10.20", "-out", "/tmp/ansible.yy7fbqau", "-keyout", "/tmp/ansible.4mi8z4js", "-days", "365" ], "delta": "0:00:00.286590", "end": "2024-08-03 01:27:06.371966", "rc": 0, "start": "2024-08-03 01:27:06.085376" } STDERR: ...+....+.........+..+....+...+...+..+.+.....+++++++++++++++++++++++++++++++++++++++*..+..+......+.+.........+.....+.+......+.........+.....+.+..+.......+...+..+.............+..+.+..+.+.........+.....+...+.......+...+.........+...+++++++++++++++++++++++++++++++++++++++*........+...+............+...+....+.....+...............+...............+...+....++++++ .+..+......+.......+..+.+...........+.............+...............+........+...+............+............+...+...+.+++++++++++++++++++++++++++++++++++++++*......+++++++++++++++++++++++++++++++++++++++*...+.+........+......+...............+....+.........+......+...............+..+.......+...+........+.+...+..................+............+...+.........+......+...+..+......................+..+......+.......+.....+.+..+...+......+....+.....+..........+......+.....+.+.....+....+.....+......+...+....++++++ ----- TASK [Copy certificate files to local tmp] ************************************* task path: /WORKDIR/git-weekly-ciccybexkv/tests/tasks/tests_tls.yml:32 Saturday 03 August 2024 01:27:06 +0000 (0:00:00.610) 0:00:03.156 ******* changed: [sut] => (item=/tmp/ansible.yy7fbqau) => { "ansible_loop_var": "item", "changed": true, "checksum": "a6171fbee9d7fd0b76d361271a8dbbcd14f342fb", "dest": "/tmp/ansible.yy7fbqau", "item": "/tmp/ansible.yy7fbqau", "md5sum": "61946141d05d55c8a20fcacadc7605b2", "remote_checksum": "a6171fbee9d7fd0b76d361271a8dbbcd14f342fb", "remote_md5sum": null } changed: [sut] => (item=/tmp/ansible.4mi8z4js) => { "ansible_loop_var": "item", "changed": true, "checksum": "81fbb4a8fcc5d1164e2c5b38e977181e1adf25dd", "dest": "/tmp/ansible.4mi8z4js", "item": "/tmp/ansible.4mi8z4js", "md5sum": "893e5a8f8ffbe4285f1a6a82920832d7", "remote_checksum": "81fbb4a8fcc5d1164e2c5b38e977181e1adf25dd", "remote_md5sum": null } TASK [Copy a private key to the playbook directory to test a relative path] **** task path: /WORKDIR/git-weekly-ciccybexkv/tests/tasks/tests_tls.yml:44 Saturday 03 August 2024 01:27:06 +0000 (0:00:00.523) 0:00:03.679 ******* changed: [sut -> localhost] => { "changed": true, "checksum": "81fbb4a8fcc5d1164e2c5b38e977181e1adf25dd", "dest": "./ansible.4mi8z4js", "gid": 1001, "group": "jenkins", "md5sum": "893e5a8f8ffbe4285f1a6a82920832d7", "mode": "0600", "owner": "jenkins", "size": 1704, "src": "/home/jenkins/.ansible/tmp/ansible-tmp-1722648426.9582305-11809-36107157348734/.source.4mi8z4js", "state": "file", "uid": 1000090000 } TASK [Set mssql_tls_cert and mssql_tls_private_key for the following test] ***** task path: /WORKDIR/git-weekly-ciccybexkv/tests/tasks/tests_tls.yml:52 Saturday 03 August 2024 01:27:07 +0000 (0:00:00.672) 0:00:04.352 ******* ok: [sut] => { "ansible_facts": { "mssql_tls_cert": "/tmp/ansible.yy7fbqau", "mssql_tls_private_key": "ansible.4mi8z4js" }, "changed": false } TASK [Run role] **************************************************************** task path: /WORKDIR/git-weekly-ciccybexkv/tests/tasks/tests_tls.yml:59 Saturday 03 August 2024 01:27:07 +0000 (0:00:00.033) 0:00:04.386 ******* included: fedora.linux_system_roles.mssql for sut TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role] *** task path: /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3 Saturday 03 August 2024 01:27:07 +0000 (0:00:00.128) 0:00:04.514 ******* included: /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml for sut TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts used by role] ***** task path: /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 Saturday 03 August 2024 01:27:07 +0000 (0:00:00.013) 0:00:04.528 ******* skipping: [sut] => { "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: /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8 Saturday 03 August 2024 01:27:07 +0000 (0:00:00.015) 0:00:04.543 ******* ok: [sut] => (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": [ "/WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } skipping: [sut] => (item=CentOS.yml) => { "ansible_loop_var": "item", "changed": false, "false_condition": "__mssql_vars_file is file", "item": "CentOS.yml", "skip_reason": "Conditional result was False" } skipping: [sut] => (item=CentOS_9.yml) => { "ansible_loop_var": "item", "changed": false, "false_condition": "__mssql_vars_file is file", "item": "CentOS_9.yml", "skip_reason": "Conditional result was False" } skipping: [sut] => (item=CentOS_9.yml) => { "ansible_loop_var": "item", "changed": false, "false_condition": "__mssql_vars_file is file", "item": "CentOS_9.yml", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] *** task path: /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8 Saturday 03 August 2024 01:27:07 +0000 (0:00:00.067) 0:00:04.611 ******* ok: [sut] => { "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: /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:15 Saturday 03 August 2024 01:27:07 +0000 (0:00:00.028) 0:00:04.640 ******* skipping: [sut] => { "false_condition": "mssql_input_sql_file is defined" } TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_input_sql_file fact] *** task path: /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:23 Saturday 03 August 2024 01:27:07 +0000 (0:00:00.045) 0:00:04.686 ******* skipping: [sut] => { "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: /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:30 Saturday 03 August 2024 01:27:07 +0000 (0:00:00.027) 0:00:04.713 ******* skipping: [sut] => { "false_condition": "mssql_ha_listener_port is defined" } TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_ha_listener_port fact] *** task path: /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:37 Saturday 03 August 2024 01:27:07 +0000 (0:00:00.022) 0:00:04.735 ******* skipping: [sut] => { "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: /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:44 Saturday 03 August 2024 01:27:07 +0000 (0:00:00.014) 0:00:04.750 ******* skipping: [sut] => { "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: /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:51 Saturday 03 August 2024 01:27:08 +0000 (0:00:00.015) 0:00:04.765 ******* skipping: [sut] => { "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: /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:58 Saturday 03 August 2024 01:27:08 +0000 (0:00:00.021) 0:00:04.787 ******* skipping: [sut] => { "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: /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:65 Saturday 03 August 2024 01:27:08 +0000 (0:00:00.025) 0:00:04.813 ******* skipping: [sut] => { "changed": false, "false_condition": "mssql_ha_cluster_run_role is defined", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify that the user accepts EULA variables] *** task path: /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:69 Saturday 03 August 2024 01:27:08 +0000 (0:00:00.024) 0:00:04.838 ******* ok: [sut] => { "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: /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:81 Saturday 03 August 2024 01:27:08 +0000 (0:00:00.041) 0:00:04.879 ******* skipping: [sut] => { "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: /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:89 Saturday 03 August 2024 01:27:08 +0000 (0:00:00.015) 0:00:04.894 ******* skipping: [sut] => { "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: /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:98 Saturday 03 August 2024 01:27:08 +0000 (0:00:00.047) 0:00:04.941 ******* skipping: [sut] => { "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: /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:107 Saturday 03 August 2024 01:27:08 +0000 (0:00:00.026) 0:00:04.968 ******* skipping: [sut] => { "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: /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:117 Saturday 03 August 2024 01:27:08 +0000 (0:00:00.031) 0:00:05.000 ******* skipping: [sut] => { "changed": false, "false_condition": "not __mssql_confined_supported", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify that mssql_manage_selinux is set properly] *** task path: /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:126 Saturday 03 August 2024 01:27:08 +0000 (0:00:00.036) 0:00:05.037 ******* skipping: [sut] => { "changed": false, "false_condition": "not mssql_run_selinux_confined", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Gather package facts] ****************** task path: /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:137 Saturday 03 August 2024 01:27:08 +0000 (0:00:00.040) 0:00:05.078 ******* ok: [sut] => { "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: /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:141 Saturday 03 August 2024 01:27:09 +0000 (0:00:00.936) 0:00:06.014 ******* skipping: [sut] => (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: [sut] => (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: [sut] => (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: [sut] => { "changed": false } MSG: All items skipped TASK [fedora.linux_system_roles.mssql : Set mssql_version variable if user does not define it] *** task path: /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:149 Saturday 03 August 2024 01:27:09 +0000 (0:00:00.036) 0:00:06.051 ******* skipping: [sut] => { "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: /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:156 Saturday 03 August 2024 01:27:09 +0000 (0:00:00.021) 0:00:06.073 ******* ok: [sut] => { "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: /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:163 Saturday 03 August 2024 01:27:09 +0000 (0:00:00.039) 0:00:06.112 ******* skipping: [sut] => (item={'key': 2017, 'value': 14}) => { "ansible_loop_var": "item", "changed": false, "false_condition": "mssql_version | int == item.key", "item": { "key": 2017, "value": 14 }, "skip_reason": "Conditional result was False" } skipping: [sut] => (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: [sut] => (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: [sut] => { "changed": false } MSG: All items skipped TASK [fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories] *** task path: /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:177 Saturday 03 August 2024 01:27:09 +0000 (0:00:00.042) 0:00:06.155 ******* ok: [sut] => { "attempts": 1, "changed": false } TASK [fedora.linux_system_roles.mssql : Update all packages from SQL Server repo version {{ __mssql_current_version }}] *** task path: /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:191 Saturday 03 August 2024 01:27:10 +0000 (0:00:01.439) 0:00:07.594 ******* skipping: [sut] => { "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: /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:201 Saturday 03 August 2024 01:27:10 +0000 (0:00:00.025) 0:00:07.620 ******* skipping: [sut] => { "changed": false, "false_condition": "__mssql_current_version is defined", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Remove the current Microsoft SQL Server repository to upgrade to 2022] *** task path: /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:212 Saturday 03 August 2024 01:27:10 +0000 (0:00:00.022) 0:00:07.642 ******* skipping: [sut] => { "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: /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:226 Saturday 03 August 2024 01:27:10 +0000 (0:00:00.045) 0:00:07.688 ******* skipping: [sut] => { "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: /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:235 Saturday 03 August 2024 01:27:10 +0000 (0:00:00.021) 0:00:07.709 ******* skipping: [sut] => { "changed": false, "false_condition": "__mssql_current_version is defined", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Remove the current Microsoft SQL Server repository to upgrade to 2022] *** task path: /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:247 Saturday 03 August 2024 01:27:10 +0000 (0:00:00.023) 0:00:07.733 ******* skipping: [sut] => { "changed": false, "false_condition": "__mssql_current_version is defined", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server repo version 2022] *** task path: /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:254 Saturday 03 August 2024 01:27:11 +0000 (0:00:00.025) 0:00:07.759 ******* redirecting (type: action) ansible.builtin.yum to ansible.builtin.dnf changed: [sut] => { "changed": true, "repo": "packages-microsoft-com-mssql-server-2022", "state": "present" } TASK [fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server repo version 2022] *** task path: /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:266 Saturday 03 August 2024 01:27:11 +0000 (0:00:00.317) 0:00:08.076 ******* skipping: [sut] => { "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: /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:279 Saturday 03 August 2024 01:27:11 +0000 (0:00:00.021) 0:00:08.098 ******* fatal: [sut]: UNREACHABLE! => { "changed": false, "unreachable": true } MSG: Data could not be sent to remote host "10.31.10.20". Make sure this host can be reached over ssh: OpenSSH_8.7p1, OpenSSL 3.0.7 1 Nov 2022 debug1: Reading configuration data /etc/ssh/ssh_config debug1: Reading configuration data /etc/ssh/ssh_config.d/50-redhat.conf debug2: checking match for 'final all' host 10.31.10.20 originally 10.31.10.20 debug2: match not found debug1: Reading configuration data /etc/crypto-policies/back-ends/openssh.config debug1: /etc/ssh/ssh_config line 56: Applying options for * debug1: configuration requests final Match pass debug2: resolve_canonicalize: hostname 10.31.10.20 is address debug1: re-parsing configuration debug1: Reading configuration data /etc/ssh/ssh_config debug1: Reading configuration data /etc/ssh/ssh_config.d/50-redhat.conf debug2: checking match for 'final all' host 10.31.10.20 originally 10.31.10.20 debug2: match found debug1: Reading configuration data /etc/crypto-policies/back-ends/openssh.config debug1: /etc/ssh/ssh_config line 56: Applying options for * debug1: auto-mux: Trying existing master debug2: fd 3 setting O_NONBLOCK debug2: mux_client_hello_exchange: master version 4 debug1: mux_client_request_session: master session id: 2 debug2: Control master terminated unexpectedly to retry, use: --limit @/tmp/tests_tls_2022.retry PLAY RECAP ********************************************************************* sut : ok=21 changed=6 unreachable=1 failed=0 skipped=27 rescued=0 ignored=0 Saturday 03 August 2024 01:27:42 +0000 (0:00:31.442) 0:00:39.540 ******* =============================================================================== fedora.linux_system_roles.mssql : Configure to run as a confined application with SELinux -- 31.44s /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:279 fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories --- 1.44s /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:177 fedora.linux_system_roles.mssql : Gather package facts ------------------ 0.94s /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:137 Ensure the openssl package ---------------------------------------------- 0.84s /WORKDIR/git-weekly-ciccybexkv/tests/tasks/tests_tls.yml:5 -------------------- Gathering Facts --------------------------------------------------------- 0.84s /WORKDIR/git-weekly-ciccybexkv/tests/tests_tls_2022.yml:9 --------------------- Copy a private key to the playbook directory to test a relative path ---- 0.67s /WORKDIR/git-weekly-ciccybexkv/tests/tasks/tests_tls.yml:44 ------------------- Generate a self-signed certificate and public key ----------------------- 0.61s /WORKDIR/git-weekly-ciccybexkv/tests/tasks/tests_tls.yml:23 ------------------- Copy certificate files to local tmp ------------------------------------- 0.52s /WORKDIR/git-weekly-ciccybexkv/tests/tasks/tests_tls.yml:32 ------------------- Ensure ansible_facts to get ansible_distribution ------------------------ 0.34s /WORKDIR/git-weekly-ciccybexkv/tests/tasks/assert_fail_on_unsupported_ver.yml:2 fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server repo version 2022 --- 0.32s /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:254 Create a tempfile for a certificate on hosts ---------------------------- 0.22s /WORKDIR/git-weekly-ciccybexkv/tests/tasks/tests_tls.yml:11 ------------------- Create a tempfile for a private key on hosts ---------------------------- 0.17s /WORKDIR/git-weekly-ciccybexkv/tests/tasks/tests_tls.yml:17 ------------------- Run role ---------------------------------------------------------------- 0.13s /WORKDIR/git-weekly-ciccybexkv/tests/tasks/tests_tls.yml:59 ------------------- fedora.linux_system_roles.mssql : Set platform/version specific variables --- 0.07s /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8 fedora.linux_system_roles.mssql : Verify if the mssql_ha_replica_type variable is provided correctly --- 0.05s /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:89 fedora.linux_system_roles.mssql : Print that the mssql_input_sql_file variable is deprecated --- 0.05s /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:15 fedora.linux_system_roles.mssql : Remove the current Microsoft SQL Server repository to upgrade to 2022 --- 0.05s /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:212 fedora.linux_system_roles.mssql : Verify if mssql_version is not smaller then the existing SQL Server version --- 0.04s /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:163 fedora.linux_system_roles.mssql : Verify that the user accepts EULA variables --- 0.04s /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:69 fedora.linux_system_roles.mssql : Verify that mssql_manage_selinux is set properly --- 0.04s /WORKDIR/git-weekly-ciccybexkv/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:126 ---^---^---^---^---^--- # STDERR: ---v---v---v---v---v--- [DEPRECATION WARNING]: ANSIBLE_COLLECTIONS_PATHS option, does not fit var naming standard, use the singular form ANSIBLE_COLLECTIONS_PATH instead. This feature will be removed from ansible-core in version 2.19. Deprecation warnings can be disabled by setting deprecation_warnings=False in ansible.cfg. [WARNING]: Platform linux on host sut is using the discovered Python interpreter at /usr/bin/python3.9, but future installation of another Python interpreter could change the meaning of that path. See https://docs.ansible.com/ansible- core/2.17/reference_appendices/interpreter_discovery.html for more information. ---^---^---^---^---^---