Can't connect to MySQL server on '127.0.0.1 | Forum

11 Aug. 2015, 15:55

Posts: 91
Location: Волгоград

11 Aug. 2015, 15:55

Posts: 91
Location: Волгоград

Здравствуйте столкнулся с такой проблемой. Пользуюсь djangocms и сначала использовал sqlite3, проблем не было, теперь перехожу на mysql и не могу понять чего не хватает. при первой команде manage.py syncdb получаю вот что

(okt)root@crackkc:/var/www/oktyabr/oktyabr# python manage.py syncdb
Operations to perform:
  Synchronize unmigrated apps: adminsortable, easy_select2, djangocms_admin_style, sitemaps, sekizai, clippings, news, treebeard, staff
  Apply all migrations: djangocms_flash, filer, djangocms_file, reversion, djangocms_inherit, sessions, admin, djangocms_column, djangocms_text_ckeditor, sites, auth, djangocms_video, menus, contenttypes, djangocms_picture, djangocms_googlemap, djangocms_style, djangocms_link, cms, easy_thumbnails, djangocms_teaser
Synchronizing apps without migrations:
Traceback (most recent call last):
  File "manage.py", line 10, in <module>
    execute_from_command_line(sys.argv)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 385, in execute_from_command_line
    utility.execute()
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 377, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/core/management/base.py", line 288, in run_from_argv
    self.execute(*args, **options.__dict__)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/core/management/base.py", line 338, in execute
    output = self.handle(*args, **options)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/core/management/base.py", line 533, in handle
    return self.handle_noargs(**options)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/core/management/commands/syncdb.py", line 27, in handle_noargs
    call_command("migrate", **options)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 115, in call_command
    return klass.execute(*args, **defaults)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/core/management/base.py", line 338, in execute
    output = self.handle(*args, **options)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/core/management/commands/migrate.py", line 128, in handle
    created_models = self.sync_apps(connection, executor.loader.unmigrated_apps)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/core/management/commands/migrate.py", line 192, in sync_apps
    tables = connection.introspection.table_names(cursor)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/db/backends/__init__.py", line 1376, in table_names
    return sorted(self.get_table_list(cursor))
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/db/backends/mysql/introspection.py", line 37, in get_table_list
    cursor.execute("SHOW TABLES")
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/db/backends/utils.py", line 81, in execute
    return super(CursorDebugWrapper, self).execute(sql, params)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/db/backends/utils.py", line 65, in execute
    return self.cursor.execute(sql, params)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/db/utils.py", line 94, in __exit__
    six.reraise(dj_exc_type, dj_exc_value, traceback)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/db/backends/utils.py", line 63, in execute
    return self.cursor.execute(sql)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py", line 129, in execute
    return self.cursor.execute(query, args)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
    self.errorhandler(self, exc, value)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
django.db.utils.OperationalError: (2013, 'Lost connection to MySQL server during query')

а при второй попытке уже

(okt)root@crackkc:/var/www/oktyabr/oktyabr# python manage.py syncdb
Traceback (most recent call last):
  File "manage.py", line 10, in <module>
    execute_from_command_line(sys.argv)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 385, in execute_from_command_line
    utility.execute()
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 377, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/core/management/base.py", line 288, in run_from_argv
    self.execute(*args, **options.__dict__)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/core/management/base.py", line 338, in execute
    output = self.handle(*args, **options)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/core/management/base.py", line 533, in handle
    return self.handle_noargs(**options)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/core/management/commands/syncdb.py", line 27, in handle_noargs
    call_command("migrate", **options)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 115, in call_command
    return klass.execute(*args, **defaults)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/core/management/base.py", line 338, in execute
    output = self.handle(*args, **options)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/core/management/commands/migrate.py", line 63, in handle
    executor = MigrationExecutor(connection, self.migration_progress_callback)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/db/migrations/executor.py", line 17, in __init__
    self.loader = MigrationLoader(self.connection)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/db/migrations/loader.py", line 48, in __init__
    self.build_graph()
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/db/migrations/loader.py", line 183, in build_graph
    self.applied_migrations = recorder.applied_migrations()
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/db/migrations/recorder.py", line 59, in applied_migrations
    self.ensure_schema()
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/db/migrations/recorder.py", line 49, in ensure_schema
    if self.Migration._meta.db_table in self.connection.introspection.get_table_list(self.connection.cursor()):
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/db/backends/__init__.py", line 165, in cursor
    cursor = self.make_debug_cursor(self._cursor())
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/db/backends/__init__.py", line 138, in _cursor
    self.ensure_connection()
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/db/backends/__init__.py", line 133, in ensure_connection
    self.connect()
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/db/utils.py", line 94, in __exit__
    six.reraise(dj_exc_type, dj_exc_value, traceback)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/db/backends/__init__.py", line 133, in ensure_connection
    self.connect()
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/db/backends/__init__.py", line 122, in connect
    self.connection = self.get_new_connection(conn_params)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py", line 472, in get_new_connection
    conn = Database.connect(**conn_params)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/MySQLdb/__init__.py", line 81, in Connect
    return Connection(*args, **kwargs)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 193, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
django.db.utils.OperationalError: (2003, "Can't connect to MySQL server on '127.0.0.1' (111)")
(okt)root@crackkc:/var/www/oktyabr/oktyabr#

из этого можно предположить что логин и пароль записаны верно, так как одну таблицу syncdb записывает, только почему он перестает писать дальше, не понятно

Answer | 0

11 Aug. 2015, 16:11 wdstrm Posts: 834	11 Aug. 2015, 16:11 wdstrm Posts: 834 хз даже. что-то с коннектом, возможно. Или с запросом. рекомендую почитать сначала в каких случая мускул возвращает такой ответ 71% добра
	Answer \| 0

11 Aug. 2015, 16:12 lampslave Posts: 517	11 Aug. 2015, 16:12 lampslave Posts: 517 mysql запущен? Все настройки правильные?
	Answer \| 0

11 Aug. 2015, 16:26

serrrgggeee1

Posts: 91
Location: Волгоград

11 Aug. 2015, 16:26

serrrgggeee1

Posts: 91
Location: Волгоград

в общем говоря, у меня сервак на нем поднят nginx и есть сайт на php, теперь я настраиваю там сайт на django через wsgi и venv, думаю конфликт в этом, теперь все файлы которые я создавал я закаментил, но все равно остается такая фигня, если я допустим ввиду myanage.py runserver не в виртуальном окружении то полезут ошибки что django.core не найдена, а щас хоть в виртуальном хоть не виртуальном окружении все библиотеки находятся, как будто закешировались

Answer | 0

11 Aug. 2015, 16:35

N.E.M

Posts: 1262

11 Aug. 2015, 16:35

N.E.M

Posts: 1262

Прекратить панику!

Сайты на php и на питоне прекрасно уживаются на одном сервере за одним nginx'ом с одним mysql'ем.

А вот настройки mysql проверить стоит. На предмет хотя бы чего-то такого:

skip-networking
bind-address = 127.0.0.1

