manualshive.com logo in svg

Cisco PXM Version 1.1, User Manual, Page: 29 / 110

Share
Download
Cisco PXM Version 1.1 User Manual Download Page 29

 

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.

CarrierName

varchar(64)

NO

Name of carrier.

CarrierType

text

NO

Valid values:

•

home

•

itsp

•

tdm

Type of carrier.

CarrierID

varchar(64)

NO

ID of carrier. 
Must be unique. 

MaxIngressUnits

integer

>=0

Maximum 
ingress units.

MaxEgressUnits

integer

>=0

Maximum egress 
units.

RuleKey

integer

Foreign key. Rule 
associated with 
this specific 
carrier.

ListKey

integer

NO

Foreign key. Key 
of the list.

isActive

boolean

NO

TRUE

Indicates whether 
carrier is active.

Table2-9

MatchPatterns Table

Name 

Type

Allow 
Null

Default

Constraints

Comments

PatternKey

integer

NO

<> 0

Primary key. Key of the 
pattern.

Pattern

varchar(64)

NO

Unique. Valid values 
are 0 to 9, a to f, A to F, 
*, and “.” 

RouteKey

integer

Foreign key. Route that 
this pattern is associated 
with.

Summary of Contents for PXM Version 1.1

Page 1: ...te 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 ...

Page 2: ...alifornia Berkeley UCB as part of UCB s public domain version of the UNIX operating system All rights reserved Copyright 1981 Regents of the University of California NOTWITHSTANDING ANY OTHER WARRANTY HEREIN ALL DOCUMENT FILES AND SOFTWARE OF THESE SUPPLIERS ARE PROVIDED AS IS WITH ALL FAULTS CISCO AND THE ABOVE NAMED SUPPLIERS DISCLAIM ALL WARRANTIES EXPRESSED ORIMPLIED INCLUDING WITHOUT LIMITATI...

Page 3: ...Cisco com x Technical Assistance Center x Contacting TAC by Using the Cisco TAC Website xi Contacting TAC by Telephone xi C H A P T E R 1 Overview of Cisco Carrier Sensitive Routing 1 1 Prerequisites 1 1 CSR Components 1 2 CSR Basics 1 2 PostgreSQL Database 1 3 CSR Application 1 3 Ingress Rejection Rules 1 4 Egress Rejection Rules 1 4 Selection Rules 1 4 CSR GUI 1 4 CSR Limitations 1 5 C H A P T E...

Page 4: ...4 1 Activating the GUI 4 1 Configuring CSR with the GUI 4 2 Changing Configuration Settings 4 2 Changing Log Levels 4 3 Changing App Priority 4 4 Changing Connection Port 4 4 Enabling Test Routes Accounting 4 4 Saving Configuration Settings 4 4 Adding Modifying and Removing Gatekeepers 4 5 Adding Gatekeepers 4 5 Modifying Gatekeepers 4 9 Removing Gatekeepers 4 10 Setting Threads for Processing Cal...

Page 5: ...4 29 Creating Modifying and Deleting Match Patterns 4 30 Creating Match Patterns 4 30 Modifying Match Patterns 4 31 Deleting Match Patterns 4 31 Creating Modifying and Deleting Routes 4 32 Creating Routes 4 32 Modifying Routes 4 33 Deleting Routes 4 34 Creating Modifying and Deleting Rules 4 35 Creating Rules 4 35 Modifying Rules 4 37 Deleting Rules 4 38 Verifying Datasets 4 39 Updating Inactive D...

Page 6: ...iguring 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 C 2 G L O S S A R Y I N D E X ...

Page 7: ...ed Documentation and References page ix Obtaining Documentation page ix Obtaining Technical Assistance page x Overview The Cisco Carrier Sensitive Routing User Guide provides information on operations and functionalities of Carrier Sensitive Routing CSR application its graphical user interface GUI and the databases associated with it Who Should Use This Guide Users of this guide should have knowle...

Page 8: ...s the configuration of syslog and viewing logs Appendix B Data Schema Describes the configuration data schema and dataset schema Appendix C Error Conditions and Recoveries Describes database and gatekeeper connectivity loss Table1 Convention Description boldface Commands and keywords are in bold face italic Arguments for which you supply values are in italic Keywords or arguments that appear withi...

Page 9: ...iterature are available in a Cisco Documentation CD ROM package which is shipped with your product The Documentation CD ROM is updated monthly and may be more current than printed documentation The CD ROM package is available as a single unit or through an annual subscription Ordering Documentation You can order Cisco documentation in these ways Registered Cisco com users Cisco direct customers ca...

Page 10: ...to the technical support resources on the Cisco TAC Web Site Cisco com Cisco com is the foundation of a suite of interactive networked services that provides immediate open access to Cisco information networking solutions services programs and resources at any time from anywhere in the world Cisco com is a highly integrated Internet application and a powerful easy to use tool that provides a broad...

