Siemens RUGGEDCOM ROS User Manual

RUGGEDCOM ROS
User Guide
Chapter 2
Using ROS
Finding the Correct Table 37
The following sections describe in more detail how to use SQL commands:
• Section 2.6.4.1, “Finding the Correct Table”
• Section 2.6.4.2, “Retrieving Information”
• Section 2.6.4.3, “Changing Values in a Table”
• Section 2.6.4.4, “Resetting a Table”
• Section 2.6.4.5, “Using RSH and SQL”
Section 2.6.4.1
Finding the Correct Table
Many SQL commands operate upon specific tables in the database, and require the table name to be specified.
Navigating the menu system in the console interface to the desired menu and pressing Ctrl-Z displays the name
of the table. The menu name and the corresponding database table name will be cited.
Another way to find a table name is to type the following in the CLI:
sql info tables
This command also displays menu names and their corresponding database table names depending upon the
features supported by the device. For example:
Table Description
-------------------------------------------------------------------------------
alarms Alarms
cpuDiags CPU Diagnostics
ethPortCfg Port Parameters
ethPortStats Ethernet Statistics
ethPortStatus Port Status
ipCfg IP Services
Section 2.6.4.2
Retrieving Information
The following describes various methods for retrieving information about tables and parameters.
Retrieving Information from a Table
Use the following command to display a summary of the parameters within a table, as well as their values:
sql select from table
Where:
• table is the name of the table
Example:
>sql select from ipAddrtable
IP Address Subnet IfIndex IfStats IfTime IfName
172.30.146.88 255.255.224.0 1001 17007888 2994 vlan1
1 records selected

Siemens RUGGEDCOM ROS Specifications

General

Brand	Siemens
Model	RUGGEDCOM ROS
Category	Control Unit
Language	English

Summary

Introduction

Overview

Provides a basic overview of the ROS software, covering its features and initial setup.

Security Recommendations and Considerations

Details important security recommendations and suggestions for device implementation on a network.

SNMP Management Interface Base (MIB) Support

Explains ROS support for standard, proprietary RUGGEDCOM MIBs, and agent capabilities for SNMP.

ModBus Management Support

Describes Modbus management support for retrieving basic status information and operator commands.

Certificate and Key Requirements

Covers requirements for loading custom SSL certificates and SSL/SSH keys in ROS.

Using ROS

Connecting to ROS

Explains various methods for connecting to the ROS device, including serial and network connections.

Using the Console Interface

Details how to use the Console interface, including navigation, parameter configuration, and commands.

Using the Command Line Interface

Describes powerful CLI commands for updating ROS, generating certificates, tracing events, and troubleshooting.

Using SQL Commands

Provides an SQL-like interface for expert users to perform operations not possible via Web or CLI.

Device Management

Viewing Product Information

Explains how to view essential device information like model, order code, and serial number.

Restoring Factory Defaults

Guides on restoring the device to its original factory default settings, either completely or partially.

Uploading/Downloading Files

Describes methods for transferring files between the device and a host computer using XMODEM, TFTP, or SFTP.

Managing Ethernet Ports

Covers setup and management of Ethernet ports, including status, statistics, and configuration.

System Administration

Configuring the System Information

Details how to configure basic information for device identification, location, and owner.

Configuring Passwords

Explains how to configure passwords for user profiles (Guest, Operator, Admin) and associated access levels.

Managing the Configuration File

Describes managing the device configuration file, including encryption and updating procedures.

Managing an Authentication Server

Guides on setting up and configuring RADIUS and TACACS+ servers for remote authentication and authorization.

Setup and Configuration

Configuring the DHCP Relay Agent

Explains how to configure the DHCP Relay Agent for forwarding DHCP packets between clients and servers.

Managing Virtual LANs

Details the concepts and management of Virtual LANs (VLANs) for network segmentation.

Managing Spanning Tree Protocol

Covers the configuration and management of Spanning Tree Protocols like RSTP and MSTP.

Managing Classes of Service

Explains how to manage Classes of Service (CoS) to expedite frame transmission based on priority.

Managing MAC Addresses

Guides on configuring and managing static and dynamic MAC addresses, including learning options.

Managing SNMP

Details SNMP versions (v1, v2c, v3) and security features, including user and group management.

Managing Multicast Filtering

Explains how to filter multicast traffic using static groups, IGMP snooping, or GMRP.

Managing Port Security

Covers port access control to filter traffic based on MAC addresses and configure IEEE 802.1X authentication.

Managing Link Aggregation

Explains how to aggregate multiple Ethernet ports into a single logical link for increased bandwidth and reliability.

Troubleshooting

General

Describes common problems and solutions related to network connectivity and device responsiveness.

Ethernet Ports

Addresses common problems related to Ethernet port operation, including duplex mismatches and link issues.

Spanning Tree

Details common problems related to Spanning Tree Protocol (STP) operation, such as network loops and topology changes.

VLANs

Discusses common problems related to VLAN configuration and inter-VLAN communication.