CVE-2021-36774: Kylin SQL Injection Vulnerability

MODERATE
Advisory Identifier: GHSA-5429-pjww-7675
Share
CVSS 6.5
CWE-668 CWE-89
Published
Advisory Summary

CVE-2021-36774 is a MODERATE (CVSS 6.5) sql injection vulnerability (CWE-668: Exposure of Resource to Wrong Sphere) affecting Kylin libraries in the Maven ecosystem. The issue involves sql injection in apache kylin. Remediation is available by upgrading affected packages to version 3.1.3.

CVE-2021-36774 at a Glance

CVE Identifier CVE-2021-36774
GHSA Identifier GHSA-5429-pjww-7675
Severity MODERATE
CVSS v3.1 Base Score 6.5
CWE Classification CWE-668: Exposure of Resource to Wrong Sphere
Affected Product Kylin
Package Ecosystem Maven
Published Date
Last Updated

Security Impact

CVSS: 6.5

The security impact metrics below are parsed directly from the CVSS v3.1 vector string (CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:N).

Attack Vector Network (AV:N)
Attack Complexity Low (AC:L)
Privileges Required Low (PR:L)
User Interaction None (UI:N)
Scope Unchanged (S:U)
Confidentiality High (C:H)
Integrity None (I:N)
Availability None (A:N)

How to Fix CVE-2021-36774

To remediate this vulnerability, upgrade all affected Kylin dependencies to a patched release. Both direct and transitive dependencies should be checked, as frameworks or security libraries may pull in vulnerable versions transitively.

org.apache.kylin:kylin fixed: 3.1.3 
<dependency>
    <groupId>org.apache.kylin</groupId>
    <artifactId>kylin</artifactId>
    <version>3.1.3</version>
</dependency>
Verify Direct and Transitive Dependencies

Run the following command in your project directory to verify that all resolved dependencies use the patched release: 

mvn dependency:tree -Dincludes=org.apache.kylin

How to Check if You Are Affected

To determine whether your Java application is affected by CVE-2021-36774, inspect your build dependencies using the Maven Dependency Plugin:

mvn dependency:tree -Dincludes=org.apache.kylin

Analyze the terminal output to locate any version of Kylin in your dependency tree. If any resolved version matches the vulnerable ranges listed in the table below (for example, versions earlier than 3.1.3), your application is affected.

Note: The mvn dependency:tree -Dincludes=org.apache.kylin command inspects the resolved dependency graph declared in your project's POM files; it does not perform automated security scanning or inspect runtime dynamic classpaths. Always verify runtime container classpaths and shaded JARs.

Technical Details

Vulnerability Mechanism & Technical Analysis

This vulnerability is classified under CWE-668: Exposure of Resource to Wrong Sphere, where the product exposes a resource to the wrong control sphere, providing unintended actors with inappropriate access to the resource. In Kylin, software state validation or input boundaries are circumvented during processing. Review the official source advisory statement below for specific affected components, classes, and reproduction details.

Source Advisory Statement

Apache Kylin allows users to read data from other database systems using JDBC. The MySQL JDBC driver supports certain properties, which, if left unmitigated, can allow an attacker to execute arbitrary code from a hacker-controlled malicious MySQL server within Kylin server processes. This issue affects Apache Kylin 2 version 2.6.6 and prior versions; Apache Kylin 3 version 3.1.2 and prior versions.

CVE-2021-36774 Affected Kylin Versions

1 component(s)
Fixed Versions:
3.1.3
Product / Package Ecosystem Affected Versions Fixed Version
org.apache.kylin:kylin
maven/org.apache.kylin/kylin
Maven
< 3.1.3
3.1.3

References

