GHSA-475g-vj6c-xf96
CrateDB database has an arbitrary file read vulnerability
Packages
| Ecosystem | Package | Affected | Fixed in |
|---|---|---|---|
| Maven | io.crate:crate | < 5.3.9 | 5.3.9 |
| Maven | io.crate:crate | >= 5.4.0, < 5.4.8 | 5.4.8 |
| Maven | io.crate:crate | >= 5.5.0, < 5.5.4 | 5.5.4 |
| Maven | io.crate:crate | >= 5.6.0, < 5.6.1 | 5.6.1 |
Details
As written in the advisory (Markdown source, shown as plain text).
### 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;
```

### 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.

References
External links from the advisory. They lead to third-party sites.
- https://github.com/crate/crate/security/advisories/GHSA-475g-vj6c-xf96
- https://nvd.nist.gov/vuln/detail/CVE-2024-24565
- https://github.com/crate/crate/commit/32d0fc2ebb834ea324eb7ab5d01320a67bc5c3c7
- https://github.com/crate/crate/commit/4e857d675683095945dd524d6ba03e692c70ecd6
- https://github.com/crate/crate/commit/b75aeeabf90f51bd96ddb499903928fd10185207
- https://github.com/crate/crate/commit/c4c97d5a1c52cc2250ea42d062a3d37550c19dd5
- https://github.com/crate/crate/commit/c5034323f1b56ca5d04b8ef4c6029eb63a5ba172
- https://github.com/crate/crate