An open API service providing security vulnerability metadata for many open source software ecosystems.

Security Advisories: GSA_kwCzR0hTQS1wM3I1LXgzaHItZ3BnNc4AA10e

OpenRefine Remote Code execution in project import with mysql jdbc url attack


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


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, 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


env: centos 7 openrefine 3.7.4 jdk11 mysql-connector-java version 8.14.0 you can use the tool to running a malicious mysql server.
for example use the CB 1.9 Gadget to exec command touch /tmp/hacked.
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.


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

Source: GitHub Advisory Database
Origin: Unspecified
Severity: Critical
Classification: General
Published: 3 months ago
Updated: 18 days ago

CVSS Score: 9.8
CVSS vector: CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H

Identifiers: GHSA-p3r5-x3hr-gpg5, CVE-2023-41887

Affected Packages

Versions: <= 3.7.4
Fixed in: 3.7.5