FantasticLBP Hotels Server SQL Injection Vulnerability in OrderList.php

A SQL injection vulnerability has been identified in the FantasticLBP Hotels Server, specifically in the file '/controller/api/OrderList.php', within the version master-67b44df162fab26df209bd5d5d542875fcbec1d0'. This vulnerability allows remote attackers to inject malicious SQL queries through the 'telephone' parameter, exploiting inadequate input validation. The lack of proper sanitization enables manipulation of SQL commands, potentially leading to unauthorized database access, data modification or deletion, and exposure of sensitive information.

Impact

Exploitation of this vulnerability allows for unauthorized access to the database, manipulation or deletion of data, and leakage of sensitive information. Such actions could disrupt services and pose significant risks to overall system security and business operations.

Reproduction

The vulnerability can be reproduced by sending a request to 'http://<target>/controller/api/OrderList.php' with the 'telephone' parameter included. The injected SQL payload can be crafted to manipulate the SQL query processing, taking advantage of the application's failure to properly sanitize user input. This can be automated using tools like sqlmap, which can exploit the vulnerability and extract data from the database.

Remediation

It is recommended to use prepared statements and parameter binding to prevent SQL injection, validate and filter user input, minimize database user permissions, and conduct regular security audits.