Vulnerabilities in pkg:golang/github.com/elgs/gosqljson

PACKAGE
Advisory Identifier: GHSA-g7mw-9pf9-p2pm
Share
Advisory Summary

CVE-2014-125064 is a CRITICAL (CVSS 9.8) sql injection vulnerability (CWE-89: Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')) affecting Github.com/elgs/gosqljson libraries in the Go ecosystem. The issue involves gosqljson sql injection vulnerability. Remediation is available by upgrading affected packages to version 0.0.0-20220916234230-750f26ee23c7.

1 Known Advisory Record(s)
Package Vulnerability Intelligence

pkg:golang/github.com/elgs/gosqljson

1 Known Advisory Record(s)

Vulnerability advisories affecting package pkg:golang/github.com/elgs/gosqljson. Select an advisory below to view technical details or fixes.

Advisory ID CVE / NVD Severity Summary
GHSA-g7mw-9pf9-p2pm CVE-2014-125064 CRITICAL gosqljson SQL Injection vulnerability

CVE-2014-125064 at a Glance

CVE Identifier CVE-2014-125064
GHSA Identifier GHSA-g7mw-9pf9-p2pm
Severity CRITICAL
CVSS v3.1 Base Score 9.8
CWE Classification CWE-89: Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')
Affected Product Github.com/elgs/gosqljson
Package Ecosystem Go
Published Date
Last Updated

Security Impact

CVSS: 9.8

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

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

How to Fix CVE-2014-125064

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

github.com/elgs/gosqljson fixed: 0.0.0-20220916234230-750f26ee23c7 
Upgrade github.com/elgs/gosqljson to 0.0.0-20220916234230-750f26ee23c7
Verify Direct and Transitive Dependencies

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

inspect dependencies for github.com/elgs/gosqljson

How to Check if You Are Affected

To determine whether your application is affected by CVE-2014-125064, inspect your project dependencies for Github.com/elgs/gosqljson:

inspect dependencies for github.com/elgs/gosqljson

Analyze the terminal output to locate any version of Github.com/elgs/gosqljson in your dependency tree. If any resolved version matches the vulnerable ranges listed in the table below (for example, versions earlier than 0.0.0-20220916234230-750f26ee23c7), your application is affected.

Note: Verify declared build manifests and deployed runtime container environments.

Technical Details

Vulnerability Mechanism & Technical Analysis

This vulnerability is classified under CWE-89: Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection'), where the product constructs all or part of an sql command using externally-influenced input from an upstream component, but it does not neutralize or incorrectly neutralizes special elements that could modify the intended sql command when it is sent to a downstream component. without sufficient removal or quoting of sql syntax in user-controllable inputs, the generated sql query can cause those inputs to be interpreted as sql instead of ordinary user data. In Github.com/elgs/gosqljson, 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

A vulnerability, which was classified as critical, has been found in elgs gosqljson. This issue affects the function `QueryDbToArray/QueryDbToMap/ExecDb` of the file `gosqljson.go`. The manipulation of the argument sqlStatement leads to sql injection. The name of the patch is 2740b331546cb88eb61771df4c07d389e9f0363a. It is recommended to apply a patch to fix this issue. The associated identifier of this vulnerability is VDB-217631.

CVE-2014-125064 Affected Github.com/elgs/gosqljson Versions

1 component(s)
Fixed Versions:
0.0.0-20220916234230-750f26ee23c7
Product / Package Ecosystem Affected Versions Fixed Version
github.com/elgs/gosqljson
golang/github.com/elgs/gosqljson
Go
< 0.0.0-20220916234230-750f26ee23c7
0.0.0-20220916234230-750f26ee23c7

References

NVD — CVE-2014-125064 NVD
https://nvd.nist.gov/vuln/detail/CVE-2014-125064
Security Fix Commit FIX COMMIT
https://github.com/elgs/gosqljson/commit/2740b331546cb88eb61771df4c07d389e9f0363a
Github.com/elgs/gosqljson Source Repository REPOSITORY
https://github.com/elgs/gosqljson
pkg.go.dev/vuln/go-2023-1494 WEB
https://pkg.go.dev/vuln/GO-2023-1494
vuldb.com/ WEB
https://vuldb.com/?ctiid.217631
vuldb.com/ WEB
https://vuldb.com/?id.217631

Frequently Asked Questions

What is CVE-2014-125064?
CVE-2014-125064 is a security vulnerability in Github.com/elgs/gosqljson involving gosqljson SQL Injection vulnerability under CWE-89: Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection').
Which Github.com/elgs/gosqljson versions are affected?
Affected versions include releases prior to 0.0.0-20220916234230-750f26ee23c7 across affected packages: github.com/elgs/gosqljson.
What version fixes CVE-2014-125064?
Upgrading to 0.0.0-20220916234230-750f26ee23c7 (or the latest patched release for your respective branch) resolves the vulnerability.
Is github.com/elgs/gosqljson affected?
Yes, github.com/elgs/gosqljson is affected in releases prior to 0.0.0-20220916234230-750f26ee23c7. Upgrade your dependency to 0.0.0-20220916234230-750f26ee23c7 or later.
What is the CVSS score of CVE-2014-125064?
CVE-2014-125064 has a CVSS v3.1 base score of 9.8 (CRITICAL) with vector string CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H.
What CWE is associated with CVE-2014-125064?
CVE-2014-125064 is classified under CWE-89: Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection') (The product constructs all or part of an SQL command using externally-influenced input from an upstream component, but it does not neutralize or incorrectly neutralizes special elements that could modify the intended SQL command when it is sent to a downstream component. Without sufficient removal or quoting of SQL syntax in user-controllable inputs, the generated SQL query can cause those inputs to be interpreted as SQL instead of ordinary user data.).
How can I check Go dependencies for CVE-2014-125064?
Run the dependency tree command: 'inspect dependencies for github.com/elgs/gosqljson'. 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-g7mw-9pf9-p2pm",
  "modified" : "2023-01-12T23:40:45Z",
  "published" : "2023-01-07T21:30:39Z",
  "aliases" : [ "CVE-2014-125064" ],
  "summary" : "gosqljson SQL Injection vulnerability",
  "details" : "A vulnerability, which was classified as critical, has been found in elgs gosqljson. This issue affects the function `QueryDbToArray/QueryDbToMap/ExecDb` of the file `gosqljson.go`. The manipulation of the argument sqlStatement leads to sql injection. The name of the patch is 2740b331546cb88eb61771df4c07d389e9f0363a. It is recommended to apply a patch to fix this issue. The associated identifier of this vulnerability is VDB-217631.",
  "severity" : [ {
    "type" : "CVSS_V3",
    "score" : "CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H"
  } ],
  "affected" : [ {
    "package" : {
      "ecosystem" : "Go",
      "name" : "github.com/elgs/gosqljson"
    },
    "ranges" : [ {
      "type" : "ECOSYSTEM",
      "events" : [ {
        "introduced" : "0"
      }, {
        "fixed" : "0.0.0-20220916234230-750f26ee23c7"
      } ]
    } ]
  } ],
  "references" : [ {
    "type" : "ADVISORY",
    "url" : "https://nvd.nist.gov/vuln/detail/CVE-2014-125064"
  }, {
    "type" : "WEB",
    "url" : "https://github.com/elgs/gosqljson/commit/2740b331546cb88eb61771df4c07d389e9f0363a"
  }, {
    "type" : "PACKAGE",
    "url" : "https://github.com/elgs/gosqljson"
  }, {
    "type" : "WEB",
    "url" : "https://pkg.go.dev/vuln/GO-2023-1494"
  }, {
    "type" : "WEB",
    "url" : "https://vuldb.com/?ctiid.217631"
  }, {
    "type" : "WEB",
    "url" : "https://vuldb.com/?id.217631"
  } ],
  "database_specific" : {
    "cwe_ids" : [ "CWE-89" ],
    "severity" : "CRITICAL",
    "github_reviewed" : true,
    "github_reviewed_at" : "2023-01-12T23:40:45Z",
    "nvd_published_at" : "2023-01-07T20:15:00Z"
  }
}