Ansible delegate to another host

Archives Ansible Project
1

Hi everyone,

I would appreciate if you could please look at my issue below and provide your suggestions -

GOAL - Identify if the data in lower environment is scrambled.

Steps -

  1. Identify all lower environment and form sql query of random records to run in PROD
  2. Dynamically identify the prod server IP address
  3. Run the sql query from lower environment task on PROD server

Steps 1 and 2 are working fine, but in the playbook if I use “delegate_to” with prod server ip (identified as part of step 2), it fails.

Query : In my scenario, If I use delegate_to option, does that mean its the UAT server ( and not the Ansible server) trying to connect to PROD?

Please suggest an alternative approach. Let me know if you need more details.

Thanks
Amit

2

Hi everyone,

I would appreciate if you could please look at my issue below and provide your suggestions -

GOAL - Identify if the data in lower environment is scrambled.

Steps -
1. Identify all lower environment and form sql query of random records to run in PROD
2. Dynamically identify the prod server IP address
3. Run the sql query from lower environment task on PROD server

Steps 1 and 2 are working fine, but in the playbook if I use "delegate_to" with prod server ip (identified as part of
step 2), it fails.

Query : In my scenario, If I use delegate_to option, does that mean its the UAT server ( and not the Ansible server)
trying to connect to PROD?

The Ansible controller connects to the host in delegate_to:.

Please suggest an alternative approach. Let me know if you need more details.

Well obviously the task you are running and the error message.

Regards
         Racke

3

Make sure the host is in your inventory, or try add_host to get it there.

V/r,
James Cassell