SUSE SLES12 Security Update : postgresql12 (SUSE-SU-2021:1783-1)

high Nessus Plugin ID 150100

Language:

Synopsis

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

Description

This update for postgresql12 fixes the following issues :

Upgrade to version 12.7 :

CVE-2021-32027: Fixed integer overflows in array subscripting calculations (bsc#1185924).

CVE-2021-32028: Fixed mishandling of junk columns in INSERT ... ON CONFLICT ... UPDATE target lists (bsc#1185925).

CVE-2021-32029: Fixed possibly-incorrect computation of UPDATE ...
RETURNING 'pg_psql_temporary_savepoint' does not exist (bsc#1185926).

CVE-2021-3393: Fixed information leakage in constraint-violation error messages (bsc#1182040).

Don't use %_stop_on_removal, because it was meant to be private and got removed from openSUSE. %_restart_on_update is also private, but still supported and needed for now (bsc#1183168).

Re-enable build of the llvmjit subpackage on SLE, but it will only be delivered on PackageHub for now (bsc#1183118).

Disable icu for PostgreSQL 10 (and older) on TW (bsc#1179945).

Note that Tenable Network Security has extracted the preceding description block directly from the SUSE security advisory. Tenable has attempted to automatically clean and format it as much as possible without introducing additional issues.

Solution

To install this SUSE Security Update use the SUSE recommended installation methods like YaST online_update or 'zypper patch'.

Alternatively you can run the command listed for your product :

SUSE Linux Enterprise Software Development Kit 12-SP5 :

zypper in -t patch SUSE-SLE-SDK-12-SP5-2021-1783=1

SUSE Linux Enterprise Server 12-SP5 :

zypper in -t patch SUSE-SLE-SERVER-12-SP5-2021-1783=1

See Also

https://bugzilla.suse.com/show_bug.cgi?id=1179945

https://bugzilla.suse.com/show_bug.cgi?id=1182040

https://bugzilla.suse.com/show_bug.cgi?id=1183118

https://bugzilla.suse.com/show_bug.cgi?id=1183168

https://bugzilla.suse.com/show_bug.cgi?id=1185924

https://bugzilla.suse.com/show_bug.cgi?id=1185925

https://bugzilla.suse.com/show_bug.cgi?id=1185926

https://www.suse.com/security/cve/CVE-2021-32027/

https://www.suse.com/security/cve/CVE-2021-32028/

https://www.suse.com/security/cve/CVE-2021-32029/

https://www.suse.com/security/cve/CVE-2021-3393/

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

Plugin Details

Severity: High

ID: 150100

File Name: suse_SU-2021-1783-1.nasl

Version: 1.5

Type: local

Agent: unix

Published: 6/1/2021

Updated: 1/26/2022

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

Risk Information

VPR

Risk Factor: Medium

Score: 5.9

CVSS v2

Risk Factor: Medium

Base Score: 6.5

Temporal Score: 4.8

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

CVSS Score Source: CVE-2021-32027

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: cpe:/o:novell:suse_linux:12, p-cpe:/a:novell:suse_linux:postgresql12-plpython, p-cpe:/a:novell:suse_linux:postgresql12-plpython-debuginfo, p-cpe:/a:novell:suse_linux:postgresql12-plperl, p-cpe:/a:novell:suse_linux:postgresql12-debuginfo, p-cpe:/a:novell:suse_linux:postgresql12, p-cpe:/a:novell:suse_linux:postgresql12-plperl-debuginfo, p-cpe:/a:novell:suse_linux:postgresql12-pltcl-debuginfo, p-cpe:/a:novell:suse_linux:postgresql12-server-debuginfo, p-cpe:/a:novell:suse_linux:postgresql12-debugsource, p-cpe:/a:novell:suse_linux:postgresql12-pltcl, p-cpe:/a:novell:suse_linux:postgresql12-contrib, p-cpe:/a:novell:suse_linux:postgresql12-server, p-cpe:/a:novell:suse_linux:postgresql12-contrib-debuginfo

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: 5/27/2021

Vulnerability Publication Date: 4/1/2021

Reference Information

CVE: CVE-2021-32027, CVE-2021-32028, CVE-2021-32029, CVE-2021-3393

IAVB: 2021-B-0036-S