{"id":5405,"sha1":"8ce84f3e6ab08c719ebac9305ee4924136f9ec26","playbook":{"id":3285,"items":{"plays":1,"tasks":5,"results":1990,"hosts":399,"files":1,"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":["RM10090_find_and_tag_snowflakes.yaml"]},"labels":[{"id":1,"name":"remote_user:root"},{"id":2,"name":"check:False"},{"id":3,"name":"tags:all"}],"started":"2025-07-22T09:21:49.524807+01:00","ended":"2025-07-22T09:27:05.172841+01:00","duration":"00:05:15.648034","name":null,"ansible_version":"2.16.11","client_version":"1.7.2","python_version":"3.10.10","server_version":"1.7.2","status":"completed","path":"/home/ssh-gateway/ansible/kuly/RM10090_find_and_tag_snowflakes.yaml","controller":"ssh-gw-4.layershift.com","user":"root"},"content":"---\n- name: Playbook to find the snowflakes having manage_server_db set\n  hosts: all\n  gather_facts: false\n  tasks:\n    - name: Get plesk info\n      plesk_info:\n      register: plsk\n    - name: On plesk server get me the state\n      when: plsk.plesk_found\n      ansible.builtin.shell: |\n        set -o pipefail\n        plesk db -N -e \"SELECT p.value FROM Permissions p LEFT JOIN clients c ON c.perm_id = p.id WHERE p.permission = 'manage_server_db' AND c.id IS NOT NULL\"\n      args:\n        executable: /bin/bash\n      register: snowflake\n      changed_when: false\n    - name: If snowflake make flag\n      when:\n        - plsk.plesk_found\n        - snowflake is defined\n        - \"'true' in snowflake.stdout\"\n      block:\n        - name: Show debug\n          ansible.builtin.debug:\n            msg: \"We have found a flake\"\n          changed_when: true\n        - name: Save the name into a file\n          ansible.builtin.lineinfile:\n            path: \"/home/ssh-gateway/ansible/kuly/RM10090_snowflakes.txt\"\n            create: true\n            mode: '0644'\n            line: \"{{ inventory_hostname }}\"\n          delegate_to: 127.0.0.1\n        - name: Create snowflake flag file\n          ansible.builtin.shell: |\n            set -o pipefail\n            echo \"test\"\n            #mkdir -p /opt/layershift/snowflake/\n            #touch /opt/layershift/snowflake/manage_server_phpmyadmin.flag\n          args:\n            executable: /bin/bash\n          changed_when: false\n","created":"2025-07-22T09:21:49.549562+01:00","updated":"2025-07-22T09:21:49.549589+01:00","path":"/home/ssh-gateway/ansible/kuly/RM10090_find_and_tag_snowflakes.yaml"}