{"id":3413,"sha1":"b2ffd210aed61b7dedacb649420b9370cdf0a94e","playbook":{"id":1757,"items":{"plays":1,"tasks":6,"results":828,"hosts":138,"files":6,"records":0},"arguments":{"version":null,"verbosity":2,"private_key_file":"/home/ssh-gateway/.ssh/id_rsa","remote_user":"root","connection":"ssh","timeout":null,"ssh_common_args":null,"sftp_extra_args":null,"scp_extra_args":null,"ssh_extra_args":null,"ask_pass":false,"connection_password_file":null,"force_handlers":false,"flush_cache":false,"become":false,"become_method":"sudo","become_user":null,"become_ask_pass":false,"become_password_file":null,"tags":["all"],"skip_tags":[],"check":false,"diff":false,"inventory":["/home/ssh-gateway/ansible/kuly/bash-kvm-inventory-prod.sh"],"listhosts":false,"subset":null,"extra_vars":"Not saved by ARA as configured by 'ignored_arguments'","vault_ids":[],"ask_vault_pass":false,"vault_password_files":[],"forks":20,"module_path":null,"syntax":false,"listtasks":false,"listtags":false,"step":false,"start_at_task":null,"args":["check-if-mariadb.yaml"]},"labels":[{"id":1,"name":"remote_user:root"},{"id":2,"name":"check:False"},{"id":3,"name":"tags:all"}],"started":"2024-09-11T15:33:23.089093+01:00","ended":"2024-09-11T15:35:16.229745+01:00","duration":"00:01:53.140652","name":null,"ansible_version":"2.16.4","client_version":"1.7.1","python_version":"3.10.10","server_version":"1.7.1","status":"completed","path":"/home/ssh-gateway/ansible/kuly/check-if-mariadb.yaml","controller":"ssh-gw-4.layershift.com","user":"root"},"content":"---\n- name: Check\n  hosts: all\n  gather_facts: false\n  roles:\n    - plesk\n  tasks:\n    - name: Check if mariadb\n      when: plesk_found\n      block:\n        - name: Check if MariaDB service is running\n          ansible.builtin.systemd:\n            name: mariadb\n            state: started\n          register: mariadb_status\n          ignore_errors: true\n        - name: Check if MySQL service is running\n          ansible.builtin.systemd:\n            name: mysql\n            state: started\n          when: mariadb_status is failed\n          register: mysql_status\n          ignore_errors: true\n        - name: Set result based on service status\n          ansible.builtin.set_fact:\n            db_service_status: |\n              {% if mariadb_status is succeeded %}\n                MariaDB is running\n              {% elif mysql_status is succeeded %}\n                MySQL is running\n              {% else %}\n                Neither MariaDB nor MySQL is running\n              {% endif %}\n        - name: Display the database service status\n          ansible.builtin.debug:\n            msg: \"{{ db_service_status }}\"\n","created":"2024-09-11T15:33:23.110605+01:00","updated":"2024-09-11T15:33:23.110626+01:00","path":"/home/ssh-gateway/ansible/kuly/check-if-mariadb.yaml"}