Impact

Any user of PostgresNIO connecting to servers with TLS enabled is vulnerable to a man-in-the-middle attacker injecting false responses to the client's first few queries, despite the use of TLS certificate verification and encryption.

The remaining text in this section is quoted verbatim from PostgreSQL's CVE-2021-23222 advisory:

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-23214. As with any exploitation of CVE-2021-23214, 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-23214. The attacker must have some other way to access the server to retrieve the exfiltrated data (a valid, unprivileged login account would be sufficient).

Patches

The vulnerability is addressed in PostgresNIO versions starting from 1.14.2 via 2df54bc94607f44584ae6ffa74e3cd754fffafc7, which required additional support from SwiftNIO.

Workarounds

There are no known workarounds for unpatched users.

Additional Credits

Special thanks to PostgreSQL's Tom Lane <tgl@sss.pgh.pa.us> for reporting this issue!

References

• PostgreSQL security advisory for CVE-2021-23222
• GitHub security advisory GHSA-735f-7qx4-jqq5 for CVE-2021-23222
• PostgreSQL security advisory for CVE-2021-23214
• GitHub security advisory GHSA-467w-rrqc-395f for CVE-2021-23214
• SwiftNIO PR #2419 Add unprocessedBytes property on NIOSingleStepByteToMessageProcessor
• PostgresNIO commit 2df54bc94607f44584ae6ffa74e3cd754fffafc7
• PostgresNIO 1.42.2 release

References

• GHSA-9cfh-vx93-84vv
• https://nvd.nist.gov/vuln/detail/CVE-2023-31136
• apple/swift-nio#2419
• vapor/postgres-nio@2df54bc
• GHSA-467w-rrqc-395f
• GHSA-735f-7qx4-jqq5
• https://github.com/vapor/postgres-nio/releases/tag/1.14.2
• https://www.postgresql.org/support/security/CVE-2021-23214/
• https://www.postgresql.org/support/security/CVE-2021-23222/