# Archives **URL:** https://forum.ansible.com/c/archives/31.md?page=595 [Latest](https://forum.ansible.com/latest.md) · [Categories](https://forum.ansible.com/categories.md) · [Tags](https://forum.ansible.com/tags.md) **Page:** 596 --- ## [storing Ansible facts in mysql database](https://forum.ansible.com/t/storing-ansible-facts-in-mysql-database/21329)
**Author:** [@Anil\_Dasmala](https://forum.ansible.com/u/Anil_Dasmala)\ **Replies:** 4\ **Last updated:** [May 3, 2016, 9:58am UTC](https://forum.ansible.com/t/storing-ansible-facts-in-mysql-database/21329 "2016-05-03T09:58:26Z")
Hi Guys, Can someone guide me on how to store the facts for all hosts in inventory into a mysql database. In other words, output data of setup module to mysql. Appreciate ideas/suggestions. –Anil --- ## [Multiple vars in with\_nested problem](https://forum.ansible.com/t/multiple-vars-in-with-nested-problem/21333)
**Author:** [@system](https://forum.ansible.com/u/system)\ **Replies:** 2\ **Last updated:** [May 3, 2016, 8:28am UTC](https://forum.ansible.com/t/multiple-vars-in-with-nested-problem/21333 "2016-05-03T08:28:44Z")
Hi, I'm trying out (Ansible 2.0.2.0 on Fedora 23). The snippet below is also on http://pastie.org/10821272 Goal: expand task #3 below so it installs for existing users all the files listed in the variable mc\_templates. … --- ## [why the playbook does not run as many times as there are entries in the hosts file ?](https://forum.ansible.com/t/why-the-playbook-does-not-run-as-many-times-as-there-are-entries-in-the-hosts-file/21328)
**Author:** [@fanvalt](https://forum.ansible.com/u/fanvalt)\ **Replies:** 4\ **Last updated:** [May 3, 2016, 7:40am UTC](https://forum.ansible.com/t/why-the-playbook-does-not-run-as-many-times-as-there-are-entries-in-the-hosts-file/21328 "2016-05-03T07:40:56Z")
Hello, I did param 2 entries in my hosts file: \[server\] localhost ansible\_connection=local ansible\_user=fvaltat PARAM=“\[‘tomweb’, ‘’, ‘Y’,‘1’\]” localhost ansible\_connection=local ansible\_user=fvaltat PARAM=“\[‘openhr’… --- ## [No config file found; using defaults](https://forum.ansible.com/t/no-config-file-found-using-defaults/21231)
**Author:** [@Jonathan\_Anderson](https://forum.ansible.com/u/Jonathan_Anderson)\ **Replies:** 1\ **Last updated:** [May 3, 2016, 6:31am UTC](https://forum.ansible.com/t/no-config-file-found-using-defaults/21231 "2016-05-03T06:31:15Z")
Centos 7 Ansible 2.1 Windows 7 on remote node My inventory file (/etc/ansible/hosts) contains \[windows\] ADS-6999 ansible\_host=123.123.123.123 I have configured my windows.yml file as follows ansible\_user: Administ… --- ## [custom facts with non-root account](https://forum.ansible.com/t/custom-facts-with-non-root-account/21193)
**Author:** [@Uwe\_Bartels](https://forum.ansible.com/u/Uwe_Bartels)\ **Replies:** 2\ **Last updated:** [May 3, 2016, 6:27am UTC](https://forum.ansible.com/t/custom-facts-with-non-root-account/21193 "2016-05-03T06:27:52Z")
Hiho, I’m currently working with most recent ansible in a very restricted system environment, e.g. I don’t have root access. now I’m gathering data via shell commands and register. E.g. name: check for java installa… --- ## [Ansible command to get the ethtool information](https://forum.ansible.com/t/ansible-command-to-get-the-ethtool-information/21211)
**Author:** [@Jai\_Reddy](https://forum.ansible.com/u/Jai_Reddy)\ **Replies:** 3\ **Last updated:** [May 3, 2016, 5:28am UTC](https://forum.ansible.com/t/ansible-command-to-get-the-ethtool-information/21211 "2016-05-03T05:28:01Z")
Greetings, I am trying to get the nic (eth0) info using ansible … When I am running below ansible command I am getting error ansible all -m shell -a “/sbin/ethtool eth0” SSH password: SUDO password\[defaults to SSH p… --- ## [Escalation Prompt Timeout?](https://forum.ansible.com/t/escalation-prompt-timeout/21277)
**Author:** [@Tennis\_Smith](https://forum.ansible.com/u/Tennis_Smith)\ **Replies:** 1\ **Last updated:** [May 3, 2016, 5:23am UTC](https://forum.ansible.com/t/escalation-prompt-timeout/21277 "2016-05-03T05:23:04Z")
Hi, I’m getting “Timeout (12s) waiting for privilege escalation prompt” errors. Can the escalation timeout value be changed somewhere? Thanks, -T --- ## [map extract not working?](https://forum.ansible.com/t/map-extract-not-working/21272)
**Author:** [@Arthur\_Tsang](https://forum.ansible.com/u/Arthur_Tsang)\ **Replies:** 1\ **Last updated:** [May 3, 2016, 5:20am UTC](https://forum.ansible.com/t/map-extract-not-working/21272 "2016-05-03T05:20:36Z")
Hi all, I have a group named cluster in my inventory file, which has 2 nodes, swarm1 & swarm2. and the following playbook, trying to use map(‘extract’) to get the IP address of the other node. I can print out the ip ju… --- ## [Understanding group vars](https://forum.ansible.com/t/understanding-group-vars/21302)
**Author:** [@Shua\_Talansky](https://forum.ansible.com/u/Shua_Talansky)\ **Replies:** 1\ **Last updated:** [May 3, 2016, 5:11am UTC](https://forum.ansible.com/t/understanding-group-vars/21302 "2016-05-03T05:11:20Z")
Based on these docs http://docs.ansible.com/ansible/playbooks\_best\_practices.html#group-and-host-variables I would think this should work. I have a yml file with db: host: 123.45.6.7 pass: secret etc… I put one in s… --- ## [help with Jinja2 for loops using keys value](https://forum.ansible.com/t/help-with-jinja2-for-loops-using-keys-value/21292)
**Author:** [@Eric\_Marquez](https://forum.ansible.com/u/Eric_Marquez)\ **Replies:** 1\ **Last updated:** [May 3, 2016, 5:06am UTC](https://forum.ansible.com/t/help-with-jinja2-for-loops-using-keys-value/21292 "2016-05-03T05:06:43Z")
Hello, I’m looking for some guidance on what’s the best way to setup my jinja2 .j2 template so I can generate my VLAN’s correctly in a template. I would like to setup my host\_vars file like the following: bmc.yml https… --- ## [mysql\_user doesen't translate variables](https://forum.ansible.com/t/mysql-user-doesent-translate-variables/21294)
**Author:** [@Florian\_Luttgens](https://forum.ansible.com/u/Florian_Luttgens)\ **Replies:** 1\ **Last updated:** [May 3, 2016, 4:57am UTC](https://forum.ansible.com/t/mysql-user-doesent-translate-variables/21294 "2016-05-03T04:57:19Z")
Hi, im trying to add a mysql user, but it seems the mysql\_user module does not translate the variables. It works on mysql\_db tho. Output: \` \<178.250..\> REMOTE\_MODULE mysql\_user name={{ item.value.projekt | lower }}{{… --- ## [When condition](https://forum.ansible.com/t/when-condition/21312)
**Author:** [@Suresh\_Uppu](https://forum.ansible.com/u/Suresh_Uppu)\ **Replies:** 1\ **Last updated:** [May 3, 2016, 4:52am UTC](https://forum.ansible.com/t/when-condition/21312 "2016-05-03T04:52:50Z")
Hi, This is Suresh. I am new to Ansible. I have a query, Can I please ask any one to clarify this. I am using when: condition. The below one is working fine. file copy is working fine based on distribution. didnt ge… --- ## [dictionary key as variable](https://forum.ansible.com/t/dictionary-key-as-variable/21311)
**Author:** [@Serkan\_C](https://forum.ansible.com/u/Serkan_C)\ **Replies:** 3\ **Last updated:** [May 3, 2016, 4:44am UTC](https://forum.ansible.com/t/dictionary-key-as-variable/21311 "2016-05-03T04:44:48Z")
Hi, I’m developing a generic tomcat role, it gets version number as variable; … roles: { role: tomcat, version: “8.0.33” } I’ve mentioned download urls for some major versions at vars.yml … file: “8”: “…apache-t… --- ## [Ansible Autoscaling with Tower and AWS blog post, instances are NOT authorized by server](https://forum.ansible.com/t/ansible-autoscaling-with-tower-and-aws-blog-post-instances-are-not-authorized-by-server/21336)
**Author:** [@ecoutin\_boingo](https://forum.ansible.com/u/ecoutin_boingo)\ **Replies:** 2\ **Last updated:** [May 3, 2016, 3:19am UTC](https://forum.ansible.com/t/ansible-autoscaling-with-tower-and-aws-blog-post-instances-are-not-authorized-by-server/21336 "2016-05-03T03:19:11Z")
Hello, So I followed this post: https://www.ansible.com/blog/autoscaling-infrastructures And managed to deploy the infrastructure, the problem is the callback isn’t working. I keep getting no available hosts: curl -k… --- ## [Using Ansible.cfg with roles and tasks](https://forum.ansible.com/t/using-ansible-cfg-with-roles-and-tasks/21323)
**Author:** [@Rick\_O\_Shea](https://forum.ansible.com/u/Rick_O_Shea)\ **Replies:** 1\ **Last updated:** [May 2, 2016, 10:17pm UTC](https://forum.ansible.com/t/using-ansible-cfg-with-roles-and-tasks/21323 "2016-05-02T22:17:40Z")
I have roles that depend on the ssh\_args settings of the local Ansible.cfg, and they succeed. I also have a role that assumes different ssh\_args values, and it fails. How do we specify Ansible.cfg settings specific to … --- ## [Not Working As Expected: main.yml - include something.yml tags=something](https://forum.ansible.com/t/not-working-as-expected-main-yml-include-something-yml-tags-something/21331)
**Author:** [@Jacob1](https://forum.ansible.com/u/Jacob1)\ **Replies:** 1\ **Last updated:** [May 2, 2016, 9:06pm UTC](https://forum.ansible.com/t/not-working-as-expected-main-yml-include-something-yml-tags-something/21331 "2016-05-02T21:06:02Z")
Hello, I’m writing a new playbook and executing it using ansible 2.1.0. It appears the tags I define in main.yml on an include line are being ignored. By comparison, this works as expected in ansible 1.9.2 Example: ro… --- ## [ansible ne récupére pas les tout les variables d'environnement de la machine distante](https://forum.ansible.com/t/ansible-ne-recupere-pas-les-tout-les-variables-denvironnement-de-la-machine-distante/21327)
**Author:** [@toshywoshy](https://forum.ansible.com/u/toshywoshy)\ **Replies:** 0\ **Last updated:** [May 2, 2016, 9:25am UTC](https://forum.ansible.com/t/ansible-ne-recupere-pas-les-tout-les-variables-denvironnement-de-la-machine-distante/21327 "2016-05-02T09:25:35Z")
Je pense que le module 'shell' ne peut pas utiliser des pipes/outputs, il utilise le python outputs (http://docs.ansible.com/ansible/shell\_module.html#return-values) pour ça vous devez utilizer le module 'raw' Votre act… --- ## [Query Regarding when condition](https://forum.ansible.com/t/query-regarding-when-condition/21314)
**Author:** [@Suresh\_Uppu](https://forum.ansible.com/u/Suresh_Uppu)\ **Replies:** 8\ **Last updated:** [May 2, 2016, 6:21am UTC](https://forum.ansible.com/t/query-regarding-when-condition/21314 "2016-05-02T06:21:34Z")
Hi, I am installing python-setuptools. I am have my play book like that to insatll on Suse and Redhat name: installing python-setuptools yum: name=python-setuptools state=latest when: ansible\_os\_family == “RedHat” … --- ## [Ansible with GitHub and Jenkins](https://forum.ansible.com/t/ansible-with-github-and-jenkins/21326)
**Author:** [@abidewan7](https://forum.ansible.com/u/abidewan7)\ **Replies:** 0\ **Last updated:** [May 2, 2016, 6:03am UTC](https://forum.ansible.com/t/ansible-with-github-and-jenkins/21326 "2016-05-02T06:03:06Z")
Hi Guys, I’m looking for a step by step process to configure GitHub, Jenkins (CI) and Ansible (CD) so that a code from local machine to → Github → Jenkins (CI) → Ansible (CD) → local or EC2 can be deployed. Also lookin… --- ## [storing/inserting Ansible facts into mysql database](https://forum.ansible.com/t/storing-inserting-ansible-facts-into-mysql-database/21322)
**Author:** [@Anil\_Dasmala](https://forum.ansible.com/u/Anil_Dasmala)\ **Replies:** 0\ **Last updated:** [May 1, 2016, 4:32pm UTC](https://forum.ansible.com/t/storing-inserting-ansible-facts-into-mysql-database/21322 "2016-05-01T16:32:55Z")
Hi Guys, I wanted to store facts of all servers(setup module data/output) into mysql database(for easy custom facts retrieval later) Can someone please give ideas on how to achieve this. Thanks in advance. –Anil --- ## [Force to gather fact even if gathering is set to smart](https://forum.ansible.com/t/force-to-gather-fact-even-if-gathering-is-set-to-smart/21310)
**Author:** [@Jurgen\_Haas2](https://forum.ansible.com/u/Jurgen_Haas2)\ **Replies:** 1\ **Last updated:** [May 1, 2016, 11:41am UTC](https://forum.ansible.com/t/force-to-gather-fact-even-if-gathering-is-set-to-smart/21310 "2016-05-01T11:41:41Z")
How can I force setup to run on a play even if the Ansible config file is set to gathering strategy of smart. When I include gather\_facts: True for a play, it is just ignored while the facts file for a host is availab… --- ## [Linux shadow password file chage module](https://forum.ansible.com/t/linux-shadow-password-file-chage-module/21320)
**Author:** [@John\_Buxton](https://forum.ansible.com/u/John_Buxton)\ **Replies:** 0\ **Last updated:** [May 1, 2016, 9:28am UTC](https://forum.ansible.com/t/linux-shadow-password-file-chage-module/21320 "2016-05-01T09:28:32Z")
Hello Ansible Developers, A little while ago I wrote an Ansible “chage” module in Python. https://galaxy.ansible.com/lqueryvg/chage/ It provides proper & efficient read & write access to the Linux /etc/shadow file via… --- ## [Possible bug: Using file to create directories recursively does not ensure owner/group](https://forum.ansible.com/t/possible-bug-using-file-to-create-directories-recursively-does-not-ensure-owner-group/21319)
**Author:** [@Johannes\_Kastl](https://forum.ansible.com/u/Johannes_Kastl)\ **Replies:** 0\ **Last updated:** [May 1, 2016, 9:07am UTC](https://forum.ansible.com/t/possible-bug-using-file-to-create-directories-recursively-does-not-ensure-owner-group/21319 "2016-05-01T09:07:48Z")
Hi all, using this snipped creates the directories foo, bar and xyz with the correct owner. - name: Create directories file: dest=/foo/bar/xyz owner=0 group=0 mode=0755 state=directory recurse=yes If a directory … --- ## [Replace IP by another en replace module](https://forum.ansible.com/t/replace-ip-by-another-en-replace-module/21274)
**Author:** [@Cavette](https://forum.ansible.com/u/Cavette)\ **Replies:** 1\ **Last updated:** [April 30, 2016, 11:35am UTC](https://forum.ansible.com/t/replace-ip-by-another-en-replace-module/21274 "2016-04-30T11:35:27Z")
Hello, I’m trying to replace an Ip address by anoher in a file but it doesn’t work : Initial file contains : My code below doesn’t work (invalid group reference) : name : Change IP in file replace: dest=myfile.xml… --- ## [ansible integration tests initiative](https://forum.ansible.com/t/ansible-integration-tests-initiative/21318)
**Author:** [@Rene\_Moser](https://forum.ansible.com/u/Rene_Moser)\ **Replies:** 0\ **Last updated:** [April 30, 2016, 11:26am UTC](https://forum.ansible.com/t/ansible-integration-tests-initiative/21318 "2016-04-30T11:26:58Z")
Hi To fast forward running integratino tests on outstanding PRs, I created a simple integration test setup to run tests on any PR by giving a few parameters. I started to run integration tests on Debian related distr… --- ## [Order of roles execution in playbook](https://forum.ansible.com/t/order-of-roles-execution-in-playbook/21286)
**Author:** [@Jim\_Richard](https://forum.ansible.com/u/Jim_Richard)\ **Replies:** 2\ **Last updated:** [April 30, 2016, 2:19am UTC](https://forum.ansible.com/t/order-of-roles-execution-in-playbook/21286 "2016-04-30T02:19:24Z")
I have the following that as of 1.9.4, executed the roles in the order in which they are listed: hosts: all max\_fail\_percentage: 0 gather\_facts: no roles: repositories yum-packages pip-packages java With Ansible 2.… --- ## [How to set an Ansible tier-specific inventory variable?](https://forum.ansible.com/t/how-to-set-an-ansible-tier-specific-inventory-variable/21317)
**Author:** [@Robert\_F](https://forum.ansible.com/u/Robert_F)\ **Replies:** 5\ **Last updated:** [April 29, 2016, 9:59pm UTC](https://forum.ansible.com/t/how-to-set-an-ansible-tier-specific-inventory-variable/21317 "2016-04-29T21:59:28Z")
Is it possible to create an Ansible inventory variable that isn’t associated with an inventory host or group but the server tier the playbook is run on? I have an Ansible role that installs the libffi-dev package using A… --- ## [Can you override $HOME/.ansible/cp on remote hosts?](https://forum.ansible.com/t/can-you-override-home-ansible-cp-on-remote-hosts/21308)
**Author:** [@Brian\_Coca](https://forum.ansible.com/u/Brian_Coca)\ **Replies:** 1\ **Last updated:** [April 29, 2016, 9:20pm UTC](https://forum.ansible.com/t/can-you-override-home-ansible-cp-on-remote-hosts/21308 "2016-04-29T21:20:32Z")
It is documented: http://docs.ansible.com/ansible/intro\_configuration.html#control-path --- ## [Fact gathering times out](https://forum.ansible.com/t/fact-gathering-times-out/21316)
**Author:** [@E.C\_Raymond](https://forum.ansible.com/u/E.C_Raymond)\ **Replies:** 0\ **Last updated:** [April 29, 2016, 4:11pm UTC](https://forum.ansible.com/t/fact-gathering-times-out/21316 "2016-04-29T16:11:32Z")
I am seeing a problem with Ansible (1.9.4) and Debian 7 (wheezy) timing out and failing on gathering facts, specifically with autofs/network mounted volumes. Its not limited to a specific host, as it is happening at rand… --- ## [i want to use environments variables of the remote host .](https://forum.ansible.com/t/i-want-to-use-environments-variables-of-the-remote-host/21315)
**Author:** [@imed\_khaskhoussi](https://forum.ansible.com/u/imed_khaskhoussi)\ **Replies:** 1\ **Last updated:** [April 29, 2016, 4:05pm UTC](https://forum.ansible.com/t/i-want-to-use-environments-variables-of-the-remote-host/21315 "2016-04-29T16:05:11Z")
Hi there, i want to use variables from the remote host i tried to save for example the variable JAVA\_HOME existing in the remote host in a file , but the file is empty . ansible can’t find this variable . is there any… [Previous page](https://forum.ansible.com/c/archives/31.md?page=594) [Next page](https://forum.ansible.com/c/archives/31.md?page=596)