SugarCRM <= 12.2.0 Two SQL Injection Vulnerabilities

• Software Link:

https://www.sugarcrm.com

• Affected Versions:

Version 12.2.0 and prior versions.

Version 12.0.2 and prior versions.

Version 11.0.5 and prior versions.

• Vulnerabilities Description:

1. User input passed through the “metrics” parameter to the "/Forecasts/metrics" REST API endpoint is not properly sanitized before being used to construct a SQL query. This can be exploited by malicious users to e.g. read sensitive data from the database through in-band SQL Injection attacks.

2. User input passed through the “placeholder_fields” parameter to the e.g. "/Notes/{recordID}/link/history" REST API endpoint is not properly sanitized before being used to construct a SQL query. This can be exploited by malicious users to e.g. read sensitive data from the database through in-band SQL Injection attacks.

• Proof of Concept:

https://karmainsecurity.com/pocs/CVE-2023-35811_1.php

https://karmainsecurity.com/pocs/CVE-2023-35811_2.php

• Solution:

Upgrade to version 12.3.0, 12.0.3, 11.0.6, or later.

• Disclosure Timeline:

[14/02/2023] – Vendor notified

[12/04/2023] – Fixed versions released

[17/06/2023] – CVE number assigned

[23/08/2023] – Publication of this advisory

• CVE Reference:

The Common Vulnerabilities and Exposures project (cve.mitre.org) has assigned the name CVE-2023-35811 to these vulnerabilities.

• Credits:

Vulnerabilities discovered by Egidio Romano.

• Other References:

https://support.sugarcrm.com/Resources/Security/sugarcrm-sa-2023-008