GHSA-QQH2-WVMV-H72M
Vulnerability from github – Published: 2023-09-12 13:52 – Updated: 2023-09-20 19:05Summary
An arbitrary file read vulnerability allows any unauthenticated user to read the file on the server._
Details
Hi,Team,
i 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.
There are some differences in utilization depending on the version of the mysql-connector dependency on the server side.
1. mysql-connector-java version > 8.14
The 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.
Since 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 ).
2. mysql-connector-java version <= 8.14
The 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.
PoC
env:
centos 7
openrefine 3.7.4
jdk11
mysql-connector-java version 8.30.0
you can use the tool https://github.com/4ra1n/mysql-fake-server to running a malicious mysql server.
for example,to read the /etc/passwd file.
set 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.
you can get the file in your fake-server-files directory.
Impact
An arbitrary file read vulnerability allows any unauthenticated user to read the file on the server._
{
"affected": [
{
"database_specific": {
"last_known_affected_version_range": "\u003c= 3.7.4"
},
"package": {
"ecosystem": "Maven",
"name": "org.openrefine:database"
},
"ranges": [
{
"events": [
{
"introduced": "0"
},
{
"fixed": "3.7.5"
}
],
"type": "ECOSYSTEM"
}
]
}
],
"aliases": [
"CVE-2023-41886"
],
"database_specific": {
"cwe_ids": [
"CWE-89"
],
"github_reviewed": true,
"github_reviewed_at": "2023-09-12T13:52:05Z",
"nvd_published_at": "2023-09-15T21:15:11Z",
"severity": "HIGH"
},
"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 \u003e 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 \u003c= 8.14\nThe default value of `allowLoadLocalInfile` on the server side is true in this case.so wo don\u0027t 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 \u003c= 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",
"id": "GHSA-qqh2-wvmv-h72m",
"modified": "2023-09-20T19:05:52Z",
"published": "2023-09-12T13:52:05Z",
"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"
}
],
"schema_version": "1.4.0",
"severity": [
{
"score": "CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:N/A:N",
"type": "CVSS_V3"
}
],
"summary": "OpenRefine vulnerable to arbitrary file read in project import with mysql jdbc url attack"
}
Sightings
| Author | Source | Type | Date |
|---|
Nomenclature
- Seen: The vulnerability was mentioned, discussed, or observed by the user.
- Confirmed: The vulnerability has been validated from an analyst's perspective.
- Published Proof of Concept: A public proof of concept is available for this vulnerability.
- Exploited: The vulnerability was observed as exploited by the user who reported the sighting.
- Patched: The vulnerability was observed as successfully patched by the user who reported the sighting.
- Not exploited: The vulnerability was not observed as exploited by the user who reported the sighting.
- Not confirmed: The user expressed doubt about the validity of the vulnerability.
- Not patched: The vulnerability was not observed as successfully patched by the user who reported the sighting.