Project

General

Profile

Actions

Bug #7042

closed

exposing DB tables when listing roles via API

Added by Martin Bacovsky over 9 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Normal
Category:
API
Target version:
Difficulty:
Triaged:
Yes
Fixed in Releases:
Found in Releases:

Description

Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1102732
Description of problem:
API for listing roles fails with information about the failed database SELECT

Version-Release number of selected component (if applicable):
Satellite-6.0.3-RHEL-6-20140523.0-Satellite-x86_64

How reproducible:
always

Steps to Reproduce:
$ curl -s -H \"Content-Type:application/json\" -H \"Accept:application/json,version=2\" -k -u admin:changeme http://localhost/katello/api/roles?per_page=10

Actual results: {"displayMessage":"PGError: ERROR: column katello_roles.per_page does not exist\nLINE 1: ...ECT \"katello_roles\".* FROM \"katello_roles\" WHERE \"katello_r...\n ^\n: SELECT \"katello_roles\".* FROM \"katello_roles\" WHERE \"katello_roles\".\"per_page\" = '10' AND (type <> 'Katello::UserOwnRole' or type is NULL) ORDER BY katello_roles.name","errors":["PGError: ERROR: column katello_roles.per_page does not exist\nLINE 1: ...ECT \"katello_roles\".* FROM \"katello_roles\" WHERE \"katello_r...\n ^\n: SELECT \"katello_roles\".* FROM \"katello_roles\" WHERE \"katello_roles\".\"per_page\" = '10' AND (type <> 'Katello::UserOwnRole' or type is NULL) ORDER BY katello_roles.name"]}

Expected results:
  • not exposing DB table names like 'katello_roles'
  • return list of roles
Actions #1

Updated by Dominic Cleal over 9 years ago

  • Project changed from Foreman to Katello
  • Category set to API
  • Triaged set to No
Actions #2

Updated by Eric Helms over 9 years ago

  • Status changed from New to Closed
  • Triaged changed from No to Yes

No longer valid after the removal of the old Katello authorization system.

Actions #3

Updated by Eric Helms over 9 years ago

  • translation missing: en.field_release set to 13
Actions

Also available in: Atom PDF