Cisco Version 1.1 - Manuals

vii Cisco Carrier Sensitive Routing User Guide Preface This preface describes the objective, audience, organization, and conventions of the Cisco Carrier Sensitive Routing User Guide . It contains the following information: • O v e r v i e w, p a g e - v i i • Who Should Use This Guide , p a g e - v...

viii Cisco Carrier Sensitive Routing User Guide Preface Document Organization Document Organization This guide is organized as follows: Document Conventions Following are conventions that might be used in this document. C h a p t e r 1 , “Overview of Cisco Carrier Sensitive Routing” Provides an over...

ix Cisco Carrier Sensitive Routing User Guide Preface Related Documentation and References Related Documentation and References • Carrier Sensitive Routing Installation Guide For Sun/Solaris  , Java, and postgreSQL database information, go to the following URLs: • http://www.sun.com • http://java.s...

x Cisco Carrier Sensitive Routing User Guide Preface Obtaining Technical Assistance Documentation Feedback You can submit comments electronically on Cisco.com. In the Cisco Documentation home page, click the F a x o r Email option in the “Leave Feedback” section at the bottom of the page. You can e-...

xi Cisco Carrier Sensitive Routing User Guide Preface Obtaining Technical Assistance Cisco TAC inquiries are categorized according to the urgency of the issue: • Priority level 4 (P4)—You need information or assistance concerning Cisco product capabilities, product installation, or basic product con...

C H A P T E R 1-1 Carrier Sensitive Routing User Guide 1 Overview of Cisco Carrier Sensitive Routing The Cisco Carrier Sensitive Routing (CSR) application provides end users with the capability to manipulate the routing of calls from the gatekeeper based on the ingress carrier and the DNIS. The rout...

1-2 Carrier Sensitive Routing User Guide C h a p t e r 1 Overview of Cisco Carrier Sensitive Routing CSR Components CSR Components The three major components of CSR are as follows. • postgreSQL Database • CSR application • CSR GUI The CSR GUI and the CSR application are not directly connected. They ...

1-3 Carrier Sensitive Routing User Guide C h a p t e r 1 Overview of Cisco Carrier Sensitive Routing CSR Basics CSR evaluates the predetermined selection and rejection criteria as part of the source carrier and DNIS information to determine what routing information to return to the gatekeeper. Note ...

1-4 Carrier Sensitive Routing User Guide C h a p t e r 1 Overview of Cisco Carrier Sensitive Routing CSR Basics Ingress Rejection Rules • Reject Max Origination Percentage • Reject Max Ingress Units • Reject Max Ingress Units per Route Egress Rejection Rules • Reject Egress Cost Greater than Ingress...

1-5 Carrier Sensitive Routing User Guide C h a p t e r 1 Overview of Cisco Carrier Sensitive Routing CSR Limitations CSR Limitations • When two rules are available (a rule associated with the carrier and a rule associated with a route), the rule associated with the carrier is chosen first. If one of...

C H A P T E R 2-1 Cisco Carrier Sensitive Routing User Guide 2 PostgreSQL Database Operations and Functionalities This chapter describes the operations and functionalities of the postgreSQL database and contains the following sections: • Database Operations, page 2-1 • Database Functionalities , pag...

2-2 Cisco Carrier Sensitive Routing User Guide C h a p t e r 2 PostgreSQL Database Operations and Functionalities Database Operations • -S—Tells the postmaster to run in silent mode. This is not recorded to a log file. • -i—Tells postmaster to allow network connections. If this is not set, the postm...

2-3 Cisco Carrier Sensitive Routing User Guide C h a p t e r 2 PostgreSQL Database Operations and Functionalities Database Operations Exporting a Database To export a database to a text file or to back up the entire database system, perform the following steps: Exporting to a Text File Step 1 Export...

2-4 Cisco Carrier Sensitive Routing User Guide C h a p t e r 2 PostgreSQL Database Operations and Functionalities Database Functionalities Database Functionalities This section describes the following: • Database Tables, p a g e 2 - 4 • PostgreSQL Database Command Summary , p a g e 2 - 1 7 Database ...

2-5 Cisco Carrier Sensitive Routing User Guide C h a p t e r 2 PostgreSQL Database Operations and Functionalities Database Functionalities Table2-1 Configuration Data Table Name Type Allow Null Default Constraints Comments ActiveDataset text N O ‘ _ 1 ’ Valid values: • _1 • _2 There are two datasets...

