Skip to content

CVE-2022-34265 Django `Trunc()` and `Extract()` database functions vulnerable to SQL Injection

CriticalCVSS 9.8 EPSS 73.6%
Published
Updated
Exploit status
No public exploit known
Technology
UbuntuDebian

Description

An issue was discovered in Django 3.2 before 3.2.14 and 4.0 before 4.0.6. The Trunc() and Extract() database functions are subject to SQL injection if untrusted data is used as a kind/lookup_name value. Applications that constrain the lookup name and kind choice to a known safe list are unaffected.

Upgrade path

17 packages: 17 fixed.

PackageAffectedFixed inStatus
alpine/py3-django(Alpine v3.16) < 3.2.14-r0 3.2.14-r0 Fixed
alpine/py3-django(Alpine v3.17) < 3.2.14-r0 3.2.14-r0 Fixed
alpine/py3-django(Alpine v3.18) < 3.2.14-r0 3.2.14-r0 Fixed
alpine/py3-django(Alpine v3.19) < 3.2.14-r0 3.2.14-r0 Fixed
alpine/py3-django(Alpine v3.20) < 3.2.14-r0 3.2.14-r0 Fixed
alpine/py3-django(Alpine v3.21) < 3.2.14-r0 3.2.14-r0 Fixed
alpine/py3-django(Alpine v3.22) < 3.2.14-r0 3.2.14-r0 Fixed
alpine/py3-django(Alpine v3.23) < 3.2.14-r0 3.2.14-r0 Fixed
alpine/py3-django(Alpine v3.24) < 3.2.14-r0 3.2.14-r0 Fixed
debian/python-django(Debian 12) < 2:4.0.6-1 2:4.0.6-1 Fixed
debian/python-django(Debian 13) < 2:4.0.6-1 2:4.0.6-1 Fixed
debian/python-django(Debian 14) < 2:4.0.6-1 2:4.0.6-1 Fixed
djangoproject django >= 3.2, < 3.2.14; >= 4.0, < 4.0.6 3.2.14, 4.0.6 Fixed
pypi django(PyPI) = 3.2; = 3.2.1; = 3.2.2; = 3.2.3 +26 more 3.2.14, 4.0.6 Fixed
ubuntu/python-django(Ubuntu 18.04) < 1:1.11.11-1ubuntu1.18; = 1:1.11.4-1ubuntu1; = 1:1.11.6-1ubuntu1; = 1:1.11.9-1ubuntu1 +18 more 1:1.11.11-1ubuntu1.18 Fixed
ubuntu/python-django(Ubuntu 20.04) < 2:2.2.12-1ubuntu0.12; = 1:1.11.22-1ubuntu1; = 2:2.2.6-1ubuntu1; = 2:2.2.9-2ubuntu1 +15 more 2:2.2.12-1ubuntu0.12 Fixed
ubuntu/python-django(Ubuntu 22.04) < 2:3.2.12-2ubuntu1.1; = 2:2.2.24-1ubuntu1; = 2:3.2.12-2; = 2:3.2.12-2ubuntu1 2:3.2.12-2ubuntu1.1 Fixed

Affected products

