A vulnerability was found in python-sql where unary operators do not escape non-Expression.

The remote Ubuntu 18.04 LTS / 20.04 LTS / 22.04 LTS / 24.04 LTS / Pro Realtime 24.04 LTS host has packages installed that are affected by a vulnerability as referenced in the USN-8765-1 advisory.

    Cdric Krier discovered that python-sql incorrectly escaped values passed to unary operators. An attacker     could possibly use this issue to perform SQL injection attacks.

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

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

There are packages installed that are affected by a vulnerability referenced in the following CVE:

  - A vulnerability was found in python-sql where unary operators do not escape non-Expression.
    (CVE-2024-9774)

The remote Fedora 41 host has a package installed that is affected by a vulnerability as referenced in the FEDORA-2024-1a2f1733ad advisory.

    - update to 1.5.2

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

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

The remote openSUSE 15 host has packages installed that are affected by a vulnerability as referenced in the openSUSE- SU-2024:0412-1 advisory.

    - CVE-2024-9774: Fixed that unary operators does not escape non-Expression (boo#1234653).

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

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

The remote openSUSE 15 host has a package installed that is affected by a vulnerability as referenced in the openSUSE- SU-2024:0413-1 advisory.

    - CVE-2024-9774: Fixed that unary operators does not escape non-Expression (boo#1234653).

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

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

The remote Debian 11 host has a package installed that is affected by a vulnerability as referenced in the dla-3932 advisory.

    -------------------------------------------------------------------------     Debian LTS Advisory DLA-3932-1                debian-lts@lists.debian.org     https://www.debian.org/lts/security/               Santiago Ruano Rincn     October 22, 2024                              https://wiki.debian.org/LTS
    -------------------------------------------------------------------------

    Package        : python-sql     Version        : 1.2.1-1+deb11u1     CVE ID         : CVE-2024-9774

    Cdric Krier discovered that python-sql, a library to write SQL queries     in a pythonic way, performed insufficient sanitising which could result     in SQL injection.

    For Debian 11 bullseye, this problem has been fixed in version     1.2.1-1+deb11u1.

    We recommend that you upgrade your python-sql packages.

    For the detailed security status of python-sql please refer to     its security tracker page at:
    https://security-tracker.debian.org/tracker/python-sql

    Further information about Debian LTS security advisories, how to apply     these updates to your system and frequently asked questions can be     found at: https://wiki.debian.org/LTS     Attachment:
    signature.asc     Description: PGP signature

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

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

The remote Debian 12 host has a package installed that is affected by a vulnerability as referenced in the dsa-5795 advisory.

    - -------------------------------------------------------------------------     Debian Security Advisory DSA-5795-1                   security@debian.org     https://www.debian.org/security/                       Moritz Muehlenhoff     October 21, 2024                      https://www.debian.org/security/faq
    - -------------------------------------------------------------------------

    Package        : python-sql     CVE ID         : CVE-2024-9774

    Cedric Krier discovered that python-sql, a library to write SQL queries     in a pythonic way, performed insufficient sanitising which could result     in SQL injection.

    For the stable distribution (bookworm), this problem has been fixed in     version 1.4.0-1+deb12u1.

    We recommend that you upgrade your python-sql packages.

    For the detailed security status of python-sql please refer to     its security tracker page at:
    https://security-tracker.debian.org/tracker/python-sql

    Further information about Debian Security Advisories, how to apply     these updates to your system and frequently asked questions can be     found at: https://www.debian.org/security/

    Mailing list: debian-security-announce@lists.debian.org

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

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

ID	Name	Product	Family	Type	Severity
346241	Ubuntu 18.04 LTS / 20.04 LTS / 22.04 LTS / 24.04 LTS / Pro Realtime 24.04 LTS : python-sql vulnerability (USN-8765-1)	Nessus	Ubuntu Local Security Checks	Local	medium
417657	SCA: security update for python-sql (GHSA-pq9p-pc3p-9hm4)	Tenable Cloud Security	SCA Checks	Local	medium
417657	SCA: security update for python-sql (GHSA-pq9p-pc3p-9hm4)	Tenable Self-Hosted Container Security	SCA Checks	Local	medium
213400	Fedora 41 : python-sql (2024-1a2f1733ad)	Nessus	Fedora Local Security Checks	Local	medium
213320	openSUSE 15 Security Update : python-python-sql (openSUSE-SU-2024:0412-1)	Nessus	SuSE Local Security Checks	Local	medium
213319	openSUSE 15 Security Update : python-python-sql (openSUSE-SU-2024:0413-1)	Nessus	SuSE Local Security Checks	Local	medium
209526	Debian dla-3932 : python3-sql - security update	Nessus	Debian Local Security Checks	Local	medium
209509	Debian dsa-5795 : python3-sql - security update	Nessus	Debian Local Security Checks	Local	medium

Detections

Analytics

CVE-2024-9774

medium

Tenable Plugins

medium

medium

medium

medium

medium

medium

medium

medium