CVE-2021-24575

School Management System – WPSchoolPress <= 2.1.9 - SQL Injection

2021-10-11 00:00

Strategic Overview

Status: Patched in 2.1.10
Affected Plugin: School Management System – WPSchoolPress
Affected Version: < 2.1.10
CVSS: 8.8High
Weakness type: CWE-89 · Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')
CVE: CVE-2021-24575

View all School Management System – WPSchoolPress vulnerabilities

At a glance

CVE-2021-24575 is a high-severity Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection') vulnerability in the School Management System WordPress plugin, affecting versions < 2.1.10. It carries a CVSS score of 8.8 (reachable over the network; low attack complexity; high confidentiality, integrity, availability impact). The issue is fixed in version 2.1.10; sites on affected versions should update now. Disclosed October 2021, reported by ZhongFu Su.

Vulnerability Overview

The School Management System – WPSchoolPress plugin for WordPress is vulnerable to blind SQL Injection via the several parameters in versions up to, and including, 2.1.9 due to insufficient escaping on the user supplied parameter and lack of sufficient preparation on the existing SQL query. This makes it possible for authenticated attackers to append additional SQL queries into already existing queries that can be used to extract sensitive information from the database. The following are the parameters that are vulnerable: 'main_m_id', 'Class', 'data', 'exmarks', 'day', 'absent' and 'AttendanceClass'.

Technical Analysis

The vector marks this flaw as remotely reachable over the network, with low attack complexity — no special timing or configuration is needed, and no interaction from a victim user. A successful exploit has high impact on confidentiality, integrity, availability — full site compromise territory.

CWE-89: Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')

School Management System < 2.1.10 carries this weakness at main_m_id, and reaching it takes a caller who can reach the endpoint. SQL injection happens when request data is concatenated into a query instead of being bound as a parameter, letting an attacker change the structure of the statement rather than just its values.

A working injection can read any table the database user can see, which on a WordPress install means user records, password hashes and session or API secrets stored in options. For School Management System the fix is 2.1.10: builds < 2.1.10 are affected, anything from 2.1.10 onward is not.

Remediation

Update to version 2.1.10, or a newer patched version

How does WordSec protect against this?

The attempt arrives as an ordinary request to School Management System: WordSec's web application firewall inspects request payloads before WordPress loads them. None of that substitutes for the fix: School Management System 2.1.10 closes this, and updating the plugin is the step that ends it.

Firewall
Alerts

External References

https://www.cve.org/CVERecord?id=CVE-2021-24575 https://www.wordfence.com/threat-intel/vulnerabilities/id/7de51bf2-f3dc-40d7-8d63-c85c267c4e98 https://nvd.nist.gov/vuln/detail/CVE-2021-24575

Related records

Same weakness class

Other vulnerabilities in School Management System – WPSchoolPress

CVSS Vector

8.8

CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H

Base

Attack VectorNetwork
Attack ComplexityLow
Privileges RequiredLow
User InteractionNone
ScopeUnchanged
ConfidentialityHigh
IntegrityHigh
AvailabilityHigh

This record contains material that is subject to copyright

CVE Usage: MITRE hereby grants you a perpetual, worldwide, non-exclusive, no-charge, royalty-free, irrevocable copyright license to reproduce, prepare derivative works of, publicly display, publicly perform, sublicense, and distribute Common Vulnerabilities and Exposures (CVE®). Any copy you make for such purposes is authorized provided that you reproduce MITRE's copyright designation and this license in any such copy.

https://www.cve.org/Legal/TermsOfUse

Defiant hereby grants you a perpetual, worldwide, non-exclusive, no-charge, royalty-free, irrevocable copyright license to reproduce, prepare derivative works of, publicly display, publicly perform, sublicense, and distribute this software vulnerability information. Any copy of the software vulnerability information you make for such purposes is authorized provided that you include a hyperlink to this vulnerability record and reproduce Defiant's copyright designation and this license in any such copy.

https://www.wordfence.com/wordfence-intelligence-terms-and-conditions/