lists.openwall.net   lists  /  announce  owl-users  owl-dev  john-users  john-dev  passwdqc-users  yescrypt  popa3d-users  /  oss-security  kernel-hardening  musl  sabotage  tlsify  passwords  /  crypt-dev  xvendor  /  Bugtraq  Full-Disclosure  linux-kernel  linux-netdev  linux-ext4  linux-hardening  linux-cve-announce  PHC 
Open Source and information security mailing list archives
 
Hash Suite: Windows password security audit tool. GUI, reports in PDF.
[<prev] [next>] [day] [month] [year] [list]
Message-ID: <CAFcQjjJWXXieiLyeARG=3M4fBt7e8tHpqFViVDOupa71mCmT6w@mail.gmail.com>
Date: Tue, 2 Nov 2021 19:17:10 +0100
From: BlackHawk <hawkgotyou@...il.com>
To: fulldisclosure <fulldisclosure@...lists.org>
Subject: [FD] Pentaho <= 9.1 Unauthenticated SQL Injection

Product: Pentaho Business Analytics / Pentaho Business Server
Vendor / Manufacturer: Hitachi Vantara
Affected Version(s): <= 9.1
Vulnerability Type: Unauthenticated SQL Injection
Solution Status: Fix Released on public GitHub repository
Manufacturer Notification:  June 2021
Public Disclosure: 01 November 2021
CVE Reference: CVE-2021-34684
Author(s) of Advisory: Alberto Favero ( HawSec ) & Altion Malka

--- ### --- ### ---

Product Description:

Pentaho is business intelligence (BI) software that provides data
integration, OLAP services, reporting, information dashboards, data mining
and extract, transform, load (ETL) capabilities. Its headquarters are in
Orlando, Florida. Pentaho was acquired by Hitachi Data Systems in 2015 and
in 2017 became part of Hitachi Vantara.

( Source: https://en.wikipedia.org/wiki/Pentaho )

--- ### --- ### ---

Vulnerability Details:

Pentaho allows users to create and manage Data Sources. Users can select a
Data Source when creating a Dashboard through the Pentaho User Console.
When a Data Source is added, Pentaho makes a HTTP request to the dashboards
editor (/pentaho/api/repos/dashboards/editor) in order to test the
connection by executing a test SQL query. However, further examination
revealed that by utilizing CVE-2021-31602 ( Authentication Bypass of Spring
APIs ) it is possible for an unauthenticated user to execute arbitrary SQL
queries on any Pentaho datasource and thus retrieve data from the related
databases.


--- ### --- ### ---

Proof of Concept (PoC):

See Ginger ( https://github.com/HawSec/ginger )

order
sqlmap -u "
http://localhost:8080/pentaho/api/repos/dashboards/editor?command=executeQuery&datasource=pentaho_operations_mart&query=*&require-cfg.js"
--dbs --dbms=postgresql


--- ### --- ### ---


Credits:

This vulnerability was discovered by Alberto Favero & Altion Malka

--- ### --- ### ---




-- 
BlackHawk - hawkgotyou@...il.com

Experientia senum, agilitas iuvenum.
Adversa fortiter. Dubia prudenter.

_______________________________________________
Sent through the Full Disclosure mailing list
https://nmap.org/mailman/listinfo/fulldisclosure
Web Archives & RSS: http://seclists.org/fulldisclosure/

Powered by blists - more mailing lists