ansible-playbook [core 2.16.14]
  config file = None
  configured module search path = ['/root/.ansible/plugins/modules', '/usr/share/ansible/plugins/modules']
  ansible python module location = /usr/local/lib/python3.12/site-packages/ansible
  ansible collection location = /tmp/collections-5YH
  executable location = /usr/local/bin/ansible-playbook
  python version = 3.12.1 (main, Feb 21 2024, 14:18:26) [GCC 8.5.0 20210514 (Red Hat 8.5.0-21)] (/usr/bin/python3.12)
  jinja version = 3.1.6
  libyaml = True
No config file found; using defaults
running playbook inside collection fedora.linux_system_roles
redirecting (type: callback) ansible.builtin.debug to ansible.posix.debug
redirecting (type: callback) ansible.builtin.debug to ansible.posix.debug
redirecting (type: callback) ansible.builtin.profile_tasks to ansible.posix.profile_tasks
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: tests_tls_2017.yml ***************************************************
2 plays in /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_tls_2017.yml

PLAY [all] *********************************************************************

TASK [Include vault variables] *************************************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_tls_2017.yml:5
Wednesday 14 May 2025  12:46:53 -0400 (0:00:00.008)       0:00:00.008 ********* 
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-a6h/tests/vars/vault-variables.yml"
    ],
    "changed": false
}

PLAY [Ensure that tls encryption configuration works] **************************

TASK [Gathering Facts] *********************************************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_tls_2017.yml:9
Wednesday 14 May 2025  12:46:53 -0400 (0:00:00.016)       0:00:00.024 ********* 
ok: [managed-node3]

TASK [Run tests_tls with SQL Server 2017] **************************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_tls_2017.yml:24
Wednesday 14 May 2025  12:46:55 -0400 (0:00:01.506)       0:00:01.530 ********* 
included: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml for managed-node3

TASK [Assert fail on EL 7 with version = 2022 and EL 9 with version != 2022] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:2
Wednesday 14 May 2025  12:46:55 -0400 (0:00:00.126)       0:00:01.657 ********* 
included: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml for managed-node3

TASK [Ensure ansible_facts to get ansible_distribution] ************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:2
Wednesday 14 May 2025  12:46:55 -0400 (0:00:00.040)       0:00:01.698 ********* 
ok: [managed-node3]

TASK [Run the role] ************************************************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:17
Wednesday 14 May 2025  12:46:56 -0400 (0:00:00.664)       0:00:02.362 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "(ansible_distribution in ['CentOS', 'RedHat'] and ansible_distribution_major_version is version('7', '=') and mssql_version | int == 2022) or (((ansible_distribution in ['CentOS', 'RedHat'] and ansible_distribution_major_version is version('9', '=')) or (ansible_distribution in ['Fedora'])) and mssql_version | int != 2022)",
    "skip_reason": "Conditional result was False"
}

TASK [Unreachable task] ********************************************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/assert_fail_on_unsupported_ver.yml:24
Wednesday 14 May 2025  12:46:56 -0400 (0:00:00.055)       0:00:02.418 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "(ansible_distribution in ['CentOS', 'RedHat'] and ansible_distribution_major_version is version('7', '=') and mssql_version | int == 2022) or (((ansible_distribution in ['CentOS', 'RedHat'] and ansible_distribution_major_version is version('9', '=')) or (ansible_distribution in ['Fedora'])) and mssql_version | int != 2022)",
    "skip_reason": "Conditional result was False"
}

TASK [Ensure the openssl package] **********************************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:5
Wednesday 14 May 2025  12:46:56 -0400 (0:00:00.056)       0:00:02.474 ********* 
ok: [managed-node3] => {
    "changed": false,
    "rc": 0,
    "results": []
}

MSG:

Nothing to do

TASK [Create a tempfile for a certificate on hosts] ****************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:11
Wednesday 14 May 2025  12:46:59 -0400 (0:00:02.950)       0:00:05.425 ********* 
changed: [managed-node3] => {
    "changed": true,
    "gid": 0,
    "group": "root",
    "mode": "0600",
    "owner": "root",
    "path": "/tmp/ansible.tcx5x7hz",
    "secontext": "unconfined_u:object_r:user_tmp_t:s0",
    "size": 0,
    "state": "file",
    "uid": 0
}

TASK [Create a tempfile for a private key on hosts] ****************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:17
Wednesday 14 May 2025  12:46:59 -0400 (0:00:00.456)       0:00:05.882 ********* 
changed: [managed-node3] => {
    "changed": true,
    "gid": 0,
    "group": "root",
    "mode": "0600",
    "owner": "root",
    "path": "/tmp/ansible.jahlsqzq",
    "secontext": "unconfined_u:object_r:user_tmp_t:s0",
    "size": 0,
    "state": "file",
    "uid": 0
}

TASK [Generate a self-signed certificate and public key] ***********************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:23
Wednesday 14 May 2025  12:46:59 -0400 (0:00:00.314)       0:00:06.196 ********* 
changed: [managed-node3] => {
    "changed": true,
    "cmd": [
        "openssl",
        "req",
        "-x509",
        "-nodes",
        "-newkey",
        "rsa:2048",
        "-subj",
        "/CN=10.31.47.206",
        "-out",
        "/tmp/ansible.tcx5x7hz",
        "-keyout",
        "/tmp/ansible.jahlsqzq",
        "-days",
        "365"
    ],
    "delta": "0:00:00.154856",
    "end": "2025-05-14 12:47:00.359917",
    "rc": 0,
    "start": "2025-05-14 12:47:00.205061"
}

STDERR:

Generating a RSA private key
.................................................................................................................+++++
..............+++++
writing new private key to '/tmp/ansible.jahlsqzq'
-----

TASK [Copy certificate files to local tmp] *************************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:32
Wednesday 14 May 2025  12:47:00 -0400 (0:00:00.562)       0:00:06.759 ********* 
changed: [managed-node3] => (item=/tmp/ansible.tcx5x7hz) => {
    "ansible_loop_var": "item",
    "changed": true,
    "checksum": "02b0f66177385cbaa115360b605ad35d966997b3",
    "dest": "/tmp/ansible.tcx5x7hz",
    "item": "/tmp/ansible.tcx5x7hz",
    "md5sum": "db510007449013ae97a9d152725f93bd",
    "remote_checksum": "02b0f66177385cbaa115360b605ad35d966997b3",
    "remote_md5sum": null
}
changed: [managed-node3] => (item=/tmp/ansible.jahlsqzq) => {
    "ansible_loop_var": "item",
    "changed": true,
    "checksum": "74600b225453a6c4a2d22ec42e8bd28f64457d9e",
    "dest": "/tmp/ansible.jahlsqzq",
    "item": "/tmp/ansible.jahlsqzq",
    "md5sum": "611e499f951c3cc15de6c5051f9b25f5",
    "remote_checksum": "74600b225453a6c4a2d22ec42e8bd28f64457d9e",
    "remote_md5sum": null
}

TASK [Copy a private key to the playbook directory to test a relative path] ****
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:44
Wednesday 14 May 2025  12:47:01 -0400 (0:00:00.781)       0:00:07.541 ********* 
changed: [managed-node3 -> localhost] => {
    "changed": true,
    "checksum": "74600b225453a6c4a2d22ec42e8bd28f64457d9e",
    "dest": "./ansible.jahlsqzq",
    "gid": 0,
    "group": "root",
    "md5sum": "611e499f951c3cc15de6c5051f9b25f5",
    "mode": "0600",
    "owner": "root",
    "secontext": "unconfined_u:object_r:admin_home_t:s0",
    "size": 1704,
    "src": "/root/.ansible/tmp/ansible-tmp-1747241221.221957-51973-252774281237423/source",
    "state": "file",
    "uid": 0
}

TASK [Set mssql_tls_cert and mssql_tls_private_key for the following test] *****
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:52
Wednesday 14 May 2025  12:47:01 -0400 (0:00:00.579)       0:00:08.120 ********* 
ok: [managed-node3] => {
    "ansible_facts": {
        "mssql_tls_cert": "/tmp/ansible.tcx5x7hz",
        "mssql_tls_private_key": "ansible.jahlsqzq"
    },
    "changed": false
}

TASK [Run role] ****************************************************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:59
Wednesday 14 May 2025  12:47:01 -0400 (0:00:00.038)       0:00:08.159 ********* 

TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3
Wednesday 14 May 2025  12:47:02 -0400 (0:00:00.199)       0:00:08.358 ********* 
included: /tmp/collections-5YH/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-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3
Wednesday 14 May 2025  12:47:02 -0400 (0:00:00.024)       0:00:08.383 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_required_facts | difference(ansible_facts.keys() | list) | length > 0",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Set platform/version specific variables] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8
Wednesday 14 May 2025  12:47:02 -0400 (0:00:00.035)       0:00:08.419 ********* 
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-5YH/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,
    "false_condition": "__mssql_vars_file is file",
    "item": "CentOS.yml",
    "skip_reason": "Conditional result was False"
}
ok: [managed-node3] => (item=CentOS_8.yml) => {
    "ansible_facts": {
        "__mssql_client_repository": "https://packages.microsoft.com/rhel/8/prod/",
        "__mssql_confined_supported": false,
        "__mssql_server_repository": "https://packages.microsoft.com/rhel/8/mssql-server-{{ mssql_version | int }}/",
        "__mssql_supported_versions": [
            2017,
            2019,
            2022
        ]
    },
    "ansible_included_var_files": [
        "/tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/CentOS_8.yml"
    ],
    "ansible_loop_var": "item",
    "changed": false,
    "item": "CentOS_8.yml"
}
ok: [managed-node3] => (item=CentOS_8.yml) => {
    "ansible_facts": {
        "__mssql_client_repository": "https://packages.microsoft.com/rhel/8/prod/",
        "__mssql_confined_supported": false,
        "__mssql_server_repository": "https://packages.microsoft.com/rhel/8/mssql-server-{{ mssql_version | int }}/",
        "__mssql_supported_versions": [
            2017,
            2019,
            2022
        ]
    },
    "ansible_included_var_files": [
        "/tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/CentOS_8.yml"
    ],
    "ansible_loop_var": "item",
    "changed": false,
    "item": "CentOS_8.yml"
}

TASK [fedora.linux_system_roles.mssql : Run systemctl] *************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:22
Wednesday 14 May 2025  12:47:02 -0400 (0:00:00.041)       0:00:08.461 ********* 
ok: [managed-node3] => {
    "changed": false,
    "cmd": [
        "systemctl",
        "is-system-running"
    ],
    "delta": "0:00:00.006988",
    "end": "2025-05-14 12:47:02.396918",
    "failed_when_result": false,
    "rc": 0,
    "start": "2025-05-14 12:47:02.389930"
}

STDOUT:

running

TASK [fedora.linux_system_roles.mssql : Require installed systemd] *************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:29
Wednesday 14 May 2025  12:47:02 -0400 (0:00:00.336)       0:00:08.797 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "\"No such file or directory\" in __is_system_running.msg | d(\"\")",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Set flag to indicate that systemd runtime operations are available] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:34
Wednesday 14 May 2025  12:47:02 -0400 (0:00:00.038)       0:00:08.835 ********* 
ok: [managed-node3] => {
    "ansible_facts": {
        "__mssql_is_booted": true
    },
    "changed": false
}

TASK [fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8
Wednesday 14 May 2025  12:47:02 -0400 (0:00:00.022)       0:00:08.857 ********* 
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-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:15
Wednesday 14 May 2025  12:47:02 -0400 (0:00:00.016)       0:00:08.873 ********* 
skipping: [managed-node3] => {
    "false_condition": "mssql_input_sql_file is defined"
}

TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_input_sql_file fact] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:23
Wednesday 14 May 2025  12:47:02 -0400 (0:00:00.018)       0:00:08.892 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_input_sql_file is defined",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Print that the variable is deprecated] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:30
Wednesday 14 May 2025  12:47:02 -0400 (0:00:00.020)       0:00:08.912 ********* 
skipping: [managed-node3] => {
    "false_condition": "mssql_ha_listener_port is defined"
}

TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_ha_listener_port fact] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:37
Wednesday 14 May 2025  12:47:02 -0400 (0:00:00.024)       0:00:08.937 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_listener_port is defined",
    "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-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:44
Wednesday 14 May 2025  12:47:02 -0400 (0:00:00.026)       0:00:08.963 ********* 
skipping: [managed-node3] => {
    "false_condition": "mssql_ad_sql_user_name is defined"
}

TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_ad_sql_user_name fact] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:51
Wednesday 14 May 2025  12:47:02 -0400 (0:00:00.027)       0:00:08.991 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ad_sql_user_name is defined",
    "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-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:58
Wednesday 14 May 2025  12:47:02 -0400 (0:00:00.028)       0:00:09.020 ********* 
skipping: [managed-node3] => {
    "false_condition": "mssql_ha_cluster_run_role is defined"
}

TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_ha_cluster_run_role fact] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:65
Wednesday 14 May 2025  12:47:02 -0400 (0:00:00.038)       0:00:09.058 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_cluster_run_role is defined",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Print that variable is deprecated] *****
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:74
Wednesday 14 May 2025  12:47:02 -0400 (0:00:00.035)       0:00:09.094 ********* 
skipping: [managed-node3] => {
    "false_condition": "mssql_accept_microsoft_odbc_driver_17_for_sql_server_eula is defined"
}

TASK [fedora.linux_system_roles.mssql : Link the deprecated fact] **************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:83
Wednesday 14 May 2025  12:47:02 -0400 (0:00:00.028)       0:00:09.123 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_accept_microsoft_odbc_driver_17_for_sql_server_eula is defined",
    "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-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:87
Wednesday 14 May 2025  12:47:02 -0400 (0:00:00.029)       0:00:09.152 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "ansible_distribution_major_version is version('10', '=')",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Verify that the user accepts EULA variables] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:94
Wednesday 14 May 2025  12:47:02 -0400 (0:00:00.028)       0:00:09.180 ********* 
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-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:106
Wednesday 14 May 2025  12:47:02 -0400 (0:00:00.059)       0:00:09.240 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "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-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:114
Wednesday 14 May 2025  12:47:02 -0400 (0:00:00.062)       0:00:09.302 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "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-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:123
Wednesday 14 May 2025  12:47:03 -0400 (0:00:00.077)       0:00:09.380 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "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-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:132
Wednesday 14 May 2025  12:47:03 -0400 (0:00:00.049)       0:00:09.430 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_ag_cluster_type | lower == 'none'",
    "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-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:142
Wednesday 14 May 2025  12:47:03 -0400 (0:00:00.044)       0:00:09.474 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "(mssql_manage_selinux | bool) or (mssql_run_selinux_confined | bool)",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Verify that mssql_manage_selinux is set properly] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:151
Wednesday 14 May 2025  12:47:03 -0400 (0:00:00.048)       0:00:09.523 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_manage_selinux | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Gather package facts] ******************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:162
Wednesday 14 May 2025  12:47:03 -0400 (0:00:00.039)       0:00:09.563 ********* 
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-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:166
Wednesday 14 May 2025  12:47:04 -0400 (0:00:01.677)       0:00:11.241 ********* 
skipping: [managed-node3] => (item={'key': 2017, 'value': 14})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "ansible_facts.packages[\"mssql-server\"][0][\"version\"] is defined",
    "item": {
        "key": 2017,
        "value": 14
    },
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node3] => (item={'key': 2019, 'value': 15})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "ansible_facts.packages[\"mssql-server\"][0][\"version\"] is defined",
    "item": {
        "key": 2019,
        "value": 15
    },
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node3] => (item={'key': 2022, 'value': 16})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "ansible_facts.packages[\"mssql-server\"][0][\"version\"] is defined",
    "item": {
        "key": 2022,
        "value": 16
    },
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node3] => {
    "changed": false
}

MSG:

All items skipped

TASK [fedora.linux_system_roles.mssql : Set mssql_version variable if user does not define it] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:174
Wednesday 14 May 2025  12:47:04 -0400 (0:00:00.052)       0:00:11.293 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_version is none",
    "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-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:181
Wednesday 14 May 2025  12:47:04 -0400 (0:00:00.031)       0:00:11.325 ********* 
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-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:188
Wednesday 14 May 2025  12:47:05 -0400 (0:00:00.051)       0:00:11.377 ********* 
skipping: [managed-node3] => (item={'key': 2017, 'value': 14})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "ansible_facts.packages[\"mssql-server\"][0][\"version\"] is defined",
    "item": {
        "key": 2017,
        "value": 14
    },
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node3] => (item={'key': 2019, 'value': 15})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "mssql_version | int == item.key",
    "item": {
        "key": 2019,
        "value": 15
    },
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node3] => (item={'key': 2022, 'value': 16})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "mssql_version | int == item.key",
    "item": {
        "key": 2022,
        "value": 16
    },
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node3] => {
    "changed": false
}

MSG:

All items skipped

TASK [fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:202
Wednesday 14 May 2025  12:47:05 -0400 (0:00:00.068)       0:00:11.445 ********* 
ok: [managed-node3] => {
    "attempts": 1,
    "changed": false
}

TASK [fedora.linux_system_roles.mssql : Update all packages from SQL Server repo version {{ __mssql_current_version }}] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:216
Wednesday 14 May 2025  12:47:05 -0400 (0:00:00.660)       0:00:12.105 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_current_version is defined",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Get yum repositories] ******************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:226
Wednesday 14 May 2025  12:47:05 -0400 (0:00:00.032)       0:00:12.137 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_current_version is defined",
    "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-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:237
Wednesday 14 May 2025  12:47:05 -0400 (0:00:00.060)       0:00:12.198 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_current_version is defined",
    "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-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:251
Wednesday 14 May 2025  12:47:05 -0400 (0:00:00.036)       0:00:12.234 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_current_version is defined",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Get zypper repositories] ***************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:260
Wednesday 14 May 2025  12:47:05 -0400 (0:00:00.045)       0:00:12.280 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_current_version is defined",
    "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-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:272
Wednesday 14 May 2025  12:47:05 -0400 (0:00:00.049)       0:00:12.330 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_current_version is defined",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server repo version 2017] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:279
Wednesday 14 May 2025  12:47:06 -0400 (0:00:00.037)       0:00:12.368 ********* 
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-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:291
Wednesday 14 May 2025  12:47:06 -0400 (0:00:00.490)       0:00:12.858 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "ansible_pkg_mgr == \"zypper\"",
    "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-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:304
Wednesday 14 May 2025  12:47:06 -0400 (0:00:00.043)       0:00:12.902 ********* 
ok: [managed-node3] => {
    "changed": false,
    "rc": 0,
    "results": []
}

MSG:

Nothing to do

TASK [fedora.linux_system_roles.mssql : Ensure the package mssql-server] *******
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:309
Wednesday 14 May 2025  12:47:09 -0400 (0:00:02.968)       0:00:15.871 ********* 
changed: [managed-node3] => {
    "changed": true,
    "rc": 0,
    "results": [
        "Installed: gcc-gdb-plugin-8.5.0-22.el8.x86_64",
        "Installed: gdb-8.2-20.el8.x86_64",
        "Installed: libipt-1.6.1-8.el8.x86_64",
        "Installed: guile-5:2.0.14-7.el8.x86_64",
        "Installed: gdb-headless-8.2-20.el8.x86_64",
        "Installed: python2-setuptools-39.0.1-14.module_el8+733+876ccfdb.noarch",
        "Installed: libtool-ltdl-2.4.6-25.el8.x86_64",
        "Installed: python2-libs-2.7.18-17.module_el8+770+d35395c9.x86_64",
        "Installed: bzip2-1.0.6-26.el8.x86_64",
        "Installed: python2-setuptools-wheel-39.0.1-14.module_el8+733+876ccfdb.noarch",
        "Installed: python2-2.7.18-17.module_el8+770+d35395c9.x86_64",
        "Installed: lsof-4.93.2-1.el8.x86_64",
        "Installed: python2-pip-9.0.3-19.module_el8+570+db61b4f9.noarch",
        "Installed: mssql-server-14.0.3490.10-4.x86_64",
        "Installed: libatomic-8.5.0-22.el8.x86_64",
        "Installed: libatomic_ops-7.6.2-3.el8.x86_64",
        "Installed: python2-pip-wheel-9.0.3-19.module_el8+570+db61b4f9.noarch",
        "Installed: gc-7.6.4-3.el8.x86_64",
        "Installed: cyrus-sasl-2.1.27-6.el8_5.x86_64",
        "Installed: libbabeltrace-1.5.4-4.el8.x86_64",
        "Installed: cyrus-sasl-gssapi-2.1.27-6.el8_5.x86_64"
    ]
}

TASK [fedora.linux_system_roles.mssql : Check if the errorlog file exists and its location] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:314
Wednesday 14 May 2025  12:47:47 -0400 (0:00:38.343)       0:00:54.214 ********* 
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.004269",
    "end": "2025-05-14 12:47:48.140300",
    "rc": 0,
    "start": "2025-05-14 12:47:48.136031"
}

