{"id":764,"sha1":"7b171766937e1117f5237d7438e8603373d22301","playbook":{"id":764,"items":{"plays":1,"tasks":3,"results":2,"hosts":1,"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/bash-kvm-inventory-prod.sh"],"listhosts":false,"subset":"versatile-chipmunk.man-1.vm.plesk-server.com","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":["projects/RM9615/RM9615-remove_duplicate_mysql_settings.yaml"]},"labels":[{"id":1,"name":"remote_user:root"},{"id":2,"name":"check:False"},{"id":3,"name":"tags:all"},{"id":80,"name":"subset:versatile-chipmunk.man-1.vm.plesk-server.com"}],"started":"2024-06-28T08:52:51.217131+01:00","ended":null,"duration":null,"name":null,"ansible_version":"2.16.4","client_version":"1.7.1","python_version":"3.10.10","server_version":"1.7.1","status":"running","path":"/home/ssh-gateway/ansible/projects/RM9615/RM9615-remove_duplicate_mysql_settings.yaml","controller":"ssh-gw-4.layershift.com","user":"root"},"content":"---\n- name: Run a script that checks and removes mysql duplicate settings\n  hosts: all\n  gather_facts: false\n  vars:\n    folder: /home/ssh-gateway/ansible/projects/RM9615\n    files_to_upload:\n      - \"{{ folder }}/RM9615-list_directives\"\n      - \"{{ folder }}/remove_mysql_settings.sh\"\n  tasks:\n    - name: Check if /etc/my.cnf exists\n      ansible.builtin.stat:\n        path: /etc/my.cnf\n      register: my_cnf\n\n    - name: Check if /etc/my.cnf.d/zz_layershift-defaults.cnf exists\n      ansible.builtin.stat:\n        path: /etc/my.cnf.d/zz_layershift-defaults.cnf\n      register: layershift_defaults_cnf\n\n    - name: Upload script if both files exist\n      ansible.builtin.copy:\n        src: \"{{ item }}\"\n        dest: \"/tmp/{{ item | basename }}\"\n        mode: '0755'\n      with_items: \"{{ files_to_upload }}\"\n      when: my_cnf.stat.exists and layershift_defaults_cnf.stat.exists\n\n    - name: Run the script if both files exist\n      when: my_cnf.stat.exists and layershift_defaults_cnf.stat.exists\n      ansible.builtin.shell: |\n        set -o pipefail\n        chmod 755 /tmp/remove_mysql_settings.sh\n        /tmp/remove_mysql_settings.sh\n      args:\n        executable: /bin/bash\n      changed_when: true\n","created":"2024-06-28T08:52:51.232855+01:00","updated":"2024-06-28T08:52:51.232875+01:00","path":"/home/ssh-gateway/ansible/projects/RM9615/RM9615-remove_duplicate_mysql_settings.yaml"}