openSIS 7.4 SQL Injection

`-----------------------------------------------------  
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  
  
  
`