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] <javascript:>> 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] <javascript:>.
>> To post to this group, send email to [email protected]<javascript:>
>> .
>> 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/047e1902-0e3e-4d21-a020-1b9a9fb5ec35%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
