Advanced

Advanced

Advanced

How do I get to this page?

This page opens when you navigate to Settings, click Advanced. This page is the default view for the Advanced settings.

What’s on this page?

The Advanced page contains a variety of advanced settings, including Database, IO, Statistics, RAID, Mail Queue, Processes, Services, Core Dumps, Logs, Operations, and Expert Settings. 

Database

Advanced

How do I get to this page?

This page opens when you navigate to Settings, click Advanced, then select Database in the left sidebar.

This page refreshes automatically to reflect updated database activity. To turn this off, un-check the Auto-refresh check box in the top right area of the page.

What’s on this page?

The Database page contains information about database table size and current database activity.

The Rocket appliance stores configuration and statistical information in a set of database tables, from which the Rocket generates reports. The information on this page is for reference only, and cannot be modified.

When should I use this?

This page provides troubleshooting information for use under the direction of Lightspeed Systems support specialists.

Activity

r3-00352

The Activity grid lists the most recent database queries.

If your Reports take an unusually long time to generate, the Activity grid may help you identify long-running database queries.

Note: Use the horizontal scroll bar at the bottom of the grid to view all columns in this report.

Fields on this page

  • DATID – This is the OID (Object Identifier) of the database. This number is unique to this specific Rocket.
  • DATNAME – This is the name of the database housing the tables. The default database name is “ls”.
  • PID- Process ID of this backend
  • USESYSID – OID of the user logged into this backend
  • USENAME – Name of the user logged into this backend
  • APPLICATION_NAME – Name of the application that is connected to this backend
  • CLIENT_ADDR – IP address of the client connected to this backend. If this field is null, it indicates either that the client is connected via a UNIX socket on the server machine or that this is an internal process such as autovacuum.
  • CLIENT_HOSTNAME – Host name of the connected client, as reported by a reverse DNS lookup of client_addr. This field will only be non-null for IP connections.
  • CLIENT_PORT – TCP port number that the client is using for communication with this backend, or -1 if a Unix socket is used
  • BACKEND_START – Time when this process was started, i.e., when the client connected to the server
  • XACT_START – Time when this process’ current transaction was started, or null if no transaction is active. If the current query is the first of its transaction, this column is equal to the query_start column.
  • QUERY_START – Time when the currently active query was started, or if state is not active, when the last query was started
  • STATE_CHANGE – Time when the overall state of this backend was last changed.
  • WAITING – t (true) if this backend is currently waiting on a lock, otherwise f (false).
  • STATE – Current overall state of this backend.
  • BACKEND_XID – Top-level transaction identifier of this backend, if any.
  • BACKEND_XMIN – The current backend’s xmin
  • QUERY – Text of this backend’s most recent query. If state is active, this field shows the currently executing query. In all other states, it shows the last query that was executed.

Table Sizes

r3-00351

The Table Sizes grid lists the amount of disk space used, in megabytes, for each table in the database. If your Rocket is running out of disk space, the Table Sizes area of this page can show you which tables contain the most data.

Note: If you do not need to store a lot of data, lowering retention time is a possible solution. Be aware that lowering retention will cause a loss of data for anything older than the configured the retention time.

Category Tables

  • category_domains – Local domain categorization
  • category_ips – Local IP categorization
  • category_urls – Local URLs

Statistics Tables

  • stats_filter – Allowed/blocked statistics
  • stats_traffic_by_host – Bytes in/out statistics for internal IP address and external hosts
  • stats_traffic_by_peer – Bytes in/out stats for internal and external IP with protocol
  • stats_traffic_by_user – Bytes in/out by username
  • stats_ident – Identification statistics

Message Tables

  • archive_messages – Email archive table
  • spam_messages – All spam messages

Note: This list of tables includes all products. You can disregard table sizes for any modules that are not installed or licensed on this Rocket.

IO Statistics

How do I get to this page?

This page opens when you navigate to Settings, click Advanced, then select IO Statistics in the left sidebar.

This page refreshes automatically to reflect updated I/O activity. To turn this off, un-check the Auto-refresh check box in the top right area of the page.

What’s on this page?

This page contains a list of devices and processes currently associated with the Rocket Appliance.

When should I use this?

This page provides troubleshooting information for use under the direction of Lightspeed Systems support specialists.

Devices

Fields on this page

  • Device – The device ID (hard drive, RAID, CD drive, etc.)
  • R/S – Reads per second
  • W/S – Writes per second
  • KR/S – Reads per second in Kilobytes
  • KW/S – Writes per second in Kilobytes
  • QLEN – The number of I/O requests waiting for disk access
  • SVC_T – Average service time
  • %B – Average busy percentage

