Vulnerability-Lookup

CNVD-2021-103392

Vulnerability from cnvd - Published: 2021-12-30

Title

Anuko Time Tracker SQL注入漏洞

Description

Anuko Time Tracker是个人开发者的一个开源的时间统计系统。用于统计员工在各个工作上花费时间的一个平台。 Anuko Time Tracker存在SQL注入漏洞，该漏洞源于groups.php文件中没有正确检查POST请求中的组和状态参数。当在组织的子组之间导航时，组参数会被发布。在多个文件中使用Status参数来更改实体的状态，例如使项目、任务或用户处于非活动状态。攻击者可利用该漏洞获取敏感信息。

Severity

中

Patch Name

Anuko Time Tracker SQL注入漏洞的补丁

Patch Description

Formal description

目前厂商已发布升级补丁以修复漏洞，补丁获取链接： https://github.com/anuko/timetracker/security/advisories/GHSA-wx6x-6rq3-pqcc

Reference

https://nvd.nist.gov/vuln/detail/CVE-2021-43851

Impacted products

Name
Anuko Time Tracker Anuko Time Tracker <=1.19.33.5606

Show details on source website

JSON

To clipboard

{
  "cves": {
    "cve": {
      "cveNumber": "CVE-2021-43851"
    }
  },
  "description": "Anuko Time Tracker\u662f\u4e2a\u4eba\u5f00\u53d1\u8005\u7684\u4e00\u4e2a\u5f00\u6e90\u7684\u65f6\u95f4\u7edf\u8ba1\u7cfb\u7edf\u3002\u7528\u4e8e\u7edf\u8ba1\u5458\u5de5\u5728\u5404\u4e2a\u5de5\u4f5c\u4e0a\u82b1\u8d39\u65f6\u95f4\u7684\u4e00\u4e2a\u5e73\u53f0\u3002\n\nAnuko Time Tracker\u5b58\u5728SQL\u6ce8\u5165\u6f0f\u6d1e\uff0c\u8be5\u6f0f\u6d1e\u6e90\u4e8egroups.php\u6587\u4ef6\u4e2d\u6ca1\u6709\u6b63\u786e\u68c0\u67e5POST\u8bf7\u6c42\u4e2d\u7684\u7ec4\u548c\u72b6\u6001\u53c2\u6570\u3002\u5f53\u5728\u7ec4\u7ec7\u7684\u5b50\u7ec4\u4e4b\u95f4\u5bfc\u822a\u65f6\uff0c\u7ec4\u53c2\u6570\u4f1a\u88ab\u53d1\u5e03\u3002\u5728\u591a\u4e2a\u6587\u4ef6\u4e2d\u4f7f\u7528Status\u53c2\u6570\u6765\u66f4\u6539\u5b9e\u4f53\u7684\u72b6\u6001\uff0c\u4f8b\u5982\u4f7f\u9879\u76ee\u3001\u4efb\u52a1\u6216\u7528\u6237\u5904\u4e8e\u975e\u6d3b\u52a8\u72b6\u6001\u3002\u653b\u51fb\u8005\u53ef\u5229\u7528\u8be5\u6f0f\u6d1e\u83b7\u53d6\u654f\u611f\u4fe1\u606f\u3002",
  "formalWay": "\u76ee\u524d\u5382\u5546\u5df2\u53d1\u5e03\u5347\u7ea7\u8865\u4e01\u4ee5\u4fee\u590d\u6f0f\u6d1e\uff0c\u8865\u4e01\u83b7\u53d6\u94fe\u63a5\uff1a\r\nhttps://github.com/anuko/timetracker/security/advisories/GHSA-wx6x-6rq3-pqcc",
  "isEvent": "\u901a\u7528\u8f6f\u786c\u4ef6\u6f0f\u6d1e",
  "number": "CNVD-2021-103392",
  "openTime": "2021-12-30",
  "patchDescription": "Anuko Time Tracker\u662f\u4e2a\u4eba\u5f00\u53d1\u8005\u7684\u4e00\u4e2a\u5f00\u6e90\u7684\u65f6\u95f4\u7edf\u8ba1\u7cfb\u7edf\u3002\u7528\u4e8e\u7edf\u8ba1\u5458\u5de5\u5728\u5404\u4e2a\u5de5\u4f5c\u4e0a\u82b1\u8d39\u65f6\u95f4\u7684\u4e00\u4e2a\u5e73\u53f0\u3002\r\n\r\nAnuko Time Tracker\u5b58\u5728SQL\u6ce8\u5165\u6f0f\u6d1e\uff0c\u8be5\u6f0f\u6d1e\u6e90\u4e8egroups.php\u6587\u4ef6\u4e2d\u6ca1\u6709\u6b63\u786e\u68c0\u67e5POST\u8bf7\u6c42\u4e2d\u7684\u7ec4\u548c\u72b6\u6001\u53c2\u6570\u3002\u5f53\u5728\u7ec4\u7ec7\u7684\u5b50\u7ec4\u4e4b\u95f4\u5bfc\u822a\u65f6\uff0c\u7ec4\u53c2\u6570\u4f1a\u88ab\u53d1\u5e03\u3002\u5728\u591a\u4e2a\u6587\u4ef6\u4e2d\u4f7f\u7528Status\u53c2\u6570\u6765\u66f4\u6539\u5b9e\u4f53\u7684\u72b6\u6001\uff0c\u4f8b\u5982\u4f7f\u9879\u76ee\u3001\u4efb\u52a1\u6216\u7528\u6237\u5904\u4e8e\u975e\u6d3b\u52a8\u72b6\u6001\u3002\u653b\u51fb\u8005\u53ef\u5229\u7528\u8be5\u6f0f\u6d1e\u83b7\u53d6\u654f\u611f\u4fe1\u606f\u3002 \u76ee\u524d\uff0c\u4f9b\u5e94\u5546\u53d1\u5e03\u4e86\u5b89\u5168\u516c\u544a\u53ca\u76f8\u5173\u8865\u4e01\u4fe1\u606f\uff0c\u4fee\u590d\u4e86\u6b64\u6f0f\u6d1e\u3002",
  "patchName": "Anuko Time Tracker SQL\u6ce8\u5165\u6f0f\u6d1e\u7684\u8865\u4e01",
  "products": {
    "product": "Anuko Time Tracker Anuko Time Tracker \u003c=1.19.33.5606"
  },
  "referenceLink": "https://nvd.nist.gov/vuln/detail/CVE-2021-43851",
  "serverity": "\u4e2d",
  "submitTime": "2021-12-23",
  "title": "Anuko Time Tracker SQL\u6ce8\u5165\u6f0f\u6d1e"
}

