PyMySQL through 1.1.0 allows SQL injection if used with untrusted JSON input because keys are not escaped by escape_dict.

The remote Oracle Linux 8 host has a package installed that is affected by a vulnerability as referenced in the ELSA-2024-4245 advisory.

    [1.1.0-3]
    - Security fix for CVE-2024-36039     Resolves: RHEL-38366

Tenable has extracted the preceding description block directly from the Oracle Linux 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 AlmaLinux 8 host has a package installed that is affected by a vulnerability as referenced in the ALSA-2024:4244 advisory.

    * python-pymysql: SQL injection if used with untrusted JSON input (CVE-2024-36039)

Tenable has extracted the preceding description block directly from the AlmaLinux 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 AlmaLinux 8 host has a package installed that is affected by a vulnerability as referenced in the ALSA-2024:4245 advisory.

    * python-pymysql: SQL injection if used with untrusted JSON input (CVE-2024-36039)

Tenable has extracted the preceding description block directly from the AlmaLinux 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 Oracle Linux 8 host has a package installed that is affected by a vulnerability as referenced in the ELSA-2024-4244 advisory.

    [1.0.2-2]
    - Security fix for CVE-2024-36039     Resolves: RHEL-38365

Tenable has extracted the preceding description block directly from the Oracle Linux 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 Redhat Enterprise Linux 8 host has a package installed that is affected by a vulnerability as referenced in the RHSA-2024:4245 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.

    Security Fix(es):

    * python-pymysql: SQL injection if used with untrusted JSON input (CVE-2024-36039)

    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 this issue but has instead relied only on the application's self-reported version number.

The remote Redhat Enterprise Linux 8 host has a package installed that is affected by a vulnerability as referenced in the RHSA-2024:4244 advisory.

    This package contains a pure-Python MySQL client library. The goal of PyMySQL is to be a drop-in     replacement for MySQLdb and work on CPython, PyPy, IronPython and Jython.

    Security Fix(es):

    * python-pymysql: SQL injection if used with untrusted JSON input (CVE-2024-36039)

    For more details about the security issue(s), including the impact, a CVSS score, acknowledgments, and     other related information, refer 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 this issue but has instead relied only on the application's self-reported version number.

The remote Fedora 40 host has a package installed that is affected by multiple vulnerabilities as referenced in the FEDORA-2024-b26f07d27b advisory.

    Update to 1.1.1 to fix [CVE CVE-2024-36039](https://github.com/advisories/GHSA-v9hf-5j83-6xpp)

Tenable has extracted the preceding description block directly from the Fedora 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 Fedora 39 host has a package installed that is affected by multiple vulnerabilities as referenced in the FEDORA-2024-e7141ab284 advisory.

    Update to 1.1.1 to fix [CVE CVE-2024-36039](https://github.com/advisories/GHSA-v9hf-5j83-6xpp)

Tenable has extracted the preceding description block directly from the Fedora 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 openSUSE 15 host has a package installed that is affected by a vulnerability as referenced in the SUSE- SU-2024:1925-1 advisory.

    - CVE-2024-36039: Fixed SQL injection when used with untrusted JSON input (bsc#1225070).

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 Ubuntu 20.04 LTS / 22.04 LTS / 23.10 / 24.04 LTS host has a package installed that is affected by a vulnerability as referenced in the USN-6801-1 advisory.

    It was discovered that PyMySQL incorrectly escaped untrusted JSON input. 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.

The remote Debian 11 / 12 host has packages installed that are affected by a vulnerability as referenced in the dsa-5700 advisory.

    - -------------------------------------------------------------------------     Debian Security Advisory DSA-5700-1                   security@debian.org     https://www.debian.org/security/                       Moritz Muehlenhoff     May 29, 2024                          https://www.debian.org/security/faq
    - -------------------------------------------------------------------------

    Package        : python-pymysql     CVE ID         : CVE-2024-36039

    An SQL injection was discovered in pymysql, a pure Python MySQL driver.

    For the oldstable distribution (bullseye), this problem has been fixed     in version 0.9.3-2+deb11u1.

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

    We recommend that you upgrade your python-pymysql packages.

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

    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.

The remote Debian 10 host has packages installed that are affected by a vulnerability as referenced in the dla-3822 advisory.

    - -------------------------------------------------------------------------     Debian LTS Advisory DLA-3822-1                debian-lts@lists.debian.org     https://www.debian.org/lts/security/                           Chris Lamb     May 27, 2024                                  https://wiki.debian.org/LTS
    - -------------------------------------------------------------------------

    Package        : python-pymysql     Version        : 0.9.3-1+deb10u1     CVE ID         : CVE-2024-36039     Debian Bug     : 1071628

    It was discovered that there was a potential SQL injection attack     in python-pymysql, a MySQL client library for Python. This was     exploitable when python-pymysql was used with untrusted JSON input     as keys were not escaped by the escape_dict routine.

    For Debian 10 buster, this problem has been fixed in version     0.9.3-1+deb10u1.

    We recommend that you upgrade your python-pymysql packages.

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

    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

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	Severity
201846	Oracle Linux 8 : python3 (ELSA-2024-4245)	Nessus	Oracle Linux Local Security Checks	medium
201542	AlmaLinux 8 : python3.11-PyMySQL (ALSA-2024:4244)	Nessus	Alma Linux Local Security Checks	medium
201536	AlmaLinux 8 : python3 (ALSA-2024:4245)	Nessus	Alma Linux Local Security Checks	medium
201337	Oracle Linux 8 : python3.11-PyMySQL (ELSA-2024-4244)	Nessus	Oracle Linux Local Security Checks	medium
201291	RHEL 8 : python3 (RHSA-2024:4245)	Nessus	Red Hat Local Security Checks	medium
201283	RHEL 8 : python3.11-PyMySQL (RHSA-2024:4244)	Nessus	Red Hat Local Security Checks	medium
200874	Fedora 40 : python-PyMySQL (2024-b26f07d27b)	Nessus	Fedora Local Security Checks	critical
200868	Fedora 39 : python-PyMySQL (2024-e7141ab284)	Nessus	Fedora Local Security Checks	critical
200143	openSUSE 15 Security Update : python-PyMySQL (SUSE-SU-2024:1925-1)	Nessus	SuSE Local Security Checks	high
198153	Ubuntu 20.04 LTS / 22.04 LTS / 23.10 / 24.04 LTS : PyMySQL vulnerability (USN-6801-1)	Nessus	Ubuntu Local Security Checks	critical
198083	Debian dsa-5700 : python-pymysql-doc - security update	Nessus	Debian Local Security Checks	critical
198065	Debian dla-3822 : python-pymysql - security update	Nessus	Debian Local Security Checks	critical

Detections

Analytics

CVE-2024-36039

medium

Tenable Plugins

medium

medium

medium

medium

medium

medium

critical

critical

high

critical

critical

critical