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"...
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Satellite
Classification: Red Hat
Component: Activation Keys
Version: 6.2.7
Hardware: x86_64
OS: Linux
medium
high
Target Milestone: Unspecified
Assignee: Marek Hulan
QA Contact: Sanket Jagtap
Sanket Jagtap
URL:
Whiteboard:
: 1433048 (view as bug list)
Depends On:
Blocks: 1316897
TreeView+ depends on / blocked
 
Reported: 2017-02-27 18:57 UTC by Rick Dixon
Modified: 2020-12-14 08:15 UTC (History)
10 users (show)

Fixed In Version: tfm-rubygem-katello-3.0.0.138-1.el7sat
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
: 1463813 (view as bug list)
Environment:
Last Closed: 2017-08-10 17:02:29 UTC
Target Upstream Version:
Embargoed:

Attachments (Terms of Use)
perm (36.00 KB, image/png)
2017-07-24 10:17 UTC, Sanket Jagtap 		no flags Details
View All


Links
System ID Private Priority Status Summary Last Updated
Foreman Issue Tracker 18738 0 None None None 2017-03-01 10:17:58 UTC
Red Hat Bugzilla 1433048 1 None None None 2021-01-20 06:05:38 UTC
Red Hat Product Errata RHBA-2017:2466 0 normal SHIPPED_LIVE Satellite 6.2.11 Async Release 2017-08-10 21:01:20 UTC

Internal Links: 1433048

Comment 2 Marek Hulan 2017-03-01 10:14:46 UTC 
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 10:17:56 UTC 
Created redmine issue http://projects.theforeman.org/issues/18738 from this bug
Comment 4 Marek Hulan 2017-03-17 16:19:10 UTC 
*** Bug 1433048 has been marked as a duplicate of this bug. ***
Comment 6 Satellite Program 2017-03-17 18:19:10 UTC 
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 10:17:07 UTC 
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 10:17:52 UTC 
Created attachment 1303549 [details]
perm

Permission with filter
Comment 10 errata-xmlrpc 2017-08-10 17:02:29 UTC 
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.