SUSE-SU-2024:4174-1: important: Security update for postgresql15
# Security update for postgresql15 Announcement ID: SUSE-SU-2024:4174-1 Release Date: 2024-12-04T14:50:52Z 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: * Basesystem Module 15-SP5 * openSUSE Leap 15.5 * Server Applications Module 15-SP5 * SUSE Enterprise Storage 7.1 * SUSE Linux Enterprise Desktop 15 SP4 LTSS * SUSE Linux Enterprise Desktop 15 SP5 * SUSE Linux Enterprise High Performance Computing 15 SP3 * SUSE Linux Enterprise High Performance Computing 15 SP4 * SUSE Linux Enterprise High Performance Computing 15 SP5 * SUSE Linux Enterprise High Performance Computing ESPOS 15 SP4 * SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 * SUSE Linux Enterprise High Performance Computing LTSS 15 SP4 * SUSE Linux Enterprise Real Time 15 SP5 * SUSE Linux Enterprise Server 15 SP3 * SUSE Linux Enterprise Server 15 SP3 LTSS * SUSE Linux Enterprise Server 15 SP4 * SUSE Linux Enterprise Server 15 SP4 LTSS * SUSE Linux Enterprise Server 15 SP5 * SUSE Linux Enterprise Server for SAP Applications 15 SP3 * SUSE Linux Enterprise Server for SAP Applications 15 SP4 * SUSE Linux Enterprise Server for SAP Applications 15 SP5 * SUSE Manager Proxy 4.3 * SUSE Manager Retail Branch Server 4.3 * SUSE Manager Server 4.3 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.5 zypper in -t patch openSUSE-SLE-15.5-2024-4174=1 * Basesystem Module 15-SP5 zypper in -t patch SUSE-SLE-Module-Basesystem-15-SP5-2024-4174=1 * Server Applications Module 15-SP5 zypper in -t patch SUSE-SLE-Module-Server-Applications-15-SP5-2024-4174=1 * SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 zypper in -t patch SUSE-SLE-Product-HPC-15-SP3-LTSS-2024-4174=1 * SUSE Linux Enterprise High Performance Computing ESPOS 15 SP4 zypper in -t patch SUSE-SLE-Product-HPC-15-SP4-ESPOS-2024-4174=1 * SUSE Linux Enterprise High Performance Computing LTSS 15 SP4 zypper in -t patch SUSE-SLE-Product-HPC-15-SP4-LTSS-2024-4174=1 * SUSE Linux Enterprise Desktop 15 SP4 LTSS zypper in -t patch SUSE-SLE-Product-SLED-15-SP4-LTSS-2024-4174=1 * SUSE Linux Enterprise Server 15 SP3 LTSS zypper in -t patch SUSE-SLE-Product-SLES-15-SP3-LTSS-2024-4174=1 * SUSE Linux Enterprise Server 15 SP4 LTSS zypper in -t patch SUSE-SLE-Product-SLES-15-SP4-LTSS-2024-4174=1 * SUSE Linux Enterprise Server for SAP Applications 15 SP3 zypper in -t patch SUSE-SLE-Product-SLES_SAP-15-SP3-2024-4174=1 * SUSE Linux Enterprise Server for SAP Applications 15 SP4 zypper in -t patch SUSE-SLE-Product-SLES_SAP-15-SP4-2024-4174=1 * SUSE Manager Proxy 4.3 zypper in -t patch SUSE-SLE-Product-SUSE-Manager-Proxy-4.3-2024-4174=1 * SUSE Manager Retail Branch Server 4.3 zypper in -t patch SUSE-SLE-Product-SUSE-Manager-Retail-Branch- Server-4.3-2024-4174=1 * SUSE Manager Server 4.3 zypper in -t patch SUSE-SLE-Product-SUSE-Manager-Server-4.3-2024-4174=1 * SUSE Enterprise Storage 7.1 zypper in -t patch SUSE-Storage-7.1-2024-4174=1 ## Package List: * openSUSE Leap 15.5 (aarch64 ppc64le s390x x86_64) * postgresql15-plpython-debuginfo-15.10-150200.5.33.1 * postgresql15-plpython-15.10-150200.5.33.1 * postgresql15-llvmjit-devel-15.10-150200.5.33.1 * postgresql15-plperl-15.10-150200.5.33.1 * postgresql15-debuginfo-15.10-150200.5.33.1 * postgresql15-llvmjit-debuginfo-15.10-150200.5.33.1 * postgresql15-test-15.10-150200.5.33.1 * postgresql15-devel-debuginfo-15.10-150200.5.33.1 * postgresql15-devel-15.10-150200.5.33.1 * postgresql15-server-devel-15.10-150200.5.33.1 * postgresql15-server-debuginfo-15.10-150200.5.33.1 * postgresql15-pltcl-15.10-150200.5.33.1 * postgresql15-contrib-15.10-150200.5.33.1 * postgresql15-pltcl-debuginfo-15.10-150200.5.33.1 * postgresql15-server-15.10-150200.5.33.1 * postgresql15-contrib-debuginfo-15.10-150200.5.33.1 * postgresql15-15.10-150200.5.33.1 * postgresql15-plperl-debuginfo-15.10-150200.5.33.1 * postgresql15-server-devel-debuginfo-15.10-150200.5.33.1 * postgresql15-llvmjit-15.10-150200.5.33.1 * postgresql15-debugsource-15.10-150200.5.33.1 * openSUSE Leap 15.5 (noarch) * postgresql15-docs-15.10-150200.5.33.1 * Basesystem Module 15-SP5 (aarch64 ppc64le s390x x86_64) * postgresql15-debuginfo-15.10-150200.5.33.1 * postgresql15-15.10-150200.5.33.1 * postgresql15-debugsource-15.10-150200.5.33.1 * Server Applications Module 15-SP5 (aarch64 ppc64le s390x x86_64) * postgresql15-devel-15.10-150200.5.33.1 * postgresql15-plpython-debuginfo-15.10-150200.5.33.1 * postgresql15-server-15.10-150200.5.33.1 * postgresql15-server-devel-15.10-150200.5.33.1 * postgresql15-plperl-15.10-150200.5.33.1 * postgresql15-debuginfo-15.10-150200.5.33.1 * postgresql15-contrib-debuginfo-15.10-150200.5.33.1 * postgresql15-plpython-15.10-150200.5.33.1 * postgresql15-server-debuginfo-15.10-150200.5.33.1 * postgresql15-plperl-debuginfo-15.10-150200.5.33.1 * postgresql15-pltcl-15.10-150200.5.33.1 * postgresql15-contrib-15.10-150200.5.33.1 * postgresql15-pltcl-debuginfo-15.10-150200.5.33.1 * postgresql15-server-devel-debuginfo-15.10-150200.5.33.1 * postgresql15-devel-debuginfo-15.10-150200.5.33.1 * postgresql15-debugsource-15.10-150200.5.33.1 * Server Applications Module 15-SP5 (noarch) * postgresql15-docs-15.10-150200.5.33.1 * SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 (aarch64 x86_64) * postgresql15-devel-15.10-150200.5.33.1 * postgresql15-plpython-debuginfo-15.10-150200.5.33.1 * postgresql15-server-15.10-150200.5.33.1 * postgresql15-server-devel-15.10-150200.5.33.1 * postgresql15-plperl-15.10-150200.5.33.1 * postgresql15-contrib-debuginfo-15.10-150200.5.33.1 * postgresql15-debuginfo-15.10-150200.5.33.1 * postgresql15-15.10-150200.5.33.1 * postgresql15-plpython-15.10-150200.5.33.1 * postgresql15-server-debuginfo-15.10-150200.5.33.1 * postgresql15-plperl-debuginfo-15.10-150200.5.33.1 * postgresql15-pltcl-15.10-150200.5.33.1 * postgresql15-contrib-15.10-150200.5.33.1 * postgresql15-pltcl-debuginfo-15.10-150200.5.33.1 * postgresql15-server-devel-debuginfo-15.10-150200.5.33.1 * postgresql15-devel-debuginfo-15.10-150200.5.33.1 * postgresql15-debugsource-15.10-150200.5.33.1 * SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 (noarch) * postgresql15-docs-15.10-150200.5.33.1 * SUSE Linux Enterprise High Performance Computing ESPOS 15 SP4 (aarch64 x86_64) * postgresql15-devel-15.10-150200.5.33.1 * postgresql15-plpython-debuginfo-15.10-150200.5.33.1 * postgresql15-server-15.10-150200.5.33.1 * postgresql15-server-devel-15.10-150200.5.33.1 * postgresql15-plperl-15.10-150200.5.33.1 * postgresql15-contrib-debuginfo-15.10-150200.5.33.1 * postgresql15-debuginfo-15.10-150200.5.33.1 * postgresql15-15.10-150200.5.33.1 * postgresql15-plpython-15.10-150200.5.33.1 * postgresql15-server-debuginfo-15.10-150200.5.33.1 * postgresql15-plperl-debuginfo-15.10-150200.5.33.1 * postgresql15-pltcl-15.10-150200.5.33.1 * postgresql15-contrib-15.10-150200.5.33.1 * postgresql15-pltcl-debuginfo-15.10-150200.5.33.1 * postgresql15-server-devel-debuginfo-15.10-150200.5.33.1 * postgresql15-devel-debuginfo-15.10-150200.5.33.1 * postgresql15-debugsource-15.10-150200.5.33.1 * SUSE Linux Enterprise High Performance Computing ESPOS 15 SP4 (noarch) * postgresql15-docs-15.10-150200.5.33.1 * SUSE Linux Enterprise High Performance Computing LTSS 15 SP4 (aarch64 x86_64) * postgresql15-devel-15.10-150200.5.33.1 * postgresql15-plpython-debuginfo-15.10-150200.5.33.1 * postgresql15-server-15.10-150200.5.33.1 * postgresql15-server-devel-15.10-150200.5.33.1 * postgresql15-plperl-15.10-150200.5.33.1 * postgresql15-contrib-debuginfo-15.10-150200.5.33.1 * postgresql15-debuginfo-15.10-150200.5.33.1 * postgresql15-15.10-150200.5.33.1 * postgresql15-plpython-15.10-150200.5.33.1 * postgresql15-server-debuginfo-15.10-150200.5.33.1 * postgresql15-plperl-debuginfo-15.10-150200.5.33.1 * postgresql15-pltcl-15.10-150200.5.33.1 * postgresql15-contrib-15.10-150200.5.33.1 * postgresql15-pltcl-debuginfo-15.10-150200.5.33.1 * postgresql15-server-devel-debuginfo-15.10-150200.5.33.1 * postgresql15-devel-debuginfo-15.10-150200.5.33.1 * postgresql15-debugsource-15.10-150200.5.33.1 * SUSE Linux Enterprise High Performance Computing LTSS 15 SP4 (noarch) * postgresql15-docs-15.10-150200.5.33.1 * SUSE Linux Enterprise Desktop 15 SP4 LTSS (x86_64) * postgresql15-debuginfo-15.10-150200.5.33.1 * postgresql15-15.10-150200.5.33.1 * postgresql15-debugsource-15.10-150200.5.33.1 * SUSE Linux Enterprise Server 15 SP3 LTSS (aarch64 ppc64le s390x x86_64) * postgresql15-devel-15.10-150200.5.33.1 * postgresql15-plpython-debuginfo-15.10-150200.5.33.1 * postgresql15-server-15.10-150200.5.33.1 * postgresql15-server-devel-15.10-150200.5.33.1 * postgresql15-plperl-15.10-150200.5.33.1 * postgresql15-contrib-debuginfo-15.10-150200.5.33.1 * postgresql15-debuginfo-15.10-150200.5.33.1 * postgresql15-15.10-150200.5.33.1 * postgresql15-plpython-15.10-150200.5.33.1 * postgresql15-server-debuginfo-15.10-150200.5.33.1 * postgresql15-plperl-debuginfo-15.10-150200.5.33.1 * postgresql15-pltcl-15.10-150200.5.33.1 * postgresql15-contrib-15.10-150200.5.33.1 * postgresql15-pltcl-debuginfo-15.10-150200.5.33.1 * postgresql15-server-devel-debuginfo-15.10-150200.5.33.1 * postgresql15-devel-debuginfo-15.10-150200.5.33.1 * postgresql15-debugsource-15.10-150200.5.33.1 * SUSE Linux Enterprise Server 15 SP3 LTSS (noarch) * postgresql15-docs-15.10-150200.5.33.1 * SUSE Linux Enterprise Server 15 SP4 LTSS (aarch64 ppc64le s390x x86_64) * postgresql15-devel-15.10-150200.5.33.1 * postgresql15-plpython-debuginfo-15.10-150200.5.33.1 * postgresql15-server-15.10-150200.5.33.1 * postgresql15-server-devel-15.10-150200.5.33.1 * postgresql15-plperl-15.10-150200.5.33.1 * postgresql15-contrib-debuginfo-15.10-150200.5.33.1 * postgresql15-debuginfo-15.10-150200.5.33.1 * postgresql15-15.10-150200.5.33.1 * postgresql15-plpython-15.10-150200.5.33.1 * postgresql15-server-debuginfo-15.10-150200.5.33.1 * postgresql15-plperl-debuginfo-15.10-150200.5.33.1 * postgresql15-pltcl-15.10-150200.5.33.1 * postgresql15-contrib-15.10-150200.5.33.1 * postgresql15-pltcl-debuginfo-15.10-150200.5.33.1 * postgresql15-server-devel-debuginfo-15.10-150200.5.33.1 * postgresql15-devel-debuginfo-15.10-150200.5.33.1 * postgresql15-debugsource-15.10-150200.5.33.1 * SUSE Linux Enterprise Server 15 SP4 LTSS (noarch) * postgresql15-docs-15.10-150200.5.33.1 * SUSE Linux Enterprise Server for SAP Applications 15 SP3 (ppc64le x86_64) * postgresql15-devel-15.10-150200.5.33.1 * postgresql15-plpython-debuginfo-15.10-150200.5.33.1 * postgresql15-server-15.10-150200.5.33.1 * postgresql15-server-devel-15.10-150200.5.33.1 * postgresql15-plperl-15.10-150200.5.33.1 * postgresql15-contrib-debuginfo-15.10-150200.5.33.1 * postgresql15-debuginfo-15.10-150200.5.33.1 * postgresql15-15.10-150200.5.33.1 * postgresql15-plpython-15.10-150200.5.33.1 * postgresql15-server-debuginfo-15.10-150200.5.33.1 * postgresql15-plperl-debuginfo-15.10-150200.5.33.1 * postgresql15-pltcl-15.10-150200.5.33.1 * postgresql15-contrib-15.10-150200.5.33.1 * postgresql15-pltcl-debuginfo-15.10-150200.5.33.1 * postgresql15-server-devel-debuginfo-15.10-150200.5.33.1 * postgresql15-devel-debuginfo-15.10-150200.5.33.1 * postgresql15-debugsource-15.10-150200.5.33.1 * SUSE Linux Enterprise Server for SAP Applications 15 SP3 (noarch) * postgresql15-docs-15.10-150200.5.33.1 * SUSE Linux Enterprise Server for SAP Applications 15 SP4 (ppc64le x86_64) * postgresql15-devel-15.10-150200.5.33.1 * postgresql15-plpython-debuginfo-15.10-150200.5.33.1 * postgresql15-server-15.10-150200.5.33.1 * postgresql15-server-devel-15.10-150200.5.33.1 * postgresql15-plperl-15.10-150200.5.33.1 * postgresql15-contrib-debuginfo-15.10-150200.5.33.1 * postgresql15-debuginfo-15.10-150200.5.33.1 * postgresql15-15.10-150200.5.33.1 * postgresql15-plpython-15.10-150200.5.33.1 * postgresql15-server-debuginfo-15.10-150200.5.33.1 * postgresql15-plperl-debuginfo-15.10-150200.5.33.1 * postgresql15-pltcl-15.10-150200.5.33.1 * postgresql15-contrib-15.10-150200.5.33.1 * postgresql15-pltcl-debuginfo-15.10-150200.5.33.1 * postgresql15-server-devel-debuginfo-15.10-150200.5.33.1 * postgresql15-devel-debuginfo-15.10-150200.5.33.1 * postgresql15-debugsource-15.10-150200.5.33.1 * SUSE Linux Enterprise Server for SAP Applications 15 SP4 (noarch) * postgresql15-docs-15.10-150200.5.33.1 * SUSE Manager Proxy 4.3 (x86_64) * postgresql15-devel-15.10-150200.5.33.1 * postgresql15-plpython-debuginfo-15.10-150200.5.33.1 * postgresql15-server-15.10-150200.5.33.1 * postgresql15-server-devel-15.10-150200.5.33.1 * postgresql15-plperl-15.10-150200.5.33.1 * postgresql15-contrib-debuginfo-15.10-150200.5.33.1 * postgresql15-debuginfo-15.10-150200.5.33.1 * postgresql15-15.10-150200.5.33.1 * postgresql15-plpython-15.10-150200.5.33.1 * postgresql15-server-debuginfo-15.10-150200.5.33.1 * postgresql15-plperl-debuginfo-15.10-150200.5.33.1 * postgresql15-pltcl-15.10-150200.5.33.1 * postgresql15-contrib-15.10-150200.5.33.1 * postgresql15-pltcl-debuginfo-15.10-150200.5.33.1 * postgresql15-server-devel-debuginfo-15.10-150200.5.33.1 * postgresql15-devel-debuginfo-15.10-150200.5.33.1 * postgresql15-debugsource-15.10-150200.5.33.1 * SUSE Manager Proxy 4.3 (noarch) * postgresql15-docs-15.10-150200.5.33.1 * SUSE Manager Retail Branch Server 4.3 (x86_64) * postgresql15-devel-15.10-150200.5.33.1 * postgresql15-plpython-debuginfo-15.10-150200.5.33.1 * postgresql15-server-15.10-150200.5.33.1 * postgresql15-server-devel-15.10-150200.5.33.1 * postgresql15-plperl-15.10-150200.5.33.1 * postgresql15-contrib-debuginfo-15.10-150200.5.33.1 * postgresql15-debuginfo-15.10-150200.5.33.1 * postgresql15-15.10-150200.5.33.1 * postgresql15-plpython-15.10-150200.5.33.1 * postgresql15-server-debuginfo-15.10-150200.5.33.1 * postgresql15-plperl-debuginfo-15.10-150200.5.33.1 * postgresql15-pltcl-15.10-150200.5.33.1 * postgresql15-contrib-15.10-150200.5.33.1 * postgresql15-pltcl-debuginfo-15.10-150200.5.33.1 * postgresql15-server-devel-debuginfo-15.10-150200.5.33.1 * postgresql15-devel-debuginfo-15.10-150200.5.33.1 * postgresql15-debugsource-15.10-150200.5.33.1 * SUSE Manager Retail Branch Server 4.3 (noarch) * postgresql15-docs-15.10-150200.5.33.1 * SUSE Manager Server 4.3 (ppc64le s390x x86_64) * postgresql15-devel-15.10-150200.5.33.1 * postgresql15-plpython-debuginfo-15.10-150200.5.33.1 * postgresql15-server-15.10-150200.5.33.1 * postgresql15-server-devel-15.10-150200.5.33.1 * postgresql15-plperl-15.10-150200.5.33.1 * postgresql15-contrib-debuginfo-15.10-150200.5.33.1 * postgresql15-debuginfo-15.10-150200.5.33.1 * postgresql15-15.10-150200.5.33.1 * postgresql15-plpython-15.10-150200.5.33.1 * postgresql15-server-debuginfo-15.10-150200.5.33.1 * postgresql15-plperl-debuginfo-15.10-150200.5.33.1 * postgresql15-pltcl-15.10-150200.5.33.1 * postgresql15-contrib-15.10-150200.5.33.1 * postgresql15-pltcl-debuginfo-15.10-150200.5.33.1 * postgresql15-server-devel-debuginfo-15.10-150200.5.33.1 * postgresql15-devel-debuginfo-15.10-150200.5.33.1 * postgresql15-debugsource-15.10-150200.5.33.1 * SUSE Manager Server 4.3 (noarch) * postgresql15-docs-15.10-150200.5.33.1 * SUSE Enterprise Storage 7.1 (aarch64 x86_64) * postgresql15-devel-15.10-150200.5.33.1 * postgresql15-plpython-debuginfo-15.10-150200.5.33.1 * postgresql15-server-15.10-150200.5.33.1 * postgresql15-server-devel-15.10-150200.5.33.1 * postgresql15-plperl-15.10-150200.5.33.1 * postgresql15-contrib-debuginfo-15.10-150200.5.33.1 * postgresql15-debuginfo-15.10-150200.5.33.1 * postgresql15-15.10-150200.5.33.1 * postgresql15-plpython-15.10-150200.5.33.1 * postgresql15-server-debuginfo-15.10-150200.5.33.1 * postgresql15-plperl-debuginfo-15.10-150200.5.33.1 * postgresql15-pltcl-15.10-150200.5.33.1 * postgresql15-contrib-15.10-150200.5.33.1 * postgresql15-pltcl-debuginfo-15.10-150200.5.33.1 * postgresql15-server-devel-debuginfo-15.10-150200.5.33.1 * postgresql15-devel-debuginfo-15.10-150200.5.33.1 * postgresql15-debugsource-15.10-150200.5.33.1 * SUSE Enterprise Storage 7.1 (noarch) * postgresql15-docs-15.10-150200.5.33.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
participants (1)
-
OPENSUSE-SECURITY-UPDATES