Test ID:	1.3.6.1.4.1.25623.1.1.12.2009.870.1
Category:	Ubuntu Local Security Checks
Title:	Ubuntu: Security Advisory (USN-870-1)
Summary:	The remote host is missing an update for the 'pygresql' package(s) announced via the USN-870-1 advisory.
Description:	Summary: The remote host is missing an update for the 'pygresql' package(s) announced via the USN-870-1 advisory. Vulnerability Insight: 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) Affected Software/OS: 'pygresql' package(s) on Ubuntu 8.04, Ubuntu 8.10. Solution: Please install the updated package(s). CVSS Score: 7.5 CVSS Vector: AV:N/AC:L/Au:N/C:P/I:P/A:P
Cross-Ref:	Common Vulnerability Exposure (CVE) ID: CVE-2009-2940 Debian Security Information: DSA-1911 (Google Search) http://www.debian.org/security/2009/dsa-1911 http://www.osvdb.org/59028 http://secunia.com/advisories/37046 http://secunia.com/advisories/37654 http://ubuntu.com/usn/usn-870-1
Copyright	Copyright (C) 2022 Greenbone AG

This is only one of 146377 vulnerability tests in our test suite. Find out more about running a complete security audit. To run a free test of this vulnerability against your system, register below.