need enable horizon_backend_database when enabled murano dashboard

Bug #1666618 reported by bjolo
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
kolla-ansible
Fix Released
High
Paul Bourke
Ocata
Fix Released
Undecided
Unassigned

Bug Description

env kolla4 stable/ocata centos source build

Cant login to horizon when murano is enabled. Without murano horizon works great.

[Tue Feb 21 18:23:52.229979 2017] [:error] [pid 19] WARNING:The UpdateAction class defined in module 'horizon.tables.actions' is deprecated as of Newton and may be removed in Horizon P (12.0). Class 'UpdateName' defined at module 'muranodashboard.environments.tables' shall no longer subclass it.
[Tue Feb 21 18:23:52.527314 2017] [:error] [pid 19] Attempted scope to domain default failed, will attemptto scope to another domain.
[Tue Feb 21 18:23:52.849434 2017] [:error] [pid 19] Login successful for user "admin", remote address 10.10.16.32.
[Tue Feb 21 18:23:52.860387 2017] [:error] [pid 19] Internal Server Error: /auth/login/
[Tue Feb 21 18:23:52.860429 2017] [:error] [pid 19] Traceback (most recent call last):
[Tue Feb 21 18:23:52.860444 2017] [:error] [pid 19] File "/var/lib/kolla/venv/lib/python2.7/site-packages/django/core/handlers/base.py", line 132, in get_response
[Tue Feb 21 18:23:52.860468 2017] [:error] [pid 19] response = wrapped_callback(request, *callback_args, **callback_kwargs)
[Tue Feb 21 18:23:52.860483 2017] [:error] [pid 19] File "/var/lib/kolla/venv/lib/python2.7/site-packages/django/views/decorators/debug.py", line 76, in sensitive_post_parameters_wrapper
[Tue Feb 21 18:23:52.860496 2017] [:error] [pid 19] return view(request, *args, **kwargs)
[Tue Feb 21 18:23:52.860513 2017] [:error] [pid 19] File "/var/lib/kolla/venv/lib/python2.7/site-packages/django/utils/decorators.py", line 110, in _wrapped_view
[Tue Feb 21 18:23:52.860526 2017] [:error] [pid 19] response = view_func(request, *args, **kwargs)
[Tue Feb 21 18:23:52.860553 2017] [:error] [pid 19] File "/var/lib/kolla/venv/lib/python2.7/site-packages/django/views/decorators/cache.py", line 57, in _wrapped_view_func
[Tue Feb 21 18:23:52.860577 2017] [:error] [pid 19] response = view_func(request, *args, **kwargs)
[Tue Feb 21 18:23:52.860597 2017] [:error] [pid 19] File "/var/lib/kolla/venv/lib/python2.7/site-packages/openstack_auth/views.py", line 104, in login
[Tue Feb 21 18:23:52.860621 2017] [:error] [pid 19] **kwargs)
[Tue Feb 21 18:23:52.860637 2017] [:error] [pid 19] File "/var/lib/kolla/venv/lib/python2.7/site-packages/django/views/decorators/debug.py", line 76, in sensitive_post_parameters_wrapper
[Tue Feb 21 18:23:52.860650 2017] [:error] [pid 19] return view(request, *args, **kwargs)
[Tue Feb 21 18:23:52.860662 2017] [:error] [pid 19] File "/var/lib/kolla/venv/lib/python2.7/site-packages/django/utils/decorators.py", line 110, in _wrapped_view
[Tue Feb 21 18:23:52.860679 2017] [:error] [pid 19] response = view_func(request, *args, **kwargs)
[Tue Feb 21 18:23:52.860692 2017] [:error] [pid 19] File "/var/lib/kolla/venv/lib/python2.7/site-packages/django/views/decorators/cache.py", line 57, in _wrapped_view_func
[Tue Feb 21 18:23:52.860705 2017] [:error] [pid 19] response = view_func(request, *args, **kwargs)
[Tue Feb 21 18:23:52.860718 2017] [:error] [pid 19] File "/var/lib/kolla/venv/lib/python2.7/site-packages/django/contrib/auth/views.py", line 51, in login
[Tue Feb 21 18:23:52.860729 2017] [:error] [pid 19] auth_login(request, form.get_user())
[Tue Feb 21 18:23:52.860744 2017] [:error] [pid 19] File "/var/lib/kolla/venv/lib/python2.7/site-packages/django/contrib/auth/__init__.py", line 110, in login
[Tue Feb 21 18:23:52.860756 2017] [:error] [pid 19] request.session.cycle_key()
[Tue Feb 21 18:23:52.860768 2017] [:error] [pid 19] File "/var/lib/kolla/venv/lib/python2.7/site-packages/django/contrib/sessions/backends/base.py", line 285, in cycle_key
[Tue Feb 21 18:23:52.860781 2017] [:error] [pid 19] self.create()
[Tue Feb 21 18:23:52.860796 2017] [:error] [pid 19] File "/var/lib/kolla/venv/lib/python2.7/site-packages/django/contrib/sessions/backends/db.py", line 37, in create
[Tue Feb 21 18:23:52.860809 2017] [:error] [pid 19] self._session_key = self._get_new_session_key()
[Tue Feb 21 18:23:52.860822 2017] [:error] [pid 19] File "/var/lib/kolla/venv/lib/python2.7/site-packages/django/contrib/sessions/backends/base.py", line 155, in _get_new_session_key
[Tue Feb 21 18:23:52.860835 2017] [:error] [pid 19] if not self.exists(session_key):
[Tue Feb 21 18:23:52.860848 2017] [:error] [pid 19] File "/var/lib/kolla/venv/lib/python2.7/site-packages/django/contrib/sessions/backends/db.py", line 33, in exists
[Tue Feb 21 18:23:52.860873 2017] [:error] [pid 19] return Session.objects.filter(session_key=session_key).exists()
[Tue Feb 21 18:23:52.860892 2017] [:error] [pid 19] File "/var/lib/kolla/venv/lib/python2.7/site-packages/django/db/models/query.py", line 586, in exists
[Tue Feb 21 18:23:52.860905 2017] [:error] [pid 19] return self.query.has_results(using=self.db)
[Tue Feb 21 18:23:52.860926 2017] [:error] [pid 19] File "/var/lib/kolla/venv/lib/python2.7/site-packages/django/db/models/sql/query.py", line 484, in has_results
[Tue Feb 21 18:23:52.860939 2017] [:error] [pid 19] return compiler.has_results()
[Tue Feb 21 18:23:52.860955 2017] [:error] [pid 19] File "/var/lib/kolla/venv/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 811, in has_results
[Tue Feb 21 18:23:52.860969 2017] [:error] [pid 19] return bool(self.execute_sql(SINGLE))
[Tue Feb 21 18:23:52.860981 2017] [:error] [pid 19] File "/var/lib/kolla/venv/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 840, in execute_sql
[Tue Feb 21 18:23:52.860993 2017] [:error] [pid 19] cursor.execute(sql, params)
[Tue Feb 21 18:23:52.861005 2017] [:error] [pid 19] File "/var/lib/kolla/venv/lib/python2.7/site-packages/django/db/backends/utils.py", line 64, in execute
[Tue Feb 21 18:23:52.861022 2017] [:error] [pid 19] return self.cursor.execute(sql, params)
[Tue Feb 21 18:23:52.861035 2017] [:error] [pid 19] File "/var/lib/kolla/venv/lib/python2.7/site-packages/django/db/utils.py", line 98, in __exit__
[Tue Feb 21 18:23:52.861048 2017] [:error] [pid 19] six.reraise(dj_exc_type, dj_exc_value, traceback)
[Tue Feb 21 18:23:52.861060 2017] [:error] [pid 19] File "/var/lib/kolla/venv/lib/python2.7/site-packages/django/db/backends/utils.py", line 64, in execute
[Tue Feb 21 18:23:52.861073 2017] [:error] [pid 19] return self.cursor.execute(sql, params)
[Tue Feb 21 18:23:52.861086 2017] [:error] [pid 19] File "/var/lib/kolla/venv/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py", line 318, in execute
[Tue Feb 21 18:23:52.861102 2017] [:error] [pid 19] return Database.Cursor.execute(self, query, params)
[Tue Feb 21 18:23:52.861113 2017] [:error] [pid 19] OperationalError: no such table: django_session

