Issue #6519: Permission issue with the newly created tables in badges - fedora-infrastructure

fedora-infrastructure

#6519 Permission issue with the newly created tables in badges

Closed: Fixed Nov 21, 2017 Opened Nov 21, 2017 by sayanchowdhury.

@nirik migrated new tables in badges
- team
- series
- milestone
The user don't have the appropriate permission to access the tables. Can the access be given to the user tahrir?
[Tue Nov 21 11:30:13.960365 2017] [:error] [pid 29721] [remote 192.168.1.15:35798] Traceback (most recent call last):
[Tue Nov 21 11:30:13.960424 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]   File "/usr/lib/python2.7/site-packages/paste/registry.py", line 379, in __call__
[Tue Nov 21 11:30:13.960509 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]     app_iter = self.application(environ, start_response)
[Tue Nov 21 11:30:13.960534 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]   File "/usr/lib/python2.7/site-packages/moksha/wsgi/middleware/middleware.py", line 76, in __call__
[Tue Nov 21 11:30:13.960578 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]     return self.application(environ, start_response)
[Tue Nov 21 11:30:13.960601 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]   File "/usr/lib/python2.7/site-packages/moksha/wsgi/middleware/extensionpoint.py", line 232, in __call__
[Tue Nov 21 11:30:13.960643 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]     response = request.get_response(self.application)
[Tue Nov 21 11:30:13.960664 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]   File "/usr/lib/python2.7/site-packages/WebOb-1.4.1-py2.7.egg/webob/request.py", line 1317, in send
[Tue Nov 21 11:30:13.960705 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]     application, catch_exc_info=False)
[Tue Nov 21 11:30:13.960726 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]   File "/usr/lib/python2.7/site-packages/WebOb-1.4.1-py2.7.egg/webob/request.py", line 1281, in call_application
[Tue Nov 21 11:30:13.960763 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]     app_iter = application(self.environ, start_response)
[Tue Nov 21 11:30:13.960785 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]   File "/usr/lib/python2.7/site-packages/tw2/core/middleware.py", line 204, in __call__
[Tue Nov 21 11:30:13.960826 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]     resp = req.get_response(self.app, catch_exc_info=True)
[Tue Nov 21 11:30:13.960846 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]   File "/usr/lib/python2.7/site-packages/WebOb-1.4.1-py2.7.egg/webob/request.py", line 1313, in send
[Tue Nov 21 11:30:13.960878 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]     application, catch_exc_info=True)
[Tue Nov 21 11:30:13.960897 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]   File "/usr/lib/python2.7/site-packages/WebOb-1.4.1-py2.7.egg/webob/request.py", line 1281, in call_application
[Tue Nov 21 11:30:13.960930 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]     app_iter = application(self.environ, start_response)
[Tue Nov 21 11:30:13.960998 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]   File "/usr/lib/python2.7/site-packages/paste/deploy/config.py", line 291, in __call__
[Tue Nov 21 11:30:13.961053 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]     return self.app(environ, start_response)
[Tue Nov 21 11:30:13.961074 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]   File "/usr/lib/python2.7/site-packages/pyramid/router.py", line 242, in __call__
[Tue Nov 21 11:30:13.961113 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]     response = self.invoke_subrequest(request, use_tweens=True)
[Tue Nov 21 11:30:13.961138 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]   File "/usr/lib/python2.7/site-packages/pyramid/router.py", line 217, in invoke_subrequest
[Tue Nov 21 11:30:13.961176 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]     response = handle_request(request)
[Tue Nov 21 11:30:13.961223 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]   File "/usr/lib/python2.7/site-packages/pyramid/tweens.py", line 21, in excview_tween
[Tue Nov 21 11:30:13.961273 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]     response = handler(request)
[Tue Nov 21 11:30:13.961295 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]   File "/usr/lib/python2.7/site-packages/pyramid_tm/__init__.py", line 99, in tm_tween
[Tue Nov 21 11:30:13.961336 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]     reraise(*exc_info)
[Tue Nov 21 11:30:13.961358 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]   File "/usr/lib/python2.7/site-packages/pyramid_tm/__init__.py", line 80, in tm_tween
[Tue Nov 21 11:30:13.961410 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]     response = handler(request)
[Tue Nov 21 11:30:13.961432 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]   File "/usr/lib/python2.7/site-packages/pyramid/router.py", line 163, in handle_request
[Tue Nov 21 11:30:13.961469 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]     response = view_callable(context, request)
[Tue Nov 21 11:30:13.961491 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]   File "/usr/lib/python2.7/site-packages/pyramid/config/views.py", line 245, in _secured_view
[Tue Nov 21 11:30:13.961531 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]     return view(context, request)
[Tue Nov 21 11:30:13.961555 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]   File "/usr/lib/python2.7/site-packages/pyramid/config/views.py", line 355, in rendered_view
[Tue Nov 21 11:30:13.961592 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]     result = view(context, request)
[Tue Nov 21 11:30:13.961618 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]   File "/usr/lib/python2.7/site-packages/pyramid/config/views.py", line 501, in _requestonly_view
[Tue Nov 21 11:30:13.961655 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]     response = view(request)
[Tue Nov 21 11:30:13.961676 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]   File "/usr/lib/python2.7/site-packages/tahrir/views.py", line 233, in admin
[Tue Nov 21 11:30:13.961726 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]     if not request.db.team_exists(team_id=team_id):
[Tue Nov 21 11:30:13.961747 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]   File "/usr/lib/python2.7/site-packages/tahrir_api/dbapi.py", line 62, in team_exists
[Tue Nov 21 11:30:13.962444 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]     func.lower(Team.id) == func.lower(team_id)).count() != 0
[Tue Nov 21 11:30:13.962480 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2640, in count
[Tue Nov 21 11:30:13.986578 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]     return self.from_self(col).scalar()
[Tue Nov 21 11:30:13.986676 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2426, in scalar
[Tue Nov 21 11:30:13.986724 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]     ret = self.one()
[Tue Nov 21 11:30:13.986744 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2395, in one
[Tue Nov 21 11:30:13.986760 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]     ret = list(self)
[Tue Nov 21 11:30:13.986769 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2438, in __iter__
[Tue Nov 21 11:30:13.986784 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]     return self._execute_and_instances(context)
[Tue Nov 21 11:30:13.986795 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2453, in _execute_and_instances
[Tue Nov 21 11:30:13.986810 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]     result = conn.execute(querycontext.statement, self._params)
[Tue Nov 21 11:30:13.986831 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 729, in execute
[Tue Nov 21 11:30:14.051669 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]     return meth(self, multiparams, params)
[Tue Nov 21 11:30:14.051743 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]   File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py", line 322, in _execute_on_connection
[Tue Nov 21 11:30:14.059068 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]     return connection._execute_clauseelement(self, multiparams, params)
[Tue Nov 21 11:30:14.059096 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 826, in _execute_clauseelement
[Tue Nov 21 11:30:14.059130 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]     compiled_sql, distilled_params
[Tue Nov 21 11:30:14.059141 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 958, in _execute_context
[Tue Nov 21 11:30:14.059158 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]     context)
[Tue Nov 21 11:30:14.059168 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1159, in _handle_dbapi_exception
[Tue Nov 21 11:30:14.059182 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]     exc_info
[Tue Nov 21 11:30:14.059193 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]   File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
[Tue Nov 21 11:30:14.063720 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]     reraise(type(exception), exception, tb=exc_tb)
[Tue Nov 21 11:30:14.063744 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
[Tue Nov 21 11:30:14.063769 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]     context)
[Tue Nov 21 11:30:14.063781 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 436, in do_execute
[Tue Nov 21 11:30:14.067110 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]     cursor.execute(statement, parameters)
[Tue Nov 21 11:30:14.067242 2017] [:error] [pid 29721] [remote 192.168.1.15:35798] ProgrammingError: (ProgrammingError) permission denied for relation team
[Tue Nov 21 11:30:14.067250 2017] [:error] [pid 29721] [remote 192.168.1.15:35798]  'SELECT count(*) AS count_1 \\nFROM (SELECT team.id AS team_id, team.name AS team_name, team.created_on AS team_created_on \\nFROM team \\nWHERE lower(team.id) = lower(%(lower_1)s)) AS anon_1' {'lower_1': u'infrastructure'}
puiterwijk commented Nov 21, 2017
These permissions should be fixed now.
Metadata Update from @puiterwijk:
- Issue close_status updated to: Fixed
- Issue status updated to: Closed (was: Open)
Nov 21, 2017
Metadata

Assignee
None
Tags
None
Blocking
None
Depending on
None
Priority
None
fedora-infrastructure

#6519 Permission issue with the newly created tables in badges Closed: Fixed Nov 21, 2017 Opened Nov 21, 2017 by sayanchowdhury.

Metadata

#6519 Permission issue with the newly created tables in badges

Closed: Fixed Nov 21, 2017 Opened Nov 21, 2017 by sayanchowdhury.
