+ cd /tmp/tmpvilyw6yi/tests; TEST_SUBJECTS=/cache/rhel-x.qcow2 TEST_ARTIFACTS=/tmp/linux-system-role-test-work-pull-linux-system-roles_mssql-12-b2c28c3-rhel-x-8fj1lawe/artifacts ANSIBLE_COLLECTIONS_PATHS=/tmp/tmphha6j_7z:~/.ansible/collections:/usr/share/ansible/collections ansible-playbook -vv --inventory=/usr/share/ansible/inventory/standard-inventory-qcow2 --skip-tags=tests::cleanup,tests::nvme /tmp/tmpvilyw6yi/_setup.yml /tmp/tmpvilyw6yi/tests/tests_accept_eula.yml ansible-playbook [core 2.12.0.post0] config file = None configured module search path = ['/home/runner/.ansible/plugins/modules', '/usr/share/ansible/plugins/modules'] ansible python module location = /usr/local/lib/python3.8/site-packages/ansible ansible collection location = /tmp/tmphha6j_7z:/home/runner/.ansible/collections:/usr/share/ansible/collections executable location = /usr/local/bin/ansible-playbook python version = 3.8.8 (default, Aug 25 2021, 16:13:02) [GCC 8.5.0 20210514 (Red Hat 8.5.0-3)] jinja version = 2.10.3 libyaml = True No config file found; using defaults Skipping callback 'default', as we already have a stdout callback. Skipping callback 'minimal', as we already have a stdout callback. Skipping callback 'oneline', as we already have a stdout callback. PLAYBOOK: _setup.yml *********************************************************** 2 plays in /tmp/tmpvilyw6yi/_setup.yml PLAY [Fail when only localhost is available] *********************************** META: ran handlers TASK [debug] ******************************************************************* task path: /tmp/tmpvilyw6yi/_setup.yml:5 ok: [/cache/rhel-x.qcow2] => { "groups": { "all": [ "/cache/rhel-x.qcow2" ], "localhost": [ "/cache/rhel-x.qcow2" ], "subjects": [ "/cache/rhel-x.qcow2" ], "ungrouped": [] } } TASK [fail] ******************************************************************** task path: /tmp/tmpvilyw6yi/_setup.yml:6 skipping: [/cache/rhel-x.qcow2] => {"changed": false, "skip_reason": "Conditional result was False"} META: ran handlers META: ran handlers PLAY [Setup repos] ************************************************************* META: ran handlers TASK [set up internal repositories] ******************************************** task path: /tmp/tmpvilyw6yi/_setup.yml:13 changed: [/cache/rhel-x.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-x.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-x.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-x.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-x.qcow2 : ok=2 changed=1 unreachable=0 failed=0 skipped=1 rescued=0 ignored=0 PLAYBOOK: tests_accept_eula.yml ************************************************ 1 plays in /tmp/tmpvilyw6yi/tests/tests_accept_eula.yml PLAY [Ensure that the role runs when EULA are accepted] ************************ TASK [Gathering Facts] ********************************************************* task path: /tmp/tmpvilyw6yi/tests/tests_accept_eula.yml:3 ok: [/cache/rhel-x.qcow2] META: ran handlers TASK [Run the role with default parameters] ************************************ task path: /tmp/tmpvilyw6yi/tests/tests_accept_eula.yml:12 TASK [linux-system-roles.mssql : Set platform/version specific variables] ****** task path: /tmp/tmpvilyw6yi/tasks/main.yml:3 ok: [/cache/rhel-x.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/tmpvilyw6yi/vars/RedHat.yml"], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml"} ok: [/cache/rhel-x.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/tmpvilyw6yi/vars/RedHat.yml"], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml"} skipping: [/cache/rhel-x.qcow2] => (item=RedHat_9.yml) => {"ansible_loop_var": "item", "changed": false, "item": "RedHat_9.yml", "skip_reason": "Conditional result was False"} skipping: [/cache/rhel-x.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/tmpvilyw6yi/tasks/main.yml:18 ok: [/cache/rhel-x.qcow2] => { "changed": false, "msg": "All assertions passed" } TASK [linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories] *** task path: /tmp/tmpvilyw6yi/tasks/main.yml:30 changed: [/cache/rhel-x.qcow2] => {"changed": true} TASK [linux-system-roles.mssql : Configure the Microsoft SQL Server 2019 repository] *** task path: /tmp/tmpvilyw6yi/tasks/main.yml:35 changed: [/cache/rhel-x.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/tmpvilyw6yi/tasks/main.yml:42 changed: [/cache/rhel-x.qcow2] => {"changed": true, "msg": "", "rc": 0, "results": ["Installed: source-highlight-3.1.9-11.el9.x86_64", "Installed: libipt-2.0.4-5.el9.x86_64", "Installed: libbabeltrace-1.5.8-8.el9.x86_64", "Installed: mssql-server-15.0.4178.1-3.x86_64", "Installed: libatomic-11.2.1-6.el9.x86_64", "Installed: elfutils-debuginfod-client-0.185-5.el9.x86_64", "Installed: cyrus-sasl-2.1.27-17.el9.x86_64", "Installed: libicu-67.1-9.el9.x86_64", "Installed: cyrus-sasl-gssapi-2.1.27-17.el9.x86_64", "Installed: gdb-10.2-9.el9.x86_64", "Installed: boost-regex-1.75.0-6.el9.x86_64", "Installed: gdb-headless-10.2-9.el9.x86_64"]} TASK [linux-system-roles.mssql : Check if the errorlog file exists and its location] *** task path: /tmp/tmpvilyw6yi/tasks/main.yml:47 ok: [/cache/rhel-x.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.062358", "end": "2021-11-17 21:15:47.424755", "msg": "", "rc": 0, "start": "2021-11-17 21:15:47.362397", "stderr": "", "stderr_lines": [], "stdout": "", "stdout_lines": []} TASK [linux-system-roles.mssql : Gather system services facts] ***************** task path: /tmp/tmpvilyw6yi/tasks/main.yml:62 ok: [/cache/rhel-x.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"}, "autofs.service": {"name": "autofs.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "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-redirect.service": {"name": "cockpit-wsinstance-http-redirect.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": "inactive", "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"}, "display-manager.service": {"name": "display-manager.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "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.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": "active"}, "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": "inactive"}, "modprobe@drm.service": {"name": "modprobe@drm.service", "source": "systemd", "state": "stopped", "status": "inactive"}, "modprobe@fuse.service": {"name": "modprobe@fuse.service", "source": "systemd", "state": "stopped", "status": "inactive"}, "mssql-server.service": {"name": "mssql-server.service", "source": "systemd", "state": "inactive", "status": "disabled"}, "network.service": {"name": "network.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "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-sudo.service": {"name": "nm-sudo.service", "source": "systemd", "state": "inactive", "status": "disabled"}, "ntpd.service": {"name": "ntpd.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "ntpdate.service": {"name": "ntpdate.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "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"}, "plymouth-quit-wait.service": {"name": "plymouth-quit-wait.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "plymouth-start.service": {"name": "plymouth-start.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "polkit.service": {"name": "polkit.service", "source": "systemd", "state": "inactive", "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"}, "rpc-svcgssd.service": {"name": "rpc-svcgssd.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "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-rc70d1d75583f4ecebd58a492cfae0e46.service": {"name": "run-rc70d1d75583f4ecebd58a492cfae0e46.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": "active"}, "sntp.service": {"name": "sntp.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "sshd-keygen.service": {"name": "sshd-keygen.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "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": "inactive"}, "sshd-keygen@ed25519.service": {"name": "sshd-keygen@ed25519.service", "source": "systemd", "state": "stopped", "status": "inactive"}, "sshd-keygen@rsa.service": {"name": "sshd-keygen@rsa.service", "source": "systemd", "state": "stopped", "status": "inactive"}, "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"}, "syslog.service": {"name": "syslog.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "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": "active"}, "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-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-timesyncd.service": {"name": "systemd-timesyncd.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "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"}, "unbound-anchor.service": {"name": "unbound-anchor.service", "source": "systemd", "state": "stopped", "status": "static"}, "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": "active"}, "user@.service": {"name": "user@.service", "source": "systemd", "state": "unknown", "status": "static"}, "user@0.service": {"name": "user@0.service", "source": "systemd", "state": "running", "status": "active"}, "ypbind.service": {"name": "ypbind.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "yppasswdd.service": {"name": "yppasswdd.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "ypserv.service": {"name": "ypserv.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "ypxfrd.service": {"name": "ypxfrd.service", "source": "systemd", "state": "stopped", "status": "not-found"}}}, "changed": false} TASK [linux-system-roles.mssql : Verify that the variables required for setting up MSSQL are defined] *** task path: /tmp/tmpvilyw6yi/tasks/main.yml:75 fatal: [/cache/rhel-x.qcow2]: FAILED! => { "assertion": "mssql_password is not none", "changed": false, "evaluated_to": false, "msg": [ "You must define the following variables to set up MSSQL:", "mssql_password", "mssql_edition" ] } TASK [Assert that the role failed with variables undefined] ******************** task path: /tmp/tmpvilyw6yi/tests/tests_accept_eula.yml:21 ok: [/cache/rhel-x.qcow2] => { "changed": false, "msg": "All assertions passed" } META: ran handlers META: ran handlers PLAY RECAP ********************************************************************* /cache/rhel-x.qcow2 : ok=11 changed=4 unreachable=0 failed=0 skipped=1 rescued=1 ignored=0 + cd /tmp/tmpvilyw6yi/tests; TEST_SUBJECTS=/cache/rhel-x.qcow2 TEST_ARTIFACTS=/tmp/linux-system-role-test-work-pull-linux-system-roles_mssql-12-b2c28c3-rhel-x-8fj1lawe/artifacts ANSIBLE_COLLECTIONS_PATHS=/tmp/tmphha6j_7z:~/.ansible/collections:/usr/share/ansible/collections ansible-playbook -vv --inventory=/usr/share/ansible/inventory/standard-inventory-qcow2 --skip-tags=tests::cleanup,tests::nvme /tmp/tmpvilyw6yi/_setup.yml /tmp/tmpvilyw6yi/tests/tests_default.yml ansible-playbook [core 2.12.0.post0] config file = None configured module search path = ['/home/runner/.ansible/plugins/modules', '/usr/share/ansible/plugins/modules'] ansible python module location = /usr/local/lib/python3.8/site-packages/ansible ansible collection location = /tmp/tmphha6j_7z:/home/runner/.ansible/collections:/usr/share/ansible/collections executable location = /usr/local/bin/ansible-playbook python version = 3.8.8 (default, Aug 25 2021, 16:13:02) [GCC 8.5.0 20210514 (Red Hat 8.5.0-3)] jinja version = 2.10.3 libyaml = True No config file found; using defaults Skipping callback 'default', as we already have a stdout callback. Skipping callback 'minimal', as we already have a stdout callback. Skipping callback 'oneline', as we already have a stdout callback. PLAYBOOK: _setup.yml *********************************************************** 2 plays in /tmp/tmpvilyw6yi/_setup.yml PLAY [Fail when only localhost is available] *********************************** META: ran handlers TASK [debug] ******************************************************************* task path: /tmp/tmpvilyw6yi/_setup.yml:5 ok: [/cache/rhel-x.qcow2] => { "groups": { "all": [ "/cache/rhel-x.qcow2" ], "localhost": [ "/cache/rhel-x.qcow2" ], "subjects": [ "/cache/rhel-x.qcow2" ], "ungrouped": [] } } TASK [fail] ******************************************************************** task path: /tmp/tmpvilyw6yi/_setup.yml:6 skipping: [/cache/rhel-x.qcow2] => {"changed": false, "skip_reason": "Conditional result was False"} META: ran handlers META: ran handlers PLAY [Setup repos] ************************************************************* META: ran handlers TASK [set up internal repositories] ******************************************** task path: /tmp/tmpvilyw6yi/_setup.yml:13 changed: [/cache/rhel-x.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-x.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-x.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-x.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-x.qcow2 : ok=2 changed=1 unreachable=0 failed=0 skipped=1 rescued=0 ignored=0 PLAYBOOK: tests_default.yml **************************************************** 1 plays in /tmp/tmpvilyw6yi/tests/tests_default.yml PLAY [Ensure that the role runs with default parameters] *********************** TASK [Gathering Facts] ********************************************************* task path: /tmp/tmpvilyw6yi/tests/tests_default.yml:3 ok: [/cache/rhel-x.qcow2] META: ran handlers TASK [Run the role with default parameters] ************************************ task path: /tmp/tmpvilyw6yi/tests/tests_default.yml:8 TASK [linux-system-roles.mssql : Set platform/version specific variables] ****** task path: /tmp/tmpvilyw6yi/tasks/main.yml:3 ok: [/cache/rhel-x.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/tmpvilyw6yi/vars/RedHat.yml"], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml"} ok: [/cache/rhel-x.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/tmpvilyw6yi/vars/RedHat.yml"], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml"} skipping: [/cache/rhel-x.qcow2] => (item=RedHat_9.yml) => {"ansible_loop_var": "item", "changed": false, "item": "RedHat_9.yml", "skip_reason": "Conditional result was False"} skipping: [/cache/rhel-x.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/tmpvilyw6yi/tasks/main.yml:18 fatal: [/cache/rhel-x.qcow2]: FAILED! => { "assertion": "mssql_accept_microsoft_odbc_driver_17_for_sql_server_eula | bool", "changed": false, "evaluated_to": false, "msg": [ "You must accept EULA by setting the following variables to true:", "mssql_accept_microsoft_odbc_driver_17_for_sql_server_eula", "mssql_accept_microsoft_cli_utilities_for_sql_server_eula", "mssql_accept_microsoft_sql_server_2019_standard_eula" ] } TASK [Assert that the role failed with EULA not accepted] ********************** task path: /tmp/tmpvilyw6yi/tests/tests_default.yml:17 ok: [/cache/rhel-x.qcow2] => { "changed": false, "msg": "All assertions passed" } META: ran handlers META: ran handlers PLAY RECAP ********************************************************************* /cache/rhel-x.qcow2 : ok=5 changed=1 unreachable=0 failed=0 skipped=1 rescued=1 ignored=0 + cd /tmp/tmpvilyw6yi/tests; TEST_SUBJECTS=/cache/rhel-x.qcow2 TEST_ARTIFACTS=/tmp/linux-system-role-test-work-pull-linux-system-roles_mssql-12-b2c28c3-rhel-x-8fj1lawe/artifacts ANSIBLE_COLLECTIONS_PATHS=/tmp/tmphha6j_7z:~/.ansible/collections:/usr/share/ansible/collections ansible-playbook -vv --inventory=/usr/share/ansible/inventory/standard-inventory-qcow2 --skip-tags=tests::cleanup,tests::nvme /tmp/tmpvilyw6yi/_setup.yml /tmp/tmpvilyw6yi/tests/tests_idempotency.yml ansible-playbook [core 2.12.0.post0] config file = None configured module search path = ['/home/runner/.ansible/plugins/modules', '/usr/share/ansible/plugins/modules'] ansible python module location = /usr/local/lib/python3.8/site-packages/ansible ansible collection location = /tmp/tmphha6j_7z:/home/runner/.ansible/collections:/usr/share/ansible/collections executable location = /usr/local/bin/ansible-playbook python version = 3.8.8 (default, Aug 25 2021, 16:13:02) [GCC 8.5.0 20210514 (Red Hat 8.5.0-3)] jinja version = 2.10.3 libyaml = True No config file found; using defaults Skipping callback 'default', as we already have a stdout callback. Skipping callback 'minimal', as we already have a stdout callback. Skipping callback 'oneline', as we already have a stdout callback. PLAYBOOK: _setup.yml *********************************************************** 2 plays in /tmp/tmpvilyw6yi/_setup.yml PLAY [Fail when only localhost is available] *********************************** META: ran handlers TASK [debug] ******************************************************************* task path: /tmp/tmpvilyw6yi/_setup.yml:5 ok: [/cache/rhel-x.qcow2] => { "groups": { "all": [ "/cache/rhel-x.qcow2" ], "localhost": [ "/cache/rhel-x.qcow2" ], "subjects": [ "/cache/rhel-x.qcow2" ], "ungrouped": [] } } TASK [fail] ******************************************************************** task path: /tmp/tmpvilyw6yi/_setup.yml:6 skipping: [/cache/rhel-x.qcow2] => {"changed": false, "skip_reason": "Conditional result was False"} META: ran handlers META: ran handlers PLAY [Setup repos] ************************************************************* META: ran handlers TASK [set up internal repositories] ******************************************** task path: /tmp/tmpvilyw6yi/_setup.yml:13 changed: [/cache/rhel-x.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-x.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-x.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-x.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-x.qcow2 : ok=2 changed=1 unreachable=0 failed=0 skipped=1 rescued=0 ignored=0 PLAYBOOK: tests_idempotency.yml ************************************************ 1 plays in /tmp/tmpvilyw6yi/tests/tests_idempotency.yml PLAY [Ensure that the role is idempotent] ************************************** TASK [Gathering Facts] ********************************************************* task path: /tmp/tmpvilyw6yi/tests/tests_idempotency.yml:3 ok: [/cache/rhel-x.qcow2] META: ran handlers TASK [Ensure that the role runs on a fresh host and sets all parameters] ******* task path: /tmp/tmpvilyw6yi/tests/tests_idempotency.yml:10 TASK [linux-system-roles.mssql : Set platform/version specific variables] ****** task path: /tmp/tmpvilyw6yi/tasks/main.yml:3 ok: [/cache/rhel-x.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/tmpvilyw6yi/vars/RedHat.yml"], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml"} ok: [/cache/rhel-x.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/tmpvilyw6yi/vars/RedHat.yml"], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml"} skipping: [/cache/rhel-x.qcow2] => (item=RedHat_9.yml) => {"ansible_loop_var": "item", "changed": false, "item": "RedHat_9.yml", "skip_reason": "Conditional result was False"} skipping: [/cache/rhel-x.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/tmpvilyw6yi/tasks/main.yml:18 ok: [/cache/rhel-x.qcow2] => { "changed": false, "msg": "All assertions passed" } TASK [linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories] *** task path: /tmp/tmpvilyw6yi/tasks/main.yml:30 changed: [/cache/rhel-x.qcow2] => {"changed": true} TASK [linux-system-roles.mssql : Configure the Microsoft SQL Server 2019 repository] *** task path: /tmp/tmpvilyw6yi/tasks/main.yml:35 changed: [/cache/rhel-x.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/tmpvilyw6yi/tasks/main.yml:42 changed: [/cache/rhel-x.qcow2] => {"changed": true, "msg": "", "rc": 0, "results": ["Installed: source-highlight-3.1.9-11.el9.x86_64", "Installed: libipt-2.0.4-5.el9.x86_64", "Installed: libbabeltrace-1.5.8-8.el9.x86_64", "Installed: mssql-server-15.0.4178.1-3.x86_64", "Installed: libatomic-11.2.1-6.el9.x86_64", "Installed: elfutils-debuginfod-client-0.185-5.el9.x86_64", "Installed: cyrus-sasl-2.1.27-17.el9.x86_64", "Installed: libicu-67.1-9.el9.x86_64", "Installed: cyrus-sasl-gssapi-2.1.27-17.el9.x86_64", "Installed: gdb-10.2-9.el9.x86_64", "Installed: boost-regex-1.75.0-6.el9.x86_64", "Installed: gdb-headless-10.2-9.el9.x86_64"]} TASK [linux-system-roles.mssql : Check if the errorlog file exists and its location] *** task path: /tmp/tmpvilyw6yi/tasks/main.yml:47 ok: [/cache/rhel-x.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.065235", "end": "2021-11-17 21:17:03.848112", "msg": "", "rc": 0, "start": "2021-11-17 21:17:03.782877", "stderr": "", "stderr_lines": [], "stdout": "", "stdout_lines": []} TASK [linux-system-roles.mssql : Gather system services facts] ***************** task path: /tmp/tmpvilyw6yi/tasks/main.yml:62 ok: [/cache/rhel-x.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"}, "autofs.service": {"name": "autofs.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "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-redirect.service": {"name": "cockpit-wsinstance-http-redirect.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": "inactive", "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"}, "display-manager.service": {"name": "display-manager.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "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.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": "active"}, "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": "inactive"}, "modprobe@drm.service": {"name": "modprobe@drm.service", "source": "systemd", "state": "stopped", "status": "inactive"}, "modprobe@fuse.service": {"name": "modprobe@fuse.service", "source": "systemd", "state": "stopped", "status": "inactive"}, "mssql-server.service": {"name": "mssql-server.service", "source": "systemd", "state": "inactive", "status": "disabled"}, "network.service": {"name": "network.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "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-sudo.service": {"name": "nm-sudo.service", "source": "systemd", "state": "inactive", "status": "disabled"}, "ntpd.service": {"name": "ntpd.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "ntpdate.service": {"name": "ntpdate.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "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"}, "plymouth-quit-wait.service": {"name": "plymouth-quit-wait.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "plymouth-start.service": {"name": "plymouth-start.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "polkit.service": {"name": "polkit.service", "source": "systemd", "state": "inactive", "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"}, "rpc-svcgssd.service": {"name": "rpc-svcgssd.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "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-r07623b85809c44a98ef8f928e2a70749.service": {"name": "run-r07623b85809c44a98ef8f928e2a70749.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": "active"}, "sntp.service": {"name": "sntp.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "sshd-keygen.service": {"name": "sshd-keygen.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "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": "inactive"}, "sshd-keygen@ed25519.service": {"name": "sshd-keygen@ed25519.service", "source": "systemd", "state": "stopped", "status": "inactive"}, "sshd-keygen@rsa.service": {"name": "sshd-keygen@rsa.service", "source": "systemd", "state": "stopped", "status": "inactive"}, "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"}, "syslog.service": {"name": "syslog.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "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": "active"}, "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-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-timesyncd.service": {"name": "systemd-timesyncd.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "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"}, "unbound-anchor.service": {"name": "unbound-anchor.service", "source": "systemd", "state": "stopped", "status": "static"}, "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": "active"}, "user@.service": {"name": "user@.service", "source": "systemd", "state": "unknown", "status": "static"}, "user@0.service": {"name": "user@0.service", "source": "systemd", "state": "running", "status": "active"}, "ypbind.service": {"name": "ypbind.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "yppasswdd.service": {"name": "yppasswdd.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "ypserv.service": {"name": "ypserv.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "ypxfrd.service": {"name": "ypxfrd.service", "source": "systemd", "state": "stopped", "status": "not-found"}}}, "changed": false} TASK [linux-system-roles.mssql : Verify that the variables required for setting up MSSQL are defined] *** task path: /tmp/tmpvilyw6yi/tasks/main.yml:75 ok: [/cache/rhel-x.qcow2] => { "changed": false, "msg": "All assertions passed" } TASK [linux-system-roles.mssql : Set up MSSQL] ********************************* task path: /tmp/tmpvilyw6yi/tasks/main.yml:85 changed: [/cache/rhel-x.qcow2] => {"changed": true, "cmd": ["/opt/mssql/bin/mssql-conf", "-n", "setup"], "delta": "0:00:00.290996", "end": "2021-11-17 21:17:06.329792", "msg": "", "rc": 0, "start": "2021-11-17 21:17:06.038796", "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\nCreated symlink /etc/systemd/system/multi-user.target.wants/mssql-server.service → /usr/lib/systemd/system/mssql-server.service.", "stderr_lines": ["/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."], "stdout": "usermod: no changes\n\nThe license terms for this product can be found in\n/usr/share/doc/mssql-server or downloaded from:\nhttps://go.microsoft.com/fwlink/?LinkId=2104294&clcid=0x409\n\nThe privacy statement can be viewed at:\nhttps://go.microsoft.com/fwlink/?LinkId=853010&clcid=0x409\n\nConfiguring SQL Server...\nSetup has completed successfully. SQL Server is now starting.", "stdout_lines": ["usermod: no changes", "", "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&clcid=0x409", "", "The privacy statement can be viewed at:", "https://go.microsoft.com/fwlink/?LinkId=853010&clcid=0x409", "", "Configuring SQL Server...", "Setup has completed successfully. SQL Server is now starting."]} TASK [linux-system-roles.mssql : Ensure that the tuned-profiles-mssql package is installed] *** task path: /tmp/tmpvilyw6yi/tasks/main.yml:94 changed: [/cache/rhel-x.qcow2] => {"changed": true, "msg": "", "rc": 0, "results": ["Installed: hdparm-9.62-2.el9.x86_64", "Installed: python3-linux-procfs-0.6.3-2.el9.noarch", "Installed: python3-perf-5.14.0-15.el9.x86_64", "Installed: python3-pyudev-0.22.0-6.el9.noarch", "Installed: tuned-profiles-mssql-2.16.0-3.el9.noarch", "Installed: tuned-2.16.0-3.el9.noarch"]} TASK [linux-system-roles.mssql : Ensure that the tuned service is started and enabled] *** task path: /tmp/tmpvilyw6yi/tasks/main.yml:99 changed: [/cache/rhel-x.qcow2] => {"changed": true, "enabled": true, "name": "tuned", "state": "started", "status": {"ActiveEnterTimestampMonotonic": "0", "ActiveExitTimestampMonotonic": "0", "ActiveState": "inactive", "After": "systemd-journald.socket dbus.socket basic.target sysinit.target system.slice network.target systemd-sysctl.service dbus-broker.service", "AllowIsolate": "no", "AssertResult": "no", "AssertTimestampMonotonic": "0", "Before": "multi-user.target shutdown.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": "[not set]", "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": "no", "ConditionTimestampMonotonic": "0", "ConfigurationDirectoryMode": "0755", "Conflicts": "shutdown.target cpupower.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": "0", "ExecMainStartTimestampMonotonic": "0", "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 }", "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": "0", "IOSchedulingPriority": "0", "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", "InactiveExitTimestampMonotonic": "0", "JobRunningTimeoutUSec": "infinity", "JobTimeoutAction": "none", "JobTimeoutUSec": "infinity", "KeyringMode": "private", "KillMode": "control-group", "KillSignal": "15", "LimitAS": "infinity", "LimitASSoft": "infinity", "LimitCORE": "infinity", "LimitCORESoft": "infinity", "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": "14635", "LimitNPROCSoft": "14635", "LimitRSS": "infinity", "LimitRSSSoft": "infinity", "LimitRTPRIO": "0", "LimitRTPRIOSoft": "0", "LimitRTTIME": "infinity", "LimitRTTIMESoft": "infinity", "LimitSIGPENDING": "14635", "LimitSIGPENDINGSoft": "14635", "LimitSTACK": "infinity", "LimitSTACKSoft": "8388608", "LoadState": "loaded", "LockPersonality": "no", "LogLevelMax": "-1", "LogRateLimitBurst": "0", "LogRateLimitIntervalUSec": "0", "LogsDirectoryMode": "0755", "MainPID": "0", "ManagedOOMMemoryPressure": "auto", "ManagedOOMMemoryPressureLimit": "0", "ManagedOOMPreference": "none", "ManagedOOMSwap": "auto", "MemoryAccounting": "yes", "MemoryAvailable": "infinity", "MemoryCurrent": "[not set]", "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", "OnSuccesJobMode": "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": "system.slice dbus-broker.service dbus.socket sysinit.target polkit.service", "Restart": "no", "RestartKillSignal": "15", "RestartUSec": "100ms", "RestrictNamespaces": "no", "RestrictRealtime": "no", "RestrictSUIDSGID": "no", "Result": "success", "RootDirectoryStartOnly": "no", "RuntimeDirectoryMode": "0755", "RuntimeDirectoryPreserve": "no", "RuntimeMaxUSec": "infinity", "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]", "StateChangeTimestampMonotonic": "0", "StateDirectoryMode": "0755", "StatusErrno": "0", "StopWhenUnneeded": "no", "SubState": "dead", "SuccessAction": "none", "SyslogFacility": "3", "SyslogLevel": "6", "SyslogLevelPrefix": "yes", "SyslogPriority": "30", "SystemCallErrorNumber": "2147483646", "TTYReset": "no", "TTYVHangup": "no", "TTYVTDisallocate": "no", "TasksAccounting": "yes", "TasksCurrent": "[not set]", "TasksMax": "4390", "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": "infinity"}} TASK [linux-system-roles.mssql : Get the active Tuned profiles] **************** task path: /tmp/tmpvilyw6yi/tasks/main.yml:105 ok: [/cache/rhel-x.qcow2] => {"changed": false, "cmd": ["tuned-adm", "active"], "delta": "0:00:00.113294", "end": "2021-11-17 21:17:09.594416", "msg": "", "rc": 0, "start": "2021-11-17 21:17:09.481122", "stderr": "", "stderr_lines": [], "stdout": "Current active profile: virtual-guest", "stdout_lines": ["Current active profile: virtual-guest"]} TASK [linux-system-roles.mssql : Add mssql to the list of Tuned profiles] ****** task path: /tmp/tmpvilyw6yi/tasks/main.yml:115 changed: [/cache/rhel-x.qcow2] => {"changed": true, "cmd": ["tuned-adm", "profile", "virtual-guest", "mssql"], "delta": "0:00:01.106162", "end": "2021-11-17 21:17:11.086331", "msg": "", "rc": 0, "start": "2021-11-17 21:17:09.980169", "stderr": "", "stderr_lines": [], "stdout": "", "stdout_lines": []} TASK [linux-system-roles.mssql : Configure the Microsoft SQL Server Tools repository] *** task path: /tmp/tmpvilyw6yi/tasks/main.yml:145 changed: [/cache/rhel-x.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/tmpvilyw6yi/tasks/main.yml:152 changed: [/cache/rhel-x.qcow2] => {"changed": true, "msg": "", "rc": 0, "results": ["Installed: unixODBC-2.3.7-1.rh.x86_64", "Installed: unixODBC-devel-2.3.7-1.rh.x86_64", "Installed: libpkgconf-1.7.3-9.el9.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: msodbcsql17-17.8.1.2-1.x86_64", "Installed: mssql-tools-17.8.1.2-1.x86_64"]} TASK [linux-system-roles.mssql : Prepare MSSQL and facts for logging in] ******* task path: /tmp/tmpvilyw6yi/tasks/main.yml:164 skipping: [/cache/rhel-x.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/tmpvilyw6yi/tasks/main.yml:169 skipping: [/cache/rhel-x.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/tmpvilyw6yi/tasks/main.yml:175 skipping: [/cache/rhel-x.qcow2] => {"changed": false, "skip_reason": "Conditional result was False"} TASK [linux-system-roles.mssql : Change the password of the sa user] *********** task path: /tmp/tmpvilyw6yi/tasks/main.yml:182 skipping: [/cache/rhel-x.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/tmpvilyw6yi/tasks/main.yml:194 skipping: [/cache/rhel-x.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/tmpvilyw6yi/tasks/main.yml:207 skipping: [/cache/rhel-x.qcow2] => {"changed": false, "skip_reason": "Conditional result was False"} TASK [linux-system-roles.mssql : Change the edition of MSSQL] ****************** task path: /tmp/tmpvilyw6yi/tasks/main.yml:214 skipping: [/cache/rhel-x.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/tmpvilyw6yi/tasks/main.yml:226 ok: [/cache/rhel-x.qcow2] => {"changed": false, "cmd": ["/opt/mssql/bin/mssql-conf", "get", "network", "ipaddress"], "delta": "0:00:00.061509", "end": "2021-11-17 21:17:27.169473", "msg": "", "rc": 0, "start": "2021-11-17 21:17:27.107964", "stderr": "", "stderr_lines": [], "stdout": "No setting for the given option found in '/var/opt/mssql/mssql.conf'.", "stdout_lines": ["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/tmpvilyw6yi/tasks/main.yml:232 NOTIFIED HANDLER linux-system-roles.mssql : Restart the mssql-server service for /cache/rhel-x.qcow2 changed: [/cache/rhel-x.qcow2] => {"changed": true, "cmd": ["/opt/mssql/bin/mssql-conf", "set", "network.ipaddress", "0.0.0.0"], "delta": "0:00:00.061905", "end": "2021-11-17 21:17:27.607446", "msg": "", "rc": 0, "start": "2021-11-17 21:17:27.545541", "stderr": "", "stderr_lines": [], "stdout": "SQL Server needs to be restarted in order to apply this setting. Please run\n'systemctl restart mssql-server.service'.", "stdout_lines": ["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/tmpvilyw6yi/tasks/main.yml:241 changed: [/cache/rhel-x.qcow2] => {"changed": true, "cmd": ["/opt/mssql/bin/mssql-conf", "set", "network.tcpport", "1443"], "delta": "0:00:00.066517", "end": "2021-11-17 21:17:28.055758", "msg": "", "rc": 0, "start": "2021-11-17 21:17:27.989241", "stderr": "", "stderr_lines": [], "stdout": "SQL Server needs to be restarted in order to apply this setting. Please run\n'systemctl restart mssql-server.service'.", "stdout_lines": ["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/tmpvilyw6yi/tasks/main.yml:251 skipping: [/cache/rhel-x.qcow2] => {"changed": false, "skip_reason": "Conditional result was False"} TASK [linux-system-roles.mssql : Create a tempfile on the host] **************** task path: /tmp/tmpvilyw6yi/tasks/main.yml:263 skipping: [/cache/rhel-x.qcow2] => {"changed": false, "skip_reason": "Conditional result was False"} TASK [linux-system-roles.mssql : Copy the file to the host] ******************* task path: /tmp/tmpvilyw6yi/tasks/main.yml:268 skipping: [/cache/rhel-x.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/tmpvilyw6yi/tasks/main.yml:274 skipping: [/cache/rhel-x.qcow2] => {"changed": false, "skip_reason": "Conditional result was False"} TASK [linux-system-roles.mssql : Prepare MSSQL and facts for logging in] ******* task path: /tmp/tmpvilyw6yi/tasks/main.yml:279 skipping: [/cache/rhel-x.qcow2] => {"changed": false, "skip_reason": "Conditional result was False"} TASK [linux-system-roles.mssql : Input the file with the sqlcmd command] ****** task path: /tmp/tmpvilyw6yi/tasks/main.yml:284 skipping: [/cache/rhel-x.qcow2] => {"changed": false, "skip_reason": "Conditional result was False"} TASK [linux-system-roles.mssql : Print the output of the sqlcmd command] ******* task path: /tmp/tmpvilyw6yi/tasks/main.yml:291 skipping: [/cache/rhel-x.qcow2] => {} TASK [linux-system-roles.mssql : Remove the {{ __mssql_sql_tempfile.path }} file] *** task path: /tmp/tmpvilyw6yi/tasks/main.yml:295 skipping: [/cache/rhel-x.qcow2] => {"changed": false, "skip_reason": "Conditional result was False"} META: role_complete for /cache/rhel-x.qcow2 TASK [Flush handlers] ********************************************************** task path: /tmp/tmpvilyw6yi/tests/tests_idempotency.yml:19 RUNNING HANDLER [linux-system-roles.mssql : Restart the mssql-server service] *** task path: /tmp/tmpvilyw6yi/handlers/main.yml:3 changed: [/cache/rhel-x.qcow2] => {"changed": true, "name": "mssql-server", "state": "started", "status": {"ActiveEnterTimestamp": "Wed 2021-11-17 21:17:06 EST", "ActiveEnterTimestampMonotonic": "57766653", "ActiveExitTimestamp": "Wed 2021-11-17 21:17:06 EST", "ActiveExitTimestampMonotonic": "57769366", "ActiveState": "failed", "After": "auditd.service -.mount sysinit.target system.slice basic.target systemd-journald.socket network.target", "AllowIsolate": "no", "AssertResult": "yes", "AssertTimestamp": "Wed 2021-11-17 21:17:06 EST", "AssertTimestampMonotonic": "58014949", "Before": "multi-user.target shutdown.target", "BlockIOAccounting": "no", "BlockIOWeight": "[not set]", "CPUAccounting": "yes", "CPUAffinityFromNUMA": "no", "CPUQuotaPerSecUSec": "infinity", "CPUQuotaPeriodUSec": "infinity", "CPUSchedulingPolicy": "0", "CPUSchedulingPriority": "0", "CPUSchedulingResetOnFork": "no", "CPUShares": "[not set]", "CPUUsageNSec": "3075000", "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": "Wed 2021-11-17 21:17:06 EST", "ConditionTimestampMonotonic": "58014947", "ConfigurationDirectoryMode": "0755", "Conflicts": "shutdown.target", "ControlPID": "0", "CoredumpFilter": "0x33", "DefaultDependencies": "yes", "DefaultMemoryLow": "0", "DefaultMemoryMin": "0", "Delegate": "no", "Description": "Microsoft SQL Server Database Engine", "DevicePolicy": "auto", "Documentation": "https://docs.microsoft.com/en-us/sql/linux", "DynamicUser": "no", "ExecMainCode": "1", "ExecMainExitTimestamp": "Wed 2021-11-17 21:17:06 EST", "ExecMainExitTimestampMonotonic": "57769308", "ExecMainPID": "13474", "ExecMainStartTimestamp": "Wed 2021-11-17 21:17:06 EST", "ExecMainStartTimestampMonotonic": "57766213", "ExecMainStatus": "127", "ExecStart": "{ path=/opt/mssql/bin/sqlservr ; argv[]=/opt/mssql/bin/sqlservr ; ignore_errors=no ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }", "ExecStartEx": "{ path=/opt/mssql/bin/sqlservr ; argv[]=/opt/mssql/bin/sqlservr ; flags= ; start_time=[n/a] ; stop_time=[n/a] ; pid=0 ; code=(null) ; status=0/0 }", "FailureAction": "none", "FileDescriptorStoreMax": "0", "FinalKillSignal": "9", "FragmentPath": "/usr/lib/systemd/system/mssql-server.service", "FreezerState": "running", "GID": "[not set]", "GuessMainPID": "yes", "IOAccounting": "no", "IOReadBytes": "18446744073709551615", "IOReadOperations": "18446744073709551615", "IOSchedulingClass": "0", "IOSchedulingPriority": "0", "IOWeight": "[not set]", "IOWriteBytes": "18446744073709551615", "IOWriteOperations": "18446744073709551615", "IPAccounting": "no", "IPEgressBytes": "[no data]", "IPEgressPackets": "[no data]", "IPIngressBytes": "[no data]", "IPIngressPackets": "[no data]", "Id": "mssql-server.service", "IgnoreOnIsolate": "no", "IgnoreSIGPIPE": "yes", "InactiveEnterTimestamp": "Wed 2021-11-17 21:17:06 EST", "InactiveEnterTimestampMonotonic": "58014866", "InactiveExitTimestamp": "Wed 2021-11-17 21:17:06 EST", "InactiveExitTimestampMonotonic": "57769756", "InvocationID": "9544148a265a41839dad7a3e26310ce8", "JobRunningTimeoutUSec": "infinity", "JobTimeoutAction": "none", "JobTimeoutUSec": "infinity", "KeyringMode": "private", "KillMode": "process", "KillSignal": "15", "LimitAS": "infinity", "LimitASSoft": "infinity", "LimitCORE": "infinity", "LimitCORESoft": "infinity", "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": "infinity", "LimitNOFILESoft": "infinity", "LimitNPROC": "infinity", "LimitNPROCSoft": "infinity", "LimitRSS": "infinity", "LimitRSSSoft": "infinity", "LimitRTPRIO": "0", "LimitRTPRIOSoft": "0", "LimitRTTIME": "infinity", "LimitRTTIMESoft": "infinity", "LimitSIGPENDING": "14635", "LimitSIGPENDINGSoft": "14635", "LimitSTACK": "infinity", "LimitSTACKSoft": "8388608", "LoadState": "loaded", "LockPersonality": "no", "LogLevelMax": "-1", "LogRateLimitBurst": "0", "LogRateLimitIntervalUSec": "0", "LogsDirectoryMode": "0755", "MainPID": "0", "ManagedOOMMemoryPressure": "auto", "ManagedOOMMemoryPressureLimit": "0", "ManagedOOMPreference": "none", "ManagedOOMSwap": "auto", "MemoryAccounting": "yes", "MemoryAvailable": "infinity", "MemoryCurrent": "[not set]", "MemoryDenyWriteExecute": "no", "MemoryHigh": "infinity", "MemoryLimit": "infinity", "MemoryLow": "0", "MemoryMax": "infinity", "MemoryMin": "0", "MemorySwapMax": "infinity", "MountAPIVFS": "no", "NFileDescriptorStore": "0", "NRestarts": "4", "NUMAPolicy": "n/a", "Names": "mssql-server.service", "NeedDaemonReload": "no", "Nice": "0", "NoNewPrivileges": "no", "NonBlocking": "no", "NotifyAccess": "none", "OOMPolicy": "stop", "OOMScoreAdjust": "0", "OnFailureJobMode": "replace", "OnSuccesJobMode": "fail", "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": "sysinit.target system.slice -.mount", "RequiresMountsFor": "/var/opt/mssql", "Restart": "on-failure", "RestartKillSignal": "15", "RestartUSec": "100ms", "RestrictNamespaces": "no", "RestrictRealtime": "no", "RestrictSUIDSGID": "no", "Result": "exit-code", "RootDirectoryStartOnly": "no", "RuntimeDirectoryMode": "0755", "RuntimeDirectoryPreserve": "no", "RuntimeMaxUSec": "infinity", "SameProcessGroup": "no", "SecureBits": "0", "SendSIGHUP": "no", "SendSIGKILL": "yes", "Slice": "system.slice", "StandardError": "inherit", "StandardInput": "null", "StandardOutput": "journal", "StartLimitAction": "none", "StartLimitBurst": "3", "StartLimitIntervalUSec": "2min", "StartupBlockIOWeight": "[not set]", "StartupCPUShares": "[not set]", "StartupCPUWeight": "[not set]", "StartupIOWeight": "[not set]", "StateChangeTimestamp": "Wed 2021-11-17 21:17:06 EST", "StateChangeTimestampMonotonic": "58015088", "StateDirectoryMode": "0755", "StatusErrno": "0", "StopWhenUnneeded": "no", "SubState": "failed", "SuccessAction": "none", "SyslogFacility": "3", "SyslogLevel": "6", "SyslogLevelPrefix": "yes", "SyslogPriority": "30", "SystemCallErrorNumber": "2147483646", "TTYReset": "no", "TTYVHangup": "no", "TTYVTDisallocate": "no", "TasksAccounting": "yes", "TasksCurrent": "[not set]", "TasksMax": "infinity", "TimeoutAbortUSec": "30min", "TimeoutCleanUSec": "infinity", "TimeoutStartFailureMode": "terminate", "TimeoutStartUSec": "30min", "TimeoutStopFailureMode": "terminate", "TimeoutStopUSec": "30min", "TimerSlackNSec": "50000", "Transient": "no", "Type": "simple", "UID": "[not set]", "UMask": "0007", "UnitFilePreset": "disabled", "UnitFileState": "enabled", "User": "mssql", "UtmpMode": "init", "WantedBy": "multi-user.target", "WatchdogSignal": "6", "WatchdogTimestampMonotonic": "0", "WatchdogUSec": "0", "WorkingDirectory": "/var/opt/mssql"}} META: ran handlers TASK [Run role again with the same settings] *********************************** task path: /tmp/tmpvilyw6yi/tests/tests_idempotency.yml:22 TASK [linux-system-roles.mssql : Set platform/version specific variables] ****** task path: /tmp/tmpvilyw6yi/tasks/main.yml:3 ok: [/cache/rhel-x.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/tmpvilyw6yi/vars/RedHat.yml"], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml"} ok: [/cache/rhel-x.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/tmpvilyw6yi/vars/RedHat.yml"], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml"} skipping: [/cache/rhel-x.qcow2] => (item=RedHat_9.yml) => {"ansible_loop_var": "item", "changed": false, "item": "RedHat_9.yml", "skip_reason": "Conditional result was False"} skipping: [/cache/rhel-x.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/tmpvilyw6yi/tasks/main.yml:18 ok: [/cache/rhel-x.qcow2] => { "changed": false, "msg": "All assertions passed" } TASK [linux-system-roles.mssql : Deploy the GPG key for Microsoft repositories] *** task path: /tmp/tmpvilyw6yi/tasks/main.yml:30 ok: [/cache/rhel-x.qcow2] => {"changed": false} TASK [linux-system-roles.mssql : Configure the Microsoft SQL Server 2019 repository] *** task path: /tmp/tmpvilyw6yi/tasks/main.yml:35 ok: [/cache/rhel-x.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/tmpvilyw6yi/tasks/main.yml:42 ok: [/cache/rhel-x.qcow2] => {"changed": false, "msg": "Nothing to do", "rc": 0, "results": []} TASK [linux-system-roles.mssql : Check if the errorlog file exists and its location] *** task path: /tmp/tmpvilyw6yi/tasks/main.yml:47 ok: [/cache/rhel-x.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.070717", "end": "2021-11-17 21:17:31.079641", "msg": "", "rc": 0, "start": "2021-11-17 21:17:31.008924", "stderr": "", "stderr_lines": [], "stdout": "", "stdout_lines": []} TASK [linux-system-roles.mssql : Gather system services facts] ***************** task path: /tmp/tmpvilyw6yi/tasks/main.yml:62 ok: [/cache/rhel-x.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"}, "autofs.service": {"name": "autofs.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "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-redirect.service": {"name": "cockpit-wsinstance-http-redirect.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"}, "display-manager.service": {"name": "display-manager.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "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.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": "active"}, "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": "inactive"}, "modprobe@drm.service": {"name": "modprobe@drm.service", "source": "systemd", "state": "stopped", "status": "inactive"}, "modprobe@fuse.service": {"name": "modprobe@fuse.service", "source": "systemd", "state": "stopped", "status": "inactive"}, "mssql-server.service": {"name": "mssql-server.service", "source": "systemd", "state": "stopped", "status": "failed"}, "network.service": {"name": "network.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "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-sudo.service": {"name": "nm-sudo.service", "source": "systemd", "state": "inactive", "status": "disabled"}, "ntpd.service": {"name": "ntpd.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "ntpdate.service": {"name": "ntpdate.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "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"}, "plymouth-quit-wait.service": {"name": "plymouth-quit-wait.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "plymouth-start.service": {"name": "plymouth-start.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "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"}, "rpc-svcgssd.service": {"name": "rpc-svcgssd.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "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": "active"}, "sntp.service": {"name": "sntp.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "sshd-keygen.service": {"name": "sshd-keygen.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "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": "inactive"}, "sshd-keygen@ed25519.service": {"name": "sshd-keygen@ed25519.service", "source": "systemd", "state": "stopped", "status": "inactive"}, "sshd-keygen@rsa.service": {"name": "sshd-keygen@rsa.service", "source": "systemd", "state": "stopped", "status": "inactive"}, "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"}, "syslog.service": {"name": "syslog.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "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": "active"}, "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-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-timesyncd.service": {"name": "systemd-timesyncd.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "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"}, "unbound-anchor.service": {"name": "unbound-anchor.service", "source": "systemd", "state": "stopped", "status": "static"}, "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": "active"}, "user@.service": {"name": "user@.service", "source": "systemd", "state": "unknown", "status": "static"}, "user@0.service": {"name": "user@0.service", "source": "systemd", "state": "running", "status": "active"}, "ypbind.service": {"name": "ypbind.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "yppasswdd.service": {"name": "yppasswdd.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "ypserv.service": {"name": "ypserv.service", "source": "systemd", "state": "stopped", "status": "not-found"}, "ypxfrd.service": {"name": "ypxfrd.service", "source": "systemd", "state": "stopped", "status": "not-found"}}}, "changed": false} TASK [linux-system-roles.mssql : Verify that the variables required for setting up MSSQL are defined] *** task path: /tmp/tmpvilyw6yi/tasks/main.yml:75 ok: [/cache/rhel-x.qcow2] => { "changed": false, "msg": "All assertions passed" } TASK [linux-system-roles.mssql : Set up MSSQL] ********************************* task path: /tmp/tmpvilyw6yi/tasks/main.yml:85 fatal: [/cache/rhel-x.qcow2]: FAILED! => {"changed": true, "cmd": ["/opt/mssql/bin/mssql-conf", "-n", "setup"], "delta": "0:00:00.130536", "end": "2021-11-17 21:17:33.127821", "msg": "non-zero return code", "rc": 1, "start": "2021-11-17 21:17:32.997285", "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\nJob for mssql-server.service failed because the control process exited with error code.\nSee \"systemctl status mssql-server.service\" and \"journalctl -xeu mssql-server.service\" for details.", "stderr_lines": ["/opt/mssql/bin/sqlservr: error while loading shared libraries: libldap-2.4.so.2: cannot open shared object file: No such file or directory", "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."], "stdout": "usermod: no changes\n\nThe license terms for this product can be found in\n/usr/share/doc/mssql-server or downloaded from:\nhttps://go.microsoft.com/fwlink/?LinkId=2104294&clcid=0x409\n\nThe privacy statement can be viewed at:\nhttps://go.microsoft.com/fwlink/?LinkId=853010&clcid=0x409\n\nConfiguring SQL Server...\nAttempting to start the Microsoft SQL Server service failed.", "stdout_lines": ["usermod: no changes", "", "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&clcid=0x409", "", "The privacy statement can be viewed at:", "https://go.microsoft.com/fwlink/?LinkId=853010&clcid=0x409", "", "Configuring SQL Server...", "Attempting to start the Microsoft SQL Server service failed."]} PLAY RECAP ********************************************************************* /cache/rhel-x.qcow2 : ok=30 changed=13 unreachable=0 failed=1 skipped=16 rescued=0 ignored=0