ManageEngine EventLog Analyzer 10.0 Information Disclosure

`# Exploit Title: ManageEngine EventLog Analyzer 10.0 - Information Disclosure  
# Date: 2020-02-23  
# Author:Scott Goodwin  
# Vendor: https://www.manageengine.com/  
# Software Link: https://www.manageengine.com/products/eventlog/  
# CVE: CVE-2019-19774  
  
Vulnerability Name: Authenticated Information Disclosure in ManageEngine EventLog Analyzer  
Registered: CVE-2019-19774  
  
Discoverer:  
Scott Goodwin, OSCP  
OCD Tech  
  
Vendor of Product:  
ManageEngine  
  
Affected Product Code Base:  
EventLog Analyzer - 10.0 SP1  
  
Affected Component:  
Affected ManageEngine endpoint: http://exampleclient:8400/event/runquery.do  
This endpoint allows the ManageEngine user to execute commands against the  
ManageEngine PostgreSQL database.  
  
Attack Type:  
Remote  
  
Vulnerability Type:  
Incorrect Access Control  
  
Vulnerability Impact:  
Authenticated Information Disclosure  
  
Attack Vector:  
To exploit the vulnerability, an authenticated user must execute a specially crafted  
query against the ManageEngine database to bypass the built-in security controls and  
extract credential data.  
  
Vulnerability Description:  
An issue was discovered in Zoho ManageEngine EventLog Analyzer 10.0 SP1.  
By running "select hostdetails from hostdetails" at the /event/runquery.do endpoint,  
it is possible to bypass the security restrictions that prevent even administrative  
users from viewing credential data stored in the database, and recover the MD5 hashes  
of the accounts used to authenticate the ManageEngine platform to the managed machines  
on the network (most often administrative accounts). Specifically, this bypasses the  
following restrictions: a query cannot mention "password", and a query result cannot  
have a "password" column.  
  
PoC: Run the database query: "select hostdetails from hostdetails" at the /event/runquery.do endpoint  
  
Reporting Timeline:  
10/30/2019: This vulnerability was reported to ManageEngine via the  
Zoho/ManageEngine Bug Bounty program. They acknowledged the initial report.  
12/12/2019: Vulnerability registered  
12/13/2019: Vulnerability acknowledged and update (12110) made available to ManageEngine  
customers.  
12/13/2019: Public disclosure  
  
Additional Information:  
This query bypasses the following security restrictions implemented within Manage Engine:  
1. restrictions on queries that include the word "password". This query will output the  
value stored in the "password" field, without the word "password" actually appearing in  
the query. If the query contains the word "password" Manage Engine will not execute the query.  
2. restrictions on printing the password field to the screen in a column called "password".  
If the results of the query include a columncalled "password", Manage Engine will mask the  
password with a series of asterisks "". This query will output the entire contents of the table,  
without formatting is as a table within the web interface, which leads to bypass of this security  
control.  
  
Remediated Product Version:  
ManageEngine EventLog Analyzer Build 12110  
  
Reference:  
https://www.manageengine.com/products/eventlog/  
https://www.manageengine.com/products/eventlog/features-new.html#release  
https://gist.github.com/scottgoodwin90/19ccecdc9f5733c0a9381765cfc7fe39  
https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2019-19774  
https://ocd-tech.com  
`