Vulnerability-Lookup

CNVD-2019-17163

Vulnerability from cnvd - Published: 2019-06-13

Title

Frappe ERPNext SQL注入漏洞（CNVD-2019-17163）

Description

Frappe ERPNext是一套开源的ERP（企业资源计划）系统。该系统包括财务管理、库存管理、客户关系管理、项目管理和人力资源管理等功能。 Frappe ERPNext 10.x版本和11.x版本至11.0.3-beta.29版本中存在SQL注入漏洞，远程攻击者可利用该漏洞获取数据库中的任意表单的任意列。

Severity

中

Formal description

厂商尚未提供漏洞修复方案，请关注厂商主页更新： http://erpnext.com/

Reference

https://github.com/frappe/erpnext/issues/15337

Impacted products

Name
['Frappe ERPNext 10.', 'Frappe ERPNext 11.，<=11.0.3-beta.29']

Show details on source website

JSON

To clipboard

{
  "cves": {
    "cve": {
      "cveNumber": "CVE-2018-20061",
      "cveUrl": "http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2018-20061"
    }
  },
  "description": "Frappe ERPNext\u662f\u4e00\u5957\u5f00\u6e90\u7684ERP\uff08\u4f01\u4e1a\u8d44\u6e90\u8ba1\u5212\uff09\u7cfb\u7edf\u3002\u8be5\u7cfb\u7edf\u5305\u62ec\u8d22\u52a1\u7ba1\u7406\u3001\u5e93\u5b58\u7ba1\u7406\u3001\u5ba2\u6237\u5173\u7cfb\u7ba1\u7406\u3001\u9879\u76ee\u7ba1\u7406\u548c\u4eba\u529b\u8d44\u6e90\u7ba1\u7406\u7b49\u529f\u80fd\u3002\n\nFrappe ERPNext 10.x\u7248\u672c\u548c11.x\u7248\u672c\u81f311.0.3-beta.29\u7248\u672c\u4e2d\u5b58\u5728SQL\u6ce8\u5165\u6f0f\u6d1e\uff0c\u8fdc\u7a0b\u653b\u51fb\u8005\u53ef\u5229\u7528\u8be5\u6f0f\u6d1e\u83b7\u53d6\u6570\u636e\u5e93\u4e2d\u7684\u4efb\u610f\u8868\u5355\u7684\u4efb\u610f\u5217\u3002",
  "discovererName": "unknown",
  "formalWay": "\u5382\u5546\u5c1a\u672a\u63d0\u4f9b\u6f0f\u6d1e\u4fee\u590d\u65b9\u6848\uff0c\u8bf7\u5173\u6ce8\u5382\u5546\u4e3b\u9875\u66f4\u65b0\uff1a\r\nhttp://erpnext.com/",
  "isEvent": "\u901a\u7528\u8f6f\u786c\u4ef6\u6f0f\u6d1e",
  "number": "CNVD-2019-17163",
  "openTime": "2019-06-13",
  "products": {
    "product": [
      "Frappe ERPNext 10.*",
      "Frappe ERPNext 11.*\uff0c\u003c=11.0.3-beta.29"
    ]
  },
  "referenceLink": "https://github.com/frappe/erpnext/issues/15337",
  "serverity": "\u4e2d",
  "submitTime": "2018-12-14",
  "title": "Frappe ERPNext SQL\u6ce8\u5165\u6f0f\u6d1e\uff08CNVD-2019-17163\uff09"
}

CVE-2018-20061 (GCVE-0-2018-20061)

Vulnerability from cvelistv5 – Published: 2018-12-11 17:00 – Updated: 2024-08-05 11:51

Summary

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.

Severity

No CVSS data available.

CWE

Assigner

mitre mitre root Scorecard

References

1 reference

URL	Tags
https://github.com/frappe/erpnext/issues/15337	x_refsource_MISC

Date Public

2018-12-11 00:00

Show details on NVD website

JSON

To clipboard

