{"action":"closed","issue":{"url":"https://api.github.com/repos/aio-libs/aiomysql/issues/85","repository_url":"https://api.github.com/repos/aio-libs/aiomysql","labels_url":"https://api.github.com/repos/aio-libs/aiomysql/issues/85/labels{/name}","comments_url":"https://api.github.com/repos/aio-libs/aiomysql/issues/85/comments","events_url":"https://api.github.com/repos/aio-libs/aiomysql/issues/85/events","html_url":"https://github.com/aio-libs/aiomysql/issues/85","id":161084529,"number":85,"title":"Connection of any kind Issues (1043 Bad Handshake)","user":{"login":"trivigy","id":3146062,"avatar_url":"https://avatars.githubusercontent.com/u/3146062?v=3","gravatar_id":"","url":"https://api.github.com/users/trivigy","html_url":"https://github.com/trivigy","followers_url":"https://api.github.com/users/trivigy/followers","following_url":"https://api.github.com/users/trivigy/following{/other_user}","gists_url":"https://api.github.com/users/trivigy/gists{/gist_id}","starred_url":"https://api.github.com/users/trivigy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/trivigy/subscriptions","organizations_url":"https://api.github.com/users/trivigy/orgs","repos_url":"https://api.github.com/users/trivigy/repos","events_url":"https://api.github.com/users/trivigy/events{/privacy}","received_events_url":"https://api.github.com/users/trivigy/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2016-06-19T18:08:09Z","updated_at":"2016-07-24T08:02:46Z","closed_at":"2016-07-24T08:02:46Z","body":"Trying to connect to the database and getting a really weird error. Tried doing this without aiomysql but rather directly with PyMySQL and the connection worked fine. Would greatly appreciate some help.\r\n\r\nEnvironment:\r\nMysql: 5.7.12\r\npython: 3.5.1+\r\nPyMySQL: 0.7.4\r\naiomysql: 0.0.7\r\n\r\n```\r\nTraceback (most recent call last):\r\n  File \"/usr/local/lib/python3.5/dist-packages/aiomysql/connection.py\", line 447, in _connect\r\n    yield from self._request_authentication()\r\n  File \"/usr/local/lib/python3.5/dist-packages/aiomysql/connection.py\", line 615, in _request_authentication\r\n    auth_packet = yield from self._read_packet()\r\n  File \"/usr/local/lib/python3.5/dist-packages/aiomysql/connection.py\", line 500, in _read_packet\r\n    packet.check_error()\r\n  File \"/usr/local/lib/python3.5/dist-packages/pymysql/connections.py\", line 393, in check_error\r\n    err.raise_mysql_exception(self._data)\r\n  File \"/usr/local/lib/python3.5/dist-packages/pymysql/err.py\", line 120, in raise_mysql_exception\r\n    _check_mysql_exception(errinfo)\r\n  File \"/usr/local/lib/python3.5/dist-packages/pymysql/err.py\", line 115, in _check_mysql_exception\r\n    raise InternalError(errno, errorvalue)\r\npymysql.err.InternalError: (1043, 'Bad handshake')\r\n\r\nThe above exception was the direct cause of the following exception:\r\n\r\nTraceback (most recent call last):\r\n  File \"/usr/lib/python3.5/code.py\", line 91, in runcode\r\n    exec(code, self.locals)\r\n  File \"<input>\", line 22, in <module>\r\n  File \"/usr/lib/python3.5/asyncio/base_events.py\", line 373, in run_until_complete\r\n    return future.result()\r\n  File \"/usr/lib/python3.5/asyncio/futures.py\", line 274, in result\r\n    raise self._exception\r\n  File \"/usr/lib/python3.5/asyncio/tasks.py\", line 240, in _step\r\n    result = coro.send(None)\r\n  File \"<input>\", line 11, in test_example\r\n  File \"/usr/local/lib/python3.5/dist-packages/aiomysql/utils.py\", line 57, in __await__\r\n    resp = yield from self._coro\r\n  File \"/usr/local/lib/python3.5/dist-packages/aiomysql/pool.py\", line 28, in _create_pool\r\n    yield from pool._fill_free_pool(False)\r\n  File \"/usr/local/lib/python3.5/dist-packages/aiomysql/pool.py\", line 163, in _fill_free_pool\r\n    **self._conn_kwargs)\r\n  File \"/usr/local/lib/python3.5/dist-packages/aiomysql/utils.py\", line 52, in __iter__\r\n    resp = yield from self._coro\r\n  File \"/usr/local/lib/python3.5/dist-packages/aiomysql/connection.py\", line 76, in _connect\r\n    yield from conn._connect()\r\n  File \"/usr/local/lib/python3.5/dist-packages/aiomysql/connection.py\", line 467, in _connect\r\n    self._host) from e\r\npymysql.err.OperationalError: (2003, \"Can't connect to MySQL server on 'XXX.XXX.XXX.XXX'\")\r\n```"}}
{"actor":{"display_login":"jettify"}}