Configuring Automatic Monitoring of CTP Platforms (CTPView)

You can configure certain monitoring operations to be automatically performed on the CTP platforms in the network. You manage these operations in the CTPView Automatic Functions window. This window displays a summary table of the currently configured automatic settings for the connected CTP platform. Table 1 describes the information provided in the table. From this window you can add and remove automatic operations for the CTP platform, and configure the monitoring details.

Table 1: Current CTPView Automatic Settings
Field	Description
Action	One of the following monitoring operations: Backup Current PostgreSQL Database. Gather Remote Host Statistical Data—Retrieves the data used to create the plots of IP Buffer Usage, Delay Jitter, Round Trip Delay, and Missing Packets. Update Network Interface Device Information—Collects network interface device information. Use this automatic function if you configure virtual IP addresses using the CLI or if you use multiple CTPView servers to configure CTP platforms and virtual IP addresses. Remove Outdated Files—Removes older files (typically CTP platform statistical data) based on the age of the data. The age criterion can be set to 6, 9, or 12 months. We recommend that you configure this automatic function to ensure that the file system does not become filled. Synchronize Secondary Servers—Copies information from the primary server to each secondary server. The information includes SSH keys, archived port configurations, email notifications, port forwarding settings, trigger point for hard drive usage warning level, and CTP platform identification information (IP address, hostname, group name). Synchronize Secondary Servers and Remote Hosts—Copies information from the primary server to each secondary server and CTP platform. The information transferred to the secondary servers includes SSH keys, archived port configurations, email notifications, port forwarding settings, trigger point for hard drive warning usage level, CTP identification information (IP address, hostname, group name), and CTP statistical data. The function copied from the primary server to CTP platforms includes each secondary server’s SSH key. Save Current CTP Host System Configuration—Saves every CTP platform configuration at the specified time interval. CTPView will save the 10 most recent configurations.
Minute	Minute of the hour when the operation is scheduled to take place.
Hour	Hour of the day when the operation is scheduled to take place.
Day	Date when the operation is scheduled to take place.
Month	Month when the operation is scheduled to take place.
Day of Week	Day of the week when the operation is scheduled to take place.

Accessing the CTPView Automatic Functions Window (CTPView)

To configure automatic functions:

In the side pane, select Server > Administration.
The Administrative Functions pane is displayed.
Click Automatic Functions.
The CTPView Automatic Functions window is displayed.

Adding an Automatic Monitoring Operation (CTPView)

To add an automatic monitoring operation:

In the CTPView Automatic Functions window, select an action.
Select when you want the operation to take place.
The numbers you select represent a specific time, not an interval of time. For example, the default setting of [0,1,ANY,ANY,ANY] means that action occurs at the 0 minute (on the hour) of the first hour (1 AM) every day (any day of any month, landing on any day of the week). A setting of [30,16,8,ANY,ANY] causes the action to occur at 4:30 PM on the 8th of every month.
Click Add New Entry; the operation appears in the summary table.
If you decide not to add the entry, click Reset.

To have the same function performed at different times, add a new entry for that operation for each time.

Removing an Automatic Monitoring Operation (CTPView)

To remove an automatic monitoring operation:

In the summary table in the CTPView Automatic Functions window, click the Remove checkbox for each action you want to remove.
Click Remove Selected Lines; the operation disappears from the summary table.

Backing Up MySQL Database and Restoring in PostgreSQL (CTPView Server CLI)

Starting from CTPView 7.3R6 release, CTPView server uses PostgreSQL database and does not support MySQL database. You can backup the current MySQL database data and restore it in the PostgreSQL database while migrating from CTPView 7.3R5 or earlier release to CTPView 7.3R6 or later release.

To backup the current MySQL database data and restore it in the PostgreSQL database:

Log in to the CTPView Server of release 7.3R5 or earlier.
Copy the backup_mysql_db.tcsh script which is located at /data/archive/gui/GUI_7.3R6 to the /tmp directory.
Go to the /tmp directory and run the script.
You need to provide the password of MySQL Apache user account as an argument to run this script. If no password argument is provided, the script automatically takes the default password “CTPView-2-2”.
The created backup file is stored at /var/www/html/acorn/backup_files/backup_mysql.sql.
Copy the created backup file to the /tmp directory of CTPView server release 7.3R6 or later.
Log in to the CTPView server of release 7.3R6 or later and access the CTPView Configuration Menu.
Select PostgreSQL Functions, and then select Restore Backup in PostgreSQL.

Select Restore MySQL Backup. An error message will be displayed if the backup file is not available in the /tmp directory.

After successful restoration, you can log in to the CTPView GUI and verify the database entries under the CTPView Admin Centre.

Backing Up and Restoring PostgreSQL Database (CTPView)

To backup and restore the current PostgreSQL database data:

Note:

Starting from CTPView 7.3R6 release, CTPView server uses PostgreSQL database and does not support MySQL database.

Log in to the CTPView GUI.
In the CTPView Automatic Functions window, select the action Backup Current PostgreSQL Database.
Select the date and time when you want the operation to take place.
The numbers you select represent a specific time, not an interval of time. For example, the default setting of [0,1,ANY,ANY,ANY] means that action occurs at the 0 minute (on the hour) of the first hour (1 AM) every day (any day of any month, landing on any day of the week). A setting of [30,16,8,ANY,ANY] causes the action to occur at 4:30 PM on the 8th of every month.
Click Add New Entry; the backup operation appears in the summary table. After the backup operation is complete, verify that the backup file is created in /var/www/html/acorn/backup_files.
In the following example, pgsql_0 is the created backup file.
Log in to the CTPView server and access the CTPView Configuration Menu.
Select PostgreSQL Functions, and then select Restore Backup in PostgreSQL.
Select Restore PostgreSQL Backup. This lists the available PostgreSQL backup files.

Select the PostgreSQL backup file you want to restore.