TASK [fedora.linux_system_roles.mssql : Check if mssql-server.service is enabled] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:331
Wednesday 14 May 2025  12:47:48 -0400 (0:00:00.336)       0:00:54.551 ********* 
ok: [managed-node3] => {
    "changed": false,
    "cmd": [
        "systemctl",
        "is-enabled",
        "mssql-server.service"
    ],
    "delta": "0:00:00.009694",
    "end": "2025-05-14 12:47:48.481045",
    "failed_when_result": false,
    "rc": 1,
    "start": "2025-05-14 12:47:48.471351"
}

STDOUT:

disabled


MSG:

non-zero return code

TASK [fedora.linux_system_roles.mssql : Check if mssql-server.service is running] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:338
Wednesday 14 May 2025  12:47:48 -0400 (0:00:00.342)       0:00:54.894 ********* 
ok: [managed-node3] => {
    "changed": false,
    "cmd": [
        "systemctl",
        "is-active",
        "mssql-server.service"
    ],
    "delta": "0:00:00.008482",
    "end": "2025-05-14 12:47:48.817422",
    "failed_when_result": false,
    "rc": 3,
    "start": "2025-05-14 12:47:48.808940"
}

STDOUT:

inactive


MSG:

non-zero return code

TASK [fedora.linux_system_roles.mssql : Set the __mssql_is_setup variable] *****
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:345
Wednesday 14 May 2025  12:47:48 -0400 (0:00:00.333)       0:00:55.227 ********* 
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-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:352
Wednesday 14 May 2025  12:47:48 -0400 (0:00:00.055)       0:00:55.282 ********* 
ok: [managed-node3] => {
    "changed": false
}

MSG:

All assertions passed

TASK [fedora.linux_system_roles.mssql : Set up MSSQL] **************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:368
Wednesday 14 May 2025  12:47:48 -0400 (0:00:00.037)       0:00:55.320 ********* 
changed: [managed-node3] => {
    "attempts": 1,
    "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result",
    "changed": true
}

TASK [fedora.linux_system_roles.mssql : Ensure the directory and permissions for datadir and logdir] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:398
Wednesday 14 May 2025  12:47:53 -0400 (0:00:04.422)       0:00:59.742 ********* 
skipping: [managed-node3] => (item={'path': None, 'mode': '755', 'setting': 'defaultdatadir'})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "item.path is not none",
    "item": {
        "mode": "755",
        "path": null,
        "setting": "defaultdatadir"
    },
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node3] => (item={'path': None, 'mode': '755', 'setting': 'defaultlogdir'})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "item.path is not none",
    "item": {
        "mode": "755",
        "path": null,
        "setting": "defaultlogdir"
    },
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node3] => {
    "changed": false
}

MSG:

All items skipped

TASK [fedora.linux_system_roles.mssql : Set selinux role facts for ports] ******
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:413
Wednesday 14 May 2025  12:47:53 -0400 (0:00:00.045)       0:00:59.787 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_manage_selinux | bool",
    "skip_reason": "Conditional result was False"
}

TASK [Ensure correct SELinux context for storage paths and ports] **************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:427
Wednesday 14 May 2025  12:47:53 -0400 (0:00:00.050)       0:00:59.837 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_manage_selinux | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Ensure that the tuned-profiles-mssql package is installed] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:438
Wednesday 14 May 2025  12:47:53 -0400 (0:00:00.045)       0:00:59.883 ********* 
ok: [managed-node3] => {
    "changed": false,
    "rc": 0,
    "results": []
}

MSG:

Nothing to do

TASK [fedora.linux_system_roles.mssql : Ensure that the tuned service is enabled] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:444
Wednesday 14 May 2025  12:47:56 -0400 (0:00:03.199)       0:01:03.082 ********* 
ok: [managed-node3] => {
    "changed": false,
    "enabled": true,
    "name": "tuned",
    "status": {
        "ActiveEnterTimestamp": "Wed 2025-05-14 12:19:23 EDT",
        "ActiveEnterTimestampMonotonic": "15850565",
        "ActiveExitTimestampMonotonic": "0",
        "ActiveState": "active",
        "After": "systemd-sysctl.service sysinit.target system.slice network.target basic.target polkit.service systemd-journald.socket dbus.socket dbus.service",
        "AllowIsolate": "no",
        "AllowedCPUs": "",
        "AllowedMemoryNodes": "",
        "AmbientCapabilities": "",
        "AssertResult": "yes",
        "AssertTimestamp": "Wed 2025-05-14 12:19:22 EDT",
        "AssertTimestampMonotonic": "14290150",
        "Before": "multi-user.target shutdown.target",
        "BlockIOAccounting": "no",
        "BlockIOWeight": "[not set]",
        "BusName": "com.redhat.tuned",
        "CPUAccounting": "no",
        "CPUAffinity": "",
        "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",
        "CollectMode": "inactive",
        "ConditionResult": "yes",
        "ConditionTimestamp": "Wed 2025-05-14 12:19:22 EDT",
        "ConditionTimestampMonotonic": "14290149",
        "ConfigurationDirectoryMode": "0755",
        "Conflicts": "cpupower.service tlp.service power-profiles-daemon.service auto-cpufreq.service shutdown.target",
        "ControlGroup": "/system.slice/tuned.service",
        "ControlPID": "0",
        "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",
        "EffectiveCPUs": "",
        "EffectiveMemoryNodes": "",
        "ExecMainCode": "0",
        "ExecMainExitTimestampMonotonic": "0",
        "ExecMainPID": "695",
        "ExecMainStartTimestamp": "Wed 2025-05-14 12:19:22 EDT",
        "ExecMainStartTimestampMonotonic": "14290855",
        "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 }",
        "FailureAction": "none",
        "FileDescriptorStoreMax": "0",
        "FragmentPath": "/usr/lib/systemd/system/tuned.service",
        "FreezerState": "running",
        "GID": "[not set]",
        "GuessMainPID": "yes",
        "IOAccounting": "no",
        "IOSchedulingClass": "0",
        "IOSchedulingPriority": "0",
        "IOWeight": "[not set]",
        "IPAccounting": "no",
        "IPEgressBytes": "18446744073709551615",
        "IPEgressPackets": "18446744073709551615",
        "IPIngressBytes": "18446744073709551615",
        "IPIngressPackets": "18446744073709551615",
        "Id": "tuned.service",
        "IgnoreOnIsolate": "no",
        "IgnoreSIGPIPE": "yes",
        "InactiveEnterTimestampMonotonic": "0",
        "InactiveExitTimestamp": "Wed 2025-05-14 12:19:22 EDT",
        "InactiveExitTimestampMonotonic": "14290894",
        "InvocationID": "387dbc3035f44087a5a53a4ed1de7ab2",
        "JobRunningTimeoutUSec": "infinity",
        "JobTimeoutAction": "none",
        "JobTimeoutUSec": "infinity",
        "KeyringMode": "private",
        "KillMode": "control-group",
        "KillSignal": "15",
        "LimitAS": "infinity",
        "LimitASSoft": "infinity",
        "LimitCORE": "infinity",
        "LimitCORESoft": "0",
        "LimitCPU": "infinity",
        "LimitCPUSoft": "infinity",
        "LimitDATA": "infinity",
        "LimitDATASoft": "infinity",
        "LimitFSIZE": "infinity",
        "LimitFSIZESoft": "infinity",
        "LimitLOCKS": "infinity",
        "LimitLOCKSSoft": "infinity",
        "LimitMEMLOCK": "65536",
        "LimitMEMLOCKSoft": "65536",
        "LimitMSGQUEUE": "819200",
        "LimitMSGQUEUESoft": "819200",
        "LimitNICE": "0",
        "LimitNICESoft": "0",
        "LimitNOFILE": "262144",
        "LimitNOFILESoft": "1024",
        "LimitNPROC": "28608",
        "LimitNPROCSoft": "28608",
        "LimitRSS": "infinity",
        "LimitRSSSoft": "infinity",
        "LimitRTPRIO": "0",
        "LimitRTPRIOSoft": "0",
        "LimitRTTIME": "infinity",
        "LimitRTTIMESoft": "infinity",
        "LimitSIGPENDING": "28608",
        "LimitSIGPENDINGSoft": "28608",
        "LimitSTACK": "infinity",
        "LimitSTACKSoft": "8388608",
        "LoadState": "loaded",
        "LockPersonality": "no",
        "LogLevelMax": "-1",
        "LogRateLimitBurst": "0",
        "LogRateLimitIntervalUSec": "0",
        "LogsDirectoryMode": "0755",
        "MainPID": "695",
        "MemoryAccounting": "yes",
        "MemoryCurrent": "21356544",
        "MemoryDenyWriteExecute": "no",
        "MemoryHigh": "infinity",
        "MemoryLimit": "infinity",
        "MemoryLow": "0",
        "MemoryMax": "infinity",
        "MemoryMin": "0",
        "MemorySwapMax": "infinity",
        "MountAPIVFS": "no",
        "MountFlags": "",
        "NFileDescriptorStore": "0",
        "NRestarts": "0",
        "NUMAMask": "",
        "NUMAPolicy": "n/a",
        "Names": "tuned.service",
        "NeedDaemonReload": "no",
        "Nice": "0",
        "NoNewPrivileges": "no",
        "NonBlocking": "no",
        "NotifyAccess": "none",
        "OOMScoreAdjust": "0",
        "OnFailureJobMode": "replace",
        "PIDFile": "/run/tuned/tuned.pid",
        "PermissionsStartOnly": "no",
        "Perpetual": "no",
        "PrivateDevices": "no",
        "PrivateMounts": "no",
        "PrivateNetwork": "no",
        "PrivateTmp": "no",
        "PrivateUsers": "no",
        "ProtectControlGroups": "no",
        "ProtectHome": "no",
        "ProtectKernelModules": "no",
        "ProtectKernelTunables": "no",
        "ProtectSystem": "no",
        "RefuseManualStart": "no",
        "RefuseManualStop": "no",
        "RemainAfterExit": "no",
        "RemoveIPC": "no",
        "Requires": "system.slice sysinit.target dbus.service dbus.socket",
        "Restart": "no",
        "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",
        "StandardInputData": "",
        "StandardOutput": "journal",
        "StartLimitAction": "none",
        "StartLimitBurst": "5",
        "StartLimitIntervalUSec": "10s",
        "StartupBlockIOWeight": "[not set]",
        "StartupCPUShares": "[not set]",
        "StartupCPUWeight": "[not set]",
        "StartupIOWeight": "[not set]",
        "StateChangeTimestamp": "Wed 2025-05-14 12:19:23 EDT",
        "StateChangeTimestampMonotonic": "15850565",
        "StateDirectoryMode": "0755",
        "StatusErrno": "0",
        "StopWhenUnneeded": "no",
        "SubState": "running",
        "SuccessAction": "none",
        "SyslogFacility": "3",
        "SyslogLevel": "6",
        "SyslogLevelPrefix": "yes",
        "SyslogPriority": "30",
        "SystemCallErrorNumber": "0",
        "TTYReset": "no",
        "TTYVHangup": "no",
        "TTYVTDisallocate": "no",
        "TasksAccounting": "yes",
        "TasksCurrent": "4",
        "TasksMax": "45773",
        "TimeoutStartUSec": "1min 30s",
        "TimeoutStopUSec": "1min 30s",
        "TimerSlackNSec": "50000",
        "Transient": "no",
        "Type": "dbus",
        "UID": "[not set]",
        "UMask": "0022",
        "UnitFilePreset": "enabled",
        "UnitFileState": "enabled",
        "UtmpMode": "init",
        "WantedBy": "multi-user.target",
        "WatchdogTimestamp": "Wed 2025-05-14 12:19:23 EDT",
        "WatchdogTimestampMonotonic": "15850562",
        "WatchdogUSec": "0"
    }
}

TASK [fedora.linux_system_roles.mssql : Ensure that the tuned service is started] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:450
Wednesday 14 May 2025  12:47:57 -0400 (0:00:00.754)       0:01:03.837 ********* 
ok: [managed-node3] => {
    "changed": false,
    "name": "tuned",
    "state": "started",
    "status": {
        "ActiveEnterTimestamp": "Wed 2025-05-14 12:19:23 EDT",
        "ActiveEnterTimestampMonotonic": "15850565",
        "ActiveExitTimestampMonotonic": "0",
        "ActiveState": "active",
        "After": "systemd-sysctl.service sysinit.target system.slice network.target basic.target polkit.service systemd-journald.socket dbus.socket dbus.service",
        "AllowIsolate": "no",
        "AllowedCPUs": "",
        "AllowedMemoryNodes": "",
        "AmbientCapabilities": "",
        "AssertResult": "yes",
        "AssertTimestamp": "Wed 2025-05-14 12:19:22 EDT",
        "AssertTimestampMonotonic": "14290150",
        "Before": "multi-user.target shutdown.target",
        "BlockIOAccounting": "no",
        "BlockIOWeight": "[not set]",
        "BusName": "com.redhat.tuned",
        "CPUAccounting": "no",
        "CPUAffinity": "",
        "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",
        "CollectMode": "inactive",
        "ConditionResult": "yes",
        "ConditionTimestamp": "Wed 2025-05-14 12:19:22 EDT",
        "ConditionTimestampMonotonic": "14290149",
        "ConfigurationDirectoryMode": "0755",
        "Conflicts": "cpupower.service tlp.service power-profiles-daemon.service auto-cpufreq.service shutdown.target",
        "ControlGroup": "/system.slice/tuned.service",
        "ControlPID": "0",
        "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",
        "EffectiveCPUs": "",
        "EffectiveMemoryNodes": "",
        "ExecMainCode": "0",
        "ExecMainExitTimestampMonotonic": "0",
        "ExecMainPID": "695",
        "ExecMainStartTimestamp": "Wed 2025-05-14 12:19:22 EDT",
        "ExecMainStartTimestampMonotonic": "14290855",
        "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 }",
        "FailureAction": "none",
        "FileDescriptorStoreMax": "0",
        "FragmentPath": "/usr/lib/systemd/system/tuned.service",
        "FreezerState": "running",
        "GID": "[not set]",
        "GuessMainPID": "yes",
        "IOAccounting": "no",
        "IOSchedulingClass": "0",
        "IOSchedulingPriority": "0",
        "IOWeight": "[not set]",
        "IPAccounting": "no",
        "IPEgressBytes": "18446744073709551615",
        "IPEgressPackets": "18446744073709551615",
        "IPIngressBytes": "18446744073709551615",
        "IPIngressPackets": "18446744073709551615",
        "Id": "tuned.service",
        "IgnoreOnIsolate": "no",
        "IgnoreSIGPIPE": "yes",
        "InactiveEnterTimestampMonotonic": "0",
        "InactiveExitTimestamp": "Wed 2025-05-14 12:19:22 EDT",
        "InactiveExitTimestampMonotonic": "14290894",
        "InvocationID": "387dbc3035f44087a5a53a4ed1de7ab2",
        "JobRunningTimeoutUSec": "infinity",
        "JobTimeoutAction": "none",
        "JobTimeoutUSec": "infinity",
        "KeyringMode": "private",
        "KillMode": "control-group",
        "KillSignal": "15",
        "LimitAS": "infinity",
        "LimitASSoft": "infinity",
        "LimitCORE": "infinity",
        "LimitCORESoft": "0",
        "LimitCPU": "infinity",
        "LimitCPUSoft": "infinity",
        "LimitDATA": "infinity",
        "LimitDATASoft": "infinity",
        "LimitFSIZE": "infinity",
        "LimitFSIZESoft": "infinity",
        "LimitLOCKS": "infinity",
        "LimitLOCKSSoft": "infinity",
        "LimitMEMLOCK": "65536",
        "LimitMEMLOCKSoft": "65536",
        "LimitMSGQUEUE": "819200",
        "LimitMSGQUEUESoft": "819200",
        "LimitNICE": "0",
        "LimitNICESoft": "0",
        "LimitNOFILE": "262144",
        "LimitNOFILESoft": "1024",
        "LimitNPROC": "28608",
        "LimitNPROCSoft": "28608",
        "LimitRSS": "infinity",
        "LimitRSSSoft": "infinity",
        "LimitRTPRIO": "0",
        "LimitRTPRIOSoft": "0",
        "LimitRTTIME": "infinity",
        "LimitRTTIMESoft": "infinity",
        "LimitSIGPENDING": "28608",
        "LimitSIGPENDINGSoft": "28608",
        "LimitSTACK": "infinity",
        "LimitSTACKSoft": "8388608",
        "LoadState": "loaded",
        "LockPersonality": "no",
        "LogLevelMax": "-1",
        "LogRateLimitBurst": "0",
        "LogRateLimitIntervalUSec": "0",
        "LogsDirectoryMode": "0755",
        "MainPID": "695",
        "MemoryAccounting": "yes",
        "MemoryCurrent": "21356544",
        "MemoryDenyWriteExecute": "no",
        "MemoryHigh": "infinity",
        "MemoryLimit": "infinity",
        "MemoryLow": "0",
        "MemoryMax": "infinity",
        "MemoryMin": "0",
        "MemorySwapMax": "infinity",
        "MountAPIVFS": "no",
        "MountFlags": "",
        "NFileDescriptorStore": "0",
        "NRestarts": "0",
        "NUMAMask": "",
        "NUMAPolicy": "n/a",
        "Names": "tuned.service",
        "NeedDaemonReload": "no",
        "Nice": "0",
        "NoNewPrivileges": "no",
        "NonBlocking": "no",
        "NotifyAccess": "none",
        "OOMScoreAdjust": "0",
        "OnFailureJobMode": "replace",
        "PIDFile": "/run/tuned/tuned.pid",
        "PermissionsStartOnly": "no",
        "Perpetual": "no",
        "PrivateDevices": "no",
        "PrivateMounts": "no",
        "PrivateNetwork": "no",
        "PrivateTmp": "no",
        "PrivateUsers": "no",
        "ProtectControlGroups": "no",
        "ProtectHome": "no",
        "ProtectKernelModules": "no",
        "ProtectKernelTunables": "no",
        "ProtectSystem": "no",
        "RefuseManualStart": "no",
        "RefuseManualStop": "no",
        "RemainAfterExit": "no",
        "RemoveIPC": "no",
        "Requires": "system.slice sysinit.target dbus.service dbus.socket",
        "Restart": "no",
        "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",
        "StandardInputData": "",
        "StandardOutput": "journal",
        "StartLimitAction": "none",
        "StartLimitBurst": "5",
        "StartLimitIntervalUSec": "10s",
        "StartupBlockIOWeight": "[not set]",
        "StartupCPUShares": "[not set]",
        "StartupCPUWeight": "[not set]",
        "StartupIOWeight": "[not set]",
        "StateChangeTimestamp": "Wed 2025-05-14 12:19:23 EDT",
        "StateChangeTimestampMonotonic": "15850565",
        "StateDirectoryMode": "0755",
        "StatusErrno": "0",
        "StopWhenUnneeded": "no",
        "SubState": "running",
        "SuccessAction": "none",
        "SyslogFacility": "3",
        "SyslogLevel": "6",
        "SyslogLevelPrefix": "yes",
        "SyslogPriority": "30",
        "SystemCallErrorNumber": "0",
        "TTYReset": "no",
        "TTYVHangup": "no",
        "TTYVTDisallocate": "no",
        "TasksAccounting": "yes",
        "TasksCurrent": "4",
        "TasksMax": "45773",
        "TimeoutStartUSec": "1min 30s",
        "TimeoutStopUSec": "1min 30s",
        "TimerSlackNSec": "50000",
        "Transient": "no",
        "Type": "dbus",
        "UID": "[not set]",
        "UMask": "0022",
        "UnitFilePreset": "enabled",
        "UnitFileState": "enabled",
        "UtmpMode": "init",
        "WantedBy": "multi-user.target",
        "WatchdogTimestamp": "Wed 2025-05-14 12:19:23 EDT",
        "WatchdogTimestampMonotonic": "15850562",
        "WatchdogUSec": "0"
    }
}

