ansible-playbook 2.9.27 config file = /etc/ansible/ansible.cfg configured module search path = [u'/root/.ansible/plugins/modules', u'/usr/share/ansible/plugins/modules'] ansible python module location = /usr/lib/python2.7/site-packages/ansible executable location = /usr/bin/ansible-playbook python version = 2.7.5 (default, Nov 14 2023, 16:14:06) [GCC 4.8.5 20150623 (Red Hat 4.8.5-44)] Using /etc/ansible/ansible.cfg as config file [WARNING]: running playbook inside collection fedora.linux_system_roles Skipping callback 'actionable', as we already have a stdout callback. Skipping callback 'counter_enabled', as we already have a stdout callback. Skipping callback 'debug', as we already have a stdout callback. Skipping callback 'dense', as we already have a stdout callback. Skipping callback 'dense', as we already have a stdout callback. Skipping callback 'full_skip', as we already have a stdout callback. Skipping callback 'json', as we already have a stdout callback. Skipping callback 'minimal', as we already have a stdout callback. Skipping callback 'null', as we already have a stdout callback. Skipping callback 'oneline', as we already have a stdout callback. Skipping callback 'selective', as we already have a stdout callback. Skipping callback 'skippy', as we already have a stdout callback. Skipping callback 'stderr', as we already have a stdout callback. Skipping callback 'unixy', as we already have a stdout callback. Skipping callback 'yaml', as we already have a stdout callback. PLAYBOOK: tests_accept_eula.yml ************************************************ 2 plays in /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_accept_eula.yml PLAY [all] ********************************************************************* META: ran handlers TASK [Include vault variables] ************************************************* task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_accept_eula.yml:5 Tuesday 20 May 2025 05:50:17 -0400 (0:00:00.040) 0:00:00.040 *********** ok: [managed-node3] => { "ansible_facts": { "mssql_password": { "__ansible_vault": "$ANSIBLE_VAULT;1.1;AES256\n66336361663164656232326461653662643537386337346563613939356466313835383235313234\n3634333565616161316639666662613564353237653663610a616639306439653033386664303839\n30663030636161326137656235636230356162373234386461363632353863393161353035316162\n3664353366373231360a343334326337353861366233656330363634353164316434616561333161\n3234\n" } }, "ansible_included_var_files": [ "/tmp/mssql-0zY/tests/vars/vault-variables.yml" ], "changed": false } META: ran handlers META: ran handlers PLAY [Ensure that the role runs when EULA are accepted] ************************ TASK [Gathering Facts] ********************************************************* task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_accept_eula.yml:9 Tuesday 20 May 2025 05:50:17 -0400 (0:00:00.032) 0:00:00.072 *********** ok: [managed-node3] META: ran handlers TASK [Run the role with default parameters] ************************************ task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_accept_eula.yml:25 Tuesday 20 May 2025 05:50:19 -0400 (0:00:01.665) 0:00:01.737 *********** TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3 Tuesday 20 May 2025 05:50:19 -0400 (0:00:00.886) 0:00:02.624 *********** included: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml for managed-node3 TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts used by role] ***** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 Tuesday 20 May 2025 05:50:20 -0400 (0:00:00.069) 0:00:02.694 *********** skipping: [managed-node3] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Set platform/version specific variables] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8 Tuesday 20 May 2025 05:50:20 -0400 (0:00:00.066) 0:00:02.761 *********** ok: [managed-node3] => (item=RedHat.yml) => { "ansible_facts": { "__mssql_client_repository": "https://packages.microsoft.com/rhel/9/prod/", "__mssql_confined_supported": true, "__mssql_server_repository": "https://packages.microsoft.com/rhel/9/mssql-server-{{ mssql_version | int }}/", "__mssql_supported_versions": [ 2022 ], "__mssql_tuned_supported": true }, "ansible_included_var_files": [ "/tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } skipping: [managed-node3] => (item=CentOS.yml) => { "ansible_loop_var": "item", "changed": false, "item": "CentOS.yml", "skip_reason": "Conditional result was False" } ok: [managed-node3] => (item=CentOS_7.yml) => { "ansible_facts": { "__mssql_client_repository": "https://packages.microsoft.com/rhel/7/prod/", "__mssql_confined_supported": false, "__mssql_server_repository": "https://packages.microsoft.com/rhel/7/mssql-server-{{ mssql_version | int }}/", "__mssql_supported_versions": [ 2017, 2019 ] }, "ansible_included_var_files": [ "/tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/CentOS_7.yml" ], "ansible_loop_var": "item", "changed": false, "item": "CentOS_7.yml" } skipping: [managed-node3] => (item=CentOS_7.9.yml) => { "ansible_loop_var": "item", "changed": false, "item": "CentOS_7.9.yml", "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8 Tuesday 20 May 2025 05:50:20 -0400 (0:00:00.115) 0:00:02.877 *********** ok: [managed-node3] => { "ansible_facts": { "__mssql_sqlcmd_login_cmd": null }, "changed": false } TASK [fedora.linux_system_roles.mssql : Print that the mssql_input_sql_file variable is deprecated] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:15 Tuesday 20 May 2025 05:50:20 -0400 (0:00:00.053) 0:00:02.930 *********** skipping: [managed-node3] => {} TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_input_sql_file fact] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:23 Tuesday 20 May 2025 05:50:20 -0400 (0:00:00.078) 0:00:03.008 *********** skipping: [managed-node3] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Print that the variable is deprecated] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:30 Tuesday 20 May 2025 05:50:20 -0400 (0:00:00.119) 0:00:03.128 *********** skipping: [managed-node3] => {} TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_ha_listener_port fact] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:37 Tuesday 20 May 2025 05:50:20 -0400 (0:00:00.139) 0:00:03.267 *********** skipping: [managed-node3] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Print that the mssql_ad_sql_user_name variable is deprecated] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:44 Tuesday 20 May 2025 05:50:20 -0400 (0:00:00.141) 0:00:03.408 *********** skipping: [managed-node3] => {} TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_ad_sql_user_name fact] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:51 Tuesday 20 May 2025 05:50:20 -0400 (0:00:00.070) 0:00:03.479 *********** skipping: [managed-node3] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Print that the mssql_ha_cluster_run_role variable is deprecated] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:58 Tuesday 20 May 2025 05:50:20 -0400 (0:00:00.068) 0:00:03.547 *********** skipping: [managed-node3] => {} TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_ha_cluster_run_role fact] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:65 Tuesday 20 May 2025 05:50:20 -0400 (0:00:00.070) 0:00:03.617 *********** skipping: [managed-node3] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Print that variable is deprecated] ***** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:74 Tuesday 20 May 2025 05:50:21 -0400 (0:00:00.068) 0:00:03.686 *********** skipping: [managed-node3] => {} TASK [fedora.linux_system_roles.mssql : Link the deprecated fact] ************** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:83 Tuesday 20 May 2025 05:50:21 -0400 (0:00:00.071) 0:00:03.757 *********** skipping: [managed-node3] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Fail on RHEL or CentOS 10 because it's not supported] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:87 Tuesday 20 May 2025 05:50:21 -0400 (0:00:00.086) 0:00:03.844 *********** skipping: [managed-node3] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify that the user accepts EULA variables] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:94 Tuesday 20 May 2025 05:50:21 -0400 (0:00:00.065) 0:00:03.909 *********** ok: [managed-node3] => { "changed": false } MSG: All assertions passed TASK [fedora.linux_system_roles.mssql : Verify that EL < 8 is not used with mssql_ha_configure=true] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:106 Tuesday 20 May 2025 05:50:21 -0400 (0:00:00.072) 0:00:03.982 *********** skipping: [managed-node3] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify if the mssql_ha_replica_type variable is provided correctly] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:114 Tuesday 20 May 2025 05:50:21 -0400 (0:00:00.061) 0:00:04.043 *********** skipping: [managed-node3] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify that 'mssql_ha_replica_type = primary' is provided once] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:123 Tuesday 20 May 2025 05:50:21 -0400 (0:00:00.066) 0:00:04.109 *********** skipping: [managed-node3] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify that mssql_ha_prep_for_pacemaker is provided correctly] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:132 Tuesday 20 May 2025 05:50:21 -0400 (0:00:00.067) 0:00:04.177 *********** skipping: [managed-node3] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify that selinux variables are used on supported platforms] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:142 Tuesday 20 May 2025 05:50:21 -0400 (0:00:00.064) 0:00:04.241 *********** skipping: [managed-node3] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify that mssql_manage_selinux is set properly] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:151 Tuesday 20 May 2025 05:50:21 -0400 (0:00:00.072) 0:00:04.313 *********** skipping: [managed-node3] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Gather package facts] ****************** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:162 Tuesday 20 May 2025 05:50:21 -0400 (0:00:00.075) 0:00:04.388 *********** ok: [managed-node3] => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false } TASK [fedora.linux_system_roles.mssql : Set fact with the currently installed SQL Server version if any] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:166 Tuesday 20 May 2025 05:50:23 -0400 (0:00:02.118) 0:00:06.507 *********** skipping: [managed-node3] => (item={u'value': 14, u'key': 2017}) => { "ansible_loop_var": "item", "changed": false, "item": { "key": 2017, "value": 14 }, "skip_reason": "Conditional result was False" } skipping: [managed-node3] => (item={u'value': 15, u'key': 2019}) => { "ansible_loop_var": "item", "changed": false, "item": { "key": 2019, "value": 15 }, "skip_reason": "Conditional result was False" } skipping: [managed-node3] => (item={u'value': 16, u'key': 2022}) => { "ansible_loop_var": "item", "changed": false, "item": { "key": 2022, "value": 16 }, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Set mssql_version variable if user does not define it] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:174 Tuesday 20 May 2025 05:50:24 -0400 (0:00:00.266) 0:00:06.774 *********** skipping: [managed-node3] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Verify if the mssql_version variable is provided correctly] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:181 Tuesday 20 May 2025 05:50:24 -0400 (0:00:00.125) 0:00:06.899 *********** ok: [managed-node3] => { "changed": false } MSG: All assertions passed TASK [fedora.linux_system_roles.mssql : Verify if mssql_version is not smaller then the existing SQL Server version] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:188 Tuesday 20 May 2025 05:50:24 -0400 (0:00:00.132) 0:00:07.032 *********** skipping: [managed-node3] => (item={u'value': 14, u'key': 2017}) => { "ansible_loop_var": "item", "changed": false, "item": { "key": 2017, "value": 14 }, "skip_reason": "Conditional result was False" } skipping: [managed-node3] => (item={u'value': 15, u'key': 2019}) => { "ansible_loop_var": "item", "changed": false, "item": { "key": 2019, "value": 15 }, "skip_reason": "Conditional result was False" } skipping: [managed-node3] => (item={u'value': 16, u'key': 2022}) => { "ansible_loop_var": "item", "changed": false, "item": { "key": 2022, "value": 16 }, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:202 Tuesday 20 May 2025 05:50:24 -0400 (0:00:00.178) 0:00:07.210 *********** changed: [managed-node3] => { "attempts": 1, "changed": true } TASK [fedora.linux_system_roles.mssql : Update all packages from SQL Server repo version {{ __mssql_current_version }}] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:216 Tuesday 20 May 2025 05:50:25 -0400 (0:00:01.118) 0:00:08.329 *********** skipping: [managed-node3] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Get yum repositories] ****************** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:226 Tuesday 20 May 2025 05:50:25 -0400 (0:00:00.161) 0:00:08.490 *********** skipping: [managed-node3] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Remove the current Microsoft SQL Server repository to upgrade to 2017] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:237 Tuesday 20 May 2025 05:50:25 -0400 (0:00:00.147) 0:00:08.638 *********** skipping: [managed-node3] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Update all packages from SQL Server repo version {{ __mssql_current_version }}] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:251 Tuesday 20 May 2025 05:50:26 -0400 (0:00:00.204) 0:00:08.843 *********** skipping: [managed-node3] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Get zypper repositories] *************** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:260 Tuesday 20 May 2025 05:50:26 -0400 (0:00:00.199) 0:00:09.043 *********** skipping: [managed-node3] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Remove the current Microsoft SQL Server repository to upgrade to 2017] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:272 Tuesday 20 May 2025 05:50:26 -0400 (0:00:00.305) 0:00:09.348 *********** skipping: [managed-node3] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server repo version 2017] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:279 Tuesday 20 May 2025 05:50:26 -0400 (0:00:00.199) 0:00:09.547 *********** changed: [managed-node3] => { "changed": true, "repo": "packages-microsoft-com-mssql-server-2017", "state": "present" } TASK [fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server repo version 2017] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:291 Tuesday 20 May 2025 05:50:27 -0400 (0:00:00.708) 0:00:10.256 *********** skipping: [managed-node3] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Configure to run as a confined application with SELinux] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:304 Tuesday 20 May 2025 05:50:27 -0400 (0:00:00.097) 0:00:10.353 *********** ok: [managed-node3] => { "changed": false, "rc": 0, "results": [ "mssql-server-selinux is not installed" ] } TASK [fedora.linux_system_roles.mssql : Ensure the package mssql-server] ******* task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:309 Tuesday 20 May 2025 05:50:28 -0400 (0:00:00.938) 0:00:11.292 *********** changed: [managed-node3] => { "changed": true, "changes": { "installed": [ "mssql-server" ] }, "rc": 0, "results": [ "Loaded plugins: fastestmirror\nLoading mirror speeds from cached hostfile\n * epel: d2lzkl7pfhq30w.cloudfront.net\n * epel-debuginfo: d2lzkl7pfhq30w.cloudfront.net\n * epel-source: d2lzkl7pfhq30w.cloudfront.net\nResolving Dependencies\n--> Running transaction check\n---> Package mssql-server.x86_64 0:14.0.3465.1-1 will be installed\n--> Processing Dependency: libatomic for package: mssql-server-14.0.3465.1-1.x86_64\n--> Processing Dependency: bzip2 for package: mssql-server-14.0.3465.1-1.x86_64\n--> Processing Dependency: gdb for package: mssql-server-14.0.3465.1-1.x86_64\n--> Processing Dependency: libsss_nss_idmap for package: mssql-server-14.0.3465.1-1.x86_64\n--> Processing Dependency: cyrus-sasl for package: mssql-server-14.0.3465.1-1.x86_64\n--> Processing Dependency: cyrus-sasl-gssapi for package: mssql-server-14.0.3465.1-1.x86_64\n--> Running transaction check\n---> Package bzip2.x86_64 0:1.0.6-13.el7 will be installed\n---> Package cyrus-sasl.x86_64 0:2.1.26-24.el7_9 will be installed\n---> Package cyrus-sasl-gssapi.x86_64 0:2.1.26-24.el7_9 will be installed\n---> Package gdb.x86_64 0:7.6.1-120.el7 will be installed\n---> Package libatomic.x86_64 0:4.8.5-44.el7 will be installed\n---> Package libsss_nss_idmap.x86_64 0:1.16.5-10.el7_9.16 will be installed\n--> Finished Dependency Resolution\n\nDependencies Resolved\n\n================================================================================\n Package Arch Version Repository Size\n================================================================================\nInstalling:\n mssql-server x86_64 14.0.3465.1-1 packages-microsoft-com-mssql-server-2017\n 200 M\nInstalling for dependencies:\n bzip2 x86_64 1.0.6-13.el7 base 52 k\n cyrus-sasl x86_64 2.1.26-24.el7_9 updates 88 k\n cyrus-sasl-gssapi x86_64 2.1.26-24.el7_9 updates 41 k\n gdb x86_64 7.6.1-120.el7 base 2.4 M\n libatomic x86_64 4.8.5-44.el7 base 51 k\n libsss_nss_idmap x86_64 1.16.5-10.el7_9.16 updates 170 k\n\nTransaction Summary\n================================================================================\nInstall 1 Package (+6 Dependent packages)\n\nTotal download size: 203 M\nInstalled size: 1.0 G\nDownloading packages:\n--------------------------------------------------------------------------------\nTotal 66 MB/s | 203 MB 00:03 \nRunning transaction check\nRunning transaction test\nTransaction test succeeded\nRunning transaction\n Installing : libatomic-4.8.5-44.el7.x86_64 1/7 \n Installing : cyrus-sasl-2.1.26-24.el7_9.x86_64 2/7 \n Installing : gdb-7.6.1-120.el7.x86_64 3/7 \n Installing : cyrus-sasl-gssapi-2.1.26-24.el7_9.x86_64 4/7 \n Installing : bzip2-1.0.6-13.el7.x86_64 5/7 \n Installing : libsss_nss_idmap-1.16.5-10.el7_9.16.x86_64 6/7 \n Installing : mssql-server-14.0.3465.1-1.x86_64 7/7 \n\n+--------------------------------------------------------------+\nPlease run 'sudo /opt/mssql/bin/mssql-conf setup'\nto complete the setup of Microsoft SQL Server\n+--------------------------------------------------------------+\n\nSQL Server needs to be restarted in order to apply this setting. Please run\n'systemctl restart mssql-server.service'.\n Verifying : libsss_nss_idmap-1.16.5-10.el7_9.16.x86_64 1/7 \n Verifying : bzip2-1.0.6-13.el7.x86_64 2/7 \n Verifying : mssql-server-14.0.3465.1-1.x86_64 3/7 \n Verifying : cyrus-sasl-gssapi-2.1.26-24.el7_9.x86_64 4/7 \n Verifying : gdb-7.6.1-120.el7.x86_64 5/7 \n Verifying : cyrus-sasl-2.1.26-24.el7_9.x86_64 6/7 \n Verifying : libatomic-4.8.5-44.el7.x86_64 7/7 \n\nInstalled:\n mssql-server.x86_64 0:14.0.3465.1-1 \n\nDependency Installed:\n bzip2.x86_64 0:1.0.6-13.el7 \n cyrus-sasl.x86_64 0:2.1.26-24.el7_9 \n cyrus-sasl-gssapi.x86_64 0:2.1.26-24.el7_9 \n gdb.x86_64 0:7.6.1-120.el7 \n libatomic.x86_64 0:4.8.5-44.el7 \n libsss_nss_idmap.x86_64 0:1.16.5-10.el7_9.16 \n\nComplete!\n" ] } TASK [fedora.linux_system_roles.mssql : Check if the errorlog file exists and its location] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:314 Tuesday 20 May 2025 05:51:05 -0400 (0:00:37.168) 0:00:48.461 *********** ok: [managed-node3] => { "changed": false, "cmd": "set -euo pipefail\nerrorlog=\"$(grep '^errorlogfile = ' /var/opt/mssql/mssql.conf \\\n| sed 's/errorlogfile : //')\" || :\nif [ -s \"${errorlog}\" ]; then\n echo \"${errorlog}\"\nelif [ -s /var/opt/mssql/log/errorlog ]; then\n echo /var/opt/mssql/log/errorlog\nelse\n echo \"\"\nfi\n", "delta": "0:00:00.005156", "end": "2025-05-20 05:51:06.218593", "rc": 0, "start": "2025-05-20 05:51:06.213437" } TASK [fedora.linux_system_roles.mssql : Check if mssql-server.service is enabled] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:331 Tuesday 20 May 2025 05:51:06 -0400 (0:00:00.495) 0:00:48.956 *********** ok: [managed-node3] => { "changed": false, "cmd": [ "systemctl", "is-enabled", "mssql-server.service" ], "delta": "0:00:00.009796", "end": "2025-05-20 05:51:06.548819", "failed_when_result": false, "rc": 1, "start": "2025-05-20 05:51:06.539023" } STDOUT: disabled MSG: non-zero return code TASK [fedora.linux_system_roles.mssql : Check if mssql-server.service is running] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:338 Tuesday 20 May 2025 05:51:06 -0400 (0:00:00.330) 0:00:49.287 *********** ok: [managed-node3] => { "changed": false, "cmd": [ "systemctl", "is-active", "mssql-server.service" ], "delta": "0:00:00.003893", "end": "2025-05-20 05:51:06.864044", "failed_when_result": false, "rc": 3, "start": "2025-05-20 05:51:06.860151" } STDOUT: unknown MSG: non-zero return code TASK [fedora.linux_system_roles.mssql : Set the __mssql_is_setup variable] ***** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:345 Tuesday 20 May 2025 05:51:06 -0400 (0:00:00.314) 0:00:49.601 *********** ok: [managed-node3] => { "ansible_facts": { "__mssql_is_setup": false }, "changed": false } TASK [fedora.linux_system_roles.mssql : Verify that the variables required for setting up MSSQL are defined] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:352 Tuesday 20 May 2025 05:51:07 -0400 (0:00:00.128) 0:00:49.730 *********** fatal: [managed-node3]: FAILED! => { "assertion": "mssql_edition is not none", "changed": false, "evaluated_to": false } MSG: [u'You must define the following variables to set up MSSQL:', u'mssql_password', u'mssql_edition'] TASK [Assert that the role failed with variables undefined] ******************** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_accept_eula.yml:34 Tuesday 20 May 2025 05:51:07 -0400 (0:00:00.072) 0:00:49.803 *********** ok: [managed-node3] => { "changed": false } MSG: All assertions passed TASK [Clean up after the role invocation] ************************************** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_accept_eula.yml:40 Tuesday 20 May 2025 05:51:07 -0400 (0:00:00.069) 0:00:49.872 *********** included: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml for managed-node3 TASK [Gather package facts] **************************************************** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:2 Tuesday 20 May 2025 05:51:07 -0400 (0:00:00.117) 0:00:49.989 *********** ok: [managed-node3] => { "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false } TASK [Set role variables needed for cleanup] *********************************** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:6 Tuesday 20 May 2025 05:51:08 -0400 (0:00:01.159) 0:00:51.149 *********** TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts used by role] ***** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3 Tuesday 20 May 2025 05:51:08 -0400 (0:00:00.127) 0:00:51.276 *********** skipping: [managed-node3] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.mssql : Set platform/version specific variables] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8 Tuesday 20 May 2025 05:51:08 -0400 (0:00:00.083) 0:00:51.360 *********** ok: [managed-node3] => (item=RedHat.yml) => { "ansible_facts": { "__mssql_client_repository": "https://packages.microsoft.com/rhel/9/prod/", "__mssql_confined_supported": true, "__mssql_server_repository": "https://packages.microsoft.com/rhel/9/mssql-server-{{ mssql_version | int }}/", "__mssql_supported_versions": [ 2022 ], "__mssql_tuned_supported": true }, "ansible_included_var_files": [ "/tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/RedHat.yml" ], "ansible_loop_var": "item", "changed": false, "item": "RedHat.yml" } skipping: [managed-node3] => (item=CentOS.yml) => { "ansible_loop_var": "item", "changed": false, "item": "CentOS.yml", "skip_reason": "Conditional result was False" } ok: [managed-node3] => (item=CentOS_7.yml) => { "ansible_facts": { "__mssql_client_repository": "https://packages.microsoft.com/rhel/7/prod/", "__mssql_confined_supported": false, "__mssql_server_repository": "https://packages.microsoft.com/rhel/7/mssql-server-{{ mssql_version | int }}/", "__mssql_supported_versions": [ 2017, 2019 ] }, "ansible_included_var_files": [ "/tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/CentOS_7.yml" ], "ansible_loop_var": "item", "changed": false, "item": "CentOS_7.yml" } skipping: [managed-node3] => (item=CentOS_7.9.yml) => { "ansible_loop_var": "item", "changed": false, "item": "CentOS_7.9.yml", "skip_reason": "Conditional result was False" } TASK [Purge cluster configuration] ********************************************* task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:12 Tuesday 20 May 2025 05:51:08 -0400 (0:00:00.109) 0:00:51.470 *********** skipping: [managed-node3] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [Debug ansible_python_version] ******************************************** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:20 Tuesday 20 May 2025 05:51:08 -0400 (0:00:00.078) 0:00:51.548 *********** ok: [managed-node3] => { "ansible_python_version": "2.7.5" } TASK [Purge firewall configuration] ******************************************** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:24 Tuesday 20 May 2025 05:51:08 -0400 (0:00:00.067) 0:00:51.616 *********** TASK [fedora.linux_system_roles.firewall : Setup firewalld] ******************** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/main.yml:2 Tuesday 20 May 2025 05:51:09 -0400 (0:00:00.235) 0:00:51.852 *********** included: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml for managed-node3 TASK [fedora.linux_system_roles.firewall : Ensure ansible_facts used by role] *** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:2 Tuesday 20 May 2025 05:51:09 -0400 (0:00:00.122) 0:00:51.974 *********** skipping: [managed-node3] => { "changed": false, "skip_reason": "Conditional result was False" } TASK [fedora.linux_system_roles.firewall : Check if system is ostree] ********** task path: /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/firewall/tasks/firewalld.yml:10 Tuesday 20 May 2025 05:51:09 -0400 (0:00:00.080) 0:00:52.054 *********** fatal: [managed-node3]: UNREACHABLE! => { "changed": false, "unreachable": true } MSG: Failed to connect to the host via ssh: ssh: connect to host 10.31.46.237 port 22: Connection refused PLAY RECAP ********************************************************************* managed-node3 : ok=22 changed=3 unreachable=1 failed=0 skipped=31 rescued=1 ignored=0 Tuesday 20 May 2025 05:51:09 -0400 (0:00:00.034) 0:00:52.089 *********** =============================================================================== fedora.linux_system_roles.mssql : Ensure the package mssql-server ------ 37.17s /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:309 fedora.linux_system_roles.mssql : Gather package facts ------------------ 2.12s /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:162 Gathering Facts --------------------------------------------------------- 1.67s /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_accept_eula.yml:9 Gather package facts ---------------------------------------------------- 1.16s /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:2 fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories --- 1.12s /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:202 fedora.linux_system_roles.mssql : Configure to run as a confined application with SELinux --- 0.94s /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:304 Run the role with default parameters ------------------------------------ 0.89s /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_accept_eula.yml:25 fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server repo version 2017 --- 0.71s /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:279 fedora.linux_system_roles.mssql : Check if the errorlog file exists and its location --- 0.50s /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:314 fedora.linux_system_roles.mssql : Check if mssql-server.service is enabled --- 0.33s /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:331 fedora.linux_system_roles.mssql : Check if mssql-server.service is running --- 0.31s /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:338 fedora.linux_system_roles.mssql : Get zypper repositories --------------- 0.31s /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:260 fedora.linux_system_roles.mssql : Set fact with the currently installed SQL Server version if any --- 0.27s /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:166 Purge firewall configuration -------------------------------------------- 0.24s /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:24 fedora.linux_system_roles.mssql : Remove the current Microsoft SQL Server repository to upgrade to 2017 --- 0.20s /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:237 fedora.linux_system_roles.mssql : Update all packages from SQL Server repo version {{ __mssql_current_version }} --- 0.20s /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:251 fedora.linux_system_roles.mssql : Remove the current Microsoft SQL Server repository to upgrade to 2017 --- 0.20s /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:272 fedora.linux_system_roles.mssql : Verify if mssql_version is not smaller then the existing SQL Server version --- 0.18s /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:188 fedora.linux_system_roles.mssql : Update all packages from SQL Server repo version {{ __mssql_current_version }} --- 0.16s /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:216 fedora.linux_system_roles.mssql : Get yum repositories ------------------ 0.15s /tmp/collections-xwS/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:226