{"action":"created","issue":{"url":"https://api.github.com/repos/ansible/ansible-modules-core/issues/3587","repository_url":"https://api.github.com/repos/ansible/ansible-modules-core","labels_url":"https://api.github.com/repos/ansible/ansible-modules-core/issues/3587/labels{/name}","comments_url":"https://api.github.com/repos/ansible/ansible-modules-core/issues/3587/comments","events_url":"https://api.github.com/repos/ansible/ansible-modules-core/issues/3587/events","html_url":"https://github.com/ansible/ansible-modules-core/pull/3587","id":152740604,"number":3587,"title":"add support for auth_socket","user":{"login":"verwilst","id":2114993,"avatar_url":"https://avatars.githubusercontent.com/u/2114993?v=3","gravatar_id":"","url":"https://api.github.com/users/verwilst","html_url":"https://github.com/verwilst","followers_url":"https://api.github.com/users/verwilst/followers","following_url":"https://api.github.com/users/verwilst/following{/other_user}","gists_url":"https://api.github.com/users/verwilst/gists{/gist_id}","starred_url":"https://api.github.com/users/verwilst/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/verwilst/subscriptions","organizations_url":"https://api.github.com/users/verwilst/orgs","repos_url":"https://api.github.com/users/verwilst/repos","events_url":"https://api.github.com/users/verwilst/events{/privacy}","received_events_url":"https://api.github.com/users/verwilst/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/ansible/ansible-modules-core/labels/feature_pull_request","name":"feature_pull_request","color":"009800"},{"url":"https://api.github.com/repos/ansible/ansible-modules-core/labels/needs_revision","name":"needs_revision","color":"eb6420"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":7,"created_at":"2016-05-03T10:11:17Z","updated_at":"2016-09-01T14:32:56Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/ansible/ansible-modules-core/pulls/3587","html_url":"https://github.com/ansible/ansible-modules-core/pull/3587","diff_url":"https://github.com/ansible/ansible-modules-core/pull/3587.diff","patch_url":"https://github.com/ansible/ansible-modules-core/pull/3587.patch"},"body":"##### ISSUE TYPE\r\n - Feature Pull Request\r\n\r\n##### COMPONENT NAME\r\ndatabase/mysql/mysql_user\r\n\r\n##### ANSIBLE VERSION\r\n```\r\nansible 2.2.0 (devel c42501cfe7) last updated 2016/05/03 09:13:13 (GMT +000)\r\n  lib/ansible/modules/core: (detached HEAD b6ad3b6773) last updated 2016/05/02 14:18:29 (GMT +000)\r\n  lib/ansible/modules/extras: (detached HEAD 1846de2809) last updated 2016/05/02 14:18:33 (GMT +000)\r\n  config file = /etc/ansible/ansible.cfg\r\n  configured module search path = Default w/o overrides\r\n```\r\n\r\n##### SUMMARY\r\nAdd support for plugins ( auth_socket ) for authentication in MySQL. Fixes #3003\r\n\r\n```\r\nroot@ansible:/tmp# ansible debian8 -m mysql_user -a \"user=bob plugin=auth_socket\" --forks 1\r\ndebian8 | SUCCESS => {\r\n    \"changed\": true, \r\n    \"user\": \"bob\"\r\n}\r\nroot@ansible:/tmp# ansible debian8 -m mysql_user -a \"user=bob plugin=auth_socket\" --forks 1\r\ndebian8 | SUCCESS => {\r\n    \"changed\": false, \r\n    \"user\": \"bob\"\r\n}\r\n\r\nmysql> select User,Host,plugin from user where User like 'bob';\r\n+------+-----------+-------------+\r\n| User | Host      | plugin      |\r\n+------+-----------+-------------+\r\n| bob  | localhost | auth_socket |\r\n+------+-----------+-------------+\r\n1 row in set (0.00 sec)\r\n\r\n```\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/ansible/ansible-modules-core/issues/comments/244097798","html_url":"https://github.com/ansible/ansible-modules-core/pull/3587#issuecomment-244097798","issue_url":"https://api.github.com/repos/ansible/ansible-modules-core/issues/3587","id":244097798,"user":{"login":"oscherler","id":189712,"avatar_url":"https://avatars.githubusercontent.com/u/189712?v=3","gravatar_id":"","url":"https://api.github.com/users/oscherler","html_url":"https://github.com/oscherler","followers_url":"https://api.github.com/users/oscherler/followers","following_url":"https://api.github.com/users/oscherler/following{/other_user}","gists_url":"https://api.github.com/users/oscherler/gists{/gist_id}","starred_url":"https://api.github.com/users/oscherler/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/oscherler/subscriptions","organizations_url":"https://api.github.com/users/oscherler/orgs","repos_url":"https://api.github.com/users/oscherler/repos","events_url":"https://api.github.com/users/oscherler/events{/privacy}","received_events_url":"https://api.github.com/users/oscherler/received_events","type":"User","site_admin":false},"created_at":"2016-09-01T14:32:56Z","updated_at":"2016-09-01T14:32:56Z","body":"I made some progress. I have a project with 13 Docker images with different MySQL or MariaDB versions, and playbooks to try and test all situations.\r\n\r\nI think I’m done fixing `user_add`, but I’ll need more time to do `user_mod`."}}
{"actor":{"display_login":"oscherler"}}