RuoYi SQL Injection Vulnerability in Monitor Online List Endpoint

A SQL injection vulnerability has been identified in RuoYi version 4.8.0. The issue arises in the monitor online list endpoint, specifically through the orderby parameter. This vulnerability allows attackers to manipulate SQL queries, potentially leading to unauthorized data access or modification.

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.

Reproduction

To reproduce this vulnerability, send a request to the '/monitor/online/list' endpoint with a crafted 'orderby' parameter that includes SQL injection payloads. The application will respond with an error message that reveals sensitive user information, such as local user directory details.