TASK [fedora.linux_system_roles.mssql : Get the active Tuned profiles] *********
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:458
Wednesday 14 May 2025  12:47:57 -0400 (0:00:00.500)       0:01:04.337 ********* 
ok: [managed-node3] => {
    "changed": false,
    "content": "dmlydHVhbC1ndWVzdCBtc3NxbAo=",
    "encoding": "base64",
    "source": "/etc/tuned/active_profile"
}

TASK [fedora.linux_system_roles.mssql : Decode the active Tuned profiles] ******
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:464
Wednesday 14 May 2025  12:47:58 -0400 (0:00:00.510)       0:01:04.847 ********* 
ok: [managed-node3] => {
    "ansible_facts": {
        "__mssql_tuned_active_profiles": "virtual-guest mssql"
    },
    "changed": false
}

TASK [fedora.linux_system_roles.mssql : Attempt to add mssql to the list of Tuned profiles] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:477
Wednesday 14 May 2025  12:47:58 -0400 (0:00:00.169)       0:01:05.017 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "\"mssql\" not in __mssql_tuned_active_profiles",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Remove troublemaking include from the mssql profile] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:489
Wednesday 14 May 2025  12:47:58 -0400 (0:00:00.049)       0:01:05.066 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "\"mssql\" not in __mssql_tuned_active_profiles",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Add the fixed mssql profile to the list of Tuned profiles] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:498
Wednesday 14 May 2025  12:47:58 -0400 (0:00:00.049)       0:01:05.115 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "\"mssql\" not in __mssql_tuned_active_profiles",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Attempt to add mssql to the list of Tuned profiles] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:515
Wednesday 14 May 2025  12:47:58 -0400 (0:00:00.051)       0:01:05.167 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "not __mssql_is_booted",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server Tools repository] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:523
Wednesday 14 May 2025  12:47:58 -0400 (0:00:00.028)       0:01:05.196 ********* 
changed: [managed-node3] => {
    "changed": true,
    "repo": "packages-microsoft-com-prod",
    "state": "present"
}

TASK [fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server Tools repository] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:531
Wednesday 14 May 2025  12:47:59 -0400 (0:00:00.368)       0:01:05.564 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "ansible_pkg_mgr == \"zypper\"",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Ensure that SQL Server client tools are installed] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:540
Wednesday 14 May 2025  12:47:59 -0400 (0:00:00.041)       0:01:05.606 ********* 
changed: [managed-node3] => {
    "changed": true,
    "rc": 0,
    "results": [
        "Installed: unixODBC-2.3.11-1.rh.x86_64",
        "Installed: mssql-tools18-18.4.1.1-1.x86_64",
        "Installed: msodbcsql18-18.5.1.1-1.x86_64",
        "Installed: unixODBC-devel-2.3.11-1.rh.x86_64"
    ]
}

TASK [Create certificates using the certificate role] **************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:557
Wednesday 14 May 2025  12:48:03 -0400 (0:00:04.029)       0:01:09.635 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_tls_certificates | length > 0",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Set mssql_tls_cert and _private_key based on the cert name] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:571
Wednesday 14 May 2025  12:48:03 -0400 (0:00:00.054)       0:01:09.690 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_tls_certificates | length > 0",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Copy certificate and private_key files to the host] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:576
Wednesday 14 May 2025  12:48:03 -0400 (0:00:00.057)       0:01:09.747 ********* 
changed: [managed-node3] => (item=/tmp/ansible.tcx5x7hz) => {
    "ansible_loop_var": "item",
    "changed": true,
    "checksum": "02b0f66177385cbaa115360b605ad35d966997b3",
    "dest": "/etc/pki/tls/certs/ansible.tcx5x7hz",
    "gid": 989,
    "group": "mssql",
    "item": "/tmp/ansible.tcx5x7hz",
    "md5sum": "db510007449013ae97a9d152725f93bd",
    "mode": "0600",
    "owner": "mssql",
    "secontext": "system_u:object_r:cert_t:s0",
    "size": 1123,
    "src": "/root/.ansible/tmp/ansible-tmp-1747241283.4629943-53528-248945198480971/source",
    "state": "file",
    "uid": 993
}
changed: [managed-node3] => (item=ansible.jahlsqzq) => {
    "ansible_loop_var": "item",
    "changed": true,
    "checksum": "74600b225453a6c4a2d22ec42e8bd28f64457d9e",
    "dest": "/etc/pki/tls/private/ansible.jahlsqzq",
    "gid": 989,
    "group": "mssql",
    "item": "ansible.jahlsqzq",
    "md5sum": "611e499f951c3cc15de6c5051f9b25f5",
    "mode": "0600",
    "owner": "mssql",
    "secontext": "system_u:object_r:cert_t:s0",
    "size": 1704,
    "src": "/root/.ansible/tmp/ansible-tmp-1747241284.1391673-53528-164311962465748/source",
    "state": "file",
    "uid": 993
}

TASK [fedora.linux_system_roles.mssql : Configure the tlscert setting] *********
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:594
Wednesday 14 May 2025  12:48:04 -0400 (0:00:01.335)       0:01:11.082 ********* 
included: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml for managed-node3

TASK [fedora.linux_system_roles.mssql : Get the setting network tlscert] *******
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:3
Wednesday 14 May 2025  12:48:04 -0400 (0:00:00.074)       0:01:11.157 ********* 
ok: [managed-node3] => {
    "changed": false,
    "cmd": [
        "grep",
        "^tlscert = ",
        "/var/opt/mssql/mssql.conf"
    ],
    "delta": "0:00:00.002576",
    "end": "2025-05-14 12:48:05.158736",
    "failed_when_result": false,
    "rc": 1,
    "start": "2025-05-14 12:48:05.156160"
}

MSG:

non-zero return code

TASK [fedora.linux_system_roles.mssql : Configure the setting network tlscert] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:12
Wednesday 14 May 2025  12:48:05 -0400 (0:00:00.430)       0:01:11.588 ********* 
Notification for handler Restart the mssql-server service has been saved.
changed: [managed-node3] => {
    "changed": true,
    "cmd": [
        "/opt/mssql/bin/mssql-conf",
        "set",
        "network.tlscert",
        "/etc/pki/tls/certs/ansible.tcx5x7hz"
    ],
    "delta": "0:00:00.043154",
    "end": "2025-05-14 12:48:05.606858",
    "failed_when_result": false,
    "rc": 0,
    "start": "2025-05-14 12:48:05.563704"
}

STDOUT:

SQL Server needs to be restarted in order to apply this setting. Please run
'systemctl restart mssql-server.service'.

TASK [fedora.linux_system_roles.mssql : Unset the setting network tlscert] *****
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:42
Wednesday 14 May 2025  12:48:05 -0400 (0:00:00.455)       0:01:12.044 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_conf_setting_value == \"unset\"",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Configure the tlskey setting] **********
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:603
Wednesday 14 May 2025  12:48:05 -0400 (0:00:00.063)       0:01:12.107 ********* 
included: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml for managed-node3

TASK [fedora.linux_system_roles.mssql : Get the setting network tlskey] ********
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:3
Wednesday 14 May 2025  12:48:05 -0400 (0:00:00.068)       0:01:12.175 ********* 
ok: [managed-node3] => {
    "changed": false,
    "cmd": [
        "grep",
        "^tlskey = ",
        "/var/opt/mssql/mssql.conf"
    ],
    "delta": "0:00:00.002660",
    "end": "2025-05-14 12:48:06.125444",
    "failed_when_result": false,
    "rc": 1,
    "start": "2025-05-14 12:48:06.122784"
}

MSG:

non-zero return code

TASK [fedora.linux_system_roles.mssql : Configure the setting network tlskey] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:12
Wednesday 14 May 2025  12:48:06 -0400 (0:00:00.381)       0:01:12.557 ********* 
Notification for handler Restart the mssql-server service has been saved.
changed: [managed-node3] => {
    "changed": true,
    "cmd": [
        "/opt/mssql/bin/mssql-conf",
        "set",
        "network.tlskey",
        "/etc/pki/tls/private/ansible.jahlsqzq"
    ],
    "delta": "0:00:00.046261",
    "end": "2025-05-14 12:48:06.609290",
    "failed_when_result": false,
    "rc": 0,
    "start": "2025-05-14 12:48:06.563029"
}

STDOUT:

SQL Server needs to be restarted in order to apply this setting. Please run
'systemctl restart mssql-server.service'.

TASK [fedora.linux_system_roles.mssql : Unset the setting network tlskey] ******
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:42
Wednesday 14 May 2025  12:48:06 -0400 (0:00:00.470)       0:01:13.028 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_conf_setting_value == \"unset\"",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Configure the tlsprotocols setting] ****
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:612
Wednesday 14 May 2025  12:48:06 -0400 (0:00:00.106)       0:01:13.135 ********* 
included: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml for managed-node3

TASK [fedora.linux_system_roles.mssql : Get the setting network tlsprotocols] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:3
Wednesday 14 May 2025  12:48:06 -0400 (0:00:00.098)       0:01:13.233 ********* 
ok: [managed-node3] => {
    "changed": false,
    "cmd": [
        "grep",
        "^tlsprotocols = ",
        "/var/opt/mssql/mssql.conf"
    ],
    "delta": "0:00:00.002691",
    "end": "2025-05-14 12:48:07.229531",
    "failed_when_result": false,
    "rc": 1,
    "start": "2025-05-14 12:48:07.226840"
}

MSG:

non-zero return code

TASK [fedora.linux_system_roles.mssql : Configure the setting network tlsprotocols] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:12
Wednesday 14 May 2025  12:48:07 -0400 (0:00:00.426)       0:01:13.659 ********* 
Notification for handler Restart the mssql-server service has been saved.
changed: [managed-node3] => {
    "changed": true,
    "cmd": [
        "/opt/mssql/bin/mssql-conf",
        "set",
        "network.tlsprotocols",
        "1.2"
    ],
    "delta": "0:00:00.043718",
    "end": "2025-05-14 12:48:07.706794",
    "failed_when_result": false,
    "rc": 0,
    "start": "2025-05-14 12:48:07.663076"
}

STDOUT:

SQL Server needs to be restarted in order to apply this setting. Please run
'systemctl restart mssql-server.service'.

TASK [fedora.linux_system_roles.mssql : Unset the setting network tlsprotocols] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:42
Wednesday 14 May 2025  12:48:07 -0400 (0:00:00.465)       0:01:14.124 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_conf_setting_value == \"unset\"",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Configure the forceencryption setting] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:619
Wednesday 14 May 2025  12:48:07 -0400 (0:00:00.034)       0:01:14.159 ********* 
included: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml for managed-node3

TASK [fedora.linux_system_roles.mssql : Get the setting network forceencryption] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:3
Wednesday 14 May 2025  12:48:07 -0400 (0:00:00.060)       0:01:14.219 ********* 
ok: [managed-node3] => {
    "changed": false,
    "cmd": [
        "grep",
        "^forceencryption = ",
        "/var/opt/mssql/mssql.conf"
    ],
    "delta": "0:00:00.003171",
    "end": "2025-05-14 12:48:08.208618",
    "failed_when_result": false,
    "rc": 1,
    "start": "2025-05-14 12:48:08.205447"
}

MSG:

non-zero return code

TASK [fedora.linux_system_roles.mssql : Configure the setting network forceencryption] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:12
Wednesday 14 May 2025  12:48:08 -0400 (0:00:00.419)       0:01:14.639 ********* 
Notification for handler Restart the mssql-server service has been saved.
changed: [managed-node3] => {
    "changed": true,
    "cmd": [
        "/opt/mssql/bin/mssql-conf",
        "set",
        "network.forceencryption",
        "1"
    ],
    "delta": "0:00:00.043704",
    "end": "2025-05-14 12:48:08.662765",
    "failed_when_result": false,
    "rc": 0,
    "start": "2025-05-14 12:48:08.619061"
}

STDOUT:

SQL Server needs to be restarted in order to apply this setting. Please run
'systemctl restart mssql-server.service'.

TASK [fedora.linux_system_roles.mssql : Unset the setting network forceencryption] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:42
Wednesday 14 May 2025  12:48:08 -0400 (0:00:00.462)       0:01:15.102 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_conf_setting_value == \"unset\"",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Get the setting forceencryption] *******
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:628
Wednesday 14 May 2025  12:48:08 -0400 (0:00:00.042)       0:01:15.145 ********* 
ok: [managed-node3] => {
    "changed": false,
    "cmd": "set -euo pipefail; grep '^forceencryption' /var/opt/mssql/mssql.conf | sed 's/forceencryption = //g'",
    "delta": "0:00:00.004586",
    "end": "2025-05-14 12:48:09.101413",
    "failed_when_result": false,
    "rc": 0,
    "start": "2025-05-14 12:48:09.096827"
}

STDOUT:

1

TASK [fedora.linux_system_roles.mssql : Append -No to sqlcmd when TLS is not configured] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:637
Wednesday 14 May 2025  12:48:09 -0400 (0:00:00.386)       0:01:15.531 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_forceencryption_val.stdout != '1'",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Append -C to sqlcmd when TLS is configured but certs are self-signed] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:644
Wednesday 14 May 2025  12:48:09 -0400 (0:00:00.060)       0:01:15.592 ********* 
ok: [managed-node3] => {
    "ansible_facts": {
        "__sqlcmd_cli": "/opt/mssql-tools18/bin/sqlcmd -C"
    },
    "changed": false
}

TASK [fedora.linux_system_roles.mssql : Prepare MSSQL and facts for logging in] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:657
Wednesday 14 May 2025  12:48:09 -0400 (0:00:00.074)       0:01:15.666 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_conf_setup is skipped",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Wait for mssql-server to prepare for client connections] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:661
Wednesday 14 May 2025  12:48:09 -0400 (0:00:00.036)       0:01:15.702 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_conf_setup is skipped",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Check if the set password matches the existing password] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:667
Wednesday 14 May 2025  12:48:09 -0400 (0:00:00.032)       0:01:15.735 ********* 
skipping: [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 : Ensure that the mssql-server service is stopped] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:683
Wednesday 14 May 2025  12:48:09 -0400 (0:00:00.031)       0:01:15.766 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_conf_setup is skipped",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Gather package facts] ******************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:692
Wednesday 14 May 2025  12:48:09 -0400 (0:00:00.032)       0:01:15.799 ********* 
skipping: [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 : Change the password of sa user] ********
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:700
Wednesday 14 May 2025  12:48:09 -0400 (0:00:00.050)       0:01:15.850 ********* 
skipping: [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 : Pre-input SQL script files to SQL Server] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:721
Wednesday 14 May 2025  12:48:09 -0400 (0:00:00.031)       0:01:15.882 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_pre_input_sql_file != []",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Pre-input SQL script contents to SQL Server] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:730
Wednesday 14 May 2025  12:48:09 -0400 (0:00:00.027)       0:01:15.909 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_pre_input_sql_content != []",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Check if the set edition matches the existing edition] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:743
Wednesday 14 May 2025  12:48:09 -0400 (0:00:00.066)       0:01:15.976 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_conf_setup is skipped",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Ensure that the mssql-server service is stopped] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:758
Wednesday 14 May 2025  12:48:09 -0400 (0:00:00.032)       0:01:16.008 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_conf_setup is skipped",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Gather package facts] ******************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:767
Wednesday 14 May 2025  12:48:09 -0400 (0:00:00.033)       0:01:16.042 ********* 
skipping: [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 : Change the edition of MSSQL] ***********
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:773
Wednesday 14 May 2025  12:48:09 -0400 (0:00:00.050)       0:01:16.093 ********* 
skipping: [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 : Configure the IP address setting] ******
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:792
Wednesday 14 May 2025  12:48:09 -0400 (0:00:00.033)       0:01:16.126 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ip_address is not none",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Register the previous tcpport setting] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:799
Wednesday 14 May 2025  12:48:09 -0400 (0:00:00.032)       0:01:16.159 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_manage_firewall | bool",
    "skip_reason": "Conditional result was False"
}

TASK [Open the TCP port 1433] **************************************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:806
Wednesday 14 May 2025  12:48:09 -0400 (0:00:00.048)       0:01:16.208 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_manage_firewall | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Configure the TCP port setting to 1433] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:818
Wednesday 14 May 2025  12:48:09 -0400 (0:00:00.047)       0:01:16.255 ********* 
included: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml for managed-node3

TASK [fedora.linux_system_roles.mssql : Get the setting network tcpport] *******
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:3
Wednesday 14 May 2025  12:48:09 -0400 (0:00:00.047)       0:01:16.303 ********* 
ok: [managed-node3] => {
    "changed": false,
    "cmd": [
        "grep",
        "^tcpport = ",
        "/var/opt/mssql/mssql.conf"
    ],
    "delta": "0:00:00.003224",
    "end": "2025-05-14 12:48:10.256007",
    "failed_when_result": false,
    "rc": 1,
    "start": "2025-05-14 12:48:10.252783"
}

MSG:

non-zero return code

TASK [fedora.linux_system_roles.mssql : Configure the setting network tcpport] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:12
Wednesday 14 May 2025  12:48:10 -0400 (0:00:00.365)       0:01:16.669 ********* 
ok: [managed-node3] => {
    "changed": false,
    "cmd": [
        "/opt/mssql/bin/mssql-conf",
        "set",
        "network.tcpport",
        "1433"
    ],
    "delta": "0:00:00.043587",
    "end": "2025-05-14 12:48:10.664699",
    "failed_when_result": false,
    "rc": 0,
    "start": "2025-05-14 12:48:10.621112"
}

STDOUT:

Validation error on setting 'network.tcpport'
Port '1433' is already in use. Please use another port

TASK [fedora.linux_system_roles.mssql : Unset the setting network tcpport] *****
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:42
Wednesday 14 May 2025  12:48:10 -0400 (0:00:00.415)       0:01:17.084 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_conf_setting_value == \"unset\"",
    "skip_reason": "Conditional result was False"
}

