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