# 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.6/site-packages/ansible executable location = /opt/ansible-2.9/bin/ansible-playbook python version = 3.6.8 (default, Oct 26 2022, 09:13:21) [GCC 8.5.0 20210514 (Red Hat 8.5.0-17)] 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_default_2019.yml *********************************************** 2 plays in /WORKDIR/dist-git-mssql-ad-integration-idj8gfyw/tests/tests_default_2019.yml PLAY [all] ********************************************************************* META: ran handlers TASK [Include vault variables] ************************************************* task path: /WORKDIR/dist-git-mssql-ad-integration-idj8gfyw/tests/tests_default_2019.yml:4 Tuesday 31 January 2023 14:58:35 +0000 (0:00:00.032) 0:00:00.032 ******* 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-ad-integration-idj8gfyw/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-ad-integration-idj8gfyw/tests/tests_default_2019.yml:9 Tuesday 31 January 2023 14:58:35 +0000 (0:00:00.051) 0:00:00.084 ******* ok: [sut] META: ran handlers TASK [Run the role with default parameters] ************************************ task path: /WORKDIR/dist-git-mssql-ad-integration-idj8gfyw/tests/tests_default_2019.yml:14 Tuesday 31 January 2023 14:58:36 +0000 (0:00:00.939) 0:00:01.023 ******* TASK [linux-system-roles.mssql : Ensure ansible_facts and variables used by role] *** task path: /WORKDIR/dist-git-mssql-ad-integration-idj8gfyw/tests/roles/linux-system-roles.mssql/tasks/main.yml:3 Tuesday 31 January 2023 14:58:36 +0000 (0:00:00.338) 0:00:01.362 ******* included: /WORKDIR/dist-git-mssql-ad-integration-idj8gfyw/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/dist-git-mssql-ad-integration-idj8gfyw/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:3 Tuesday 31 January 2023 14:58:36 +0000 (0:00:00.049) 0:00:01.411 ******* ok: [sut] TASK [linux-system-roles.mssql : Set platform/version specific variables] ****** task path: /WORKDIR/dist-git-mssql-ad-integration-idj8gfyw/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:11 Tuesday 31 January 2023 14:58:37 +0000 (0:00:00.460) 0:00:01.872 ******* 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-ad-integration-idj8gfyw/tests/roles/linux-system-roles.mssql/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } 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-ad-integration-idj8gfyw/tests/roles/linux-system-roles.mssql/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } skipping: [sut] => (item=RedHat_8.yml) => { "ansible_loop_var": "item", "changed": false, "item": "RedHat_8.yml", "skip_reason": "Conditional result was False" } skipping: [sut] => (item=RedHat_8.8.yml) => { "ansible_loop_var": "item", "changed": false, "item": "RedHat_8.8.yml", "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ****** task path: /WORKDIR/dist-git-mssql-ad-integration-idj8gfyw/tests/roles/linux-system-roles.mssql/tasks/main.yml:8 Tuesday 31 January 2023 14:58:37 +0000 (0:00:00.086) 0:00:01.958 ******* 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/dist-git-mssql-ad-integration-idj8gfyw/tests/roles/linux-system-roles.mssql/tasks/main.yml:15 Tuesday 31 January 2023 14:58:37 +0000 (0:00:00.026) 0:00:01.985 ******* skipping: [sut] => {} TASK [linux-system-roles.mssql : Link the deprecated mssql_input_sql_file fact] *** task path: /WORKDIR/dist-git-mssql-ad-integration-idj8gfyw/tests/roles/linux-system-roles.mssql/tasks/main.yml:23 Tuesday 31 January 2023 14:58:37 +0000 (0:00:00.065) 0:00:02.051 ******* skipping: [sut] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Print that the variable is deprecated] ******** task path: /WORKDIR/dist-git-mssql-ad-integration-idj8gfyw/tests/roles/linux-system-roles.mssql/tasks/main.yml:30 Tuesday 31 January 2023 14:58:37 +0000 (0:00:00.049) 0:00:02.100 ******* skipping: [sut] => {} TASK [linux-system-roles.mssql : Link the deprecated mssql_ha_listener_port fact] *** task path: /WORKDIR/dist-git-mssql-ad-integration-idj8gfyw/tests/roles/linux-system-roles.mssql/tasks/main.yml:37 Tuesday 31 January 2023 14:58:37 +0000 (0:00:00.063) 0:00:02.164 ******* 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/dist-git-mssql-ad-integration-idj8gfyw/tests/roles/linux-system-roles.mssql/tasks/main.yml:41 Tuesday 31 January 2023 14:58:37 +0000 (0:00:00.065) 0:00:02.230 ******* 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-ad-integration-idj8gfyw/tests/tests_default_2019.yml:23 Tuesday 31 January 2023 14:58:37 +0000 (0:00:00.071) 0:00:02.302 ******* ok: [sut] => { "changed": false } MSG: All assertions passed META: ran handlers META: ran handlers PLAY RECAP ********************************************************************* sut : ok=7 changed=0 unreachable=0 failed=0 skipped=4 rescued=1 ignored=0 Tuesday 31 January 2023 14:58:37 +0000 (0:00:00.054) 0:00:02.356 ******* =============================================================================== Gathering Facts --------------------------------------------------------- 0.94s /WORKDIR/dist-git-mssql-ad-integration-idj8gfyw/tests/tests_default_2019.yml:9 linux-system-roles.mssql : Ensure ansible_facts used by role ------------ 0.46s /WORKDIR/dist-git-mssql-ad-integration-idj8gfyw/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:3 Run the role with default parameters ------------------------------------ 0.34s /WORKDIR/dist-git-mssql-ad-integration-idj8gfyw/tests/tests_default_2019.yml:14 linux-system-roles.mssql : Set platform/version specific variables ------ 0.09s /WORKDIR/dist-git-mssql-ad-integration-idj8gfyw/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml:11 linux-system-roles.mssql : Verify that the user accepts EULA variables --- 0.07s /WORKDIR/dist-git-mssql-ad-integration-idj8gfyw/tests/roles/linux-system-roles.mssql/tasks/main.yml:41 linux-system-roles.mssql : Link the deprecated mssql_ha_listener_port fact --- 0.07s /WORKDIR/dist-git-mssql-ad-integration-idj8gfyw/tests/roles/linux-system-roles.mssql/tasks/main.yml:37 linux-system-roles.mssql : Print that the mssql_input_sql_file variable is deprecated --- 0.07s /WORKDIR/dist-git-mssql-ad-integration-idj8gfyw/tests/roles/linux-system-roles.mssql/tasks/main.yml:15 linux-system-roles.mssql : Print that the variable is deprecated -------- 0.06s /WORKDIR/dist-git-mssql-ad-integration-idj8gfyw/tests/roles/linux-system-roles.mssql/tasks/main.yml:30 Assert that the role failed with EULA not accepted ---------------------- 0.05s /WORKDIR/dist-git-mssql-ad-integration-idj8gfyw/tests/tests_default_2019.yml:23 Include vault variables ------------------------------------------------- 0.05s /WORKDIR/dist-git-mssql-ad-integration-idj8gfyw/tests/tests_default_2019.yml:4 linux-system-roles.mssql : Ensure ansible_facts and variables used by role --- 0.05s /WORKDIR/dist-git-mssql-ad-integration-idj8gfyw/tests/roles/linux-system-roles.mssql/tasks/main.yml:3 linux-system-roles.mssql : Link the deprecated mssql_input_sql_file fact --- 0.05s /WORKDIR/dist-git-mssql-ad-integration-idj8gfyw/tests/roles/linux-system-roles.mssql/tasks/main.yml:23 linux-system-roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact ------ 0.03s /WORKDIR/dist-git-mssql-ad-integration-idj8gfyw/tests/roles/linux-system-roles.mssql/tasks/main.yml:8 ---^---^---^---^---^--- # STDERR: ---v---v---v---v---v--- /opt/ansible-2.9/lib/python3.6/site-packages/ansible/parsing/vault/__init__.py:44: CryptographyDeprecationWarning: Python 3.6 is no longer supported by the Python core team. Therefore, support for it is deprecated in cryptography and will be removed in a future release. from cryptography.exceptions import InvalidSignature ---^---^---^---^---^---