| Package | Affected versions | Patched versions |
|---|---|---|
| org.openrefine:database | < 3.7.5 | 3.7.5 |
| openrefine | < 3.7.5 | 3.7.5 |
An arbitrary file read vulnerability allows any unauthenticated user to read the file 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 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.
allowLoadLocalInfile on the server side is false in this case.We need to manually set this value to true in the connection string.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 ).allowLoadLocalInfile on the server side is true in this case.so wo don't need do anything,Just connect to our malicious server.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.
An arbitrary file read vulnerability allows any unauthenticated user to read the file on the server._
Running one of these products? Scan your site to see whether it exposes a vulnerable version.
Scan my site free