Nx Server Database Files

The Nx Witness Server uses a combination of database technologies to accomplish its amazing feats. Below we outline the details of each database required in order to keep your Nx Witness System up and running.

*NEVER modify database files in a System without express direction from the Nx Support Team.  

System Database (SQLite, synchronized)

The System Database is the main database that keeps a System up and running. When you create a backup of your System'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 (not synchronized)

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 (not synchronized)

Nx Server keeps Smart Search index files for all recorded video in a binary format. They're also not synced across the system and are local to the Server. Server reports this information to the rest of the System while it's online. Files are used for Smart Motion Search with a spyglass at Nx Desktop.

Database Technology: Index Files in Binary Format

Synchronized: No

Contents:

• Motion index for recorded video (binary format)

Location:

• Windows
  

  C:\Windows\System32\config\systemprofile\AppData\Local\Network Optix\Network Optix Media Server\record_catalog\metadata

• Linux
  

  /opt/networkoptix/mediaserver/var/record_catalog/metadata

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

Object Metadata (not synchronized)

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

Questions

If you have any questions related to this topic or you want to share your experience with other community members or our team, please visit and engage in our support community or reach out to your local reseller.