Manuals / Cisco Systems / Computer Equipment / Network Router

Cisco Systems Version 1.1 manual 4 TestOutputs Table, 5 LogEntries Table, 6 StringResources Table

Models: Version 1.1

1 110

Download 110 pages 58.42 Kb

Page 27

Table2-4 TestOutputs Table

Chapter2

PostgreSQL Database Operations and Functionalities

Database Functionalities

Table2-4 TestOutputs Table

		Allow
Name	Type	Null
TestKey	integer	NO
SelectOrder	integer	NO

DstCarrierID varchar(64) NO

ListKey integer NO

IsSelected

boolean

NO

Default

FALSE

Constraints

Comments

Foreign key. Key of this test (see TestRoutes table).

For a given TestKey, this shows the order in which the carriers will be returned. The database does not guarantee the original ordering.

ID of Destination Carrier.

Specifies key for the contact list associated with the particular carrier.

Specifies whether this is a selected carrier.

Table2-5 LogEntries Table

Name

TestKey

EntryOrder

LogString

Type

integer

integer

varchar(1024)

Allow

Null

NO

NO

NO

Default Constraints

Comments

Foreign key. Test key that this log file was generated for.

For a given Test key, this field is used to show the order in which the log events were generated.

The database does not guarantee the original ordering.

The log entries associated with the test run.

Caution The following table should not be modified or deleted. It consists of error messages that are logged. The CSR application does not work without this table.

Table2-6 StringResources Table

		Allow
Name	Type	Null
ResourceKey	integer	NO
ResourceString	text	NO

Default

Constraints Comments

Primary key. Key to the resource.

String (error value).

Cisco Carrier Sensitive Routing User Guide

2-9

Image 27

Cisco Systems Version 1.1 manual 4 TestOutputs Table, 5 LogEntries Table, 6 StringResources Table

Contents

