GHSA-6pmj-xjxp-p8g9: LibreNMS is vulnerable to SQL Injection (Boolean-Based Blind) in hostname parameter in ajax_output.php endpoint
SummaryA **Boolean-Based Blind SQL Injection** vulnerability was identified in the LibreNMS application at the `/ajax_output.php` endpoint. The `hostname` parameter is interpolated directly into an SQL query without proper sanitization or parameter binding, allowing an attacker to manipulate the query logic and infer data from the database through conditional responses.Details**Vulnerable Endpoint:** `GET /ajax_output.php**Parameter:** `hostname`**Authentication Required:** Admin privileges required to access `/ajax_output.php` discovery endpoint**Vulnerability type:** Boolean-Based Blind SQL Injection — input is concatenated into a SQL statement without proper escapingDescriptionThe LibreNMS application uses the `hostname` parameter during device discovery operations to query the database for matching devices.  
However, user-supplied data is concatenated directly into the SQL query within `/opt/librenms/includes/html/output/capture.inc.php` without adequate sanitization..This allows attackers to modify the query logic using Boolean expressions.  
When crafted conditions evaluate to **true**, the application behaves normally and returns the expected device data.  
When conditions evaluate to **false**, the response is altered (e.g., the queried host is not found).This difference in behavior confirms that the parameter’s value is being interpreted as SQL logic, demonstrating a **Boolean-Based Blind SQL Injection**.Note: This vulnerability requires an authenticated user with **administrator privileges** to access the affected discovery functionality. While this limits exploitation to internal or compromised admin sessions, the vulnerability still represents a critical security risk due to the ability to manipulate backend SQL logic in privileged contexts.Proof of Concept (PoC)1 - **Authenticate with an administrator account.**  
The discovery endpoint `/ajax_output.php` is accessible only to users with admin-level privileges.2 - Access the following URL with the payload that evaluates to `TRUE`:3 - Observe that the system returns the expected data and triggers the discovery process.4 - Now repeat the request with a `FALSE` condition:5 - Observe that the response is altered: no device is found, and no discovery is triggered.Query behavior observed in logs``SQL[SELECT * FROM `devices` WHERE disabled = 0 AND `hostname` LIKE '10.0.5.4' AND 1=1 AND '1'='1' ORDER BY device_id DESC [] 0.5ms]``The difference in output confirms that the injected Boolean logic is being executed by the database.ImpactBoolean-based SQL Injection can have severe consequences depending on the deployment context:**Data extraction:** Attackers can infer database data (schema, users, configuration) through Boolean inference techniques.**System compromise:** Database or application state could be manipulated if the injection is further exploited.**Information disclosure:** Reveals internal SQL structure and logic of the LibreNMS backend.ReferencesCWE-89 — Improper Neutralization of Special Elements used in an SQL Command (‘SQL Injection’)OWASP SQL Injection Prevention Cheat Sheet
CVSS v3.1: 5.5