CVE-2023-41887: Database Remote Code Execution Vulnerability
CRITICALCVE-2023-41887 is a CRITICAL (CVSS 9.8) remote code execution vulnerability (CWE-89: Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')) affecting Database libraries in the Maven ecosystem. The issue involves openrefine remote code execution in project import with mysql jdbc url attack. Remediation is available by upgrading affected packages to version 3.7.5.
CVE-2023-41887 at a Glance
Security Impact
CVSS: 9.8
The security impact metrics below are parsed directly from the CVSS v3.1 vector string (CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H).
How to Fix CVE-2023-41887
To remediate this vulnerability, upgrade all affected Database dependencies to a patched release. Both direct and transitive dependencies should be checked, as frameworks or security libraries may pull in vulnerable versions transitively.
<dependency>
<groupId>org.openrefine</groupId>
<artifactId>database</artifactId>
<version>3.7.5</version>
</dependency>Run the following command in your project directory to verify that all resolved dependencies use the patched release:
mvn dependency:tree -Dincludes=org.openrefineHow to Check if You Are Affected
To determine whether your Java application is affected by CVE-2023-41887, inspect your build dependencies using the Maven Dependency Plugin:
mvn dependency:tree -Dincludes=org.openrefineAnalyze the terminal output to locate any version of Database in your dependency tree. If any resolved version matches the vulnerable ranges listed in the table below (for example, versions earlier than 3.7.5), your application is affected.
Note: The mvn dependency:tree -Dincludes=org.openrefine command inspects the resolved dependency graph declared in your project's POM files; it does not perform automated security scanning or inspect runtime dynamic classpaths. Always verify runtime container classpaths and shaded JARs.
Technical Details
Vulnerability Mechanism & Technical Analysis
This vulnerability is classified under CWE-89: Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection'), where the product constructs all or part of an sql command using externally-influenced input from an upstream component, but it does not neutralize or incorrectly neutralizes special elements that could modify the intended sql command when it is sent to a downstream component. without sufficient removal or quoting of sql syntax in user-controllable inputs, the generated sql query can cause those inputs to be interpreted as sql instead of ordinary user data. In Database, software state validation or input boundaries are circumvented during processing. Review the official source advisory statement below for specific affected components, classes, and reproduction details.
Source Advisory Statement
CVE-2023-41887 Affected Database Versions
1 component(s)| Product / Package | Ecosystem | Affected Versions | Fixed Version |
|---|---|---|---|
|
org.openrefine:database
|
Maven |
< 3.7.5
|
3.7.5
|
References
Frequently Asked Questions
What is CVE-2023-41887?
Which Database versions are affected?
What version fixes CVE-2023-41887?
Is database affected?
What is the CVSS score of CVE-2023-41887?
What CWE is associated with CVE-2023-41887?
How can I check Maven dependencies for CVE-2023-41887?
Machine-readable OSV JSON
OSV v1.5 Schema
{
"schema_version" : "1.4.0",
"id" : "GHSA-p3r5-x3hr-gpg5",
"modified" : "2023-09-20T19:15:39Z",
"published" : "2023-09-12T13:52:54Z",
"aliases" : [ "CVE-2023-41887" ],
"summary" : "OpenRefine Remote Code execution in project import with mysql jdbc url attack",
"details" : "### Summary\nAn remote Code exec vulnerability allows any unauthenticated user to exec code on the server.\n\n### Details\nHi,Team,\ni find openrefine support to import data from database,When use mysql jdbc to connect to database,It is vulnerable to jdbc url attacks,for example,unauthenticated attacker can get rce on the server through the mysql userializable If the mysql-connector-java version used on the server side is less than 8.20.\nIn order for the server to enable deserialization we need to set the `autoDeserialize` and `queryInterceptors` parameters in the connection string,As same with https://github.com/OpenRefine/OpenRefine/security/advisories/GHSA-qqh2-wvmv-h72m, since the concatenation string is a direct concatenation, it is possible to inject the required parameters after the other parameters.\n\n\nAnd there is a commons-beanutils dependency library on the server side, which contains an RCE-capable deserialization exploit chain\n\n### PoC\nenv:\ncentos 7\nopenrefine 3.7.4\njdk11\nmysql-connector-java version 8.14.0\nyou can use the tool https://github.com/4ra1n/mysql-fake-server to running a malicious mysql server. \nfor example use the CB 1.9 Gadget to exec command `touch /tmp/hacked`. \n \nset the `user` to `base64ZGVzZXJfQ0JfdG91Y2ggL3RtcC9oYWNrZWQ=`(`touch /tmp/hacked` base64 encode),`dataBaseName` to `test?autoDeserialize=true&queryInterceptors=com.mysql.cj.jdbc.interceptors.ServerStatusDiffInterceptor#`. \n\n \n command `touch /tmp/hacked` is executed. \n\n\n### Impact\nAn remote Code exec vulnerability allows any unauthenticated user to exec code on the server.",
"severity" : [ {
"type" : "CVSS_V3",
"score" : "CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H"
} ],
"affected" : [ {
"package" : {
"ecosystem" : "Maven",
"name" : "org.openrefine:database"
},
"ranges" : [ {
"type" : "ECOSYSTEM",
"events" : [ {
"introduced" : "0"
}, {
"fixed" : "3.7.5"
} ]
} ],
"database_specific" : {
"last_known_affected_version_range" : "<= 3.7.4"
}
} ],
"references" : [ {
"type" : "WEB",
"url" : "https://github.com/OpenRefine/OpenRefine/security/advisories/GHSA-p3r5-x3hr-gpg5"
}, {
"type" : "ADVISORY",
"url" : "https://nvd.nist.gov/vuln/detail/CVE-2023-41887"
}, {
"type" : "WEB",
"url" : "https://github.com/OpenRefine/OpenRefine/commit/693fde606d4b5b78b16391c29d110389eb605511"
}, {
"type" : "PACKAGE",
"url" : "https://github.com/OpenRefine/OpenRefine"
} ],
"database_specific" : {
"cwe_ids" : [ "CWE-89" ],
"severity" : "CRITICAL",
"github_reviewed" : true,
"github_reviewed_at" : "2023-09-12T13:52:54Z",
"nvd_published_at" : "2023-09-15T21:15:11Z"
}
}