Ubuntu 8.04 LTS / 8.10 : pygresql vulnerability (USN-870-1)

High Nessus Plugin ID 43108


The remote Ubuntu host is missing one or more security-related patches.


Steffen Joeris discovered that PyGreSQL 3.8 did not use PostgreSQL's safe string and bytea functions in its own escaping functions. As a result, applications written to use PyGreSQL's escaping functions are vulnerable to SQL injections when processing certain multi-byte character sequences. Because the safe functions require a database connection, to maintain backwards compatibility, pg.escape_string() and pg.escape_bytea() are still available, but applications will have to be adjusted to use the new pyobj.escape_string() and pyobj.escape_bytea() functions. For example, code containing :

import pg connection = pg.connect(...) escaped = pg.escape_string(untrusted_input)

should be adjusted to use :

import pg connection = pg.connect(...) escaped = connection.escape_string(untrusted_input).

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


Update the affected python-pygresql and / or python-pygresql-dbg packages.

Plugin Details

Severity: High

ID: 43108

File Name: ubuntu_USN-870-1.nasl

Version: $Revision: 1.9 $

Type: local

Agent: unix

Published: 2009/12/11

Modified: 2016/05/27

Dependencies: 12634

Risk Information

Risk Factor: High


Base Score: 7.5

Vector: CVSS2#AV:N/AC:L/Au:N/C:P/I:P/A:P

Vulnerability Information

CPE: p-cpe:/a:canonical:ubuntu_linux:python-pygresql, p-cpe:/a:canonical:ubuntu_linux:python-pygresql-dbg, cpe:/o:canonical:ubuntu_linux:8.04:-:lts, cpe:/o:canonical:ubuntu_linux:8.10

Required KB Items: Host/cpu, Host/Ubuntu, Host/Ubuntu/release, Host/Debian/dpkg-l

Patch Publication Date: 2009/12/10

Reference Information

CVE: CVE-2009-2940

USN: 870-1