ansible-playbook [core 2.12.6] config file = /etc/ansible/ansible.cfg configured module search path = ['/root/.ansible/plugins/modules', '/usr/share/ansible/plugins/modules'] ansible python module location = /usr/lib/python3.9/site-packages/ansible ansible collection location = /tmp/tmpc9shnupj executable location = /usr/bin/ansible-playbook python version = 3.9.13 (main, May 18 2022, 00:00:00) [GCC 11.3.1 20220421 (Red Hat 11.3.1-2)] jinja version = 2.11.3 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: rhel-7_setup.yml ***************************************************** 1 plays in /cache/rhel-7_setup.yml PLAY [Setup repos] ************************************************************* META: ran handlers TASK [set up internal repositories] ******************************************** task path: /cache/rhel-7_setup.yml:5 Wednesday 03 August 2022 16:23:35 +0000 (0:00:00.018) 0:00:00.018 ****** changed: [/cache/rhel-7.qcow2] => (item=None) => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": true } changed: [/cache/rhel-7.qcow2] => (item=None) => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": true } changed: [/cache/rhel-7.qcow2] => (item=None) => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": true } changed: [/cache/rhel-7.qcow2] => (item=None) => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": true } changed: [/cache/rhel-7.qcow2] => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": true } META: ran handlers META: ran handlers PLAY RECAP ********************************************************************* /cache/rhel-7.qcow2 : ok=1 changed=1 unreachable=0 failed=0 skipped=0 rescued=0 ignored=0 Wednesday 03 August 2022 16:23:36 +0000 (0:00:01.434) 0:00:01.452 ****** =============================================================================== set up internal repositories -------------------------------------------- 1.43s /cache/rhel-7_setup.yml:5 ----------------------------------------------------- PLAYBOOK: tests_accept_eula_2019.yml ******************************************* 1 plays in /tmp/tmpg0n6vuiy/tests/tests_accept_eula_2019.yml PLAY [Ensure that the role runs when EULA are accepted] ************************ TASK [Gathering Facts] ********************************************************* task path: /tmp/tmpg0n6vuiy/tests/tests_accept_eula_2019.yml:3 Wednesday 03 August 2022 16:23:36 +0000 (0:00:00.009) 0:00:01.461 ****** ok: [/cache/rhel-7.qcow2] META: ran handlers TASK [Run the role with default parameters] ************************************ task path: /tmp/tmpg0n6vuiy/tests/tests_accept_eula_2019.yml:12 Wednesday 03 August 2022 16:23:37 +0000 (0:00:00.980) 0:00:02.441 ****** TASK [linux-system-roles.mssql : Ensure ansible_facts and variables used by role] *** task path: /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:3 Wednesday 03 August 2022 16:23:37 +0000 (0:00:00.086) 0:00:02.528 ****** included: /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml for /cache/rhel-7.qcow2 TASK [linux-system-roles.mssql : Ensure ansible_facts used by role] ************ task path: /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:3 Wednesday 03 August 2022 16:23:37 +0000 (0:00:00.028) 0:00:02.557 ****** ok: [/cache/rhel-7.qcow2] TASK [linux-system-roles.mssql : Set platform/version specific variables] ****** task path: /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:11 Wednesday 03 August 2022 16:23:38 +0000 (0:00:00.429) 0:00:02.986 ****** ok: [/cache/rhel-7.qcow2] => (item=RedHat.yml) => { "ansible_facts": { "__mssql_client_repository": "https://packages.microsoft.com/rhel/8/prod/", "__mssql_server_repository": "https://packages.microsoft.com/rhel/8/mssql-server-{{ mssql_version | int }}/" }, "ansible_included_var_files": [ "/tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } ok: [/cache/rhel-7.qcow2] => (item=RedHat.yml) => { "ansible_facts": { "__mssql_client_repository": "https://packages.microsoft.com/rhel/8/prod/", "__mssql_server_repository": "https://packages.microsoft.com/rhel/8/mssql-server-{{ mssql_version | int }}/" }, "ansible_included_var_files": [ "/tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } ok: [/cache/rhel-7.qcow2] => (item=RedHat_7.yml) => { "ansible_facts": { "__mssql_client_repository": "https://packages.microsoft.com/rhel/7/prod/", "__mssql_server_repository": "https://packages.microsoft.com/rhel/7/mssql-server-{{ mssql_version | int }}/" }, "ansible_included_var_files": [ "/tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/vars/RedHat_7.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat_7.yml" } skipping: [/cache/rhel-7.qcow2] => (item=RedHat_7.9.yml) => { "ansible_loop_var": "item", "changed": false, "item": "RedHat_7.9.yml", "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ****** task path: /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:8 Wednesday 03 August 2022 16:23:38 +0000 (0:00:00.064) 0:00:03.050 ****** ok: [/cache/rhel-7.qcow2] => { "ansible_facts": { "__mssql_sqlcmd_login_cmd": null }, "changed": false } TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ****** task path: /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:12 Wednesday 03 August 2022 16:23:38 +0000 (0:00:00.026) 0:00:03.076 ****** ok: [/cache/rhel-7.qcow2] => { "ansible_facts": { "__mssql_sqlcmd_login_cmd": null }, "changed": false } TASK [linux-system-roles.mssql : Link the deprecated accept_microsoft_sql_server_2019_standard_eula fact] *** task path: /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:16 Wednesday 03 August 2022 16:23:38 +0000 (0:00:00.026) 0:00:03.103 ****** skipping: [/cache/rhel-7.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Link the deprecated mssql_input_sql_file fact] *** task path: /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:22 Wednesday 03 August 2022 16:23:38 +0000 (0:00:00.021) 0:00:03.124 ****** skipping: [/cache/rhel-7.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Verify that the user accepts EULA variables] *** task path: /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:27 Wednesday 03 August 2022 16:23:38 +0000 (0:00:00.022) 0:00:03.146 ****** ok: [/cache/rhel-7.qcow2] => { "changed": false } MSG: All assertions passed TASK [linux-system-roles.mssql : Verify if the mssql_version variable is provided correctly] *** task path: /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:39 Wednesday 03 August 2022 16:23:38 +0000 (0:00:00.043) 0:00:03.189 ****** ok: [/cache/rhel-7.qcow2] => { "changed": false } MSG: All assertions passed TASK [linux-system-roles.mssql : Verify if the mssql_upgrade variable is provided correctly] *** task path: /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:44 Wednesday 03 August 2022 16:23:38 +0000 (0:00:00.043) 0:00:03.233 ****** skipping: [/cache/rhel-7.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Verify that EL < 8 is not used with mssql_ha_configure=true] *** task path: /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:55 Wednesday 03 August 2022 16:23:38 +0000 (0:00:00.031) 0:00:03.264 ****** skipping: [/cache/rhel-7.qcow2] => { "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: /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:63 Wednesday 03 August 2022 16:23:38 +0000 (0:00:00.030) 0:00:03.295 ****** skipping: [/cache/rhel-7.qcow2] => { "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: /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:72 Wednesday 03 August 2022 16:23:38 +0000 (0:00:00.030) 0:00:03.326 ****** skipping: [/cache/rhel-7.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Gather package facts] ************************* task path: /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:85 Wednesday 03 August 2022 16:23:38 +0000 (0:00:00.031) 0:00:03.357 ****** ok: [/cache/rhel-7.qcow2] => { "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 : Verify if mssql_version is not smaller then the existing SQL Server version] *** task path: /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:90 Wednesday 03 August 2022 16:23:39 +0000 (0:00:01.186) 0:00:04.544 ****** skipping: [/cache/rhel-7.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories] *** task path: /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:101 Wednesday 03 August 2022 16:23:39 +0000 (0:00:00.046) 0:00:04.590 ****** changed: [/cache/rhel-7.qcow2] => { "changed": true } TASK [linux-system-roles.mssql : Update all packages from SQL Server 2017 repo] *** task path: /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:107 Wednesday 03 August 2022 16:23:40 +0000 (0:00:00.726) 0:00:05.317 ****** skipping: [/cache/rhel-7.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Remove the Microsoft SQL Server 2017 repository to upgrade to 2019] *** task path: /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:118 Wednesday 03 August 2022 16:23:40 +0000 (0:00:00.049) 0:00:05.366 ****** skipping: [/cache/rhel-7.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Configure the Microsoft SQL Server 2019 repository] *** task path: /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:124 Wednesday 03 August 2022 16:23:40 +0000 (0:00:00.046) 0:00:05.412 ****** changed: [/cache/rhel-7.qcow2] => { "changed": true, "repo": "packages-microsoft-com-mssql-server-2019", "state": "present" } TASK [linux-system-roles.mssql : Ensure the mssql-server package] ************** task path: /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:134 Wednesday 03 August 2022 16:23:40 +0000 (0:00:00.349) 0:00:05.762 ****** changed: [/cache/rhel-7.qcow2] => { "changed": true, "changes": { "installed": [ "mssql-server" ] }, "rc": 0, "results": [ "Loaded plugins: search-disabled-repos\nResolving Dependencies\n--> Running transaction check\n---> Package mssql-server.x86_64 0:15.0.4236.7-1 will be installed\n--> Processing Dependency: libatomic for package: mssql-server-15.0.4236.7-1.x86_64\n--> Processing Dependency: bzip2 for package: mssql-server-15.0.4236.7-1.x86_64\n--> Processing Dependency: gdb for package: mssql-server-15.0.4236.7-1.x86_64\n--> Processing Dependency: python3 for package: mssql-server-15.0.4236.7-1.x86_64\n--> Processing Dependency: libsss_nss_idmap for package: mssql-server-15.0.4236.7-1.x86_64\n--> Processing Dependency: cyrus-sasl for package: mssql-server-15.0.4236.7-1.x86_64\n--> Processing Dependency: cyrus-sasl-gssapi for package: mssql-server-15.0.4236.7-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.13 will be installed\n---> Package python3.x86_64 0:3.6.8-18.el7 will be installed\n--> Processing Dependency: python3-libs(x86-64) = 3.6.8-18.el7 for package: python3-3.6.8-18.el7.x86_64\n--> Processing Dependency: python3-setuptools for package: python3-3.6.8-18.el7.x86_64\n--> Processing Dependency: python3-pip for package: python3-3.6.8-18.el7.x86_64\n--> Processing Dependency: libpython3.6m.so.1.0()(64bit) for package: python3-3.6.8-18.el7.x86_64\n--> Running transaction check\n---> Package python3-libs.x86_64 0:3.6.8-18.el7 will be installed\n---> Package python3-pip.noarch 0:9.0.3-8.el7 will be installed\n---> Package python3-setuptools.noarch 0:39.2.0-10.el7 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 15.0.4236.7-1 packages-microsoft-com-mssql-server-2019\n 254 M\nInstalling for dependencies:\n bzip2 x86_64 1.0.6-13.el7 rhel 52 k\n cyrus-sasl x86_64 2.1.26-24.el7_9 rhel 88 k\n cyrus-sasl-gssapi x86_64 2.1.26-24.el7_9 rhel 41 k\n gdb x86_64 7.6.1-120.el7 rhel 2.4 M\n libatomic x86_64 4.8.5-44.el7 rhel 51 k\n libsss_nss_idmap x86_64 1.16.5-10.el7_9.13 rhel 169 k\n python3 x86_64 3.6.8-18.el7 rhel 70 k\n python3-libs x86_64 3.6.8-18.el7 rhel 6.9 M\n python3-pip noarch 9.0.3-8.el7 rhel 1.6 M\n python3-setuptools noarch 39.2.0-10.el7 rhel 629 k\n\nTransaction Summary\n================================================================================\nInstall 1 Package (+10 Dependent packages)\n\nTotal download size: 266 M\nInstalled size: 1.3 G\nDownloading packages:\n--------------------------------------------------------------------------------\nTotal 45 MB/s | 266 MB 00:05 \nRunning transaction check\nRunning transaction test\nTransaction test succeeded\nRunning transaction\n Installing : python3-libs-3.6.8-18.el7.x86_64 1/11 \n Installing : python3-3.6.8-18.el7.x86_64 2/11 \n Installing : python3-setuptools-39.2.0-10.el7.noarch 3/11 \n Installing : python3-pip-9.0.3-8.el7.noarch 4/11 \n Installing : cyrus-sasl-gssapi-2.1.26-24.el7_9.x86_64 5/11 \n Installing : cyrus-sasl-2.1.26-24.el7_9.x86_64 6/11 \n Installing : gdb-7.6.1-120.el7.x86_64 7/11 \n Installing : libsss_nss_idmap-1.16.5-10.el7_9.13.x86_64 8/11 \n Installing : bzip2-1.0.6-13.el7.x86_64 9/11 \n Installing : libatomic-4.8.5-44.el7.x86_64 10/11 \n Installing : mssql-server-15.0.4236.7-1.x86_64 11/11 \n\n+--------------------------------------------------------------+\nPlease run 'sudo /opt/mssql/bin/mssql-conf setup'\nto complete the setup of Microsoft SQL Server\n+--------------------------------------------------------------+\n\n Verifying : libatomic-4.8.5-44.el7.x86_64 1/11 \n Verifying : python3-setuptools-39.2.0-10.el7.noarch 2/11 \n Verifying : python3-libs-3.6.8-18.el7.x86_64 3/11 \n Verifying : bzip2-1.0.6-13.el7.x86_64 4/11 \n Verifying : libsss_nss_idmap-1.16.5-10.el7_9.13.x86_64 5/11 \n Verifying : gdb-7.6.1-120.el7.x86_64 6/11 \n Verifying : mssql-server-15.0.4236.7-1.x86_64 7/11 \n Verifying : python3-3.6.8-18.el7.x86_64 8/11 \n Verifying : python3-pip-9.0.3-8.el7.noarch 9/11 \n Verifying : cyrus-sasl-2.1.26-24.el7_9.x86_64 10/11 \n Verifying : cyrus-sasl-gssapi-2.1.26-24.el7_9.x86_64 11/11 \n\nInstalled:\n mssql-server.x86_64 0:15.0.4236.7-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.13 \n python3.x86_64 0:3.6.8-18.el7 \n python3-libs.x86_64 0:3.6.8-18.el7 \n python3-pip.noarch 0:9.0.3-8.el7 \n python3-setuptools.noarch 0:39.2.0-10.el7 \n\nComplete!\n" ] } TASK [linux-system-roles.mssql : Ensure that the openldap-compat package is installed] *** task path: /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:142 Wednesday 03 August 2022 16:24:28 +0000 (0:00:47.450) 0:00:53.213 ****** skipping: [/cache/rhel-7.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Check if the errorlog file exists and its location] *** task path: /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:150 Wednesday 03 August 2022 16:24:28 +0000 (0:00:00.029) 0:00:53.242 ****** ok: [/cache/rhel-7.qcow2] => { "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.006524", "end": "2022-08-03 12:24:28.309626", "rc": 0, "start": "2022-08-03 12:24:28.303102" } TASK [linux-system-roles.mssql : Gather system services facts] ***************** task path: /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:165 Wednesday 03 August 2022 16:24:28 +0000 (0:00:00.453) 0:00:53.695 ****** ok: [/cache/rhel-7.qcow2] => { "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 : Verify that the variables required for setting up MSSQL are defined] *** task path: /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:179 Wednesday 03 August 2022 16:24:29 +0000 (0:00:01.103) 0:00:54.799 ****** fatal: [/cache/rhel-7.qcow2]: FAILED! => { "assertion": "mssql_password is not none", "changed": false, "evaluated_to": false } MSG: ['You must define the following variables to set up MSSQL:', 'mssql_password', 'mssql_edition'] TASK [Assert that the role failed with variables undefined] ******************** task path: /tmp/tmpg0n6vuiy/tests/tests_accept_eula_2019.yml:21 Wednesday 03 August 2022 16:24:29 +0000 (0:00:00.063) 0:00:54.862 ****** ok: [/cache/rhel-7.qcow2] => { "changed": false } MSG: All assertions passed META: ran handlers META: ran handlers PLAY RECAP ********************************************************************* /cache/rhel-7.qcow2 : ok=16 changed=4 unreachable=0 failed=0 skipped=10 rescued=1 ignored=0 Wednesday 03 August 2022 16:24:30 +0000 (0:00:00.062) 0:00:54.925 ****** =============================================================================== linux-system-roles.mssql : Ensure the mssql-server package ------------- 47.45s /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:134 ------ set up internal repositories -------------------------------------------- 1.43s /cache/rhel-7_setup.yml:5 ----------------------------------------------------- linux-system-roles.mssql : Gather package facts ------------------------- 1.19s /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:85 ------- linux-system-roles.mssql : Gather system services facts ----------------- 1.10s /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:165 ------ Gathering Facts --------------------------------------------------------- 0.98s /tmp/tmpg0n6vuiy/tests/tests_accept_eula_2019.yml:3 --------------------------- linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories --- 0.73s /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:101 ------ linux-system-roles.mssql : Check if the errorlog file exists and its location --- 0.45s /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:150 ------ linux-system-roles.mssql : Ensure ansible_facts used by role ------------ 0.43s /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:3 ---- linux-system-roles.mssql : Configure the Microsoft SQL Server 2019 repository --- 0.35s /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:124 ------ Run the role with default parameters ------------------------------------ 0.09s /tmp/tmpg0n6vuiy/tests/tests_accept_eula_2019.yml:12 -------------------------- linux-system-roles.mssql : Set platform/version specific variables ------ 0.06s /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:11 --- linux-system-roles.mssql : Verify that the variables required for setting up MSSQL are defined --- 0.06s /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:179 ------ Assert that the role failed with variables undefined -------------------- 0.06s /tmp/tmpg0n6vuiy/tests/tests_accept_eula_2019.yml:21 -------------------------- linux-system-roles.mssql : Update all packages from SQL Server 2017 repo --- 0.05s /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:107 ------ linux-system-roles.mssql : Verify if mssql_version is not smaller then the existing SQL Server version --- 0.05s /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:90 ------- linux-system-roles.mssql : Remove the Microsoft SQL Server 2017 repository to upgrade to 2019 --- 0.05s /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:118 ------ linux-system-roles.mssql : Verify if the mssql_version variable is provided correctly --- 0.04s /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:39 ------- linux-system-roles.mssql : Verify that the user accepts EULA variables --- 0.04s /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:27 ------- linux-system-roles.mssql : Verify that 'mssql_ha_replica_type = primary' is provided once --- 0.03s /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:72 ------- linux-system-roles.mssql : Verify if the mssql_upgrade variable is provided correctly --- 0.03s /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:44 ------- ansible-playbook [core 2.12.6] config file = /etc/ansible/ansible.cfg configured module search path = ['/root/.ansible/plugins/modules', '/usr/share/ansible/plugins/modules'] ansible python module location = /usr/lib/python3.9/site-packages/ansible ansible collection location = /tmp/tmpc9shnupj executable location = /usr/bin/ansible-playbook python version = 3.9.13 (main, May 18 2022, 00:00:00) [GCC 11.3.1 20220421 (Red Hat 11.3.1-2)] jinja version = 2.11.3 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: rhel-7_setup.yml ***************************************************** 1 plays in /cache/rhel-7_setup.yml PLAY [Setup repos] ************************************************************* META: ran handlers TASK [set up internal repositories] ******************************************** task path: /cache/rhel-7_setup.yml:5 Wednesday 03 August 2022 16:51:32 +0000 (0:00:00.018) 0:00:00.018 ****** changed: [/cache/rhel-7.qcow2] => (item=None) => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": true } changed: [/cache/rhel-7.qcow2] => (item=None) => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": true } changed: [/cache/rhel-7.qcow2] => (item=None) => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": true } changed: [/cache/rhel-7.qcow2] => (item=None) => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": true } changed: [/cache/rhel-7.qcow2] => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": true } META: ran handlers META: ran handlers PLAY RECAP ********************************************************************* /cache/rhel-7.qcow2 : ok=1 changed=1 unreachable=0 failed=0 skipped=0 rescued=0 ignored=0 Wednesday 03 August 2022 16:51:34 +0000 (0:00:01.415) 0:00:01.433 ****** =============================================================================== set up internal repositories -------------------------------------------- 1.42s /cache/rhel-7_setup.yml:5 ----------------------------------------------------- PLAYBOOK: tests_accept_eula_2019.yml ******************************************* 1 plays in /tmp/tmpjm0ncwf7/tests/mssql/tests_accept_eula_2019.yml PLAY [Ensure that the role runs when EULA are accepted] ************************ TASK [Gathering Facts] ********************************************************* task path: /tmp/tmpjm0ncwf7/tests/mssql/tests_accept_eula_2019.yml:3 Wednesday 03 August 2022 16:51:34 +0000 (0:00:00.009) 0:00:01.442 ****** ok: [/cache/rhel-7.qcow2] META: ran handlers TASK [Run the role with default parameters] ************************************ task path: /tmp/tmpjm0ncwf7/tests/mssql/tests_accept_eula_2019.yml:12 Wednesday 03 August 2022 16:51:35 +0000 (0:00:00.966) 0:00:02.408 ****** TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role] *** task path: /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3 Wednesday 03 August 2022 16:51:35 +0000 (0:00:00.114) 0:00:02.523 ****** included: /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml for /cache/rhel-7.qcow2 TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts used by role] ***** task path: /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 Wednesday 03 August 2022 16:51:35 +0000 (0:00:00.031) 0:00:02.555 ****** ok: [/cache/rhel-7.qcow2] TASK [fedora.linux_system_roles.mssql : Set platform/version specific variables] *** task path: /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:10 Wednesday 03 August 2022 16:51:35 +0000 (0:00:00.412) 0:00:02.967 ****** ok: [/cache/rhel-7.qcow2] => (item=RedHat.yml) => { "ansible_facts": { "__mssql_client_repository": "https://packages.microsoft.com/rhel/8/prod/", "__mssql_server_repository": "https://packages.microsoft.com/rhel/8/mssql-server-{{ mssql_version | int }}/" }, "ansible_included_var_files": [ "/tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } ok: [/cache/rhel-7.qcow2] => (item=RedHat.yml) => { "ansible_facts": { "__mssql_client_repository": "https://packages.microsoft.com/rhel/8/prod/", "__mssql_server_repository": "https://packages.microsoft.com/rhel/8/mssql-server-{{ mssql_version | int }}/" }, "ansible_included_var_files": [ "/tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } ok: [/cache/rhel-7.qcow2] => (item=RedHat_7.yml) => { "ansible_facts": { "__mssql_client_repository": "https://packages.microsoft.com/rhel/7/prod/", "__mssql_server_repository": "https://packages.microsoft.com/rhel/7/mssql-server-{{ mssql_version | int }}/" }, "ansible_included_var_files": [ "/tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/RedHat_7.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat_7.yml" } skipping: [/cache/rhel-7.qcow2] => (item=RedHat_7.9.yml) => { "ansible_loop_var": "item", "changed": false, "item": "RedHat_7.9.yml", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] *** task path: /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8 Wednesday 03 August 2022 16:51:36 +0000 (0:00:00.067) 0:00:03.035 ****** ok: [/cache/rhel-7.qcow2] => { "ansible_facts": { "__mssql_sqlcmd_login_cmd": null }, "changed": false } TASK [fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] *** task path: /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:12 Wednesday 03 August 2022 16:51:36 +0000 (0:00:00.026) 0:00:03.062 ****** ok: [/cache/rhel-7.qcow2] => { "ansible_facts": { "__mssql_sqlcmd_login_cmd": null }, "changed": false } TASK [fedora.linux_system_roles.mssql : Link the deprecated accept_microsoft_sql_server_2019_standard_eula fact] *** task path: /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:16 Wednesday 03 August 2022 16:51:36 +0000 (0:00:00.028) 0:00:03.091 ****** skipping: [/cache/rhel-7.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_input_sql_file fact] *** task path: /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:22 Wednesday 03 August 2022 16:51:36 +0000 (0:00:00.023) 0:00:03.114 ****** skipping: [/cache/rhel-7.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify that the user accepts EULA variables] *** task path: /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:27 Wednesday 03 August 2022 16:51:36 +0000 (0:00:00.023) 0:00:03.137 ****** ok: [/cache/rhel-7.qcow2] => { "changed": false } MSG: All assertions passed TASK [fedora.linux_system_roles.mssql : Verify if the mssql_version variable is provided correctly] *** task path: /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:39 Wednesday 03 August 2022 16:51:36 +0000 (0:00:00.044) 0:00:03.181 ****** ok: [/cache/rhel-7.qcow2] => { "changed": false } MSG: All assertions passed TASK [fedora.linux_system_roles.mssql : Verify if the mssql_upgrade variable is provided correctly] *** task path: /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:44 Wednesday 03 August 2022 16:51:36 +0000 (0:00:00.043) 0:00:03.225 ****** skipping: [/cache/rhel-7.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify that EL < 8 is not used with mssql_ha_configure=true] *** task path: /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:55 Wednesday 03 August 2022 16:51:36 +0000 (0:00:00.032) 0:00:03.257 ****** skipping: [/cache/rhel-7.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify if the mssql_ha_replica_type variable is provided correctly] *** task path: /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:63 Wednesday 03 August 2022 16:51:36 +0000 (0:00:00.031) 0:00:03.288 ****** skipping: [/cache/rhel-7.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify that 'mssql_ha_replica_type = primary' is provided once] *** task path: /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:71 Wednesday 03 August 2022 16:51:36 +0000 (0:00:00.030) 0:00:03.318 ****** skipping: [/cache/rhel-7.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Gather package facts] ****************** task path: /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:80 Wednesday 03 August 2022 16:51:36 +0000 (0:00:00.030) 0:00:03.349 ****** ok: [/cache/rhel-7.qcow2] => { "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 : Verify if mssql_version is not smaller then the existing SQL Server version] *** task path: /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:85 Wednesday 03 August 2022 16:51:37 +0000 (0:00:01.179) 0:00:04.528 ****** skipping: [/cache/rhel-7.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories] *** task path: /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:96 Wednesday 03 August 2022 16:51:37 +0000 (0:00:00.041) 0:00:04.569 ****** changed: [/cache/rhel-7.qcow2] => { "changed": true } TASK [fedora.linux_system_roles.mssql : Update all packages from SQL Server 2017 repo] *** task path: /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:102 Wednesday 03 August 2022 16:51:38 +0000 (0:00:00.744) 0:00:05.314 ****** skipping: [/cache/rhel-7.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Remove the Microsoft SQL Server 2017 repository to upgrade to 2019] *** task path: /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:113 Wednesday 03 August 2022 16:51:38 +0000 (0:00:00.042) 0:00:05.357 ****** skipping: [/cache/rhel-7.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server 2019 repository] *** task path: /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:119 Wednesday 03 August 2022 16:51:38 +0000 (0:00:00.044) 0:00:05.401 ****** changed: [/cache/rhel-7.qcow2] => { "changed": true, "repo": "packages-microsoft-com-mssql-server-2019", "state": "present" } TASK [fedora.linux_system_roles.mssql : Ensure the mssql-server package] ******* task path: /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:129 Wednesday 03 August 2022 16:51:38 +0000 (0:00:00.317) 0:00:05.719 ****** changed: [/cache/rhel-7.qcow2] => { "changed": true, "changes": { "installed": [ "mssql-server" ] }, "rc": 0, "results": [ "Loaded plugins: search-disabled-repos\nResolving Dependencies\n--> Running transaction check\n---> Package mssql-server.x86_64 0:15.0.4236.7-1 will be installed\n--> Processing Dependency: libatomic for package: mssql-server-15.0.4236.7-1.x86_64\n--> Processing Dependency: bzip2 for package: mssql-server-15.0.4236.7-1.x86_64\n--> Processing Dependency: gdb for package: mssql-server-15.0.4236.7-1.x86_64\n--> Processing Dependency: python3 for package: mssql-server-15.0.4236.7-1.x86_64\n--> Processing Dependency: libsss_nss_idmap for package: mssql-server-15.0.4236.7-1.x86_64\n--> Processing Dependency: cyrus-sasl for package: mssql-server-15.0.4236.7-1.x86_64\n--> Processing Dependency: cyrus-sasl-gssapi for package: mssql-server-15.0.4236.7-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.13 will be installed\n---> Package python3.x86_64 0:3.6.8-18.el7 will be installed\n--> Processing Dependency: python3-libs(x86-64) = 3.6.8-18.el7 for package: python3-3.6.8-18.el7.x86_64\n--> Processing Dependency: python3-setuptools for package: python3-3.6.8-18.el7.x86_64\n--> Processing Dependency: python3-pip for package: python3-3.6.8-18.el7.x86_64\n--> Processing Dependency: libpython3.6m.so.1.0()(64bit) for package: python3-3.6.8-18.el7.x86_64\n--> Running transaction check\n---> Package python3-libs.x86_64 0:3.6.8-18.el7 will be installed\n---> Package python3-pip.noarch 0:9.0.3-8.el7 will be installed\n---> Package python3-setuptools.noarch 0:39.2.0-10.el7 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 15.0.4236.7-1 packages-microsoft-com-mssql-server-2019\n 254 M\nInstalling for dependencies:\n bzip2 x86_64 1.0.6-13.el7 rhel 52 k\n cyrus-sasl x86_64 2.1.26-24.el7_9 rhel 88 k\n cyrus-sasl-gssapi x86_64 2.1.26-24.el7_9 rhel 41 k\n gdb x86_64 7.6.1-120.el7 rhel 2.4 M\n libatomic x86_64 4.8.5-44.el7 rhel 51 k\n libsss_nss_idmap x86_64 1.16.5-10.el7_9.13 rhel 169 k\n python3 x86_64 3.6.8-18.el7 rhel 70 k\n python3-libs x86_64 3.6.8-18.el7 rhel 6.9 M\n python3-pip noarch 9.0.3-8.el7 rhel 1.6 M\n python3-setuptools noarch 39.2.0-10.el7 rhel 629 k\n\nTransaction Summary\n================================================================================\nInstall 1 Package (+10 Dependent packages)\n\nTotal download size: 266 M\nInstalled size: 1.3 G\nDownloading packages:\n--------------------------------------------------------------------------------\nTotal 36 MB/s | 266 MB 00:07 \nRunning transaction check\nRunning transaction test\nTransaction test succeeded\nRunning transaction\n Installing : python3-libs-3.6.8-18.el7.x86_64 1/11 \n Installing : python3-3.6.8-18.el7.x86_64 2/11 \n Installing : python3-setuptools-39.2.0-10.el7.noarch 3/11 \n Installing : python3-pip-9.0.3-8.el7.noarch 4/11 \n Installing : cyrus-sasl-gssapi-2.1.26-24.el7_9.x86_64 5/11 \n Installing : cyrus-sasl-2.1.26-24.el7_9.x86_64 6/11 \n Installing : gdb-7.6.1-120.el7.x86_64 7/11 \n Installing : libsss_nss_idmap-1.16.5-10.el7_9.13.x86_64 8/11 \n Installing : bzip2-1.0.6-13.el7.x86_64 9/11 \n Installing : libatomic-4.8.5-44.el7.x86_64 10/11 \n Installing : mssql-server-15.0.4236.7-1.x86_64 11/11 \n\n+--------------------------------------------------------------+\nPlease run 'sudo /opt/mssql/bin/mssql-conf setup'\nto complete the setup of Microsoft SQL Server\n+--------------------------------------------------------------+\n\n Verifying : libatomic-4.8.5-44.el7.x86_64 1/11 \n Verifying : python3-setuptools-39.2.0-10.el7.noarch 2/11 \n Verifying : python3-libs-3.6.8-18.el7.x86_64 3/11 \n Verifying : bzip2-1.0.6-13.el7.x86_64 4/11 \n Verifying : libsss_nss_idmap-1.16.5-10.el7_9.13.x86_64 5/11 \n Verifying : gdb-7.6.1-120.el7.x86_64 6/11 \n Verifying : mssql-server-15.0.4236.7-1.x86_64 7/11 \n Verifying : python3-3.6.8-18.el7.x86_64 8/11 \n Verifying : python3-pip-9.0.3-8.el7.noarch 9/11 \n Verifying : cyrus-sasl-2.1.26-24.el7_9.x86_64 10/11 \n Verifying : cyrus-sasl-gssapi-2.1.26-24.el7_9.x86_64 11/11 \n\nInstalled:\n mssql-server.x86_64 0:15.0.4236.7-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.13 \n python3.x86_64 0:3.6.8-18.el7 \n python3-libs.x86_64 0:3.6.8-18.el7 \n python3-pip.noarch 0:9.0.3-8.el7 \n python3-setuptools.noarch 0:39.2.0-10.el7 \n\nComplete!\n" ] } TASK [fedora.linux_system_roles.mssql : Ensure that the openldap-compat package is installed] *** task path: /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:137 Wednesday 03 August 2022 16:52:26 +0000 (0:00:48.102) 0:00:53.822 ****** skipping: [/cache/rhel-7.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Check if the errorlog file exists and its location] *** task path: /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:145 Wednesday 03 August 2022 16:52:26 +0000 (0:00:00.029) 0:00:53.851 ****** ok: [/cache/rhel-7.qcow2] => { "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.006393", "end": "2022-08-03 12:52:26.807357", "rc": 0, "start": "2022-08-03 12:52:26.800964" } TASK [fedora.linux_system_roles.mssql : Gather system services facts] ********** task path: /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:160 Wednesday 03 August 2022 16:52:27 +0000 (0:00:00.436) 0:00:54.288 ****** ok: [/cache/rhel-7.qcow2] => { "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 : Verify that the variables required for setting up MSSQL are defined] *** task path: /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:174 Wednesday 03 August 2022 16:52:28 +0000 (0:00:01.122) 0:00:55.411 ****** fatal: [/cache/rhel-7.qcow2]: FAILED! => { "assertion": "mssql_password is not none", "changed": false, "evaluated_to": false } MSG: ['You must define the following variables to set up MSSQL:', 'mssql_password', 'mssql_edition'] TASK [Assert that the role failed with variables undefined] ******************** task path: /tmp/tmpjm0ncwf7/tests/mssql/tests_accept_eula_2019.yml:21 Wednesday 03 August 2022 16:52:28 +0000 (0:00:00.065) 0:00:55.477 ****** ok: [/cache/rhel-7.qcow2] => { "changed": false } MSG: All assertions passed META: ran handlers META: ran handlers PLAY RECAP ********************************************************************* /cache/rhel-7.qcow2 : ok=16 changed=4 unreachable=0 failed=0 skipped=10 rescued=1 ignored=0 Wednesday 03 August 2022 16:52:28 +0000 (0:00:00.060) 0:00:55.537 ****** =============================================================================== fedora.linux_system_roles.mssql : Ensure the mssql-server package ------ 48.10s /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:129 set up internal repositories -------------------------------------------- 1.42s /cache/rhel-7_setup.yml:5 ----------------------------------------------------- fedora.linux_system_roles.mssql : Gather package facts ------------------ 1.18s /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:80 fedora.linux_system_roles.mssql : Gather system services facts ---------- 1.12s /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:160 Gathering Facts --------------------------------------------------------- 0.97s /tmp/tmpjm0ncwf7/tests/mssql/tests_accept_eula_2019.yml:3 --------------------- fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories --- 0.75s /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:96 fedora.linux_system_roles.mssql : Check if the errorlog file exists and its location --- 0.44s /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:145 fedora.linux_system_roles.mssql : Ensure ansible_facts used by role ----- 0.41s /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server 2019 repository --- 0.32s /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:119 Run the role with default parameters ------------------------------------ 0.11s /tmp/tmpjm0ncwf7/tests/mssql/tests_accept_eula_2019.yml:12 -------------------- fedora.linux_system_roles.mssql : Set platform/version specific variables --- 0.07s /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:10 fedora.linux_system_roles.mssql : Verify that the variables required for setting up MSSQL are defined --- 0.07s /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:174 Assert that the role failed with variables undefined -------------------- 0.06s /tmp/tmpjm0ncwf7/tests/mssql/tests_accept_eula_2019.yml:21 -------------------- fedora.linux_system_roles.mssql : Remove the Microsoft SQL Server 2017 repository to upgrade to 2019 --- 0.04s /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:113 fedora.linux_system_roles.mssql : Verify that the user accepts EULA variables --- 0.04s /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:27 fedora.linux_system_roles.mssql : Verify if the mssql_version variable is provided correctly --- 0.04s /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:39 fedora.linux_system_roles.mssql : Update all packages from SQL Server 2017 repo --- 0.04s /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:102 fedora.linux_system_roles.mssql : Verify if mssql_version is not smaller then the existing SQL Server version --- 0.04s /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:85 fedora.linux_system_roles.mssql : Verify if the mssql_upgrade variable is provided correctly --- 0.03s /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:44 fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role --- 0.03s /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3