TASK [Close the previously set SQL Server TCP port if it changed] **************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:824
Wednesday 14 May 2025  12:48:10 -0400 (0:00:00.028)       0:01:17.113 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_manage_firewall | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Configure the sqlagent setting] ********
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:844
Wednesday 14 May 2025  12:48:10 -0400 (0:00:00.046)       0:01:17.159 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_enable_sql_agent is not none",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Ensure the package mssql-server-fts] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:851
Wednesday 14 May 2025  12:48:10 -0400 (0:00:00.034)       0:01:17.194 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_install_fts is not none",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Ensure the package powershell] *********
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:858
Wednesday 14 May 2025  12:48:10 -0400 (0:00:00.033)       0:01:17.227 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_install_powershell is not none",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Check if the 3979 trace flag is enabled] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:867
Wednesday 14 May 2025  12:48:10 -0400 (0:00:00.032)       0:01:17.260 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_tune_for_fua_storage is not none",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Set the 3979 traceflag] ****************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:873
Wednesday 14 May 2025  12:48:10 -0400 (0:00:00.031)       0:01:17.292 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_tune_for_fua_storage is not none",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Unset the 3979 traceflag] **************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:880
Wednesday 14 May 2025  12:48:10 -0400 (0:00:00.032)       0:01:17.325 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_tune_for_fua_storage is not none",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Configure the alternatewritethrough setting] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:888
Wednesday 14 May 2025  12:48:11 -0400 (0:00:00.032)       0:01:17.357 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_tune_for_fua_storage is not none",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Configure the writethrough setting] ****
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:894
Wednesday 14 May 2025  12:48:11 -0400 (0:00:00.032)       0:01:17.389 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_tune_for_fua_storage is not none",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Verify that ad_integration_realm variable is provided] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:904
Wednesday 14 May 2025  12:48:11 -0400 (0:00:00.044)       0:01:17.434 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ad_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [Join to realm {{ ad_integration_realm }}] ********************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:912
Wednesday 14 May 2025  12:48:11 -0400 (0:00:00.128)       0:01:17.562 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ad_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Ensure adutil and krb5-workstation] ****
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:920
Wednesday 14 May 2025  12:48:11 -0400 (0:00:00.046)       0:01:17.609 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ad_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Print credential caches to check if AD principal exists] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:927
Wednesday 14 May 2025  12:48:11 -0400 (0:00:00.050)       0:01:17.660 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ad_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Print status of credential cache for {{ __mssql_ad_kinit_user }}] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:934
Wednesday 14 May 2025  12:48:11 -0400 (0:00:00.071)       0:01:17.731 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ad_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Obtain Kerberos ticket for {{ __mssql_ad_kinit_user }}] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:943
Wednesday 14 May 2025  12:48:11 -0400 (0:00:00.033)       0:01:17.765 ********* 
skipping: [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 : Check if AD user exists] ***************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:956
Wednesday 14 May 2025  12:48:11 -0400 (0:00:00.030)       0:01:17.795 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ad_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : In AD server create user] **************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:965
Wednesday 14 May 2025  12:48:11 -0400 (0:00:00.029)       0:01:17.825 ********* 
skipping: [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 : Ensure proper configuration on user] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:979
Wednesday 14 May 2025  12:48:11 -0400 (0:00:00.031)       0:01:17.856 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ad_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Get SPNs for the principal] ************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:989
Wednesday 14 May 2025  12:48:11 -0400 (0:00:00.028)       0:01:17.885 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ad_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Register SPNs to the principal] ********
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:994
Wednesday 14 May 2025  12:48:11 -0400 (0:00:00.031)       0:01:17.916 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ad_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Get kvno of the SPN host] **************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1011
Wednesday 14 May 2025  12:48:11 -0400 (0:00:00.027)       0:01:17.943 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ad_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Get stats of the keytab file] **********
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1016
Wednesday 14 May 2025  12:48:11 -0400 (0:00:00.029)       0:01:17.973 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ad_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Get keytab properties] *****************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1021
Wednesday 14 May 2025  12:48:11 -0400 (0:00:00.027)       0:01:18.000 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ad_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Create keytab] *************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1027
Wednesday 14 May 2025  12:48:11 -0400 (0:00:00.028)       0:01:18.029 ********* 
skipping: [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 : Add an entry in the keytab for the principal name and password] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1053
Wednesday 14 May 2025  12:48:11 -0400 (0:00:00.027)       0:01:18.057 ********* 
skipping: [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 : Ensure correct permissions and ownership on the keytab] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1074
Wednesday 14 May 2025  12:48:11 -0400 (0:00:00.028)       0:01:18.086 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ad_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Fetch keytab file to host] *************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1082
Wednesday 14 May 2025  12:48:11 -0400 (0:00:00.027)       0:01:18.114 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ad_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Configure the network.kerberoskeytabfile setting] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1092
Wednesday 14 May 2025  12:48:11 -0400 (0:00:00.029)       0:01:18.143 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ad_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Configure the network.kerberoskeytabfile setting] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1098
Wednesday 14 May 2025  12:48:11 -0400 (0:00:00.027)       0:01:18.170 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ad_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Verify that hosts with mssql_ha_replica_type=primary is available] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1116
Wednesday 14 May 2025  12:48:11 -0400 (0:00:00.029)       0:01:18.200 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [Open the port and enable the high-availability service in firewall tcp port 5022] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1127
Wednesday 14 May 2025  12:48:11 -0400 (0:00:00.028)       0:01:18.229 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Set host variables] ********************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1147
Wednesday 14 May 2025  12:48:11 -0400 (0:00:00.029)       0:01:18.258 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Ensure the package mssql-server-ha] ****
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1200
Wednesday 14 May 2025  12:48:11 -0400 (0:00:00.070)       0:01:18.328 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Enable the hadrenabled setting] ********
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1207
Wednesday 14 May 2025  12:48:12 -0400 (0:00:00.029)       0:01:18.358 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Restart the mssql-server service if hadrenabled task was changed] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1214
Wednesday 14 May 2025  12:48:12 -0400 (0:00:00.030)       0:01:18.389 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Remove certificate from SQL Server] ****
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1226
Wednesday 14 May 2025  12:48:12 -0400 (0:00:00.046)       0:01:18.435 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Remove certificate and private key files] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1232
Wednesday 14 May 2025  12:48:12 -0400 (0:00:00.061)       0:01:18.497 ********* 
skipping: [managed-node3] => (item=/var/opt/mssql/data/.cer)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "item": "/var/opt/mssql/data/.cer",
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node3] => (item=/var/opt/mssql/data/.pvk)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "item": "/var/opt/mssql/data/.pvk",
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node3] => {
    "changed": false
}

MSG:

All items skipped

TASK [fedora.linux_system_roles.mssql : Configure SQL entities on the primary replica] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1240
Wednesday 14 May 2025  12:48:12 -0400 (0:00:00.067)       0:01:18.564 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Create login for HA on in SQL Server] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1249
Wednesday 14 May 2025  12:48:12 -0400 (0:00:00.048)       0:01:18.612 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Fetch certificate files from the primary to the control node] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1257
Wednesday 14 May 2025  12:48:12 -0400 (0:00:00.048)       0:01:18.661 ********* 
skipping: [managed-node3] => (item={'key': 'cert', 'value': '/var/opt/mssql/data/.cer'})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "item": {
        "key": "cert",
        "value": "/var/opt/mssql/data/.cer"
    },
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node3] => (item={'key': 'key', 'value': '/var/opt/mssql/data/.pvk'})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "item": {
        "key": "key",
        "value": "/var/opt/mssql/data/.pvk"
    },
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node3] => {
    "changed": false
}

MSG:

All items skipped

TASK [fedora.linux_system_roles.mssql : Get the current primary replica in SQL] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1271
Wednesday 14 May 2025  12:48:12 -0400 (0:00:00.059)       0:01:18.720 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Set fact with the current primary replica] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1277
Wednesday 14 May 2025  12:48:12 -0400 (0:00:00.046)       0:01:18.767 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Verify that primary instance hosts is available] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1299
Wednesday 14 May 2025  12:48:12 -0400 (0:00:00.047)       0:01:18.814 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Configure ag] **************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1309
Wednesday 14 May 2025  12:48:12 -0400 (0:00:00.046)       0:01:18.861 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Grant permissions to HA login] *********
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1318
Wednesday 14 May 2025  12:48:12 -0400 (0:00:00.046)       0:01:18.907 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Replicate DBs] *************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1327
Wednesday 14 May 2025  12:48:12 -0400 (0:00:00.052)       0:01:18.959 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Grant permissions to HA login] *********
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1338
Wednesday 14 May 2025  12:48:12 -0400 (0:00:00.035)       0:01:18.995 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Verify that hosts with replica_type=primary is available] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1351
Wednesday 14 May 2025  12:48:12 -0400 (0:00:00.033)       0:01:19.028 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Ensure the package mssql-server-ha] ****
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1360
Wednesday 14 May 2025  12:48:12 -0400 (0:00:00.036)       0:01:19.064 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Enable the hadrenabled setting] ********
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1367
Wednesday 14 May 2025  12:48:12 -0400 (0:00:00.040)       0:01:19.105 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Restart the mssql-server service if hadrenabled task was changed] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1374
Wednesday 14 May 2025  12:48:12 -0400 (0:00:00.031)       0:01:19.136 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Remove certificate from SQL Server] ****
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1383
Wednesday 14 May 2025  12:48:12 -0400 (0:00:00.032)       0:01:19.169 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Distribute certificate and private key to managed nodes] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1390
Wednesday 14 May 2025  12:48:12 -0400 (0:00:00.027)       0:01:19.197 ********* 
skipping: [managed-node3] => (item={'key': 'cert', 'value': '/var/opt/mssql/data/.cer'})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "item": {
        "key": "cert",
        "value": "/var/opt/mssql/data/.cer"
    },
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node3] => (item={'key': 'key', 'value': '/var/opt/mssql/data/.pvk'})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "item": {
        "key": "key",
        "value": "/var/opt/mssql/data/.pvk"
    },
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node3] => {
    "changed": false
}

MSG:

All items skipped

TASK [fedora.linux_system_roles.mssql : Configure SQL entities on not primary replicas] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1402
Wednesday 14 May 2025  12:48:12 -0400 (0:00:00.075)       0:01:19.272 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Create HA login] ***********************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1411
Wednesday 14 May 2025  12:48:12 -0400 (0:00:00.028)       0:01:19.300 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Join to availability group] ************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1418
Wednesday 14 May 2025  12:48:12 -0400 (0:00:00.030)       0:01:19.330 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Grant permissions to HA login] *********
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1424
Wednesday 14 May 2025  12:48:13 -0400 (0:00:00.028)       0:01:19.359 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Remove certificate and private key from the control node] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1432
Wednesday 14 May 2025  12:48:13 -0400 (0:00:00.030)       0:01:19.390 ********* 
skipping: [managed-node3] => (item=cert)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "item": "cert",
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node3] => (item=key)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "item": "key",
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node3] => {
    "changed": false
}

MSG:

All items skipped

TASK [fedora.linux_system_roles.mssql : Save credentials for the SQL Server login] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1445
Wednesday 14 May 2025  12:48:13 -0400 (0:00:00.036)       0:01:19.426 ********* 
skipping: [managed-node3] => {
    "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result",
    "changed": false
}

TASK [Run ha_cluster to configure pacemaker] ***********************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1457
Wednesday 14 May 2025  12:48:13 -0400 (0:00:00.033)       0:01:19.460 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Wait for the cluster to finish configuration] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1462
Wednesday 14 May 2025  12:48:13 -0400 (0:00:00.041)       0:01:19.502 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Configure listener for the availability group] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1470
Wednesday 14 May 2025  12:48:13 -0400 (0:00:00.047)       0:01:19.549 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Ensure the ansible_managed header in /var/opt/mssql/mssql.conf] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1479
Wednesday 14 May 2025  12:48:13 -0400 (0:00:00.044)       0:01:19.593 ********* 
changed: [managed-node3] => {
    "changed": true
}

MSG:

Block inserted

TASK [fedora.linux_system_roles.mssql : Flush handlers prior to inputting post SQL scripts] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1488
Wednesday 14 May 2025  12:48:13 -0400 (0:00:00.515)       0:01:20.109 ********* 
NOTIFIED HANDLER fedora.linux_system_roles.mssql : Restart the mssql-server service for managed-node3
META: triggered running handlers for managed-node3

RUNNING HANDLER [fedora.linux_system_roles.mssql : Restart the mssql-server service] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/handlers/main.yml:3
Wednesday 14 May 2025  12:48:13 -0400 (0:00:00.023)       0:01:20.133 ********* 
changed: [managed-node3] => {
    "changed": true,
    "name": "mssql-server",
    "state": "started",
    "status": {
        "ActiveEnterTimestamp": "Wed 2025-05-14 12:47:53 EDT",
        "ActiveEnterTimestampMonotonic": "1725199632",
        "ActiveExitTimestampMonotonic": "0",
        "ActiveState": "active",
        "After": "sysinit.target network.target systemd-journald.socket -.mount basic.target system.slice auditd.service",
        "AllowIsolate": "no",
        "AllowedCPUs": "",
        "AllowedMemoryNodes": "",
        "AmbientCapabilities": "",
        "AssertResult": "yes",
        "AssertTimestamp": "Wed 2025-05-14 12:47:53 EDT",
        "AssertTimestampMonotonic": "1725192536",
        "Before": "multi-user.target shutdown.target",
        "BlockIOAccounting": "no",
        "BlockIOWeight": "[not set]",
        "CPUAccounting": "no",
        "CPUAffinity": "",
        "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",
        "CollectMode": "inactive",
        "ConditionResult": "yes",
        "ConditionTimestamp": "Wed 2025-05-14 12:47:53 EDT",
        "ConditionTimestampMonotonic": "1725192535",
        "ConfigurationDirectoryMode": "0755",
        "Conflicts": "shutdown.target",
        "ControlGroup": "/system.slice/mssql-server.service",
        "ControlPID": "0",
        "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",
        "EffectiveCPUs": "",
        "EffectiveMemoryNodes": "",
        "ExecMainCode": "0",
        "ExecMainExitTimestampMonotonic": "0",
        "ExecMainPID": "137846",
        "ExecMainStartTimestamp": "Wed 2025-05-14 12:47:53 EDT",
        "ExecMainStartTimestampMonotonic": "1725199598",
        "ExecMainStatus": "0",
        "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 }",
        "FailureAction": "none",
        "FileDescriptorStoreMax": "0",
        "FragmentPath": "/usr/lib/systemd/system/mssql-server.service",
        "FreezerState": "running",
        "GID": "989",
        "GuessMainPID": "yes",
        "IOAccounting": "no",
        "IOSchedulingClass": "0",
        "IOSchedulingPriority": "0",
        "IOWeight": "[not set]",
        "IPAccounting": "no",
        "IPEgressBytes": "18446744073709551615",
        "IPEgressPackets": "18446744073709551615",
        "IPIngressBytes": "18446744073709551615",
        "IPIngressPackets": "18446744073709551615",
        "Id": "mssql-server.service",
        "IgnoreOnIsolate": "no",
        "IgnoreSIGPIPE": "yes",
        "InactiveEnterTimestampMonotonic": "0",
        "InactiveExitTimestamp": "Wed 2025-05-14 12:47:53 EDT",
        "InactiveExitTimestampMonotonic": "1725199632",
        "InvocationID": "cd0b01be89134ca19547dd06693745af",
        "JobRunningTimeoutUSec": "infinity",
        "JobTimeoutAction": "none",
        "JobTimeoutUSec": "infinity",
        "KeyringMode": "private",
        "KillMode": "process",
        "KillSignal": "15",
        "LimitAS": "infinity",
        "LimitASSoft": "infinity",
        "LimitCORE": "infinity",
        "LimitCORESoft": "0",
        "LimitCPU": "infinity",
        "LimitCPUSoft": "infinity",
        "LimitDATA": "infinity",
        "LimitDATASoft": "infinity",
        "LimitFSIZE": "infinity",
        "LimitFSIZESoft": "infinity",
        "LimitLOCKS": "infinity",
        "LimitLOCKSSoft": "infinity",
        "LimitMEMLOCK": "65536",
        "LimitMEMLOCKSoft": "65536",
        "LimitMSGQUEUE": "819200",
        "LimitMSGQUEUESoft": "819200",
        "LimitNICE": "0",
        "LimitNICESoft": "0",
        "LimitNOFILE": "infinity",
        "LimitNOFILESoft": "infinity",
        "LimitNPROC": "infinity",
        "LimitNPROCSoft": "infinity",
        "LimitRSS": "infinity",
        "LimitRSSSoft": "infinity",
        "LimitRTPRIO": "0",
        "LimitRTPRIOSoft": "0",
        "LimitRTTIME": "infinity",
        "LimitRTTIMESoft": "infinity",
        "LimitSIGPENDING": "28608",
        "LimitSIGPENDINGSoft": "28608",
        "LimitSTACK": "infinity",
        "LimitSTACKSoft": "8388608",
        "LoadState": "loaded",
        "LockPersonality": "no",
        "LogLevelMax": "-1",
        "LogRateLimitBurst": "0",
        "LogRateLimitIntervalUSec": "0",
        "LogsDirectoryMode": "0755",
        "MainPID": "137846",
        "MemoryAccounting": "yes",
        "MemoryCurrent": "635637760",
        "MemoryDenyWriteExecute": "no",
        "MemoryHigh": "infinity",
        "MemoryLimit": "infinity",
        "MemoryLow": "0",
        "MemoryMax": "infinity",
        "MemoryMin": "0",
        "MemorySwapMax": "infinity",
        "MountAPIVFS": "no",
        "MountFlags": "",
        "NFileDescriptorStore": "0",
        "NRestarts": "0",
        "NUMAMask": "",
        "NUMAPolicy": "n/a",
        "Names": "mssql-server.service",
        "NeedDaemonReload": "no",
        "Nice": "0",
        "NoNewPrivileges": "no",
        "NonBlocking": "no",
        "NotifyAccess": "none",
        "OOMScoreAdjust": "0",
        "OnFailureJobMode": "replace",
        "PermissionsStartOnly": "no",
        "Perpetual": "no",
        "PrivateDevices": "no",
        "PrivateMounts": "no",
        "PrivateNetwork": "no",
        "PrivateTmp": "no",
        "PrivateUsers": "no",
        "ProtectControlGroups": "no",
        "ProtectHome": "no",
        "ProtectKernelModules": "no",
        "ProtectKernelTunables": "no",
        "ProtectSystem": "no",
        "RefuseManualStart": "no",
        "RefuseManualStop": "no",
        "RemainAfterExit": "no",
        "RemoveIPC": "no",
        "Requires": "sysinit.target system.slice -.mount",
        "RequiresMountsFor": "/var/opt/mssql",
        "Restart": "on-failure",
        "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",
        "StandardInputData": "",
        "StandardOutput": "journal",
        "StartLimitAction": "none",
        "StartLimitBurst": "3",
        "StartLimitIntervalUSec": "2min",
        "StartupBlockIOWeight": "[not set]",
        "StartupCPUShares": "[not set]",
        "StartupCPUWeight": "[not set]",
        "StartupIOWeight": "[not set]",
        "StateChangeTimestamp": "Wed 2025-05-14 12:47:53 EDT",
        "StateChangeTimestampMonotonic": "1725199632",
        "StateDirectoryMode": "0755",
        "StatusErrno": "0",
        "StopWhenUnneeded": "no",
        "SubState": "running",
        "SuccessAction": "none",
        "SyslogFacility": "3",
        "SyslogLevel": "6",
        "SyslogLevelPrefix": "yes",
        "SyslogPriority": "30",
        "SystemCallErrorNumber": "0",
        "TTYReset": "no",
        "TTYVHangup": "no",
        "TTYVTDisallocate": "no",
        "TasksAccounting": "yes",
        "TasksCurrent": "140",
        "TasksMax": "infinity",
        "TimeoutStartUSec": "30min",
        "TimeoutStopUSec": "30min",
        "TimerSlackNSec": "50000",
        "Transient": "no",
        "Type": "simple",
        "UID": "993",
        "UMask": "0007",
        "UnitFilePreset": "disabled",
        "UnitFileState": "enabled",
        "User": "mssql",
        "UtmpMode": "init",
        "WantedBy": "multi-user.target",
        "WatchdogTimestamp": "Wed 2025-05-14 12:47:53 EDT",
        "WatchdogTimestampMonotonic": "1725199630",
        "WatchdogUSec": "0",
        "WorkingDirectory": "/var/opt/mssql"
    }
}

