# Archives **URL:** https://forum.ansible.com/c/archives/31.md?page=231 [Latest](https://forum.ansible.com/latest.md) · [Categories](https://forum.ansible.com/categories.md) · [Tags](https://forum.ansible.com/tags.md) **Page:** 232 --- ## [Problem with Conditional variable](https://forum.ansible.com/t/problem-with-conditional-variable/32039)
**Author:** [@Yehuda\_Pinhas](https://forum.ansible.com/u/Yehuda_Pinhas)\ **Replies:** 5\ **Last updated:** [January 27, 2020, 9:22am UTC](https://forum.ansible.com/t/problem-with-conditional-variable/32039 "2020-01-27T09:22:20Z")
Hi! I want to make the variable qos\_policy set on conditional basis: If bandwidth\_mb == ‘50’ then qos\_policy == ‘qos-nested-50’ else qos\_policy == ‘qos-nested-new-50’ My code is this (not working): qos\_policy: “{{… --- ## [Basic beginner question](https://forum.ansible.com/t/basic-beginner-question/32061)
**Author:** [@Waqar\_Khan](https://forum.ansible.com/u/Waqar_Khan)\ **Replies:** 3\ **Last updated:** [January 26, 2020, 1:54pm UTC](https://forum.ansible.com/t/basic-beginner-question/32061 "2020-01-26T13:54:46Z")
Starting out with ansible and trying to configure sshd config. Here is what I have, it works but is there a better way to do with for future reference. e.g. if I have many different distributions it looks like a lot of c… --- ## [Running a select statement as script using oracle\_sql module](https://forum.ansible.com/t/running-a-select-statement-as-script-using-oracle-sql-module/32058)
**Author:** [@Anand\_Solomon](https://forum.ansible.com/u/Anand_Solomon)\ **Replies:** 2\ **Last updated:** [January 26, 2020, 2:37am UTC](https://forum.ansible.com/t/running-a-select-statement-as-script-using-oracle-sql-module/32058 "2020-01-26T02:37:05Z")
Hi, I am trying to run a sql script which has simple select statement. (select username from dba\_users). Will oracle\_sql module run a “Select” statement and returns the results ? My playbook is name: Script will crea… --- ## [Run excel VB or Macro?](https://forum.ansible.com/t/run-excel-vb-or-macro/32054)
**Author:** [@John\_Harmon](https://forum.ansible.com/u/John_Harmon)\ **Replies:** 1\ **Last updated:** [January 25, 2020, 10:56pm UTC](https://forum.ansible.com/t/run-excel-vb-or-macro/32054 "2020-01-25T22:56:41Z")
I am trying to automate a process. Is it possible, natively in Ansible, to run an Excel Macro, or Visual Basic code against an .csv? Thanks in advance. --- ## [Hostvars giving me undefined error](https://forum.ansible.com/t/hostvars-giving-me-undefined-error/32048)
**Author:** [@Rakesh\_Parida](https://forum.ansible.com/u/Rakesh_Parida)\ **Replies:** 7\ **Last updated:** [January 25, 2020, 10:25pm UTC](https://forum.ansible.com/t/hostvars-giving-me-undefined-error/32048 "2020-01-25T22:25:40Z")
Hi Iam trying to access the variable from other hosts using hostvars. I am getting the undefined error. Can anybody help me: stuck at this point hosts: yum gather\_facts: false vars: file\_locn: “/san/repos/{{ vers… --- ## [oracle\_sql module question](https://forum.ansible.com/t/oracle-sql-module-question/32060)
**Author:** [@Anand\_Solomon](https://forum.ansible.com/u/Anand_Solomon)\ **Replies:** 0\ **Last updated:** [January 25, 2020, 3:09pm UTC](https://forum.ansible.com/t/oracle-sql-module-question/32060 "2020-01-25T15:09:04Z")
Hi, I am trying to run a sql script which has simple select statement. (select username from dba\_users). Will oracle\_sql module run a “Select” statement and returns the results ? My playbook is name: Script will crea… --- ## [import\_playbook - Passing variables - error](https://forum.ansible.com/t/import-playbook-passing-variables-error/30406)
**Author:** [@Geoff](https://forum.ansible.com/u/Geoff)\ **Replies:** 2\ **Last updated:** [January 25, 2020, 2:58am UTC](https://forum.ansible.com/t/import-playbook-passing-variables-error/30406 "2020-01-25T02:58:12Z")
I have a playbook called: testing\_vars\_pass.yml It imports another playbook called: testing\_vars\_call.yml The playbook testing\_vars\_call.yml expects a variable called: myVar Below is the contents of each playbook … $… --- ## [How to Stop playbook execution based on a file ?](https://forum.ansible.com/t/how-to-stop-playbook-execution-based-on-a-file/32053)
**Author:** [@Anand\_Solomon](https://forum.ansible.com/u/Anand_Solomon)\ **Replies:** 1\ **Last updated:** [January 25, 2020, 2:06am UTC](https://forum.ansible.com/t/how-to-stop-playbook-execution-based-on-a-file/32053 "2020-01-25T02:06:11Z")
Hi, I basically wanted to skip the remaining of the playbook if a file exists name: Check if the file exists stat: path: /home/ansible/dbname/sql/file.sql register: optional\_file debug: msg: “File Exists” whe… --- ## [Need Help in Ansible regex](https://forum.ansible.com/t/need-help-in-ansible-regex/32046)
**Author:** [@Rakesh\_Parida](https://forum.ansible.com/u/Rakesh_Parida)\ **Replies:** 2\ **Last updated:** [January 25, 2020, 1:51am UTC](https://forum.ansible.com/t/need-help-in-ansible-regex/32046 "2020-01-25T01:51:31Z")
Hi all, I have a rpm whcich i have added in a list. I want to make it dynamic i.e when the version of rpm changes playbook should handle it. I have build a logic but the playbook skips the task where i have mentioned t… --- ## [What is the module to install drivers?](https://forum.ansible.com/t/what-is-the-module-to-install-drivers/32056)
**Author:** [@Work\_Email](https://forum.ansible.com/u/Work_Email)\ **Replies:** 2\ **Last updated:** [January 25, 2020, 12:35am UTC](https://forum.ansible.com/t/what-is-the-module-to-install-drivers/32056 "2020-01-25T00:35:43Z")
What is the module to install drivers ? it’s not working with win\_updates. --- ## [can someone please explain about "undefined" error](https://forum.ansible.com/t/can-someone-please-explain-about-undefined-error/32045)
**Author:** [@Work\_Email](https://forum.ansible.com/u/Work_Email)\ **Replies:** 3\ **Last updated:** [January 24, 2020, 11:01pm UTC](https://forum.ansible.com/t/can-someone-please-explain-about-undefined-error/32045 "2020-01-24T23:01:26Z")
Hello Guys, can someone please explain about “undefined” error Task name: reboot if required win\_reboot: when: update\_count.reboot\_required TASK \[reboot if required\] \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*… --- ## [How to skip the playbook based on a condition](https://forum.ansible.com/t/how-to-skip-the-playbook-based-on-a-condition/32052)
**Author:** [@Anand\_Solomon](https://forum.ansible.com/u/Anand_Solomon)\ **Replies:** 2\ **Last updated:** [January 24, 2020, 9:04pm UTC](https://forum.ansible.com/t/how-to-skip-the-playbook-based-on-a-condition/32052 "2020-01-24T21:04:43Z")
Hi, I basically wanted to skip the remaining of the playbook if a file exists name: Check if the file exists stat: path: /home/ansible/dbname/sql/file.sql register: optional\_file debug: msg: “File Exists” whe… --- ## [AWX 9.1.1 shows wrong page after successful SAML authentication](https://forum.ansible.com/t/awx-9-1-1-shows-wrong-page-after-successful-saml-authentication/32051)
**Author:** [@Norman](https://forum.ansible.com/u/Norman)\ **Replies:** 0\ **Last updated:** [January 24, 2020, 6:08pm UTC](https://forum.ansible.com/t/awx-9-1-1-shows-wrong-page-after-successful-saml-authentication/32051 "2020-01-24T18:08:36Z")
Hi community, the latest AWX 9.1.1 shows a strange behaviour whenever I try to access a certain AWX page via hyperlink (e.g. one specific workflow job id). After pressing the SAML button and successful authentication ag… --- ## [Unable to connect to Windows 2016 over HTTPS using self signed certificates; using ansible securely in a mixed active directory environment](https://forum.ansible.com/t/unable-to-connect-to-windows-2016-over-https-using-self-signed-certificates-using-ansible-securely-in-a-mixed-active-directory-environment/32050)
**Author:** [@Dan\_Hebert](https://forum.ansible.com/u/Dan_Hebert)\ **Replies:** 0\ **Last updated:** [January 24, 2020, 5:34pm UTC](https://forum.ansible.com/t/unable-to-connect-to-windows-2016-over-https-using-self-signed-certificates-using-ansible-securely-in-a-mixed-active-directory-environment/32050 "2020-01-24T17:34:36Z")
Good afternoon, I have been trying to get ansible working over a Windows 2016 HTTPS listener with encryption using TLS encryption and self-signed certificate authentication. User authentication over HTTP is not going t… --- ## [I have Ansible and Jenkins installed on Different Servers how can i configure both](https://forum.ansible.com/t/i-have-ansible-and-jenkins-installed-on-different-servers-how-can-i-configure-both/32035)
**Author:** [@Sai\_Prasha](https://forum.ansible.com/u/Sai_Prasha)\ **Replies:** 1\ **Last updated:** [January 24, 2020, 5:31pm UTC](https://forum.ansible.com/t/i-have-ansible-and-jenkins-installed-on-different-servers-how-can-i-configure-both/32035 "2020-01-24T17:31:30Z")
I have Ansible and Jenkins on Windows but on different servers how can i establish a connection between this two to trigger a playbook based on inventory files What is the inventory path to be given? My inventory file … --- ## [How to a activate ONOS apps by ansible-playbook?](https://forum.ansible.com/t/how-to-a-activate-onos-apps-by-ansible-playbook/32049)
**Author:** [@Ivy\_Min](https://forum.ansible.com/u/Ivy_Min)\ **Replies:** 0\ **Last updated:** [January 24, 2020, 4:51pm UTC](https://forum.ansible.com/t/how-to-a-activate-onos-apps-by-ansible-playbook/32049 "2020-01-24T16:51:37Z")
My ansible-playbook version is latest. I try to activate ONOS service in docker container by running ansible-playbook. I tried some ways. However they all failed. --- - hosts: local tasks: - name: Create a onos-a co… --- ## [Ansible collections: my new terminal plugin is not picked up while run](https://forum.ansible.com/t/ansible-collections-my-new-terminal-plugin-is-not-picked-up-while-run/32038)
**Author:** [@Mohamed\_Javeed](https://forum.ansible.com/u/Mohamed_Javeed)\ **Replies:** 2\ **Last updated:** [January 24, 2020, 4:49pm UTC](https://forum.ansible.com/t/ansible-collections-my-new-terminal-plugin-is-not-picked-up-while-run/32038 "2020-01-24T16:49:21Z")
To test my collections, i moved the dellos10 terminal plugin from the ansible installable. Attached my sample collections tar file My playbook: (attachments)dell\_networking-dellos10-1.0.0.tar.gz (2.34 KB) --- ## [Encrypted Password in Playbook](https://forum.ansible.com/t/encrypted-password-in-playbook/32016)
**Author:** [@Srinivas\_Naram](https://forum.ansible.com/u/Srinivas_Naram)\ **Replies:** 8\ **Last updated:** [January 24, 2020, 11:51am UTC](https://forum.ansible.com/t/encrypted-password-in-playbook/32016 "2020-01-24T11:51:39Z")
Hi All, I am trying to use Ansible vault encrypted password in my playbook and don’t see clear documentation on how to use it. Here is what I did so far - In ansible.cfg I have set the ‘vault\_password\_file’. I have a… --- ## [Help on using the wen condition](https://forum.ansible.com/t/help-on-using-the-wen-condition/32047)
**Author:** [@Daniel\_Nanboe](https://forum.ansible.com/u/Daniel_Nanboe)\ **Replies:** 0\ **Last updated:** [January 24, 2020, 11:21am UTC](https://forum.ansible.com/t/help-on-using-the-wen-condition/32047 "2020-01-24T11:21:35Z")
I have a list of users defined as variable on my inventory. I want to create a task that checks if for each user exists a file in a folder if it exists will run a task if not will run an other task. I have a task that a… --- ## [Printing only stdout\_lines with command + with\_items](https://forum.ansible.com/t/printing-only-stdout-lines-with-command-with-items/32043)
**Author:** [@Nicholas\_Yue](https://forum.ansible.com/u/Nicholas_Yue)\ **Replies:** 1\ **Last updated:** [January 24, 2020, 5:09am UTC](https://forum.ansible.com/t/printing-only-stdout-lines-with-command-with-items/32043 "2020-01-24T05:09:58Z")
Hi, I have the following ansible script $ cat generated-head-node.yaml hosts: all tasks: name: Run multiple commands command: “{{item}}” with\_items: pwd ls register: out debug: msg=“{{ item.stdout\_lines }}” with… --- ## [Playbook is unable to install specified KB number updates but shows OK in playbook recap](https://forum.ansible.com/t/playbook-is-unable-to-install-specified-kb-number-updates-but-shows-ok-in-playbook-recap/32041)
**Author:** [@Work\_Email](https://forum.ansible.com/u/Work_Email)\ **Replies:** 6\ **Last updated:** [January 24, 2020, 1:45am UTC](https://forum.ansible.com/t/playbook-is-unable-to-install-specified-kb-number-updates-but-shows-ok-in-playbook-recap/32041 "2020-01-24T01:45:51Z")
KB number upgrades/ security patches are not installing? Playbook tasks: name: Install all security, critical, and rollup updates without a scheduled task win\_updates: category\_names: Upgrades SecurityUpdates whit… --- ## [Playbook is stuck, is it bug ?](https://forum.ansible.com/t/playbook-is-stuck-is-it-bug/32044)
**Author:** [@Work\_Email](https://forum.ansible.com/u/Work_Email)\ **Replies:** 1\ **Last updated:** [January 24, 2020, 1:32am UTC](https://forum.ansible.com/t/playbook-is-stuck-is-it-bug/32044 "2020-01-24T01:32:32Z")
Hello guys, My playbook seems to be stuck for 5 mins for 1 server. Is it bug ? tasks: name: Search and download Windows updates without installing them win\_updates: category\_names: SecurityUpdates CriticalUpdates U… --- ## [Any updates on this, please help on my POST? https://groups.google.com/forum/#!topic/ansible-project/vVYN7qsRn7U](https://forum.ansible.com/t/any-updates-on-this-please-help-on-my-post-https-groups-google-com-forum-topic-ansible-project-vvyn7qsrn7u/32042)
**Author:** [@Work\_Email](https://forum.ansible.com/u/Work_Email)\ **Replies:** 1\ **Last updated:** [January 23, 2020, 8:25pm UTC](https://forum.ansible.com/t/any-updates-on-this-please-help-on-my-post-https-groups-google-com-forum-topic-ansible-project-vvyn7qsrn7u/32042 "2020-01-23T20:25:35Z")
Any updates on this, please help on my POST? https://groups.google.com/forum/#!topic/ansible-project/vVYN7qsRn7U --- ## [Filtering a complex list of dictionaries into another list of dictionaries in an efficient way](https://forum.ansible.com/t/filtering-a-complex-list-of-dictionaries-into-another-list-of-dictionaries-in-an-efficient-way/32029)
**Author:** [@actionmystique](https://forum.ansible.com/u/actionmystique)\ **Replies:** 4\ **Last updated:** [January 23, 2020, 7:42pm UTC](https://forum.ansible.com/t/filtering-a-complex-list-of-dictionaries-into-another-list-of-dictionaries-in-an-efficient-way/32029 "2020-01-23T19:42:31Z")
ansible 2.9.4 Let’s assume the following list of dictionaries: \` list: key1: ‘abc’ ‘def’ key2: ‘ghi’ key3: ‘jkl’ key1: ‘mno’ ‘pqr’ key3: ‘stu’ key4: ‘dfg’ key1: ‘vwx’ ‘yza’ key3: ‘okl’ key4: ‘azel’ \` The goa… --- ## [How to fix this ssh-keyscan problem in my playbook?](https://forum.ansible.com/t/how-to-fix-this-ssh-keyscan-problem-in-my-playbook/32033)
**Author:** [@RobertF](https://forum.ansible.com/u/RobertF)\ **Replies:** 2\ **Last updated:** [January 23, 2020, 7:32pm UTC](https://forum.ansible.com/t/how-to-fix-this-ssh-keyscan-problem-in-my-playbook/32033 "2020-01-23T19:32:40Z")
I have an Ansible playbook for provisioning servers. After the server is provisioned, I want to remove the old FQDN and/or hostname alias for that server from my local SSH known\_hosts file, pause until the server is up, … --- ## [Setting a fact using action\_plugin](https://forum.ansible.com/t/setting-a-fact-using-action-plugin/32040)
**Author:** [@Punit\_Jain](https://forum.ansible.com/u/Punit_Jain)\ **Replies:** 0\ **Last updated:** [January 23, 2020, 5:00pm UTC](https://forum.ansible.com/t/setting-a-fact-using-action-plugin/32040 "2020-01-23T17:00:53Z")
Hi, Is there a way to set fact using action\_plugin, than calling set\_fact? Here is my playbook: --- ## [turn on boto debugging in Ansible (~/.boto)](https://forum.ansible.com/t/turn-on-boto-debugging-in-ansible-boto/21562)
**Author:** [@cosbug](https://forum.ansible.com/u/cosbug)\ **Replies:** 2\ **Last updated:** [January 23, 2020, 12:52pm UTC](https://forum.ansible.com/t/turn-on-boto-debugging-in-ansible-boto/21562 "2020-01-23T12:52:44Z")
Hi All, Is there any way to turn on boto debugging for Ansible playbooks? In user home directory I created .boto file with contents: \[Boto\] debug = 2 But Ansible doesn’t pick it up though the python script which invo… --- ## [authorized\_key : How to put default value or bypass it](https://forum.ansible.com/t/authorized-key-how-to-put-default-value-or-bypass-it/32036)
**Author:** [@Hieronymus1](https://forum.ansible.com/u/Hieronymus1)\ **Replies:** 2\ **Last updated:** [January 23, 2020, 12:40pm UTC](https://forum.ansible.com/t/authorized-key-how-to-put-default-value-or-bypass-it/32036 "2020-01-23T12:40:12Z")
Hi I’m using the authorized\_key module in my ansible user role. As some user aren’t ssh key yet, I would like that by default this key is not created and the task escaped. I’ve seen that the key string is required by … --- ## [ignore -has no attribute](https://forum.ansible.com/t/ignore-has-no-attribute/32037)
**Author:** [@jegansignup](https://forum.ansible.com/u/jegansignup)\ **Replies:** 1\ **Last updated:** [January 23, 2020, 10:58am UTC](https://forum.ansible.com/t/ignore-has-no-attribute/32037 "2020-01-23T10:58:22Z")
Hello Team, I am parsing register value using debug and using when condition to print particular matching value. While doing that am getting below error. some of the register value doesn’t have “volume\_attachments” vari… --- ## [The List manipulation doesnt work](https://forum.ansible.com/t/the-list-manipulation-doesnt-work/32032)
**Author:** [@Rakesh\_Parida](https://forum.ansible.com/u/Rakesh_Parida)\ **Replies:** 2\ **Last updated:** [January 23, 2020, 8:16am UTC](https://forum.ansible.com/t/the-list-manipulation-doesnt-work/32032 "2020-01-23T08:16:48Z")
Hi Ansible Gurus, I have created a list and from that list i want to prepare some customise list as per my need. But when i execute my playbook i get at last step when i want to see my customised list i get an error . … [Previous page](https://forum.ansible.com/c/archives/31.md?page=230) [Next page](https://forum.ansible.com/c/archives/31.md?page=232)