CVE-2021-43851 (GCVE-0-2021-43851)

Vulnerability from cvelistv5 – Published: 2021-12-21 23:40 – Updated: 2024-08-04 04:10

Title

SQL injection vulnerability in anuko timetracker

Summary

Anuko Time Tracker is an open source, web-based time tracking application written in PHP. SQL injection vulnerability exist in multiple files in Time Tracker version 1.19.33.5606 and prior due to not properly checking of the "group" and "status" parameters in POST requests. Group parameter is posted along when navigating between organizational subgroups (groups.php file). Status parameter is used in multiple files to change a status of an entity such as making a project, task, or user inactive. This issue has been patched in version 1.19.33.5607. An upgrade is highly recommended. If an upgrade is not practical, introduce ttValidStatus function as in the latest version and start using it user input check blocks wherever status field is used. For groups.php fix, introduce ttValidInteger function as in the latest version and use it in the access check block in the file.

Severity

8.1 (High)


                        
                          CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:N

CWE

CWE-89 - Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')

Assigner

GitHub_M mitre root

References

3 references

URL	Tags
https://github.com/anuko/timetracker/security/adv…	x_refsource_CONFIRM
https://github.com/anuko/timetracker/commit/0cf32…	x_refsource_MISC
https://github.com/anuko/timetracker/commit/94fda…	x_refsource_MISC

Impacted products

1 product

Vendor	Product	Version
anuko	timetracker	Affected: < 1.19.33.5607

Show details on NVD website

JSON

To clipboard

