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/ >>> msg/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/CAFg%2Bn8R-97o5B2OM8RxOTEn2-e6WyF38R5LY%3DAYYSnCZ1H4Z1g%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
