Bug 1427282 – PG::Error: ERROR: missing FROM-clause entry for table "katello_environments" when viewing activation keys as a user with customized viewing permissions

Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.

Bug 1427282 - PG::Error: ERROR: missing FROM-clause entry for table "katello_environments" when viewing activation keys as a user with customized viewing permissions

Summary:	PG::Error: ERROR: missing FROM-clause entry for table "katello_environments"...

Status:	CLOSED ERRATA

Aliases:	None

Product:	Red Hat Satellite 6
Classification:	Red Hat
Component:	Activation Keys (Show other bugs)
Sub Component:
Version:	6.2.7
Hardware:	x86_64 Linux

Priority	medium Severity high (vote)
Target Milestone:	6.2.11
Target Release:	Unused
Assigned To:	Marek Hulan
QA Contact:	Sanket Jagtap
Docs Contact:	Sanket Jagtap

URL:
Whiteboard:
Keywords:	Triaged

Duplicates:	1433048 (view as bug list)
Depends On:
Blocks:	1316897
	Show dependency tree / graph

Reported:	2017-02-27 13:57 EST by Rick Dixon
Modified:	2017-12-07 03:17 EST (History)
CC List:	10 users (show)

See Also:	1433048
Fixed In Version:	tfm-rubygem-katello-3.0.0.138-1.el7sat
Doc Type:	If docs needed, set a value
Doc Text:
Story Points:	---
Clone Of:
Clones:	1463813 (view as bug list)
Environment:
Last Closed:	2017-08-10 13:02:29 EDT
Type:	Bug
Regression:	---
Mount Type:	---
Documentation:	---
CRM:
Verified Versions:
Category:	---
oVirt Team:	---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---

Attachments	(Terms of Use)
perm (36.00 KB, image/png) 2017-07-24 06:17 EDT, Sanket Jagtap	no flags	Details
Add an attachment (proposed patch, testcase, etc.)

External Trackers
Tracker	ID	Priority	Status	Summary	Last Updated
Foreman Issue Tracker	18738	None	None	None	2017-03-01 05:17 EST
Red Hat Product Errata	RHBA-2017:2466	normal	SHIPPED_LIVE	Satellite 6.2.11 Async Release	2017-08-10 17:01:20 EDT

Groups: None (edit)

Comment 2 Marek Hulan 2017-03-01 05:14:46 EST

I was able to reproduce on 6.2.8, it's not related to authorization layer. The filters works fine with Katello::ActivationKey.authorized(:view_actiovation_keys). The problem appears when counts of found resources are calculated in generic api controller.

Comment 3 Marek Hulan 2017-03-01 05:17:56 EST

Created redmine issue http://projects.theforeman.org/issues/18738 from this bug

Comment 4 Marek Hulan 2017-03-17 12:19:10 EDT

*** Bug 1433048 has been marked as a duplicate of this bug. ***

Comment 6 pm-sat@redhat.com 2017-03-17 14:19:10 EDT

Moving this bug to POST for triage into Satellite 6 since the upstream issue http://projects.theforeman.org/issues/18738 has been resolved.

Comment 7 Sanket Jagtap 2017-07-24 06:17:07 EDT

Build : Satellite 6.2.11 snap1


1.Created a role with Similar filter mentioned above
2.Created ak with three envs QA, Dev, Production
3.Created filter for view_activation_keys with filter as environment = QA or environment = Dev
Output: This displayed the ak's for QA and Dev Environment

There was no traceback

Comment 8 Sanket Jagtap 2017-07-24 06:17 EDT

Created attachment 1303549 [details]
perm

Permission with filter

Comment 10 errata-xmlrpc 2017-08-10 13:02:29 EDT

Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHBA-2017:2466

Note You need to log in before you can comment on or make changes to this bug.