Issued:

2012-06-25

Updated:

2012-06-25

RHSA-2012:1037 - Moderate: postgresql and postgresql84 security update

Synopsis

Moderate: postgresql and postgresql84 security update

Type/Severity

Security Advisory Moderate

Topic

Updated postgresql84 and postgresql packages that fix two 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.

Description

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

A flaw was found in the way the crypt() password hashing function from the optional PostgreSQL pgcrypto contrib module performed password transformation when used with the DES algorithm. If the password string to be hashed contained the 0x80 byte value, the remainder of the string was ignored when calculating the hash, significantly reducing the password strength. This made brute-force guessing more efficient as the whole password was not required to gain access to protected resources. (CVE-2012-2143)

Note: With this update, the rest of the string is properly included in the DES hash; therefore, any previously stored password values that are affected by this issue will no longer match. In such cases, it will be necessary for those stored password hashes to be updated.

A denial of service flaw was found in the way the PostgreSQL server performed a user privileges check when applying SECURITY DEFINER or SET attributes to a procedural language's (such as PL/Perl or PL/Python) call handler function. A non-superuser database owner could use this flaw to cause the PostgreSQL server to crash due to infinite recursion. (CVE-2012-2655)

Upstream acknowledges Rubin Xu and Joseph Bonneau as the original reporters of the CVE-2012-2143 issue.

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

Content from www.postgresql.org is not included.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

Before applying this update, make sure all previously-released errata relevant to your system have been applied.

This update is available via the Red Hat Network. Details on how to use the Red Hat Network to apply this update are available at https://access.redhat.com/knowledge/articles/11258

Affected Products

Updated Packages

