Ubuntu 8.04 LTS / 8.10 : pygresql vulnerability (USN-870-1)
High Nessus Plugin ID 43108
SynopsisThe remote Ubuntu host is missing one or more security-related patches.
DescriptionSteffen 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.
SolutionUpdate the affected python-pygresql and / or python-pygresql-dbg packages.