7 7signal solution 69 Access point centric test profile means that all individual active tests are run against an access point at once. After all active tests of the profile are run against the access point, the profile proceeds to test against the next access point. Access point centric profile can be configured so that all active tests are run within a single association with the access point. This helps reducing workload of authentication servers.
17 7signal solution 70 Attach AP1 Ping AP1 Attach AP2 TCP download AP1 TCP upload AP1 Ping AP2 Detach AP1 Attach AP3 TCP download AP2 TCP upload AP2 Ping AP3 TCP Download AP3 Detach AP2 Attach AP1 TCP upload AP3 Managed scan Ping AP1 MOS uplink AP1 MOS uplink AP2 MOS downlink AP2 Detach AP3 Attach AP2 MOS downlink AP1 Ping AP2 Detach AP1 Detach AP2 Attach AP3 Ping AP3 MOS uplink AP3 MOS downlink AP3 Noise monitor Detach AP3 17.
17 7signal solution 71 The pre-requisite here is to have existing test profiles that shall be the target for pasting all elements in the template. This is one form of cut&paste operation. 1. 2. 3. 4. 5. 6. 7.
17 7signal solution 72 A new test profile object to the tree shall be inserted. The only input required is the name of the profile and the execution mode. 17.8 Operations on Test Profile Edit Open a pane with “Common Values” and “Name” field ready for editing. “Bound Tests” remains read-only, the elements are managed in the tree. Duplicate Create identical test profile with a new name. It is possible to change top-level parameters on the same pane.
17 7signal solution 73 Edit Open a pane with “Common Values” and “Name” field ready for editing. Copy Enable pasting of the object. Paste test profile element Paste previously copied test profile element as the last element in the profile. Remove Deletes the object. 17.10 On test elements Each test has default parameters, which can be used as is or modified as needed.
17 7signal solution 74 17.10.2 Disabling and enabling test elements A test element within test profile can be disabled. This means that the test is excluded from the test profile and the test won’t be run until it is enabled again. Disabled and enabled test profile elements can be identified by their colors (see beginning of the chapter 17). How to disable a test element: 1. Select the test element from the profile and right-click 2. Select “Disable element” How to enable a test element: 1.
17 7signal solution 75 When planning the test cycles, one should bear in mind: • The more tests there are in the sequence, the bigger the difference in sample distribution. • The more networks, the fewer samples for individual networks. 17.11 Running Test Profiles Select “Tools | Automated tests management” to see current status of Eye units. Figure 35: Automated tests management view The Eyes of the user context are enlisted in the box on the right.
17 7signal solution 76 Each automated test produces measurement data for one or more KPIs. The following table represents which automated test produces data for which KPI.
17 7signal solution Noise monitor Access point traffic Spectrum analysis Air utilization Access point radio environment Access point traffic + collect frame details option QUFR034- QUFR069 QUFR118-QUFR129 QUIP005 QUIP006 QURS026-QURS032 RE001 RE002 RE004 AC001 AC002 AC004-AC014 AV002 QUAP005 QUAP006 QUAP013 QUAP015 QUAP022 QUAP025 QUAP032-QUAP036 QUFR082-QUFR129 RE005 RE011 RE012 QURS001 QURS004-QURS008 TR001-TR003 TR012-TR015 TR018-TR023 SP001-SP004 TR030-TR040 TR138 TR050-TR060 TR100-TR137 TR140-TR145
18 7signal solution 78 Manual tests can run simultaneously with automated testing. Sapphire will perform ongoing automated test first and then run user defined manual test. Automated test will continue after manual test has been finished. Manual test results will not be saved to database. 18.1 Session events Session events can be shown from active tests (i.e. tests in which the monitoring station associates with an access point).
18 7signal solution Deauthentication: Monitoring station has deauthenticated itself from the access point o Disconnect: Monitoring station has disconnected itself from the access point o Information: Various types of information events State: State change CTRL-EVENT-*: Internal supplicant events related to e.g. EAP authentication. Source: Source MAC address causing the event. Either the MAC address of the monitoring station or the access point. Target: Destination MAC address causing the event.
18 7signal solution 80 The information in the table can be edited. Remember to save the changes.
18 7signal solution Select channel widths Select the channels to scan Select “Scan” The results are displayed in a table: a. The MAC address of the scanned devices that transmitted during the test b. The noise level and signal strength, by antenna MAC hidden Figure 39: Client scan results 9. Select “Save”; the clients detected remain in the table 10.
18 7signal solution 82 Figure 40: Saving client scan results as network clients 11. Select “Save” to save the friendly names and descriptions The data can be viewed and edited. 1. 2. 3. 4. 5. From the top menu bar, select “Manage | Network clients” To change the information, select the MAC address or name Right-click and select “Edit” Edit the information Select “Save” MAC hidden Figure 41: Editing network client 7signal Solutions, Inc., 526 S.
18 7signal solution 83 1. From the top menu bar, select “Manage | Network clients” 2. In the hierarchical tree in the left pane, right-click the topmost element, titled “Network clients” 3. Select “Add” 4. Enter a MAC alias for the client 5. Enter a user’s name, if known 6. Enter a description (optional) 7. Enter the client’s MAC address 8. Click “Save” To add several clients at once, select “Import network clients” in step 3. This option imports a text file from the Carat server’s file system.
18 7signal solution 84 7signal Sapphire Carat User Guide Release 5.0 Figure 42: Spectrum analyzer result 18.5 Noise monitor test18 You can measure the noise levels surrounding the monitoring station. 1. 2. 3. 4. 5. 6. 7. In the Network topology, select the Eye that will run the test Right-click and select “Noise Monitor” Select the scan directions – i.e.
18 7signal solution 85 7signal Sapphire Carat User Guide Release 5.0 Figure 43: Noise monitor test 18.6 Air utilization test To capture spectrum heavy-users and misconfigurations – such as extensive use of legacy codecs - in the WLAN network, air utilization test should be run. This test is not part of the default test profiles as it is lengthy troubleshoot test. Special attention to the test parameters is required as the maximum runtime is easily very high.
7signal solution The results are shown in a table that has each antenna/channel combination as one row. By activating a row on the table with the mouse, detailed results about used bitrates and frame statistics are shown on the right side of the dialog.
18 7signal solution The antenna test is used to verify the suitability of the selected antenna. Because of reflections, the network scan can show similar results for different antennas. However, during transmission of data to an access point, the differences between antennas become significant. This test is worth running if more than one antenna shows similar results. 1. In the Network topology, select a. the Eye that will run the test i.
18 7signal solution 88 7signal Sapphire Carat User Guide Release 5.0 Figure 47: Optimal antenna selection test 18.8 Download tests This test gives an indication of an access point’s TCP or UDP downlink capacity. 1. In the Network topology, select a. the Eye that will run the test i. Right-click and select ”Manual tests” ii. From the submenu select either “TCP Download Test” or “UDP Download Test” iii. Select an access point b. Or an access point through which the test will be run 21 i.
18 7signal solution 89 You can change how the test result is shown even after the test is executed. Figure 48: TCP download test 18.9 Upload tests This test gives an indication of an access point’s TCP uplink capacity. 1. In the Network topology, select a. the Eye that will run the test i. Right-click and select ”Manual tests” ii. From the submenu select either “TCP Upload Test” or “UDP Upload Test” iii. Select an access point from the pull-down menu 7signal Solutions, Inc., 526 S.
18 7signal solution 90 You can change how the test results are shown even after the test is executed. 23 24 Meaningless of Ethernet test is chosen. Only if WLAN test is chosen. 7signal Solutions, Inc., 526 S. Main Street, Akron, Ohio 44311, USA, 855-763-9526, info@7signal.com, www.7signal.com 7signal Sapphire Carat User Guide Release 5.0 b. Or an access point through which the test will be run 23 i. Right-click and select ”Manual tests” ii.
18 7signal solution 91 7signal Sapphire Carat User Guide Release 5.0 Figure 49: TCP upload test 18.10 Ping test A ping test tests the accessibility of a device, the number of packets sent and received, and latency time. 1. In the Network topology, select a. the Eye that will run the test i. Right-click and select ”Manual tests | Ping test” ii. Select an access point from the pull-down menu b. Or an access point through which the test will be run 25 i. Right-click and select ”Manual tests | Ping Test” 2.
18 7signal solution You can change how the test results are shown even after the test is executed. Figure 50: Ping test 18.11 Trace route test This test helps one perform network troubleshooting and identify routing problems or firewalls that may be blocking access to a host. 1. In the Network topology, select a. the Eye that will run the test i. Right-click and select ”Manual tests | Traceroute Test” ii. Select an access point from the pull-down menu b.
18 7signal solution 93 Maximum TTL: maximum number of devices/hops to try Queries per hop: how many times a device/hop is tried Timeout: how long to wait before giving up on a device/hop Test timeout: how long the test is allowed to be run at maximum (useful if there is a risk that the destination Sonar is unreachable) 6. Select the traffic classes to use (licensed products only) 7. Select “Execute”.
18 7signal solution 94 7signal Sapphire Carat User Guide Release 5.0 Figure 52: Access point traffic test The results are displayed in a table as seen above – the tree view in the table shows the access point as the root node, and the heard clients under it; for more information, move the mouse cursor over the individual items in the tree or, to display even more details and a graphical view, click an item in the tree.
18 7signal solution This test creates a VoIP call between Sapphire Eye and Sonar. Both uplink and downlink call quality can be measured. 1. In the Network topology, select a. the Eye that will run the test i. Right-click and select ”Manual tests | VoIP MOS test” ii. Select an access point from the pull-down menu b. Or an access point through which the test will be run29 i. Right-click and select ”Manual tests | VoIP MOS Test” 2. Select the Sonar against which you want to run the test 3.
18 7signal solution 18.13.2 MOS test result Sample result set: Figure 55: VoIP MOS test result graphs (top) 7signal Solutions, Inc., 526 S. Main Street, Akron, Ohio 44311, USA, 855-763-9526, info@7signal.com, www.7signal.com 7signal Sapphire Carat User Guide Release 5.0 5. Configure sender information: a. Enter a port for the MOS test (Local port, 0 means port allocated by the system) b. Enter the test duration in seconds (Send time) c. Enter the packet interval in milliseconds (Stream interval) d.
18 7signal solution 97 7signal Sapphire Carat User Guide Release 5.0 Figure 56: VoIP MOS test result graphs (bottom) Elements of the results image: • MOS result: The distribution of MOS values related to test duration. The color coding indicates quality. • Loss Rate: Packet loss as a function of test duration. • Average Jitter: Variation in delay as a function of test duration. • Codec: The distribution of codecs used during the test.
18 7signal solution 98 This test is used for “downloading” actual WWW-pages. Figure 57: Web page download test To run the web page download test: 1. In the Network topology, select a. the Eye that will run the test i. Right-click and select ”Manual tests | Web page download test” ii. Select an access point from the pull-down menu b. Or an access point through which the test will be run 31 i. Right-click and select ”Manual tests | Web page download test” 2. Select test type, WLAN or Ethernet a.
18 7signal solution 99 18.15 Internet Availability test This is an infrastructure test that reflects how well a WLAN or Ethernet client (Eye monitoring station) is able to utilize the Internet.
18 7signal solution 100 The result-set is three-fold: 1. General results: IP address obtained, attach time, DHCP retrieval time and gateway address. 2. Status of DNS servers 3. Results of the name resolving. 18.16 SIP Register test It is possible to run SIP Register test in both unauthorized and authorized mode. To run the SIP test: 1. In the Network topology, select a. the Eye that will run the test i. Right-click and select ”Manual tests | SIP Registration Test” ii.
18 7signal solution 101 7signal Sapphire Carat User Guide Release 5.0 Figure 59: SIP register test The test result is two-fold: test setup information and SIP specific. Test setup information contains: - attach time - DHCP retrieval time - Eye IP address used in WLAN interface - The gateway SIP results contain: - used IEEE802.
18 7signal solution 102 Packet capture test executes packet capture on selected Eye, and resulted capture file will be downloaded to PC running the Management GUI. Packet capture can be run either for a selected access point or with selected antenna, channel and capture filter. Optionally, the downloaded capture file will be automatically opened in selected packet capture viewer (e.g. Wireshark)40. Figure 60: Packet capture test 1. In the Network topology, select the Eye that will run the test 2.
18 7signal solution Optionally, select “Open after capture” check-box. Select “Execute packet capture”. Capture progress can be seen in the progress bar. After capture is completed, the capture file is available in the selected directory (and optionally opened with packet capture viewer) 7signal Solutions, Inc., 526 S. Main Street, Akron, Ohio 44311, USA, 855-763-9526, info@7signal.com, www.7signal.com 7signal Sapphire Carat User Guide Release 5.0 6. 7. 8. 9.
19 7signal solution 104 Service Level Agreement (SLA) groups a number of KPIs and their expected target values. In a nutshell, typically a KPI has a scalar value while SLA is combination of numerous KPI values and statistical rules that result in a higher-level view on the quality of the network. The ultimate goal is to bind together a contractual agreement and actual measurements, the expression of the desired or required level of the service and the proven real-life phenomena.
19 7signal solution 105 As an example, the table below explains how an SLA value is calculated for Upload Throughput KPI, its measurement and statistical analysis. Boundary value Green level above 5,5 Mbit/s 99,0% Yellow level 95,0% Red level below 95,0% The threshold value for KPI. At least 99,0% of measured samples must attain an upload throughput of at least 5,5Mbit/s in order to attain the green level for the KPI in question.
19 7signal solution 106 19.3.2 Creating an SLA group from scratch The dialog pane is identical to the case of duplicated template. Naturally the contents of the pane are empty, but the look and the process are identical. Create the SLA group as follows: 1. Click on "Manage | SLA definitions" from the top menu bar 2. Right-click on "SLA groups" from the tree hierarchy 3. Choose "Add SLA group" from pop-up menu. An SLA group editing dialog opens to the right. 4. Name the SLA group 5.
19 7signal solution Click on "Manage | SLA definitions" from the top menu bar Open “SLA Definitions” node. Right-click on the desired SLA group Choose "Set as not default group" from the pop-up menu. Suffix “(default)” will disappear from the end of the SLA group name in the tree. 19.4 SLA propagation An SLA Group can be bound to any topology element type.
19 7signal solution Link Group inherits from Location. o If the Location does not have a bound SLA Group, the Link Group inherits from parent Location or Organization, etc. Access Point inherits from Eye. o If the Eye does not have a bound SLA Group, the Access Point inherits from Service Area, etc. Eye inherits from Service Area. o If the Service Area does not have a bound SLA Group, the Service Area inherits from Location, etc. Service Area inherits from Location.
19 7signal solution 109 Figure 63: SLA Group inherited from SLA Group bound to an Eye 19.5 Binding SLA Groups 19.5.1 Binding an SLA group to a Link Bind an SLA group to a link as follows: 1. 2. 3. 4. Click on "View | Network topology" from the top menu bar Right-click on the link that you want to bind an SLA group to from the tree hierarchy Choose "Set SLA group" from the pop-up menu Choose the desired SLA group from the menu that opens Or alternatively 1. 2. 3. 4. 5.
19 7signal solution Bind an SLA group to a link group as follows: 1. Click on "View | Network topology" from the top menu bar 2. Right-click on the link group that you want to bind an SLA group to from the tree hierarchy 3. Choose "Set SLA group" from the pop-up menu 4. Choose the desired SLA group from the menu that opens Or alternatively 1. Click on "View | Network topology" from the top menu bar 2. Right-click on the link group that you want to bind an SLA group to from the tree hierarchy 3.
20 7signal solution 111 Analyzer is an interactive tool for studying network phenomena of interest and for in-depth investigation of problems. Reports in standard, easy-to-interpret formats are available to support routine monitoring. By using the report view in Carat, the user can configure reports from elements that are familiar from Analyzer. In addition to the user-selected indicators, a report configured here contains the time of compilation and delivery and a list of the delivery addresses.
20 7signal solution 112 Enter a name for the subscription Enter a description for the subscription (optional) Select an report image (optional) Choose the location for the image on the page The image will be repeated on each page of the report. It might represent, for example, a company or a target network. 7. Select the resolution (quality) to be used for the report graphics, mainly relevant to charting. In the “Report items” area: 8. Configure the items to be included in the report by selecting “Add” a.
20 7signal solution 113 7signal Sapphire Carat User Guide Release 5.0 Figure 65: Adding a report item To add a report item: 1. Choose the content type 2. Give a name to the report item a. a descriptive name is good especially if the item content groups together numerous pieces of information 3. Optionally write a description of the report item 4. Select “Next” 20.2.1 Adding SLA compliance report item 1. Select topology elements of the report item. See chapter 20.2.6. 2.
20 7signal solution 114 Figure 66: Multiple KPI chart report item 3. Select the desired KPI by left-clicking it in the right-hand pane 4. Right-click and select “Add KPI” in the submenu 5. Repeat steps 2–3 until all desired KPIs are in the left pane (depending on chart type: “Multiple KPI chart allows more than one KPI) 6. Select the Chart type 7. Select the method for displaying the measurement series in Chart content 8. Select the display method a. Data Table, Aggregation Chart 9.
20 7signal solution 115 Figure 67: Adding alarm report item 1. Select the desired alarm by left-clicking it in the right-hand pane 2. Right-click the alarm and select “Add alarm” in the submenu a. One may remind oneself about the alarm by selecting “Description” 3. Repeat steps 2–3 until all of the desired alarms are in the left pane 4. Select “Next” to continue to “Report item topology configuration”. See chapter 20.2.6. 5. Select the time interval for the report. See chapter 20.2.6. 20.2.
20 7signal solution 116 7signal Sapphire Carat User Guide Release 5.
20 7signal solution Serv NWBandServ Topology tree is used for selecting topology elements to the report item. Which topology elements can be selected depends on the chosen area aggregation. Notice that on Map report items, there must be a map configured for the Service Area.
20 7signal solution 118 At least one Service Area and Network NWBandServ At least one Service Area, Network and band of the Network NWEye At least one Network and Eye NWBand At least one Network and band of the Network 7signal Solutions, Inc., 526 S. Main Street, Akron, Ohio 44311, USA, 855-763-9526, info@7signal.com, www.7signal.com 7signal Sapphire Carat User Guide Release 5.
20 7signal solution 119 At least one Network, band of the Network and Eye Dest At least one Sonar DestAP At least one Sonar and Access Point 7signal Solutions, Inc., 526 S. Main Street, Akron, Ohio 44311, USA, 855-763-9526, info@7signal.com, www.7signal.com 7signal Sapphire Carat User Guide Release 5.
20 7signal solution DestEyeEth EyeEth At least one Sonar and Eye At least one Eye Steps for report item topology configuration: 1. Select the Area aggregation 2. From the hierarchical tree presented, select the corresponding elements depending on the selected area aggregation. 3. Click “Next” to continue to “Report item time configuration” Report item time configuration Report time configuration dialog contains time interval and time aggregation selectors.
20 7signal solution 121 1. Select the time interval for the report a. History (in the picture above)uses pre-defined intervals from the generation time backwards b. Calendar allows free interval definition 2. Time aggregation defines the averaging period for the report item 3. Click “Finish” to return to first subscription page 7signal Solutions, Inc., 526 S. Main Street, Akron, Ohio 44311, USA, 855-763-9526, info@7signal.com, www.7signal.com 7signal Sapphire Carat User Guide Release 5.
21 7signal solution 122 Import utility supports currently importing of access point names access point names when last MAC digit is zero access points by replacing existing access points in the configuration In order to import start import utility, select “Tools | Import …” from the menu. The import dialog is opened: Figure 71: Import dialog, access point name import selected Select “Import type” from drop-down menu. 21.1 Importing access point names 1.
21 7signal solution 123 21.1.1 Example access point name import ap_names.txt file contains the following BSSID-to-name mappings: SSID MAC address Alias ---- ----------- ----- 7Guest 00:17:9A:F2:2D:89 7signal-Guest-AP 7signal 58:BC:27:59:CC:20 7signal-AP-5GHz 7signal 58:BC:27:5D:8B:B0 7signal-AP-2.4GHz The file import settings and result looks like the following: 7signal Solutions, Inc., 526 S. Main Street, Akron, Ohio 44311, USA, 855-763-9526, info@7signal.com, www.7signal.
21 7signal solution Separator character is “white space” Two header lines must be ignored No ignored lines at the end of the file No comment lines MAC address is at the second column of the file AP name is at the third column of the file “Import status” field indicates that all lines were successfully imported. 21.2 Importing access point names (“last digit zero” mode) 21.2.1 Overview This import mode is useful for importing access point names to the system from e.g. Cisco controller output.
21 7signal solution 125 7signal Sapphire Carat User Guide Release 5.0 Figure 72: Import access point names, last digit zero mode 21.3 Import and replace APs This import type can be used to replace access points in the configuration. Replace is usually needed if, for example, physical access point has been replaced but the access point is wanted to be considered as the same access point in 7signal Sapphire configuration. 7signal Solutions, Inc., 526 S.
21 7signal solution 126 7signal Sapphire Carat User Guide Release 5.0 Figure 73: Replace access point by import utility 1. Select a separator character according to field separator character in the file to be imported. 2. If the file contains header lines that should be ignored, select correct number of lines in “Header ignored lines” drop-down menu. 3. If the file contains footer lines that should be ignored, select correct number of lines in “Footer ignored lines” drop-down menu. 4.
22 7signal solution 127 7signal Sapphire is capable for exporting test results and alarms to system log of the host running the Carat server. XML schemas applied can be found in Utilities directory of Carat distribution media. The Utilities directory contains three XML schema files: testresult.xsd: Test result XML schema alarm.xsd: Alarm XML schema common.xsd: Common schema used by two former schemas 22.1 Configuring Carat system logging properties carat-syslog.
22 7signal solution 128 # service rsyslog restart 22.3 Exporting test results to system log Start Management GUI and log in as solution adminstrator. 1. Select “Tool | Export…” in main menu. 2. Select “Export test results to system log” checkbox 3. Click “Save” button. Figure 74: Configuring XML alarm export If automated tests are configured and running, test results start to appear in configured system log file: Dec 4 15:31:34 localhost INFO:
22 7signal solution 129 Start Management GUI and log in as solution adminstrator. 4. Select “Tool | Export…” in main menu. 5. Select “Export alarms to system log” checkbox 6. Click “Save” button. Figure 75: Configuring XML alarm export If automated tests are configured and running, test results start to appear in configured system log file: Dec 23 14:44:50 localhost INFO:
23 7signal solution 130 There can be events on wireless networks that impact measurement results of 7signal Sapphire. Such events can be e.g. controller software update, configuration changes in access points, power level changes etc. Because the changes affect to measurement results, 7signal Sapphire provides a method, change event framework, for attaching change information to measurement results.
23 7signal solution 131 Change events are reported by using Management GUI. Figure 76: Adding a change event Select a desired topology element and right-click to open a popup menu: Access point o Select “Change events” to report a change event for the access points. o Select “Change events on this Eye” to report change event for the access point under specific Eye. o Select “Change events” to report a change for the Eye. o Select “Change events” to report a change for the link.
23 7signal solution 132 2. Enter name of the change 3. Enter description of the change (optional) 4. Select “Add change event” The added change event will appear on the list. 23.2 Viewing change events Change events related to topology elements can be viewed by right-clicking the topology element and selecting “Change events”. Alternatively, all change events logged to the 7signal Sapphire can be viewed by selecting “View | View change events” from the main menu: 23.
23 7signal solution 133 7signal Sapphire Carat User Guide Release 5.0 Figure 77: Removing change events 1. Open a. change event dialog of the desired topology element. Or b. view change event dialog from “View | View change events” 2. Select change events to be removed from the list by ticking check boxes 3. Select “Remove selected change events” 7signal Solutions, Inc., 526 S. Main Street, Akron, Ohio 44311, USA, 855-763-9526, info@7signal.com, www.7signal.
24 7signal solution 134 Test result information and other results can be transferred outside Carat in spreadsheet format and as raw or delimited text and PDFs. You can select the applications you want to use to process these files in Carat. Packet capture viewer application is also defined in this dialog. 1. 2. 3. 4. 5.
25 7signal solution In order to enable sending of automated reports and alarms to email addresses, the email server has to be configured. This setting is only for the SMTP server, the email account information is given in each of the features using the SMTP server. There can be only one SMTP per organization. Solution Administrator has visibility to all SMTP servers but local Administrators and Configurators may add only one SMTP server. 1. 2. 3. 4. 5. 6.
26 7signal solution 136 26.1 Measurement data purge In order to save disk space it is possible to purge old measurement data from the database. Available purge options are scheduled purge and instant purge. Figure 80: Database maintenance configuration 1. Select “Manage | Database maintenance” from “Manage” menu 2. In order to schedule data purge a. Select daily, weekly or monthly schedule i. If selected monthly, select day of month and time ii. If selected weekly, select day of week and time iii.
26 7signal solution 137 c. Progress can be followed from progress bar. 4. Select “Close” Figure 81: Instant measurement data purge ongoing If the database contains huge amount data that is going to be purged, the purge process may take very long time, even several days. 26.2 Database backup It is possible to backup databases in 7signal Sapphire. Given a proper backup, the system state may be recovered completely in case of system crash.
26 7signal solution 138 # 7db backup set daily 03:00 /mnt/backups Automated backup without server downtime Online backup is a circadian backup that keeps 7signal Sapphire in production while creating the backups. Database logging method must be archival logging. Example: # 7db backup set daily 03:00 /mnt/backups # 7db backup set type online Manual backup Circular logging Sapphire processes will be stopped during backup process and automatically restarted after backup has been created.
26 7signal solution 139 Infinite archive logging There is one secure way of purging the log files in the infinite archive directory. Offline backup has to be done and this comes with price of the 7signal Sapphire halt. Offline backup provides one single and unique point-in-time to be restored later. Once the offline backup exists, the log files in the infinite archive directory become obsolete and may be removed. The other option comes with no warranty whatsoever.
26 7signal solution 140 Handicaps of the default method: - no precise and secure backup (system state) to return to by default - backup process is completely manual - backup process requires downtime Method strengths: - least planning - least resource consuming First degree of backup: offline backup Most importantly this method gives fully recoverable snapshots at the desired intervals.
26 7signal solution 141 During installation there shall be various destination folders inquired by the install script. The folders are for logs, for backup files etc. As complex as online backup may sound, the setting of the online backup is easy. To maintain and keep it available and functional requires IT support that is beyond the scope of 7signal guidance.
26 7signal solution 142 NOTE: log files and databases residing in the same physical disk mean duplicate disk operation efforts on the same device. It is good design to separate logs and actual databases to different physical storage devices. Changing backup settings Install time gives the option to set all the backup related settings. To change the settings while the system is installed and in production later, please use the tool 7db and the backup sub-command.
26 7signal solution 143 The Carat management database may sometimes end up to inconsistent state because of power outages, operating system crashes, etc. 7signal Sapphire provides integritycheck tool which is used to check and repair the management database. 1. Login to the server that hosts the Carat server as root user 2. Stop the Carat server: # 7carat stop 3. Execute integrity check tool: # 7carat integritycheck 4.
26 7signal solution 144 26.4 Reorganizing measurement database In order to maintain optimal performance of the measurement database, the database needs be reorganized periodically. This can be done e.g. before offline backup. Login to the server that hosts the Carat server as root user and execute the measurement database reorganization command: # 7db reorg meas7 The reorganization tool first checks if reorganization is needed for each table. If so, it executes DB2 reorganization command.
27 7signal solution 145 7signal Sapphire supports Nagios, a commonplace open license tool for IT infrastructure monitoring. In this case Sapphire is the object of monitoring, not the monitor itself. Therefore we assume the general concepts and usage of Nagios to be well-known to the user. If this is not the case, one may start exploring the topic from the Nagios web pages (http://www.nagios.org).
27 7signal solution 146 The prerequisite is that client-side tools of Nagios have been installed on the host running 7signal Sapphire software. The protocol being used is NRPE. There is no SSH support concurrently. 27.2.1 Install NRPE daemon Use online install with yum: # yum install nrpe 27.2.2 Install toolset ‘Nagios plugins’ Use online install with yum: # yum install nagios-plugins-nrpe NOTE: the following installers shall open port tcp/5666 for Nagios traffic in the firewall settings.