Bug 1322050 (CVE-2016-3072) - CVE-2016-3072 Katello: Authenticated sql injection via sort_by and sort_order request parameter
Summary: CVE-2016-3072 Katello: Authenticated sql injection via sort_by and sort_order...
Status: CLOSED ERRATA
Alias: CVE-2016-3072
Product: Security Response
Classification: Other
Component: vulnerability
Version: unspecified
Hardware: All
OS: Linux
high
high
Target Milestone: ---
Assignee: Red Hat Product Security
QA Contact:
URL:
Whiteboard: impact=important,public=20160516,repo...
Keywords: Security
Depends On: 1321635 1350803
Blocks: 1322054
TreeView+ depends on / blocked
 
Reported: 2016-03-29 16:05 UTC by Kurt Seifried
Modified: 2019-06-08 21:05 UTC (History)
14 users (show)

(edit)
An input sanitization flaw was found in the scoped search parameters sort_by and sort_order in the REST API. An authenticated user could use this flaw to perform an SQL injection attack on the Katello back end database.
Clone Of:
(edit)
Last Closed: 2016-06-01 19:34:11 UTC


Attachments (Terms of Use)


External Trackers
Tracker ID Priority Status Summary Last Updated
Red Hat Product Errata RHSA-2016:1083 normal SHIPPED_LIVE Important: ruby193-rubygem-katello security update 2016-05-16 23:15:49 UTC

Description Kurt Seifried 2016-03-29 16:05:39 UTC
Description of problem:

The foreman & Katello projects received an upstream notification about the discovery of an authenticated sql injection vulnerability within katello:

Dear Katello/Foreman Team,

During an internal test it was discovered that the scoped search
parameters sort_by and sort_order are vulnerable to an authenticated SQL
injection.

If we access:
https://x.x.x.x/katello/api/v2/organizations/1/sync_plans/1/products?available_for=sync_plan&full_result=true&page=1&search=&sort_by=name&sort_order=ASC'

we will see the following error:

{"displayMessage":"PG::Error: ERROR:  unterminated quoted string at or
near \"', katello_products.id <http://katello_products.id> DESC\"\nLINE
1: ...n_id IS NULL))  ORDER BY katello_products.name
<http://katello_products.name> ASC', katello...\n
                                      ^\n: SELECT \"katello_products\".*
FROM \"katello_products\"  WHERE \"katello_products\".\"id\" IN (SELECT
DISTINCT \"katello_products\".\"id\" FROM \"katello_products\"  WHERE
\"katello_products\".\"organization_id\" = 1 AND (katello_products.id
<http://katello_products.id> in (NULL) or katello_products.id
<http://katello_products.id> in (6,5,4,2,3,1)) AND (sync_plan_id != '1'
OR sync_plan_id IS NULL))  ORDER BY katello_products.name
<http://katello_products.name> ASC', katello_products.id
<http://katello_products.id> DESC","errors":["PG::Error: ERROR:
unterminated quoted string at or near \"', katello_products.id
<http://katello_products.id> DESC\"\nLINE 1: ...n_id IS NULL))  ORDER BY
katello_products.name <http://katello_products.name> ASC', katello...\n


The injection can be exploited as a blind time based injection.

Best Regards
Oliver

External reference:
The line of code in question here is:  https://github.com/Katello/katello/blob/KATELLO-3.0/app/controllers/katello/api/v2/api_controller.rb#L67

Comment 2 errata-xmlrpc 2016-05-16 19:16:04 UTC
This issue has been addressed in the following products:

  Red Hat Satellite 6.1

Via RHSA-2016:1083 https://access.redhat.com/errata/RHSA-2016:1083


Note You need to log in before you can comment on or make changes to this bug.