SUSE SLED15: libecpg6 / libpq5 / libpq5-32bit / postgresql / postgresql-contrib / etc (SUSE-SU-2024:0106-1)

high Nessus Plugin ID 188064

Language:

Synopsis

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

Description

The remote SUSE Linux SLED15 / SLED_SAP15 / SLES15 / SLES_SAP15 host has packages installed that are affected by multiple vulnerabilities as referenced in the SUSE-SU-2024:0106-1 advisory.

This update ships postgresql 16.

Security issues fixed:

* CVE-2023-5868: Fix handling of unknown-type arguments in DISTINCT 'any' aggregate functions. This error led to a text-type value being interpreted as an unknown-type value (that is, a zero-terminated string) at runtime. This could result in disclosure of server memory following the text value. (bsc#1216962)
* CVE-2023-5869: Detect integer overflow while computing new array dimensions. When assigning new elements to array subscripts that are outside the current array bounds, an undetected integer overflow could occur in edge cases. Memory stomps that are potentially exploitable for arbitrary code execution are possible, and so is disclosure of server memory. (bsc#1216961)
* CVE-2023-5870: Prevent the pg_signal_backend role from signalling background workers and autovacuum processes.
The documentation says that pg_signal_backend cannot issue signals to superuser-owned processes. It was able to signal these background processes, though, because they advertise a role OID of zero. Treat that as indicating superuser ownership.
The security implications of cancelling one of these process types are fairly small so far as the core code goes (we'll just start another one), but extensions might add background workers that are more vulnerable.
Also ensure that the is_superuser parameter is set correctly in such processes. No specific security consequences are known for that oversight, but it might be significant for some extensions.
(bsc#1216960)

Changes in postgresql16:

- Upgrade to 16.1:

* https://www.postgresql.org/about/news/2715
* https://www.postgresql.org/docs/16/release-16.html
* https://www.postgresql.org/docs/16/release-16-1.html

- Overhaul postgresql-README.SUSE and move it from the binary package to the noarch wrapper package.
- Change the unix domain socket location from /var/run to /run.

Changes in postgresql15:

- Update to 15.5 https://www.postgresql.org/docs/15/release-15-5.html

- The libs and mini package are now provided by postgresql16.

- Overhaul postgresql-README.SUSE and move it from the binary package to the noarch wrapper package.
- Change the unix domain socket location from /var/run to /run.

Changes in postgresql:

- Interlock version and release of all noarch packages except for the postgresql-docs.
- bsc#1122892: Add a sysconfig variable for initdb.
- Overhaul postgresql-README.SUSE and move it from the binary package to the noarch wrapper package.
- bsc#1179231: Add an explanation for the /tmp -> /run/postgresql move and permission change.
- Add postgresql-README as a separate source file.
- bsc#1209208: Drop hard dependency on systemd
- bsc#1206796: Refine the distinction of where to use sysusers and use bcond to have the expression only in one place.

Tenable has extracted the preceding description block directly from the SUSE security advisory.

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

Solution

Update the affected packages.

See Also

https://bugzilla.suse.com/1122892

https://bugzilla.suse.com/1179231

https://bugzilla.suse.com/1206796

https://bugzilla.suse.com/1209208

https://bugzilla.suse.com/1216022

https://bugzilla.suse.com/1216734

https://bugzilla.suse.com/1216960

https://bugzilla.suse.com/1216961

https://bugzilla.suse.com/1216962

https://www.suse.com/security/cve/CVE-2023-5868

https://www.suse.com/security/cve/CVE-2023-5869

https://www.suse.com/security/cve/CVE-2023-5870

http://www.nessus.org/u?8fbe19b1

Plugin Details

Severity: High

ID: 188064

File Name: suse_SU-2024-0106-1.nasl

Version: 1.2

Type: Local

Agent: unix

Published: 1/16/2024

Updated: 6/25/2026

Supported Sensors: Frictionless Assessment AWS, Frictionless Assessment Azure, Frictionless Assessment Agent, Nessus Agent, Agentless Assessment, Continuous Assessment, tenable_cloud_security, tenable_self_hosted_container_security, Nessus

Risk Information

VPR

Risk Factor: Medium

Score: 6.7

CVSS v2

Risk Factor: High

Base Score: 9

Temporal Score: 6.7

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

CVSS Score Source: CVE-2023-5869

CVSS v3

Risk Factor: High

Base Score: 8.8

Temporal Score: 7.7

Vector: CVSS:3.0/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H

Temporal Vector: CVSS:3.0/E:U/RL:O/RC:C

Vulnerability Information

CPE: p-cpe:/a:novell:suse_linux:postgresql16-server-devel, p-cpe:/a:novell:suse_linux:postgresql15-server, p-cpe:/a:novell:suse_linux:postgresql-server, p-cpe:/a:novell:suse_linux:postgresql-docs, p-cpe:/a:novell:suse_linux:postgresql-llvmjit, p-cpe:/a:novell:suse_linux:postgresql-test, p-cpe:/a:novell:suse_linux:postgresql15-pltcl, cpe:/o:novell:suse_linux:15, p-cpe:/a:novell:suse_linux:postgresql-devel, p-cpe:/a:novell:suse_linux:postgresql15-llvmjit-devel, p-cpe:/a:novell:suse_linux:postgresql-server-devel, p-cpe:/a:novell:suse_linux:postgresql16-server, p-cpe:/a:novell:suse_linux:postgresql-contrib, p-cpe:/a:novell:suse_linux:postgresql15-plperl, p-cpe:/a:novell:suse_linux:postgresql16-llvmjit-devel, p-cpe:/a:novell:suse_linux:postgresql16-llvmjit, p-cpe:/a:novell:suse_linux:postgresql-plpython, p-cpe:/a:novell:suse_linux:postgresql16-plperl, p-cpe:/a:novell:suse_linux:postgresql16-contrib, p-cpe:/a:novell:suse_linux:postgresql15-contrib, p-cpe:/a:novell:suse_linux:postgresql-pltcl, p-cpe:/a:novell:suse_linux:postgresql15-llvmjit, p-cpe:/a:novell:suse_linux:postgresql15-docs, p-cpe:/a:novell:suse_linux:libecpg6, p-cpe:/a:novell:suse_linux:libpq5-32bit, p-cpe:/a:novell:suse_linux:postgresql16-plpython, p-cpe:/a:novell:suse_linux:postgresql15-server-devel, p-cpe:/a:novell:suse_linux:postgresql16-devel, p-cpe:/a:novell:suse_linux:postgresql16-pltcl, p-cpe:/a:novell:suse_linux:postgresql, p-cpe:/a:novell:suse_linux:postgresql15-test, p-cpe:/a:novell:suse_linux:postgresql-plperl, p-cpe:/a:novell:suse_linux:postgresql15-plpython, p-cpe:/a:novell:suse_linux:postgresql15-devel, p-cpe:/a:novell:suse_linux:postgresql16-docs, p-cpe:/a:novell:suse_linux:postgresql16-test, p-cpe:/a:novell:suse_linux:libpq5, p-cpe:/a:novell:suse_linux:postgresql16, p-cpe:/a:novell:suse_linux:postgresql15, p-cpe:/a:novell:suse_linux:postgresql-llvmjit-devel

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

Exploit Ease: No known exploits are available

Patch Publication Date: 1/15/2024

Vulnerability Publication Date: 11/9/2023

Reference Information

CVE: CVE-2023-5868, CVE-2023-5869, CVE-2023-5870

IAVB: 2023-B-0088-S

SuSE: SUSE-SU-2024:0106-1