CVE-2024-0784: 
NixOS vulnerability analysis and mitigation

A critical SQL injection vulnerability (CVE-2024-0784) was discovered in hongmaple octopus version 1.0, specifically affecting the /system/role/list interface. The vulnerability was disclosed on January 22, 2024, and involves the manipulation of the dataScope parameter. This vulnerability has been classified as critical with a CVSS v3.1 base score of 9.8 (NVD).

The vulnerability exists in the /system/role/list interface where improper neutralization of special elements in SQL commands occurs (CWE-89). The vulnerability specifically involves the use of the $ placeholder symbol in the dataScope parameter, allowing for SQL injection attacks. The CVSS v3.1 vector string is CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H, indicating network accessibility, low attack complexity, and no required privileges or user interaction (NVD).

The vulnerability allows remote attackers to execute arbitrary SQL commands through the dataScope parameter. This can lead to unauthorized access to the database, potential data theft, and manipulation of the underlying database system (Github POC).

The vulnerability is actively exploitable and a proof of concept has been publicly disclosed. The exploit can be triggered through the role management interface by manipulating the dataScope parameter in POST requests to /system/role/list. The attack can be executed remotely without requiring significant privileges (Github POC).