Ketr JEPaaS SQL Injection Vulnerability in Postil Service LoadPostil Function

A SQL injection vulnerability has been identified in Ketr JEPaaS versions through 7.2.8. The issue arises in the postilService.loadPostils function, specifically within the /je/postil/postil/loadPostil file. The vulnerability is introduced by the keyWord parameter, which is susceptible to string manipulation, allowing for SQL injection attacks. This vulnerability can be exploited remotely, and a public exploit is available.

Impact

Exploitation of this vulnerability allows for SQL injection, where an attacker can manipulate SQL queries to the database. This could lead to unauthorized data access, data manipulation, or in some cases, executing administrative operations on the database.

Reproduction

The vulnerability can be reproduced by sending a POST request to the /je/postil/postil/loadPostil endpoint with a crafted keyWord parameter that exploits the SQL injection flaw. The request should include the necessary headers and cookies for authentication, such as the authorization header and session cookies. Once the request is sent, the injection can be verified by using payloads that, for example, cause a time delay response, indicating successful exploitation.

Remediation

It is recommended to avoid using string concatenation in SQL queries, as this practice can lead to SQL injection vulnerabilities. Instead, use prepared statements or parameterized queries that properly sanitize user input.