###発生している問題・エラーメッセージ
pythonのDjangoとmysqlを使ったアプリをherokuにデプロイしたのですが、うまく動きません。
###エラー内容
途中まではDjango Girls Tutorialのチュートリアルを見てやっておりました。
$ git push heroku master
までは終了しておりまして、そこまでは正常にできております。
その後、MySQLを使うときには別の設定が必要ということを聞いて、こちらを参照して、herokuのアドオンにClearDB MySQLをセットすることができました。
その後、
$ heroku ps:scale web=1 $ heroku run python manage.py migrate
を打つと、
Traceback (most recent call last): File "/app/.heroku/python/lib/python3.6/site-packages/pymysql/connections.py", line 916, in connect **kwargs) File "/app/.heroku/python/lib/python3.6/socket.py", line 722, in create_connection raise err File "/app/.heroku/python/lib/python3.6/socket.py", line 713, in create_connection sock.connect(sa) ConnectionRefusedError: [Errno 111] Connection refused During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/app/.heroku/python/lib/python3.6/site-packages/django/db/backends/base/base.py", line 213, in ensure_connection self.connect() File "/app/.heroku/python/lib/python3.6/site-packages/django/db/backends/base/base.py", line 189, in connect self.connection = self.get_new_connection(conn_params) File "/app/.heroku/python/lib/python3.6/site-packages/django/db/backends/mysql/base.py", line 274, in get_new_connection conn = Database.connect(**conn_params) File "/app/.heroku/python/lib/python3.6/site-packages/pymysql/__init__.py", line 90, in Connect return Connection(*args, **kwargs) File "/app/.heroku/python/lib/python3.6/site-packages/pymysql/connections.py", line 706, in __init__ self.connect() File "/app/.heroku/python/lib/python3.6/site-packages/pymysql/connections.py", line 963, in connect raise exc pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on 'localhost' ([Errno 111] Connection refused)") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "manage.py", line 24, in <module> execute_from_command_line(sys.argv) File "/app/.heroku/python/lib/python3.6/site-packages/django/core/management/__init__.py", line 363, in execute_from_command_line utility.execute() File "/app/.heroku/python/lib/python3.6/site-packages/django/core/management/__init__.py", line 355, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "/app/.heroku/python/lib/python3.6/site-packages/django/core/management/base.py", line 283, in run_from_argv self.execute(*args, **cmd_options) File "/app/.heroku/python/lib/python3.6/site-packages/django/core/management/base.py", line 327, in execute self.check() File "/app/.heroku/python/lib/python3.6/site-packages/django/core/management/base.py", line 359, in check include_deployment_checks=include_deployment_checks, File "/app/.heroku/python/lib/python3.6/site-packages/django/core/management/commands/migrate.py", line 61, in _run_checks issues = run_checks(tags=[Tags.database]) File "/app/.heroku/python/lib/python3.6/site-packages/django/core/checks/registry.py", line 81, in run_checks new_errors = check(app_configs=app_configs) File "/app/.heroku/python/lib/python3.6/site-packages/django/core/checks/database.py", line 10, in check_database_backends issues.extend(conn.validation.check(**kwargs)) File "/app/.heroku/python/lib/python3.6/site-packages/django/db/backends/mysql/validation.py", line 9, in check issues.extend(self._check_sql_mode(**kwargs)) File "/app/.heroku/python/lib/python3.6/site-packages/django/db/backends/mysql/validation.py", line 13, in _check_sql_mode with self.connection.cursor() as cursor: File "/app/.heroku/python/lib/python3.6/site-packages/django/db/backends/base/base.py", line 254, in cursor return self._cursor() File "/app/.heroku/python/lib/python3.6/site-packages/django/db/backends/base/base.py", line 229, in _cursor self.ensure_connection() File "/app/.heroku/python/lib/python3.6/site-packages/django/db/backends/base/base.py", line 213, in ensure_connection self.connect() File "/app/.heroku/python/lib/python3.6/site-packages/django/db/utils.py", line 94, in __exit__ six.reraise(dj_exc_type, dj_exc_value, traceback) File "/app/.heroku/python/lib/python3.6/site-packages/django/utils/six.py", line 685, in reraise raise value.with_traceback(tb) File "/app/.heroku/python/lib/python3.6/site-packages/django/db/backends/base/base.py", line 213, in ensure_connection self.connect() File "/app/.heroku/python/lib/python3.6/site-packages/django/db/backends/base/base.py", line 189, in connect self.connection = self.get_new_connection(conn_params) File "/app/.heroku/python/lib/python3.6/site-packages/django/db/backends/mysql/base.py", line 274, in get_new_connection conn = Database.connect(**conn_params) File "/app/.heroku/python/lib/python3.6/site-packages/pymysql/__init__.py", line 90, in Connect return Connection(*args, **kwargs) File "/app/.heroku/python/lib/python3.6/site-packages/pymysql/connections.py", line 706, in __init__ self.connect() File "/app/.heroku/python/lib/python3.6/site-packages/pymysql/connections.py", line 963, in connect raise exc django.db.utils.OperationalError: (2003, "Can't connect to MySQL server on 'localhost' ([Errno 111] Connection refused)")
というエラーが出てしまいます。
この
pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on 'localhost' ([Errno 111] Connection refused)") django.db.utils.OperationalError: (2003, "Can't connect to MySQL server on 'localhost' ([Errno 111] Connection refused)")
はどういう意味でしょうか?
また、このエラーはどうやったら解決できるでしょうか?
よろしくお願いします。
###ツール・バージョン
Python 3.6.0
django 1.10.5
バッドをするには、ログインかつ
こちらの条件を満たす必要があります。
2017/06/20 06:11
2017/06/20 06:18