• postgresql84-plpython-8.4.12-1.el5_8.i386.rpm
• postgresql84-docs-8.4.12-1.el5_8.i386.rpm
• postgresql84-plpython-8.4.12-1.el5_8.ppc.rpm
• postgresql84-plpython-8.4.12-1.el5_8.s390x.rpm
• postgresql84-contrib-8.4.12-1.el5_8.ppc.rpm
• postgresql84-docs-8.4.12-1.el5_8.ppc.rpm
• postgresql-plperl-8.4.12-1.el6_2.ppc64.rpm
• postgresql-8.4.12-1.el6_2.s390x.rpm
• postgresql84-8.4.12-1.el5_8.ppc.rpm
• postgresql84-libs-8.4.12-1.el5_8.s390.rpm
• postgresql84-server-8.4.12-1.el5_8.i386.rpm
• postgresql-contrib-8.4.12-1.el6_2.ppc64.rpm
• postgresql-contrib-8.4.12-1.el6_2.x86_64.rpm
• postgresql84-test-8.4.12-1.el5_8.x86_64.rpm
• postgresql-test-8.4.12-1.el6_2.x86_64.rpm
• postgresql84-test-8.4.12-1.el5_8.ppc.rpm
• postgresql-docs-8.4.12-1.el6_2.ppc64.rpm
• postgresql-8.4.12-1.el6_2.s390.rpm
• postgresql84-devel-8.4.12-1.el5_8.i386.rpm
• postgresql84-pltcl-8.4.12-1.el5_8.x86_64.rpm
• postgresql-docs-8.4.12-1.el6_2.x86_64.rpm
• postgresql-plpython-8.4.12-1.el6_2.i686.rpm
• postgresql-libs-8.4.12-1.el6_2.x86_64.rpm
• postgresql-pltcl-8.4.12-1.el6_2.ppc64.rpm
• postgresql84-debuginfo-8.4.12-1.el5_8.ppc64.rpm
• postgresql84-docs-8.4.12-1.el5_8.x86_64.rpm
• postgresql-devel-8.4.12-1.el6_2.ppc64.rpm
• postgresql84-8.4.12-1.el5_8.x86_64.rpm
• postgresql-plpython-8.4.12-1.el6_2.ppc64.rpm
• postgresql84-8.4.12-1.el5_8.src.rpm
• postgresql84-server-8.4.12-1.el5_8.ia64.rpm
• postgresql-debuginfo-8.4.12-1.el6_2.s390.rpm
• postgresql84-devel-8.4.12-1.el5_8.s390x.rpm
• postgresql84-pltcl-8.4.12-1.el5_8.i386.rpm
• postgresql84-plpython-8.4.12-1.el5_8.ia64.rpm
• postgresql-8.4.12-1.el6_2.src.rpm
• postgresql-libs-8.4.12-1.el6_2.s390x.rpm
• postgresql84-debuginfo-8.4.12-1.el5_8.i386.rpm
• postgresql-plperl-8.4.12-1.el6_2.i686.rpm
• postgresql-server-8.4.12-1.el6_2.i686.rpm
• postgresql-devel-8.4.12-1.el6_2.x86_64.rpm
• postgresql-server-8.4.12-1.el6_2.ppc64.rpm
• postgresql84-pltcl-8.4.12-1.el5_8.s390x.rpm
• postgresql84-libs-8.4.12-1.el5_8.s390x.rpm
• postgresql84-pltcl-8.4.12-1.el5_8.ia64.rpm
• postgresql-docs-8.4.12-1.el6_2.s390x.rpm
• postgresql84-plperl-8.4.12-1.el5_8.ia64.rpm
• postgresql-docs-8.4.12-1.el6_2.i686.rpm
• postgresql-debuginfo-8.4.12-1.el6_2.ppc.rpm
• postgresql84-plperl-8.4.12-1.el5_8.ppc.rpm
• postgresql84-docs-8.4.12-1.el5_8.ia64.rpm
• postgresql84-contrib-8.4.12-1.el5_8.s390x.rpm
• postgresql84-8.4.12-1.el5_8.s390x.rpm
• postgresql84-libs-8.4.12-1.el5_8.x86_64.rpm
• postgresql84-debuginfo-8.4.12-1.el5_8.ia64.rpm
• postgresql84-test-8.4.12-1.el5_8.i386.rpm
• postgresql-test-8.4.12-1.el6_2.ppc64.rpm
• postgresql84-tcl-8.4.12-1.el5_8.x86_64.rpm
• postgresql84-libs-8.4.12-1.el5_8.ppc.rpm
• postgresql84-plperl-8.4.12-1.el5_8.i386.rpm
• postgresql84-server-8.4.12-1.el5_8.ppc.rpm
• postgresql-contrib-8.4.12-1.el6_2.s390x.rpm
• postgresql84-plperl-8.4.12-1.el5_8.s390x.rpm
• postgresql84-test-8.4.12-1.el5_8.s390x.rpm
• postgresql-server-8.4.12-1.el6_2.x86_64.rpm
• postgresql-8.4.12-1.el6_2.x86_64.rpm
• postgresql84-pltcl-8.4.12-1.el5_8.ppc.rpm
• postgresql-debuginfo-8.4.12-1.el6_2.i686.rpm
• postgresql84-contrib-8.4.12-1.el5_8.x86_64.rpm
• postgresql84-devel-8.4.12-1.el5_8.ia64.rpm
• postgresql-debuginfo-8.4.12-1.el6_2.ppc64.rpm
• postgresql84-plpython-8.4.12-1.el5_8.x86_64.rpm
• postgresql-libs-8.4.12-1.el6_2.s390.rpm
• postgresql-plperl-8.4.12-1.el6_2.x86_64.rpm
• postgresql-plpython-8.4.12-1.el6_2.s390x.rpm
• postgresql84-debuginfo-8.4.12-1.el5_8.s390.rpm
• postgresql-libs-8.4.12-1.el6_2.ppc64.rpm
• postgresql84-docs-8.4.12-1.el5_8.s390x.rpm
• postgresql84-tcl-8.4.12-1.el5_8.i386.rpm
• postgresql84-devel-8.4.12-1.el5_8.ppc64.rpm
• postgresql84-8.4.12-1.el5_8.ia64.rpm
• postgresql84-8.4.12-1.el5_8.ppc64.rpm
• postgresql-libs-8.4.12-1.el6_2.ppc.rpm
• postgresql-server-8.4.12-1.el6_2.s390x.rpm
• postgresql84-devel-8.4.12-1.el5_8.x86_64.rpm
• postgresql-8.4.12-1.el6_2.i686.rpm
• postgresql-pltcl-8.4.12-1.el6_2.i686.rpm
• postgresql-test-8.4.12-1.el6_2.i686.rpm
• postgresql-contrib-8.4.12-1.el6_2.i686.rpm
• postgresql84-tcl-8.4.12-1.el5_8.ppc.rpm
• postgresql84-devel-8.4.12-1.el5_8.ppc.rpm
• postgresql84-python-8.4.12-1.el5_8.i386.rpm
• postgresql84-devel-8.4.12-1.el5_8.s390.rpm
• postgresql84-plperl-8.4.12-1.el5_8.x86_64.rpm
• postgresql-pltcl-8.4.12-1.el6_2.x86_64.rpm
• postgresql-plpython-8.4.12-1.el6_2.x86_64.rpm
• postgresql84-server-8.4.12-1.el5_8.x86_64.rpm
• postgresql84-python-8.4.12-1.el5_8.s390x.rpm
• postgresql-debuginfo-8.4.12-1.el6_2.s390x.rpm
• postgresql-plperl-8.4.12-1.el6_2.s390x.rpm
• postgresql-devel-8.4.12-1.el6_2.ppc.rpm
• postgresql84-libs-8.4.12-1.el5_8.i386.rpm
• postgresql84-contrib-8.4.12-1.el5_8.i386.rpm
• postgresql-devel-8.4.12-1.el6_2.s390x.rpm
• postgresql84-tcl-8.4.12-1.el5_8.ia64.rpm
• postgresql-8.4.12-1.el6_2.ppc64.rpm
• postgresql84-server-8.4.12-1.el5_8.s390x.rpm
• postgresql84-python-8.4.12-1.el5_8.ia64.rpm
• postgresql84-debuginfo-8.4.12-1.el5_8.x86_64.rpm
• postgresql84-8.4.12-1.el5_8.i386.rpm
• postgresql84-libs-8.4.12-1.el5_8.ia64.rpm
• postgresql84-python-8.4.12-1.el5_8.x86_64.rpm
• postgresql84-libs-8.4.12-1.el5_8.ppc64.rpm
• postgresql84-test-8.4.12-1.el5_8.ia64.rpm
• postgresql84-python-8.4.12-1.el5_8.ppc.rpm
• postgresql84-tcl-8.4.12-1.el5_8.s390x.rpm
• postgresql84-debuginfo-8.4.12-1.el5_8.s390x.rpm
• postgresql-debuginfo-8.4.12-1.el6_2.x86_64.rpm
• postgresql84-contrib-8.4.12-1.el5_8.ia64.rpm
• postgresql84-debuginfo-8.4.12-1.el5_8.ppc.rpm
• postgresql-libs-8.4.12-1.el6_2.i686.rpm
• postgresql-8.4.12-1.el6_2.ppc.rpm
• postgresql-pltcl-8.4.12-1.el6_2.s390x.rpm
• postgresql-test-8.4.12-1.el6_2.s390x.rpm
• postgresql-devel-8.4.12-1.el6_2.s390.rpm
• postgresql-devel-8.4.12-1.el6_2.i686.rpm

Fixes

• This content is not included.BZ - 816956
• This content is not included.BZ - 825995

CVEs

• CVE-2012-2143
• CVE-2012-2655

References

• https://access.redhat.com/security/updates/classification/#moderate
• Content from www.postgresql.org is not included.Content from www.postgresql.org is not included.http://www.postgresql.org/docs/8.4/static/release.html

Additional information

• The Red Hat security contact is This content is not included.secalert@redhat.com. More contact details at https://access.redhat.com/security/team/contact/.
• Offline Security Data data is available for integration with other systems. See Offline Security Data API to get started.