Seems reasonable to me since that's not a valid hostname?
On Thu, May 15, 2014 at 6:12 PM, Wynne Pirini <[email protected]> wrote: > If I run this... > > - name: Create/assign database user to db and grant permissions > mysql_user: name={{ item.env.db_user }} > password={{ item.env.db_password }} > priv={{ item.env.db_name | default(item.site_name) > }}.*:ALL,GRANT > state=present > login_host={{ item.env.db_host | default('localhost') }} > with_items: web_site > > > If item:env.db_host == 'localhost' it works. > > If item:env.db_host == '%' it fails. > > > > > On Friday, May 16, 2014 9:57:59 AM UTC+12, Michael DeHaan wrote: >> >> It's a database error, so nothing with "with_nested". >> >> Key part: >> >> "You have an error in your SQL syntax; check the manual that corresponds >> to your MariaDB server version for the right syntax to use near '.* TO >> 'john'@'localhost'' at line 1" >> > -- > 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/a29a6b5a-18ba-4fe9-b5a3-d763cfa13489%40googlegroups.com<https://groups.google.com/d/msgid/ansible-project/a29a6b5a-18ba-4fe9-b5a3-d763cfa13489%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > For more options, visit https://groups.google.com/d/optout. > -- 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/CA%2BnsWgw_UcH9OtiFCXktiXaLmv6bqaC%3DzgZL8tUpHBZTAYhhnA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
