ansible-playbook 2.9.27 config file = /etc/ansible/ansible.cfg configured module search path = [u'/root/.ansible/plugins/modules', u'/usr/share/ansible/plugins/modules'] ansible python module location = /usr/lib/python2.7/site-packages/ansible executable location = /usr/bin/ansible-playbook python version = 2.7.5 (default, May 27 2022, 11:27:32) [GCC 4.8.5 20150623 (Red Hat 4.8.5-44)] Using /etc/ansible/ansible.cfg as config file [ERROR]: GNU xorriso 1.4.8 : RockRidge filesystem manipulator, libburnia project. xorriso : NOTE : Local character set is now assumed as: 'utf-8' 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: rhel-9_setup.yml ***************************************************** 1 plays in /cache/rhel-9_setup.yml PLAY [Setup repos] ************************************************************* META: ran handlers TASK [set up internal repositories] ******************************************** task path: /cache/rhel-9_setup.yml:5 Tuesday 07 June 2022 03:36:22 +0000 (0:00:00.026) 0:00:00.026 ********** changed: [/cache/rhel-9.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-9.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-9.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-9.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-9.qcow2 : ok=1 changed=1 unreachable=0 failed=0 skipped=0 rescued=0 ignored=0 Tuesday 07 June 2022 03:36:24 +0000 (0:00:01.278) 0:00:01.304 ********** =============================================================================== set up internal repositories -------------------------------------------- 1.28s /cache/rhel-9_setup.yml:5 ----------------------------------------------------- PLAYBOOK: tests_accept_eula.yml ************************************************ 1 plays in /tmp/tmpajc2l7lu/tests/tests_accept_eula.yml PLAY [Ensure that the role runs when EULA are accepted] ************************ TASK [Gathering Facts] ********************************************************* task path: /tmp/tmpajc2l7lu/tests/tests_accept_eula.yml:3 Tuesday 07 June 2022 03:36:24 +0000 (0:00:00.008) 0:00:01.313 ********** ok: [/cache/rhel-9.qcow2] META: ran handlers TASK [Run the role with default parameters] ************************************ task path: /tmp/tmpajc2l7lu/tests/tests_accept_eula.yml:12 Tuesday 07 June 2022 03:36:25 +0000 (0:00:01.065) 0:00:02.378 ********** TASK [linux-system-roles.mssql : Set platform/version specific variables] ****** task path: /tmp/tmpajc2l7lu/tasks/main.yml:3 Tuesday 07 June 2022 03:36:25 +0000 (0:00:00.061) 0:00:02.440 ********** ok: [/cache/rhel-9.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-2019/" }, "ansible_included_var_files": [ "/tmp/tmpajc2l7lu/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } ok: [/cache/rhel-9.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-2019/" }, "ansible_included_var_files": [ "/tmp/tmpajc2l7lu/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } skipping: [/cache/rhel-9.qcow2] => (item=RedHat_9.yml) => { "ansible_loop_var": "item", "changed": false, "item": "RedHat_9.yml", "skip_reason": "Conditional result was False" } skipping: [/cache/rhel-9.qcow2] => (item=RedHat_9.0.yml) => { "ansible_loop_var": "item", "changed": false, "item": "RedHat_9.0.yml", "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Verify that the user accepts EULA variables] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:18 Tuesday 07 June 2022 03:36:25 +0000 (0:00:00.074) 0:00:02.515 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false } MSG: All assertions passed TASK [linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:30 Tuesday 07 June 2022 03:36:25 +0000 (0:00:00.051) 0:00:02.567 ********** changed: [/cache/rhel-9.qcow2] => { "changed": true } TASK [linux-system-roles.mssql : Configure the Microsoft SQL Server 2019 repository] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:35 Tuesday 07 June 2022 03:36:26 +0000 (0:00:00.782) 0:00:03.350 ********** changed: [/cache/rhel-9.qcow2] => { "changed": true, "repo": "packages-microsoft-com-mssql-server-2019-gdr", "state": "present" } TASK [linux-system-roles.mssql : Ensure that the Microsoft SQL Server package is installed] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:42 Tuesday 07 June 2022 03:36:26 +0000 (0:00:00.416) 0:00:03.766 ********** changed: [/cache/rhel-9.qcow2] => { "changed": true, "rc": 0, "results": [ "Installed: elfutils-debuginfod-client-0.186-1.el9.x86_64", "Installed: boost-regex-1.75.0-6.el9.x86_64", "Installed: cyrus-sasl-2.1.27-20.el9.x86_64", "Installed: cyrus-sasl-gssapi-2.1.27-20.el9.x86_64", "Installed: mssql-server-15.0.4223.1-2.x86_64", "Installed: libbabeltrace-1.5.8-8.el9.x86_64", "Installed: libipt-2.0.4-5.el9.x86_64", "Installed: source-highlight-3.1.9-11.el9.x86_64", "Installed: gdb-10.2-9.el9.x86_64", "Installed: gdb-headless-10.2-9.el9.x86_64", "Installed: libatomic-11.2.1-9.4.el9.x86_64" ] } TASK [linux-system-roles.mssql : Check if the errorlog file exists and its location] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:47 Tuesday 07 June 2022 03:37:12 +0000 (0:00:45.884) 0:00:49.651 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false, "cmd": "set -euo pipefail\nerrorlog=\"$(/opt/mssql/bin/mssql-conf get filelocation errorlogfile 2>&1 \\\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.097258", "end": "2022-06-06 23:37:12.761656", "rc": 0, "start": "2022-06-06 23:37:12.664398" } TASK [linux-system-roles.mssql : Gather system services facts] ***************** task path: /tmp/tmpajc2l7lu/tasks/main.yml:62 Tuesday 07 June 2022 03:37:13 +0000 (0:00:00.593) 0:00:50.244 ********** ok: [/cache/rhel-9.qcow2] => { "ansible_facts": { "services": { "NetworkManager-dispatcher.service": { "name": "NetworkManager-dispatcher.service", "source": "systemd", "state": "inactive", "status": "enabled" }, "NetworkManager-wait-online.service": { "name": "NetworkManager-wait-online.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "NetworkManager.service": { "name": "NetworkManager.service", "source": "systemd", "state": "running", "status": "enabled" }, "auditd.service": { "name": "auditd.service", "source": "systemd", "state": "running", "status": "enabled" }, "auth-rpcgss-module.service": { "name": "auth-rpcgss-module.service", "source": "systemd", "state": "stopped", "status": "static" }, "autovt@.service": { "name": "autovt@.service", "source": "systemd", "state": "unknown", "status": "alias" }, "chrony-wait.service": { "name": "chrony-wait.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "chronyd.service": { "name": "chronyd.service", "source": "systemd", "state": "running", "status": "enabled" }, "cloud-config.service": { "name": "cloud-config.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "cloud-final.service": { "name": "cloud-final.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "cloud-init-local.service": { "name": "cloud-init-local.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "cloud-init.service": { "name": "cloud-init.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "cockpit-motd.service": { "name": "cockpit-motd.service", "source": "systemd", "state": "inactive", "status": "static" }, "cockpit-wsinstance-http.service": { "name": "cockpit-wsinstance-http.service", "source": "systemd", "state": "inactive", "status": "static" }, "cockpit-wsinstance-https-factory@.service": { "name": "cockpit-wsinstance-https-factory@.service", "source": "systemd", "state": "unknown", "status": "static" }, "cockpit-wsinstance-https@.service": { "name": "cockpit-wsinstance-https@.service", "source": "systemd", "state": "unknown", "status": "static" }, "cockpit.service": { "name": "cockpit.service", "source": "systemd", "state": "inactive", "status": "static" }, "console-getty.service": { "name": "console-getty.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "container-getty@.service": { "name": "container-getty@.service", "source": "systemd", "state": "unknown", "status": "static" }, "cpupower.service": { "name": "cpupower.service", "source": "systemd", "state": "stopped", "status": "disabled" }, "crond.service": { "name": "crond.service", "source": "systemd", "state": "running", "status": "enabled" }, "dbus-broker.service": { "name": "dbus-broker.service", "source": "systemd", "state": "running", "status": "enabled" }, "dbus-org.freedesktop.hostname1.service": { "name": "dbus-org.freedesktop.hostname1.service", "source": "systemd", "state": "inactive", "status": "alias" }, "dbus-org.freedesktop.locale1.service": { "name": "dbus-org.freedesktop.locale1.service", "source": "systemd", "state": "inactive", "status": "alias" }, "dbus-org.freedesktop.login1.service": { "name": "dbus-org.freedesktop.login1.service", "source": "systemd", "state": "active", "status": "alias" }, "dbus-org.freedesktop.nm-dispatcher.service": { "name": "dbus-org.freedesktop.nm-dispatcher.service", "source": "systemd", "state": "inactive", "status": "alias" }, "dbus-org.freedesktop.timedate1.service": { "name": "dbus-org.freedesktop.timedate1.service", "source": "systemd", "state": "inactive", "status": "alias" }, "dbus.service": { "name": "dbus.service", "source": "systemd", "state": "active", "status": "alias" }, "debug-shell.service": { "name": "debug-shell.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "dnf-makecache.service": { "name": "dnf-makecache.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-cmdline.service": { "name": "dracut-cmdline.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-initqueue.service": { "name": "dracut-initqueue.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-mount.service": { "name": "dracut-mount.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-pre-mount.service": { "name": "dracut-pre-mount.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-pre-pivot.service": { "name": "dracut-pre-pivot.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-pre-trigger.service": { "name": "dracut-pre-trigger.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-pre-udev.service": { "name": "dracut-pre-udev.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-shutdown-onfailure.service": { "name": "dracut-shutdown-onfailure.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-shutdown.service": { "name": "dracut-shutdown.service", "source": "systemd", "state": "stopped", "status": "static" }, "emergency.service": { "name": "emergency.service", "source": "systemd", "state": "stopped", "status": "static" }, "fstrim.service": { "name": "fstrim.service", "source": "systemd", "state": "inactive", "status": "static" }, "fwupd-offline-update.service": { "name": "fwupd-offline-update.service", "source": "systemd", "state": "inactive", "status": "static" }, "fwupd-refresh.service": { "name": "fwupd-refresh.service", "source": "systemd", "state": "inactive", "status": "static" }, "fwupd.service": { "name": "fwupd.service", "source": "systemd", "state": "inactive", "status": "static" }, "getty@.service": { "name": "getty@.service", "source": "systemd", "state": "unknown", "status": "enabled" }, "getty@tty1.service": { "name": "getty@tty1.service", "source": "systemd", "state": "running", "status": "unknown" }, "grub-boot-indeterminate.service": { "name": "grub-boot-indeterminate.service", "source": "systemd", "state": "inactive", "status": "static" }, "grub2-systemd-integration.service": { "name": "grub2-systemd-integration.service", "source": "systemd", "state": "inactive", "status": "static" }, "gssproxy.service": { "name": "gssproxy.service", "source": "systemd", "state": "running", "status": "disabled" }, "initrd-cleanup.service": { "name": "initrd-cleanup.service", "source": "systemd", "state": "stopped", "status": "static" }, "initrd-parse-etc.service": { "name": "initrd-parse-etc.service", "source": "systemd", "state": "stopped", "status": "static" }, "initrd-switch-root.service": { "name": "initrd-switch-root.service", "source": "systemd", "state": "stopped", "status": "static" }, "initrd-udevadm-cleanup-db.service": { "name": "initrd-udevadm-cleanup-db.service", "source": "systemd", "state": "stopped", "status": "static" }, "insights-client-boot.service": { "name": "insights-client-boot.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "insights-client-results.service": { "name": "insights-client-results.service", "source": "systemd", "state": "inactive", "status": "static" }, "insights-client.service": { "name": "insights-client.service", "source": "systemd", "state": "inactive", "status": "static" }, "irqbalance.service": { "name": "irqbalance.service", "source": "systemd", "state": "running", "status": "enabled" }, "kdump.service": { "name": "kdump.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "kmod-static-nodes.service": { "name": "kmod-static-nodes.service", "source": "systemd", "state": "stopped", "status": "static" }, "kvm_stat.service": { "name": "kvm_stat.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "ldconfig.service": { "name": "ldconfig.service", "source": "systemd", "state": "stopped", "status": "static" }, "logrotate.service": { "name": "logrotate.service", "source": "systemd", "state": "stopped", "status": "static" }, "man-db-cache-update.service": { "name": "man-db-cache-update.service", "source": "systemd", "state": "stopped", "status": "static" }, "man-db-restart-cache-update.service": { "name": "man-db-restart-cache-update.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "microcode.service": { "name": "microcode.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "modprobe@.service": { "name": "modprobe@.service", "source": "systemd", "state": "unknown", "status": "static" }, "modprobe@configfs.service": { "name": "modprobe@configfs.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "modprobe@drm.service": { "name": "modprobe@drm.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "modprobe@fuse.service": { "name": "modprobe@fuse.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "mssql-server.service": { "name": "mssql-server.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "nfs-blkmap.service": { "name": "nfs-blkmap.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "nfs-idmapd.service": { "name": "nfs-idmapd.service", "source": "systemd", "state": "stopped", "status": "static" }, "nfs-mountd.service": { "name": "nfs-mountd.service", "source": "systemd", "state": "stopped", "status": "static" }, "nfs-server.service": { "name": "nfs-server.service", "source": "systemd", "state": "stopped", "status": "disabled" }, "nfs-utils.service": { "name": "nfs-utils.service", "source": "systemd", "state": "stopped", "status": "static" }, "nfsdcld.service": { "name": "nfsdcld.service", "source": "systemd", "state": "stopped", "status": "static" }, "nis-domainname.service": { "name": "nis-domainname.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "nm-priv-helper.service": { "name": "nm-priv-helper.service", "source": "systemd", "state": "inactive", "status": "static" }, "oddjobd.service": { "name": "oddjobd.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "packagekit-offline-update.service": { "name": "packagekit-offline-update.service", "source": "systemd", "state": "inactive", "status": "static" }, "packagekit.service": { "name": "packagekit.service", "source": "systemd", "state": "inactive", "status": "static" }, "pam_namespace.service": { "name": "pam_namespace.service", "source": "systemd", "state": "inactive", "status": "static" }, "polkit.service": { "name": "polkit.service", "source": "systemd", "state": "running", "status": "static" }, "qemu-guest-agent.service": { "name": "qemu-guest-agent.service", "source": "systemd", "state": "inactive", "status": "enabled" }, "quotaon.service": { "name": "quotaon.service", "source": "systemd", "state": "inactive", "status": "static" }, "rc-local.service": { "name": "rc-local.service", "source": "systemd", "state": "stopped", "status": "static" }, "rdisc.service": { "name": "rdisc.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "rescue.service": { "name": "rescue.service", "source": "systemd", "state": "stopped", "status": "static" }, "rhsm-facts.service": { "name": "rhsm-facts.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "rhsm.service": { "name": "rhsm.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "rhsmcertd.service": { "name": "rhsmcertd.service", "source": "systemd", "state": "running", "status": "enabled" }, "rpc-gssd.service": { "name": "rpc-gssd.service", "source": "systemd", "state": "stopped", "status": "static" }, "rpc-statd-notify.service": { "name": "rpc-statd-notify.service", "source": "systemd", "state": "stopped", "status": "static" }, "rpc-statd.service": { "name": "rpc-statd.service", "source": "systemd", "state": "stopped", "status": "static" }, "rpcbind.service": { "name": "rpcbind.service", "source": "systemd", "state": "running", "status": "enabled" }, "rpmdb-rebuild.service": { "name": "rpmdb-rebuild.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "rsyslog.service": { "name": "rsyslog.service", "source": "systemd", "state": "running", "status": "enabled" }, "run-r9880255e876a4fd794c40c83bf9c8c85.service": { "name": "run-r9880255e876a4fd794c40c83bf9c8c85.service", "source": "systemd", "state": "running", "status": "transient" }, "saslauthd.service": { "name": "saslauthd.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "selinux-autorelabel-mark.service": { "name": "selinux-autorelabel-mark.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "selinux-autorelabel.service": { "name": "selinux-autorelabel.service", "source": "systemd", "state": "inactive", "status": "static" }, "serial-getty@.service": { "name": "serial-getty@.service", "source": "systemd", "state": "unknown", "status": "indirect" }, "serial-getty@ttyS0.service": { "name": "serial-getty@ttyS0.service", "source": "systemd", "state": "running", "status": "unknown" }, "sshd-keygen@.service": { "name": "sshd-keygen@.service", "source": "systemd", "state": "unknown", "status": "disabled" }, "sshd-keygen@ecdsa.service": { "name": "sshd-keygen@ecdsa.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "sshd-keygen@ed25519.service": { "name": "sshd-keygen@ed25519.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "sshd-keygen@rsa.service": { "name": "sshd-keygen@rsa.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "sshd.service": { "name": "sshd.service", "source": "systemd", "state": "running", "status": "enabled" }, "sshd@.service": { "name": "sshd@.service", "source": "systemd", "state": "unknown", "status": "static" }, "sssd-autofs.service": { "name": "sssd-autofs.service", "source": "systemd", "state": "inactive", "status": "indirect" }, "sssd-kcm.service": { "name": "sssd-kcm.service", "source": "systemd", "state": "stopped", "status": "indirect" }, "sssd-nss.service": { "name": "sssd-nss.service", "source": "systemd", "state": "inactive", "status": "indirect" }, "sssd-pac.service": { "name": "sssd-pac.service", "source": "systemd", "state": "inactive", "status": "indirect" }, "sssd-pam.service": { "name": "sssd-pam.service", "source": "systemd", "state": "inactive", "status": "indirect" }, "sssd-ssh.service": { "name": "sssd-ssh.service", "source": "systemd", "state": "inactive", "status": "indirect" }, "sssd-sudo.service": { "name": "sssd-sudo.service", "source": "systemd", "state": "inactive", "status": "indirect" }, "sssd.service": { "name": "sssd.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "system-update-cleanup.service": { "name": "system-update-cleanup.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-ask-password-console.service": { "name": "systemd-ask-password-console.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-ask-password-wall.service": { "name": "systemd-ask-password-wall.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-backlight@.service": { "name": "systemd-backlight@.service", "source": "systemd", "state": "unknown", "status": "static" }, "systemd-binfmt.service": { "name": "systemd-binfmt.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-boot-check-no-failures.service": { "name": "systemd-boot-check-no-failures.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "systemd-coredump@.service": { "name": "systemd-coredump@.service", "source": "systemd", "state": "unknown", "status": "static" }, "systemd-exit.service": { "name": "systemd-exit.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-firstboot.service": { "name": "systemd-firstboot.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-fsck-root.service": { "name": "systemd-fsck-root.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-fsck@.service": { "name": "systemd-fsck@.service", "source": "systemd", "state": "unknown", "status": "static" }, "systemd-fsck@dev-disk-by\\x2duuid-7B77\\x2d95E7.service": { "name": "systemd-fsck@dev-disk-by\\x2duuid-7B77\\x2d95E7.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "systemd-fsck@dev-vda2.service": { "name": "systemd-fsck@dev-vda2.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "systemd-halt.service": { "name": "systemd-halt.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-hibernate-resume@.service": { "name": "systemd-hibernate-resume@.service", "source": "systemd", "state": "unknown", "status": "static" }, "systemd-hibernate.service": { "name": "systemd-hibernate.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-hostnamed.service": { "name": "systemd-hostnamed.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-hwdb-update.service": { "name": "systemd-hwdb-update.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-hybrid-sleep.service": { "name": "systemd-hybrid-sleep.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-initctl.service": { "name": "systemd-initctl.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-journal-catalog-update.service": { "name": "systemd-journal-catalog-update.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-journal-flush.service": { "name": "systemd-journal-flush.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-journald.service": { "name": "systemd-journald.service", "source": "systemd", "state": "running", "status": "static" }, "systemd-journald@.service": { "name": "systemd-journald@.service", "source": "systemd", "state": "unknown", "status": "static" }, "systemd-kexec.service": { "name": "systemd-kexec.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-localed.service": { "name": "systemd-localed.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-logind.service": { "name": "systemd-logind.service", "source": "systemd", "state": "running", "status": "static" }, "systemd-machine-id-commit.service": { "name": "systemd-machine-id-commit.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-modules-load.service": { "name": "systemd-modules-load.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-network-generator.service": { "name": "systemd-network-generator.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "systemd-poweroff.service": { "name": "systemd-poweroff.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-pstore.service": { "name": "systemd-pstore.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "systemd-quotacheck.service": { "name": "systemd-quotacheck.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-random-seed.service": { "name": "systemd-random-seed.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-reboot.service": { "name": "systemd-reboot.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-remount-fs.service": { "name": "systemd-remount-fs.service", "source": "systemd", "state": "stopped", "status": "enabled-runtime" }, "systemd-repart.service": { "name": "systemd-repart.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-rfkill.service": { "name": "systemd-rfkill.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-suspend-then-hibernate.service": { "name": "systemd-suspend-then-hibernate.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-suspend.service": { "name": "systemd-suspend.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-sysctl.service": { "name": "systemd-sysctl.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-sysext.service": { "name": "systemd-sysext.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "systemd-sysusers.service": { "name": "systemd-sysusers.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-timedated.service": { "name": "systemd-timedated.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-tmpfiles-clean.service": { "name": "systemd-tmpfiles-clean.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-tmpfiles-setup-dev.service": { "name": "systemd-tmpfiles-setup-dev.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-tmpfiles-setup.service": { "name": "systemd-tmpfiles-setup.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-udev-settle.service": { "name": "systemd-udev-settle.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-udev-trigger.service": { "name": "systemd-udev-trigger.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-udevd.service": { "name": "systemd-udevd.service", "source": "systemd", "state": "running", "status": "static" }, "systemd-update-done.service": { "name": "systemd-update-done.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-update-utmp-runlevel.service": { "name": "systemd-update-utmp-runlevel.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-update-utmp.service": { "name": "systemd-update-utmp.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-user-sessions.service": { "name": "systemd-user-sessions.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-vconsole-setup.service": { "name": "systemd-vconsole-setup.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-volatile-root.service": { "name": "systemd-volatile-root.service", "source": "systemd", "state": "inactive", "status": "static" }, "teamd@.service": { "name": "teamd@.service", "source": "systemd", "state": "unknown", "status": "static" }, "tuned.service": { "name": "tuned.service", "source": "systemd", "state": "running", "status": "enabled" }, "user-runtime-dir@.service": { "name": "user-runtime-dir@.service", "source": "systemd", "state": "unknown", "status": "static" }, "user-runtime-dir@0.service": { "name": "user-runtime-dir@0.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "user@.service": { "name": "user@.service", "source": "systemd", "state": "unknown", "status": "static" }, "user@0.service": { "name": "user@0.service", "source": "systemd", "state": "running", "status": "unknown" } } }, "changed": false } TASK [linux-system-roles.mssql : Verify that the variables required for setting up MSSQL are defined] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:75 Tuesday 07 June 2022 03:37:14 +0000 (0:00:01.711) 0:00:51.956 ********** fatal: [/cache/rhel-9.qcow2]: FAILED! => { "assertion": "mssql_password is not none", "changed": false, "evaluated_to": false } MSG: [u'You must define the following variables to set up MSSQL:', u'mssql_password', u'mssql_edition'] TASK [Assert that the role failed with variables undefined] ******************** task path: /tmp/tmpajc2l7lu/tests/tests_accept_eula.yml:21 Tuesday 07 June 2022 03:37:14 +0000 (0:00:00.094) 0:00:52.050 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false } MSG: All assertions passed META: ran handlers META: ran handlers PLAY RECAP ********************************************************************* /cache/rhel-9.qcow2 : ok=10 changed=4 unreachable=0 failed=0 skipped=0 rescued=1 ignored=0 Tuesday 07 June 2022 03:37:15 +0000 (0:00:00.038) 0:00:52.089 ********** =============================================================================== linux-system-roles.mssql : Ensure that the Microsoft SQL Server package is installed -- 45.88s /tmp/tmpajc2l7lu/tasks/main.yml:42 -------------------------------------------- linux-system-roles.mssql : Gather system services facts ----------------- 1.71s /tmp/tmpajc2l7lu/tasks/main.yml:62 -------------------------------------------- set up internal repositories -------------------------------------------- 1.28s /cache/rhel-9_setup.yml:5 ----------------------------------------------------- Gathering Facts --------------------------------------------------------- 1.07s /tmp/tmpajc2l7lu/tests/tests_accept_eula.yml:3 -------------------------------- linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories --- 0.78s /tmp/tmpajc2l7lu/tasks/main.yml:30 -------------------------------------------- linux-system-roles.mssql : Check if the errorlog file exists and its location --- 0.59s /tmp/tmpajc2l7lu/tasks/main.yml:47 -------------------------------------------- linux-system-roles.mssql : Configure the Microsoft SQL Server 2019 repository --- 0.42s /tmp/tmpajc2l7lu/tasks/main.yml:35 -------------------------------------------- linux-system-roles.mssql : Verify that the variables required for setting up MSSQL are defined --- 0.09s /tmp/tmpajc2l7lu/tasks/main.yml:75 -------------------------------------------- linux-system-roles.mssql : Set platform/version specific variables ------ 0.07s /tmp/tmpajc2l7lu/tasks/main.yml:3 --------------------------------------------- Run the role with default parameters ------------------------------------ 0.06s /tmp/tmpajc2l7lu/tests/tests_accept_eula.yml:12 ------------------------------- linux-system-roles.mssql : Verify that the user accepts EULA variables --- 0.05s /tmp/tmpajc2l7lu/tasks/main.yml:18 -------------------------------------------- Assert that the role failed with variables undefined -------------------- 0.04s /tmp/tmpajc2l7lu/tests/tests_accept_eula.yml:21 ------------------------------- ansible-playbook 2.9.27 config file = /etc/ansible/ansible.cfg configured module search path = [u'/root/.ansible/plugins/modules', u'/usr/share/ansible/plugins/modules'] ansible python module location = /usr/lib/python2.7/site-packages/ansible executable location = /usr/bin/ansible-playbook python version = 2.7.5 (default, May 27 2022, 11:27:32) [GCC 4.8.5 20150623 (Red Hat 4.8.5-44)] 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: rhel-9_setup.yml ***************************************************** 1 plays in /cache/rhel-9_setup.yml PLAY [Setup repos] ************************************************************* META: ran handlers TASK [set up internal repositories] ******************************************** task path: /cache/rhel-9_setup.yml:5 Tuesday 07 June 2022 03:37:15 +0000 (0:00:00.022) 0:00:00.022 ********** ok: [/cache/rhel-9.qcow2] => (item=None) => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false } ok: [/cache/rhel-9.qcow2] => (item=None) => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false } ok: [/cache/rhel-9.qcow2] => (item=None) => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false } ok: [/cache/rhel-9.qcow2] => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false } META: ran handlers META: ran handlers PLAY RECAP ********************************************************************* /cache/rhel-9.qcow2 : ok=1 changed=0 unreachable=0 failed=0 skipped=0 rescued=0 ignored=0 Tuesday 07 June 2022 03:37:17 +0000 (0:00:01.277) 0:00:01.300 ********** =============================================================================== set up internal repositories -------------------------------------------- 1.28s /cache/rhel-9_setup.yml:5 ----------------------------------------------------- PLAYBOOK: tests_default.yml **************************************************** 1 plays in /tmp/tmpajc2l7lu/tests/tests_default.yml PLAY [Ensure that the role runs with default parameters] *********************** TASK [Gathering Facts] ********************************************************* task path: /tmp/tmpajc2l7lu/tests/tests_default.yml:3 Tuesday 07 June 2022 03:37:17 +0000 (0:00:00.009) 0:00:01.309 ********** ok: [/cache/rhel-9.qcow2] META: ran handlers TASK [Run the role with default parameters] ************************************ task path: /tmp/tmpajc2l7lu/tests/tests_default.yml:8 Tuesday 07 June 2022 03:37:17 +0000 (0:00:00.936) 0:00:02.245 ********** TASK [linux-system-roles.mssql : Set platform/version specific variables] ****** task path: /tmp/tmpajc2l7lu/tasks/main.yml:3 Tuesday 07 June 2022 03:37:18 +0000 (0:00:00.060) 0:00:02.306 ********** ok: [/cache/rhel-9.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-2019/" }, "ansible_included_var_files": [ "/tmp/tmpajc2l7lu/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } ok: [/cache/rhel-9.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-2019/" }, "ansible_included_var_files": [ "/tmp/tmpajc2l7lu/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } skipping: [/cache/rhel-9.qcow2] => (item=RedHat_9.yml) => { "ansible_loop_var": "item", "changed": false, "item": "RedHat_9.yml", "skip_reason": "Conditional result was False" } skipping: [/cache/rhel-9.qcow2] => (item=RedHat_9.0.yml) => { "ansible_loop_var": "item", "changed": false, "item": "RedHat_9.0.yml", "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Verify that the user accepts EULA variables] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:18 Tuesday 07 June 2022 03:37:18 +0000 (0:00:00.071) 0:00:02.377 ********** fatal: [/cache/rhel-9.qcow2]: FAILED! => { "assertion": "mssql_accept_microsoft_odbc_driver_17_for_sql_server_eula | bool", "changed": false, "evaluated_to": false } MSG: [u'You must accept EULA by setting the following variables to true:', u'mssql_accept_microsoft_odbc_driver_17_for_sql_server_eula', u'mssql_accept_microsoft_cli_utilities_for_sql_server_eula', u'mssql_accept_microsoft_sql_server_2019_standard_eula'] TASK [Assert that the role failed with EULA not accepted] ********************** task path: /tmp/tmpajc2l7lu/tests/tests_default.yml:17 Tuesday 07 June 2022 03:37:18 +0000 (0:00:00.043) 0:00:02.420 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false } MSG: All assertions passed META: ran handlers META: ran handlers PLAY RECAP ********************************************************************* /cache/rhel-9.qcow2 : ok=4 changed=0 unreachable=0 failed=0 skipped=0 rescued=1 ignored=0 Tuesday 07 June 2022 03:37:18 +0000 (0:00:00.035) 0:00:02.456 ********** =============================================================================== set up internal repositories -------------------------------------------- 1.28s /cache/rhel-9_setup.yml:5 ----------------------------------------------------- Gathering Facts --------------------------------------------------------- 0.94s /tmp/tmpajc2l7lu/tests/tests_default.yml:3 ------------------------------------ linux-system-roles.mssql : Set platform/version specific variables ------ 0.07s /tmp/tmpajc2l7lu/tasks/main.yml:3 --------------------------------------------- Run the role with default parameters ------------------------------------ 0.06s /tmp/tmpajc2l7lu/tests/tests_default.yml:8 ------------------------------------ linux-system-roles.mssql : Verify that the user accepts EULA variables --- 0.04s /tmp/tmpajc2l7lu/tasks/main.yml:18 -------------------------------------------- Assert that the role failed with EULA not accepted ---------------------- 0.04s /tmp/tmpajc2l7lu/tests/tests_default.yml:17 ----------------------------------- ansible-playbook 2.9.27 config file = /etc/ansible/ansible.cfg configured module search path = [u'/root/.ansible/plugins/modules', u'/usr/share/ansible/plugins/modules'] ansible python module location = /usr/lib/python2.7/site-packages/ansible executable location = /usr/bin/ansible-playbook python version = 2.7.5 (default, May 27 2022, 11:27:32) [GCC 4.8.5 20150623 (Red Hat 4.8.5-44)] 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: rhel-9_setup.yml ***************************************************** 1 plays in /cache/rhel-9_setup.yml PLAY [Setup repos] ************************************************************* META: ran handlers TASK [set up internal repositories] ******************************************** task path: /cache/rhel-9_setup.yml:5 Tuesday 07 June 2022 03:37:18 +0000 (0:00:00.022) 0:00:00.022 ********** ok: [/cache/rhel-9.qcow2] => (item=None) => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false } ok: [/cache/rhel-9.qcow2] => (item=None) => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false } ok: [/cache/rhel-9.qcow2] => (item=None) => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false } ok: [/cache/rhel-9.qcow2] => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false } META: ran handlers META: ran handlers PLAY RECAP ********************************************************************* /cache/rhel-9.qcow2 : ok=1 changed=0 unreachable=0 failed=0 skipped=0 rescued=0 ignored=0 Tuesday 07 June 2022 03:37:20 +0000 (0:00:01.242) 0:00:01.264 ********** =============================================================================== set up internal repositories -------------------------------------------- 1.24s /cache/rhel-9_setup.yml:5 ----------------------------------------------------- PLAYBOOK: tests_idempotency.yml ************************************************ 1 plays in /tmp/tmpajc2l7lu/tests/tests_idempotency.yml PLAY [Ensure that the role is idempotent] ************************************** TASK [Gathering Facts] ********************************************************* task path: /tmp/tmpajc2l7lu/tests/tests_idempotency.yml:3 Tuesday 07 June 2022 03:37:20 +0000 (0:00:00.009) 0:00:01.274 ********** ok: [/cache/rhel-9.qcow2] META: ran handlers TASK [Ensure that the role runs on a fresh host and sets all parameters] ******* task path: /tmp/tmpajc2l7lu/tests/tests_idempotency.yml:10 Tuesday 07 June 2022 03:37:21 +0000 (0:00:00.922) 0:00:02.196 ********** TASK [linux-system-roles.mssql : Set platform/version specific variables] ****** task path: /tmp/tmpajc2l7lu/tasks/main.yml:3 Tuesday 07 June 2022 03:37:21 +0000 (0:00:00.062) 0:00:02.259 ********** ok: [/cache/rhel-9.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-2019/" }, "ansible_included_var_files": [ "/tmp/tmpajc2l7lu/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } ok: [/cache/rhel-9.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-2019/" }, "ansible_included_var_files": [ "/tmp/tmpajc2l7lu/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } skipping: [/cache/rhel-9.qcow2] => (item=RedHat_9.yml) => { "ansible_loop_var": "item", "changed": false, "item": "RedHat_9.yml", "skip_reason": "Conditional result was False" } skipping: [/cache/rhel-9.qcow2] => (item=RedHat_9.0.yml) => { "ansible_loop_var": "item", "changed": false, "item": "RedHat_9.0.yml", "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Verify that the user accepts EULA variables] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:18 Tuesday 07 June 2022 03:37:21 +0000 (0:00:00.074) 0:00:02.333 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false } MSG: All assertions passed TASK [linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:30 Tuesday 07 June 2022 03:37:21 +0000 (0:00:00.047) 0:00:02.381 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false } TASK [linux-system-roles.mssql : Configure the Microsoft SQL Server 2019 repository] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:35 Tuesday 07 June 2022 03:37:21 +0000 (0:00:00.665) 0:00:03.046 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false, "repo": "packages-microsoft-com-mssql-server-2019-gdr", "state": "present" } TASK [linux-system-roles.mssql : Ensure that the Microsoft SQL Server package is installed] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:42 Tuesday 07 June 2022 03:37:22 +0000 (0:00:00.394) 0:00:03.441 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false, "rc": 0, "results": [] } MSG: Nothing to do TASK [linux-system-roles.mssql : Check if the errorlog file exists and its location] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:47 Tuesday 07 June 2022 03:37:23 +0000 (0:00:01.041) 0:00:04.482 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false, "cmd": "set -euo pipefail\nerrorlog=\"$(/opt/mssql/bin/mssql-conf get filelocation errorlogfile 2>&1 \\\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.093142", "end": "2022-06-06 23:37:23.546872", "rc": 0, "start": "2022-06-06 23:37:23.453730" } TASK [linux-system-roles.mssql : Gather system services facts] ***************** task path: /tmp/tmpajc2l7lu/tasks/main.yml:62 Tuesday 07 June 2022 03:37:23 +0000 (0:00:00.589) 0:00:05.072 ********** ok: [/cache/rhel-9.qcow2] => { "ansible_facts": { "services": { "NetworkManager-dispatcher.service": { "name": "NetworkManager-dispatcher.service", "source": "systemd", "state": "inactive", "status": "enabled" }, "NetworkManager-wait-online.service": { "name": "NetworkManager-wait-online.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "NetworkManager.service": { "name": "NetworkManager.service", "source": "systemd", "state": "running", "status": "enabled" }, "auditd.service": { "name": "auditd.service", "source": "systemd", "state": "running", "status": "enabled" }, "auth-rpcgss-module.service": { "name": "auth-rpcgss-module.service", "source": "systemd", "state": "stopped", "status": "static" }, "autovt@.service": { "name": "autovt@.service", "source": "systemd", "state": "unknown", "status": "alias" }, "chrony-wait.service": { "name": "chrony-wait.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "chronyd.service": { "name": "chronyd.service", "source": "systemd", "state": "running", "status": "enabled" }, "cloud-config.service": { "name": "cloud-config.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "cloud-final.service": { "name": "cloud-final.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "cloud-init-local.service": { "name": "cloud-init-local.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "cloud-init.service": { "name": "cloud-init.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "cockpit-motd.service": { "name": "cockpit-motd.service", "source": "systemd", "state": "inactive", "status": "static" }, "cockpit-wsinstance-http.service": { "name": "cockpit-wsinstance-http.service", "source": "systemd", "state": "inactive", "status": "static" }, "cockpit-wsinstance-https-factory@.service": { "name": "cockpit-wsinstance-https-factory@.service", "source": "systemd", "state": "unknown", "status": "static" }, "cockpit-wsinstance-https@.service": { "name": "cockpit-wsinstance-https@.service", "source": "systemd", "state": "unknown", "status": "static" }, "cockpit.service": { "name": "cockpit.service", "source": "systemd", "state": "inactive", "status": "static" }, "console-getty.service": { "name": "console-getty.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "container-getty@.service": { "name": "container-getty@.service", "source": "systemd", "state": "unknown", "status": "static" }, "cpupower.service": { "name": "cpupower.service", "source": "systemd", "state": "stopped", "status": "disabled" }, "crond.service": { "name": "crond.service", "source": "systemd", "state": "running", "status": "enabled" }, "dbus-broker.service": { "name": "dbus-broker.service", "source": "systemd", "state": "running", "status": "enabled" }, "dbus-org.freedesktop.hostname1.service": { "name": "dbus-org.freedesktop.hostname1.service", "source": "systemd", "state": "inactive", "status": "alias" }, "dbus-org.freedesktop.locale1.service": { "name": "dbus-org.freedesktop.locale1.service", "source": "systemd", "state": "inactive", "status": "alias" }, "dbus-org.freedesktop.login1.service": { "name": "dbus-org.freedesktop.login1.service", "source": "systemd", "state": "active", "status": "alias" }, "dbus-org.freedesktop.nm-dispatcher.service": { "name": "dbus-org.freedesktop.nm-dispatcher.service", "source": "systemd", "state": "inactive", "status": "alias" }, "dbus-org.freedesktop.timedate1.service": { "name": "dbus-org.freedesktop.timedate1.service", "source": "systemd", "state": "inactive", "status": "alias" }, "dbus.service": { "name": "dbus.service", "source": "systemd", "state": "active", "status": "alias" }, "debug-shell.service": { "name": "debug-shell.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "dnf-makecache.service": { "name": "dnf-makecache.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-cmdline.service": { "name": "dracut-cmdline.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-initqueue.service": { "name": "dracut-initqueue.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-mount.service": { "name": "dracut-mount.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-pre-mount.service": { "name": "dracut-pre-mount.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-pre-pivot.service": { "name": "dracut-pre-pivot.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-pre-trigger.service": { "name": "dracut-pre-trigger.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-pre-udev.service": { "name": "dracut-pre-udev.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-shutdown-onfailure.service": { "name": "dracut-shutdown-onfailure.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-shutdown.service": { "name": "dracut-shutdown.service", "source": "systemd", "state": "stopped", "status": "static" }, "emergency.service": { "name": "emergency.service", "source": "systemd", "state": "stopped", "status": "static" }, "fstrim.service": { "name": "fstrim.service", "source": "systemd", "state": "inactive", "status": "static" }, "fwupd-offline-update.service": { "name": "fwupd-offline-update.service", "source": "systemd", "state": "inactive", "status": "static" }, "fwupd-refresh.service": { "name": "fwupd-refresh.service", "source": "systemd", "state": "inactive", "status": "static" }, "fwupd.service": { "name": "fwupd.service", "source": "systemd", "state": "inactive", "status": "static" }, "getty@.service": { "name": "getty@.service", "source": "systemd", "state": "unknown", "status": "enabled" }, "getty@tty1.service": { "name": "getty@tty1.service", "source": "systemd", "state": "running", "status": "unknown" }, "grub-boot-indeterminate.service": { "name": "grub-boot-indeterminate.service", "source": "systemd", "state": "inactive", "status": "static" }, "grub2-systemd-integration.service": { "name": "grub2-systemd-integration.service", "source": "systemd", "state": "inactive", "status": "static" }, "gssproxy.service": { "name": "gssproxy.service", "source": "systemd", "state": "running", "status": "disabled" }, "initrd-cleanup.service": { "name": "initrd-cleanup.service", "source": "systemd", "state": "stopped", "status": "static" }, "initrd-parse-etc.service": { "name": "initrd-parse-etc.service", "source": "systemd", "state": "stopped", "status": "static" }, "initrd-switch-root.service": { "name": "initrd-switch-root.service", "source": "systemd", "state": "stopped", "status": "static" }, "initrd-udevadm-cleanup-db.service": { "name": "initrd-udevadm-cleanup-db.service", "source": "systemd", "state": "stopped", "status": "static" }, "insights-client-boot.service": { "name": "insights-client-boot.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "insights-client-results.service": { "name": "insights-client-results.service", "source": "systemd", "state": "inactive", "status": "static" }, "insights-client.service": { "name": "insights-client.service", "source": "systemd", "state": "inactive", "status": "static" }, "irqbalance.service": { "name": "irqbalance.service", "source": "systemd", "state": "running", "status": "enabled" }, "kdump.service": { "name": "kdump.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "kmod-static-nodes.service": { "name": "kmod-static-nodes.service", "source": "systemd", "state": "stopped", "status": "static" }, "kvm_stat.service": { "name": "kvm_stat.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "ldconfig.service": { "name": "ldconfig.service", "source": "systemd", "state": "stopped", "status": "static" }, "logrotate.service": { "name": "logrotate.service", "source": "systemd", "state": "stopped", "status": "static" }, "man-db-cache-update.service": { "name": "man-db-cache-update.service", "source": "systemd", "state": "inactive", "status": "static" }, "man-db-restart-cache-update.service": { "name": "man-db-restart-cache-update.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "microcode.service": { "name": "microcode.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "modprobe@.service": { "name": "modprobe@.service", "source": "systemd", "state": "unknown", "status": "static" }, "modprobe@configfs.service": { "name": "modprobe@configfs.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "modprobe@drm.service": { "name": "modprobe@drm.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "modprobe@fuse.service": { "name": "modprobe@fuse.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "mssql-server.service": { "name": "mssql-server.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "nfs-blkmap.service": { "name": "nfs-blkmap.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "nfs-idmapd.service": { "name": "nfs-idmapd.service", "source": "systemd", "state": "stopped", "status": "static" }, "nfs-mountd.service": { "name": "nfs-mountd.service", "source": "systemd", "state": "stopped", "status": "static" }, "nfs-server.service": { "name": "nfs-server.service", "source": "systemd", "state": "stopped", "status": "disabled" }, "nfs-utils.service": { "name": "nfs-utils.service", "source": "systemd", "state": "stopped", "status": "static" }, "nfsdcld.service": { "name": "nfsdcld.service", "source": "systemd", "state": "stopped", "status": "static" }, "nis-domainname.service": { "name": "nis-domainname.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "nm-priv-helper.service": { "name": "nm-priv-helper.service", "source": "systemd", "state": "inactive", "status": "static" }, "oddjobd.service": { "name": "oddjobd.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "packagekit-offline-update.service": { "name": "packagekit-offline-update.service", "source": "systemd", "state": "inactive", "status": "static" }, "packagekit.service": { "name": "packagekit.service", "source": "systemd", "state": "inactive", "status": "static" }, "pam_namespace.service": { "name": "pam_namespace.service", "source": "systemd", "state": "inactive", "status": "static" }, "polkit.service": { "name": "polkit.service", "source": "systemd", "state": "running", "status": "static" }, "qemu-guest-agent.service": { "name": "qemu-guest-agent.service", "source": "systemd", "state": "inactive", "status": "enabled" }, "quotaon.service": { "name": "quotaon.service", "source": "systemd", "state": "inactive", "status": "static" }, "rc-local.service": { "name": "rc-local.service", "source": "systemd", "state": "stopped", "status": "static" }, "rdisc.service": { "name": "rdisc.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "rescue.service": { "name": "rescue.service", "source": "systemd", "state": "stopped", "status": "static" }, "rhsm-facts.service": { "name": "rhsm-facts.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "rhsm.service": { "name": "rhsm.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "rhsmcertd.service": { "name": "rhsmcertd.service", "source": "systemd", "state": "running", "status": "enabled" }, "rpc-gssd.service": { "name": "rpc-gssd.service", "source": "systemd", "state": "stopped", "status": "static" }, "rpc-statd-notify.service": { "name": "rpc-statd-notify.service", "source": "systemd", "state": "stopped", "status": "static" }, "rpc-statd.service": { "name": "rpc-statd.service", "source": "systemd", "state": "stopped", "status": "static" }, "rpcbind.service": { "name": "rpcbind.service", "source": "systemd", "state": "running", "status": "enabled" }, "rpmdb-rebuild.service": { "name": "rpmdb-rebuild.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "rsyslog.service": { "name": "rsyslog.service", "source": "systemd", "state": "running", "status": "enabled" }, "saslauthd.service": { "name": "saslauthd.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "selinux-autorelabel-mark.service": { "name": "selinux-autorelabel-mark.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "selinux-autorelabel.service": { "name": "selinux-autorelabel.service", "source": "systemd", "state": "inactive", "status": "static" }, "serial-getty@.service": { "name": "serial-getty@.service", "source": "systemd", "state": "unknown", "status": "indirect" }, "serial-getty@ttyS0.service": { "name": "serial-getty@ttyS0.service", "source": "systemd", "state": "running", "status": "unknown" }, "sshd-keygen@.service": { "name": "sshd-keygen@.service", "source": "systemd", "state": "unknown", "status": "disabled" }, "sshd-keygen@ecdsa.service": { "name": "sshd-keygen@ecdsa.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "sshd-keygen@ed25519.service": { "name": "sshd-keygen@ed25519.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "sshd-keygen@rsa.service": { "name": "sshd-keygen@rsa.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "sshd.service": { "name": "sshd.service", "source": "systemd", "state": "running", "status": "enabled" }, "sshd@.service": { "name": "sshd@.service", "source": "systemd", "state": "unknown", "status": "static" }, "sssd-autofs.service": { "name": "sssd-autofs.service", "source": "systemd", "state": "inactive", "status": "indirect" }, "sssd-kcm.service": { "name": "sssd-kcm.service", "source": "systemd", "state": "stopped", "status": "indirect" }, "sssd-nss.service": { "name": "sssd-nss.service", "source": "systemd", "state": "inactive", "status": "indirect" }, "sssd-pac.service": { "name": "sssd-pac.service", "source": "systemd", "state": "inactive", "status": "indirect" }, "sssd-pam.service": { "name": "sssd-pam.service", "source": "systemd", "state": "inactive", "status": "indirect" }, "sssd-ssh.service": { "name": "sssd-ssh.service", "source": "systemd", "state": "inactive", "status": "indirect" }, "sssd-sudo.service": { "name": "sssd-sudo.service", "source": "systemd", "state": "inactive", "status": "indirect" }, "sssd.service": { "name": "sssd.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "system-update-cleanup.service": { "name": "system-update-cleanup.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-ask-password-console.service": { "name": "systemd-ask-password-console.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-ask-password-wall.service": { "name": "systemd-ask-password-wall.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-backlight@.service": { "name": "systemd-backlight@.service", "source": "systemd", "state": "unknown", "status": "static" }, "systemd-binfmt.service": { "name": "systemd-binfmt.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-boot-check-no-failures.service": { "name": "systemd-boot-check-no-failures.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "systemd-coredump@.service": { "name": "systemd-coredump@.service", "source": "systemd", "state": "unknown", "status": "static" }, "systemd-exit.service": { "name": "systemd-exit.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-firstboot.service": { "name": "systemd-firstboot.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-fsck-root.service": { "name": "systemd-fsck-root.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-fsck@.service": { "name": "systemd-fsck@.service", "source": "systemd", "state": "unknown", "status": "static" }, "systemd-fsck@dev-disk-by\\x2duuid-7B77\\x2d95E7.service": { "name": "systemd-fsck@dev-disk-by\\x2duuid-7B77\\x2d95E7.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "systemd-fsck@dev-vda2.service": { "name": "systemd-fsck@dev-vda2.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "systemd-halt.service": { "name": "systemd-halt.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-hibernate-resume@.service": { "name": "systemd-hibernate-resume@.service", "source": "systemd", "state": "unknown", "status": "static" }, "systemd-hibernate.service": { "name": "systemd-hibernate.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-hostnamed.service": { "name": "systemd-hostnamed.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-hwdb-update.service": { "name": "systemd-hwdb-update.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-hybrid-sleep.service": { "name": "systemd-hybrid-sleep.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-initctl.service": { "name": "systemd-initctl.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-journal-catalog-update.service": { "name": "systemd-journal-catalog-update.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-journal-flush.service": { "name": "systemd-journal-flush.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-journald.service": { "name": "systemd-journald.service", "source": "systemd", "state": "running", "status": "static" }, "systemd-journald@.service": { "name": "systemd-journald@.service", "source": "systemd", "state": "unknown", "status": "static" }, "systemd-kexec.service": { "name": "systemd-kexec.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-localed.service": { "name": "systemd-localed.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-logind.service": { "name": "systemd-logind.service", "source": "systemd", "state": "running", "status": "static" }, "systemd-machine-id-commit.service": { "name": "systemd-machine-id-commit.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-modules-load.service": { "name": "systemd-modules-load.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-network-generator.service": { "name": "systemd-network-generator.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "systemd-poweroff.service": { "name": "systemd-poweroff.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-pstore.service": { "name": "systemd-pstore.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "systemd-quotacheck.service": { "name": "systemd-quotacheck.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-random-seed.service": { "name": "systemd-random-seed.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-reboot.service": { "name": "systemd-reboot.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-remount-fs.service": { "name": "systemd-remount-fs.service", "source": "systemd", "state": "stopped", "status": "enabled-runtime" }, "systemd-repart.service": { "name": "systemd-repart.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-rfkill.service": { "name": "systemd-rfkill.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-suspend-then-hibernate.service": { "name": "systemd-suspend-then-hibernate.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-suspend.service": { "name": "systemd-suspend.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-sysctl.service": { "name": "systemd-sysctl.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-sysext.service": { "name": "systemd-sysext.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "systemd-sysusers.service": { "name": "systemd-sysusers.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-timedated.service": { "name": "systemd-timedated.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-tmpfiles-clean.service": { "name": "systemd-tmpfiles-clean.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-tmpfiles-setup-dev.service": { "name": "systemd-tmpfiles-setup-dev.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-tmpfiles-setup.service": { "name": "systemd-tmpfiles-setup.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-udev-settle.service": { "name": "systemd-udev-settle.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-udev-trigger.service": { "name": "systemd-udev-trigger.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-udevd.service": { "name": "systemd-udevd.service", "source": "systemd", "state": "running", "status": "static" }, "systemd-update-done.service": { "name": "systemd-update-done.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-update-utmp-runlevel.service": { "name": "systemd-update-utmp-runlevel.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-update-utmp.service": { "name": "systemd-update-utmp.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-user-sessions.service": { "name": "systemd-user-sessions.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-vconsole-setup.service": { "name": "systemd-vconsole-setup.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-volatile-root.service": { "name": "systemd-volatile-root.service", "source": "systemd", "state": "inactive", "status": "static" }, "teamd@.service": { "name": "teamd@.service", "source": "systemd", "state": "unknown", "status": "static" }, "tuned.service": { "name": "tuned.service", "source": "systemd", "state": "running", "status": "enabled" }, "user-runtime-dir@.service": { "name": "user-runtime-dir@.service", "source": "systemd", "state": "unknown", "status": "static" }, "user-runtime-dir@0.service": { "name": "user-runtime-dir@0.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "user@.service": { "name": "user@.service", "source": "systemd", "state": "unknown", "status": "static" }, "user@0.service": { "name": "user@0.service", "source": "systemd", "state": "running", "status": "unknown" } } }, "changed": false } TASK [linux-system-roles.mssql : Verify that the variables required for setting up MSSQL are defined] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:75 Tuesday 07 June 2022 03:37:25 +0000 (0:00:01.625) 0:00:06.697 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false } MSG: All assertions passed TASK [linux-system-roles.mssql : Set up MSSQL] ********************************* task path: /tmp/tmpajc2l7lu/tasks/main.yml:85 Tuesday 07 June 2022 03:37:25 +0000 (0:00:00.059) 0:00:06.757 ********** changed: [/cache/rhel-9.qcow2] => { "changed": true, "cmd": [ "/opt/mssql/bin/mssql-conf", "-n", "setup" ], "delta": "0:00:00.318676", "end": "2022-06-06 23:37:25.918253", "rc": 0, "start": "2022-06-06 23:37:25.599577" } STDOUT: The license terms for this product can be found in /usr/share/doc/mssql-server or downloaded from: https://go.microsoft.com/fwlink/?LinkId=2104294 The privacy statement can be viewed at: https://go.microsoft.com/fwlink/?LinkId=853010 Configuring SQL Server... Setup has completed successfully. SQL Server is now starting. STDERR: /opt/mssql/bin/sqlservr: error while loading shared libraries: libldap-2.4.so.2: cannot open shared object file: No such file or directory Created symlink /etc/systemd/system/multi-user.target.wants/mssql-server.service -> /usr/lib/systemd/system/mssql-server.service. TASK [linux-system-roles.mssql : Ensure that the tuned-profiles-mssql package is installed] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:94 Tuesday 07 June 2022 03:37:26 +0000 (0:00:00.695) 0:00:07.452 ********** changed: [/cache/rhel-9.qcow2] => { "changed": true, "rc": 0, "results": [ "Installed: tuned-profiles-mssql-2.18.0-1.el9.noarch" ] } TASK [linux-system-roles.mssql : Ensure that the tuned service is started and enabled] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:99 Tuesday 07 June 2022 03:37:27 +0000 (0:00:01.105) 0:00:08.557 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false, "enabled": true, "name": "tuned", "state": "started", "status": { "ActiveEnterTimestamp": "Mon 2022-06-06 23:36:20 EDT", "ActiveEnterTimestampMonotonic": "5094434", "ActiveExitTimestampMonotonic": "0", "ActiveState": "active", "After": "dbus-broker.service sysinit.target basic.target network.target systemd-sysctl.service system.slice systemd-journald.socket dbus.socket", "AllowIsolate": "no", "AssertResult": "yes", "AssertTimestamp": "Mon 2022-06-06 23:36:19 EDT", "AssertTimestampMonotonic": "4792291", "Before": "shutdown.target multi-user.target", "BlockIOAccounting": "no", "BlockIOWeight": "[not set]", "BusName": "com.redhat.tuned", "CPUAccounting": "yes", "CPUAffinityFromNUMA": "no", "CPUQuotaPerSecUSec": "infinity", "CPUQuotaPeriodUSec": "infinity", "CPUSchedulingPolicy": "0", "CPUSchedulingPriority": "0", "CPUSchedulingResetOnFork": "no", "CPUShares": "[not set]", "CPUUsageNSec": "265254000", "CPUWeight": "[not set]", "CacheDirectoryMode": "0755", "CanFreeze": "yes", "CanIsolate": "no", "CanReload": "no", "CanStart": "yes", "CanStop": "yes", "CapabilityBoundingSet": "cap_chown cap_dac_override cap_dac_read_search cap_fowner cap_fsetid cap_kill cap_setgid cap_setuid cap_setpcap cap_linux_immutable cap_net_bind_service cap_net_broadcast cap_net_admin cap_net_raw cap_ipc_lock cap_ipc_owner cap_sys_module cap_sys_rawio cap_sys_chroot cap_sys_ptrace cap_sys_pacct cap_sys_admin cap_sys_boot cap_sys_nice cap_sys_resource cap_sys_time cap_sys_tty_config cap_mknod cap_lease cap_audit_write cap_audit_control cap_setfcap cap_mac_override cap_mac_admin cap_syslog cap_wake_alarm cap_block_suspend cap_audit_read cap_perfmon cap_bpf cap_checkpoint_restore", "CleanResult": "success", "CollectMode": "inactive", "ConditionResult": "yes", "ConditionTimestamp": "Mon 2022-06-06 23:36:19 EDT", "ConditionTimestampMonotonic": "4792290", "ConfigurationDirectoryMode": "0755", "Conflicts": "shutdown.target cpupower.service", "ControlGroup": "/system.slice/tuned.service", "ControlPID": "0", "CoredumpFilter": "0x33", "DefaultDependencies": "yes", "DefaultMemoryLow": "0", "DefaultMemoryMin": "0", "Delegate": "no", "Description": "Dynamic System Tuning Daemon", "DevicePolicy": "auto", "Documentation": "\"man:tuned(8)\" \"man:tuned.conf(5)\" \"man:tuned-adm(8)\"", "DynamicUser": "no", "ExecMainCode": "0", "ExecMainExitTimestampMonotonic": "0", "ExecMainPID": "761", "ExecMainStartTimestamp": "Mon 2022-06-06 23:36:19 EDT", "ExecMainStartTimestampMonotonic": "4793223", "ExecMainStatus": "0", "ExecStart": "{ path=/usr/sbin/tuned ; argv[]=/usr/sbin/tuned -l -P ; ignore_errors=no ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }", "ExecStartEx": "{ path=/usr/sbin/tuned ; argv[]=/usr/sbin/tuned -l -P ; flags= ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }", "ExitType": "main", "FailureAction": "none", "FileDescriptorStoreMax": "0", "FinalKillSignal": "9", "FragmentPath": "/usr/lib/systemd/system/tuned.service", "FreezerState": "running", "GID": "[not set]", "GuessMainPID": "yes", "IOAccounting": "no", "IOReadBytes": "18446744073709551615", "IOReadOperations": "18446744073709551615", "IOSchedulingClass": "2", "IOSchedulingPriority": "4", "IOWeight": "[not set]", "IOWriteBytes": "18446744073709551615", "IOWriteOperations": "18446744073709551615", "IPAccounting": "no", "IPEgressBytes": "[no data]", "IPEgressPackets": "[no data]", "IPIngressBytes": "[no data]", "IPIngressPackets": "[no data]", "Id": "tuned.service", "IgnoreOnIsolate": "no", "IgnoreSIGPIPE": "yes", "InactiveEnterTimestampMonotonic": "0", "InactiveExitTimestamp": "Mon 2022-06-06 23:36:19 EDT", "InactiveExitTimestampMonotonic": "4793389", "InvocationID": "9bf42224ef6f463095183b8de6dd523a", "JobRunningTimeoutUSec": "infinity", "JobTimeoutAction": "none", "JobTimeoutUSec": "infinity", "KeyringMode": "private", "KillMode": "control-group", "KillSignal": "15", "LimitAS": "infinity", "LimitASSoft": "infinity", "LimitCORE": "infinity", "LimitCORESoft": "0", "LimitCPU": "infinity", "LimitCPUSoft": "infinity", "LimitDATA": "infinity", "LimitDATASoft": "infinity", "LimitFSIZE": "infinity", "LimitFSIZESoft": "infinity", "LimitLOCKS": "infinity", "LimitLOCKSSoft": "infinity", "LimitMEMLOCK": "65536", "LimitMEMLOCKSoft": "65536", "LimitMSGQUEUE": "819200", "LimitMSGQUEUESoft": "819200", "LimitNICE": "0", "LimitNICESoft": "0", "LimitNOFILE": "524288", "LimitNOFILESoft": "1024", "LimitNPROC": "14637", "LimitNPROCSoft": "14637", "LimitRSS": "infinity", "LimitRSSSoft": "infinity", "LimitRTPRIO": "0", "LimitRTPRIOSoft": "0", "LimitRTTIME": "infinity", "LimitRTTIMESoft": "infinity", "LimitSIGPENDING": "14637", "LimitSIGPENDINGSoft": "14637", "LimitSTACK": "infinity", "LimitSTACKSoft": "8388608", "LoadState": "loaded", "LockPersonality": "no", "LogLevelMax": "-1", "LogRateLimitBurst": "0", "LogRateLimitIntervalUSec": "0", "LogsDirectoryMode": "0755", "MainPID": "761", "ManagedOOMMemoryPressure": "auto", "ManagedOOMMemoryPressureLimit": "0", "ManagedOOMPreference": "none", "ManagedOOMSwap": "auto", "MemoryAccounting": "yes", "MemoryAvailable": "infinity", "MemoryCurrent": "16842752", "MemoryDenyWriteExecute": "no", "MemoryHigh": "infinity", "MemoryLimit": "infinity", "MemoryLow": "0", "MemoryMax": "infinity", "MemoryMin": "0", "MemorySwapMax": "infinity", "MountAPIVFS": "no", "NFileDescriptorStore": "0", "NRestarts": "0", "NUMAPolicy": "n/a", "Names": "tuned.service", "NeedDaemonReload": "no", "Nice": "0", "NoNewPrivileges": "no", "NonBlocking": "no", "NotifyAccess": "none", "OOMPolicy": "stop", "OOMScoreAdjust": "0", "OnFailureJobMode": "replace", "OnSuccessJobMode": "fail", "PIDFile": "/run/tuned/tuned.pid", "Perpetual": "no", "PrivateDevices": "no", "PrivateIPC": "no", "PrivateMounts": "no", "PrivateNetwork": "no", "PrivateTmp": "no", "PrivateUsers": "no", "ProcSubset": "all", "ProtectClock": "no", "ProtectControlGroups": "no", "ProtectHome": "no", "ProtectHostname": "no", "ProtectKernelLogs": "no", "ProtectKernelModules": "no", "ProtectKernelTunables": "no", "ProtectProc": "default", "ProtectSystem": "no", "RefuseManualStart": "no", "RefuseManualStop": "no", "ReloadResult": "success", "RemainAfterExit": "no", "RemoveIPC": "no", "Requires": "dbus-broker.service sysinit.target system.slice polkit.service dbus.socket", "Restart": "no", "RestartKillSignal": "15", "RestartUSec": "100ms", "RestrictNamespaces": "no", "RestrictRealtime": "no", "RestrictSUIDSGID": "no", "Result": "success", "RootDirectoryStartOnly": "no", "RuntimeDirectoryMode": "0755", "RuntimeDirectoryPreserve": "no", "RuntimeMaxUSec": "infinity", "RuntimeRandomizedExtraUSec": "0", "SameProcessGroup": "no", "SecureBits": "0", "SendSIGHUP": "no", "SendSIGKILL": "yes", "Slice": "system.slice", "StandardError": "inherit", "StandardInput": "null", "StandardOutput": "journal", "StartLimitAction": "none", "StartLimitBurst": "5", "StartLimitIntervalUSec": "10s", "StartupBlockIOWeight": "[not set]", "StartupCPUShares": "[not set]", "StartupCPUWeight": "[not set]", "StartupIOWeight": "[not set]", "StateChangeTimestamp": "Mon 2022-06-06 23:37:25 EDT", "StateChangeTimestampMonotonic": "70903824", "StateDirectoryMode": "0755", "StatusErrno": "0", "StopWhenUnneeded": "no", "SubState": "running", "SuccessAction": "none", "SyslogFacility": "3", "SyslogLevel": "6", "SyslogLevelPrefix": "yes", "SyslogPriority": "30", "SystemCallErrorNumber": "2147483646", "TTYReset": "no", "TTYVHangup": "no", "TTYVTDisallocate": "no", "TasksAccounting": "yes", "TasksCurrent": "4", "TasksMax": "23420", "TimeoutAbortUSec": "1min 30s", "TimeoutCleanUSec": "infinity", "TimeoutStartFailureMode": "terminate", "TimeoutStartUSec": "1min 30s", "TimeoutStopFailureMode": "terminate", "TimeoutStopUSec": "1min 30s", "TimerSlackNSec": "50000", "Transient": "no", "Type": "dbus", "UID": "[not set]", "UMask": "0022", "UnitFilePreset": "enabled", "UnitFileState": "enabled", "UtmpMode": "init", "WantedBy": "multi-user.target", "WatchdogSignal": "6", "WatchdogTimestampMonotonic": "0", "WatchdogUSec": "0" } } TASK [linux-system-roles.mssql : Get the active Tuned profiles] **************** task path: /tmp/tmpajc2l7lu/tasks/main.yml:105 Tuesday 07 June 2022 03:37:28 +0000 (0:00:00.788) 0:00:09.346 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false, "cmd": [ "tuned-adm", "active" ], "delta": "0:00:00.107085", "end": "2022-06-06 23:37:28.277777", "rc": 0, "start": "2022-06-06 23:37:28.170692" } STDOUT: Current active profile: virtual-guest TASK [linux-system-roles.mssql : Add mssql to the list of Tuned profiles] ****** task path: /tmp/tmpajc2l7lu/tasks/main.yml:115 Tuesday 07 June 2022 03:37:28 +0000 (0:00:00.463) 0:00:09.810 ********** changed: [/cache/rhel-9.qcow2] => { "changed": true, "cmd": [ "tuned-adm", "profile", "virtual-guest", "mssql" ], "delta": "0:00:01.109684", "end": "2022-06-06 23:37:29.755854", "rc": 0, "start": "2022-06-06 23:37:28.646170" } TASK [linux-system-roles.mssql : Configure the Microsoft SQL Server Tools repository] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:145 Tuesday 07 June 2022 03:37:30 +0000 (0:00:01.479) 0:00:11.289 ********** changed: [/cache/rhel-9.qcow2] => { "changed": true, "repo": "packages-microsoft-com-prod", "state": "present" } TASK [linux-system-roles.mssql : Ensure that SQL Server client tools are installed] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:152 Tuesday 07 June 2022 03:37:30 +0000 (0:00:00.374) 0:00:11.664 ********** changed: [/cache/rhel-9.qcow2] => { "changed": true, "rc": 0, "results": [ "Installed: mssql-tools-17.9.1.1-1.x86_64", "Installed: libpkgconf-1.7.3-9.el9.x86_64", "Installed: msodbcsql17-17.9.1.1-1.x86_64", "Installed: pkgconf-1.7.3-9.el9.x86_64", "Installed: pkgconf-m4-1.7.3-9.el9.noarch", "Installed: pkgconf-pkg-config-1.7.3-9.el9.x86_64", "Installed: unixODBC-2.3.7-1.rh.x86_64", "Installed: unixODBC-devel-2.3.7-1.rh.x86_64" ] } TASK [linux-system-roles.mssql : Prepare MSSQL and facts for logging in] ******* task path: /tmp/tmpajc2l7lu/tasks/main.yml:164 Tuesday 07 June 2022 03:37:34 +0000 (0:00:03.613) 0:00:15.278 ********** skipping: [/cache/rhel-9.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Check if the set password matches the existing password] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:169 Tuesday 07 June 2022 03:37:34 +0000 (0:00:00.048) 0:00:15.326 ********** skipping: [/cache/rhel-9.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Ensure that the mssql-server service is stopped] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:175 Tuesday 07 June 2022 03:37:34 +0000 (0:00:00.045) 0:00:15.371 ********** skipping: [/cache/rhel-9.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Change the password of the sa user] *********** task path: /tmp/tmpajc2l7lu/tasks/main.yml:182 Tuesday 07 June 2022 03:37:34 +0000 (0:00:00.044) 0:00:15.416 ********** skipping: [/cache/rhel-9.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Check if the set edition matches the existing edition] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:194 Tuesday 07 June 2022 03:37:34 +0000 (0:00:00.047) 0:00:15.464 ********** skipping: [/cache/rhel-9.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Ensure that the mssql-server service is stopped] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:207 Tuesday 07 June 2022 03:37:34 +0000 (0:00:00.044) 0:00:15.509 ********** skipping: [/cache/rhel-9.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Change the edition of MSSQL] ****************** task path: /tmp/tmpajc2l7lu/tasks/main.yml:214 Tuesday 07 June 2022 03:37:34 +0000 (0:00:00.043) 0:00:15.552 ********** skipping: [/cache/rhel-9.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Check if the IP address setting is defined] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:226 Tuesday 07 June 2022 03:37:34 +0000 (0:00:00.043) 0:00:15.596 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false, "cmd": [ "/opt/mssql/bin/mssql-conf", "get", "network", "ipaddress" ], "delta": "0:00:00.093839", "end": "2022-06-06 23:37:34.550070", "rc": 0, "start": "2022-06-06 23:37:34.456231" } STDOUT: No setting for the given option found in '/var/opt/mssql/mssql.conf'. TASK [linux-system-roles.mssql : Change the IP address setting] **************** task path: /tmp/tmpajc2l7lu/tasks/main.yml:232 Tuesday 07 June 2022 03:37:34 +0000 (0:00:00.487) 0:00:16.084 ********** NOTIFIED HANDLER linux-system-roles.mssql : Restart the mssql-server service for /cache/rhel-9.qcow2 changed: [/cache/rhel-9.qcow2] => { "changed": true, "cmd": [ "/opt/mssql/bin/mssql-conf", "set", "network.ipaddress", "0.0.0.0" ], "delta": "0:00:00.090941", "end": "2022-06-06 23:37:35.023837", "rc": 0, "start": "2022-06-06 23:37:34.932896" } STDOUT: SQL Server needs to be restarted in order to apply this setting. Please run 'systemctl restart mssql-server.service'. TASK [linux-system-roles.mssql : Set the new TCP port for MSSQL] *************** task path: /tmp/tmpajc2l7lu/tasks/main.yml:241 Tuesday 07 June 2022 03:37:35 +0000 (0:00:00.470) 0:00:16.555 ********** changed: [/cache/rhel-9.qcow2] => { "changed": true, "cmd": [ "/opt/mssql/bin/mssql-conf", "set", "network.tcpport", "1443" ], "delta": "0:00:00.091711", "end": "2022-06-06 23:37:35.487181", "rc": 0, "start": "2022-06-06 23:37:35.395470" } STDOUT: SQL Server needs to be restarted in order to apply this setting. Please run 'systemctl restart mssql-server.service'. TASK [linux-system-roles.mssql : Verify that the mssql_password variable is defined] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:251 Tuesday 07 June 2022 03:37:35 +0000 (0:00:00.467) 0:00:17.022 ********** skipping: [/cache/rhel-9.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Create a tempfile on the host] **************** task path: /tmp/tmpajc2l7lu/tasks/main.yml:263 Tuesday 07 June 2022 03:37:35 +0000 (0:00:00.047) 0:00:17.069 ********** skipping: [/cache/rhel-9.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Copy the file to the host] ******************* task path: /tmp/tmpajc2l7lu/tasks/main.yml:268 Tuesday 07 June 2022 03:37:36 +0000 (0:00:00.065) 0:00:17.135 ********** skipping: [/cache/rhel-9.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Ensure that the mssql-server service is started] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:274 Tuesday 07 June 2022 03:37:36 +0000 (0:00:00.026) 0:00:17.162 ********** skipping: [/cache/rhel-9.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Prepare MSSQL and facts for logging in] ******* task path: /tmp/tmpajc2l7lu/tasks/main.yml:279 Tuesday 07 June 2022 03:37:36 +0000 (0:00:00.027) 0:00:17.190 ********** skipping: [/cache/rhel-9.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Input the file with the sqlcmd command] ****** task path: /tmp/tmpajc2l7lu/tasks/main.yml:284 Tuesday 07 June 2022 03:37:36 +0000 (0:00:00.029) 0:00:17.219 ********** skipping: [/cache/rhel-9.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Print the output of the sqlcmd command] ******* task path: /tmp/tmpajc2l7lu/tasks/main.yml:291 Tuesday 07 June 2022 03:37:36 +0000 (0:00:00.025) 0:00:17.244 ********** skipping: [/cache/rhel-9.qcow2] => {} TASK [linux-system-roles.mssql : Remove the {{ __mssql_sql_tempfile.path }} file] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:295 Tuesday 07 June 2022 03:37:36 +0000 (0:00:00.033) 0:00:17.277 ********** skipping: [/cache/rhel-9.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } RUNNING HANDLER [linux-system-roles.mssql : Restart the mssql-server service] *** task path: /tmp/tmpajc2l7lu/handlers/main.yml:3 Tuesday 07 June 2022 03:37:36 +0000 (0:00:00.016) 0:00:17.294 ********** fatal: [/cache/rhel-9.qcow2]: FAILED! => { "changed": false } MSG: Unable to start service mssql-server: Job for mssql-server.service failed because the control process exited with error code. See "systemctl status mssql-server.service" and "journalctl -xeu mssql-server.service" for details. META: ran handlers NO MORE HOSTS LEFT ************************************************************* PLAY RECAP ********************************************************************* /cache/rhel-9.qcow2 : ok=20 changed=7 unreachable=0 failed=1 skipped=15 rescued=0 ignored=0 Tuesday 07 June 2022 03:37:36 +0000 (0:00:00.486) 0:00:17.780 ********** =============================================================================== linux-system-roles.mssql : Ensure that SQL Server client tools are installed --- 3.61s /tmp/tmpajc2l7lu/tasks/main.yml:152 ------------------------------------------- linux-system-roles.mssql : Gather system services facts ----------------- 1.63s /tmp/tmpajc2l7lu/tasks/main.yml:62 -------------------------------------------- linux-system-roles.mssql : Add mssql to the list of Tuned profiles ------ 1.48s /tmp/tmpajc2l7lu/tasks/main.yml:115 ------------------------------------------- set up internal repositories -------------------------------------------- 1.24s /cache/rhel-9_setup.yml:5 ----------------------------------------------------- linux-system-roles.mssql : Ensure that the tuned-profiles-mssql package is installed --- 1.11s /tmp/tmpajc2l7lu/tasks/main.yml:94 -------------------------------------------- linux-system-roles.mssql : Ensure that the Microsoft SQL Server package is installed --- 1.04s /tmp/tmpajc2l7lu/tasks/main.yml:42 -------------------------------------------- Gathering Facts --------------------------------------------------------- 0.92s /tmp/tmpajc2l7lu/tests/tests_idempotency.yml:3 -------------------------------- linux-system-roles.mssql : Ensure that the tuned service is started and enabled --- 0.79s /tmp/tmpajc2l7lu/tasks/main.yml:99 -------------------------------------------- linux-system-roles.mssql : Set up MSSQL --------------------------------- 0.70s /tmp/tmpajc2l7lu/tasks/main.yml:85 -------------------------------------------- linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories --- 0.67s /tmp/tmpajc2l7lu/tasks/main.yml:30 -------------------------------------------- linux-system-roles.mssql : Check if the errorlog file exists and its location --- 0.59s /tmp/tmpajc2l7lu/tasks/main.yml:47 -------------------------------------------- linux-system-roles.mssql : Check if the IP address setting is defined --- 0.49s /tmp/tmpajc2l7lu/tasks/main.yml:226 ------------------------------------------- linux-system-roles.mssql : Restart the mssql-server service ------------- 0.49s /tmp/tmpajc2l7lu/handlers/main.yml:3 ------------------------------------------ linux-system-roles.mssql : Change the IP address setting ---------------- 0.47s /tmp/tmpajc2l7lu/tasks/main.yml:232 ------------------------------------------- linux-system-roles.mssql : Set the new TCP port for MSSQL --------------- 0.47s /tmp/tmpajc2l7lu/tasks/main.yml:241 ------------------------------------------- linux-system-roles.mssql : Get the active Tuned profiles ---------------- 0.46s /tmp/tmpajc2l7lu/tasks/main.yml:105 ------------------------------------------- linux-system-roles.mssql : Configure the Microsoft SQL Server 2019 repository --- 0.39s /tmp/tmpajc2l7lu/tasks/main.yml:35 -------------------------------------------- linux-system-roles.mssql : Configure the Microsoft SQL Server Tools repository --- 0.37s /tmp/tmpajc2l7lu/tasks/main.yml:145 ------------------------------------------- linux-system-roles.mssql : Set platform/version specific variables ------ 0.07s /tmp/tmpajc2l7lu/tasks/main.yml:3 --------------------------------------------- linux-system-roles.mssql : Create a tempfile on the host ---------------- 0.07s /tmp/tmpajc2l7lu/tasks/main.yml:263 ------------------------------------------- ansible-playbook 2.9.27 config file = /etc/ansible/ansible.cfg configured module search path = [u'/root/.ansible/plugins/modules', u'/usr/share/ansible/plugins/modules'] ansible python module location = /usr/lib/python2.7/site-packages/ansible executable location = /usr/bin/ansible-playbook python version = 2.7.5 (default, May 27 2022, 11:27:32) [GCC 4.8.5 20150623 (Red Hat 4.8.5-44)] 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: rhel-9_setup.yml ***************************************************** 1 plays in /cache/rhel-9_setup.yml PLAY [Setup repos] ************************************************************* META: ran handlers TASK [set up internal repositories] ******************************************** task path: /cache/rhel-9_setup.yml:5 Tuesday 07 June 2022 03:37:37 +0000 (0:00:00.027) 0:00:00.027 ********** ok: [/cache/rhel-9.qcow2] => (item=None) => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false } ok: [/cache/rhel-9.qcow2] => (item=None) => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false } ok: [/cache/rhel-9.qcow2] => (item=None) => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false } ok: [/cache/rhel-9.qcow2] => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false } META: ran handlers META: ran handlers PLAY RECAP ********************************************************************* /cache/rhel-9.qcow2 : ok=1 changed=0 unreachable=0 failed=0 skipped=0 rescued=0 ignored=0 Tuesday 07 June 2022 03:37:38 +0000 (0:00:01.236) 0:00:01.264 ********** =============================================================================== set up internal repositories -------------------------------------------- 1.24s /cache/rhel-9_setup.yml:5 ----------------------------------------------------- PLAYBOOK: tests_include_vars_from_parent.yml *********************************** 1 plays in /tmp/tmpajc2l7lu/tests/tests_include_vars_from_parent.yml PLAY [all] ********************************************************************* TASK [Gathering Facts] ********************************************************* task path: /tmp/tmpajc2l7lu/tests/tests_include_vars_from_parent.yml:1 Tuesday 07 June 2022 03:37:38 +0000 (0:00:00.011) 0:00:01.276 ********** ok: [/cache/rhel-9.qcow2] META: ran handlers TASK [create var file in caller that can override the one in called role] ****** task path: /tmp/tmpajc2l7lu/tests/tests_include_vars_from_parent.yml:3 Tuesday 07 June 2022 03:37:39 +0000 (0:00:00.985) 0:00:02.261 ********** changed: [/cache/rhel-9.qcow2 -> localhost] => (item=RedHat-9.0) => { "ansible_loop_var": "item", "changed": true, "checksum": "870b2314d3f4184a363b31373f07abb444f26444", "dest": "/tmp/tmpajc2l7lu/tests/roles/caller/vars/RedHat-9.0.yml", "gid": 0, "group": "root", "item": "RedHat-9.0", "md5sum": "5a57da448a1d752b982858b38aab344d", "mode": "0600", "owner": "root", "size": 23, "src": "/root/.ansible/tmp/ansible-tmp-1654573059.69-142696-137485480164292/source", "state": "file", "uid": 0 } changed: [/cache/rhel-9.qcow2 -> localhost] => (item=RedHat-9) => { "ansible_loop_var": "item", "changed": true, "checksum": "870b2314d3f4184a363b31373f07abb444f26444", "dest": "/tmp/tmpajc2l7lu/tests/roles/caller/vars/RedHat-9.yml", "gid": 0, "group": "root", "item": "RedHat-9", "md5sum": "5a57da448a1d752b982858b38aab344d", "mode": "0600", "owner": "root", "size": 23, "src": "/root/.ansible/tmp/ansible-tmp-1654573060.18-142696-152617022416896/source", "state": "file", "uid": 0 } changed: [/cache/rhel-9.qcow2 -> localhost] => (item=RedHat_9.0) => { "ansible_loop_var": "item", "changed": true, "checksum": "870b2314d3f4184a363b31373f07abb444f26444", "dest": "/tmp/tmpajc2l7lu/tests/roles/caller/vars/RedHat_9.0.yml", "gid": 0, "group": "root", "item": "RedHat_9.0", "md5sum": "5a57da448a1d752b982858b38aab344d", "mode": "0600", "owner": "root", "size": 23, "src": "/root/.ansible/tmp/ansible-tmp-1654573060.42-142696-214351358371346/source", "state": "file", "uid": 0 } changed: [/cache/rhel-9.qcow2 -> localhost] => (item=RedHat_9) => { "ansible_loop_var": "item", "changed": true, "checksum": "870b2314d3f4184a363b31373f07abb444f26444", "dest": "/tmp/tmpajc2l7lu/tests/roles/caller/vars/RedHat_9.yml", "gid": 0, "group": "root", "item": "RedHat_9", "md5sum": "5a57da448a1d752b982858b38aab344d", "mode": "0600", "owner": "root", "size": 23, "src": "/root/.ansible/tmp/ansible-tmp-1654573060.67-142696-111854164567004/source", "state": "file", "uid": 0 } changed: [/cache/rhel-9.qcow2 -> localhost] => (item=RedHat) => { "ansible_loop_var": "item", "changed": true, "checksum": "870b2314d3f4184a363b31373f07abb444f26444", "dest": "/tmp/tmpajc2l7lu/tests/roles/caller/vars/RedHat.yml", "gid": 0, "group": "root", "item": "RedHat", "md5sum": "5a57da448a1d752b982858b38aab344d", "mode": "0600", "owner": "root", "size": 23, "src": "/root/.ansible/tmp/ansible-tmp-1654573060.92-142696-232862569933792/source", "state": "file", "uid": 0 } TASK [include_role : {{ roletoinclude }}] ************************************** task path: /tmp/tmpajc2l7lu/tests/roles/caller/tasks/main.yml:4 Tuesday 07 June 2022 03:37:41 +0000 (0:00:01.513) 0:00:03.775 ********** TASK [linux-system-roles.mssql : Set platform/version specific variables] ****** task path: /tmp/tmpajc2l7lu/tasks/main.yml:3 Tuesday 07 June 2022 03:37:41 +0000 (0:00:00.068) 0:00:03.843 ********** ok: [/cache/rhel-9.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-2019/" }, "ansible_included_var_files": [ "/tmp/tmpajc2l7lu/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } ok: [/cache/rhel-9.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-2019/" }, "ansible_included_var_files": [ "/tmp/tmpajc2l7lu/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } skipping: [/cache/rhel-9.qcow2] => (item=RedHat_9.yml) => { "ansible_loop_var": "item", "changed": false, "item": "RedHat_9.yml", "skip_reason": "Conditional result was False" } skipping: [/cache/rhel-9.qcow2] => (item=RedHat_9.0.yml) => { "ansible_loop_var": "item", "changed": false, "item": "RedHat_9.0.yml", "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Verify that the user accepts EULA variables] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:18 Tuesday 07 June 2022 03:37:41 +0000 (0:00:00.061) 0:00:03.905 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false } MSG: All assertions passed TASK [linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:30 Tuesday 07 June 2022 03:37:41 +0000 (0:00:00.033) 0:00:03.939 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false } TASK [linux-system-roles.mssql : Configure the Microsoft SQL Server 2019 repository] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:35 Tuesday 07 June 2022 03:37:42 +0000 (0:00:00.709) 0:00:04.648 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false, "repo": "packages-microsoft-com-mssql-server-2019-gdr", "state": "present" } TASK [linux-system-roles.mssql : Ensure that the Microsoft SQL Server package is installed] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:42 Tuesday 07 June 2022 03:37:42 +0000 (0:00:00.375) 0:00:05.024 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false, "rc": 0, "results": [] } MSG: Nothing to do TASK [linux-system-roles.mssql : Check if the errorlog file exists and its location] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:47 Tuesday 07 June 2022 03:37:43 +0000 (0:00:01.004) 0:00:06.029 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false, "cmd": "set -euo pipefail\nerrorlog=\"$(/opt/mssql/bin/mssql-conf get filelocation errorlogfile 2>&1 \\\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.093361", "end": "2022-06-06 23:37:43.581018", "rc": 0, "start": "2022-06-06 23:37:43.487657" } TASK [linux-system-roles.mssql : Gather system services facts] ***************** task path: /tmp/tmpajc2l7lu/tasks/main.yml:62 Tuesday 07 June 2022 03:37:44 +0000 (0:00:00.585) 0:00:06.615 ********** ok: [/cache/rhel-9.qcow2] => { "ansible_facts": { "services": { "NetworkManager-dispatcher.service": { "name": "NetworkManager-dispatcher.service", "source": "systemd", "state": "inactive", "status": "enabled" }, "NetworkManager-wait-online.service": { "name": "NetworkManager-wait-online.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "NetworkManager.service": { "name": "NetworkManager.service", "source": "systemd", "state": "running", "status": "enabled" }, "auditd.service": { "name": "auditd.service", "source": "systemd", "state": "running", "status": "enabled" }, "auth-rpcgss-module.service": { "name": "auth-rpcgss-module.service", "source": "systemd", "state": "stopped", "status": "static" }, "autovt@.service": { "name": "autovt@.service", "source": "systemd", "state": "unknown", "status": "alias" }, "chrony-wait.service": { "name": "chrony-wait.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "chronyd.service": { "name": "chronyd.service", "source": "systemd", "state": "running", "status": "enabled" }, "cloud-config.service": { "name": "cloud-config.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "cloud-final.service": { "name": "cloud-final.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "cloud-init-local.service": { "name": "cloud-init-local.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "cloud-init.service": { "name": "cloud-init.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "cockpit-motd.service": { "name": "cockpit-motd.service", "source": "systemd", "state": "inactive", "status": "static" }, "cockpit-wsinstance-http.service": { "name": "cockpit-wsinstance-http.service", "source": "systemd", "state": "inactive", "status": "static" }, "cockpit-wsinstance-https-factory@.service": { "name": "cockpit-wsinstance-https-factory@.service", "source": "systemd", "state": "unknown", "status": "static" }, "cockpit-wsinstance-https@.service": { "name": "cockpit-wsinstance-https@.service", "source": "systemd", "state": "unknown", "status": "static" }, "cockpit.service": { "name": "cockpit.service", "source": "systemd", "state": "inactive", "status": "static" }, "console-getty.service": { "name": "console-getty.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "container-getty@.service": { "name": "container-getty@.service", "source": "systemd", "state": "unknown", "status": "static" }, "cpupower.service": { "name": "cpupower.service", "source": "systemd", "state": "stopped", "status": "disabled" }, "crond.service": { "name": "crond.service", "source": "systemd", "state": "running", "status": "enabled" }, "dbus-broker.service": { "name": "dbus-broker.service", "source": "systemd", "state": "running", "status": "enabled" }, "dbus-org.freedesktop.hostname1.service": { "name": "dbus-org.freedesktop.hostname1.service", "source": "systemd", "state": "inactive", "status": "alias" }, "dbus-org.freedesktop.locale1.service": { "name": "dbus-org.freedesktop.locale1.service", "source": "systemd", "state": "inactive", "status": "alias" }, "dbus-org.freedesktop.login1.service": { "name": "dbus-org.freedesktop.login1.service", "source": "systemd", "state": "active", "status": "alias" }, "dbus-org.freedesktop.nm-dispatcher.service": { "name": "dbus-org.freedesktop.nm-dispatcher.service", "source": "systemd", "state": "inactive", "status": "alias" }, "dbus-org.freedesktop.timedate1.service": { "name": "dbus-org.freedesktop.timedate1.service", "source": "systemd", "state": "inactive", "status": "alias" }, "dbus.service": { "name": "dbus.service", "source": "systemd", "state": "active", "status": "alias" }, "debug-shell.service": { "name": "debug-shell.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "dnf-makecache.service": { "name": "dnf-makecache.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-cmdline.service": { "name": "dracut-cmdline.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-initqueue.service": { "name": "dracut-initqueue.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-mount.service": { "name": "dracut-mount.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-pre-mount.service": { "name": "dracut-pre-mount.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-pre-pivot.service": { "name": "dracut-pre-pivot.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-pre-trigger.service": { "name": "dracut-pre-trigger.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-pre-udev.service": { "name": "dracut-pre-udev.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-shutdown-onfailure.service": { "name": "dracut-shutdown-onfailure.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-shutdown.service": { "name": "dracut-shutdown.service", "source": "systemd", "state": "stopped", "status": "static" }, "emergency.service": { "name": "emergency.service", "source": "systemd", "state": "stopped", "status": "static" }, "fstrim.service": { "name": "fstrim.service", "source": "systemd", "state": "inactive", "status": "static" }, "fwupd-offline-update.service": { "name": "fwupd-offline-update.service", "source": "systemd", "state": "inactive", "status": "static" }, "fwupd-refresh.service": { "name": "fwupd-refresh.service", "source": "systemd", "state": "inactive", "status": "static" }, "fwupd.service": { "name": "fwupd.service", "source": "systemd", "state": "inactive", "status": "static" }, "getty@.service": { "name": "getty@.service", "source": "systemd", "state": "unknown", "status": "enabled" }, "getty@tty1.service": { "name": "getty@tty1.service", "source": "systemd", "state": "running", "status": "unknown" }, "grub-boot-indeterminate.service": { "name": "grub-boot-indeterminate.service", "source": "systemd", "state": "inactive", "status": "static" }, "grub2-systemd-integration.service": { "name": "grub2-systemd-integration.service", "source": "systemd", "state": "inactive", "status": "static" }, "gssproxy.service": { "name": "gssproxy.service", "source": "systemd", "state": "running", "status": "disabled" }, "initrd-cleanup.service": { "name": "initrd-cleanup.service", "source": "systemd", "state": "stopped", "status": "static" }, "initrd-parse-etc.service": { "name": "initrd-parse-etc.service", "source": "systemd", "state": "stopped", "status": "static" }, "initrd-switch-root.service": { "name": "initrd-switch-root.service", "source": "systemd", "state": "stopped", "status": "static" }, "initrd-udevadm-cleanup-db.service": { "name": "initrd-udevadm-cleanup-db.service", "source": "systemd", "state": "stopped", "status": "static" }, "insights-client-boot.service": { "name": "insights-client-boot.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "insights-client-results.service": { "name": "insights-client-results.service", "source": "systemd", "state": "inactive", "status": "static" }, "insights-client.service": { "name": "insights-client.service", "source": "systemd", "state": "inactive", "status": "static" }, "irqbalance.service": { "name": "irqbalance.service", "source": "systemd", "state": "running", "status": "enabled" }, "kdump.service": { "name": "kdump.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "kmod-static-nodes.service": { "name": "kmod-static-nodes.service", "source": "systemd", "state": "stopped", "status": "static" }, "kvm_stat.service": { "name": "kvm_stat.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "ldconfig.service": { "name": "ldconfig.service", "source": "systemd", "state": "stopped", "status": "static" }, "logrotate.service": { "name": "logrotate.service", "source": "systemd", "state": "stopped", "status": "static" }, "man-db-cache-update.service": { "name": "man-db-cache-update.service", "source": "systemd", "state": "inactive", "status": "static" }, "man-db-restart-cache-update.service": { "name": "man-db-restart-cache-update.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "microcode.service": { "name": "microcode.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "modprobe@.service": { "name": "modprobe@.service", "source": "systemd", "state": "unknown", "status": "static" }, "modprobe@configfs.service": { "name": "modprobe@configfs.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "modprobe@drm.service": { "name": "modprobe@drm.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "modprobe@fuse.service": { "name": "modprobe@fuse.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "mssql-server.service": { "name": "mssql-server.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "nfs-blkmap.service": { "name": "nfs-blkmap.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "nfs-idmapd.service": { "name": "nfs-idmapd.service", "source": "systemd", "state": "stopped", "status": "static" }, "nfs-mountd.service": { "name": "nfs-mountd.service", "source": "systemd", "state": "stopped", "status": "static" }, "nfs-server.service": { "name": "nfs-server.service", "source": "systemd", "state": "stopped", "status": "disabled" }, "nfs-utils.service": { "name": "nfs-utils.service", "source": "systemd", "state": "stopped", "status": "static" }, "nfsdcld.service": { "name": "nfsdcld.service", "source": "systemd", "state": "stopped", "status": "static" }, "nis-domainname.service": { "name": "nis-domainname.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "nm-priv-helper.service": { "name": "nm-priv-helper.service", "source": "systemd", "state": "inactive", "status": "static" }, "oddjobd.service": { "name": "oddjobd.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "packagekit-offline-update.service": { "name": "packagekit-offline-update.service", "source": "systemd", "state": "inactive", "status": "static" }, "packagekit.service": { "name": "packagekit.service", "source": "systemd", "state": "inactive", "status": "static" }, "pam_namespace.service": { "name": "pam_namespace.service", "source": "systemd", "state": "inactive", "status": "static" }, "polkit.service": { "name": "polkit.service", "source": "systemd", "state": "running", "status": "static" }, "qemu-guest-agent.service": { "name": "qemu-guest-agent.service", "source": "systemd", "state": "inactive", "status": "enabled" }, "quotaon.service": { "name": "quotaon.service", "source": "systemd", "state": "inactive", "status": "static" }, "rc-local.service": { "name": "rc-local.service", "source": "systemd", "state": "stopped", "status": "static" }, "rdisc.service": { "name": "rdisc.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "rescue.service": { "name": "rescue.service", "source": "systemd", "state": "stopped", "status": "static" }, "rhsm-facts.service": { "name": "rhsm-facts.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "rhsm.service": { "name": "rhsm.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "rhsmcertd.service": { "name": "rhsmcertd.service", "source": "systemd", "state": "running", "status": "enabled" }, "rpc-gssd.service": { "name": "rpc-gssd.service", "source": "systemd", "state": "stopped", "status": "static" }, "rpc-statd-notify.service": { "name": "rpc-statd-notify.service", "source": "systemd", "state": "stopped", "status": "static" }, "rpc-statd.service": { "name": "rpc-statd.service", "source": "systemd", "state": "stopped", "status": "static" }, "rpcbind.service": { "name": "rpcbind.service", "source": "systemd", "state": "running", "status": "enabled" }, "rpmdb-rebuild.service": { "name": "rpmdb-rebuild.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "rsyslog.service": { "name": "rsyslog.service", "source": "systemd", "state": "running", "status": "enabled" }, "saslauthd.service": { "name": "saslauthd.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "selinux-autorelabel-mark.service": { "name": "selinux-autorelabel-mark.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "selinux-autorelabel.service": { "name": "selinux-autorelabel.service", "source": "systemd", "state": "inactive", "status": "static" }, "serial-getty@.service": { "name": "serial-getty@.service", "source": "systemd", "state": "unknown", "status": "indirect" }, "serial-getty@ttyS0.service": { "name": "serial-getty@ttyS0.service", "source": "systemd", "state": "running", "status": "unknown" }, "sshd-keygen@.service": { "name": "sshd-keygen@.service", "source": "systemd", "state": "unknown", "status": "disabled" }, "sshd-keygen@ecdsa.service": { "name": "sshd-keygen@ecdsa.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "sshd-keygen@ed25519.service": { "name": "sshd-keygen@ed25519.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "sshd-keygen@rsa.service": { "name": "sshd-keygen@rsa.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "sshd.service": { "name": "sshd.service", "source": "systemd", "state": "running", "status": "enabled" }, "sshd@.service": { "name": "sshd@.service", "source": "systemd", "state": "unknown", "status": "static" }, "sssd-autofs.service": { "name": "sssd-autofs.service", "source": "systemd", "state": "inactive", "status": "indirect" }, "sssd-kcm.service": { "name": "sssd-kcm.service", "source": "systemd", "state": "stopped", "status": "indirect" }, "sssd-nss.service": { "name": "sssd-nss.service", "source": "systemd", "state": "inactive", "status": "indirect" }, "sssd-pac.service": { "name": "sssd-pac.service", "source": "systemd", "state": "inactive", "status": "indirect" }, "sssd-pam.service": { "name": "sssd-pam.service", "source": "systemd", "state": "inactive", "status": "indirect" }, "sssd-ssh.service": { "name": "sssd-ssh.service", "source": "systemd", "state": "inactive", "status": "indirect" }, "sssd-sudo.service": { "name": "sssd-sudo.service", "source": "systemd", "state": "inactive", "status": "indirect" }, "sssd.service": { "name": "sssd.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "system-update-cleanup.service": { "name": "system-update-cleanup.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-ask-password-console.service": { "name": "systemd-ask-password-console.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-ask-password-wall.service": { "name": "systemd-ask-password-wall.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-backlight@.service": { "name": "systemd-backlight@.service", "source": "systemd", "state": "unknown", "status": "static" }, "systemd-binfmt.service": { "name": "systemd-binfmt.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-boot-check-no-failures.service": { "name": "systemd-boot-check-no-failures.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "systemd-coredump@.service": { "name": "systemd-coredump@.service", "source": "systemd", "state": "unknown", "status": "static" }, "systemd-exit.service": { "name": "systemd-exit.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-firstboot.service": { "name": "systemd-firstboot.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-fsck-root.service": { "name": "systemd-fsck-root.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-fsck@.service": { "name": "systemd-fsck@.service", "source": "systemd", "state": "unknown", "status": "static" }, "systemd-fsck@dev-disk-by\\x2duuid-7B77\\x2d95E7.service": { "name": "systemd-fsck@dev-disk-by\\x2duuid-7B77\\x2d95E7.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "systemd-fsck@dev-vda2.service": { "name": "systemd-fsck@dev-vda2.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "systemd-halt.service": { "name": "systemd-halt.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-hibernate-resume@.service": { "name": "systemd-hibernate-resume@.service", "source": "systemd", "state": "unknown", "status": "static" }, "systemd-hibernate.service": { "name": "systemd-hibernate.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-hostnamed.service": { "name": "systemd-hostnamed.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-hwdb-update.service": { "name": "systemd-hwdb-update.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-hybrid-sleep.service": { "name": "systemd-hybrid-sleep.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-initctl.service": { "name": "systemd-initctl.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-journal-catalog-update.service": { "name": "systemd-journal-catalog-update.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-journal-flush.service": { "name": "systemd-journal-flush.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-journald.service": { "name": "systemd-journald.service", "source": "systemd", "state": "running", "status": "static" }, "systemd-journald@.service": { "name": "systemd-journald@.service", "source": "systemd", "state": "unknown", "status": "static" }, "systemd-kexec.service": { "name": "systemd-kexec.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-localed.service": { "name": "systemd-localed.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-logind.service": { "name": "systemd-logind.service", "source": "systemd", "state": "running", "status": "static" }, "systemd-machine-id-commit.service": { "name": "systemd-machine-id-commit.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-modules-load.service": { "name": "systemd-modules-load.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-network-generator.service": { "name": "systemd-network-generator.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "systemd-poweroff.service": { "name": "systemd-poweroff.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-pstore.service": { "name": "systemd-pstore.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "systemd-quotacheck.service": { "name": "systemd-quotacheck.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-random-seed.service": { "name": "systemd-random-seed.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-reboot.service": { "name": "systemd-reboot.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-remount-fs.service": { "name": "systemd-remount-fs.service", "source": "systemd", "state": "stopped", "status": "enabled-runtime" }, "systemd-repart.service": { "name": "systemd-repart.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-rfkill.service": { "name": "systemd-rfkill.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-suspend-then-hibernate.service": { "name": "systemd-suspend-then-hibernate.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-suspend.service": { "name": "systemd-suspend.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-sysctl.service": { "name": "systemd-sysctl.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-sysext.service": { "name": "systemd-sysext.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "systemd-sysusers.service": { "name": "systemd-sysusers.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-timedated.service": { "name": "systemd-timedated.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-tmpfiles-clean.service": { "name": "systemd-tmpfiles-clean.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-tmpfiles-setup-dev.service": { "name": "systemd-tmpfiles-setup-dev.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-tmpfiles-setup.service": { "name": "systemd-tmpfiles-setup.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-udev-settle.service": { "name": "systemd-udev-settle.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-udev-trigger.service": { "name": "systemd-udev-trigger.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-udevd.service": { "name": "systemd-udevd.service", "source": "systemd", "state": "running", "status": "static" }, "systemd-update-done.service": { "name": "systemd-update-done.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-update-utmp-runlevel.service": { "name": "systemd-update-utmp-runlevel.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-update-utmp.service": { "name": "systemd-update-utmp.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-user-sessions.service": { "name": "systemd-user-sessions.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-vconsole-setup.service": { "name": "systemd-vconsole-setup.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-volatile-root.service": { "name": "systemd-volatile-root.service", "source": "systemd", "state": "inactive", "status": "static" }, "teamd@.service": { "name": "teamd@.service", "source": "systemd", "state": "unknown", "status": "static" }, "tuned.service": { "name": "tuned.service", "source": "systemd", "state": "running", "status": "enabled" }, "user-runtime-dir@.service": { "name": "user-runtime-dir@.service", "source": "systemd", "state": "unknown", "status": "static" }, "user-runtime-dir@0.service": { "name": "user-runtime-dir@0.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "user@.service": { "name": "user@.service", "source": "systemd", "state": "unknown", "status": "static" }, "user@0.service": { "name": "user@0.service", "source": "systemd", "state": "running", "status": "unknown" } } }, "changed": false } TASK [linux-system-roles.mssql : Verify that the variables required for setting up MSSQL are defined] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:75 Tuesday 07 June 2022 03:37:45 +0000 (0:00:01.629) 0:00:08.244 ********** skipping: [/cache/rhel-9.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Set up MSSQL] ********************************* task path: /tmp/tmpajc2l7lu/tasks/main.yml:85 Tuesday 07 June 2022 03:37:45 +0000 (0:00:00.065) 0:00:08.309 ********** skipping: [/cache/rhel-9.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Ensure that the tuned-profiles-mssql package is installed] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:94 Tuesday 07 June 2022 03:37:45 +0000 (0:00:00.033) 0:00:08.342 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false, "rc": 0, "results": [] } MSG: Nothing to do TASK [linux-system-roles.mssql : Ensure that the tuned service is started and enabled] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:99 Tuesday 07 June 2022 03:37:46 +0000 (0:00:00.921) 0:00:09.263 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false, "enabled": true, "name": "tuned", "state": "started", "status": { "ActiveEnterTimestamp": "Mon 2022-06-06 23:36:20 EDT", "ActiveEnterTimestampMonotonic": "5094434", "ActiveExitTimestampMonotonic": "0", "ActiveState": "active", "After": "dbus-broker.service sysinit.target basic.target network.target systemd-sysctl.service system.slice systemd-journald.socket dbus.socket", "AllowIsolate": "no", "AssertResult": "yes", "AssertTimestamp": "Mon 2022-06-06 23:36:19 EDT", "AssertTimestampMonotonic": "4792291", "Before": "shutdown.target multi-user.target", "BlockIOAccounting": "no", "BlockIOWeight": "[not set]", "BusName": "com.redhat.tuned", "CPUAccounting": "yes", "CPUAffinityFromNUMA": "no", "CPUQuotaPerSecUSec": "infinity", "CPUQuotaPeriodUSec": "infinity", "CPUSchedulingPolicy": "0", "CPUSchedulingPriority": "0", "CPUSchedulingResetOnFork": "no", "CPUShares": "[not set]", "CPUUsageNSec": "526618000", "CPUWeight": "[not set]", "CacheDirectoryMode": "0755", "CanFreeze": "yes", "CanIsolate": "no", "CanReload": "no", "CanStart": "yes", "CanStop": "yes", "CapabilityBoundingSet": "cap_chown cap_dac_override cap_dac_read_search cap_fowner cap_fsetid cap_kill cap_setgid cap_setuid cap_setpcap cap_linux_immutable cap_net_bind_service cap_net_broadcast cap_net_admin cap_net_raw cap_ipc_lock cap_ipc_owner cap_sys_module cap_sys_rawio cap_sys_chroot cap_sys_ptrace cap_sys_pacct cap_sys_admin cap_sys_boot cap_sys_nice cap_sys_resource cap_sys_time cap_sys_tty_config cap_mknod cap_lease cap_audit_write cap_audit_control cap_setfcap cap_mac_override cap_mac_admin cap_syslog cap_wake_alarm cap_block_suspend cap_audit_read cap_perfmon cap_bpf cap_checkpoint_restore", "CleanResult": "success", "CollectMode": "inactive", "ConditionResult": "yes", "ConditionTimestamp": "Mon 2022-06-06 23:36:19 EDT", "ConditionTimestampMonotonic": "4792290", "ConfigurationDirectoryMode": "0755", "Conflicts": "shutdown.target cpupower.service", "ControlGroup": "/system.slice/tuned.service", "ControlPID": "0", "CoredumpFilter": "0x33", "DefaultDependencies": "yes", "DefaultMemoryLow": "0", "DefaultMemoryMin": "0", "Delegate": "no", "Description": "Dynamic System Tuning Daemon", "DevicePolicy": "auto", "Documentation": "\"man:tuned(8)\" \"man:tuned.conf(5)\" \"man:tuned-adm(8)\"", "DynamicUser": "no", "ExecMainCode": "0", "ExecMainExitTimestampMonotonic": "0", "ExecMainPID": "761", "ExecMainStartTimestamp": "Mon 2022-06-06 23:36:19 EDT", "ExecMainStartTimestampMonotonic": "4793223", "ExecMainStatus": "0", "ExecStart": "{ path=/usr/sbin/tuned ; argv[]=/usr/sbin/tuned -l -P ; ignore_errors=no ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }", "ExecStartEx": "{ path=/usr/sbin/tuned ; argv[]=/usr/sbin/tuned -l -P ; flags= ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }", "ExitType": "main", "FailureAction": "none", "FileDescriptorStoreMax": "0", "FinalKillSignal": "9", "FragmentPath": "/usr/lib/systemd/system/tuned.service", "FreezerState": "running", "GID": "[not set]", "GuessMainPID": "yes", "IOAccounting": "no", "IOReadBytes": "18446744073709551615", "IOReadOperations": "18446744073709551615", "IOSchedulingClass": "2", "IOSchedulingPriority": "4", "IOWeight": "[not set]", "IOWriteBytes": "18446744073709551615", "IOWriteOperations": "18446744073709551615", "IPAccounting": "no", "IPEgressBytes": "[no data]", "IPEgressPackets": "[no data]", "IPIngressBytes": "[no data]", "IPIngressPackets": "[no data]", "Id": "tuned.service", "IgnoreOnIsolate": "no", "IgnoreSIGPIPE": "yes", "InactiveEnterTimestampMonotonic": "0", "InactiveExitTimestamp": "Mon 2022-06-06 23:36:19 EDT", "InactiveExitTimestampMonotonic": "4793389", "InvocationID": "9bf42224ef6f463095183b8de6dd523a", "JobRunningTimeoutUSec": "infinity", "JobTimeoutAction": "none", "JobTimeoutUSec": "infinity", "KeyringMode": "private", "KillMode": "control-group", "KillSignal": "15", "LimitAS": "infinity", "LimitASSoft": "infinity", "LimitCORE": "infinity", "LimitCORESoft": "0", "LimitCPU": "infinity", "LimitCPUSoft": "infinity", "LimitDATA": "infinity", "LimitDATASoft": "infinity", "LimitFSIZE": "infinity", "LimitFSIZESoft": "infinity", "LimitLOCKS": "infinity", "LimitLOCKSSoft": "infinity", "LimitMEMLOCK": "65536", "LimitMEMLOCKSoft": "65536", "LimitMSGQUEUE": "819200", "LimitMSGQUEUESoft": "819200", "LimitNICE": "0", "LimitNICESoft": "0", "LimitNOFILE": "524288", "LimitNOFILESoft": "1024", "LimitNPROC": "14637", "LimitNPROCSoft": "14637", "LimitRSS": "infinity", "LimitRSSSoft": "infinity", "LimitRTPRIO": "0", "LimitRTPRIOSoft": "0", "LimitRTTIME": "infinity", "LimitRTTIMESoft": "infinity", "LimitSIGPENDING": "14637", "LimitSIGPENDINGSoft": "14637", "LimitSTACK": "infinity", "LimitSTACKSoft": "8388608", "LoadState": "loaded", "LockPersonality": "no", "LogLevelMax": "-1", "LogRateLimitBurst": "0", "LogRateLimitIntervalUSec": "0", "LogsDirectoryMode": "0755", "MainPID": "761", "ManagedOOMMemoryPressure": "auto", "ManagedOOMMemoryPressureLimit": "0", "ManagedOOMPreference": "none", "ManagedOOMSwap": "auto", "MemoryAccounting": "yes", "MemoryAvailable": "infinity", "MemoryCurrent": "18874368", "MemoryDenyWriteExecute": "no", "MemoryHigh": "infinity", "MemoryLimit": "infinity", "MemoryLow": "0", "MemoryMax": "infinity", "MemoryMin": "0", "MemorySwapMax": "infinity", "MountAPIVFS": "no", "NFileDescriptorStore": "0", "NRestarts": "0", "NUMAPolicy": "n/a", "Names": "tuned.service", "NeedDaemonReload": "no", "Nice": "0", "NoNewPrivileges": "no", "NonBlocking": "no", "NotifyAccess": "none", "OOMPolicy": "stop", "OOMScoreAdjust": "0", "OnFailureJobMode": "replace", "OnSuccessJobMode": "fail", "PIDFile": "/run/tuned/tuned.pid", "Perpetual": "no", "PrivateDevices": "no", "PrivateIPC": "no", "PrivateMounts": "no", "PrivateNetwork": "no", "PrivateTmp": "no", "PrivateUsers": "no", "ProcSubset": "all", "ProtectClock": "no", "ProtectControlGroups": "no", "ProtectHome": "no", "ProtectHostname": "no", "ProtectKernelLogs": "no", "ProtectKernelModules": "no", "ProtectKernelTunables": "no", "ProtectProc": "default", "ProtectSystem": "no", "RefuseManualStart": "no", "RefuseManualStop": "no", "ReloadResult": "success", "RemainAfterExit": "no", "RemoveIPC": "no", "Requires": "dbus-broker.service sysinit.target system.slice polkit.service dbus.socket", "Restart": "no", "RestartKillSignal": "15", "RestartUSec": "100ms", "RestrictNamespaces": "no", "RestrictRealtime": "no", "RestrictSUIDSGID": "no", "Result": "success", "RootDirectoryStartOnly": "no", "RuntimeDirectoryMode": "0755", "RuntimeDirectoryPreserve": "no", "RuntimeMaxUSec": "infinity", "RuntimeRandomizedExtraUSec": "0", "SameProcessGroup": "no", "SecureBits": "0", "SendSIGHUP": "no", "SendSIGKILL": "yes", "Slice": "system.slice", "StandardError": "inherit", "StandardInput": "null", "StandardOutput": "journal", "StartLimitAction": "none", "StartLimitBurst": "5", "StartLimitIntervalUSec": "10s", "StartupBlockIOWeight": "[not set]", "StartupCPUShares": "[not set]", "StartupCPUWeight": "[not set]", "StartupIOWeight": "[not set]", "StateChangeTimestamp": "Mon 2022-06-06 23:37:25 EDT", "StateChangeTimestampMonotonic": "70903824", "StateDirectoryMode": "0755", "StatusErrno": "0", "StopWhenUnneeded": "no", "SubState": "running", "SuccessAction": "none", "SyslogFacility": "3", "SyslogLevel": "6", "SyslogLevelPrefix": "yes", "SyslogPriority": "30", "SystemCallErrorNumber": "2147483646", "TTYReset": "no", "TTYVHangup": "no", "TTYVTDisallocate": "no", "TasksAccounting": "yes", "TasksCurrent": "5", "TasksMax": "23420", "TimeoutAbortUSec": "1min 30s", "TimeoutCleanUSec": "infinity", "TimeoutStartFailureMode": "terminate", "TimeoutStartUSec": "1min 30s", "TimeoutStopFailureMode": "terminate", "TimeoutStopUSec": "1min 30s", "TimerSlackNSec": "50000", "Transient": "no", "Type": "dbus", "UID": "[not set]", "UMask": "0022", "UnitFilePreset": "enabled", "UnitFileState": "enabled", "UtmpMode": "init", "WantedBy": "multi-user.target", "WatchdogSignal": "6", "WatchdogTimestampMonotonic": "0", "WatchdogUSec": "0" } } TASK [linux-system-roles.mssql : Get the active Tuned profiles] **************** task path: /tmp/tmpajc2l7lu/tasks/main.yml:105 Tuesday 07 June 2022 03:37:47 +0000 (0:00:00.745) 0:00:10.009 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false, "cmd": [ "tuned-adm", "active" ], "delta": "0:00:00.097387", "end": "2022-06-06 23:37:47.438564", "rc": 0, "start": "2022-06-06 23:37:47.341177" } STDOUT: Current active profile: virtual-guest mssql TASK [linux-system-roles.mssql : Add mssql to the list of Tuned profiles] ****** task path: /tmp/tmpajc2l7lu/tasks/main.yml:115 Tuesday 07 June 2022 03:37:47 +0000 (0:00:00.472) 0:00:10.481 ********** skipping: [/cache/rhel-9.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Configure the Microsoft SQL Server Tools repository] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:145 Tuesday 07 June 2022 03:37:47 +0000 (0:00:00.027) 0:00:10.508 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false, "repo": "packages-microsoft-com-prod", "state": "present" } TASK [linux-system-roles.mssql : Ensure that SQL Server client tools are installed] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:152 Tuesday 07 June 2022 03:37:48 +0000 (0:00:00.357) 0:00:10.865 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false, "rc": 0, "results": [] } MSG: Nothing to do TASK [linux-system-roles.mssql : Prepare MSSQL and facts for logging in] ******* task path: /tmp/tmpajc2l7lu/tasks/main.yml:164 Tuesday 07 June 2022 03:37:49 +0000 (0:00:00.821) 0:00:11.686 ********** included: /tmp/tmpajc2l7lu/tasks/verify_password.yml for /cache/rhel-9.qcow2 TASK [linux-system-roles.mssql : Ensure that the mssql-server service is started] *** task path: /tmp/tmpajc2l7lu/tasks/verify_password.yml:1 Tuesday 07 June 2022 03:37:49 +0000 (0:00:00.047) 0:00:11.734 ********** fatal: [/cache/rhel-9.qcow2]: FAILED! => { "changed": false } MSG: Unable to start service mssql-server: Job for mssql-server.service failed because the control process exited with error code. See "systemctl status mssql-server.service" and "journalctl -xeu mssql-server.service" for details. PLAY RECAP ********************************************************************* /cache/rhel-9.qcow2 : ok=16 changed=1 unreachable=0 failed=1 skipped=3 rescued=0 ignored=0 Tuesday 07 June 2022 03:37:49 +0000 (0:00:00.477) 0:00:12.211 ********** =============================================================================== linux-system-roles.mssql : Gather system services facts ----------------- 1.63s /tmp/tmpajc2l7lu/tasks/main.yml:62 -------------------------------------------- create var file in caller that can override the one in called role ------ 1.51s /tmp/tmpajc2l7lu/tests/tests_include_vars_from_parent.yml:3 ------------------- set up internal repositories -------------------------------------------- 1.24s /cache/rhel-9_setup.yml:5 ----------------------------------------------------- linux-system-roles.mssql : Ensure that the Microsoft SQL Server package is installed --- 1.00s /tmp/tmpajc2l7lu/tasks/main.yml:42 -------------------------------------------- Gathering Facts --------------------------------------------------------- 0.99s /tmp/tmpajc2l7lu/tests/tests_include_vars_from_parent.yml:1 ------------------- linux-system-roles.mssql : Ensure that the tuned-profiles-mssql package is installed --- 0.92s /tmp/tmpajc2l7lu/tasks/main.yml:94 -------------------------------------------- linux-system-roles.mssql : Ensure that SQL Server client tools are installed --- 0.82s /tmp/tmpajc2l7lu/tasks/main.yml:152 ------------------------------------------- linux-system-roles.mssql : Ensure that the tuned service is started and enabled --- 0.75s /tmp/tmpajc2l7lu/tasks/main.yml:99 -------------------------------------------- linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories --- 0.71s /tmp/tmpajc2l7lu/tasks/main.yml:30 -------------------------------------------- linux-system-roles.mssql : Check if the errorlog file exists and its location --- 0.59s /tmp/tmpajc2l7lu/tasks/main.yml:47 -------------------------------------------- linux-system-roles.mssql : Ensure that the mssql-server service is started --- 0.48s /tmp/tmpajc2l7lu/tasks/verify_password.yml:1 ---------------------------------- linux-system-roles.mssql : Get the active Tuned profiles ---------------- 0.47s /tmp/tmpajc2l7lu/tasks/main.yml:105 ------------------------------------------- linux-system-roles.mssql : Configure the Microsoft SQL Server 2019 repository --- 0.38s /tmp/tmpajc2l7lu/tasks/main.yml:35 -------------------------------------------- linux-system-roles.mssql : Configure the Microsoft SQL Server Tools repository --- 0.36s /tmp/tmpajc2l7lu/tasks/main.yml:145 ------------------------------------------- include_role : {{ roletoinclude }} -------------------------------------- 0.07s /tmp/tmpajc2l7lu/tests/roles/caller/tasks/main.yml:4 -------------------------- linux-system-roles.mssql : Verify that the variables required for setting up MSSQL are defined --- 0.07s /tmp/tmpajc2l7lu/tasks/main.yml:75 -------------------------------------------- linux-system-roles.mssql : Set platform/version specific variables ------ 0.06s /tmp/tmpajc2l7lu/tasks/main.yml:3 --------------------------------------------- linux-system-roles.mssql : Prepare MSSQL and facts for logging in ------- 0.05s /tmp/tmpajc2l7lu/tasks/main.yml:164 ------------------------------------------- linux-system-roles.mssql : Verify that the user accepts EULA variables --- 0.03s /tmp/tmpajc2l7lu/tasks/main.yml:18 -------------------------------------------- linux-system-roles.mssql : Set up MSSQL --------------------------------- 0.03s /tmp/tmpajc2l7lu/tasks/main.yml:85 -------------------------------------------- ansible-playbook 2.9.27 config file = /etc/ansible/ansible.cfg configured module search path = [u'/root/.ansible/plugins/modules', u'/usr/share/ansible/plugins/modules'] ansible python module location = /usr/lib/python2.7/site-packages/ansible executable location = /usr/bin/ansible-playbook python version = 2.7.5 (default, May 27 2022, 11:27:32) [GCC 4.8.5 20150623 (Red Hat 4.8.5-44)] 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: rhel-9_setup.yml ***************************************************** 1 plays in /cache/rhel-9_setup.yml PLAY [Setup repos] ************************************************************* META: ran handlers TASK [set up internal repositories] ******************************************** task path: /cache/rhel-9_setup.yml:5 Tuesday 07 June 2022 03:37:50 +0000 (0:00:00.022) 0:00:00.022 ********** ok: [/cache/rhel-9.qcow2] => (item=None) => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false } ok: [/cache/rhel-9.qcow2] => (item=None) => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false } ok: [/cache/rhel-9.qcow2] => (item=None) => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false } ok: [/cache/rhel-9.qcow2] => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false } META: ran handlers META: ran handlers PLAY RECAP ********************************************************************* /cache/rhel-9.qcow2 : ok=1 changed=0 unreachable=0 failed=0 skipped=0 rescued=0 ignored=0 Tuesday 07 June 2022 03:37:51 +0000 (0:00:01.285) 0:00:01.308 ********** =============================================================================== set up internal repositories -------------------------------------------- 1.29s /cache/rhel-9_setup.yml:5 ----------------------------------------------------- PLAYBOOK: tests_input_sql_file.yml ********************************************* 1 plays in /tmp/tmpajc2l7lu/tests/tests_input_sql_file.yml PLAY [Ensure that the role can input sql files to MSSQL] *********************** TASK [Gathering Facts] ********************************************************* task path: /tmp/tmpajc2l7lu/tests/tests_input_sql_file.yml:3 Tuesday 07 June 2022 03:37:51 +0000 (0:00:00.010) 0:00:01.318 ********** ok: [/cache/rhel-9.qcow2] META: ran handlers TASK [Set up MSSQL and input the sql file] ************************************* task path: /tmp/tmpajc2l7lu/tests/tests_input_sql_file.yml:10 Tuesday 07 June 2022 03:37:52 +0000 (0:00:00.966) 0:00:02.284 ********** TASK [linux-system-roles.mssql : Set platform/version specific variables] ****** task path: /tmp/tmpajc2l7lu/tasks/main.yml:3 Tuesday 07 June 2022 03:37:52 +0000 (0:00:00.062) 0:00:02.347 ********** ok: [/cache/rhel-9.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-2019/" }, "ansible_included_var_files": [ "/tmp/tmpajc2l7lu/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } ok: [/cache/rhel-9.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-2019/" }, "ansible_included_var_files": [ "/tmp/tmpajc2l7lu/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } skipping: [/cache/rhel-9.qcow2] => (item=RedHat_9.yml) => { "ansible_loop_var": "item", "changed": false, "item": "RedHat_9.yml", "skip_reason": "Conditional result was False" } skipping: [/cache/rhel-9.qcow2] => (item=RedHat_9.0.yml) => { "ansible_loop_var": "item", "changed": false, "item": "RedHat_9.0.yml", "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Verify that the user accepts EULA variables] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:18 Tuesday 07 June 2022 03:37:52 +0000 (0:00:00.071) 0:00:02.418 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false } MSG: All assertions passed TASK [linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:30 Tuesday 07 June 2022 03:37:52 +0000 (0:00:00.044) 0:00:02.463 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false } TASK [linux-system-roles.mssql : Configure the Microsoft SQL Server 2019 repository] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:35 Tuesday 07 June 2022 03:37:54 +0000 (0:00:01.674) 0:00:04.138 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false, "repo": "packages-microsoft-com-mssql-server-2019-gdr", "state": "present" } TASK [linux-system-roles.mssql : Ensure that the Microsoft SQL Server package is installed] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:42 Tuesday 07 June 2022 03:37:54 +0000 (0:00:00.392) 0:00:04.531 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false, "rc": 0, "results": [] } MSG: Nothing to do TASK [linux-system-roles.mssql : Check if the errorlog file exists and its location] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:47 Tuesday 07 June 2022 03:37:55 +0000 (0:00:01.085) 0:00:05.616 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false, "cmd": "set -euo pipefail\nerrorlog=\"$(/opt/mssql/bin/mssql-conf get filelocation errorlogfile 2>&1 \\\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.097283", "end": "2022-06-06 23:37:56.101883", "rc": 0, "start": "2022-06-06 23:37:56.004600" } TASK [linux-system-roles.mssql : Gather system services facts] ***************** task path: /tmp/tmpajc2l7lu/tasks/main.yml:62 Tuesday 07 June 2022 03:37:56 +0000 (0:00:00.586) 0:00:06.202 ********** ok: [/cache/rhel-9.qcow2] => { "ansible_facts": { "services": { "NetworkManager-dispatcher.service": { "name": "NetworkManager-dispatcher.service", "source": "systemd", "state": "inactive", "status": "enabled" }, "NetworkManager-wait-online.service": { "name": "NetworkManager-wait-online.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "NetworkManager.service": { "name": "NetworkManager.service", "source": "systemd", "state": "running", "status": "enabled" }, "auditd.service": { "name": "auditd.service", "source": "systemd", "state": "running", "status": "enabled" }, "auth-rpcgss-module.service": { "name": "auth-rpcgss-module.service", "source": "systemd", "state": "stopped", "status": "static" }, "autovt@.service": { "name": "autovt@.service", "source": "systemd", "state": "unknown", "status": "alias" }, "chrony-wait.service": { "name": "chrony-wait.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "chronyd.service": { "name": "chronyd.service", "source": "systemd", "state": "running", "status": "enabled" }, "cloud-config.service": { "name": "cloud-config.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "cloud-final.service": { "name": "cloud-final.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "cloud-init-local.service": { "name": "cloud-init-local.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "cloud-init.service": { "name": "cloud-init.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "cockpit-motd.service": { "name": "cockpit-motd.service", "source": "systemd", "state": "inactive", "status": "static" }, "cockpit-wsinstance-http.service": { "name": "cockpit-wsinstance-http.service", "source": "systemd", "state": "inactive", "status": "static" }, "cockpit-wsinstance-https-factory@.service": { "name": "cockpit-wsinstance-https-factory@.service", "source": "systemd", "state": "unknown", "status": "static" }, "cockpit-wsinstance-https@.service": { "name": "cockpit-wsinstance-https@.service", "source": "systemd", "state": "unknown", "status": "static" }, "cockpit.service": { "name": "cockpit.service", "source": "systemd", "state": "inactive", "status": "static" }, "console-getty.service": { "name": "console-getty.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "container-getty@.service": { "name": "container-getty@.service", "source": "systemd", "state": "unknown", "status": "static" }, "cpupower.service": { "name": "cpupower.service", "source": "systemd", "state": "stopped", "status": "disabled" }, "crond.service": { "name": "crond.service", "source": "systemd", "state": "running", "status": "enabled" }, "dbus-broker.service": { "name": "dbus-broker.service", "source": "systemd", "state": "running", "status": "enabled" }, "dbus-org.freedesktop.hostname1.service": { "name": "dbus-org.freedesktop.hostname1.service", "source": "systemd", "state": "inactive", "status": "alias" }, "dbus-org.freedesktop.locale1.service": { "name": "dbus-org.freedesktop.locale1.service", "source": "systemd", "state": "inactive", "status": "alias" }, "dbus-org.freedesktop.login1.service": { "name": "dbus-org.freedesktop.login1.service", "source": "systemd", "state": "active", "status": "alias" }, "dbus-org.freedesktop.nm-dispatcher.service": { "name": "dbus-org.freedesktop.nm-dispatcher.service", "source": "systemd", "state": "inactive", "status": "alias" }, "dbus-org.freedesktop.timedate1.service": { "name": "dbus-org.freedesktop.timedate1.service", "source": "systemd", "state": "inactive", "status": "alias" }, "dbus.service": { "name": "dbus.service", "source": "systemd", "state": "active", "status": "alias" }, "debug-shell.service": { "name": "debug-shell.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "dnf-makecache.service": { "name": "dnf-makecache.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-cmdline.service": { "name": "dracut-cmdline.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-initqueue.service": { "name": "dracut-initqueue.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-mount.service": { "name": "dracut-mount.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-pre-mount.service": { "name": "dracut-pre-mount.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-pre-pivot.service": { "name": "dracut-pre-pivot.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-pre-trigger.service": { "name": "dracut-pre-trigger.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-pre-udev.service": { "name": "dracut-pre-udev.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-shutdown-onfailure.service": { "name": "dracut-shutdown-onfailure.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-shutdown.service": { "name": "dracut-shutdown.service", "source": "systemd", "state": "stopped", "status": "static" }, "emergency.service": { "name": "emergency.service", "source": "systemd", "state": "stopped", "status": "static" }, "fstrim.service": { "name": "fstrim.service", "source": "systemd", "state": "inactive", "status": "static" }, "fwupd-offline-update.service": { "name": "fwupd-offline-update.service", "source": "systemd", "state": "inactive", "status": "static" }, "fwupd-refresh.service": { "name": "fwupd-refresh.service", "source": "systemd", "state": "inactive", "status": "static" }, "fwupd.service": { "name": "fwupd.service", "source": "systemd", "state": "inactive", "status": "static" }, "getty@.service": { "name": "getty@.service", "source": "systemd", "state": "unknown", "status": "enabled" }, "getty@tty1.service": { "name": "getty@tty1.service", "source": "systemd", "state": "running", "status": "unknown" }, "grub-boot-indeterminate.service": { "name": "grub-boot-indeterminate.service", "source": "systemd", "state": "inactive", "status": "static" }, "grub2-systemd-integration.service": { "name": "grub2-systemd-integration.service", "source": "systemd", "state": "inactive", "status": "static" }, "gssproxy.service": { "name": "gssproxy.service", "source": "systemd", "state": "running", "status": "disabled" }, "initrd-cleanup.service": { "name": "initrd-cleanup.service", "source": "systemd", "state": "stopped", "status": "static" }, "initrd-parse-etc.service": { "name": "initrd-parse-etc.service", "source": "systemd", "state": "stopped", "status": "static" }, "initrd-switch-root.service": { "name": "initrd-switch-root.service", "source": "systemd", "state": "stopped", "status": "static" }, "initrd-udevadm-cleanup-db.service": { "name": "initrd-udevadm-cleanup-db.service", "source": "systemd", "state": "stopped", "status": "static" }, "insights-client-boot.service": { "name": "insights-client-boot.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "insights-client-results.service": { "name": "insights-client-results.service", "source": "systemd", "state": "inactive", "status": "static" }, "insights-client.service": { "name": "insights-client.service", "source": "systemd", "state": "inactive", "status": "static" }, "irqbalance.service": { "name": "irqbalance.service", "source": "systemd", "state": "running", "status": "enabled" }, "kdump.service": { "name": "kdump.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "kmod-static-nodes.service": { "name": "kmod-static-nodes.service", "source": "systemd", "state": "stopped", "status": "static" }, "kvm_stat.service": { "name": "kvm_stat.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "ldconfig.service": { "name": "ldconfig.service", "source": "systemd", "state": "stopped", "status": "static" }, "logrotate.service": { "name": "logrotate.service", "source": "systemd", "state": "stopped", "status": "static" }, "man-db-cache-update.service": { "name": "man-db-cache-update.service", "source": "systemd", "state": "inactive", "status": "static" }, "man-db-restart-cache-update.service": { "name": "man-db-restart-cache-update.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "microcode.service": { "name": "microcode.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "modprobe@.service": { "name": "modprobe@.service", "source": "systemd", "state": "unknown", "status": "static" }, "modprobe@configfs.service": { "name": "modprobe@configfs.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "modprobe@drm.service": { "name": "modprobe@drm.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "modprobe@fuse.service": { "name": "modprobe@fuse.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "mssql-server.service": { "name": "mssql-server.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "nfs-blkmap.service": { "name": "nfs-blkmap.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "nfs-idmapd.service": { "name": "nfs-idmapd.service", "source": "systemd", "state": "stopped", "status": "static" }, "nfs-mountd.service": { "name": "nfs-mountd.service", "source": "systemd", "state": "stopped", "status": "static" }, "nfs-server.service": { "name": "nfs-server.service", "source": "systemd", "state": "stopped", "status": "disabled" }, "nfs-utils.service": { "name": "nfs-utils.service", "source": "systemd", "state": "stopped", "status": "static" }, "nfsdcld.service": { "name": "nfsdcld.service", "source": "systemd", "state": "stopped", "status": "static" }, "nis-domainname.service": { "name": "nis-domainname.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "nm-priv-helper.service": { "name": "nm-priv-helper.service", "source": "systemd", "state": "inactive", "status": "static" }, "oddjobd.service": { "name": "oddjobd.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "packagekit-offline-update.service": { "name": "packagekit-offline-update.service", "source": "systemd", "state": "inactive", "status": "static" }, "packagekit.service": { "name": "packagekit.service", "source": "systemd", "state": "inactive", "status": "static" }, "pam_namespace.service": { "name": "pam_namespace.service", "source": "systemd", "state": "inactive", "status": "static" }, "polkit.service": { "name": "polkit.service", "source": "systemd", "state": "running", "status": "static" }, "qemu-guest-agent.service": { "name": "qemu-guest-agent.service", "source": "systemd", "state": "inactive", "status": "enabled" }, "quotaon.service": { "name": "quotaon.service", "source": "systemd", "state": "inactive", "status": "static" }, "rc-local.service": { "name": "rc-local.service", "source": "systemd", "state": "stopped", "status": "static" }, "rdisc.service": { "name": "rdisc.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "rescue.service": { "name": "rescue.service", "source": "systemd", "state": "stopped", "status": "static" }, "rhsm-facts.service": { "name": "rhsm-facts.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "rhsm.service": { "name": "rhsm.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "rhsmcertd.service": { "name": "rhsmcertd.service", "source": "systemd", "state": "running", "status": "enabled" }, "rpc-gssd.service": { "name": "rpc-gssd.service", "source": "systemd", "state": "stopped", "status": "static" }, "rpc-statd-notify.service": { "name": "rpc-statd-notify.service", "source": "systemd", "state": "stopped", "status": "static" }, "rpc-statd.service": { "name": "rpc-statd.service", "source": "systemd", "state": "stopped", "status": "static" }, "rpcbind.service": { "name": "rpcbind.service", "source": "systemd", "state": "running", "status": "enabled" }, "rpmdb-rebuild.service": { "name": "rpmdb-rebuild.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "rsyslog.service": { "name": "rsyslog.service", "source": "systemd", "state": "running", "status": "enabled" }, "saslauthd.service": { "name": "saslauthd.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "selinux-autorelabel-mark.service": { "name": "selinux-autorelabel-mark.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "selinux-autorelabel.service": { "name": "selinux-autorelabel.service", "source": "systemd", "state": "inactive", "status": "static" }, "serial-getty@.service": { "name": "serial-getty@.service", "source": "systemd", "state": "unknown", "status": "indirect" }, "serial-getty@ttyS0.service": { "name": "serial-getty@ttyS0.service", "source": "systemd", "state": "running", "status": "unknown" }, "sshd-keygen@.service": { "name": "sshd-keygen@.service", "source": "systemd", "state": "unknown", "status": "disabled" }, "sshd-keygen@ecdsa.service": { "name": "sshd-keygen@ecdsa.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "sshd-keygen@ed25519.service": { "name": "sshd-keygen@ed25519.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "sshd-keygen@rsa.service": { "name": "sshd-keygen@rsa.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "sshd.service": { "name": "sshd.service", "source": "systemd", "state": "running", "status": "enabled" }, "sshd@.service": { "name": "sshd@.service", "source": "systemd", "state": "unknown", "status": "static" }, "sssd-autofs.service": { "name": "sssd-autofs.service", "source": "systemd", "state": "inactive", "status": "indirect" }, "sssd-kcm.service": { "name": "sssd-kcm.service", "source": "systemd", "state": "stopped", "status": "indirect" }, "sssd-nss.service": { "name": "sssd-nss.service", "source": "systemd", "state": "inactive", "status": "indirect" }, "sssd-pac.service": { "name": "sssd-pac.service", "source": "systemd", "state": "inactive", "status": "indirect" }, "sssd-pam.service": { "name": "sssd-pam.service", "source": "systemd", "state": "inactive", "status": "indirect" }, "sssd-ssh.service": { "name": "sssd-ssh.service", "source": "systemd", "state": "inactive", "status": "indirect" }, "sssd-sudo.service": { "name": "sssd-sudo.service", "source": "systemd", "state": "inactive", "status": "indirect" }, "sssd.service": { "name": "sssd.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "system-update-cleanup.service": { "name": "system-update-cleanup.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-ask-password-console.service": { "name": "systemd-ask-password-console.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-ask-password-wall.service": { "name": "systemd-ask-password-wall.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-backlight@.service": { "name": "systemd-backlight@.service", "source": "systemd", "state": "unknown", "status": "static" }, "systemd-binfmt.service": { "name": "systemd-binfmt.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-boot-check-no-failures.service": { "name": "systemd-boot-check-no-failures.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "systemd-coredump@.service": { "name": "systemd-coredump@.service", "source": "systemd", "state": "unknown", "status": "static" }, "systemd-exit.service": { "name": "systemd-exit.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-firstboot.service": { "name": "systemd-firstboot.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-fsck-root.service": { "name": "systemd-fsck-root.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-fsck@.service": { "name": "systemd-fsck@.service", "source": "systemd", "state": "unknown", "status": "static" }, "systemd-fsck@dev-disk-by\\x2duuid-7B77\\x2d95E7.service": { "name": "systemd-fsck@dev-disk-by\\x2duuid-7B77\\x2d95E7.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "systemd-fsck@dev-vda2.service": { "name": "systemd-fsck@dev-vda2.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "systemd-halt.service": { "name": "systemd-halt.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-hibernate-resume@.service": { "name": "systemd-hibernate-resume@.service", "source": "systemd", "state": "unknown", "status": "static" }, "systemd-hibernate.service": { "name": "systemd-hibernate.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-hostnamed.service": { "name": "systemd-hostnamed.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-hwdb-update.service": { "name": "systemd-hwdb-update.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-hybrid-sleep.service": { "name": "systemd-hybrid-sleep.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-initctl.service": { "name": "systemd-initctl.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-journal-catalog-update.service": { "name": "systemd-journal-catalog-update.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-journal-flush.service": { "name": "systemd-journal-flush.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-journald.service": { "name": "systemd-journald.service", "source": "systemd", "state": "running", "status": "static" }, "systemd-journald@.service": { "name": "systemd-journald@.service", "source": "systemd", "state": "unknown", "status": "static" }, "systemd-kexec.service": { "name": "systemd-kexec.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-localed.service": { "name": "systemd-localed.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-logind.service": { "name": "systemd-logind.service", "source": "systemd", "state": "running", "status": "static" }, "systemd-machine-id-commit.service": { "name": "systemd-machine-id-commit.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-modules-load.service": { "name": "systemd-modules-load.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-network-generator.service": { "name": "systemd-network-generator.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "systemd-poweroff.service": { "name": "systemd-poweroff.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-pstore.service": { "name": "systemd-pstore.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "systemd-quotacheck.service": { "name": "systemd-quotacheck.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-random-seed.service": { "name": "systemd-random-seed.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-reboot.service": { "name": "systemd-reboot.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-remount-fs.service": { "name": "systemd-remount-fs.service", "source": "systemd", "state": "stopped", "status": "enabled-runtime" }, "systemd-repart.service": { "name": "systemd-repart.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-rfkill.service": { "name": "systemd-rfkill.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-suspend-then-hibernate.service": { "name": "systemd-suspend-then-hibernate.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-suspend.service": { "name": "systemd-suspend.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-sysctl.service": { "name": "systemd-sysctl.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-sysext.service": { "name": "systemd-sysext.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "systemd-sysusers.service": { "name": "systemd-sysusers.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-timedated.service": { "name": "systemd-timedated.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-tmpfiles-clean.service": { "name": "systemd-tmpfiles-clean.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-tmpfiles-setup-dev.service": { "name": "systemd-tmpfiles-setup-dev.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-tmpfiles-setup.service": { "name": "systemd-tmpfiles-setup.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-udev-settle.service": { "name": "systemd-udev-settle.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-udev-trigger.service": { "name": "systemd-udev-trigger.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-udevd.service": { "name": "systemd-udevd.service", "source": "systemd", "state": "running", "status": "static" }, "systemd-update-done.service": { "name": "systemd-update-done.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-update-utmp-runlevel.service": { "name": "systemd-update-utmp-runlevel.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-update-utmp.service": { "name": "systemd-update-utmp.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-user-sessions.service": { "name": "systemd-user-sessions.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-vconsole-setup.service": { "name": "systemd-vconsole-setup.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-volatile-root.service": { "name": "systemd-volatile-root.service", "source": "systemd", "state": "inactive", "status": "static" }, "teamd@.service": { "name": "teamd@.service", "source": "systemd", "state": "unknown", "status": "static" }, "tuned.service": { "name": "tuned.service", "source": "systemd", "state": "running", "status": "enabled" }, "user-runtime-dir@.service": { "name": "user-runtime-dir@.service", "source": "systemd", "state": "unknown", "status": "static" }, "user-runtime-dir@0.service": { "name": "user-runtime-dir@0.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "user@.service": { "name": "user@.service", "source": "systemd", "state": "unknown", "status": "static" }, "user@0.service": { "name": "user@0.service", "source": "systemd", "state": "running", "status": "unknown" } } }, "changed": false } TASK [linux-system-roles.mssql : Verify that the variables required for setting up MSSQL are defined] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:75 Tuesday 07 June 2022 03:37:58 +0000 (0:00:01.633) 0:00:07.836 ********** skipping: [/cache/rhel-9.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Set up MSSQL] ********************************* task path: /tmp/tmpajc2l7lu/tasks/main.yml:85 Tuesday 07 June 2022 03:37:58 +0000 (0:00:00.058) 0:00:07.895 ********** skipping: [/cache/rhel-9.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Ensure that the tuned-profiles-mssql package is installed] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:94 Tuesday 07 June 2022 03:37:58 +0000 (0:00:00.056) 0:00:07.951 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false, "rc": 0, "results": [] } MSG: Nothing to do TASK [linux-system-roles.mssql : Ensure that the tuned service is started and enabled] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:99 Tuesday 07 June 2022 03:37:59 +0000 (0:00:00.882) 0:00:08.833 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false, "enabled": true, "name": "tuned", "state": "started", "status": { "ActiveEnterTimestamp": "Mon 2022-06-06 23:36:20 EDT", "ActiveEnterTimestampMonotonic": "5094434", "ActiveExitTimestampMonotonic": "0", "ActiveState": "active", "After": "dbus-broker.service sysinit.target basic.target network.target systemd-sysctl.service system.slice systemd-journald.socket dbus.socket", "AllowIsolate": "no", "AssertResult": "yes", "AssertTimestamp": "Mon 2022-06-06 23:36:19 EDT", "AssertTimestampMonotonic": "4792291", "Before": "shutdown.target multi-user.target", "BlockIOAccounting": "no", "BlockIOWeight": "[not set]", "BusName": "com.redhat.tuned", "CPUAccounting": "yes", "CPUAffinityFromNUMA": "no", "CPUQuotaPerSecUSec": "infinity", "CPUQuotaPeriodUSec": "infinity", "CPUSchedulingPolicy": "0", "CPUSchedulingPriority": "0", "CPUSchedulingResetOnFork": "no", "CPUShares": "[not set]", "CPUUsageNSec": "707431000", "CPUWeight": "[not set]", "CacheDirectoryMode": "0755", "CanFreeze": "yes", "CanIsolate": "no", "CanReload": "no", "CanStart": "yes", "CanStop": "yes", "CapabilityBoundingSet": "cap_chown cap_dac_override cap_dac_read_search cap_fowner cap_fsetid cap_kill cap_setgid cap_setuid cap_setpcap cap_linux_immutable cap_net_bind_service cap_net_broadcast cap_net_admin cap_net_raw cap_ipc_lock cap_ipc_owner cap_sys_module cap_sys_rawio cap_sys_chroot cap_sys_ptrace cap_sys_pacct cap_sys_admin cap_sys_boot cap_sys_nice cap_sys_resource cap_sys_time cap_sys_tty_config cap_mknod cap_lease cap_audit_write cap_audit_control cap_setfcap cap_mac_override cap_mac_admin cap_syslog cap_wake_alarm cap_block_suspend cap_audit_read cap_perfmon cap_bpf cap_checkpoint_restore", "CleanResult": "success", "CollectMode": "inactive", "ConditionResult": "yes", "ConditionTimestamp": "Mon 2022-06-06 23:36:19 EDT", "ConditionTimestampMonotonic": "4792290", "ConfigurationDirectoryMode": "0755", "Conflicts": "shutdown.target cpupower.service", "ControlGroup": "/system.slice/tuned.service", "ControlPID": "0", "CoredumpFilter": "0x33", "DefaultDependencies": "yes", "DefaultMemoryLow": "0", "DefaultMemoryMin": "0", "Delegate": "no", "Description": "Dynamic System Tuning Daemon", "DevicePolicy": "auto", "Documentation": "\"man:tuned(8)\" \"man:tuned.conf(5)\" \"man:tuned-adm(8)\"", "DynamicUser": "no", "ExecMainCode": "0", "ExecMainExitTimestampMonotonic": "0", "ExecMainPID": "761", "ExecMainStartTimestamp": "Mon 2022-06-06 23:36:19 EDT", "ExecMainStartTimestampMonotonic": "4793223", "ExecMainStatus": "0", "ExecStart": "{ path=/usr/sbin/tuned ; argv[]=/usr/sbin/tuned -l -P ; ignore_errors=no ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }", "ExecStartEx": "{ path=/usr/sbin/tuned ; argv[]=/usr/sbin/tuned -l -P ; flags= ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }", "ExitType": "main", "FailureAction": "none", "FileDescriptorStoreMax": "0", "FinalKillSignal": "9", "FragmentPath": "/usr/lib/systemd/system/tuned.service", "FreezerState": "running", "GID": "[not set]", "GuessMainPID": "yes", "IOAccounting": "no", "IOReadBytes": "18446744073709551615", "IOReadOperations": "18446744073709551615", "IOSchedulingClass": "2", "IOSchedulingPriority": "4", "IOWeight": "[not set]", "IOWriteBytes": "18446744073709551615", "IOWriteOperations": "18446744073709551615", "IPAccounting": "no", "IPEgressBytes": "[no data]", "IPEgressPackets": "[no data]", "IPIngressBytes": "[no data]", "IPIngressPackets": "[no data]", "Id": "tuned.service", "IgnoreOnIsolate": "no", "IgnoreSIGPIPE": "yes", "InactiveEnterTimestampMonotonic": "0", "InactiveExitTimestamp": "Mon 2022-06-06 23:36:19 EDT", "InactiveExitTimestampMonotonic": "4793389", "InvocationID": "9bf42224ef6f463095183b8de6dd523a", "JobRunningTimeoutUSec": "infinity", "JobTimeoutAction": "none", "JobTimeoutUSec": "infinity", "KeyringMode": "private", "KillMode": "control-group", "KillSignal": "15", "LimitAS": "infinity", "LimitASSoft": "infinity", "LimitCORE": "infinity", "LimitCORESoft": "0", "LimitCPU": "infinity", "LimitCPUSoft": "infinity", "LimitDATA": "infinity", "LimitDATASoft": "infinity", "LimitFSIZE": "infinity", "LimitFSIZESoft": "infinity", "LimitLOCKS": "infinity", "LimitLOCKSSoft": "infinity", "LimitMEMLOCK": "65536", "LimitMEMLOCKSoft": "65536", "LimitMSGQUEUE": "819200", "LimitMSGQUEUESoft": "819200", "LimitNICE": "0", "LimitNICESoft": "0", "LimitNOFILE": "524288", "LimitNOFILESoft": "1024", "LimitNPROC": "14637", "LimitNPROCSoft": "14637", "LimitRSS": "infinity", "LimitRSSSoft": "infinity", "LimitRTPRIO": "0", "LimitRTPRIOSoft": "0", "LimitRTTIME": "infinity", "LimitRTTIMESoft": "infinity", "LimitSIGPENDING": "14637", "LimitSIGPENDINGSoft": "14637", "LimitSTACK": "infinity", "LimitSTACKSoft": "8388608", "LoadState": "loaded", "LockPersonality": "no", "LogLevelMax": "-1", "LogRateLimitBurst": "0", "LogRateLimitIntervalUSec": "0", "LogsDirectoryMode": "0755", "MainPID": "761", "ManagedOOMMemoryPressure": "auto", "ManagedOOMMemoryPressureLimit": "0", "ManagedOOMPreference": "none", "ManagedOOMSwap": "auto", "MemoryAccounting": "yes", "MemoryAvailable": "infinity", "MemoryCurrent": "18870272", "MemoryDenyWriteExecute": "no", "MemoryHigh": "infinity", "MemoryLimit": "infinity", "MemoryLow": "0", "MemoryMax": "infinity", "MemoryMin": "0", "MemorySwapMax": "infinity", "MountAPIVFS": "no", "NFileDescriptorStore": "0", "NRestarts": "0", "NUMAPolicy": "n/a", "Names": "tuned.service", "NeedDaemonReload": "no", "Nice": "0", "NoNewPrivileges": "no", "NonBlocking": "no", "NotifyAccess": "none", "OOMPolicy": "stop", "OOMScoreAdjust": "0", "OnFailureJobMode": "replace", "OnSuccessJobMode": "fail", "PIDFile": "/run/tuned/tuned.pid", "Perpetual": "no", "PrivateDevices": "no", "PrivateIPC": "no", "PrivateMounts": "no", "PrivateNetwork": "no", "PrivateTmp": "no", "PrivateUsers": "no", "ProcSubset": "all", "ProtectClock": "no", "ProtectControlGroups": "no", "ProtectHome": "no", "ProtectHostname": "no", "ProtectKernelLogs": "no", "ProtectKernelModules": "no", "ProtectKernelTunables": "no", "ProtectProc": "default", "ProtectSystem": "no", "RefuseManualStart": "no", "RefuseManualStop": "no", "ReloadResult": "success", "RemainAfterExit": "no", "RemoveIPC": "no", "Requires": "dbus-broker.service sysinit.target system.slice polkit.service dbus.socket", "Restart": "no", "RestartKillSignal": "15", "RestartUSec": "100ms", "RestrictNamespaces": "no", "RestrictRealtime": "no", "RestrictSUIDSGID": "no", "Result": "success", "RootDirectoryStartOnly": "no", "RuntimeDirectoryMode": "0755", "RuntimeDirectoryPreserve": "no", "RuntimeMaxUSec": "infinity", "RuntimeRandomizedExtraUSec": "0", "SameProcessGroup": "no", "SecureBits": "0", "SendSIGHUP": "no", "SendSIGKILL": "yes", "Slice": "system.slice", "StandardError": "inherit", "StandardInput": "null", "StandardOutput": "journal", "StartLimitAction": "none", "StartLimitBurst": "5", "StartLimitIntervalUSec": "10s", "StartupBlockIOWeight": "[not set]", "StartupCPUShares": "[not set]", "StartupCPUWeight": "[not set]", "StartupIOWeight": "[not set]", "StateChangeTimestamp": "Mon 2022-06-06 23:37:25 EDT", "StateChangeTimestampMonotonic": "70903824", "StateDirectoryMode": "0755", "StatusErrno": "0", "StopWhenUnneeded": "no", "SubState": "running", "SuccessAction": "none", "SyslogFacility": "3", "SyslogLevel": "6", "SyslogLevelPrefix": "yes", "SyslogPriority": "30", "SystemCallErrorNumber": "2147483646", "TTYReset": "no", "TTYVHangup": "no", "TTYVTDisallocate": "no", "TasksAccounting": "yes", "TasksCurrent": "5", "TasksMax": "23420", "TimeoutAbortUSec": "1min 30s", "TimeoutCleanUSec": "infinity", "TimeoutStartFailureMode": "terminate", "TimeoutStartUSec": "1min 30s", "TimeoutStopFailureMode": "terminate", "TimeoutStopUSec": "1min 30s", "TimerSlackNSec": "50000", "Transient": "no", "Type": "dbus", "UID": "[not set]", "UMask": "0022", "UnitFilePreset": "enabled", "UnitFileState": "enabled", "UtmpMode": "init", "WantedBy": "multi-user.target", "WatchdogSignal": "6", "WatchdogTimestampMonotonic": "0", "WatchdogUSec": "0" } } TASK [linux-system-roles.mssql : Get the active Tuned profiles] **************** task path: /tmp/tmpajc2l7lu/tasks/main.yml:105 Tuesday 07 June 2022 03:37:59 +0000 (0:00:00.800) 0:00:09.634 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false, "cmd": [ "tuned-adm", "active" ], "delta": "0:00:00.098178", "end": "2022-06-06 23:38:00.009663", "rc": 0, "start": "2022-06-06 23:37:59.911485" } STDOUT: Current active profile: virtual-guest mssql TASK [linux-system-roles.mssql : Add mssql to the list of Tuned profiles] ****** task path: /tmp/tmpajc2l7lu/tasks/main.yml:115 Tuesday 07 June 2022 03:38:00 +0000 (0:00:00.478) 0:00:10.113 ********** skipping: [/cache/rhel-9.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Configure the Microsoft SQL Server Tools repository] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:145 Tuesday 07 June 2022 03:38:00 +0000 (0:00:00.048) 0:00:10.161 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false, "repo": "packages-microsoft-com-prod", "state": "present" } TASK [linux-system-roles.mssql : Ensure that SQL Server client tools are installed] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:152 Tuesday 07 June 2022 03:38:00 +0000 (0:00:00.375) 0:00:10.536 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false, "rc": 0, "results": [] } MSG: Nothing to do TASK [linux-system-roles.mssql : Prepare MSSQL and facts for logging in] ******* task path: /tmp/tmpajc2l7lu/tasks/main.yml:164 Tuesday 07 June 2022 03:38:01 +0000 (0:00:00.873) 0:00:11.410 ********** included: /tmp/tmpajc2l7lu/tasks/verify_password.yml for /cache/rhel-9.qcow2 TASK [linux-system-roles.mssql : Ensure that the mssql-server service is started] *** task path: /tmp/tmpajc2l7lu/tasks/verify_password.yml:1 Tuesday 07 June 2022 03:38:01 +0000 (0:00:00.066) 0:00:11.477 ********** fatal: [/cache/rhel-9.qcow2]: FAILED! => { "changed": false } MSG: Unable to start service mssql-server: Job for mssql-server.service failed because the control process exited with error code. See "systemctl status mssql-server.service" and "journalctl -xeu mssql-server.service" for details. PLAY RECAP ********************************************************************* /cache/rhel-9.qcow2 : ok=15 changed=0 unreachable=0 failed=1 skipped=3 rescued=0 ignored=0 Tuesday 07 June 2022 03:38:02 +0000 (0:00:00.497) 0:00:11.975 ********** =============================================================================== linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories --- 1.67s /tmp/tmpajc2l7lu/tasks/main.yml:30 -------------------------------------------- linux-system-roles.mssql : Gather system services facts ----------------- 1.63s /tmp/tmpajc2l7lu/tasks/main.yml:62 -------------------------------------------- set up internal repositories -------------------------------------------- 1.29s /cache/rhel-9_setup.yml:5 ----------------------------------------------------- linux-system-roles.mssql : Ensure that the Microsoft SQL Server package is installed --- 1.09s /tmp/tmpajc2l7lu/tasks/main.yml:42 -------------------------------------------- Gathering Facts --------------------------------------------------------- 0.97s /tmp/tmpajc2l7lu/tests/tests_input_sql_file.yml:3 ----------------------------- linux-system-roles.mssql : Ensure that the tuned-profiles-mssql package is installed --- 0.88s /tmp/tmpajc2l7lu/tasks/main.yml:94 -------------------------------------------- linux-system-roles.mssql : Ensure that SQL Server client tools are installed --- 0.87s /tmp/tmpajc2l7lu/tasks/main.yml:152 ------------------------------------------- linux-system-roles.mssql : Ensure that the tuned service is started and enabled --- 0.80s /tmp/tmpajc2l7lu/tasks/main.yml:99 -------------------------------------------- linux-system-roles.mssql : Check if the errorlog file exists and its location --- 0.59s /tmp/tmpajc2l7lu/tasks/main.yml:47 -------------------------------------------- linux-system-roles.mssql : Ensure that the mssql-server service is started --- 0.50s /tmp/tmpajc2l7lu/tasks/verify_password.yml:1 ---------------------------------- linux-system-roles.mssql : Get the active Tuned profiles ---------------- 0.48s /tmp/tmpajc2l7lu/tasks/main.yml:105 ------------------------------------------- linux-system-roles.mssql : Configure the Microsoft SQL Server 2019 repository --- 0.39s /tmp/tmpajc2l7lu/tasks/main.yml:35 -------------------------------------------- linux-system-roles.mssql : Configure the Microsoft SQL Server Tools repository --- 0.38s /tmp/tmpajc2l7lu/tasks/main.yml:145 ------------------------------------------- linux-system-roles.mssql : Set platform/version specific variables ------ 0.07s /tmp/tmpajc2l7lu/tasks/main.yml:3 --------------------------------------------- linux-system-roles.mssql : Prepare MSSQL and facts for logging in ------- 0.07s /tmp/tmpajc2l7lu/tasks/main.yml:164 ------------------------------------------- Set up MSSQL and input the sql file ------------------------------------- 0.06s /tmp/tmpajc2l7lu/tests/tests_input_sql_file.yml:10 ---------------------------- linux-system-roles.mssql : Verify that the variables required for setting up MSSQL are defined --- 0.06s /tmp/tmpajc2l7lu/tasks/main.yml:75 -------------------------------------------- linux-system-roles.mssql : Set up MSSQL --------------------------------- 0.06s /tmp/tmpajc2l7lu/tasks/main.yml:85 -------------------------------------------- linux-system-roles.mssql : Add mssql to the list of Tuned profiles ------ 0.05s /tmp/tmpajc2l7lu/tasks/main.yml:115 ------------------------------------------- linux-system-roles.mssql : Verify that the user accepts EULA variables --- 0.04s /tmp/tmpajc2l7lu/tasks/main.yml:18 -------------------------------------------- ansible-playbook 2.9.27 config file = /etc/ansible/ansible.cfg configured module search path = [u'/root/.ansible/plugins/modules', u'/usr/share/ansible/plugins/modules'] ansible python module location = /usr/lib/python2.7/site-packages/ansible executable location = /usr/bin/ansible-playbook python version = 2.7.5 (default, May 27 2022, 11:27:32) [GCC 4.8.5 20150623 (Red Hat 4.8.5-44)] 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: rhel-9_setup.yml ***************************************************** 1 plays in /cache/rhel-9_setup.yml PLAY [Setup repos] ************************************************************* META: ran handlers TASK [set up internal repositories] ******************************************** task path: /cache/rhel-9_setup.yml:5 Tuesday 07 June 2022 03:38:03 +0000 (0:00:00.022) 0:00:00.022 ********** ok: [/cache/rhel-9.qcow2] => (item=None) => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false } ok: [/cache/rhel-9.qcow2] => (item=None) => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false } ok: [/cache/rhel-9.qcow2] => (item=None) => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false } ok: [/cache/rhel-9.qcow2] => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false } META: ran handlers META: ran handlers PLAY RECAP ********************************************************************* /cache/rhel-9.qcow2 : ok=1 changed=0 unreachable=0 failed=0 skipped=0 rescued=0 ignored=0 Tuesday 07 June 2022 03:38:04 +0000 (0:00:01.194) 0:00:01.216 ********** =============================================================================== set up internal repositories -------------------------------------------- 1.19s /cache/rhel-9_setup.yml:5 ----------------------------------------------------- PLAYBOOK: tests_password.yml *************************************************** 1 plays in /tmp/tmpajc2l7lu/tests/tests_password.yml PLAY [Ensure that the role is idempotent when changing the sa user password] *** TASK [Gathering Facts] ********************************************************* task path: /tmp/tmpajc2l7lu/tests/tests_password.yml:3 Tuesday 07 June 2022 03:38:04 +0000 (0:00:00.016) 0:00:01.233 ********** ok: [/cache/rhel-9.qcow2] META: ran handlers TASK [Set up MSSQL] ************************************************************ task path: /tmp/tmpajc2l7lu/tests/tests_password.yml:10 Tuesday 07 June 2022 03:38:05 +0000 (0:00:00.939) 0:00:02.173 ********** TASK [linux-system-roles.mssql : Set platform/version specific variables] ****** task path: /tmp/tmpajc2l7lu/tasks/main.yml:3 Tuesday 07 June 2022 03:38:05 +0000 (0:00:00.065) 0:00:02.239 ********** ok: [/cache/rhel-9.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-2019/" }, "ansible_included_var_files": [ "/tmp/tmpajc2l7lu/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } ok: [/cache/rhel-9.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-2019/" }, "ansible_included_var_files": [ "/tmp/tmpajc2l7lu/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } skipping: [/cache/rhel-9.qcow2] => (item=RedHat_9.yml) => { "ansible_loop_var": "item", "changed": false, "item": "RedHat_9.yml", "skip_reason": "Conditional result was False" } skipping: [/cache/rhel-9.qcow2] => (item=RedHat_9.0.yml) => { "ansible_loop_var": "item", "changed": false, "item": "RedHat_9.0.yml", "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Verify that the user accepts EULA variables] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:18 Tuesday 07 June 2022 03:38:05 +0000 (0:00:00.070) 0:00:02.309 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false } MSG: All assertions passed TASK [linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:30 Tuesday 07 June 2022 03:38:05 +0000 (0:00:00.045) 0:00:02.354 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false } TASK [linux-system-roles.mssql : Configure the Microsoft SQL Server 2019 repository] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:35 Tuesday 07 June 2022 03:38:06 +0000 (0:00:00.686) 0:00:03.040 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false, "repo": "packages-microsoft-com-mssql-server-2019-gdr", "state": "present" } TASK [linux-system-roles.mssql : Ensure that the Microsoft SQL Server package is installed] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:42 Tuesday 07 June 2022 03:38:06 +0000 (0:00:00.391) 0:00:03.432 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false, "rc": 0, "results": [] } MSG: Nothing to do TASK [linux-system-roles.mssql : Check if the errorlog file exists and its location] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:47 Tuesday 07 June 2022 03:38:07 +0000 (0:00:01.046) 0:00:04.478 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false, "cmd": "set -euo pipefail\nerrorlog=\"$(/opt/mssql/bin/mssql-conf get filelocation errorlogfile 2>&1 \\\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.092466", "end": "2022-06-06 23:38:07.655554", "rc": 0, "start": "2022-06-06 23:38:07.563088" } TASK [linux-system-roles.mssql : Gather system services facts] ***************** task path: /tmp/tmpajc2l7lu/tasks/main.yml:62 Tuesday 07 June 2022 03:38:08 +0000 (0:00:00.583) 0:00:05.062 ********** ok: [/cache/rhel-9.qcow2] => { "ansible_facts": { "services": { "NetworkManager-dispatcher.service": { "name": "NetworkManager-dispatcher.service", "source": "systemd", "state": "inactive", "status": "enabled" }, "NetworkManager-wait-online.service": { "name": "NetworkManager-wait-online.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "NetworkManager.service": { "name": "NetworkManager.service", "source": "systemd", "state": "running", "status": "enabled" }, "auditd.service": { "name": "auditd.service", "source": "systemd", "state": "running", "status": "enabled" }, "auth-rpcgss-module.service": { "name": "auth-rpcgss-module.service", "source": "systemd", "state": "stopped", "status": "static" }, "autovt@.service": { "name": "autovt@.service", "source": "systemd", "state": "unknown", "status": "alias" }, "chrony-wait.service": { "name": "chrony-wait.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "chronyd.service": { "name": "chronyd.service", "source": "systemd", "state": "running", "status": "enabled" }, "cloud-config.service": { "name": "cloud-config.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "cloud-final.service": { "name": "cloud-final.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "cloud-init-local.service": { "name": "cloud-init-local.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "cloud-init.service": { "name": "cloud-init.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "cockpit-motd.service": { "name": "cockpit-motd.service", "source": "systemd", "state": "inactive", "status": "static" }, "cockpit-wsinstance-http.service": { "name": "cockpit-wsinstance-http.service", "source": "systemd", "state": "inactive", "status": "static" }, "cockpit-wsinstance-https-factory@.service": { "name": "cockpit-wsinstance-https-factory@.service", "source": "systemd", "state": "unknown", "status": "static" }, "cockpit-wsinstance-https@.service": { "name": "cockpit-wsinstance-https@.service", "source": "systemd", "state": "unknown", "status": "static" }, "cockpit.service": { "name": "cockpit.service", "source": "systemd", "state": "inactive", "status": "static" }, "console-getty.service": { "name": "console-getty.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "container-getty@.service": { "name": "container-getty@.service", "source": "systemd", "state": "unknown", "status": "static" }, "cpupower.service": { "name": "cpupower.service", "source": "systemd", "state": "stopped", "status": "disabled" }, "crond.service": { "name": "crond.service", "source": "systemd", "state": "running", "status": "enabled" }, "dbus-broker.service": { "name": "dbus-broker.service", "source": "systemd", "state": "running", "status": "enabled" }, "dbus-org.freedesktop.hostname1.service": { "name": "dbus-org.freedesktop.hostname1.service", "source": "systemd", "state": "inactive", "status": "alias" }, "dbus-org.freedesktop.locale1.service": { "name": "dbus-org.freedesktop.locale1.service", "source": "systemd", "state": "inactive", "status": "alias" }, "dbus-org.freedesktop.login1.service": { "name": "dbus-org.freedesktop.login1.service", "source": "systemd", "state": "active", "status": "alias" }, "dbus-org.freedesktop.nm-dispatcher.service": { "name": "dbus-org.freedesktop.nm-dispatcher.service", "source": "systemd", "state": "inactive", "status": "alias" }, "dbus-org.freedesktop.timedate1.service": { "name": "dbus-org.freedesktop.timedate1.service", "source": "systemd", "state": "inactive", "status": "alias" }, "dbus.service": { "name": "dbus.service", "source": "systemd", "state": "active", "status": "alias" }, "debug-shell.service": { "name": "debug-shell.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "dnf-makecache.service": { "name": "dnf-makecache.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-cmdline.service": { "name": "dracut-cmdline.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-initqueue.service": { "name": "dracut-initqueue.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-mount.service": { "name": "dracut-mount.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-pre-mount.service": { "name": "dracut-pre-mount.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-pre-pivot.service": { "name": "dracut-pre-pivot.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-pre-trigger.service": { "name": "dracut-pre-trigger.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-pre-udev.service": { "name": "dracut-pre-udev.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-shutdown-onfailure.service": { "name": "dracut-shutdown-onfailure.service", "source": "systemd", "state": "stopped", "status": "static" }, "dracut-shutdown.service": { "name": "dracut-shutdown.service", "source": "systemd", "state": "stopped", "status": "static" }, "emergency.service": { "name": "emergency.service", "source": "systemd", "state": "stopped", "status": "static" }, "fstrim.service": { "name": "fstrim.service", "source": "systemd", "state": "inactive", "status": "static" }, "fwupd-offline-update.service": { "name": "fwupd-offline-update.service", "source": "systemd", "state": "inactive", "status": "static" }, "fwupd-refresh.service": { "name": "fwupd-refresh.service", "source": "systemd", "state": "inactive", "status": "static" }, "fwupd.service": { "name": "fwupd.service", "source": "systemd", "state": "inactive", "status": "static" }, "getty@.service": { "name": "getty@.service", "source": "systemd", "state": "unknown", "status": "enabled" }, "getty@tty1.service": { "name": "getty@tty1.service", "source": "systemd", "state": "running", "status": "unknown" }, "grub-boot-indeterminate.service": { "name": "grub-boot-indeterminate.service", "source": "systemd", "state": "inactive", "status": "static" }, "grub2-systemd-integration.service": { "name": "grub2-systemd-integration.service", "source": "systemd", "state": "inactive", "status": "static" }, "gssproxy.service": { "name": "gssproxy.service", "source": "systemd", "state": "running", "status": "disabled" }, "initrd-cleanup.service": { "name": "initrd-cleanup.service", "source": "systemd", "state": "stopped", "status": "static" }, "initrd-parse-etc.service": { "name": "initrd-parse-etc.service", "source": "systemd", "state": "stopped", "status": "static" }, "initrd-switch-root.service": { "name": "initrd-switch-root.service", "source": "systemd", "state": "stopped", "status": "static" }, "initrd-udevadm-cleanup-db.service": { "name": "initrd-udevadm-cleanup-db.service", "source": "systemd", "state": "stopped", "status": "static" }, "insights-client-boot.service": { "name": "insights-client-boot.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "insights-client-results.service": { "name": "insights-client-results.service", "source": "systemd", "state": "inactive", "status": "static" }, "insights-client.service": { "name": "insights-client.service", "source": "systemd", "state": "inactive", "status": "static" }, "irqbalance.service": { "name": "irqbalance.service", "source": "systemd", "state": "running", "status": "enabled" }, "kdump.service": { "name": "kdump.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "kmod-static-nodes.service": { "name": "kmod-static-nodes.service", "source": "systemd", "state": "stopped", "status": "static" }, "kvm_stat.service": { "name": "kvm_stat.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "ldconfig.service": { "name": "ldconfig.service", "source": "systemd", "state": "stopped", "status": "static" }, "logrotate.service": { "name": "logrotate.service", "source": "systemd", "state": "stopped", "status": "static" }, "man-db-cache-update.service": { "name": "man-db-cache-update.service", "source": "systemd", "state": "inactive", "status": "static" }, "man-db-restart-cache-update.service": { "name": "man-db-restart-cache-update.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "microcode.service": { "name": "microcode.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "modprobe@.service": { "name": "modprobe@.service", "source": "systemd", "state": "unknown", "status": "static" }, "modprobe@configfs.service": { "name": "modprobe@configfs.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "modprobe@drm.service": { "name": "modprobe@drm.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "modprobe@fuse.service": { "name": "modprobe@fuse.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "mssql-server.service": { "name": "mssql-server.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "nfs-blkmap.service": { "name": "nfs-blkmap.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "nfs-idmapd.service": { "name": "nfs-idmapd.service", "source": "systemd", "state": "stopped", "status": "static" }, "nfs-mountd.service": { "name": "nfs-mountd.service", "source": "systemd", "state": "stopped", "status": "static" }, "nfs-server.service": { "name": "nfs-server.service", "source": "systemd", "state": "stopped", "status": "disabled" }, "nfs-utils.service": { "name": "nfs-utils.service", "source": "systemd", "state": "stopped", "status": "static" }, "nfsdcld.service": { "name": "nfsdcld.service", "source": "systemd", "state": "stopped", "status": "static" }, "nis-domainname.service": { "name": "nis-domainname.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "nm-priv-helper.service": { "name": "nm-priv-helper.service", "source": "systemd", "state": "inactive", "status": "static" }, "oddjobd.service": { "name": "oddjobd.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "packagekit-offline-update.service": { "name": "packagekit-offline-update.service", "source": "systemd", "state": "inactive", "status": "static" }, "packagekit.service": { "name": "packagekit.service", "source": "systemd", "state": "inactive", "status": "static" }, "pam_namespace.service": { "name": "pam_namespace.service", "source": "systemd", "state": "inactive", "status": "static" }, "polkit.service": { "name": "polkit.service", "source": "systemd", "state": "running", "status": "static" }, "qemu-guest-agent.service": { "name": "qemu-guest-agent.service", "source": "systemd", "state": "inactive", "status": "enabled" }, "quotaon.service": { "name": "quotaon.service", "source": "systemd", "state": "inactive", "status": "static" }, "rc-local.service": { "name": "rc-local.service", "source": "systemd", "state": "stopped", "status": "static" }, "rdisc.service": { "name": "rdisc.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "rescue.service": { "name": "rescue.service", "source": "systemd", "state": "stopped", "status": "static" }, "rhsm-facts.service": { "name": "rhsm-facts.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "rhsm.service": { "name": "rhsm.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "rhsmcertd.service": { "name": "rhsmcertd.service", "source": "systemd", "state": "running", "status": "enabled" }, "rpc-gssd.service": { "name": "rpc-gssd.service", "source": "systemd", "state": "stopped", "status": "static" }, "rpc-statd-notify.service": { "name": "rpc-statd-notify.service", "source": "systemd", "state": "stopped", "status": "static" }, "rpc-statd.service": { "name": "rpc-statd.service", "source": "systemd", "state": "stopped", "status": "static" }, "rpcbind.service": { "name": "rpcbind.service", "source": "systemd", "state": "running", "status": "enabled" }, "rpmdb-rebuild.service": { "name": "rpmdb-rebuild.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "rsyslog.service": { "name": "rsyslog.service", "source": "systemd", "state": "running", "status": "enabled" }, "saslauthd.service": { "name": "saslauthd.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "selinux-autorelabel-mark.service": { "name": "selinux-autorelabel-mark.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "selinux-autorelabel.service": { "name": "selinux-autorelabel.service", "source": "systemd", "state": "inactive", "status": "static" }, "serial-getty@.service": { "name": "serial-getty@.service", "source": "systemd", "state": "unknown", "status": "indirect" }, "serial-getty@ttyS0.service": { "name": "serial-getty@ttyS0.service", "source": "systemd", "state": "running", "status": "unknown" }, "sshd-keygen@.service": { "name": "sshd-keygen@.service", "source": "systemd", "state": "unknown", "status": "disabled" }, "sshd-keygen@ecdsa.service": { "name": "sshd-keygen@ecdsa.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "sshd-keygen@ed25519.service": { "name": "sshd-keygen@ed25519.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "sshd-keygen@rsa.service": { "name": "sshd-keygen@rsa.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "sshd.service": { "name": "sshd.service", "source": "systemd", "state": "running", "status": "enabled" }, "sshd@.service": { "name": "sshd@.service", "source": "systemd", "state": "unknown", "status": "static" }, "sssd-autofs.service": { "name": "sssd-autofs.service", "source": "systemd", "state": "inactive", "status": "indirect" }, "sssd-kcm.service": { "name": "sssd-kcm.service", "source": "systemd", "state": "stopped", "status": "indirect" }, "sssd-nss.service": { "name": "sssd-nss.service", "source": "systemd", "state": "inactive", "status": "indirect" }, "sssd-pac.service": { "name": "sssd-pac.service", "source": "systemd", "state": "inactive", "status": "indirect" }, "sssd-pam.service": { "name": "sssd-pam.service", "source": "systemd", "state": "inactive", "status": "indirect" }, "sssd-ssh.service": { "name": "sssd-ssh.service", "source": "systemd", "state": "inactive", "status": "indirect" }, "sssd-sudo.service": { "name": "sssd-sudo.service", "source": "systemd", "state": "inactive", "status": "indirect" }, "sssd.service": { "name": "sssd.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "system-update-cleanup.service": { "name": "system-update-cleanup.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-ask-password-console.service": { "name": "systemd-ask-password-console.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-ask-password-wall.service": { "name": "systemd-ask-password-wall.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-backlight@.service": { "name": "systemd-backlight@.service", "source": "systemd", "state": "unknown", "status": "static" }, "systemd-binfmt.service": { "name": "systemd-binfmt.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-boot-check-no-failures.service": { "name": "systemd-boot-check-no-failures.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "systemd-coredump@.service": { "name": "systemd-coredump@.service", "source": "systemd", "state": "unknown", "status": "static" }, "systemd-exit.service": { "name": "systemd-exit.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-firstboot.service": { "name": "systemd-firstboot.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-fsck-root.service": { "name": "systemd-fsck-root.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-fsck@.service": { "name": "systemd-fsck@.service", "source": "systemd", "state": "unknown", "status": "static" }, "systemd-fsck@dev-disk-by\\x2duuid-7B77\\x2d95E7.service": { "name": "systemd-fsck@dev-disk-by\\x2duuid-7B77\\x2d95E7.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "systemd-fsck@dev-vda2.service": { "name": "systemd-fsck@dev-vda2.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "systemd-halt.service": { "name": "systemd-halt.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-hibernate-resume@.service": { "name": "systemd-hibernate-resume@.service", "source": "systemd", "state": "unknown", "status": "static" }, "systemd-hibernate.service": { "name": "systemd-hibernate.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-hostnamed.service": { "name": "systemd-hostnamed.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-hwdb-update.service": { "name": "systemd-hwdb-update.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-hybrid-sleep.service": { "name": "systemd-hybrid-sleep.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-initctl.service": { "name": "systemd-initctl.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-journal-catalog-update.service": { "name": "systemd-journal-catalog-update.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-journal-flush.service": { "name": "systemd-journal-flush.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-journald.service": { "name": "systemd-journald.service", "source": "systemd", "state": "running", "status": "static" }, "systemd-journald@.service": { "name": "systemd-journald@.service", "source": "systemd", "state": "unknown", "status": "static" }, "systemd-kexec.service": { "name": "systemd-kexec.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-localed.service": { "name": "systemd-localed.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-logind.service": { "name": "systemd-logind.service", "source": "systemd", "state": "running", "status": "static" }, "systemd-machine-id-commit.service": { "name": "systemd-machine-id-commit.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-modules-load.service": { "name": "systemd-modules-load.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-network-generator.service": { "name": "systemd-network-generator.service", "source": "systemd", "state": "stopped", "status": "enabled" }, "systemd-poweroff.service": { "name": "systemd-poweroff.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-pstore.service": { "name": "systemd-pstore.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "systemd-quotacheck.service": { "name": "systemd-quotacheck.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-random-seed.service": { "name": "systemd-random-seed.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-reboot.service": { "name": "systemd-reboot.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-remount-fs.service": { "name": "systemd-remount-fs.service", "source": "systemd", "state": "stopped", "status": "enabled-runtime" }, "systemd-repart.service": { "name": "systemd-repart.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-rfkill.service": { "name": "systemd-rfkill.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-suspend-then-hibernate.service": { "name": "systemd-suspend-then-hibernate.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-suspend.service": { "name": "systemd-suspend.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-sysctl.service": { "name": "systemd-sysctl.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-sysext.service": { "name": "systemd-sysext.service", "source": "systemd", "state": "inactive", "status": "disabled" }, "systemd-sysusers.service": { "name": "systemd-sysusers.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-timedated.service": { "name": "systemd-timedated.service", "source": "systemd", "state": "inactive", "status": "static" }, "systemd-tmpfiles-clean.service": { "name": "systemd-tmpfiles-clean.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-tmpfiles-setup-dev.service": { "name": "systemd-tmpfiles-setup-dev.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-tmpfiles-setup.service": { "name": "systemd-tmpfiles-setup.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-udev-settle.service": { "name": "systemd-udev-settle.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-udev-trigger.service": { "name": "systemd-udev-trigger.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-udevd.service": { "name": "systemd-udevd.service", "source": "systemd", "state": "running", "status": "static" }, "systemd-update-done.service": { "name": "systemd-update-done.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-update-utmp-runlevel.service": { "name": "systemd-update-utmp-runlevel.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-update-utmp.service": { "name": "systemd-update-utmp.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-user-sessions.service": { "name": "systemd-user-sessions.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-vconsole-setup.service": { "name": "systemd-vconsole-setup.service", "source": "systemd", "state": "stopped", "status": "static" }, "systemd-volatile-root.service": { "name": "systemd-volatile-root.service", "source": "systemd", "state": "inactive", "status": "static" }, "teamd@.service": { "name": "teamd@.service", "source": "systemd", "state": "unknown", "status": "static" }, "tuned.service": { "name": "tuned.service", "source": "systemd", "state": "running", "status": "enabled" }, "user-runtime-dir@.service": { "name": "user-runtime-dir@.service", "source": "systemd", "state": "unknown", "status": "static" }, "user-runtime-dir@0.service": { "name": "user-runtime-dir@0.service", "source": "systemd", "state": "stopped", "status": "unknown" }, "user@.service": { "name": "user@.service", "source": "systemd", "state": "unknown", "status": "static" }, "user@0.service": { "name": "user@0.service", "source": "systemd", "state": "running", "status": "unknown" } } }, "changed": false } TASK [linux-system-roles.mssql : Verify that the variables required for setting up MSSQL are defined] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:75 Tuesday 07 June 2022 03:38:09 +0000 (0:00:01.605) 0:00:06.667 ********** skipping: [/cache/rhel-9.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Set up MSSQL] ********************************* task path: /tmp/tmpajc2l7lu/tasks/main.yml:85 Tuesday 07 June 2022 03:38:09 +0000 (0:00:00.052) 0:00:06.720 ********** skipping: [/cache/rhel-9.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Ensure that the tuned-profiles-mssql package is installed] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:94 Tuesday 07 June 2022 03:38:09 +0000 (0:00:00.051) 0:00:06.772 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false, "rc": 0, "results": [] } MSG: Nothing to do TASK [linux-system-roles.mssql : Ensure that the tuned service is started and enabled] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:99 Tuesday 07 June 2022 03:38:10 +0000 (0:00:00.864) 0:00:07.637 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false, "enabled": true, "name": "tuned", "state": "started", "status": { "ActiveEnterTimestamp": "Mon 2022-06-06 23:36:20 EDT", "ActiveEnterTimestampMonotonic": "5094434", "ActiveExitTimestampMonotonic": "0", "ActiveState": "active", "After": "dbus-broker.service sysinit.target basic.target network.target systemd-sysctl.service system.slice systemd-journald.socket dbus.socket", "AllowIsolate": "no", "AssertResult": "yes", "AssertTimestamp": "Mon 2022-06-06 23:36:19 EDT", "AssertTimestampMonotonic": "4792291", "Before": "shutdown.target multi-user.target", "BlockIOAccounting": "no", "BlockIOWeight": "[not set]", "BusName": "com.redhat.tuned", "CPUAccounting": "yes", "CPUAffinityFromNUMA": "no", "CPUQuotaPerSecUSec": "infinity", "CPUQuotaPeriodUSec": "infinity", "CPUSchedulingPolicy": "0", "CPUSchedulingPriority": "0", "CPUSchedulingResetOnFork": "no", "CPUShares": "[not set]", "CPUUsageNSec": "879296000", "CPUWeight": "[not set]", "CacheDirectoryMode": "0755", "CanFreeze": "yes", "CanIsolate": "no", "CanReload": "no", "CanStart": "yes", "CanStop": "yes", "CapabilityBoundingSet": "cap_chown cap_dac_override cap_dac_read_search cap_fowner cap_fsetid cap_kill cap_setgid cap_setuid cap_setpcap cap_linux_immutable cap_net_bind_service cap_net_broadcast cap_net_admin cap_net_raw cap_ipc_lock cap_ipc_owner cap_sys_module cap_sys_rawio cap_sys_chroot cap_sys_ptrace cap_sys_pacct cap_sys_admin cap_sys_boot cap_sys_nice cap_sys_resource cap_sys_time cap_sys_tty_config cap_mknod cap_lease cap_audit_write cap_audit_control cap_setfcap cap_mac_override cap_mac_admin cap_syslog cap_wake_alarm cap_block_suspend cap_audit_read cap_perfmon cap_bpf cap_checkpoint_restore", "CleanResult": "success", "CollectMode": "inactive", "ConditionResult": "yes", "ConditionTimestamp": "Mon 2022-06-06 23:36:19 EDT", "ConditionTimestampMonotonic": "4792290", "ConfigurationDirectoryMode": "0755", "Conflicts": "shutdown.target cpupower.service", "ControlGroup": "/system.slice/tuned.service", "ControlPID": "0", "CoredumpFilter": "0x33", "DefaultDependencies": "yes", "DefaultMemoryLow": "0", "DefaultMemoryMin": "0", "Delegate": "no", "Description": "Dynamic System Tuning Daemon", "DevicePolicy": "auto", "Documentation": "\"man:tuned(8)\" \"man:tuned.conf(5)\" \"man:tuned-adm(8)\"", "DynamicUser": "no", "ExecMainCode": "0", "ExecMainExitTimestampMonotonic": "0", "ExecMainPID": "761", "ExecMainStartTimestamp": "Mon 2022-06-06 23:36:19 EDT", "ExecMainStartTimestampMonotonic": "4793223", "ExecMainStatus": "0", "ExecStart": "{ path=/usr/sbin/tuned ; argv[]=/usr/sbin/tuned -l -P ; ignore_errors=no ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }", "ExecStartEx": "{ path=/usr/sbin/tuned ; argv[]=/usr/sbin/tuned -l -P ; flags= ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }", "ExitType": "main", "FailureAction": "none", "FileDescriptorStoreMax": "0", "FinalKillSignal": "9", "FragmentPath": "/usr/lib/systemd/system/tuned.service", "FreezerState": "running", "GID": "[not set]", "GuessMainPID": "yes", "IOAccounting": "no", "IOReadBytes": "18446744073709551615", "IOReadOperations": "18446744073709551615", "IOSchedulingClass": "2", "IOSchedulingPriority": "4", "IOWeight": "[not set]", "IOWriteBytes": "18446744073709551615", "IOWriteOperations": "18446744073709551615", "IPAccounting": "no", "IPEgressBytes": "[no data]", "IPEgressPackets": "[no data]", "IPIngressBytes": "[no data]", "IPIngressPackets": "[no data]", "Id": "tuned.service", "IgnoreOnIsolate": "no", "IgnoreSIGPIPE": "yes", "InactiveEnterTimestampMonotonic": "0", "InactiveExitTimestamp": "Mon 2022-06-06 23:36:19 EDT", "InactiveExitTimestampMonotonic": "4793389", "InvocationID": "9bf42224ef6f463095183b8de6dd523a", "JobRunningTimeoutUSec": "infinity", "JobTimeoutAction": "none", "JobTimeoutUSec": "infinity", "KeyringMode": "private", "KillMode": "control-group", "KillSignal": "15", "LimitAS": "infinity", "LimitASSoft": "infinity", "LimitCORE": "infinity", "LimitCORESoft": "0", "LimitCPU": "infinity", "LimitCPUSoft": "infinity", "LimitDATA": "infinity", "LimitDATASoft": "infinity", "LimitFSIZE": "infinity", "LimitFSIZESoft": "infinity", "LimitLOCKS": "infinity", "LimitLOCKSSoft": "infinity", "LimitMEMLOCK": "65536", "LimitMEMLOCKSoft": "65536", "LimitMSGQUEUE": "819200", "LimitMSGQUEUESoft": "819200", "LimitNICE": "0", "LimitNICESoft": "0", "LimitNOFILE": "524288", "LimitNOFILESoft": "1024", "LimitNPROC": "14637", "LimitNPROCSoft": "14637", "LimitRSS": "infinity", "LimitRSSSoft": "infinity", "LimitRTPRIO": "0", "LimitRTPRIOSoft": "0", "LimitRTTIME": "infinity", "LimitRTTIMESoft": "infinity", "LimitSIGPENDING": "14637", "LimitSIGPENDINGSoft": "14637", "LimitSTACK": "infinity", "LimitSTACKSoft": "8388608", "LoadState": "loaded", "LockPersonality": "no", "LogLevelMax": "-1", "LogRateLimitBurst": "0", "LogRateLimitIntervalUSec": "0", "LogsDirectoryMode": "0755", "MainPID": "761", "ManagedOOMMemoryPressure": "auto", "ManagedOOMMemoryPressureLimit": "0", "ManagedOOMPreference": "none", "ManagedOOMSwap": "auto", "MemoryAccounting": "yes", "MemoryAvailable": "infinity", "MemoryCurrent": "18976768", "MemoryDenyWriteExecute": "no", "MemoryHigh": "infinity", "MemoryLimit": "infinity", "MemoryLow": "0", "MemoryMax": "infinity", "MemoryMin": "0", "MemorySwapMax": "infinity", "MountAPIVFS": "no", "NFileDescriptorStore": "0", "NRestarts": "0", "NUMAPolicy": "n/a", "Names": "tuned.service", "NeedDaemonReload": "no", "Nice": "0", "NoNewPrivileges": "no", "NonBlocking": "no", "NotifyAccess": "none", "OOMPolicy": "stop", "OOMScoreAdjust": "0", "OnFailureJobMode": "replace", "OnSuccessJobMode": "fail", "PIDFile": "/run/tuned/tuned.pid", "Perpetual": "no", "PrivateDevices": "no", "PrivateIPC": "no", "PrivateMounts": "no", "PrivateNetwork": "no", "PrivateTmp": "no", "PrivateUsers": "no", "ProcSubset": "all", "ProtectClock": "no", "ProtectControlGroups": "no", "ProtectHome": "no", "ProtectHostname": "no", "ProtectKernelLogs": "no", "ProtectKernelModules": "no", "ProtectKernelTunables": "no", "ProtectProc": "default", "ProtectSystem": "no", "RefuseManualStart": "no", "RefuseManualStop": "no", "ReloadResult": "success", "RemainAfterExit": "no", "RemoveIPC": "no", "Requires": "dbus-broker.service sysinit.target system.slice polkit.service dbus.socket", "Restart": "no", "RestartKillSignal": "15", "RestartUSec": "100ms", "RestrictNamespaces": "no", "RestrictRealtime": "no", "RestrictSUIDSGID": "no", "Result": "success", "RootDirectoryStartOnly": "no", "RuntimeDirectoryMode": "0755", "RuntimeDirectoryPreserve": "no", "RuntimeMaxUSec": "infinity", "RuntimeRandomizedExtraUSec": "0", "SameProcessGroup": "no", "SecureBits": "0", "SendSIGHUP": "no", "SendSIGKILL": "yes", "Slice": "system.slice", "StandardError": "inherit", "StandardInput": "null", "StandardOutput": "journal", "StartLimitAction": "none", "StartLimitBurst": "5", "StartLimitIntervalUSec": "10s", "StartupBlockIOWeight": "[not set]", "StartupCPUShares": "[not set]", "StartupCPUWeight": "[not set]", "StartupIOWeight": "[not set]", "StateChangeTimestamp": "Mon 2022-06-06 23:37:25 EDT", "StateChangeTimestampMonotonic": "70903824", "StateDirectoryMode": "0755", "StatusErrno": "0", "StopWhenUnneeded": "no", "SubState": "running", "SuccessAction": "none", "SyslogFacility": "3", "SyslogLevel": "6", "SyslogLevelPrefix": "yes", "SyslogPriority": "30", "SystemCallErrorNumber": "2147483646", "TTYReset": "no", "TTYVHangup": "no", "TTYVTDisallocate": "no", "TasksAccounting": "yes", "TasksCurrent": "5", "TasksMax": "23420", "TimeoutAbortUSec": "1min 30s", "TimeoutCleanUSec": "infinity", "TimeoutStartFailureMode": "terminate", "TimeoutStartUSec": "1min 30s", "TimeoutStopFailureMode": "terminate", "TimeoutStopUSec": "1min 30s", "TimerSlackNSec": "50000", "Transient": "no", "Type": "dbus", "UID": "[not set]", "UMask": "0022", "UnitFilePreset": "enabled", "UnitFileState": "enabled", "UtmpMode": "init", "WantedBy": "multi-user.target", "WatchdogSignal": "6", "WatchdogTimestampMonotonic": "0", "WatchdogUSec": "0" } } TASK [linux-system-roles.mssql : Get the active Tuned profiles] **************** task path: /tmp/tmpajc2l7lu/tasks/main.yml:105 Tuesday 07 June 2022 03:38:11 +0000 (0:00:00.793) 0:00:08.430 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false, "cmd": [ "tuned-adm", "active" ], "delta": "0:00:00.100225", "end": "2022-06-06 23:38:11.473262", "rc": 0, "start": "2022-06-06 23:38:11.373037" } STDOUT: Current active profile: virtual-guest mssql TASK [linux-system-roles.mssql : Add mssql to the list of Tuned profiles] ****** task path: /tmp/tmpajc2l7lu/tasks/main.yml:115 Tuesday 07 June 2022 03:38:11 +0000 (0:00:00.454) 0:00:08.885 ********** skipping: [/cache/rhel-9.qcow2] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [linux-system-roles.mssql : Configure the Microsoft SQL Server Tools repository] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:145 Tuesday 07 June 2022 03:38:11 +0000 (0:00:00.047) 0:00:08.933 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false, "repo": "packages-microsoft-com-prod", "state": "present" } TASK [linux-system-roles.mssql : Ensure that SQL Server client tools are installed] *** task path: /tmp/tmpajc2l7lu/tasks/main.yml:152 Tuesday 07 June 2022 03:38:12 +0000 (0:00:00.391) 0:00:09.324 ********** ok: [/cache/rhel-9.qcow2] => { "changed": false, "rc": 0, "results": [] } MSG: Nothing to do TASK [linux-system-roles.mssql : Prepare MSSQL and facts for logging in] ******* task path: /tmp/tmpajc2l7lu/tasks/main.yml:164 Tuesday 07 June 2022 03:38:13 +0000 (0:00:00.826) 0:00:10.150 ********** included: /tmp/tmpajc2l7lu/tasks/verify_password.yml for /cache/rhel-9.qcow2 TASK [linux-system-roles.mssql : Ensure that the mssql-server service is started] *** task path: /tmp/tmpajc2l7lu/tasks/verify_password.yml:1 Tuesday 07 June 2022 03:38:13 +0000 (0:00:00.067) 0:00:10.218 ********** fatal: [/cache/rhel-9.qcow2]: FAILED! => { "changed": false } MSG: Unable to start service mssql-server: Job for mssql-server.service failed because the control process exited with error code. See "systemctl status mssql-server.service" and "journalctl -xeu mssql-server.service" for details. PLAY RECAP ********************************************************************* /cache/rhel-9.qcow2 : ok=15 changed=0 unreachable=0 failed=1 skipped=3 rescued=0 ignored=0 Tuesday 07 June 2022 03:38:13 +0000 (0:00:00.503) 0:00:10.721 ********** =============================================================================== linux-system-roles.mssql : Gather system services facts ----------------- 1.61s /tmp/tmpajc2l7lu/tasks/main.yml:62 -------------------------------------------- set up internal repositories -------------------------------------------- 1.19s /cache/rhel-9_setup.yml:5 ----------------------------------------------------- linux-system-roles.mssql : Ensure that the Microsoft SQL Server package is installed --- 1.05s /tmp/tmpajc2l7lu/tasks/main.yml:42 -------------------------------------------- Gathering Facts --------------------------------------------------------- 0.94s /tmp/tmpajc2l7lu/tests/tests_password.yml:3 ----------------------------------- linux-system-roles.mssql : Ensure that the tuned-profiles-mssql package is installed --- 0.86s /tmp/tmpajc2l7lu/tasks/main.yml:94 -------------------------------------------- linux-system-roles.mssql : Ensure that SQL Server client tools are installed --- 0.83s /tmp/tmpajc2l7lu/tasks/main.yml:152 ------------------------------------------- linux-system-roles.mssql : Ensure that the tuned service is started and enabled --- 0.79s /tmp/tmpajc2l7lu/tasks/main.yml:99 -------------------------------------------- linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories --- 0.69s /tmp/tmpajc2l7lu/tasks/main.yml:30 -------------------------------------------- linux-system-roles.mssql : Check if the errorlog file exists and its location --- 0.58s /tmp/tmpajc2l7lu/tasks/main.yml:47 -------------------------------------------- linux-system-roles.mssql : Ensure that the mssql-server service is started --- 0.50s /tmp/tmpajc2l7lu/tasks/verify_password.yml:1 ---------------------------------- linux-system-roles.mssql : Get the active Tuned profiles ---------------- 0.45s /tmp/tmpajc2l7lu/tasks/main.yml:105 ------------------------------------------- linux-system-roles.mssql : Configure the Microsoft SQL Server 2019 repository --- 0.39s /tmp/tmpajc2l7lu/tasks/main.yml:35 -------------------------------------------- linux-system-roles.mssql : Configure the Microsoft SQL Server Tools repository --- 0.39s /tmp/tmpajc2l7lu/tasks/main.yml:145 ------------------------------------------- linux-system-roles.mssql : Set platform/version specific variables ------ 0.07s /tmp/tmpajc2l7lu/tasks/main.yml:3 --------------------------------------------- linux-system-roles.mssql : Prepare MSSQL and facts for logging in ------- 0.07s /tmp/tmpajc2l7lu/tasks/main.yml:164 ------------------------------------------- Set up MSSQL ------------------------------------------------------------ 0.07s /tmp/tmpajc2l7lu/tests/tests_password.yml:10 ---------------------------------- linux-system-roles.mssql : Verify that the variables required for setting up MSSQL are defined --- 0.05s /tmp/tmpajc2l7lu/tasks/main.yml:75 -------------------------------------------- linux-system-roles.mssql : Set up MSSQL --------------------------------- 0.05s /tmp/tmpajc2l7lu/tasks/main.yml:85 -------------------------------------------- linux-system-roles.mssql : Add mssql to the list of Tuned profiles ------ 0.05s /tmp/tmpajc2l7lu/tasks/main.yml:115 ------------------------------------------- linux-system-roles.mssql : Verify that the user accepts EULA variables --- 0.05s /tmp/tmpajc2l7lu/tasks/main.yml:18 -------------------------------------------- Testing /tmp/tmpg9008n_5/tests/tests_accept_eula.yml...SUCCESS Testing /tmp/tmpg9008n_5/tests/tests_default.yml...SUCCESS Testing /tmp/tmpg9008n_5/tests/tests_idempotency.yml...FAILURE Testing /tmp/tmpg9008n_5/tests/tests_include_vars_from_parent.yml...FAILURE Testing /tmp/tmpg9008n_5/tests/tests_input_sql_file.yml...FAILURE Testing /tmp/tmpg9008n_5/tests/tests_password.yml...FAILURE Testing /tmp/tmp3bi54b00/tests/tests_accept_eula_2019.yml...SUCCESS Testing /tmp/tmp3bi54b00/tests/tests_configure_ha_cluster.yml...FAILURE Testing /tmp/tmp3bi54b00/tests/tests_default_2019.yml...SUCCESS Testing /tmp/tmp3bi54b00/tests/tests_idempotency_2017.yml...FAILURE Testing /tmp/tmp3bi54b00/tests/tests_idempotency_2019.yml...FAILURE Testing /tmp/tmp3bi54b00/tests/tests_include_vars_from_parent_2019.yml...FAILURE Testing /tmp/tmp3bi54b00/tests/tests_input_sql_file_2019.yml...FAILURE Testing /tmp/tmp3bi54b00/tests/tests_password_2017.yml...FAILURE Testing /tmp/tmp3bi54b00/tests/tests_password_2019.yml...FAILURE Testing /tmp/tmp3bi54b00/tests/tests_powershell_2019.yml...FAILURE Testing /tmp/tmp3bi54b00/tests/tests_tls_2019.yml...FAILURE Testing /tmp/tmp3bi54b00/tests/tests_upgrade_2017.yml...FAILURE Testing /tmp/tmpajc2l7lu/tests/tests_accept_eula.yml...SUCCESS Testing /tmp/tmpajc2l7lu/tests/tests_default.yml...SUCCESS Testing /tmp/tmpajc2l7lu/tests/tests_idempotency.yml...FAILURE Testing /tmp/tmpajc2l7lu/tests/tests_include_vars_from_parent.yml...FAILURE Testing /tmp/tmpajc2l7lu/tests/tests_input_sql_file.yml...FAILURE Testing /tmp/tmpajc2l7lu/tests/tests_password.yml...FAILURE FAILURE