CVE-2022-28346

An issue was discovered in Django 2.2 before 2.2.28, 3.2 before 3.2.13, and 4.0 before 4.0.4. QuerySet.annotate(), aggregate(), and extra() methods are subject to SQL injection in column aliases via a crafted dictionary (with dictionary expansion) as the passed **kwargs.

A high-level Python Web framework that encourages rapid development and clean, pragmatic design.

Security Fix(es):

An issue was discovered in Django 2.2 before 2.2.28, 3.2 before 3.2.13, and 4.0 before 4.0.4. QuerySet.annotate(), aggregate(), and extra() methods are subject to SQL injection in column aliases via a crafted dictionary (with dictionary expansion) as the passed **kwargs.(CVE-2022-28346) A SQL injection issue was discovered in QuerySet.explain() in Django 2.2 before 2.2.28, 3.2 before 3.2.13, and 4.0 before 4.0.4. This occurs by passing a crafted dictionary (with dictionary expansion) as the **options argument, and placing the injection payload in an option name.(CVE-2022-28347)

An issue was discovered in Django 2.2 before 2.2.28, 3.2 before 3.2.13, and 4.0 before 4.0.4. QuerySet.annotate(), aggregate(), and extra() methods are subject to SQL injection in column aliases via a crafted dictionary (with dictionary expansion) as the passed **kwargs.

An issue was discovered in Django 2.2 before 2.2.28, 3.2 before 3.2.13, and 4.0 before 4.0.4. QuerySet.annotate(), aggregate(), and extra() methods are subject to SQL injection in column aliases via a crafted dictionary (with dictionary expansion) as the passed **kwargs.

TuxCare rebuilt django to address 3 CVEs. Fixed in 4.0.post4+tuxcare.

An issue was discovered in Django 2.2 before 2.2.28, 3.2 before 3.2.13, and 4.0 before 4.0.4. QuerySet.annotate(), aggregate(), and extra() methods are subject to SQL injection in column aliases via a crafted dictionary (with dictionary expansion) as the passed **kwargs.

Potential SQL injection in QuerySet.annotate(), aggregate(), and extra() (CVE-2022-28346) Potential SQL injection via QuerySet.explain(**options) on PostgreSQL QuerySet.explain() (CVE-2022-28347)

This update for python-Django fixes the following issues:

