mysql_user doesen't translate variables

[Florian Lüttgens]

Hi,
im trying to add a mysql user, but it seems the mysql_user module does not translate the variables. It works on mysql_db tho.

Output:

<178.250.***.***> REMOTE_MODULE mysql_user name={{ item.value.projekt | lower }}_{{ item.key }}_{{ stage }} password=VALUE_HIDDEN item.value.password }} host=localhost login_host={{ ansible.fqdn }} priv=*.*:ALL state=present
[...]
msg: this module requires key=value arguments (['name={#', 'item.value.projekt', '|', 'lower', '#}_{#', 'item.key', '#}_{#', 'stage', '#}', 'password={#', 'item.value.password', '#}', 'host=localhost', 'login_host={#', 'ansible.fqdn', '#}', 'priv=*.*:ALL', 'state=present'])

Task:

    - name: Create MySQL Database User
      mysql_user: name={{ item.value.projekt | lower }}_{{ item.key }}_{{ stage }} password={{ item.value.password }} host=localhost login_host={{ ansible.fqdn }} priv=*.*:ALL state=present
      with_dict: "{{webpaket}}"

Any guess?

Regards
Florian Luettgens

[Johannes Kastl]

On 28.04.16 10:15 Florian Lüttgens wrote:

> - name: Create MySQL Database User
> mysql_user: name={{ item.value.projekt | lower }}_{{ item.key }}_{{
> stage }} password={{ item.value.password }} host=localhost login_host={{
> ansible.fqdn }} priv=*.*:ALL state=present
> with_dict: "{{webpaket}}"

Don't you need to quote all the variables?

... name: "{{ item.value.projekt | lower }}_{{ item.key }}_{{
> stage }}" ...

Johannes