VDB
Sign up
MEDIUM5.7

GHSA-475g-vj6c-xf96

CrateDB database has an arbitrary file read vulnerability

Quick fix

GHSA-475g-vj6c-xf96 — io.crate:crate: upgrade to the fixed version with the command below.

# pom.xml: bump <version>5.3.9</version> for io.crate:crate

Details

### Summary There is an arbitrary file read vulnerability in the CrateDB database, and authenticated CrateDB database users can read any file on the system.

### Details There is a COPY FROM function in the CrateDB database that is used to import file data into database tables. This function has a flaw, and authenticated attackers can use the COPY FROM function to import arbitrary file content into database tables, resulting in information leakage.

### PoC ``` CREATE TABLE info_leak(info_leak STRING); COPY info_leak FROM '/etc/passwd' with (format='csv', header=false); or COPY info_leak FROM '/crate/config/crate.yml' with (format='csv', header=false); SELECT * FROM info_leak; ``` ![image](https://user-images.githubusercontent.com/154296962/292985975-ff5f2fb8-1a3f-4b49-9951-cd1fc6e78031.png)

### Impact This vulnerability affects all current versions of the CrateDB database. Attackers who exploit this vulnerability to obtain sensitive information may carry out further attacks, while also affecting CrateDB Cloud Clusters. ![image](https://user-images.githubusercontent.com/154296962/292986215-aec5adfe-38cc-4f31-bf86-c50ecbb44d5d.png)

Are you affected?

Enter the version of the package you're using.

Affected packages

Maven/io.crate:crate
Introduced in: 0Fixed in: 5.3.9
Fix# pom.xml: bump <version>5.3.9</version> for io.crate:crate
Maven/io.crate:crate
Introduced in: 5.4.0Fixed in: 5.4.8
Fix# pom.xml: bump <version>5.4.8</version> for io.crate:crate
Maven/io.crate:crate
Introduced in: 5.5.0Fixed in: 5.5.4
Fix# pom.xml: bump <version>5.5.4</version> for io.crate:crate
Maven/io.crate:crate
Introduced in: 5.6.0Fixed in: 5.6.1
Fix# pom.xml: bump <version>5.6.1</version> for io.crate:crate

References