Cisco Cisco PXM Version 1.1 manual

Corporate Headquarters Cisco Systems, Inc. 170 West Tasman Drive San Jose, CA 95134-1706 USA http://www.cisco.com Tel: 408 526-4000 800 553-NETS (6387) Fax: 408 526-4100 Cisco Carrier Sensitive Routing User Guide Version 1.1[...]

THE SPECIFICATIONS AND INFORMATION REGARDING THE PRODUCTS IN THIS MANUAL ARE SUBJECT TO CHANGE WITHOUT NOTICE. ALL STATEMENTS, INFORMATION, AND RECOMMENDATIONS IN THIS MANUAL ARE BELIEVED TO BE ACCURATE BUT ARE PRESENTED WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED. USERS MUST TAKE FULL RESPONSIBILITY FOR THEIR APPLICATION OF ANY PRODUCTS. THE [...]

iii Cisco Carrier Sensitive Routing User Guide C ON TE N T S Preface vii Overview vii Who Should Use This Guide vii Document Organization viii Document Conventions viii Related Documentation and References ix Obtaining Documentation ix World Wide Web ix Documentation CD-ROM ix Ordering Documentation ix Documentation Feedback x Obtaining Technical A[...]

Contents iv Cisco Carrier Sensitive Routing User Guide Exporting a Database 2-2 Reintializing a Database 2-3 Database Functionalities 2-3 Database Tables 2-4 Configuration Tables 2-4 Dataset Tables 2-10 PostgreSQL Database Command Summary 2-17 CH A P TE R 3 Cisco Carrier Sensitive Routing Application Operations 3-1 Activating CSR 3-1 Single Instanc[...]

Contents v Cisco Carrier Sensitive Routing User Guide Deleting Contacts 4-18 Creating, Modifying, and Deleting Contact Lists 4-19 Creating Contact Lists 4-19 Modifying Contact Lists 4-20 Deleting Contact Lists 4-21 Creating, Modifying, and Deleting Egress Route Attributes 4-21 Creating Egress Route Attributes 4-21 Modifying Egress Route Attributes [...]

Contents vi Cisco Carrier Sensitive Routing User Guide A P P E N D I X A Logging A-1 Configuring Syslog A-1 Examples A-2 Viewing Logs A-2 Sample logs A-3 A P P E N D I X B Data Schema B-1 Configuration Data Schema B-1 Dataset Schema B-5 A P P E N D I X C Error Conditions and Recoveries C-1 Database Connectivity Loss C-1 Gatekeeper Connectivity Loss[...]

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: • Overview , page-vii • Who Should Use This Guide , page-vii • Document Organization , page-viii • Document Convention[...]

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. Chapter1, “ Overview of Cisco Carrier Sensitive Routing ” Provides an overview of the postgreSQL database, CSR application, an[...]

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.sun.com • http://www.postgresql.org Obtai[...]

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 Fax or Email option in the “Leave Feedback” section at the bottom of the page. You can e-mail your comments to bug-doc@cisco.com. You can [...]

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 configuration. • Priority level 3 (P3)—Your n[...]

xii Cisco Carrier Sensitive Routing User Guide Preface Obtaining Technical Assistance[...]

CH A P TE 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 routing can be based on QoS along with many other attrib[...]

1-2 Carrier Sensitive Routing User Guide Chapter1 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 are both connected to the database. Figure1-1 illus[...]

1-3 Carrier Sensitive Routing User Guide Chapter1 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 CSR can operate with multiple gatekeepers. CSR passes thr[...]

1-4 Carrier Sensitive Routing User Guide Chapter1 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 • Reject Insufficient QoS • Reject Max Egres[...]

1-5 Carrier Sensitive Routing User Guide Chapter1 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 the rules (carrier’s rule) does not exist, the rule [...]

1-6 Carrier Sensitive Routing User Guide Chapter1 Overview of Cisco Carrier Sensitive Routing CSR Limitations[...]

CH A P TE 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 , page 2-3 The postgreSQL database is a relational d[...]

2-2 Cisco Carrier Sensitive Routing User Guide Chapter2 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 postmaster accepts connections only from the local hos[...]

2-3 Cisco Carrier Sensitive Routing User Guide Chapter2 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 a database into a text file by entering the following co[...]

2-4 Cisco Carrier Sensitive Routing User Guide Chapter2 PostgreSQL Database Operations and Functionalities Database 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 plac[...]

