Deerwms Deer-WMS-2 SQL Injection Vulnerability in Role Export Functionality

A critical SQL injection vulnerability has been identified in DeerWMS Deer-WMS-2 versions up to 3.3. The issue arises in the role export functionality, specifically within the file '/system/role/export'. The vulnerability is caused by user-controllable parameters that are not properly sanitized, allowing attackers to manipulate the 'params[dataScope]' argument and inject malicious SQL. This exploitation can be performed remotely, potentially leading to unauthorized access to sensitive database information or complete control over the server.

Impact

Exploitation of this vulnerability allows for SQL injection, where an attacker can interfere with the application's database queries. This could lead to unauthorized data access, data manipulation, or in some cases, executing administrative operations on the database. Additionally, according to the vulnerability's VulDB entry, this SQL injection could result in gaining full control over the server.

Reproduction

To reproduce this vulnerability, send a POST request to the '/system/role/export' endpoint. Include the 'params[dataScope]' parameter with a crafted SQL payload, such as one that uses 'extractvalue' to retrieve database information. The absence of input sanitization and the lack of prepared statements in the SQL query execution facilitate this injection.