Skip to main content

ServiceOps Application and Database Restore Procedure

Overview​

Restoring the Motadata ServiceOps Application and Database is critical to ensure business continuity in case of data loss, system failure, or migration. The restoration process involves recovering the application files, configurations, and database records from the most recent backup to minimize downtime and maintain operational efficiency.

Restore Application​

To restore the ServiceOps application, follow the below steps:

  1. Login to the terminal server.
  2. Check the status of all the services and stop the ones that are running using the below commands:
systemctl status ft-main-server.service
systemctl status ft-plugin-server.service (If the system has any plugins)
systemctl status ft-discovery-service.service (before v8.5.0)
systemctl status ft-discovery-go.service (from v8.5.0 onwards)
systemctl status ft-file-server.service
systemctl status elasticsearch.service
systemctl status nginx.service
systemctl status postgresql.service
systemctl status file-sync.service (If HA Architecture with Master Server)
systemctl stop ft-main-server.service
systemctl stop ft-plugin-server.service (If system with any plugins)
systemctl stop ft-discovery-service.service (before v8.5.0)
systemctl stop ft-discovery-go.service (from v8.5.0 onwards)
systemctl stop ft-file-server.service
systemctl stop elasticsearch.service
systemctl stop nginx.service
systemctl stop postgresql.service
systemctl stop file-sync.service (If HA Architecture with Master Server)

  1. Navigate to the home directory using the below command:

    cd /home/motadata

  2. Move into the backup directory using the below command:

    Syntax: cd backupApp_DD-MM-YYYY/

    Example: cd backupApp_12-03-2025

Restore the files in the following servers:

Restore Main Server​

  1. Navigate to the main server directory using the below command:

    cd main-server

  2. Copy the necessary files:

    cp -pr lib /opt/flotomate/main-server
    cp -pr dbs /opt/flotomate/main-server
    cp -pr config /opt/flotomate/main-server
    cp -pr filedb /opt/flotomate/main-server

Restore Analytics Server​

  1. Navigate to the analytics-server directory using the below command:

    cd ../analytics-server

  2. Copy the necessary files:

    cp -pr lib /opt/flotomate/cm-analytics
    cp -pr config /opt/flotomate/cm-analytics
    cp -pr filedb /opt/flotomate/cm-analytics

File Server Backup​

  1. Navigate to the fileserver directory using the below command:

    cd ../fileserver

  1. Copy the necessary files:

    cp -pr lib /opt/flotomate/fileserver
    cp -pr config /opt/flotomate/fileserver

Restore Chat Server​

  1. Navigate to the chat_server directory using the below command:

    cd ../chat_server

  2. Copy the necessary files:

    cp -pr *.* /opt/flotomate/chat_server

Restore Plugin Server​

  1. Navigate to the plugin-server directory using the below command:

    cd ../plugin-server

  2. Copy the necessary files:

    cp -pr plugin-server /opt/flotomate

Restore Discovery Service​

  1. Navigate to the discovery-service directory using the below command:

    cd ../discovery-service

  2. Copy the necessary files:

    cp -pr lib /opt/flotomate/discovery-service
    cp -pr config /opt/flotomate/discovery-service
    cp -pr filedb /opt/flotomate/discovery-service

Restore Other Files​

  1. Navigate to the otherfiles directory using the below command:

    cd ../otherfiles

  2. Copy the necessary files from the required folders:

Frontend Application

cp -pr frontend /opt/flotomate
chown -R fmtuser:fmtusergroup /opt/flotomate

Nginx

cp -pr nginx /etc

Security certificate and keys:

Copy only cert and key file from the ssl folder. Take the backup of cert and key file only.

cp -pr www.example.cert /etc/ssl
cp -pr www.example.key /etc/ssl

Add the SSL certificate to the fmt_nginx.conf file located in the /etc/nginx/conf.d/ folder and verify it.

Configuration files of PostgreSQL database:

cp -pr postgresql /etc
chown -R postgres:postgres /etc/postgresql

Rename the existing main folder from postgresql database (optional)

mv -pr /var/lib/postgresql/16/main /var/lib/postgresql/16/main_DD-MM-YYYY

Data files of PostgreSQL database: (optional)

cp -pr main /var/lib/postgresql/16
chown -R postgres:postgres /var/lib/postgresql/16

Restore Database​

To restore the database, follow the below steps:

Prepare for the Database Restore​

Download and move the latest database backup file to the /tmp folder using the below command:

Syntax:

mv DB_DATE_BACKUP.zip /tmp/
cd /tmp
unzip DB_DATE_BACKUP.zip

Example:

mv DB_22-03-2024_11-00-00_pm.zip /tmp
cd /tmp
unzip DB_22-03-2024_11-00-00_pm.zip

Stop Running Services​

Stop the Main Server and Analytics Server if they are running using the below commands:

systemctl stop ft-main-server
systemctl stop ft-analytics-server

Recreate the Database​

  • Login to the PostgreSQL database console using the below commands:

    su postgres
    psql

  • Drop the current database:

    drop database flotoitsmdb;

  • Create a new database:

    create database flotoitsmdb;

  • Verify the database creation:

    \l

  • Quit the PostgreSQL console:

    \q

Restore the Database​

  • Restore the database dump file into the newly created database:

    pg_restore -U postgres -d flotoitsmdb {DB_DATE_BACKUP}

    Example:

    pg_restore -U postgres -d flotoitsmdb DB_10-6-2021_11-00-00_pm

Restart Application Services​

  • Start the Main Server and Analytics Server services using the below commands:

    systemctl start ft-main-server
    systemctl start ft-analytics-server

  • Log into the application and check its functionality by accessing the various screens.