Can you please cross check this
Im trying to create a user but it gets executed but the user is not getting
created in my RDS mysql DB .
--------------------
---
#creating a sql user
- hosts: localhost
tasks:
#- name: test
- mysql_user: login_host=abcde.us-west-2.rds.amazonaws.com
priv=*.*:SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,RELOAD,PROCESS,REFERENCES,INDEX,ALTER,SHOWDATABASES,CREATETEMPORARYTABLES,LOCKTABLES,EXECUTE,REPLICATIONSLAVE,REPLICATIONCLIENT,CREATEVIEW,SHOWVIEW,CREATEROUTINE,ALTERROUTINE,CREATEUSER,EVENT
login_port=3306 login_user=klm login_password=abc name=marley
password=klmsrib123 state=absent
On Thursday, October 3, 2013 3:21:31 AM UTC+5:30, Michael DeHaan wrote:
>
> An easier way do to this would be to just quote the entire string.
>
> shlex understands quotes and is pretty smart.
>
> priv="gitlabhq_production.*:SELECT,LOCK TABLES,INSERT,UPDATE,DELETE,
> CREATE,DROP,INDEX,ALTER"
>
>
>
>
>
>
> On Wed, Oct 2, 2013 at 5:04 PM, Jonathan Rowlands
> <[email protected]<javascript:>
> > wrote:
>
>> Doh, I should have known. Thanks that worked.
>>
>>
>> On Wednesday, October 2, 2013 5:00:21 PM UTC-4, James Cammarata wrote:
>>
>>> Escape the space: "LOCK\ TABLES". The parsing is done by the python
>>> shlex module if I remember right, so this should get you past the issue.
>>>
>>>
>>> On Wed, Oct 2, 2013 at 3:57 PM, Jonathan Rowlands
>>> <[email protected]>wrote:
>>>
>>>> TASK: [gitlab | mysql | ensure database user gitlab has necessary
>>>> privileges] ***
>>>> failed: [192.168.0.13] => {"failed": true, "item": ""}
>>>> msg: this module requires key=value arguments (['state=present',
>>>> 'name=gitlab', 'priv=gitlabhq_production.*:SELECT,LOCK',
>>>> 'TABLES,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX,ALTER'])
>>>>
>>>>
>>>> On Wednesday, October 2, 2013 4:49:55 PM UTC-4, Jonathan Rowlands wrote:
>>>>
>>>>> I am trying to run the following:
>>>>>
>>>>> - name: gitlab | mysql | ensure database user gitlab has necessary
>>>>> privleges
>>>>> mysql_user: state=present name=gitlab
>>>>> priv=gitlabhq_production.*:SELECT,LOCK
>>>>> TABLES,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX,ALTER
>>>>>
>>>>> The "LOCK TABLES" priv is a problem though since it has a space. Is
>>>>> there any way around this?
>>>>>
>>>> --
>>>> 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].
>>>>
>>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>>
>>>
>>>
>>>
>>> --
>>>
>>> James Cammarata <[email protected]>
>>>
>>> Sr. Software Engineer, AnsibleWorks, Inc.
>>> http://www.ansibleworks.com/
>>>
>> --
>> 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] <javascript:>.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>
>
>
> --
> Michael DeHaan <[email protected] <javascript:>>
> CTO, AnsibleWorks, Inc.
> http://www.ansibleworks.com/
>
>
--
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/269870f8-2cd9-4a28-8a7e-c1e3e9dabc94%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
