{"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-30T06: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":"<strong>CVE-2017-20197: Critical SQL Injection Vulnerability in propanetank Roommate-Bill-Tracking<\/strong>"},"content":{"rendered":"<p><strong>Overview<\/strong><\/p>\n<p>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<p><strong>Vulnerability Summary<\/strong><\/p>\n<p>CVE ID: CVE-2017-20197<br \/>\nSeverity: Critical (7.3 CVSS Score)<br \/>\nAttack Vector: Remote<br \/>\nPrivileges Required: None<br \/>\nUser Interaction: Required<br \/>\nImpact: Potential system compromise or data leakage<\/p>\n<p><strong>Affected Products<\/strong><\/p><div id=\"ameeb-1052230054\" class=\"ameeb-content-2 ameeb-entity-placement\"><div style=\"border-left: 4px solid #555; padding-left: 20px; margin: 48px 0; font-family: Roboto, sans-serif; color: #ffffff; line-height: 1.6; max-width: 720px;\">\r\n  <h2 style=\"margin-top: 0; font-size: 22px; font-weight: 600; display: flex; align-items: center; letter-spacing: -0.02em;\">\r\n    <a href=\"https:\/\/www.ameeba.com\/chat\" style=\"display: inline-flex; align-items: center; margin-right: 10px;\">\r\n      <img decoding=\"async\" src=\"https:\/\/www.ameeba.com\/blog\/wp-content\/uploads\/2025\/10\/Best-App-icon-Ameeba.png\" alt=\"Ameeba Chat Icon\" style=\"width: 42px; height: 42px;\" \/>\r\n    <\/a>\r\n    Share secrets securely\r\n  <\/h2>\r\n\r\n  <p style=\"margin-bottom: 14px; color: #d1d5db;\">\r\n    Ameeba is private infrastructure for communication and sensitive work built on encrypted identity instead of exposed corporate identity systems.\r\n  <\/p>\r\n\r\n  <p style=\"margin-bottom: 18px; color: #a1a1aa;\">\r\n    Passwords, credentials, confidential files, screenshots, internal discussions, sensitive AI context, and private coordination should not become exposed across ordinary communication platforms.\r\n  <\/p>\r\n\r\n  <ul style=\"list-style: none; padding-left: 0; margin-bottom: 24px; color: #e4e4e7;\">\r\n    <li style=\"margin-bottom: 8px;\">\u2022 Encrypted identity<\/li>\r\n    <li style=\"margin-bottom: 8px;\">\u2022 Private Spaces for organizations and teams<\/li>\r\n    <li style=\"margin-bottom: 8px;\">\u2022 End-to-end encrypted chat, calls, files, and notes<\/li>\r\n    <li style=\"margin-bottom: 8px;\">\u2022 Sensitive AI work and protected collaboration<\/li>\r\n    <li>\u2022 Built for information that cannot leak<\/li>\r\n  <\/ul>\r\n\r\n  <p style=\"font-style: italic; font-weight: 600; margin-bottom: 24px; color: #ffffff;\">\r\n    Our mission is to secure human work alongside AI.\r\n  <\/p>\r\n\r\n  <div style=\"display: flex; flex-wrap: wrap; gap: 12px;\">\r\n    <a href=\"https:\/\/www.ameeba.com\/chat\/download\" style=\"background-color: #ffffff; color: #000000; padding: 10px 20px; text-decoration: none; border-radius: 8px; font-weight: 500;\">\r\n      Download Ameeba\r\n    <\/a>\r\n\r\n    <a href=\"https:\/\/www.ameeba.com\/chat\" style=\"border: 1px solid #ffffff; color: #ffffff; padding: 10px 20px; text-decoration: none; border-radius: 8px; font-weight: 500;\">\r\n      Learn More\r\n    <\/a>\r\n  <\/div>\r\n<\/div><\/div>\n<p>Product | Affected Versions<\/p>\n<p>propanetank Roommate-Bill-Tracking | Up to 288437f658fc9ee7d4b92a9da12557024d8bc55c<\/p>\n<p><strong>How the Exploit Works<\/strong><\/p>\n<p>The exploit works by manipulating the &#8220;Username&#8221; 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<p><strong>Conceptual Example Code<\/strong><\/p><div id=\"ameeb-103966727\" class=\"ameeb-content ameeb-entity-placement\"><div class=\"poptin-embedded\" data-id=\"f6b387694f681\"><\/div>\r\n\r\n\r\n\r\n\r\n\r\n<\/div>\n<p>A conceptual example of this vulnerability might look like this:<\/p>\n<pre><code class=\"\" data-line=\"\">POST \/includes\/login.php HTTP\/1.1\nHost: target.example.com\nContent-Type: application\/x-www-form-urlencoded\nusername=&#039; OR &#039;1&#039;=&#039;1&#039;; --&amp;password=whatever<\/code><\/pre>\n<p>In this example, the &#8216; OR &#8216;1&#8217;=&#8217;1&#8242; is the SQL injection, which will always evaluate to true and provide access to the attacker.<\/p>\n<p><strong>Recommendations for Mitigation<\/strong><\/p>\n<p>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":"<p>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 [&hellip;]<\/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,"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":[],"_links":{"self":[{"href":"https:\/\/www.ameeba.com\/blog\/wp-json\/wp\/v2\/posts\/87216","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ameeba.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ameeba.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ameeba.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ameeba.com\/blog\/wp-json\/wp\/v2\/comments?post=87216"}],"version-history":[{"count":0,"href":"https:\/\/www.ameeba.com\/blog\/wp-json\/wp\/v2\/posts\/87216\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.ameeba.com\/blog\/wp-json\/wp\/v2\/media?parent=87216"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ameeba.com\/blog\/wp-json\/wp\/v2\/categories?post=87216"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ameeba.com\/blog\/wp-json\/wp\/v2\/tags?post=87216"},{"taxonomy":"vendor","embeddable":true,"href":"https:\/\/www.ameeba.com\/blog\/wp-json\/wp\/v2\/vendor?post=87216"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.ameeba.com\/blog\/wp-json\/wp\/v2\/product?post=87216"},{"taxonomy":"attack_vector","embeddable":true,"href":"https:\/\/www.ameeba.com\/blog\/wp-json\/wp\/v2\/attack_vector?post=87216"},{"taxonomy":"asset_type","embeddable":true,"href":"https:\/\/www.ameeba.com\/blog\/wp-json\/wp\/v2\/asset_type?post=87216"},{"taxonomy":"severity","embeddable":true,"href":"https:\/\/www.ameeba.com\/blog\/wp-json\/wp\/v2\/severity?post=87216"},{"taxonomy":"exploit_status","embeddable":true,"href":"https:\/\/www.ameeba.com\/blog\/wp-json\/wp\/v2\/exploit_status?post=87216"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}