Quantum Secular Labs / Blog / Advisories

CVE-2016-8640: Pycsw: SQL injection

CVE-2016-8640 is rated critical with a CVSS v3.0 base score of 9.1 and affects Pycsw. Per its scoring, it can be exploited over the network, without authentication, without any user interaction.

Vulnerability description

A SQL injection vulnerability in pycsw all versions before 2.0.2, 1.10.5 and 1.8.6 that leads to read and extract of any data from any table in the pycsw database that the database user has access to. Also on PostgreSQL (at least) it is possible to perform updates/inserts/deletes and database modifications to any table the database user has access to.

Severity breakdown

CVSS v3.0 9.1: CVSS:3.0/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:N

Attack vector: Network. Exploitable remotely over the network, with no need for local or physical access.
Attack complexity: Low. No special conditions; the attack can be repeated reliably.
Privileges required: None. No account or prior access is needed.
User interaction: None. No action from any user is needed.
Scope: Unchanged. Impact stays within the vulnerable component.
Confidentiality impact: High. Total loss of confidentiality; sensitive data can be fully disclosed.
Integrity impact: High. Total loss of integrity; data or system state can be fully modified.
Availability impact: None. No effect on availability.

Underlying weakness

CWE-89: Improper Neutralization of Special Elements used in an SQL Command

The product constructs all or part of an SQL command using externally-influenced input from an upstream component, but it does not neutralize or incorrectly neutralizes special elements that could modify the intended SQL command when it is sent to a downstream component. Without sufficient removal or quoting of SQL syntax in user-controllable inputs, the generated SQL query can cause those inputs to be interpreted as SQL instead of ordinary user data.

Affected products

Pycsw: before 1.8.6; from 1.10.0 before 1.10.5; from 2.0.0 before 2.0.2