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:25:00 +0000 (0:00:00.017) 0:00:00.017 ****** 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:25:02 +0000 (0:00:01.387) 0:00:01.405 ****** =============================================================================== set up internal repositories -------------------------------------------- 1.39s /cache/rhel-7_setup.yml:5 ----------------------------------------------------- PLAYBOOK: tests_default_2019.yml *********************************************** 1 plays in /tmp/tmpg0n6vuiy/tests/tests_default_2019.yml PLAY [Ensure that the role runs with default parameters] *********************** TASK [Gathering Facts] ********************************************************* task path: /tmp/tmpg0n6vuiy/tests/tests_default_2019.yml:3 Wednesday 03 August 2022 16:25:02 +0000 (0:00:00.009) 0:00:01.414 ****** ok: [/cache/rhel-7.qcow2] META: ran handlers TASK [Run the role with default parameters] ************************************ task path: /tmp/tmpg0n6vuiy/tests/tests_default_2019.yml:8 Wednesday 03 August 2022 16:25:02 +0000 (0:00:00.960) 0:00:02.375 ****** 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:25:03 +0000 (0:00:00.086) 0:00:02.461 ****** 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:25:03 +0000 (0:00:00.028) 0:00:02.490 ****** 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:25:03 +0000 (0:00:00.417) 0:00:02.907 ****** 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:25:03 +0000 (0:00:00.064) 0:00:02.971 ****** 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:25:03 +0000 (0:00:00.026) 0:00:02.998 ****** 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:25:03 +0000 (0:00:00.025) 0:00:03.023 ****** 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:25:03 +0000 (0:00:00.025) 0:00:03.049 ****** 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:25:03 +0000 (0:00:00.025) 0:00:03.074 ****** fatal: [/cache/rhel-7.qcow2]: FAILED! => { "assertion": "mssql_accept_microsoft_odbc_driver_17_for_sql_server_eula | bool", "changed": false, "evaluated_to": false } MSG: ['You must accept EULA by setting the following variables to true:', 'mssql_accept_microsoft_odbc_driver_17_for_sql_server_eula', 'mssql_accept_microsoft_cli_utilities_for_sql_server_eula', 'mssql_accept_microsoft_sql_server_standard_eula'] TASK [Assert that the role failed with EULA not accepted] ********************** task path: /tmp/tmpg0n6vuiy/tests/tests_default_2019.yml:17 Wednesday 03 August 2022 16:25:03 +0000 (0:00:00.043) 0:00:03.118 ****** ok: [/cache/rhel-7.qcow2] => { "changed": false } MSG: All assertions passed META: ran handlers META: ran handlers PLAY RECAP ********************************************************************* /cache/rhel-7.qcow2 : ok=8 changed=1 unreachable=0 failed=0 skipped=2 rescued=1 ignored=0 Wednesday 03 August 2022 16:25:03 +0000 (0:00:00.036) 0:00:03.155 ****** =============================================================================== set up internal repositories -------------------------------------------- 1.39s /cache/rhel-7_setup.yml:5 ----------------------------------------------------- Gathering Facts --------------------------------------------------------- 0.96s /tmp/tmpg0n6vuiy/tests/tests_default_2019.yml:3 ------------------------------- linux-system-roles.mssql : Ensure ansible_facts used by role ------------ 0.42s /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:3 ---- Run the role with default parameters ------------------------------------ 0.09s /tmp/tmpg0n6vuiy/tests/tests_default_2019.yml:8 ------------------------------- 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 user accepts EULA variables --- 0.04s /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:27 ------- Assert that the role failed with EULA not accepted ---------------------- 0.04s /tmp/tmpg0n6vuiy/tests/tests_default_2019.yml:17 ------------------------------ linux-system-roles.mssql : Ensure ansible_facts and variables used by role --- 0.03s /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:3 -------- linux-system-roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact ------ 0.03s /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:8 -------- linux-system-roles.mssql : Link the deprecated mssql_input_sql_file fact --- 0.03s /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:22 ------- linux-system-roles.mssql : Link the deprecated accept_microsoft_sql_server_2019_standard_eula fact --- 0.03s /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:16 ------- linux-system-roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact ------ 0.03s /tmp/tmpg0n6vuiy/tests/roles/linux-system-roles.mssql/tasks/main.yml:12 ------- 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:53:02 +0000 (0:00:00.017) 0:00:00.017 ****** 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:53:04 +0000 (0:00:01.360) 0:00:01.378 ****** =============================================================================== set up internal repositories -------------------------------------------- 1.36s /cache/rhel-7_setup.yml:5 ----------------------------------------------------- PLAYBOOK: tests_default_2019.yml *********************************************** 1 plays in /tmp/tmpjm0ncwf7/tests/mssql/tests_default_2019.yml PLAY [Ensure that the role runs with default parameters] *********************** TASK [Gathering Facts] ********************************************************* task path: /tmp/tmpjm0ncwf7/tests/mssql/tests_default_2019.yml:3 Wednesday 03 August 2022 16:53:04 +0000 (0:00:00.009) 0:00:01.387 ****** ok: [/cache/rhel-7.qcow2] META: ran handlers TASK [Run the role with default parameters] ************************************ task path: /tmp/tmpjm0ncwf7/tests/mssql/tests_default_2019.yml:8 Wednesday 03 August 2022 16:53:05 +0000 (0:00:00.929) 0:00:02.316 ****** 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:53:05 +0000 (0:00:00.114) 0:00:02.431 ****** 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:53:05 +0000 (0:00:00.031) 0:00:02.462 ****** 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:53:05 +0000 (0:00:00.394) 0:00:02.856 ****** 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:53:05 +0000 (0:00:00.068) 0:00:02.925 ****** 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:53:05 +0000 (0:00:00.029) 0:00:02.955 ****** 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:53:05 +0000 (0:00:00.027) 0:00:02.982 ****** 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:53:05 +0000 (0:00:00.022) 0:00:03.004 ****** 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:53:05 +0000 (0:00:00.022) 0:00:03.027 ****** fatal: [/cache/rhel-7.qcow2]: FAILED! => { "assertion": "mssql_accept_microsoft_odbc_driver_17_for_sql_server_eula | bool", "changed": false, "evaluated_to": false } MSG: ['You must accept EULA by setting the following variables to true:', 'mssql_accept_microsoft_odbc_driver_17_for_sql_server_eula', 'mssql_accept_microsoft_cli_utilities_for_sql_server_eula', 'mssql_accept_microsoft_sql_server_standard_eula'] TASK [Assert that the role failed with EULA not accepted] ********************** task path: /tmp/tmpjm0ncwf7/tests/mssql/tests_default_2019.yml:17 Wednesday 03 August 2022 16:53:06 +0000 (0:00:00.041) 0:00:03.068 ****** ok: [/cache/rhel-7.qcow2] => { "changed": false } MSG: All assertions passed META: ran handlers META: ran handlers PLAY RECAP ********************************************************************* /cache/rhel-7.qcow2 : ok=8 changed=1 unreachable=0 failed=0 skipped=2 rescued=1 ignored=0 Wednesday 03 August 2022 16:53:06 +0000 (0:00:00.037) 0:00:03.106 ****** =============================================================================== set up internal repositories -------------------------------------------- 1.36s /cache/rhel-7_setup.yml:5 ----------------------------------------------------- Gathering Facts --------------------------------------------------------- 0.93s /tmp/tmpjm0ncwf7/tests/mssql/tests_default_2019.yml:3 ------------------------- fedora.linux_system_roles.mssql : Ensure ansible_facts used by role ----- 0.39s /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 Run the role with default parameters ------------------------------------ 0.11s /tmp/tmpjm0ncwf7/tests/mssql/tests_default_2019.yml:8 ------------------------- 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 user accepts EULA variables --- 0.04s /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:27 Assert that the role failed with EULA not accepted ---------------------- 0.04s /tmp/tmpjm0ncwf7/tests/mssql/tests_default_2019.yml:17 ------------------------ 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 fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact --- 0.03s /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8 fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact --- 0.03s /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:12 fedora.linux_system_roles.mssql : Link the deprecated accept_microsoft_sql_server_2019_standard_eula fact --- 0.02s /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:16 fedora.linux_system_roles.mssql : Link the deprecated mssql_input_sql_file fact --- 0.02s /tmp/tmpc9shnupj/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:22