NVD — CVE-2021-36774 NVD
https://nvd.nist.gov/vuln/detail/CVE-2021-36774
Kylin Source Repository REPOSITORY
https://github.com/apache/kylin/pull/1646
Kylin Source Repository REPOSITORY
https://github.com/apache/kylin
lists.apache.org/thread/lchpcvoolc6w... WEB
https://lists.apache.org/thread/lchpcvoolc6w8zc6vo1wstk8zbfqv2ow
Kylin Security Information SECURITY
http://www.openwall.com/lists/oss-security/2022/01/06/5

Frequently Asked Questions

What is CVE-2021-36774?
CVE-2021-36774 is a security vulnerability in Kylin involving SQL Injection in Apache Kylin under CWE-668: Exposure of Resource to Wrong Sphere.
Which Kylin versions are affected?
Affected versions include releases prior to 3.1.3 across affected packages: org.apache.kylin:kylin.
What version fixes CVE-2021-36774?
Upgrading to 3.1.3 (or the latest patched release for your respective branch) resolves the vulnerability.
Is kylin affected?
Yes, org.apache.kylin:kylin is affected in releases prior to 3.1.3. Upgrade your dependency to 3.1.3 or later.
What is the CVSS score of CVE-2021-36774?
CVE-2021-36774 has a CVSS v3.1 base score of 6.5 (MODERATE) with vector string CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:N.
What CWE is associated with CVE-2021-36774?
CVE-2021-36774 is classified under CWE-668: Exposure of Resource to Wrong Sphere (The product exposes a resource to the wrong control sphere, providing unintended actors with inappropriate access to the resource.).
How can I check Maven dependencies for CVE-2021-36774?
Run the dependency tree command: 'mvn dependency:tree -Dincludes=org.apache.kylin'. This command lists direct and transitive dependencies in your build configuration so you can verify if a vulnerable version is resolved.
Machine-readable OSV JSON OSV v1.5 Schema
Normalized schema output
View Raw JSON 
{
  "schema_version" : "1.4.0",
  "id" : "GHSA-5429-pjww-7675",
  "modified" : "2023-08-08T20:44:51Z",
  "published" : "2022-01-08T00:43:04Z",
  "aliases" : [ "CVE-2021-36774" ],
  "summary" : "SQL Injection in Apache Kylin",
  "details" : "Apache Kylin allows users to read data from other database systems using JDBC. The MySQL JDBC driver supports certain properties, which, if left unmitigated, can allow an attacker to execute arbitrary code from a hacker-controlled malicious MySQL server within Kylin server processes. This issue affects Apache Kylin 2 version 2.6.6 and prior versions; Apache Kylin 3 version 3.1.2 and prior versions.",
  "severity" : [ {
    "type" : "CVSS_V3",
    "score" : "CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:N"
  } ],
  "affected" : [ {
    "package" : {
      "ecosystem" : "Maven",
      "name" : "org.apache.kylin:kylin"
    },
    "ranges" : [ {
      "type" : "ECOSYSTEM",
      "events" : [ {
        "introduced" : "0"
      }, {
        "fixed" : "3.1.3"
      } ]
    } ]
  } ],
  "references" : [ {
    "type" : "ADVISORY",
    "url" : "https://nvd.nist.gov/vuln/detail/CVE-2021-36774"
  }, {
    "type" : "WEB",
    "url" : "https://github.com/apache/kylin/pull/1646"
  }, {
    "type" : "PACKAGE",
    "url" : "https://github.com/apache/kylin"
  }, {
    "type" : "WEB",
    "url" : "https://lists.apache.org/thread/lchpcvoolc6w8zc6vo1wstk8zbfqv2ow"
  }, {
    "type" : "WEB",
    "url" : "http://www.openwall.com/lists/oss-security/2022/01/06/5"
  } ],
  "database_specific" : {
    "cwe_ids" : [ "CWE-668", "CWE-89" ],
    "severity" : "MODERATE",
    "github_reviewed" : true,
    "github_reviewed_at" : "2022-01-07T23:19:03Z",
    "nvd_published_at" : "2022-01-06T13:15:00Z"
  }
}