Bug 1192516 (CVE-2021-23214) - VUL-0: postgresql12,postgresql13,postgresql14: 2 November 2021 security issues
Summary: VUL-0: postgresql12,postgresql13,postgresql14: 2 November 2021 security issues
Status: RESOLVED FIXED
Alias: CVE-2021-23214
Product: SUSE Security Incidents
Classification: Novell Products
Component: Incidents (show other bugs)
Version: unspecified
Hardware: Other Other
: P1 - Urgent : Major
Target Milestone: ---
Assignee: Security Team bot
QA Contact: Security Team bot
URL: https://smash.suse.de/issue/314534/
Whiteboard: CVSSv3.1:SUSE:CVE-2021-23214:8.1:(AV:...
Keywords:
Depends on:
Blocks:
 
Reported: 2021-11-09 13:32 UTC by Marcus Meissner
Modified: 2024-04-19 12:42 UTC (History)
1 user (show)

See Also:
Found By: ---
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.
Comment 1 Marcus Meissner 2021-11-11 14:56:45 UTC 
is public

https://www.postgresql.org/about/news/postgresql-141-135-129-1114-1019-and-9624-released-2349/

https://www.postgresql.org/support/security/CVE-2021-23214/

Server processes unencrypted bytes from man-in-the-middle

When the server is configured to use trust authentication with a clientcert requirement or to use cert authentication, a man-in-the-middle attacker can inject arbitrary SQL queries when a connection is first established, despite the use of SSL certificate verification and encryption. This is similar to CVE-2011-0411 (different product).

The PostgreSQL project thanks Jacob Champion for reporting this problem.

9.6 -> 14 affected


https://www.postgresql.org/support/security/CVE-2021-23222/
libpq processes unencrypted bytes from man-in-the-middle

A man-in-the-middle attacker can inject false responses to the client's first few queries, despite the use of SSL certificate verification and encryption.

If more preconditions hold, the attacker can exfiltrate the client's password or other confidential data that might be transmitted early in a session. The attacker must have a way to trick the client's intended server into making the confidential data accessible to the attacker. A known implementation having that property is a PostgreSQL configuration vulnerable to CVE-2021-32029. As with any exploitation of CVE-2021-32029, the server must be using trust authentication with a clientcert requirement or using cert authentication. To disclose a password, the client must be in possession of a password, which is atypical when using an authentication configuration vulnerable to CVE-2021-32029. The attacker must have some other way to access the server to retrieve the exfiltrated data (a valid, unprivileged login account would be sufficient).

The PostgreSQL project thanks Jacob Champion for reporting this problem.

9.6 -> 14
Comment 3 OBSbugzilla Bot 2021-11-11 17:40:17 UTC 
This is an autogenerated message for OBS integration:
This bug (1192516) was mentioned in
https://build.opensuse.org/request/show/930949 Factory / postgresql14
https://build.opensuse.org/request/show/930950 Factory / postgresql13
https://build.opensuse.org/request/show/930951 Factory / postgresql12
https://build.opensuse.org/request/show/930952 Factory / postgresql11
https://build.opensuse.org/request/show/930953 Factory / postgresql10
Comment 5 Reinhard Max 2021-11-12 12:42:08 UTC 
All packages submitted.
Comment 6 Swamp Workflow Management 2021-11-20 20:18:03 UTC 
SUSE-SU-2021:3755-1: An update that fixes two vulnerabilities, contains one feature is now available.

Category: security (important)
Bug References: 1192516
CVE References: CVE-2021-23214,CVE-2021-23222
JIRA References: SLE-22673
Sources used:
SUSE OpenStack Cloud Crowbar 9 (src):    postgresql-14-4.10.1, postgresql14-14.1-3.3.1
SUSE OpenStack Cloud Crowbar 8 (src):    postgresql-14-4.10.1, postgresql14-14.1-3.3.1
SUSE OpenStack Cloud 9 (src):    postgresql-14-4.10.1, postgresql14-14.1-3.3.1
SUSE OpenStack Cloud 8 (src):    postgresql-14-4.10.1, postgresql14-14.1-3.3.1
SUSE Linux Enterprise Software Development Kit 12-SP5 (src):    postgresql-14-4.10.1, postgresql13-13.5-3.15.2, postgresql14-14.1-3.3.1
SUSE Linux Enterprise Server for SAP 12-SP4 (src):    postgresql-14-4.10.1, postgresql14-14.1-3.3.1
SUSE Linux Enterprise Server for SAP 12-SP3 (src):    postgresql-14-4.10.1, postgresql14-14.1-3.3.1
SUSE Linux Enterprise Server 12-SP5 (src):    postgresql-14-4.10.1, postgresql13-13.5-3.15.2, postgresql14-14.1-3.3.1
SUSE Linux Enterprise Server 12-SP4-LTSS (src):    postgresql-14-4.10.1, postgresql14-14.1-3.3.1
SUSE Linux Enterprise Server 12-SP3-LTSS (src):    postgresql-14-4.10.1, postgresql14-14.1-3.3.1
SUSE Linux Enterprise Server 12-SP3-BCL (src):    postgresql-14-4.10.1, postgresql14-14.1-3.3.1
SUSE Linux Enterprise Server 12-SP2-BCL (src):    postgresql-14-4.10.1, postgresql14-14.1-3.3.1
HPE Helion Openstack 8 (src):    postgresql-14-4.10.1, postgresql14-14.1-3.3.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 Swamp Workflow Management 2021-11-22 14:19:09 UTC 
openSUSE-SU-2021:3758-1: An update that fixes two vulnerabilities is now available.

Category: security (important)
Bug References: 1192516
CVE References: CVE-2021-23214,CVE-2021-23222
JIRA References: 
Sources used:
openSUSE Leap 15.3 (src):    postgresql12-12.9-8.26.1
Comment 8 Swamp Workflow Management 2021-11-22 14:21:34 UTC 
openSUSE-SU-2021:3762-1: An update that fixes two vulnerabilities is now available.

Category: security (important)
Bug References: 1192516
CVE References: CVE-2021-23214,CVE-2021-23222
JIRA References: 
Sources used:
openSUSE Leap 15.3 (src):    postgresql13-13.5-5.22.1
Comment 9 Swamp Workflow Management 2021-11-22 14:23:01 UTC 
SUSE-SU-2021:3760-1: An update that fixes two vulnerabilities is now available.

Category: security (important)
Bug References: 1192516
CVE References: CVE-2021-23214,CVE-2021-23222
JIRA References: 
Sources used:
SUSE Linux Enterprise Software Development Kit 12-SP5 (src):    postgresql12-12.9-3.21.1
SUSE Linux Enterprise Server 12-SP5 (src):    postgresql12-12.9-3.21.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 10 Swamp Workflow Management 2021-11-22 14:24:37 UTC 
SUSE-SU-2021:3762-1: An update that fixes two vulnerabilities is now available.

Category: security (important)
Bug References: 1192516
CVE References: CVE-2021-23214,CVE-2021-23222
JIRA References: 
Sources used:
SUSE Linux Enterprise Module for Server Applications 15-SP3 (src):    postgresql13-13.5-5.22.1
SUSE Linux Enterprise Module for Server Applications 15-SP2 (src):    postgresql13-13.5-5.22.1
SUSE Linux Enterprise Module for Packagehub Subpackages 15-SP3 (src):    postgresql13-13.5-5.22.1
SUSE Linux Enterprise Module for Packagehub Subpackages 15-SP2 (src):    postgresql13-13.5-5.22.1
SUSE Linux Enterprise Module for Basesystem 15-SP3 (src):    postgresql13-13.5-5.22.1
SUSE Linux Enterprise Module for Basesystem 15-SP2 (src):    postgresql13-13.5-5.22.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 Swamp Workflow Management 2021-11-22 14:26:03 UTC 
SUSE-SU-2021:3757-1: An update that fixes two vulnerabilities is now available.

Category: security (important)
Bug References: 1192516
CVE References: CVE-2021-23214,CVE-2021-23222
JIRA References: 
Sources used:
SUSE OpenStack Cloud Crowbar 8 (src):    postgresql96-9.6.24-6.18.2
SUSE OpenStack Cloud 8 (src):    postgresql96-9.6.24-6.18.2
SUSE Linux Enterprise Server for SAP 12-SP3 (src):    postgresql96-9.6.24-6.18.2
SUSE Linux Enterprise Server 12-SP3-LTSS (src):    postgresql96-9.6.24-6.18.2
SUSE Linux Enterprise Server 12-SP3-BCL (src):    postgresql96-9.6.24-6.18.2
SUSE Linux Enterprise Server 12-SP2-BCL (src):    postgresql96-9.6.24-6.18.2
HPE Helion Openstack 8 (src):    postgresql96-9.6.24-6.18.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 12 Swamp Workflow Management 2021-11-22 14:27:42 UTC 
SUSE-SU-2021:3761-1: An update that fixes two vulnerabilities is now available.

Category: security (important)
Bug References: 1192516
CVE References: CVE-2021-23214,CVE-2021-23222
JIRA References: 
Sources used:
SUSE OpenStack Cloud Crowbar 9 (src):    postgresql10-10.19-4.22.1
SUSE OpenStack Cloud Crowbar 8 (src):    postgresql10-10.19-4.22.1
SUSE OpenStack Cloud 9 (src):    postgresql10-10.19-4.22.1
SUSE OpenStack Cloud 8 (src):    postgresql10-10.19-4.22.1
SUSE Linux Enterprise Software Development Kit 12-SP5 (src):    postgresql10-10.19-4.22.1
SUSE Linux Enterprise Server for SAP 12-SP4 (src):    postgresql10-10.19-4.22.1
SUSE Linux Enterprise Server for SAP 12-SP3 (src):    postgresql10-10.19-4.22.1
SUSE Linux Enterprise Server 12-SP5 (src):    postgresql10-10.19-4.22.1
SUSE Linux Enterprise Server 12-SP4-LTSS (src):    postgresql10-10.19-4.22.1
SUSE Linux Enterprise Server 12-SP3-LTSS (src):    postgresql10-10.19-4.22.1
SUSE Linux Enterprise Server 12-SP3-BCL (src):    postgresql10-10.19-4.22.1
SUSE Linux Enterprise Server 12-SP2-BCL (src):    postgresql10-10.19-4.22.1
HPE Helion Openstack 8 (src):    postgresql10-10.19-4.22.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 13 Swamp Workflow Management 2021-11-22 14:30:26 UTC 
openSUSE-SU-2021:3759-1: An update that fixes two vulnerabilities is now available.

Category: security (important)
Bug References: 1191782,1192516
CVE References: CVE-2021-23214,CVE-2021-23222
JIRA References: 
Sources used:
openSUSE Leap 15.3 (src):    postgresql14-14.1-5.6.1
Comment 14 Swamp Workflow Management 2021-11-22 14:31:59 UTC 
SUSE-SU-2021:3758-1: An update that fixes two vulnerabilities is now available.

Category: security (important)
Bug References: 1192516
CVE References: CVE-2021-23214,CVE-2021-23222
JIRA References: 
Sources used:
SUSE Linux Enterprise Module for Server Applications 15-SP2 (src):    postgresql12-12.9-8.26.1
SUSE Linux Enterprise Module for Packagehub Subpackages 15-SP3 (src):    postgresql12-12.9-8.26.1
SUSE Linux Enterprise Module for Packagehub Subpackages 15-SP2 (src):    postgresql12-12.9-8.26.1
SUSE Linux Enterprise Module for Legacy Software 15-SP3 (src):    postgresql12-12.9-8.26.1
SUSE Linux Enterprise Module for Basesystem 15-SP2 (src):    postgresql12-12.9-8.26.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 15 Swamp Workflow Management 2021-11-22 14:33:43 UTC 
SUSE-SU-2021:3759-1: An update that fixes two vulnerabilities is now available.

Category: security (important)
Bug References: 1191782,1192516
CVE References: CVE-2021-23214,CVE-2021-23222
JIRA References: 
Sources used:
SUSE Linux Enterprise Module for Server Applications 15-SP3 (src):    postgresql14-14.1-5.6.1
SUSE Linux Enterprise Module for Server Applications 15-SP2 (src):    postgresql14-14.1-5.6.1
SUSE Linux Enterprise Module for Packagehub Subpackages 15-SP3 (src):    postgresql14-14.1-5.6.1
SUSE Linux Enterprise Module for Packagehub Subpackages 15-SP2 (src):    postgresql14-14.1-5.6.1
SUSE Linux Enterprise Module for Basesystem 15-SP3 (src):    postgresql14-14.1-5.6.1
SUSE Linux Enterprise Module for Basesystem 15-SP2 (src):    postgresql14-14.1-5.6.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 16 Swamp Workflow Management 2021-12-14 14:19:11 UTC 
openSUSE-SU-2021:4058-1: An update that fixes two vulnerabilities is now available.

Category: security (important)
Bug References: 1192516
CVE References: CVE-2021-23214,CVE-2021-23222
JIRA References: 
Sources used:
openSUSE Leap 15.3 (src):    postgresql10-10.19-8.41.1
Comment 17 Swamp Workflow Management 2021-12-14 14:23:26 UTC 
SUSE-SU-2021:4058-1: An update that fixes two vulnerabilities is now available.

Category: security (important)
Bug References: 1192516
CVE References: CVE-2021-23214,CVE-2021-23222
JIRA References: 
Sources used:
SUSE Linux Enterprise Server for SAP 15-SP1 (src):    postgresql10-10.19-8.41.1
SUSE Linux Enterprise Server 15-SP1-LTSS (src):    postgresql10-10.19-8.41.1
SUSE Linux Enterprise Server 15-SP1-BCL (src):    postgresql10-10.19-8.41.1
SUSE Linux Enterprise Module for Server Applications 15-SP2 (src):    postgresql10-10.19-8.41.1
SUSE Linux Enterprise Module for Legacy Software 15-SP3 (src):    postgresql10-10.19-8.41.1
SUSE Linux Enterprise Module for Basesystem 15-SP2 (src):    postgresql10-10.19-8.41.1
SUSE Linux Enterprise High Performance Computing 15-SP1-LTSS (src):    postgresql10-10.19-8.41.1
SUSE Linux Enterprise High Performance Computing 15-SP1-ESPOS (src):    postgresql10-10.19-8.41.1
SUSE Enterprise Storage 6 (src):    postgresql10-10.19-8.41.1
SUSE CaaS Platform 4.0 (src):    postgresql10-10.19-8.41.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 18 Swamp Workflow Management 2021-12-15 02:17:13 UTC 
openSUSE-SU-2021:1584-1: An update that fixes two vulnerabilities is now available.

Category: security (important)
Bug References: 1192516
CVE References: CVE-2021-23214,CVE-2021-23222
JIRA References: 
Sources used:
openSUSE Leap 15.2 (src):    postgresql10-10.19-lp152.2.27.1
Comment 23 Swamp Workflow Management 2022-08-25 13:18:53 UTC 
SUSE-SU-2022:2893-1: An update that solves four vulnerabilities and has 6 fixes is now available.

Category: security (important)
Bug References: 1179945,1183168,1185952,1187751,1190177,1190740,1192516,1195680,1199475,1202368
CVE References: CVE-2021-23214,CVE-2021-23222,CVE-2022-1552,CVE-2022-2625
JIRA References: 
Sources used:
SUSE Linux Enterprise Server for SAP 15-SP1 (src):    postgresql-12.0.1-150000.8.19.1
SUSE Linux Enterprise Server for SAP 15 (src):    postgresql-12.0.1-150000.8.19.1, postgresql10-10.22-150000.4.42.1
SUSE Linux Enterprise Server 15-SP1-LTSS (src):    postgresql-12.0.1-150000.8.19.1
SUSE Linux Enterprise Server 15-SP1-BCL (src):    postgresql-12.0.1-150000.8.19.1
SUSE Linux Enterprise Server 15-LTSS (src):    postgresql-12.0.1-150000.8.19.1, postgresql10-10.22-150000.4.42.1
SUSE Linux Enterprise High Performance Computing 15-SP1-LTSS (src):    postgresql-12.0.1-150000.8.19.1
SUSE Linux Enterprise High Performance Computing 15-SP1-ESPOS (src):    postgresql-12.0.1-150000.8.19.1
SUSE Linux Enterprise High Performance Computing 15-LTSS (src):    postgresql-12.0.1-150000.8.19.1, postgresql10-10.22-150000.4.42.1
SUSE Linux Enterprise High Performance Computing 15-ESPOS (src):    postgresql-12.0.1-150000.8.19.1, postgresql10-10.22-150000.4.42.1
SUSE Enterprise Storage 6 (src):    postgresql-12.0.1-150000.8.19.1
SUSE CaaS Platform 4.0 (src):    postgresql-12.0.1-150000.8.19.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 24 Swamp Workflow Management 2022-08-31 16:18:49 UTC 
SUSE-SU-2022:2958-1: An update that solves 8 vulnerabilities and has 6 fixes is now available.

Category: security (important)
Bug References: 1179945,1183168,1185924,1185925,1185926,1185952,1187751,1189748,1190740,1192516,1195680,1198166,1199475,1202368
CVE References: CVE-2021-23214,CVE-2021-23222,CVE-2021-32027,CVE-2021-32028,CVE-2021-32029,CVE-2021-3677,CVE-2022-1552,CVE-2022-2625
JIRA References: 
Sources used:
SUSE Linux Enterprise Server for SAP 15-SP1 (src):    postgresql12-12.12-150100.3.33.1
SUSE Linux Enterprise Server 15-SP1-LTSS (src):    postgresql12-12.12-150100.3.33.1
SUSE Linux Enterprise Server 15-SP1-BCL (src):    postgresql12-12.12-150100.3.33.1
SUSE Linux Enterprise High Performance Computing 15-SP1-LTSS (src):    postgresql12-12.12-150100.3.33.1
SUSE Linux Enterprise High Performance Computing 15-SP1-ESPOS (src):    postgresql12-12.12-150100.3.33.1
SUSE Enterprise Storage 6 (src):    postgresql12-12.12-150100.3.33.1
SUSE CaaS Platform 4.0 (src):    postgresql12-12.12-150100.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 30 Thomas Leroy 2024-04-19 12:42:43 UTC 
All done, closing.