Updated postgresql packages that fix several security vulnerabilities and risks of data loss are now available.

This update has been rated as having moderate security impact by the Red Hat Security Response Team.

PostgreSQL is an advanced Object-Relational database management system (DBMS) that supports almost all SQL constructs (including transactions, subselects and user-defined types and functions).

The PostgreSQL community discovered two distinct errors in initial system catalog entries that could allow authorized database users to crash the database and possibly escalate their privileges. The Common Vulnerabilities and Exposures project (cve.mitre.org) has assigned the names CVE-2005-1409 and CVE-2005-1410 to these issues.

Although installing this update will protect new (freshly initdb'd) database installations from these errors, administrators MUST TAKE MANUAL ACTION to repair the errors in pre-existing databases. The appropriate procedures are explained at http://www.postgresql.org/docs/8.0/static/release-7-4-8.html for Red Hat Enterprise Linux 4 users, or http://www.postgresql.org/docs/8.0/static/release-7-3-10.html for Red Hat Enterprise Linux 3 users.

This update corrects several problems that might occur while trying to upgrade a Red Hat Enterprise Linux 3 installation (containing rh-postgresql packages) to Red Hat Enterprise Linux 4 (containing postgresql packages). These updated packages correctly supersede the rh-postgresql packages.

The original release of Red Hat Enterprise Linux 4 failed to initialize the database correctly if started for the first time with SELinux in enforcement mode. This update corrects that problem.

If you already have a nonfunctional database in place, shut down the postgresql service if running, install this update, then do 'sudo rm
-rf /var/lib/pgsql/data' before restarting the postgresql service.

This update also solves the problem that the PostgreSQL server might fail to restart after a system reboot, due to a stale lockfile.

This update also corrects a problem with wrong error messages in libpq, the postgresql client library. The library would formerly report kernel error messages incorrectly when the locale setting was not C.

This update also includes fixes for several other errors, including two race conditions that could result in apparent data inconsistency or actual data loss.

All users of PostgreSQL are advised to upgrade to these updated packages and to apply the recommended manual corrections to existing databases.

The remote Redhat Enterprise Linux 4 host has packages installed that are affected by multiple vulnerabilities as referenced in the RHSA-2005:433 advisory.

  - security flaw (CVE-2005-1409, CVE-2005-1410)

Note that Nessus has not tested for these issues but has instead relied only on the application's self-reported version number.

A number of vulnerabilities were found and corrected in the PostgreSQL DBMS :

Two serious security errors have been found in PostgreSQL 7.3 and newer releases. These errors at least allow an unprivileged database user to crash the backend process, and may make it possible for an unprivileged user to gain the privileges of a database superuser.

Functions that support client-to-server character set conversion can be called from SQL commands by unprivileged users, but these functions are not designed to be safe against malicious choices of argument values. (CVE-2005-1409)

The contrib/tsearch2 module misdeclares several functions as returning type 'internal' when they do not have any 'internal' argument. This breaks the type safety of 'internal' by allowing users to construct SQL commands that invoke other functions accepting 'internal' arguments. (CVE-2005-1410)

These vulnerabilities must also be fixed in all existing databases when upgrading. The post-installation script of the updated postgresql-server package attempts to do this automatically.

The updated packages have been patched to correct these problems.

バナーによると、リモートホストにインストールされているバージョンの PostgreSQL は、以下の脆弱性の影響を受けることがあります。

  - 文字変換の脆弱性
    これらの関数が引数の検証を行わない場合であっても、権限のないユーザーが、SQL コマンドからクライアント/サーバー文字セット変換をサポートする関数を呼び出すことができます。

  - tsearch2 脆弱性
    インストールされている場合、「contrib/tsearch2」モジュールは、ユーザーに対して、最小限でもバックエンドをクラッシュすることを許可します。理由は、複数の関数を、実際には「内部」引数がない場合に、戻りタイプ「内部」として誤って宣言するためです。

It was discovered that unprivileged users were allowed to call internal character conversion functions. However, since these functions were not designed to be safe against malicious choices of argument values, this could potentially be exploited to execute arbitrary code with the privileges of the PostgreSQL server (user 'postgres'). (CAN-2005-1409)

Another vulnerability was found in the 'tsearch2' module of postgresql-contrib. This module declared several functions as internal, although they did not accept any internal argument; this breaks the type safety of 'internal' by allowing users to construct SQL commands that invoke other functions accepting 'internal' arguments. This could eventually be exploited to crash the server, or possibly even execute arbitrary code with the privileges of the PostgreSQL server. (CAN-2005-1410)

These vulnerabilities must also be fixed in all existing databases when upgrading. The post-installation script of the updated package attempts to do this automatically; if the package installs without any error, all existing databases have been updated to be safe against above vulnerabilities. Should the installation fail, please contact the Ubuntu security team (security@ubuntu.com) immediately.

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.

The postgresql development team reports :

The more severe of the two errors is that the functions that support client-to-server character set conversion can be called from SQL commands by unprivileged users, but these functions are not designed to be safe against malicious choices of argument values. This problem exists in PostgreSQL 7.3.* through 8.0.*. The recommended fix is to disable public EXECUTE access for these functions. This does not affect normal usage of the functions for character set conversion, but it will prevent misuse.

The other error is that the contrib/tsearch2 module misdeclares several functions as returning type 'internal' when they do not have any 'internal' argument. This breaks the type safety of 'internal' by allowing users to construct SQL commands that invoke other functions accepting 'internal' arguments. The consequences of this have not been investigated in detail, but it is certainly at least possible to crash the backend.

The remote host is affected by the vulnerability described in GLSA-200505-12 (PostgreSQL: Multiple vulnerabilities)

    PostgreSQL gives public EXECUTE access to a number of character     conversion routines, but doesn't validate the given arguments     (CAN-2005-1409). It has also been reported that the contrib/tsearch2     module of PostgreSQL misdeclares the return value of some functions as     'internal' (CAN-2005-1410).
  Impact :

    An attacker could call the character conversion routines with specially     setup arguments to crash the backend process of PostgreSQL or to     potentially gain administrator rights. A malicious user could also call     the misdeclared functions of the contrib/tsearch2 module, resulting in     a Denial of Service or other, yet uninvestigated, impacts.
  Workaround :

    There is no known workaround at this time.

According to its banner, the version of PostgreSQL installed on the remote host may suffer from the following vulnerabilities :

  - Character Conversion Vulnerability     Unprivileged users can call functions supporting client-     server character set conversion from SQL commands even     though those functions do not validate their arguments.

  - tsearch2 Vulnerability     If installed, the 'contrib/tsearch2' module permits     users     to at a minimum crash the backend because it misdeclares     several functions as returning type 'internal' when in     fact they do not have any 'internal' argument.

根據其標題，遠端主機上安裝的 PostgreSQL 版本可能受到以下弱點的影響：

  - 字元轉換弱點：不具權限的使用者可在 SQL 命令中呼叫支援用戶端與伺服器之間字元組轉換的函式，即使這些函數不會驗證其引數亦然。

  - tsearch2 弱點若已安裝，「contrib/tsearch2」模組會允許使用者最低限度地損毀後端，因為它將多個函數誤報為傳回類型「internal」，但事實上這些函數沒有任何「internal」引數。

根据其标题，远程主机上安装的 PostgreSQL 的版本可能受到下列漏洞的攻击：

  - 字符转换漏洞。即使支持客户端-服务器字符集转换的函数未验证其参数，非特权用户也可通过 SQL 命令调用这些函数。

  - tsearch2 漏洞安装“contrib/tsearch2”模块后，用户可以至少使后端崩溃，因为在返回“internal”类型时其误报了多个函数，而事实上它们没有任何“internal”参数。

The remote host is running PostgreSQL, an open source relational database.  This version is vulnerable to a number of flaws.  Specifically, the following functions are directly accessible to remote users:
dex_init()
snb_en_init()
snb_ru_init()
spell_init()
syn_init()

An attacker calling these functions can submit queries that lead to compromise of confidential data or execution of arbitrary code on the remote database server. 

ID	名前	製品	ファミリー	公開日	更新日	深刻度
21826	CentOS 3 / 4 : postgresql (CESA-2005:433)	Nessus	CentOS Local Security Checks	2006/7/3	2021/1/4	high
18408	RHEL 4 : postgresql (RHSA-2005:433)	Nessus	Red Hat Local Security Checks	2005/6/2	2024/4/27	critical
18411	Mandrake Linux Security Advisory : postgresql (MDKSA-2005:093)	Nessus	Mandriva Local Security Checks	2005/6/2	2021/1/6	high
18202	PostgreSQL < 8.0.3 の複数の脆弱性	Nessus	Databases	2005/5/5	2022/4/11	medium
20506	Ubuntu 4.10 / 5.04 : postgresql vulnerabilities (USN-118-1)	Nessus	Ubuntu Local Security Checks	2006/1/15	2021/1/19	high
21425	FreeBSD : postgresql -- character conversion and tsearch2 vulnerabilities (486aff57-9ecd-11da-b410-000e0c2e438a)	Nessus	FreeBSD Local Security Checks	2006/5/13	2021/1/6	high
18271	GLSA-200505-12 : PostgreSQL: Multiple vulnerabilities	Nessus	Gentoo Local Security Checks	2005/5/17	2021/1/6	high
18202	PostgreSQL < 8.0.3 Multiple Vulnerabilities	Nessus	Databases	2005/5/5	2022/4/11	medium
18202	PostgreSQL < 8.0.3 多種弱點	Nessus	Databases	2005/5/5	2022/4/11	medium
18202	PostgreSQL < 8.0.3 多种漏洞	Nessus	Databases	2005/5/5	2022/4/11	medium
2876	PostgreSQL < 8.0.3 Incorrect Function Declaration	Nessus Network Monitor	Database	2005/5/4	2019/3/6	medium

検出

プラグインの検索

high

critical

high

medium

high

high

high

medium

medium

medium

medium