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

medium Nessus Plugin ID 150100
New! Plugin Severity Now Using CVSS v3

The calculated severity for Plugins has been updated to use CVSS v3 by default. Plugins that do not have a CVSS v3 score will fall back to CVSS v2 for calculating severity. Severity display preferences can be toggled in the settings dropdown.

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: Medium

ID: 150100

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

Version: 1.4

Type: local

Agent: unix

Published: 6/1/2021

Updated: 8/19/2021

Dependencies: ssh_get_info.nasl

Risk Information

VPR

Risk Factor: Medium

Score: 6.7

CVSS v2

Risk Factor: Low

Base Score: 3.5

Temporal Score: 2.6

Vector: AV:N/AC:M/Au:S/C:P/I:N/A:N

Temporal Vector: E:U/RL:OF/RC:C

CVSS v3

Risk Factor: Medium

Base Score: 4.3

Temporal Score: 3.8

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

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

Vulnerability Information

CPE: p-cpe:/a:novell:suse_linux:postgresql12, p-cpe:/a:novell:suse_linux:postgresql12-contrib, p-cpe:/a:novell:suse_linux:postgresql12-contrib-debuginfo, p-cpe:/a:novell:suse_linux:postgresql12-debuginfo, p-cpe:/a:novell:suse_linux:postgresql12-debugsource, p-cpe:/a:novell:suse_linux:postgresql12-plperl, p-cpe:/a:novell:suse_linux:postgresql12-plperl-debuginfo, p-cpe:/a:novell:suse_linux:postgresql12-plpython, p-cpe:/a:novell:suse_linux:postgresql12-plpython-debuginfo, p-cpe:/a:novell:suse_linux:postgresql12-pltcl, p-cpe:/a:novell:suse_linux:postgresql12-pltcl-debuginfo, p-cpe:/a:novell:suse_linux:postgresql12-server, p-cpe:/a:novell:suse_linux:postgresql12-server-debuginfo, cpe:/o:novell:suse_linux:12

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