Page 11: ...service contract have complete access to the technical support resources on the Cisco TAC Web Site The Cisco TAC Web Site requires a Cisco com login ID and password If you have a valid service contract but do not have a login ID or password go to this URL to register http www cisco com register If you are a Cisco com registered user and you cannot resolve your technical issues by using the Cisco T...

Page 12: ...xii Cisco Carrier Sensitive Routing User Guide Preface Obtaining Technical Assistance ...

Page 13: ...that pertain to your network to maximize cost QoS and carrier relations CSR can run on a Sun Solaris system that has a network connection to gatekeepers This chapter contains the following sections Prerequisites page 1 1 CSR Components page 1 2 CSR Basics page 1 2 CSR Limitations page 1 5 Prerequisites Root access to a UNIX machine for the following tasks Create users Modify Syslog conf Setting da...

Page 14: ...tly connected They are both connected to the database Figure1 1 illustrates these components Figure1 1 CSR Components CSR Basics This section describes the basic operation of CSR After CSR is started it registers with the gatekeeper connected to a network Any one or a combination of the following registration messages are used ARQ LRQ DRQ BRQ URQ RAI LCF LRJ IRR The gatekeeper responds with any of...

Page 15: ...ess attributes and associated routes Ingress Route Attributes Table Contains a list ingress attributes and associated data Ingress Routes Table Contains a list of ingress attributes and associated routes Match Patterns Table Contains a list of match patterns and associated routes QoS Table Contains a list of relative QoS values associated to route ingress and egress Routes Table Contains a list of...

Page 16: ...oS Select Same Carrier Select Percentage Egress Select Preferred Carrier CSR operates on an internal copy of the active dataset which is loaded from the active dataset of the postgreSQL database CSR can also operate without the postgreSQL database running as long as it has an active dataset For more information on the active dataset see the Loading the Active Dataset section on page4 44 CSR GUI Th...

Page 17: ...iated with the carrier and the contact list associated with the EgressRouteAttribute the carrier s contact list is used first If one of the contact lists carrier s contact list does not exist then the contact list associated with the EgressRouteAttribute is used If a contact is provisioned with a DNS name and a DNS server is not found that is cannot get an IP address the dataset verification fails...

Page 18: ...1 6 Carrier Sensitive Routing User Guide Chapter1 Overview of Cisco Carrier Sensitive Routing CSR Limitations ...

Page 19: ... can manage many different databases simultaneously The CSR creates a database in this system and performs call routing based on the data in the database Database Operations This section describes the following tasks Activating the Database Exiting the Database Reactivating the Database Exporting a Database Reintializing a Database Activating the Database To activate the postgreSQL database perfor...

Page 20: ... the file profile so the database can be restarted from a reboot Exiting the Database To exit the postgreSQL database perform the following steps Step 1 Log in to the Solaris system by entering postgres as the user A postgres password prompt may appear Step 2 Enter the following command etc init d postgres_init stop This command calls the postgreSQL command pg_ctl stop Reactivating the Database To...

Page 21: ...irectory usr local pgsql data base into a tar file Reintializing a Database To reinitialize a database the existing database must be destroyed and a new one must be created To reinitialize a database performing the following steps Step 1 Destroy the database by entering the following command with csrdb as the name of the database dropdb csrdb Note The database to be destroyed must not be connected...

Page 22: ...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...

Page 23: ...n 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 CSR_ID varchar 64 NO ID used to register with the gatekeeper which application is connecting Also known as the application ID CSR_Version text Version of CSR This is entered when the GUI requests it from the CSR GKTMP_Ver...

Page 24: ...commands through the GUI the call units are updated if this is set to True RejectSrcCarrierI nactive boolean NO FALSE If this rejection rule applies the CSR returns a rejection instead of a null body RejectNullSrcCar rier boolean NO FALSE If this rejection rule applies the CSR returns a rejection instead of a null body RejectSrcCarrier Unknown boolean NO FALSE If this rejection rule applies the CS...

Page 25: ...rimary key Key of the gatekeeper GKID varchar 64 NO ID of the gatekeeper Must be unique GK_IP inet NO IP address of the gatekeeper GK_Port integer NO 0 and 32767 Port that the gatekeeper is listening on ListenARQ boolean NO FALSE Set to TRUE if registering for this type of message ListenLRQ boolean NO FALSE Set to TRUE if registering for this type of message ListenIRR boolean NO FALSE Set to TRUE ...

Page 26: ...atekeeper Table2 2 Gatekeeper Table continued Name Type Allow Null Default Constraints Comments Table2 3 TestRoutes Table Name Type Allow Null Default Constraints Comments TestKey integer NO Primary key Key of this test route TestTime time Time of the test TestDate date Date of the test DatasetID text _1 Valid values _1 _2 This marks which dataset to issue the test on ANI varchar 64 ANI message DN...

