Bug 1678520 (CVE-2019-7164)

Summary:	CVE-2019-7164 python-sqlalchemy: SQL Injection when the order_by parameter can be controlled
Product:	[Other] Security Response	Reporter:	Doran Moppert <dmoppert>
Component:	vulnerability	Assignee:	Red Hat Product Security <security-response-team>
Status:	CLOSED ERRATA	QA Contact:
Severity:	medium	Docs Contact:
Priority:	medium
Version:	unspecified	CC:	apevec, dbecker, dciabrin, hhorak, hvyas, infra-sig, jjoyce, jorton, jschluet, kbasil, lewk, lhh, lpeer, mbacovsk, mbayer, mburns, nphilipp, python-maint, rbarlow, sclewis, sisharma, slinaber
Target Milestone:	---	Keywords:	Security
Target Release:	---
Hardware:	All
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2019-06-10 10:48:12 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:	1674060, 1678523, 1678524, 1678525, 1678526, 1678527, 1678528, 1678530, 1678531, 1678532, 1678533, 1678534, 1678535, 1678734, 1693968, 1693978, 1695754, 1697624
Bug Blocks:	1674063

Description Doran Moppert 2019-02-19 02:04:19 UTC

A vulnerability was found in SQLAlchemy 1.2.17. An SQL Injection when the order_by parameter can be controlled.

Upstream issue:

https://github.com/sqlalchemy/sqlalchemy/issues/4481

Upstream patch:

https://github.com/sqlalchemy/sqlalchemy/commit/30307c4616ad67c01ddae2e1e8e34fabf6028414

Comment 1 Doran Moppert 2019-02-19 02:06:02 UTC

This flaw is related to CVE-2019-7548 (bug 1674059) and is fixed by the same upstream patch.

Comment 2 Doran Moppert 2019-02-19 02:12:16 UTC

This issue has been rated Moderate because it is not common in SQLAlchemy backed applications for the order_by parameter to be populated by an externally-controlled string. The upstream issue has more discussion about safe use of group_by and order_by.

Comment 3 Doran Moppert 2019-02-19 02:20:09 UTC

Created python-sqlalchemy tracking bugs for this issue:

Affects: fedora-all [bug 1674060]

Comment 8 Hardik Vyas 2019-02-20 12:37:18 UTC

Statement:

This issue affects the version of python-sqlalchemy(bundled with calamari-server) shipped with Red Hat Ceph Storage 2, as it can be abused by SQL Injection.

Comment 10 errata-xmlrpc 2019-05-07 04:19:59 UTC

This issue has been addressed in the following products:

  Red Hat Enterprise Linux 8

Via RHSA-2019:0981 https://access.redhat.com/errata/RHSA-2019:0981

Comment 11 errata-xmlrpc 2019-05-07 04:20:32 UTC

This issue has been addressed in the following products:

  Red Hat Enterprise Linux 8

Via RHSA-2019:0984 https://access.redhat.com/errata/RHSA-2019:0984