Done and done. Thank you for your help! :-) On Friday, March 14, 2014 3:39:50 PM UTC, James Cammarata wrote: > > Yes, all lookups like that (and action_plugins too) occur locally on the > machine running ansible, not remotely. Looking through > http://docs.ansible.com/playbooks_lookups.html, it does not mention that > specifically, so it would be good to add. Please feel free to open up a > github issue for that. > > Thanks! > > > On Fri, Mar 14, 2014 at 10:04 AM, William Hall-BrandFour < > [email protected] <javascript:>> wrote: > >> The MySQL account I use should be all singing all dancing. >> >> I think I may have figured it out. >> >> The debug command came back with a value but I couldn't find the >> passwordfile and then it occurred to me that the file might be local and >> sure enough it was. >> >> Did I miss the part where the file lookup works on local files and not >> remote files? >> >> >> On Friday, March 14, 2014 3:01:48 PM UTC, James Cammarata wrote: >> >>> Really though, this seems like your mysqluser/mysqlpassword variables >>> are incorrect, or the user you're connecting as does not have the proper >>> GRANT permissions to add/edit the user. >>> >>> Can you run other actions with that user/passord? >>> >>> >>> On Fri, Mar 14, 2014 at 9:58 AM, James Cammarata >>> <[email protected]>wrote: >>> >>>> What happens if you use debug: var={{ lookup('password', >>>> '/tmp/passwordfile length=15') }} ? >>>> >>>> >>>> >>>> On Fri, Mar 14, 2014 at 6:10 AM, William Hall-BrandFour < >>>> [email protected]> wrote: >>>> >>>>> I never got the message to say there was a reply so sorry for the >>>>> delay in getting back to you. >>>>> >>>>> I have disabled sudo for that play and updated to ansible 1.5.3. >>>>> >>>>> The play now works but does not create a file at /tmp/passwordfile and >>>>> if I try to use an alternative directory, it errors completely differently >>>>> >>>>> failed: [g.b4dev.com] => {"failed": true, "parsed": false} >>>>> invalid output was: Traceback (most recent call last): >>>>> File >>>>> "/home/wh/.ansible/tmp/ansible-tmp-1394795091.79-153729821362509/mysql_user", >>>>> >>>>> line 1561, in <module> >>>>> main() >>>>> File >>>>> "/home/wh/.ansible/tmp/ansible-tmp-1394795091.79-153729821362509/mysql_user", >>>>> >>>>> line 459, in main >>>>> changed = user_add(cursor, user, host, password, priv) >>>>> File >>>>> "/home/wh/.ansible/tmp/ansible-tmp-1394795091.79-153729821362509/mysql_user", >>>>> >>>>> line 158, in user_add >>>>> cursor.execute("CREATE USER %s@%s IDENTIFIED BY %s", >>>>> (user,host,password)) >>>>> File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line >>>>> 174, in execute >>>>> self.errorhandler(self, exc, value) >>>>> File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", >>>>> line 36, in defaulterrorhandler >>>>> raise errorclass, errorvalue >>>>> _mysql_exceptions.OperationalError: (1396, "Operation CREATE USER >>>>> failed for 'test'@'localhost'") >>>>> >>>>> >>>>> >>>>> >>>>> On Monday, February 17, 2014 4:11:42 PM UTC, James Cammarata wrote: >>>>> >>>>>> Are you using sudo to execute this? In that case, you may be hitting >>>>>> this bug: >>>>>> >>>>>> https://github.com/ansible/ansible/issues/5533 >>>>>> >>>>>> There are pull-requests open to address this, which I will be looking >>>>>> to test today. >>>>>> >>>>>> >>>>>> On Thu, Feb 13, 2014 at 1:00 PM, William Hall-BrandFour < >>>>>> [email protected]> wrote: >>>>>> >>>>>>> Similar to this discussion https://groups.google.com/d/ms >>>>>>> g/ansible-project/aBE51ToAC7A/QC3jwdPOK4MJ >>>>>>> >>>>>>> I am getting this error: >>>>>>> >>>>>>> failed to parse: SUDO-SUCCESS-ugbdmgqomyttgubummftugavvodrnugl >>>>>>> >>>>>>> I am trying to make use of the password lookup in mysql_user like so >>>>>>> >>>>>>> - name: create and/or update database user >>>>>>> mysql_user: >>>>>>> login_user={{ mysqluser }} >>>>>>> login_password={{ mysqlpassword }} >>>>>>> name={{ databaseuser }} >>>>>>> password={{ lookup('password', '/tmp/passwordfile >>>>>>> length=15') }} >>>>>>> append_privs=yes >>>>>>> priv={{ databasename }}.*:SELECT,INSERT,UPDATE,DELETE >>>>>>> >>>>>>> I was previously using a similar play to get a password via an api >>>>>>> and that worked so I know the syntax is correct, its just the >>>>>>> introduction >>>>>>> of the password lookup which seems to have broken things. >>>>>>> >>>>>>> Client: Mac OS X 10.6.8 >>>>>>> Server: Debian 7 >>>>>>> >>>>>>> Any ideas? >>>>>>> >>>>>>> -- >>>>>>> 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 [email protected]. >>>>>>> To post to this group, send email to [email protected]. >>>>>>> >>>>>>> For more options, visit https://groups.google.com/groups/opt_out. >>>>>>> >>>>>> >>>>>> >>>> >>> >
-- 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 [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/4f09e626-c35f-4320-b918-6a6f26592417%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
