CVE-2019-7548
Aliases:GHSA-38fc-9xqv-7f7qPYSEC-2019-124
Advisory lineage Upstream: 0 Downstream: 16
Modified
Published: 06 Feb 2019, 21:00
Last modified:04 Aug 2024, 20:54
Vulnerability Summary
Overall Risk (default)
medium
41/100 CVSS Score
7.8 HIGH
v3.1 (nvd)
EPSS Score
1.09% LOW
1% probability +0.05%
KEV
Not listed
Ransomware
No reports
Public exploits
1 found
Dark Web
Not detected
Timeline
06 Feb 2019, 21:00
Published
Vulnerability first disclosed
04 Aug 2024, 20:54
Last Modified
Vulnerability information updated
Description
SQLAlchemy 1.2.17 has SQL Injection when the group_by parameter can be controlled.
CVSS Metrics
- v4.0•CRITICAL•Score: 9.3CVSS:4.0/AV:N/AC:L/AT:N/PR:N/UI:N/VC:H/VI:H/VA:H/SC:N/SI:N/SA:N
- v3.1•HIGH•Score: 7.8CVSS:3.1/AV:L/AC:L/PR:N/UI:R/S:U/C:H/I:H/A:H
- v3.0•HIGH•Score: 7.8CVSS:3.0/AV:L/AC:L/PR:N/UI:R/S:U/C:H/I:H/A:H
- v2.0•MEDIUM•Score: 6.8AV:N/AC:M/Au:N/C:P/I:P/A:P
EPSS Trends
Current EPSS score: 1.09%• Percentile: 78%
Techniques & Countermeasures
- CWE-89•Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')
The product constructs all or part of an SQL command using externally-influenced input from an upstream component, but it does not neutralize or incorrectly neutralizes special elements that could modify the intended SQL command when it is sent to a downstream component. Without sufficient removal or quoting of SQL syntax in user-controllable inputs, the generated SQL query can cause those inputs to be interpreted as SQL instead of ordinary user data.
Affected Systems
- debian•debian_linux
8.0 | 9.0
- opensuse•backports_sle
15.0
- opensuse•leap
15.0 | 15.1
- oracle•communications_operations_monitor
4.2 | 4.3
- PyPI•sqlalchemy
< 1.2.19 | < 1.2.18
- redhat•enterprise_linux
8.0
- redhat•enterprise_linux_eus
8.1 | 8.2 | 8.4
- redhat•enterprise_linux_server_aus
8.2 | 8.4
- redhat•enterprise_linux_server_tus
8.2 | 8.4
- sqlalchemy•sqlalchemy
1.2.17
References (15)
- https://lists.debian.org/debian-lts-announce/2019/03/msg00020.html
- https://access.redhat.com/errata/RHSA-2019:0984
- https://access.redhat.com/errata/RHSA-2019:0981
- http://lists.opensuse.org/opensuse-security-announce/2019-08/msg00087.html
- http://lists.opensuse.org/opensuse-security-announce/2019-09/msg00010.html
- http://lists.opensuse.org/opensuse-security-announce/2019-09/msg00016.html
- https://www.oracle.com/security-alerts/cpujan2021.html
- https://github.com/sqlalchemy/sqlalchemy/issues/4481#issuecomment-461204518
- https://github.com/no-security/sqlalchemy_test
- https://lists.debian.org/debian-lts-announce/2021/11/msg00005.html
- https://nvd.nist.gov/vuln/detail/CVE-2019-7548
- https://github.com/sqlalchemy/sqlalchemy/issues/4510
- https://github.com/advisories/GHSA-38fc-9xqv-7f7q
- https://github.com/pypa/advisory-database/tree/main/vulns/sqlalchemy/PYSEC-2019-124.yaml
- https://github.com/sqlalchemy/sqlalchemy