Page 27: ...g DstCarrierID varchar 64 NO ID of Destination Carrier ListKey integer NO Specifies key for the contact list associated with the particular carrier IsSelected boolean NO FALSE Specifies whether this is a selected carrier Table2 5 LogEntries Table Name Type Allow Null Default Constraints Comments TestKey integer NO Foreign key Test key that this log file was generated for EntryOrder integer NO For ...

Page 28: ...rom it This allows two datasets to be created Table2 7 Filters Table Name Type Allow Null Default Constraints Comments FilterKey integer NO Primary key Key of the filter GKID varchar 64 NO Foreign key ID of the gatekeeper associated with this filter MsgType text NO Valid values ARQ LRQ RRQ URQ LCF LRJ DRQ BRQ IRR RAI The message type for this filter FilterType text NO Valid values endpoint support...

Page 29: ...tdm Type of carrier CarrierID varchar 64 NO ID of carrier Must be unique MaxIngressUnits integer 0 Maximum ingress units MaxEgressUnits integer 0 Maximum egress units RuleKey integer Foreign key Rule associated with this specific carrier ListKey integer NO Foreign key Key of the list isActive boolean NO TRUE Indicates whether carrier is active Table2 9 MatchPatterns Table Name Type Allow Null Defa...

Page 30: ...y Key of the route RouteName text Name of the route RuleKey integer Foreign key Rule associated with this route Table2 11 Rules Table Name Type Allow Null Default Constraints Comments RuleKey integer NO 0 Primary key Key of the rule RuleName text Optional name to describe this rule IsDefaultRule boolean NO FALSE Indicates if this is the default rule One default rule must exist MinQoS integer 1 and...

Page 31: ...ates whether to reject this rule RejectInsufficientQoS boolean NO FALSE Indicates whether to reject this rule RejectMaxEgressUnits boolean NO FALSE Indicates whether to reject this rule RejectMaxEgressUnitsPerRoute boolean NO FALSE Indicates whether to reject this rule PreventITSPtoITSP boolean NO FALSE Indicates whether to reject this rule SelectMinCostPerEgressRoute integer NO 0 0 and 5 Specifie...

Page 32: ...ifies egress percentage Table2 11 Rules Table continued Name Type Allow Null Default Constraints Comments Table2 12 Contacts Table Name Type Allow Null Default Constraints Comments ContactKey integer NO 0 Primary key Key of the contact RASAddress varchar 64 NO RAS address AddressType text NO Valid values ipv4 gkid dnsname Type of address IP address gatekeeper ID or DNS name The CSR converts the DN...

Page 33: ...omments ListKey integer NO 0 Primary key Key of the list ListName text Name of the list Table2 14 ContactLists Table Name Type Allow Null Default Constraints Comments ListKey NO Foreign key Key of the list ContactKey NO Foreign key Key of the contact Table2 15 RouteAttributes Table Name Type Allow Null Default Constraints Comments AttributeKey integer NO 0 Primary key Key of the route attribute At...

Page 34: ...the week during a specific time Start time end time and weekday must be entered daily each day for a specific time Start time and end time must be entered always all the time WeekDay integer 0 and 6 As 0 Sunday 6 Saturday This is for the weekly setting StartTime time Valid format hour 0 23 min 0 60 sec 0 60 This is for the absolute weekly and daily settings EndTime time Valid format hour 0 23 min ...

Page 35: ...e ListKey integer Foreign key Key of list associated with this egress route attribute Table2 17 QoS Table Name Type Allow Null Default Constraints Comments IngressCarrierKey integer NO Foreign key Key of the ingress carrier EgressCarrierKey integer NO Foreign key Key of the egress carrier RouteKey integer NO Foreign key Key of the route associated with the QoS RelativeQoS integer NO 1 and 9 Relati...

Page 36: ...tgreSQL A database name is required when using this command createuser Creates a postgreSQL user A user name is required when using this command dropdb Removes a database from postgreSQL A database name is required when using this command dropuser Removes a postgreSQL user A user name is required when using this command initdb Creates a new postgreSQL database installation This command is used onl...

Page 37: ...the same machine Single Instance Before activating the CSR application the postgreSQL database must be installed and set up for use A database named csrdb must be loaded into the application You can use either of the following methods to activate the CSR application CSR as a Daemon The daemon file is located in directory etc init d csr_init and it accepts only the start parameter Step 1 To activat...

Page 38: ... and typing the process to a console Step 2 Optionally to run CSR continuously after logout enter the following command nohup Multiple Instances To run multiple CSR instances all but one must run as a user process If all instances are connected to the same database at startup startup errors occur because the following processes are attempted by all instances Listening on the same TCP port for inco...

Page 39: ...e is 1 to 32 characters b Enter the password The range is 1 to 32 characters c Enter the host name that is the location of the database This can be a remote or local host The range is 1 to 32 characters d Enter port number This is the port on the system for the database connection The range is 1 to 32767 e Enter DB Name This is the name of the database to be connected to The range is 1 to 32 chara...

Page 40: ...er 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 ...