Processes (Disk I/O)

The Processes grid shows a list of disk I/O processes currently running on the Rocket server.

For a list of active RAM and CPU processes, click here.

Note: Use the horizontal scroll bar at the bottom of the grid to view all columns in this report.

Fields on this page

  • Show All – By default, the Processes grid shows processes from ??? Select (check) this checkbox to show processes from all users.
  • PID – Process ID
  • USERNAME – The name of the user that executed this process
  • VCSW – Voluntary context switches
  • IVCSW – Involuntary context switches
  • READ – The number of blocks read by this process
  • WRITE – The number of blocks written by this process
  • FAULT – The number of page faults associated with this process
  • TOTAL – The total number of I/O operations by this process
  • PERCENT – Percentage of total I/O attributed to this process
  • COMMAND – The console command that executed this process

Controller

r3raidcontroller

This table contains a summary of the RAID controller properties.

  • View Event Log – Click to view the event log for this RAID controller.

RAID

r3raidcontroller

How do I get to this page?

This page opens when you navigate to Settings, click Advanced, then select RAID in the left sidebar.

What’s on this page?

The RAID page displays data for RAID devices associated with this Rocket appliance.

When should I use this?

This page provides troubleshooting information for use under the direction of Lightspeed Systems support specialists.

Event Log

r3raidevents

How do I get to this page?

This page opens when you click Event Log on the RAID page.

What’s on this page?

This page is a log of events generated by the RAID controller, listed by day and time from newest to oldest.

When should I use this?

This page provides troubleshooting information for use under the direction of Lightspeed Systems support specialists.

Drives

r3raiddrives

This grid lists information about the drives that make up the RAID array(s) on this Rocket Appliance.

Volumes

r3raiddrives

This grid lists information about the volumes (virtual drives) that reside on the RAID array(s) on this Rocket Appliance.

Processes (Ram & CPU)

Processess RAM CPU

How do I get to this page?

This page opens when you navigate to Settings, click Advanced, then select Processes in the left sidebar. This page refreshes automatically to reflect updated activity. To turn this off, un-select the Auto-refresh check box in the top right area of the page.

What’s on this page?

The Processes page shows a list of active RAM and CPU processes (applications) currently running on the Rocket server. For a list of active Disk I/O processes, click here.

This page consists of two tabs:

When should I use this?

This page provides troubleshooting information for use under the direction of Lightspeed Systems support specialists.

Summary

r3-00676

The Summary grid contains aggregated data about the processes and services running on the Rocket Appliance.

  • last pid – The process ID number of the last process executed.
  • load averages – The load averages for the system.
  • up – The number of days, hours, minutes, and seconds since the last reboot or restart and the current local time.
  • processes – The total number of processes on the system, including running, sleeping (inactive), and zombie (defunct) processes.
  • Mem – The active, inactive, wired, cache, buffer, and free memory on the system.
  • Swap – The total, used, and free swap space on the system.

Processes grid

Processes Grid

Note: Show all, which shows all processes, is enabled by default. Un-select (uncheck) it to hide processes.

Fields on this page

  • PID – The process ID of the process
  • USERNAME – The name of the user that called the process.
  • THR – The number of threads used by this process.
  • PRI – The priority of the process.
  • NICE – The scheduling priority of the process.
  • SIZE – The actual size of the process.
  • RES – The amount of memory currently in use by the process.
  • STATE – The current state of the process.
  • C – The last CPU the ran on.
  • TIME – The number of seconds used by the process.
  • WCPU – The Weighted CPU (WCPU) utilization percentage for the process.
  • COMMAND – The console command that executed this process.

Terminating a Process

Terminating a Process

To terminate (kill) a stalled process, mouse over the process you wish to terminate, then click the X on the left side of the row.

Services

How do I get to this page?

This page opens when you navigate to Settings, click Advanced, then select Processes in the left sidebar and select the Services tab. This page refreshes automatically to reflect updated activity. To turn this off, un-check the Auto-refresh check box in the top right area of the page.

What’s on this page?

A service is a process that runs in the background and does not interact with the user interface.

The Services tab displays the name of the service and its current state (either running or stopped). Mouse over a row to restart, stop, start, or “hang up” (HUP) the service.

For services that are hyperlinked, click to view a page with more information about the service.

When should I use this?

This page provides troubleshooting information for use under the direction of Lightspeed Systems support specialists.

Redis Key Lookup

Redis Key Lookup

How do I get to this page?

