Mandrake Linux Security Advisory : postgresql (MDKSA-2002:062-1)

high Nessus Plugin ID 13963

Synopsis

The remote Mandrake Linux host is missing one or more security updates.

Description

Vulnerabilities were discovered in the Postgresql relational database by Mordred Labs. These vulnerabilities are buffer overflows in the rpad(), lpad(), repeat(), and cash_words() functions. The Postgresql developers also fixed a buffer overflow in functions that deal with time/date and timezone.

Finally, more buffer overflows were discovered by Mordred Labs in the 7.2.2 release that are currently only fixed in CVS. These buffer overflows exist in the circle_poly(), path_encode(), and path_addr() functions.

In order for these vulnerabilities to be exploited, an attacker must be able to query the server somehow. However, this cannot directly lead to root privilege because the server runs as the postgresql user.

Prior to upgrading, users should dump their database and retain it as backup. You can dump the database by using :

$ pg_dumpall > db.out

If you need to restore from the backup, you can do so by using :

$ psql -f db.out template1

Update :

The previous update missed a few small fixes, including a buffer overflow in the cash_words() function that allows local users to cause a DoS and possibly execute arbitrary code via a malformed argument in Postgresql 7.2 and earlier. As well, buffer overflows in the TZ and SET TIME ZONE environment variables for Postgresql 7.2.1 and earlier can allow local users to cause a DoS and possibly execute arbitrary code.

Solution

Update the affected packages.

See Also

http://archives.postgresql.org/pgsql-announce/2002-08/msg00004.php

http://online.securityfocus.com/archive/1/288036

http://online.securityfocus.com/archive/1/288305

http://online.securityfocus.com/archive/1/288334

Plugin Details

Severity: High

ID: 13963

File Name: mandrake_MDKSA-2002-062.nasl

Version: 1.21

Type: local

Published: 7/31/2004

Updated: 1/6/2021

Supported Sensors: Nessus

Risk Information

VPR

Risk Factor: Medium

Score: 6.6

CVSS v2

Risk Factor: High

Base Score: 7.5

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

Vulnerability Information

CPE: p-cpe:/a:mandriva:linux:libpgtcl2, p-cpe:/a:mandriva:linux:postgresql-perl, p-cpe:/a:mandriva:linux:postgresql-docs, p-cpe:/a:mandriva:linux:postgresql-test, p-cpe:/a:mandriva:linux:postgresql-odbc, p-cpe:/a:mandriva:linux:postgresql-tk, cpe:/o:mandrakesoft:mandrake_linux:8.0, p-cpe:/a:mandriva:linux:postgresql-contrib, p-cpe:/a:mandriva:linux:postgresql-devel, p-cpe:/a:mandriva:linux:libecpg3, cpe:/o:mandrakesoft:mandrake_linux:8.2, cpe:/o:mandrakesoft:mandrake_linux:8.1, cpe:/o:mandrakesoft:mandrake_linux:9.0, p-cpe:/a:mandriva:linux:postgresql-python, p-cpe:/a:mandriva:linux:postgresql, p-cpe:/a:mandriva:linux:libpgsql2, p-cpe:/a:mandriva:linux:postgresql-jdbc, p-cpe:/a:mandriva:linux:postgresql-tcl, cpe:/o:mandrakesoft:mandrake_linux:7.2, p-cpe:/a:mandriva:linux:libpgsqlodbc0, p-cpe:/a:mandriva:linux:postgresql-libs, p-cpe:/a:mandriva:linux:postgresql-plperl, p-cpe:/a:mandriva:linux:postgresql-server, p-cpe:/a:mandriva:linux:libpgperl

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

Patch Publication Date: 2/11/2003

Reference Information

CVE: CVE-2002-0972, CVE-2002-1397, CVE-2002-1398, CVE-2002-1400, CVE-2002-1401, CVE-2002-1402

CWE: 119

MDKSA: 2002:062-1