Page 41: ...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 Commands page 4 41 Multiple GUI Operation page 4 46 Activating the GUI Step 1 To start the GUI enter the following command at the system prompt usr local csr gui csrgui The Login dialog box appears in Figure4 1 Login Dialog Box as shown below Figure4 1 Login Dialog Box ...

Page 42: ... and the Login dialog box reappears After three unsuccessful login attempts the GUI shuts down Alternatively click Cancel to exit from the GUI Note Information from the last successful login is saved to the CSRLoginProperties file in the current working directory When the Login dialog box appears next time the login information excluding the password is displayed Configuring CSR with the GUI This ...

Page 43: ... 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 Level Pull down Menu ...

Page 44: ...gatekeeper uses this priority number to distinguish which one should be used first To change App Priority enter a number from 1 to 9 in the App Priority box Changing Connection Port Incoming Connection Port is the port where CSR listens for gatekeeper connection and where the simulator that acts as a client is connected to the CSR It is normally used for testing because gatekeepers do not act as c...

Page 45: ...CSR window Use the Current Gatekeepers area on the screen to add modify or remove gatekeepers Adding Gatekeepers This section describes the steps to add a gatekeeper and its associated messages and filters Step 1 To add a gatekeeper click Add in the Current Gatekeepers area The following dialog box appears Figure4 4 Registered Messages and Filters Dialog Box for a New Gatekeeper Figure4 4 Register...

Page 46: ...e CSR The default is Connected Step 6 To select a message to be associated with the gatekeeper check the checkbox next to the message shown as follows Figure4 5 Registered Messages and Filters Checkbox Figure4 5 Registered Messages and Filters Checkbox Step 7 To display the existing filters for the message click the round button to the far left of the message The following screen appears Figure4 6...

Page 47: ...onfiguring 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 Figure4 8 Sample Filter Display ...

Page 48: ...o 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 Click Delete Step 13 Click OK to save the changes or click Cancel to cancel the changes Note If the maximum number of filters of a particular type has already been added to a message an error message appears ...

Page 49: ...o 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 Figure4 11 Current Gatekeepers Area in CSR Window Step 2 Click Modify The following dialog box appears Figure4 12 Registered Messages and Filters Dialog Box for an Existing Gatekeeper ...

Page 50: ...atekeeper 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 messages and filters in the Adding Gatekeepers section on page5 Step 5 Click OK to save the changes or click Cancel to cancel the changes Removing Gatekeepers This section describes how to remove an existing gatekeeper ...

Page 51: ...s and Call Queue Size This section describes how to set the number of working threads for processing calls in the queue and the maximum number of calls allowed to be queued Step 1 In the Configuration Management screen in the CSR window click Advanced The Advanced Configuration dialog box appears Figure4 14 Advanced Configuration Dialog Box Figure4 14 Advanced Configuration Dialog Box Step 2 To se...

Page 52: ...e the changes or click Cancel to cancel the changes Swapping Datasets This section describes how to swap an active and inactive dataset Step 1 In the Configuration Management screen in the CSR window click Swap Active Inactive Datasets The following message appears Figure4 15 Swap Dataset Message Figure4 15 Swap Dataset Message Step 2 Check the checkbox to the left of Load Dataset into CSR Step 3 ...

Page 53: ...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 Figure4 16 Active Dataset Tab in CSR Window The following sections describe functionalities and operations of the Active Dataset tab Creating Modifying and Deleting Carriers This section describes the steps to create modify and delete carriers ...

Page 54: ...ed data See the Deleting Contact Lists section on page4 21 Step 1 In the Active Dataset screen in the CSR window if Carriers is not selected in the Selection box click the down arrow in that box A pull down menu appears Figure4 17 Carrier Selection Box in Active Dataset Figure4 17 Carrier Selection Box in Active Dataset Step 2 Select Carriers from the pull down menu then click New The New Carrier ...

Page 55: ...x click the down arrow then select the rule this carrier applies to from the pull down menu Step 8 In the Max Egress Units box enter the maximum number of egress units that this carrier may terminate across all routes serviced by this carrier The range is 0 to 2147483647 This is optional Step 9 In the Contact List box click the down arrow then select the contact list that this carrier applies to f...

Page 56: ... Active Dataset tab in the CSR window if Carriers is not selected in the Selection box click the down arrow in that box then select Carrier from the pull down menu Step 2 In the Carriers area click a carrier You can select more than one carrier by holding down the Ctrl key while clicking each carrier Step 3 Click Delete The following message appears Figure4 20 Delete Carrier Message in Active Data...

Page 57: ...b screen in the CSR window click the down arrow in the Selection box then select Contacts from the pull down menu Step 2 Click New The following dialog box appears Figure4 21 Dialog Box for New Contact in Active Dataset Figure4 21 Dialog Box for New Contact in Active Dataset The contact key is the primary key of this contact in the Contacts table When a new contact is being created is displayed St...

