CVE-2020-27239 SQL injection in OpenClinic

What is CVE-2020-27239?

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

Official description

An exploitable SQL injection vulnerability exists in ‘getAssets.jsp’ page of OpenClinic GA 5.173.3. The assetStatus parameter in the getAssets.jsp page is vulnerable to unauthenticated SQL injection An attacker can make an authenticated HTTP request to trigger this vulnerability.

Weakness: CWE-89

Which versions are affected by CVE-2020-27239?

It affects 1 product.

Products include Openclinic Ga Project Openclinic Ga.

How do I fix CVE-2020-27239?

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

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

Other vulnerabilities in OpenClinic

• 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-f896-64x6-54qp.