ASA-202204-9: python-django: sql injection
Arch Linux Security Advisory ASA-202204-9
=========================================
Severity: High
Date : 2022-04-12
CVE-ID : CVE-2022-28346 CVE-2022-28347
Package : python-django
Type : sql injection
Remote : Yes
Link : https://security.archlinux.org/AVG-2667
Summary
=======
The package python-django before version 4.0.4-1 is vulnerable to sql
injection.
Resolution
==========
Upgrade to 4.0.4-1.
# pacman -Syu "python-django>=4.0.4-1"
The problems have been fixed upstream in version 4.0.4.
Workaround
==========
None.
Description
===========
- CVE-2022-28346 (sql injection)
QuerySet.annotate(), aggregate(), and extra() methods were subject to
SQL injection in column aliases, using a suitably crafted dictionary,
with dictionary expansion, as the **kwargs passed to these methods.
- CVE-2022-28347 (sql injection)
QuerySet.explain() method was subject to SQL injection in option names,
using a suitably crafted dictionary, with dictionary expansion, as the
**options argument.
Impact
======
An attacker is able to perform an SQL injection via a specially crafted
input.
References
==========
https://www.djangoproject.com/weblog/2022/apr/11/security-releases/
https://github.com/django/django/commit/93cae5cb2f9a4ef1514cf1a41f714fef08005200
https://github.com/django/django/commit/800828887a0509ad1162d6d407e94d8de7eafc60
https://github.com/django/django/commit/2044dac5c6968441be6f534c4139bcf48c5c7e48
https://github.com/django/django/commit/2c09e68ec911919360d5f8502cefc312f9e03c5d
https://github.com/django/django/commit/6723a26e59b0b5429a0c5873941e01a2e1bdbb81
https://github.com/django/django/commit/00b0fc50e1738c7174c495464a5ef069408a4402
https://github.com/django/django/commit/9e19accb6e0a00ba77d5a95a91675bf18877c72d
https://github.com/django/django/commit/29a6c98b4c13af82064f993f0acc6e8fafa4d3f5
https://security.archlinux.org/CVE-2022-28346
https://security.archlinux.org/CVE-2022-28347
A python-django security update has been released for Arch Linux to address a sql injection.