SQL Injection on Jorani

{
  "id": "1906e3bd96a3368f53f47332e7ca775ff814a71b7cc9e167b03f33fddb9e0601",
  "url": "https://osv.dev/vulnerability/CVE-2023-2681",
  "method": "structured",
  "payload": {
    "kind": "advisory",
    "title": "SQL Injection on Jorani",
    "summary": "An SQL Injection vulnerability has been found on Jorani version 1.0.0. This vulnerability allows an authenticated remote user, with low privileges, to send queries with malicious SQL code on the \"/leaves/validate\" path and the “id” parameter, managing to extract arbritary information from the database.",
    "evidence": "osv:CVE-2023-2681",
    "products": [],
    "severity": "high",
    "structured": {
      "id": "CVE-2023-2681",
      "aliases": [
        "CVE-2023-2681"
      ],
      "metrics": [
        {
          "type": "CVSS_V3",
          "score": "CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H"
        }
      ],
      "affected": [
        {
          "ranges": [
            {
              "repo": "https://github.com/jorani/jorani",
              "type": "GIT",
              "events": [
                {
                  "introduced": "b5f700954e41c158e41c6dd68063778e8b735e26"
                },
                {
                  "last_affected": "b5f700954e41c158e41c6dd68063778e8b735e26"
                }
              ],
              "database_specific": {
                "extracted_events": [
                  {
                    "cpe": "cpe:2.3:a:jorani:jorani:1.0.0:*:*:*:*:*:*:*",
                    "range": [
                      {
                        "introduced": "1.0.0"
                      },
                      {
                        "last_affected": "1.0.0"
                      }
                    ],
                    "source": "CPE_STRING"
                  }
                ]
              }
            }
          ],
          "versions": [
            "1.0.0",
            "v1.0.0"
          ],
          "database_specific": {
            "source": "https://storage.googleapis.com/cve-osv-conversion/osv-output/CVE-2023-2681.json"
          }
        }
      ],
      "modified": "2026-10-28T02:30:31.021642763Z",
      "provider": "osv",
      "references": [
        "https://www.incibe.es/en/incibe-cert/notices/aviso/jorani-sql-injection",
        "https://github.com/CVEProject/cvelistV5/tree/main/cves/2023/2xxx/CVE-2023-2681.json",
        "https://nvd.nist.gov/vuln/detail/CVE-2023-2681"
      ],
      "provider_metadata": {
        "cwe_ids": [
          "CWE-89"
        ],
        "cna_assigner": "INCIBE",
        "unresolved_ranges": [
          {
            "extracted_events": [
              {
                "range": [
                  {
                    "introduced": "1.0.0"
                  },
                  {
                    "last_affected": "1.0.0"
                  }
                ],
                "source": "AFFECTED_FIELD",
                "strategy": "StandaloneSingleVersion"
              }
            ]
          }
        ],
        "osv_generated_from": "https://github.com/CVEProject/cvelistV5/tree/main/cves/2023/2xxx/CVE-2023-2681.json"
      }
    },
    "related_cves": [
      {
        "value": "CVE-2023-2681",
        "evidence": "/id"
      }
    ],
    "security_relevant": true,
    "severity_evidence": "/severity/0/score"
  },
  "source_id": "core-osv",
  "document_id": 498213,
  "published_at": "2023-10-03T12:19:55.164+00:00"
}