Vulnerability identifier: #VU18094

Vulnerability risk: High

CVSSv3.1: 8.8 [CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H/E:P/RL:O/RC:C]

CVE-ID: N/A

CWE-ID: CWE-89

Exploitation vector: Network

Exploit availability: No

Vulnerable software:
Magento Open Source
Web applications / E-Commerce systems
Adobe Commerce (formerly Magento Commerce)
Web applications / E-Commerce systems

Vendor: Magento, Inc

Description

The vulnerability allows a remote attacker to execute arbitrary SQL queries in database.

The vulnerability exists due to insufficient sanitization of user-supplied data passed via "ids[0][product_id][to]" HTTP GET parameter to "/catalog/product_frontend_action/synchronize" URL. A remote non-authenticated attacker can send a specially crafted request to the affected application and execute arbitrary SQL commands within the application database.

Successful exploitation of this vulnerability may allow a remote attacker to read, delete, modify data in database and gain complete control over the affected application.

Exploitation example:

http://[host]/catalog/product_frontend_action/synchronize?
    type_id=recently_products&
    ids[0][added_at]=&
    ids[0][product_id][from]=?&
    ids[0][product_id][to]=))) OR (SELECT 1 UNION SELECT 2 FROM DUAL WHERE 1=1) -- -	

Mitigation
Install updates from vendor's website.

Vulnerable software versions

Magento Open Source: 2.3.0, 2.2.0 - 2.2.7, 2.1.0 - 2.1.16, 1.9.0.0 - 1.9.4.0

Adobe Commerce (formerly Magento Commerce): 1.14.0.0 - 1.14.4.0

---

External links
http://magento.com/security/patches/magento-2.3.1-2.2.8-and-2.1.17-security-update
http://www.ambionics.io/blog/magento-sqli

---

Q & A

Can this vulnerability be exploited remotely?

Yes. This vulnerability can be exploited by a remote non-authenticated attacker via the Internet.

Is there known malware, which exploits this vulnerability?

No. We are not aware of malware exploiting this vulnerability. However, proof of concept for this vulnerability is available.