{
  "containers": {
    "adp": [
      {
        "providerMetadata": {
          "dateUpdated": "2024-08-04T04:10:16.291Z",
          "orgId": "af854a3a-2127-422b-91ae-364da2661108",
          "shortName": "CVE"
        },
        "references": [
          {
            "tags": [
              "x_refsource_CONFIRM",
              "x_transferred"
            ],
            "url": "https://github.com/anuko/timetracker/security/advisories/GHSA-wx6x-6rq3-pqcc"
          },
          {
            "tags": [
              "x_refsource_MISC",
              "x_transferred"
            ],
            "url": "https://github.com/anuko/timetracker/commit/0cf32f1046418aa2e5218b0b370064820c330c6a"
          },
          {
            "tags": [
              "x_refsource_MISC",
              "x_transferred"
            ],
            "url": "https://github.com/anuko/timetracker/commit/94fda0cc0c9c20ab98d38ccc75ff040d13dc7f1b"
          }
        ],
        "title": "CVE Program Container"
      }
    ],
    "cna": {
      "affected": [
        {
          "product": "timetracker",
          "vendor": "anuko",
          "versions": [
            {
              "status": "affected",
              "version": "\u003c 1.19.33.5607"
            }
          ]
        }
      ],
      "descriptions": [
        {
          "lang": "en",
          "value": "Anuko Time Tracker is an open source, web-based time tracking application written in PHP. SQL injection vulnerability exist in multiple files in Time Tracker version 1.19.33.5606 and prior due to not properly checking of the \"group\" and \"status\" parameters in POST requests. Group parameter is posted along when navigating between organizational subgroups (groups.php file). Status parameter is used in multiple files to change a status of an entity such as making a project, task, or user inactive. This issue has been patched in version 1.19.33.5607. An upgrade is highly recommended. If an upgrade is not practical, introduce ttValidStatus function as in the latest version and start using it user input check blocks wherever status field is used. For groups.php fix, introduce ttValidInteger function as in the latest version and use it in the access check block in the file."
        }
      ],
      "metrics": [
        {
          "cvssV3_1": {
            "attackComplexity": "LOW",
            "attackVector": "NETWORK",
            "availabilityImpact": "NONE",
            "baseScore": 8.1,
            "baseSeverity": "HIGH",
            "confidentialityImpact": "HIGH",
            "integrityImpact": "HIGH",
            "privilegesRequired": "LOW",
            "scope": "UNCHANGED",
            "userInteraction": "NONE",
            "vectorString": "CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:N",
            "version": "3.1"
          }
        }
      ],
      "problemTypes": [
        {
          "descriptions": [
            {
              "cweId": "CWE-89",
              "description": "CWE-89: Improper Neutralization of Special Elements used in an SQL Command (\u0027SQL Injection\u0027)",
              "lang": "en",
              "type": "CWE"
            }
          ]
        }
      ],
      "providerMetadata": {
        "dateUpdated": "2021-12-21T23:40:10.000Z",
        "orgId": "a0819718-46f1-4df5-94e2-005712e83aaa",
        "shortName": "GitHub_M"
      },
      "references": [
        {
          "tags": [
            "x_refsource_CONFIRM"
          ],
          "url": "https://github.com/anuko/timetracker/security/advisories/GHSA-wx6x-6rq3-pqcc"
        },
        {
          "tags": [
            "x_refsource_MISC"
          ],
          "url": "https://github.com/anuko/timetracker/commit/0cf32f1046418aa2e5218b0b370064820c330c6a"
        },
        {
          "tags": [
            "x_refsource_MISC"
          ],
          "url": "https://github.com/anuko/timetracker/commit/94fda0cc0c9c20ab98d38ccc75ff040d13dc7f1b"
        }
      ],
      "source": {
        "advisory": "GHSA-wx6x-6rq3-pqcc",
        "discovery": "UNKNOWN"
      },
      "title": "SQL injection vulnerability in anuko timetracker",
      "x_legacyV4Record": {
        "CVE_data_meta": {
          "ASSIGNER": "security-advisories@github.com",
          "ID": "CVE-2021-43851",
          "STATE": "PUBLIC",
          "TITLE": "SQL injection vulnerability in anuko timetracker"
        },
        "affects": {
          "vendor": {
            "vendor_data": [
              {
                "product": {
                  "product_data": [
                    {
                      "product_name": "timetracker",
                      "version": {
                        "version_data": [
                          {
                            "version_value": "\u003c 1.19.33.5607"
                          }
                        ]
                      }
                    }
                  ]
                },
                "vendor_name": "anuko"
              }
            ]
          }
        },
        "data_format": "MITRE",
        "data_type": "CVE",
        "data_version": "4.0",
        "description": {
          "description_data": [
            {
              "lang": "eng",
              "value": "Anuko Time Tracker is an open source, web-based time tracking application written in PHP. SQL injection vulnerability exist in multiple files in Time Tracker version 1.19.33.5606 and prior due to not properly checking of the \"group\" and \"status\" parameters in POST requests. Group parameter is posted along when navigating between organizational subgroups (groups.php file). Status parameter is used in multiple files to change a status of an entity such as making a project, task, or user inactive. This issue has been patched in version 1.19.33.5607. An upgrade is highly recommended. If an upgrade is not practical, introduce ttValidStatus function as in the latest version and start using it user input check blocks wherever status field is used. For groups.php fix, introduce ttValidInteger function as in the latest version and use it in the access check block in the file."
            }
          ]
        },
        "impact": {
          "cvss": {
            "attackComplexity": "LOW",
            "attackVector": "NETWORK",
            "availabilityImpact": "NONE",
            "baseScore": 8.1,
            "baseSeverity": "HIGH",
            "confidentialityImpact": "HIGH",
            "integrityImpact": "HIGH",
            "privilegesRequired": "LOW",
            "scope": "UNCHANGED",
            "userInteraction": "NONE",
            "vectorString": "CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:N",
            "version": "3.1"
          }
        },
        "problemtype": {
          "problemtype_data": [
            {
              "description": [
                {
                  "lang": "eng",
                  "value": "CWE-89: Improper Neutralization of Special Elements used in an SQL Command (\u0027SQL Injection\u0027)"
                }
              ]
            }
          ]
        },
        "references": {
          "reference_data": [
            {
              "name": "https://github.com/anuko/timetracker/security/advisories/GHSA-wx6x-6rq3-pqcc",
              "refsource": "CONFIRM",
              "url": "https://github.com/anuko/timetracker/security/advisories/GHSA-wx6x-6rq3-pqcc"
            },
            {
              "name": "https://github.com/anuko/timetracker/commit/0cf32f1046418aa2e5218b0b370064820c330c6a",
              "refsource": "MISC",
              "url": "https://github.com/anuko/timetracker/commit/0cf32f1046418aa2e5218b0b370064820c330c6a"
            },
            {
              "name": "https://github.com/anuko/timetracker/commit/94fda0cc0c9c20ab98d38ccc75ff040d13dc7f1b",
              "refsource": "MISC",
              "url": "https://github.com/anuko/timetracker/commit/94fda0cc0c9c20ab98d38ccc75ff040d13dc7f1b"
            }
          ]
        },
        "source": {
          "advisory": "GHSA-wx6x-6rq3-pqcc",
          "discovery": "UNKNOWN"
        }
      }
    }
  },
  "cveMetadata": {
    "assignerOrgId": "a0819718-46f1-4df5-94e2-005712e83aaa",
    "assignerShortName": "GitHub_M",
    "cveId": "CVE-2021-43851",
    "datePublished": "2021-12-21T23:40:10.000Z",
    "dateReserved": "2021-11-16T00:00:00.000Z",
    "dateUpdated": "2024-08-04T04:10:16.291Z",
    "state": "PUBLISHED"
  },
  "dataType": "CVE_RECORD",
  "dataVersion": "5.1"
}