TASK [fedora.linux_system_roles.mssql : Post-input SQL scripts to SQL Server] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1492
Wednesday 14 May 2025  12:48:14 -0400 (0:00:00.751)       0:01:20.884 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_post_input_sql_file != []",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Post-input SQL scripts to SQL Server] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:1499
Wednesday 14 May 2025  12:48:14 -0400 (0:00:00.029)       0:01:20.914 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_post_input_sql_content != []",
    "skip_reason": "Conditional result was False"
}

TASK [Remove a private key from the playbook directory] ************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:68
Wednesday 14 May 2025  12:48:14 -0400 (0:00:00.057)       0:01:20.972 ********* 
changed: [managed-node3 -> localhost] => {
    "changed": true,
    "path": "ansible.jahlsqzq",
    "state": "absent"
}

TASK [Configure the mssql-server service start limit interval and burst] *******
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:75
Wednesday 14 May 2025  12:48:15 -0400 (0:00:00.531)       0:01:21.503 ********* 
included: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/mssql-sever-increase-start-limit.yml for managed-node3

TASK [Create service drop-in directory] ****************************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/mssql-sever-increase-start-limit.yml:3
Wednesday 14 May 2025  12:48:15 -0400 (0:00:00.079)       0:01:21.583 ********* 
changed: [managed-node3] => {
    "changed": true,
    "gid": 0,
    "group": "root",
    "mode": "0755",
    "owner": "root",
    "path": "/etc/systemd/system/mssql-server.service.d",
    "secontext": "unconfined_u:object_r:systemd_unit_file_t:s0",
    "size": 6,
    "state": "directory",
    "uid": 0
}

TASK [Modify the mssql-server service start limit interval and burst] **********
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/mssql-sever-increase-start-limit.yml:11
Wednesday 14 May 2025  12:48:15 -0400 (0:00:00.434)       0:01:22.018 ********* 
changed: [managed-node3] => {
    "changed": true,
    "checksum": "c2c05a3dc1d516acdec3ead86f9dbbc1adaa39d7",
    "dest": "/etc/systemd/system/mssql-server.service.d/startlimit.conf",
    "gid": 0,
    "group": "root",
    "md5sum": "4e553ebde6af773b4efe9008c4676a82",
    "mode": "0644",
    "owner": "root",
    "secontext": "system_u:object_r:systemd_unit_file_t:s0",
    "size": 49,
    "src": "/root/.ansible/tmp/ansible-tmp-1747241295.7095737-54019-256934545532461/source",
    "state": "file",
    "uid": 0
}

TASK [Reload service daemon] ***************************************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/mssql-sever-increase-start-limit.yml:23
Wednesday 14 May 2025  12:48:16 -0400 (0:00:00.787)       0:01:22.805 ********* 
ok: [managed-node3] => {
    "changed": false,
    "name": null,
    "status": {}
}

TASK [Verify connectivity and settings] ****************************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:78
Wednesday 14 May 2025  12:48:17 -0400 (0:00:00.756)       0:01:23.561 ********* 
included: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/verify_settings.yml for managed-node3

TASK [Get server version on non-booted systems] ********************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/verify_settings.yml:10
Wednesday 14 May 2025  12:48:17 -0400 (0:00:00.187)       0:01:23.748 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__verify_mssql_edition is defined",
    "skip_reason": "Conditional result was False"
}

TASK [Get server edition on booted systems] ************************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/verify_settings.yml:19
Wednesday 14 May 2025  12:48:17 -0400 (0:00:00.048)       0:01:23.797 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__verify_mssql_edition is defined",
    "skip_reason": "Conditional result was False"
}

TASK [Verify that the edition matches] *****************************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/verify_settings.yml:33
Wednesday 14 May 2025  12:48:17 -0400 (0:00:00.054)       0:01:23.852 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__verify_mssql_edition is defined",
    "skip_reason": "Conditional result was False"
}

TASK [Verify the setting {{ item.key }}] ***************************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/verify_settings.yml:39
Wednesday 14 May 2025  12:48:17 -0400 (0:00:00.048)       0:01:23.900 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "item.value is defined",
    "skip_reason": "Conditional result was False"
}

TASK [Get stat of mssql_datadir] ***********************************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/verify_settings.yml:55
Wednesday 14 May 2025  12:48:17 -0400 (0:00:00.050)       0:01:23.951 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__verify_mssql_datadir_mode is defined",
    "skip_reason": "Conditional result was False"
}

TASK [Assert that mssql_datadir has proper permissions and ownership] **********
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/verify_settings.yml:60
Wednesday 14 May 2025  12:48:17 -0400 (0:00:00.046)       0:01:23.997 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__verify_mssql_datadir_mode is defined",
    "skip_reason": "Conditional result was False"
}

TASK [Get stat of mssql_logdir] ************************************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/verify_settings.yml:70
Wednesday 14 May 2025  12:48:17 -0400 (0:00:00.047)       0:01:24.045 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__verify_mssql_logdir_mode is defined",
    "skip_reason": "Conditional result was False"
}

TASK [Assert that mssql_logdir has proper permissions and ownership] ***********
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/verify_settings.yml:75
Wednesday 14 May 2025  12:48:17 -0400 (0:00:00.048)       0:01:24.093 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__verify_mssql_logdir_mode is defined",
    "skip_reason": "Conditional result was False"
}

TASK [Prepare MSSQL and facts for logging in] **********************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/verify_settings.yml:85
Wednesday 14 May 2025  12:48:17 -0400 (0:00:00.049)       0:01:24.143 ********* 

TASK [fedora.linux_system_roles.mssql : Ensure that the mssql-server service is started] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/verify_password.yml:3
Wednesday 14 May 2025  12:48:17 -0400 (0:00:00.100)       0:01:24.243 ********* 
ok: [managed-node3] => {
    "changed": false,
    "name": "mssql-server",
    "state": "started",
    "status": {
        "ActiveEnterTimestamp": "Wed 2025-05-14 12:48:14 EDT",
        "ActiveEnterTimestampMonotonic": "1746469035",
        "ActiveExitTimestamp": "Wed 2025-05-14 12:48:14 EDT",
        "ActiveExitTimestampMonotonic": "1746238724",
        "ActiveState": "active",
        "After": "basic.target network.target -.mount sysinit.target system.slice systemd-journald.socket auditd.service",
        "AllowIsolate": "no",
        "AllowedCPUs": "",
        "AllowedMemoryNodes": "",
        "AmbientCapabilities": "",
        "AssertResult": "yes",
        "AssertTimestamp": "Wed 2025-05-14 12:48:14 EDT",
        "AssertTimestampMonotonic": "1746468173",
        "Before": "shutdown.target multi-user.target",
        "BlockIOAccounting": "no",
        "BlockIOWeight": "[not set]",
        "CPUAccounting": "no",
        "CPUAffinity": "",
        "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",
        "CollectMode": "inactive",
        "ConditionResult": "yes",
        "ConditionTimestamp": "Wed 2025-05-14 12:48:14 EDT",
        "ConditionTimestampMonotonic": "1746468172",
        "ConfigurationDirectoryMode": "0755",
        "Conflicts": "shutdown.target",
        "ControlGroup": "/system.slice/mssql-server.service",
        "ControlPID": "0",
        "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",
        "DropInPaths": "/etc/systemd/system/mssql-server.service.d/startlimit.conf",
        "DynamicUser": "no",
        "EffectiveCPUs": "",
        "EffectiveMemoryNodes": "",
        "ExecMainCode": "0",
        "ExecMainExitTimestampMonotonic": "0",
        "ExecMainPID": "141258",
        "ExecMainStartTimestamp": "Wed 2025-05-14 12:48:14 EDT",
        "ExecMainStartTimestampMonotonic": "1746468966",
        "ExecMainStatus": "0",
        "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 }",
        "FailureAction": "none",
        "FileDescriptorStoreMax": "0",
        "FragmentPath": "/usr/lib/systemd/system/mssql-server.service",
        "FreezerState": "running",
        "GID": "989",
        "GuessMainPID": "yes",
        "IOAccounting": "no",
        "IOSchedulingClass": "0",
        "IOSchedulingPriority": "0",
        "IOWeight": "[not set]",
        "IPAccounting": "no",
        "IPEgressBytes": "18446744073709551615",
        "IPEgressPackets": "18446744073709551615",
        "IPIngressBytes": "18446744073709551615",
        "IPIngressPackets": "18446744073709551615",
        "Id": "mssql-server.service",
        "IgnoreOnIsolate": "no",
        "IgnoreSIGPIPE": "yes",
        "InactiveEnterTimestamp": "Wed 2025-05-14 12:48:14 EDT",
        "InactiveEnterTimestampMonotonic": "1746467460",
        "InactiveExitTimestamp": "Wed 2025-05-14 12:48:14 EDT",
        "InactiveExitTimestampMonotonic": "1746469035",
        "InvocationID": "2b1ded33b03c4c9983173f031600dbf9",
        "JobRunningTimeoutUSec": "infinity",
        "JobTimeoutAction": "none",
        "JobTimeoutUSec": "infinity",
        "KeyringMode": "private",
        "KillMode": "process",
        "KillSignal": "15",
        "LimitAS": "infinity",
        "LimitASSoft": "infinity",
        "LimitCORE": "infinity",
        "LimitCORESoft": "0",
        "LimitCPU": "infinity",
        "LimitCPUSoft": "infinity",
        "LimitDATA": "infinity",
        "LimitDATASoft": "infinity",
        "LimitFSIZE": "infinity",
        "LimitFSIZESoft": "infinity",
        "LimitLOCKS": "infinity",
        "LimitLOCKSSoft": "infinity",
        "LimitMEMLOCK": "65536",
        "LimitMEMLOCKSoft": "65536",
        "LimitMSGQUEUE": "819200",
        "LimitMSGQUEUESoft": "819200",
        "LimitNICE": "0",
        "LimitNICESoft": "0",
        "LimitNOFILE": "infinity",
        "LimitNOFILESoft": "infinity",
        "LimitNPROC": "infinity",
        "LimitNPROCSoft": "infinity",
        "LimitRSS": "infinity",
        "LimitRSSSoft": "infinity",
        "LimitRTPRIO": "0",
        "LimitRTPRIOSoft": "0",
        "LimitRTTIME": "infinity",
        "LimitRTTIMESoft": "infinity",
        "LimitSIGPENDING": "28608",
        "LimitSIGPENDINGSoft": "28608",
        "LimitSTACK": "infinity",
        "LimitSTACKSoft": "8388608",
        "LoadState": "loaded",
        "LockPersonality": "no",
        "LogLevelMax": "-1",
        "LogRateLimitBurst": "0",
        "LogRateLimitIntervalUSec": "0",
        "LogsDirectoryMode": "0755",
        "MainPID": "141258",
        "MemoryAccounting": "yes",
        "MemoryCurrent": "627859456",
        "MemoryDenyWriteExecute": "no",
        "MemoryHigh": "infinity",
        "MemoryLimit": "infinity",
        "MemoryLow": "0",
        "MemoryMax": "infinity",
        "MemoryMin": "0",
        "MemorySwapMax": "infinity",
        "MountAPIVFS": "no",
        "MountFlags": "",
        "NFileDescriptorStore": "0",
        "NRestarts": "0",
        "NUMAMask": "",
        "NUMAPolicy": "n/a",
        "Names": "mssql-server.service",
        "NeedDaemonReload": "no",
        "Nice": "0",
        "NoNewPrivileges": "no",
        "NonBlocking": "no",
        "NotifyAccess": "none",
        "OOMScoreAdjust": "0",
        "OnFailureJobMode": "replace",
        "PermissionsStartOnly": "no",
        "Perpetual": "no",
        "PrivateDevices": "no",
        "PrivateMounts": "no",
        "PrivateNetwork": "no",
        "PrivateTmp": "no",
        "PrivateUsers": "no",
        "ProtectControlGroups": "no",
        "ProtectHome": "no",
        "ProtectKernelModules": "no",
        "ProtectKernelTunables": "no",
        "ProtectSystem": "no",
        "RefuseManualStart": "no",
        "RefuseManualStop": "no",
        "RemainAfterExit": "no",
        "RemoveIPC": "no",
        "Requires": "-.mount sysinit.target system.slice",
        "RequiresMountsFor": "/var/opt/mssql",
        "Restart": "on-failure",
        "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",
        "StandardInputData": "",
        "StandardOutput": "journal",
        "StartLimitAction": "none",
        "StartLimitBurst": "0",
        "StartLimitIntervalUSec": "0",
        "StartupBlockIOWeight": "[not set]",
        "StartupCPUShares": "[not set]",
        "StartupCPUWeight": "[not set]",
        "StartupIOWeight": "[not set]",
        "StateChangeTimestamp": "Wed 2025-05-14 12:48:14 EDT",
        "StateChangeTimestampMonotonic": "1746469035",
        "StateDirectoryMode": "0755",
        "StatusErrno": "0",
        "StopWhenUnneeded": "no",
        "SubState": "running",
        "SuccessAction": "none",
        "SyslogFacility": "3",
        "SyslogLevel": "6",
        "SyslogLevelPrefix": "yes",
        "SyslogPriority": "30",
        "SystemCallErrorNumber": "0",
        "TTYReset": "no",
        "TTYVHangup": "no",
        "TTYVTDisallocate": "no",
        "TasksAccounting": "yes",
        "TasksCurrent": "136",
        "TasksMax": "infinity",
        "TimeoutStartUSec": "30min",
        "TimeoutStopUSec": "30min",
        "TimerSlackNSec": "50000",
        "Transient": "no",
        "Type": "simple",
        "UID": "993",
        "UMask": "0007",
        "UnitFilePreset": "disabled",
        "UnitFileState": "enabled",
        "User": "mssql",
        "UtmpMode": "init",
        "WantedBy": "multi-user.target",
        "WatchdogTimestamp": "Wed 2025-05-14 12:48:14 EDT",
        "WatchdogTimestampMonotonic": "1746469033",
        "WatchdogUSec": "0",
        "WorkingDirectory": "/var/opt/mssql"
    }
}

TASK [fedora.linux_system_roles.mssql : Check if a custom tcpport setting exist] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/verify_password.yml:9
Wednesday 14 May 2025  12:48:18 -0400 (0:00:00.560)       0:01:24.803 ********* 
ok: [managed-node3] => {
    "changed": false,
    "cmd": [
        "grep",
        "^tcpport = ",
        "/var/opt/mssql/mssql.conf"
    ],
    "delta": "0:00:00.002421",
    "end": "2025-05-14 12:48:18.775528",
    "failed_when_result": false,
    "rc": 1,
    "start": "2025-05-14 12:48:18.773107"
}

MSG:

non-zero return code

TASK [fedora.linux_system_roles.mssql : Check if a custom ipaddress setting exist] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/verify_password.yml:15
Wednesday 14 May 2025  12:48:18 -0400 (0:00:00.403)       0:01:25.206 ********* 
ok: [managed-node3] => {
    "changed": false,
    "cmd": [
        "grep",
        "^ipaddress = ",
        "/var/opt/mssql/mssql.conf"
    ],
    "delta": "0:00:00.002347",
    "end": "2025-05-14 12:48:19.160749",
    "failed_when_result": false,
    "rc": 1,
    "start": "2025-05-14 12:48:19.158402"
}

MSG:

non-zero return code

TASK [fedora.linux_system_roles.mssql : Set a fact with a login command] *******
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/verify_password.yml:21
Wednesday 14 May 2025  12:48:19 -0400 (0:00:00.368)       0:01:25.574 ********* 
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 [Wait for mssql-server to prepare for client connections] *****************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/verify_settings.yml:96
Wednesday 14 May 2025  12:48:19 -0400 (0:00:00.066)       0:01:25.641 ********* 
ok: [managed-node3] => {
    "changed": false,
    "elapsed": 1,
    "gid": 989,
    "group": "mssql",
    "match_groupdict": {},
    "match_groups": [],
    "mode": "0660",
    "owner": "mssql",
    "path": "/var/opt/mssql/log/errorlog",
    "port": null,
    "search_regex": "SQL Server is now ready for client connections",
    "secontext": "system_u:object_r:var_t:s0",
    "size": 6351,
    "state": "file",
    "uid": 993
}

TASK [Check if the set password matches the existing password] *****************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/verify_settings.yml:117
Wednesday 14 May 2025  12:48:20 -0400 (0:00:01.511)       0:01:27.152 ********* 
ok: [managed-node3] => {
    "attempts": 1,
    "changed": false,
    "cmd": [
        "/opt/mssql-tools18/bin/sqlcmd",
        "-C",
        "-U",
        "sa",
        "-P",
        "p@55w0rD",
        "-Q",
        "SELECT @@VERSION"
    ],
    "delta": "0:00:00.020911",
    "end": "2025-05-14 12:48:21.121664",
    "rc": 0,
    "start": "2025-05-14 12:48:21.100753"
}

STDOUT:

                                                                                                                                                                                                                                                                                                            
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Microsoft SQL Server 2017 (RTM-CU31-OD) (KB5050533) - 14.0.3490.10 (X64) 
	Feb 19 2025 12:19:28 
	Copyright (C) 2017 Microsoft Corporation
	Enterprise Evaluation Edition (64-bit) on Linux (CentOS Stream 8)                                                                                               

(1 rows affected)

TASK [Set the mssql_password variable to default null] *************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/verify_settings.yml:137
Wednesday 14 May 2025  12:48:21 -0400 (0:00:00.410)       0:01:27.563 ********* 
ok: [managed-node3] => {
    "ansible_facts": {
        "mssql_password": null
    },
    "changed": false
}

TASK [Verify the package mssql-server-fts] *************************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/verify_settings.yml:141
Wednesday 14 May 2025  12:48:21 -0400 (0:00:00.053)       0:01:27.616 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__verify_mssql_fts_is_installed is defined",
    "skip_reason": "Conditional result was False"
}

TASK [Verify the package powershell] *******************************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/verify_settings.yml:148
Wednesday 14 May 2025  12:48:21 -0400 (0:00:00.107)       0:01:27.723 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__verify_mssql_powershell_is_installed is defined",
    "skip_reason": "Conditional result was False"
}

TASK [Get the value of the traceflag setting] **********************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/verify_settings.yml:159
Wednesday 14 May 2025  12:48:21 -0400 (0:00:00.051)       0:01:27.776 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__verify_mssql_is_tuned_for_fua is defined",
    "skip_reason": "Conditional result was False"
}

TASK [Verify that the traceflag setting is set to 3979] ************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/verify_settings.yml:164
Wednesday 14 May 2025  12:48:21 -0400 (0:00:00.052)       0:01:27.828 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__verify_mssql_is_tuned_for_fua is defined",
    "skip_reason": "Conditional result was False"
}

