# Latest **URL:** https://forum.ansible.com/latest.md?page=472 [Latest](https://forum.ansible.com/latest.md) · [Categories](https://forum.ansible.com/categories.md) · [Tags](https://forum.ansible.com/tags.md) **Page:** 473 --- ## [module mssql\_db in ansible](https://forum.ansible.com/t/module-mssql-db-in-ansible/29994)
**Author:** [@ryad9200000](https://forum.ansible.com/u/ryad9200000)\ **Replies:** 4\ **Last updated:** [March 27, 2019, 2:35pm UTC](https://forum.ansible.com/t/module-mssql-db-in-ansible/29994 "2019-03-27T14:35:54Z")
Hi all, I want know if module mssql\_db can only do “Add and remove MSSQL databases from a remote host” ? https://docs.ansible.com/ansible/latest/modules/mssql\_db\_module.html#examples If i want exemple show table with … --- ## [Need help with how to grab public ip and use it for later part in playbook](https://forum.ansible.com/t/need-help-with-how-to-grab-public-ip-and-use-it-for-later-part-in-playbook/29946)
**Author:** [@tinkuchowdary32](https://forum.ansible.com/u/tinkuchowdary32)\ **Replies:** 5\ **Last updated:** [March 27, 2019, 11:26am UTC](https://forum.ansible.com/t/need-help-with-how-to-grab-public-ip-and-use-it-for-later-part-in-playbook/29946 "2019-03-27T11:26:49Z")
here is the dubug output ec2-facts “ec2”: { “changed”: false, “failed”: false, “instances”: \[ { “ami\_launch\_index”: 0, “architecture”: “x86\_64”, “block\_device\_mappings”: \[ { “device\_name”: “/dev/xvda”, “ebs”: … --- ## [Launch instances from a file](https://forum.ansible.com/t/launch-instances-from-a-file/29989)
**Author:** [@shyam.rpms](https://forum.ansible.com/u/shyam.rpms)\ **Replies:** 3\ **Last updated:** [March 27, 2019, 5:58am UTC](https://forum.ansible.com/t/launch-instances-from-a-file/29989 "2019-03-27T05:58:26Z")
Hi, I want to launch instances from a file. The file contains the variables like “InstanceName”, HttpPortnumber and Portnumber and I want to pass this file as a Input parameter to the playbook to launch the instances on… --- ## [Ansible modules copy/template errors for Linux 5 hosts using python26 ,python binding libselinux-pyt](https://forum.ansible.com/t/ansible-modules-copy-template-errors-for-linux-5-hosts-using-python26-python-binding-libselinux-pyt/29990)
**Author:** [@iamlightsocialxen](https://forum.ansible.com/u/iamlightsocialxen)\ **Replies:** 2\ **Last updated:** [March 27, 2019, 1:48am UTC](https://forum.ansible.com/t/ansible-modules-copy-template-errors-for-linux-5-hosts-using-python26-python-binding-libselinux-pyt/29990 "2019-03-27T01:48:38Z")
Hello Ladies & Gentlemen, We have some 50 odd linux 5 hosts, and to manage that we use ansible. Problem :- Ansible modules copy/template errors for Linux 5 hosts using python26 ,python binding libselinux-python needed … --- ## [Files validation](https://forum.ansible.com/t/files-validation/29992)
**Author:** [@Karthik\_Sivakumar](https://forum.ansible.com/u/Karthik_Sivakumar)\ **Replies:** 1\ **Last updated:** [March 26, 2019, 9:18pm UTC](https://forum.ansible.com/t/files-validation/29992 "2019-03-26T21:18:49Z")
Hi While executing the main.yml file , the ansible controller validate the main.yml , it checks for all files in the path , if the files is present , it runs sucessfully. Eventhough we are creating the file at run time… --- ## [ansible using lambda module](https://forum.ansible.com/t/ansible-using-lambda-module/29979)
**Author:** [@qasim\_sahi](https://forum.ansible.com/u/qasim_sahi)\ **Replies:** 1\ **Last updated:** [March 26, 2019, 7:58pm UTC](https://forum.ansible.com/t/ansible-using-lambda-module/29979 "2019-03-26T19:58:38Z")
Hi, can someone please help in creating the playbook to stop/start EC2 instance using lambda ? --- ## [aws\_ec2 & constructed not working as per documentation?](https://forum.ansible.com/t/aws-ec2-constructed-not-working-as-per-documentation/29993)
**Author:** [@Derek\_Murawsky](https://forum.ansible.com/u/Derek_Murawsky)\ **Replies:** 1\ **Last updated:** [March 26, 2019, 6:57pm UTC](https://forum.ansible.com/t/aws-ec2-constructed-not-working-as-per-documentation/29993 "2019-03-26T18:57:21Z")
Hi All, I’m trying to create a dynamic group of hosts that are in the intersection of 3 other groups. From what I am reading, I see that the new aws\_ec2 and constructed inventory plugins should be able to do what I want… --- ## [debug statement not working](https://forum.ansible.com/t/debug-statement-not-working/29962)
**Author:** [@Jerry\_Seven](https://forum.ansible.com/u/Jerry_Seven)\ **Replies:** 6\ **Last updated:** [March 26, 2019, 3:30pm UTC](https://forum.ansible.com/t/debug-statement-not-working/29962 "2019-03-26T15:30:52Z")
I cant figure out why --- ## [Ansible and SQL Server ?](https://forum.ansible.com/t/ansible-and-sql-server/29991)
**Author:** [@ryad9200000](https://forum.ansible.com/u/ryad9200000)\ **Replies:** 2\ **Last updated:** [March 26, 2019, 1:44pm UTC](https://forum.ansible.com/t/ansible-and-sql-server/29991 "2019-03-26T13:44:55Z")
Hi all, I want know if Ansible can execut commands SQL for Microsoft SQL Server ? I think that possible with command powershell but what is syntax ansible ? for exemple, i want create table on my SQL Server (CREATE DA… --- ## [Host related problem](https://forum.ansible.com/t/host-related-problem/29987)
**Author:** [@skdmeng](https://forum.ansible.com/u/skdmeng)\ **Replies:** 3\ **Last updated:** [March 26, 2019, 3:44am UTC](https://forum.ansible.com/t/host-related-problem/29987 "2019-03-26T03:44:25Z")
Hello, I just starte to use ansible, now there is a question ， when during the batch execution of the playbook, some operations are performed only on one of the hosts. How do you avoid other hosts on a piaybook while pe… --- ## [ec2\_instance vs ec2 - which one to use & and is there a plan?](https://forum.ansible.com/t/ec2-instance-vs-ec2-which-one-to-use-and-is-there-a-plan/29976)
**Author:** [@Dick\_Visser](https://forum.ansible.com/u/Dick_Visser)\ **Replies:** 1\ **Last updated:** [March 26, 2019, 3:07am UTC](https://forum.ansible.com/t/ec2-instance-vs-ec2-which-one-to-use-and-is-there-a-plan/29976 "2019-03-26T03:07:24Z")
Hi While trying to debug some issues (notably trying to add several security groups to an EC2 instance), I once again ran into the question about which ansible module to use to for EC2 instances. From the docs it appea… --- ## [Random anisble failures due to tmp files not found](https://forum.ansible.com/t/random-anisble-failures-due-to-tmp-files-not-found/29835)
**Author:** [@igorc](https://forum.ansible.com/u/igorc)\ **Replies:** 3\ **Last updated:** [March 26, 2019, 12:51am UTC](https://forum.ansible.com/t/random-anisble-failures-due-to-tmp-files-not-found/29835 "2019-03-26T00:51:13Z")
Anyone else seeing random playbook execution failuers like this: \` Source /home/user/.ansible/tmp/ansible-tmp-1551917585.84-139567381415844/source not found"} \` Any idea what is causing them and how to fix it? Thank… --- ## [ansible using lambda module](https://forum.ansible.com/t/ansible-using-lambda-module/29978)
**Author:** [@qasim\_sahi](https://forum.ansible.com/u/qasim_sahi)\ **Replies:** 1\ **Last updated:** [March 25, 2019, 10:59pm UTC](https://forum.ansible.com/t/ansible-using-lambda-module/29978 "2019-03-25T22:59:43Z")
Hi, can someone please help in creating the playbook to stop/start EC2 instance using lambda ? --- ## [aws\_s3 module fails, says Boto3 is missing when it is not - bug?](https://forum.ansible.com/t/aws-s3-module-fails-says-boto3-is-missing-when-it-is-not-bug/29963)
**Author:** [@gigit1000](https://forum.ansible.com/u/gigit1000)\ **Replies:** 3\ **Last updated:** [March 25, 2019, 9:36pm UTC](https://forum.ansible.com/t/aws-s3-module-fails-says-boto3-is-missing-when-it-is-not-bug/29963 "2019-03-25T21:36:00Z")
This Play installs python3, pip3, boto3 and botocore, and trys to use aws\_s3 module to download a file: TASK \[run yum update -y using yum module\] \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*… --- ## [Ansible upgrade](https://forum.ansible.com/t/ansible-upgrade/29986)
**Author:** [@Sindhuja\_Koneru](https://forum.ansible.com/u/Sindhuja_Koneru)\ **Replies:** 1\ **Last updated:** [March 25, 2019, 9:32pm UTC](https://forum.ansible.com/t/ansible-upgrade/29986 "2019-03-25T21:32:22Z")
Hello, Can some one pls answer following 2 questions.? Trying to upgrade Tower from 3.2.5 to 3.4.2. Installation fails with error Preflight check — require new enough ansible Msg:: “ your current version of Ansible … --- ## [Display specific lines from cisco output](https://forum.ansible.com/t/display-specific-lines-from-cisco-output/29972)
**Author:** [@Raheel\_Khilji](https://forum.ansible.com/u/Raheel_Khilji)\ **Replies:** 3\ **Last updated:** [March 25, 2019, 9:03pm UTC](https://forum.ansible.com/t/display-specific-lines-from-cisco-output/29972 "2019-03-25T21:03:02Z")
I have a situation my script is hosts: Branch gather\_facts: false connection: local tasks: name: Facts ios\_command: commands: show inter gi0/0 register: output debug: msg: “{{ output.stdout\_lines }}” T… --- ## [DEFAULT\_REMOTE\_TMP not working](https://forum.ansible.com/t/default-remote-tmp-not-working/29952)
**Author:** [@syed.qasim.sarfraz](https://forum.ansible.com/u/syed.qasim.sarfraz)\ **Replies:** 1\ **Last updated:** [March 25, 2019, 8:10pm UTC](https://forum.ansible.com/t/default-remote-tmp-not-working/29952 "2019-03-25T20:10:51Z")
Hi, I want to fetch the custom controller remote directory and create it if required, I used the remote\_tmp in my ansible.cfg to set a custom value. Previously I was using DEFAULT\_REMOTE\_TMP to get the custom value but… --- ## [Changing the network and ip of th virtual machine after creation using vmware\_guest module](https://forum.ansible.com/t/changing-the-network-and-ip-of-th-virtual-machine-after-creation-using-vmware-guest-module/29982)
**Author:** [@Sahar](https://forum.ansible.com/u/Sahar)\ **Replies:** 0\ **Last updated:** [March 25, 2019, 7:20pm UTC](https://forum.ansible.com/t/changing-the-network-and-ip-of-th-virtual-machine-after-creation-using-vmware-guest-module/29982 "2019-03-25T19:20:23Z")
Hi, I’m trying to change the network and ip/netmask of a vm after creation in vmware using the below playbook: vmware\_guest: hostname: ‘{{ }}’ username: ‘{{ }}’ password: ‘{{ }}’ validate\_certs: no datacenter: ‘{… --- ## [Certificate invalid error while accessing the Ansible Tower URL from a Windows Server - internet explorer](https://forum.ansible.com/t/certificate-invalid-error-while-accessing-the-ansible-tower-url-from-a-windows-server-internet-explorer/29977)
**Author:** [@Muthu\_R\_D](https://forum.ansible.com/u/Muthu_R_D)\ **Replies:** 3\ **Last updated:** [March 25, 2019, 6:38pm UTC](https://forum.ansible.com/t/certificate-invalid-error-while-accessing-the-ansible-tower-url-from-a-windows-server-internet-explorer/29977 "2019-03-25T18:38:12Z")
Certificate invalid error while accessing the Ansible Tower URL from a Windows Server - internet explorer. Ansible Tower own support edition installed on RHEL 7.3. Trying to access the Tower Server URL from a windows m… --- ## [K8s module with Custom Resource Definition always changed](https://forum.ansible.com/t/k8s-module-with-custom-resource-definition-always-changed/29969)
**Author:** [@Thms\_Hmm](https://forum.ansible.com/u/Thms_Hmm)\ **Replies:** 2\ **Last updated:** [March 25, 2019, 6:09pm UTC](https://forum.ansible.com/t/k8s-module-with-custom-resource-definition-always-changed/29969 "2019-03-25T18:09:20Z")
Hi, when I use the k8s module to patch a CRD object the task is always marked as “changed: true” even if there are no changes to the object. ok: \[localhost\] =\> { "msg": { "changed": true, "diff": \[ \[ "change", "metadat… --- ## [String concatenation whith stdout under with\_items](https://forum.ansible.com/t/string-concatenation-whith-stdout-under-with-items/29981)
**Author:** [@Vino\_B](https://forum.ansible.com/u/Vino_B)\ **Replies:** 0\ **Last updated:** [March 25, 2019, 6:06pm UTC](https://forum.ansible.com/t/string-concatenation-whith-stdout-under-with-items/29981 "2019-03-25T18:06:19Z")
Hi All, Request your help with string concatenation whith stdout under with\_items. name: \_List Name shell: (sysls -l) register: sys\_list ignore\_errors: true name: check System Type shell: (systype -t {{item.s}… --- ## [loop using only the top items in a data structure.](https://forum.ansible.com/t/loop-using-only-the-top-items-in-a-data-structure/29975)
**Author:** [@Steve\_Button](https://forum.ansible.com/u/Steve_Button)\ **Replies:** 1\ **Last updated:** [March 25, 2019, 5:58pm UTC](https://forum.ansible.com/t/loop-using-only-the-top-items-in-a-data-structure/29975 "2019-03-25T17:58:13Z")
Hi, Bit of a confusing one, and perhaps I’m barking up the wrong tree (which is why I’ve turned here after some research) . I’m trying to create a bunch of kubernetes namespaces using a template, have got that working … --- ## [Root prefix for AWX](https://forum.ansible.com/t/root-prefix-for-awx/29973)
**Author:** [@ahmed](https://forum.ansible.com/u/ahmed)\ **Replies:** 2\ **Last updated:** [March 25, 2019, 1:49pm UTC](https://forum.ansible.com/t/root-prefix-for-awx/29973 "2019-03-25T13:49:23Z")
Hi, I’m wondering if it is possible to configure a root prefix for all requests received by AWX. Example : Instead of https://@IP/#/home, AWX serves https://@IP/app/#/home Thank you. --- ## [Ansible inventory organization](https://forum.ansible.com/t/ansible-inventory-organization/29974)
**Author:** [@Sascha\_Andres](https://forum.ansible.com/u/Sascha_Andres)\ **Replies:** 5\ **Last updated:** [March 25, 2019, 12:52pm UTC](https://forum.ansible.com/t/ansible-inventory-organization/29974 "2019-03-25T12:52:40Z")
Hi, I have servers that are organized into environment (such as staging, production, test, etc.) and into function (www, db, etc) My idea was to have a group ‘production’ with a list of servers, and a group www with a … --- ## [Ansible synchronize database sql](https://forum.ansible.com/t/ansible-synchronize-database-sql/29955)
**Author:** [@ryad9200000](https://forum.ansible.com/u/ryad9200000)\ **Replies:** 3\ **Last updated:** [March 25, 2019, 8:30am UTC](https://forum.ansible.com/t/ansible-synchronize-database-sql/29955 "2019-03-25T08:30:25Z")
Hi all, " Data synchronization can be resumed by right-clicking on the database and choosing “Resume data movement …”. " I want know if in ansible its possible to realize the same thing as on the image. That is to … --- ## [This topic needs a title](https://forum.ansible.com/t/this-topic-needs-a-title/29967)
**Author:** [@The\_Vandyy\_Vines](https://forum.ansible.com/u/The_Vandyy_Vines)\ **Replies:** 2\ **Last updated:** [March 25, 2019, 6:06am UTC](https://forum.ansible.com/t/this-topic-needs-a-title/29967 "2019-03-25T06:06:39Z")
Hello , I have standalone AWX version 1.0.6 installed manually. If left for few days without any tasks running i can see tat the jobs are going in pending . Even after AWX services restarts it fails. As a work around… --- ## [Unable to negotiate with 10.192.1.5 port 22: no matching cipher found. Their offer: aes128-cbc,3des-cbc,aes192-cbc,aes256-cbc](https://forum.ansible.com/t/unable-to-negotiate-with-10-192-1-5-port-22-no-matching-cipher-found-their-offer-aes128-cbc-3des-cbc-aes192-cbc-aes256-cbc/29949)
**Author:** [@Hitesh\_Kumar](https://forum.ansible.com/u/Hitesh_Kumar)\ **Replies:** 3\ **Last updated:** [March 25, 2019, 5:17am UTC](https://forum.ansible.com/t/unable-to-negotiate-with-10-192-1-5-port-22-no-matching-cipher-found-their-offer-aes128-cbc-3des-cbc-aes192-cbc-aes256-cbc/29949 "2019-03-25T05:17:43Z")
I am trying to connect switches in my network using ansible play book, but not able to connect it to my network switches When I am running a command: hiteshkumar@INPNBXXX:/mnt/c/Users/hitesh.kumar$ sudo ansible-playboo… --- ## [Installing Office 2016 through Ansible?](https://forum.ansible.com/t/installing-office-2016-through-ansible/29964)
**Author:** [@Tuyen\_Nguyen](https://forum.ansible.com/u/Tuyen_Nguyen)\ **Replies:** 3\ **Last updated:** [March 25, 2019, 3:54am UTC](https://forum.ansible.com/t/installing-office-2016-through-ansible/29964 "2019-03-25T03:54:38Z")
Hi I created a playbook to install Office 2016 which I think should work. I had it run setup.exe /adminfile \ – the unattended.msp file I created by running setup.exe /setup and setting it to install… --- ## [replace module regexp with newline character](https://forum.ansible.com/t/replace-module-regexp-with-newline-character/29940)
**Author:** [@John\_Harmon](https://forum.ansible.com/u/John_Harmon)\ **Replies:** 13\ **Last updated:** [March 24, 2019, 8:35pm UTC](https://forum.ansible.com/t/replace-module-regexp-with-newline-character/29940 "2019-03-24T20:35:06Z")
I need to use replace to find a regexp that includes \\n; however, I keep getting an error. How can I properly do this (don’t even know if I am using back reference correct either, but if I can get past this error I think… --- ## [dpkg\_divert module](https://forum.ansible.com/t/dpkg-divert-module/29968)
**Author:** [@Klaus\_Ethgen](https://forum.ansible.com/u/Klaus_Ethgen)\ **Replies:** 0\ **Last updated:** [March 24, 2019, 6:39pm UTC](https://forum.ansible.com/t/dpkg-divert-module/29968 "2019-03-24T18:39:31Z")
Hi folks, as debian needs more and more diversions from there idea of where files should be, I created a dpkg\_divert module to address that from ansible. I'd like to give that to other ansible folks but I am not sure … [Previous page](https://forum.ansible.com/latest.md?page=471) [Next page](https://forum.ansible.com/latest.md?page=473)