Here is my entire playbook:
---
- name: "Play 1"
hosts: localhost
gather_facts: no
tasks:
- name: "Search database"
command: > mysql --user=root --password=p@ssword deployment
--host=localhost -Ns -e "SELECT dest_ip,file_dets,install_dir,layer
FROM deploy_dets"
register: command_result
- debug:
msg: "User was {{ item.split('\t')[3] }}"
with_items: "{{ command_result.stdout_lines }}"
- debug:
vars:
USER: "{{ 'user1' if item.split('\t')[3] == 'FrontEnd' else 'user2'
}}"
msg: "User is {{ USER }}"
with_items: "{{ command_result.stdout_lines }}"
On Wednesday, September 25, 2019 at 2:23:22 PM UTC+5:30, Stefan Hornburg
(Racke) wrote:
>
> On 9/25/19 10:44 AM, Mohtashim S wrote:
> > @Stefan here is the output
> >
>
> Sorry but there is no "Hello world" in the tasks you posted. Providing
> inaccurate information isn't helpful.
>
> Regards
> Racke
>
>
> > TASK [debug]
> >
> ************************************************************************************************************************************************
>
>
> > ok: [localhost] => (item=10.12.1.13 10.12.1.13\n-rw-rw-r-- user1
> 2019-09-13 15:39
> > /was//testingjsp/testingcom.jsp 1786385840 /was//testingjsp
> FrontEnd) => {
> > "msg": "User was FrontEnd"
> > }
> > ok: [localhost] => (item=10.12.1.13 10.12.1.13\n-rw-rw-r-- user2
> 2019-09-13 15:29 /fin/scripts/testingscr.scr
> > 367595418\n-rw-rw-r-- user2 2019-09-13 15:36 /fin/mrt/testingmrt.mrt
> 1251350031\n-rw-rw-r-- user2 2019-09-13 15:37
> > /fin/exe/testingexe.exe 1390265645\n-rw-rw-r-- user2 2019-09-13
> 15:38 /fin/com/testingcom.com 90193476
> > /fin/scripts\n/fin/mrt\n/fin/exe\n/fin/com BackEnd) => {
> > "msg": "User was BackEnd"
> > }
> > TASK [debug]
> >
> ************************************************************************************************************************************************
>
>
> > ok: [localhost] => (item=10.12.1.13 10.12.1.13\n-rw-rw-r-- user1
> 2019-09-13 15:39
> > /was//testingjsp/testingcom.jsp 1786385840 /was//testingjsp
> FrontEnd) => {
> > "msg": "Hello world!"
> > }
> > ok: [localhost] => (item=10.12.1.13 10.12.1.13\n-rw-rw-r-- user2
> 2019-09-13 15:29 /fin/scripts/testingscr.scr
> > 367595418\n-rw-rw-r-- user2 2019-09-13 15:36 /fin/mrt/testingmrt.mrt
> 1251350031\n-rw-rw-r-- user2 2019-09-13 15:37
> > /fin/exe/testingexe.exe 1390265645\n-rw-rw-r-- user2 2019-09-13
> 15:38 /fin/com/testingcom.com 90193476
> > /fin/scripts\n/fin/mrt\n/fin/exe\n/fin/com BackEnd) => {
> > "msg": "Hello world!"
> > }
> >
> >
> > On Wednesday, September 25, 2019 at 1:40:38 PM UTC+5:30, Stefan Hornburg
> (Racke) wrote:
> >
> > On 9/25/19 9:58 AM, Mohtashim S wrote:
> > > | - debug:
> > > msg: "User was {{ item.split('\t')[3] }}"
> > > with_items: "{{ command_result.stdout_lines }}"|
> > >
> > >
> > > The above give me the below output:
> > >
> > > "msg": "User was FrontEnd"
> > > "msg": "User was BackEnd"
> > >
> > >
> > > I now wish to set USER variable as user1 is returned value is
> FrontEnd else USER value should be user2.
> > >
> > > I dont know how to do this but below is my failing playbook.
> > >
> > > | - debug:
> > > vars:
> > > USER: "{{ 'user1' if item.split('\t')[3] == 'FrontEnd'
> else 'user2' }}"
> > > msg: "User is {{ USER }}"
> > >
> > > with_items: "{{ command_result.stdout_lines }}"|
> > >
> > >
> > > Expected output is:
> > >
> > > "msg": "User is user1"
> > > "msg": "User is user2"
> > >
> > >
> > >
> > > Can you please suggest ?
> > >
> >
> > Hello,
> >
> > what is the output that you actually get ... and please don't post
> the same question twice.
> >
> > Regards
> > Racke
> >
> > > --
> > > 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...@googlegroups.com <javascript:> <mailto:
> ansible-project+unsubscr...@googlegroups.com <javascript:>
> <javascript:>>.
> > > To view this discussion on the web visit
> > >
> https://groups.google.com/d/msgid/ansible-project/11286705-639c-43e2-8e0d-47080203cfc1%40googlegroups.com
>
> > <
> https://groups.google.com/d/msgid/ansible-project/11286705-639c-43e2-8e0d-47080203cfc1%40googlegroups.com>
>
>
> > >
> > <
> https://groups.google.com/d/msgid/ansible-project/11286705-639c-43e2-8e0d-47080203cfc1%40googlegroups.com?utm_medium=email&utm_source=footer
>
> > <
> https://groups.google.com/d/msgid/ansible-project/11286705-639c-43e2-8e0d-47080203cfc1%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
> > ansible...@googlegroups.com <javascript:> <mailto:
> ansible-project+unsubscr...@googlegroups.com <javascript:>>.
> > To view this discussion on the web visit
> >
> https://groups.google.com/d/msgid/ansible-project/d2354140-209e-4554-b057-95514e0ba08c%40googlegroups.com
>
> > <
> https://groups.google.com/d/msgid/ansible-project/d2354140-209e-4554-b057-95514e0ba08c%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 ansible-project+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/ansible-project/4a485c3d-6ffa-4e61-8e72-1549dfb091ae%40googlegroups.com.
