phpCollab CMS 2.5 SQL Injection

`Document Title:  
===============  
phpCollab v2.5 CMS - SQL Injection Vulnerability  
  
  
References (Source):  
====================  
http://www.vulnerability-lab.com/get_content.php?id=1898  
  
  
Release Date:  
=============  
2016-08-08  
  
  
Vulnerability Laboratory ID (VL-ID):  
====================================  
1898  
  
  
Common Vulnerability Scoring System:  
====================================  
6.6  
  
  
Product & Service Introduction:  
===============================  
phpCollab is an open source internet-enabled system for use in projects that require collaboration over the internet. Those organizations,   
such as consulting firms, that rely on a division between firm-side and client-side information will benefit most from use of phpCollab.  
  
  
Abstract Advisory Information:  
==============================  
The vulnerability laboratory research team discovered a remote sql-injection web vulnerability in the official phpCollab v2.5 content management system.  
  
  
Vulnerability Disclosure Timeline:  
==================================  
2016-08-08: Public Disclosure (Vulnerability Laboratory)  
  
  
Discovery Status:  
=================  
Published  
  
  
Affected Product(s):  
====================  
phpCollab Community  
Product: phpCollab - Content Management System 2.5  
  
  
Exploitation Technique:  
=======================  
Remote  
  
  
Severity Level:  
===============  
High  
  
  
Technical Details & Description:  
================================  
A remote sql-injection web vulnerability has been discovered in the official phpCollab v2.5 content management system.  
The vulnerability allows remote attackers to execute own malicious sql commands to compromise the application or dbms.  
  
The sql-injection vulnerability is located in the `id` parameter of the `./phpcollab/users/` module GET method request.   
Remote attackers are able to execute own sql commands by usage of the insecure `emailusers.php` file GET method request.   
The attack vector of the vulnerability is application-side and the request method to inject is GET The vulnerability   
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.6.  
Exploitation of the remote sql injection web 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):  
[+] GET  
  
Vulnerable Module(s):  
[+] ./phpcollab/users/  
  
Vulnerable File(s):  
[+] emailusers.php  
  
Vulnerable Parameter(s):  
[+] id  
  
  
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: Exploitation  
http://phpcollab.localhost:8080/phpcollab/users/emailusers.php?id=1'[SQL-INJECTION VULNERABILITY!]&&PHPSESSID=ghtu76jt276nji04lua07930t5  
  
  
--- Error Exception Logs [SQL] ---  
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1  
-  
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2  
-  
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3  
  
  
--- PoC Session Logs [GET] ---  
Status: 200[OK]  
GET http://phpcollab.localhost:8080/phpcollab/users/emailusers.php?id=1%27&&PHPSESSID=ghtu76jt276nji04lua07930t5   
Mime Type[text/html]  
Request Header:  
Host[phpcollab.localhost:8080]  
User-Agent[Mozilla/5.0 (Windows NT 10.0; WOW64; rv:47.0) Gecko/20100101 Firefox/47.0]  
Cookie[PHPSESSID=ghtu76jt276nji04lua07930t5; _pk_id.2.bb5e=7b20cb9175a196a9.1470585617.1.1470586689.1470585617.;   
_pk_ref.2.bb5e=%5B%22%22%2C%22%22%2C1470585617%2C%22http%3A%2F%2Fphpcollab.localhost:8080%2Fdemo%2F1%2F394%2FStash%22%5D; _pk_ses.2.bb5e=*]  
Connection[keep-alive]  
Cache-Control[max-age=0]  
Response Header:  
Server[nginx/1.2.1]  
Content-Type[text/html]  
Transfer-Encoding[chunked]  
Connection[keep-alive]  
X-Powered-By[PHP/5.5.27-1+deb.sury.org~precise+1]  
  
  
Reference(s):  
http://phpcollab.localhost:8080/  
http://phpcollab.localhost:8080/phpcollab/  
http://phpcollab.localhost:8080/phpcollab/users/  
http://phpcollab.localhost:8080/phpcollab/users/emailusers.php  
  
  
Solution - Fix & Patch:  
=======================  
The vulnerability can be patched by usage of a prepared statement in the emailusers.php file GET method request.  
Disallow special chars and escape the input and outpit context entries to prevent further sql-injection attacks.  
  
  
Security Risk:  
==============  
The security risk of the remote sql-injection web vulnerability in the id parameter of the emailusers.php file is estimated as high. (CVSS 6.6)  
  
  
Credits & Authors:  
==================  
Vulnerability Laboratory [Research Team] - Benjamin Kunz Mejri (http://www.vulnerability-lab.com/show.php?user=Benjamin%20K.M.)  
  
  
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 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  
Contact: [email protected] - [email protected] - [email protected]  
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 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@ or [email protected]) to get a ask permission.  
  
Copyright A(c) 2016 | Vulnerability Laboratory - [Evolution Security GmbH]aC/  
  
--   
VULNERABILITY LABORATORY - RESEARCH TEAM  
SERVICE: www.vulnerability-lab.com  
  
`