[ansible-project] Re: mysql_user errors when using with_items

[Jeff Sault]

Anyone?

On Monday, 11 July 2016 16:33:55 UTC+1, Jeff Sault wrote:
>
> Hi All,
>
> Does anyone know why the below ansible code is failing?
>
>  - name: Add permissions to heeservers to connect to SQL
>mysql_user: name={{ mu_db_user }} password={{ mu_db_pass }} host="{{ 
> item }}"  priv={{ mu_db_name }}.*:ALL state=present
>with_items: '{{groups.heeservers}}' 
>
> The error reported is..
>
> failed: [mu.vagrant] (item=hee.vagrant) => {"failed": true, "item": 
> "hee.vagrant", "msg": "(1396, \"Operation CREATE USER failed for 
> 'root'@'hee.vagrant'\")"}
>
> If I change the host from "{{ item }}" to a fixed string it works as 
> expected but I dont understand why.
>
> Thanks!
> Jeff
>

-- 
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 ansible-project+unsubscr...@googlegroups.com.
To post to this group, send email to ansible-project@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/ansible-project/0a0e2df3-0c66-4e9a-bf39-131af0fc59cf%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[ansible-project] mysql_user errors when using with_items

[Jeff Sault]

Hi All,

Does anyone know why the below ansible code is failing?

 - name: Add permissions to heeservers to connect to SQL
   mysql_user: name={{ mu_db_user }} password={{ mu_db_pass }} host="{{ 
item }}"  priv={{ mu_db_name }}.*:ALL state=present
   with_items: '{{groups.heeservers}}' 

The error reported is..

failed: [mu.vagrant] (item=hee.vagrant) => {"failed": true, "item": 
"hee.vagrant", "msg": "(1396, \"Operation CREATE USER failed for 
'root'@'hee.vagrant'\")"}

If I change the host from "{{ item }}" to a fixed string it works as 
expected but I dont understand why.

Thanks!
Jeff

-- 
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 ansible-project+unsubscr...@googlegroups.com.
To post to this group, send email to ansible-project@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/ansible-project/1809bd75-fec3-46f3-b5bf-a2aefa1333bc%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.