CVE-2023-52290: Apache StreamPark (incubating): Unchecked SQL query fields trigger SQL injection vulnerability

[Huajie Wang <benjobs () apache org>]

Severity: low

Affected versions:

- Apache StreamPark (incubating) 2.0.0 before 2.1.4

Description:

In streampark-console the list pages(e.g: application pages), users can sort page by field. This sort field is sent 
from the front-end to the back-end, and the SQL query is generated using this field. However, because this sort field 
isn't validated, there is a risk of SQL injection vulnerability. The attacker must successfully log into the system to 
launch an attack, which may cause data leakage. Since no data will be written, so this is a low-impact vulnerability.

Mitigation:

all users should upgrade to 2.1.4,  Such parameters will be blocked.

Credit:

thiscodecc of MoyunSec Vlab and Bing (reporter)

References:

https://streampark.incubator.apache.org
https://www.cve.org/CVERecord?id=CVE-2023-52290