Manuals / Cisco Systems / Computer Equipment / Network Router

Cisco Systems Version 1.1 manual 2-14, Name

Models: Version 1.1

1 110

Download 110 pages 58.42 Kb

Page 32

2-14

Chapter2

PostgreSQL Database Operations and Functionalities

Database Functionalities

Table2-11 Rules Table (continued)
			Allow
			Allow
Name		Type	Null
SelectPreferredCarrier		integer	NO
SelectPercentageEgress		integer	NO

Default

0

0

Constraints	Comments
>= 0 and <= 5	Specifies
	preferred
	carrier.
>= 0 and <= 5	Specifies
	egress
	percentage.

Note Tables Rules_1 and Rules_2 can inherit from the Rules table.

Table2-12 Contacts Table

Name

ContactKey

RASAddress AddressType

	Allow
Type	Null
integer	NO
varchar(64)	NO
text	NO

Default

Constraints

<> 0

Valid values:

•ipv4

•gkid

•dnsname

Comments

Primary key. Key of the contact.

RAS address.

Type of address (IP address, gatekeeper ID, or DNS name).

The CSR converts the DNS name to IP address. When you use the DNS name, a DNS server must be available. Otherwise, this value is not used.

Cost	integer	>= 0
Priority	integer	>= 0

Specifies desired cost.

Specifies desired priority.

Note Tables Contacts_1 and Contacts_2 can inherit from the Contacts table.

Cisco Carrier Sensitive Routing User Guide

2-14

Image 32

Cisco Systems Version 1.1 manual 2-14, Name

Contents

