{"action":"created","issue":{"url":"https://api.github.com/repos/glzjin/ss-panel-v3-mod/issues/321","repository_url":"https://api.github.com/repos/glzjin/ss-panel-v3-mod","labels_url":"https://api.github.com/repos/glzjin/ss-panel-v3-mod/issues/321/labels{/name}","comments_url":"https://api.github.com/repos/glzjin/ss-panel-v3-mod/issues/321/comments","events_url":"https://api.github.com/repos/glzjin/ss-panel-v3-mod/issues/321/events","html_url":"https://github.com/glzjin/ss-panel-v3-mod/issues/321","id":182700797,"number":321,"title":"魔改版后端一直连接不上前端数据库","user":{"login":"chocolatesir","id":12197868,"avatar_url":"https://avatars.githubusercontent.com/u/12197868?v=3","gravatar_id":"","url":"https://api.github.com/users/chocolatesir","html_url":"https://github.com/chocolatesir","followers_url":"https://api.github.com/users/chocolatesir/followers","following_url":"https://api.github.com/users/chocolatesir/following{/other_user}","gists_url":"https://api.github.com/users/chocolatesir/gists{/gist_id}","starred_url":"https://api.github.com/users/chocolatesir/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chocolatesir/subscriptions","organizations_url":"https://api.github.com/users/chocolatesir/orgs","repos_url":"https://api.github.com/users/chocolatesir/repos","events_url":"https://api.github.com/users/chocolatesir/events{/privacy}","received_events_url":"https://api.github.com/users/chocolatesir/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-10-13T05:44:33Z","updated_at":"2016-10-13T05:46:15Z","closed_at":null,"body":"后端系统是debian7，安装的wiki上的魔改版后端，使用supervisor守护进程，启动后提示如下错误（服务端数据库账户已开启远程登录，且有全局权限）\r\n7/dist-packages/cymysql/__init__.py\", line 85, in Connect\r\n    return Connection(*args, **kwargs)\r\n  File \"/usr/local/lib/python2.7/dist-packages/cymysql/connections.py\", line 244, in __init__\r\n    self._connect()\r\n  File \"/usr/local/lib/python2.7/dist-packages/cymysql/connections.py\", line 409, in _connect\r\n    raise OperationalError(2003, \"Can't connect to MySQL server on %r (%s)\" % (self.host, e.args[0]))\r\nOperationalError: (2003, \"Can't connect to MySQL server on '104.xxx.xxx.xxx' (110)\")\r\n\r\n2016-10-13 01:31:04 INFO     util.py:85 loading libcrypto from libcrypto.so.1.0.0\r\n2016-10-13 01:31:04 INFO     asyncdns.py:324 dns server: [('8.8.8.8', 53), ('8.8.4.4', 53)]\r\n2016-10-13 01:31:04 INFO     asyncdns.py:324 dns server: [('8.8.8.8', 53), ('8.8.4.4', 53)]\r\n2016-10-13 01:31:23 INFO     util.py:85 loading libcrypto from libcrypto.so.1.0.0\r\n2016-10-13 01:31:23 INFO     asyncdns.py:324 dns server: [('8.8.8.8', 53), ('8.8.4.4', 53)]\r\n2016-10-13 01:31:23 INFO     asyncdns.py:324 dns server: [('8.8.8.8', 53), ('8.8.4.4', 53)]\r\n2016-10-13 01:32:26 ERROR    db_transfer.py:561 Traceback (most recent call last):\r\n  File \"/root/shadowsocks/db_transfer.py\", line 553, in thread_db\r\n    db_instance.push_db_all_user()\r\n  File \"/root/shadowsocks/db_transfer.py\", line 211, in push_db_all_user\r\n    update_transfer = self.update_all_user(dt_transfer)\r\n  File \"/root/shadowsocks/db_transfer.py\", line 56, in update_all_user\r\n    passwd=get_config().MYSQL_PASS, db=get_config().MYSQL_DB, charset='utf8')\r\n  File \"/usr/local/lib/python2.7/dist-packages/cymysql/__init__.py\", line 85, in Connect\r\n    return Connection(*args, **kwargs)\r\n  File \"/usr/local/lib/python2.7/dist-packages/cymysql/connections.py\", line 244, in __init__\r\n    self._connect()\r\n  File \"/usr/local/lib/python2.7/dist-packages/cymysql/connections.py\", line 409, in _connect\r\n    raise OperationalError(2003, \"Can't connect to MySQL server on %r (%s)\" % (self.host, e.args[0]))\r\nOperationalError: (2003, \"Can't connect to MySQL server on '104.xxx.xxx.xxx' (110)\")\r\n\r\n2016-10-13 01:33:26 ERROR    auto_block.py:185 Auto block thread error\r\n2016-10-13 01:34:29 ERROR    db_transfer.py:561 Traceback (most recent call last):\r\n  File \"/root/shadowsocks/db_transfer.py\", line 553, in thread_db\r\n    db_instance.push_db_all_user()\r\n  File \"/root/shadowsocks/db_transfer.py\", line 211, in push_db_all_user\r\n    update_transfer = self.update_all_user(dt_transfer)\r\n  File \"/root/shadowsocks/db_transfer.py\", line 56, in update_all_user\r\n    passwd=get_config().MYSQL_PASS, db=get_config().MYSQL_DB, charset='utf8')\r\n  File \"/usr/local/lib/python2.7/dist-packages/cymysql/__init__.py\", line 85, in Connect\r\n    return Connection(*args, **kwargs)\r\n  File \"/usr/local/lib/python2.7/dist-packages/cymysql/connections.py\", line 244, in __init__\r\n    self._connect()\r\n  File \"/usr/local/lib/python2.7/dist-packages/cymysql/connections.py\", line 409, in _connect\r\n    raise OperationalError(2003, \"Can't connect to MySQL server on %r (%s)\" % (self.host, e.args[0]))\r\nOperationalError: (2003, \"Can't connect to MySQL server on '104.xxx.xxx.xxx' (110)\")\r\n"},"comment":{"url":"https://api.github.com/repos/glzjin/ss-panel-v3-mod/issues/comments/253419945","html_url":"https://github.com/glzjin/ss-panel-v3-mod/issues/321#issuecomment-253419945","issue_url":"https://api.github.com/repos/glzjin/ss-panel-v3-mod/issues/321","id":253419945,"user":{"login":"glzjin","id":7975407,"avatar_url":"https://avatars.githubusercontent.com/u/7975407?v=3","gravatar_id":"","url":"https://api.github.com/users/glzjin","html_url":"https://github.com/glzjin","followers_url":"https://api.github.com/users/glzjin/followers","following_url":"https://api.github.com/users/glzjin/following{/other_user}","gists_url":"https://api.github.com/users/glzjin/gists{/gist_id}","starred_url":"https://api.github.com/users/glzjin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/glzjin/subscriptions","organizations_url":"https://api.github.com/users/glzjin/orgs","repos_url":"https://api.github.com/users/glzjin/repos","events_url":"https://api.github.com/users/glzjin/events{/privacy}","received_events_url":"https://api.github.com/users/glzjin/received_events","type":"User","site_admin":false},"created_at":"2016-10-13T05:46:15Z","updated_at":"2016-10-13T05:46:15Z","body":"请检查下数据库服务器3306端口是否开放。"}}
{"actor":{"display_login":"glzjin"}}