Schoolhos CMS v2.29 – userberita SQL injection Vulnerability

fulldisclosure logo
Full Disclosure
mailing list archives

Schoolhos CMS v2.29 – userberita SQL injection Vulnerability

From: Vulnerability Lab <research () vulnerability-lab com>

Date: Mon, 28 Nov 2016 12:11:29 +0100

Document Title:
Schoolhos CMS v2.29 - userberita SQL injection Vulnerability 

References (Source):

Release Date:

Vulnerability Laboratory ID (VL-ID):

Common Vulnerability Scoring System:

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:  & )

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-22: Public Disclosure (Vulnerability Laboratory)

Discovery Status:

Affected Product(s):
Product: Schoolhos - Content Management System (Web-Application) 2016 Q3

Exploitation Technique:

Severity Level:

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 

The sql injection vulnerability is located in the `user` parameter of the `index?p=userberita` module GET method 
Remote attackers are able to execute own sql commands by usage of an insecure GET 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 GET. 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 
Exploitation of the remote sql injection vulnerability requires no user interaction or privileged web-application user 
Successful exploitation of the remote sql injection results in database management system, web-server and 
web-application compromise.

Request Method(s):
[+] GET 

Vulnerable Module(s):
[+] userberita 

Vulnerable Parameter(s):
[+] user 

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: Payload

PoC: Exploitation
<title>Schoolhos (userberita) - Remote SQL Injection Vulnerability</title>
<iframe src="http://schoolhos.localhost:8080/versi_2.29/?p=userberita&user=999999.9%27+union+all+select+
 width="700" height="700">


Solution - Fix & Patch:
The sql-injection web vulnerability can be patched by usage of a secure prepared statement to perform the queries.
Parse the parameter input and filter the context. Disallow the usage of special chars to prevent further sql-injection 

Security Risk:
The security risk of the sql-injection vulnerability in the schoolhos web-application is estimated as high. (CVSS 6.8)

Credits & Authors:
Vulnerability Laboratory [Research Team] - 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:           -                                              -
Section:      -                             -
Social:                -                                 -
Feeds:   -                    -
Programs:    -         -

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]™


Sent through the Full Disclosure mailing list
Web Archives & RSS:

  By Date  
  By Thread  

Current thread:

  • Schoolhos CMS v2.29 – userberita SQL injection Vulnerability Vulnerability Lab (Nov 28)

Source: Full Disclosure @ November 28, 2016 at 04:21AM