SUSE-SU-2024:4099-1: important: Security update for postgresql12

28 Nov 2024

      # Security update for postgresql12

Announcement ID: SUSE-SU-2024:4099-1  
Release Date: 2024-11-28T12:25:29Z  
Rating: important  
References:

  * bsc#1233323
  * bsc#1233325
  * bsc#1233326
  * bsc#1233327

Cross-References:

  * CVE-2024-10976
  * CVE-2024-10977
  * CVE-2024-10978
  * CVE-2024-10979

CVSS scores:

  * CVE-2024-10976 ( SUSE ):  4.2 CVSS:3.1/AV:N/AC:H/PR:L/UI:N/S:U/C:L/I:L/A:N
  * CVE-2024-10976 ( NVD ):  4.2 CVSS:3.1/AV:N/AC:H/PR:L/UI:N/S:U/C:L/I:L/A:N
  * CVE-2024-10977 ( SUSE ):  3.1 CVSS:3.1/AV:N/AC:H/PR:N/UI:R/S:U/C:N/I:L/A:N
  * CVE-2024-10977 ( NVD ):  3.1 CVSS:3.1/AV:N/AC:H/PR:N/UI:R/S:U/C:N/I:L/A:N
  * CVE-2024-10978 ( SUSE ):  4.2 CVSS:3.1/AV:N/AC:H/PR:L/UI:N/S:U/C:L/I:L/A:N
  * CVE-2024-10978 ( NVD ):  4.2 CVSS:3.1/AV:N/AC:H/PR:L/UI:N/S:U/C:L/I:L/A:N
  * CVE-2024-10979 ( SUSE ):  8.8 CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H
  * CVE-2024-10979 ( NVD ):  8.8 CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H

Affected Products:

  * openSUSE Leap 15.5
  * openSUSE Leap 15.6
  * SUSE Enterprise Storage 7.1
  * SUSE Linux Enterprise High Performance Computing 15 SP2
  * SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS
  * SUSE Linux Enterprise High Performance Computing 15 SP3
  * SUSE Linux Enterprise High Performance Computing LTSS 15 SP3
  * SUSE Linux Enterprise Server 15 SP2
  * SUSE Linux Enterprise Server 15 SP2 LTSS
  * SUSE Linux Enterprise Server 15 SP3
  * SUSE Linux Enterprise Server 15 SP3 LTSS
  * SUSE Linux Enterprise Server for SAP Applications 15 SP2
  * SUSE Linux Enterprise Server for SAP Applications 15 SP3

An update that solves four vulnerabilities can now be installed.

## Description:

