SugarCRM (portal_get_related_notes) SQL Injection Vulnerability
• Software Link:
• 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.
• Other References:
https://support.sugarcrm.com/Resources/Security/sugarcrm-sa-2018-003/