Project

General

Profile

Actions
Copy link

Bug #7042

closed

exposing DB tables when listing roles via API

Added by Martin Bacovsky over 10 years ago. Updated over 6 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Martin Bacovsky
Category:
API
Target version:
Katello 2.0
Difficulty:
Triaged:
Yes
Bugzilla link:
1102732
Pull request:
Fixed in Releases:
Found in Releases:
Red Hat JIRA:

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
Copy link

Also available in: Atom PDF