Lucene search

Talos IntelligenceTALOS-2020-1072

HistoryAug 31, 2020 - 12:00 a.m.

OS4Ed openSIS CheckDuplicateStudent.php page SQL injection vulnerability

2020-08-3100:00:00

Talos Intelligence

www.talosintelligence.com

6.5 Medium

CVSS2

Attack Vector

NETWORK

Attack Complexity

LOW

Authentication

SINGLE

Confidentiality Impact

PARTIAL

Integrity Impact

PARTIAL

Availability Impact

PARTIAL

AV:N/AC:L/Au:S/C:P/I:P/A:P

8.8 High

CVSS3

Attack Vector

NETWORK

Attack Complexity

LOW

Privileges Required

LOW

User Interaction

NONE

Scope

UNCHANGED

Confidentiality Impact

HIGH

Integrity Impact

HIGH

Availability Impact

HIGH

CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H

0.001 Low

EPSS

Percentile

39.3%

JSON

Talos Vulnerability Report

TALOS-2020-1072

OS4Ed openSIS CheckDuplicateStudent.php page SQL injection vulnerability

August 31, 2020

CVE Number

CVE-2020-6117,CVE-2020-6119,CVE-2020-6121,CVE-2020-6118,CVE-2020-6120,CVE-2020-6122

SUMMARY

Multiple exploitable SQL injection vulnerabilities exist in the CheckDuplicateStudent.php page of OS4Ed openSIS 7.3. A specially crafted HTTP request lead to SQL injection. An attacker can make an authenticated HTTP request to trigger these vulnerabilities.

CONFIRMED VULNERABLE VERSIONS

The versions below were either tested or verified to be vulnerable by Talos or confirmed to be vulnerable by the vendor.

OS4Ed openSIS 7.3

PRODUCT URLS

openSIS - <https://opensis.com/>

CVSSv3 SCORE

6.4 - CVSS:3.0/AV:N/AC:L/PR:L/UI:N/S:C/C:L/I:L/A:N

CWE

CWE-89 - Improper Neutralization of Special Elements used in an SQL Command (‘SQL Injection’)

DETAILS

openSIS is a student information system and school management system. It is available in commercial and open-source versions. It allows schools to create schedules and track attendance, grades and transcripts.

The following code in CheckDuplicateStudent is vulnerable to multiple SQL injection attacks at lines 64 and 66:

 31         $student_fname= $_REQUEST['fn'];
 32         $student_mname = $_REQUEST['mn'];
 33         $student_lname = $_REQUEST['ln'];
 34         $student_byear = $_REQUEST['byear'];
 35         $student_bmonth = $_REQUEST['bmonth'];
 36         $student_bday = $_REQUEST['bday'];
 37
 [...]
 62    $student_birthday =trim($student_byear).'-'.  trim($student_bmonth).'-'.  trim($student_bday);
 63 if(trim($student_mname)=='')
 64 $chechk_stu = 'SELECT s.student_id AS ID FROM students s,student_enrollment se WHERE s.student_id=se.student_id AND lcase(s.last_name)="'.strtolower($student_lname).'" AND lcase(s.first_name)="'.strtolower($student_fname).'" AND (lcase(s.middle_name)="" OR lcase(s.middle_name) IS NULL ) AND s.birthdate="'.$student_birthday.'"  AND se.syear="'.$_SESSION['UserSyear'].'" AND se.school_id="'.$_SESSION['UserSchool'].'    " ';
 65 else
 66 $chechk_stu = 'SELECT s.student_id AS ID FROM students s,student_enrollment se WHERE s.student_id=se.student_id AND lcase(s.last_name)="'.strtolower($student_lname).'" AND lcase(s.first_name)="'.strtolower($s    tudent_fname).'" AND lcase(s.middle_name)="'.strtolower($student_mname).'" AND s.birthdate="'.$student_birthday.'"  AND se.syear="'.$_SESSION['UserSyear'].'" AND se.school_id="'.$_SESSION['UserSchool'].'"  ';
 67 $chechk_stu_result = DBGet(DBQuery($chechk_stu));
 68 $prev_student = count($chechk_stu_result);
 69   echo $prev_student;

The following sections detail the specific parameters and how they can be exploited.