TASK [Verify that the traceflag setting is not set to 3979] ********************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/verify_settings.yml:169
Wednesday 14 May 2025  12:48:21 -0400 (0:00:00.049)       0:01:27.878 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__verify_mssql_is_tuned_for_fua is defined",
    "skip_reason": "Conditional result was False"
}

TASK [Verify that the alternatewritethrough setting is false] ******************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/verify_settings.yml:175
Wednesday 14 May 2025  12:48:21 -0400 (0:00:00.038)       0:01:27.916 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__verify_mssql_is_tuned_for_fua is defined",
    "skip_reason": "Conditional result was False"
}

TASK [Verify the writethrough setting] *****************************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/verify_settings.yml:181
Wednesday 14 May 2025  12:48:21 -0400 (0:00:00.042)       0:01:27.959 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__verify_mssql_is_tuned_for_fua is defined",
    "skip_reason": "Conditional result was False"
}

TASK [Verify the tlscert setting] **********************************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/verify_settings.yml:191
Wednesday 14 May 2025  12:48:21 -0400 (0:00:00.050)       0:01:28.010 ********* 
included: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/mssql_conf_verify.yml for managed-node3

TASK [Get the value of the setting tlscert] ************************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/mssql_conf_verify.yml:7
Wednesday 14 May 2025  12:48:21 -0400 (0:00:00.087)       0:01:28.097 ********* 
ok: [managed-node3] => {
    "changed": false,
    "cmd": "grep '^tlscert' /var/opt/mssql/mssql.conf || true",
    "delta": "0:00:00.003554",
    "end": "2025-05-14 12:48:22.034424",
    "rc": 0,
    "start": "2025-05-14 12:48:22.030870"
}

STDOUT:

tlscert = /etc/pki/tls/certs/ansible.tcx5x7hz

TASK [Verify the setting when it is type str tlscert] **************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/mssql_conf_verify.yml:14
Wednesday 14 May 2025  12:48:22 -0400 (0:00:00.354)       0:01:28.452 ********* 
ok: [managed-node3] => {
    "changed": false
}

MSG:

All assertions passed

TASK [Verify the setting when it is type bool tlscert] *************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/mssql_conf_verify.yml:25
Wednesday 14 May 2025  12:48:22 -0400 (0:00:00.052)       0:01:28.505 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_conf_value | type_debug == 'bool'",
    "skip_reason": "Conditional result was False"
}

TASK [Verify that tcpport = /etc/pki/tls/certs/ansible.tcx5x7hz] ***************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/mssql_conf_verify.yml:40
Wednesday 14 May 2025  12:48:22 -0400 (0:00:00.046)       0:01:28.551 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_conf_setting == \"tcpport\"",
    "skip_reason": "Conditional result was False"
}

TASK [Verify the tlskey setting] ***********************************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/verify_settings.yml:202
Wednesday 14 May 2025  12:48:22 -0400 (0:00:00.035)       0:01:28.587 ********* 
included: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/mssql_conf_verify.yml for managed-node3

TASK [Get the value of the setting tlskey] *************************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/mssql_conf_verify.yml:7
Wednesday 14 May 2025  12:48:22 -0400 (0:00:00.052)       0:01:28.639 ********* 
ok: [managed-node3] => {
    "changed": false,
    "cmd": "grep '^tlskey' /var/opt/mssql/mssql.conf || true",
    "delta": "0:00:00.003355",
    "end": "2025-05-14 12:48:22.567772",
    "rc": 0,
    "start": "2025-05-14 12:48:22.564417"
}

STDOUT:

tlskey = /etc/pki/tls/private/ansible.jahlsqzq

TASK [Verify the setting when it is type str tlskey] ***************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/mssql_conf_verify.yml:14
Wednesday 14 May 2025  12:48:22 -0400 (0:00:00.348)       0:01:28.988 ********* 
ok: [managed-node3] => {
    "changed": false
}

MSG:

All assertions passed

TASK [Verify the setting when it is type bool tlskey] **************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/mssql_conf_verify.yml:25
Wednesday 14 May 2025  12:48:22 -0400 (0:00:00.044)       0:01:29.032 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_conf_value | type_debug == 'bool'",
    "skip_reason": "Conditional result was False"
}

TASK [Verify that tcpport = /etc/pki/tls/private/ansible.jahlsqzq] *************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/mssql_conf_verify.yml:40
Wednesday 14 May 2025  12:48:22 -0400 (0:00:00.037)       0:01:29.069 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_conf_setting == \"tcpport\"",
    "skip_reason": "Conditional result was False"
}

TASK [Verify the tlsprotocols setting] *****************************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/verify_settings.yml:214
Wednesday 14 May 2025  12:48:22 -0400 (0:00:00.032)       0:01:29.101 ********* 
included: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/mssql_conf_verify.yml for managed-node3

TASK [Get the value of the setting tlsprotocols] *******************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/mssql_conf_verify.yml:7
Wednesday 14 May 2025  12:48:22 -0400 (0:00:00.058)       0:01:29.160 ********* 
ok: [managed-node3] => {
    "changed": false,
    "cmd": "grep '^tlsprotocols' /var/opt/mssql/mssql.conf || true",
    "delta": "0:00:00.003887",
    "end": "2025-05-14 12:48:23.088638",
    "rc": 0,
    "start": "2025-05-14 12:48:23.084751"
}

STDOUT:

tlsprotocols = 1.2

TASK [Verify the setting when it is type str tlsprotocols] *********************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/mssql_conf_verify.yml:14
Wednesday 14 May 2025  12:48:23 -0400 (0:00:00.382)       0:01:29.542 ********* 
ok: [managed-node3] => {
    "changed": false
}

MSG:

All assertions passed

TASK [Verify the setting when it is type bool tlsprotocols] ********************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/mssql_conf_verify.yml:25
Wednesday 14 May 2025  12:48:23 -0400 (0:00:00.041)       0:01:29.584 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_conf_value | type_debug == 'bool'",
    "skip_reason": "Conditional result was False"
}

TASK [Verify that tcpport = 1.2] ***********************************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/mssql_conf_verify.yml:40
Wednesday 14 May 2025  12:48:23 -0400 (0:00:00.037)       0:01:29.622 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_conf_setting == \"tcpport\"",
    "skip_reason": "Conditional result was False"
}

TASK [Verify the forceencryption setting] **************************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/verify_settings.yml:222
Wednesday 14 May 2025  12:48:23 -0400 (0:00:00.030)       0:01:29.653 ********* 
included: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/mssql_conf_verify.yml for managed-node3

TASK [Get the value of the setting forceencryption] ****************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/mssql_conf_verify.yml:7
Wednesday 14 May 2025  12:48:23 -0400 (0:00:00.060)       0:01:29.713 ********* 
ok: [managed-node3] => {
    "changed": false,
    "cmd": "grep '^forceencryption' /var/opt/mssql/mssql.conf || true",
    "delta": "0:00:00.003889",
    "end": "2025-05-14 12:48:23.658721",
    "rc": 0,
    "start": "2025-05-14 12:48:23.654832"
}

STDOUT:

forceencryption = 1

TASK [Verify the setting when it is type str forceencryption] ******************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/mssql_conf_verify.yml:14
Wednesday 14 May 2025  12:48:23 -0400 (0:00:00.376)       0:01:30.089 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_conf_value | type_debug != 'bool'",
    "skip_reason": "Conditional result was False"
}

TASK [Verify the setting when it is type bool forceencryption] *****************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/mssql_conf_verify.yml:25
Wednesday 14 May 2025  12:48:23 -0400 (0:00:00.052)       0:01:30.142 ********* 
ok: [managed-node3] => {
    "changed": false
}

MSG:

All assertions passed

TASK [Verify that tcpport = True] **********************************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/mssql_conf_verify.yml:40
Wednesday 14 May 2025  12:48:23 -0400 (0:00:00.064)       0:01:30.207 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_conf_setting == \"tcpport\"",
    "skip_reason": "Conditional result was False"
}

TASK [Verify configuration for confined application] ***************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/verify_settings.yml:229
Wednesday 14 May 2025  12:48:23 -0400 (0:00:00.050)       0:01:30.257 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__verify_mssql_is_confined is defined",
    "skip_reason": "Conditional result was False"
}

TASK [Disable TLS encryption] **************************************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:85
Wednesday 14 May 2025  12:48:23 -0400 (0:00:00.050)       0:01:30.308 ********* 

TASK [fedora.linux_system_roles.mssql : Ensure ansible_facts and variables used by role] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:3
Wednesday 14 May 2025  12:48:24 -0400 (0:00:00.322)       0:01:30.630 ********* 
included: /tmp/collections-5YH/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-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:3
Wednesday 14 May 2025  12:48:24 -0400 (0:00:00.077)       0:01:30.708 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_required_facts | difference(ansible_facts.keys() | list) | length > 0",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Set platform/version specific variables] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:8
Wednesday 14 May 2025  12:48:24 -0400 (0:00:00.055)       0:01:30.763 ********* 
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-5YH/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,
    "false_condition": "__mssql_vars_file is file",
    "item": "CentOS.yml",
    "skip_reason": "Conditional result was False"
}
ok: [managed-node3] => (item=CentOS_8.yml) => {
    "ansible_facts": {
        "__mssql_client_repository": "https://packages.microsoft.com/rhel/8/prod/",
        "__mssql_confined_supported": false,
        "__mssql_server_repository": "https://packages.microsoft.com/rhel/8/mssql-server-{{ mssql_version | int }}/",
        "__mssql_supported_versions": [
            2017,
            2019,
            2022
        ]
    },
    "ansible_included_var_files": [
        "/tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/CentOS_8.yml"
    ],
    "ansible_loop_var": "item",
    "changed": false,
    "item": "CentOS_8.yml"
}
ok: [managed-node3] => (item=CentOS_8.yml) => {
    "ansible_facts": {
        "__mssql_client_repository": "https://packages.microsoft.com/rhel/8/prod/",
        "__mssql_confined_supported": false,
        "__mssql_server_repository": "https://packages.microsoft.com/rhel/8/mssql-server-{{ mssql_version | int }}/",
        "__mssql_supported_versions": [
            2017,
            2019,
            2022
        ]
    },
    "ansible_included_var_files": [
        "/tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/vars/CentOS_8.yml"
    ],
    "ansible_loop_var": "item",
    "changed": false,
    "item": "CentOS_8.yml"
}

TASK [fedora.linux_system_roles.mssql : Run systemctl] *************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:22
Wednesday 14 May 2025  12:48:24 -0400 (0:00:00.086)       0:01:30.849 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_is_booted is not defined",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Require installed systemd] *************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:29
Wednesday 14 May 2025  12:48:24 -0400 (0:00:00.049)       0:01:30.899 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_is_booted is not defined",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Set flag to indicate that systemd runtime operations are available] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/set_vars.yml:34
Wednesday 14 May 2025  12:48:24 -0400 (0:00:00.113)       0:01:31.013 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_is_booted is not defined",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Unset the __mssql_sqlcmd_login_cmd fact] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:8
Wednesday 14 May 2025  12:48:24 -0400 (0:00:00.064)       0:01:31.077 ********* 
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-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:15
Wednesday 14 May 2025  12:48:24 -0400 (0:00:00.052)       0:01:31.130 ********* 
skipping: [managed-node3] => {
    "false_condition": "mssql_input_sql_file is defined"
}

TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_input_sql_file fact] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:23
Wednesday 14 May 2025  12:48:24 -0400 (0:00:00.049)       0:01:31.179 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_input_sql_file is defined",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Print that the variable is deprecated] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:30
Wednesday 14 May 2025  12:48:24 -0400 (0:00:00.048)       0:01:31.228 ********* 
skipping: [managed-node3] => {
    "false_condition": "mssql_ha_listener_port is defined"
}

TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_ha_listener_port fact] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:37
Wednesday 14 May 2025  12:48:24 -0400 (0:00:00.047)       0:01:31.276 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_listener_port is defined",
    "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-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:44
Wednesday 14 May 2025  12:48:24 -0400 (0:00:00.048)       0:01:31.324 ********* 
skipping: [managed-node3] => {
    "false_condition": "mssql_ad_sql_user_name is defined"
}

TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_ad_sql_user_name fact] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:51
Wednesday 14 May 2025  12:48:25 -0400 (0:00:00.046)       0:01:31.370 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ad_sql_user_name is defined",
    "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-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:58
Wednesday 14 May 2025  12:48:25 -0400 (0:00:00.050)       0:01:31.421 ********* 
skipping: [managed-node3] => {
    "false_condition": "mssql_ha_cluster_run_role is defined"
}

TASK [fedora.linux_system_roles.mssql : Link the deprecated mssql_ha_cluster_run_role fact] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:65
Wednesday 14 May 2025  12:48:25 -0400 (0:00:00.050)       0:01:31.471 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_cluster_run_role is defined",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Print that variable is deprecated] *****
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:74
Wednesday 14 May 2025  12:48:25 -0400 (0:00:00.036)       0:01:31.507 ********* 
skipping: [managed-node3] => {
    "false_condition": "mssql_accept_microsoft_odbc_driver_17_for_sql_server_eula is defined"
}

TASK [fedora.linux_system_roles.mssql : Link the deprecated fact] **************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:83
Wednesday 14 May 2025  12:48:25 -0400 (0:00:00.031)       0:01:31.539 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_accept_microsoft_odbc_driver_17_for_sql_server_eula is defined",
    "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-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:87
Wednesday 14 May 2025  12:48:25 -0400 (0:00:00.036)       0:01:31.576 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "ansible_distribution_major_version is version('10', '=')",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Verify that the user accepts EULA variables] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:94
Wednesday 14 May 2025  12:48:25 -0400 (0:00:00.043)       0:01:31.619 ********* 
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-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:106
Wednesday 14 May 2025  12:48:25 -0400 (0:00:00.038)       0:01:31.658 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "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-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:114
Wednesday 14 May 2025  12:48:25 -0400 (0:00:00.029)       0:01:31.688 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "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-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:123
Wednesday 14 May 2025  12:48:25 -0400 (0:00:00.030)       0:01:31.718 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_configure | bool",
    "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-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:132
Wednesday 14 May 2025  12:48:25 -0400 (0:00:00.028)       0:01:31.747 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_ha_ag_cluster_type | lower == 'none'",
    "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-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:142
Wednesday 14 May 2025  12:48:25 -0400 (0:00:00.031)       0:01:31.779 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "(mssql_manage_selinux | bool) or (mssql_run_selinux_confined | bool)",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Verify that mssql_manage_selinux is set properly] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:151
Wednesday 14 May 2025  12:48:25 -0400 (0:00:00.031)       0:01:31.811 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_manage_selinux | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Gather package facts] ******************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:162
Wednesday 14 May 2025  12:48:25 -0400 (0:00:00.029)       0:01:31.841 ********* 
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-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:166
Wednesday 14 May 2025  12:48:27 -0400 (0:00:01.542)       0:01:33.383 ********* 
ok: [managed-node3] => (item={'key': 2017, 'value': 14}) => {
    "ansible_facts": {
        "__mssql_current_version": "2017"
    },
    "ansible_loop_var": "item",
    "changed": false,
    "item": {
        "key": 2017,
        "value": 14
    }
}
skipping: [managed-node3] => (item={'key': 2019, 'value': 15})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "ansible_facts.packages[\"mssql-server\"][0][\"version\"].split(\".\") | first | int == item.value",
    "item": {
        "key": 2019,
        "value": 15
    },
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node3] => (item={'key': 2022, 'value': 16})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "ansible_facts.packages[\"mssql-server\"][0][\"version\"].split(\".\") | first | int == item.value",
    "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-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:174
Wednesday 14 May 2025  12:48:27 -0400 (0:00:00.083)       0:01:33.466 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_version is none",
    "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-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:181
Wednesday 14 May 2025  12:48:27 -0400 (0:00:00.031)       0:01:33.497 ********* 
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-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:188
Wednesday 14 May 2025  12:48:27 -0400 (0:00:00.037)       0:01:33.535 ********* 
skipping: [managed-node3] => (item={'key': 2017, 'value': 14})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "ansible_facts.packages[\"mssql-server\"][0][\"version\"].split(\".\") | first | int > item.value",
    "item": {
        "key": 2017,
        "value": 14
    },
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node3] => (item={'key': 2019, 'value': 15})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "mssql_version | int == item.key",
    "item": {
        "key": 2019,
        "value": 15
    },
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node3] => (item={'key': 2022, 'value': 16})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "mssql_version | int == item.key",
    "item": {
        "key": 2022,
        "value": 16
    },
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node3] => {
    "changed": false
}

MSG:

All items skipped

TASK [fedora.linux_system_roles.mssql : Deploy the GPG key for Microsoft repositories] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:202
Wednesday 14 May 2025  12:48:27 -0400 (0:00:00.059)       0:01:33.594 ********* 
ok: [managed-node3] => {
    "attempts": 1,
    "changed": false
}

TASK [fedora.linux_system_roles.mssql : Update all packages from SQL Server repo version 2017] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:216
Wednesday 14 May 2025  12:48:27 -0400 (0:00:00.574)       0:01:34.169 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_upgrade | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Get yum repositories] ******************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:226
Wednesday 14 May 2025  12:48:27 -0400 (0:00:00.049)       0:01:34.218 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_upgrade | bool",
    "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-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:237
Wednesday 14 May 2025  12:48:27 -0400 (0:00:00.036)       0:01:34.255 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_upgrade | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Update all packages from SQL Server repo version 2017] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:251
Wednesday 14 May 2025  12:48:27 -0400 (0:00:00.037)       0:01:34.292 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_upgrade | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Get zypper repositories] ***************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:260
Wednesday 14 May 2025  12:48:27 -0400 (0:00:00.032)       0:01:34.325 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_upgrade | bool",
    "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-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:272
Wednesday 14 May 2025  12:48:28 -0400 (0:00:00.034)       0:01:34.360 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_upgrade | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server repo version 2017] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:279
Wednesday 14 May 2025  12:48:28 -0400 (0:00:00.035)       0:01:34.395 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "(__mssql_server_packages not in ansible_facts.packages) or (mssql_upgrade | bool)",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server repo version 2017] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:291
Wednesday 14 May 2025  12:48:28 -0400 (0:00:00.037)       0:01:34.432 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "ansible_pkg_mgr == \"zypper\"",
    "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-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:304
Wednesday 14 May 2025  12:48:28 -0400 (0:00:00.030)       0:01:34.463 ********* 
ok: [managed-node3] => {
    "changed": false,
    "rc": 0,
    "results": []
}

MSG:

Nothing to do

TASK [fedora.linux_system_roles.mssql : Ensure the package mssql-server] *******
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:309
Wednesday 14 May 2025  12:48:30 -0400 (0:00:02.869)       0:01:37.332 ********* 
ok: [managed-node3] => {
    "changed": false,
    "rc": 0,
    "results": []
}

MSG:

Nothing to do

TASK [fedora.linux_system_roles.mssql : Check if the errorlog file exists and its location] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:314
Wednesday 14 May 2025  12:48:33 -0400 (0:00:02.853)       0:01:40.186 ********* 
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.004335",
    "end": "2025-05-14 12:48:34.132477",
    "rc": 0,
    "start": "2025-05-14 12:48:34.128142"
}

STDOUT:

/var/opt/mssql/log/errorlog

TASK [fedora.linux_system_roles.mssql : Check if mssql-server.service is enabled] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:331
Wednesday 14 May 2025  12:48:34 -0400 (0:00:00.360)       0:01:40.547 ********* 
ok: [managed-node3] => {
    "changed": false,
    "cmd": [
        "systemctl",
        "is-enabled",
        "mssql-server.service"
    ],
    "delta": "0:00:00.008002",
    "end": "2025-05-14 12:48:34.492899",
    "failed_when_result": false,
    "rc": 0,
    "start": "2025-05-14 12:48:34.484897"
}

