CVE-2023-41886 – org.openrefine:database

Package

Manager: maven
Name: org.openrefine:database
Vulnerable Version: >=0 <3.7.5

Severity

Level: High

CVSS v3.1: CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:N/A:N

CVSS v4.0: CVSS:4.0/AV:N/AC:L/AT:N/PR:N/UI:N/VC:H/VI:N/VA:N/SC:N/SI:N/SA:N

EPSS: 0.03325 pctl0.86789

Details

OpenRefine vulnerable to arbitrary file read in project import with mysql jdbc url attack ### 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 ).    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._

Metadata

Created: 2023-09-12T13:52:05Z
Modified: 2023-09-20T19:05:52Z
Source: https://github.com/github/advisory-database/blob/main/advisories/github-reviewed/2023/09/GHSA-qqh2-wvmv-h72m/GHSA-qqh2-wvmv-h72m.json
CWE IDs: ["CWE-89"]
Alternative ID: GHSA-qqh2-wvmv-h72m
Finding: F106
Auto approve: 1