USN-870-1: PyGreSQL vulnerability | Ubuntu security notices

Packages

pygresql -

Details

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)

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)

Update instructions

In general, a standard system upgrade is sufficient to effect the necessary changes.

Learn more about how to get the fixes.

Ubuntu Release	Package Version
8.10 intrepid	python-pygresql – 1:3.8.1-3ubuntu0.1
8.04 hardy	python-pygresql – 1:3.8.1-2ubuntu0.1

Reduce your security exposure

Ubuntu Pro provides ten-year security coverage to 25,000+ packages in Main and Universe repositories, and it is free for up to five machines.

Get Ubuntu Pro

References

CVE-2009-2940

CVE-2009-2940