PYSEC-2019-54 - SQLAlchemy 1.2.17 has SQL Injection when the group_by parameter can be controlled.

Severity: info · Published 2019-02-06

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

Technologies: SQLAlchemy (PyPI). Vendors: PyPI.

Quick answers

Is This vulnerability exploited in the wild?
No. Junglewise Threat Intelligence has no report of This vulnerability being exploited in the wild.
How severe is This vulnerability?
Informational severity, published 6 February 2019.
Which products and versions are affected?
SQLAlchemy (PyPI) ECOSYSTEM:introduced=0,fixed=1.2.18.
Is there a fix for This vulnerability?
Yes. SQLAlchemy (PyPI): upgrade to 1.2.18 or later. Junglewise finds every place you run it, drafts the upgrade and applies it once you approve.
Am I affected?
Check whether you run SQLAlchemy (PyPI) at an affected version. Junglewise does that check for you around the clock: connect your code, cloud and domains, and it matches new vulnerabilities like this one against what you actually run and tells you when one reaches you.

How to fix

  • SQLAlchemy (PyPI): upgrade to 1.2.18 or later
    pip install "SQLAlchemy>=1.2.18"

Affected products

  • SQLAlchemy (PyPI) ECOSYSTEM:introduced=0,fixed=1.2.18

This page as Markdown. Free to reuse under CC BY 4.0 with a link back.