И сравнить со значением DATABASES['default']["HOST'] из settings.py

Answer | 0

11 Aug. 2015, 16:45 serrrgggeee1 Posts: 91 Location: Волгоград	11 Aug. 2015, 16:45 serrrgggeee1 Posts: 91 Location: Волгоград вы имеете в виду это `mysql> skip-networking -> bind-address = 127.0.0.1`
	Answer \| 0

11 Aug. 2015, 16:49 N.E.M Posts: 1262	11 Aug. 2015, 16:49 N.E.M Posts: 1262 я имею в виду посмотреть на наличие таких строк в my.cnf
	Answer \| 0

11 Aug. 2015, 17:00

serrrgggeee1

Posts: 91
Location: Волгоград

11 Aug. 2015, 17:00

serrrgggeee1

Posts: 91
Location: Волгоград

(okt)root@crackkc:/var/www/oktyabr/oktyabr# cat /etc/mysql/my.cnf
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
# 
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0

[mysqld]
#
# * Basic Settings
#
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address            = 127.0.0.1
#
# * Fine Tuning
#
key_buffer              = 16M
max_allowed_packet      = 16M
thread_stack            = 192K
thread_cache_size       = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover-options  = BACKUP
#max_connections        = 100
#table_cache            = 64
#thread_concurrency     = 10
#
# * Query Cache Configuration
#
query_cache_limit       = 1M
query_cache_size        = 16M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# As of 5.1 you can enable the log at runtime!
#general_log_file        = /var/log/mysql/mysql.log
#general_log             = 1
#
# Error log - should be very few entries.
#
log_error = /var/log/mysql/error.log
#
# Here you can see queries with especially long duration
#slow_query_log = 1
#slow_query_log_file = /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
#       other settings you may need to change.
#server-id              = 1
#log_bin                        = /var/log/mysql/mysql-bin.log
expire_logs_days        = 10
max_binlog_size         = 100M
#binlog_do_db           = include_database_name
#binlog_ignore_db       = include_database_name
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem



[mysqldump]
quick
quote-names
max_allowed_packet      = 16M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
key_buffer              = 16M

#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/
(okt)root@crackkc:/var/www/oktyabr/oktyabr#

Answer | 0

12 Aug. 2015, 18:02 serzh_0111_1100_1001 Posts: 18	12 Aug. 2015, 18:02 serzh_0111_1100_1001 Posts: 18 Непонятный конфиг, mysql работает через сокет или через сеть?
	Answer \| 0

13 Aug. 2015, 8:13 serrrgggeee1 Posts: 91 Location: Волгоград	13 Aug. 2015, 8:13 serrrgggeee1 Posts: 91 Location: Волгоград это виртуальная машина
	Answer \| 0

13 Aug. 2015, 17:39 tima-savelyev Posts: 25 Location: Kiev	13 Aug. 2015, 17:39 tima-savelyev Posts: 25 Location: Kiev Виртуальная машина Java, а SQL-server в сети? Ну и что! все равно должно работать как обычно
	Answer \| 0

20 Aug. 2015, 16:58

serrrgggeee1

Posts: 91
Location: Волгоград

20 Aug. 2015, 16:58

serrrgggeee1

Posts: 91
Location: Волгоград

должно но не работает не могу разобраться. Описываю еще раз, у меня стоит nginx на вертуальной машине debian, здесь же mysql. Есть два сайта один php, этот сайт работает нормально. но как только запускается uwsgi то вот что я имею

root@crackkc:~# uwsgi --ini /var/www/oktyabr/oktyabr/mysite_uwsgi.ini
[uWSGI] getting INI configuration from /var/www/oktyabr/oktyabr/mysite_uwsgi.ini
*** Starting uWSGI 2.0.11.1 (32bit) on [Thu Aug 20 09:55:10 2015] ***
compiled with version: 4.7.2 on 11 August 2015 03:03:03
os: Linux-2.6.32-042stab108.2 #1 SMP Tue May 12 18:07:50 MSK 2015
nodename: crackkc
machine: i686
clock source: unix
detected number of CPU cores: 1
current working directory: /root
detected binary path: /usr/local/bin/uwsgi
!!! no internal routing support, rebuild with pcre support !!!
uWSGI running as root, you can use --uid/--gid/--chroot options
*** WARNING: you are running uWSGI as root !!! (use the --uid flag) *** 
chdir() to /var/www/oktyabr/oktyabr
your processes number limit is 513280
your memory page size is 4096 bytes
detected max file descriptor number: 1024
lock engine: pthread robust mutexes
thunder lock: disabled (you can enable it with --thunder-lock)
uwsgi socket 0 bound to UNIX address /var/www/oktyabr/oktyabr/mysite.sock fd 3
Python version: 2.7.3 (default, Mar 14 2014, 12:14:27)  [GCC 4.7.2]
Set PythonHome to /var/www/oktyabr/okt
*** Python threads support is disabled. You can enable it with --enable-threads ***
Python main interpreter initialized at 0x9bafa88
your server socket listen backlog is limited to 100 connections
your mercy for graceful operations on workers is 60 seconds
mapped 703868 bytes (687 KB) for 10 cores
*** Operational MODE: preforking ***
WSGI app 0 (mountpoint='') ready in 1 seconds on interpreter 0x9bafa88 pid: 3089 (default app)
*** uWSGI is running in multiple interpreter mode ***
spawned uWSGI master process (pid: 3089)
spawned uWSGI worker 1 (pid: 3094, cores: 1)
spawned uWSGI worker 2 (pid: 3095, cores: 1)
spawned uWSGI worker 3 (pid: 3096, cores: 1)
spawned uWSGI worker 4 (pid: 3097, cores: 1)
spawned uWSGI worker 5 (pid: 3098, cores: 1)
spawned uWSGI worker 6 (pid: 3099, cores: 1)
spawned uWSGI worker 7 (pid: 3100, cores: 1)
spawned uWSGI worker 8 (pid: 3101, cores: 1)
spawned uWSGI worker 9 (pid: 3102, cores: 1)
spawned uWSGI worker 10 (pid: 3103, cores: 1)
[pid: 3096|app: 0|req: 1/1] 94.233.44.174 () {44 vars in 864 bytes} [Thu Aug 20 16:55:21 2015] GET /ru/ => generated 120681 bytes in 824 msecs (HTTP/1.1 500) 4 headers in 128 bytes (1 switches on core 0)
Traceback (most recent call last):
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/core/handlers/wsgi.py", line 168, in __call__
    self.load_middleware()
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/core/handlers/base.py", line 46, in load_middleware
    mw_instance = mw_class()
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/middleware/locale.py", line 23, in __init__
    for url_pattern in get_resolver(None).url_patterns:
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/core/urlresolvers.py", line 372, in url_patterns
    patterns = getattr(self.urlconf_module, "urlpatterns", self.urlconf_module)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/core/urlresolvers.py", line 366, in urlconf_module
    self._urlconf_module = import_module(self.urlconf_name)
  File "/usr/lib/python2.7/importlib/__init__.py", line 37, in import_module
    __import__(name)
  File "./mysite/urls.py", line 12, in <module>
    url(r'^admin/', include(admin.site.urls)),  # NOQA
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/contrib/admin/sites.py", line 262, in urls
    return self.get_urls(), self.app_name, self.name
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/contrib/admin/sites.py", line 246, in get_urls
    url(r'^%s/%s/' % (model._meta.app_label, model._meta.model_name), include(model_admin.urls))
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/contrib/admin/options.py", line 598, in urls
    return self.get_urls()
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/cms/admin/pageadmin.py", line 139, in get_urls
    url_patterns += super(PageAdmin, self).get_urls()
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/cms/admin/placeholderadmin.py", line 121, in get_urls
    from cms.urls import SLUG_REGEXP
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/cms/urls.py", line 20, in <module>
    urlpatterns = get_app_patterns()
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/cms/appresolver.py", line 196, in get_app_patterns
    current_site = Site.objects.get_current()
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/contrib/sites/models.py", line 54, in get_current
    current_site = self.get(pk=sid)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/db/models/manager.py", line 92, in manager_method
    return getattr(self.get_queryset(), name)(*args, **kwargs)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/db/models/query.py", line 351, in get
    num = len(clone)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/db/models/query.py", line 122, in __len__
    self._fetch_all()
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/db/models/query.py", line 966, in _fetch_all
    self._result_cache = list(self.iterator())
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/db/models/query.py", line 265, in iterator
    for row in compiler.results_iter():
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 701, in results_iter
    for rows in self.execute_sql(MULTI):
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 785, in execute_sql
    cursor = self.connection.cursor()
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/db/backends/__init__.py", line 165, in cursor
    cursor = self.make_debug_cursor(self._cursor())
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/db/backends/__init__.py", line 138, in _cursor
    self.ensure_connection()
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/db/backends/__init__.py", line 133, in ensure_connection
    self.connect()
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/db/utils.py", line 94, in __exit__
    six.reraise(dj_exc_type, dj_exc_value, traceback)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/db/backends/__init__.py", line 133, in ensure_connection
    self.connect()
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/db/backends/__init__.py", line 122, in connect
    self.connection = self.get_new_connection(conn_params)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py", line 472, in get_new_connection
    conn = Database.connect(**conn_params)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/MySQLdb/__init__.py", line 81, in Connect
    return Connection(*args, **kwargs)
  File "/var/www/oktyabr/okt/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 193, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
django.db.utils.OperationalError: (2002, "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)")
[pid: 3103|app: 0|req: 1/2] 94.233.44.174 () {44 vars in 864 bytes} [Thu Aug 20 16:55:32 2015] GET /ru/ => generated 0 bytes in 29 msecs (HTTP/1.1 500) 0 headers in 0 bytes (0 switches on core 0)

вот логи мускула

root@crackkc:~# cat /var/log/mysql/mysql.log   
/usr/sbin/mysqld, Version: 5.6.25-1~dotdeb+7.1-log ((Debian)). started with:
Tcp port: 3306  Unix socket: /var/run/mysqld/mysqld.sock
Time                 Id Command    Argument
150820  8:54:32     1 Connect   debian-sys-maint@localhost on 
                    1 Quit
                    2 Connect   debian-sys-maint@localhost on mysql
                    2 Query     select @@version_comment limit 1
                    2 Query     SET SQL_LOG_BIN=0
                    2 Query     show variables like 'datadir'
                    2 Quit
                    3 Connect   debian-sys-maint@localhost on 
                    3 Query     select @@version_comment limit 1
                    3 Query     SELECT count(*) FROM mysql.user WHERE user='root' and password=''
                    3 Quit
                    4 Connect   debian-sys-maint@localhost on 
                    4 Query     select @@version_comment limit 1
                    4 Query     select concat('select count(*) into @discard from `',
                    TABLE_SCHEMA, '`.`', TABLE_NAME, '`') 
      from information_schema.TABLES where ENGINE='MyISAM'
                    4 Quit
                    5 Connect   debian-sys-maint@localhost on 
                    5 Query     select @@version_comment limit 1
                    5 Query     select count(*) into @discard from `information_schema`.`COLUMNS`
                    5 Quit
                    6 Connect   debian-sys-maint@localhost on 
                    6 Query     select @@version_comment limit 1
                    6 Query     select count(*) into @discard from `information_schema`.`EVENTS`
                    6 Quit
                    7 Connect   debian-sys-maint@localhost on 
                    7 Query     select @@version_comment limit 1
                    7 Query     select count(*) into @discard from `information_schema`.`OPTIMIZER_TRACE`
                    7 Quit
                    8 Connect   debian-sys-maint@localhost on 
                    8 Query     select @@version_comment limit 1
                    8 Query     select count(*) into @discard from `information_schema`.`PARAMETERS`
                    8 Quit
                    9 Connect   debian-sys-maint@localhost on 
                    9 Query     select @@version_comment limit 1
                    9 Query     select count(*) into @discard from `information_schema`.`PARTITIONS`
                    9 Quit
                   10 Connect   debian-sys-maint@localhost on 
                   10 Query     select @@version_comment limit 1
                   10 Query     select count(*) into @discard from `information_schema`.`PLUGINS`
                   10 Quit
                   11 Connect   debian-sys-maint@localhost on 
                   11 Query     select @@version_comment limit 1
                   11 Query     select count(*) into @discard from `information_schema`.`PROCESSLIST`
                   11 Quit
                   12 Connect   debian-sys-maint@localhost on 
                   12 Query     select @@version_comment limit 1
                   12 Query     select count(*) into @discard from `information_schema`.`ROUTINES`
                   12 Quit
                   13 Connect   debian-sys-maint@localhost on 
                   13 Query     select @@version_comment limit 1
                   13 Query     select count(*) into @discard from `information_schema`.`TRIGGERS`
                   13 Quit
                   14 Connect   debian-sys-maint@localhost on 
                   14 Query     select @@version_comment limit 1
                   14 Query     select count(*) into @discard from `information_schema`.`VIEWS`
                   14 Quit
                   15 Connect   debian-sys-maint@localhost on 
                   15 Query     select @@version_comment limit 1
                   15 Query     select count(*) into @discard from `mysql`.`columns_priv`
                   15 Quit
                   16 Connect   debian-sys-maint@localhost on 
                   16 Query     select @@version_comment limit 1
                   16 Query     select count(*) into @discard from `mysql`.`db`
                   16 Quit
                   17 Connect   debian-sys-maint@localhost on 
                   17 Query     select @@version_comment limit 1
                   17 Query     select count(*) into @discard from `mysql`.`event`
                   17 Quit
                   18 Connect   debian-sys-maint@localhost on 
                   18 Query     select @@version_comment limit 1
                   18 Query     select count(*) into @discard from `mysql`.`func`
                   18 Quit
                   19 Connect   debian-sys-maint@localhost on 
                   19 Query     select @@version_comment limit 1
                   19 Query     select count(*) into @discard from `mysql`.`help_category`
                   19 Quit
                   20 Connect   debian-sys-maint@localhost on 
                   20 Query     select @@version_comment limit 1
                   20 Query     select count(*) into @discard from `mysql`.`help_keyword`
                   20 Quit
                   21 Connect   debian-sys-maint@localhost on 
                   21 Query     select @@version_comment limit 1
                   21 Query     select count(*) into @discard from `mysql`.`help_relation`
                   21 Quit
                   22 Connect   debian-sys-maint@localhost on 
                   22 Query     select @@version_comment limit 1
                   22 Query     select count(*) into @discard from `mysql`.`help_topic`
                   22 Quit
                   23 Connect   debian-sys-maint@localhost on 
                   23 Query     select @@version_comment limit 1
                   23 Query     select count(*) into @discard from `mysql`.`ndb_binlog_index`
                   23 Quit
                   24 Connect   debian-sys-maint@localhost on 
                   24 Query     select @@version_comment limit 1
                   24 Query     select count(*) into @discard from `mysql`.`plugin`
                   24 Quit
                   25 Connect   debian-sys-maint@localhost on 
                   25 Query     select @@version_comment limit 1
                   25 Query     select count(*) into @discard from `mysql`.`proc`
                   25 Quit
                   26 Connect   debian-sys-maint@localhost on 
                   26 Query     select @@version_comment limit 1
                   26 Query     select count(*) into @discard from `mysql`.`procs_priv`
                   26 Quit
                   27 Connect   debian-sys-maint@localhost on 
                   27 Query     select @@version_comment limit 1
                   27 Query     select count(*) into @discard from `mysql`.`proxies_priv`
                   27 Quit
                   28 Connect   debian-sys-maint@localhost on 
                   28 Query     select @@version_comment limit 1
                   28 Query     select count(*) into @discard from `mysql`.`servers`
                   28 Quit
                   29 Connect   debian-sys-maint@localhost on 
                   29 Query     select @@version_comment limit 1
                   29 Query     select count(*) into @discard from `mysql`.`tables_priv`
                   29 Quit
                   30 Connect   debian-sys-maint@localhost on 
                   30 Query     select @@version_comment limit 1
                   30 Query     select count(*) into @discard from `mysql`.`time_zone`
                   30 Quit
                   31 Connect   debian-sys-maint@localhost on 
                   31 Query     select @@version_comment limit 1
                   31 Query     select count(*) into @discard from `mysql`.`time_zone_leap_second`
                   31 Quit
                   32 Connect   debian-sys-maint@localhost on 
                   32 Query     select @@version_comment limit 1
                   32 Query     select count(*) into @discard from `mysql`.`time_zone_name`
                   32 Quit
                   33 Connect   debian-sys-maint@localhost on 
                   33 Query     select @@version_comment limit 1
                   33 Query     select count(*) into @discard from `mysql`.`time_zone_transition`
                   33 Quit
                   34 Connect   debian-sys-maint@localhost on 
                   34 Query     select @@version_comment limit 1
                   34 Query     select count(*) into @discard from `mysql`.`time_zone_transition_type`
                   34 Quit
                   35 Connect   debian-sys-maint@localhost on 
                   35 Query     select @@version_comment limit 1
                   35 Query     select count(*) into @discard from `mysql`.`user`
                   35 Quit
                   36 Connect   debian-sys-maint@localhost on 
                   36 Query     select @@version_comment limit 1
                   36 Query     select count(*) into @discard from `niws`.`catalog`
                   36 Quit
                   37 Connect   debian-sys-maint@localhost on 
                   37 Query     select @@version_comment limit 1
                   37 Query     select count(*) into @discard from `niws`.`comments`
                   37 Quit
                   38 Connect   debian-sys-maint@localhost on 
                   38 Query     select @@version_comment limit 1
                   38 Query     select count(*) into @discard from `niws`.`content`
                   38 Quit
                   39 Connect   debian-sys-maint@localhost on 
                   39 Query     select @@version_comment limit 1
                   39 Query     select count(*) into @discard from `niws`.`forum`
                   39 Quit
                   40 Connect   debian-sys-maint@localhost on 
                   40 Query     select @@version_comment limit 1
                   40 Query     select count(*) into @discard from `niws`.`mail`
                   40 Quit
                   41 Connect   debian-sys-maint@localhost on 
                   41 Query     select @@version_comment limit 1
                   41 Query     select count(*) into @discard from `niws`.`menu`
                   41 Quit
                   42 Connect   debian-sys-maint@localhost on 
                   42 Query     select @@version_comment limit 1
                   42 Query     select count(*) into @discard from `niws`.`news`
                   42 Quit
                   43 Connect   debian-sys-maint@localhost on 
                   43 Query     select @@version_comment limit 1
                   43 Query     select count(*) into @discard from `niws`.`pages`
                   43 Quit
                   44 Connect   debian-sys-maint@localhost on 
                   44 Query     select @@version_comment limit 1
                   44 Query     select count(*) into @discard from `niws`.`user_admin`
                   44 Quit
                   45 Connect   debian-sys-maint@localhost on 
                   45 Query     select @@version_comment limit 1
                   45 Query     select count(*) into @discard from `phpmyadmin`.`pma_bookmark`
                   45 Quit
                   46 Connect   debian-sys-maint@localhost on 
                   46 Query     select @@version_comment limit 1
                   46 Query     select count(*) into @discard from `phpmyadmin`.`pma_column_info`
                   46 Quit
                   47 Connect   debian-sys-maint@localhost on 
                   47 Query     select @@version_comment limit 1
                   47 Query     select count(*) into @discard from `phpmyadmin`.`pma_designer_coords`
                   47 Quit
                   48 Connect   debian-sys-maint@localhost on 
                   48 Query     select @@version_comment limit 1
                   48 Query     select count(*) into @discard from `phpmyadmin`.`pma_history`
                   48 Quit
                   49 Connect   debian-sys-maint@localhost on 
                   49 Query     select @@version_comment limit 1
                   49 Query     select count(*) into @discard from `phpmyadmin`.`pma_pdf_pages`
                   49 Quit
                   50 Connect   debian-sys-maint@localhost on 
                   50 Query     select @@version_comment limit 1
                   50 Query     select count(*) into @discard from `phpmyadmin`.`pma_relation`
                   50 Quit
                   51 Connect   debian-sys-maint@localhost on 
                   51 Query     select @@version_comment limit 1
                   51 Query     select count(*) into @discard from `phpmyadmin`.`pma_table_coords`
                   51 Quit
                   52 Connect   debian-sys-maint@localhost on 
                   52 Query     select @@version_comment limit 1
                   52 Query     select count(*) into @discard from `phpmyadmin`.`pma_table_info`
                   52 Quit
                   53 Connect   debian-sys-maint@localhost on 
                   53 Query     select @@version_comment limit 1
                   53 Query     select count(*) into @discard from `phpmyadmin`.`pma_tracking`
                   53 Quit
                   54 Connect   debian-sys-maint@localhost on 
                   54 Query     select @@version_comment limit 1
                   54 Query     select count(*) into @discard from `phpmyadmin`.`pma_userconfig`
                   54 Quit
150820  8:54:37    55 Connect   root@localhost on 
                   55 Init DB   niws
                   55 Query     SET NAMES utf8
                   55 Query     SELECT *
FROM (`menu`)
WHERE `id` =  '84'
                   55 Query     SELECT *
FROM (`menu`)
WHERE `id_mom` =  '22'
ORDER BY `order` ASC
                   55 Query     SELECT *
FROM (`menu`)
WHERE `id` =  '84'
                   55 Query     SELECT *
FROM (`menu`)
ORDER BY `order` ASC
                   55 Query     SELECT *
FROM (`catalog`)
WHERE `cat` =  '84'
ORDER BY `id` DESC
                   55 Query     SELECT *
FROM (`menu`)
WHERE `url` =  '1'
ORDER BY `order` ASC
150820  8:54:38    56 Connect   root@localhost on 
                   56 Init DB   niws
                   56 Query     SET NAMES utf8
                   56 Query     SELECT *
FROM (`pages`)
WHERE `name` =  'main'
                   56 Query     SELECT *
FROM (`menu`)
ORDER BY `order` ASC
                   56 Query     SELECT *
FROM (`menu`)
WHERE `id_mom` =  '22'
ORDER BY `order` ASC
                   56 Query     SELECT *
FROM (`content`)
WHERE `cat` =  'main'
                   56 Query     SELECT *
FROM (`catalog`)
WHERE `tip_text` =  'history'
ORDER BY `id` DESC
LIMIT 2
                   56 Query     SELECT *
FROM (`catalog`)
WHERE `tip_text` =  'open'
ORDER BY `id` DESC
LIMIT 2
                   56 Query     SELECT *
FROM (`catalog`)
WHERE `tip_text` =  'ludi'
ORDER BY `id` DESC
LIMIT 2
150820  8:54:52    57 Connect   root@localhost on oktyabr
                   57 Query     SET NAMES utf8
                   57 Query     set autocommit=0
                   57 Query     set autocommit=1
                   57 Query     SET SQL_AUTO_IS_NULL = 0
                   57 Query     SELECT `django_site`.`id`, `django_site`.`domain`, `django_site`.`name` FROM `django_site` WHERE `django_site`.`id` = 1 LIMIT 21
                   57 Query     SELECT `cms_title`.`id`, `cms_title`.`language`, `cms_title`.`title`, `cms_title`.`page_title`, `cms_title`.`menu_title`, `cms_title`.`meta_description`, `cms_title`.`slug`, `cms_title`.`path`, `cms_title`.`has_url_overwrite`, `cms_title`.`redirect`, `cms_title`.`page_id`, `cms_title`.`creation_date`, `cms_title`.`published`, `cms_title`.`publisher_is_draft`, `cms_title`.`publisher_public_id`, `cms_title`.`publisher_state`, `cms_page`.`id`, `cms_page`.`path`, `cms_page`.`depth`, `cms_page`.`numchild`, `cms_page`.`created_by`, `cms_page`.`changed_by`, `cms_page`.`parent_id`, `cms_page`.`creation_date`, `cms_page`.`changed_date`, `cms_page`.`publication_date`, `cms_page`.`publication_end_date`, `cms_page`.`in_navigation`, `cms_page`.`soft_root`, `cms_page`.`reverse_id`, `cms_page`.`navigation_extenders`, `cms_page`.`template`, `cms_page`.`site_id`, `cms_page`.`login_required`, `cms_page`.`limit_visibility_in_menu`, `cms_page`.`is_home`, `cms_page`.`application_urls`, `cms_page`.`application_namespace`, `cms_page`.`publisher_is_draft`, `cms_page`.`publisher_public_id`, `cms_page`.`languages`, `cms_page`.`revision_id`, `cms_page`.`xframe_options`, `django_site`.`id`, `django_site`.`domain`, `django_site`.`name` FROM `cms_title` INNER JOIN `cms_page` ON ( `cms_title`.`page_id` = `cms_page`.`id` ) INNER JOIN `django_site` ON ( `cms_page`.`site_id` = `django_site`.`id` ) WHERE (`cms_title`.`publisher_is_draft` = 0 AND `cms_title`.`published` = 1 AND `cms_page`.`site_id` = 1 AND NOT (`cms_page`.`application_urls` IS NULL) AND NOT (`cms_page`.`application_urls` = '' AND `cms_page`.`application_urls` IS NOT NULL)) ORDER BY `cms_page`.`path` DESC
                   57 Quit
                   58 Connect   root@localhost on oktyabr
                   58 Query     SET NAMES utf8
                   58 Query     set autocommit=0
                   58 Query     set autocommit=1
                   58 Query     SET SQL_AUTO_IS_NULL = 0
                   58 Query     SELECT `django_session`.`session_key`, `django_session`.`session_data`, `django_session`.`expire_date` FROM `django_session` WHERE (`django_session`.`session_key` = 'cauonm8p1qo8nz1w5qsq3brx0qv8dmsp' AND `django_session`.`expire_date` > '2015-08-20 12:54:52') LIMIT 21
                   58 Query     SELECT `cms_page`.`id`, `cms_page`.`path`, `cms_page`.`depth`, `cms_page`.`numchild`, `cms_page`.`created_by`, `cms_page`.`changed_by`, `cms_page`.`parent_id`, `cms_page`.`creation_date`, `cms_page`.`changed_date`, `cms_page`.`publication_date`, `cms_page`.`publication_end_date`, `cms_page`.`in_navigation`, `cms_page`.`soft_root`, `cms_page`.`reverse_id`, `cms_page`.`navigation_extenders`, `cms_page`.`template`, `cms_page`.`site_id`, `cms_page`.`login_required`, `cms_page`.`limit_visibility_in_menu`, `cms_page`.`is_home`, `cms_page`.`application_urls`, `cms_page`.`application_namespace`, `cms_page`.`publisher_is_draft`, `cms_page`.`publisher_public_id`, `cms_page`.`languages`, `cms_page`.`revision_id`, `cms_page`.`xframe_options` FROM `cms_page` INNER JOIN `cms_title` ON ( `cms_page`.`id` = `cms_title`.`page_id` ) WHERE (`cms_page`.`publisher_is_draft` = 0 AND `cms_page`.`site_id` = 1 AND (`cms_page`.`publication_date` <= '2015-08-20 12:54:52' OR `cms_page`.`publication_date` IS NULL) AND (`cms_page`.`publication_end_date` > '2015-08-20 12:54:52' OR `cms_page`.`publication_end_date` IS NULL) AND `cms_title`.`published` = 1 AND `cms_page`.`is_home` = 1 AND `cms_page`.`site_id` = 1) ORDER BY `cms_page`.`path` ASC LIMIT 1
                   58 Query     SELECT `cms_title`.`id`, `cms_title`.`language`, `cms_title`.`title`, `cms_title`.`page_title`, `cms_title`.`menu_title`, `cms_title`.`meta_description`, `cms_title`.`slug`, `cms_title`.`path`, `cms_title`.`has_url_overwrite`, `cms_title`.`redirect`, `cms_title`.`page_id`, `cms_title`.`creation_date`, `cms_title`.`published`, `cms_title`.`publisher_is_draft`, `cms_title`.`publisher_public_id`, `cms_title`.`publisher_state` FROM `cms_title` WHERE `cms_title`.`page_id` = 2
                   58 Query     SELECT `cms_page`.`id`, `cms_page`.`path`, `cms_page`.`depth`, `cms_page`.`numchild`, `cms_page`.`created_by`, `cms_page`.`changed_by`, `cms_page`.`parent_id`, `cms_page`.`creation_date`, `cms_page`.`changed_date`, `cms_page`.`publication_date`, `cms_page`.`publication_end_date`, `cms_page`.`in_navigation`, `cms_page`.`soft_root`, `cms_page`.`reverse_id`, `cms_page`.`navigation_extenders`, `cms_page`.`template`, `cms_page`.`site_id`, `cms_page`.`login_required`, `cms_page`.`limit_visibility_in_menu`, `cms_page`.`is_home`, `cms_page`.`application_urls`, `cms_page`.`application_namespace`, `cms_page`.`publisher_is_draft`, `cms_page`.`publisher_public_id`, `cms_page`.`languages`, `cms_page`.`revision_id`, `cms_page`.`xframe_options` FROM `cms_page` WHERE `cms_page`.`publisher_public_id` = 2 LIMIT 21
                   58 Query     SELECT `cms_pagepermission`.`id`, `cms_pagepermission`.`user_id`, `cms_pagepermission`.`group_id`, `cms_pagepermission`.`can_change`, `cms_pagepermission`.`can_add`, `cms_pagepermission`.`can_delete`, `cms_pagepermission`.`can_change_advanced_settings`, `cms_pagepermission`.`can_publish`, `cms_pagepermission`.`can_change_permissions`, `cms_pagepermission`.`can_move_page`, `cms_pagepermission`.`can_view`, `cms_pagepermission`.`grant_on`, `cms_pagepermission`.`page_id` FROM `cms_pagepermission` LEFT OUTER JOIN `cms_page` ON ( `cms_pagepermission`.`page_id` = `cms_page`.`id` ) WHERE (((`cms_pagepermission`.`page_id` IS NULL AND (`cms_pagepermission`.`grant_on` = 2 OR `cms_pagepermission`.`grant_on` = 3)) OR (`cms_pagepermission`.`page_id` = 1 AND (`cms_pagepermission`.`grant_on` = 5 OR `cms_pagepermission`.`grant_on` = 3 OR `cms_pagepermission`.`grant_on` = 1))) AND `cms_pagepermission`.`can_view` = 1) ORDER BY `cms_page`.`depth` ASC
                   58 Query     SELECT `cms_page`.`id`, `cms_page`.`path`, `cms_page`.`depth`, `cms_page`.`numchild`, `cms_page`.`created_by`, `cms_page`.`changed_by`, `cms_page`.`parent_id`, `cms_page`.`creation_date`, `cms_page`.`changed_date`, `cms_page`.`publication_date`, `cms_page`.`publication_end_date`, `cms_page`.`in_navigation`, `cms_page`.`soft_root`, `cms_page`.`reverse_id`, `cms_page`.`navigation_extenders`, `cms_page`.`template`, `cms_page`.`site_id`, `cms_page`.`login_required`, `cms_page`.`limit_visibility_in_menu`, `cms_page`.`is_home`, `cms_page`.`application_urls`, `cms_page`.`application_namespace`, `cms_page`.`publisher_is_draft`, `cms_page`.`publisher_public_id`, `cms_page`.`languages`, `cms_page`.`revision_id`, `cms_page`.`xframe_options` FROM `cms_page` WHERE (`cms_page`.`application_urls` IN ('SliderApp') OR `cms_page`.`navigation_extenders` = 'SliderSubMenu') ORDER BY `cms_page`.`path` ASC
150820  8:54:53    58 Query     SELECT `cms_page`.`id`, `cms_page`.`path`, `cms_page`.`depth`, `cms_page`.`numchild`, `cms_page`.`created_by`, `cms_page`.`changed_by`, `cms_page`.`parent_id`, `cms_page`.`creation_date`, `cms_page`.`changed_date`, `cms_page`.`publication_date`, `cms_page`.`publication_end_date`, `cms_page`.`in_navigation`, `cms_page`.`soft_root`, `cms_page`.`reverse_id`, `cms_page`.`navigation_extenders`, `cms_page`.`template`, `cms_page`.`site_id`, `cms_page`.`login_required`, `cms_page`.`limit_visibility_in_menu`, `cms_page`.`is_home`, `cms_page`.`application_urls`, `cms_page`.`application_namespace`, `cms_page`.`publisher_is_draft`, `cms_page`.`publisher_public_id`, `cms_page`.`languages`, `cms_page`.`revision_id`, `cms_page`.`xframe_options` FROM `cms_page` WHERE (`cms_page`.`application_urls` IN ('StaffApp') OR `cms_page`.`navigation_extenders` = 'StaffSubMenu') ORDER BY `cms_page`.`path` ASC
                   58 Query     SELECT `cms_page`.`id`, `cms_page`.`path`, `cms_page`.`depth`, `cms_page`.`numchild`, `cms_page`.`created_by`, `cms_page`.`changed_by`, `cms_page`.`parent_id`, `cms_page`.`creation_date`, `cms_page`.`changed_date`, `cms_page`.`publication_date`, `cms_page`.`publication_end_date`, `cms_page`.`in_navigation`, `cms_page`.`soft_root`, `cms_page`.`reverse_id`, `cms_page`.`navigation_extenders`, `cms_page`.`template`, `cms_page`.`site_id`, `cms_page`.`login_required`, `cms_page`.`limit_visibility_in_menu`, `cms_page`.`is_home`, `cms_page`.`application_urls`, `cms_page`.`application_namespace`, `cms_page`.`publisher_is_draft`, `cms_page`.`publisher_public_id`, `cms_page`.`languages`, `cms_page`.`revision_id`, `cms_page`.`xframe_options` FROM `cms_page` INNER JOIN `cms_title` ON ( `cms_page`.`id` = `cms_title`.`page_id` ) WHERE (`cms_page`.`publisher_is_draft` = 0 AND `cms_page`.`site_id` = 1 AND (`cms_page`.`publication_date` <= '2015-08-20 12:54:53' OR `cms_page`.`publication_date` IS NULL) AND (`cms_page`.`publication_end_date` > '2015-08-20 12:54:53' OR `cms_page`.`publication_end_date` IS NULL) AND `cms_title`.`published` = 1 AND `cms_page`.`site_id` = 1) ORDER BY `cms_page`.`path` ASC
                   58 Query     SELECT `cms_pagepermission`.`id`, `cms_pagepermission`.`user_id`, `cms_pagepermission`.`group_id`, `cms_pagepermission`.`can_change`, `cms_pagepermission`.`can_add`, `cms_pagepermission`.`can_delete`, `cms_pagepermission`.`can_change_advanced_settings`, `cms_pagepermission`.`can_publish`, `cms_pagepermission`.`can_change_permissions`, `cms_pagepermission`.`can_move_page`, `cms_pagepermission`.`can_view`, `cms_pagepermission`.`grant_on`, `cms_pagepermission`.`page_id`, `auth_group`.`id`, `auth_group`.`name`, `cms_pageusergroup`.`group_ptr_id`, `cms_pageusergroup`.`created_by_id` FROM `cms_pagepermission` LEFT OUTER JOIN `auth_group` ON ( `cms_pagepermission`.`group_id` = `auth_group`.`id` ) LEFT OUTER JOIN `cms_pageusergroup` ON ( `auth_group`.`id` = `cms_pageusergroup`.`group_ptr_id` ) WHERE (`cms_pagepermission`.`page_id` IN (1, 3) AND `cms_pagepermission`.`can_view` = 1)
                   58 Query     SELECT `cms_title`.`id`, `cms_title`.`language`, `cms_title`.`title`, `cms_title`.`page_title`, `cms_title`.`menu_title`, `cms_title`.`meta_description`, `cms_title`.`slug`, `cms_title`.`path`, `cms_title`.`has_url_overwrite`, `cms_title`.`redirect`, `cms_title`.`page_id`, `cms_title`.`creation_date`, `cms_title`.`published`, `cms_title`.`publisher_is_draft`, `cms_title`.`publisher_public_id`, `cms_title`.`publisher_state` FROM `cms_title` WHERE (`cms_title`.`language` IN ('ru') AND `cms_title`.`page_id` IN (2, 4))
/usr/sbin/mysqld, Version: 5.6.25-1~dotdeb+7.1-log ((Debian)). started with:
Tcp port: 3306  Unix socket: /var/run/mysqld/mysqld.sock
Time                 Id Command    Argument
/usr/sbin/mysqld, Version: 5.6.25-1~dotdeb+7.1-log ((Debian)). started with:
Tcp port: 3306  Unix socket: /var/run/mysqld/mysqld.sock
Time                 Id Command    Argument
150820  8:54:55     1 Connect   debian-sys-maint@localhost on 
                    1 Quit
/usr/sbin/mysqld, Version: 5.6.25-1~dotdeb+7.1-log ((Debian)). started with:
Tcp port: 3306  Unix socket: /var/run/mysqld/mysqld.sock
Time                 Id Command    Argument
150820  8:55:01     1 Connect   debian-sys-maint@localhost on 
                    1 Quit
                    2 Connect   debian-sys-maint@localhost on mysql
                    2 Query     select @@version_comment limit 1
                    2 Query     SET SQL_LOG_BIN=0
                    2 Query     show variables like 'datadir'
                    2 Quit
                    3 Connect   debian-sys-maint@localhost on 
                    3 Query     select @@version_comment limit 1
                    3 Query     SELECT count(*) FROM mysql.user WHERE user='root' and password=''
                    3 Quit
                    4 Connect   debian-sys-maint@localhost on 
                    4 Query     select @@version_comment limit 1
                    4 Query     select concat('select count(*) into @discard from `',
                    TABLE_SCHEMA, '`.`', TABLE_NAME, '`') 
      from information_schema.TABLES where ENGINE='MyISAM'
                    4 Quit
                    5 Connect   debian-sys-maint@localhost on 
                    5 Query     select @@version_comment limit 1
                    5 Query     select count(*) into @discard from `information_schema`.`COLUMNS`
                    5 Quit
                    6 Connect   debian-sys-maint@localhost on 
                    6 Query     select @@version_comment limit 1
                    6 Query     select count(*) into @discard from `information_schema`.`EVENTS`
                    6 Quit
                    7 Connect   debian-sys-maint@localhost on 
                    7 Query     select @@version_comment limit 1
                    7 Query     select count(*) into @discard from `information_schema`.`OPTIMIZER_TRACE`
                    7 Quit
                    8 Connect   debian-sys-maint@localhost on 
                    8 Query     select @@version_comment limit 1
                    8 Query     select count(*) into @discard from `information_schema`.`PARAMETERS`
                    8 Quit
                    9 Connect   debian-sys-maint@localhost on 
                    9 Query     select @@version_comment limit 1
                    9 Query     select count(*) into @discard from `information_schema`.`PARTITIONS`
                    9 Quit
                   10 Connect   debian-sys-maint@localhost on 
                   10 Query     select @@version_comment limit 1
                   10 Query     select count(*) into @discard from `information_schema`.`PLUGINS`
                   10 Quit
                   11 Connect   debian-sys-maint@localhost on 
                   11 Query     select @@version_comment limit 1
                   11 Query     select count(*) into @discard from `information_schema`.`PROCESSLIST`
                   11 Quit
                   12 Connect   debian-sys-maint@localhost on 
                   12 Query     select @@version_comment limit 1
                   12 Query     select count(*) into @discard from `information_schema`.`ROUTINES`
                   12 Quit
                   13 Connect   debian-sys-maint@localhost on 
                   13 Query     select @@version_comment limit 1
                   13 Query     select count(*) into @discard from `information_schema`.`TRIGGERS`
150820  8:55:02    13 Quit
                   14 Connect   debian-sys-maint@localhost on 
                   14 Query     select @@version_comment limit 1
                   14 Query     select count(*) into @discard from `information_schema`.`VIEWS`
                   14 Quit
                   15 Connect   debian-sys-maint@localhost on 
                   15 Query     select @@version_comment limit 1
                   15 Query     select count(*) into @discard from `mysql`.`columns_priv`
                   15 Quit
                   16 Connect   debian-sys-maint@localhost on 
                   16 Query     select @@version_comment limit 1
                   16 Query     select count(*) into @discard from `mysql`.`db`
                   16 Quit
                   17 Connect   debian-sys-maint@localhost on 
                   17 Query     select @@version_comment limit 1
                   17 Query     select count(*) into @discard from `mysql`.`event`
                   17 Quit
                   18 Connect   debian-sys-maint@localhost on 
                   18 Query     select @@version_comment limit 1
                   18 Query     select count(*) into @discard from `mysql`.`func`
                   18 Quit
                   19 Connect   debian-sys-maint@localhost on 
                   19 Query     select @@version_comment limit 1
                   19 Query     select count(*) into @discard from `mysql`.`help_category`
                   19 Quit
                   20 Connect   debian-sys-maint@localhost on 
                   20 Query     select @@version_comment limit 1
                   20 Query     select count(*) into @discard from `mysql`.`help_keyword`
                   20 Quit
                   21 Connect   debian-sys-maint@localhost on 
                   21 Query     select @@version_comment limit 1
                   21 Query     select count(*) into @discard from `mysql`.`help_relation`
                   21 Quit
                   22 Connect   debian-sys-maint@localhost on 
                   22 Query     select @@version_comment limit 1
                   22 Query     select count(*) into @discard from `mysql`.`help_topic`
                   22 Quit
                   23 Connect   debian-sys-maint@localhost on 
                   23 Query     select @@version_comment limit 1
                   23 Query     select count(*) into @discard from `mysql`.`ndb_binlog_index`
                   23 Quit
                   24 Connect   debian-sys-maint@localhost on 
                   24 Query     select @@version_comment limit 1
                   24 Query     select count(*) into @discard from `mysql`.`plugin`
                   24 Quit
                   25 Connect   debian-sys-maint@localhost on 
                   25 Query     select @@version_comment limit 1
                   25 Query     select count(*) into @discard from `mysql`.`proc`
                   25 Quit
                   26 Connect   debian-sys-maint@localhost on 
                   26 Query     select @@version_comment limit 1
                   26 Query     select count(*) into @discard from `mysql`.`procs_priv`
                   26 Quit
                   27 Connect   debian-sys-maint@localhost on 
                   27 Query     select @@version_comment limit 1
                   27 Query     select count(*) into @discard from `mysql`.`proxies_priv`
                   27 Quit
                   28 Connect   debian-sys-maint@localhost on 
                   28 Query     select @@version_comment limit 1
                   28 Query     select count(*) into @discard from `mysql`.`servers`
                   28 Quit
                   29 Connect   debian-sys-maint@localhost on 
                   29 Query     select @@version_comment limit 1
                   29 Query     select count(*) into @discard from `mysql`.`tables_priv`
                   29 Quit
                   30 Connect   debian-sys-maint@localhost on 
                   30 Query     select @@version_comment limit 1
                   30 Query     select count(*) into @discard from `mysql`.`time_zone`
                   30 Quit
                   31 Connect   debian-sys-maint@localhost on 
                   31 Query     select @@version_comment limit 1
                   31 Query     select count(*) into @discard from `mysql`.`time_zone_leap_second`
                   31 Quit
                   32 Connect   debian-sys-maint@localhost on 
                   32 Query     select @@version_comment limit 1
                   32 Query     select count(*) into @discard from `mysql`.`time_zone_name`
                   32 Quit
                   33 Connect   debian-sys-maint@localhost on 
                   33 Query     select @@version_comment limit 1
                   33 Query     select count(*) into @discard from `mysql`.`time_zone_transition`
                   33 Quit
                   34 Connect   debian-sys-maint@localhost on 
                   34 Query     select @@version_comment limit 1
                   34 Query     select count(*) into @discard from `mysql`.`time_zone_transition_type`
                   34 Quit
                   35 Connect   debian-sys-maint@localhost on 
                   35 Query     select @@version_comment limit 1
                   35 Query     select count(*) into @discard from `mysql`.`user`
                   35 Quit
                   36 Connect   debian-sys-maint@localhost on 
                   36 Query     select @@version_comment limit 1
                   36 Query     select count(*) into @discard from `niws`.`catalog`
                   36 Quit
                   37 Connect   debian-sys-maint@localhost on 
                   37 Query     select @@version_comment limit 1
                   37 Query     select count(*) into @discard from `niws`.`comments`
                   37 Quit
                   38 Connect   debian-sys-maint@localhost on 
                   38 Query     select @@version_comment limit 1
                   38 Query     select count(*) into @discard from `niws`.`content`
                   38 Quit
                   39 Connect   debian-sys-maint@localhost on 
                   39 Query     select @@version_comment limit 1
                   39 Query     select count(*) into @discard from `niws`.`forum`
                   39 Quit
                   40 Connect   debian-sys-maint@localhost on 
                   40 Query     select @@version_comment limit 1
                   40 Query     select count(*) into @discard from `niws`.`mail`
                   40 Quit
                   41 Connect   debian-sys-maint@localhost on 
                   41 Query     select @@version_comment limit 1
                   41 Query     select count(*) into @discard from `niws`.`menu`
                   41 Quit
                   42 Connect   debian-sys-maint@localhost on 
                   42 Query     select @@version_comment limit 1
                   42 Query     select count(*) into @discard from `niws`.`news`
                   42 Quit
                   43 Connect   debian-sys-maint@localhost on 
                   43 Query     select @@version_comment limit 1
                   43 Query     select count(*) into @discard from `niws`.`pages`
                   43 Quit
                   44 Connect   debian-sys-maint@localhost on 
                   44 Query     select @@version_comment limit 1
                   44 Query     select count(*) into @discard from `niws`.`user_admin`
                   44 Quit
                   45 Connect   debian-sys-maint@localhost on 
                   45 Query     select @@version_comment limit 1
                   45 Query     select count(*) into @discard from `phpmyadmin`.`pma_bookmark`
                   45 Quit
                   46 Connect   debian-sys-maint@localhost on 
                   46 Query     select @@version_comment limit 1
                   46 Query     select count(*) into @discard from `phpmyadmin`.`pma_column_info`
                   46 Quit
                   47 Connect   debian-sys-maint@localhost on 
                   47 Query     select @@version_comment limit 1
                   47 Query     select count(*) into @discard from `phpmyadmin`.`pma_designer_coords`
                   47 Quit
                   48 Connect   debian-sys-maint@localhost on 
                   48 Query     select @@version_comment limit 1
                   48 Query     select count(*) into @discard from `phpmyadmin`.`pma_history`
                   48 Quit
                   49 Connect   debian-sys-maint@localhost on 
                   49 Query     select @@version_comment limit 1
                   49 Query     select count(*) into @discard from `phpmyadmin`.`pma_pdf_pages`
                   49 Quit
                   50 Connect   debian-sys-maint@localhost on 
                   50 Query     select @@version_comment limit 1
                   50 Query     select count(*) into @discard from `phpmyadmin`.`pma_relation`
                   50 Quit
                   51 Connect   debian-sys-maint@localhost on 
                   51 Query     select @@version_comment limit 1
                   51 Query     select count(*) into @discard from `phpmyadmin`.`pma_table_coords`
                   51 Quit
                   52 Connect   debian-sys-maint@localhost on 
                   52 Query     select @@version_comment limit 1
                   52 Query     select count(*) into @discard from `phpmyadmin`.`pma_table_info`
                   52 Quit
                   53 Connect   debian-sys-maint@localhost on 
                   53 Query     select @@version_comment limit 1
                   53 Query     select count(*) into @discard from `phpmyadmin`.`pma_tracking`
                   53 Quit
                   54 Connect   debian-sys-maint@localhost on 
                   54 Query     select @@version_comment limit 1
                   54 Query     select count(*) into @discard from `phpmyadmin`.`pma_userconfig`
                   54 Quit
150820  8:55:05    55 Connect   root@localhost on oktyabr
                   55 Query     SET NAMES utf8
                   55 Query     set autocommit=0
                   55 Query     set autocommit=1
                   55 Query     SET SQL_AUTO_IS_NULL = 0
                   55 Query     SELECT `django_site`.`id`, `django_site`.`domain`, `django_site`.`name` FROM `django_site` WHERE `django_site`.`id` = 1 LIMIT 21
                   55 Query     SELECT `cms_title`.`id`, `cms_title`.`language`, `cms_title`.`title`, `cms_title`.`page_title`, `cms_title`.`menu_title`, `cms_title`.`meta_description`, `cms_title`.`slug`, `cms_title`.`path`, `cms_title`.`has_url_overwrite`, `cms_title`.`redirect`, `cms_title`.`page_id`, `cms_title`.`creation_date`, `cms_title`.`published`, `cms_title`.`publisher_is_draft`, `cms_title`.`publisher_public_id`, `cms_title`.`publisher_state`, `cms_page`.`id`, `cms_page`.`path`, `cms_page`.`depth`, `cms_page`.`numchild`, `cms_page`.`created_by`, `cms_page`.`changed_by`, `cms_page`.`parent_id`, `cms_page`.`creation_date`, `cms_page`.`changed_date`, `cms_page`.`publication_date`, `cms_page`.`publication_end_date`, `cms_page`.`in_navigation`, `cms_page`.`soft_root`, `cms_page`.`reverse_id`, `cms_page`.`navigation_extenders`, `cms_page`.`template`, `cms_page`.`site_id`, `cms_page`.`login_required`, `cms_page`.`limit_visibility_in_menu`, `cms_page`.`is_home`, `cms_page`.`application_urls`, `cms_page`.`application_namespace`, `cms_page`.`publisher_is_draft`, `cms_page`.`publisher_public_id`, `cms_page`.`languages`, `cms_page`.`revision_id`, `cms_page`.`xframe_options`, `django_site`.`id`, `django_site`.`domain`, `django_site`.`name` FROM `cms_title` INNER JOIN `cms_page` ON ( `cms_title`.`page_id` = `cms_page`.`id` ) INNER JOIN `django_site` ON ( `cms_page`.`site_id` = `django_site`.`id` ) WHERE (`cms_title`.`publisher_is_draft` = 0 AND `cms_title`.`published` = 1 AND `cms_page`.`site_id` = 1 AND NOT (`cms_page`.`application_urls` IS NULL) AND NOT (`cms_page`.`application_urls` = '' AND `cms_page`.`application_urls` IS NOT NULL)) ORDER BY `cms_page`.`path` DESC
                   55 Quit
                   56 Connect   root@localhost on oktyabr
                   56 Query     SET NAMES utf8
                   56 Query     set autocommit=0
                   56 Query     set autocommit=1
                   56 Query     SET SQL_AUTO_IS_NULL = 0
                   56 Query     SELECT `django_session`.`session_key`, `django_session`.`session_data`, `django_session`.`expire_date` FROM `django_session` WHERE (`django_session`.`session_key` = 'cauonm8p1qo8nz1w5qsq3brx0qv8dmsp' AND `django_session`.`expire_date` > '2015-08-20 12:55:05') LIMIT 21
/usr/sbin/mysqld, Version: 5.6.25-1~dotdeb+7.1-log ((Debian)). started with:
Tcp port: 3306  Unix socket: /var/run/mysqld/mysqld.sock
Time                 Id Command    Argument
150820  8:55:07     1 Connect   debian-sys-maint@localhost on 
                    1 Quit
/usr/sbin/mysqld, Version: 5.6.25-1~dotdeb+7.1-log ((Debian)). started with:
Tcp port: 3306  Unix socket: /var/run/mysqld/mysqld.sock
Time                 Id Command    Argument
150820  8:55:08     1 Connect   debian-sys-maint@localhost on 
                    1 Quit

гдето конфликт!

Answer | 0