{"action":"created","issue":{"url":"https://api.github.com/repos/ansible/ansible-modules-extras/issues/719","repository_url":"https://api.github.com/repos/ansible/ansible-modules-extras","labels_url":"https://api.github.com/repos/ansible/ansible-modules-extras/issues/719/labels{/name}","comments_url":"https://api.github.com/repos/ansible/ansible-modules-extras/issues/719/comments","events_url":"https://api.github.com/repos/ansible/ansible-modules-extras/issues/719/events","html_url":"https://github.com/ansible/ansible-modules-extras/issues/719","id":95461301,"number":719,"title":"mysql_replication module:  warning from MySQLdb.Warning result in failed task","user":{"login":"nadley","id":148801,"avatar_url":"https://avatars.githubusercontent.com/u/148801?v=3","gravatar_id":"","url":"https://api.github.com/users/nadley","html_url":"https://github.com/nadley","followers_url":"https://api.github.com/users/nadley/followers","following_url":"https://api.github.com/users/nadley/following{/other_user}","gists_url":"https://api.github.com/users/nadley/gists{/gist_id}","starred_url":"https://api.github.com/users/nadley/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nadley/subscriptions","organizations_url":"https://api.github.com/users/nadley/orgs","repos_url":"https://api.github.com/users/nadley/repos","events_url":"https://api.github.com/users/nadley/events{/privacy}","received_events_url":"https://api.github.com/users/nadley/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/ansible/ansible-modules-extras/labels/bug_report","name":"bug_report","color":"fbca04"},{"url":"https://api.github.com/repos/ansible/ansible-modules-extras/labels/P3","name":"P3","color":"fef2c0"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-07-16T15:35:06Z","updated_at":"2016-02-23T15:32:25Z","closed_at":null,"body":"##### Issue Type:\r\nBug Report\r\n\r\n##### Ansible Version:\r\nansible --version\r\nansible 1.9.2\r\n  configured module search path = None\r\n\r\n##### Ansible Configuration:\r\n```\r\n[defaults]\r\n# smart - gather by default, but don't regather if already gathered\r\n# implicit - gather by default, turn off with gather_facts: False\r\n# explicit - do not gather by default, must say gather_facts: True\r\ngathering = smart\r\n\r\n# if set to a persistant type (not 'memory', for example 'redis') fact values\r\n# from previous runs in Ansible will be stored.  This may be useful when\r\n# wanting to use, for example, IP information from one group of servers\r\n# without having to talk to them in the same playbook run to get their\r\n# current IP information.\r\n# fact_caching = memory\r\n\r\nfact_caching = jsonfile\r\nfact_caching_connection = /tmp/ansiblefacts\r\n\r\n```\r\n##### Environment:\r\nRunning from Debian 8\r\nManaging Debian 8\r\n\r\n##### Summary:\r\n\r\nWhen running a playbook to setup MySQL replication with a task doing  mode=changemaster the task failed, after a warning from MySQLdb. The warning complains about \"Sending passwords in plain text without SSL/TLS is extremely insecure\"\r\n\r\n##### Steps To Reproduce:\r\nCreate a playbook to setup mysql and replication with a task like this which should be run on slave MySQL to declare the master host : \r\n```\r\n- name: Change the master in slave to start the replication\r\n  mysql_replication: mode=changemaster master_host={{ mysql_repl_master }} master_log_file={{ repl_stat.File }} master_log_pos={{ repl_stat.Position }} master_user={{ mysql_replication_user }} master_password={{ mysql_replication_user_password }}\r\n```\r\n\r\n##### Expected Results:\r\n```\r\nTASK: [mysql | Change the master in slave to start the replication] *** \r\nchanged: [mysql2.preprod]\r\n```\r\n##### Actual Results:\r\n```\r\nfailed: [mysql2.preprod] => {\"failed\": true, \"parsed\": false}\r\nTraceback (most recent call last):\r\n  File \"/root/.ansible/tmp/ansible-tmp-1437058776.53-24949336144903/mysql_replication\", line 2001, in <module>\r\n    main()\r\n  File \"/root/.ansible/tmp/ansible-tmp-1437058776.53-24949336144903/mysql_replication\", line 379, in main\r\n    changemaster(cursor, chm, chm_params)\r\n  File \"/root/.ansible/tmp/ansible-tmp-1437058776.53-24949336144903/mysql_replication\", line 174, in changemaster\r\n    cursor.execute(query, chm_params)\r\n  File \"/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py\", line 176, in execute\r\n    if not self._defer_warnings: self._warning_check()\r\n  File \"/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py\", line 92, in _warning_check\r\n    warn(w[-1], self.Warning, 3)\r\n_mysql_exceptions.Warning: Sending passwords in plain text without SSL/TLS is extremely insecure.\r\n\r\n```\r\n"},"comment":{"url":"https://api.github.com/repos/ansible/ansible-modules-extras/issues/comments/187745831","html_url":"https://github.com/ansible/ansible-modules-extras/issues/719#issuecomment-187745831","issue_url":"https://api.github.com/repos/ansible/ansible-modules-extras/issues/719","id":187745831,"user":{"login":"Jmainguy","id":1372228,"avatar_url":"https://avatars.githubusercontent.com/u/1372228?v=3","gravatar_id":"","url":"https://api.github.com/users/Jmainguy","html_url":"https://github.com/Jmainguy","followers_url":"https://api.github.com/users/Jmainguy/followers","following_url":"https://api.github.com/users/Jmainguy/following{/other_user}","gists_url":"https://api.github.com/users/Jmainguy/gists{/gist_id}","starred_url":"https://api.github.com/users/Jmainguy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Jmainguy/subscriptions","organizations_url":"https://api.github.com/users/Jmainguy/orgs","repos_url":"https://api.github.com/users/Jmainguy/repos","events_url":"https://api.github.com/users/Jmainguy/events{/privacy}","received_events_url":"https://api.github.com/users/Jmainguy/received_events","type":"User","site_admin":false},"created_at":"2016-02-23T15:32:25Z","updated_at":"2016-02-23T15:32:25Z","body":"Hey, is this still ongoing?"}}