—

PYSEC-2019-123

Quick fix

PYSEC-2019-123 — sqlalchemy: upgrade to the fixed version with the command below.

pip install --upgrade 'sqlalchemy>=1.3.0b3'

Details

SQLAlchemy before 1.3.0b3 allows SQL Injection via the order_by parameter. The fix (commit 30307c4) was applied only to the main branch and was never backported to the 1.2.x release line; all 1.2.x versions remain vulnerable.

Are you affected?

Enter the version of the package you're using.

Affected packages

PyPI/sqlalchemy

Introduced in: 0Fixed in: 1.3.0b3

Fixpip install --upgrade 'sqlalchemy>=1.3.0b3'

References

https://github.com/sqlalchemy/sqlalchemy/issues/4481[REPORT]
https://lists.debian.org/debian-lts-announce/2019/03/msg00020.html[WEB]
https://access.redhat.com/errata/RHSA-2019:0984[ADVISORY]
https://access.redhat.com/errata/RHSA-2019:0981[ADVISORY]
http://lists.opensuse.org/opensuse-security-announce/2019-08/msg00087.html[WEB]
http://lists.opensuse.org/opensuse-security-announce/2019-09/msg00010.html[WEB]
http://lists.opensuse.org/opensuse-security-announce/2019-09/msg00016.html[WEB]
https://www.oracle.com/security-alerts/cpujan2021.html[WEB]
https://github.com/advisories/GHSA-887w-45rq-vxgf[ADVISORY]