| Summary: | PGError: ERROR: column reference "name" is ambiguous LINE 1: ...TINCT when clicked on "Environment" link as a non-admin user. | ||
|---|---|---|---|
| Product: | [Retired] CloudForms Cloud Engine | Reporter: | Shveta <ssachdev> |
| Component: | aeolus-conductor | Assignee: | Angus Thomas <athomas> |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | wes hayutin <whayutin> |
| Severity: | unspecified | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | 1.0.0 | CC: | akarol, deltacloud-maint, jprovazn, ssachdev |
| Target Milestone: | rc | ||
| Target Release: | --- | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2012-08-30 17:16:53 UTC | Type: | --- |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
what permission did the non admin user have? If they were default, you should have been denied when clicking the admin tab Permissions were default . You are right when i click on Administer i was denied permission but when i go to Myaccount it goes to Administer tab with all subtabs enabled. adding to ce-sprint-next adding to ce-sprint-next I believe this is same bug as https://bugzilla.redhat.com/show_bug.cgi?id=761504 which is already fixed (commit 003398f4c23ca45d79c6fdd53a1f5ea9001400bd). No error displayed. verified on: [root@dell-pe1950-02 ~]# rpm -qa | grep aeolus aeolus-configure-2.5.0-4.el6.noarch rubygem-aeolus-cli-0.3.0-3.el6.noarch aeolus-conductor-doc-0.8.0-5.el6.noarch aeolus-all-0.8.0-5.el6.noarch aeolus-conductor-daemons-0.8.0-5.el6.noarch rubygem-aeolus-image-0.3.0-2.el6.noarch aeolus-conductor-0.8.0-5.el6.noarch removing verified on-qa from tracker |
Description of problem: Version-Release number of selected component (if applicable): How reproducible: Steps to Reproduce: 1. Create a non-admin user 2. Login as that user 3. Click on Environment PGError: ERROR: column reference "name" is ambiguous LINE 1: ...TINCT ON ("pool_families".id) "pool_families".id, name AS al... ^ : SELECT * FROM (SELECT DISTINCT ON ("pool_families".id) "pool_families".id, name AS alias_0 FROM "pool_families" LEFT OUTER JOIN "permissions" ON "permissions"."permission_object_id" = "pool_families"."id" AND "permissions"."permission_object_type" = 'PoolFamily' LEFT OUTER JOIN "roles" ON "roles"."id" = "permissions"."role_id" LEFT OUTER JOIN "privileges" ON "privileges"."role_id" = "roles"."id" WHERE (permissions.user_id=3 and privileges.target_type='PoolFamily' and privileges.action='view')) AS id_list ORDER BY id_list.alias_0 LIMIT 30 OFFSET 0 Actual results: Expected results: Additional info: rpm -qa|grep aeolus rubygem-aeolus-image-0.2.0-1.el6.noarch rubygem-aeolus-cli-0.2.0-3.el6.noarch aeolus-conductor-doc-0.7.0-4.el6.noarch aeolus-all-0.7.0-4.el6.noarch aeolus-conductor-daemons-0.7.0-4.el6.noarch aeolus-configure-2.4.0-3.el6.noarch aeolus-conductor-0.7.0-4.el6.noarch