GHSA-qqh2-wvmv-h72m

Suggest an improvement
Source
https://github.com/advisories/GHSA-qqh2-wvmv-h72m
Import Source
https://github.com/github/advisory-database/blob/main/advisories/github-reviewed/2023/09/GHSA-qqh2-wvmv-h72m/GHSA-qqh2-wvmv-h72m.json
JSON Data
https://api.test.osv.dev/v1/vulns/GHSA-qqh2-wvmv-h72m
Aliases
Published
2023-09-12T13:52:05Z
Modified
2023-11-11T05:27:39.755875Z
Severity
  • 7.5 (High) CVSS_V3 - CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:N/A:N CVSS Calculator
Summary
OpenRefine vulnerable to arbitrary file read in project import with mysql jdbc url attack
Details

Summary

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 ).
image
image image 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.
image
for example,to read the /etc/passwd file. image 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. image

Impact

An arbitrary file read vulnerability allows any unauthenticated user to read the file on the server._

Database specific 
{
    "nvd_published_at": "2023-09-15T21:15:11Z",
    "cwe_ids": [
        "CWE-89"
    ],
    "severity": "HIGH",
    "github_reviewed": true,
    "github_reviewed_at": "2023-09-12T13:52:05Z"
}
References

Affected packages

Maven / org.openrefine:database

Package

Name
org.openrefine:database
View open source insights on deps.dev
Purl
pkg:maven/org.openrefine/database

Affected ranges

Type
ECOSYSTEM
Events
Introduced
0Unknown introduced version / All previous versions are affected
Fixed
3.7.5

Affected versions

3.*

3.6-beta1
3.6-beta2
3.6-rc1
3.6.0
3.6.1
3.6.2
3.7-beta1
3.7-beta2
3.7.0
3.7.2

Database specific 

{
    "last_known_affected_version_range": "<= 3.7.4"
}