# Archives **URL:** https://forum.ansible.com/c/archives/31.md?page=114 [Latest](https://forum.ansible.com/latest.md) · [Categories](https://forum.ansible.com/categories.md) · [Tags](https://forum.ansible.com/tags.md) **Page:** 115 --- ## [How run t-sql commands on Azure SQL databases](https://forum.ansible.com/t/how-run-t-sql-commands-on-azure-sql-databases/35531)
**Author:** [@Grant\_Sutcliffe](https://forum.ansible.com/u/Grant_Sutcliffe)\ **Replies:** 0\ **Last updated:** [July 21, 2021, 7:34am UTC](https://forum.ansible.com/t/how-run-t-sql-commands-on-azure-sql-databases/35531 "2021-07-21T07:34:02Z")
We need to run a series of T-SQL statements (to create database objects and inert data) on an Azure SQL databases (not Managed Instance database flavour). We successfully tested that we can and run the sql commands from… --- ## [how to pass the variable holding the value to regex\_search for matching the output?](https://forum.ansible.com/t/how-to-pass-the-variable-holding-the-value-to-regex-search-for-matching-the-output/35525)
**Author:** [@Charles\_Daniel](https://forum.ansible.com/u/Charles_Daniel)\ **Replies:** 1\ **Last updated:** [July 21, 2021, 7:29am UTC](https://forum.ansible.com/t/how-to-pass-the-variable-holding-the-value-to-regex-search-for-matching-the-output/35525 "2021-07-21T07:29:16Z")
Team, I would like to pass the variable holding value to regex to match the output. prim\_b2b\_ip is the variable which i need to use inside the regex search for matching whether the return output comes as expected or no… --- ## [Skipping plugin (filenam.py) as it seems to be invalid: The 'cryptography' distribution was not found and is required by ansible](https://forum.ansible.com/t/skipping-plugin-filenam-py-as-it-seems-to-be-invalid-the-cryptography-distribution-was-not-found-and-is-required-by-ansible/35529)
**Author:** [@Dick\_Visser](https://forum.ansible.com/u/Dick_Visser)\ **Replies:** 0\ **Last updated:** [July 21, 2021, 6:17am UTC](https://forum.ansible.com/t/skipping-plugin-filenam-py-as-it-seems-to-be-invalid-the-cryptography-distribution-was-not-found-and-is-required-by-ansible/35529 "2021-07-21T06:17:50Z")
There is very little tangible information in your message. The error however still looks pretty clear to me. Try installing the cryptography package (pip install cryptography). I’m guessing that this will cause your f… --- ## [Looking for ideas - AWX High Availability and performance improvement](https://forum.ansible.com/t/looking-for-ideas-awx-high-availability-and-performance-improvement/35528)
**Author:** [@Svetoslav](https://forum.ansible.com/u/Svetoslav)\ **Replies:** 0\ **Last updated:** [July 21, 2021, 5:14am UTC](https://forum.ansible.com/t/looking-for-ideas-awx-high-availability-and-performance-improvement/35528 "2021-07-21T05:14:34Z")
Hi Colleagues, Is there any information - procedures, manuals etc. about High Availability implementations of AWX ? Is it possible to install more, than one AWX instance, which work with one PostgreSQL database. How the… --- ## [How to answer to prompt in configuration mode Cisco switch](https://forum.ansible.com/t/how-to-answer-to-prompt-in-configuration-mode-cisco-switch/35488)
**Author:** [@mana\_maghrebi](https://forum.ansible.com/u/mana_maghrebi)\ **Replies:** 2\ **Last updated:** [July 21, 2021, 1:00am UTC](https://forum.ansible.com/t/how-to-answer-to-prompt-in-configuration-mode-cisco-switch/35488 "2021-07-21T01:00:21Z")
Hi all, I want to configure Radius do1x in 2960 cisco switch with ansible. As soon as I run command aaa accounting identity default start-stop group, a prompt pops up saying: This operation will permanently convert all … --- ## [Ansible-4.3.0 has been released](https://forum.ansible.com/t/ansible-4-3-0-has-been-released/35527)
**Author:** [@tkuratom](https://forum.ansible.com/u/tkuratom)\ **Replies:** 0\ **Last updated:** [July 20, 2021, 9:43pm UTC](https://forum.ansible.com/t/ansible-4-3-0-has-been-released/35527 "2021-07-20T21:43:24Z")
Hi all, We're happy to announce that the ansible-4.3.0 package has been released! The update contains bugfixes and new, backwards compatible features in the contained collections. How to get it --- ## [Ansible for Dasan](https://forum.ansible.com/t/ansible-for-dasan/35526)
**Author:** [@Cameron1](https://forum.ansible.com/u/Cameron1)\ **Replies:** 0\ **Last updated:** [July 20, 2021, 2:10pm UTC](https://forum.ansible.com/t/ansible-for-dasan/35526 "2021-07-20T14:10:27Z")
Hi Team, Does anyone know whether Ansible supports Dasan Networks OLT’s or vice versa? It’s OS is similar to that of Cisco and Arista, but playbooks that run on those don’t typically work the same on the OLT, in partic… --- ## [lineinfile is skipped if one of the task ignored](https://forum.ansible.com/t/lineinfile-is-skipped-if-one-of-the-task-ignored/35517)
**Author:** [@Hanumantha\_Reddy\_Bas](https://forum.ansible.com/u/Hanumantha_Reddy_Bas)\ **Replies:** 1\ **Last updated:** [July 20, 2021, 5:16am UTC](https://forum.ansible.com/t/lineinfile-is-skipped-if-one-of-the-task-ignored/35517 "2021-07-20T05:16:45Z")
Hi All, I have a playbook as follows: --- ## [how to get values from dict in template with for loop ?](https://forum.ansible.com/t/how-to-get-values-from-dict-in-template-with-for-loop/35524)
**Author:** [@Eric\_Chang](https://forum.ansible.com/u/Eric_Chang)\ **Replies:** 0\ **Last updated:** [July 20, 2021, 3:03am UTC](https://forum.ansible.com/t/how-to-get-values-from-dict-in-template-with-for-loop/35524 "2021-07-20T03:03:41Z")
I have two dict file like teams.yml { “teams”: \[{“gid”: 10125,“location”: \[“hq”\],“name”: “aa”,“users”: \[“chenhu”,“chouf”\]}, {“gid”: 10126,“location”: \[“hq”\],“name”: “ac”,“users”: \[“guoj”,“yangc”\]} \] } users.yml { … --- ## [New releases: ansible-core 2.11.3, ansible-base 2.10.12, ansible 2.9.24](https://forum.ansible.com/t/new-releases-ansible-core-2-11-3-ansible-base-2-10-12-ansible-2-9-24/35523)
**Author:** [@relrod](https://forum.ansible.com/u/relrod)\ **Replies:** 0\ **Last updated:** [July 20, 2021, 3:03am UTC](https://forum.ansible.com/t/new-releases-ansible-core-2-11-3-ansible-base-2-10-12-ansible-2-9-24/35523 "2021-07-20T03:03:38Z")
Hi all- we're happy to announce the general release of: - ansible-core 2.11.3 - ansible-base 2.10.12 - ansible 2.9.24 How to get it --- ## [Stouck in Ansible](https://forum.ansible.com/t/stouck-in-ansible/35516)
**Author:** [@Abdul\_Waheed\_Khan](https://forum.ansible.com/u/Abdul_Waheed_Khan)\ **Replies:** 2\ **Last updated:** [July 20, 2021, 2:52am UTC](https://forum.ansible.com/t/stouck-in-ansible/35516 "2021-07-20T02:52:49Z")
Hi everyone, i am new in this forum . i am configuring ansible (tyk-ansible) but stuck in . please help me. Regards, Abdul waheed --- ## [list all files in directory and copy all content.](https://forum.ansible.com/t/list-all-files-in-directory-and-copy-all-content/35522)
**Author:** [@Vincent\_Nambatac](https://forum.ansible.com/u/Vincent_Nambatac)\ **Replies:** 1\ **Last updated:** [July 20, 2021, 1:49am UTC](https://forum.ansible.com/t/list-all-files-in-directory-and-copy-all-content/35522 "2021-07-20T01:49:06Z")
Hi there , I want to ask what approach I will do If I want to copy all content in an unzip files. I unzip the files and list all directories. the problem is I want to copy all files inside the directory but only 1 conten… --- ## [question about tags](https://forum.ansible.com/t/question-about-tags/35521)
**Author:** [@jcpetro](https://forum.ansible.com/u/jcpetro)\ **Replies:** 3\ **Last updated:** [July 19, 2021, 7:59pm UTC](https://forum.ansible.com/t/question-about-tags/35521 "2021-07-19T19:59:21Z")
I have a bit of a problem, and was wondering if anyone has ever done something like this. I have a playbook I am working on, where it updates firewalld rules for some kubernetes clusters we have. Rather than have a playb… --- ## [Ansible play freezes and never completes after copying part of the files using synchronize module](https://forum.ansible.com/t/ansible-play-freezes-and-never-completes-after-copying-part-of-the-files-using-synchronize-module/35519)
**Author:** [@Easy\_King](https://forum.ansible.com/u/Easy_King)\ **Replies:** 0\ **Last updated:** [July 19, 2021, 1:49pm UTC](https://forum.ansible.com/t/ansible-play-freezes-and-never-completes-after-copying-part-of-the-files-using-synchronize-module/35519 "2021-07-19T13:49:45Z")
Below is my playbook that helps transfer a set of files from remote source to local directory. name: “Play 1.5” hosts: “{{ groups\[‘dest\_nodes’\] | default(groups\[‘all’\]) }}” serial: 1 gather\_facts: false vars: ansi… --- ## [Upload var\_files based on a value or ignore if not exist](https://forum.ansible.com/t/upload-var-files-based-on-a-value-or-ignore-if-not-exist/35515)
**Author:** [@dudu.c](https://forum.ansible.com/u/dudu.c)\ **Replies:** 1\ **Last updated:** [July 18, 2021, 7:36pm UTC](https://forum.ansible.com/t/upload-var-files-based-on-a-value-or-ignore-if-not-exist/35515 "2021-07-18T19:36:36Z")
hosts: server1 vars\_files: main.yml second.yml Hi, I have a a small playbook that is using variables based on a file. Main.yml the file will always exist while second.yml might exist. Is it possible to configure … --- ## [Parse a dynamic json response](https://forum.ansible.com/t/parse-a-dynamic-json-response/35514)
**Author:** [@Stephane\_Cremel](https://forum.ansible.com/u/Stephane_Cremel)\ **Replies:** 0\ **Last updated:** [July 16, 2021, 2:00pm UTC](https://forum.ansible.com/t/parse-a-dynamic-json-response/35514 "2021-07-16T14:00:00Z")
I work on role for administrate an elastic cluster. When i execute this : name: Get Statistic of index uri: url: “{{ update\_index }}” method: GET body: “” body\_format: json register: result\_stats when: index\_ … --- ## [After 23 attempts, failed to spawn pexpect session](https://forum.ansible.com/t/after-23-attempts-failed-to-spawn-pexpect-session/35513)
**Author:** [@Suneel\_Hegde](https://forum.ansible.com/u/Suneel_Hegde)\ **Replies:** 0\ **Last updated:** [July 16, 2021, 12:42pm UTC](https://forum.ansible.com/t/after-23-attempts-failed-to-spawn-pexpect-session/35513 "2021-07-16T12:42:37Z")
ello All, we are trying to copy NXOS image using ansible getting this error when we ran the playbook form the AWX anyone please help what is causing this issuefatal: \[switch\]: FAILED! =\> { “msg”: “After 23 attempts, … --- ## [To display the logs other than secret codes in a task](https://forum.ansible.com/t/to-display-the-logs-other-than-secret-codes-in-a-task/35512)
**Author:** [@Aneesh](https://forum.ansible.com/u/Aneesh)\ **Replies:** 1\ **Last updated:** [July 16, 2021, 8:14am UTC](https://forum.ansible.com/t/to-display-the-logs-other-than-secret-codes-in-a-task/35512 "2021-07-16T08:14:34Z")
Hi I am using vault for database passwords and used for the execution of database tasks, With no\_log, the messages are getting censored. But if in case of any error from MySQL /database also not visible because of this … --- ## [Executing powershell script via ansible playbook is not working properly](https://forum.ansible.com/t/executing-powershell-script-via-ansible-playbook-is-not-working-properly/35502)
**Author:** [@Deepan\_M](https://forum.ansible.com/u/Deepan_M)\ **Replies:** 1\ **Last updated:** [July 16, 2021, 3:59am UTC](https://forum.ansible.com/t/executing-powershell-script-via-ansible-playbook-is-not-working-properly/35502 "2021-07-16T03:59:48Z")
Hi, I’m trying to execute powershell script via ansible, however playbook is successfully running but its incomplete. same script if I run directely on windows server its perfectly working, its failing whenever i ran th… --- ## [After 23 attempts, failed to spawn pexpect session error](https://forum.ansible.com/t/after-23-attempts-failed-to-spawn-pexpect-session-error/35511)
**Author:** [@Suneel\_Hegde](https://forum.ansible.com/u/Suneel_Hegde)\ **Replies:** 0\ **Last updated:** [July 16, 2021, 3:49am UTC](https://forum.ansible.com/t/after-23-attempts-failed-to-spawn-pexpect-session-error/35511 "2021-07-16T03:49:50Z")
Hello Team, we are trying to copy NXOS image using ansible getting this error when we ran the playbook form the AWX anyone please help what is causing this issuefatal: \[switch\]: FAILED! =\> { “msg”: “After 23 attempts… --- ## [Ansible - Authentication timeout error](https://forum.ansible.com/t/ansible-authentication-timeout-error/35510)
**Author:** [@benilde\_tadonkeng](https://forum.ansible.com/u/benilde_tadonkeng)\ **Replies:** 0\ **Last updated:** [July 15, 2021, 10:59pm UTC](https://forum.ansible.com/t/ansible-authentication-timeout-error/35510 "2021-07-15T22:59:49Z")
Hi every one, I’m trying to pull out some information from a cisco switch device using ios\_facts module, for exemple ios version using ansible. By running the playbook, the following message appears: PLAY \[Host(s) nam… --- ## [Ansible winrm Read timed out when running win\_update - intermittent](https://forum.ansible.com/t/ansible-winrm-read-timed-out-when-running-win-update-intermittent/35509)
**Author:** [@Robert\_Rozek](https://forum.ansible.com/u/Robert_Rozek)\ **Replies:** 0\ **Last updated:** [July 15, 2021, 9:11pm UTC](https://forum.ansible.com/t/ansible-winrm-read-timed-out-when-running-win-update-intermittent/35509 "2021-07-15T21:11:52Z")
Hello, I have this intermittent issue where, when Windows Server servers are patching or rebooting I would get WinRM -Read Timed out. This is occruing intermittently so I cannot freely replicate it. Normally this would… --- ## [Need help with communication issue from Jenkins](https://forum.ansible.com/t/need-help-with-communication-issue-from-jenkins/35197)
**Author:** [@Richard\_Lund](https://forum.ansible.com/u/Richard_Lund)\ **Replies:** 10\ **Last updated:** [July 15, 2021, 8:41pm UTC](https://forum.ansible.com/t/need-help-with-communication-issue-from-jenkins/35197 "2021-07-15T20:41:15Z")
Hi. I’m hoping someone here can give me advice on how to troubleshoot this, maybe point me at logs that I haven’t found yet or settings that produce more debugging information, or whatever. TLDR: During AWX jobs that t… --- ## [Ansible Contributor Summit 2021.06](https://forum.ansible.com/t/ansible-contributor-summit-2021-06/35134)
**Author:** [@cybette](https://forum.ansible.com/u/cybette)\ **Replies:** 1\ **Last updated:** [July 15, 2021, 12:06pm UTC](https://forum.ansible.com/t/ansible-contributor-summit-2021-06/35134 "2021-07-15T12:06:02Z")
Hi everyone, We’re happy to announce the second Ansible Contributor Summit for 2021! It will be on Tuesday, June 8, from 07:00-15:00 UTC, and will be held online. For those unfamiliar with this event, the Ansible Co… --- ## [How to set become pass for become\_method: su?](https://forum.ansible.com/t/how-to-set-become-pass-for-become-method-su/35508)
**Author:** [@Joey\_Cheng](https://forum.ansible.com/u/Joey_Cheng)\ **Replies:** 0\ **Last updated:** [July 14, 2021, 5:46pm UTC](https://forum.ansible.com/t/how-to-set-become-pass-for-become-method-su/35508 "2021-07-14T17:46:18Z")
Hello folks, I was using --ask-become-pass and it worked fine. But now I’m going to run multiple playbooks at one time so I’m going to include become pass in plaintext for each group. I tried “ansible\_become\_pass” in in… --- ## [AWX - Configure LDAP for multiple groups](https://forum.ansible.com/t/awx-configure-ldap-for-multiple-groups/35507)
**Author:** [@hieronymus](https://forum.ansible.com/u/hieronymus)\ **Replies:** 0\ **Last updated:** [July 14, 2021, 3:00pm UTC](https://forum.ansible.com/t/awx-configure-ldap-for-multiple-groups/35507 "2021-07-14T15:00:46Z")
Hi everyone, I’m configuring LDAP Setting for accessing the AWX WebUI. I need to configure two LDAP Group Search but apparently it is not possible : group search does not support LDAPSearchUnion. So, we’re two teams w… --- ## [How can i multi factor authentication for login..?](https://forum.ansible.com/t/how-can-i-multi-factor-authentication-for-login/35478)
**Author:** [@kelly](https://forum.ansible.com/u/kelly)\ **Replies:** 2\ **Last updated:** [July 14, 2021, 12:10pm UTC](https://forum.ansible.com/t/how-can-i-multi-factor-authentication-for-login/35478 "2021-07-14T12:10:41Z")
I want to use multi factor authentication for login. like… use OTP after ldap login. The login I’m talking about is login of awx web page. is it possible ?? Help me --- ## [Failed to change ownership of the temporary files Ansible needs to create despite connecting as a privileged user](https://forum.ansible.com/t/failed-to-change-ownership-of-the-temporary-files-ansible-needs-to-create-despite-connecting-as-a-privileged-user/35506)
**Author:** [@apex\_legend](https://forum.ansible.com/u/apex_legend)\ **Replies:** 0\ **Last updated:** [July 14, 2021, 7:18am UTC](https://forum.ansible.com/t/failed-to-change-ownership-of-the-temporary-files-ansible-needs-to-create-despite-connecting-as-a-privileged-user/35506 "2021-07-14T07:18:23Z")
I am new to awx i use pre-exsisting playbook when i run it from ubuntu 20 terminal it works fine but i want to run it through awx when i run it from awx i get this error. Failed to change ownership of the temporary file… --- ## [New release candidates: ansible-core 2.11.3rc1, ansible-base 2.10.12rc1, ansible 2.9.24rc1](https://forum.ansible.com/t/new-release-candidates-ansible-core-2-11-3rc1-ansible-base-2-10-12rc1-ansible-2-9-24rc1/35505)
**Author:** [@relrod](https://forum.ansible.com/u/relrod)\ **Replies:** 0\ **Last updated:** [July 14, 2021, 6:24am UTC](https://forum.ansible.com/t/new-release-candidates-ansible-core-2-11-3rc1-ansible-base-2-10-12rc1-ansible-2-9-24rc1/35505 "2021-07-14T06:24:17Z")
Hi all- we're happy to announce the following release candidates: - ansible-core 2.11.3rc1 - ansible-base 2.10.12rc1 - ansible 2.9.24rc1 ...which were released Monday night (US time). How to get it --- ## [FRR in a Docker container: socket\_path must be a value](https://forum.ansible.com/t/frr-in-a-docker-container-socket-path-must-be-a-value/35504)
**Author:** [@Saqib\_Ilyas](https://forum.ansible.com/u/Saqib_Ilyas)\ **Replies:** 0\ **Last updated:** [July 13, 2021, 6:38pm UTC](https://forum.ansible.com/t/frr-in-a-docker-container-socket-path-must-be-a-value/35504 "2021-07-13T18:38:30Z")
Hi I used containerlab to set up a small topology with a few FRR routers running as Docker containers. Accordingly, I set ansible\_connection: Docker. However, when I run the following playbook: name: testing facts ho… [Previous page](https://forum.ansible.com/c/archives/31.md?page=113) [Next page](https://forum.ansible.com/c/archives/31.md?page=115)