# STDOUT: ---v---v---v---v---v--- ansible-playbook 2.9.27 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.9/lib/python3.9/site-packages/ansible executable location = /opt/ansible-2.9/bin/ansible-playbook python version = 3.9.18 (main, Sep 7 2023, 00:00:00) [GCC 11.4.1 20230605 (Red Hat 11.4.1-2)] Using /etc/ansible/ansible.cfg as config file 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 '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_tls_2017.yml *************************************************** 2 plays in /WORKDIR/git-weekly-ciphj8yeot/tests/tests_tls_2017.yml PLAY [all] ********************************************************************* META: ran handlers TASK [Include vault variables] ************************************************* task path: /WORKDIR/git-weekly-ciphj8yeot/tests/tests_tls_2017.yml:4 Saturday 03 August 2024 01:34:03 +0000 (0:00:00.014) 0:00:00.014 ******* 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-ciphj8yeot/tests/vars/vault-variables.yml" ], "changed": false } META: ran handlers META: ran handlers PLAY [Ensure that tls encryption configuration works] ************************** TASK [Gathering Facts] ********************************************************* task path: /WORKDIR/git-weekly-ciphj8yeot/tests/tests_tls_2017.yml:9 Saturday 03 August 2024 01:34:03 +0000 (0:00:00.010) 0:00:00.024 ******* ok: [sut] META: ran handlers TASK [Run tests_tls with SQL Server 2017] ************************************** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/tests_tls_2017.yml:23 Saturday 03 August 2024 01:34:03 +0000 (0:00:00.551) 0:00:00.575 ******* included: /WORKDIR/git-weekly-ciphj8yeot/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-ciphj8yeot/tests/tasks/tests_tls.yml:2 Saturday 03 August 2024 01:34:03 +0000 (0:00:00.026) 0:00:00.602 ******* included: /WORKDIR/git-weekly-ciphj8yeot/tests/tasks/assert_fail_on_unsupported_ver.yml for sut TASK [Ensure ansible_facts to get ansible_distribution] ************************ task path: /WORKDIR/git-weekly-ciphj8yeot/tests/tasks/assert_fail_on_unsupported_ver.yml:2 Saturday 03 August 2024 01:34:03 +0000 (0:00:00.016) 0:00:00.618 ******* ok: [sut] TASK [Run the role] ************************************************************ task path: /WORKDIR/git-weekly-ciphj8yeot/tests/tasks/assert_fail_on_unsupported_ver.yml:15 Saturday 03 August 2024 01:34:04 +0000 (0:00:00.191) 0:00:00.809 ******* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [Unreachable task] ******************************************************** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/tasks/assert_fail_on_unsupported_ver.yml:22 Saturday 03 August 2024 01:34:04 +0000 (0:00:00.012) 0:00:00.822 ******* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [Ensure the openssl package] ********************************************** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/tasks/tests_tls.yml:5 Saturday 03 August 2024 01:34:04 +0000 (0:00:00.011) 0:00:00.833 ******* ok: [sut] => { "changed": false, "rc": 0, "results": [ "1:openssl-1.0.2k-26.el7_9.x86_64 providing openssl is already installed" ] } lsrpackages: openssl TASK [Create a tempfile for a certificate on hosts] **************************** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/tasks/tests_tls.yml:11 Saturday 03 August 2024 01:34:04 +0000 (0:00:00.423) 0:00:01.257 ******* changed: [sut] => { "changed": true, "gid": 0, "group": "root", "mode": "0600", "owner": "root", "path": "/tmp/ansible.oljWgE", "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-ciphj8yeot/tests/tasks/tests_tls.yml:17 Saturday 03 August 2024 01:34:04 +0000 (0:00:00.168) 0:00:01.425 ******* changed: [sut] => { "changed": true, "gid": 0, "group": "root", "mode": "0600", "owner": "root", "path": "/tmp/ansible.Psd7gq", "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-ciphj8yeot/tests/tasks/tests_tls.yml:23 Saturday 03 August 2024 01:34:04 +0000 (0:00:00.101) 0:00:01.527 ******* changed: [sut] => { "changed": true, "cmd": [ "openssl", "req", "-x509", "-nodes", "-newkey", "rsa:2048", "-subj", "/CN=10.31.40.114", "-out", "/tmp/ansible.oljWgE", "-keyout", "/tmp/ansible.Psd7gq", "-days", "365" ], "delta": "0:00:00.350606", "end": "2024-08-03 01:34:05.280687", "rc": 0, "start": "2024-08-03 01:34:04.930081" } STDERR: Generating a 2048 bit RSA private key .......................................................................................................+++ .................+++ writing new private key to '/tmp/ansible.Psd7gq' ----- TASK [Copy certificate files to local tmp] ************************************* task path: /WORKDIR/git-weekly-ciphj8yeot/tests/tasks/tests_tls.yml:32 Saturday 03 August 2024 01:34:05 +0000 (0:00:00.518) 0:00:02.046 ******* changed: [sut] => (item=/tmp/ansible.oljWgE) => { "ansible_loop_var": "item", "changed": true, "checksum": "9f3d2733cbd953dea421180346e5c41888cd6145", "dest": "/tmp/ansible.oljWgE", "item": "/tmp/ansible.oljWgE", "md5sum": "22f788cf5c60850b8652d6d8615a31ba", "remote_checksum": "9f3d2733cbd953dea421180346e5c41888cd6145", "remote_md5sum": null } changed: [sut] => (item=/tmp/ansible.Psd7gq) => { "ansible_loop_var": "item", "changed": true, "checksum": "b1a5a0f7df8b292f7ffaa3294b7198d3252fce3e", "dest": "/tmp/ansible.Psd7gq", "item": "/tmp/ansible.Psd7gq", "md5sum": "1daaa8d94495ea32057bfaa5caa1edb4", "remote_checksum": "b1a5a0f7df8b292f7ffaa3294b7198d3252fce3e", "remote_md5sum": null } TASK [Copy a private key to the playbook directory to test a relative path] **** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/tasks/tests_tls.yml:44 Saturday 03 August 2024 01:34:05 +0000 (0:00:00.355) 0:00:02.402 ******* changed: [sut -> localhost] => { "changed": true, "checksum": "b1a5a0f7df8b292f7ffaa3294b7198d3252fce3e", "dest": "./ansible.Psd7gq", "gid": 1001, "group": "jenkins", "md5sum": "1daaa8d94495ea32057bfaa5caa1edb4", "mode": "0600", "owner": "jenkins", "size": 1704, "src": "/home/jenkins/.ansible/tmp/ansible-tmp-1722648845.6738582-21119-90294382096501/source", "state": "file", "uid": 1000090000 } TASK [Set mssql_tls_cert and mssql_tls_private_key for the following test] ***** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/tasks/tests_tls.yml:52 Saturday 03 August 2024 01:34:05 +0000 (0:00:00.279) 0:00:02.681 ******* ok: [sut] => { "ansible_facts": { "mssql_tls_cert": "/tmp/ansible.oljWgE", "mssql_tls_private_key": "ansible.Psd7gq" }, "changed": false } TASK [Run role] **************************************************************** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/tasks/tests_tls.yml:59 Saturday 03 August 2024 01:34:05 +0000 (0:00:00.010) 0:00:02.692 ******* TASK [linux-system-roles.mssql : Ensure ansible_facts and variables used by role] *** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:3 Saturday 03 August 2024 01:34:06 +0000 (0:00:00.130) 0:00:02.823 ******* included: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml for sut TASK [linux-system-roles.mssql : Ensure ansible_facts used by role] ************ task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:3 Saturday 03 August 2024 01:34:06 +0000 (0:00:00.011) 0:00:02.835 ******* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Set platform/version specific variables] ****** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:9 Saturday 03 August 2024 01:34:06 +0000 (0:00:00.011) 0:00:02.846 ******* 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-ciphj8yeot/tests/roles/linux-system-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, "item": "CentOS.yml", "skip_reason": "Conditional result was False" } ok: [sut] => (item=CentOS_7.yml) => { "ansible_facts": { "__mssql_client_repository": "https://packages.microsoft.com/rhel/7/prod/", "__mssql_confined_supported": false, "__mssql_server_repository": "https://packages.microsoft.com/rhel/7/mssql-server-{{ mssql_version | int }}/", "__mssql_supported_versions": [ 2017, 2019 ] }, "ansible_included_var_files": [ "/WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/vars/CentOS_7.yml" ], "ansible_loop_var": "item", "changed": false, "item": "CentOS_7.yml" } skipping: [sut] => (item=CentOS_7.9.yml) => { "ansible_loop_var": "item", "changed": false, "item": "CentOS_7.9.yml", "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ****** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:8 Saturday 03 August 2024 01:34:06 +0000 (0:00:00.025) 0:00:02.871 ******* ok: [sut] => { "ansible_facts": { "__mssql_sqlcmd_login_cmd": null }, "changed": false } TASK [linux-system-roles.mssql : Print that the mssql_input_sql_file variable is deprecated] *** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:15 Saturday 03 August 2024 01:34:06 +0000 (0:00:00.009) 0:00:02.881 ******* skipping: [sut] => {} TASK [linux-system-roles.mssql : Link the deprecated mssql_input_sql_file fact] *** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:23 Saturday 03 August 2024 01:34:06 +0000 (0:00:00.009) 0:00:02.891 ******* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Print that the variable is deprecated] ******** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:30 Saturday 03 August 2024 01:34:06 +0000 (0:00:00.009) 0:00:02.900 ******* skipping: [sut] => {} TASK [linux-system-roles.mssql : Link the deprecated mssql_ha_listener_port fact] *** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:37 Saturday 03 August 2024 01:34:06 +0000 (0:00:00.009) 0:00:02.910 ******* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Print that the mssql_ad_sql_user_name variable is deprecated] *** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:44 Saturday 03 August 2024 01:34:06 +0000 (0:00:00.009) 0:00:02.920 ******* skipping: [sut] => {} TASK [linux-system-roles.mssql : Link the deprecated mssql_ad_sql_user_name fact] *** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:51 Saturday 03 August 2024 01:34:06 +0000 (0:00:00.009) 0:00:02.930 ******* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Print that the mssql_ha_cluster_run_role variable is deprecated] *** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:58 Saturday 03 August 2024 01:34:06 +0000 (0:00:00.009) 0:00:02.939 ******* skipping: [sut] => {} TASK [linux-system-roles.mssql : Link the deprecated mssql_ha_cluster_run_role fact] *** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:65 Saturday 03 August 2024 01:34:06 +0000 (0:00:00.009) 0:00:02.949 ******* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Verify that the user accepts EULA variables] *** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:69 Saturday 03 August 2024 01:34:06 +0000 (0:00:00.009) 0:00:02.959 ******* ok: [sut] => { "changed": false } MSG: All assertions passed TASK [linux-system-roles.mssql : Verify that EL < 8 is not used with mssql_ha_configure=true] *** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:81 Saturday 03 August 2024 01:34:06 +0000 (0:00:00.013) 0:00:02.972 ******* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Verify if the mssql_ha_replica_type variable is provided correctly] *** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:89 Saturday 03 August 2024 01:34:06 +0000 (0:00:00.009) 0:00:02.981 ******* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Verify that 'mssql_ha_replica_type = primary' is provided once] *** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:98 Saturday 03 August 2024 01:34:06 +0000 (0:00:00.009) 0:00:02.991 ******* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Verify that mssql_ha_prep_for_pacemaker is provided correctly] *** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:111 Saturday 03 August 2024 01:34:06 +0000 (0:00:00.008) 0:00:02.999 ******* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Verify that selinux variables are used on supported platforms] *** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:122 Saturday 03 August 2024 01:34:06 +0000 (0:00:00.009) 0:00:03.009 ******* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Verify that mssql_manage_selinux is set properly] *** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:131 Saturday 03 August 2024 01:34:06 +0000 (0:00:00.010) 0:00:03.020 ******* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Gather package facts] ************************* task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:142 Saturday 03 August 2024 01:34:06 +0000 (0:00:00.008) 0:00:03.028 ******* ok: [sut] => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false } TASK [linux-system-roles.mssql : Set fact with the currently installed SQL Server version if any] *** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:146 Saturday 03 August 2024 01:34:07 +0000 (0:00:00.949) 0:00:03.977 ******* skipping: [sut] => (item={'key': 2017, 'value': 14}) => { "ansible_loop_var": "item", "changed": false, "item": { "key": 2017, "value": 14 }, "skip_reason": "Conditional result was False" } skipping: [sut] => (item={'key': 2019, 'value': 15}) => { "ansible_loop_var": "item", "changed": false, "item": { "key": 2019, "value": 15 }, "skip_reason": "Conditional result was False" } skipping: [sut] => (item={'key': 2022, 'value': 16}) => { "ansible_loop_var": "item", "changed": false, "item": { "key": 2022, "value": 16 }, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Set mssql_version variable if user does not define it] *** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:155 Saturday 03 August 2024 01:34:07 +0000 (0:00:00.035) 0:00:04.013 ******* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Verify if the mssql_version variable is provided correctly] *** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:162 Saturday 03 August 2024 01:34:07 +0000 (0:00:00.018) 0:00:04.032 ******* ok: [sut] => { "changed": false } MSG: All assertions passed TASK [linux-system-roles.mssql : Verify if mssql_version is not smaller then the existing SQL Server version] *** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:169 Saturday 03 August 2024 01:34:07 +0000 (0:00:00.020) 0:00:04.052 ******* skipping: [sut] => (item={'key': 2017, 'value': 14}) => { "ansible_loop_var": "item", "changed": false, "item": { "key": 2017, "value": 14 }, "skip_reason": "Conditional result was False" } skipping: [sut] => (item={'key': 2019, 'value': 15}) => { "ansible_loop_var": "item", "changed": false, "item": { "key": 2019, "value": 15 }, "skip_reason": "Conditional result was False" } skipping: [sut] => (item={'key': 2022, 'value': 16}) => { "ansible_loop_var": "item", "changed": false, "item": { "key": 2022, "value": 16 }, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories] *** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:184 Saturday 03 August 2024 01:34:07 +0000 (0:00:00.031) 0:00:04.083 ******* ok: [sut] => { "attempts": 1, "changed": false } TASK [linux-system-roles.mssql : Update all packages from SQL Server repo version {{ __mssql_current_version }}] *** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:198 Saturday 03 August 2024 01:34:07 +0000 (0:00:00.389) 0:00:04.473 ******* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Get yum repositories] ************************* task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:208 Saturday 03 August 2024 01:34:07 +0000 (0:00:00.020) 0:00:04.493 ******* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Remove the current Microsoft SQL Server repository to upgrade to 2017] *** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:219 Saturday 03 August 2024 01:34:07 +0000 (0:00:00.018) 0:00:04.511 ******* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Update all packages from SQL Server repo version {{ __mssql_current_version }}] *** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:233 Saturday 03 August 2024 01:34:07 +0000 (0:00:00.019) 0:00:04.531 ******* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Get zypper repositories] ********************** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:242 Saturday 03 August 2024 01:34:07 +0000 (0:00:00.018) 0:00:04.549 ******* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Remove the current Microsoft SQL Server repository to upgrade to 2017] *** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:254 Saturday 03 August 2024 01:34:07 +0000 (0:00:00.020) 0:00:04.570 ******* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Configure the Microsoft SQL Server repo version 2017] *** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:261 Saturday 03 August 2024 01:34:07 +0000 (0:00:00.019) 0:00:04.589 ******* changed: [sut] => { "changed": true, "repo": "packages-microsoft-com-mssql-server-2017", "state": "present" } TASK [linux-system-roles.mssql : Configure the Microsoft SQL Server repo version 2017] *** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:273 Saturday 03 August 2024 01:34:08 +0000 (0:00:00.216) 0:00:04.805 ******* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Configure to run as a confined application with SELinux] *** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:286 Saturday 03 August 2024 01:34:08 +0000 (0:00:00.018) 0:00:04.824 ******* ok: [sut] => { "changed": false, "rc": 0, "results": [ "mssql-server-selinux is not installed" ] } TASK [linux-system-roles.mssql : Ensure the package mssql-server] ************** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:291 Saturday 03 August 2024 01:34:08 +0000 (0:00:00.349) 0:00:05.173 ******* changed: [sut] => { "changed": true, "changes": { "installed": [ "mssql-server" ] }, "rc": 0, "results": [ "Loaded plugins: fastestmirror\nLoading mirror speeds from cached hostfile\nResolving Dependencies\n--> Running transaction check\n---> Package mssql-server.x86_64 0:14.0.3465.1-1 will be installed\n--> Processing Dependency: libatomic for package: mssql-server-14.0.3465.1-1.x86_64\n--> Processing Dependency: bzip2 for package: mssql-server-14.0.3465.1-1.x86_64\n--> Processing Dependency: gdb for package: mssql-server-14.0.3465.1-1.x86_64\n--> Processing Dependency: libsss_nss_idmap for package: mssql-server-14.0.3465.1-1.x86_64\n--> Processing Dependency: cyrus-sasl for package: mssql-server-14.0.3465.1-1.x86_64\n--> Processing Dependency: cyrus-sasl-gssapi for package: mssql-server-14.0.3465.1-1.x86_64\n--> Running transaction check\n---> Package bzip2.x86_64 0:1.0.6-13.el7 will be installed\n---> Package cyrus-sasl.x86_64 0:2.1.26-24.el7_9 will be installed\n---> Package cyrus-sasl-gssapi.x86_64 0:2.1.26-24.el7_9 will be installed\n---> Package gdb.x86_64 0:7.6.1-120.el7 will be installed\n---> Package libatomic.x86_64 0:4.8.5-44.el7 will be installed\n---> Package libsss_nss_idmap.x86_64 0:1.16.5-10.el7_9.16 will be installed\n--> Finished Dependency Resolution\n\nDependencies Resolved\n\n================================================================================\n Package Arch Version Repository Size\n================================================================================\nInstalling:\n mssql-server x86_64 14.0.3465.1-1 packages-microsoft-com-mssql-server-2017\n 200 M\nInstalling for dependencies:\n bzip2 x86_64 1.0.6-13.el7 base 52 k\n cyrus-sasl x86_64 2.1.26-24.el7_9 updates 88 k\n cyrus-sasl-gssapi x86_64 2.1.26-24.el7_9 updates 41 k\n gdb x86_64 7.6.1-120.el7 base 2.4 M\n libatomic x86_64 4.8.5-44.el7 base 51 k\n libsss_nss_idmap x86_64 1.16.5-10.el7_9.16 updates 170 k\n\nTransaction Summary\n================================================================================\nInstall 1 Package (+6 Dependent packages)\n\nTotal size: 203 M\nInstalled size: 1.0 G\nDownloading packages:\nRunning transaction check\nRunning transaction test\nTransaction test succeeded\nRunning transaction\n Installing : libatomic-4.8.5-44.el7.x86_64 1/7 \n Installing : cyrus-sasl-2.1.26-24.el7_9.x86_64 2/7 \n Installing : gdb-7.6.1-120.el7.x86_64 3/7 \n Installing : cyrus-sasl-gssapi-2.1.26-24.el7_9.x86_64 4/7 \n Installing : bzip2-1.0.6-13.el7.x86_64 5/7 \n Installing : libsss_nss_idmap-1.16.5-10.el7_9.16.x86_64 6/7 \n Installing : mssql-server-14.0.3465.1-1.x86_64 7/7 \n\n+--------------------------------------------------------------+\nPlease run 'sudo /opt/mssql/bin/mssql-conf setup'\nto complete the setup of Microsoft SQL Server\n+--------------------------------------------------------------+\n\nSQL Server needs to be restarted in order to apply this setting. Please run\n'systemctl restart mssql-server.service'.\n Verifying : libsss_nss_idmap-1.16.5-10.el7_9.16.x86_64 1/7 \n Verifying : bzip2-1.0.6-13.el7.x86_64 2/7 \n Verifying : mssql-server-14.0.3465.1-1.x86_64 3/7 \n Verifying : cyrus-sasl-gssapi-2.1.26-24.el7_9.x86_64 4/7 \n Verifying : gdb-7.6.1-120.el7.x86_64 5/7 \n Verifying : cyrus-sasl-2.1.26-24.el7_9.x86_64 6/7 \n Verifying : libatomic-4.8.5-44.el7.x86_64 7/7 \n\nInstalled:\n mssql-server.x86_64 0:14.0.3465.1-1 \n\nDependency Installed:\n bzip2.x86_64 0:1.0.6-13.el7 \n cyrus-sasl.x86_64 0:2.1.26-24.el7_9 \n cyrus-sasl-gssapi.x86_64 0:2.1.26-24.el7_9 \n gdb.x86_64 0:7.6.1-120.el7 \n libatomic.x86_64 0:4.8.5-44.el7 \n libsss_nss_idmap.x86_64 0:1.16.5-10.el7_9.16 \n\nComplete!\n" ] } lsrpackages: mssql-server TASK [linux-system-roles.mssql : Ensure that the openldap-compat package is installed] *** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:299 Saturday 03 August 2024 01:34:39 +0000 (0:00:30.868) 0:00:36.042 ******* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Check if the errorlog file exists and its location] *** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:307 Saturday 03 August 2024 01:34:39 +0000 (0:00:00.018) 0:00:36.060 ******* ok: [sut] => { "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.004738", "end": "2024-08-03 01:34:39.423242", "rc": 0, "start": "2024-08-03 01:34:39.418504" } TASK [linux-system-roles.mssql : Gather system services facts] ***************** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:323 Saturday 03 August 2024 01:34:39 +0000 (0:00:00.123) 0:00:36.183 ******* ok: [sut] => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false } TASK [linux-system-roles.mssql : Set the __mssql_is_setup variable] ************ task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:327 Saturday 03 August 2024 01:34:40 +0000 (0:00:00.679) 0:00:36.863 ******* ok: [sut] => { "ansible_facts": { "__mssql_is_setup": false }, "changed": false } TASK [linux-system-roles.mssql : Verify that the variables required for setting up MSSQL are defined] *** task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:336 Saturday 03 August 2024 01:34:40 +0000 (0:00:00.027) 0:00:36.890 ******* ok: [sut] => { "changed": false } MSG: All assertions passed TASK [linux-system-roles.mssql : Set up MSSQL] ********************************* task path: /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:352 Saturday 03 August 2024 01:34:40 +0000 (0:00:00.024) 0:00:36.915 ******* fatal: [sut]: UNREACHABLE! => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false } to retry, use: --limit @/tmp/tests_tls_2017.retry PLAY RECAP ********************************************************************* sut : ok=26 changed=7 unreachable=1 failed=0 skipped=28 rescued=0 ignored=0 Saturday 03 August 2024 01:34:42 +0000 (0:00:02.734) 0:00:39.649 ******* =============================================================================== linux-system-roles.mssql : Ensure the package mssql-server ------------- 30.87s /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:291 linux-system-roles.mssql : Set up MSSQL --------------------------------- 2.73s /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:352 linux-system-roles.mssql : Gather package facts ------------------------- 0.95s /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:142 linux-system-roles.mssql : Gather system services facts ----------------- 0.68s /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:323 Gathering Facts --------------------------------------------------------- 0.55s /WORKDIR/git-weekly-ciphj8yeot/tests/tests_tls_2017.yml:9 --------------------- Generate a self-signed certificate and public key ----------------------- 0.52s /WORKDIR/git-weekly-ciphj8yeot/tests/tasks/tests_tls.yml:23 ------------------- Ensure the openssl package ---------------------------------------------- 0.42s /WORKDIR/git-weekly-ciphj8yeot/tests/tasks/tests_tls.yml:5 -------------------- linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories --- 0.39s /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:184 Copy certificate files to local tmp ------------------------------------- 0.36s /WORKDIR/git-weekly-ciphj8yeot/tests/tasks/tests_tls.yml:32 ------------------- linux-system-roles.mssql : Configure to run as a confined application with SELinux --- 0.35s /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:286 Copy a private key to the playbook directory to test a relative path ---- 0.28s /WORKDIR/git-weekly-ciphj8yeot/tests/tasks/tests_tls.yml:44 ------------------- linux-system-roles.mssql : Configure the Microsoft SQL Server repo version 2017 --- 0.22s /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:261 Ensure ansible_facts to get ansible_distribution ------------------------ 0.19s /WORKDIR/git-weekly-ciphj8yeot/tests/tasks/assert_fail_on_unsupported_ver.yml:2 Create a tempfile for a certificate on hosts ---------------------------- 0.17s /WORKDIR/git-weekly-ciphj8yeot/tests/tasks/tests_tls.yml:11 ------------------- Run role ---------------------------------------------------------------- 0.13s /WORKDIR/git-weekly-ciphj8yeot/tests/tasks/tests_tls.yml:59 ------------------- linux-system-roles.mssql : Check if the errorlog file exists and its location --- 0.12s /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:307 Create a tempfile for a private key on hosts ---------------------------- 0.10s /WORKDIR/git-weekly-ciphj8yeot/tests/tasks/tests_tls.yml:17 ------------------- linux-system-roles.mssql : Set fact with the currently installed SQL Server version if any --- 0.04s /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:146 linux-system-roles.mssql : Verify if mssql_version is not smaller then the existing SQL Server version --- 0.03s /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:169 linux-system-roles.mssql : Set the __mssql_is_setup variable ------------ 0.03s /WORKDIR/git-weekly-ciphj8yeot/tests/roles/linux-system-roles.mssql/tasks/main.yml:327 ---^---^---^---^---^--- # STDERR: ---v---v---v---v---v--- ---^---^---^---^---^---