Page 58: ... the CSR window click the down arrow in the Selection box then select Contacts from the pull down menu Step 2 In the Contacts area select a contact by double clicking on that contact on the list Contact information similar to the following appears Figure4 22 Dialog Box for an Existing Contact in Active Dataset Figure4 22 Dialog Box for an Existing Contact in Active Dataset Step 3 Change the inform...

Page 59: ...lternatively you can delete a contact by clicking Delete when you are in the screen for modifying the contact Creating Modifying and Deleting Contact Lists This section describes the steps to create modify and delete Contacts Lists Creating 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 menu St...

Page 60: ...ated Contacts box you can select a contact and click Remove to remove that contact from the box and return it to the Available Contacts box Step 6 Click Add to add this contact list or click Cancel to exit Modifying 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 menu Step 2 In the Contact Lists...

Page 61: ...t list Step 3 Click Delete A Delete message appears Step 4 Click Yes to delete the contact list or click No to stop the deletion Note Alternatively you can delete a contact list by clicking Delete when you are in the dialog box for modifying the list Creating Modifying and Deleting Egress Route Attributes This section describes the steps to create modify and delete Egress Route Attributes Creating...

Page 62: ...y is optional Step 5 In the Max box enter the maximum percentage of calls that the associated carrier may terminate on a route associated with this route attribute The range is 0 to 100 This entry is optional Step 6 In the Max Units box enter the maximum number of egress units this carrier may terminate on a route associated with this route attribute This entry is optional Step 7 In the Carrier bo...

Page 63: ...or date as in 2002 12 03 hour 0 23 min 0 60 sec 0 60 for time as in 12 59 10 d If you select Constant the egress route attribute is applied at all times of all days Note If two RouteAttributes exist in the same timeframe with the same date and time constraint the RouteAttribute is nondeterminstic That is the order of selection among time intervals of the same type that overlap cannot be determined...

Page 64: ...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 ...

Page 65: ...bute in Active Dataset Step 4 Change the information accordingly Step 5 Click Modify to save the changes or click Cancel to cancel the changes Deleting Egress Route Attributes Step 1 In the Active Dataset tab screen in the CSR window click the down arrow in the Selection box then select Egress Route Attributes from the pull down menu Step 2 Click the down arrow in the Carriers box then select the ...

Page 66: ...e dialog box for modifying the attribute Creating Modifying and Deleting Ingress Route Attributes This section describes the steps to create modify and delete Ingress Route Attributes Creating Ingress Route Attributes Step 1 In the Active Dataset tab in the CSR window click the down arrow in the Selection box then select Ingress Route Attributes from the pull down menu Step 2 Click New The New Ing...

Page 67: ...ry is optional Step 5 In the Max box enter the maximum percentage of calls that the associated carrier may originate on a route associated with this route attribute The range is 0 to 100 This entry is optional Step 6 In the Max Units box enter the maximum number of ingress units that this carrier may originate on a route associated with this route attribute This entry is optional Step 7 In the Car...

Page 68: ...me frame with the same date and time constraint the RouteAttribute is nondeterminstic That is the order of selection among time intervals of the same type that overlap cannot be determined Step 9 In the Available Routes box click Add or Remove to add or remove a route from the Associated Routes box respectively Step 10 Click Add to add this ingress route attribute or click Cancel to exit Modifying...

Page 69: ... Step 1 In the Active Dataset tab in the CSR window click the down arrow in the Selection box then select Ingress Route Attributes from the pull down menu Step 2 Click the down arrow in the Carriers box then select the appropriate carrier from the pull down menu Step 3 In the Ingress Route Attribute list select an attribute You can select more than one attribute by holding down the Ctrl key while ...

Page 70: ... arrow in the Selection box then select Match Patterns from the pull down menu Step 2 Click New The following New Pattern dialog box appears Figure4 30 Dialog Box for New Pattern in Active Dataset Figure4 30 Dialog Box for New Pattern in Active Dataset The Pattern Key on this screen is the primary key of this pattern in the Match Patterns Table When a new pattern is being created is displayed Step...

Page 71: ...or New Match Pattern 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 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 You can select more than...

Page 72: ...g box appears Figure4 32 Dialog Box for New Route in Active Dataset Figure4 32 Dialog Box for New Route in Active Dataset The key shown on the screen is the primary key of this route in the Route table When a new route is being created is displayed Step 3 In the Name box enter the name of the route The range is 1 to 64 characters This entry is optional Step 4 In the Rule box click the down arrow t...

Page 73: ... the Available Patterns box select a pattern and click Add to add a pattern to the route The patterns in this box are not bound to this route until they are added to the Patterns in Route box Click Remove to remove a pattern bound to the route Note A pattern can be bounded to only one route at a time If you add a pattern to the Patterns in Route list that pattern is removed from all other routes S...

Page 74: ...tes Step 1 In the Active Dataset tab in the CSR window click the down arrow in the Selection box then select Routes from the pull down menu Step 2 In the Routes area select a route You can select more than one route by holding down the Ctrl key while clicking each route Step 3 Click Delete A Delete message appears Step 4 Click Yes to delete the route or click No to stop the deletion Note Alternati...

