Executive Summary

The Computer and Mobile Repair Shop Management System v1.0 by Sourcecodester has an SQL injection vulnerability in the file /rsms/admin/repairs/view_details.php.

This vulnerability occurs because the id parameter in the URL /rsms/admin/?page=repairs/view_details&id= is not properly sanitized, allowing an attacker to inject malicious SQL code.

An attacker can exploit this by injecting SQL commands through the id parameter, such as using a UNION-based SQL injection to extract sensitive information like the current database name.

Useful 0 Not Useful 0

Impact Analysis

This SQL injection vulnerability can lead to unauthorized data leakage by allowing attackers to manipulate database queries.

Attackers may extract sensitive information from the database, compromising the confidentiality and integrity of the data stored in the system.

Useful 0 Not Useful 0

Detection Guidance

This SQL injection vulnerability can be detected by testing the `id` parameter in the URL `/rsms/admin/?page=repairs/view_details&id=` for SQL injection flaws.

A common detection method is to inject SQL payloads into the `id` parameter and observe the response for database errors or unexpected data.

For example, you can use the following URL payload to test for the vulnerability:

• /rsms/admin/?page=repairs/view_details&id=-1' union select 1,database(),3,4,5,6,7,8,9,10--+

This payload attempts a UNION-based SQL injection to extract the current database name, which indicates the presence of the vulnerability.

Useful 0 Not Useful 0

Compliance Impact

The SQL injection vulnerability in the Sourcecodester Computer and Mobile Repair Shop Management System v1.0 allows unauthorized data leakage by exploiting the `id` parameter in the admin repair details page. This unauthorized access to sensitive data can compromise the confidentiality and integrity of the database.

Such a compromise can lead to violations of common standards and regulations like GDPR and HIPAA, which require protection of personal and sensitive data against unauthorized access and breaches.

Useful 0 Not Useful 0

Mitigation Strategies

To mitigate the SQL injection vulnerability in the file `/rsms/admin/repairs/view_details.php`, immediate steps include:

• Restrict or disable access to the vulnerable admin repair details page until a fix is applied.
• Implement input validation and sanitization on the `id` parameter to prevent malicious SQL code injection.
• Use prepared statements or parameterized queries in the PHP code to safely handle database queries involving user input.
• Review and monitor database logs for suspicious activity related to the `id` parameter.
• Update or patch the system if a vendor-provided fix becomes available.

Useful 0 Not Useful 0