Debian DLA-2811-1 : sqlalchemy - LTS security update

critical Nessus Plugin ID 154950

Synopsis

The remote Debian host is missing one or more security-related updates.

Description

The remote Debian 9 host has packages installed that are affected by multiple vulnerabilities as referenced in the dla-2811 advisory.

- SQLAlchemy through 1.2.17 and 1.3.x through 1.3.0b2 allows SQL Injection via the order_by parameter.
(CVE-2019-7164)

- SQLAlchemy 1.2.17 has SQL Injection when the group_by parameter can be controlled. (CVE-2019-7548)

Note that Nessus has not tested for this issue but has instead relied only on the application's self-reported version number.

Solution

Upgrade the sqlalchemy packages.

For Debian 9 stretch, these problems have been fixed in version 1.0.15+ds1-1+deb9u1.

See Also

https://packages.debian.org/source/stretch/sqlalchemy

https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=922669

https://security-tracker.debian.org/tracker/source-package/sqlalchemy

https://www.debian.org/lts/security/2021/dla-2811

https://security-tracker.debian.org/tracker/CVE-2019-7164

https://security-tracker.debian.org/tracker/CVE-2019-7548

Plugin Details

Severity: Critical

ID: 154950

File Name: debian_DLA-2811.nasl

Version: 1.4

Type: local

Agent: unix

Published: 11/7/2021

Updated: 11/27/2023

Supported Sensors: Frictionless Assessment Agent, Nessus Agent, Agentless Assessment, Continuous Assessment, Nessus

Risk Information

VPR

Risk Factor: Medium

Score: 6.7

CVSS v2

Risk Factor: High

Base Score: 7.5

Temporal Score: 5.9

Vector: CVSS2#AV:N/AC:L/Au:N/C:P/I:P/A:P

CVSS Score Source: CVE-2019-7164

CVSS v3

Risk Factor: Critical

Base Score: 9.8

Temporal Score: 8.8

Vector: CVSS:3.0/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H

Temporal Vector: CVSS:3.0/E:P/RL:O/RC:C

Vulnerability Information

CPE: p-cpe:/a:debian:debian_linux:python-sqlalchemy-doc, cpe:/o:debian:debian_linux:9.0, p-cpe:/a:debian:debian_linux:python-sqlalchemy, p-cpe:/a:debian:debian_linux:python-sqlalchemy-ext, p-cpe:/a:debian:debian_linux:python3-sqlalchemy-ext, p-cpe:/a:debian:debian_linux:python3-sqlalchemy

Required KB Items: Host/local_checks_enabled, Host/Debian/release, Host/Debian/dpkg-l

Exploit Available: true

Exploit Ease: Exploits are available

Patch Publication Date: 11/6/2021

Vulnerability Publication Date: 2/6/2019

Reference Information

CVE: CVE-2019-7164, CVE-2019-7548