Version Cisco Systems, Inc 170 West Tasman Drive San Jose, CA800 553-NETS Fax 408 Cisco Carrier Sensitive Routing User GuideCisco Carrier Sensitive Routing User Guide Copyright 2002, Cisco Systems, Inc All rights reservedPreface OverviewOverview of Cisco Carrier Sensitive Routing PrerequisitesSaving Configuration Settings Activating CSRAdding, Modifying, and Removing Gatekeepers Database TablesResetting Call Accounting Cleaning Test ResultsCreating Contact Lists Deleting Contact ListsData Schema B-1 Configuration Data SchemaLogging A-1 ExamplesPreface OverviewWho Should Use This Guide Overview, page-vii Who Should Use This Guide, page-viiAppendix B, “Data Schema” Appendix C, “Error Conditions and Recoveries”Document Organization Document ConventionsRelated Documentation and References Obtaining DocumentationWorld Wide Web Documentation CD-ROMObtaining Technical Assistance Documentation FeedbackCisco.com Technical Assistance CenterCisco TAC Web Site Cisco TAC Escalation CenterPreface Obtaining Technical Assistance Cisco Carrier Sensitive Routing User GuidePrerequisites Prerequisites, page CSR Components, page CSR Basics, pageCSR Limitations, page Overview of Cisco Carrier Sensitive RoutingCSR Components CSR BasicsPostgreSQL Database CSR ApplicationCSR GUI Ingress Rejection RulesEgress Rejection Rules Selection RulesCSR Limitations Overview of Cisco Carrier Sensitive Routing Chapter1CSR Limitations Carrier Sensitive Routing User Guide PostgreSQL Database Operations and Functionalities Database OperationsActivating the Database Database Operations, page Database Functionalities, pageExiting the Database Reactivating the Databaseetc/init.d/postgresinit stop etc/init.d/postgresinit restartExporting a Database Reintializing a DatabaseExporting to a Text File Backing Up the Database SystemConfiguration Tables Database Tables, page PostgreSQL Database Command Summary, pageDatabase Functionalities Database TablesActiveDataset textDefault NameTable2-1 Configuration Data Table continued ThreadCountinteger RejectSrcUnits booleanFALSE AllowTable2-3 TestRoutes Table DefaultTable2-2 Gatekeeper Table continued Table2-6 StringResources Table Table2-4 TestOutputs TableTable2-5 LogEntries Table Table2-7 Filters Table Dataset Tables2-10 Table2-9 MatchPatterns Table 2-11Table2-8 Carriers Table SelectPreferr edCarrier rule is used 2-12Table2-10 Routes Table Table2-11 Rules Table2-13 DefaultName Type2-14 NameLists Table 2-15Table2-13 Lists Table Table2-14 ContactLists Table2-16 DefaultName Type2-17 Table2-16 EgressRouteAttributes TableTable2-17 QoS Table Table2-18 QoS TablePostgreSQL Database Command Summary 2-18Cisco Carrier Sensitive Routing Application Operations Activating CSRSingle Instance CSR as a DaemonMultiple Instances CSR as a User ProcessDeactivating CSR Step 4 Click Shutdown CSR Figure3-2 CSR WindowChapter3 Deactivating CSRActivating the GUI, page Configuring CSR with the GUI, page CSR Commands, page Multiple GUI Operation, pageCSR GUI Functionalities Activating the GUIConfiguring CSR with the GUI Changing Configuration SettingsChanging Configuration Settings, page Adding, Modifying, and Removing Gatekeepers, pageChanging Log Levels Figure4-2 Configuration Management Tab in CSR WindowChapter4 CSR GUI Functionalities Configuring CSR with the GUI Cisco Carrier Sensitive Routing User GuideSaving Configuration Settings Changing App PriorityChanging Connection Port Enabling Test Routes AccountingAdding, Modifying, and Removing Gatekeepers Adding GatekeepersFigure4-5 Registered Messages and Filters Checkbox Chapter4 CSR GUI Functionalities Configuring CSR with the GUI Step 9 Click a filter on the pop-up menuFigure4-7 Filters Pop-up Menu Figure4-8 Sample Filter DisplayStep 12 Click Delete Figure4-9 Sample Filter DisplayFigure4-10 Delete Filter Display Modifying Gatekeepers Removing Gatekeepers 4-10Setting Threads for Processing Calls and Call Queue Size 4-11Figure4-14 Advanced Configuration Dialog Box Figure4-13 Delete Gatekeeper Message4-12 Updating Active DatasetsSwapping Datasets Creating, Modifying, and Deleting Carriers 4-13Figure4-17 Carrier Selection Box in Active Dataset Creating Carriers4-14 Figure4-18 Dialog Box for New Carrier in Active Dataset Modifying Carriers4-15 Deleting Carriers 4-164-17 Creating, Modifying, and Deleting ContactsCreating Contacts Modifying Contacts Deleting Contacts4-18 Figure4-22 Dialog Box for an Existing Contact in Active Dataset4-19 Creating, Modifying, and Deleting Contact ListsCreating Contact Lists Figure4-24 Dialog Box for an Existing Contact List in Active Dataset Modifying Contact Lists4-20 Creating, Modifying, and Deleting Egress Route Attributes Deleting Contact ListsCreating Egress Route Attributes 4-214-22 The 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 displayedhour0-23min 0-60sec Modifying Egress Route Attributes4-23 4-24 Figure4-26 List of Egress Route Attribute Names in Active DatasetChapter4 CSR GUI Functionalities Updating Active Datasets Cisco Carrier Sensitive Routing User GuideDeleting Egress Route Attributes 4-254-26 Creating, Modifying, and Deleting Ingress Route AttributesCreating Ingress Route Attributes 4-27 a. If you select Daily, enter Start Time and End TimeModifying Ingress Route Attributes 4-28Chapter4 CSR GUI Functionalities Updating Active Datasets Cisco Carrier Sensitive Routing User GuideDeleting Ingress Route Attributes 4-294-30 Creating, Modifying, and Deleting Match PatternsCreating Match Patterns Modifying Match Patterns Deleting Match Patterns4-31 Figure4-31 Dialog Box for New Match Pattern in Active Dataset4-32 Creating, Modifying, and Deleting RoutesCreating Routes Figure4-33 QoS Relationships Dialog Box in Active Dataset Modifying Routes4-33 Figure4-34 Dialog Box for an Existing Route in Active Dataset Deleting Routes4-34 4-35 Creating, Modifying, and Deleting RulesCreating Rules 4-36 A provisioned minimum QoSModifying Rules 4-37Figure4-36 Dialog Box for Existing Rule in Active Dataset Deleting Rules4-38 4-39 Updating Inactive DatasetsVerifying Datasets Figure4-37 Inactive Dataset Tab in CSR Window Destroying Inactive Datasets4-40 CSR Commands Resetting Call Accounting, page Updating Gatekeepers, pageCleaning Test Results, page Activating Inactive DatasetsSending Test Route Request Commands to an Active CSR Application 4-424-43 This entry is optional4-44 Updating Logging LevelLoading the Active Dataset Resetting Call Accounting Cleaning Test ResultsUpdating Gatekeepers 4-454-46 Checking CSR VersionMultiple GUI Operation Logging Configuring SyslogConfiguring Syslog Viewing Logs Viewing Logs ExamplesSample logs AppendixA Logging Viewing Logs Cisco Carrier Sensitive Routing User GuideConfiguration Data Schema Dataset Schema Data SchemaConfiguration Data Schema Page Page Page Dataset Schema Page Page Cisco Carrier Sensitive Routing User Guide Page B-10 CHECK RelativeQoS = 1 AND RelativeQoS =B-11 B-12 B-13 Cisco Carrier Sensitive Routing User Guide B-14AppendixB Data Schema Dataset Schema Database Connectivity Loss Gatekeeper Connectivity Loss Error Conditions and RecoveriesDatabase Connectivity Loss Gatekeeper Connectivity Loss dialed number identification service automatic number identificationadmission request message domain naming systemresource availability indication message registration request messageunregistration request message GL-4I N D E IN-5IN-6