CentOS 5 / 6 : postgresql / postgresql84 (CESA-2012:0678)

medium Nessus Plugin ID 59214

Synopsis

The remote CentOS host is missing one or more security updates.

Description

Updated postgresql84 and postgresql packages that fix three security issues are now available for Red Hat Enterprise Linux 5 and 6 respectively.

The Red Hat Security Response Team has rated this update as having moderate security impact. Common Vulnerability Scoring System (CVSS) base scores, which give detailed severity ratings, are available for each vulnerability from the CVE links in the References section.

PostgreSQL is an advanced object-relational database management system (DBMS).

The pg_dump utility inserted object names literally into comments in the SQL script it produces. An unprivileged database user could create an object whose name includes a newline followed by a SQL command.
This SQL command might then be executed by a privileged user during later restore of the backup dump, allowing privilege escalation.
(CVE-2012-0868)

When configured to do SSL certificate verification, PostgreSQL only checked the first 31 characters of the certificate's Common Name field. Depending on the configuration, this could allow an attacker to impersonate a server or a client using a certificate from a trusted Certificate Authority issued for a different name. (CVE-2012-0867)

CREATE TRIGGER did not do a permissions check on the trigger function to be called. This could possibly allow an authenticated database user to call a privileged trigger function on data of their choosing.
(CVE-2012-0866)

These updated packages upgrade PostgreSQL to version 8.4.11, which fixes these issues as well as several data-corruption issues and lesser non-security issues. Refer to the PostgreSQL Release Notes for a full list of changes :

http://www.postgresql.org/docs/8.4/static/release.html

All PostgreSQL users are advised to upgrade to these updated packages, which correct these issues. If the postgresql service is running, it will be automatically restarted after installing this update.

Solution

Update the affected postgresql and / or postgresql84 packages.

See Also

http://www.nessus.org/u?fcf0109b

http://www.nessus.org/u?b2e4df4e

Plugin Details

Severity: Medium

ID: 59214

File Name: centos_RHSA-2012-0678.nasl

Version: 1.12

Type: local

Agent: unix

Published: 5/22/2012

Updated: 1/4/2021

Supported Sensors: Agentless Assessment, Frictionless Assessment Agent, Frictionless Assessment AWS, Frictionless Assessment Azure

Risk Information

VPR

Risk Factor: Medium

Score: 5.9

CVSS v2

Risk Factor: Medium

Base Score: 6.8

Temporal Score: 5

Vector: AV:N/AC:M/Au:N/C:P/I:P/A:P

Temporal Vector: E:U/RL:OF/RC:C

CVSS Score Source: CVE-2012-0868

Vulnerability Information

CPE: p-cpe:/a:centos:centos:postgresql, p-cpe:/a:centos:centos:postgresql-contrib, p-cpe:/a:centos:centos:postgresql-devel, p-cpe:/a:centos:centos:postgresql-docs, p-cpe:/a:centos:centos:postgresql-libs, p-cpe:/a:centos:centos:postgresql-plperl, p-cpe:/a:centos:centos:postgresql-plpython, p-cpe:/a:centos:centos:postgresql-pltcl, p-cpe:/a:centos:centos:postgresql-server, p-cpe:/a:centos:centos:postgresql-test, p-cpe:/a:centos:centos:postgresql84, p-cpe:/a:centos:centos:postgresql84-contrib, p-cpe:/a:centos:centos:postgresql84-devel, p-cpe:/a:centos:centos:postgresql84-docs, p-cpe:/a:centos:centos:postgresql84-libs, p-cpe:/a:centos:centos:postgresql84-plperl, p-cpe:/a:centos:centos:postgresql84-plpython, p-cpe:/a:centos:centos:postgresql84-pltcl, p-cpe:/a:centos:centos:postgresql84-python, p-cpe:/a:centos:centos:postgresql84-server, p-cpe:/a:centos:centos:postgresql84-tcl, p-cpe:/a:centos:centos:postgresql84-test, cpe:/o:centos:centos:5, cpe:/o:centos:centos:6

Required KB Items: Host/local_checks_enabled, Host/CentOS/release, Host/CentOS/rpm-list

Exploit Ease: No known exploits are available

Patch Publication Date: 5/21/2012

Vulnerability Publication Date: 7/18/2012

Reference Information

CVE: CVE-2012-0866, CVE-2012-0867, CVE-2012-0868

BID: 52188

RHSA: 2012:0678