Manuals / Cisco Systems / Computer Equipment / Network Router

Cisco Systems Version 1.1 manual Database Functionalities, Database Tables, Configuration Tables

Models: Version 1.1

1 110

Download 110 pages 58.42 Kb

Page 22

Image 22

Chapter2

PostgreSQL Database Operations and Functionalities

Database Functionalities

This section describes the following:

•Database Tables, page 2-4

•PostgreSQL Database Command Summary, page 2-17

Database Tables

This section describes database tables, constraints placed on each table, and relationships between tables.

Note Advanced knowledge of SQL is required to access the database through SQL commands. Use the psql interface to access an SQL prompt. For more detail on psql interface, see the postgreSQL online manual.

Configuration Tables

See AppendixB, “Data Schema,” for the database script to create database tables, constraints and relationships.

Note The configuration data must contain one record that is created when the user executes the createcsrdb command.

Cisco Carrier Sensitive Routing User Guide

2-4

Page 22

Image 22

Cisco Systems Version 1.1 manual Database Functionalities, Database Tables, Configuration Tables

Contents

800 553-NETS Fax 408 VersionCisco Systems, Inc 170 West Tasman Drive San Jose, CA Cisco Carrier Sensitive Routing User GuideCisco Carrier Sensitive Routing User Guide Copyright 2002, Cisco Systems, Inc All rights reservedOverview of Cisco Carrier Sensitive Routing PrefaceOverview PrerequisitesAdding, Modifying, and Removing Gatekeepers Saving Configuration SettingsActivating CSR Database TablesCreating Contact Lists Resetting Call AccountingCleaning Test Results Deleting Contact ListsLogging A-1 Data Schema B-1Configuration Data Schema ExamplesWho Should Use This Guide PrefaceOverview Overview, page-vii Who Should Use This Guide, page-viiDocument Organization Appendix B, “Data Schema”Appendix C, “Error Conditions and Recoveries” Document ConventionsWorld Wide Web Related Documentation and ReferencesObtaining Documentation Documentation CD-ROMCisco.com Obtaining Technical AssistanceDocumentation Feedback Technical Assistance CenterCisco TAC Web Site Cisco TAC Escalation CenterPreface Obtaining Technical Assistance Cisco Carrier Sensitive Routing User GuideCSR Limitations, page PrerequisitesPrerequisites, page CSR Components, page CSR Basics, page Overview of Cisco Carrier Sensitive RoutingCSR Components CSR BasicsPostgreSQL Database CSR ApplicationEgress Rejection Rules CSR GUIIngress Rejection Rules Selection RulesCSR Limitations CSR Limitations Carrier Sensitive Routing User Guide Chapter1Overview of Cisco Carrier Sensitive Routing Activating the Database PostgreSQL Database Operations and FunctionalitiesDatabase Operations Database Operations, page Database Functionalities, pageetc/init.d/postgresinit stop Exiting the DatabaseReactivating the Database etc/init.d/postgresinit restartExporting to a Text File Exporting a DatabaseReintializing a Database Backing Up the Database SystemDatabase Functionalities Configuration TablesDatabase Tables, page PostgreSQL Database Command Summary, page Database TablesDefault ActiveDatasettext Nameinteger ThreadCountTable2-1 Configuration Data Table continued FALSE RejectSrcUnitsboolean AllowTable2-2 Gatekeeper Table continued DefaultTable2-3 TestRoutes Table Table2-5 LogEntries Table Table2-4 TestOutputs TableTable2-6 StringResources Table 2-10 Dataset TablesTable2-7 Filters Table Table2-8 Carriers Table 2-11Table2-9 MatchPatterns Table Table2-10 Routes Table SelectPreferr edCarrier rule is used2-12 Table2-11 Rules TableName 2-13Default Type2-14 NameTable2-13 Lists Table Lists Table2-15 Table2-14 ContactLists TableName 2-16Default TypeTable2-17 QoS Table 2-17Table2-16 EgressRouteAttributes Table Table2-18 QoS TablePostgreSQL Database Command Summary 2-18Single Instance Cisco Carrier Sensitive Routing Application OperationsActivating CSR CSR as a DaemonMultiple Instances CSR as a User ProcessDeactivating CSR Chapter3 Step 4 Click Shutdown CSRFigure3-2 CSR Window Deactivating CSRCSR GUI Functionalities Activating the GUI, page Configuring CSR with the GUI, pageCSR Commands, page Multiple GUI Operation, page Activating the GUIChanging Configuration Settings, page Configuring CSR with the GUIChanging Configuration Settings Adding, Modifying, and Removing Gatekeepers, pageChapter4 CSR GUI Functionalities Configuring CSR with the GUI Changing Log LevelsFigure4-2 Configuration Management Tab in CSR Window Cisco Carrier Sensitive Routing User GuideChanging Connection Port Saving Configuration SettingsChanging App Priority Enabling Test Routes AccountingAdding, Modifying, and Removing Gatekeepers Adding GatekeepersFigure4-5 Registered Messages and Filters Checkbox Figure4-7 Filters Pop-up Menu Chapter4 CSR GUI Functionalities Configuring CSR with the GUIStep 9 Click a filter on the pop-up menu Figure4-8 Sample Filter DisplayFigure4-10 Delete Filter Display Figure4-9 Sample Filter DisplayStep 12 Click Delete Modifying Gatekeepers Removing Gatekeepers 4-10Figure4-14 Advanced Configuration Dialog Box Setting Threads for Processing Calls and Call Queue Size4-11 Figure4-13 Delete Gatekeeper MessageSwapping Datasets Updating Active Datasets4-12 Creating, Modifying, and Deleting Carriers 4-134-14 Creating CarriersFigure4-17 Carrier Selection Box in Active Dataset 4-15 Modifying CarriersFigure4-18 Dialog Box for New Carrier in Active Dataset Deleting Carriers 4-16Creating Contacts Creating, Modifying, and Deleting Contacts4-17 4-18 Modifying ContactsDeleting Contacts Figure4-22 Dialog Box for an Existing Contact in Active DatasetCreating Contact Lists Creating, Modifying, and Deleting Contact Lists4-19 4-20 Modifying Contact ListsFigure4-24 Dialog Box for an Existing Contact List in Active Dataset Creating Egress Route Attributes Creating, Modifying, and Deleting Egress Route AttributesDeleting Contact Lists 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 displayed4-23 Modifying Egress Route Attributeshour0-23min 0-60sec Chapter4 CSR GUI Functionalities Updating Active Datasets 4-24Figure4-26 List of Egress Route Attribute Names in Active Dataset Cisco Carrier Sensitive Routing User GuideDeleting Egress Route Attributes 4-25Creating Ingress Route Attributes Creating, Modifying, and Deleting Ingress Route Attributes4-26 4-27 a. If you select Daily, enter Start Time and End TimeChapter4 CSR GUI Functionalities Updating Active Datasets Modifying Ingress Route Attributes4-28 Cisco Carrier Sensitive Routing User GuideDeleting Ingress Route Attributes 4-29Creating Match Patterns Creating, Modifying, and Deleting Match Patterns4-30 4-31 Modifying Match PatternsDeleting Match Patterns Figure4-31 Dialog Box for New Match Pattern in Active DatasetCreating Routes Creating, Modifying, and Deleting Routes4-32 4-33 Modifying RoutesFigure4-33 QoS Relationships Dialog Box in Active Dataset 4-34 Deleting RoutesFigure4-34 Dialog Box for an Existing Route in Active Dataset Creating Rules Creating, Modifying, and Deleting Rules4-35 4-36 A provisioned minimum QoSModifying Rules 4-374-38 Deleting RulesFigure4-36 Dialog Box for Existing Rule in Active Dataset Verifying Datasets Updating Inactive Datasets4-39 4-40 Destroying Inactive DatasetsFigure4-37 Inactive Dataset Tab in CSR Window Cleaning Test Results, page CSR CommandsResetting Call Accounting, page Updating Gatekeepers, page Activating Inactive DatasetsSending Test Route Request Commands to an Active CSR Application 4-424-43 This entry is optionalLoading the Active Dataset Updating Logging Level4-44 Updating Gatekeepers Resetting Call AccountingCleaning Test Results 4-45Multiple GUI Operation Checking CSR Version4-46 Configuring Syslog Viewing Logs Configuring SyslogLogging Viewing Logs ExamplesSample logs AppendixA Logging Viewing Logs Cisco Carrier Sensitive Routing User GuideConfiguration Data Schema Data SchemaConfiguration Data Schema Dataset 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 AppendixB Data Schema Dataset Schema B-14Cisco Carrier Sensitive Routing User Guide Database Connectivity Loss Error Conditions and RecoveriesDatabase Connectivity Loss Gatekeeper Connectivity Loss Gatekeeper Connectivity Loss admission request message dialed number identification serviceautomatic number identification domain naming systemunregistration request message resource availability indication messageregistration request message GL-4I N D E IN-5IN-6