# ExploitTitle:ManageEngineEventLogAnalyzer10.0-InformationDisclosure
# Date:2020-02-23
# Author:ScottGoodwin
# Vendor: https://www.manageengine.com/
# SoftwareLink: https://www.manageengine.com/products/eventlog/
# CVE:CVE-2019-19774VulnerabilityName:AuthenticatedInformationDisclosure in ManageEngineEventLogAnalyzerRegistered:CVE-2019-19774Discoverer:ScottGoodwin,OSCPOCDTechVendor of Product:ManageEngineAffectedProductCodeBase:EventLogAnalyzer-10.0SP1AffectedComponent:AffectedManageEngine endpoint: http://exampleclient:8400/event/runquery.doThis endpoint allows the ManageEngine user toexecute commands against the
ManageEnginePostgreSQLdatabase.
AttackType:RemoteVulnerabilityType:IncorrectAccessControlVulnerabilityImpact:AuthenticatedInformationDisclosureAttackVector:To exploit the vulnerability, an authenticated user must execute a specially crafted
query against the ManageEngine database tobypass the built-in security controls and
extract credential data.
VulnerabilityDescription:An issue was discovered in ZohoManageEngineEventLogAnalyzer10.0SP1.
By running "select hostdetails from hostdetails" at the /event/runquery.do endpoint,
it is possible tobypass 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 toauthenticate the ManageEngine platform tothe 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
ReportingTimeline:10/30/2019:This vulnerability was reported toManageEngine via the
Zoho/ManageEngineBugBountyprogram. They acknowledged the initial report.12/12/2019:Vulnerability registered
12/13/2019:Vulnerability acknowledged and update (12110) made available toManageEngine
customers.12/13/2019:Public disclosure
AdditionalInformation:This query bypasses the following security restrictions implemented within ManageEngine: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"ManageEngine will not execute the query.2. restrictions on printing the password field tothe screen in a column called "password".If the results of the query include a columncalled "password",ManageEngine will mask the
password witha 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 tobypass of this security
control.
RemediatedProductVersion:ManageEngineEventLogAnalyzerBuild12110Reference:
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