Bug 50873

Summary: python-django: Multiple issues (4.4)
Product: UCS Reporter: Quality Assurance <qa>
Component: Security updatesAssignee: Quality Assurance <qa>
Status: CLOSED FIXED QA Contact: Philipp Hahn <hahn>
Severity: normal    
Priority: P3    
Version: UCS 4.4   
Target Milestone: UCS 4.4-3-errata   
Hardware: All   
OS: Linux   
What kind of report is it?: Security Issue What type of bug is this?: ---
Who will be affected by this bug?: --- How will those affected feel about the bug?: ---
User Pain: Enterprise Customer affected?:
School Customer affected?: ISV affected?:
Waiting Support: Flags outvoted (downgraded) after PO Review:
Ticket number: Bug group (optional):
Max CVSS v3 score: 7.6 (CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:L/A:L)

Description Quality Assurance univentionstaff 2020-02-27 15:34:40 CET
New Debian python-django 1:1.10.7-2+deb9u8 fixes:
This update addresses the following issue:
* potential SQL injection via StringAgg(delimiter) (CVE-2020-7471)
Comment 1 Quality Assurance univentionstaff 2020-02-27 16:01:42 CET
--- mirror/ftp/4.4/unmaintained/component/4.4-3-errata/source/python-django_1.10.7-2+deb9u7.dsc
+++ apt/ucs_4.4-0-errata4.4-3/source/python-django_1.10.7-2+deb9u8.dsc
@@ -1,3 +1,15 @@
+1:1.10.7-2+deb9u8 [Sat, 15 Feb 2020 10:25:11 +0000] Chris Lamb <lamby@debian.org>:
+
+  * CVE-2020-7471: Prevent a Potential SQL injection via StringAgg(delimiter).
+    (Closes: #950581)
+
+    Django 1.11 before 1.11.28, 2.2 before 2.2.10, and 3.0 before 3.0.3 allows
+    SQL Injection if untrusted data is used as a StringAgg delimiter (e.g., in
+    Django applications that offer downloads of data as a series of rows with a
+    user-specified column delimiter). By passing a suitably crafted delimiter
+    to a contrib.postgres.aggregates.StringAgg instance, it was possible to
+    break escaping and inject malicious SQL.
+
 1:1.10.7-2+deb9u7 [Mon, 06 Jan 2020 17:52:10 +0000] Chris Lamb <lamby@debian.org>:
 
   * CVE-2019-19844: Prevent a potential account hijack via the password reset

<http://10.200.17.11/4.4-3/#6557579374627130162>
Comment 2 Philipp Hahn univentionstaff 2020-03-09 13:19:05 CET
OK: yaml
OK: announce_errata
OK: patch
OK: piuparts

[4.4-3] d83423667e Bug #50873: python-django 1:1.10.7-2+deb9u8
 doc/errata/staging/python-django.yaml | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

[4.4-3] b0ac173eb9 Bug #50873: python-django 1:1.10.7-2+deb9u8
 doc/errata/staging/python-django.yaml | 12 ++++++++++++
 1 file changed, 12 insertions(+)
Comment 3 Erik Damrose univentionstaff 2020-03-11 14:42:02 CET
<http://errata.software-univention.de/ucs/4.4/470.html>