CVE-2020-27229 SQL injection in OpenClinic GA

What is CVE-2020-27229?

CVE-2020-27229 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 findPersonID 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-27229?

It affects 1 product.

Products include Openclinic Ga Project Openclinic Ga.

How do I fix CVE-2020-27229?

No fix has been published for CVE-2020-27229 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-27229 being exploited?

There is no known exploitation of CVE-2020-27229 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-w39c-mmc3-2472.