This update for postgresql12 fixes the following issues:

  * CVE-2024-10976: Ensure cached plans are marked as dependent on the calling
    role when RLS applies to a non-top-level table reference (bsc#1233323).
  * CVE-2024-10977: Make libpq discard error messages received during SSL or GSS
    protocol negotiation (bsc#1233325).
  * CVE-2024-10978: Fix unintended interactions between SET SESSION
    AUTHORIZATION and SET ROLE (bsc#1233326).
  * CVE-2024-10979: Prevent trusted PL/Perl code from changing environment
    variables (bsc#1233327).

## Patch Instructions:

To install this SUSE 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 High Performance Computing 15 SP2 LTSS  
    zypper in -t patch SUSE-SLE-Product-HPC-15-SP2-LTSS-2024-4099=1

  * SUSE Linux Enterprise High Performance Computing LTSS 15 SP3  
    zypper in -t patch SUSE-SLE-Product-HPC-15-SP3-LTSS-2024-4099=1

  * SUSE Linux Enterprise Server 15 SP2 LTSS  
    zypper in -t patch SUSE-SLE-Product-SLES-15-SP2-LTSS-2024-4099=1

  * SUSE Linux Enterprise Server 15 SP3 LTSS  
    zypper in -t patch SUSE-SLE-Product-SLES-15-SP3-LTSS-2024-4099=1

  * SUSE Linux Enterprise Server for SAP Applications 15 SP2  
    zypper in -t patch SUSE-SLE-Product-SLES_SAP-15-SP2-2024-4099=1

  * SUSE Linux Enterprise Server for SAP Applications 15 SP3  
    zypper in -t patch SUSE-SLE-Product-SLES_SAP-15-SP3-2024-4099=1

  * SUSE Enterprise Storage 7.1  
    zypper in -t patch SUSE-Storage-7.1-2024-4099=1

  * openSUSE Leap 15.5  
    zypper in -t patch openSUSE-SLE-15.5-2024-4099=1

  * openSUSE Leap 15.6  
    zypper in -t patch openSUSE-SLE-15.6-2024-4099=1

## Package List:

  * SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS (aarch64
    x86_64)
    * postgresql12-plpython-12.22-150200.8.66.1
    * postgresql12-debuginfo-12.22-150200.8.66.1
    * postgresql12-devel-12.22-150200.8.66.1
    * postgresql12-contrib-12.22-150200.8.66.1
    * postgresql12-plperl-debuginfo-12.22-150200.8.66.1
    * postgresql12-plpython-debuginfo-12.22-150200.8.66.1
    * postgresql12-12.22-150200.8.66.1
    * postgresql12-server-12.22-150200.8.66.1
    * postgresql12-plperl-12.22-150200.8.66.1
    * postgresql12-server-devel-debuginfo-12.22-150200.8.66.1
    * postgresql12-pltcl-debuginfo-12.22-150200.8.66.1
    * postgresql12-devel-debuginfo-12.22-150200.8.66.1
    * postgresql12-server-devel-12.22-150200.8.66.1
    * postgresql12-debugsource-12.22-150200.8.66.1
    * postgresql12-contrib-debuginfo-12.22-150200.8.66.1
    * postgresql12-server-debuginfo-12.22-150200.8.66.1
    * postgresql12-pltcl-12.22-150200.8.66.1
  * SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS (noarch)
    * postgresql12-docs-12.22-150200.8.66.1
  * SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 (aarch64
    x86_64)
    * postgresql12-plpython-12.22-150200.8.66.1
    * postgresql12-debuginfo-12.22-150200.8.66.1
    * postgresql12-devel-12.22-150200.8.66.1
    * postgresql12-contrib-12.22-150200.8.66.1
    * postgresql12-plperl-debuginfo-12.22-150200.8.66.1
    * postgresql12-plpython-debuginfo-12.22-150200.8.66.1
    * postgresql12-12.22-150200.8.66.1
    * postgresql12-server-12.22-150200.8.66.1
    * postgresql12-plperl-12.22-150200.8.66.1
    * postgresql12-server-devel-debuginfo-12.22-150200.8.66.1
    * postgresql12-pltcl-debuginfo-12.22-150200.8.66.1
    * postgresql12-devel-debuginfo-12.22-150200.8.66.1
    * postgresql12-server-devel-12.22-150200.8.66.1
    * postgresql12-debugsource-12.22-150200.8.66.1
    * postgresql12-contrib-debuginfo-12.22-150200.8.66.1
    * postgresql12-server-debuginfo-12.22-150200.8.66.1
    * postgresql12-pltcl-12.22-150200.8.66.1
  * SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 (noarch)
    * postgresql12-docs-12.22-150200.8.66.1
  * SUSE Linux Enterprise Server 15 SP2 LTSS (aarch64 ppc64le s390x x86_64)
    * postgresql12-plpython-12.22-150200.8.66.1
    * postgresql12-debuginfo-12.22-150200.8.66.1
    * postgresql12-devel-12.22-150200.8.66.1
    * postgresql12-contrib-12.22-150200.8.66.1
    * postgresql12-plperl-debuginfo-12.22-150200.8.66.1
    * postgresql12-plpython-debuginfo-12.22-150200.8.66.1
    * postgresql12-12.22-150200.8.66.1
    * postgresql12-server-12.22-150200.8.66.1
    * postgresql12-plperl-12.22-150200.8.66.1
    * postgresql12-server-devel-debuginfo-12.22-150200.8.66.1
    * postgresql12-pltcl-debuginfo-12.22-150200.8.66.1
    * postgresql12-devel-debuginfo-12.22-150200.8.66.1
    * postgresql12-server-devel-12.22-150200.8.66.1
    * postgresql12-debugsource-12.22-150200.8.66.1
    * postgresql12-contrib-debuginfo-12.22-150200.8.66.1
    * postgresql12-server-debuginfo-12.22-150200.8.66.1
    * postgresql12-pltcl-12.22-150200.8.66.1
  * SUSE Linux Enterprise Server 15 SP2 LTSS (noarch)
    * postgresql12-docs-12.22-150200.8.66.1
  * SUSE Linux Enterprise Server 15 SP3 LTSS (aarch64 ppc64le s390x x86_64)
    * postgresql12-plpython-12.22-150200.8.66.1
    * postgresql12-debuginfo-12.22-150200.8.66.1
    * postgresql12-devel-12.22-150200.8.66.1
    * postgresql12-contrib-12.22-150200.8.66.1
    * postgresql12-plperl-debuginfo-12.22-150200.8.66.1
    * postgresql12-plpython-debuginfo-12.22-150200.8.66.1
    * postgresql12-12.22-150200.8.66.1
    * postgresql12-server-12.22-150200.8.66.1
    * postgresql12-plperl-12.22-150200.8.66.1
    * postgresql12-server-devel-debuginfo-12.22-150200.8.66.1
    * postgresql12-pltcl-debuginfo-12.22-150200.8.66.1
    * postgresql12-devel-debuginfo-12.22-150200.8.66.1
    * postgresql12-server-devel-12.22-150200.8.66.1
    * postgresql12-debugsource-12.22-150200.8.66.1
    * postgresql12-contrib-debuginfo-12.22-150200.8.66.1
    * postgresql12-server-debuginfo-12.22-150200.8.66.1
    * postgresql12-pltcl-12.22-150200.8.66.1
  * SUSE Linux Enterprise Server 15 SP3 LTSS (noarch)
    * postgresql12-docs-12.22-150200.8.66.1
  * SUSE Linux Enterprise Server for SAP Applications 15 SP2 (ppc64le x86_64)
    * postgresql12-plpython-12.22-150200.8.66.1
    * postgresql12-debuginfo-12.22-150200.8.66.1
    * postgresql12-devel-12.22-150200.8.66.1
    * postgresql12-contrib-12.22-150200.8.66.1
    * postgresql12-plperl-debuginfo-12.22-150200.8.66.1
    * postgresql12-plpython-debuginfo-12.22-150200.8.66.1
    * postgresql12-12.22-150200.8.66.1
    * postgresql12-server-12.22-150200.8.66.1
    * postgresql12-plperl-12.22-150200.8.66.1
    * postgresql12-server-devel-debuginfo-12.22-150200.8.66.1
    * postgresql12-pltcl-debuginfo-12.22-150200.8.66.1
    * postgresql12-devel-debuginfo-12.22-150200.8.66.1
    * postgresql12-server-devel-12.22-150200.8.66.1
    * postgresql12-debugsource-12.22-150200.8.66.1
    * postgresql12-contrib-debuginfo-12.22-150200.8.66.1
    * postgresql12-server-debuginfo-12.22-150200.8.66.1
    * postgresql12-pltcl-12.22-150200.8.66.1
  * SUSE Linux Enterprise Server for SAP Applications 15 SP2 (noarch)
    * postgresql12-docs-12.22-150200.8.66.1
  * SUSE Linux Enterprise Server for SAP Applications 15 SP3 (ppc64le x86_64)
    * postgresql12-plpython-12.22-150200.8.66.1
    * postgresql12-debuginfo-12.22-150200.8.66.1
    * postgresql12-devel-12.22-150200.8.66.1
    * postgresql12-contrib-12.22-150200.8.66.1
    * postgresql12-plperl-debuginfo-12.22-150200.8.66.1
    * postgresql12-plpython-debuginfo-12.22-150200.8.66.1
    * postgresql12-12.22-150200.8.66.1
    * postgresql12-server-12.22-150200.8.66.1
    * postgresql12-plperl-12.22-150200.8.66.1
    * postgresql12-server-devel-debuginfo-12.22-150200.8.66.1
    * postgresql12-pltcl-debuginfo-12.22-150200.8.66.1
    * postgresql12-devel-debuginfo-12.22-150200.8.66.1
    * postgresql12-server-devel-12.22-150200.8.66.1
    * postgresql12-debugsource-12.22-150200.8.66.1
    * postgresql12-contrib-debuginfo-12.22-150200.8.66.1
    * postgresql12-server-debuginfo-12.22-150200.8.66.1
    * postgresql12-pltcl-12.22-150200.8.66.1
  * SUSE Linux Enterprise Server for SAP Applications 15 SP3 (noarch)
    * postgresql12-docs-12.22-150200.8.66.1
  * SUSE Enterprise Storage 7.1 (aarch64 x86_64)
    * postgresql12-plpython-12.22-150200.8.66.1
    * postgresql12-debuginfo-12.22-150200.8.66.1
    * postgresql12-devel-12.22-150200.8.66.1
    * postgresql12-contrib-12.22-150200.8.66.1
    * postgresql12-plperl-debuginfo-12.22-150200.8.66.1
    * postgresql12-plpython-debuginfo-12.22-150200.8.66.1
    * postgresql12-12.22-150200.8.66.1
    * postgresql12-server-12.22-150200.8.66.1
    * postgresql12-plperl-12.22-150200.8.66.1
    * postgresql12-server-devel-debuginfo-12.22-150200.8.66.1
    * postgresql12-pltcl-debuginfo-12.22-150200.8.66.1
    * postgresql12-devel-debuginfo-12.22-150200.8.66.1
    * postgresql12-server-devel-12.22-150200.8.66.1
    * postgresql12-debugsource-12.22-150200.8.66.1
    * postgresql12-contrib-debuginfo-12.22-150200.8.66.1
    * postgresql12-server-debuginfo-12.22-150200.8.66.1
    * postgresql12-pltcl-12.22-150200.8.66.1
  * SUSE Enterprise Storage 7.1 (noarch)
    * postgresql12-docs-12.22-150200.8.66.1
  * openSUSE Leap 15.5 (aarch64 ppc64le s390x x86_64)
    * postgresql12-plpython-12.22-150200.8.66.1
    * postgresql12-pltcl-debuginfo-12.22-150200.8.66.1
    * postgresql12-server-devel-12.22-150200.8.66.1
    * postgresql12-server-debuginfo-12.22-150200.8.66.1
    * postgresql12-debuginfo-12.22-150200.8.66.1
    * postgresql12-devel-12.22-150200.8.66.1
    * postgresql12-plperl-debuginfo-12.22-150200.8.66.1
    * postgresql12-server-12.22-150200.8.66.1
    * postgresql12-llvmjit-debuginfo-12.22-150200.8.66.1
    * postgresql12-contrib-debuginfo-12.22-150200.8.66.1
    * postgresql12-pltcl-12.22-150200.8.66.1
    * postgresql12-contrib-12.22-150200.8.66.1
    * postgresql12-llvmjit-devel-12.22-150200.8.66.1
    * postgresql12-plpython-debuginfo-12.22-150200.8.66.1
    * postgresql12-12.22-150200.8.66.1
    * postgresql12-plperl-12.22-150200.8.66.1
    * postgresql12-llvmjit-12.22-150200.8.66.1
    * postgresql12-devel-debuginfo-12.22-150200.8.66.1
    * postgresql12-debugsource-12.22-150200.8.66.1
    * postgresql12-test-12.22-150200.8.66.1
    * postgresql12-server-devel-debuginfo-12.22-150200.8.66.1
  * openSUSE Leap 15.5 (noarch)
    * postgresql12-docs-12.22-150200.8.66.1
  * openSUSE Leap 15.6 (aarch64 ppc64le s390x x86_64)
    * postgresql12-plpython-12.22-150200.8.66.1
    * postgresql12-pltcl-debuginfo-12.22-150200.8.66.1
    * postgresql12-server-devel-12.22-150200.8.66.1
    * postgresql12-server-debuginfo-12.22-150200.8.66.1
    * postgresql12-debuginfo-12.22-150200.8.66.1
    * postgresql12-devel-12.22-150200.8.66.1
    * postgresql12-plperl-debuginfo-12.22-150200.8.66.1
    * postgresql12-server-12.22-150200.8.66.1
    * postgresql12-llvmjit-debuginfo-12.22-150200.8.66.1
    * postgresql12-contrib-debuginfo-12.22-150200.8.66.1
    * postgresql12-pltcl-12.22-150200.8.66.1
    * postgresql12-contrib-12.22-150200.8.66.1
    * postgresql12-llvmjit-devel-12.22-150200.8.66.1
    * postgresql12-plpython-debuginfo-12.22-150200.8.66.1
    * postgresql12-12.22-150200.8.66.1
    * postgresql12-plperl-12.22-150200.8.66.1
    * postgresql12-llvmjit-12.22-150200.8.66.1
    * postgresql12-devel-debuginfo-12.22-150200.8.66.1
    * postgresql12-debugsource-12.22-150200.8.66.1
    * postgresql12-test-12.22-150200.8.66.1
    * postgresql12-server-devel-debuginfo-12.22-150200.8.66.1
  * openSUSE Leap 15.6 (noarch)
    * postgresql12-docs-12.22-150200.8.66.1

## References:

  * https://www.suse.com/security/cve/CVE-2024-10976.html
  * https://www.suse.com/security/cve/CVE-2024-10977.html
  * https://www.suse.com/security/cve/CVE-2024-10978.html
  * https://www.suse.com/security/cve/CVE-2024-10979.html
  * https://bugzilla.suse.com/show_bug.cgi?id=1233323
  * https://bugzilla.suse.com/show_bug.cgi?id=1233325
  * https://bugzilla.suse.com/show_bug.cgi?id=1233326
  * https://bugzilla.suse.com/show_bug.cgi?id=1233327

SUSE-SU-2024:4099-1: important: Security update for postgresql12

OPENSUSE-SECURITY-UPDATES