CVE-2021-44427: Rosario Student Information System Unauthenticated SQL Injection

id: CVE-2021-44427

info:
  name: Rosario Student Information System Unauthenticated SQL Injection
  author: furkansayim,xShuden
  severity: critical
  description: An unauthenticated SQL injection vulnerability in Rosario Student Information System (aka rosariosis) 8.1 and below allow remote attackers to execute PostgreSQL statements (e.g., SELECT, INSERT, UPDATE, and DELETE) through /Side.php via the syear parameter.
  impact: |
    Successful exploitation of this vulnerability could allow an attacker to extract sensitive information from the database, modify data, or execute arbitrary SQL commands.
  remediation: Upgrade to version 8.1.1 or higher.
  reference:
    - https://gitlab.com/francoisjacquet/rosariosis/-/issues/328
    - https://twitter.com/RemotelyAlerts/status/1465697928178122775
    - https://nvd.nist.gov/vuln/detail/CVE-2021-44427
    - https://github.com/ARPSyndicate/cvemon
    - https://github.com/ARPSyndicate/kenzer-templates
  classification:
    cvss-metrics: CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H
    cvss-score: 9.8
    cve-id: CVE-2021-44427
    cwe-id: CWE-89
    epss-score: 0.85981
    epss-percentile: 0.9935
    cpe: cpe:2.3:a:rosariosis:rosariosis:*:*:*:*:*:*:*:*
  metadata:
    max-request: 1
    vendor: rosariosis
    product: rosariosis
  tags: cve,cve2021,sqli,rosariosis

http:
  - method: POST
    path:
      - "{{BaseURL}}/Side.php"

    body: "sidefunc=update&syear=111'"

    headers:
      Content-Type: application/x-www-form-urlencoded; charset=utf-8

    matchers-condition: and
    matchers:
      - type: word
        part: body
        words:
          - "DB Execute Failed. ERROR:"
          - "unterminated quoted string"
        condition: and

      - type: word
        part: header
        words:
          - "RosarioSIS="

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