Project

General

Profile

Bug #25251

non-admin user gets 'PG::AmbiguousColumn: ERROR: column reference "puppet_proxy_id" is ambiguous' when trying to view smart-proxy details

Added by Kevin Carrasco 10 months ago. Updated 10 months ago.

Status:
Need more information
Priority:
Normal
Assignee:
-
Category:
Database
Target version:
-
Difficulty:
Triaged:
No
Bugzilla link:
Pull request:
Team Backlog:
Fixed in Releases:
Found in Releases:

Description

When a user without admin privileges navigates the web UI to Infrastructure -> Smart Proxies -> smart-proxy.example.com
We are getting the following error:

ActionView::Template::Error: external method 'search_by_proxy' failed with error: PG::AmbiguousColumn: ERROR:  column reference "puppet_proxy_id" is ambiguous

Attached production log which shows the SQL query and stack trace.

production.log production.log 21.1 KB Kevin Carrasco, 10/19/2018 07:33 PM
desktop-team-filters.csv desktop-team-filters.csv 4.71 KB Kevin Carrasco, 10/22/2018 06:02 PM

History

#1 Updated by Amit Karsale 10 months ago

need info: what all roles are required for the non-admin user to reproduce the issue.
Tried with roles as :
manager
site manager
view host
viewer

together for a single non-admin user and could not reproduce the issue.

#2 Updated by Amit Karsale 10 months ago

  • Triaged changed from No to Yes

#3 Updated by Lukas Zapletal 10 months ago

  • Triaged changed from Yes to No
  • Status changed from New to Need more information

Thanks Amit, until we confirm a bug/feature let's keep triaged flag off. Setting status to NeedMoreInfo.

Another question: Are you sure you experienced this in 1.9 version? This is unsupported and very old one, is it 1.19 by chance?

#4 Updated by Kevin Carrasco 10 months ago

Lukas, Sorry it is Foreman 1.19, I chose the wrong version previously.

Amit, I Created a custom Role called 'desktop-team'. I've attached a csv file with with all the filters for this role as returned by the following hammer command:

hammer --csv filter list --order 'resource type ASC' --search 'desktop-team'

Thanks.

#5 Updated by Kevin Carrasco 10 months ago

Hi guys,

Is there any more information I can provide to help fix this? I'm open to a remote session as well if it will help in any way.

Thanks.

Also available in: Atom PDF