2-5 Cisco Carrier Sensitive Routing User Guide Chapter2 PostgreSQL Database Operations and Functionalities Database Functionalities Table2-1 Configuration Data Table Name Type Allow Null Default Constraints Comments ActiveDataset text NO ‘_1’ Valid values: • _1 • _2 There are two datasets in the CSR (active and inactive). There are two of e[...]

2-6 Cisco Carrier Sensitive Routing User Guide Chapter2 PostgreSQL Database Operations and Functionalities Database Functionalities ThreadCount integer NO 10 Number of threads in the working pool that handle routes in the rules engine. This number must be adjusted for different systems. MaxSizeOfQueue integer NO 5000 Maximum size of the queue to ha[...]

2-7 Cisco Carrier Sensitive Routing User Guide Chapter2 PostgreSQL Database Operations and Functionalities Database Functionalities RejectSrcUnits boolean NO FALSE If this rejection rule applies, the CSR returns a rejection instead of a null body. RejectNoDstCarri er boolean NO FALSE If this rejection rule applies, the CSR returns a rejection inste[...]

2-8 Cisco Carrier Sensitive Routing User Guide Chapter2 PostgreSQL Database Operations and Functionalities Database Functionalities ListenLRJ boolean NO FALSE Set to TRUE if registering for this type of message. ListenRAI boolean NO FALSE Set to TRUE if registering for this type of message. ListenBRQ boolean NO FALSE Set to TRUE if registering for [...]

2-9 Cisco Carrier Sensitive Routing User Guide Chapter2 PostgreSQL Database Operations and Functionalities Database Functionalities Caution The following table should not be modified or deleted. It consists of error messages that are logged. The CSR application does not work without this table. Table2-4 TestOutputs Table Name Type Allow Null Defaul[...]

2-10 Cisco Carrier Sensitive Routing User Guide Chapter2 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 tables to be inherited from it. For example, you can create a[...]

2-11 Cisco Carrier Sensitive Routing User Guide Chapter2 PostgreSQL Database Operations and Functionalities Database Functionalities Note Tables Carriers_1 and Carriers_2 can inherit from the Carriers table. Table2-8 Carriers Table Name Type Allow Null Default Constraints Comments CarrierKey integer NO <>0 Primary key. Key of the carrier. Car[...]

2-12 Cisco Carrier Sensitive Routing User Guide Chapter2 PostgreSQL Database Operations and Functionalities Database Functionalities Note Tables MatchPatterns_1 and MatchPatterns_2 can inherit from this table. Note Tables Routes_1 and Routes_2 can inherit from the Routes table. Table2-10 Routes Table Name Type Allow Null Default Constraints Comment[...]

2-13 Cisco Carrier Sensitive Routing User Guide Chapter2 PostgreSQL Database Operations and Functionalities Database Functionalities RejectMaxOriginationPercentage boolean NO FALSE Indicates whether to reject this rule. RejectMaxIngressUnits boolean NO FALSE Indicates whether to reject this rule. RejectMaxIngressUnitsPerRoute boolean NO FALSE Indic[...]

2-14 Cisco Carrier Sensitive Routing User Guide Chapter2 PostgreSQL Database Operations and Functionalities Database Functionalities Note Tables Rules_1 and Rules_2 can inherit from the Rules table. Note Tables Contacts_1 and Contacts_2 can inherit from the Contacts table. SelectPreferredCarrier integer NO 0 >= 0 and <= 5 Specifies preferred [...]

2-15 Cisco Carrier Sensitive Routing User Guide Chapter2 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-13 Lists Table Name Type Allow Null Default Constraints C[...]

2-16 Cisco Carrier Sensitive Routing User Guide Chapter2 PostgreSQL Database Operations and Functionalities Database Functionalities Note Tables IngressRouteAttributes_1 and IngressRouteAttributes _2 can inherit from the RouteAttributes table. DaypartType text NO Valid values: • absolute • weekly • daily • always The CSR searches for the co[...]

2-17 Cisco Carrier Sensitive Routing User Guide Chapter2 PostgreSQL Database Operations and Functionalities Database Functionalities Note EgressRouteAttributes_1 and EgressRouteAttributes_2 can inherit from the EgressRouteAttributes and RouteAttriubtes tables. Note Tables QoS_1 and QoS_2 can inherit from this QoS table. Table2-16 EgressRouteAttribu[...]

