Transferring the DW Cloud Users Database

Transferring the DW Cloud™ Users Database

-----------------------------------

Affected Roles: Administrator, Owner

Related Digital Watchdog VMS Apps: DW Spectrum® IPVMS

Complexity: High

Software Version: DW Spectrum® IPVMS v4.1 or higher

Last Edit: March 16, 2021

-----------------------------------

DW Cloud™ Database

Currently, DW Spectrum® IPVMS will not transfer DW Cloud™ users along with the Owner account when backing up and restoring the Server database. This means that if a DW Spectrum Server® is replaced, restoring the database will not carry over DW Cloud™ Users.

However, the database of DW Cloud™ users can be added to from a restored server by using a copy of the raw database from one Server to another.

This article will outline

**NOTE: To use this method, all associated DW Spectrum® Servers must all be using the same software version of DW Spectrum® IPVMS.

Supported/Affected Devices:

DW Blackjack® Server Series

Transferring the Raw Database with Windows

To copy the raw database from a DW Spectrum® Server in Windows:

Stop the Media Server

Right-click on the Media Server icon located in the Service Tray and select Stop Server (started).

After stopping the Media Server, navigate to the Media Server folder.

Using the File Explorer, navigate to C:\Windows\System32\config\systemprofile\AppData\Local\Digital Watchdog\Digital Watchdog Media Server

Next, copy the files ecs.sqlite and ecs_static.sqlite

Paste the database files ecs.sqlite and ecs_staticsqlite to the Server computer’s Desktop or to another safe location (e.g. USB drive, external drive, etc.)

Stop the Media Server on the new Server, then copy and paste the ecs.sqlite and ecs_static.sqlite raw database files to the same folder location on the new DW Spectrum® Server.

After copying the raw database files to the new Server, start the Media Server again on the new Server.

Right-click on the Media Server icon located in the Service Tray and select Start Server (Stopped).

The DW Cloud™ user database should now be copied from the old Server and available on the new Server.

Transferring the Raw Database with Ubuntu/Linux

To copy the raw database from a DW Spectrum® Server in Windows:

Open the Terminal (CTRL+ALT+T) application and use the following command to log in as a super user.

sudo su

Press ENTER, then enter the root password of:

**NOTE: The root password will not display as you type.

admin

Next, stop the Media Server by using:

service digitalwatchdog-mediaserver stop

After stopping the Media Server, navigate to the Media Server folder.

In the Terminal application, use the command:

cd /opt/digitalwatchdog/mediaserver/var

Copy the raw files ecs.sqlite and ecs_static.sqlite to the Desktop.

In the Terminal application, use the commands:

cp ecs.sqlite /home/dwcube/Desktop

cp ecs_static.sqlite /home/dwcube/Desktop

**NOTE: If you are using a different computer model than the DW Blackjack® Cube, then instead of “dwcube”, use the server’s model name.

You now have the raw database files copied.

For Ubuntu/Linux systems, the permissions of the file must be changed. In the Terminal application, use the commands:

cd /home/dwcube/Desktop

chmod 777 ecs.sqlite

chmod 777 ecs_static.sqlite

You may now transfer the files from the Desktop to the new Server.

Once this is done, open the Terminal application on the new Server and log in as a super user.

sudo su

Use the password

admin

Stop the Media Server on the new Server.

service digitalwatchdog-mediaserver stop

Copy the raw database files ecs.sqlite and ecs_static.sqlite from the Desktop to the same DW Spectrum Media Server file location of the new Server.

cp ecs.sqlite /opt/digitalwatchdog/mediaserver/var

cp ecs_static.sqlite /opt/digitalwatchdog/mediaserver/var

Start the Media Server on the new Server.

service digitalwatchdog-mediaserver start