Cisco Carrier Sensitive Routing User Guide VersionCisco Systems, Inc 170 West Tasman Drive San Jose, CA 800 553-NETS Fax 408Copyright 2002, Cisco Systems, Inc All rights reserved Cisco Carrier Sensitive Routing User GuidePrerequisites PrefaceOverview Overview of Cisco Carrier Sensitive RoutingDatabase Tables Saving Configuration SettingsActivating CSR Adding, Modifying, and Removing GatekeepersDeleting Contact Lists Resetting Call AccountingCleaning Test Results Creating Contact ListsExamples Data Schema B-1Configuration Data Schema Logging A-1Overview, page-vii Who Should Use This Guide, page-vii PrefaceOverview Who Should Use This GuideDocument Conventions Appendix B, “Data Schema”Appendix C, “Error Conditions and Recoveries” Document OrganizationDocumentation CD-ROM Related Documentation and ReferencesObtaining Documentation World Wide WebTechnical Assistance Center Obtaining Technical AssistanceDocumentation Feedback Cisco.comCisco TAC Escalation Center Cisco TAC Web SiteCisco Carrier Sensitive Routing User Guide Preface Obtaining Technical AssistanceOverview of Cisco Carrier Sensitive Routing PrerequisitesPrerequisites, page CSR Components, page CSR Basics, page CSR Limitations, pageCSR Basics CSR ComponentsCSR Application PostgreSQL DatabaseSelection Rules CSR GUIIngress Rejection Rules Egress Rejection RulesCSR Limitations Chapter1 CSR Limitations Carrier Sensitive Routing User GuideOverview of Cisco Carrier Sensitive Routing Database Operations, page Database Functionalities, page PostgreSQL Database Operations and FunctionalitiesDatabase Operations Activating the Databaseetc/init.d/postgresinit restart Exiting the DatabaseReactivating the Database etc/init.d/postgresinit stopBacking Up the Database System Exporting a DatabaseReintializing a Database Exporting to a Text FileDatabase Tables Configuration TablesDatabase Tables, page PostgreSQL Database Command Summary, page Database FunctionalitiesName ActiveDatasettext DefaultThreadCount integerTable2-1 Configuration Data Table continued Allow RejectSrcUnitsboolean FALSEDefault Table2-2 Gatekeeper Table continuedTable2-3 TestRoutes Table Table2-4 TestOutputs Table Table2-5 LogEntries TableTable2-6 StringResources Table Dataset Tables 2-10Table2-7 Filters Table 2-11 Table2-8 Carriers TableTable2-9 MatchPatterns Table Table2-11 Rules Table SelectPreferr edCarrier rule is used2-12 Table2-10 Routes TableType 2-13Default NameName 2-14Table2-14 ContactLists Table Lists Table2-15 Table2-13 Lists TableType 2-16Default NameTable2-18 QoS Table 2-17Table2-16 EgressRouteAttributes Table Table2-17 QoS Table2-18 PostgreSQL Database Command SummaryCSR as a Daemon Cisco Carrier Sensitive Routing Application OperationsActivating CSR Single InstanceCSR as a User Process Multiple InstancesDeactivating CSR Deactivating CSR Step 4 Click Shutdown CSRFigure3-2 CSR Window Chapter3Activating the GUI Activating the GUI, page Configuring CSR with the GUI, pageCSR Commands, page Multiple GUI Operation, page CSR GUI FunctionalitiesAdding, Modifying, and Removing Gatekeepers, page Configuring CSR with the GUIChanging Configuration Settings Changing Configuration Settings, pageCisco Carrier Sensitive Routing User Guide Changing Log LevelsFigure4-2 Configuration Management Tab in CSR Window Chapter4 CSR GUI Functionalities Configuring CSR with the GUIEnabling Test Routes Accounting Saving Configuration SettingsChanging App Priority Changing Connection PortAdding Gatekeepers Adding, Modifying, and Removing GatekeepersFigure4-5 Registered Messages and Filters Checkbox Figure4-8 Sample Filter Display Chapter4 CSR GUI Functionalities Configuring CSR with the GUIStep 9 Click a filter on the pop-up menu Figure4-7 Filters Pop-up MenuFigure4-9 Sample Filter Display Figure4-10 Delete Filter DisplayStep 12 Click Delete Modifying Gatekeepers 4-10 Removing GatekeepersFigure4-13 Delete Gatekeeper Message Setting Threads for Processing Calls and Call Queue Size4-11 Figure4-14 Advanced Configuration Dialog BoxUpdating Active Datasets Swapping Datasets4-12 4-13 Creating, Modifying, and Deleting CarriersCreating Carriers 4-14Figure4-17 Carrier Selection Box in Active Dataset Modifying Carriers 4-15Figure4-18 Dialog Box for New Carrier in Active Dataset 4-16 Deleting CarriersCreating, Modifying, and Deleting Contacts Creating Contacts4-17 Figure4-22 Dialog Box for an Existing Contact in Active Dataset Modifying ContactsDeleting Contacts 4-18Creating, Modifying, and Deleting Contact Lists Creating Contact Lists4-19 Modifying Contact Lists 4-20Figure4-24 Dialog Box for an Existing Contact List in Active Dataset 4-21 Creating, Modifying, and Deleting Egress Route AttributesDeleting Contact Lists Creating Egress Route AttributesThe key shown on the screen is the primary key of this egress route attribute in the Egress Route Attributes table. When a new egress route attribute is being created, “%%%%” is displayed 4-22Modifying Egress Route Attributes 4-23hour0-23min 0-60sec Cisco Carrier Sensitive Routing User Guide 4-24Figure4-26 List of Egress Route Attribute Names in Active Dataset Chapter4 CSR GUI Functionalities Updating Active Datasets4-25 Deleting Egress Route AttributesCreating, Modifying, and Deleting Ingress Route Attributes Creating Ingress Route Attributes4-26 a. If you select Daily, enter Start Time and End Time 4-27Cisco Carrier Sensitive Routing User Guide Modifying Ingress Route Attributes4-28 Chapter4 CSR GUI Functionalities Updating Active Datasets4-29 Deleting Ingress Route AttributesCreating, Modifying, and Deleting Match Patterns Creating Match Patterns4-30 Figure4-31 Dialog Box for New Match Pattern in Active Dataset Modifying Match PatternsDeleting Match Patterns 4-31Creating, Modifying, and Deleting Routes Creating Routes4-32 Modifying Routes 4-33Figure4-33 QoS Relationships Dialog Box in Active Dataset Deleting Routes 4-34Figure4-34 Dialog Box for an Existing Route in Active Dataset Creating, Modifying, and Deleting Rules Creating Rules4-35 A provisioned minimum QoS 4-364-37 Modifying RulesDeleting Rules 4-38Figure4-36 Dialog Box for Existing Rule in Active Dataset Updating Inactive Datasets Verifying Datasets4-39 Destroying Inactive Datasets 4-40Figure4-37 Inactive Dataset Tab in CSR Window Activating Inactive Datasets CSR CommandsResetting Call Accounting, page Updating Gatekeepers, page Cleaning Test Results, page4-42 Sending Test Route Request Commands to an Active CSR ApplicationThis entry is optional 4-43Updating Logging Level Loading the Active Dataset4-44 4-45 Resetting Call AccountingCleaning Test Results Updating GatekeepersChecking CSR Version Multiple GUI Operation4-46 Configuring Syslog Configuring Syslog Viewing LogsLogging Examples Viewing LogsSample logs Cisco Carrier Sensitive Routing User Guide AppendixA Logging Viewing LogsData Schema Configuration Data SchemaConfiguration Data Schema Dataset Schema Page Page Page Dataset Schema Page Page Cisco Carrier Sensitive Routing User Guide Page CHECK RelativeQoS = 1 AND RelativeQoS = B-10B-11 B-12 B-13 B-14 AppendixB Data Schema Dataset SchemaCisco Carrier Sensitive Routing User Guide Error Conditions and Recoveries Database Connectivity LossDatabase Connectivity Loss Gatekeeper Connectivity Loss Gatekeeper Connectivity Loss domain naming system dialed number identification serviceautomatic number identification admission request messageGL-4 resource availability indication messageregistration request message unregistration request messageIN-5 I N D EIN-6