# STDOUT:
---v---v---v---v---v---
Using /etc/ansible/ansible.cfg as config file

PLAY [Ensure that the role runs when EULA are accepted] ************************

TASK [Gathering Facts] *********************************************************
Wednesday 31 August 2022  10:33:52 +0000 (0:00:00.020)       0:00:00.020 ****** 
ok: [sut]

TASK [Run the role with default parameters] ************************************
Wednesday 31 August 2022  10:33:53 +0000 (0:00:01.209)       0:00:01.229 ****** 

TASK [linux-system-roles.mssql : Ensure ansible_facts and variables used by role] ***
Wednesday 31 August 2022  10:33:53 +0000 (0:00:00.139)       0:00:01.368 ****** 
included: /WORKDIR/dist-git-mssql-input-multiple-sql-scripts-QBRTGp/tests/roles/linux-system-roles.mssql/tasks/set_vars.yml for sut

TASK [linux-system-roles.mssql : Ensure ansible_facts used by role] ************
Wednesday 31 August 2022  10:33:53 +0000 (0:00:00.047)       0:00:01.416 ****** 
ok: [sut]

TASK [linux-system-roles.mssql : Set platform/version specific variables] ******
Wednesday 31 August 2022  10:33:53 +0000 (0:00:00.456)       0:00:01.873 ****** 
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-input-multiple-sql-scripts-QBRTGp/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-input-multiple-sql-scripts-QBRTGp/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.7.yml)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": "RedHat_8.7.yml",
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ******
Wednesday 31 August 2022  10:33:54 +0000 (0:00:00.119)       0:00:01.992 ****** 
ok: [sut] => {
    "ansible_facts": {
        "__mssql_sqlcmd_login_cmd": null
    },
    "changed": false
}

TASK [linux-system-roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ******
Wednesday 31 August 2022  10:33:54 +0000 (0:00:00.043)       0:00:02.036 ****** 
ok: [sut] => {
    "ansible_facts": {
        "__mssql_sqlcmd_login_cmd": null
    },
    "changed": false
}

TASK [linux-system-roles.mssql : Print that the variable is deprecated] ********
Wednesday 31 August 2022  10:33:54 +0000 (0:00:00.045)       0:00:02.081 ****** 
skipping: [sut] => {}

TASK [linux-system-roles.mssql : Link the deprecated accept_microsoft_sql_server_2019_standard_eula fact] ***
Wednesday 31 August 2022  10:33:54 +0000 (0:00:00.037)       0:00:02.118 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Print that the mssql_input_sql_file variable is deprecated] ***
Wednesday 31 August 2022  10:33:54 +0000 (0:00:00.038)       0:00:02.157 ****** 
skipping: [sut] => {}

TASK [linux-system-roles.mssql : Link the deprecated mssql_input_sql_file fact] ***
Wednesday 31 August 2022  10:33:54 +0000 (0:00:00.038)       0:00:02.195 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Verify that the user accepts EULA variables] ***
Wednesday 31 August 2022  10:33:54 +0000 (0:00:00.038)       0:00:02.233 ****** 
ok: [sut] => {
    "changed": false
}

MSG:

All assertions passed

TASK [linux-system-roles.mssql : Verify if the mssql_version variable is provided correctly] ***
Wednesday 31 August 2022  10:33:54 +0000 (0:00:00.072)       0:00:02.305 ****** 
ok: [sut] => {
    "changed": false
}

MSG:

All assertions passed

TASK [linux-system-roles.mssql : Verify if the mssql_upgrade variable is provided correctly] ***
Wednesday 31 August 2022  10:33:54 +0000 (0:00:00.068)       0:00:02.374 ****** 
skipping: [sut] => {
    "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] ***
Wednesday 31 August 2022  10:33:54 +0000 (0:00:00.052)       0:00:02.427 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Verify if the mssql_ha_replica_type variable is provided correctly] ***
Wednesday 31 August 2022  10:33:54 +0000 (0:00:00.059)       0:00:02.486 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Verify that 'mssql_ha_replica_type = primary' is provided once] ***
Wednesday 31 August 2022  10:33:54 +0000 (0:00:00.051)       0:00:02.538 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Gather package facts] *************************
Wednesday 31 August 2022  10:33:54 +0000 (0:00:00.055)       0:00:02.593 ****** 
ok: [sut] => {
    "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] ***
Wednesday 31 August 2022  10:33:56 +0000 (0:00:01.883)       0:00:04.477 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories] ***
Wednesday 31 August 2022  10:33:56 +0000 (0:00:00.072)       0:00:04.550 ****** 
changed: [sut] => {
    "changed": true
}

TASK [linux-system-roles.mssql : Update all packages from SQL Server 2017 repo] ***
Wednesday 31 August 2022  10:33:57 +0000 (0:00:01.087)       0:00:05.637 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Remove the Microsoft SQL Server 2017 repository to upgrade to 2019] ***
Wednesday 31 August 2022  10:33:57 +0000 (0:00:00.080)       0:00:05.717 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Configure the Microsoft SQL Server 2019 repository] ***
Wednesday 31 August 2022  10:33:57 +0000 (0:00:00.072)       0:00:05.789 ****** 
changed: [sut] => {
    "changed": true,
    "repo": "packages-microsoft-com-mssql-server-2019",
    "state": "present"
}

