[KIS-2018-03] SugarCRM (portal_get_related_notes) SQL Injection Vulnerability

[Egidio Romano <research@xxxxxxxxxxxxxxxxxxx>]

---------------------------------------------------------------
SugarCRM (portal_get_related_notes) SQL Injection Vulnerability
---------------------------------------------------------------


[-] Software Link:

http://www.sugarcrm.com


[-] Affected Versions:

All versions prior to 7.9.4.0 and 7.11.0.0.


[-] Vulnerability Description:

The vulnerability is located within the SOAP API, specifically into the
"portal_get_related_notes()" SOAP function. User input passed through the
"order_by" parameter isn’t properly sanitized before being used to construct
an "ORDER BY" clause of a SQL query from within the "get_notes_in_contacts()"
or "get_notes_in_module()" functions. This can be exploited by Portal API Users
to e.g. read sensitive data from the database through time-based SQL injection 
attacks.


[-] Solution:

Update to versions 7.9.4.0, 7.11.0.0, or later.


[-] Disclosure Timeline:

[13/10/2017] - Vendor notified
[28/03/2018] - Fixed versions released and security advisory published
[31/12/2018] - Publication of this advisory


[-] CVE Reference:

The Common Vulnerabilities and Exposures project (cve.mitre.org)
has not assigned a CVE identifier for this vulnerability.


[-] Credits:

Vulnerability discovered by Egidio Romano.


[-] Original Advisory:

http://karmainsecurity.com/KIS-2018-03


[-] Other References:

https://support.sugarcrm.com/Resources/Security/sugarcrm-sa-2018-003/