GHSA-475g-vj6c-xf96

Dashboard / Vulnerabilities / GHSA-475g-vj6c-xf96

GHSA-475g-vj6c-xf96

Summary: CrateDB database has an arbitrary file read vulnerability

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; ```  ### 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: 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