CVE-2018-20061 SQL injection in n/a

High 7.5 Published 11 Dec 2018 Updated 5 Aug 2024

A logged-in user can execute arbitrary SQL queries via crafted API requests, allowing unauthorized access to any database table columns.

Exploited in the wild: Not known
Login needed: Not needed
Attackable: Over the internet
Victim action needed: Not needed
Fix: None listed

What is CVE-2018-20061?

CVE-2018-20061 is a high-severity SQL injection vulnerability in Frappe Erpnext, published on 11 Dec 2018. An attacker can exploit it over the internet without logging in, with no action from the victim.

Official description

A SQL injection issue was discovered in ERPNext 10.x and 11.x through 11.0.3-beta.29. This attack is only available to a logged-in user; however, many ERPNext sites allow account creation via the web. No special privileges are needed to conduct the attack. By calling a JavaScript function that calls a server-side Python function with carefully chosen arguments, a SQL attack can be carried out which allows SQL queries to be constructed to return any columns from any tables in the database. This is related to /api/resource/Item?fields= URIs, frappe.get_list, and frappe.call.

Weakness: CWE-89

Which versions are affected by CVE-2018-20061?

It affects 1 product.

Products include Frappe Erpnext.

How do I fix CVE-2018-20061?

No fix has been published for CVE-2018-20061 yet. Limit exposure of the affected software until one is available.

Use parameterised queries everywhere and never build SQL by joining strings. Upgrade affected software first; a web application firewall only buys time. More about SQL injection.

Is CVE-2018-20061 being exploited?

There is no known exploitation of CVE-2018-20061 in the wild and no public exploit code.

All Frappe Erpnext vulnerabilities

Sources

Also known as GHSA-66f4-g2vx-q58x.