~ / search / GHSA-69wx-xc6j-28v3

GHSA-69wx-xc6j-28v3

Admidio has Blind SQL Injection in ecard_send.php

Source: GitHub Advisory Database (reviewed) Critical CVE-2024-37906

Packages

EcosystemPackageAffectedFixed in
Packagist admidio/admidio < 4.3.9 4.3.9

Details

As written in the advisory (Markdown source, shown as plain text).

### Description: An SQL Injection has been identified in the `/adm_program/modules/ecards/ecard_send.php` source file of the Admidio Application. The SQL Injection results in a compromise of the application's database. The value of `ecard_recipients `POST parameter is being directly concatenated with the SQL query in the source code causing the SQL Injection. The SQL Injection can be exploited by a member user, using blind condition-based, time-based, and Out of band interaction SQL Injection payloads. I successfully exploited SQL Injections by causing Time Delays. Advancing the payload, I was able to exfiltrate data from the database based on trial and error conditions and step-wise enumerating the characters of the database name. This was done as a POC of SQL Injection. An attacker could simply drop the database by providing a single payload, steal data, and potentially update the database according to their will. ### Impact: SQL injection (SQLi) vulnerabilities can have serious consequences for the security of a web application and its underlying database. Attackers can use SQLi to access sensitive data, and modify, delete, or add data to the database. SQLi can also be potentially used to perform RCE. ### Remediation: Use parameterized queries or prepared statements instead of concatenating user input directly into SQL queries. Parameterized queries ensure that user input is treated as data and not executable queries. OR Sanitize the input before including it in the SQL Query. ### Steps to Reproduce: - Intercept the POST request to `/adm_program/modules/ecards/ecard_send.php`, which is used to send photo as greeting card. - Change the value of `ecard_recipients%5B%5D` POST parameter to `2%2bsleep(10)`. - Sending the request will cause a time delay. ### Proof Of Concept: ![image](https://github.com/Admidio/admidio/assets/59286712/8ea87f4f-dad0-4df1-999d-212b07e02527) Figure 1: Code Vulnerable to SQL Injection ![image](https://github.com/Admidio/admidio/assets/59286712/d803a92c-3469-45aa-a844-e8aa311b55f4) Figure 2: Code Vulnerable to SQL Injection ![image](https://github.com/Admidio/admidio/assets/59286712/2ccdf865-2867-4dc8-abe1-f25b5e906db3) Figure 3: SQLi to trigger time delay ![image](https://github.com/Admidio/admidio/assets/59286712/eed06ce6-6591-427f-b98e-5314233b5996) Figure 4: Data Exfiltration via Condition-based Time Delays

References

External links from the advisory. They lead to third-party sites.