Page 75: ...re4 35 Dialog Box for New Rule in Active Dataset The key shown on the screen is the primary key of this rule in the Rules table When a new rule is being created is displayed Step 3 In the Name box enter the name of the rule The range is 1 to 64 characters Step 4 In the Min QoS box enter the lowest QoS level associated with this rule The range is 1 to 9 Step 5 Click the checkbox to the left of Is D...

Page 76: ... Egress Cost Greater Than Ingress If the ingress carrier and egress carrier both have a provisioned cost and the egress carrier s cost is greater the egress carrier is eliminated Reject Insufficient QoS If the rule has the following elements the egress carrier is eliminated A provisioned minimum QoS The egress carrier has a QoS value available The egress carrier s QoS is worse higher Reject Max Eg...

Page 77: ... list Select Preferred Carrier If the preferred carrier is an egress carrier candidate it is selected and all others are deselected When this is selected click the down arrow in the Preferred Carrier box A preferred carrier pull down menu appears Percentage Termination Find the best candidate egress carriers farthest from meeting their provisioned maximum percentage on this route This is based on ...

Page 78: ...ng Rules Step 1 In the Active Dataset tab in the CSR window click the down arrow in the Selection box then select Rules from the pull down menu Step 2 In the Rule area select a rule You can select more than one rule by holding down the Ctrl key by clicking each rule Step 3 Click Delete A Delete message appears Step 4 Click Yes to delete the rule or click No to quit deleting Note Alternatively you ...

Page 79: ...it cannot be loaded into the active CSR memory After verification a message with the verification results appears Note You can use a name and an ID for a carrier contact contact list route attribute match pattern route and rule The ID must be unique Updating Inactive Datasets This section describes how to update inactive datasets by using the Inactive Dataset tab in the CSR window to create modify...

Page 80: ...ve Dataset Tab in CSR Window Only one functionality in the Inactive Dataset tab is different from those in the Active Dataset tab The additional functionality Destroy Dataset is described in the following section See Updating Active Datasets section on page4 12 for details on all other functionalities Destroying Inactive Datasets Step 1 In the Inactive Dataset tab in the CSR window click Destroy D...

Page 81: ...a to verify the inactive dataset Step 2 Click the Configuration Management tab and click Swap Active Inactive Datasets to swap the inactive dataset to active dataset Step 3 In the Select Dataset box click Load Dataset into CSR Step 4 Click Swap to swap the datasets or click Cancel to cancel swapping Also see Swapping Datasets section on page4 12 CSR Commands This section describes how to use the C...

Page 82: ... 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 box enter the origination pattern Step 3 In the DNIS box enter the pattern dialed Step 4 In the Source Carrier Id box enter the ingress carrier to be used for testing Step 5 In the Destination Carrier Id box enter the test egress carrier ...

Page 83: ...he current date is used Format and example for date entry are 4 digit year 2 digit month 2 digit day for date as in 2002 12 03 Step 8 Click the button to the left of Active or Inactive for the provisioned dataset for running the test This dataset is stored in the CSR database The current dataset in CSR memory is not used Step 9 Click Send Test to CSR to send the request to the CSR for processing T...

Page 84: ...ed to the database The logging level is set to Informational for all test requests See AppendixA Logging for more detail on syslog The following sections describes other CSR functionalities in the CSR Commands tab in the CSR window Updating Logging Level To specify the logging level click Update Logging Level Loading the Active Dataset To load the active dataset into memory for use click Load Acti...

Page 85: ...rrier and per route carrier for the CSR This is the same data used by the Test Route Request functionality Updating Gatekeepers To update the CSR gatekeepers table click Update GateKeepers The CSR unregisters each message type from each gatekeeper and reconnects the gatekeepers on the current list Cleaning Test Results To purge all the test requests inputs and outputs from the database click Clean...

Page 86: ...e 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 results occur If two or more users are modifying the same data the last saved data is the current data A deleted item is visible to a user if another user removes it Added data may not be seen immediately by all users ...

Page 87: ...ne in the syslog conf file describes the type of message the location and how that message should be handled Available message levels in syslog are as follows emerg Emergency panic alert Alert crit Critical errors err Other errors warning Warning notice Notice info Informational messages debug Debugging messages none Do not send message to file Note The Carrier Sensitive Routing application sends ...

Page 88: ... Syslog sends all error messages notice messages and error message from the authorization system to var adm some_messages file err notice auth err var adm some_messages ExampleA 4 Syslog sends error messages to console and var adm messages file separately err dev console err var adm messages Note Log messages can be captured in more than one location ExampleA 5 Syslog sends message to the adminuse...

