WordPress Clean Up Optimizer 4.0.0 SQL Injection Vulnerability

Advisory Title: WordPress Clean Up Optimizer Plugin Security Vulnerability
Advisory URL:   http://www.defensecode.com/advisories.php
Software:       WordPress Clean Up Optimizer plugin
Language:       PHP
Version:        4.0.0 and below
Vendor Status:  Vendor contacted, update released
Release Date:   2017/12/13
Risk:           High



1. General Overview
===================
During the security audit of Clean Up Optimizer plugin for WordPress
CMS, security vulnerability was discovered using DefenseCode
ThunderScan application source code security analysis platform.

More information about ThunderScan is available at URL:
http://www.defensecode.com


2. Software Overview
====================
According to the plugin developers, Clean Up Optimizer is an optimizes
your WordPress as well as clean up the obsolete data from database.
You can schedule the process of Cleaning, Optimizing, Deleting and
Repairing the database tables without going to phpMyAdmin.

Homepage:
https://wordpress.org/plugins/wp-clean-up-optimizer/
http://beta.tech-banker.com/

According to wordpress.org, it has more than 7,000 active installs.


3. Vulnerability Description
============================
During the security analysis, ThunderScan discovered
SQL injection vulnerability in Clean Up Optimizer WordPress plugin.

The easiest way to reproduce the vulnerability is to visit the
provided URL while being logged in as administrator or another user
that is authorized to access the plugin settings page. Users that do
not have full administrative privileges could abuse the database
access the vulnerability provides to either escalate their privileges
or obtain and modify database contents they were not supposed to be
able to.

Due to the missing nonce token, the vulnerable code is also directly
exposed to attack vectors such as Cross Site request forgery (CSRF).


3.1 SQL injection
  Function: $wpdb->get_results
  Variable: $_REQUEST["table_name"]
  Sample URL:
http://vulnerablesite.com/wp-admin/admin.php?page=cpo_database_view_records&table_name=wp3_wsd_plugin_alerts
WHERE 123=123 AND 456=456-- DCDC
  File: wp-clean-up-optimizer\includes\queries.php
        ---------
        587 $table_name_database = isset($_REQUEST["table_name"]) ?
esc_attr($_REQUEST["table_name"]) : "";
        ...
        594 "SELECT * FROM $table_name_database"
        ...
        598 "SHOW columns FROM $table_name_database"
        ---------
 

4. Solution
===========
After the vulnerability was reported the vendor resolved the security
issues. All users are strongly advised to update WordPress Clean Up
Optimizer plugin to the latest available version.


5. Credits
==========
Discovered by Neven Biruski using DefenseCode ThunderScan source code
security analyzer.

 
6. Disclosure Timeline
======================
2017/04/04      Vendor contacted
2017/04/10      Vendor responded
2017/04/10      Update released
2017/12/13      Advisory released to the public

#  0day.today [2018-04-01]  #