A recent Common Vulnerabilities and Exposures (CVE) listing, identified as CVE-2022-24124, has drawn attention to a critical SQL injection vulnerability in the Casdoor open-source authentication system. The vulnerability can be found in the Casdoor query API, specifically in versions of Casdoor before 1.13.1. In this blog post, we will discuss the vulnerability, the risks it poses, and how to mitigate them effectively.

Overview of Casdoor

Casdoor is an authorization management system that helps developers implement authentication and authorization functionalities in their applications. Casdoor is built upon the popular Casbin open-source project. For more information about Casdoor and detailed documentation, refer to the official GitHub repository: https://github.com/casdoor/casdoor

Vulnerability Details

The SQL injection vulnerability, in versions before 1.13.1, is related to the field and value parameters used in API calls. This vulnerability can be exploited by an attacker to gain unauthorized access to sensitive data, or potentially perform other malicious actions. As a proof of concept, the following API endpoint is known to be affected:

- api/get-organizations

An attacker might execute the SQL injection vulnerability using a crafted API call as follows

/api/get-organizations?field=name&value=' UNION SELECT * FROM users WHERE 'a'='a

In this example, the attacker attempts to inject the following SQL code

' UNION SELECT * FROM users WHERE 'a'='a

As a result, the injected code essentially unions the organization data with the user data, allowing the attacker to retrieve unauthorized information.

Mitigation Steps

The Casdoor development team has patched the vulnerability in version 1.13.1. Users should update to the latest Casdoor version to avoid this vulnerability. Follow these steps to update your Casdoor instance:

1. Visit the Casdoor GitHub repository at https://github.com/casdoor/casdoor

Restart the Casdoor service for the changes to take effect

It is also recommended for developers to implement proper input validation and adhere to best practices for preventing SQL injection in their applications. A defense-in-depth approach should be taken by using prepared statements, stored procedures, or object-relational mapping libraries, and practicing the principle of least privilege.


SQL injection vulnerabilities can pose a significant risk to any application, and CVE-2022-24124 presents a similar threat to Casdoor users. However, by updating Casdoor to the latest version and practicing best coding practices, developers can significantly reduce the risk of being exploited by this vulnerability. Stay informed and stay safe.


Published on: 01/29/2022 23:15:00 UTC
Last modified on: 04/05/2022 20:21:00 UTC