ProductAffected versionsFixed in
pypi django(PyPI) >= 3.2a1, < 3.2.14 3.2.14
pypi django(PyPI) = 3.2 No fix listed
pypi django(PyPI) = 3.2.1 No fix listed
pypi django(PyPI) = 3.2.10 No fix listed
pypi django(PyPI) = 3.2.11 No fix listed
pypi django(PyPI) = 3.2.12 No fix listed
pypi django(PyPI) = 3.2.13 No fix listed
pypi django(PyPI) = 3.2.2 No fix listed
pypi django(PyPI) = 3.2.3 No fix listed
pypi django(PyPI) = 3.2.4 No fix listed
pypi django(PyPI) = 3.2.5 No fix listed
pypi django(PyPI) = 3.2.6 No fix listed
pypi django(PyPI) = 3.2.7 No fix listed
pypi django(PyPI) = 3.2.8 No fix listed
pypi django(PyPI) = 3.2.9 No fix listed
pypi django(PyPI) = 3.2a1 No fix listed
pypi django(PyPI) = 3.2b1 No fix listed
pypi django(PyPI) = 3.2rc1 No fix listed
pypi django(PyPI) >= 4.0a1, < 4.0.6 4.0.6
pypi django(PyPI) = 4.0 No fix listed
pypi django(PyPI) = 4.0.1 No fix listed
pypi django(PyPI) = 4.0.2 No fix listed
pypi django(PyPI) = 4.0.3 No fix listed
pypi django(PyPI) = 4.0.4 No fix listed
pypi django(PyPI) = 4.0.5 No fix listed
Show 64 more
ProductAffected versionsFixed in
pypi django(PyPI) = 4.0a1 No fix listed
pypi django(PyPI) = 4.0b1 No fix listed
pypi django(PyPI) = 4.0rc1 No fix listed
pypi django(PyPI) >= 3.2, < 3.2.14 3.2.14
pypi django(PyPI) >= 4.0, < 4.0.6 4.0.6
ubuntu/python-django(Ubuntu:22.04) < 2:3.2.12-2ubuntu1.1 2:3.2.12-2ubuntu1.1
djangoproject django >= 3.2, < 3.2.14 3.2.14
djangoproject django >= 4.0, < 4.0.6 4.0.6
debian/python-django(Debian:12) < 2:4.0.6-1 2:4.0.6-1
debian/python-django(Debian:14) < 2:4.0.6-1 2:4.0.6-1
debian/python-django(Debian:13) < 2:4.0.6-1 2:4.0.6-1
ubuntu/python-django(Ubuntu:18.04) < 1:1.11.11-1ubuntu1.18 1:1.11.11-1ubuntu1.18
ubuntu/python-django(Ubuntu:18.04) = 1:1.11.4-1ubuntu1 No fix listed
ubuntu/python-django(Ubuntu:18.04) = 1:1.11.6-1ubuntu1 No fix listed
ubuntu/python-django(Ubuntu:18.04) = 1:1.11.9-1ubuntu1 No fix listed
ubuntu/python-django(Ubuntu:18.04) = 1:1.11.11-1ubuntu1 No fix listed
ubuntu/python-django(Ubuntu:18.04) = 1:1.11.11-1ubuntu1.1 No fix listed
ubuntu/python-django(Ubuntu:18.04) = 1:1.11.11-1ubuntu1.2 No fix listed
ubuntu/python-django(Ubuntu:18.04) = 1:1.11.11-1ubuntu1.3 No fix listed
ubuntu/python-django(Ubuntu:18.04) = 1:1.11.11-1ubuntu1.4 No fix listed
ubuntu/python-django(Ubuntu:18.04) = 1:1.11.11-1ubuntu1.5 No fix listed
ubuntu/python-django(Ubuntu:18.04) = 1:1.11.11-1ubuntu1.6 No fix listed
ubuntu/python-django(Ubuntu:18.04) = 1:1.11.11-1ubuntu1.7 No fix listed
ubuntu/python-django(Ubuntu:18.04) = 1:1.11.11-1ubuntu1.8 No fix listed
ubuntu/python-django(Ubuntu:18.04) = 1:1.11.11-1ubuntu1.9 No fix listed
ubuntu/python-django(Ubuntu:18.04) = 1:1.11.11-1ubuntu1.10 No fix listed
ubuntu/python-django(Ubuntu:18.04) = 1:1.11.11-1ubuntu1.11 No fix listed
ubuntu/python-django(Ubuntu:18.04) = 1:1.11.11-1ubuntu1.12 No fix listed
ubuntu/python-django(Ubuntu:18.04) = 1:1.11.11-1ubuntu1.13 No fix listed
ubuntu/python-django(Ubuntu:18.04) = 1:1.11.11-1ubuntu1.14 No fix listed
ubuntu/python-django(Ubuntu:18.04) = 1:1.11.11-1ubuntu1.15 No fix listed
ubuntu/python-django(Ubuntu:18.04) = 1:1.11.11-1ubuntu1.16 No fix listed
ubuntu/python-django(Ubuntu:18.04) = 1:1.11.11-1ubuntu1.17 No fix listed
ubuntu/python-django(Ubuntu:20.04) < 2:2.2.12-1ubuntu0.12 2:2.2.12-1ubuntu0.12
ubuntu/python-django(Ubuntu:20.04) = 1:1.11.22-1ubuntu1 No fix listed
ubuntu/python-django(Ubuntu:20.04) = 2:2.2.6-1ubuntu1 No fix listed
ubuntu/python-django(Ubuntu:20.04) = 2:2.2.9-2ubuntu1 No fix listed
ubuntu/python-django(Ubuntu:20.04) = 2:2.2.10-1 No fix listed
ubuntu/python-django(Ubuntu:20.04) = 2:2.2.10-1ubuntu1 No fix listed
ubuntu/python-django(Ubuntu:20.04) = 2:2.2.11-1 No fix listed
ubuntu/python-django(Ubuntu:20.04) = 2:2.2.12-1 No fix listed
ubuntu/python-django(Ubuntu:20.04) = 2:2.2.12-1ubuntu0.1 No fix listed
ubuntu/python-django(Ubuntu:20.04) = 2:2.2.12-1ubuntu0.2 No fix listed
ubuntu/python-django(Ubuntu:20.04) = 2:2.2.12-1ubuntu0.3 No fix listed
ubuntu/python-django(Ubuntu:20.04) = 2:2.2.12-1ubuntu0.4 No fix listed
ubuntu/python-django(Ubuntu:20.04) = 2:2.2.12-1ubuntu0.5 No fix listed
ubuntu/python-django(Ubuntu:20.04) = 2:2.2.12-1ubuntu0.6 No fix listed
ubuntu/python-django(Ubuntu:20.04) = 2:2.2.12-1ubuntu0.7 No fix listed
ubuntu/python-django(Ubuntu:20.04) = 2:2.2.12-1ubuntu0.8 No fix listed
ubuntu/python-django(Ubuntu:20.04) = 2:2.2.12-1ubuntu0.9 No fix listed
ubuntu/python-django(Ubuntu:20.04) = 2:2.2.12-1ubuntu0.10 No fix listed
ubuntu/python-django(Ubuntu:20.04) = 2:2.2.12-1ubuntu0.11 No fix listed
ubuntu/python-django(Ubuntu:22.04) = 2:2.2.24-1ubuntu1 No fix listed
ubuntu/python-django(Ubuntu:22.04) = 2:3.2.12-2 No fix listed
ubuntu/python-django(Ubuntu:22.04) = 2:3.2.12-2ubuntu1 No fix listed
alpine/py3-django(Alpine:v3.16) < 3.2.14-r0 3.2.14-r0
alpine/py3-django(Alpine:v3.17) < 3.2.14-r0 3.2.14-r0
alpine/py3-django(Alpine:v3.18) < 3.2.14-r0 3.2.14-r0
alpine/py3-django(Alpine:v3.19) < 3.2.14-r0 3.2.14-r0
alpine/py3-django(Alpine:v3.20) < 3.2.14-r0 3.2.14-r0
alpine/py3-django(Alpine:v3.21) < 3.2.14-r0 3.2.14-r0
alpine/py3-django(Alpine:v3.22) < 3.2.14-r0 3.2.14-r0
alpine/py3-django(Alpine:v3.23) < 3.2.14-r0 3.2.14-r0
alpine/py3-django(Alpine:v3.24) < 3.2.14-r0 3.2.14-r0

References