{"id":87216,"date":"2026-07-17T06:57:43","date_gmt":"2026-07-17T06:57:43","guid":{"rendered":""},"modified":"-0001-11-30T00:00:00","modified_gmt":"-0001-11-30T00:00:00","slug":"cve-2017-20197-critical-sql-injection-vulnerability-in-propanetank-roommate-bill-tracking","status":"publish","type":"post","link":"https:\/\/www.ameeba.com\/blog\/cve-2017-20197-critical-sql-injection-vulnerability-in-propanetank-roommate-bill-tracking\/","title":{"rendered":"CVE-2017-20197: Critical SQL Injection Vulnerability in propanetank Roommate-Bill-Tracking<\/strong>"},"content":{"rendered":"

Overview<\/strong><\/p>\n

This report covers CVE-2017-20197, a critical SQL injection vulnerability found in the propanetank Roommate-Bill-Tracking software up to version 288437f658fc9ee7d4b92a9da12557024d8bc55c. The vulnerability specifically affects the \/includes\/login.php file. If exploited, this vulnerability has the potential for system compromise and data leakage. It is of significant importance due to the potential to gain unauthorized access to sensitive data or systems.<\/p>\n

Vulnerability Summary<\/strong><\/p>\n

CVE ID: CVE-2017-20197
\nSeverity: Critical (7.3 CVSS Score)
\nAttack Vector: Remote
\nPrivileges Required: None
\nUser Interaction: Required
\nImpact: Potential system compromise or data leakage<\/p>\n

Affected Products<\/strong><\/p>\n

Product | Affected Versions<\/p>\n

propanetank Roommate-Bill-Tracking | Up to 288437f658fc9ee7d4b92a9da12557024d8bc55c<\/p>\n

How the Exploit Works<\/strong><\/p>\n

The exploit works by manipulating the “Username” argument in the \/includes\/login.php file. This is a classic example of a SQL injection attack, where an attacker can insert malicious SQL code into a query that is designed to pull up user credentials. When the query is executed, the malicious code runs, potentially giving the attacker full access to all data held in the database.<\/p>\n

Conceptual Example Code<\/strong><\/p>\n

A conceptual example of this vulnerability might look like this:<\/p>\n

POST \/includes\/login.php HTTP\/1.1\nHost: target.example.com\nContent-Type: application\/x-www-form-urlencoded\nusername=' OR '1'='1'; --&password=whatever<\/code><\/pre>\n
In this example, the ‘ OR ‘1’=’1′ is the SQL injection, which will always evaluate to true and provide access to the attacker.<\/p>\n
Recommendations for Mitigation<\/strong><\/p>\n
It is recommended to apply the vendor-supplied patch (b32bb1b940f82d38fb9310cd66ebe349e20a1d0a) to fix this issue. If the patch cannot be applied immediately, use a Web Application Firewall (WAF) or an Intrusion Detection System (IDS) as a temporary mitigation measure.<\/p>\n","protected":false},"excerpt":{"rendered":"
Overview This report covers CVE-2017-20197, a critical SQL injection vulnerability found in the propanetank Roommate-Bill-Tracking software up to version 288437f658fc9ee7d4b92a9da12557024d8bc55c. The vulnerability specifically affects the \/includes\/login.php file. If exploited, this vulnerability has the potential for system compromise and data leakage. It is of significant importance due to the potential to gain unauthorized access to sensitive […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"footnotes":""},"categories":[],"tags":[],"vendor":[],"product":[],"attack_vector":[],"asset_type":[],"severity":[],"exploit_status":[],"class_list":["post-87216","post","type-post","status-publish","format-standard","hentry"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t