Security readout for executives and security teams
Plain-English summary
This is a high-severity SQL injection in the login flow of propanetank Roommate-Bill-Tracking. An unauthenticated remote attacker could tamper with the Username input and potentially read, change, or disrupt application data. It matters most where this app is still deployed and reachable, especially if it stores household billing or account information.
Executive priority
Treat this as a prompt remediation item for any exposed deployment. It is not presented as a widespread platform emergency, but unauthenticated SQL injection in a login path can threaten confidentiality, integrity, and availability of stored billing data.
Technical view
CVE-2017-20197 affects /includes/login.php in Roommate-Bill-Tracking up to commit 288437f658fc9ee7d4b92a9da12557024d8bc55c. Manipulation of the Username argument leads to SQL injection, mapped to CWE-89 and CWE-74. CVSS v2 is 7.5 with network access, low complexity, and no authentication required.
Likely exposure
Exposure is limited to deployments of propanetank Roommate-Bill-Tracking at the affected commit or earlier. The source bundle provides no CPEs, asset-discovery indicators, or evidence of broad packaged distribution, so organizations should validate through code and application inventories.
Exploitation context
The vulnerability is remotely reachable and does not require authentication based on the CVSS vector. The provided bundle does not identify active exploitation, and KEV status is false. VulDB provides a CTI reference, but the bundle does not include enough detail to claim exploitation in the wild.
Researcher notes
The public record names the vulnerable file and parameter but does not include affected release tags, CPEs, or exploit details. Focus validation on repository commit state, reachable login endpoints, and whether the patched SQL handling is present. Do not assume unrelated forks or products are affected without code evidence.
Mitigation direction
- Apply patch commit b32bb1b940f82d38fb9310cd66ebe349e20a1d0a or a version containing it.
- Remove public access to unpatched Roommate-Bill-Tracking instances until fixed.
- Review vendor or repository guidance for any additional remediation notes.
- Rotate credentials if logs or data suggest unauthorized login activity.
Validation and detection
- Inventory systems for propanetank Roommate-Bill-Tracking deployments.
- Confirm deployed code includes patch commit b32bb1b940f82d38fb9310cd66ebe349e20a1d0a.
- Check whether /includes/login.php is reachable from untrusted networks.
- Review application logs for suspicious login attempts targeting Username handling.
Public sources used
Generated from the cited source records. This long-tail analysis has not been individually reviewed by a named human.
Conservative CVE-to-ATT&CK context
These mappings and lookup hints may be relevant to the vulnerability behavior, CWE, affected product, or exposure path. Glexia-inferred context is not an official MITRE, ATT&CK, CWE, or CVE Program mapping.
ATT&CK lookup starting points
Use these exact CWE pages and searches to review the Glexia ATT&CK library from this CVE's weakness and description context.
CWE-74: Exact CWE lookup
Use the exact CWE identifier as the starting point before reviewing related ATT&CK behavior. Open the exact CWE lookup page first, then review the ATT&CK searches from that MITRE weakness context. This is a Glexia lookup hint, not an official ATT&CK mapping.
Open ATT&CK lookupCWE-89: Database access and collection lookup
Injection into data stores can inform collection, data access, and exfiltration detection reviews. Open the exact CWE lookup page first, then review the ATT&CK searches from that MITRE weakness context. This is a Glexia lookup hint, not an official ATT&CK mapping.
Open ATT&CK lookupDatabase behavior lookup
The CVE wording references database injection or access, so collection and exfiltration review may help. This is a Glexia inferred lookup path, not an official MITRE, ATT&CK, or CVE Program mapping.
Open ATT&CK lookupCVE-2017-20197 mapping review
Open the CVE-to-ATT&CK bridge for reviewed, inferred, or future official mappings tied to this CVE.
Open ATT&CK lookup- Severity
- High
- CVSS
- 7.5 (2.0)
- Known Exploited
- No
- Published
Vector: AV:N/AC:L/Au:N/C:P/I:P/A:P
CNA and ADP enrichment extracted from CVE v5
These fields come from the CVE record and ADP containers, not from Glexia's Take. They preserve time-varying source decisions such as CISA SSVC, KEV status, CVSS metrics, and provider references.
CVSS vector scores
1 official scoreWe collect every scored CVSS vector available in the official CNA and ADP containers. When more than one version is present, the table keeps the source vectors side by side instead of collapsing them into the highest score.
AV:N/AC:L/Au:N/C:P/I:P/A:P106.4Primary CVE scoreVulnerability scoring details
Base CVSS 2.0 score
7.5HighVector: AV:N/AC:L/Au:N/C:P/I:P/A:P
Source materials
- CVE List V5 sourceCVE List V5
- VDB-303640 | propanetank Roommate-Bill-Tracking login.php sql injectionCVE reference · vdb-entry, technical-description
- VDB-303640 | CTI Indicators (IOB, IOC, TTP, IOA)CVE reference · signature, permissions-required
- https://github.com/propanetank/Roommate-Bill-Tracking/commit/b32bb1b940f82d38fb9310cd66ebe349e20a1d0aCVE reference · patch
Products and packages named in the record
CWE details
CWE links open Glexia weakness intelligence pages with official CWE context, developer remediation guidance, and related CVE mappings.