mysql_user doesen't translate variables

Archives Ansible Project
1

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

2

    - 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