Playbook #86
/home/ssh-gateway/ansible/projects/RM9380/fetch_csv.yaml
Execution
Date 03 Apr 2024 08:24:54 +0100
Duration 00:00:04.14
Controller ssh-gw-4.layershift.com
User root
Versions
Ansible 2.16.4
ara 1.7.1 / 1.7.2.dev2
Python 3.10.10
Summary
2 Hosts
3 Tasks
3 Results
1 Plays
1 Files
0 Records
remote_user:root check:False tags:all

File: /home/ssh-gateway/ansible/projects/RM9380/fetch_csv.yaml

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
---
- name: Playbook to run mysqlquery on infra4 and fetch the results
  hosts: all
  gather_facts: false
  vars:
    proj_folder: /home/ssh-gateway/ansible/projects/RM9380/
  tasks:
    - name: Delete the inventory file first
      ansible.builtin.file:
        state: absent
        path: "{{ proj_folder }}/RM9380-inventory-source-file"
        force: true
      delegate_to: 127.0.0.1
    - name: Run the script
      ansible.builtin.shell: |
        set -o pipefail
        echo "U0VMRUNUCmRzdG9zLm5hbWUgQVMgZHN0bm9kZW5hbWUsClJFR0VYUF9TVUJTVFIoZHN0b3MubmFtZSwgJ1swLTldKycpIEFTIGRzdG5vZGVuYW1lX2N0aWQsCmRzdGhuLmhvc3RuYW1lIEFTIGRzdGhubmFtZSwKZmlsZV9wZXJtaXNzaW9ucy5maWxlcGF0aCBhcyBzb3VyY2VwYXRoLApmaWxlX3Blcm1pc3Npb25zLnNyY3BhdGggYXMgbmZzc2VydmVycGF0aCwKZmlsZV9wZXJtaXNzaW9ucy5zcmNIb3N0IGFzIHN0b3JhZ2VBZGRyZXNzLApmaWxlX3Blcm1pc3Npb25zLnN0b3JhZ2VfaWQgQVMgc3RvcmFnZW5vZGVfaWQsCm9zX25vZGUuaWQgYXMgc3RvcmFnZV9jdGlkLApoYXJkX25vZGUuaG9zdG5hbWUgQVMgaGFyZG5vZGUsCmFwcF9ub2Rlcy51aWQgQVMgdWlkLApgdXNlcmAuZW1haWwgQVMgdXNlcmVtYWlsLApDT05DQVQoZmlsZV9wZXJtaXNzaW9ucy5maWxlcGF0aCwgIi0iLCBmaWxlX3Blcm1pc3Npb25zLnNyY3BhdGgpIEFTIHRlbXBEYXRhCkZST00KaGl2ZXh0X2plbGFzdGljLmZpbGVfcGVybWlzc2lvbnMKSU5ORVIgSk9JTiBoaXZleHRfamVsYXN0aWMuc29mdF9ub2RlIE9OIHNvZnRfbm9kZS5pZCA9IGZpbGVfcGVybWlzc2lvbnMuc3RvcmFnZV9pZApJTk5FUiBKT0lOIGhpdmV4dF9qZWxhc3RpYy5vc19ub2RlIE9OIG9zX25vZGUuaWQgPSBzb2Z0X25vZGUub3NOb2RlX2lkCklOTkVSIEpPSU4gaGl2ZXh0X2plbGFzdGljLmhhcmRfbm9kZSBPTiBvc19ub2RlLmhhcmROb2RlX2lkID0gaGFyZF9ub2RlLmlkCklOTkVSIEpPSU4gaGl2ZXh0X2plbGFzdGljLmFwcF9ub2RlcyBPTiBzb2Z0X25vZGUuZW52X2lkID0gYXBwX25vZGVzLmlkCklOTkVSIEpPSU4gaGl2ZXh0X3VzZXJzLmB1c2VyYCBPTiBgdXNlcmAuaWQgPSBhcHBfbm9kZXMudWlkCklOTkVSIEpPSU4gaGl2ZXh0X2plbGFzdGljLnNvZnRfbm9kZSBkc3Rzb2Z0IE9OIGZpbGVfcGVybWlzc2lvbnMuc29mdE5vZGVfaWQgPSBkc3Rzb2Z0LmlkCklOTkVSIEpPSU4gaGl2ZXh0X2plbGFzdGljLm9zX25vZGUgZHN0b3MgT04gZHN0c29mdC5vc05vZGVfaWQgPSBkc3Rvcy5pZApJTk5FUiBKT0lOIGhpdmV4dF9qZWxhc3RpYy5oYXJkX25vZGUgZHN0aG4gT04gZHN0b3MuaGFyZE5vZGVfaWQgPSBkc3Robi5pZApXSEVSRQpzdG9yYWdlX2lkIElTIE5PVCBOVUxMCkFORCBhcHBfbm9kZXMuaXNEZWxldGVkID0gMApBTkQgb3Nfbm9kZS5pc0RlbGV0ZWQgPSAwCg==" | base64 -d > /vz/root/301/tmp/query
        echo "IyEvYmluL2Jhc2gKbXlzcWwgLXVsYXllcnNoaWZ0IC1wJ2dXZFJEYlVHbE5qVkVveHdsYXp0JyAtZSAiJChjYXQgL3RtcC9xdWVyeSkiIC1OcyB8IHRyICdcdCcgJywnID4gL3RtcC9STTkzODAtZmlsZS5jc3YK" | base64 -d > /vz/root/301/tmp/make_csv.sh
        vzctl exec 301 'bash /tmp/make_csv.sh'
        rm -f /vz/root/301/tmp/make_csv.sh /vz/root/301/tmp/query
      args:
        executable: /bin/bash
      changed_when: false
    - name: Fetch the file
      ansible.builtin.fetch:
        dest: "{{ proj_folder }}/RM9380-inventory-source-file"
        src: /vz/root/301/tmp/RM9380-file.csv
        flat: true
        force: true