mysql_user module and LOCK TABLES

[Jonathan Rowlands]

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?

[Jonathan Rowlands]

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'])

[James Cammarata]

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.

--
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 ansible-proje...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--

James Cammarata <jcamm...@ansibleworks.com>
Sr. Software Engineer, AnsibleWorks, Inc.
http://www.ansibleworks.com/

[Jonathan Rowlands]

Doh, I should have known. Thanks that worked.

[Michael DeHaan]

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"

Michael DeHaan <mic...@ansibleworks.com>
CTO, AnsibleWorks, Inc.
http://www.ansibleworks.com/

[prateek gupta]

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