STDOUT:

enabled

TASK [fedora.linux_system_roles.mssql : Check if mssql-server.service is running] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:338
Wednesday 14 May 2025  12:48:34 -0400 (0:00:00.429)       0:01:40.977 ********* 
ok: [managed-node3] => {
    "changed": false,
    "cmd": [
        "systemctl",
        "is-active",
        "mssql-server.service"
    ],
    "delta": "0:00:00.006736",
    "end": "2025-05-14 12:48:34.946916",
    "failed_when_result": false,
    "rc": 0,
    "start": "2025-05-14 12:48:34.940180"
}

STDOUT:

active

TASK [fedora.linux_system_roles.mssql : Set the __mssql_is_setup variable] *****
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:345
Wednesday 14 May 2025  12:48:35 -0400 (0:00:00.396)       0:01:41.374 ********* 
ok: [managed-node3] => {
    "ansible_facts": {
        "__mssql_is_setup": true
    },
    "changed": false
}

TASK [fedora.linux_system_roles.mssql : Verify that the variables required for setting up MSSQL are defined] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:352
Wednesday 14 May 2025  12:48:35 -0400 (0:00:00.036)       0:01:41.411 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "not __mssql_is_setup",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Set up MSSQL] **************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:368
Wednesday 14 May 2025  12:48:35 -0400 (0:00:00.030)       0:01:41.441 ********* 
skipping: [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 : Ensure the directory and permissions for datadir and logdir] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:398
Wednesday 14 May 2025  12:48:35 -0400 (0:00:00.029)       0:01:41.471 ********* 
skipping: [managed-node3] => (item={'path': None, 'mode': '755', 'setting': 'defaultdatadir'})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "item.path is not none",
    "item": {
        "mode": "755",
        "path": null,
        "setting": "defaultdatadir"
    },
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node3] => (item={'path': None, 'mode': '755', 'setting': 'defaultlogdir'})  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "item.path is not none",
    "item": {
        "mode": "755",
        "path": null,
        "setting": "defaultlogdir"
    },
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node3] => {
    "changed": false
}

MSG:

All items skipped

TASK [fedora.linux_system_roles.mssql : Set selinux role facts for ports] ******
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:413
Wednesday 14 May 2025  12:48:35 -0400 (0:00:00.039)       0:01:41.510 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_manage_selinux | bool",
    "skip_reason": "Conditional result was False"
}

TASK [Ensure correct SELinux context for storage paths and ports] **************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:427
Wednesday 14 May 2025  12:48:35 -0400 (0:00:00.030)       0:01:41.540 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_manage_selinux | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Ensure that the tuned-profiles-mssql package is installed] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:438
Wednesday 14 May 2025  12:48:35 -0400 (0:00:00.029)       0:01:41.570 ********* 
ok: [managed-node3] => {
    "changed": false,
    "rc": 0,
    "results": []
}

MSG:

Nothing to do

TASK [fedora.linux_system_roles.mssql : Ensure that the tuned service is enabled] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:444
Wednesday 14 May 2025  12:48:38 -0400 (0:00:02.824)       0:01:44.395 ********* 
ok: [managed-node3] => {
    "changed": false,
    "enabled": true,
    "name": "tuned",
    "status": {
        "ActiveEnterTimestamp": "Wed 2025-05-14 12:19:23 EDT",
        "ActiveEnterTimestampMonotonic": "15850565",
        "ActiveExitTimestampMonotonic": "0",
        "ActiveState": "active",
        "After": "basic.target dbus.socket system.slice systemd-sysctl.service sysinit.target network.target polkit.service dbus.service systemd-journald.socket",
        "AllowIsolate": "no",
        "AllowedCPUs": "",
        "AllowedMemoryNodes": "",
        "AmbientCapabilities": "",
        "AssertResult": "yes",
        "AssertTimestamp": "Wed 2025-05-14 12:19:22 EDT",
        "AssertTimestampMonotonic": "14290150",
        "Before": "shutdown.target multi-user.target",
        "BlockIOAccounting": "no",
        "BlockIOWeight": "[not set]",
        "BusName": "com.redhat.tuned",
        "CPUAccounting": "no",
        "CPUAffinity": "",
        "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",
        "CollectMode": "inactive",
        "ConditionResult": "yes",
        "ConditionTimestamp": "Wed 2025-05-14 12:19:22 EDT",
        "ConditionTimestampMonotonic": "14290149",
        "ConfigurationDirectoryMode": "0755",
        "Conflicts": "power-profiles-daemon.service shutdown.target cpupower.service auto-cpufreq.service tlp.service",
        "ControlGroup": "/system.slice/tuned.service",
        "ControlPID": "0",
        "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",
        "EffectiveCPUs": "",
        "EffectiveMemoryNodes": "",
        "ExecMainCode": "0",
        "ExecMainExitTimestampMonotonic": "0",
        "ExecMainPID": "695",
        "ExecMainStartTimestamp": "Wed 2025-05-14 12:19:22 EDT",
        "ExecMainStartTimestampMonotonic": "14290855",
        "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 }",
        "FailureAction": "none",
        "FileDescriptorStoreMax": "0",
        "FragmentPath": "/usr/lib/systemd/system/tuned.service",
        "FreezerState": "running",
        "GID": "[not set]",
        "GuessMainPID": "yes",
        "IOAccounting": "no",
        "IOSchedulingClass": "0",
        "IOSchedulingPriority": "0",
        "IOWeight": "[not set]",
        "IPAccounting": "no",
        "IPEgressBytes": "18446744073709551615",
        "IPEgressPackets": "18446744073709551615",
        "IPIngressBytes": "18446744073709551615",
        "IPIngressPackets": "18446744073709551615",
        "Id": "tuned.service",
        "IgnoreOnIsolate": "no",
        "IgnoreSIGPIPE": "yes",
        "InactiveEnterTimestampMonotonic": "0",
        "InactiveExitTimestamp": "Wed 2025-05-14 12:19:22 EDT",
        "InactiveExitTimestampMonotonic": "14290894",
        "InvocationID": "387dbc3035f44087a5a53a4ed1de7ab2",
        "JobRunningTimeoutUSec": "infinity",
        "JobTimeoutAction": "none",
        "JobTimeoutUSec": "infinity",
        "KeyringMode": "private",
        "KillMode": "control-group",
        "KillSignal": "15",
        "LimitAS": "infinity",
        "LimitASSoft": "infinity",
        "LimitCORE": "infinity",
        "LimitCORESoft": "0",
        "LimitCPU": "infinity",
        "LimitCPUSoft": "infinity",
        "LimitDATA": "infinity",
        "LimitDATASoft": "infinity",
        "LimitFSIZE": "infinity",
        "LimitFSIZESoft": "infinity",
        "LimitLOCKS": "infinity",
        "LimitLOCKSSoft": "infinity",
        "LimitMEMLOCK": "65536",
        "LimitMEMLOCKSoft": "65536",
        "LimitMSGQUEUE": "819200",
        "LimitMSGQUEUESoft": "819200",
        "LimitNICE": "0",
        "LimitNICESoft": "0",
        "LimitNOFILE": "262144",
        "LimitNOFILESoft": "1024",
        "LimitNPROC": "28608",
        "LimitNPROCSoft": "28608",
        "LimitRSS": "infinity",
        "LimitRSSSoft": "infinity",
        "LimitRTPRIO": "0",
        "LimitRTPRIOSoft": "0",
        "LimitRTTIME": "infinity",
        "LimitRTTIMESoft": "infinity",
        "LimitSIGPENDING": "28608",
        "LimitSIGPENDINGSoft": "28608",
        "LimitSTACK": "infinity",
        "LimitSTACKSoft": "8388608",
        "LoadState": "loaded",
        "LockPersonality": "no",
        "LogLevelMax": "-1",
        "LogRateLimitBurst": "0",
        "LogRateLimitIntervalUSec": "0",
        "LogsDirectoryMode": "0755",
        "MainPID": "695",
        "MemoryAccounting": "yes",
        "MemoryCurrent": "21356544",
        "MemoryDenyWriteExecute": "no",
        "MemoryHigh": "infinity",
        "MemoryLimit": "infinity",
        "MemoryLow": "0",
        "MemoryMax": "infinity",
        "MemoryMin": "0",
        "MemorySwapMax": "infinity",
        "MountAPIVFS": "no",
        "MountFlags": "",
        "NFileDescriptorStore": "0",
        "NRestarts": "0",
        "NUMAMask": "",
        "NUMAPolicy": "n/a",
        "Names": "tuned.service",
        "NeedDaemonReload": "no",
        "Nice": "0",
        "NoNewPrivileges": "no",
        "NonBlocking": "no",
        "NotifyAccess": "none",
        "OOMScoreAdjust": "0",
        "OnFailureJobMode": "replace",
        "PIDFile": "/run/tuned/tuned.pid",
        "PermissionsStartOnly": "no",
        "Perpetual": "no",
        "PrivateDevices": "no",
        "PrivateMounts": "no",
        "PrivateNetwork": "no",
        "PrivateTmp": "no",
        "PrivateUsers": "no",
        "ProtectControlGroups": "no",
        "ProtectHome": "no",
        "ProtectKernelModules": "no",
        "ProtectKernelTunables": "no",
        "ProtectSystem": "no",
        "RefuseManualStart": "no",
        "RefuseManualStop": "no",
        "RemainAfterExit": "no",
        "RemoveIPC": "no",
        "Requires": "sysinit.target dbus.socket dbus.service system.slice",
        "Restart": "no",
        "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",
        "StandardInputData": "",
        "StandardOutput": "journal",
        "StartLimitAction": "none",
        "StartLimitBurst": "5",
        "StartLimitIntervalUSec": "10s",
        "StartupBlockIOWeight": "[not set]",
        "StartupCPUShares": "[not set]",
        "StartupCPUWeight": "[not set]",
        "StartupIOWeight": "[not set]",
        "StateChangeTimestamp": "Wed 2025-05-14 12:19:23 EDT",
        "StateChangeTimestampMonotonic": "15850565",
        "StateDirectoryMode": "0755",
        "StatusErrno": "0",
        "StopWhenUnneeded": "no",
        "SubState": "running",
        "SuccessAction": "none",
        "SyslogFacility": "3",
        "SyslogLevel": "6",
        "SyslogLevelPrefix": "yes",
        "SyslogPriority": "30",
        "SystemCallErrorNumber": "0",
        "TTYReset": "no",
        "TTYVHangup": "no",
        "TTYVTDisallocate": "no",
        "TasksAccounting": "yes",
        "TasksCurrent": "4",
        "TasksMax": "45773",
        "TimeoutStartUSec": "1min 30s",
        "TimeoutStopUSec": "1min 30s",
        "TimerSlackNSec": "50000",
        "Transient": "no",
        "Type": "dbus",
        "UID": "[not set]",
        "UMask": "0022",
        "UnitFilePreset": "enabled",
        "UnitFileState": "enabled",
        "UtmpMode": "init",
        "WantedBy": "multi-user.target",
        "WatchdogTimestamp": "Wed 2025-05-14 12:19:23 EDT",
        "WatchdogTimestampMonotonic": "15850562",
        "WatchdogUSec": "0"
    }
}

TASK [fedora.linux_system_roles.mssql : Ensure that the tuned service is started] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:450
Wednesday 14 May 2025  12:48:38 -0400 (0:00:00.488)       0:01:44.883 ********* 
ok: [managed-node3] => {
    "changed": false,
    "name": "tuned",
    "state": "started",
    "status": {
        "ActiveEnterTimestamp": "Wed 2025-05-14 12:19:23 EDT",
        "ActiveEnterTimestampMonotonic": "15850565",
        "ActiveExitTimestampMonotonic": "0",
        "ActiveState": "active",
        "After": "basic.target dbus.socket system.slice systemd-sysctl.service sysinit.target network.target polkit.service dbus.service systemd-journald.socket",
        "AllowIsolate": "no",
        "AllowedCPUs": "",
        "AllowedMemoryNodes": "",
        "AmbientCapabilities": "",
        "AssertResult": "yes",
        "AssertTimestamp": "Wed 2025-05-14 12:19:22 EDT",
        "AssertTimestampMonotonic": "14290150",
        "Before": "shutdown.target multi-user.target",
        "BlockIOAccounting": "no",
        "BlockIOWeight": "[not set]",
        "BusName": "com.redhat.tuned",
        "CPUAccounting": "no",
        "CPUAffinity": "",
        "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",
        "CollectMode": "inactive",
        "ConditionResult": "yes",
        "ConditionTimestamp": "Wed 2025-05-14 12:19:22 EDT",
        "ConditionTimestampMonotonic": "14290149",
        "ConfigurationDirectoryMode": "0755",
        "Conflicts": "power-profiles-daemon.service shutdown.target cpupower.service auto-cpufreq.service tlp.service",
        "ControlGroup": "/system.slice/tuned.service",
        "ControlPID": "0",
        "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",
        "EffectiveCPUs": "",
        "EffectiveMemoryNodes": "",
        "ExecMainCode": "0",
        "ExecMainExitTimestampMonotonic": "0",
        "ExecMainPID": "695",
        "ExecMainStartTimestamp": "Wed 2025-05-14 12:19:22 EDT",
        "ExecMainStartTimestampMonotonic": "14290855",
        "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 }",
        "FailureAction": "none",
        "FileDescriptorStoreMax": "0",
        "FragmentPath": "/usr/lib/systemd/system/tuned.service",
        "FreezerState": "running",
        "GID": "[not set]",
        "GuessMainPID": "yes",
        "IOAccounting": "no",
        "IOSchedulingClass": "0",
        "IOSchedulingPriority": "0",
        "IOWeight": "[not set]",
        "IPAccounting": "no",
        "IPEgressBytes": "18446744073709551615",
        "IPEgressPackets": "18446744073709551615",
        "IPIngressBytes": "18446744073709551615",
        "IPIngressPackets": "18446744073709551615",
        "Id": "tuned.service",
        "IgnoreOnIsolate": "no",
        "IgnoreSIGPIPE": "yes",
        "InactiveEnterTimestampMonotonic": "0",
        "InactiveExitTimestamp": "Wed 2025-05-14 12:19:22 EDT",
        "InactiveExitTimestampMonotonic": "14290894",
        "InvocationID": "387dbc3035f44087a5a53a4ed1de7ab2",
        "JobRunningTimeoutUSec": "infinity",
        "JobTimeoutAction": "none",
        "JobTimeoutUSec": "infinity",
        "KeyringMode": "private",
        "KillMode": "control-group",
        "KillSignal": "15",
        "LimitAS": "infinity",
        "LimitASSoft": "infinity",
        "LimitCORE": "infinity",
        "LimitCORESoft": "0",
        "LimitCPU": "infinity",
        "LimitCPUSoft": "infinity",
        "LimitDATA": "infinity",
        "LimitDATASoft": "infinity",
        "LimitFSIZE": "infinity",
        "LimitFSIZESoft": "infinity",
        "LimitLOCKS": "infinity",
        "LimitLOCKSSoft": "infinity",
        "LimitMEMLOCK": "65536",
        "LimitMEMLOCKSoft": "65536",
        "LimitMSGQUEUE": "819200",
        "LimitMSGQUEUESoft": "819200",
        "LimitNICE": "0",
        "LimitNICESoft": "0",
        "LimitNOFILE": "262144",
        "LimitNOFILESoft": "1024",
        "LimitNPROC": "28608",
        "LimitNPROCSoft": "28608",
        "LimitRSS": "infinity",
        "LimitRSSSoft": "infinity",
        "LimitRTPRIO": "0",
        "LimitRTPRIOSoft": "0",
        "LimitRTTIME": "infinity",
        "LimitRTTIMESoft": "infinity",
        "LimitSIGPENDING": "28608",
        "LimitSIGPENDINGSoft": "28608",
        "LimitSTACK": "infinity",
        "LimitSTACKSoft": "8388608",
        "LoadState": "loaded",
        "LockPersonality": "no",
        "LogLevelMax": "-1",
        "LogRateLimitBurst": "0",
        "LogRateLimitIntervalUSec": "0",
        "LogsDirectoryMode": "0755",
        "MainPID": "695",
        "MemoryAccounting": "yes",
        "MemoryCurrent": "21356544",
        "MemoryDenyWriteExecute": "no",
        "MemoryHigh": "infinity",
        "MemoryLimit": "infinity",
        "MemoryLow": "0",
        "MemoryMax": "infinity",
        "MemoryMin": "0",
        "MemorySwapMax": "infinity",
        "MountAPIVFS": "no",
        "MountFlags": "",
        "NFileDescriptorStore": "0",
        "NRestarts": "0",
        "NUMAMask": "",
        "NUMAPolicy": "n/a",
        "Names": "tuned.service",
        "NeedDaemonReload": "no",
        "Nice": "0",
        "NoNewPrivileges": "no",
        "NonBlocking": "no",
        "NotifyAccess": "none",
        "OOMScoreAdjust": "0",
        "OnFailureJobMode": "replace",
        "PIDFile": "/run/tuned/tuned.pid",
        "PermissionsStartOnly": "no",
        "Perpetual": "no",
        "PrivateDevices": "no",
        "PrivateMounts": "no",
        "PrivateNetwork": "no",
        "PrivateTmp": "no",
        "PrivateUsers": "no",
        "ProtectControlGroups": "no",
        "ProtectHome": "no",
        "ProtectKernelModules": "no",
        "ProtectKernelTunables": "no",
        "ProtectSystem": "no",
        "RefuseManualStart": "no",
        "RefuseManualStop": "no",
        "RemainAfterExit": "no",
        "RemoveIPC": "no",
        "Requires": "sysinit.target dbus.socket dbus.service system.slice",
        "Restart": "no",
        "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",
        "StandardInputData": "",
        "StandardOutput": "journal",
        "StartLimitAction": "none",
        "StartLimitBurst": "5",
        "StartLimitIntervalUSec": "10s",
        "StartupBlockIOWeight": "[not set]",
        "StartupCPUShares": "[not set]",
        "StartupCPUWeight": "[not set]",
        "StartupIOWeight": "[not set]",
        "StateChangeTimestamp": "Wed 2025-05-14 12:19:23 EDT",
        "StateChangeTimestampMonotonic": "15850565",
        "StateDirectoryMode": "0755",
        "StatusErrno": "0",
        "StopWhenUnneeded": "no",
        "SubState": "running",
        "SuccessAction": "none",
        "SyslogFacility": "3",
        "SyslogLevel": "6",
        "SyslogLevelPrefix": "yes",
        "SyslogPriority": "30",
        "SystemCallErrorNumber": "0",
        "TTYReset": "no",
        "TTYVHangup": "no",
        "TTYVTDisallocate": "no",
        "TasksAccounting": "yes",
        "TasksCurrent": "4",
        "TasksMax": "45773",
        "TimeoutStartUSec": "1min 30s",
        "TimeoutStopUSec": "1min 30s",
        "TimerSlackNSec": "50000",
        "Transient": "no",
        "Type": "dbus",
        "UID": "[not set]",
        "UMask": "0022",
        "UnitFilePreset": "enabled",
        "UnitFileState": "enabled",
        "UtmpMode": "init",
        "WantedBy": "multi-user.target",
        "WatchdogTimestamp": "Wed 2025-05-14 12:19:23 EDT",
        "WatchdogTimestampMonotonic": "15850562",
        "WatchdogUSec": "0"
    }
}

