CVE-2019-7548 SQLAlchemy is vulnerable to SQL Injection via group_by parameter

High 7.8 Published Updated

SQL injection vulnerability in SQLAlchemy allows attackers to manipulate database queries via the group_by parameter.

Exploited in the wild
Not known
Login needed
Not needed
Attackable
Local or same network only
Victim action needed
A user has to click or open something
Fix
Available

What is CVE-2019-7548?

CVE-2019-7548 is a high-severity SQL injection vulnerability in Debian Debian Linux, published on 6 Feb 2019. It can only be exploited from the same machine or local network, and only if a user opens a file or follows a link.

Official description

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

Weakness: CWE-89

Which versions are affected by CVE-2019-7548?

3 open source packages ship an affected version, including sqlalchemy and SQLAlchemy. It affects 9 products.

PackageAffectedFixed in
sqlalchemy PyPIAll versions1.2.18
sqlalchemy PyPIAll versions1.2.19
SQLAlchemy PyPIAll versions1.2.19

Products include Debian Debian Linux, Opensuse Backports Sle, Opensuse Leap, Oracle Communications Operations Monitor, Redhat Enterprise Linux, Redhat Enterprise Linux Eus and 3 more.

How do I fix CVE-2019-7548?

Upgrade sqlalchemy to a fixed version for your release line: 1.2.18 or 1.2.19.

Use parameterised queries everywhere and never build SQL by joining strings. Upgrade affected software first; a web application firewall only buys time. More about SQL injection.

Is CVE-2019-7548 being exploited?

There is no known exploitation of CVE-2019-7548 in the wild and no public exploit code.

All Debian Debian Linux vulnerabilities

Sources

Also known as DEBIAN-CVE-2019-7548, GHSA-38fc-9xqv-7f7q, OESA-2021-1274, PYSEC-2019-124, UBUNTU-CVE-2019-7548.

Is CVE-2019-7548 in your software?

Upload an SBOM and sbomify checks it against every vulnerability here, every day.

Check your SBOMs for free