PT-2009-5288 · Pygresql · Pygresql

Steffen Joeris · Published 2009-10-22 · Updated 2022-05-02 · CVE-2009-2940

Positive Technologies (AI Summary)

CVSS v2.0

7.5

High

Base vector

AV:N/AC:L/Au:N/C:P/I:P/A:P

Name of the Vulnerable Software and Affected Versions: PyGreSQL versions 3.8.1 and 4.0

Description: The issue arises from improper support of the PQescapeStringConn function in the pygresql module, potentially allowing remote attackers to exploit escaping issues involving multibyte character encodings. This can lead to SQL injections when processing certain multi-byte character sequences. The problem is due to PyGreSQL not using PostgreSQL's safe string and bytea functions in its own escaping functions.

Recommendations: For PyGreSQL version 3.8.1, adjust applications to use the new connection.escape string() and connection.escape bytea() functions instead of pg.escape string() and pg.escape bytea(). For PyGreSQL version 4.0, adjust applications to use the new connection.escape string() and connection.escape bytea() functions instead of pg.escape string() and pg.escape bytea().

Fix

SQL injection

Weakness Enumeration

CWE-89

Related Identifiers

CVE-2009-2940

DSA-1911-1

GHSA-XV6X-43GQ-4HFJ

PYSEC-2009-18

Affected Products

Pygresql

References · 15

• https://security-tracker.debian.org/tracker/CVE-2009-2940 · Vendor Advisory
• http://ubuntu.com/usn/usn-870-1 · Vendor Advisory
• http://secunia.com/advisories/37046 · Vendor Advisory
• https://osv.dev/vulnerability/DEBIAN-CVE-2009-2940 · Vendor Advisory
• https://nvd.nist.gov/vuln/detail/CVE-2009-2940 · Security Note
• http://debian.org/security/2009/dsa-1911 · Vendor Advisory
• https://osv.dev/vulnerability/GHSA-xv6x-43gq-4hfj · Vendor Advisory
• https://osv.dev/vulnerability/PYSEC-2009-18 · Vendor Advisory
• https://osv.dev/vulnerability/CVE-2009-2940 · Vendor Advisory
• https://github.com/pypa/advisory-database/tree/main/vulns/pygresql/PYSEC-2009-18.yaml · Note
• https://github.com/PyGreSQL/PyGreSQL · Note
• https://github.com/PyGreSQL/PyGreSQL/commit/f7237d773e6f4d5a7da3d99bb6bc5062bd07935e · Note
• https://github.com/PyGreSQL/PyGreSQL/commit/8e19320b130946eed6f043297e3e4e005a523612 · Note
• http://secunia.com/advisories/37654 · Note
• http://osvdb.org/59028 · Note