mysql_user priv problem

Archives Ansible Project
1

Hello,

I have a task that reads user and db and grants permisions on specific db for specific user.

https://gist.github.com/markotitel/9931850

Problem is that only last DB from list is granted for specific user.

I have same task with same vars for folder creation and it works fine.

https://gist.github.com/markotitel/9931867

What am I doing wrong?

2

UPDATE:

Here is debug msg from mysql task that looks fine, so I guess something about mysql_user module may be odd.

3

I am sorry for spamming like this but just got into my mind to try something:

  • name: grant privileges on databases
    raw: mysql -e “grant all privileges on {{ item.1 }}.* to {{ item.0.user}}@localhost”
    with_subelements:
  • users
  • db
    this task works as expected, and I beleive this might be a bug in mysql_user module.
4

Yep, probably is.

I think you filed a ticket on this earlier today, so we’re good to go.

(If you’d like to attempt a fix or further debugging, that would be welcome too!)

5

Hi,

I would gladly fix it but dont know programming much, I am ultimate noobster.