Authenticated SQL Injection in OpenEMR before 5.0.2.1

Overview :

Authenticated SQL Injection in interface/forms/eye_mag/js/eye_base.php in OpenEMR through 5.0.2 allows a user to extract arbitrary data from the openemr database via a non-parameterized INSERT INTO statement, as demonstrated by the providerID parameter.

Affected Product(s) :

OpenEMR 5.0.1
OpenEMR 5.0.1.1
OpenEMR 5.0.1.2
OpenEMR 5.0.1.3
OpenEMR 5.0.1.4
OpenEMR 5.0.1.5
OpenEMR 5.0.1.6
OpenEMR 5.0.1.7
OpenEMR 5.0.2

Vulnerability Details :

CVE ID :

CVE-2019-16404

If the OpenEMR instance was running on localhost port 80, the following URL could be used to exploit the vulnerability, executing the payload “version()”.

http://localhost/openemr/interface/forms/eye/js/eye_base.php?providerID=1%27,%274%27,%27title%27

Note that this would require there to be no existing providerID 1 present in the database. After retrieving the cell of data, the next cell retrieved would have to use a new provider id, since this also has the affect of adding data with the provderID.

Solution :

Fixed-In Version: 5.0.2.1