2-10 Cisco Carrier Sensitive Routing User Guide C h a p t e r 2 PostgreSQL Database Operations and Functionalities Database Functionalities Dataset Tables The dataset tables use functionality that is specific to postgreSQL, that is, table inheritance. This allows a table to be created and other tabl...

2-15 Cisco Carrier Sensitive Routing User Guide C h a p t e r 2 PostgreSQL Database Operations and Functionalities Database Functionalities Lists Table Note Tables Lists_1 and Lists_2 can inherit from the Lists table. Note Tables ContactLists_1 and ContactLists_2 can inherit from this table. Table2-...

2-18 Cisco Carrier Sensitive Routing User Guide C h a p t e r 2 PostgreSQL Database Operations and Functionalities Database Functionalities Note Tables IngressRoutes_1, IngressRoutes_2, EgressRoutes_1, and EgressRoutes_2 can inherit from this QoS table. PostgreSQL Database Command Summary Following ...

C H A P T E R 3-1 Cisco Carrier Sensitive Routing User Guide 3 Cisco Carrier Sensitive Routing Application Operations This chapter describes the following Cisco Carrier Sensitive Routing application operations: • Activating CSR , p a g e 3 - 1 • Deactivating CSR , page 3-3 Activating CSR This sectio...

3-2 Cisco Carrier Sensitive Routing User Guide C h a p t e r 3 Cisco Carrier Sensitive Routing Application Operations Activating CSR CSR as a User Process While the CSR is running as a daemon, other instances may run as user processes. If all instances are connected to the same database at startup, ...

3-3 Cisco Carrier Sensitive Routing User Guide C h a p t e r 3 Cisco Carrier Sensitive Routing Application Operations Deactivating CSR Deactivating CSR To stop CSR, log in to the CSR GUI by performing the following steps: Step 1 At the system prompt, enter the following command: /usr/local/csr/gui/c...

3-4 Cisco Carrier Sensitive Routing User Guide C h a p t e r 3 Cisco Carrier Sensitive Routing Application Operations Deactivating CSR Figure3-2 CSR Window Step 3 Click the CSR Commands tab. Step 4 Click Shutdown CSR . This shuts down all CSRs connected to this database. All current calls are droppe...

C H A P T E R 4-1 Cisco Carrier Sensitive Routing User Guide 4 CSR GUI Functionalities This chapter describes CSR functionalities and commands, and contains the following sections: • Activating the GUI, page 4-1 • Configuring CSR with the GUI, page 4-2 • Updating Active Datasets, p a g e 4 - 1 2 • U...

4-2 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Configuring CSR with the GUI Step 2 Enter the information in the Login dialog box as follows: a. Enter the user name. The range is 1 to 32 characters. b. Enter the password. The range is 1 to 32 characters. c. Ent...

4-3 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Configuring CSR with the GUI Figure4-2 Configuration Management Tab in CSR Window Changing Log Levels To change the logging level for the messages to be logged to syslog, select from the Logging Level pull-down me...

4-4 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Configuring CSR with the GUI Figure4-3 Logging Level Pull-down Menu The available levels are as follows: • Error—Only messages containing severe errors are logged. Optimally, this level may not generate any error ...

4-5 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Configuring CSR with the GUI Adding, Modifying, and Removing Gatekeepers To add, modify, and remove gatekeepers, log in to CSR and select the Configuration Management tab in the CSR window. Use the Current Gatekee...

