Headline
GHSA-x9vc-6hfv-hg8c: Npgsql vulnerable to SQL Injection via Protocol Message Size Overflow
Summary
The WriteBind()
method in src/Npgsql/Internal/NpgsqlConnector.FrontendMessages.cs
uses int
variables to store the message length and the sum of parameter lengths. Both variables overflow when the sum of parameter lengths becomes too large.
This causes Npgsql to write a message size that is too small when constructing a Postgres protocol message to send it over the network to the database. When parsing the message, the database will only read a small number of bytes and treat any following bytes as new messages while they belong to the old message.
Attackers can abuse this to inject arbitrary Postgres protocol messages into the connection, leading to the execution of arbitrary SQL statements on the application’s behalf.
Details
Please see this attached PDF file for a detailed description, including the suspected root cause, exploitation steps, impact, and recommendations on for fixing the issue.
PoC
See the steps in the “Exploitation” section of the attached PDF and this PoC project: npgsql-protocol-overflow-poc.zip
Impact
Attackers can issue arbitrary SQL statements to the database on behalf of the application. The final impact depends on the application that uses Npgsql, the data it stores in Postgres, etc.
Summary
The WriteBind() method in src/Npgsql/Internal/NpgsqlConnector.FrontendMessages.cs uses int variables to store the message length and the sum of parameter lengths. Both variables overflow when the sum of parameter lengths becomes too large.
This causes Npgsql to write a message size that is too small when constructing a Postgres protocol message to send it over the network to the database. When parsing the message, the database will only read a small number of bytes and treat any following bytes as new messages while they belong to the old message.
Attackers can abuse this to inject arbitrary Postgres protocol messages into the connection, leading to the execution of arbitrary SQL statements on the application’s behalf.
Details
Please see this attached PDF file for a detailed description, including the suspected root cause, exploitation steps, impact, and recommendations on for fixing the issue.
PoC
See the steps in the “Exploitation” section of the attached PDF and this PoC project: npgsql-protocol-overflow-poc.zip
Impact
Attackers can issue arbitrary SQL statements to the database on behalf of the application. The final impact depends on the application that uses Npgsql, the data it stores in Postgres, etc.
References
- GHSA-x9vc-6hfv-hg8c
- npgsql/npgsql@f7e7ead
- https://github.com/npgsql/npgsql/files/14309386/Npgsql.Security.Advisory.pdf
- https://github.com/npgsql/npgsql/files/14309397/npgsql-protocol-overflow-poc.zip
- https://github.com/npgsql/npgsql/releases/tag/v8.0.3