This page opens when you click Redis Key Lookup on the Operations page.

When should I use this?

Use this page to browse and search the Redis database. This page provides troubleshooting information for use under the direction of Lightspeed Systems support specialists.

Core Dumps

How do I get to this page?

This page opens when you navigate to Settings, click Advanced, then select Core Dumps in the left sidebar.

What’s on this page?

A core dump is a memory image written to disk when a service crashes (terminates abnormally). Lightspeed technical support staff can analyze core dump file in a debugger to determine the cause of the crash.

The name of the core dump file consists of the service that crashed (for example, ddbUpdate), followed by “.core.” and then a numeric identifier.

Once you have identified and resolved the issue that caused the core dump, you can delete (permanently remove) the file(s) to free up disk space.

  • To download a core dump file, click the file name.
  • To delete an individual core dump file, mouse over the row containing the file, then click the small “X” button on the right side of the row.
  • To delete all core dump files, click Delete All.

When should I use this?

This page provides troubleshooting information for use under the direction of Lightspeed Systems support specialists.

Logs

How do I get to this page?

This page opens when you navigate to Settings, click Advanced, then select Logs in the left sidebar.

What’s on this page?

This page contains a list of log files generated by various components of the Lightspeed Rocket software. Click the name to view the log file.

The Verbose Logging functions generate the rui.log and db.log logs.

Note: A detailed discussion of each log file is outside the scope of this document. If you have specific questions about an entry in a log file, please contact Lightspeed Systems support.

When should I use this?

This page provides troubleshooting information for use under the direction of Lightspeed Systems support specialists.

Operations

Operations

How do I get to this page?

This page opens when you navigate to Settings, click Advanced, then select Core Dumps in the left sidebar.

What’s on this page?

Connectivity Test

How do I get to this page?

This page opens when you click Connectivity Test on the Operations page.

What’s on this page?

In order for your Rocket appliance to function correctly, it must be able to connect to Lightspeed servers over the Internet. The Connectivity page reports on current connection status to these servers.

This page shows the results of the connectivity test between your Rocket appliance and the following Lightspeed servers:

  • Lightspeed Content Database — required for content filtering
  • Lightspeed Update Server — required for Rocket software maintenance
  • Licensing — required for product license verification

When should I use this?

The Connectivity Test page can help you verify that your Rocket is able to connect to the Internet so it can filter web requests. If the Rocket is unable to connect with these servers, this indicates that one or more of the following issues is preventing communication:

  • Communication is being blocked by your firewall
  • The DNS server is configured incorrectly
  • The Rocket’s network interfaces are configured incorrectly

If your Rocket is not filtering web traffic, use the Connectivity Test to verify that its connection to the Internet is not being blocked. Here are some examples of connection errors you may encounter:

  • 1. The firewall is blocking outbound communication on a port required by the Rocket (in this case, SSH port 1999):

blockedatfirewall

  • 2. DNS error. The DNS server the Rocket is using does not have any record for the domain name (ddb.lsfilter.com) the client is looking up.

dnserror

  • Connection refused. The requested host is not resolving to the correct IP address, or the request is being redirected to a different server, which is refusing the connection.
  • Connection timed out. The Rocket was unable to connect to the requested host because the host did not respond in time to acknowledge the request.

refused

If the Connectivity Test results indicate that the Rocket is communicating with the Lightspeed servers but is still not filtering web traffic, please follow the steps in this Knowledgebase article to resolve the issue.

 

DDB Lookup

DDB Lookup

How do I get to this page?

This page opens when you click DDB Lookup on the Operations page.

When should I use this?

Use this page to test connectivity with the cloud database. This page provides troubleshooting information for use under the direction of Lightspeed Systems support specialists.

Identification Lookup

Identification Lookup

How do I get to this page?

This page opens when you click Identification Lookup on the Operations page.

When should I use this?

Use this page to verify identification details by IP address. This page provides troubleshooting information for use under the direction of Lightspeed Systems support specialists.

Reload Base DDB

Reload Base DDB

How do I get to this page?

This page opens when you click Reload Base DDB on the Operations page.

When should I use this?

Use this page to reload the local category database. This page provides troubleshooting information for use under the direction of Lightspeed Systems support specialists.

Note: If Keep Local Changes is NOT selected, the database reload will overwrite local changes and categories.

Shutdown/Restart

How do I get to this page?

This page opens when you click Shutdown/Restart on the Operations page.

Shutting down the Rocket Appliance

