Overview
SQLAlchemy is vulnerable to SQL Injection via group_by parameter
Advisory
SQLAlchemy affected versions has SQL Injection when the group_by parameter can be controlled.
How to Fix
Upgrade
sqlalchemy
to1.3.0
or higher.Mitigation and Workarounds
---
Vulnerable Functions
Functions linked to known vulnerabilities.
References
- https://getsafety.com/vulnerabilities/SFTY-20190206-75561/CVE-2019-7548
- https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2019-7548
- https://github.com/sqlalchemy/sqlalchemy/commit/30307c4616ad67c01ddae2e1e8e34fabf6028414
- https://nvd.nist.gov/vuln/detail/CVE-2019-7548
- https://github.com/sqlalchemy/sqlalchemy/issues/4481#issuecomment-461204518
- https://access.redhat.com/errata/RHSA-2019:0981
- https://access.redhat.com/errata/RHSA-2019:0984
- https://github.com/advisories/GHSA-38fc-9xqv-7f7q
- https://github.com/no-security/sqlalchemy_test
- https://lists.debian.org/debian-lts-announce/2019/03/msg00020.html
- https://www.oracle.com/security-alerts/cpujan2021.html
- 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://lists.debian.org/debian-lts-announce/2021/11/msg00005.html
- https://github.com/sqlalchemy/sqlalchemy/issues/4510
- https://github.com/pypa/advisory-database/tree/main/vulns/sqlalchemy/PYSEC-2019-124.yaml
Verified by Safety
Our Cybersecurity Intelligence Team reviewed this vulnerability. We combine public data with our own research to find issues not yet reported to public sources.
Learn more