Tags: doc
Revision history for this message
Jeffrey Zhang (jeffrey4l) wrote :

we have horizon_backend_database: "no" variable now, please enable this.

I think we need doc for this.

[0] https://github.com/openstack/kolla-ansible/blob/master/ansible/group_vars/all.yml#L487

summary: - horizon murano error: no such table django.session
+ [doc] need enable horizon_backend_database when enabled murano dashboard
tags: added: doc
Changed in kolla-ansible:
status: New → Confirmed
importance: Undecided → High
assignee: nobody → Paul Bourke (pauldbourke)
milestone: none → pike-1
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to kolla-ansible (master)

Reviewed: https://review.openstack.org/445511
Committed: https://git.openstack.org/cgit/openstack/kolla-ansible/commit/?id=b03906dd8baac075458c930b4f9430ed5666b904
Submitter: Jenkins
Branch: master

commit b03906dd8baac075458c930b4f9430ed5666b904
Author: Paul Bourke <email address hidden>
Date: Tue Mar 14 14:15:43 2017 +0000

    Enable horizon_backend_database if murano is enabled

    Change-Id: I0eed4024b4ca86e458d92bd9703fb4a02feee947
    Closes-Bug: #1666618

Changed in kolla-ansible:
status: Confirmed → Fix Released
summary: - [doc] need enable horizon_backend_database when enabled murano dashboard
+ need enable horizon_backend_database when enabled murano dashboard
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to kolla-ansible (stable/ocata)

Reviewed: https://review.openstack.org/445685
Committed: https://git.openstack.org/cgit/openstack/kolla-ansible/commit/?id=bffd75dcc250e137025d17f02afaf9c4612a8c76
Submitter: Jenkins
Branch: stable/ocata

commit bffd75dcc250e137025d17f02afaf9c4612a8c76
Author: Paul Bourke <email address hidden>
Date: Tue Mar 14 14:15:43 2017 +0000

    Enable horizon_backend_database if murano is enabled

    Change-Id: I0eed4024b4ca86e458d92bd9703fb4a02feee947
    Closes-Bug: #1666618
    (cherry picked from commit b03906dd8baac075458c930b4f9430ed5666b904)

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix included in openstack/kolla-ansible 4.0.1

This issue was fixed in the openstack/kolla-ansible 4.0.1 release.

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix included in openstack/kolla-ansible 5.0.0.0b2

This issue was fixed in the openstack/kolla-ansible 5.0.0.0b2 development milestone.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.