CriticalGHSA-38fc-9xqv-7f7qCVE-2019-7548PYSEC-2019-124
SQLAlchemy is vulnerable to SQL Injection via group_by parameter
Published 16 Apr 2019 · Updated 28 Oct 2024
Is your project on an affected sqlalchemy?
Look after several Python apps? Indie watches up to 15 repos, private ones too, for $5 a month. See Indie
Affected package
sqlalchemyPyPI
- Affected
- <1.2.19
- Fixed in
- 1.2.19
Update to the fixed version for your release line, for example:
pip install 'sqlalchemy>=1.2.19'Details
SQLAlchemy 1.2.17 has SQL Injection when the group_by parameter can be controlled.
Is GHSA-38fc-9xqv-7f7q in any of your client repos?
Checking one package by hand is fine. Checking it across forty client projects is not. NPMscan reads the lockfiles in every GitHub repo you pick, finds each project with an affected sqlalchemy, and gives you the command that fixes it.
More advisories for sqlalchemy
- CriticalCVE-2012-0805SQLAlchemy vulnerable to SQL injection · 14 May 2022
- CriticalCVE-2019-7164SQLAlchemy vulnerable to SQL Injection via order_by parameter · 16 Apr 2019
References
- Advisorynvd.nist.gov/vuln/detail/CVE-2019-7548
- Linkgithub.com/sqlalchemy/sqlalchemy/issues/4481#issuecomment-461204518
- Linkgithub.com/sqlalchemy/sqlalchemy/issues/4510
- Linkaccess.redhat.com/errata/RHSA-2019:0981
- Linkaccess.redhat.com/errata/RHSA-2019:0984
- Advisorygithub.com/advisories/GHSA-38fc-9xqv-7f7q
- Linkgithub.com/no-security/sqlalchemy_test
- Linkgithub.com/pypa/advisory-database/tree/main/vulns/sqlalchemy/PYSEC-2019-124.yaml
- Packagegithub.com/sqlalchemy/sqlalchemy
- Linklists.debian.org/debian-lts-announce/2019/03/msg00020.html
- Linklists.debian.org/debian-lts-announce/2021/11/msg00005.html
- Linkwww.oracle.com/security-alerts/cpujan2021.html
- Linklists.opensuse.org/opensuse-security-announce/2019-08/msg00087.html
- Linklists.opensuse.org/opensuse-security-announce/2019-09/msg00010.html
- Linklists.opensuse.org/opensuse-security-announce/2019-09/msg00016.html
Advisory data from OSV.dev (opens OSV.dev in a new tab), refreshed daily.