Manuals / Cisco Systems / Computer Equipment / Network Router

Cisco Systems Version 1.1 ActiveDataset, text, Name, Type, Null, Default, Constraints, Comments

Models: Version 1.1

1 110

Download 110 pages 58.42 Kb

Page 23

Name

Chapter2

PostgreSQL Database Operations and Functionalities

Database Functionalities

Table2-1 Configuration Data Table

		Allow
Name	Type	Null
ActiveDataset	text	NO

LoggingLevel

text

NO

CSR_ID

varchar(64) NO

CSR_Version	text
GKTMP_Version	integer
Priority	integer	NO
ListenPort	integer

Default

‘_1’

‘Error’

1

Constraints

Valid values:

•_1

•_2

Valid values:

•error

•info

•debug

>=1

>0 and < 32767

Comments

There are two datasets in the CSR (active and inactive). There are two of each table for entities that are created (for example, Carriers_1, Carriers_2). The active dataset marks which of the above is active.

When the application, is active, logs are generated. This marks the level of logging that is being done. During realtime, this runs only at error level to avoid performance deterioration.

ID used to register with the gatekeeper which application is connecting. (Also known as the application ID).

Version of CSR. This is entered when the GUI requests it from the CSR.

Version of GKTMP. This is entered when the GUI requests it from the CSR.

Priority to register this application to the gatekeeper.

TCP port to listen for incoming connection. A gatekeeper or simulator may connect to the CSR, and this is the port to connect to.

Cisco Carrier Sensitive Routing User Guide

2-5

Image 23

Cisco Systems Version 1.1 manual ActiveDataset, text, Name, Type, Null, Default, Constraints, Comments

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 Overview of Cisco Carrier Sensitive Routing Chapter1CSR Limitations Carrier Sensitive Routing User Guide 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 DefaultTable2-1 Configuration Data Table continued ThreadCountinteger Allow RejectSrcUnitsboolean FALSETable2-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 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 MenuStep 12 Click Delete Figure4-9 Sample Filter DisplayFigure4-10 Delete Filter Display 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 Box4-12 Updating Active DatasetsSwapping Datasets 4-13 Creating, Modifying, and Deleting CarriersFigure4-17 Carrier Selection Box in Active Dataset Creating Carriers4-14 Figure4-18 Dialog Box for New Carrier in Active Dataset Modifying Carriers4-15 4-16 Deleting Carriers4-17 Creating, Modifying, and Deleting ContactsCreating Contacts Figure4-22 Dialog Box for an Existing Contact in Active Dataset Modifying ContactsDeleting Contacts 4-184-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 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-22hour0-23min 0-60sec Modifying Egress Route Attributes4-23 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 Attributes4-26 Creating, Modifying, and Deleting Ingress Route AttributesCreating Ingress Route Attributes 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 Attributes4-30 Creating, Modifying, and Deleting Match PatternsCreating Match Patterns Figure4-31 Dialog Box for New Match Pattern in Active Dataset Modifying Match PatternsDeleting Match Patterns 4-314-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 A provisioned minimum QoS 4-364-37 Modifying RulesFigure4-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 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-434-44 Updating Logging LevelLoading the Active Dataset 4-45 Resetting Call AccountingCleaning Test Results Updating Gatekeepers4-46 Checking CSR VersionMultiple GUI Operation Logging Configuring SyslogConfiguring Syslog Viewing Logs Examples Viewing LogsSample logs Cisco Carrier Sensitive Routing User Guide AppendixA Logging Viewing LogsConfiguration Data Schema Dataset Schema Data SchemaConfiguration Data 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 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 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