Re: [ansible-project] Ansible for RDS

[Dick Visser]

Hi

The error is pretty self explanatory.
You need to make sure you can connect to the RDS Oracle instance by SSH.

Check out https://docs.ansible.com/ansible/latest/user_guide/intro_getting_started.html#connecting-to-remote-nodes


On Thu, 6 Feb 2020 at 21:22, Anand Solomon <anand.v...@gmail.com> wrote:
>
> Hi,
> How to even run ansible commands to the RDS Oracle instance ? Is there a special parameter I should be passing ? . I have "connection; local" in the task. I tried to execute the playbook, I get the below error. Am i missing something ?
>
>
> Here is my playbook variable.
>
> vars:
> oracle_home: /home/ansible/instantclient_12_2
> user: ANTMSYSDBA
> prt: "1521"
> host: "dbname.ymst2nb7ngoi.us-east-1.rds.amazonaws.com"
> sname: lcktstdb
> oracle_env:
> ORACLE_HOME: "{{oracle_home}}"
> LD_LIBRARY_PATH: "{{oracle_home}}"
> PATH: "{{oracle_home}}"
>
>
> I am getting the below error
>
> TASK [Gathering Facts] *******************************************************************************************************************************
> fatal: [dbname.ymst2nb7ngoi.us-east-1.rds.amazonaws.com]: UNREACHABLE! => {"changed": false, "msg": "Failed to connect to the host via ssh: ssh_exchange_identification: Connection closed by remote host", "unreachable": true}
>
> PLAY RECAP *******************************************************************************************************************************************
> dbname.ymst2nb7ngoi.us-east-1.rds.amazonaws.com : ok=0 changed=0 unreachable=1 failed=0 skipped=0 rescued=0 ignored=0
>
> --
> You received this message because you are subscribed to the Google Groups "Ansible Project" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to ansible-proje...@googlegroups.com.
> To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/329a8e50-c98f-4fcb-bae0-5f5526be35f9%40googlegroups.com.



--
Dick Visser
Trust & Identity Service Operations Manager
GÉANT