Sightings

Author	Source	Type	Date	Other

Nomenclature

Seen: The vulnerability was mentioned, discussed, or observed by the user.
Confirmed: The vulnerability has been validated from an analyst's perspective.
Published Proof of Concept: A public proof of concept is available for this vulnerability.
Exploited: The vulnerability was observed as exploited by the user who reported the sighting.
Patched: The vulnerability was observed as successfully patched by the user who reported the sighting.
Not exploited: The vulnerability was not observed as exploited by the user who reported the sighting.
Not confirmed: The user expressed doubt about the validity of the vulnerability.
Not patched: The vulnerability was not observed as successfully patched by the user who reported the sighting.

Detection rules are retrieved from Rulezet.

The MITRE ATT&CK techniques below are AI-generated suggestions, inferred from the description of the vulnerability by the CIRCL/vulnerability-attack-technique-classification-roberta-base model, served locally by ML-Gateway. They have not been verified by an analyst and are provided for guidance only.
The approach is described in our paper Mapping CVEs to MITRE ATT&CK Techniques: A Curated Gold-Set Classifier and the Limits of LLM-Assisted Label Expansion.
Browse all ATT&CK techniques and the vulnerabilities related to each.

Related by attack behaviour

Vulnerabilities whose description is nearest to this one in the vector space of the CIRCL/vulnerability-attack-technique-biencoder model. This is a similarity search over the bi-encoder space (plain cosine), not a classification, and it has no measured accuracy.