CVE-2023-41886: Database OpenRefine Vulnerable To Arbitrary File Vulnerability
HIGHCVE-2023-41886 is a HIGH (CVSS 7.5) openrefine vulnerable to arbitrary file 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 vulnerable to arbitrary file read in project import with mysql jdbc url attack. Remediation is available by upgrading affected packages to version 3.7.5.
CVE-2023-41886 at a Glance
Security Impact
CVSS: 7.5
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:N/A:N).
How to Fix CVE-2023-41886
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-41886, 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-41886 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-41886?
Which Database versions are affected?
What version fixes CVE-2023-41886?
Is database affected?
What is the CVSS score of CVE-2023-41886?
What CWE is associated with CVE-2023-41886?
How can I check Maven dependencies for CVE-2023-41886?
Machine-readable OSV JSON
OSV v1.5 Schema
{
"schema_version" : "1.4.0",
"id" : "GHSA-qqh2-wvmv-h72m",
"modified" : "2023-09-20T19:05:52Z",
"published" : "2023-09-12T13:52:05Z",
"aliases" : [ "CVE-2023-41886" ],
"summary" : "OpenRefine vulnerable to arbitrary file read in project import with mysql jdbc url attack",
"details" : "### Summary\nAn arbitrary file read vulnerability allows any unauthenticated user to read the file 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 read the file on the server.\nThere are some differences in utilization depending on the version of the mysql-connector dependency on the server side. \n1. mysql-connector-java version > 8.14\nThe default value of `allowLoadLocalInfile` on the server side is false in this case.We need to manually set this value to true in the connection string. \nSince the way to get the databaseurl in `com/google/refine/extension/database/mysql/MySQLConnectionManager.java` is to splice the individual configurations directly, we can set the `allowLoadLocalInfile` parameter after the other parameters(for example the `databaseName` parameter ). \n \n\n\n2. mysql-connector-java version <= 8.14\nThe default value of `allowLoadLocalInfile` on the server side is true in this case.so wo don't need do anything,Just connect to our malicious server.\n\n### PoC\nenv: \ncentos 7\nopenrefine 3.7.4 \njdk11 \nmysql-connector-java version 8.30.0 \n\nyou can use the tool https://github.com/4ra1n/mysql-fake-server to running a malicious mysql server. \n \nfor example,to read the /etc/passwd file.\n\nset the `username` to `base64ZmlsZXJlYWRfL2V0Yy9wYXNzd2Q=` and `Database name` to `test?allowLoadLocalInfile=true#` (for mysql-connector-java version <= 8.14,just setting the database name normally) and test to connect your malicious mysql server.\nyou can get the file in your fake-server-files directory.\n\n\n\n### Impact\n\nAn arbitrary file read vulnerability allows any unauthenticated user to read the file on the server._\n",
"severity" : [ {
"type" : "CVSS_V3",
"score" : "CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:N/A:N"
} ],
"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-qqh2-wvmv-h72m"
}, {
"type" : "ADVISORY",
"url" : "https://nvd.nist.gov/vuln/detail/CVE-2023-41886"
}, {
"type" : "WEB",
"url" : "https://github.com/OpenRefine/OpenRefine/commit/2de1439f5be63d9d0e89bbacbd24fa28c8c3e29d"
}, {
"type" : "PACKAGE",
"url" : "https://github.com/OpenRefine/OpenRefine"
} ],
"database_specific" : {
"cwe_ids" : [ "CWE-89" ],
"severity" : "HIGH",
"github_reviewed" : true,
"github_reviewed_at" : "2023-09-12T13:52:05Z",
"nvd_published_at" : "2023-09-15T21:15:11Z"
}
}