SQLAlchemy through 1.2.17 and 1.3.x through 1.3.0b2 allows SQL Injection via the order_by parameter.

The remote Redhat Enterprise Linux 6 host has one or more packages installed that are affected by a vulnerability that has been acknowledged by the vendor but will not be patched.

  - python-sqlalchemy: SQL Injection when the order_by parameter can be controlled (CVE-2019-7164)

Note that Nessus has not tested for this issue but has instead relied on the package manager's report that the package is installed.

The remote Redhat Enterprise Linux 7 host has one or more packages installed that are affected by a vulnerability that has been acknowledged by the vendor but will not be patched.

  - python-sqlalchemy: SQL Injection when the order_by parameter can be controlled (CVE-2019-7164)

Note that Nessus has not tested for this issue but has instead relied on the package manager's report that the package is installed.

This plugin has been deprecated as it does not adhere to established standards for this style of check.

The remote Rocky Linux 8 host has packages installed that are affected by multiple vulnerabilities as referenced in the RLSA-2019:0981 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)

  - Python 2.7.x through 2.7.16 and 3.x through 3.7.2 is affected by: Improper Handling of Unicode Encoding     (with an incorrect netloc) during NFKC normalization. The impact is: Information disclosure (credentials,     cookies, etc. that are cached against a given hostname). The components are: urllib.parse.urlsplit,     urllib.parse.urlparse. The attack vector is: A specially crafted URL could be incorrectly parsed to locate     cookies or authentication data and send that information to a different host than when parsed correctly.
    This is fixed in: v2.7.17, v2.7.17rc1, v2.7.18, v2.7.18rc1; v3.5.10, v3.5.10rc1, v3.5.7, v3.5.8,     v3.5.8rc1, v3.5.8rc2, v3.5.9; v3.6.10, v3.6.10rc1, v3.6.11, v3.6.11rc1, v3.6.12, v3.6.9, v3.6.9rc1;
    v3.7.3, v3.7.3rc1, v3.7.4, v3.7.4rc1, v3.7.4rc2, v3.7.5, v3.7.5rc1, v3.7.6, v3.7.6rc1, v3.7.7, v3.7.7rc1,     v3.7.8, v3.7.8rc1, v3.7.9. (CVE-2019-9636)

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

The remote Rocky Linux 8 host has packages installed that are affected by multiple vulnerabilities as referenced in the RLSA-2019:0984 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 these issues but has instead relied only on the application's self-reported version number.

The version of FreeBSD installed on the remote host is prior to tested version. It is, therefore, affected by multiple vulnerabilities as referenced in the d2293e22-4390-42c2-a323-34cca2066000 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 these issues but has instead relied only on the application's self-reported version number.

The version of FreeBSD installed on the remote host is prior to tested version. It is, therefore, affected by multiple vulnerabilities as referenced in the 8ccff771-ceca-43a0-85ad-3e595e73b425 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 these issues but has instead relied only on the application's self-reported version number.

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.

The remote CentOS Linux 8 host has packages installed that are affected by multiple vulnerabilities as referenced in the CESA-2019:0984 advisory.

  - python-sqlalchemy: SQL Injection when the order_by parameter can be controlled (CVE-2019-7164)

  - python-sqlalchemy: SQL Injection when the group_by parameter can be controlled (CVE-2019-7548)

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

The remote CentOS Linux 8 host has packages installed that are affected by multiple vulnerabilities as referenced in the CESA-2019:0981 advisory.

  - python-sqlalchemy: SQL Injection when the order_by parameter can be controlled (CVE-2019-7164)

  - python-sqlalchemy: SQL Injection when the group_by parameter can be controlled (CVE-2019-7548)

  - python: Information Disclosure due to urlsplit improper NFKC normalization (CVE-2019-9636)

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

This update for python-SQLAlchemy fixes the following issues :

Security issues fixed :

