The Nx Witness Mediaserver application uses a combination of databases to accomplish its amazing features. Below, we outline the details of each database required in order to keep your Nx Witness System up and running.

NOTE: Never modify database files in a System without an explicit request from the Nx Support Team.  

Site Database (SQLite, synchronized)

The Site Database is the main database that keeps a Site up and running. When you create a backup of your Site's database - this is what gets backed up.

Database Technology: SQLite

Synchronized: Yes

Contents:

• User Rights & Settings
• System Settings
• Device Configuration

Database Location: 

• Windows

  C:\Windows\System32\config\systemprofile\AppData\Local\Network Optix\Network Optix Media Server\ecs.sqlite

• Ubuntu

  /opt/networkoptix/mediaserver/var/ecs.sqlite

Server Database

The Server Database is a local database that keeps track of all events, bookmarks and operator actions. It's local for every Server and is not synchronized.

Database Technology: SQLite

Synchronized: No

Database Location: 

• Windows

  C:\Windows\System32\config\systemprofile\AppData\Local\Network Optix\Network Optix Media Server\mserver.sqlite

• Ubuntu

  /opt/networkoptix/mediaserver/var/mserver.sqlite

Archive Index

Database Technology: .NXDB (proprietary)

Synchronized: No

Contents:

• Storage index for recorded video (used for recall and timeline)

Location:

• Next to recorded archives (on the same drive)

Smart Motion Index 

The Nx Mediaserver keeps the Smart Search index files for all recorded video in a binary format. They're also not synced across the Site and are local to the Server. The Server reports this information to the rest of the System while it's online. 

Database Technology: Index Files in Binary Format

Synchronized: No

Contents:

• Motion index for recorded video (binary format)

Location:

• Windows

   C:\HD Witness Media\server UUID\motion_data

• Linux

  /opt/company name/mediaserver/var/server UUID/motion_data

 # Use physical ID to find the corresponding folder. (Follow the article and search "physical Id").

Object Metadata

A set of different files that are used to store information about the objects generated by the analytics plugins. These files are required to visualize the detection on the timeline and to form a response to the search queries (in the search bar or over the API).

Synchronized: No

Contents:

• Objects index
• Various objects metadata

Location:

• User-defined  archive directory
  • "archive" - subdirectory with a particular structure
  • "object_detection.sqlite*" - set of files with metadata inside