CVE-2020-27231 SQL injection in OpenClinic GA

What is CVE-2020-27231?

CVE-2020-27231 is a medium-severity SQL injection vulnerability in OpenClinic GA, published on 10 May 2021. Any signed-in user can exploit it over the network, with no action from the victim.

Official description

A number of exploitable SQL injection vulnerabilities exists in ‘patientslist.do’ page of OpenClinic GA 5.173.3 application. The findDistrict parameter in ‘‘patientslist.do’ page is vulnerable to authenticated SQL injection. An attacker can make an authenticated HTTP request to trigger this vulnerability.

Weakness: CWE-89

Which versions are affected by CVE-2020-27231?

It affects 1 product.

Products include Openclinic Ga Project Openclinic Ga.

How do I fix CVE-2020-27231?

No fix has been published for CVE-2020-27231 yet. Limit exposure of the affected software until one is available.

Use parameterised queries everywhere and never build SQL by joining strings. Upgrade affected software first; a web application firewall only buys time. More about SQL injection.

Is CVE-2020-27231 being exploited?

There is no known exploitation of CVE-2020-27231 in the wild and no public exploit code.

Other vulnerabilities in OpenClinic GA

• CVE-2020-27227 Command injection in OpenClinic Critical 10.0
• CVE-2020-14484 Security feature bypass in OpenClinic GA Critical 9.8
• CVE-2020-14485 Auth bypass in OpenClinic GA Critical 9.8
• CVE-2020-14494 Auth bypass in OpenClinic GA Critical 9.8
• CVE-2023-40275 Information disclosure in n/a Critical 9.1

Sources

• CVE record
• NVD
• OSV
• GitHub advisory
• How this page is made

Also known as GHSA-x5gp-5p79-9xh8.