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

Task result details

  • Status
    OK
  • Duration
    00:00:01.74
  • Play
    Playbook to run mysqlquery on infra4 and fetch the results
  • Task
    Run the script
  • Host
    infra_vz1

Field Value
ansible_facts 
{
    "discovered_interpreter_python": "/usr/bin/python"
}
changed 
False
cmd 
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
delta 
0:00:00.052266
end 
2024-04-03 07:24:56.853219
invocation 
{
    "module_args": {
        "_raw_params": "set -o pipefail\necho \"U0VMRUNUCmRzdG9zLm5hbWUgQVMgZHN0bm9kZW5hbWUsClJFR0VYUF9TVUJTVFIoZHN0b3MubmFtZSwgJ1swLTldKycpIEFTIGRzdG5vZGVuYW1lX2N0aWQsCmRzdGhuLmhvc3RuYW1lIEFTIGRzdGhubmFtZSwKZmlsZV9wZXJtaXNzaW9ucy5maWxlcGF0aCBhcyBzb3VyY2VwYXRoLApmaWxlX3Blcm1pc3Npb25zLnNyY3BhdGggYXMgbmZzc2VydmVycGF0aCwKZmlsZV9wZXJtaXNzaW9ucy5zcmNIb3N0IGFzIHN0b3JhZ2VBZGRyZXNzLApmaWxlX3Blcm1pc3Npb25zLnN0b3JhZ2VfaWQgQVMgc3RvcmFnZW5vZGVfaWQsCm9zX25vZGUuaWQgYXMgc3RvcmFnZV9jdGlkLApoYXJkX25vZGUuaG9zdG5hbWUgQVMgaGFyZG5vZGUsCmFwcF9ub2Rlcy51aWQgQVMgdWlkLApgdXNlcmAuZW1haWwgQVMgdXNlcmVtYWlsLApDT05DQVQoZmlsZV9wZXJtaXNzaW9ucy5maWxlcGF0aCwgIi0iLCBmaWxlX3Blcm1pc3Npb25zLnNyY3BhdGgpIEFTIHRlbXBEYXRhCkZST00KaGl2ZXh0X2plbGFzdGljLmZpbGVfcGVybWlzc2lvbnMKSU5ORVIgSk9JTiBoaXZleHRfamVsYXN0aWMuc29mdF9ub2RlIE9OIHNvZnRfbm9kZS5pZCA9IGZpbGVfcGVybWlzc2lvbnMuc3RvcmFnZV9pZApJTk5FUiBKT0lOIGhpdmV4dF9qZWxhc3RpYy5vc19ub2RlIE9OIG9zX25vZGUuaWQgPSBzb2Z0X25vZGUub3NOb2RlX2lkCklOTkVSIEpPSU4gaGl2ZXh0X2plbGFzdGljLmhhcmRfbm9kZSBPTiBvc19ub2RlLmhhcmROb2RlX2lkID0gaGFyZF9ub2RlLmlkCklOTkVSIEpPSU4gaGl2ZXh0X2plbGFzdGljLmFwcF9ub2RlcyBPTiBzb2Z0X25vZGUuZW52X2lkID0gYXBwX25vZGVzLmlkCklOTkVSIEpPSU4gaGl2ZXh0X3VzZXJzLmB1c2VyYCBPTiBgdXNlcmAuaWQgPSBhcHBfbm9kZXMudWlkCklOTkVSIEpPSU4gaGl2ZXh0X2plbGFzdGljLnNvZnRfbm9kZSBkc3Rzb2Z0IE9OIGZpbGVfcGVybWlzc2lvbnMuc29mdE5vZGVfaWQgPSBkc3Rzb2Z0LmlkCklOTkVSIEpPSU4gaGl2ZXh0X2plbGFzdGljLm9zX25vZGUgZHN0b3MgT04gZHN0c29mdC5vc05vZGVfaWQgPSBkc3Rvcy5pZApJTk5FUiBKT0lOIGhpdmV4dF9qZWxhc3RpYy5oYXJkX25vZGUgZHN0aG4gT04gZHN0b3MuaGFyZE5vZGVfaWQgPSBkc3Robi5pZApXSEVSRQpzdG9yYWdlX2lkIElTIE5PVCBOVUxMCkFORCBhcHBfbm9kZXMuaXNEZWxldGVkID0gMApBTkQgb3Nfbm9kZS5pc0RlbGV0ZWQgPSAwCg==\" | base64 -d > /vz/root/301/tmp/query\necho \"IyEvYmluL2Jhc2gKbXlzcWwgLXVsYXllcnNoaWZ0IC1wJ2dXZFJEYlVHbE5qVkVveHdsYXp0JyAtZSAiJChjYXQgL3RtcC9xdWVyeSkiIC1OcyB8IHRyICdcdCcgJywnID4gL3RtcC9STTkzODAtZmlsZS5jc3YK\" | base64 -d > /vz/root/301/tmp/make_csv.sh\nvzctl exec 301 'bash /tmp/make_csv.sh'\nrm -f /vz/root/301/tmp/make_csv.sh /vz/root/301/tmp/query\n",
        "_uses_shell": true,
        "argv": null,
        "chdir": null,
        "creates": null,
        "executable": "/bin/bash",
        "expand_argument_vars": true,
        "removes": null,
        "stdin": null,
        "stdin_add_newline": true,
        "strip_empty_ends": true
    }
}
msg
rc 
0
start 
2024-04-03 07:24:56.800953
stderr
stderr_lines 
[]
stdout
stdout_lines 
[]