CVE-2019-7164: Fixed SQL Injection via the order_by parameter (bsc#1124593).

CVE-2019-7548: Fixed SQL Injection via the group_by parameter (bsc#1124593).

Note that Tenable Network Security has extracted the preceding description block directly from the SUSE security advisory. Tenable has attempted to automatically clean and format it as much as possible without introducing additional issues.

This update for python-SQLAlchemy fixes the following issues :

Security issues fixed :

  - CVE-2019-7164: Fixed SQL Injection via the order_by     parameter (bsc#1124593).

  - CVE-2019-7548: Fixed SQL Injection via the group_by     parameter (bsc#1124593).

This update was imported from the SUSE:SLE-15-SP1:Update update project.

This update for python-SQLAlchemy fixes the following issues :

Security issues fixed :

  - CVE-2019-7164: Fixed SQL Injection via the order_by     parameter (bsc#1124593).

  - CVE-2019-7548: Fixed SQL Injection via the group_by     parameter (bsc#1124593).

This update was imported from the SUSE:SLE-15:Update update project.

The remote Oracle Linux 8 host has packages installed that are affected by multiple vulnerabilities as referenced in the ELSA-2019-0984 advisory.

    - Rebase to 1.3.2 to fix CVE-2019-7164 and CVE-2019-7548     Resolves: rhbz#1693978

Tenable has extracted the preceding description block directly from the Oracle Linux security advisory.

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

The remote Oracle Linux 8 host has packages installed that are affected by multiple vulnerabilities as referenced in the ELSA-2019-0981 advisory.

    - Rebase to 1.3.2 to fix CVE-2019-7164 and CVE-2019-7548     Resolves: rhbz#1693978
    - Security fix for CVE-2019-9636 (rhbz#1693974)

    python2-pip

Tenable has extracted the preceding description block directly from the Oracle Linux security advisory.

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

The remote Redhat Enterprise Linux 8 host has packages installed that are affected by multiple vulnerabilities as referenced in the RHSA-2019:0984 advisory.

    Python is an interpreted, interactive, object-oriented programming language, which includes modules,     classes, exceptions, very high level dynamic data types and dynamic typing. Python supports interfaces to     many system calls and libraries, as well as to various windowing systems.

    SQLAlchemy is an Object Relational Mapper (ORM) that provides a flexible, high-level interface to SQL     databases.

    Security Fix(es):

    * python-sqlalchemy: SQL Injection when the order_by parameter can be controlled (CVE-2019-7164)

    * python-sqlalchemy: SQL Injection when the group_by parameter can be controlled (CVE-2019-7548)

    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.

Tenable has extracted the preceding description block directly from the Red Hat Enterprise Linux security advisory.

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

The remote Redhat Enterprise Linux 8 host has packages installed that are affected by multiple vulnerabilities as referenced in the RHSA-2019:0981 advisory.

    Python is an interpreted, interactive, object-oriented programming language that supports modules,     classes, exceptions, high-level dynamic data types, and dynamic typing.

    SQLAlchemy is an Object Relational Mapper (ORM) that provides a flexible, high-level interface to SQL     databases.

    Security Fix(es):

    * python: Information Disclosure due to urlsplit improper NFKC normalization (CVE-2019-9636)

    * python-sqlalchemy: SQL Injection when the order_by parameter can be controlled (CVE-2019-7164)

    * python-sqlalchemy: SQL Injection when the group_by parameter can be controlled (CVE-2019-7548)

    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.

Tenable has extracted the preceding description block directly from the Red Hat Enterprise Linux security advisory.

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

Two vulnerabilities were discovered in SQLALchemy, a Python SQL Toolkit and Object Relational Mapper.

CVE-2019-7164

SQLAlchemy allows SQL Injection via the order_by parameter.

CVE-2019-7548

SQLAlchemy has SQL Injection when the group_by parameter can be controlled.

The SQLAlchemy project warns that these security fixes break the seldom-used text coercion feature.

For Debian 8 'Jessie', these problems have been fixed in version 0.9.8+dfsg-0.1+deb8u1.

We recommend that you upgrade your sqlalchemy packages.

NOTE: Tenable Network Security has extracted the preceding description block directly from the DLA security advisory. Tenable has attempted to automatically clean and format it as much as possible without introducing additional issues.

ID	Name	Product	Family	Severity
199188	RHEL 6 : calamari-server (Unpatched Vulnerability)	Nessus	Red Hat Local Security Checks	critical
199143	RHEL 7 : calamari-server (Unpatched Vulnerability)	Nessus	Red Hat Local Security Checks	critical
196810	RHEL 6 : python-sqlalchemy (Unpatched Vulnerability) (deprecated)	Nessus	Red Hat Local Security Checks	critical
196809	RHEL 7 : python-sqlalchemy (Unpatched Vulnerability) (deprecated)	Nessus	Red Hat Local Security Checks	critical
184893	Rocky Linux 8 : python27:2.7 (RLSA-2019:0981)	Nessus	Rocky Linux Local Security Checks	critical
184542	Rocky Linux 8 : python36:3.6 (RLSA-2019:0984)	Nessus	Rocky Linux Local Security Checks	critical
174322	FreeBSD : py39-sqlalchemy12 -- multiple SQL Injection vulnerabilities (d2293e22-4390-42c2-a323-34cca2066000)	Nessus	FreeBSD Local Security Checks	critical
174289	FreeBSD : py39-sqlalchemy11 -- multiple SQL Injection vulnerabilities (8ccff771-ceca-43a0-85ad-3e595e73b425)	Nessus	FreeBSD Local Security Checks	critical
154950	Debian DLA-2811-1 : sqlalchemy - LTS security update	Nessus	Debian Local Security Checks	critical
145649	CentOS 8 : python36:3.6 (CESA-2019:0984)	Nessus	CentOS Local Security Checks	critical
145592	CentOS 8 : python27:2.7 (CESA-2019:0981)	Nessus	CentOS Local Security Checks	critical
129096	SUSE SLED15 / SLES15 Security Update : python-SQLAlchemy (SUSE-SU-2019:2253-2)	Nessus	SuSE Local Security Checks	critical
128519	openSUSE Security Update : python-SQLAlchemy (openSUSE-2019-2064)	Nessus	SuSE Local Security Checks	critical
128455	openSUSE Security Update : python-SQLAlchemy (openSUSE-2019-2039)	Nessus	SuSE Local Security Checks	critical
128410	SUSE SLED15 / SLES15 Security Update : python-SQLAlchemy (SUSE-SU-2019:2253-1)	Nessus	SuSE Local Security Checks	critical
128144	SUSE SLED15 / SLES15 Security Update : python-SQLAlchemy (SUSE-SU-2019:2211-1)	Nessus	SuSE Local Security Checks	critical
127573	Oracle Linux 8 : python36:3.6 (ELSA-2019-0984)	Nessus	Oracle Linux Local Security Checks	critical
127571	Oracle Linux 8 : python27:2.7 (ELSA-2019-0981)	Nessus	Oracle Linux Local Security Checks	critical
124670	RHEL 8 : python36:3.6 (RHSA-2019:0984)	Nessus	Red Hat Local Security Checks	critical
124668	RHEL 8 : python27:2.7 (RHSA-2019:0981)	Nessus	Red Hat Local Security Checks	critical
122930	Debian DLA-1718-1 : sqlalchemy security update	Nessus	Debian Local Security Checks	critical

Detections

Analytics

CVE-2019-7164

critical

Tenable Plugins

critical

critical

critical

critical

critical

critical

critical

critical

critical

critical

critical

critical

critical

critical

critical

critical

critical

critical

critical

critical

critical