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

critical Nessus Plugin ID 154950


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


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.

- 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.


Upgrade the sqlalchemy packages.

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

See Also

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, Nessus

Risk Information


Risk Factor: Medium

Score: 6.7


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


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, p-cpe:/a:debian:debian_linux:python-sqlalchemy-doc, p-cpe:/a:debian:debian_linux:python-sqlalchemy-ext, p-cpe:/a:debian:debian_linux:python3-sqlalchemy, p-cpe:/a:debian:debian_linux:python3-sqlalchemy-ext, cpe:/o:debian:debian_linux:9.0

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