Page 89: ...R Started Note This is logged at err level to note when the CSR was started even if debug and informational logging is off Jan 2 13 01 15 ciscoe250 CSR01 8333 DEBUG Current size of call queue 0 2 known GateKeeper s Jan 2 13 01 17 ciscoe250 CSR01 8333 INFO Report Version notification received CSR Version reported to the database Jan 2 13 01 18 ciscoe250 CSR01 8333 DEBUG Current size of call queue 0...

Page 90: ...A 4 Cisco Carrier Sensitive Routing User Guide AppendixA Logging Viewing Logs ...

Page 91: ...tionData ActiveDataset text NOT NULL DEFAULT _1 CONSTRAINT ActiveDatasetSuffixInvalid CHECK lower ActiveDataset _1 OR lower ActiveDataset _2 LoggingLevel text NOT NULL DEFAULT Error CONSTRAINT LoggingLevelInvalid CHECK lower LoggingLevel error OR lower LoggingLevel info OR lower LoggingLevel debug CSR_ID varchar 64 NOT NULL CSR_Version text GKTMP_Versioninteger Priority integer NOT NULL DEFAULT 1C...

Page 92: ...lean NOT NULL DEFAULT FALSE RejectNoDstCarrier boolean NOT NULL DEFAULT FALSE CREATE TABLE GateKeepers GKKey integer NOT NULL PRIMARY KEY GKID varchar 64 NOT NULL UNIQUE GK_IP inet NOT NULL GK_Port integer NOT NULL CONSTRAINT GK_PortInvalid CHECK GK_Port 0 AND GK_Port 32767 ListenARQ boolean NOT NULL DEFAULT FALSE ListenLRQ boolean NOT NULL DEFAULT FALSE ListenIRR boolean NOT NULL DEFAULT FALSE Li...

Page 93: ...64 SrcCarrierID varchar 64 DstCarrierID varchar 64 RunMe boolean NOT NULL DEFAULT FALSE HomeCarrierID varchar 64 ResultCode text CREATE TABLE TestOutputs TestKey integer NOT NULL SelectOrder integer NOT NULL DstCarrierID varchar 64 NOT NULL ListKey integer NOT NULL IsSelected boolean NOT NULL DEFAULT FALSE CREATE TABLE LogEntries TestKey integer NOT NULL EntryOrder integer NOT NULL LogString varch...

Page 94: ...rr OR lower MsgType rai FilterType text NOT NULL CONSTRAINT FilterTypeInvalid CHECK lower FilterType endpoint OR lower FilterType supportedprefix OR lower FilterType destinationinformation OR lower FilterType remoteextensionaddress OR lower FilterType redirectreason OR lower FilterType answercall OR lower FilterType notificationonly Value text NOT NULL ALTER TABLE TestOutputs ADD FOREIGN KEY TestK...

Page 95: ...rID varchar 64 NOT NULL UNIQUE MaxIngressUnitsinteger CONSTRAINT MaxIngressUnitsInvalid CHECK MaxIngressUnits 0 MaxEgressUnitsinteger CONSTRAINT MaxEgressUnitsInvalid CHECK MaxEgressUnits 0 RuleKey integer ListKey integer NOT NULL isActive boolean NOT NULL DEFAULT TRUE CREATE TABLE Carriers_1 INHERITS Carriers CREATE TABLE Carriers_2 INHERITS Carriers CREATE TABLE MatchPatterns PatternKey integer ...

Page 96: ...D MinQoS 9 PreferredCarrierKey integer RejectMaxOriginationPercentageboolean NOT NULL DEFAULT FALSE RejectMaxIngressUnits boolean NOT NULL DEFAULT FALSE RejectMaxIngressUnitsPerRouteboolean NOT NULL DEFAULT FALSE RejectEgressCostMoreThanIngressbooleanNOT NULL DEFAULT FALSE RejectInsufficientQoS boolean NOT NULL DEFAULT FALSE RejectMaxEgressUnits boolean NOT NULL DEFAULT FALSE RejectMaxEgressUnitsP...

Page 97: ...PreferredCarrier 0 AND SelectPreferredCarrier 5 SelectPercentageEgress integer NOT NULL DEFAULT 0 CONSTRAINT SelPercentageEgressInvalid CHECK SelectPercentageEgress 0 AND SelectPercentageEgress 5 CREATE TABLE Rules_1 INHERITS Rules CREATE TABLE Rules_2 INHERITS Rules CREATE TABLE Contacts ContactKey integer NOT NULL PRIMARY KEY CONSTRAINT ContactKeyNotZero CHECK ContactKey 0 RASAddress varchar 64 ...

Page 98: ...1 INHERITS Lists CREATE TABLE Lists_2 INHERITS Lists CREATE TABLE ContactLists ListKey integer NOT NULL ContactKey integer NOT NULL CREATE TABLE ContactLists_1 INHERITS ContactLists CREATE TABLE ContactLists_2 INHERITS ContactLists CREATE TABLE RouteAttributes AttributeKey integer NOT NULL PRIMARY KEY CONSTRAINT AttributeKeyNotZero CHECK AttributeKey 0 AttributeName text CarrierKey integer NOT NUL...

