Security
Headlines
HeadlinesLatestCVEs

Headline

CVE-2020-13381: openSIS 7.4 SQL Injection ≈ Packet Storm

openSIS through 7.4 allows SQL Injection.

CVE
#sql#vulnerability#git#php#perl#auth

openSIS <= 7.4 Multiple SQL Injection Vulnerabilities

[-] Software Link:

https://opensis.com/

[-] Affected Versions:

Version 7.4 and prior versions.

[-] Vulnerabilities Description:

The application is affected by multiple SQL Injection vulnerabilities,
following are some examples:

  1. User input passed through the “api_key” and “api_secret” parameters
    to '/api/SchoolInfo.php’,
    '/api/StaffInfo.php’, and ‘/api/StudentEnrollmentInfo.php’ is not
    properly sanitized before being
    used to construct a SQL query. This can be exploited by unauthenticated
    attackers to e.g. read
    sensitive data from the database through error-based SQL Injection
    attacks.

  2. User input passed through the “event_id” parameter to
    ‘/CalendarModal.php’ is not properly
    sanitized before being used to construct a SQL query. This can be
    exploited by remote attackers
    to e.g. read sensitive data from the database through in-band SQL
    Injection attacks.

  3. User input passed through the “course_id” parameter to
    ‘/modules/scheduling/MassSchedule.php’
    is not properly sanitized before being used to construct a SQL query.
    This can be exploited by
    remote attackers to e.g. read sensitive data from the database through
    SQL Injection attacks.

  4. User input passed through the “student” parameter to
    ‘/modules/attendance/AddAbsences.php’
    is not properly sanitized before being used to construct a SQL query.
    This can be exploited by
    remote attackers to e.g. read sensitive data from the database through
    SQL Injection attacks.

NOTE: certain SQL Injection vulnerabilities in openSIS - like (3) or (4)

  • could also be
    abused to execute arbitrary PHP code due to an unsafe use of the
    "eval()" PHP function
    within the "DBGet()" function defined in the ‘/functions/DbGetFnc.php’
    script.

[-] Solution:

Upgrade to version 7.4 to remediate vulnerabilities (1) and (2).
No official solution is currently available for the other
vulnerabilities.

[-] Disclosure Timeline:

[04/11/2019] - Vendor notified
[04/11/2019] - Vendor acknowledgement
[10/01/2020] - Vendor contacted again asking for updates
[15/01/2020] - Vendor replied they would need a few examples
[20/01/2020] - Told the vendor they could use the PoC I sent them in
November
[05/02/2020] - Vendor asked for a video recording to demonstrate the
vulnerabilities
[06/02/2020] - Proof of Concept video sent to the vendor
[06/02/2020] - Vendor informed about the correct fix for (1) and (2)
with commit https://git.io/JJf4L
[03/03/2020] - Vendor contacted again asking for updates about the other
vulnerabilities
[04/03/2020] - Vendor replied “we just have to wait a little longer”
[25/04/2020] - Version 7.4 released, vulnerabilities still not fixed
[22/05/2020] - CVE numbers assigned
[30/06/2020] - Public disclosure

[-] CVE Reference:

The Common Vulnerabilities and Exposures project (cve.mitre.org)
has assigned the name CVE-2020-13380 to vulnerabilities (1) and (2),
and name CVE-2020-13381 for the other vulnerabilities.

[-] Credits:

Vulnerabilities discovered by Egidio Romano.

[-] Original Advisory:

http://karmainsecurity.com/KIS-2020-08

CVE: Latest News

CVE-2023-50976: Transactions API Authorization by oleiman · Pull Request #14969 · redpanda-data/redpanda
CVE-2023-6905
CVE-2023-6903
CVE-2023-6904
CVE-2023-3907