CVE-2019-7548

python-sqlalchemy: SQL Injection when the group_by parameter can be controlled

Severity Score

7.8

*CVSS v3.1

Exploit Likelihood

*EPSS

Affected Versions

*CPE

Public Exploits

*Multiple Sources

Exploited in Wild

*KEV

Decision

*SSVC

Descriptions

SQLAlchemy 1.2.17 has SQL Injection when the group_by parameter can be controlled.

SQLAlchemy 1.2.17 tiene una inyección SQL cuando el parámetro group_by se puede controlar.

*Credits: N/A

CVSS Scores

Attack Vector

Local

Attack Complexity

Low

Privileges Required

None

User Interaction

Required

Scope

Unchanged

Confidentiality

High

Integrity

High

Availability

High

Attack Vector

Network

Attack Complexity

Low

Privileges Required

None

User Interaction

None

Scope

Unchanged

Confidentiality

Low

Integrity

Low

Availability

Low

Attack Vector

Network

Attack Complexity

Medium

Authentication

None

Confidentiality

Partial

Integrity

Partial

Availability

Partial

* Common Vulnerability Scoring System

SSVC

Decision:-

Exploitation

Automatable

Tech. Impact

* Organization's Worst-case Scenario

Timeline

2019-02-06 CVE Reserved
2019-02-06 CVE Published
2024-08-04 CVE Updated
2024-08-04 First Exploit
2024-08-08 EPSS Updated
---------- Exploited in Wild
---------- KEV Due Date

CWE

CWE-89: Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')

CAPEC

References (12)

URL	Tag	Source
https://lists.debian.org/debian-lts-announce/2019/03/msg00020.html	Mailing List
https://lists.debian.org/debian-lts-announce/2021/11/msg00005.html	Mailing List

URL	Date	SRC
https://github.com/no-security/sqlalchemy_test	2024-08-04

URL	Date	SRC
https://github.com/sqlalchemy/sqlalchemy/issues/4481#issuecomment-461204518	2021-11-30
https://www.oracle.com/security-alerts/cpujan2021.html	2021-11-30

URL	Date	SRC
http://lists.opensuse.org/opensuse-security-announce/2019-08/msg00087.html	2021-11-30
http://lists.opensuse.org/opensuse-security-announce/2019-09/msg00010.html	2021-11-30
http://lists.opensuse.org/opensuse-security-announce/2019-09/msg00016.html	2021-11-30
https://access.redhat.com/errata/RHSA-2019:0981	2021-11-30
https://access.redhat.com/errata/RHSA-2019:0984	2021-11-30
https://access.redhat.com/security/cve/CVE-2019-7548	2019-05-07
https://bugzilla.redhat.com/show_bug.cgi?id=1674059	2019-05-07

Affected Vendors, Products, and Versions

Vendor		Product				Version		Other		Status
Vendor	Product	Version	Other	Status	<-- -->	Vendor	Product	Version	Other	Status
Sqlalchemy Search vendor "Sqlalchemy"		Sqlalchemy Search vendor "Sqlalchemy" for product "Sqlalchemy"				1.2.17 Search vendor "Sqlalchemy" for product "Sqlalchemy" and version "1.2.17"		-		Affected
Debian Search vendor "Debian"		Debian Linux Search vendor "Debian" for product "Debian Linux"				8.0 Search vendor "Debian" for product "Debian Linux" and version "8.0"		-		Affected
Debian Search vendor "Debian"		Debian Linux Search vendor "Debian" for product "Debian Linux"				9.0 Search vendor "Debian" for product "Debian Linux" and version "9.0"		-		Affected
Opensuse Search vendor "Opensuse"		Backports Sle Search vendor "Opensuse" for product "Backports Sle"				15.0 Search vendor "Opensuse" for product "Backports Sle" and version "15.0"		-		Affected
Opensuse Search vendor "Opensuse"		Leap Search vendor "Opensuse" for product "Leap"				15.0 Search vendor "Opensuse" for product "Leap" and version "15.0"		-		Affected
Opensuse Search vendor "Opensuse"		Leap Search vendor "Opensuse" for product "Leap"				15.1 Search vendor "Opensuse" for product "Leap" and version "15.1"		-		Affected
Redhat Search vendor "Redhat"		Enterprise Linux Search vendor "Redhat" for product "Enterprise Linux"				8.0 Search vendor "Redhat" for product "Enterprise Linux" and version "8.0"		-		Affected
Redhat Search vendor "Redhat"		Enterprise Linux Eus Search vendor "Redhat" for product "Enterprise Linux Eus"				8.1 Search vendor "Redhat" for product "Enterprise Linux Eus" and version "8.1"		-		Affected
Redhat Search vendor "Redhat"		Enterprise Linux Eus Search vendor "Redhat" for product "Enterprise Linux Eus"				8.2 Search vendor "Redhat" for product "Enterprise Linux Eus" and version "8.2"		-		Affected
Redhat Search vendor "Redhat"		Enterprise Linux Eus Search vendor "Redhat" for product "Enterprise Linux Eus"				8.4 Search vendor "Redhat" for product "Enterprise Linux Eus" and version "8.4"		-		Affected
Redhat Search vendor "Redhat"		Enterprise Linux Server Aus Search vendor "Redhat" for product "Enterprise Linux Server Aus"				8.2 Search vendor "Redhat" for product "Enterprise Linux Server Aus" and version "8.2"		-		Affected
Redhat Search vendor "Redhat"		Enterprise Linux Server Aus Search vendor "Redhat" for product "Enterprise Linux Server Aus"				8.4 Search vendor "Redhat" for product "Enterprise Linux Server Aus" and version "8.4"		-		Affected
Redhat Search vendor "Redhat"		Enterprise Linux Server Tus Search vendor "Redhat" for product "Enterprise Linux Server Tus"				8.2 Search vendor "Redhat" for product "Enterprise Linux Server Tus" and version "8.2"		-		Affected
Redhat Search vendor "Redhat"		Enterprise Linux Server Tus Search vendor "Redhat" for product "Enterprise Linux Server Tus"				8.4 Search vendor "Redhat" for product "Enterprise Linux Server Tus" and version "8.4"		-		Affected
Oracle Search vendor "Oracle"		Communications Operations Monitor Search vendor "Oracle" for product "Communications Operations Monitor"				4.2 Search vendor "Oracle" for product "Communications Operations Monitor" and version "4.2"		-		Affected
Oracle Search vendor "Oracle"		Communications Operations Monitor Search vendor "Oracle" for product "Communications Operations Monitor"				4.3 Search vendor "Oracle" for product "Communications Operations Monitor" and version "4.3"		-		Affected