4-8 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Configuring CSR with the GUI Figure4-9 Sample Filter Display Step 11 To delete a filter to the message, select from the pull-down menu for the filter. The following screen appears ( F i g u r e 4 - 1 0 “ Delete Fi...

4-9 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Configuring CSR with the GUI Modifying Gatekeepers This section describes how to modify an existing gatekeeper. Step 1 Select a gatekeeper from the gatekeeper list in the Current Gatekeepers area, as follows ( F i...

4-10 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Configuring CSR with the GUI Figure4-12 Registered Messages and Filters Dialog Box for an Existing Gatekeeper Step 3 To modify a message and its filters associated with the gatekeeper, click the round button to t...

4-11 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Configuring CSR with the GUI Step 1 To remove an existing gatekeeper, select a gatekeeper from the gatekeeper list in the Current Gatekeepers area. Step 2 Click Remove. The following message appears ( F i g u r e...

4-12 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Step 3 To enter the maximum number of calls allowed to be queued, enter a number for “Maximum Queue Size.” The default is 5000. If this number is too low, the gatekeeper connection waits ...

4-13 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets • Egress and ingress route attributes • Match patterns • Routes • Rules After you log in to CSR and select the Active Dataset tab in the CSR window, the following screen appears ( F i g u...

4-14 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Creating Carriers Note At least one contact list must be created before a carrier can be created. There must be a single carrier of “Home” type created for the provisioned data. See the “...

4-15 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Figure4-18 Dialog Box for New Carrier in Active Dataset The carrier key is the primary key of this carrier in the Carriers table. When a new carrier is being created, “ %%%% ” is displaye...

4-16 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Figure4-19 Dialog Box for an Existing Carrier in Active Dataset Step 3 Change the information accordingly. Step 4 Click Modify to save the changes, or click Cancel to cancel the changes. ...

4-17 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Note Alternatively, you can delete a carrier by clicking Delete when you are in the dialog box for modifying the carrier. Creating, Modifying, and Deleting Contacts This section describes...

4-18 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Step 5 In the Cost box, enter cost associated with this contact. The entry must be greater than 0. This is optional. Step 6 In the Priority box, enter priority of this contact. The entry ...

4-19 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Step 2 In the Contacts area, click a contact. You can select more than one contact by holding down the Ctrl key while clicking each contact. Step 3 Click Delete . A Delete message appears...

4-20 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets The key shown on the screen is the primary key of this contact list in the Contact List table. When a new contact list is being created, “ % % % % ” is displayed. Step 3 In the Contact Li...

4-21 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Step 4 Click Modify to save the changes, or click Cancel to cancel the changes. Deleting Contact Lists Step 1 In the Active Dataset tab in the CSR window, click the down arrow in the Sele...

4-23 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Step 10 In the Date/Time area, click Daily , Weekly, Absolute o r Constant . The egress route attribute is being applied according to these time segments. a. If you select Daily, enter St...

4-25 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Step 3 From the list, select an Egress Route Attribute by double-clicking on that attribute. Egress Route Attributes information similar to the following appears ( F i g u r e 4 - 2 7 “ D...

4-26 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Step 4 Click Delete . A Delete message appears: Step 5 Click Yes to delete the attribute, or click No to stop the deletion. Note Alternatively, you can delete an attribute by clicking Del...

4-28 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets h o u r ( 0 - 2 3 ) : m i n ( 0 - 6 0 ) : s e c ( 0 - 6 0 ) b. If you select Weekly, select day of the week from the pull-down menu and enter the Start Time and the End Time. c. If you se...

4-29 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Figure4-29 Dialog Box for an Existing Ingress Route Attribute in Active Dataset Step 4 Change the information accordingly. Step 5 Click Modify to save the changes, or click Cancel to leav...

4-30 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Note Alternatively, you can delete an attribute by clicking Delete when you are in the dialog box for modifying the attribute. Creating, Modifying, and Deleting Match Patterns This sectio...

4-31 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Modifying Match Patterns Step 1 In the Active Dataset tab in the CSR window, click the down arrow in the Selection box, then select Match Patterns from the pull-down menu. Step 2 In the M...

4-32 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Creating, Modifying, and Deleting Routes This section describes the steps to create, modify, and delete routes. Creating Routes Step 1 In the Active Dataset tab in the CSR window, click t...

4-33 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Figure4-33 QoS Relationships Dialog Box in Active Dataset a. In the Ingress Carrier box, click the down arrow, then select the ingress carrier from the pull-down menu. b. In the Egress Ca...

4-34 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Figure4-34 Dialog Box for an Existing Route in Active Dataset Step 3 Change the information accordingly. Step 4 Click Modify to save the changes, or click Cancel to leave the changes. Del...

4-35 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Creating, Modifying, and Deleting Rules This section describes the steps to create, modify and delete rules. Creating Rules Step 1 In the Active Dataset tab in the CSR window, click the d...

4-37 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets • Select Same Carrier—If the ingress carrier is also a egress carrier candidate, it is selected and all others are deselected. • Select Percentage Egress—Carriers with a zero percentage e...

4-38 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Active Datasets Figure4-36 Dialog Box for Existing Rule in Active Dataset Step 3 Change the information accordingly. Step 4 Click Modify to save the changes, or click Cancel to leave the changes. Deletin...

4-39 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Inactive Datasets Verifying Datasets To verify whether a dataset is valid, click Verify Dataset in the Dataset Commands area. This command ensures that all the provisioned data for the active dataset is ...

4-40 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Updating Inactive Datasets After you log in to CSR and click the Inactive Dataset tab in the CSR window, the following screen appears ( F i g u r e 4 - 3 7 “ Inactive Dataset Tab in CSR Window” ): Figure4-37 Inac...

4-41 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities CSR Commands Figure4-38 Destroy Message in Inactive Dataset Step 2 Click Yes to destroy the inactive dataset, or No to quit destroying. Activating Inactive Datasets An inactive dataset is not loaded into the CSR ...

4-42 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities CSR Commands Sending Test Route Request Commands to an Active CSR Application Step 1 Click the CSR Commands tab in the CSR window. The following screen appears ( CSR Commands Tab in CSR Window, p a g e 4 - 4 2 ):...

4-44 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities CSR Commands Step 11 To display a log of actions used to process the test results, click Show Log. The following screen appears ( F i g u r e 4 - 4 1 “ Log Entries Generated by the CSR Commands Tab” ): Figure4-41...

4-45 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities CSR Commands Resetting Call Accounting To reset all call units to zero, click Reset Call Accounting. This sets all accounting per carrier and per route/carrier for the CSR. This is the same data used by the Test ...

4-46 Cisco Carrier Sensitive Routing User Guide C h a p t e r 4 CSR GUI Functionalities Checking CSR Version Checking CSR Version To check the CSR version number, select the About tab in the CSR window. Multiple GUI Operation Multiple GUIs can run against a single database and multiple databases. If...

A-1 Cisco Carrier Sensitive Routing User Guide A P P E N D I X A Logging This appendix describes the following activities: • Configuring Syslog • Viewing Logs Configuring Syslog This section provides an overview of the UNIX syslog. For more detail, refer to the online manual page for syslog.conf. Sy...

A-2 Cisco Carrier Sensitive Routing User Guide A p p e n d i x A Logging Viewing Logs Messages can originate from the following locations or facilities: • user—User processes from the CSR application. • kern—Kernel • mail—Mail system • daemon—System daemons • auth—Authorization system, such as login...

A-3 Cisco Carrier Sensitive Routing User Guide A p p e n d i x A Logging Viewing Logs • Name of the machine that generated the log • Application/PID • Log level • Message content Sample logs • Jan 2 13:01:14 ciscoe250 CSR01[8333]: ERROR: CSR Started. Note This is logged at err level to note when the...

B-1 Cisco Carrier Sensitive Routing User Guide A P P E N D I X B Data Schema This appendix describes the following: • Configuration Data Schema • Dataset Schema Configuration Data Schema BEGIN WORK; SET CONSTRAINTS ALL DEFERRED; CREATE TABLE ConfigurationData ( ActiveDataset t e x t NOT NULL DEFAULT...

B-5 Cisco Carrier Sensitive Routing User Guide A p p e n d i x B Data Schema Dataset Schema Dataset Schema BEGIN WORK; SET CONSTRAINTS ALL DEFERRED; CREATE TABLE Carriers ( CarrierKey integer NOT NULL PRIMARY KEY CONSTRAINT CarrierKeyNotZero CHECK (CarrierKey <> 0), CarrierName varchar(64) NOT...

C-1 Cisco Carrier Sensitive Routing User Guide A P P E N D I X C Error Conditions and Recoveries This appendix describes the following error conditions and recoveries: • Database Connectivity Loss • Gatekeeper Connectivity Loss Database Connectivity Loss During connectivity loss, CSR attempts to rec...

C-2 Cisco Carrier Sensitive Routing User Guide A p p e n d i x C Error Conditions and Recoveries Gatekeeper Connectivity Loss Gatekeeper Connectivity Loss Gatekeeper Connectivity Loss can occur for any of the following reasons: • Power failure on gatekeeper • General network problem • Network proble...

IN-5 Cisco Carrier Sensitive Routing User Guide I N D E X A active and inactive datasets 1-3 Active Dataset tab 4-12 A N I 1-2 ARQ 1-2 B BRQ 1-2 C Configuration Management tab 4-2 CSR Commands tab 4-41 D Destination carrier 1-2 DNIS 1-2 D N S 3-5 DNS server 3-5 DRQ 1-2 G GateKeeper Transaction Messa...