You should always shut down the Lightspeed Systems Rocket Appliance properly before disconnecting power. Proper shutdown protects the integrity of your configuration and data files. To shut down the Lightspeed Rocket Appliance, click Shutdown. You will be prompted to confirm your selection.

When the Lightspeed Systems Rocket Appliance is shut down, all traffic will be bypassed or blocked, depending on the Bypass on failure setting.

Caution: Although the Lightspeed Systems Rocket Appliance has several built-in features that protect data integrity in most circumstances, an improper shutdown (for example, by disconnecting the power cord while the appliance is running) may cause data loss or corruption. You should implement, and regularly test, a backup power source for your critical network servers.

Restarting the Rocket Appliance

You should only need to restart the Lightspeed Systems Rocket Appliance if you are directed to do so by Lightspeed Systems Technical Support. To restart the appliance, click Restart. You will be prompted to confirm your selection.

During the time the appliance is restarting (generally from 15 to 60 seconds, depending on hardware and software configuration), all traffic will be bypassed or blocked, depending on the Bypass on failure setting.

Redis Key Lookup Detail Page

r3-00373

How do I get to this page?

This page opens when you click Reload Base DDB on the Operations page.

When should I use this?

Use this page to view details about the selected Redis key. This page provides troubleshooting information for use under the direction of Lightspeed Systems support specialists.

Expert Settings

Expert Settings

How do I get to this page?

This page opens when you navigate to Settings, click Advanced, then select Expert Settings in the left sidebar.

What’s on this page?

This page contains infrequently-used configuration settings for the Rocket Appliance.

Activity Settings

  • Disable Report Widgets on Dashboard – Select (check) this checkbox to hide the report widgets on the Rocket dashboard.

General Settings

r3-00377

  • Force HTTPS Console – Select (check) to turn on SSL encryption when logging into the Rocket console.
  • Hide ‘Administration’ link from non-root admins – Select (check) if tier administrators should not see the Settings button in the left sidebar. This action restricts tier admins to Reports, Web Filter, and Email Management settings only, depending on the Administrator Roles assigned to their user accounts.
  • Disable Internal/External Ignore lists for non-root admins – Select (check) if tier administrators should not see the Internal Ignore List and External Ignore List settings in the Web Filter module.
  • Hide ‘Help’ links from non-root admins – The Help button on the Rocket console opens a related documentation page on the Lightspeed Community website. Select (check) If tier admins should not see the Help button on the Rocket console.
  • Use an external Help site for non-root admins – To redirect the Help link from the Lightspeed Community website to your own help pages, select (check) this option, then enter the URL for the help page you want your tier admins to see.

Report Settings

r3-00379

This setting applies to scheduled reports, and limits the report size to the number of rows specified here. Reduce this number if the Report Queue size indicates that reports are taking too long to generate.

DNS Redirect Basics

r3-00380

Use DNS Redirect to redirect search engines and video sites to “safe” versions at google.com and youtube.com.

How do I …

Adding a DNS Redirect

  • 1. Navigate to Settings, click Advanced, then select Expert Settings
  • 2. On the Expert Settings page, scroll down to DNS Redirect.

r3-00380

  • 3. In the DNS Redirect grid, click the green “+” icon. This action opens the following page:

  • 4. In the Add DNS Redirect form, edit the fields as needed.
  • 5. Click Save to apply your changes, or click Cancel to discard your changes and return to the previous page.

Configurable Fields on this Page

  • Host – Type the host name to capture and redirect in this field.
  • Select one of the following to redirect requests for this hostname:
    • forcesafesearch.google.com
    • strict.bing.com
    • restrictedmoderate.youtube.com (Moderate)
    • restricted.youtube.com (Strict)

Editing a DNS Redirect

  • 1. Navigate to Settings, click Advanced, then select Expert Settings
  • 2. On the Expert Settings page, scroll down to DNS Redirect.

r3-00380

  • 3. Click the name to edit the item. This action opens the following page:

  • In the Edit DNS Redirect form, edit the fields as needed.
  • Click Save to apply your changes, or click Cancel to discard your changes and return to the previous page.

Configurable Fields on this Page

  • Host – Type the host name to capture and redirect in this field.
  • Select one of the following to redirect requests for this hostname:
    • forcesafesearch.google.com
    • strict.bing.com
    • restrictedmoderate.youtube.com (Moderate)
    • restricted.youtube.com (Strict)

 

Deleting a DNS Redirect

  • To delete (permanently remove) an item, mouse over the item you wish to remove, then click the X on the right side of the row. You will be prompted to confirm the action.

Deleting DNS Redirect

Caution: Items deleted this way are permanently removed, and cannot be recovered.