Page 99: ...te EndDate date Cost integer CONSTRAINT CostInvalid CHECK Cost 1 MaxUnits integer CONSTRAINT MaxUnitsInvalid CHECK MaxUnits 0 MaxPercentage integer CONSTRAINT MaxPercentageInvalid CHECK MaxPercentage 1 AND MaxPercentage 100 CREATE TABLE IngressRouteAttributes_1 INHERITS RouteAttributes CREATE TABLE IngressRouteAttributes_2 INHERITS RouteAttributes CREATE TABLE EgressRouteAttributes QoS integer CON...

Page 100: ...NHERITS RouteParent CREATE TABLE EgressRoutes_1 INHERITS RouteParent CREATE TABLE EgressRoutes_2 INHERITS RouteParent COMMIT BEGIN WORK CREATE UNIQUE INDEX Carriers_1_PKey ON Carriers_1 CarrierKey CREATE UNIQUE INDEX Carriers_2_PKey ON Carriers_2 CarrierKey CREATE UNIQUE INDEX Carriers_1_ID ON Carriers_1 CarrierID CREATE UNIQUE INDEX Carriers_2_ID ON Carriers_2 CarrierID CREATE UNIQUE INDEX Patter...

Page 101: ...UNIQUE INDEX ECA_1_PKey ON EgressRouteAttributes_1 AttributeKey CREATE UNIQUE INDEX ECA_2_PKey ON EgressRouteAttributes_2 AttributeKey CREATE UNIQUE INDEX ContactLists_1_Key ON ContactLists_1 ListKey ContactKey CREATE UNIQUE INDEX ContactLists_2_Key ON ContactLists_2 ListKey ContactKey CREATE UNIQUE INDEX QoS_1_Key ON QoS_1 IngressCarrierKey EgressCarrierKey RouteKey CREATE UNIQUE INDEX QoS_2_Key ...

Page 102: ...ey DEFERRABLE ALTER TABLE Routes_1 ADD FOREIGN KEY RuleKey REFERENCES Rules_1 RuleKey DEFERRABLE ALTER TABLE Routes_2 ADD FOREIGN KEY RuleKey REFERENCES Rules_2 RuleKey DEFERRABLE ALTER TABLE MatchPatterns_1 ADD FOREIGN KEY RouteKey REFERENCES Routes_1 RouteKey DEFERRABLE ALTER TABLE MatchPatterns_2 ADD FOREIGN KEY RouteKey REFERENCES Routes_2 RouteKey DEFERRABLE ALTER TABLE Rules_1 ADD FOREIGN KE...

Page 103: ...ABLE ALTER TABLE QoS_2 ADD FOREIGN KEY RouteKey REFERENCES Routes_2 RouteKey DEFERRABLE ALTER TABLE IngressRoutes_1 ADD FOREIGN KEY RouteKey REFERENCES Routes_1 RouteKey DEFERRABLE ALTER TABLE IngressRoutes_1 ADD FOREIGN KEY AttributeKey REFERENCES IngressRouteAttributes_1 AttributeKey DEFERRABLE ALTER TABLE IngressRoutes_2 ADD FOREIGN KEY RouteKey REFERENCES Routes_2 RouteKey DEFERRABLE ALTER TAB...

Page 104: ...B 14 Cisco Carrier Sensitive Routing User Guide AppendixB Data Schema Dataset Schema ...

Page 105: ...vity Loss Gatekeeper Connectivity Loss Database Connectivity Loss During connectivity loss CSR attempts to reconnect to the database every minute and it continues to handle gatekeeper requests with the current dataset in memory However the following are not available Tools associated with the database as follows psql pg_dump createdb dropdb GUI Additional active dataset not in memory ...

Page 106: ...ctivity 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 connectivity loss CSR attempts to reconnect to the gatekeepers every minute You can also use the GUI to attempt a reconnection by clicking Update GateKeepers in the CSR Commands tab in the CSR window ...

Page 107: ...sion 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 location confirm message LRJ location reject message LRQ location request message ...

Page 108: ...Glossary GL 4 Cisco Carrier Sensitive Routing User Guide R RAI resource availability indication message RRQ registration request message U URQ unregistration request message ...

Page 109: ...sources 1 3 Logging Level Debug 4 4 Error 4 4 Information 4 4 see also Updating Logging Level 4 45 LRJ 1 2 LRQ 1 2 R RAI 1 2 registration messages 1 2 root 1 1 Rules Prevent ITSP to ITSP 1 4 Reject Egress Cost Greater than Ingress 1 4 Reject Insufficient QoS 1 4 Reject Max Egress Units Exceeded 1 4 Reject Max Egress Units per Route Exceede 1 4 Reject Max Ingress Units 1 3 Reject Max Ingress Units ...

Page 110: ... 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 4 TestOutputs 1 3 TestRoutes 1 3 U URQ 1 2 ...

Reviews:

No comments