{
  "containers": {
    "adp": [
      {
        "providerMetadata": {
          "dateUpdated": "2024-08-05T11:51:18.930Z",
          "orgId": "af854a3a-2127-422b-91ae-364da2661108",
          "shortName": "CVE"
        },
        "references": [
          {
            "tags": [
              "x_refsource_MISC",
              "x_transferred"
            ],
            "url": "https://github.com/frappe/erpnext/issues/15337"
          }
        ],
        "title": "CVE Program Container"
      }
    ],
    "cna": {
      "affected": [
        {
          "product": "n/a",
          "vendor": "n/a",
          "versions": [
            {
              "status": "affected",
              "version": "n/a"
            }
          ]
        }
      ],
      "datePublic": "2018-12-11T00:00:00.000Z",
      "descriptions": [
        {
          "lang": "en",
          "value": "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."
        }
      ],
      "problemTypes": [
        {
          "descriptions": [
            {
              "description": "n/a",
              "lang": "en",
              "type": "text"
            }
          ]
        }
      ],
      "providerMetadata": {
        "dateUpdated": "2018-12-11T17:57:02.000Z",
        "orgId": "8254265b-2729-46b6-b9e3-3dfca2d5bfca",
        "shortName": "mitre"
      },
      "references": [
        {
          "tags": [
            "x_refsource_MISC"
          ],
          "url": "https://github.com/frappe/erpnext/issues/15337"
        }
      ],
      "x_legacyV4Record": {
        "CVE_data_meta": {
          "ASSIGNER": "cve@mitre.org",
          "ID": "CVE-2018-20061",
          "STATE": "PUBLIC"
        },
        "affects": {
          "vendor": {
            "vendor_data": [
              {
                "product": {
                  "product_data": [
                    {
                      "product_name": "n/a",
                      "version": {
                        "version_data": [
                          {
                            "version_value": "n/a"
                          }
                        ]
                      }
                    }
                  ]
                },
                "vendor_name": "n/a"
              }
            ]
          }
        },
        "data_format": "MITRE",
        "data_type": "CVE",
        "data_version": "4.0",
        "description": {
          "description_data": [
            {
              "lang": "eng",
              "value": "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."
            }
          ]
        },
        "problemtype": {
          "problemtype_data": [
            {
              "description": [
                {
                  "lang": "eng",
                  "value": "n/a"
                }
              ]
            }
          ]
        },
        "references": {
          "reference_data": [
            {
              "name": "https://github.com/frappe/erpnext/issues/15337",
              "refsource": "MISC",
              "url": "https://github.com/frappe/erpnext/issues/15337"
            }
          ]
        }
      }
    }
  },
  "cveMetadata": {
    "assignerOrgId": "8254265b-2729-46b6-b9e3-3dfca2d5bfca",
    "assignerShortName": "mitre",
    "cveId": "CVE-2018-20061",
    "datePublished": "2018-12-11T17:00:00.000Z",
    "dateReserved": "2018-12-11T00:00:00.000Z",
    "dateUpdated": "2024-08-05T11:51:18.930Z",
    "state": "PUBLISHED"
  },
  "dataType": "CVE_RECORD",
  "dataVersion": "5.1"
}

Sightings

Author	Source	Type	Date	Other

Nomenclature

Seen: The vulnerability was mentioned, discussed, or observed by the user.
Confirmed: The vulnerability has been validated from an analyst's perspective.
Published Proof of Concept: A public proof of concept is available for this vulnerability.
Exploited: The vulnerability was observed as exploited by the user who reported the sighting.
Patched: The vulnerability was observed as successfully patched by the user who reported the sighting.
Not exploited: The vulnerability was not observed as exploited by the user who reported the sighting.
Not confirmed: The user expressed doubt about the validity of the vulnerability.
Not patched: The vulnerability was not observed as successfully patched by the user who reported the sighting.

The MITRE ATT&CK techniques below are AI-generated suggestions, inferred from the description of the vulnerability by the CIRCL/vulnerability-attack-technique-classification-roberta-base model, served locally by ML-Gateway. They have not been verified by an analyst and are provided for guidance only.
The approach is described in our paper Mapping CVEs to MITRE ATT&CK Techniques: A Curated Gold-Set Classifier and the Limits of LLM-Assisted Label Expansion.
Browse all ATT&CK techniques and the vulnerabilities related to each.

Related by attack behaviour

Vulnerabilities whose description is nearest to this one in the vector space of the CIRCL/vulnerability-attack-technique-biencoder model. This is a similarity search over the bi-encoder space (plain cosine), not a classification, and it has no measured accuracy.

Action not permitted

CNVD-2019-17163

CVE-2018-20061 (GCVE-0-2018-20061)

Tags

Sightings

Nomenclature

Related by attack behaviour