# STDOUT: ---v---v---v---v---v--- ansible-playbook [core 2.13.6] 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.13/lib/python3.8/site-packages/ansible ansible collection location = /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection executable location = /opt/ansible-2.13/bin/ansible-playbook python version = 3.8.13 (default, Jun 24 2022, 15:27:57) [GCC 8.5.0 20210514 (Red Hat 8.5.0-13)] jinja version = 3.1.2 libyaml = True Using /etc/ansible/ansible.cfg as config file Skipping callback 'debug', as we already have a stdout callback. Skipping callback 'default', as we already have a stdout callback. Skipping callback 'minimal', as we already have a stdout callback. Skipping callback 'oneline', as we already have a stdout callback. PLAYBOOK: tests_default_2019.yml *********************************************** 2 plays in /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/tests/tests_default_2019.yml PLAY [all] ********************************************************************* META: ran handlers TASK [Include vault variables] ************************************************* task path: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/tests/tests_default_2019.yml:4 Monday 05 December 2022 14:58:21 +0000 (0:00:00.125) 0:00:00.125 ******* ok: [sut] => { "ansible_facts": { "mssql_password": { "__ansible_vault": "$ANSIBLE_VAULT;1.1;AES256\n66336361663164656232326461653662643537386337346563613939356466313835383235313234\n3634333565616161316639666662613564353237653663610a616639306439653033386664303839\n30663030636161326137656235636230356162373234386461363632353863393161353035316162\n3664353366373231360a343334326337353861366233656330363634353164316434616561333161\n3234\n" } }, "ansible_included_var_files": [ "/WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/tests/vars/vault-variables.yml" ], "changed": false } META: ran handlers META: ran handlers PLAY [Ensure that the role runs with default parameters] *********************** TASK [Gathering Facts] ********************************************************* task path: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/tests/tests_default_2019.yml:9 Monday 05 December 2022 14:58:21 +0000 (0:00:00.166) 0:00:00.291 ******* ok: [sut] META: ran handlers TASK [Run the role with default parameters] ************************************ task path: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/tests/tests_default_2019.yml:14 Monday 05 December 2022 14:58:24 +0000 (0:00:02.942) 0:00:03.233 ******* TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role] *** task path: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3 Monday 05 December 2022 14:58:24 +0000 (0:00:00.617) 0:00:03.851 ******* included: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml for sut TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts used by role] ***** task path: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 Monday 05 December 2022 14:58:25 +0000 (0:00:00.164) 0:00:04.016 ******* ok: [sut] TASK [fedora.linux_system_roles.mssql : Set platform/version specific variables] *** task path: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:10 Monday 05 December 2022 14:58:26 +0000 (0:00:01.531) 0:00:05.547 ******* ok: [sut] => (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": [ "/WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } skipping: [sut] => (item=Fedora.yml) => { "ansible_loop_var": "item", "changed": false, "item": "Fedora.yml", "skip_reason": "Conditional result was False" } skipping: [sut] => (item=Fedora_35.yml) => { "ansible_loop_var": "item", "changed": false, "item": "Fedora_35.yml", "skip_reason": "Conditional result was False" } skipping: [sut] => (item=Fedora_35.yml) => { "ansible_loop_var": "item", "changed": false, "item": "Fedora_35.yml", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] *** task path: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8 Monday 05 December 2022 14:58:26 +0000 (0:00:00.128) 0:00:05.676 ******* ok: [sut] => { "ansible_facts": { "__mssql_sqlcmd_login_cmd": null }, "changed": false } TASK [fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] *** task path: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:12 Monday 05 December 2022 14:58:26 +0000 (0:00:00.124) 0:00:05.800 ******* ok: [sut] => { "ansible_facts": { "__mssql_sqlcmd_login_cmd": null }, "changed": false } TASK [fedora.linux_system_roles.mssql : Print that the variable is deprecated] *** task path: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:19 Monday 05 December 2022 14:58:26 +0000 (0:00:00.049) 0:00:05.849 ******* skipping: [sut] => {} TASK [fedora.linux_system_roles.mssql : Link the deprecated accept_microsoft_sql_server_2019_standard_eula fact] *** task path: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:27 Monday 05 December 2022 14:58:27 +0000 (0:00:00.270) 0:00:06.119 ******* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Print that the mssql_input_sql_file variable is deprecated] *** task path: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:36 Monday 05 December 2022 14:58:27 +0000 (0:00:00.142) 0:00:06.262 ******* skipping: [sut] => {} TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_input_sql_file fact] *** task path: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:44 Monday 05 December 2022 14:58:27 +0000 (0:00:00.110) 0:00:06.372 ******* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify that the user accepts EULA variables] *** task path: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:48 Monday 05 December 2022 14:58:27 +0000 (0:00:00.097) 0:00:06.469 ******* fatal: [sut]: 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: /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/tests/tests_default_2019.yml:23 Monday 05 December 2022 14:58:27 +0000 (0:00:00.332) 0:00:06.801 ******* ok: [sut] => { "changed": false } MSG: All assertions passed META: ran handlers META: ran handlers PLAY RECAP ********************************************************************* sut : ok=8 changed=0 unreachable=0 failed=0 skipped=4 rescued=1 ignored=0 Monday 05 December 2022 14:58:28 +0000 (0:00:00.261) 0:00:07.063 ******* =============================================================================== Gathering Facts --------------------------------------------------------- 2.94s /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/tests/tests_default_2019.yml:9 fedora.linux_system_roles.mssql : Ensure ansible_facts used by role ----- 1.53s /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 Run the role with default parameters ------------------------------------ 0.62s /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/tests/tests_default_2019.yml:14 fedora.linux_system_roles.mssql : Verify that the user accepts EULA variables --- 0.33s /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:48 fedora.linux_system_roles.mssql : Print that the variable is deprecated --- 0.27s /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:19 Assert that the role failed with EULA not accepted ---------------------- 0.26s /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/tests/tests_default_2019.yml:23 Include vault variables ------------------------------------------------- 0.17s /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/tests/tests_default_2019.yml:4 fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role --- 0.16s /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3 fedora.linux_system_roles.mssql : Link the deprecated accept_microsoft_sql_server_2019_standard_eula fact --- 0.14s /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:27 fedora.linux_system_roles.mssql : Set platform/version specific variables --- 0.13s /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:10 fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact --- 0.12s /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8 fedora.linux_system_roles.mssql : Print that the mssql_input_sql_file variable is deprecated --- 0.11s /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:36 fedora.linux_system_roles.mssql : Link the deprecated mssql_input_sql_file fact --- 0.10s /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:44 fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact --- 0.05s /WORKDIR/dist-git-mssql-single-node-test-fix-zvmqk8u5/.collection/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:12 ---^---^---^---^---^--- # STDERR: ---v---v---v---v---v--- [DEPRECATION WARNING]: [defaults]callback_whitelist option, normalizing names to new standard, use callbacks_enabled instead. This feature will be removed from ansible-core in version 2.15. Deprecation warnings can be disabled by setting deprecation_warnings=False in ansible.cfg. ---^---^---^---^---^---