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