Security update for postgresql15

Announcement ID:	SUSE-SU-2024:4098-1
Release Date:	2024-11-28T12:24:37Z
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:	Legacy Module 15-SP6 openSUSE Leap 15.6 SUSE Linux Enterprise Server 15 SP6 SUSE Linux Enterprise Server for SAP Applications 15 SP6

An update that solves four vulnerabilities can now be installed.

Description:

This update for postgresql15 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:

• openSUSE Leap 15.6
  zypper in -t patch SUSE-2024-4098=1 openSUSE-SLE-15.6-2024-4098=1
• Legacy Module 15-SP6
  zypper in -t patch SUSE-SLE-Module-Legacy-15-SP6-2024-4098=1

Package List:

• openSUSE Leap 15.6 (aarch64 ppc64le s390x x86_64 i586)
  • postgresql15-debuginfo-15.10-150600.16.9.1
  • postgresql15-llvmjit-debuginfo-15.10-150600.16.9.1
  • postgresql15-plpython-debuginfo-15.10-150600.16.9.1
  • postgresql15-plperl-15.10-150600.16.9.1
  • postgresql15-server-devel-15.10-150600.16.9.1
  • postgresql15-15.10-150600.16.9.1
  • postgresql15-contrib-debuginfo-15.10-150600.16.9.1
  • postgresql15-devel-15.10-150600.16.9.1
  • postgresql15-llvmjit-15.10-150600.16.9.1
  • postgresql15-plperl-debuginfo-15.10-150600.16.9.1
  • postgresql15-server-devel-debuginfo-15.10-150600.16.9.1
  • postgresql15-contrib-15.10-150600.16.9.1
  • postgresql15-pltcl-debuginfo-15.10-150600.16.9.1
  • postgresql15-plpython-15.10-150600.16.9.1
  • postgresql15-server-15.10-150600.16.9.1
  • postgresql15-debugsource-15.10-150600.16.9.1
  • postgresql15-pltcl-15.10-150600.16.9.1
  • postgresql15-llvmjit-devel-15.10-150600.16.9.1
  • postgresql15-test-15.10-150600.16.9.1
  • postgresql15-devel-debuginfo-15.10-150600.16.9.1
  • postgresql15-server-debuginfo-15.10-150600.16.9.1
• openSUSE Leap 15.6 (noarch)
  • postgresql15-docs-15.10-150600.16.9.1
• Legacy Module 15-SP6 (aarch64 ppc64le s390x x86_64)
  • postgresql15-debuginfo-15.10-150600.16.9.1
  • postgresql15-plperl-debuginfo-15.10-150600.16.9.1
  • postgresql15-server-devel-15.10-150600.16.9.1
  • postgresql15-devel-15.10-150600.16.9.1
  • postgresql15-devel-debuginfo-15.10-150600.16.9.1
  • postgresql15-server-devel-debuginfo-15.10-150600.16.9.1
  • postgresql15-contrib-15.10-150600.16.9.1
  • postgresql15-plperl-15.10-150600.16.9.1
  • postgresql15-server-debuginfo-15.10-150600.16.9.1
  • postgresql15-15.10-150600.16.9.1
  • postgresql15-plpython-debuginfo-15.10-150600.16.9.1
  • postgresql15-pltcl-debuginfo-15.10-150600.16.9.1
  • postgresql15-plpython-15.10-150600.16.9.1
  • postgresql15-server-15.10-150600.16.9.1
  • postgresql15-contrib-debuginfo-15.10-150600.16.9.1
  • postgresql15-debugsource-15.10-150600.16.9.1
  • postgresql15-pltcl-15.10-150600.16.9.1
• Legacy Module 15-SP6 (noarch)
  • postgresql15-docs-15.10-150600.16.9.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