On 2/14/20 2:10 PM, Anand Solomon wrote: > Thanks Rache, > This didn't solve the issue. I need to read the content in the "msg" in > "results" section >
What's the output when you run it in a loop as suggested?
Regards
Racke
>
>
> On Friday, February 14, 2020 at 7:52:31 AM UTC-5, Stefan Hornburg (Racke)
> wrote:
>
> On 2/14/20 1:31 PM, Anand Solomon wrote:
> > Thanks Vlado,
> > I am new to Ansible. I tried "query_result.results' etc. But no luck.
> Will really appreciate and also will learn
> at the
> > same time if you can help me crack the mystery.
> >
> > Thanks for all your help.
>
> Amand, you need to use the loop in the debug task as well:
>
> - name: Display the query results
> debug:
> msg: "{{query_result.msg}}
> loop: "{{ scripts|dict2items }}"
>
> Regards
> Racke
>
> >
> > On Thursday, February 13, 2020 at 5:08:12 PM UTC-5, Vladimir Botka
> wrote:
> >
> > On Thu, 13 Feb 2020 13:33:32 -0800 (PST)
> > Anand Solomon <[email protected] <javascript:>> wrote:
> >
> > > - name: Display the query results
> > > debug:
> > > msg: "{{query_result.msg}}
> > >
> > > I get the below
> > > "msg": "All items completed"
> > >
> > > I couldn't get the below, what ever I put in my debug statement.
> Is there
> > > is something I should do in order to get the below messages ?
> Thanks again
> > > for your help.
> > >
> > > "msg": [
> > > [
> > > "Revoke EXECUTE on UTL_FILE from TESTDBA;"
> > > ],
> > > [
> > > "Revoke EXECUTE on UTL_FILE from TSTSCH;"
> > > ]
> > > ]
> >
> > What you should do in order to get the above messages? Solve the
> mystery and
> > find out how you get the "msg" below. Perhaps?
> >
> >
> > > > > TASK [Display the query results]
> > > > >
> > > >
> ************************************************************************************************************
> > > >
> > > > > ok: "tstdb.fdst3sb9ngoi.us-east-1.rds.amazonaws.com
> <http://tstdb.fdst3sb9ngoi.us-east-1.rds.amazonaws.com>
> <http://tstdb.fdst3sb9ngoi.us-east-1.rds.amazonaws.com
> <http://tstdb.fdst3sb9ngoi.us-east-1.rds.amazonaws.com>>] => {
> > > > > "msg": {
> > > > > "ansible_loop_var": "item",
> > > > > "changed": false,
> > > > > "failed": false,
> > > > > "invocation": {
> > > > > "module_args": {
> > > > > "host":
> > > > > "tstdb.fdst3sb9ngoi.us-east-1.rds.amazonaws.com
> <http://tstdb.fdst3sb9ngoi.us-east-1.rds.amazonaws.com>
> <http://tstdb.fdst3sb9ngoi.us-east-1.rds.amazonaws.com
> <http://tstdb.fdst3sb9ngoi.us-east-1.rds.amazonaws.com>>",
> > > > > "hostname":
> > > > > "tstdb.fdst3sb9ngoi.us-east-1.rds.amazonaws.com
> <http://tstdb.fdst3sb9ngoi.us-east-1.rds.amazonaws.com>
> <http://tstdb.fdst3sb9ngoi.us-east-1.rds.amazonaws.com
> <http://tstdb.fdst3sb9ngoi.us-east-1.rds.amazonaws.com>>",
> > > > > "mode": "normal",
> > > > > "password":
> > > > "VALUE_SPECIFIED_IN_NO_LOG_PARAMETER",
> > > > > "port": "1521",
> > > > > "script": null,
> > > > > "service_name": "tstdb",
> > > > > "sql": "select 'Revoke ' || privilege
> || ' on
> > > > > UTL_FILE from ' || grantee || ';' from dba_tab_privs where
> > > > > table_name='UTL_FILE' and grantee not like 'APEX%' and
> grantee !=
> > > > 'CTXSYS'
> > > > > and grantee != 'DBSNMP' order by grantee;",
> > > > > "user": "SYSDBA",
> > > > > "username": "SYSDBA"
> > > > > }
> > > > > },
> > > > > "item": {
> > > > > "key": "Script1",
> > > > > "value": "select 'Revoke ' || privilege
> || ' on
> > > > > UTL_FILE from ' || grantee || ';' from dba_tab_privs where
> > > > > table_name='UTL_FILE' and grantee not like 'APEX%' and
> grantee !=
> > > > 'CTXSYS'
> > > > > and grantee != 'DBSNMP' and grantee != 'DMSYS' and grantee !=
> 'EXFSYS'
> > > > and
> > > > > grantee != 'MDSYS' order by grantee;"
> > > > > },
> > > > > "msg": [
> > > > > [
> > > > > "Revoke EXECUTE on UTL_FILE from
> TESTDBA;"
> > > > > ],
> > > > > [
> > > > > "Revoke EXECUTE on UTL_FILE from
> TSTSCH;"
> > > > > ]
> > > > > ]
> > > > > }
> > > > > ]
> > > > > }
> > > > > }
> > > > > -------------------------------------------------------
> > > > > I just want to get extract the below value and pass it on to
> my Jinja
> > > > > template.
> > > > >
> > > > > [
> > > > > "Revoke EXECUTE on UTL_FILE from
> TESTDBA;"
> > > > > ],
> > > > > [
> > > > > "Revoke EXECUTE on UTL_FILE from
> TSTSCH;"
> > > > > ]
> > > > >
> > > > > Here is my Jinja template
> > > > >
> > > > > - name: Generate Revoke Statement
> > > > > copy:
> > > > > dest:
> > > > /home/ansible/Playbooks/{{sname}}/sql/{{item.key}}_revoke.sql
> > > > > content: |
> > > > > spool
> /home/ansible/Playbooks/{{sname}}/log/{{item.key}}.log
> > > > > {% for line in query_result | flatten %}
> > > > > {{ line }}
> > > > > {% endfor %}
> > > > > spool off;
> > > > > delegate_to: localhost
> > > > > connection: local
> > > > > loop: "{{ scripts|dict2items }}"
> >
> > --
> > 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
> > [email protected] <javascript:>
> <mailto:[email protected] <javascript:>>.
> > To view this discussion on the web visit
> >
> https://groups.google.com/d/msgid/ansible-project/16c46f66-32bb-4719-97a6-b63fb4883f17%40googlegroups.com
>
> <https://groups.google.com/d/msgid/ansible-project/16c46f66-32bb-4719-97a6-b63fb4883f17%40googlegroups.com>
> >
>
> <https://groups.google.com/d/msgid/ansible-project/16c46f66-32bb-4719-97a6-b63fb4883f17%40googlegroups.com?utm_medium=email&utm_source=footer
>
> <https://groups.google.com/d/msgid/ansible-project/16c46f66-32bb-4719-97a6-b63fb4883f17%40googlegroups.com?utm_medium=email&utm_source=footer>>.
>
>
>
> --
> Ecommerce and Linux consulting + Perl and web application programming.
> Debian and Sympa administration. Provisioning with Ansible.
>
> --
> 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
> [email protected]
> <mailto:[email protected]>.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/ansible-project/e951706a-a6bd-44c9-9df5-7308bde5d65a%40googlegroups.com
> <https://groups.google.com/d/msgid/ansible-project/e951706a-a6bd-44c9-9df5-7308bde5d65a%40googlegroups.com?utm_medium=email&utm_source=footer>.
--
Ecommerce and Linux consulting + Perl and web application programming.
Debian and Sympa administration. Provisioning with Ansible.
--
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/ansible-project/675e04d3-5ac9-c764-3041-03a663732d3a%40linuxia.de.
signature.asc
Description: OpenPGP digital signature