2-18 Cisco Carrier Sensitive Routing User Guide Chapter2 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 is a summary of frequently used postgreSQL commands. Refe[...]

CH A P TE 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 , page 3-1 • Deactivating CSR , page 3-3 Activating CSR This section provides instructions on running single and multipl[...]

3-2 Cisco Carrier Sensitive Routing User Guide Chapter3 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, startup errors can occur because the following processes [...]

3-3 Cisco Carrier Sensitive Routing User Guide Chapter3 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/csrgui & The login dialog box in Figure3-1‘ Login Di[...]

3-4 Cisco Carrier Sensitive Routing User Guide Chapter3 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 dropped, and connections to gatekeepers are terminated.[...]

CH A P TE 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 , page 4-12 • Updating Inactive Datasets , page 4-39 • CSR C[...]

4-2 Cisco Carrier Sensitive Routing User Guide Chapter4 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. Enter the host name where the database is located. This can [...]

4-3 Cisco Carrier Sensitive Routing User Guide Chapter4 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 menu. The following menu appears ( Figure4-3 “ Logging Le[...]

4-4 Cisco Carrier Sensitive Routing User Guide Chapter4 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 messages. • Information—Informational messages ar[...]

4-5 Cisco Carrier Sensitive Routing User Guide Chapter4 CSR GUI Functionalities Configuring CSR with the GUI Adding, Modifying, and Removing Gatekeepers To add, modify, and remove gatekeeper s, log in to CSR and select the Configuration Management tab in the CSR window. Use the Current Gatekeepers area on the screen to add, modify, or remove gateke[...]

4-6 Cisco Carrier Sensitive Routing User Guide Chapter4 CSR GUI Functionalities Configuring CSR with the GUI Step 2 Ε nter the ID of the gatekeeper to be added. The range is 1 to 64 characters. Step 3 Ε nter remote address (IP address) of the gatekeeper to be connected to. The format is x.x.x.x where x is a number from 0 to 255. Step 4 Ε nter po[...]

4-7 Cisco Carrier Sensitive Routing User Guide Chapter4 CSR GUI Functionalities Configuring CSR with the GUI Figure4-7 Filters Pop-up Menu Step 9 Click a filter on the pop-up menu. Step 10 Enter or select a value for the filter, as shown in the following sample displays ( Figure4-8 “ Sample Filter Display ” , Figure4-9 “ Sample Filter Display[...]

4-8 Cisco Carrier Sensitive Routing User Guide Chapter4 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 ( Figure4-10 “ Delete Filter Display ” ): Figure4-10 Delete Filter Display Step 12 Cli[...]

4-9 Cisco Carrier Sensitive Routing User Guide Chapter4 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 ( Figure4-11 “ Current Gatekeepers Area in CSR Window ” ).[...]

4-10 Cisco Carrier Sensitive Routing User Guide Chapter4 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 the left of the message. Step 4 Use the steps in adding me[...]

4-11 Cisco Carrier Sensitive Routing User Guide Chapter4 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 ( Figure4-13 “ Delete Gatekeeper Message ” ). Figure4-13 Delete G[...]

4-12 Cisco Carrier Sensitive Routing User Guide Chapter4 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 for the CSR to catch up. If this number is too high, [...]

4-13 Cisco Carrier Sensitive Routing User Guide Chapter4 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 ( Figure4-16 “ Active Dataset Tab in CSR Window ” ): F[...]

4-14 Cisco Carrier Sensitive Routing User Guide Chapter4 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 “ Deleting Contact Lists ” section on page4-21 . S[...]

4-15 Cisco Carrier Sensitive Routing User Guide Chapter4 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 displayed. Step 3 In the Carrier ID box, enter the ID of the [...]

4-16 Cisco Carrier Sensitive Routing User Guide Chapter4 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. Deleting Carriers Step 1 In the Active Dataset tab in the[...]

4-17 Cisco Carrier Sensitive Routing User Guide Chapter4 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 the steps to create, modify, and delete contacts. Creati[...]

4-18 Cisco Carrier Sensitive Routing User Guide Chapter4 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 must be greater than 0. This is optional. Step 7 Click Ne[...]

4-19 Cisco Carrier Sensitive Routing User Guide Chapter4 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: Step 4 Click Yes to delete the contact, or click No to [...]

4-20 Cisco Carrier Sensitive Routing User Guide Chapter4 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 List Name box, enter the name of the contact list. The ran[...]

4-21 Cisco Carrier Sensitive Routing User Guide Chapter4 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 Selection box, then select Contact Lists from the pull-down m[...]

4-22 Cisco Carrier Sensitive Routing User Guide Chapter4 CSR GUI Functionalities Updating Active Datasets Figure4-25 Dialog Box for New Egress Route Attribute in Active Dataset 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, “ %[...]

4-23 Cisco Carrier Sensitive Routing User Guide Chapter4 CSR GUI Functionalities Updating Active Datasets Step 10 In the Date/Time area, click Daily , Weekly , Absolute or Constant . The egress route attribute is being applied according to these time segments. a. If you select Daily, enter Start Time and End Time. Use the format shown in the exampl[...]

4-24 Cisco Carrier Sensitive Routing User Guide Chapter4 CSR GUI Functionalities Updating Active Datasets Figure4-26 List of Egress Route Attribute Names in Active Dataset[...]

4-25 Cisco Carrier Sensitive Routing User Guide Chapter4 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 ( Figure4-27 “ Dialog Box for an Existing Egress Route Attribute in Active Datas[...]

4-26 Cisco Carrier Sensitive Routing User Guide Chapter4 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 Delete when you are in the dialog box for modifying the attr[...]

4-27 Cisco Carrier Sensitive Routing User Guide Chapter4 CSR GUI Functionalities Updating Active Datasets Figure4-28 Dialog Box for New Ingress Route Attribute in Active Dataset The key shown on the screen is the primary key of this Ingress Route Attribute in the Ingress Route Attributes table. When a new ingress route attribute is being created, ?[...]

4-28 Cisco Carrier Sensitive Routing User Guide Chapter4 CSR GUI Functionalities Updating Active Datasets hour(0-23):min (0-60):sec (0-60) 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 select Absolute , enter the Start Date, Start Time, End Date, and End Time. The Start [...]

4-29 Cisco Carrier Sensitive Routing User Guide Chapter4 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 leave the changes. Deleting Ingress Route Attributes Step 1 I[...]

4-30 Cisco Carrier Sensitive Routing User Guide Chapter4 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 section describes the steps to create, modify, and delete Match[...]

4-31 Cisco Carrier Sensitive Routing User Guide Chapter4 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 Match Pattern area, select a pattern by double-clicking on[...]

4-32 Cisco Carrier Sensitive Routing User Guide Chapter4 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 the down arrow in the Selection box, then select Match Pat[...]

4-33 Cisco Carrier Sensitive Routing User Guide Chapter4 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 Carrier box, click the down arrow , then select the egress[...]

4-34 Cisco Carrier Sensitive Routing User Guide Chapter4 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. Deleting Routes Step 1 In the Active Dataset tab in the CSR [...]

4-35 Cisco Carrier Sensitive Routing User Guide Chapter4 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 down arrow in the Selection box, then select Rules from th[...]

4-36 Cisco Carrier Sensitive Routing User Guide Chapter4 CSR GUI Functionalities Updating Active Datasets • Reject Max Origination Percentage—If the ingress carrier’s current percentage of calls is greater than its provisioned maximum, the call is rejected. Note This rule rejects a call if the percentage of calls originated by this ingress ca[...]

4-37 Cisco Carrier Sensitive Routing User Guide Chapter4 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 egress and sharing the greatest difference between[...]

4-38 Cisco Carrier Sensitive Routing User Guide Chapter4 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. Deleting Rules Step 1 In the Active Dataset tab in the CSR windo[...]

4-39 Cisco Carrier Sensitive Routing User Guide Chapter4 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 valid. If the dataset is not valid, it cannot be loaded i[...]

4-40 Cisco Carrier Sensitive Routing User Guide Chapter4 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 ( Figure4-37 “ Inactive Dataset Tab in CSR Window ” ): Figure4-37 Inactive Dataset Tab in CSR Window Only one functionality in the [...]

4-41 Cisco Carrier Sensitive Routing User Guide Chapter4 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 memory, with the exception of test commands. To place the[...]

4-42 Cisco Carrier Sensitive Routing User Guide Chapter4 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 , page 4-42 ): Figure4-39 CSR Commands Tab in CSR Window Step 2 In the ANI b[...]

4-43 Cisco Carrier Sensitive Routing User Guide Chapter4 CSR GUI Functionalities CSR Commands Note If an egress carrier is specified, the call is ignored. It is assumed that the egress carrier has been found. Step 6 In the Time box, enter the simulated time to test time-sensitive calls. If this is not specified, the current time is used. The format[...]

4-44 Cisco Carrier Sensitive Routing User Guide Chapter4 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 ( Figure4-41 “ Log Entries Generated by the CSR Commands Tab ” ): Figure4-41 Log Entries Generated by the CSR Commands Tab The log messa[...]

4-45 Cisco Carrier Sensitive Routing User Guide Chapter4 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 Route Request functionality. Updating Gatekeepers To upd[...]

4-46 Cisco Carrier Sensitive Routing User Guide Chapter4 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 all users are working in a read-only mode, the following[...]

A-1 Cisco Carrier Sensitive Routing User Guide A PP E ND 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. Syslog is a general location or mechanism for logg[...]

A-2 Cisco Carrier Sensitive Routing User Guide AppendixA 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 or su. • lpr—Print spooler • ne[...]

A-3 Cisco Carrier Sensitive Routing User Guide AppendixA 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 CSR was started, even if debug and informationa[...]

A-4 Cisco Carrier Sensitive Routing User Guide AppendixA Logging Viewing Logs[...]

B-1 Cisco Carrier Sensitive Routing User Guide A PP E ND 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 text NOT NULL DEFAULT '_1' CONSTRAINT ActiveDatasetSuffixInval[...]

B-2 Cisco Carrier Sensitive Routing User Guide AppendixB Data Schema Configuration Data Schema ListenPort integer CONSTRAINT CSRListenPortInvalid CHECK (ListenPort > 0 AND ListenPort <= 32767), ThreadCount integer NOT NULL DEFAULT 10, MaxSizeOfQueue integer NOT NULL DEFAULT 5000, TestRoutesAccountingEnabled boolean NOT NULL DEFAULT FALSE, Rej[...]

B-3 Cisco Carrier Sensitive Routing User Guide AppendixB Data Schema Configuration Data Schema ) ); CREATE TABLE TestRoutes ( TestKey integer NOT NULL PRIMARY KEY, TestTime time, TestDate date, DatasetID text DEFAULT '_1' CONSTRAINT DatasetIDInvalid CHECK ( lower(DatasetID) = '_1' OR lower(DatasetID) = '_2' ), ANI varc[...]

B-4 Cisco Carrier Sensitive Routing User Guide AppendixB Data Schema Configuration Data Schema CREATE TABLE Filters ( FilterKey integer NOT NULL PRIMARY KEY, GKID varchar(64) NOT NULL, MsgType text NOT NULL CONSTRAINT MsgTypeInvalid CHECK ( lower(MsgType) = 'arq' OR lower(MsgType) = 'lrq' OR lower(MsgType) = 'rrq' OR l[...]

B-5 Cisco Carrier Sensitive Routing User Guide AppendixB 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 NULL, CarrierType text NOT NULL CONSTRAINT CarrierTypeInv[...]

B-6 Cisco Carrier Sensitive Routing User Guide AppendixB Data Schema Dataset Schema CREATE TABLE Routes ( RouteKey integer NOT NULL PRIMARY KEY CONSTRAINT RouteKeyNotZero CHECK (RouteKey <> 0), RouteName text, RuleKey integer ); CREATE TABLE Routes_1 () INHERITS (Routes); CREATE TABLE Routes_2 () INHERITS (Routes); CREATE TABLE Rules ( RuleKe[...]

B-7 Cisco Carrier Sensitive Routing User Guide AppendixB Data Schema Dataset Schema CHECK ( SelectBestQoS >= 0 AND SelectBestQoS <= 5 ), SelectSameCarrier integer NOT NULL DEFAULT 0 CONSTRAINT SelSameCarrierInvalid CHECK ( SelectSameCarrier >= 0 AND SelectSameCarrier <= 5 ), SelectPreferredCarrier integer NOT NULL DEFAULT 0 CONSTRAINT S[...]

B-8 Cisco Carrier Sensitive Routing User Guide AppendixB Data Schema Dataset Schema Cost integer CONSTRAINT CostInvalid CHECK (Cost >= 0), Priority integer CONSTRAINT PriorityInvalid CHECK (Priority >= 0) ); CREATE TABLE Contacts_1 () INHERITS (Contacts); CREATE TABLE Contacts_2 () INHERITS (Contacts); CREATE TABLE Lists ( ListKey integer NOT[...]

B-9 Cisco Carrier Sensitive Routing User Guide AppendixB Data Schema Dataset Schema CHECK (Weekday >=0 AND Weekday <= 6), StartTime time, EndTime time CONSTRAINT TimeRangeInvalid CHECK ( (StartTime ISNULL AND EndTime ISNULL AND lower(DaypartType) = 'always') OR (StartTime NOTNULL AND EndTime NOTNULL AND (StartTime < EndTime) OR ([...]

B-10 Cisco Carrier Sensitive Routing User Guide AppendixB Data Schema Dataset Schema CREATE TABLE QoS ( IngressCarrierKey integer NOT NULL, EgressCarrierKey integer NOT NULL, RouteKey integer NOT NULL, RelativeQoS integer NOT NULL CONSTRAINT RelativeQoSInvalid CHECK (RelativeQoS >= 1 AND RelativeQoS <= 9) ); CREATE TABLE QoS_1 () INHERITS (Qo[...]

B-11 Cisco Carrier Sensitive Routing User Guide AppendixB Data Schema Dataset Schema CREATE UNIQUE INDEX Contacts_1_PKey ON Contacts_1 (ContactKey); CREATE UNIQUE INDEX Contacts_2_PKey ON Contacts_2 (ContactKey); CREATE UNIQUE INDEX Lists_1_PKey ON Lists_1 (ListKey); CREATE UNIQUE INDEX Lists_2_PKey ON Lists_2 (ListKey); CREATE UNIQUE INDEX Match_1[...]

B-12 Cisco Carrier Sensitive Routing User Guide AppendixB Data Schema Dataset Schema ALTER TABLE Carriers_1 ADD FOREIGN KEY (RuleKey) REFERENCES Rules_1 (RuleKey) DEFERRABLE; ALTER TABLE Carriers_1 ADD FOREIGN KEY (ListKey) REFERENCES Lists_1 (ListKey) DEFERRABLE; ALTER TABLE Carriers_2 ADD FOREIGN KEY (RuleKey) REFERENCES Rules_2 (RuleKey) DEFERRA[...]

B-13 Cisco Carrier Sensitive Routing User Guide AppendixB Data Schema Dataset Schema ALTER TABLE EgressRouteAttributes_2 ADD FOREIGN KEY (CarrierKey) REFERENCES Carriers_2 (CarrierKey) DEFERRABLE; ALTER TABLE EgressRouteAttributes_2 ADD FOREIGN KEY (ListKey) REFERENCES Lists_2 (ListKey) DEFERRABLE; ALTER TABLE QoS_1 ADD FOREIGN KEY (IngressCarrierK[...]

B-14 Cisco Carrier Sensitive Routing User Guide AppendixB Data Schema Dataset Schema[...]

C-1 Cisco Carrier Sensitive Routing User Guide A PP E ND 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 reconnect to the database every minute, and it cont[...]

C-2 Cisco Carrier Sensitive Routing User Guide AppendixC 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 problem related to the Sun/Solaris  system During conne[...]

GL-3 Cisco Carrier Sensitive Routing User Guide G L O SS A R Y A ANI automatic number identification. ARQ admission request message. B BRQ bandwidth request message. D DNIS dialed number identification service. DNS domain naming system. DRQ disengage request message. G GUI graphical user interface. I irr information request response message. L LCF [...]

Glossary GL-4 Cisco Carrier Sensitive Routing User Guide R RAI resource availability indication message. RRQ registration request message. U URQ unregistration request message.[...]

IN-5 Cisco Carrier Sensitive Routing User Guide INDEX A active and inactive datasets 1-3 Active Dataset tab 4-12 ANI 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 DNS 3-5 DNS server 3-5 DRQ 1-2 G GateKeeper Transaction Message Protocol A-1 I Inactive Dataset Tab 4-39 IRR 1-2 L LCF [...]

Index IN-6 Cisco Carrier Sensitive Routing User Guide S Source carrier 1-2 T Tables Carrier 1-3 Configuration Settings 1-3 Contact List 1-3 Contacts 1-3 Egress Route Attributes 1-3 Egress Routes 1-3 Filters 1-3 Gatekeepers 1-3 Ingress Route Attributes 1-3 Ingress Routes 1-3 Match Patterns 1-3 QoS 1-3 Routes 1-3 Rules 1-3 see also Database Tables 2-[...]