TASK [fedora.linux_system_roles.mssql : Get the active Tuned profiles] *********
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:458
Wednesday 14 May 2025  12:48:39 -0400 (0:00:00.490)       0:01:45.374 ********* 
ok: [managed-node3] => {
    "changed": false,
    "content": "dmlydHVhbC1ndWVzdCBtc3NxbAo=",
    "encoding": "base64",
    "source": "/etc/tuned/active_profile"
}

TASK [fedora.linux_system_roles.mssql : Decode the active Tuned profiles] ******
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:464
Wednesday 14 May 2025  12:48:39 -0400 (0:00:00.393)       0:01:45.767 ********* 
ok: [managed-node3] => {
    "ansible_facts": {
        "__mssql_tuned_active_profiles": "virtual-guest mssql"
    },
    "changed": false
}

TASK [fedora.linux_system_roles.mssql : Attempt to add mssql to the list of Tuned profiles] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:477
Wednesday 14 May 2025  12:48:39 -0400 (0:00:00.042)       0:01:45.809 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "\"mssql\" not in __mssql_tuned_active_profiles",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Remove troublemaking include from the mssql profile] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:489
Wednesday 14 May 2025  12:48:39 -0400 (0:00:00.032)       0:01:45.842 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "\"mssql\" not in __mssql_tuned_active_profiles",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Add the fixed mssql profile to the list of Tuned profiles] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:498
Wednesday 14 May 2025  12:48:39 -0400 (0:00:00.030)       0:01:45.873 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "\"mssql\" not in __mssql_tuned_active_profiles",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Attempt to add mssql to the list of Tuned profiles] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:515
Wednesday 14 May 2025  12:48:39 -0400 (0:00:00.032)       0:01:45.905 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "not __mssql_is_booted",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server Tools repository] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:523
Wednesday 14 May 2025  12:48:39 -0400 (0:00:00.027)       0:01:45.933 ********* 
ok: [managed-node3] => {
    "changed": false,
    "repo": "packages-microsoft-com-prod",
    "state": "present"
}

TASK [fedora.linux_system_roles.mssql : Configure the Microsoft SQL Server Tools repository] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:531
Wednesday 14 May 2025  12:48:39 -0400 (0:00:00.354)       0:01:46.287 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "ansible_pkg_mgr == \"zypper\"",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Ensure that SQL Server client tools are installed] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:540
Wednesday 14 May 2025  12:48:39 -0400 (0:00:00.029)       0:01:46.316 ********* 
ok: [managed-node3] => {
    "changed": false,
    "rc": 0,
    "results": []
}

MSG:

Nothing to do

TASK [Create certificates using the certificate role] **************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:557
Wednesday 14 May 2025  12:48:42 -0400 (0:00:02.923)       0:01:49.240 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_tls_enable | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Set mssql_tls_cert and _private_key based on the cert name] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:571
Wednesday 14 May 2025  12:48:42 -0400 (0:00:00.037)       0:01:49.277 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_tls_enable | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Copy certificate and private_key files to the host] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:576
Wednesday 14 May 2025  12:48:42 -0400 (0:00:00.035)       0:01:49.313 ********* 
skipping: [managed-node3] => (item=/tmp/ansible.tcx5x7hz)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "mssql_tls_enable | bool",
    "item": "/tmp/ansible.tcx5x7hz",
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node3] => (item=ansible.jahlsqzq)  => {
    "ansible_loop_var": "item",
    "changed": false,
    "false_condition": "mssql_tls_enable | bool",
    "item": "ansible.jahlsqzq",
    "skip_reason": "Conditional result was False"
}
skipping: [managed-node3] => {
    "changed": false
}

MSG:

All items skipped

TASK [fedora.linux_system_roles.mssql : Configure the tlscert setting] *********
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:594
Wednesday 14 May 2025  12:48:42 -0400 (0:00:00.040)       0:01:49.353 ********* 
included: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml for managed-node3

TASK [fedora.linux_system_roles.mssql : Get the setting network tlscert] *******
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:3
Wednesday 14 May 2025  12:48:43 -0400 (0:00:00.054)       0:01:49.408 ********* 
ok: [managed-node3] => {
    "changed": false,
    "cmd": [
        "grep",
        "^tlscert = ",
        "/var/opt/mssql/mssql.conf"
    ],
    "delta": "0:00:00.002338",
    "end": "2025-05-14 12:48:43.371196",
    "failed_when_result": false,
    "rc": 0,
    "start": "2025-05-14 12:48:43.368858"
}

STDOUT:

tlscert = /etc/pki/tls/certs/ansible.tcx5x7hz

TASK [fedora.linux_system_roles.mssql : Configure the setting network tlscert] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:12
Wednesday 14 May 2025  12:48:43 -0400 (0:00:00.382)       0:01:49.790 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "(__mssql_conf_setting_value != 'unset') and ((\"No setting for the given\" in __mssql_conf_get_setting.stdout) or ((__mssql_conf_setting_value | type_debug != \"bool\") and (__mssql_conf_setting_value | string | lower not in __mssql_conf_get_value | lower)) or ((__mssql_conf_setting_value | type_debug == \"bool\") and (__mssql_conf_setting_value != __mssql_conf_get_value | bool)))",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Unset the setting network tlscert] *****
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:42
Wednesday 14 May 2025  12:48:43 -0400 (0:00:00.055)       0:01:49.845 ********* 
Notification for handler Restart the mssql-server service has been saved.
changed: [managed-node3] => {
    "changed": true,
    "cmd": [
        "/opt/mssql/bin/mssql-conf",
        "unset",
        "network.tlscert"
    ],
    "delta": "0:00:00.042481",
    "end": "2025-05-14 12:48:43.816300",
    "failed_when_result": false,
    "rc": 0,
    "start": "2025-05-14 12:48:43.773819"
}

STDOUT:

SQL Server needs to be restarted in order to apply this setting. Please run
'systemctl restart mssql-server.service'.

TASK [fedora.linux_system_roles.mssql : Configure the tlskey setting] **********
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:603
Wednesday 14 May 2025  12:48:43 -0400 (0:00:00.403)       0:01:50.249 ********* 
included: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml for managed-node3

TASK [fedora.linux_system_roles.mssql : Get the setting network tlskey] ********
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:3
Wednesday 14 May 2025  12:48:43 -0400 (0:00:00.065)       0:01:50.315 ********* 
ok: [managed-node3] => {
    "changed": false,
    "cmd": [
        "grep",
        "^tlskey = ",
        "/var/opt/mssql/mssql.conf"
    ],
    "delta": "0:00:00.002516",
    "end": "2025-05-14 12:48:44.241719",
    "failed_when_result": false,
    "rc": 0,
    "start": "2025-05-14 12:48:44.239203"
}

STDOUT:

tlskey = /etc/pki/tls/private/ansible.jahlsqzq

TASK [fedora.linux_system_roles.mssql : Configure the setting network tlskey] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:12
Wednesday 14 May 2025  12:48:44 -0400 (0:00:00.360)       0:01:50.675 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "(__mssql_conf_setting_value != 'unset') and ((\"No setting for the given\" in __mssql_conf_get_setting.stdout) or ((__mssql_conf_setting_value | type_debug != \"bool\") and (__mssql_conf_setting_value | string | lower not in __mssql_conf_get_value | lower)) or ((__mssql_conf_setting_value | type_debug == \"bool\") and (__mssql_conf_setting_value != __mssql_conf_get_value | bool)))",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Unset the setting network tlskey] ******
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:42
Wednesday 14 May 2025  12:48:44 -0400 (0:00:00.063)       0:01:50.738 ********* 
Notification for handler Restart the mssql-server service has been saved.
changed: [managed-node3] => {
    "changed": true,
    "cmd": [
        "/opt/mssql/bin/mssql-conf",
        "unset",
        "network.tlskey"
    ],
    "delta": "0:00:00.042101",
    "end": "2025-05-14 12:48:44.727493",
    "failed_when_result": false,
    "rc": 0,
    "start": "2025-05-14 12:48:44.685392"
}

STDOUT:

SQL Server needs to be restarted in order to apply this setting. Please run
'systemctl restart mssql-server.service'.

TASK [fedora.linux_system_roles.mssql : Configure the tlsprotocols setting] ****
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:612
Wednesday 14 May 2025  12:48:44 -0400 (0:00:00.405)       0:01:51.144 ********* 
included: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml for managed-node3

TASK [fedora.linux_system_roles.mssql : Get the setting network tlsprotocols] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:3
Wednesday 14 May 2025  12:48:44 -0400 (0:00:00.057)       0:01:51.201 ********* 
ok: [managed-node3] => {
    "changed": false,
    "cmd": [
        "grep",
        "^tlsprotocols = ",
        "/var/opt/mssql/mssql.conf"
    ],
    "delta": "0:00:00.002406",
    "end": "2025-05-14 12:48:45.125999",
    "failed_when_result": false,
    "rc": 0,
    "start": "2025-05-14 12:48:45.123593"
}

STDOUT:

tlsprotocols = 1.2

TASK [fedora.linux_system_roles.mssql : Configure the setting network tlsprotocols] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:12
Wednesday 14 May 2025  12:48:45 -0400 (0:00:00.336)       0:01:51.538 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "(__mssql_conf_setting_value != 'unset') and ((\"No setting for the given\" in __mssql_conf_get_setting.stdout) or ((__mssql_conf_setting_value | type_debug != \"bool\") and (__mssql_conf_setting_value | string | lower not in __mssql_conf_get_value | lower)) or ((__mssql_conf_setting_value | type_debug == \"bool\") and (__mssql_conf_setting_value != __mssql_conf_get_value | bool)))",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Unset the setting network tlsprotocols] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:42
Wednesday 14 May 2025  12:48:45 -0400 (0:00:00.065)       0:01:51.603 ********* 
Notification for handler Restart the mssql-server service has been saved.
changed: [managed-node3] => {
    "changed": true,
    "cmd": [
        "/opt/mssql/bin/mssql-conf",
        "unset",
        "network.tlsprotocols"
    ],
    "delta": "0:00:00.042984",
    "end": "2025-05-14 12:48:45.609707",
    "failed_when_result": false,
    "rc": 0,
    "start": "2025-05-14 12:48:45.566723"
}

STDOUT:

SQL Server needs to be restarted in order to apply this setting. Please run
'systemctl restart mssql-server.service'.

TASK [fedora.linux_system_roles.mssql : Configure the forceencryption setting] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:619
Wednesday 14 May 2025  12:48:45 -0400 (0:00:00.449)       0:01:52.052 ********* 
included: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml for managed-node3

TASK [fedora.linux_system_roles.mssql : Get the setting network forceencryption] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:3
Wednesday 14 May 2025  12:48:45 -0400 (0:00:00.142)       0:01:52.195 ********* 
ok: [managed-node3] => {
    "changed": false,
    "cmd": [
        "grep",
        "^forceencryption = ",
        "/var/opt/mssql/mssql.conf"
    ],
    "delta": "0:00:00.002379",
    "end": "2025-05-14 12:48:46.121924",
    "failed_when_result": false,
    "rc": 0,
    "start": "2025-05-14 12:48:46.119545"
}

STDOUT:

forceencryption = 1

TASK [fedora.linux_system_roles.mssql : Configure the setting network forceencryption] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:12
Wednesday 14 May 2025  12:48:46 -0400 (0:00:00.342)       0:01:52.538 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "(__mssql_conf_setting_value != 'unset') and ((\"No setting for the given\" in __mssql_conf_get_setting.stdout) or ((__mssql_conf_setting_value | type_debug != \"bool\") and (__mssql_conf_setting_value | string | lower not in __mssql_conf_get_value | lower)) or ((__mssql_conf_setting_value | type_debug == \"bool\") and (__mssql_conf_setting_value != __mssql_conf_get_value | bool)))",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Unset the setting network forceencryption] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/mssql_conf_setting.yml:42
Wednesday 14 May 2025  12:48:46 -0400 (0:00:00.040)       0:01:52.578 ********* 
Notification for handler Restart the mssql-server service has been saved.
changed: [managed-node3] => {
    "changed": true,
    "cmd": [
        "/opt/mssql/bin/mssql-conf",
        "unset",
        "network.forceencryption"
    ],
    "delta": "0:00:00.043244",
    "end": "2025-05-14 12:48:46.546864",
    "failed_when_result": false,
    "rc": 0,
    "start": "2025-05-14 12:48:46.503620"
}

STDOUT:

SQL Server needs to be restarted in order to apply this setting. Please run
'systemctl restart mssql-server.service'.

TASK [fedora.linux_system_roles.mssql : Get the setting forceencryption] *******
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:628
Wednesday 14 May 2025  12:48:46 -0400 (0:00:00.389)       0:01:52.967 ********* 
ok: [managed-node3] => {
    "changed": false,
    "cmd": "set -euo pipefail; grep '^forceencryption' /var/opt/mssql/mssql.conf | sed 's/forceencryption = //g'",
    "delta": "0:00:00.004033",
    "end": "2025-05-14 12:48:46.898428",
    "failed_when_result": false,
    "rc": 1,
    "start": "2025-05-14 12:48:46.894395"
}

MSG:

non-zero return code

TASK [fedora.linux_system_roles.mssql : Append -No to sqlcmd when TLS is not configured] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:637
Wednesday 14 May 2025  12:48:46 -0400 (0:00:00.345)       0:01:53.312 ********* 
ok: [managed-node3] => {
    "ansible_facts": {
        "__sqlcmd_cli": "/opt/mssql-tools18/bin/sqlcmd -C -No"
    },
    "changed": false
}

TASK [fedora.linux_system_roles.mssql : Append -C to sqlcmd when TLS is configured but certs are self-signed] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:644
Wednesday 14 May 2025  12:48:46 -0400 (0:00:00.039)       0:01:53.351 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "__mssql_forceencryption_val.stdout == '1'",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Prepare MSSQL and facts for logging in] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:657
Wednesday 14 May 2025  12:48:47 -0400 (0:00:00.035)       0:01:53.387 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_password is not none",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Wait for mssql-server to prepare for client connections] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:661
Wednesday 14 May 2025  12:48:47 -0400 (0:00:00.031)       0:01:53.419 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_password is not none",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Check if the set password matches the existing password] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:667
Wednesday 14 May 2025  12:48:47 -0400 (0:00:00.033)       0:01:53.452 ********* 
skipping: [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 : Ensure that the mssql-server service is stopped] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:683
Wednesday 14 May 2025  12:48:47 -0400 (0:00:00.033)       0:01:53.485 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_password is not none",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Gather package facts] ******************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:692
Wednesday 14 May 2025  12:48:47 -0400 (0:00:00.036)       0:01:53.522 ********* 
skipping: [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 : Change the password of sa user] ********
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:700
Wednesday 14 May 2025  12:48:47 -0400 (0:00:00.053)       0:01:53.575 ********* 
skipping: [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 : Pre-input SQL script files to SQL Server] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:721
Wednesday 14 May 2025  12:48:47 -0400 (0:00:00.040)       0:01:53.616 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_pre_input_sql_file != []",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Pre-input SQL script contents to SQL Server] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:730
Wednesday 14 May 2025  12:48:47 -0400 (0:00:00.037)       0:01:53.654 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "mssql_pre_input_sql_content != []",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Check if the set edition matches the existing edition] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:743
Wednesday 14 May 2025  12:48:47 -0400 (0:00:00.036)       0:01:53.691 ********* 
ok: [managed-node3] => {
    "changed": false,
    "cmd": "errorlog_edition=\"$(grep -oi 'Evaluation edition' \\\n/var/opt/mssql/log/errorlog)\"\nif [ -z \"${errorlog_edition}\" ]; then\n  edition_matches=false\nelse\n  edition_matches=true\nfi\necho \"${edition_matches}\"\n",
    "delta": "0:00:00.004301",
    "end": "2025-05-14 12:48:47.624442",
    "rc": 0,
    "start": "2025-05-14 12:48:47.620141"
}

STDOUT:

true

TASK [fedora.linux_system_roles.mssql : Ensure that the mssql-server service is stopped] ***
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:758
Wednesday 14 May 2025  12:48:47 -0400 (0:00:00.369)       0:01:54.060 ********* 
skipping: [managed-node3] => {
    "changed": false,
    "false_condition": "not __mssql_edition_matches.stdout | bool",
    "skip_reason": "Conditional result was False"
}

TASK [fedora.linux_system_roles.mssql : Gather package facts] ******************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:767
Wednesday 14 May 2025  12:48:47 -0400 (0:00:00.053)       0:01:54.114 ********* 
fatal: [managed-node3]: FAILED! => {
    "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result"
}

TASK [Clean up after the role invocation] **************************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_tls_2017.yml:27
Wednesday 14 May 2025  12:48:48 -0400 (0:00:00.863)       0:01:54.977 ********* 
included: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml for managed-node3

TASK [Gather package facts] ****************************************************
task path: /tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/cleanup.yml:2
Wednesday 14 May 2025  12:48:48 -0400 (0:00:00.110)       0:01:55.088 ********* 
fatal: [managed-node3]: UNREACHABLE! => {
    "censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result",
    "changed": false
}

PLAY RECAP *********************************************************************
managed-node3              : ok=119  changed=24   unreachable=1    failed=1    skipped=208  rescued=0    ignored=0   


TASKS RECAP ********************************************************************
Wednesday 14 May 2025  12:48:48 -0400 (0:00:00.021)       0:01:55.110 ********* 
=============================================================================== 
fedora.linux_system_roles.mssql : Ensure the package mssql-server ------ 38.34s
/tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:309 
fedora.linux_system_roles.mssql : Set up MSSQL -------------------------- 4.42s
/tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:368 
fedora.linux_system_roles.mssql : Ensure that SQL Server client tools are installed --- 4.03s
/tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:540 
fedora.linux_system_roles.mssql : Ensure that the tuned-profiles-mssql package is installed --- 3.20s
/tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:438 
fedora.linux_system_roles.mssql : Configure to run as a confined application with SELinux --- 2.97s
/tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:304 
Ensure the openssl package ---------------------------------------------- 2.95s
/tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:5 
fedora.linux_system_roles.mssql : Ensure that SQL Server client tools are installed --- 2.92s
/tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:540 
fedora.linux_system_roles.mssql : Configure to run as a confined application with SELinux --- 2.87s
/tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:304 
fedora.linux_system_roles.mssql : Ensure the package mssql-server ------- 2.85s
/tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:309 
fedora.linux_system_roles.mssql : Ensure that the tuned-profiles-mssql package is installed --- 2.82s
/tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:438 
fedora.linux_system_roles.mssql : Gather package facts ------------------ 1.68s
/tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:162 
fedora.linux_system_roles.mssql : Gather package facts ------------------ 1.54s
/tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:162 
Wait for mssql-server to prepare for client connections ----------------- 1.51s
/tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/verify_settings.yml:96 
Gathering Facts --------------------------------------------------------- 1.51s
/tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tests_tls_2017.yml:9 
fedora.linux_system_roles.mssql : Copy certificate and private_key files to the host --- 1.34s
/tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:576 
fedora.linux_system_roles.mssql : Gather package facts ------------------ 0.86s
/tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:767 
Modify the mssql-server service start limit interval and burst ---------- 0.79s
/tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/mssql-sever-increase-start-limit.yml:11 
Copy certificate files to local tmp ------------------------------------- 0.78s
/tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/tests_tls.yml:32 
Reload service daemon --------------------------------------------------- 0.76s
/tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/tests/mssql/tasks/mssql-sever-increase-start-limit.yml:23 
fedora.linux_system_roles.mssql : Ensure that the tuned service is enabled --- 0.75s
/tmp/collections-5YH/ansible_collections/fedora/linux_system_roles/roles/mssql/tasks/main.yml:444