TASK [linux-system-roles.mssql : Ensure the mssql-server package] **************
Wednesday 31 August 2022  10:33:58 +0000 (0:00:00.480)       0:00:06.270 ****** 
changed: [sut] => {
    "changed": true,
    "rc": 0,
    "results": [
        "Installed: gdb-8.2-19.el8.x86_64",
        "Installed: gdb-headless-8.2-19.el8.x86_64",
        "Installed: cyrus-sasl-2.1.27-6.el8_5.x86_64",
        "Installed: gc-7.6.4-3.el8.x86_64",
        "Installed: libatomic-8.5.0-15.el8.x86_64",
        "Installed: libatomic_ops-7.6.2-3.el8.x86_64",
        "Installed: gcc-gdb-plugin-8.5.0-15.el8.x86_64",
        "Installed: cyrus-sasl-gssapi-2.1.27-6.el8_5.x86_64",
        "Installed: guile-5:2.0.14-7.el8.x86_64",
        "Installed: libtool-ltdl-2.4.6-25.el8.x86_64",
        "Installed: libipt-1.6.1-8.el8.x86_64",
        "Installed: libbabeltrace-1.5.4-4.el8.x86_64",
        "Installed: bzip2-1.0.6-26.el8.x86_64",
        "Installed: mssql-server-15.0.4249.2-1.x86_64"
    ]
}

TASK [linux-system-roles.mssql : Ensure that the openldap-compat package is installed] ***
Wednesday 31 August 2022  10:34:51 +0000 (0:00:52.928)       0:00:59.198 ****** 
skipping: [sut] => {
    "changed": false,
    "skip_reason": "Conditional result was False"
}

TASK [linux-system-roles.mssql : Check if the errorlog file exists and its location] ***
Wednesday 31 August 2022  10:34:51 +0000 (0:00:00.050)       0:00:59.249 ****** 
ok: [sut] => {
    "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.007551",
    "end": "2022-08-31 10:34:51.767699",
    "rc": 0,
    "start": "2022-08-31 10:34:51.760148"
}

TASK [linux-system-roles.mssql : Gather system services facts] *****************
Wednesday 31 August 2022  10:34:51 +0000 (0:00:00.473)       0:00:59.722 ****** 
ok: [sut] => {
    "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] ***
Wednesday 31 August 2022  10:34:53 +0000 (0:00:02.100)       0:01:01.823 ****** 
fatal: [sut]: 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] ********************
Wednesday 31 August 2022  10:34:54 +0000 (0:00:00.104)       0:01:01.927 ****** 
ok: [sut] => {
    "changed": false
}

MSG:

All assertions passed

PLAY RECAP *********************************************************************
sut                        : ok=15   changed=3    unreachable=0    failed=0    skipped=12   rescued=1    ignored=0   

Wednesday 31 August 2022  10:34:54 +0000 (0:00:00.100)       0:01:02.027 ****** 
=============================================================================== 
linux-system-roles.mssql : Ensure the mssql-server package ------------- 52.93s
linux-system-roles.mssql : Gather system services facts ----------------- 2.10s
linux-system-roles.mssql : Gather package facts ------------------------- 1.88s
Gathering Facts --------------------------------------------------------- 1.21s
linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories --- 1.09s
linux-system-roles.mssql : Configure the Microsoft SQL Server 2019 repository --- 0.48s
linux-system-roles.mssql : Check if the errorlog file exists and its location --- 0.47s
linux-system-roles.mssql : Ensure ansible_facts used by role ------------ 0.46s
Run the role with default parameters ------------------------------------ 0.14s
linux-system-roles.mssql : Set platform/version specific variables ------ 0.12s
linux-system-roles.mssql : Verify that the variables required for setting up MSSQL are defined --- 0.10s
Assert that the role failed with variables undefined -------------------- 0.10s
linux-system-roles.mssql : Update all packages from SQL Server 2017 repo --- 0.08s
linux-system-roles.mssql : Verify if mssql_version is not smaller then the existing SQL Server version --- 0.07s
linux-system-roles.mssql : Remove the Microsoft SQL Server 2017 repository to upgrade to 2019 --- 0.07s
linux-system-roles.mssql : Verify that the user accepts EULA variables --- 0.07s
linux-system-roles.mssql : Verify if the mssql_version variable is provided correctly --- 0.07s
linux-system-roles.mssql : Verify that EL < 8 is not used with mssql_ha_configure=true --- 0.06s
linux-system-roles.mssql : Verify that 'mssql_ha_replica_type = primary' is provided once --- 0.06s
linux-system-roles.mssql : Verify if the mssql_upgrade variable is provided correctly --- 0.05s

---^---^---^---^---^---

# 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.

---^---^---^---^---^---