Ubuntu 6.06 LTS : postgresql-8.1 vulnerabilities (USN-369-1)

Medium Nessus Plugin ID 27949


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


Michael Fuhr discovered an incorrect type check when handling unknown literals. By attempting to coerce such a literal to the ANYARRAY type, a local authenticated attacker could cause a server crash.

Josh Drake and Alvaro Herrera reported a crash when using aggregate functions in UPDATE statements. A local authenticated attacker could exploit this to crash the server backend. This update disables this construct, since it is not very well defined and forbidden by the SQL standard.

Sergey Koposov discovered a flaw in the duration logging. This could cause a server crash under certain circumstances.

Please note that these flaws can usually not be exploited through web and other applications that use a database and are exposed to untrusted input, so these flaws do not pose a threat in usual setups.

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 packages.

Plugin Details

Severity: Medium

ID: 27949

File Name: ubuntu_USN-369-1.nasl

Version: $Revision: 1.11 $

Type: local

Agent: unix

Published: 2007/11/10

Modified: 2016/05/27

Dependencies: 12634

Risk Information

Risk Factor: Medium


Base Score: 4

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

Vulnerability Information

CPE: p-cpe:/a:canonical:ubuntu_linux:libecpg-compat2, p-cpe:/a:canonical:ubuntu_linux:libecpg-dev, p-cpe:/a:canonical:ubuntu_linux:libecpg5, p-cpe:/a:canonical:ubuntu_linux:libpgtypes2, p-cpe:/a:canonical:ubuntu_linux:libpq-dev, p-cpe:/a:canonical:ubuntu_linux:libpq4, p-cpe:/a:canonical:ubuntu_linux:postgresql-8.1, p-cpe:/a:canonical:ubuntu_linux:postgresql-client-8.1, p-cpe:/a:canonical:ubuntu_linux:postgresql-contrib-8.1, p-cpe:/a:canonical:ubuntu_linux:postgresql-doc-8.1, p-cpe:/a:canonical:ubuntu_linux:postgresql-plperl-8.1, p-cpe:/a:canonical:ubuntu_linux:postgresql-plpython-8.1, p-cpe:/a:canonical:ubuntu_linux:postgresql-pltcl-8.1, p-cpe:/a:canonical:ubuntu_linux:postgresql-server-dev-8.1, cpe:/o:canonical:ubuntu_linux:6.06:-:lts

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

Patch Publication Date: 2006/10/24

Vulnerability Publication Date: 2006/06/21

Reference Information

CVE: CVE-2006-5540, CVE-2006-5541, CVE-2006-5542

OSVDB: 30018, 30019, 30020

USN: 369-1