# STDOUT: ---v---v---v---v---v--- ansible-playbook [core 2.16.0] 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.16/lib/python3.11/site-packages/ansible ansible collection location = /WORKDIR/git-storage-selinuxgb9otk71/.collection executable location = /opt/ansible-2.16/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.16/bin/python) jinja version = 3.1.2 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_2019.yml *************************************************** 2 plays in /WORKDIR/git-storage-selinuxgb9otk71/tests/tests_tls_2019.yml PLAY [all] ********************************************************************* TASK [Include vault variables] ************************************************* task path: /WORKDIR/git-storage-selinuxgb9otk71/tests/tests_tls_2019.yml:4 Wednesday 06 December 2023 10:27:33 +0000 (0:00:00.021) 0:00:00.021 **** 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-storage-selinuxgb9otk71/tests/vars/vault-variables.yml" ], "changed": false } PLAY [Ensure that tls encryption configuration works] ************************** TASK [Gathering Facts] ********************************************************* task path: /WORKDIR/git-storage-selinuxgb9otk71/tests/tests_tls_2019.yml:9 Wednesday 06 December 2023 10:27:33 +0000 (0:00:00.012) 0:00:00.033 **** ok: [sut] TASK [Run tests_tls with SQL Server 2019] ************************************** task path: /WORKDIR/git-storage-selinuxgb9otk71/tests/tests_tls_2019.yml:22 Wednesday 06 December 2023 10:27:39 +0000 (0:00:05.915) 0:00:05.949 **** included: /WORKDIR/git-storage-selinuxgb9otk71/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-storage-selinuxgb9otk71/tests/tasks/tests_tls.yml:2 Wednesday 06 December 2023 10:27:39 +0000 (0:00:00.018) 0:00:05.967 **** included: /WORKDIR/git-storage-selinuxgb9otk71/tests/tasks/assert_fail_on_unsupported_ver.yml for sut TASK [Ensure ansible_facts to get ansible_distribution] ************************ task path: /WORKDIR/git-storage-selinuxgb9otk71/tests/tasks/assert_fail_on_unsupported_ver.yml:2 Wednesday 06 December 2023 10:27:39 +0000 (0:00:00.011) 0:00:05.979 **** ok: [sut] TASK [Run the role] ************************************************************ task path: /WORKDIR/git-storage-selinuxgb9otk71/tests/tasks/assert_fail_on_unsupported_ver.yml:15 Wednesday 06 December 2023 10:27:39 +0000 (0:00:00.344) 0:00:06.323 **** 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-storage-selinuxgb9otk71/tests/tasks/assert_fail_on_unsupported_ver.yml:22 Wednesday 06 December 2023 10:27:39 +0000 (0:00:00.019) 0:00:06.343 **** 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-storage-selinuxgb9otk71/tests/tasks/tests_tls.yml:5 Wednesday 06 December 2023 10:27:39 +0000 (0:00:00.018) 0:00:06.362 **** ok: [sut] => { "changed": false, "rc": 0, "results": [] } MSG: Nothing to do TASK [Create a tempfile for a certificate on hosts] **************************** task path: /WORKDIR/git-storage-selinuxgb9otk71/tests/tasks/tests_tls.yml:11 Wednesday 06 December 2023 10:27:42 +0000 (0:00:02.896) 0:00:09.258 **** changed: [sut] => { "changed": true, "gid": 0, "group": "root", "mode": "0600", "owner": "root", "path": "/tmp/ansible.yprm4iaq", "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-storage-selinuxgb9otk71/tests/tasks/tests_tls.yml:17 Wednesday 06 December 2023 10:27:42 +0000 (0:00:00.237) 0:00:09.496 **** changed: [sut] => { "changed": true, "gid": 0, "group": "root", "mode": "0600", "owner": "root", "path": "/tmp/ansible.02t5yjht", "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-storage-selinuxgb9otk71/tests/tasks/tests_tls.yml:23 Wednesday 06 December 2023 10:27:43 +0000 (0:00:00.182) 0:00:09.678 **** changed: [sut] => { "changed": true, "cmd": [ "openssl", "req", "-x509", "-nodes", "-newkey", "rsa:2048", "-subj", "/CN=10.31.11.4", "-out", "/tmp/ansible.yprm4iaq", "-keyout", "/tmp/ansible.02t5yjht", "-days", "365" ], "delta": "0:00:00.117431", "end": "2023-12-06 10:27:43.470270", "rc": 0, "start": "2023-12-06 10:27:43.352839" } STDERR: Generating a RSA private key ......+++++ .....+++++ writing new private key to '/tmp/ansible.02t5yjht' ----- TASK [Copy certificate files to local tmp] ************************************* task path: /WORKDIR/git-storage-selinuxgb9otk71/tests/tasks/tests_tls.yml:32 Wednesday 06 December 2023 10:27:43 +0000 (0:00:00.359) 0:00:10.038 **** changed: [sut] => (item=/tmp/ansible.yprm4iaq) => { "ansible_loop_var": "item", "changed": true, "checksum": "4b06c7e0a11b2e072a3dff53247eae7eb5fc5449", "dest": "/tmp/ansible.yprm4iaq", "item": "/tmp/ansible.yprm4iaq", "md5sum": "55b0622dffe3f544a4d0fb4079d7bf8a", "remote_checksum": "4b06c7e0a11b2e072a3dff53247eae7eb5fc5449", "remote_md5sum": null } changed: [sut] => (item=/tmp/ansible.02t5yjht) => { "ansible_loop_var": "item", "changed": true, "checksum": "bbabaa50d7c6f95867d5a76e0494d511db4f52e4", "dest": "/tmp/ansible.02t5yjht", "item": "/tmp/ansible.02t5yjht", "md5sum": "0673718c7792b6ca470425a07fd903c8", "remote_checksum": "bbabaa50d7c6f95867d5a76e0494d511db4f52e4", "remote_md5sum": null } TASK [Copy a private key to the playbook directory to test a relative path] **** task path: /WORKDIR/git-storage-selinuxgb9otk71/tests/tasks/tests_tls.yml:44 Wednesday 06 December 2023 10:27:44 +0000 (0:00:00.534) 0:00:10.573 **** changed: [sut -> localhost] => { "changed": true, "checksum": "bbabaa50d7c6f95867d5a76e0494d511db4f52e4", "dest": "./ansible.02t5yjht", "gid": 1001, "group": "jenkins", "md5sum": "0673718c7792b6ca470425a07fd903c8", "mode": "0600", "owner": "jenkins", "size": 1708, "src": "/home/jenkins/.ansible/tmp/ansible-tmp-1701858464.0411952-17703-88065594876534/source", "state": "file", "uid": 1000090000 } TASK [Set mssql_tls_cert and mssql_tls_private_key for the following test] ***** task path: /WORKDIR/git-storage-selinuxgb9otk71/tests/tasks/tests_tls.yml:52 Wednesday 06 December 2023 10:27:44 +0000 (0:00:00.346) 0:00:10.919 **** ok: [sut] => { "ansible_facts": { "mssql_tls_cert": "/tmp/ansible.yprm4iaq", "mssql_tls_private_key": "ansible.02t5yjht" }, "changed": false } TASK [Run role] **************************************************************** task path: /WORKDIR/git-storage-selinuxgb9otk71/tests/tasks/tests_tls.yml:59 Wednesday 06 December 2023 10:27:44 +0000 (0:00:00.026) 0:00:10.946 **** TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role] *** task path: /WORKDIR/git-storage-selinuxgb9otk71/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3 Wednesday 06 December 2023 10:27:44 +0000 (0:00:00.089) 0:00:11.036 **** included: /WORKDIR/git-storage-selinuxgb9otk71/.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-storage-selinuxgb9otk71/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 Wednesday 06 December 2023 10:27:44 +0000 (0:00:00.011) 0:00:11.047 **** 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-storage-selinuxgb9otk71/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8 Wednesday 06 December 2023 10:27:44 +0000 (0:00:00.018) 0:00:11.066 **** 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 ] }, "ansible_included_var_files": [ "/WORKDIR/git-storage-selinuxgb9otk71/.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" } ok: [sut] => (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": [ "/WORKDIR/git-storage-selinuxgb9otk71/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/CentOS_8.yml" ], "ansible_loop_var": "item", "changed": false, "item": "CentOS_8.yml" } ok: [sut] => (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": [ "/WORKDIR/git-storage-selinuxgb9otk71/.collection/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: /WORKDIR/git-storage-selinuxgb9otk71/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8 Wednesday 06 December 2023 10:27:44 +0000 (0:00:00.028) 0:00:11.094 **** 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-storage-selinuxgb9otk71/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:15 Wednesday 06 December 2023 10:27:44 +0000 (0:00:00.010) 0:00:11.104 **** 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-storage-selinuxgb9otk71/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:23 Wednesday 06 December 2023 10:27:44 +0000 (0:00:00.012) 0:00:11.117 **** 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-storage-selinuxgb9otk71/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:30 Wednesday 06 December 2023 10:27:44 +0000 (0:00:00.013) 0:00:11.130 **** 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-storage-selinuxgb9otk71/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:37 Wednesday 06 December 2023 10:27:44 +0000 (0:00:00.010) 0:00:11.140 **** 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-storage-selinuxgb9otk71/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:44 Wednesday 06 December 2023 10:27:44 +0000 (0:00:00.010) 0:00:11.151 **** 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-storage-selinuxgb9otk71/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:51 Wednesday 06 December 2023 10:27:44 +0000 (0:00:00.011) 0:00:11.162 **** 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 : Verify that the user accepts EULA variables] *** task path: /WORKDIR/git-storage-selinuxgb9otk71/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:55 Wednesday 06 December 2023 10:27:44 +0000 (0:00:00.010) 0:00:11.173 **** 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-storage-selinuxgb9otk71/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:67 Wednesday 06 December 2023 10:27:44 +0000 (0:00:00.018) 0:00:11.191 **** 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-storage-selinuxgb9otk71/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:75 Wednesday 06 December 2023 10:27:44 +0000 (0:00:00.015) 0:00:11.207 **** 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-storage-selinuxgb9otk71/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:84 Wednesday 06 December 2023 10:27:44 +0000 (0:00:00.015) 0:00:11.222 **** 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-storage-selinuxgb9otk71/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:93 Wednesday 06 December 2023 10:27:44 +0000 (0:00:00.015) 0:00:11.238 **** 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-storage-selinuxgb9otk71/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:103 Wednesday 06 December 2023 10:27:44 +0000 (0:00:00.015) 0:00:11.253 **** skipping: [sut] => { "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 : Gather package facts] ****************** task path: /WORKDIR/git-storage-selinuxgb9otk71/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:112 Wednesday 06 December 2023 10:27:44 +0000 (0:00:00.016) 0:00:11.269 **** fatal: [sut]: FAILED! => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result" } TASK [Remove a private key from the playbook directory] ************************ task path: /WORKDIR/git-storage-selinuxgb9otk71/tests/tasks/tests_tls.yml:68 Wednesday 06 December 2023 10:27:44 +0000 (0:00:00.007) 0:00:11.277 **** changed: [sut -> localhost] => { "changed": true, "path": "ansible.02t5yjht", "state": "absent" } TASK [Clean up after the role invocation] ************************************** task path: /WORKDIR/git-storage-selinuxgb9otk71/tests/tests_tls_2019.yml:25 Wednesday 06 December 2023 10:27:44 +0000 (0:00:00.216) 0:00:11.494 **** ---^---^---^---^---^--- # 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. ERROR! conflicting action statements: shell, warn The error appears to be in '/WORKDIR/git-storage-selinuxgb9otk71/tests/tasks/cleanup.yml': line 58, column 3, but may be elsewhere in the file depending on the exact syntax problem. The offending line appears to be: - name: Remove related files ^ here ---^---^---^---^---^---