Manuals / Cisco Systems / Computer Equipment / Network Router

Cisco Systems Version 1.1 manual 2-15, 13 Lists Table, 14 ContactLists Table

Models: Version 1.1

1 110

Download 110 pages 58.42 Kb

Page 33

Image 33

Chapter2

PostgreSQL Database Operations and Functionalities

Database Functionalities

Lists Table

Table2-13 Lists Table

Name	Type
ListKey	integer
ListName	text

Allow

Null

Default

Constraints

<> 0

Comments

Primary key. Key of the list.

Name of the list.

Note Tables Lists_1 and Lists_2 can inherit from the Lists table.

Table2-14 ContactLists Table

		Allow
Name	Type	Null
ListKey	NO
ContactKey	NO

Default

Constraints

Comments

Foreign key. Key of the list.

Foreign key. Key of the contact.

Note Tables ContactLists_1 and ContactLists_2 can inherit from this table.

Table2-15 RouteAttributes Table

		Allow
Name	Type	Null
AttributeKey	integer	NO
AttributeName	text
CarrierKey	integer	NO

Default Constraints

<>0

Comments

Primary key. Key of the route attribute.

Name of attribute associated with the route.

Foreign key. Key of the carrier associated with this route attribute.

Cisco Carrier Sensitive Routing User Guide

2-15

Page 33

Image 33

Cisco Systems Version 1.1 manual 2-15, 13 Lists Table, 14 ContactLists Table, 15 RouteAttributes Table

Contents

Cisco Systems, Inc 170 West Tasman Drive San Jose, CA Version800 553-NETS Fax 408 Cisco Carrier Sensitive Routing User GuideCopyright 2002, Cisco Systems, Inc All rights reserved Cisco Carrier Sensitive Routing User GuideOverview PrefaceOverview of Cisco Carrier Sensitive Routing PrerequisitesActivating CSR Saving Configuration SettingsAdding, Modifying, and Removing Gatekeepers Database TablesCleaning Test Results Resetting Call AccountingCreating Contact Lists Deleting Contact ListsConfiguration Data Schema Data Schema B-1Logging A-1 ExamplesOverview PrefaceWho Should Use This Guide Overview, page-vii Who Should Use This Guide, page-viiAppendix C, “Error Conditions and Recoveries” Appendix B, “Data Schema”Document Organization Document ConventionsObtaining Documentation Related Documentation and ReferencesWorld Wide Web Documentation CD-ROMDocumentation Feedback Obtaining Technical AssistanceCisco.com Technical Assistance CenterCisco TAC Escalation Center Cisco TAC Web SiteCisco Carrier Sensitive Routing User Guide Preface Obtaining Technical AssistancePrerequisites, page CSR Components, page CSR Basics, page PrerequisitesCSR Limitations, page Overview of Cisco Carrier Sensitive RoutingCSR Basics CSR ComponentsCSR Application PostgreSQL DatabaseIngress Rejection Rules CSR GUIEgress Rejection Rules Selection RulesCSR Limitations Chapter1 CSR Limitations Carrier Sensitive Routing User GuideOverview of Cisco Carrier Sensitive Routing Database Operations PostgreSQL Database Operations and FunctionalitiesActivating the Database Database Operations, page Database Functionalities, pageReactivating the Database Exiting the Databaseetc/init.d/postgresinit stop etc/init.d/postgresinit restartReintializing a Database Exporting a DatabaseExporting to a Text File Backing Up the Database SystemDatabase Tables, page PostgreSQL Database Command Summary, page Configuration TablesDatabase Functionalities Database Tablestext ActiveDatasetDefault NameThreadCount integerTable2-1 Configuration Data Table continued boolean RejectSrcUnitsFALSE AllowDefault 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 2-12 SelectPreferr edCarrier rule is usedTable2-10 Routes Table Table2-11 Rules TableDefault 2-13Name TypeName 2-142-15 Lists TableTable2-13 Lists Table Table2-14 ContactLists TableDefault 2-16Name TypeTable2-16 EgressRouteAttributes Table 2-17Table2-17 QoS Table Table2-18 QoS Table2-18 PostgreSQL Database Command SummaryActivating CSR Cisco Carrier Sensitive Routing Application OperationsSingle Instance CSR as a DaemonCSR as a User Process Multiple InstancesDeactivating CSR Figure3-2 CSR Window Step 4 Click Shutdown CSRChapter3 Deactivating CSRCSR Commands, page Multiple GUI Operation, page Activating the GUI, page Configuring CSR with the GUI, pageCSR GUI Functionalities Activating the GUIChanging Configuration Settings Configuring CSR with the GUIChanging Configuration Settings, page Adding, Modifying, and Removing Gatekeepers, pageFigure4-2 Configuration Management Tab in CSR Window Changing Log LevelsChapter4 CSR GUI Functionalities Configuring CSR with the GUI Cisco Carrier Sensitive Routing User GuideChanging App Priority Saving Configuration SettingsChanging Connection Port Enabling Test Routes AccountingAdding Gatekeepers Adding, Modifying, and Removing GatekeepersFigure4-5 Registered Messages and Filters Checkbox Step 9 Click a filter on the pop-up menu Chapter4 CSR GUI Functionalities Configuring CSR with the GUIFigure4-7 Filters Pop-up Menu Figure4-8 Sample Filter DisplayFigure4-9 Sample Filter Display Figure4-10 Delete Filter DisplayStep 12 Click Delete Modifying Gatekeepers 4-10 Removing Gatekeepers4-11 Setting Threads for Processing Calls and Call Queue SizeFigure4-14 Advanced Configuration Dialog Box Figure4-13 Delete Gatekeeper MessageUpdating 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 Deleting Contacts Modifying Contacts4-18 Figure4-22 Dialog Box for an Existing Contact in Active DatasetCreating, 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 Deleting Contact Lists Creating, Modifying, and Deleting Egress Route AttributesCreating Egress Route Attributes 4-21The 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 Figure4-26 List of Egress Route Attribute Names in Active Dataset 4-24Chapter4 CSR GUI Functionalities Updating Active Datasets Cisco Carrier Sensitive Routing User Guide4-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-274-28 Modifying Ingress Route AttributesChapter4 CSR GUI Functionalities Updating Active Datasets Cisco Carrier Sensitive Routing User Guide4-29 Deleting Ingress Route AttributesCreating, Modifying, and Deleting Match Patterns Creating Match Patterns4-30 Deleting Match Patterns Modifying Match Patterns4-31 Figure4-31 Dialog Box for New Match Pattern in Active DatasetCreating, 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 Resetting Call Accounting, page Updating Gatekeepers, page CSR CommandsCleaning Test Results, page Activating Inactive Datasets4-42 Sending Test Route Request Commands to an Active CSR ApplicationThis entry is optional 4-43Updating Logging Level Loading the Active Dataset4-44 Cleaning Test Results Resetting Call AccountingUpdating Gatekeepers 4-45Checking 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 automatic number identification dialed number identification serviceadmission request message domain naming systemregistration request message resource availability indication messageunregistration request message GL-4IN-5 I N D EIN-6