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

High Nessus Plugin ID 13963


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


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.


Update the affected packages.

See Also

Plugin Details

Severity: High

ID: 13963

File Name: mandrake_MDKSA-2002-062.nasl

Version: $Revision: 1.18 $

Type: local

Published: 2004/07/31

Modified: 2013/05/31

Dependencies: 12634

Risk Information

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

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

Patch Publication Date: 2003/02/11

Reference Information

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

MDKSA: 2002:062-1

CWE: 119