This task:
- name: test1
mysql_user: name={{ item.name }} password={{ item.password }} host={{
item.host }} priv={{ item.priv }} state=present login_user=root
login_password=rtAtJ8NaWvRX6EJsLPiixm
with_items:
- { name: 'hibbert_admin', password: 'Fi4iKbwuoNyfK3KsNMThDn', host:
'10.209.104.19', priv: '*.*:ALL' }
Is resulting in the following error:
TASK: [hibbert_db | test1]
****************************************************
fatal: [q-mysql01] => failed to parse:
SUDO-SUCCESS-msjntpckybyqqlzjnhyleigbtnhouzjy
Traceback (most recent call last):
File "/tmp/ansible-tmp-1395766982.93-90997544941085/mysql_user", line
1539, in <module>
main()
File "/tmp/ansible-tmp-1395766982.93-90997544941085/mysql_user", line
459, in main
changed = user_add(cursor, user, host, password, priv)
File "/tmp/ansible-tmp-1395766982.93-90997544941085/mysql_user", line
158, in user_add
cursor.execute("CREATE USER %s@%s IDENTIFIED BY %s",
(user,host,password))
File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 173,
in execute
self.errorhandler(self, exc, value)
File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line
36, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1396, "Operation CREATE USER failed
for 'hibbert_admin'@'10.209.104.19'")
FATAL: all hosts have already failed -- aborting
Any ideas why this wouldn't work? login_user and login_password are correct.
--
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/89ba0599-86f4-461f-8a65-e983ecfe203d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
