GHSA-p3r5-x3hr-gpg5

Suggest an improvement
Source
https://github.com/advisories/GHSA-p3r5-x3hr-gpg5
Import Source
https://github.com/github/advisory-database/blob/main/advisories/github-reviewed/2023/09/GHSA-p3r5-x3hr-gpg5/GHSA-p3r5-x3hr-gpg5.json
JSON Data
https://api.osv.dev/v1/vulns/GHSA-p3r5-x3hr-gpg5
Aliases
Published
2023-09-12T13:52:54Z
Modified
2024-02-16T08:19:17.488416Z
Severity
  • 9.8 (Critical) CVSS_V3 - CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H CVSS Calculator
Summary
OpenRefine Remote Code execution in project import with mysql jdbc url attack
Details

Summary

An remote Code exec vulnerability allows any unauthenticated user to exec code 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 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. In 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. image

And there is a commons-beanutils dependency library on the server side, which contains an RCE-capable deserialization exploit chain

PoC

env: centos 7 openrefine 3.7.4 jdk11 mysql-connector-java version 8.14.0 you can use the tool https://github.com/4ra1n/mysql-fake-server to running a malicious mysql server.
for example use the CB 1.9 Gadget to exec command touch /tmp/hacked.
image
set the user to base64ZGVzZXJfQ0JfdG91Y2ggL3RtcC9oYWNrZWQ=(touch /tmp/hacked base64 encode),dataBaseName to test?autoDeserialize=true&queryInterceptors=com.mysql.cj.jdbc.interceptors.ServerStatusDiffInterceptor#.
image image
command touch /tmp/hacked is executed.
image

Impact

An remote Code exec vulnerability allows any unauthenticated user to exec code on the server.

Database specific 
{
    "nvd_published_at": "2023-09-15T21:15:11Z",
    "cwe_ids": [
        "CWE-89"
    ],
    "severity": "CRITICAL",
    "github_reviewed": true,
    "github_reviewed_at": "2023-09-12T13:52:54Z"
}
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"
}