异常值：(2002, "无法通过套接字'/var/run/mysqld/mysqld.sock'连接到本地MySQL服务器(111)")

Question

大家好，我在我的部署服务器上反复遇到这个错误。网站一开始运行得挺好，但过一段时间又崩溃了，显示这个错误。

这是错误的追踪信息 `

Environment:


Request Method: GET
Request URL: http://getfbstuff.com/

Django Version: 1.6.2
Python Version: 2.7.3
Installed Applications:
('django.contrib.auth',
 'django.contrib.contenttypes',
 'django.contrib.sessions',
 'django.contrib.sites',
 'django.contrib.messages',
 'django.contrib.staticfiles',
 'django.contrib.admin',
 'downloader',
 'ckeditor',
 'django.contrib.sitemaps')
Installed Middleware:
('django.middleware.common.CommonMiddleware',
 'django.contrib.sessions.middleware.SessionMiddleware',
 'django.middleware.csrf.CsrfViewMiddleware',
 'django.contrib.auth.middleware.AuthenticationMiddleware',
 'django.contrib.messages.middleware.MessageMiddleware')


Traceback:
File "/usr/local/lib/python2.7/dist-packages/django/core/handlers/base.py" in get_response
  114.                     response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "/usr/local/lib/python2.7/dist-packages/django/views/decorators/cache.py" in _cache_controlled
  38.             response = viewfunc(request, *args, **kw)
File "/home/getfbstuff/public_html/getfbstuff.com/fb/downloader/views.py" in index
  23.   if seo:
File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py" in __nonzero__
  100.         self._fetch_all()
File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py" in _fetch_all
  854.             self._result_cache = list(self.iterator())
File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py" in iterator
  220.         for row in compiler.results_iter():
File "/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py" in results_iter
  709.         for rows in self.execute_sql(MULTI):
File "/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py" in execute_sql
  781.         cursor = self.connection.cursor()
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/__init__.py" in cursor
  157.             cursor = self.make_debug_cursor(self._cursor())
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/__init__.py" in _cursor
  129.         self.ensure_connection()
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/__init__.py" in ensure_connection
  124.                 self.connect()
File "/usr/local/lib/python2.7/dist-packages/django/db/utils.py" in __exit__
  99.                 six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/__init__.py" in ensure_connection
  124.                 self.connect()
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/__init__.py" in connect
  112.         self.connection = self.get_new_connection(conn_params)
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/mysql/base.py" in get_new_connection
  435.         conn = Database.connect(**conn_params)
File "/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py" in Connect
  81.     return Connection(*args, **kwargs)
File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py" in __init__
  187.         super(Connection, self).__init__(*args, **kwargs2)

Exception Type: OperationalError at /
Exception Value: (2002, "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)")`

请帮帮我，我搞不清楚自己哪里做错了。我按照这些步骤配置了mysql和django，具体可以参考这个链接：www.saltycrane.com/blog/2008/07/how-set-django-mysql-ubuntu-hardy/

在我的本地机器上没有遇到这样的情况。提前谢谢大家！

mysql django 错误追踪套接字服务器崩溃异常值部署问题本地配置

异常值：(2002, "无法通过套接字'/var/run/mysqld/mysqld.sock'连接到本地MySQL服务器(111)")

1 个回答

撰写回答