• CVE-2022-41323: Fixed potential denial-of-service vulnerability in internationalized URLs (boo#1203793)

• CVE-2022-36359: Fixed a potential reflected file download vulnerability in FileResponse (boo#1201923)

• Update from 2.2.12 to 2.2.28 (boo#1198297)

  • Many CVEs fixes (check https://github.com/django/django/blob/main/docs/releases/)

  2.2.28:

  • CVE-2022-28346: Fixed potential SQL injection in QuerySet.annotate(), aggregate(), and extra() (bsc#1198398)
  • CVE-2022-28347: Fixed potential SQL injection via QuerySet.explain(**options) (bsc#1198399)

  2.2.27:

  • CVE-2022-22818: Fixed possible XSS via {% debug %} template tag (bsc#1195086)
  • CVE-2022-23833: Fixed denial-of-service possibility in file uploads (bsc#1195088)

  2.2.26:

  • CVE-2021-45115: Denial-of-service possibility in UserAttributeSimilarityValidator (bsc#1194115)
  • CVE-2021-45116: Potential information disclosure in dictsort template filter (bsc#1194117)
  • CVE-2021-45452: Potential directory-traversal via Storage.save() (bsc#)

  2.2.25:

  • CVE-2021-44420: Potential bypass of an upstream access control based on URL paths (bsc#1193240)

  2.2.24:

  • CVE-2021-33203: Potential directory traversal via admindocs
  • CVE-2021-33571: Possible indeterminate SSRF, RFI, and LFI attacks since validators accepted leading zeros in IPv4 addresses

  2.2.23:

  • regression fix

  2.2.22:

  • CVE-2021-32052: Header injection possibility since URLValidator accepted newlines in input on Python 3.9.5+

These are all security issues fixed in the python310-Django-4.0.4-1.1 package on the GA media of openSUSE Tumbleweed.

These are all security issues fixed in the python310-Django4-4.2.14-1.1 package on the GA media of openSUSE Tumbleweed.

These are all security issues fixed in the python311-Django-5.1.5-1.1 package on the GA media of openSUSE Tumbleweed.

These are all security issues fixed in the python312-Django6-6.0-1.1 package on the GA media of openSUSE Tumbleweed.

These are all security issues fixed in the python313-Django4-4.2.30-4.1 package on the GA media of openSUSE Tumbleweed.

These are all security issues fixed in the python313-Django5-5.2.16-1.1 package on the GA media of openSUSE Tumbleweed.

An issue was discovered in Django 2.2 before 2.2.28, 3.2 before 3.2.13, and 4.0 before 4.0.4. QuerySet.annotate(), aggregate(), and extra() methods are subject to SQL injection in column aliases via a crafted dictionary (with dictionary expansion) as the passed **kwargs.

Rocky Enterprise Software Foundation Satellite is a systems management tool for Linux-based infrastructure. It allows for provisioning, remote management, and monitoring of multiple Linux deployments with a single centralized tool.

Security Fix(es):

• libsolv: Heap-based buffer overflow in testcase_read() in src/testcase.c (CVE-2021-3200)
• satellite: foreman: Authenticate remote code execution through Sendmail configuration (CVE-2021-3584)
• candlepin: Allow unintended SCA certificate to authenticate Candlepin (CVE-2021-4142)
• candlepin: netty: Information disclosure via the local system temporary directory (CVE-2021-21290)
• candlepin: netty: Possible request smuggling in HTTP/2 due missing validation (CVE-2021-21295)
• candlepin: netty: Request smuggling via content-length header (CVE-2021-21409)
• tfm-rubygem-sidekiq: XSS via the queue name of the live-poll feature (CVE-2021-30151)
• python-sqlparse: ReDoS via regular expression in StripComments filter (CVE-2021-32839)
• libsolv: various flaws (CVE-2021-33928 CVE-2021-33929 CVE-2021-33930 CVE-2021-33938)
• tfm-rubygem-puma: Inconsistent Interpretation of HTTP Requests in puma (CVE-2021-41136)
• logback-classic: Remote code execution through JNDI call from within its configuration file (CVE-2021-42550)
• candlepin: netty: Control chars in header names may lead to HTTP request smuggling (CVE-2021-43797)
• python-lxml: HTML Cleaner allows crafted and SVG embedded scripts to pass through (CVE-2021-43818)
• python3-django: Potential bypass of an upstream access control based on URL paths (CVE-2021-44420)
• libsolv: Heap overflow (CVE-2021-44568)
• python3-django: Various flaws (CVE-2021-45115 CVE-2021-45116 CVE-2021-45452 CVE-2022-22818)
• tfm-rubygem-actionpack: Information leak between requests (CVE-2022-23633)
• tfm-rubygem-puma: rubygem-rails: Information leak between requests (CVE-2022-23634)
• python3-django: Denial-of-service possibility in file uploads (CVE-2022-23833)
• tfm-rubygem-sidekiq: WebUI Denial of Service caused by number of days on graph (CVE-2022-23837)
• python3-django: Various flaws (CVE-2022-28346 CVE-2022-28347)

For more details about the security issue(s), including the impact, a CVSS score, acknowledgments, and other related information, refer to the CVE page(s) listed in the References section.

Additional Changes:

• New repo layout for Satellite, Utils, Maintenance, and Client repos.
• Support for Rocky Linux 9 clients
• Module-based installation on Rocky Linux 8
• Upgrading Satellite Server and Capsule Server installations from Rocky Linux 7 to Rocky Linux 8
• Connected and Disconnected servers supported on Rocky Linux 7 and Rocky Linux 8
• Inter-Server Synchronization improvements
• Puppet integration optional and disabled by default
• Pulp 3 updated to Python 3.8
• Change to Capsule certificate archive
• New default port for communication with Rocky Enterprise Software Foundation Subscription Management * (RHSM) API on Capsule servers
• New Content Views Page (Content Publication workflow simplification)
• New Hosts Page (Technology Preview)
• Registration and preview templates
• Simplified host content source changing
• Improved behavior for configuring and running remote jobs
• Provisioning improvements
• New error signaling unsupported options in TASK-Filter
• Virt-who configuration enhanced to support Nutanix AHV
• Cloud Connector configuration updated
• Improved Insights adoption

The items above are not a complete list of changes. This update also fixes several bugs and adds various enhancements. Documentation for these changes is available from the Release Notes document linked to in the References section.

This update for ardana-ansible, ardana-cobbler, grafana, openstack-heat-templates, openstack-murano, python-Django, rabbitmq-server, rubygem-puma fixes the following issues:

Security updates included on this update:

ardana-ansible, ardana-cobbler, grafana, openstack-heat-templates, openstack-murano, rabbitmq-server:

• CVE-2020-1734: Fixed vulnerability where shell was enabled by default in a pipe lookup plugin subprocess. (SOC-11662, bnc#1164139)
• CVE-2021-44716: Fixed uncontrolled memory consumption in go's net/http. (bsc#1193597)
• CVE-2019-11287: Fixed DoS via 'X-Reason' HTTP Header in malicious Erlang format string. (bsc#1157665)

grafana:

• CVE-2021-39226: Fixed snapshot authentication bypass (bsc#1191454).
• CVE-2021-44716: Fixed uncontrolled memory consumption in go's net/http (bsc#1193597).

python-Django:

• CVE-2022-28346: Fixed vulnerability that could lead to SQL injection in QuerySet.annotate(),aggregate() and extra(). (bsc#1198398)
• CVE-2022-34265: Fixed vulnerability that could lead to SQL injection via Trunc(kind) and Extract(lookup_name) arguments. (bsc#1201186)

rubygem puma:

• CVE-2022-24790: Fixed HTTP request smuggling vulnerability. (bsc#1197818)

Additional information about the this update:

Changes in ardana-ansible:

• Update to version 8.0+git.1660773729.3789a6d:
  • Mitigate CVE-2020-1734 (SOC-11662)

Changes in ardana-cobbler:

• Update to version 8.0+git.1660773402.d845a45:
  • Mitigate CVE-2020-1734 (SOC-11662)

Changes in grafana:

• Add CVE-2021-39226 patch (bsc#1191454, CVE-2021-39226)

  • snapshot authentication bypass

• Bump Go to 1.16 (bsc#1193597, CVE-2021-44716)

  • Fix Go net/http: limit growth of header canonicalization cache.

Changes in openstack-heat-templates:

• Update to version 0.0.0+git.1654529662.75fa04a:
  • doc: Comment out language option

Changes in openstack-murano:

• Update to version murano-4.0.2.dev3:
  • [stable-only] Remove periodic-stable-jobs template

Changes in openstack-murano:

• Update to version murano-4.0.2.dev3:
  • [stable-only] Remove periodic-stable-jobs template

Changes in rabbitmq-server:

• add explanation-format patch to fix CVE-2019-11287 (bsc#1157665)

Changes in python-Django:

• Rename Django-1.11.29.tar.gz.asc to Django-1.11.29.tar.gz.checksums.txt to avoid source_validator incorrectly trying to use it as a detached signature file for the sources tarball.

• Remove unnecessary project.diff file.

• Add CVE-2022-28346 patch (bsc#1198398, CVE-2022-28346)

  • Potential SQL injection in QuerySet.annotate(),aggregate() and extra()

• Add CVE-2022-34265 patch (bsc#1201186, CVE-2022-34265)

  • SQL injection via Trunc(kind) and Extract(lookup_name) arguments

Changes in rubygem-puma:

• Add CVE-2022-24790: Fixed HTTP request smuggling vulnerability (bsc#1197818).

This update for ardana-ansible, ardana-cobbler, ardana-tempest, grafana, openstack-heat-templates, openstack-horizon-plugin-gbp-ui, openstack-neutron-gbp, openstack-nova, python-Django1, rabbitmq-server, rubygem-puma fixes the following issues:

Security fixes included in this update:

ardana-ansible:

• CVE-2020-1734: Fixed vulnerability where shell was enabled by default in a pipe lookup plugin subprocess (SOC-11662, bnc#1164139). grafana:
• CVE-2021-39226: Fixed snapshot authentication bypass (bsc#1191454). rabbitmq-server:
• CVE-2019-11287: Fixed DoS via 'X-Reason' HTTP Header in malicious Erlang format string (bsc#1157665). rubygem-puma:
• CVE-2022-24790: Fixed HTTP request smuggling (bsc#1197818). python-Django1:
• CVE-2022-28346: Fixed vulnerability allowing SQL injection in QuerySet.annotate(),aggregate() and extra() (bsc#1198398).
• CVE-2022-34265: Fixed vulnerability allowing SQL injection via Trunc(kind) and Extract(lookup_name) arguments (bsc#1201186). Bugfixes:
• Disabled two barbican tests (SOC-8764).

Non-security fixes included on this update:

Changes in ardana-ansible:

• Update to version 9.0+git.1660748476.c118d23:
  • Mitigate CVE-2020-1734 (SOC-11662)

Changes in ardana-cobbler:

• Update to version 9.0+git.1660747489.119efcd:
  • Mitigate CVE-2020-1734 (SOC-11662)

Changes in ardana-tempest:

• Update to version 9.0+git.1651855288.a2341ad:
  • Disable two barbican tests (SOC-8764)

Changes in grafana:

• Add CVE-2021-39226 patch (bsc#1191454, CVE-2021-39226)
  • snapshot authentication bypass

Changes in openstack-heat-templates:

• Update to version 0.0.0+git.1654529662.75fa04a7:
  • doc: Comment out language option

Changes in openstack-horizon-plugin-gbp-ui:

• Update to version group-based-policy-ui-14.0.1.dev4:
  • remove legacy servicechain code

Changes in openstack-neutron-gbp:

• Update to version group-based-policy-14.0.1.dev46:

  • Remove logs 2014.2.rc1

• Update to version group-based-policy-14.0.1.dev45:

  • FIP Status active after dissociate

• Update to version group-based-policy-14.0.1.dev43:

  • fixed apic synchronization state for multiple erspan session

• Update to version group-based-policy-14.0.1.dev41:

  • Remove_legacy_service_chain_code(2)

• Update to version group-based-policy-14.0.1.dev39:

  • data-migrations spelling fixes 2014.2rc1

• Update to version group-based-policy-14.0.1.dev38:

  • Adding support for address group feature in upstream

• Update to version group-based-policy-14.0.1.dev36:

  • Add support for yoga 2014.2.rc1

• Update to version group-based-policy-14.0.1.dev35:

  • Removed_legacy_service_chain_code 2014.2rc1

Changes in openstack-nova:

• Update to version nova-18.3.1.dev92:
  • [stable-only] Drop lower-constraints job

Changes in openstack-nova:

• Update to version nova-18.3.1.dev92:
  • [stable-only] Drop lower-constraints job

Changes in python-Djanjo1:

• Rename Django-1.11.29.tar.gz.asc to Django-1.11.29.tar.gz.checksums.txt to avoid source_validator incorrectly trying to use it as a detached signature file for the sources tarball.

• Add CVE-2022-28346 patch (bsc#1198398, CVE-2022-28346)

  • Potential SQL injection in QuerySet.annotate(),aggregate() and extra()

• Add CVE-2022-34265 patch (bsc#1201186, CVE-2022-34265)

  • SQL injection via Trunc(kind) and Extract(lookup_name) arguments

Changes in rabbitmq-server:

• add explanation-format patch to fix CVE-2019-11287 (bsc#1157665)

Changes in rubygem-puma:

• Add CVE-2022-24790 patch (bsc#1197818, CVE-2022-24790).

This update for python-Django fixes the following issues:

• CVE-2024-42005: Fixed SQL injection in QuerySet.values() and values_list() (bsc#1228629)
• CVE-2024-41989: Fixed Memory exhaustion in django.utils.numberformat.floatformat() (bsc#1228630)
• CVE-2024-41990: Fixed denial-of-service vulnerability in django.utils.html.urlize() (bsc#1228631)
• CVE-2024-41991: Fixed another denial-of-service vulnerability in django.utils.html.urlize() (bsc#1228632)
• CVE-2022-28346: Fixed SQL injection in QuerySet.annotate(),aggregate() and extra() (bsc#1198398)
• CVE-2019-12308: Fixed XSS in AdminURLFieldWidget (bsc#1136468)

It was discovered that Django incorrectly handled certain certain column aliases in the QuerySet.annotate(), aggregate(), and extra() methods. A remote attacker could possibly use this issue to perform an SQL injection attack. (CVE-2022-28346)

It was discovered that Django incorrectly handled certain option names in the QuerySet.explain() method. A remote attacker could possibly use this issue to perform an SQL injection attack. This issue only affected Ubuntu 20.04 LTS, and Ubuntu 21.10. (CVE-2022-28347)

It was discovered that the Django URLValidator function incorrectly handled newlines and tabs. A remote attacker could possibly use this issue to perform a header injection attack. This issue only affected Ubuntu 18.04 LTS. (CVE-2021-32052)

USN-5373-1 fixed several vulnerabilities in Django. This update provides the corresponding update for Ubuntu 14.04 ESM and Ubuntu 16.04 ESM.

Original advisory details:

It was discovered that Django incorrectly handled certain certain column aliases in the QuerySet.annotate(), aggregate(), and extra() methods. A remote attacker could possibly use this issue to perform an SQL injection attack. (CVE-2022-28346)

It was discovered that the Django URLValidator function incorrectly handled newlines and tabs. A remote attacker could possibly use this issue to perform a header injection attack. (CVE-2021-32052)