Bug 1216960 (CVE-2023-5870) - VUL-0: CVE-2023-5870: postgresql,postgresql12,postgresql13,postgresql14,postgresql15,postgresql16: pg_signal sending signals to root processes
Summary: VUL-0: CVE-2023-5870: postgresql,postgresql12,postgresql13,postgresql14,postg...
Status: RESOLVED FIXED
Alias: CVE-2023-5870
Product: SUSE Security Incidents
Classification: Novell Products
Component: Incidents (show other bugs)
Version: unspecified
Hardware: Other Other
: P3 - Medium : Normal
Target Milestone: ---
Assignee: Security Team bot
QA Contact: Security Team bot
URL: https://smash.suse.de/issue/384362/
Whiteboard: CVSSv3.1:SUSE:CVE-2023-5870:6.2:(AV:L...
Keywords:
Depends on:
Blocks:
 
Reported: 2023-11-08 13:30 UTC by SMASH SMASH
Modified: 2024-07-05 15:31 UTC (History)
2 users (show)

See Also:
Found By: Security Response Team
Services Priority:
Business Priority:
Blocker: ---
Marketing QA Status: ---
IT Deployment: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description SMASH SMASH 2023-11-08 13:30:33 UTC 
Prevent the pg_signal_backend role from signalling background workers and autovacuum processes (Noah Misch, Jelte Fennema-Nio)

The documentation says that pg_signal_backend cannot issue signals to superuser-owned processes. It was able to signal these background  processes, though, because they advertise a role OID of zero. Treat that as indicating superuser ownership. The security implications of cancelling one of these process types are fairly small so far as the core code goes (we'll just start another one), but extensions might add background workers that are more vulnerable.

Also ensure that the is_superuser parameter is set correctly in such processes. No specific security consequences are known for that oversight,  but it might be significant for some extensions.

The PostgreSQL Project thanks Hemanth Sandrana and Mahendrakar Srinivasarao for reporting this problem. (CVE-2023-5870)
Comment 2 Maintenance Automation 2023-11-13 12:45:54 UTC 
SUSE-SU-2023:4418-1: An update that solves three vulnerabilities and has two security fixes can now be installed.

Category: security (important)
Bug References: 1216022, 1216734, 1216960, 1216961, 1216962
CVE References: CVE-2023-5868, CVE-2023-5869, CVE-2023-5870
Sources used:
SUSE Linux Enterprise Software Development Kit 12 SP5 (src): postgresql14-14.10-3.33.1
SUSE Linux Enterprise High Performance Computing 12 SP5 (src): postgresql14-14.10-3.33.1
SUSE Linux Enterprise Server 12 SP5 (src): postgresql14-14.10-3.33.1
SUSE Linux Enterprise Server for SAP Applications 12 SP5 (src): postgresql14-14.10-3.33.1

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.
Comment 3 Maintenance Automation 2023-11-13 16:30:11 UTC 
SUSE-SU-2023:4425-1: An update that solves three vulnerabilities, contains one feature and has six security fixes can now be installed.

Category: security (important)
Bug References: 1122892, 1179231, 1206796, 1209208, 1216022, 1216734, 1216960, 1216961, 1216962
CVE References: CVE-2023-5868, CVE-2023-5869, CVE-2023-5870
Jira References: PED-5586
Sources used:
SUSE Linux Enterprise Software Development Kit 12 SP5 (src): postgresql16-16.1-3.7.1, postgresql-16-4.23.3, postgresql15-15.5-3.19.2
SUSE Linux Enterprise High Performance Computing 12 SP5 (src): postgresql16-16.1-3.7.1, postgresql-16-4.23.3, postgresql15-15.5-3.19.2
SUSE Linux Enterprise Server 12 SP5 (src): postgresql16-16.1-3.7.1, postgresql-16-4.23.3, postgresql15-15.5-3.19.2
SUSE Linux Enterprise Server for SAP Applications 12 SP5 (src): postgresql16-16.1-3.7.1, postgresql-16-4.23.3, postgresql15-15.5-3.19.2

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.
Comment 4 Maintenance Automation 2023-11-14 12:30:06 UTC 
SUSE-SU-2023:4434-1: An update that solves three vulnerabilities and has two security fixes can now be installed.

Category: security (important)
Bug References: 1216022, 1216734, 1216960, 1216961, 1216962
CVE References: CVE-2023-5868, CVE-2023-5869, CVE-2023-5870
Sources used:
SUSE Linux Enterprise Software Development Kit 12 SP5 (src): postgresql13-13.13-3.43.1
SUSE Linux Enterprise High Performance Computing 12 SP5 (src): postgresql13-13.13-3.43.1
SUSE Linux Enterprise Server 12 SP5 (src): postgresql13-13.13-3.43.1
SUSE Linux Enterprise Server for SAP Applications 12 SP5 (src): postgresql13-13.13-3.43.1

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.
Comment 5 Maintenance Automation 2023-11-14 12:30:09 UTC 
SUSE-SU-2023:4433-1: An update that solves three vulnerabilities and has two security fixes can now be installed.

Category: security (important)
Bug References: 1216022, 1216734, 1216960, 1216961, 1216962
CVE References: CVE-2023-5868, CVE-2023-5869, CVE-2023-5870
Sources used:
SUSE Linux Enterprise Software Development Kit 12 SP5 (src): postgresql12-12.17-3.49.1
SUSE Linux Enterprise High Performance Computing 12 SP5 (src): postgresql12-12.17-3.49.1
SUSE Linux Enterprise Server 12 SP5 (src): postgresql12-12.17-3.49.1
SUSE Linux Enterprise Server for SAP Applications 12 SP5 (src): postgresql12-12.17-3.49.1

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.
Comment 6 Maintenance Automation 2023-11-16 08:30:03 UTC 
SUSE-SU-2023:4455-1: An update that solves three vulnerabilities and has two security fixes can now be installed.

Category: security (important)
Bug References: 1216022, 1216734, 1216960, 1216961, 1216962
CVE References: CVE-2023-5868, CVE-2023-5869, CVE-2023-5870
Sources used:
openSUSE Leap 15.4 (src): postgresql13-13.13-150200.5.50.1
openSUSE Leap 15.5 (src): postgresql13-13.13-150200.5.50.1
Legacy Module 15-SP4 (src): postgresql13-13.13-150200.5.50.1
SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2 (src): postgresql13-13.13-150200.5.50.1
SUSE Linux Enterprise High Performance Computing ESPOS 15 SP3 (src): postgresql13-13.13-150200.5.50.1
SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 (src): postgresql13-13.13-150200.5.50.1
SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2 (src): postgresql13-13.13-150200.5.50.1
SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3 (src): postgresql13-13.13-150200.5.50.1
Galera for Ericsson 15 SP5 (src): postgresql13-13.13-150200.5.50.1
SUSE Linux Enterprise Server for SAP Applications 15 SP2 (src): postgresql13-13.13-150200.5.50.1
SUSE Linux Enterprise Server for SAP Applications 15 SP3 (src): postgresql13-13.13-150200.5.50.1
SUSE Enterprise Storage 7.1 (src): postgresql13-13.13-150200.5.50.1

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.
Comment 7 Maintenance Automation 2023-11-16 08:30:06 UTC 
SUSE-SU-2023:4454-1: An update that solves three vulnerabilities and has two security fixes can now be installed.

Category: security (important)
Bug References: 1216022, 1216734, 1216960, 1216961, 1216962
CVE References: CVE-2023-5868, CVE-2023-5869, CVE-2023-5870
Sources used:
openSUSE Leap 15.4 (src): postgresql12-12.17-150200.8.54.1
openSUSE Leap 15.5 (src): postgresql12-12.17-150200.8.54.1
SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2 (src): postgresql12-12.17-150200.8.54.1
SUSE Linux Enterprise High Performance Computing ESPOS 15 SP3 (src): postgresql12-12.17-150200.8.54.1
SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 (src): postgresql12-12.17-150200.8.54.1
SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2 (src): postgresql12-12.17-150200.8.54.1
SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3 (src): postgresql12-12.17-150200.8.54.1
SUSE Linux Enterprise Server for SAP Applications 15 SP2 (src): postgresql12-12.17-150200.8.54.1
SUSE Linux Enterprise Server for SAP Applications 15 SP3 (src): postgresql12-12.17-150200.8.54.1
SUSE Enterprise Storage 7.1 (src): postgresql12-12.17-150200.8.54.1

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.
Comment 8 Maintenance Automation 2023-11-20 12:30:07 UTC 
SUSE-SU-2023:4479-1: An update that solves three vulnerabilities and has two security fixes can now be installed.

Category: security (important)
Bug References: 1216022, 1216734, 1216960, 1216961, 1216962
CVE References: CVE-2023-5868, CVE-2023-5869, CVE-2023-5870
Sources used:
SUSE Linux Enterprise Server for SAP Applications 15 SP3 (src): postgresql14-14.10-150200.5.36.1
SUSE Enterprise Storage 7.1 (src): postgresql14-14.10-150200.5.36.1
openSUSE Leap 15.4 (src): postgresql14-14.10-150200.5.36.1
openSUSE Leap 15.5 (src): postgresql14-14.10-150200.5.36.1
Basesystem Module 15-SP4 (src): postgresql14-14.10-150200.5.36.1
Legacy Module 15-SP5 (src): postgresql14-14.10-150200.5.36.1
SUSE Package Hub 15 15-SP4 (src): postgresql14-14.10-150200.5.36.1
SUSE Package Hub 15 15-SP5 (src): postgresql14-14.10-150200.5.36.1
Server Applications Module 15-SP4 (src): postgresql14-14.10-150200.5.36.1
SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2 (src): postgresql14-14.10-150200.5.36.1
SUSE Linux Enterprise High Performance Computing ESPOS 15 SP3 (src): postgresql14-14.10-150200.5.36.1
SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 (src): postgresql14-14.10-150200.5.36.1
SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2 (src): postgresql14-14.10-150200.5.36.1
SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3 (src): postgresql14-14.10-150200.5.36.1
SUSE Linux Enterprise Server for SAP Applications 15 SP2 (src): postgresql14-14.10-150200.5.36.1

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.
Comment 9 Maintenance Automation 2023-11-21 08:30:03 UTC 
SUSE-SU-2023:4495-1: An update that solves three vulnerabilities, contains one feature and has six security fixes can now be installed.

Category: security (important)
Bug References: 1122892, 1179231, 1206796, 1209208, 1216022, 1216734, 1216960, 1216961, 1216962
CVE References: CVE-2023-5868, CVE-2023-5869, CVE-2023-5870
Jira References: PED-5586
Sources used:
openSUSE Leap 15.3 (src): postgresql-16-150300.10.18.3
openSUSE Leap 15.4 (src): postgresql-16-150400.4.9.2, postgresql16-mini-16.1-150200.5.7.1, postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1
openSUSE Leap 15.5 (src): postgresql-16-150500.10.3.2, postgresql16-mini-16.1-150200.5.7.1, postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1
Basesystem Module 15-SP4 (src): postgresql-16-150400.4.9.2, postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1
Basesystem Module 15-SP5 (src): postgresql-16-150500.10.3.2, postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1
Legacy Module 15-SP4 (src): postgresql-16-150400.4.9.2
Legacy Module 15-SP5 (src): postgresql-16-150500.10.3.2
SUSE Package Hub 15 15-SP4 (src): postgresql-16-150400.4.9.2, postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1
SUSE Package Hub 15 15-SP5 (src): postgresql-16-150500.10.3.2, postgresql16-16.1-150200.5.7.1
Server Applications Module 15-SP4 (src): postgresql-16-150400.4.9.2, postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1
Server Applications Module 15-SP5 (src): postgresql-16-150500.10.3.2, postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1
SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2 (src): postgresql16-16.1-150200.5.7.1, postgresql-16-150200.4.24.1
SUSE Linux Enterprise High Performance Computing ESPOS 15 SP3 (src): postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1, postgresql-16-150300.10.18.3
SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 (src): postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1, postgresql-16-150300.10.18.3
SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2 (src): postgresql16-16.1-150200.5.7.1, postgresql-16-150200.4.24.1
SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3 (src): postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1, postgresql-16-150300.10.18.3
SUSE Linux Enterprise Server for SAP Applications 15 SP2 (src): postgresql16-16.1-150200.5.7.1, postgresql-16-150200.4.24.1
SUSE Linux Enterprise Server for SAP Applications 15 SP3 (src): postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1, postgresql-16-150300.10.18.3
SUSE Enterprise Storage 7.1 (src): postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1, postgresql-16-150300.10.18.3

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.
Comment 10 Maintenance Automation 2024-01-15 20:30:01 UTC 
SUSE-SU-2024:0106-1: An update that solves three vulnerabilities, contains one feature and has six security fixes can now be installed.

Category: security (important)
Bug References: 1122892, 1179231, 1206796, 1209208, 1216022, 1216734, 1216960, 1216961, 1216962
CVE References: CVE-2023-5868, CVE-2023-5869, CVE-2023-5870
Jira References: PED-5586
Sources used:
Basesystem Module 15-SP4 (src): postgresql-16-150400.4.9.2, postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1
Basesystem Module 15-SP5 (src): postgresql16-16.1-150200.5.7.1, postgresql15-15.5-150200.5.19.1, postgresql-16-150500.10.3.2
Legacy Module 15-SP4 (src): postgresql-16-150400.4.9.2
Legacy Module 15-SP5 (src): postgresql-16-150500.10.3.2
SUSE Package Hub 15 15-SP4 (src): postgresql-16-150400.4.9.2, postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1
Server Applications Module 15-SP4 (src): postgresql-16-150400.4.9.2, postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1
Server Applications Module 15-SP5 (src): postgresql16-16.1-150200.5.7.1, postgresql15-15.5-150200.5.19.1, postgresql-16-150500.10.3.2
SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3 (src): postgresql-16-150300.10.18.3, postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.
Comment 11 OBSbugzilla Bot 2024-02-08 17:55:01 UTC 
This is an autogenerated message for OBS integration:
This bug (1216960) was mentioned in
https://build.opensuse.org/request/show/1145273 Factory / postgresql12
Comment 12 Thomas Leroy 2024-07-05 15:30:25 UTC 
All done, closing.
Comment 13 Thomas Leroy 2024-07-05 15:31:01 UTC 
All done, closing.