OpenC3 COSMOS QuestDB Time-Series Database Data Disclosure and Deletion

Summary

A security issue exists in the QuestDB database used by OpenC3 COSMOS. If an attacker with certain permissions can exploit this issue, they may be able to access and delete sensitive telemetry data. To protect your data, ensure you are running an updated version of OpenC3 COSMOS and restrict permissions for users with access to the QuestDB database.

What to do

Update ryan melton openc3 to version 7.0.0-rc3.
Update openc3 to version 7.0.0-rc3.

Affected software

Ecosystem	Vendor	Product	Affected versions
rubygems	ryan melton	openc3	>= 6.7.0, < 7.0.0-rc3 Fix: upgrade to 7.0.0-rc3
rubygems	–	openc3	>= 6.7.0, < 7.0.0-rc3 Fix: upgrade to 7.0.0-rc3

Original title

OpenC3 COSMOS provides the functionality needed to send commands to and receive data from one or more embedded systems. From version 6.7.0 to before version 7.0.0-rc3, a SQL injection vulnerability...

Original description

OpenC3 COSMOS provides the functionality needed to send commands to and receive data from one or more embedded systems. From version 6.7.0 to before version 7.0.0-rc3, a SQL injection vulnerability exists in the Time-Series Database (TSDB) component of COSMOS. The tsdb_lookup function in the cvt_model.rb file directly places user-supplied input into a SQL query without sanitizing the input. As a result, a user can break out of the initial SQL statement and execute arbitrary SQL commands, including deleting data. This issue has been patched in version 7.0.0-rc3.

ghsa CVSS3.1 9.6

Vulnerability type

CWE-89 SQL Injection