Home

PortaBilling: User Manual

Contents

1. 54 Use ODBC to connect to PortaBilling see 54 Using redirect number feature sss 60 Isolate network of Big client so you do not have to track their individual gateways sss tentent neni 61 Isolate your TIG WOFK eee Hl Decem certe eon etit 64 Configure outgoing connection to vendor if send calls using gatekeeper so remote IP address is not known in advance 66 Force PortaBilling to disconnect after a customer talks over his credit eem 67 Create accounts be to used for SIP 67 Integrate PB logins in your web 5 67 Configure Web Subscription 68 7 Mantenadli6B 71 Conbig labori TII 1d erc RO 76 c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 9 PORTA Billing1OO PortaBilling Guide Part 11 Preface This document provides PortaBillling100 user with the most common examples and guidelines on setting up a VoIP network The last section of the document answers the most frequent questions users encounter after running PortaBilling100 for the first time Where to Get the Latest Version of this Guide The hard copy of this guide is updated at major releases only and does not alway
2. Each of the remote customer gateways will be represented as an account and will be billed accordingly Hence we need to create a product which this account will have so it will have a defined way to bill the account If you have per customer specific rates tariffs then you will need a product for each customer 1 In the Management section of the Admin Index page choose Products 2 On the Product management page click Add icon 3 Fill in the Add product form O O O Product name the product object name Currency Product currency Only tariffs which have the same currency will be permitted in the accessibility list Managed by if you plan for this product to be used for your reseller s accounts so that the reseller himself can change the parameters of this tariff and create new accounts with this product choose the customer s name from the menu Otherwise choose None here Breakage Balance left over which is considered useless for statistical purposes Accounts with a balance below the breakage will be counted as depleted This does not affect account authentication or authorization so the account can still make calls if there is enough money left to cover at least the first interval c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 1 7 PORTA Billing 100 Setting up a Wholesale IP Telephony Company o Maintenance period surcharge application interval will
3. rights Reserved www portaone com 13 PORTA Billing100 Setting up a Wholesale IP Telephony Company Termination services tariff rates cle B tog Effective From Destination roue Souris Country Interval sec Price USD min V Effective From Edit Destination 2 4 fig Delete Description First Hext First Next 24 55 Ll LEE ME eee 1 015000 015000 2004 07 29 Enter Rates Rates are per destination prices Please refer to the System Concepts chapter for more details on the billing parameters Managing rates online Managing rates online is very convenient for maintenance of existing rate tables and for reference purposes For new price lists or for major updates the offline method is better 1 When you are on the Tariff management page and you see the list of the available tariffs click the L Rates icon next to the name of the tariff When you are in the Tariff management for a particular tariff then click on the 5 Rates in the toolbar 2 When in the Edit Rates screen click 9 Add 3 Fillin required information o Destination destination prefix may be entered directly e g 47 for Norway ot you can access destinations directory by clicking the Destination link in the column header In the destinations directoty you can find the desi
4. E Calendar Mi Effective From Destination E America Vancouver Country Interval sec Price USD min Effective From Edit Destination m E MM DD Description First Next First HH24 MI SS 2004 July immediately Mo Tu We Th CZECH REPUBLIC 1 m 4202 28 28 301 2 3 4 Prague LE C S Ae n 1 045000 015000 2904 07 29 o Hidden Forbidden or Discontinued flags are optional 4 Click Save button in the toolbar or m icon on the left side of the row 5 Repeat if you need mote rates to be entered Managing rates offline NOTE There are Templates available in the PortaBilling powerful tool for uploading rates from the custom format data files However for this particular example we would assume that you prepare data in the default format of PortaBilling The rates table may be prepared with spreadsheet processor i e Microsoft Excel and imported into PortaBilling easily This is very convenient if you are going to make many changes For example you might increase all the prices by 10 1 Ifyou are not on the Tariff Management for your tariff go to the main menu click on the Tariffs and then click on the tariff name 2 Inthe Edit Tariff window move mouse over the Download button and hold it there until popup menu will appear Choose Now menu item and click on it This will
5. radcheck pl amp porta clients pl Radius Path_To_radius sh home porta billing radius_scripts radius sh Path_To_Config var db raddb Path To PID File var run radiusd pid General parameters of radius server required by scripts like self check Log Where logs should go Possible values are Syslog File and Console Log To File This would write PortaBilling log to the file on disk This is the default option and normally it is sufficient for both production and debugging Use other ways of logging only for special debug purposes For logging to file give the filename For logging to the syslog give description in T form of Syslog lt taci lary lt priority Log Dest var log porta billing log Path to log file Default is var log porta billing log Log_Dest syslog daemon warn NAS 13 232 103 106 Username 0007777777 Call_Cleanup Parameters in this section configure life time on the calls in the call cache Radius_Retransmits 5 Radius_Timeout 3 In order to know when we should no expect any more packets we should know what is the maximum possible delay that the request can be delivered to the Radius last possible retransmit Alive 1 60 If we bill by the keep alive requests we need to know what is the interval between them Incoming Session Lifetime 10 Call lifetime after incoming call leg was disconnected Default Lifetime 120 Default lifetime of the call
6. incoming charges feature disabled by default e On the PortaBilling master edit the home porta billing etc porta billing conf and make sute the following line is present in the Features section ChargeCustomerForIncomingCalls yes On the PortaBilling slave edit the home porta admin etc porta admin conf and make sure the following line is present in the Customers section ChargeCustomerForIncomingCalls 1 9 Define a PSTN from vendor connection which will describe the point when calls are delivered to your network from the vendor and therefore have costs associated with them Associate the tariff created in step 1 with this connection 10 Edit your reseller information Now on the Additional Info tab you will see a new select menu Incoming tariff Choose the tariff you created in step 2 then click xl Save amp Close So now when an account belonging to the reseller makes a call to the toll free number 18001234567 and there is matching PSTN from the vendor connection then makes an outgoing call to the Czech Republic 42021234567 and hangs up the following charges will be applied e The account will be charged for an outgoing call to 42021234567 according to his rates to the Czech Republic a CDR will be written to the database e For the vendor who terminated this call to the Czech Republic a CDR will be written which describes our termination cost e For the vendor who provided the toll free line a
7. In the Management section of the Admin Index choose Destinations 2 Click on the Get default set to download set of destinations as a CSV Comma Separated Values file 3 Open this file in Microsoft Excel or any other suitable program Edit the data if required 4 Save the file and close it in Excel 5 Switch back to the PortaBilling web interface and click the Upload on the Destinations screen 6 Typein the filename of the file you have edited or click on the Browse button and select the file 7 Click ml Save amp Close c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 9 PORTA Billing 100 Setting up a Wholesale IP Telephony Company Create Nodes This step is only required if you have not entered all of your gateways into the system before Now you have to enter your gateways as nodes PortaBilling requires some key information about your network equipment such as the IP address h323 id Radius shared secret etc NOTE Only your own gateways have to be entered as nodes Remote gateways which belong to the customer or the ones which legally belong to you but are solely used by customer are not considered as nodes i 4 Node Management gt 0 add O H323 ID Radius Client Oves Oui Hame h323 id IP Radius Client Delete HEB Add Node Save 8 Save amp Close Close Node Name test gw Node info h323 id t
8. Managed by None v Currency USD US Dollar v General Info Off Peak Period Off Peak Description Destination Group Set Free seconds Post Call Surcharge Login Fee Connect Fee Short Description Termination services Description What we charge our customers for calls they terminate on our network Ed e E 2 Add Tariff Name Termination services Currency USD Managed by None General Info Web Upload amp Download Email Upload Notepad Off Peak Period Off Peak Description Destination Group Set Free seconds 0 Post Call Surcharge Login Fee Connect Fee Short Description Description M 4 0 00000 0 00000 USD 0 00000 USD Termination services What we charge our customers for calls they terminate on our network LU Termination services tariff rates gt add i save Close Biog Effective From Destination Country Destination Desc v Proper Now v ription First Interval sec Next First Next Err Group Coue Price USD min Effective From 4 fig HH24 MI SS immediately CZECH REPUBLIC 0 15 0 15 2000 2004 Porta Software Ltd
9. Suggestions No Remote IP Auth no c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 13 PORTA Billing 100 Maintenance If PortaBilling should not warn you when it seems that your gateways do not authenticate incoming VolP sessions Admin server and web interface The configuration file is called the porta admin conf and located in the home porta admin etc directory It is automatically created by the installation program and populated with the initial configuration You might want to edit so system will better suite your needs porta admin conf Global System Name MyBilling Put some distinctive name of your system here sendmail usr sbin sendmail ZIP usr local bin zip UNZIP usr local bin unzip TempDir var tmp porta maintainer PortaBilling lt porta 100 mybilling com gt What shall be in the From address of the outgoing emails Time Zone America New York Default timezone when creating new objects such as user customer etc Debug 0 Check_Age 2 Pager 30 How many entries per page should be shown in tables This is master parameter can be altered for the individual forms Porta Realm admin 443 accounts 8445 cc staff 8446 customer 8444 Ports that different web interface parts are using Master DSN DBI mysql database porta billing host porta billing master UsGr rooc Password xxxx PrintError 1 Connect parameters for the master database Slave DSN DBI mysql databas
10. This step is only required if you have not define necessary destinations before There are two ways to insert new destination into the system e One by one using Add functionality on the web interface e Bulk update by uploading destinations from the file NOTE There is a file with the default destination set supplied with the PortaBilling You can download it and then upload it to the server However it might be possible that your business requires different types of prefixes so please check the data in the file before the upload Creating destinations in one by one 1 In the Management section of Admin Index choose Destinations c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 9 PORTA Billing 100 Setting up a Wholesale IP Telephony Company Destinations Prefix Country Description ABCDEFGHIJKLMNOPQRSTUYWXYZ Prefix Country Subdivision Description Delete 4202 CZECH REPUBLIC Not Applicable v Prague 4202 CZECH REPUBLIC Prague 2 Click on the amp Add button 3 Fill the required information This includes the phone prefix and the country Country subdivision is optional You can use the Description column to store some extra information about the destination for example if it is mobile or fixed number 4 Click Save 5 Repeat steps 2 4 for each additional destination Uploading a set of destinations from the file 1
11. 00 Billable calls zero duration calls Figure 5 1 Number of calls If the disconnect time on the CDR does not lie within the past 15 minutes the call may not be finished and will not be reflected in the graph See picture below call types 3 and 4 Zero duration calls The graph can also display possible problems in our system such as unexpectedly high number of failed calls By default this graph displays statistics for the last 30 hours Total minutes statistics The graph below gives you the ability to monitor how the call volume in your system changes each day ui 1 ru 5i gu isi qan a Week 27 Week z8 Week 29 Week 30 Billable calls minj c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 9g PORTA Billing100 Statistics and Monitoring Tools Master and slave MySQL servers statistics These statistics are accessible from the main admin menu via Database link in the Statistics section E 4 Database Load Wed Jul 28 11 23 11 2004 a QQ D Fri Jul 30 02 14 46 2004 200 T 150 EI Se eee EE MEINEN SS ae EEE E DR SoS M MM 18 00 00 00 Humber of queries Bi Number of threads Figure 5 2 These two graphs show values from status of our MySQL servers The green line indicates the number of queries processed by server every 15 minutes blue indicates number of threads running on the servet Qu
12. 11 12 13 14 51 15 16 17 18 19 20 21 52 22 23 24 25 26 27 28 53 29 30 31 May 2003 We ThFr Sa Su 18 X Ed 19 5 6 7 8 91011 20 12 13 14 15 16 17 18 21 19 20 21 22 23 24 25 22 26 27 28 29 30 31 Sep 2003 Mo Tu Th Fr SaSu 361 52 53 54 8 9 10 11 12 13 14 38 15 16 17 18 19 20 21 39 22 23 24 25 26 27 28 40 23 30 Jan 2004 Tu We ThFr Sa Su 1 WA a 4 2 et 3 12 13 14 15 16 17 18 4 19 20 21 22 23 24 25 5 26 27 28 29 30 31 Jun 2003 Mo Tu We ThFr Sa Su 22 1 24 9 10 11 12 13 14 15 25 16 17 18 19 20 21 22 26 23 24 25 26 27 28 29 27 30 Oct 2003 Mo Tu We ThFr Sa Su 40 DERE EN EJ 416 7 8 91011 12 42 13 14 15 16 17 18 19 43 20 21 22 23 24 25 26 44 27 26 29 30 31 Feb 2004 Tu We ThFr Sa Su 5 1 T 9 10 11 12 13 14 15 8 16 17 19 19 20 21 22 9 23 24 25 26 27 28 29 desired period CSV file will have structure as shown below c 2000 2004 Porta Software Ltd All rights Reserved www portaone com Download Options a c3 36 PORTA Billing 100 Statistics and Monitoring Tools Microsoft Excel 2002 12 31 2002 12 01 GenTel csv 7 OX E File Edit Yiew Insert Format Tools Data Window Help _ E 7 10 B 7 U 390905203 fa2 o bb 297 755100 297755100 390943697 295179301 297755100 414406029 414406029 297 755100 295574794 290040959 290049959 295009467 295009467 295500190 3 Dec 2002 1
13. E Billing100 Maintenance c 2000 2004 Porta Software Ltd All rights Reserved www portaone com Maintenance 71 PORTA Billing1OO Maintenance Configuration files There are two separate configuration files one for the billing engine master server and one for the web interface slave server Billing engine The configuration file is called the porta billing conf and located in the home porta billing etc directory It is automatically created by the installation program and populated with the initial configuration You do not have to edit it unless you want to alter the default behavior porta billing conf Only full qualifyed email addresses no local aliases please Global last resort email admin yourdomain com In case critical condition is detected e g radius server is down who should receive the email alert email header from porta billing yourdomain com What should be in the From field of the email alerts Suspicious Time Threshold sec 86400 Maximum acceptable difference in time sent by gateway and current time on server Default is 24 hours SOL Trace 0 If all SQL queries and their results should be logged to the PortaBilling log file Use with caution and only when detailed debug is necessary since it produces a huge log files Master DSN DBI mysql database porta billing User root Password Xxxxxx Connect parameters for the master database Simultaneous login prevention for debit acc
14. are mandatory 6 The translation rule is necessary if you send calls to the vendor in a format different from the one you use e g the number 420296111222 is sent to the vendor as 004202111222 so that you can convert the phone number to the correct format Outgoing rule is only present if PortaSIP is installed and is used to convert the number into the vendor specific format 7 Click 8 Save 2000 2004 Porta Software Ltd All rights Reserved www portaone com 21 PORTA Billing 100 Setting up a Wholesale IP Telephony Company 8 Repeat steps 3 5 to add more connections to the same vendor then click Close to exit to the Vendor Management screen 9 Repeat steps 2 7 to add connections for other vendors Create a Customer A Customer is an owner of Accounts The Customet s contact information 15 used to distribute generated accounts data and account usage information In the Management section of the Main Menu choose Customers On the Customer Management page choose Add Fill the New Customer form Please note that there are several tabs available on the screen with the extra information The most important fields are E Customer Management gt 8 cose too Type Representative Search Direct Customers v ANY v CDRs Accounts Subcustomers Currency Type Credit limit Balance E mail Status Delete 0 Prepaid card tes
15. be reflected in call history as separate line each time when charged Charged at the end of a specified period o Maintenance fee surcharge amount o Account default ACL the access level assigned by default to new accounts created with this product The ACL determines which operations may be performed by accounts on the self care pages The default value is Account self care pre defined ACL which allows all possible operations Description your description of the intended use of this product 4 Click lal Save Click on the Accessibility tab to edit this product s accessibility i 4 Product Management Bwa Sne Managed By Search sone Currency Managed By Description Delete Prepaid cards 05 None Prepaid cards Ha Add Product gt E save led coef W Product Name Customer SmartNet Termination Currency USD US Dollar v Managed None General Info Breakage 0 Maintenance Period Maintenance Fee Account default ACL Account self care v Info URL Description What we charge customer SmartNet for calls they terminate to us M Edit Customer SmartNet Termination Product gt 18 Add i Save gl Save amp close Close Bi Ratelookup 0 E Log Product Name Customer SmartNet Termination Currency USD Managed By Mone General I
16. by using the secure copy tool scp scp porta billing tgz porta admin lt slave server name gt X You will be prompted for the porta admin user password and then the archive will be copied into the porta admin user home directory on the slave server With a provided username and password the archive can be stored in any user home directory In a single setver configuration the secure copy tool is not necessary The regular copy command can be used instead c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 77 PORTA Billing1OO Maintenance 4 Remember the master binary logs position Login to the master MySQL server and enter the command show master logs Remember the last 109 nane you will need it to start replication on the slave server later 5 Restoring database from archive on the slave server Logged in as root on the slave server unpack the archive file to the mysql data directory To do this simply to the mysql data dir and enter command tar xvzf path tooJ porta blllimnmg tgz If you used the scp copy command as described earlier the lt path o may be replaced by the porta admin Delete old database stored in porta billing directory rm rf porta billing and then rename newly created porta billing copy tO porta billing mv porta billing copy porta billing Check the permissions on the unpacked files Normally all files and the porta billing directory must be own
17. download the current set of rates empty but will also provide you with an overview of the file structure 3 You will see File download dialog and will be prompted if you would like to save the file or open it from the current location We c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 1 5 PORTA Billing100 Setting up a Wholesale IP Telephony Company recommend you to save file into some folder you will be using in future for storing tariff data files and then open it in the Excel 4 You should see something similar to the screenshot below 8 File Edit view Insert Format Tools Data Window Help x D ux E GAY r M C 70 BZU 8 5 A gt AB 420 u A 8 lelo 0 Ui ipt 2 Ar Temi USD charms our customers for their calls we terminate 3 4 Offpeak P Free Seconds Post Call Login Fee Connect Fee 5 D D D 0 7 Destinatior Countr Descriptior Interval 1 Interval N Price 1 Price Offpeak In Off peak In Off peak FOff peak P Forbidder Hidden Discontin Effective From 8 420 CZECH REPUBLIC Proper 1 1 005 005 12 12 03 03 9 10 11 12 M4 csv An Termination 2 i Read Sum 38391 34809 5 Edit the file by adding more rows with the rate data so it looks similar to the screenshot below 6 Note that columns Country and Desctiption are only for reference purposes and are ignored during the import Also w
18. following charges will be applied e The account will be charged for an outgoing call to 42021234567 according to his rates to the Czech Republic a CDR will be written to the database e For the vendor who terminated this call to the Czech Republic a CDR will be written which describes our termination cost e For the vendor who provided the toll free line a CDR will be created which describes our incoming call cost e For the reseller two CDRs will be created and his balance will be modified accordingly For the call to 42021234567 according to his outgoing tariff wholesale rates O For the call to 18001234567 according to his incoming tariff Please note that these two calls will usually have a different duration The incoming call will be longer because the customer needs time to enter the prompts wait to be connected and so on In this case we charge the reseller for the actual incoming call duration te exactly the same duration we are charged by the toll free line vendor c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 49 PORTA Billing1OO How to Deal with technical prefixes and numbering formats c 2000 2004 Porta Software Ltd All rights Reserved www portaone com Different termination partners often require you to send number to them in some specific format For example your termination partner might require usage of the technical prefix 289013 so you have to send him 58901 420
19. gk client returns proxy client address to gw client of client gw client of client calls proxy client proxy client consults gk client to discover the true call s destination which is gw termination in this example gk client instructs proxy client to call gw termination proxy client completes the call to gw termination gw termination asks PortaBilling to authenticate proxy client IP address 10 Assuming that there is an account with Account ID equal to this IP 11 address PortaBilling sends authentication confirm message Upon call completion gw termination sends the stop accounting tecotd to PortaBilling with User Name proxy client IP and account with such Account ID is billed for the call c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 62 PORTA Billing1OO How to We would recommend a single proxy configuration in this case Installation must be done in cooperation with the client and include gatekeeper and proxy installation on the client network and PortaBilling configuration No gatekeeper or any other H 323 server reconfiguration in your network is necessary Today this should not be an issue as current Cisco gatekeeper proxy gateway software can be executed on the same box Client gatekeeper amp proxy configuration Provided below are important sample configurations NOTE all 3 logical instances in this sample could be configured on single Cisco chassis Sample client of
20. h323 gw id gw client h323 id NOT hostname domain 10 Upon call completion proxy sends a stop accounting record to PortaBilling WITHOUT h323 remote ip Network components configuration Provided are sample configurations NOTE all 3 logical instances could be configured on single Cisco chassis Sample client gateway interface description VoIP ip address 1 Lada 59 2092209340 h323 gateway voip interface h323 gateway voip id gk directory ipaddr 2 2 2 2 1718 h323 gateway voip h323 id gw client Common part for Gatekeeper and Proxy aaa new model aaa authentication login h323 group radius aaa authorization exec h323 group radius aaa accounting connection h323 stop only group radius radius server radius server radius server radius server Gatekeeper gatekeeper zone local gk directory your host PortaBilling your domain key your top secret vsa send accounting vsa send authentication domain 2 2 2 2 zone remote gk operator operator domain 3 3 3 3 1719 zone prefix gk operator accounting vsa lrg forward queries use proxy gk directory remote zone gk operator outbound from gateway use proxy gk directory remote zone gk operator outbound from terminal no shutdown H323 proxy shown on same chassis as gatekeeper hostname proxy ip domain name client gw accounting h323 vsa c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 65 PORTA Billing100 How to pro
21. in many cases the quality of VoIP is superior to that of traditional PSTN service c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 4 PORTA Billing100 Setting up a Wholesale IP Telephony Company Typical business case Central to the delivery of wholesale voice services are voice points of presence POPs which are interconnected to other service providers Minutes Aggregation and Resale Including ASP Termination service allows wholesale network providers to collect traffic from multiple originating providers then aggregate and deliver it to termination providers they select PORTA amp Billing100 Customer1 gw example Vendor The provider in this scenario is the owner of termination node POP gw examplel It is a typical example of a VoIP network where Customers pay the provider to terminate traffic at point An and the provider himself pays the Vendor for the traffic at point B The provider makes its profit on difference between Tariff he charges his customer An and Tariff he is being charged by the vendor c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 5 PORTA Billing100 Setting up a Wholesale IP Telephony Company Setting up your network components Configuring NAS gw example1 1 Basic router configuration It is highly recommended to use the latest telephony IOS and DSP firmware and to set the hostname the sa
22. parameter serves two purposes First of all it defines in which time zone customer will see his CDRs It also defines which time zone will be used to separate the customer s billing periods For example if you choose America New York with a monthly billing period here the customer s invoice will cover the period starting at 00 00 EST on the 1 of every month Web Interface Language the language to be used on the customer self care web interface c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 9 4 PORTA Billing 100 Setting up a Wholesale IP Telephony Company Click inl Save amp Close to save your work See PortaBilling Administrator Interface for more information Create Accounts NOTE before generating accounts for a production system read section Provisioning of prepaid accounts 1 If you are not yet in the Customers screen the one which contains a list of customers enter there It should look like the screenshot below 2 Next to the customer name click on the icon the one in the Accounts column it will take you to the account management for that customer Customer Management r Blad Groe togout Bog Type Representative Search Direct Customers v ANY v CDRs Accounts Subcustomers Currency Type Credit limit Balance Status Delete Prepaid card test USD Retail 0 00000 SmartNet USD Retail 0 0
23. reseller for incoming calls This is a very common situation You provide your reseller with the billing gateways and other required components When the end user makes a call you charge the reseller according to your wholesale rates But now the reseller wishes to give his subscribers the ability to use either a local access line or a toll free line c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 51 PORTA Billing1OO How to to access the service The reseller can use the accessibility feature to charge subscribers by different tariffs depending on the access number But what about the amount you charge the reseller Obviously when somebody calls a toll free line and then calls China your cost is higher than when somebody calls a local access line and then calls the same number in China This fact should be reflected 1n the reseller chatges PortaBilling allows you to charge your reseller not just for outgoing calls but also for incoming ones This is done when the call is crossing PSTN from the vendor connection In order to implement this follow these instructions 6 Create a tariff which defines your incoming line costs 7 Create a separate tariff which will describe charges for the incoming access numbers you would like to apply to your reseller for instance incoming calls to 1800 numbers will cost your reseller 0 02 min while calls to 1718 and 1206 numbers will be free 8 Activate the
24. s load graph 100 1 i i r5 1130 1301 434 100 120 calls 18 00 00 00 06 00 12 00 18 00 00 00 Load E setup Time ASR Load Threshold 5 This graph shows the node load setup time and ASR Average Success Rate statistics The green area indicates node load red shows relative setup time and the blue line indicates ASR Information appears on this graph with a one hour delay Now 900 Now 0 Time sec Assumptions calls with duration more then 3600 seconds are rare and don t affect our statistics very much zero duration calls need an average duration of 10 seconds to be processed by the router c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 31 PORTA Billing 100 Statistics and Monitoring Tools Connection load calculations For better understanding of the calculations performed consider the following diagram Now 900 Now 0 Time sec The total duration must be calculated for all calls processed by the system fitting the interval between now 1 hour 15 minutes and now 1 hour Four different call types are recognized in the above diagram an additional call type is that of zero duration Sum of durations of all these calls Sum of durations between 0 and disconnect_time Sum of durations between connect_time and t1 Calculate sum as number of calls 900 seconds Calculate sum as number of calls 10 sec Maxi
25. tariff which will describe charges for the incoming access numbers you would like to apply to your reseller for instance incoming calls to 1800 numbers will cost your c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 47 PORTA Billing1OO How to reseller 0 02 min while calls to 1718 and 1206 numbers will be free 3 Activate the incoming charges feature disabled by default e On the PortaBilling master edit the home porta billing etc porta billing conf and make sure the following line is present in the Features section ChargeCustomerForIncomingCalls yes e On the PortaBilling slave edit the home porta admin etc porta admin conf and make sure the following line is present in the Customers section ChargeCustomerForIncomingCalls 1 4 Define a PSTN from vendor connection which will describe the point when calls are delivered to your netwotk from the vendor and therefore have costs associated with them Associate the tariff created in step 1 with this connection 5 Edit your reseller information Now on the Additional Info tab you will see a new select menu Incoming tariff Choose the tariff you created in step 2 then click lal Save amp Close So now when an account belonging to the reseller makes a call to the toll free number 18001234567 and there is matching PSTN from the vendor connection then makes an outgoing call to the Czech Republic 42021234567 and hangs up the
26. this manual are for identification purposes only and are either trademarks or registered trademarks of their respective owners c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 1 PORTA Billing1OO PortaBilling Guide Part 11 Table of contents 3 4 Setting up a Wholesale I P Telephony Company 4 gt 5 Setting up your network components senes 6 BIMO leo rns 8 5 Statistics and Monitoring Tools 28 Billing servers health monitoring see 29 VoIP network performance statistics sse 31 I SCY Cece cect eects oat can 34 6 40 Charge my calling card customers XX min extra when they call toll free 41 Authorize and bill my customers by the phone number they calling from ANI based billing wo eee 41 Bill my customers who are connected via T1 E1 directly to some port on My 43 Authenticate bill my customers by the address of their gateway E 44 Use volume based 45 Charge reseller for incoming calls eene 47 Deal with technical prefixes and numbering formats 49 Troubleshoot incorrectly billed call eee 50 Create a custom TCL application sese 53 Make a custom report from
27. 0000 admin smartnet com Accounts of Retail Customer gt Account Generator cose B toot Account ID ANY Show Accounts i Add Account for Retail Customer SmartNet fe save S ase m BAccountID 205 12 34 56 Product USD Customer SmartNet Termination gBlocked Opening Balance o 2 L Account Info Subscriber Additional Info Life Cycle User Interface Tyne O Debit Credit Voucher screditLimit Password cisco zE mail Match smartnet New batch Accounts of Retail Customer toe Account ID ur CDRs Account ID Idle days Currency Balance Open Balance Credit Limit Type Product Batch Status 205 12 34 56 USD 0 00000 0 00000 Credit Customer SmartNettermination smartnetip 3 After you are in the account management form click on the 4 Add 4 Fill out the Add account form c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 95 PORTA Billing100 Setting up a Wholesale IP Telephony Company Account ID Identification of the account value which will be sent in the User Name attribute For the account which represents remote gateway it is normally an IP address Product choose the product which you would like y
28. 2 05 13 0651266276093 CHINA 062061711695 CHINA 067592242436 CHINA 067592242436 CHINA 062444153766 CHINA 062164985417 CHINA 067592242436 CHINA 064102217626 CHINA 064102217626 CHINA 067592242436 CHINA 9621658419898 CHINA 061067091308 CHINA 061067091308 CHINA 064154650661 CHINA 062159700603 CHINA 062067302621 CHINA hh 2002 12 31 2002 12 01 GenTel Ready The following data is available e CLI or ANI From e CLD or DNIS To e Country and description of the destination e Call start time e Charged time e Charged amount Country D Descriptio Connect Time Proper 3 Dec 2002 12 10 suangzho 3 Dec 2002 12 07 Proper Proper Proper Shanghai Froper Froper Froper Froper Shanghai Beijing Beijing shanqghal shanghal 3 Dec 2002 12 07 3 Dec 2002 12 05 3 Dec 2002 12 05 3 Dec 2002 12 04 3 2002 12 04 3 Dec 2002 12 04 3 Dec 2002 12 04 3 Dec 2002 12 04 3 Dec 2002 11 58 3 Dec 2002 11 57 3 Dec 2002 11 55 3 Dec 2002 11 53 3 Dec 2002 11 51 3uangzhor 3 Dec 2002 11 51 m m LL 44 ma 00 00 00 00 05 47 00 00 00 00 06 45 00 00 00 00 00 00 00 00 04 47 00 00 00 00 00 00 00 00 00 00 mm Charged Ti Charged amp mount 0 0 0 63617 Cost Revenue statistics These are essential tool for monitoring your business growth Working with different partners different currencies and different prices it is very easy to make a mistake and start carr
29. 21234567 instead of 42021234567 and your local phone provider requires that for outgoing calls numbers will be dialed without country code so a call to 42021234567 has to be dialed as 21234567 The more partners you have the more likely it is you will run into these problems with the different number formats Of course it is better to use single numbering format internally Our recommendation is to use E 164 format in billing and on your network E 164 compliant number is such number which consists of lt countrycode gt lt areacode gt lt phone gt Examples of valid E 164 numbers are 42021234567 and 16049876543 The following numbers are not valid E 164 numbers 6049876543 NANP format 01142021234567 US overseas dialing format 021234567 local format PortaBilling provides you with a powerful tool to convert all such strange numbers into the unified format to be used in billing For every connection to vendor you can specify translation rule which will convert number into the E 164 format Here are some ready to use examples of the translation rules e Convert NANP North America Numbering Plan phone number area code phone number e g 604 888 7766 into the E 164 s 1 e Convert European international dialing format 00 country code area code phone number e g 00 1 604 888 7766 into the E 164 s 00 e Convert North America international dialing format 011 country code area code phone number e g 011 1 604 8
30. 3741 ARMENIA Yerevan 13 983333 0 80521 13 983333 1 27417 133 78333 0 43476 6 15 1 70895 139 93333 2 35228 214 26667 2 35228 214 26667 1 51933 21 75 0 18463 2 166666 1 70396 23 916667 106 21 35 433333 11 2362 87 983333 0 18254 58 6166667 0 261 2 9666667 1 19768 1 19768 3 05561 0 98769 4 0433 3 20971 3 20971 3 66377 0 40983 2 00289 2 00289 4 32978 1 42247 5 75225 5 56199 5 56199 5 1831 0 59446 4 0736 5 77756 5 58076 111 7908 14 06189 25 289809 1 70489 1 52235 0 56698 0 84788 SmartNet SUBTOTAL SmartNet SmartNet SUBTOTAL SmartNet SUBTOTAL SmartNet SmartNet SUBTOTAL 12 Pre paid 13 SmartNet 61 AUSTRALI Proper 61404 AUSTRALIA 43 AUSTRIA Proper H 4 5 6 7 8 9 994 AZERBAIJ Proper 99450 AZERBAI Mobile s 25 375 BELARUS Proper 3 375 BELARUS Proper 14 Pre paid car 37517 BELARUS Minsk 15 SmartNet 37517 BELARUS Minsk gt 2004 02 20 2004 02 20 Inbound b Read The following data is available e Name of customer vendor e Destination prefix e Country and description of destination c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 38 PORTA Billing 100 Statistics and Monitoring Tools e Total number of successful calls e Gross margin difference between total revenue and the cost for this destination e Rated sec sum of the time charged for all calls to this destination in secon
31. 7 28 29 gt Jun 2004 TuWe ThFr SaSu 2 pup 3 34433 24 7 8 89 10 11 12 13 25 14 15 16 17 18 19 20 26 2 22 23 24 25 26 27 27 28 29 30 Nov 2003 TuWe ThFr SaSu 44 il 8 45 B3 A RH 46 10 11 12 13 14 15 16 47 17 18 19 20 21 22 23 48 24 25 26 27 28 29 30 Mar 2004 TuWe ThFr SaSu 19 HL ER 11 8 9 10 11 12 13 14 12 15 16 17 18 18 20 1 13 22 23 24 25 26 27 28 14 23 30 31 Jul 2004 Tu We ThFr SaSu 27 i3 9 5 28 ES B EROR 29 12 13 14 15 16 17 18 30 18 20 21 22 23 24 25 31 26 27 28 29 30 31 Download Options ch CDR Types Invoice C Debit 23 31 Choose customer and then click on the calendar to choose statistics for desired period CSV file will have structure as shown below a File Edit view Insert Format Tools Data Window Help DODGE 28 o rfi a Al v Account From To Country Description Connect Time Charged Charged Charged Time Time Amount min sec sec USD 03 00 180 0 15661 01 00 60 0 02428 24 00 00 1440 0 79992 20 00 1200 3 16382 04 00 240 0 09173 09 00 540 0 22933 07 00 420 0 22664 03 00 180 0 15661 01 00 60 0 04085 08 00 0 25664 01 00 60 0 01666 21 00 1260 1 42989 50 00 00 3000 3 38407 01 00 60 0 0166 Account 5167583578 unknown 1620944835 7188514399 2971379160 unknown 3618446434 7189345246 3860327653 7189539069 9348239454 2488900081 2971379160 unknown _ 8109655857 unknown 6109656857 unkno
32. 88 7166 into the E 164 s 011 e Convert Australian international dialing format 0011 country code area code phone number e g 0011 1 604 888 7766 into the E 164 s 0011 e Convert tech prefix format tech prefix country code area code phone number e g 6789 1 604 888 7766 into the E 164 s 6789 e Convert European domestic dialing format 0 area code phone number e g 0 5 888 7766 into the E 164 assuming that the country code 15 44 s 0 44 Always test your translation rules before inserting them into the billing There is a special test window available on the web interface in order to access it click on the test icon next to the translation rule field 49 PORTA Billing1OO How to Translation Rule Test Close window Translation rule s 0117 Input 011420222333444 Test Save Input 011420222333444 Output 420222333444 It will let you check if your translation rule has a proper syntax and also you can immediately see if it does the translation you need Troubleshoot incorrectly billed call 1 Make sure that someone in your organization is subscribed to the PortaBilling mail alerts especially Missing critical information This will help you detect problems early 2 Find the h323 conf id of this call This is unique ID string of four hex numbers generated by the gateway when the call was started and it will help you to exactly identify this particula
33. CDR will be created which describes our incoming call cost c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 59 PORTA Billing1OO How to e For the reseller two CDRs will be created and his balance will be modified accordingly For the call to 42021234567 according to his outgoing tariff wholesale rates O For the call to 18001234567 according to his incoming tariff Please note that these two calls will usually have a different duration The incoming call will be longer because the customer needs time to enter the prompts wait to be connected and so on In this case we charge the reseller for the actual incoming call duration te exactly the same duration we are charged by the toll free line vendot e Deal with technical prefixes and numbering formats chaptet e Call was billed and the phone number I see in the billing is correct but I get Mismatch in rates or destinations error Cause missing rate for that phone prefix in the tariff Remedy Create a rate for this destination in the tariff 5 If you are unable to solve the problem by yourself submit problem report to support portaone com Please make sute that you include in your email e Detailed description of the call flow and what seem to be incorrect e H323 conf id of the call e Relevant pieces from the porta billing log Create a custom TCL application Sometimes you need special call handling or functionality whi
34. Czech Republic and the other one with the toll free rates including your toll free cost there for example 0 17 dollar min for calls to Czech Republic TIP When calculating the price for the toll free line it is not enough to add together your ordinary price and costs of 1 minute of the toll free line In order to make a 3 minutes call customer will spend about 4 minutes on the line while listening to voice prompts entering PIN destination and waiting for an answer Additionally the situations where a customer will enter the incorrect PIN or is unable reach his party at all should be taken into account So usually TollFree_ Price Ordinary_Price X Toll_FreeCost where X is a ratio between the total duration of your incoming toll free calls and the total duration of the outgoing calls 2 Make sure your IVR script supports PortaBilling Original CLD feature 3 Create a product for your calling cards and put two entries into the Accessibility e One with CLD equal to your toll free number and Toll free tariff e Another one with CLD equal to your local access number and Ordinary tariff Authorize and bill my customers by the phone number they are calling from ANI based billing PortaBilling gives you great flexibility in choosing how you would like to authorize and bill your customers For the ANI based billing you just have to 1 Create a tariff or tariffs and a product Note If you are providing both p
35. Margin Measure day month GrossMargin Measure day GrossMargin MaxAge max age in days c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 5 PORTA Billing100 Maintenance GrossMargin_MaxAge 1000 ASR_days 90 ASR_weeks 52 ASR_month 10 It is not recommended to change these parameters without deep understanding of the RRD principles Load delay seconds Zero call length 10 Load delay interval 900 when ASR graph appears ASR Threshold 5 2000 StatCalc Interval 0 Mask OnlinePayment PassFile home porta admin etc passphrase txt Encryption key for merchant account passwords Pager 25 CDR How long CDRs should be kept in the database Keep month 2 Keep month failed 2 Replication repair o For better understanding of the following material it is highly recommended to read the Replication in MySQL chapter from www mysql com or follow the link http www mysql com doc R e Replication html In the most common situation recovering the replication process after a fault resembles setting up replication from scratch You should follow the instructions in the How to Set up Replication chapter of MySQL documentation But in our case master database shouldn t be stopped Let s go through the procedure step by step 1 Make sure slave database has stopped the slave thread Logon to the MySQL slave database using the the mysql command At the sl
36. PORTA ONE N d 1 M _ User Guide Part ll www portaone com PORTA Billing1OO PortaBilling Guide Part 11 Copyright notice amp disclaimers Copyright c 2000 2004 Porta Software Ltd All rights reserved PortaBilling100 User Guide Part II V 1 9 1 June 2004 Please address your comments and suggestions to Sales Department Porta Software Ltd 902 2181 W 38 Ave Vancouver BC V6M 1R8 Canada Changes may be made periodically to the information in this publication Such changes will be incorporated in new editions of the guide The softwate described in this document is furnished under a license agreement and may be used or copied only in accordance with the terms thereof It is against the law to copy the software on any other medium except as specifically provided in the license agreement The licensee may make one copy of the software for backup purposes No part of this publication may be reproduced stored in a retrieval system or transmitted in any form or by any means electronic mechanical photocopied recorded or otherwise without the prior written permission of Porta Software Ltd The software license and limited warranty for the accompanying product are set forth in the information packet supplied with the product and are incorporated herein by this reference If you cannot locate the software license contact your Porta Software Representative for a copy All product names mentioned in
37. R and Cost Revenue parameters are shown Billing statistics Customers CDRs List of all customers CDR are calculated daily and are split into files according to the customer s billing period These pre calculated statistics could be automatically mailed to customer Also they are available for download by customer on the customer self care pages and for your staff on admin interface Different types of CDR files are available depending on the type of customer CDR files for retail customers e Invoice calls made by the credit accounts of this customer These calls will be included on the customer s invoice for the corresponding billing period e Debit calls made by the debit accounts of this customer Since debit accounts are prepaid calls made by them do not affect the customer s balance or invoice Therefore they are included in a separate file so that the customer can easily monitor activities on his debit accounts CDR files for resellers e Wholesale CDRs calculated using the reseller s wholesale tariff These are the charges applied to the reseller and reflected on the his invoice e Retail calls made by an account of this customer and charged using the account s tariff This allows a wholesale customer to monitor the charges applied to his accounts c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 3 4 PORTA 8 Billing100 Statistics and Monitoring Tools NOTE Since now
38. RIVILEGES Query OK O0 rows affected 0 07 sec Installing the MySQL ODBC driver 1 Download and run the installation package from the http www tmysql com 2 Press Next on the information screens 33 MySQL Connector ODBC 3 51 Welcome Welcome to MySQL Connector ODBC 3 51 Setup program This program will install MyODBC 3 51 on vour computer It ig strongly recommended that you exit all windows programs QI before running this Setup Program Click Cancel to quit Setup and close any programs you have running Click Nest to continue with the Setup program WARNING This program is protected by copyright law and International treaties Unauthorized reproduction or distribution of this program or any portion of it may result in severe cvil and criminal penalties and will be prosecuted to the masimum extent possible under law http wm mysql conn 3i MySQL Connector ODBC 3 51 SU taata aaa taaa attt MySQL ODBC 3 51 Driver README C Copyright MySQL AB 1995 2002 SMA A A This the source binary distribution of ODBC For MySQL This software is distributed under General Public License OL GPL For more information read the file COPYING that comes along with this distribution As special exception to the MyODBC GPL license one is allowed to use MyODBC with any ODBC manager even the ODBC manager is not GPL In other words The ODBC manager itself is not affected by
39. Su 36 ES S ER 31 8 9 10 11 12 13 14 38 15 16 17 18 19 20 21 39 22 23 24 25 26 27 20 40 23 30 Jan 2004 Mo Tu We ThFr Sa Su 1 12334 2 ER ET 3 12 13 14 15 16 17 16 4 19 20 21 22 23 24 25 5 26 27 20 29 30 31 Jun 2003 Mo Tu We ThFr Sa Su 22 1 1111 24 9 10 11 12 13 14 15 25 16 17 18 19 20 21 22 26 23 24 25 26 27 28 29 27 30 Oct 2003 Mo Tu We ThFr Sa Su 40 4 6 7 8 9 10 11 12 42 13 14 15 16 17 18 19 43 20 21 22 23 24 25 26 44 27 26 29 30 31 Feb 2004 Tu ile ThFr Sa Su 5 1 11111 7 9 10 11 12 13 14 15 8 16 17 18 19 20 21 22 9 23 24 25 26 27 28 23 Download Options oa There are five variants of pre calculated reports e Inbound by Country information 1 split by customer and destination and sorted by country e Inbound by Customer information is split by customer and destination and sorted by customer e Outbound by Country information is split by vendor and destination and sorted by country e Outbound by Vendor information is split by vendor and destination and sorted by vendor e Inbound information is split only by destination 1 File Edit View Insert Format Tools Data Window Help DEAR o amp gt 5 2 gt v Customer mg Te SS ee ee ee Destination Country Description Calls Gross Rated Rated Total Total margin Sec i Revenue USD 0 80521 Customer N
40. a proxy See Isolate your network chapter above Then you can create Proxied VoIP to Vendor connection If you only have one such vendor where termination IP address is unknown beforehand and you are sure that everything which goes to the unknown IP address goes to this vendor you can use a special feature in PortaBilling to handle this situation You can create a VoIP to Vendor connection and put ANY as a remote IP address Any outgoing VoIP call which goes neither to one of your trusted nodes nor IP addresses explicitly defined in other connections will match this connection This method can be used as quick solution but has a few disadvantages comparing to using h323 proxy The most important is the fact that using c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 66 PORTA Billing1OO How to h323 proxy you can bill traffic which goes directly from your customer s GW to your vendor s GW Force PortaBilling to disconnect after a customer talks over his credit limit There is no need for the PortaBilling to do this because gateway 15 able to do it by itself When gateway authorizes account to make a call in the PortaBilling in case of successful authorization PortaBilling returns maximum credit time in the h323 credit time RADIUS attribute When gateway connects the call it starts the timer and when timer hits the zero it automatically disconnects the call Create accounts be to used for SIP S
41. aditional Radius ports used by many vendors without obtaining an official IANA assignment The official assignment is now ports 1812 1813 and users are encouraged to migrate when possible to these new ports Cisco notes radius server commands will be available only after issuing aaa new model command port for RADIUS accounting server default is 1646 see note above UDP port for RADIUS authentication server default is 1645 see note above Keep in mind Default ports for Cisco are 1645 1646 Defaults in etc services 1812 1813 radius server host name IP acct port 1812 auth port 1813 radius server key key radius server vsa send accounting radius server vsa send authentication 8 voice card 9 controller 10 voice port Dependant on your hardware configuration 11 call application voice amp deal peer s call application voice remote ip ftp remote ip authenticate 1l 1 1 tcl dial peer voice 10 pots destination pattern port OzD dial peer voice 11 voip application remote_ip incoming called number NOTE There is an Advanced remote authenticate application available at http store portaone com It contains many extra features beyond the default Cisco application and so we recommend using it instead of that application c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 7 PORTA Billing100 Setting up a Wholesale IP Telephony Compa
42. ave server shell command prompt enter following command mysql uroot p mysql root password porta billing c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 16 PORTA Billing100 Maintenance After that you will see the mysql command prompt Query the slave setver status by entering command show slave status MySQL displays the table with a status of slave replication Important You should see No as a value in the Slave Running column If You see Yes stop the replication process using this command slave stop 2 Make master database snapshot The MySQL distribution provides a special tool for this mysqlhotcopy To use this tool logon to the master server and at command prompt enter mysdglhotoopy flushlog u root p lt root password gt porta After the program completes you can find the porta billing copy database in your mysql data directory Normally the data directory is located at ust local var or var db mysql but may vary by installation Consult your mysql conf or system administrator if unsure Now you have a fresh snapshot of your database 3 Make archive of snapshot and copy it to the slave server As root uset go to the mysql data directory Enter the following command tar czvf porta billing tgz porta billing This command creates an archive of the snapshot Now it can be copied to the slave server The best way of doing that is
43. ch is not available in the applications you already have For example you need a prepaid card IVR which will try to do ANI authentication prior to the PIN authentication First of all check TCL applications available as a part of Cisco TCLWare package perhaps what you are looking for or something similar is already there If you find some application similar to what you need you can use it as template 7 There is a productivity tool for the TCL IVR e development available from the Porta Software Ltd FastIVR is an emulator of Cisco in regard to the FastiVR script execution TCL API VoIP related IOS commands You can find more information at http www portaone com solutions fastivr c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 53 PORTA Billing1OO How to Make a custom report from PortaBilling PortaBilling provides you with an open data model ER diagram of the database structure is not included in this document but available from the Porta Software Ltd upon request If you want to prepare custom reports on your workstation ot some non PortaBilling server you will need to e Make sure the remote computer has installed database drivers to access the PortaBilling database Normally you would use native MySQL connectivity on the Unix based hosts and ODBC on the Windows based hosts e For any data mining solutions extracting data from the database use only slave database e Use some tool like Cry
44. currency this customer will be billed Opening balance starting balance for the customer default is Zero Additional info o Billing period split period for vendor statistics User Interface Time zone the time zone which the vendor uses for his billing period Statistics will be divided by periods according to this time zone 4 Click Save amp Close 5 Repeat steps 2 4 to add all of your vendors c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 1 9 PORTA Billing 100 Setting up a Wholesale IP Telephony Company Vendor Management RR ad e B CDRs Connections Currency Balance E mail Delete X Telecom USD 43 37330 voip xtelecom com E Add Yendor gt sove sovencose tee Woe Currency USD US Dollar Opening Balance Address Info Additional Info El Company Name SPT Telecom Contact a 7 Phone 420 2 24010100 Firs Name Fax a Phone Addtess V Celnici Alt Contact E mail billing spt cz BCC Summary Province State 4 Code 11721 City m Prague Description Couflity Region czech Republic A Add Vendor gt E sive led sovencore coe toot Vendor Name SPT Telecom Cu
45. ds e Rated min sum of the time charged for all calls to this destination in minutes This is the same value as in the previous column only expressed in different units So for instance if Rated sec contains 180 here 3 0 will be shown e Total Cost summary of the amount charged for all the vendor s CDRs for this destination If the vendor uses a currency different than your base one this will be converted using the current exchange rate e Total Revenue summary for the amount charged for all the customer s CDRs for this destination If the customer uses currency different than your base one this will be converted using the current exchange rate Note that in the case of wholesale customers we use the value of the customer s CDR not the account s since your revenue is what is invoiced to the wholesale customer In addition you can use Custom Query report which is identical to the Custom Query report in the ASR statistics c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 39 PORTA E Billing100 How to c 2000 2004 Porta Software Ltd All rights Reserved www portaone com How to 80 PORTA Billing1OO How to Charge my calling card customers XX min extra when they call toll free line This is very easy to accomplish using the PortaBilling Accessibility feature 1 Create two tariffs one with your normal rates for example 0 13 dollar min for calls to
46. e USD min Volume qi Effective From A Delete Edit Destination Country Description x First Next First min YYYY MM DD HH24 MI SS ILL JL 1000 S 420 CZECHREPUBLIC Proper 0 00000 0 00000 2004 02 24 00 04 11 4200 CZECHREPUBLIC Proper 0 00000 0 00000 2004 02 24 00 00 47 CZECHREPUBLIC Prague 0 00000 0 00000 2004 02 24 00 04 24 CZECH REPUBLIC Prague 0 00000 0 00000 2004 02 24 00 01 01 2000 2004 Porta Software Ltd All rights Reserved www portaone com 4G PORTA Billing1OO How to Have reliable cost revenue figures if volume based billing is used If in addition to the volume lot you want to include price parameters in the rate then this will not be used to create a CDR for the customer and the customer s CDR will still show zero as the charged amount It will however be used to calculate your estimated revenue and will be stored in the vendor s CDR so it can be used for cost revenue calculations For example suppose you sold a volume lot of 50 000 minutes to Prague Czech Republic to a customer and he has now used it all up If you created his volume based rate with price 0 and your termination cost to the Czech Republic is 0 08 min then your cost revenue report will show 4000 which is incorrect However if you configured your rate as shown below and entered an average price minute the cost revenue statistics would show the actual figure of 1500 4 ABC volume ba
47. e porta billing mysql_socket tmp mysql slave sock User root 5 PrinrtErrorel Connect parameters for the slave database Backup Keep 1 X Rates Max age days Max age 60 Pager 25 c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 7 4 PORTA Billing1OO Maintenance Base Currency USD Web Login expiration seconds Login expire 172800 Login expire if not used seconds Passive expire 86400 Currency Pager 25 Default values for Card generator Default values for Account generator Billing_model Debit Credit Voucher Preferred_language lt 2 chars language name from iso 639 1 gt Cardissue Amount 1000 Balance 10 Life time 90 Length 12 Default PIN length Billing_model Debit Preferred_language en Default values for Add card manually Billing_model Debit Credit Voucher Preferred language 2 chars language name from iso 639 1 gt Addcard Balance 0 Life time 90 Batch Billing_model Credit Preferred_language en Default values for Rates Pager Lines per page Cleanup Interval interval for cleanup in days Rates Pager 50 Cleanup Interval 90 How long old not effective rates should be kept CustomerWeb Pager 50 Interval 1 AccountWeb 1 1 Pager 50 TraceCall Pager 50 Interval 1 Invoice Pager 50 Interval 1 Stats GrossMargin Interval 1 Gross
48. ed by the mysql user In a single setver configuration it will be the porta admin user X Note The above described action doesn t completely agree with MySQL documentation which instructs the user to dump the whole database to sql statements and then restore it on the slave machine Performing such an action on the production database with a large amount of traffic could result in significant latency Resume replication Logon to the slave mysql server using the mysgq1 command mysql uroot p lt root password porta billing Recall 109 name from the previous step and use it in the following statement CHANGE MASTER TO MASTER LOG FILE lt log_name gt MASTER LOG POS 4 c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 78 PORTA Billing1OO Maintenance At this point the mysql server must be restarted for replication to continue Following are the commands to stop and start mysql on a typical FreeBSD system u sr local etc rc d mysql server stop usr local etc rc d mysql server start On RedHat Linux systems the commands may be usr etc init d mysql stop usr etc init d mysql start The location may vary depending on operating system If in doubt ask your system administrator To ensure replication has resumed logon to the server and check slave status show slave status In the second row of Slave Running column you will see Yes c 2000 2004 Porta Software Ltd All rights Re
49. eeds For more information visit Http aan msg conn services http viens com Press FINISH button to exit from the installation 3 Press Finish Configuring ODBC Before configuring data source create MySQL user on slave DB with read only permissions Please consider the following document on how to add new user accounts to MySQL http www mysql com doc en Adding_users html 1 Control panel gt Administrative tools gt Data sources ODBC 2 Select myodbc3 test and click Configure Fill out the configuration form c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 57 PORTA Billing100 How to r ODBC Data Source Administrator User DSN System DSN File OSN Drivers Tracing Connection Pooling About User Data Sources Add dBASE Files Microsoft dBase Driver dbf Excel Files Microsoft Excel Driver nla Remove MS Access Database Microsoft Access Driver mdb muyadbc 3 test MySQL ODBC 3 51 Driver Configure An ODBC User data source stores information about how to connect to the indicated data provider User data source is only visible to you and can only be used on the current machine Cancel Help MySQL ODBC 3 51 Driver DSN Configuration V This dialog helps you in configuring the ODBC Data Source Mame that you use to connect to MySQL server DSN Information Data Source Name PortaBilling Descrip
50. elete qu test v ISDN 096 s 011 1 SPT Telecom ter Termination 124 E x HB Vendor SPT Telecom connections Add Save Save amp Close amp Close B Log gt Add Save m Save amp Close Close Bio PSTN from vendor from Vendor PSTN to Vendor VoIP to Vendor Proxied VoIP to vendor to Vendor Proxied VoIP to Vendor Edit Load Hode Port Transl Rule Outgoing Rule Tariff Description Capacity Delete qu test wv Prepaid cards gi atest ISDNO si011 SPT Telecom termin Termination Define connections This step is only required if you have not entered information about your vendors into the system before Vendors are your termination partners or providers of the incoming toll free lines In the Management section of the admin interface choose Vendors Click on the Connections icon next to the vendor name 3 Choose type of the connection PSTN to Vendor VoIP to Vendor etc by clicking on the corresponding tab 4 Press 3l Add to add a new connection 5 Fill in the connection information If you send traffic to vendor via telephony choose node and enter optional port pattern If you send traffic via VoIP enter the remote IP address Choose tariff which defines your termination costs for this connection vendor For all connection types Description and Capacity
51. epaid minutes you will simply create another volume based rate Or if you wish to give him 100 minutes every month simply create volume rates for 100 minutes effective from the Ist of February the 1st of March etc Wholesale volume lot Let us suppose a customer buys from you 50 000 minutes to the Czech Republic and 30 000 minutes to Prague Since he has prepaid you for these minutes you want to make sure that as soon as his lot to the given destination is used up no further service is provided 1 Create a new volume based tariff choose Volume Based in the Type menu in the Add tariff form 2 Enter the default rates These rates should not be volume based keep the Volume Time column empty as they are the rates to be used if the volume lot is used up So in our example we will enter the rate for destinations 420 and 4202 marking them Forbidden 3 Now create a rate for prefix 420 with volume lot 50 000 and a rate for prefix 4202 with volume lot 30 000 So now the customer can make calls to both the Czech Republic and Prague If he tries to call 4202123456 and his lot for Prague is used up the Forbidden rate will be applied during authorization thus the call will be rejected At the same time however he can still call the rest of the Czech Republic HB ABC volume based tariff rates E Add i save Close tariff togout Effective From Destination wj esu Interval sec Pric
52. eries The graph indicates how many times clients are querying the database On recommended hardware the value can be more then 200 without any problems High peaks with number of requests over 2000 can indicate wrong configuration of the system or temporary problems Also these peaks can appear when replication was restored after a system fault Threads Normal values for these graphs are for the Master server lt 2 for the Slave server gt 1 and lt 3 Normally these values depend on processes that run on the server such as the Radius daemon the Apache httpd server statistics collection tools etc Greater values can indicate other client connections to the server If the number of threads on the slave name server is 0 it means the replication process is down and requires administrator attention see 2 4 for details c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 30 PORTA Billing100 Statistics and Monitoring Tools VoIP network performance statistics Connection load You can monitor load and quality parameters of the individual connections To see list of the available connections from the Statistics section in the main menu follow Connections link Connection Load Vendor PSTH from Vendor PSTH to Vendor VoIP to Vendor Proxied VoIP to Vendor 3 Termination SPT Telecom A Telecom After you will pick a vendor and particular connection you can see it
53. ervices There are no special requirements how such accounts should be created For all services supported by PortaBilling H323 SIP you use the same interface to create and manage accounts After that accounts can use H323 SIP or SIP amp H323 services depending on their product s accessibility So if you plan that accounts with the certain product should be able to login to SIP server and make outgoing calls make sure you will include the PortaSIP node with the appropriate tariff into the Accessibility for this product Integrate PB logins in your web site You can include the login form on your website using the following HTML code lt form name log method post action https pb mycompany com login html L gin lt input type text name Uuser value gt Password lt input type password name password value gt lt input type button value Login onClick Ssubmit gt lt input type hidden name redirectOnLoginError value www myweb com gt lt form gt redirectOnLoginError in case if unsuccessful login PortaBilling will redirect the browser to the URL specified in the value attribute c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 67 PORTA Billing1OO How to Configure Web Subscription Typical steps of Web Subscription configuration Decide where you going to host your Web Subscription page It could be your corporate web site for instance Find out what is t
54. est gw mydomain com Type VOIP GU cisco Manufacturer Cisco 123 45 67 89 h323 password NAS IP Address Hostname test gw Domain mydomain com Radius Client Auth Transl Rule f Radius Key secret n Time Zone America Vancouver Radius Source 123 45 67 89 lt i Node Management gt cose MH Logout H323 ID Radius Client Oves Hame h323 id IP Radius Client Delete qw test gw test my domain com 123 45 67 89 A x Submitted infor mation is being cached in the billing engine and will not take effect immediately Default caching time is 10 minutes Please contact your system administrator for more information 1 In the management section of the Admin Index page choose Nodes 2 In the Node management window click the 2 Add icon 3 Fill in the New Node form Node name some short descriptive name for this node will be used in the select menus c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 10 PORTA Billing100 Setting up a Wholesale IP Telephony Company H323 ID h323 id recommended hostname domainname H323 Password If you plan to use default Cisco remote IP authentication script put cisco here o NAS IP Addtess IP address of the h323 interface o Auth Translation rule u
55. extensions Hardware solution advantages Simplicity out of the box functionality In most cases there is only one option for negotiating heterogeneous protocols Rapid deployment Almost no maintenance is necessary Hardware solution disadvantages It 1s expensive Unnecessary protocol translations Late problem detection it is always necessary to place a call first c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 60 PORTA Billing1OO How to Software solution advantages Cost efficient In the case of network interconnection running the same protocol it is a native solution with maximum interoperability and transparency Early problem detection the system is aware of the remote network state Software solution disadvantages There is the potential need for protocol translation More complex Both patties software versions must be synchronized Isolate network of Big client so you do not have to track their individual gateways If the client has more than one gateway it is possible to enter all gateways into the PortaBilling as separate accounts Each of them will be billed separately and Customer who owns them will carry a total balance Usually this is fine if all gateways are owned and provisioned by your client for himself or in other words if the client is the end user This case could be outlined as Low and stale number of gateways Stable gateway config
56. fot previous days or obtain data online using Custom Query For pre calculated statistics click on the vendor on the left side and then choose statistics period in the calendar Pre calculated statistics will look similar to the example below Ei Microsoft Encel 2004 06 30 2004 06 01 PaeTec csv BEE wew jet Took Wires Type gt Et Gay amp lt 7 Ww r Hi e O RIUESERGHSs EZ 5 A 7 A m A B D G H i Fin Country Dasernplian Connect Time Changed Time amp Changed Amount USO 35 d 7185213590 6463559218 Diehl Cust Srt 5102004 11 04 342 0 111 6463555219 aen toll free ETO 8 23 5106 0 153 x 3r3364r557 6463569217 Den Sales B 2 2004 14 22 1 18 0 039 39 3175819389 6463559219 Diehl im boll free Eur B 52 Dx 0 015 an Ba z327 2204 76137544255 RUSSIAN FEDERATION Proper BAI 3 34 0 00 0 41 3155262036 12425025550 Proper 5 0 2004 15 35 0 00 42 EIS TRI 12425005590 BAHAMAS Proper 15 33 0100 12425023550 BAHAMAS Proper EA 15 29 unknean 1037248643016 North America E 8 2004 15 23 0 00 TY SEES 1416400700 CANADA 15 23 135 0 048 14257891107 19204351215 UNTED STATES Wiscorrsin 15 23 0 30 0 015 rn 33169020317 FRANCE Proper E 8 2004 15 21 0 30 0 0115 231414512 18453313649 UNITED STATES a
57. he URL of the page which will submit request for creating an account in PortaBilling You will need to put it into the Subscription HTTP REFERER field You will need https server and digital certificate in order to secure credit card transactions Create Web Subscription HTML form using example provided with PortaBilling and put it to your web site You can add or remove some fields in order to achieve the functionality you need i c you can request to enter account ID if you doing ANI based service or may not if you are in debit card business etc In the configuration file of the web servet usr local etc apache porta httpd conf uncomment the section about the virtual host for the web subscription by default it runs on port 8500 Create a validation module or use the one provided with PortaBilling By customizing the validation module you can implement the advanced restrictions you require e g allow creation of accounts with a balance of 10 20 or 50 dollars only or ensure that lifetime 1s no more than 180 days Place this module somewhere on the web server so that it will be accessible for mod_perl for example in usr 10cal lib perl5 site perl Thus if you decided to name your module My PortaValidation ResellerABC the actual program code would reside in usr local lib perl5 site perl My PortaValidation Reselle rABC pm NOTE Make sure that you restart the web server apachectl restart after making changes i
58. hen using the default template you have to fill out the data in the Offpeak columns even if your tariff does not have an off peak period use the clipboard to easy copy the values of 4 peak columns 7 Also note that you may use only those phone prefixes which you already have defined as destinations see Create destinations step above File Edit View Insert Format Tools Data Window Help D AT BBS Br fh MOT Currency Description An Termi USD What we charge our customers for their calls we terminate Off peak P Free Seco Post Call Login Fee Connect Fee 0 0 Destinatior Country Descriptior Interval 1 Interval Price 1 Price Off peak In Of peak In Off peak P Off peak P Forbidden Hidden Discontinu Effective Fr 420 CZECH REProper 1 1 0 05 0 05 1 1 0 05 0 05 0 09 0 09 0 09 0 09 4 M csv An Termination 1 Read Sum 420606 36 Save the file in Excel You will probably get a warning from the Excel that your file may contain features that are not compatible with CSV Comma delimited Ignore this and choose Yes to keep the CSV format Close the file in Excel If you performed step 6 then disregard message Do you want to save the changes you made because it 1s only caused by the fact your format is not in the nattve Excel XLS format 10 Go back to the PortaBilling web interface to the Edit Tariff screen 11 Click on the Upload button 12 Either enter the name of your file man
59. ic to a user on this machine System data sources can be used by all users on this machine or by a system wide service At MS Access Create a blank database Right click in the table design view and choose Link tables Choose ODBC databases from Files of type list Select Machine data source Select PortaBilling and press OK Select desired tables pac ae c DS eta Crystal Reports Pile x File View Help amp amp amp ma E oz e 02 d 4 9 6 m su E e Favorites Add u we i t C History EG Remove i Create New Data Source 2 Connect Using File Data Source ig CRXMLV36 Add to Favorites amp dBASE Files H fj Excel Files Delete Favorite amp MS Access Database EJ PortaBilling H amp Xtreme Sample Database 28 Database Files Data Explorer Browse through the folders to find your data source s tables Select and Add tables that contain data you Me report on can also double click a table to it For Help press F1 At Crystal Reports 1 Create a New Report 2 In Data Explorer open ODBC branch 3 Select PortaBilling 4 Select desired tables c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 59 PORTA Billing1OO How to Using redirect number feature Each Account in PortaBilling has redirect number field If field is not empty PortaBilling will incl
60. ients do not directly send traffic to your termination partners since they might try to avoid billing in this way or get a direct contract with the termination partner Sample network We assume that gk directory and proxy belong to you PortaBilling owner gk operator and gw termination belong to your termination partner and gw client is either your own gateway or your customer s If gateway gw client in Zone gk directory wants to call gateway gw termination in gk operator the following sequence of events occurs Vendor gw termination Billing 1 gw client asks gk directory for permission to call certain destination 2 gk directory locates gk operator as the gatekeeper handling that destination 3 gk directory asks gk operator for address of the termination gateway gw operator responds with gw termination address 4 gk directory knows that to get to gw termination the call must go through proxy hence gk directory returns proxy address to gw client c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 6 4 PORTA Billing 100 How to 5 gw client calls proxy 6 proxy consults gk directory to discover the true call s destination which is gw termination in this example 7 gk directory instructs proxy to call gw termination E proxy completes the call to gw termination 9 Upon call completion gk directory sends a stop accounting record to PortaBilling with
61. in h323 group radius aaa authorization exec h323 group radius aaa accounting connection h323 stop only group radius gdw accounting h323 call application voice remote ip tftp remote ip authenticate 1 1 1 tcl dial peer voice 11 voip application remote ip incoming called number 3 Create a customer who will own these accounts 4 Create accounts with the Account ID equal to the IP address of the remote gateway Use volume based billing When you define the rate in a volume based tariff and assign a volume lot to it it will decrease with every call Note that the volume lot data 15 associated with the tariff so normally you will need a separate volume based tariff for each of your volume based customers When the volume lot parameter of the rate reaches zero the rate will be marked as discontinued so that some other rate which has not been discontinued and has an Effective From date in the past can be used instead Thus usually some normal non volume based rates are first created in the tariff and these define policy in the event that all the volume rates are used up Let s look at how to implement the most typical volume based services Volume threshold If you would like to give your customer 100 minutes of calls to the US amp Canada for free and after that charge him 0 07 min 1 Create a new volume based tariff choose Volume Based in the Type menu in the Add tariff form 2 E
62. me as the h323 id hostname h323 id ip domain name default domain NOTE vsa h323 gw id hostname domain 2 NTP NOTE it is very important to have reliable time services ntp server name IP ntp server lt name IP gt ntp master 5 clock timezone lt your time zone gt 1 clock summer time lt your summer time zone gt recurring lt your rules gt NOTE It is important that you only use well known time zone abbreviations which are supported by the billing engine If unsure use the UTC time zone 3 AAA aaa new model aaa authentication login h323 group radius aaa authorization exec h323 group radius aaa accounting connection h323 stop only group radius 4 VoIP interface interface your interface to the world h323 gateway voip interface h323 gateway voip id gatekeeper id ipaddr IP port h323 gateway voip h323 id h323 id NOTE if you want to use a virtual interface then add the line h323 gateway voip bind srcaddr IP 5 Enable gateway functionality gateway 6 Enable gateway accounting For older IOS versions c 2000 2004 Porta Software Ltd All rights Reserved www portaone com B PORTA Billing 100 Setting up a Wholesale IP Telephony Company qw accounting h323 vsa For newer IOS versions 12 2T or 12 3 gw accounting aaa acct template callhistory detail NOTE VSA does not work for all platforms 7 Radius IMPORTANT NOTE Ports 1645 1646 are the tr
63. mum value of seconds which a connection can hold in the 900 sec interval is calculated as capacity 900sec The load of the connection 15 calculated as the sum of durations for all call types divided by the Maximum value in seconds The result will be shown as percentage value multiplied by 100 ASR calculations Assumption connection load less than 5 is not representative for ASR calculating The ASR is calculated as the number of type 5 calls divided by the total number of calls The result is shown as a percentage value multiplied by 100 Relative setup time calculations Relative setup time calculated as a ratio between total setup time of all calls during the period and maximum value of seconds capacity 900sec ASR statistics From the Statistics section in the main menu follow ASR link c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 39 PORTA 8 Billing100 i 4 Pe eme famous Logout je Search Call Center Colo Central iBasis Metrocom NDNT DirectNet PaeTec RadioNet SIP ua2ua T Systems Teleglobe Statistics and Monitoring Tools Vendor reports gt Aug 2003 Mo ThFr Sa Su 31 2 ES 32 RD RE 33 11 12 13 14 15 16 17 34 18 19 20 21 22 23 24 35 25 26 27 28 29 30 31 Dec 2003 TuWe ThFr Sa Su 50 8 9 10 11 12 13 14 51 15 16 17 18 19 20 21 52 22 23 24 25 26 27 28 53 29 30 31 Apr 2004 TuWe ThFr Sa S
64. n error then registration 1s rejected and browser is redirected using Continue URL If status is OK then PortaBilling proceeds with registration and executes credit card transaction If status is indicating an error then registration 1s rejected and browser is redirected using Continue URL If status is OK then PortaBilling creates an account and redirect browser using Continue URL Each time when browser is redirected using Continue URL PortaBilling provides a comprehensive set of parameters List of Continue URL parameters and possible values status ERROR message rejected session id unique session ID supplied by the web subscription server account_id generated account ID Sample files c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 69 PORTA Billing1OO How to Can be found on your PortaBilling installation in the following directories porta admin apache subscription subscription html porta admin apache subscription subscription_result html porta admin site_lib Porta Subscription pm Web Subscription HTML form can be found at the following URL https myPortaBilling myCompany com 8500 subscription html where myPortaBilling myCompany com is URL of your PortaBilling Web Interface and 8500 is the port on which the subscription virtual host is running c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 70 PORTA
65. n the module Create Wholesale Customer Create Product Tariff set managed by Wholesale Customer Fill in the form on the Product Web Subscription Tab Login into customer self provisioning interface and enter merchant account data Company Info gt Merchant Account tab c 2000 2004 Porta Software Ltd All rights Reserved www portaone com B 9 PORTA Billing100 How to HEX Edit EasyCall Product Product Name EasyCall Managed By Reseller ABC HTTP REFERER https www rnydornain com subscribe action asp Validation Module My PortaValidation ResellerABC Continue URL https www mydomain com subscribe done asp How it works To start using your services a person must open your web site and proceed to the subscription page Once the subscription form is completed the data will be posted to PortaBilling server After receiving the subscription form data PortaBilling searches for Subscription HTTP REFERER and accepts it only if the host is found in the database If not found then transaction 15 rejected PortaBilling associates the Subscription Host with the product for the account that is being created PortaBilling will use the appropriate validation module to check if the supplied data are correct Validation module will check the data fill any non mandatory fields and return the data along with the acquired status to PortaBilling If status is indicating a
66. nd see what was in the User Name attribute Typical situations are 1 Incorrect value in User Name for example phone number instead of the IP address of the remote gateway Cause Required application was not used to handle the call Remedy check that application is configured and associated with the corresponding incoming dial peer 2 On some of the call legs there is correct value in the User Name on others there is some IP address In the situation when call is originated on your gateway A and is terminated on your gateway B then we will have real username only on the accounting from the gateway A On the gateway s B accounting username will be the IP address of the gateway A because gateway A had to authenticate itself before being able to make a call This is perfectly normal situation PortaBilling recognizes this situation and will replace username equal to the node s ID IP address with a real username from the other call legs 3 Value in the User Name is correct but it says Did not find account customer Check accessibility for the account s product It might be that even if you have such account accessibility is incorrect Call was billed but the phone number I see in the billing is incorrect not in the E 164 format and I get Mismatch in rates or destinations error Cause missing or incorrect translation rule on the connection to the vendor Remedy Assign translation rule read the Charge
67. nd you cannot change it later if you plan for this tariff to be used for your wholesale customet s accounts so that the customer himself can edit rates in this tariff choose Managed where NNN is the customet s name Otherwise if this tariff is for the retail customer s accounts or for your termination costs to the vendor choose Managed by None here Off peak Period defines the off peak period Click on the Off peak period wizard icon 4 to summon the wizard which will c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 1 1 PORTA Billing 100 Setting up a Wholesale IP Telephony Company help you to construct the correct period definition Click Help to get more information on period format definition If you do not differentiate between peak and off peak rates just leave this field blank o Off Peak Description a description of the off peak period automatically filled in by the off peak period wizard You do not have to fill in this field Destination group set if you wish to enter rates in the tariff not for every individual prefix but for a whole group of prefixes at once you should create a destination group set and destination groups beforehand Leave this select menu empty for now Free seconds the number of free seconds granted for each call In order to claim free seconds the length of the call must be at least one billing unit first i
68. nfo Accessibility Notepad Edit Hode Tariff CLD Info Digits Delete Bl inair service 2000 2004 Porta Software Ltd All rights Reserved www portaone com 1 8 PORTA Billing100 Setting up a Wholesale IP Telephony Company Enter Node and Tariff into accessibility list of the product For the incoming VoIP traffic normally we do not really need different accessibility entries only one row with ANY node and a tariff should be enough However if for example for some customer you want to let him send traffic to your gateway A but not gateway B this can be achieved by using the accessibility entries 1 When Accessibility tab is selected click on the 9 Add icon Choose ANY as a node choose tariff with which you want to bill yout customer and leave CLD field empty 3 Click Save to save this accessibility entry Create Vendors This step is only required if you have not entered information about your vendors into the system before Vendors are your termination partners or providers of the incoming toll free lines 1 In the Management section of the admin interface choose Vendots On the Vendor Management page choose 8 Add 3 Fill in the New Vendor form Please note that there are two tabs available on the screen The most important fields are Main form top o Vendor Name short name for the Vendor object will be used on the web interface Currency in which
69. ng clid col Authenticate with ani NULL and 3 tries without pw DEFAULT Default system session application session t old Session Application in TCL fax hop on t old Script to talk to a fax redialer clid authen t old Authenticate with ani dnis clid authen collect Authenticate with ani dnis collect if that fails clid authen npw t ol Authenticate with ani NULLI clid authen col npw Authenticate with ani NULL collect if that fails clid col npw 3 t old Authenticate with ani NULL and 3 tries collecting clid col npw npw t o Authenticate with ani NULL and 3 tries without pw prepaid TgashsdoebvEOaQPO lsdb 3 prepaid v2 flash app debitcard 2 0 0 tcl test vl flash test api vl tcl test v2 flash test api v2 tcl Use the clid application that corresponds to your authentication configuration ot develop your own From the billing point of view this 15 transparent as it uses ANI CLI as User name Configuration example aaa new model aaa authentication login h323 group radius aaa authorization exec h323 group radius aaa accounting connection h323 stop only group radius gw acoounting 323 dial peer voice 1 pots application clid authen npw incoming called number port 1 D gateway 3 Create a customer who will own those accounts 4 Create accounts with the Account ID equal to the phone number from which the service will be used c 2000 2004 Porta Software Ltd All rights Re
70. nter the default rates These rates should not be volume based keep the Volume Time column empty rather they are the rates to be used if the volume lot has been used up So in our example we will enter a rate for destination 1 with a price of 0 07 min 3 Now create another rate for prefix 1 This rate will be volume based thus we enter 100 in the Volume Time The volume based rate we have created will be now effective so if a call is made to the US or Canada it will be subtracted from the volume lot but will not affect the customer s balance This will continue until all of the 100 minutes are used up After that this rate will be discontinued and if c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 4 5 PORTA Billing 100 How to another call is made it will be charged according to the 0 07 rate and so will be reflected in the customer s balance John Smith volume tariff rates gt 0 ada id save cose _________ toot _ Effective From Destination Prefix Interval sec Price USD min Volume aq Effective From us Sra elete First Next First Next min YYYY MM DD HH24 MI SS C IL di Jajaja Mot Applicable North America 1 1 0 00000 0 00000 100 2004 02 24 00 09 34 Not Applicable North America 1 1 0 07000 0 07000 2004 02 24 00 09 23 Edit Destination Country Description If the customer is to recetve more pr
71. nterval see the Enter Rates section above Post Call Surcharge percentage of the amount charged for the call Login amount to be charged immediately after the first user authentication i e after user enters his PIN O Connect Fee amount to be charged for each connected call calls with a non zero duration o Short Description a short tariff description This will be shown in the rate lookup on the admin interface and the self care pages for your accounts and customers For example you can have a tariff named cust ABC Easy Call 1800 and the short description will provide better information for your wholesale customer ABC who will be using this tariff such as EasyCall via a toll free number This field is mandatory if unsure what to enter here just use the same value as for the name of the tariff o Description extended tariff description 4 Click Save E Tariff Management am i Hame Currency Type Description Rates Delete Prepaid cards USD Managed by None VWhatwe charge prepaid card users for outgoing calls Wholesale rates USD Managed by None What we charge our resellers x lt 2000 2004 Porta Software Ltd All rights Reserved www portaone com 12 PORTA 8 Billing100 HE 8 ame tae 7 E lt Setting a Wholesale IP Telephony Company Add Tariff Name Termination services Type
72. ny Billing configuration Please see the PortaBilling Administrator Interface PDF file for detailed instructions how to navigate and operate on the web interface and for detailed explanation of particular fields Initial configuration of the PortaBilling The following steps normally are performed only once after the system is installed This includes e Visit the Company Info from the main menu Enter information about your company and set up base currency This of course does not limit your operations to only this currency However on the reports such as cost revenue different currencies will be converted to the one you specify here e From the main admin menu choose Users and create login entries for users who will be working with the system It is not recommended to use the default PortaBilling root user pb root for any other operations except initial set up e Make sure you are able to login as a newly created user and change the password for the pb root user NOTE It is possible that you will require assistance from the PortaBilling support personnel in the future In order to provide support they will need access to the web interface So when you submit a problem report please either provide them with a new password for the pb root user or create a special user for them e Ifyou plan to do billing in more than one currency define these in the Currencies and specify exchange rates in the Exchange Rates Create destinations
73. ord Password for self care pages Time zone when an account owner accesses the web self care pages to view the list of his calls the time can be shown in the time zone most appropriate for him Web Interface Language the language to be used on the customer self care web interface c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 26 PORTA Billing 100 Setting up a Wholesale IP Telephony Company 5 Click il Save amp Close you ll get confirmation popup saying that the account has been created 6 Repeat steps 3 5 if customer has more than one remote gateway c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 9 PORTA Billing 100 Statistics and Monitoring Tools 5 Statistics and Monitoring Tools 2004 Porta Software Ltd All rights Reserved www portaone com 98 PORTA Billing 100 Statistics and Monitoring Tools Billing servers health monitoring Entire system load These statistics are accessible from the main admin menu via System load link in the Statistics section This graph shows number of calls registered by a production system every 15 minutes Normal calls with duration gt 0 green areas and calls with zero duration red line The most recent information appearing on the right hand of the graphs is up to an hour old nu m a ui E 16 00 18 00 20 00 22 00 00 00 Oe 00 04 00 06 00 08 00 10 00 12 00 14 00 16
74. ormatting in Excel to eliminate this problem e Charged time in seconds e Charged amount NOTE Call duration shown in the file is based on the charged duration for the call and not the actual call duration So for instance if you bill by 6 seconds intervals total call duration here will be higher than the actual duration of the calls Vendor CDRs It is very useful to have detailed list of call for specific vendor in case of dispute over amount of terminated traffic These statistics are calculated daily and are split into files according to the vendor s billing period Vendor reports Pee cel i toot 96 SPT Telecom Choose vendor and then click on the calendar to download statistics for Mar 2003 Mo Tu We ThFr Sa Su 9 we 19 3 P3 ER EB EHI 11 10 11 12 13 14 15 16 12 17 18 19 20 21 22 23 13 24 25 26 27 28 29 30 14 31 Jul 2003 Tu We ThFr Sa Su 111111 28 7 6 9 10 11 12 13 29 14 15 16 17 18 19 20 30 21 22 23 24 25 26 27 31 28 29 30 31 Nov 2003 Mo Tu We ThFr Sa Su 44 152 443455783 46 10 11 12 13 14 15 16 47 17 18 19 20 21 22 23 48 24 25 26 27 28 29 30 Apr 2003 Tu We ThFr Sa Su 14 qm 8 15 7 8 9 10 11 12 13 16 14 15 16 17 18 19 20 17 21 22 23 24 25 26 27 18 28 23 30 Aug 2003 Mo We Th Fr Sa Su 31 1 ES 32 45618910 33 11 12 13 14 15 16 17 34 18 19 20 21 22 23 24 35 25 26 27 28 29 30 31 Dec 2003 We ThFr Sa Su 41234567 50 8 9 10
75. ounts Fraud Detection Active Yes Turn the fraud protection on Test Mode zNo Turn the fraud detection on Debit account will be allowed to login more than once but email alert will be sent Recovery Time sec 1800 After debit account is successfully authenticated how log this information should be kept in the memory Default is 30 minutes Longer recovery time will increase amount of memory required by the billing engine Node IP Cache Node IP Cache Cache_Cleanup_Time_sec 600 How often information about nodes and connections should be updated from the database You can force nodes connections reload by sending HUP signal to radius daemon Email flood prevention Email c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 7 9 PORTA Billing1OO Maintenance Max Sequential Emails 5 Look Behind sec 450 If within Look Behind sec interval Max Sequential Emails already have been sent any extre email alert will be blocked This is done to protect email flood Mail Templates Dir Mail Templates radcheck pl Self Test Timeout sec 5 Test Frequency sec 60 Errors Before Restart 3 Path To Lock File var run radcheck pid NAS IP Addressel127 0 0 1 Shared Secret SecretKey User Name 127 0 0 1 Password cisco This sections defines parameters for the PortaBilling self test suite Periodically script sends authentication request to the radius server and expects positive answer
76. our accounts to use Blocked check this if you want to create this account as initially blocked Opening balance the initial balance on the card For the credit accounts opening balance normally is a zero Account info tab o Account type account type select credit Credit limit Maximum allowed credit o VoIP Password password for authentication authorization If you ate using default Cisco remote_ip_authenticate script put cisco here Batch batch is a management unit for accounts Batch name is alphanumeric You can type a new name here or use the existing name in order to generate more accounts for same batch Additional Info tab Preferred language this is a custom attribute which is transferred to the IVR Leave English here if you are not sure if your IVR supports it o Redirect number redirect number discussed in the Advanced features section leave it empty Life Cycle tab Activation date account activation date Expiration date account expiration date Life time relative expiration date account will expire on first usage date life time days If you do not want to use this feature leave the field blank User Interface tab Login login name this account will use to access the self care page This can be the same as the account ID or choose something different for increased security This field is mandatory Passw
77. r call among the others You can find this ID by either e See statistics on your gateway e Go to the radius details directory var log radacc enter the subdirectory for the corresponding gateway and use program like more of less to browse the file You can search by the number you dialed account PIN number or just browse records near the end of the file e Browse the PortaBilling log var log porta billing log search by the number you dialed account PIN number or just browse records near the end of the file 3 Look in the PortaBilling log vat log porta billsng log ot use View logs on the web interface and find all of the information there about the call processing Note Normally we receive information about each of the call legs separately so it is necessary that you check log entry for processing all of the call legs and the final call clean up 4 Typical error situations are e Call was not billed at all It was considered as net call because we did not detect that it went to any c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 50 PORTA Billing 100 How to of the vendors Check that you have correctly defined connections to your vendors Call was billed only to vendor but not to an account or customer and when you received email alert The billing engine needs Account ID in the User Name attribute to correctly identify account and customer Check the logs a
78. red prefix by country name NOTE The phone prefix you are trying to create a rate for has to exist already in the Destinations o Interval First first billing unit in seconds Interval Next next billing unit in seconds Price First per minute price for first interval Price Next per minute price for next interval Off peak Interval First first billing unit in seconds for off peak time Off peak Interval Next next billing unit in seconds for off peak time Off peak Price First per minute price for first interval for off peak time Off peak Price Next per minute price for next interval for off peak time c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 14 PORTA Billing 100 Setting up a Wholesale IP Telephony Company NOTE Off peak fields appear only if off peak period has been defined for tariff o Formula amp launches the wizard for creating a custom rating formula Effective from if you want this rate to take effect sometime the future you can either type a date manually or use a calendar click on the DD MM YYYY link Click on the 9 Stop Watch icon to make the rate effective immediately NOTE When using the calendar you can specify that the date you entering is in the different time zone than your current one PortaBilling will automatically adjust the time then HEB Termination services tariff rates EE Sret
79. repaid cards and ANI based billing take measures to prevent frauds e g someone could dial to your IVR and enter their neighbor s home phone number as the PIN When creating accessibility for the ANI based billing product separate it from the prepaid cards by using a different access phone number a different node or different PIN lengths for the prepaid cards c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 41 PORTA Billing1OO How to 2 On your gateway use the corresponding application to handle the call You can use one of the Cisco default applications clid_ or create your own The only important thing is that ANI CLI must be in the User Name attribute in the AAA requests which go into the billing Cisco gateways usually have a number of authentication TCL scripts embedded into IOS The application set may be slightly different on different platforms The richest set available at the time of this writing is shown below Router show call application voice summary name description session Basic app to do DID or supply dialtone tax hop on Script to talk to a fax redialer clid authen Authenticate with ani dnis clid authen collect Authenticate with ani dnis collect if that fails clid authen npw Authenticate with ani NULL clid authen col Authenticate with ani NULL collect if that fails clid col npw Authenticate with ani NULL and 3 tries collecti
80. rk 15 19 0 30 0 015 TOKELAU Proper 15 18 50 unknewm 13103195237 UNITED STATES California E2004 15 18 0 30 0 015 The following data is available e Total number of calls e Number of calls with non zero duration Billable calls e ASR e Total calls duration e Average Length of Call ALOC Numbers are aggregated per destination prefix with sub total per country and total for all calls In case if you need statistics for today or report with some other parameters for example split by hour so you see how did the ASR evolve during the day you can use Custom query report It extracts data directly from the database so use with caution in order to do not overload the server c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 33 PORTA Billing 100 Statistics and Monitoring Tools 7 Custom Query Pe coe a obees Customer ALL Vendor ALL v Destination 1 From 2004 02 23 YYYY MM DD 00 00 00 HH MI SS To 2004 02 24 YYYY MM DD 00 00 00 HH MI SS Split No split Show results Customer s Calls Billable Calls Duration min sec ASR min sec Cost Revenue USD Vendor s Interval 2004 02 23 00 00 00 2004 02 24 00 00 00 ALL 5475 2785 20935 29 50 87 7 31 3804 32 ALL 5475 2785 20935 29 50 87 trad 637 47 Note that on the Custom Quety report both AS
81. rrency USD US Dollar v Opening Balance Categorizing and Defaults Billing Period HE Add Vendor gt E sive ed sovencose 9 coe Vendor Name SPT Telecom Currency USD US Dollar Opening Balance v Address Info Additional Info User Interface Login Time Zone Europe Prague v Password Web Interface Language Czech sd v Access Level Vendor v Output Format Date PYYY MM DD 2003 12 31 Time HH24 MI 8S User Defined Date amp Time vYvYvY MM DD HH24 MI SS User Defined Input Format Date YYY MM DD 2003 12 31 Time 24 88 User Defined c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 90 PORTA Billing 100 Setting up a Wholesale IP Telephony Company E Vendor Management gt Bogut tog Search CDRs Connections Currency Balance E mail Delete D SPTTelecom W USD 0 00000 billina spt cz x 0 F3 USD 0 00000 yoip xtelecomcom Vendor SPT Telecom connections gt Gl close B topo PSTN from vendor from Vendor PSTN to Vendor VoIP to vendor Proxied VoIP to vendor to Vendor Proxied VoIP to Vendor Edit Load Hode Port Transl Rule Outgoing Rule Tariff Description Capacity D
82. s contain the latest material on enhancements occurring in between minor releases The online copy of this guide is always up to date integrating the latest changes to the product You can access the latest copy of this guide at www portaone com solutions billing docs Conventions This publication uses the following conventions Commands and keywords are in boldface Terminal sessions console screens or system file names are displayed in fixed width font Caution means reader be careful You are capable of doing something that might result in program malfunction or loss of data NOTE Means reader take note Notes contain helpful suggestions or references to materials not contained in this manual Timesaver means the described action saves time You can save time by performing the action described in the paragraph Tips Means the following information might help you solve a problem c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 3 PORTA Billing 100 Setting up a Wholesale IP Telephony Company Setting up a Wholesale IP Telephony Company Wholesale voice is a growth market with service providers building new capacity and launching new services The primary wholesale service is long distance transport and aggregation with the key advantage that country specific features and domestic calling regulations are not required The principal beneficiaries are developing countries where
83. se to converts dialed number in the desired format VoIP node type select VOIP GW o Manufacturer Select Cisco or Quintum o Radius Client Check this if this node will be communicating with the billing o Radius Key If this node is a radius client put the shared secret here it must be same as configured on the NAS as a key in the configuration of the radius setvet o Radius Source IP Unless your gateway has multiple network interfaces the value here should be the same as NAS IP Address 4 Click ill Save amp Close 5 Repeat steps 2 4 until all of your nodes are entered NOTE There is some propagation delay between the database and the Radius server configuration file no more than 15 minutes Create Tariff A tariff is a single price list for calling services A tariff combines Conditions which are applicable for every call regardless of the called destination Per destination rates Normally you need a separate tariff for each of your customers 1 Inthe Management section of the Admin Index choose Tariffs 2 On the Tariff Management page choose Add 3 Fill in the New Tariff form o Name the short name for tariff object This is the name you will see later in the select menus Currency indicates in which currency the pricing information is defined All pricing information for a single tariff must be defined in the same currency NOTE Currency for the tariff is chosen only once a
84. sed tariff rates Effective From Destination ev 202 Grafix ean Interval sec Price USDimin yolume Effective From 9 elete First First Next min YYYY MM DD HH24 MI SS Edit Destination Country Description 4202 CZECH REPUBLIC Prague 1 0 11000 0 11000 50000 2004 02 24 00 19 42 Charge reseller for incoming calls This is a very common situation You provide your reseller with the billing gateways and other required components When the end user makes a call you charge the reseller according to your wholesale rates But now the reseller wishes to give his subscribers the ability to use either a local access line or a toll free line to access the service The reseller can use the accessibility feature to charge subscribers by different tariffs depending on the access number But what about the amount you charge the reseller Obviously when somebody calls a toll free line and then calls China your cost is higher than when somebody calls a local access line and then calls the same number in China This fact should be reflected in the reseller charges PortaBilling allows you to charge your reseller not just for outgoing calls but also for incoming ones This is done when the call is crossing PSTN from the vendor connection In order to implement this follow these instructions 1 Create a tariff which defines your incoming line costs 2 Create a separate
85. served www portaone com 19
86. served www portaone com 4 9 PORTA Billing1OO How to TIP check in which format ANI CLI numbers are reported by your gateway For example for the phone number 420 2 1234567 might be reported as 21234567 021234567 42021234567 ot may be something different You have to use exactly the same format for the Account ID ot change your application to convert it to the desired format Bill my customers who are connected via 1 1 directly to some port on my gateway Typically for such port based billing you do not use authentication or authorization since you are always sure that you customer is on the other end of the physical line It might be a good idea though to implement call authorization so you may control which destinations customer is allowed to call but we leave it out of this example For the port based billing you just have to 1 For each of such customets create a tariff that you want bill your customer and a product Only one row in the accessibility is necessary with the node ANY and the tariff which you have created 2 Now we have to make sure that each call made by that customer is tagged as belonging to him On your gateway use the corresponding application to handle the call You can use the Cisco application app session name create your own The often difficult part in gateway configuration is to design dial peers for matching certain voice ports Dial peers should like
87. stal Reports Microsoft Access or custom application to retrieve data from the database process it and present to user Use ODBC to connect to PortaBilling ODBC Open Database Connectivity provides a way for client programs to access a wide range of databases or data sources If you need extended customized reporting not available in PortaBilling you can do it using external tools such as MS Access or Crystal Reports Create a MySQL user to be used for reports 1 Login into your Portabilling slave server using ssh 2 Start MySQL command tool andrew demo home porta adminSmysql u root mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with A Welcome to the MySQL monitor Commands end with or Ng Your MySQL connection id is 42122 to server version 4 0 17 log help or Xh for help Type to clear the buffer mysql gt 3 Create a new user using GRANT command mysql gt grant ALL PRIVILEGES on porta billing to reports 192 168 0 5 identified by pod23uk Query OK O rows affected 0 02 sec mysql gt NOTE The command above will give access to all of the tables in the database It is provided just as an example modify it accordingly to your actual needs c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 5 4 PORTA Billing100 How to 4 Flush the privileges mysql FLUSH P
88. t USD Retail 0 00000 HET Add Customer Customer Name wi Petersen Currency usp US Dollar Blocked Opening Balance Address info Additional info Company Name Petersen amp Biz Contact Mr dMs Phone First Name Fax Last Alt phone Address a Alt Contact Email Juill petersen biz Bcc Summary only z Province State EID BI Note Country Region HE Add Customer fr E sive tal savexciose cose Customer Name SmartNet Currency USD US Dollar Blocked Opening Balance E Type Retail v wv Address Info Additional Info Payment Info User Interface Credit Limit Balance Warning Threshold c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 99 PORTA Billing 100 Setting up a Wholesale IP Telephony Company He Add Customer gt Tea save cese O Bteme Customer Name SmartNet Currency USD US Dollar Blocked Opening Balance Type Retail Address Info Additional Info Payment Info User Interface Routing Plan Default Categorizing and Defaults Billing Period Monthly Invoice Template Do not create invoice Terms Due on receipt v Representative Not defined Tax ID Callshop Enabled Add Customer gt ea si
89. the MyODBC GPL license MySQL the most popular Open Source SOL database is provided by MySGL MySQL is commercial Cancel c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 55 PORTA 8 Billing100 EE MySQL Connector ODBC 3 51 Start Installation You now ready to install MySQL Connector ODBC 3 51 Press the Next button to begin the installation ar the Back 3 button to reenter the installation information http Avene msg conn MySQL Connector ODBC 3 51 Installing a CAWINO OWS modi 3 dil Current File Copying Al Files Time Remaining minutes 0 seconds ise Installation Wizard c 2000 2004 Porta Software Ltd All rights Reserved www portaone com How to 96 PORTA Billing1OO How to 33 MySQL Connector ODBC 3 51 Finished MySQL Connector ODBC 3 51 has been successfully installed on your system For more information about MyODBCC visit http aan msg com products myodbe MySQL AB offers a full palette af Professional Services ta help you design a better database schema and optimise your MySOL server parameters in order to increase the throughput of your Support Support from the developers of the MySQL Server Training Training for the MySQL Server Consulting Consulting tailored to your specific MySQL n
90. the client gateway interface description VoIP ip address lal 2594299324993 h323 gateway voip interface h323 gateway voip id gk client ipaddr 2 2 2 2 1718 h323 gateway voip h323 id gw client of client Gatekeeper gatekeeper zone local gk client client domain 2 2 2 2 zone remote gk directory your domain 3 3 3 3 1719 zone prefix gk directory use proxy gk client remote zone gk directory outbound from gateway use proxy gk client remote zone gk directory outbound from terminal no shutdown H323 proxy shown on the same chassis as gatekeeper hostname proxy ip domain name client proxy 0349 interface ip address 2 24242 2992255 255 0 h323 interface h323 h323 1d proxy client h323 gatekeeper ipaddr 2 2 2 2 Your termination gateway and PortaBilling Configuration is the same as in case of billing by remote IP address see Authenticate and bill my customers by the IP address of their gateway and Setting up a Wholesale IP Telephony Company c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 63 PORTA Billing1OO How to Make sure your customers do not know who your real termination pattners are and never communicate directly with them See Isolate your network below Isolate your network Two cartiers interested in interconnecting will desire a single interconnection point which is convenient for management and billing Another reason why you might need this is to make sure that your cl
91. the following configuration example dial peer voice 1 pots application client on port 1 direct anward dial port ID They will be listed as having an operation status of down as the port specification must be accompanied with a number matching a specification for example dial peer voice 1 pots application client on port 1 incoming called number direct inward dial port 1 D This dial peer is not adequate for our needs because any number matching the specification will prefer the port specification This dial peer will match any port The solution is to use a number matching scheme which will not match any number dial peer voice 1 pots application client on port 1 incoming called number A direct inward dxal port 1 0 c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 43 PORTA Billing1OO How to The solution may be considered a hack but is functional and secure For increased security you may specify a 32 character string with a random sequence of ABCD characters The probability of receiving such number is near zero 5o the configuration should look like the following aaa new model authentication login h323 group radius aaa authorization exec h323 group radius aaa accounting connection h323 stop only group radius call application voice client on port 1 flash app session name 2 1 0 tcl call application voice client on port 1 user name abc ltd call application
92. there are sub customers under the reseller with statistics for each of them calculated individually this type of statistics is now obsolete This item has been left here only for backward compatibility so that you can download statistics for the previous billing periods Mes E 2 Customer reports Pe Bel je Search maxim wholesale Pre paid card test Reseller ABC SmartNet Aug 2003 TuWe ThFr Sa Su 31 1 2 ied 32 ES S E 33 11 12 13 14 15 16 17 34 18 18 20 21 22 23 24 35 25 26 27 28 29 30 31 Dec 2003 Mo Tu We ThFr Sa Su 49 DP ESSE 50 8 9101112 13 14 51 15 16 17 18 19 20 21 52 22 23 24 25 26 27 28 53 23 30 31 Apr 2004 TuWe ThFr SaSu 14 fl fe ES 15 5 6 7 8 91011 16 12 13 14 15 16 17 18 17 19 20 21 22 23 24 25 18 26 27 28 29 30 Sep 2003 TuWe ThFr Sa Su 36 BU EZ LES S 37 8 91011 12 13 14 38 15 16 17 18 19 20 21 39 22 23 24 25 26 27 28 40 23 30 Jan 2004 TuWe ThFr SaSu 1 Wu 3 2 Ea B5 3 12 13 14 15 16 17 18 4 19 20 21 22 23 24 25 5 26 27 28 29 30 31 May 2004 TuWe ThFr SaSu 18 1 2 19 RH 20 10 11 12 13 14 15 16 21 17 18 19 20 21 22 23 22 24 25 26 27 28 29 30 Oct 2003 TuWe ThFr Sa Su 40 ED 416 7 8 8 10 11 12 42 13 14 15 16 17 18 19 43 20 21 22 23 24 25 26 44 27 28 28 30 31 Feb 2004 TuWe ThFr SaSu 5 1 1 3 25 0 BH 7 9 10 11 12 13 14 15 8 16 17 18 19 20 21 22 9 23 24 25 26 2
93. tion Portabiling database MySQL Connection Parameters Ln Hast Server IP porta biling slave g Database M ame porta biling Lj SQL User reports Password if not 3206 3307 SQL command on connect Cancel Options gt gt Test Data Source Help Important parameters are e Host Server Name or IP hostname or IP address of your slave server e Database Name porta billing e User Password username and password of the MySQL user you have created for the report purposes e Port the port on which the database service is accessible enter 3307 here Note This port number differs from the one used by default c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 58 PORTA Billing 100 How to Using ODBC EZ Microsoft Access File Edit View Insert Tools Window Help Type a question For hel iar ld 3 V amp o o oo i 98 0 db1 Database Access 2000 file format Open Design x 2 Create table in Design view Tables Create table by using wizard Queries Create table by entering data Select Data Source File Data Source Machine Data Source Reports Pages dBASE Files Excel Files Macros AE _ Database ortaBillin Modules Favorites Machine Data Source is specific to this machine and cannot be shared User data sources are specif
94. tistics will be sent to this address o Bec blind carbon copy in email may be used for debug and archiving purposes o Summary only distribute summary only do not attach details file might be useful when amount of calls is vety large Additional info tab o Billing period frequency of accounting information distribution Available billing periods Daily one day midnight to midnight sent on the next day Weekly Mon Sun inclusive sent on Monday Bi weekly 1 15 inclusive sent on the 16 day of the month and 16 last day inclusive sent on the 1 of the following month Monthly 1 last day inclusive sent the 1 of the following month Payment info tab Credit limit if left empty then there is no credit limit for this customer Balance Warning Threshold customer can be notified by the email when his balance is dangerously close to the credit limit and his service will be blocked soon Here you can enter the value for the warning threshold It can be entered In percents e g 90 Warning will be send when customer balance will exceed that percentage of his credit limit So if credit limit is 1000 00 and threshold is 90 warning will be sent as soon as the balance is over 900 00 Only applicable when customer has positive credit limit As absolute value Warning will be sent as soon as the balance is over the specified value User Interface Time zone this
95. u 14 il ES 15 5 6 7 8 9 10 11 16 12 13 14 15 16 17 18 17 19 20 21 22 23 24 25 18 26 27 28 29 30 Download Options gt Sep 2003 TuWe ThFr SaSu 350 d 4 4d 3 37 8 9 10 11 12 13 14 38 15 16 17 18 19 20 1 39 22 23 24 25 26 27 28 40 29 30 Jan 2004 Mo TuWe ThFr Sa Su 1 E EBD 2 BR T 3 12 13 14 15 16 17 18 4 19 20 21 22 23 24 25 5 26 27 28 29 30 31 May 2004 Mo TuWe ThFr Sa Su 18 19 E IE BS A IO OH 20 10 11 12 13 14 15 16 21 17 18 19 20 21 22 23 22 24 25 26 27 28 29 30 23 31 Oct 2003 TuWe ThFr SaSu 40 2 5 EL DD 44 EA 42 13 14 15 16 17 18 19 43 20 21 22 23 24 25 26 44 27 26 29 30 31 gt Feb 2004 TuWe ThFr Sa Su 5 1 T 9 10 11 12 13 14 15 8 16 17 18 19 20 21 22 9 23 24 25 26 27 26 23 Jun 2004 Tu We ThFr Sa Su 2 ERE ER E 24 7 8 8 10 11 12 13 25 14 15 16 17 18 19 20 26 21 22 23 24 25 26 27 27 28 29 30 Nov 2003 TuWe ThFr SaSu 44 1 4434557838 46 10 11 12 13 14 15 16 47 17 18 19 20 21 22 23 48 24 25 26 27 20 29 30 Mar 2004 TuWe ThFr SaSu 19 B EZ 141 8 9 10 11 12 13 14 12 15 16 17 18 19 20 21 13 22 23 24 25 26 27 28 14 23 30 31 Jul 2004 TuWe ThFr SaSu 27 1 28 m5 b ed RA 29 12 13 14 15 16 17 18 19 20 21 22 23 24 25 31 26 27 26 23 30 31 You can download pre calculated statistics in CSV format
96. ually or click Browse and choose the file 13 Click gl Save amp Close You should return to the Edit Tariff screen c 2000 2004 Porta Softw and a message will tell you the status of the import Also you will receive an email confirmation about the tariff upload If any operation are Ltd All rights Reserved www portaone com 1 B PORTA Billing100 Setting up a Wholesale IP Telephony Company has failed you will receive the portion of data which was not uploaded as an attachment so you can try to import them later You can verify your work using the Edit Rates feature After you have done so go to the Main menu by clicking on the Home icon Create all required tariffs Repeat the Create Tariff and Enter Rates steps until you have created A tariff for each account billing scheme For the wholesale termination business model you will usually need one tariff per customer which will be used to charge all of the customer s accounts A tariff with the termination costs for each of your termination partners If you have resellers you must also create the tariffs that you will use for charging each of them Do not create the tariffs which will be applied to subscribers of your resellers yet First create the customers then return to this step Make sure that when creating these subscriber tariffs you choose Managed by NNN in the Type menu where NNN is the name of the corresponding reseller Create Product
97. ude an h323 redirect number in each authorization confirm message and use an h323 return code of 52 How to proceed in this case is determined by the gateway The account owner is allowed to modify the redirect number using customer self provisioning web There are no scripts for any redirect number functionality in the Cisco TCL package You may desire to implement this functionality in house ot Porta Software may be able to assist you Customer support number PortaBilling allows you to enter the redirect number during the process of account generation so that you may specify different redirect numbers for different account batches Different batches may be distributed in different regions and only a slight modification to the prepaid card script can make it more intelligent about how to choose a customer support centet IP telephony private line auto ringdown In the case of the combination of ANI CLI authentication and immediate call forward you may map phone lines from one world region to another This is advantageous as you will require only one local access number The mapping is dependant on the ANI CLD Know which H323 proxy is right for me There are two possible implementations of the H323 proxy hardware and software Hardware is a VoIP gateway with some of the voice ports connected to the others or two back to back gateways can be used Software proxy is a Cisco router no DSP or voice ports required with certain IOS
98. uration Stable billing relationships If your client is the service provider then your case may look more like this A large number of unstable gateways service installation and cancellation Unstable gateways configuration IP h323 1d Different billing procedures for different gateways In this case it is possible to isolate client s network by using H 323 proxy All of the customer s gateways send traffic to the proxy and then it resends traffic to your netwotk So for you and for the Portabilling it looks like customer has a single gateway which sends all the traffic c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 61 PORTA Billing1OO How to Sample network gw client gk client gk directory of client PortaBilling100 owne PORTA Billing In the example above gw termination belongs to you PortaBilling owner the rest belongs to your client or your client s client If gateway gw client of client in Zone gk client wants to call gateway gw termination in gk directory the following sequence of events occurs 1 29 gw client of client asks gk client for permission to call certain destination gk client locates gk directory as the gatekeeper for that destination gk client asks gk directory for address of the termination gateway gw directory responds with gw termination address gk client knows that to get to gw termination the call must go through proxy client hence
99. ve core tooo Customer Name SmartNet Currency USD US Dollar Blocked Opening Balance Type Retail Address Info Additional Info Payment Info User Interface Login Time Zone Europe Prague Password Web Interface Language en English Access Level Retail v C Periodical Payments management Enabled C Dialing Rules Management Enabled Output Format Date PYYY MM DD 2003 12 31 Time HH24 MI S S User Defined Date amp Time YYYY MM DD HH24 MI SS User Defined Input Format Main form top Name short name for the Customer object will be used on the web interface Currency in which currency this customer will be billed Opening balance the starting balance for the customer default 1 zero Type is ita reseller or retail direct customer Normally most of your customers would be retail customers Only if a customer is reselling your services and you are providing services and billing to his subscribers would he be created as a reseller Address info tab c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 93 PORTA 14 Billing100 Setting up a Wholesale IP Telephony Company Email email address for distribution of accounting information After the billing period is over a list of CDRs and other sta
100. voice client_on_port_2 flash app_session_name 2 1 0 tcl call application voice client_on_port_2 user name xyz_inc gw accounting 323 vsa dial peer voice 1 pots application client on port 1 incoming called number A direct inward dial port 1 0 dial peer voice 2 pots application client on port Z incoming called number B direct inward dial port 2 D gateway 1 Create customers who will own these accounts Create accounts with the Account ID equal to the name you put in the configuration of the applications abc Itd and xyz inc in out example Authenticate and bill my customers by the IP address of their gateway This is another example of how easy you can implement different billing schemes with PortaBilling For the IP based billing you just have to 1 Create a tariff and product Since Node and CLD only make sense for the incoming telephony calls for the IP based billing product set node to ANY and leave CLD blank 2 On your gateway use the corresponding application to handle the call You can use the Cisco application remote ip authenticate or create your own The only important thing 1s that the IP address of the remote GW is in the User Name attribute in the AAA requests which will go into the billing Here is an example of the configuration c 2000 2004 Porta Software Ltd All rights Reserved www portaone com aq PORTA Billing1OO How to aaa new model authentication log
101. wn 7533308111 2123430383 2971379160 unknown 9210417860 9175199147 73474521511 RUSSIAN FEDERATIC 31 01 04 23 57 70125289892 RUSSIAN Saint Peter 31 01 04 23 56 17708536266 UNITED S Georgia 31 01 04 23 56 3 80412 11 UKRAINE Proper 31 01 04 23 52 78121142201 RUSSIAN Saint Peters 31 01 04 23 52 78121142201 RUSSIAN Saint Peters 31 01 04 23 42 17708536266 UNITED S Georgia 31 01 04 23 41 73422246198 RUSSIAN FEDERATIC 31 01 04 23 32 73422364533 RUSSIAN FEDERATIC 31 01 04 23 31 17326033936 UNITED S New Jersey 31 01 04 23 31 17708534266 UNITED S Georgia 31 01 04 23 30 73832237983 RUSSIAN FEDERATIC 31 01 04 23 29 2739293329 7183314905 73452353477 RUSSIAN FEDERATIC 31 01 04 23 22 2971379160 unknown 17708536266 UNITED S Georgia 31 01 04 23 18 4 2004 02 21 2004 02 21 a Read The following data 1s available e Account ID if applicable not available for wholesale customer s CDRs but available for his account s CDRs e CLI or ANI From e CLD or DNIS To e Country and description of the destination e Call start time e Charged time in minutes seconds NOTE When browsing data in Microsoft Excel extra trailing zeros might be added for example 345 37 three hundred forty five minutes and thirty seven seconds will c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 35 PORTA Billing 100 Statistics and Monitoring Tools be shown as 345 37 00 Use proper call f
102. xy n323 interface ip address 2 2 2 2 2994299429930 h323 interface h325 h323 3d proxy clieut h323 gatekeeper ipaddr 2 2 2 2 PortaBilling configuration If Gw client is a client s gateway it should be entered as an account see Setting up a Wholesale IP Telephony Company otherwise if it your own gateway it should be entered as a node If the Gk directory is separate from the proxy it should be entered as a node make sure type is H323 Proxy should be entered as a node with type H323 GW The last and the most important thing is to create a Proxied VoIP to vendor connection with proxy node Restrictions Only total proxy traffic accounting is possible If you will have more than one operator behind the proxy it will not be possible separate accounting information This is a Cisco limitation and may be resolved in a future IOS revision As a temporary solution it 1s suggested to use a separate proxy instance for each operator The origination point gw client must be the gateway not the terminal In the case of an FXS port dial peer use no register e164 Configure outgoing connection to vendor if send calls using gatekeeper so remote IP address is not known in advance In this situation you indeed cannot use VoIP to Vendor connection since IP address of the remote gateway will be assigned dynamically Solution in this case is to set up h323 proxy and send traffic to this vendor vi
103. y out non profitable calls Cost Revenue reports allow you to monitor this and stay out of troubles To access Cost Revenue reports follow Cost Revenue reports link from the Statistics section of the main menu c 2000 2004 Porta Software Ltd All rights Reserved www portaone com 37 PORTA Billing 100 Statistics and Monitoring Tools HET Cost Revenue reports gt 9 Pe Inbound by Country Inbound by Customer Outbound by Country Outbound by Vendor Inbound Mar 2003 Mo Tu We ThFr Sa Su 9 ij 4 11 10 11 12 13 14 15 16 12 17 18 19 20 21 22 23 13 24 25 26 27 28 29 30 14 31 Jul 2003 Tu We ThFr Sa Su 21 28 9 10 11 12 13 29 14 15 16 17 18 19 20 30 21 22 23 24 25 26 27 31 28 23 30 31 Nov 2003 Mo Tu ThFr Sa Su Hu 18 45 C3 1 08 46 10 11 12 13 14 15 16 47 17 18 19 20 21 22 23 48 24 25 26 27 20 29 30 Apr 2003 Mo Tu We ThFr Sa Su 15 7 8 9 10 11 12 13 16 14 15 16 17 18 19 20 17 21 22 23 24 25 26 27 18 26 29 30 Aug 2003 Tu We ThFr Sa Su 31 EU 3245 6 7 8 910 33 11 12 13 14 15 16 17 34 18 19 20 21 22 23 24 35 25 26 27 28 29 30 31 Dec 2003 Mo Tu ile ThFr Sa Su 49 EB 8 50 8 9 10 11 12 13 14 51 15 16 17 18 18 20 21 52 22 23 24 25 26 27 26 53 29 30 31 May 2003 Mo ThFr Sa Su 18 19 5 6 7 8 9 10 11 20 12 13 14 15 16 17 18 21 19 20 21 22 23 24 25 22 26 27 28 29 30 31 Sep 2003 Mo Tue ThFr Sa

Download Pdf Manuals

Related Search

Related Contents

KL53ZHQ-PCT  AIM Utilities User`s & Reference Guide, v3.2B  HEATING BLANKET 1 PERS EN  モバイルクリエイト[3669]東証  Manuale Utente Per Tester E Pinze Amperometriche Valex Cod    EQD 312 User`s Manual Manual del Usuario.  Whitehaus Collection WHNDB3016-BSS Installation Guide  Bedienungsanleitung  connessione della gettoniera  

Copyright © All rights reserved. Failed to retrieve file