CVE-2016-10556 SQL Injection in sequelize
Attackers can execute arbitrary SQL commands via improper array escaping in Sequelize when using Postgres, SQLite, or MSSQL.
- Exploited in the wild
- Not known
- Login needed
- Not needed
- Attackable
- Over the internet
- Victim action needed
- Not needed
- Fix
- Available
What is CVE-2016-10556?
CVE-2016-10556 is a high-severity SQL injection vulnerability in HackerOne sequelize node module, published on 29 May 2018. An attacker can exploit it over the internet without logging in, with no action from the victim.
Official description
sequelize is an Object-relational mapping, or a middleman to convert things from Postgres, MySQL, MariaDB, SQLite and Microsoft SQL Server into usable data for NodeJS In Postgres, SQLite, and Microsoft SQL Server there is an issue where arrays are treated as strings and improperly escaped. This causes potential SQL injection in sequelize 3.19.3 and earlier, where a malicious user could put `["test", "'); DELETE TestTable WHERE Id = 1 --')"]` inside of ``` database.query('SELECT * FROM TestTable WHERE Name IN (:names)', { replacements: { names: directCopyOfUserInput } }); ``` and cause the SQL statement to become `SELECT Id FROM Table WHERE Name IN ('test', '\'); DELETE TestTable WHERE Id = 1 --')`. In Postgres, MSSQL, and SQLite, the backslash has no special meaning. This causes the the statement to delete whichever Id has a value of 1 in the TestTable table.
Weakness: CWE-89
Which versions are affected by CVE-2016-10556?
2 open source packages ship an affected version, including sequelize. It affects 1 product.
| Package | Affected | Fixed in |
|---|---|---|
sequelize npm | All versions | 3.20.0 |
sequelize npm | All versions | 3.20.0 |
Products include Sequelizejs Sequelize.
How do I fix CVE-2016-10556?
Upgrade sequelize to 3.20.0 or later.
Use parameterised queries everywhere and never build SQL by joining strings. Upgrade affected software first; a web application firewall only buys time. More about SQL injection.
Is CVE-2016-10556 being exploited?
There is no known exploitation of CVE-2016-10556 in the wild and no public exploit code.
Other vulnerabilities in HackerOne sequelize node module
Sources
Also known as GHSA-9c2p-jw8p-f84v.