должно но не работает не могу разобраться. Описываю еще раз, у меня стоит 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
гдето конфликт!