Home

PortaBilling: User Manual

1. Choose ODBC databases from Files of type list Select Machine data source Select PortaBilling and click OK Select the desired tables 5 x E amp Crystal Reports RT Fie View Help D D Waa F7 tBBo m ma r ag Sw o s z m e m ate O eee ie ue For Help press F1 it H 9 Favorites Add G History 26 Govec Remove i Create New Data Source Connect Using File Data Source EH amp CRXMLV36 Add to Favorites A dBASE Files E 9 Excel Files Delete Favorite H amp MS Access Database H EJ PortaBilling H amp Xtreme Sample Database H A Database Files Data Explorer Browse through the folders to find your data source s tables Select and Add tables that contain data you ap Me report on You can also double click a table to it In Crystal Reports 1 Create a New Report 2 In Data Explorer open ODBC branch 3 Select PortaBilling 4 Select the desired tables c 2000 2006 PortaOne I nc All rights Reserved www portaone com 6 5 PORTA Billing100 How to Use redirect number feature Each account in PortaBilling has a redirect number field If this field is not empty PortaBilling will include an h323 redirect number in each authentication 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 the customer self provision
2. Currency USD Managed by None General Info Web Upload amp Download Email Upload Notepad Off Peak Period Off Peak Descri Destination Gro Free Seconds Post Call Surch Login Fee Connect Fee 2 TEST K ption up Set o arge o o0000 0 00000 USD 0 00000 USD Round Charged Amount XXXXxX XXKKK Formula Short Description Description M Ed s E Termination services What we charge our customers for calls they terminate on our network MA Termination services tariff rates gt add i save close tanh Logout B Lor Effective From Now v Destination Country Destination Description CZECH REPUBLIC Vv Proper 4 Interval sec First Next Price USD min First Next Prefix Group Count Effective From yyyy mM pp 4 fig delete HH24 MI SS immediately c 2000 2006 PortaOne I nc All rights Reserved www portaone com 13 PORTA Billing 100 Setting up a Wholesale IP Telephony Company G 4 Termination services tariff rates gt E asa ia save cle rann OOOO o Bo Effective From Destination now Cri Group e Country Interval sec Price USD min m Effective From Edit Destination ye i A A YYYY MM DD I w Delete Desc
3. 61 AUSTRALI Proper 61404 AUSTRALIA 43 AUSTRIA Proper a 4 5 6 7 8 3 994 AZERBAIJ Proper 99450 AZERBAI Mobile 375 BELARUS Proper 375 BELARUS Proper Pre paid cart 37517 BELARUS Minsk 15 SmartNet 37517 BELARUS Minsk 4 gt gt I 2004 02 20 2004 02 20 Inbound b Read T The following data is available e Name of customer vendor e Destination prefix e Country and description of destination c 2000 2006 PortaOne I nc All rights Reserved www portaone com 39 PORTA Billing 100 Statistics and Monitoring Tools e Total number of successful calls e Gross margin the difference between total revenue and the cost for this destination e Rated sec the sum of the time charged for all calls to this destination in seconds e Rated min the 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 Thus for instance if Rated sec contains 180 here 3 0 will be shown e Total Cost the 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 the summary of the amount charged for all the customer s CDRs for this destination If the customer uses a currency different than your base one this will be converted using the curr
4. 5 Enable gateway functionality gateway 6 Enable gateway accounting c 2000 2006 PortaOne I nc All rights Reserved www portaone com 6 PORTA Billing 100 Setting up a Wholesale IP Telephony Company For older IOS versions gGw 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 traditional 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 to these new ports when possible Cisco notes radius server commands will be available only after issuing aaa new model command UDP 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 are 1812 1813 radius server host lt name IP gt acct port 1812 auth port 1813 radius server key lt key gt radius server vsa send accounting radius server vsa send authentication 8 voice card 9 controller 10 voice port Depends on your hardware configuration 11 call application voice amp dial peers call application voice remote_ip ftp remote_ip_authenticate 1 1 1 tcl I dial peer voice 10 pots destinati
5. Account info tab o Account type Account type select credit o Credit limit Maximum allowed credit o VoIP Password Password for authentication authorization If you ate using the default Cisco remote_ip_authenticate script put cisco here o Batch A batch is a management unit for accounts The batch name is alphanumeric You can type a new name here or use the existing name in order to generate more accounts for the same batch Additional Info tab o Preferred language This is a custom attribute which is transferred to the IVR Leave English here if you are not sure whether your IVR supports it o Redirect number Redirect number discussed in the Advanced features section leave this empty Life Cycle tab o Activation date Account activation date o Expiration date Account expiration date O Lifetime Relative expiration date account will expire on first usage date lifetime days If you do not want to use this feature leave the field blank User Interface tab c 2000 2006 PortaOne I nc All rights Reserved www portaone com 2G PORTA Billing 100 Setting up a Wholesale IP Telephony Company o Login The login name this account will use to access the self care pages This can be the same as the account ID or a different one may be chosen for increased security This field is mandatory o Password Password for the self care pages o Time zone Wh
6. Mo Tu We Thr Sa Su 9 lE 10 a a es E a e 11 10 11 12 13 14 15 16 12 17 16 19 20 21 22 23 13 24 25 26 27 26 29 30 14 31 Jul 2003 Mo Tue ThFr SaSu 27 il a fee es es 28 7 6 9 10 11 12 13 29 14 15 16 17 16 19 20 30 21 22 23 24 25 26 27 31 26 29 30 31 Nov 2003 Mo Tue ThFr SaSu 44 1 6 345678 9 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 Mo Tu We ThEr Sa Su 14 il E E Gt S G 15 7 8 910 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 Mo Tu We ThFr Sa Su 31 ee es 32 456 7 8 910 33 11 12 13 14 15 16 17 34 16 19 20 21 22 23 24 35 25 26 27 26 29 30 31 Dec 2003 Mo Tu We ThFr Sa Su 49 1 2 ES EA a e 50 8 9 10 11 12 13 14 51 15 16 17 16 19 20 21 52 22 23 24 25 26 27 28 53 29 30 31 May 2003 Mo Tu We ThEr Sa Su 18 a oe bo ee 19 55 28 jor ee 9 AD pi 20 12 13 14 15 16 17 16 21 19 20 21 22 23 24 25 22 26 27 26 29 30 31 Sep 2003 Mo Tu We ThEr Sa Su 36 i E Ea EA 2 8 a 37 6 91011121314 38 15 16 17 18 19 20 21 39 22 23 24 25 26 27 28 40 29 30 Jan 2004 Mo Tu We ThFr Sa Su 1 1E D A 2 Ea o fet ae 8 a il 3 12 13 14 15 16 17 18 4 19 20 21 22 23 24 25 5 26 27 26 29 30 31 Jun 2003 Mo Tu We ThEr Sa Su 22 1 23 Ea ies en S es a 24 9 10 11 12 13 14 15 25 16 17 16 19 20 21 22 26 23 24 25 26 27 26 29 27 30 Oct 2003 Mo Tu We ThFr SaSu 40 o E a a a 416 7 8 910 11 12 42 13 14 15 16 17 18 19 43 20 21 22 23 24 25 26 44 27 26 29 30
7. MoTuWeThFrSaSu eh re Pre paid card test 123 61234567 4 12345 4 12 ae 32 RA RSG STOR SS 8645 a ee Reseller Age 33 1112 13 14 15 16 17 38 15 16 17 18 19 20 21 42 13 14 15 16 17 18 19 46 10 11 12 13 14 15 16 ee SmartNet 34 18 19 20 21 22 23 24 39 22 23 24 25 26 27 28 43 20 21 22 23 24 25 26 47 17 18 19 20 21 22 23 Invoice 35 25 26 27 26 29 30 31 40 29 30 44 27 26 29 30 31 48 24 25 26 27 28 29 30 C Debit Dec 2003 Jan 2004 Feb 2004 Mar 2004 MoTuWeThFrSaSu MoTuWeThFrSaSu MoTuWeThFrSaSu MoTuWe ThFrSaSu SHEER ER 1 ieee 5 1 oO e e a e SOR RRO t HEARKE SRB Meee 51 15 16 17 18 19 20 21 3 12 13 14 15 16 17 18 7 9 10 11 12 13 14 15 12 15 16 17 18 19 20 21 52 22 23 24 25 26 27 28 41920 21 22 23 24 25 8161718 19 2 2422 13 22 23 24 26 26 27 28 53 29 30 31 5 26 27 26 29 30 31 9 23 24 25 26 27 26 29 14 29 30 31 Apr 2004 gt May 2004 Jun 2004 Jul 2004 MoTuWeThFrSaSu MoTuWeThFrSaSu MoTuWeThFrSaSu MoTuWeThFrSaSu 14 line 18 ime 23 ieee 27 1 ke es E4 185 6 E 8 91011 16 12 13 14 15 16 17 18 17 19 20 21 22 23 24 25 18 26 27 26 29 30 19 a ie es se ed a 20 10 11 12 13 14 15 16 24 17 18 19 20 21 22 23 22 24 25 26 27 26 29 30 24 7 8 910 11 12 13 25 14 15 16 17 18 19 20 26 21 22 23 24 25 26 27 27 26 29 30 285 6 7 amp 91011 29 12 13 14 15 16 17 18 30 19 20 21 22 23 24 25 34 26 27 26 29 30 31 23 31 Choose the customer and then click on the calendar to obtain statistics for desired period The CSV file wi
8. Output Format Date ivy y MM DD 2003 12 31 Time HH24 MI1 SS User Defined Date amp Time YYYY MM DD HH24 MI SS User Defined Input Format Date AYYY MM DD 2003 12 31 Time HH24 MI SS User Defined c 2000 2006 PortaOne I nc All rights Reserved www portaone com 20 PORTA Billing 100 Setting up a Wholesale IP Telephony Company E Vendor Management gt Badd cose PB togout tog Search CDRs Hame Connections Currency Balance E mail Delete O SPT Telecom USD 0 00000 billina spt cz x E x Telecom USD 0 00000 yoip telecom com x E 4 Vendor SPT Telecom connections gt E ada a sive el savegciose cose toot ton PSTN from vendor from Yendor PSTN to endor VoIP to vendor Proxied VoIP to vendor to endor Proxied oIP to endor Edit Load Hode Port Transl Rule Outgoing Rule Tariff Description Capacity Delete Led qw test v ISDN 0 s o 2 a SPT Telecom ter v Termination 24 x E G 4 Vendor SPT Telecom connections Add tl Save fe Save amp Close amp Close B Log gt Badd tal Save m Saveaclose close C dr IM Logout Log PSTN from vendor from endor PSTN to endor VoIP to Vendor Proxied VoIP to vendor to endor Proxied YoIP to endor Edit Load Hode Port Transl Rule Outgoing R
9. 2 MySQL Connector ODBC 3 51 Mysare Http waaay msl conn Welcome Welcome to MySQL Connector ODBC 3 51 Setup program This program will install MyODBC 3 57 on vour computer ltiz strongly recommended that you exit all windows programs before running this Setup Program Click Cancel to quit Setup and close any programs you have running Click Mest 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 anw portion of it may result in severe cvil and criminal penalties and will be prosecuted to the maximum extent possible under law lt 2 MySQL Connector ODBC 3 51 MySQL hip iw mysg conn c 2000 2006 PortaOne Inc All rights Reserved www portaone com HEL RMN EA MME EER MER AREER MEER ERE ERR MEE RMR EERE EES MySQL ODBC 3 51 Driver README C Copyright MySQL AB 1995 2002 Bett tte etter teeter This ts the source or binary distribution of ODBC for MySQL This software i distributed under General Public License GPL For more information read the file COPYING that comes along with this distribution As a special exception to the MyODBC GPL license one is allowed to use MYODBC with any ODBC manager even If the ODBC manager it not GPL In other words The ODBC manager itself is not affected by the MyODBC GPL license MeSGL the most popular Open Source SOL database is p
10. 28 7 8 9 10 11 12 13 29 14 15 16 17 16 19 20 30 21 22 23 24 25 26 27 31 26 29 30 31 Nov 2003 Mo Tu We ThFr Sa Su 4 die 45 39 40550677 8 5 46 10 11 12 13 14 15 16 47 17 16 19 20 21 22 23 48 24 25 26 27 26 29 30 Apr 2003 Mo Tu We Thr Sa Su 14 e e S a a e 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 Mo Tu We ThEr Sa Su 31 i tine a 32456 7 8 910 33 11 12 13 14 15 16 17 34 16 19 20 21 22 23 24 35 25 26 27 26 29 30 31 Dec 2003 Mo Tu We Thr Sa Su 49 l 2 ed a S e 50 amp 91011121314 51 15 16 1718 19 20 21 52 22 23 24 25 26 27 26 53 29 30 31 May 2003 Mo Tu We ThFr Sa Su 18 dee a s 19 55 5 ee ee ee a 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 We ThEr Sa Su 36 2 a ae 37 6 91011121314 38 15 16 17 18 19 20 21 39 22 23 24 25 26 27 28 40 29 30 Jan 2004 Mo Tu We Thr Sa Su 1 WAA 2 a 8 ee o 8 a lil 3 12 13 14 15 16 17 16 4 19 20 21 22 23 24 25 5 26 27 26 29 30 31 Jun 2003 Mo Tue ThEr Sa Su 22 1 23 ez ES ee ee ee 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 Wepepey a 416 7 8 910 11 12 42 13 14 15 16 17 16 19 43 20 21 22 23 24 25 26 44 27 26 29 30 31 Feb 2004 Mo Tu We ThEr Sa Su 5 1 c ie Ga ee ed ee T 910 11 12 13 14 15 8 16 17 16 19 20 21 22 9 23 24 25 26 27 26 29 Download Options oa OQ There are five variants of pre c
11. 31 Feb 2004 Mo Tu We ThFr Sa Su 5 1 6 E E a ie 7 9 10 11 12 13 14 15 8 16 17 18 19 2 21 22 9 23 24 25 26 27 28 29 Download Options M a Choose the vendor and then click on the calendar to download statistics for desired period The CSV file will have the following structure c 2000 2006 PortaOne I nc All rights Reserved www portaone com 37 PORTA Billing 100 Statistics and Monitoring Tools Microsoft Excel 2002 12 31 2002 12 01 GenTel csv LOX E File Edit Yiew Insert Format Tools Data Window Help X W 2 arial i Bau 390905203 fa2 o bb 297r 55100 297755100 390943697 295179301 297755100 414406029 414406029 297755100 295574794 290040959 290040959 295009467 295009467 295500190 Ta 7 E fe 3 Dec 2002 12 05 13 C 0651266276093 CHINA 062061711695 CHINA 067592242436 CHINA 067592242436 CHINA 062444153766 CHINA 062164985417 CHINA 067592242436 CHINA 064102217626 CHINA 064102217626 CHINA 067592242436 CHINA 062165641688 CHINA 061067091308 CHINA 061067091308 CHINA 064154650661 CHINA 062159700603 CHINA 062067302621 CHINA t 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 destination e Call start time e Charged time e Charged amount Country D Descriptio Connect Time Proper 3 Dec 2002 12 10 Guangzhol 3 Dec 2002 12 07 Proper Proper Proper Shangh
12. Once the signup form is completed the data will be posted to the PortaBilling server e After receiving the signup request PortaBilling checks the HTTP header provided by the customer s browser and searches for a product with a matching Subscription HTTP_REFERER allowing further processing only if the host is found in the database If not found the transaction is rejected e PortaBilling associates the Subscription Host with the product for the account that is being created e PortaBilling will use the appropriate validation module to check if the supplied data are correct e The validation module will check the data fill in any non mandatory fields and return the data along with the acquired status to PortaBilling e Ifthe status indicates an error then registration is rejected and the browser is redirected using Continue URL e If the status is OK then PortaBilling proceeds with registration and executes the credit card transaction e Ifthe status indicates an error then registration is rejected and the browser is redirected using Continue URL e If the status is OK then PortaBilling creates an account and redirects the browser using Continue URL c 2000 2006 PortaOne I nc All rights Reserved www portaone com 66 PORTA Billing 100 How to e Fach time the browser is redirected using Continue URL PortaBilline provides a comprehensive set of parameters List of Continue U
13. Retail v a E Additional Info User Interface Login Time Zone Europe Prague Password Web Interface Language en English Access Level v C Periodical Payments management Enabled C Dialing Rules Management Enabled Output Format Date ivy y MM DD 2003 12 31 Time HH24 MI SS User Defined Date amp Time YYYY MM DD HH24 MI S User Defined Input Format Main form top o Name Short name for the customer object will be used on the web interface c 2000 2006 PortaOne I nc All rights Reserved www portaone com 93 PORTA Billing100 Setting up a Wholesale IP Telephony Company O O O Currency The currency in which this customer will be billed Opening balance Starting balance for the customer default is Zero Type Choose if this a reseller or retail direct customer Normally most of your customers would be retail customers Only if a customer is reselling your services while you are providing services and billing to his subscribers would he be created as a reseller Address info tab O Email Email address for distribution of accounting information After the billing period is over a list of CDRs and other statistics will be sent to this address Bcc Blind carbon copy in email may be used for debug and archiving purposes Summary only Distribute summary only do not attac
14. a copy All product names mentioned in this manual are for identification purposes only and are either trademarks or registered trademarks of their respective owners c 2000 2006 PortaOne Inc All rights Reserved www portaone com 1 PORTA Billing100 PortaBilling Guide Part Il Table of contents PC racecar E A ofan acinar tae Stade pentane aime one ees 3 4 Setting up a Wholesale I P Telephony Company 4 Typical DUSINESS ofc 15 lt a ee ee eno Pv Re PO 5 Setting up your network COMPONENTS scsesescssssecscsesesceseseesesesesees 6 Bior OTM Cl OU aan E EE E 8 5 Statistics and Monitoring Tools ccccccccccssssssreeees 28 Billing server health monitoring e esesessessessersesssrsesssissrssrssrssresrssresrrsrssrsrrsss 29 VolP network performance statistics woos cscscscscesssssssssseseseneees 32 SILT aye West a gt e E E EA A EEA EEA 35 0 HON O e EE EE 41 Charge my calling card customers XX min extra when they call a toll MG NNN e A AA E ER ence 42 Authorize and bill my customers by the phone number they are calling from ANI based billing oc cccscscscscscscsescscsesescscssssssscsssssssssssvensesneeens 42 Bill customers who are connected via T1 E1 directly to a port on my fs S 7 ae neo E De eee ee 44 Authenticate and bill my customers by the IP address of their gateway EEE es E PTEE AE EE T IAA EEE dav vaca sean ese aes 46 Use WONG Wg SS CUO IN MO aacsesstacenscncaceessczacatscessa
15. as the PIN authentication will fail because the password supplied does not match the one assigned to the account e If given the option enter your registered phone number the user will then enter both his phone number and password the latter is required to prevent unauthorized usage of his account and both will be supplied to the billing Authentication will be successful only if a correct account ID and password are provided Make a custom report from PortaBilling PortaBilline provides you with an open data model An ER diagram of the database structure is not included in this document but may be obtained from PortaOne Inc upon request If you want to prepare custom reports on your workstation or a non PortaBilling server you will need to do the following e Make sure the remote computer has database drivers installed to access the PortaBilling database Normally you would use native MySQL connectivity on Unix based hosts and ODBC on Windows based hosts e For any data mining solutions extracting data from the database use Only the slave database e Use a tool like Crystal Reports Microsoft Access or some custom application to retrieve data from the database process it and submit it to the 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 Porta
16. at all It was considered an on net call because we did not detect that it went to any of the vendors Check that you have correctly defined connections to your vendors Call was billed only to vendor not to an account or customer and you received an email alert The billing engine needs an Account ID in the User Name attribute to correctly identify the account and customer Check the logs to see what was in the User Name attribute Typical situations are 1 Incorrect value in User Name for example phone number instead of IP address of the remote gateway Cause the required application was not used to handle the call Remedy check that the application is configured and associated with the corresponding incoming dial peer On some of the call legs there is a correct value in the User Name while on others there is an IP address When a call is originated on gateway A and terminated on gateway B then a real username appears only in the accounting from gateway A In gateway s B accounting the username will be the IP address of gateway A because gateway c 2000 2006 PortaOne Inc All rights Reserved www portaone com 53 PORTA Billing 100 How to A had to authenticate itself before being able to make the call This is a perfectly normal situation PortaBilling recognizes this and will replace a username identical to the node s ID IP address with a real username from the other call le
17. graph See picture below call types 3 and 4 Zero duration calls The graph can also show possible problems in the system such as an 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 c 2000 2006 PortaOne Inc All rights Reserved www portaone com 29 PORTA Billing100 Statistics and Monitoring Tools wi wi rm is ew is LMJ ao Week 27 Week 25 Week 29 Week 30 B billable Calls ming Master and slave MySQL server statistics These statistics are accessible from the main admin menu via the Database link in the Statistics section E 4 Database Load Pe cose a omes tog Fri Jul 30 02 14 46 2004 18 00 00 00 E Number of queries W Number of threads Figure 5 2 These two graphs show values for the status of the MySQL servers The green line indicates the number of queries processed by the server every 15 minutes while the blue one shows the number of threads running on the server Queries The graph indicates how many times clients have queried the database On recommended hardware this value may exceed 200 without any difficulties High peaks with a number of requests over 2 000 could indicate improper configuration of the system or temporary problems Also these peaks can appea
18. in the Add product form o Product name Product object name o Currency Product currency Only tariffs which have the same currency will be permitted in the accessibility list o 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 o Breakage Leftover balance which is considered useless for statistical purposes Accounts with a balance below 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 o Maintenance period Surcharge application interval will be reflected in call history as a separate line each time when charged c 2000 2006 PortaOne Inc All rights Reserved www portaone com 1 7 PORTA Billing 100 Setting up a Wholesale IP Telephony Company 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 o Description Your description of the intended use of t
19. lot data is associated with a tariff so that 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 may be used c 2000 2006 PortaOne I nc All rights Reserved www portaone com 46 PORTA Billing100 How to instead Thus some normal non volume based rates are usually first created in the tariff to 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 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 Enter the default rates These rates should not be volume based keep the Volume Time column empty rather these are the rates to be used when the volume lot has been used up Thus 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 now be effective so if a call is made to the US or Canada it will be subtracted from the
20. off peak time o Off peak Price First per minute price for first interval for off peak time o Off peak Price Next per minute price for next interval for off peak time O O OOO O c 2000 2006 PortaOne Inc All rights Reserved www portaone com 1 4 PORTA Billing 100 Setting up a Wholesale IP Telephony Company NOTE Off peak fields appear only if an off peak period has been defined for the tariff o Formula launches the wizard for creating a custom rating formula o Effective from If you want this rate to take effect sometime in the future you can either type a date manually or use the calendar click on the DD MM YYYY link Click on the T Stop Watch icon to make the rate effective immediately NOTE When using the calendar you can specify that the date you are entering is ina different time zone than your current one PortaBilling will then automatically adjust the time El 4 Termination services tariff rates gt Ada fel save close Tartt Logout E Log Calendar Mi E Effective From Destination wo E Prefix Grove County America Vancouver Country Interval sec Price USDimin Effective From Edit Destination re 3 R YYYY MM DD Description First Next First Hext HH24 MI SS CZECH REPUBLIC immediately Tu We Th jem e jas ons Aa OO O m EE ee 1 0 15000 01
21. on the type of customer CDR files for retail customers e Invoice Calls made by 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 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 his invoice c 2000 2006 PortaOne I nc All rights Reserved www portaone com 35 PORTA Billing100 Statistics and Monitoring Tools 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 NOTE Since there are now sub customers under a reseller with statistics for each of them calculated individually statistics of this type are now obsolete This item has been retained here only for backward compatibility so that you can download Statistics for earlier billing periods Mes ww Customer reports Pe Beef fm toot 96 Search Aug 2003 Sep 2003 Oct 2003 Noy 2003 Download Options maxim wholesale MoTuWeThFrSaSu MoTuWeThFrSaSu MoTuWeThFrSaSu
22. port The solution is to use a number matching scheme that will not match any number dial peer voice 1 pots application client_on_port_1l incoming called number A direct inward dial port 12D This solution may be considered a hack yet it is functional and secure For increased security you may specify a 32 character string with a random sequence of ABCD characters The probability of recetving such a number is near zero So the configuration should look as follows aaa new model aaa 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_1l user name abc_ltd I call application voice client_on_port_2 flash app_session_name 2 1 0 tcl call application voice client_on_port_2 user name xyz_inc I Gw accounting N323 vsa I dial peer voice 1 pots application client_on_port_1l incoming called number A direct inward dial port 1 D I dial peer voice 2 pots application client on port_2 incoming called number B direct inward dial port 220 gateway 1 Create customers who will own these accounts 2 Create accounts with an Account ID identical to the name you entered in the configuration for the applications abc_Itd and xyz_inc in our example c 2000 2006 PortaOne I nc All rights Reserved www portaone com 4 5 PORTA Bi
23. such as EasyCall via a toll free number This field is mandatory if you are unsure what to enter here use the same value as for the name of the tariff Description Extended tariff description 4 Click Save E Tariff Management Pe Tqai cel Logo r eee Search ar Jj Hame Currency Type Description Rates Delete Prepaid cards USD Managed by None What we charge prepaid card users for outgoing calls Wholesale rates USD Managed by None What we charge our resellers x c 2000 2006 PortaOne Inc All rights Reserved www portaone com 1 J PORTA Li Billing100 i 4 Pe E save el savenclose cose Logout B og M Ed e E 4 Setting up a Wholesale IP Telephony Company Add Tariff Name Termination services Type Managed by None W Off Peak Period Off Peak Description Destination Group Set Free Seconds Post Call Surcharge Login Fee Connect Fee Round Charged Amount Formula Short Description Description Currency USD US Dollar Y General Info Ae KARKR KAKKAR Termination services What we charge our customers for calls they terminate on our network Edit Termination services Tariff bal save im Save amp close Close 1 Download Upload Rates Test MD Logout E Loa Name Termination services
24. the replication process by using this command slave stop 2 Make a master database snapshot The MySQL distribution provides a special tool for this mysqlhotcopy To use this tool logon to the master server and enter the following at the command prompt mysqlhotcopy flushlog u root p lt root password gt porta BLLITNG After the program finishes running 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 this may vary by installation Consult your mysql conf or system administrator if you are unsure You now have a fresh snapshot of your database 3 Make a snapshot archive and copy it to slave server As the root user go to the mysql data directory Enter the following command tar Czvi porta billing toz porte b11 ling copy This creates an archive of the snapshot Now it can be copied to the slave server The best way of doing this is by using the secure copy tool scp scp porta billing tgz porta admin lt slave server name gt XK 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 When username and password are provided the archive can be stored in any user s home directory In a single server configuration the secure copy tool is not necessary The regular copy command may be used inste
25. to host your online web signup page This could be your corporate website for instance Determine the URL of the page which will submit the request to create an account in PortaBillinge You will need to enter this in the Subscription HTTP_REFERER field For instance if your web sionup page is running on http www mydomain com subscribe html then this is exactly what you should enter in the field If your web signup portal consists of several pages or screens you should enter the address of the last page i e the one which contains the Submit button invoking the PortaBilling signup procedure You will need an https server and a digital certificate in order to secure credit card transactions Create a Web Subscription HTML form using the example provided with PortaBilling and put it on your web site You can add or remove some fields in order to achieve the functionality you require i e you may request that an account ID be entered if you ate providing ANI based service or may not if you are in the debit card business and so on In the configuration file of the web server usr local etc apache porta httpd conf uncomment the section about the virtual host for online signup 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
26. 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 another call is made it will be charged according to the 0 07 rate and so will be reflected in the customer s balance Gi A John Smith volume tariff rates Effective From Destination a Interval sec Price USD min Volume 4 Effective From eS ome z elete First Next First Next min YYYY MM DD HH24 MI SS Edit Destination Country Description It Ji__ I l jajaja Not 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 If the customer is to receive more prepaid 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 1st of February the 1st of March and so on Wholesale volume lot Let us suppose a customer buys 50 000 minutes from you 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 c 2000 2006 PortaOne I nc All rights Reserved www portaone com 47 PORTA Billing100 How to 1 Create a new volume based tariff choose Volume Based in the Type men
27. you need a separate tariff for each of your customers 1 In the Management section of Admin Index choose Tariffs 2 On the Tariff Management page choose I Add 3 Fill in the New Tariff form o Name Short name of the tariff object This is the name you will see later in the select menus o 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 The currency for the tariff is chosen only once and cannot be changed later o Type If you plan for this tariff to be used for your reseller s accounts so that the reseller himself can edit rates in this tariff choose Managed by NNN where NNN is the reseller 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 o Off peak Period Defines the off peak period Click on the Off peak period wizard icon CA to summon the wizard which c 2000 2006 PortaOne Inc All rights Reserved www portaone com 1 1 PORTA Billing 100 Setting up a Wholesale IP Telephony Company O will help you 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 Off Peak Description Description of the off peak period automatically filled in by the of
28. 10 20 or 50 dollars only or ensure that lifetime is 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 local lib per15 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 c 2000 2006 PortaOne Inc All rights Reserved www portaone com 65 PORTA Billing100 How to NOTE Make sure that you restart the web server apachectl restart after making changes in the module e Create a reseller e Create a set of tariffs and products managed by this reseller e Fillin the form on the Product Web Subscription Tab e Login to the customer self provisioning interface and enter the merchant account data Company Info gt Merchant Account tab E 4 Edit EasyCall Product gt E Save R Save t coe B ratetookup OO O oe O Product Name EasyCall Currency USD Managed By Reseller ABC General Info Web Subscription Accessibility Notepad Notepad HTTP_REFERER https www mydomain com subscribe action asp Validation Module my PortaValidation ResellerABC Continue URL https www mydomain com subscribe done asp How it works e To start using your services a user must go to your website and proceed to the online web signup page e
29. 379160 unknown 17708536266 UNITED S Georgia 31 01 04 23 18 M 4 gt P 2004 02 21 2004 02 21 SmartNet Read ea i zji The following data is available e Account ID if applicable not available for a wholesale customers CDRs but available for his accounts CDRs e CLI or ANI From e CLD or DNIS To e Country and description of destination c 2000 2006 PortaOne I nc All rights Reserved www portaone com 36 PORTA Li Billing100 Call start time Statistics and Monitoring Tools 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 be shown as 345 37 00 Use proper call formatting in Excel to eliminate this problem Charged amount Charged time in seconds NOTE The call duration shown in the file is based on the charged duration of the call not the actual call duration So if for instance you bill by 6 second intervals the total call duration will be higher than the actual duration of the calls Vendor CDRs It is very useful to have a detailed list of calls for a specific vendor in case of disputes over the amount of terminated traffic These statistics are calculated daily and are split into files according to the vendor s billing period Mes E 4 Vendor reports Peete lfm cout 1 SPT Telecom X Telecom Mar 2003
30. 5000 2004 07 29 o Hidden Forbidden or Discontinued flags are optional 4 Click the l Save button in the toolbar or the cd of the row 5 Repeat if you need to enter more rates icon on the left end Managing rates offline NOTE Templates are available in PortaBilling a powerful tool for uploading rates from custom format data files However in this particular example we assume that you are preparing data in the default PortaBilling format The rates table may be prepared using a spreadsheet processor i e Microsoft Excel and easily imported into PortaBilling This is very convenient if you wish to make many changes For example you might increase all prices by 10 1 Ifyou are not in Tariff Management for your tariff go to the main menu click on Tariffs and then click on the tariff name 2 Inthe Edit Tariff window move the mouse over the Download button and hold it there until a popup menu appears Choose the Now menu item and click on it This will download the current set of rates empty and will also provide you with an overview of the file structure c 2000 2006 PortaOne I nc All rights Reserved www portaone com 1 5 PORTA Billing100 Setting up a Wholesale IP Telephony Company 3 You will see the File download dialog and be prompted to save the file or open it from its current location We recommend that you first save the file into a folder you will be using to store tariff data files in the futur
31. 6 PortaOne Inc All rights Reserved www portaone com 51 PORTA Billing100 How to Translation Rule Test Close window Translation rule ar01 input 011420222333444 Test Save Input 011420222333444 Output 420222333444 This will enable you to check if your translation rule has the proper syntax and you can also immediately see if it performs the translation you need Locate h323 conf id fora call Unique call IDs are extremely important for troubleshooting They allow you locate a call in the database and find call information in the billing engine logs or RADIUS detail files Finally and this is the most important thing when reporting call problems to the PortaOne Support team or your business partner a call ID helps to prevent confusion and allows the problem to be solved quickly In order to find the h323 conf id for a call do the following 1 From the main menu go to Trace Call 2 Using the CLD and from to date filters make sure the required call is shown in the list of calls on the screen 3 In the row containing call information click on the a View icon far left column You will be shown detailed information about the call 4 The first field on the screen should be the h323 conf id which is a combination of four hexadecimal numbers separated by spaces e g 5FF7F6D1 715E02C6 A40990F3 C823E27E Troubleshoot incorrectly billed call 1 Make sure that someone in your organization is subsc
32. 7 SQL command on connect Cancel Options gt gt Test Data Source Help Important parameters include 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 reporting 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 2006 PortaOne I nc All rights Reserved www portaone com 61 PORTA Li Billing100 Using ODBC FZ Microsoft Access File Edit View Insert Tools Window Help Type a question For hel Oe 8S 9 dS Bo B cB ty 00 g a O How to g db1 Database Access 2000 file format open D Design New x 25 Create table in Design view Tables Create table by using wizard Create table by entering data Select Data Source Queries Forms B Reports s Pages Macros amp Modules Favorites In MS Access i a SS File Data Source Machine Data Source dBASE Files Excel Files Me sores Database ortaBillin A Machine Data Source is specific to this machine and cannot be shared User data sources are specific to a user on this machine System data sources can be used by all users on this machine or by a system wide service Create a blank database Right click in the table design view and choose Link tables
33. 7 US overseas dialing format 021234567 local format PortaBilling provides you with a powerful tool for converting all outside numbering formats into the unified format which is to be used in billing For every connection to a vendor you can specify a translation rule that will convert the number into E 164 format Here are some ready to use examples of translation rules e Convert NANP North American Numbering Plan phone number area code phone number e g 604 888 7766 into 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 E 164 s 00 e Convert North American international dialing format 011 country code area code phone number e g 011 1 604 888 7766 into 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 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 E 164 s 6789 e Convert European domestic dialing format 0 area code phone number e g 0 5 888 7766 into E 164 assuming that the country code is 44 s 0 44 Always test your translation rules before entering them into the billing A special test window is available on the web interface To access it click on the test icon next to the translation rule field c 2000 200
34. Billing you can do this using external tools such as MS Access or Crystal Reports c 2000 2006 PortaOne Inc All rights Reserved www portaone com 56 PORTA Billing 100 How to Create a MySQL user to be used for reports 1 Login into your Portabilling slave server using ssh 2 Start the 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 g Your MySQL connection id is 42122 to server version 4 0 17 log Type help or h for help Type ie to clear the buffer mysql gt 3 Create a new user using the 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 permit access to all of the tables in the database It is provided just as an example modify it according to your actual needs 4 Flush the privileges mysql gt FLUSH PRIVILEGES Query OK O rows affected 0 07 sec Installing the MySQL ODBC driver 1 Download and run the installation package from http www mysql com 2 Click Next on the information screens c 2000 2006 PortaOne I nc All rights Reserved www portaone com 57 PORTA Billing 100 How to
35. E Only your own gateways have to be entered as nodes Remote gateways which belong to the customer or ones which legally belong to you but are used solely by your customer s are not considered nodes i 4 Node Management gt 0 add close o O O H323 ID Radius Client Oves Ono OMI Hame h323 id IP Radius Client Delete He Add Node i Save el Save amp Close Close i s s s s sSsSsSsid CM eogout Node Name test gw Node info h323 id test gw mydomain com z Type VOIP GW vi cisco Manufacturer Cisco 123 45 67 99 h323 password NAS IP Address Hostname test gw Domain mydomain com Radius Client Auth Transl Rule f Radius Key secret A E s Time Zone America Vancouver Radius Source IP 123 45 67 89 lt i 4 Node Management gt 0 add cose o O Dot H323 ID Radius Client Oves Ono OAI Hame h323 id IP Radius Client Delete gw test gw test my domain com 123 45 67 89 EJ 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 In the Management section of the Admin Index page choose Nodes In the Node management window click the amp Add icon 3 Fill in t
36. LWare package since what you are looking for or something similar is perhaps already there If you find an application similar to what you need you can use it as a template c 2000 2006 PortaOne I nc All rights Reserved www portaone com 5 4 PORTA Billing100 How to lt A productivity tool for TCL IVR development is NE available from PortaOne Inc FastIVR emulates Cisco with regard to script execution TCL FastiVR API and VoIP related IOS commands You can find out more at http www portaone com solutions fastivr Make the Periodical payments tab appear in the customer account info The Periodical payments tab will only be shown if the rest of the system is configured to accept payments This requires e Atleast one payment system defined in the Company Info section e A payment system assigning the currency of this account or customer e For accounts the E commerce enabled flag must also be switched on e On the Payment info tab the Preferred payment method must be set and information about the credit card entered For sub customers or accounts belonging to sub customers the requirements are the same except that the payment systems are defined in the reseller information not in Company Info Prevent ANI number from being used as a PIN The first method is the easiest one use different gateways or access numbers for PIN based and ANI services and configure product accessibility accordingly Th
37. NOTE It is possible that you will require assistance from PortaBilling support personnel in the future In order to provide support they will need access to the web interface Therefore 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 Currencies and specify the exchange rates in Exchange Rates Create destinations This step is only required if you have not defined the necessary destinations before There are two ways of entering new destinations into the system e One by one using the l Add functionality on the web interface e Bulk update by uploading destinations from a file NOTE A file with the default destination set is supplied with PortaBilling You can download it and then upload it to the server However it may be possible that your business requires different types of prefixes so please check the data in the file before uploading c 2000 2006 PortaOne I nc All rights Reserved www portaone com g PORTA Billing 100 Setting up a Wholesale IP Telephony Company Creating destinations one by one 1 Inthe Management section of Admin Index choose Destinations i 4 Destinations f oe 4202 Prefix Country Description gt ABCDEFGHIIJKLMNOPQRSTUYWXYZ hfi Prefix Country Subdivision Description Delete Ld 4202 CZECH
38. PORTA ONE Porta 4 Billing 100 Maintenance Release 10 F al he User Guide Part Il www portaone com PORTA Billing100 PortaBilling Guide Part II Copyright notice amp disclaimers Copyright c 2000 2006 PortaOne Inc All rights reserved PortaBilling100 User Guide Part II V 1 10 5 January 2005 Please address your comments and suggestions to Sales Department PortaOne Inc Suite 400 2963 Glen Drive Coquitlam BC V3B 2P7 Canada Changes may periodically be made to the information in this publication Such changes will be incorporated in new editions of this guide The software described in this document is furnished under a license agreement and may be used or copied only in accordance with the terms of the license agreement It is against the law to copy the software on any other medium except as specifically allowed 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 electronic mechanical photocopied recorded or any other means without the prior written permission of PortaOne Inc 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 PortaOne representative for
39. R Load Threshold 5 x This graph shows the node load setup time and ASR Average Success Rate statistics The green area indicates node load the 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 a duration of more then 3 600 seconds ate rare and do not affect our statistics very much zero duration calls need an average duration of 10 seconds to be processed by the router c 2000 2006 PortaOne Inc All rights Reserved www portaone com 39 PORTA Billing 100 Statistics and Monitoring Tools Connection load calculations For a 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 corresponding to 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 zero duration Sum of durations of all the calls Sum of durations between to 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 ae iS The maximum value in seconds which a connection can hold in the 900 sec interval is calculated as capacity 900sec The connection load is calculated as the s
40. REPUBLIC Not Applicable v Prague 4202 CZECH REPUBLIC Prague 2 Click on the El Add button 3 Fill in the required information This includes the phone prefix and country Country subdivision is optional You can use the Description column to store some extra information about the destination for example if it is a mobile or fixed number 4 Click lal Save 5 Repeat steps 2 4 for each additional destination Uploading a set of destinations from a file 1 Inthe Management section of Admin Index choose Destinations 2 Click on Get default set to download a 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 Upload on the Destinations screen 6 Type in 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 2006 PortaOne I nc 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 your gateways into the system before In this case you must enter your gateways as nodes PortaBilline requires some key information about your network equipment such as IP address h323 id Radius shared secret etc NOT
41. RL parameters and possible values e status ORK ERROR message CC rejected session_id unique session ID supplied by the web subscription server e account_id generated account ID Sample files These 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 An online web signup HTML form can be found at the following URL https myPortaBilling myCompany com 8500 subscription html where myPortaBilling myCompany com is the URL of your PortaBilling Web Interface and 8500 is the port on which the subscription virtual host is running c 2000 2006 PortaOne I nc All rights Reserved www portaone com 67 PORTA Li Billing100 Maintenance c 2000 2006 PortaOne I nc All rights Reserved www portaone com Maintenance PORTA Billing100 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 porta billing conf and is 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 wish to alter the default behavior porta billin
42. ad c 2000 2006 PortaOne I nc All rights Reserved www portaone com 7 4 PORTA Billing100 Maintenance 4 Remember master binary logs position Login to the master MySQL server and enter the command show master logs Remember the last log_name you will need it to start replication on the slave server later 5 Restoring database from archive on slave server While logged in as root on the slave server unpack the archive file to the mysql data directory To do this simply ca to the mysql data dir and enter the command tar XVZT lt path to gt porta billin ng tgz If you used the scp copy command as described earlier the lt path to gt may be replaced by the porta admin Delete the old database stored in porta billing directory im r i porte billing and then rename the 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 owned by the mysql user In a single server configuration this will be the porta admin user Note This procedure is not completely in agreement with MySQL X documentation which instructs the user to dump the whole database to sql statements and then restore it on the slave machine Carrying out such an action on a production database with a large amount of traffic could result in significant latency Resume replication Lo
43. ai 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 120A 3 Dec 2007 1204 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 Guangzhol 3 Dec 2002 11 51 m LL aa 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 mm Charged Ti Charged Amount 0 0 0 63617 Cost Revenue statistics These are essential tools for monitoring the growth of your business Working with different partners different currencies and different prices it is very easy to make mistakes and carry out non profitable calls Cost Revenue reports allow you to monitor this and stay out of trouble To access Cost Revenue reports follow the Cost Revenue reports link from the Statistics section of the main menu c 2000 2006 PortaOne Inc All rights Reserved www portaone com 39 PORTA Li Billing100 Mes E 4 Statistics and Monitoring Tools Cost Revenue reports gt cose Bewtomavey Pe Inbound by Country Inbound by Customer Outbound b Country Outbound by Vendor Inbound Mar 2003 Mo Tu We Thr Sa Su 9 ij 10 es A a e ee E 11 10 11 12 13 14 15 16 12 17 18 19 20 21 22 23 13 24 25 26 27 26 29 30 14 31 Jul 2003 Mo Tu We ThFr SaSu 27 ah ise et is A t
44. aid_v2 flash app debitcard 2 0 0 tel test_vl flash test_api_vl tcl test_v2 flash test_api_v2 tcl Use the clid_ application that corresponds to your authentication configuration or develop your own This is transparent from the billing point of view as it uses ANI CLD as User name Here is a sample configuration aaa new model aaa authentication login h323 group radius aaa authorization exec h323 group radius aaa accounting connection h323 stop only group radius Gw accounting h323 vsa dial peer voice 1 pots application clid_authen_npw incoming called number port 1 D gateway c 2000 2006 PortaOne Inc All rights Reserved www portaone com 43 PORTA Billing100 How to 3 Create a customer who will own these accounts 4 Create accounts with an Account ID identical to the phone number from which the service is to be used TIP Check in which format ANI CLI numbers are reported by your gateway For example the phone number 420 2 1234567 might be reported as 21234567 021234567 42021234567 or something different You must use exactly the same format for the Account ID or change your application so as to convert it to the desired format Bill customers who are connected via TI El directly to a port on my gateway Typically you do not use authentication or authorization for such port based billing since you are always sure that your customer is on the other end of the
45. alculated reports e Inbound by Country Information is 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 by destination only i File Edit View Insert Format Tools Data Window Help DEAR BAS o Br AA Al v Customer E ee a a a SS ee ee ee y Destination Country Description Calls Gross Rated Rated Total Total margin Sec i Revenue Arial Customer N ok SmartNet SUBTOTAL SmartNet SmartNet SUBTOTAL SmartNet SUBTOTAL SmartNet SmartNet SUBTOTAL 12 Pre paid car SmartNet 3741 ARMENIA Yerevan 0 60521 639 0 60521 639 1 27417 6027 0 43476 369 1 70895 6396 2 35228 12656 2 35228 12656 1 51933 1305 0 16463 130 1 70396 1435 106 21 2126 11 2362 6279 0 18254 517 0 261 178 IKI 13 983333 13 983333 133 78333 6 15 139 93333 214 26667 214 26667 21 75 2 1666667 23 916667 35 433333 87 903333 58 6166667 2 9666667 1 19768 1 19768 3 05561 0 98769 4 0433 3 20971 3 20971 3 66377 0 40983 4 0736 5 56076 14 06189 1 70489 0 58696 2 00289 2 00289 4 32976 1 42247 5 75225 5 56199 5 56199 5 1831 0 59446 5 77756 111 7906 25 29009 1 52235 0 64796
46. base You can force nodes connections to reload by sending a HUP signal to the radius daemon Email flood prevention Email c 2000 2006 PortaOne Inc All rights Reserved www portaone com 69 PORTA Billing 100 Maintenance Max_Sequential_Emails 5 Look_Behind_sec 450 If the Max_Sequential_ Emails in the Look_Behind_sec interval have already been sent any extra email alert will be blocked This is done to protect against email flooding 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 Address 127 0 0 1 Shared_Secret SecretKey User Name 127 0 0 1 Password cisco This section defines parameters for the PortaBilling self test suite The script periodically sends an authentication request to the radius server and expects a positive answer radcheck pl amp porta clients pl Radius Host 127 0 0 1 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 the radius server required by the scripts as a self check Log Where logs should go Possible values are Syslog File and Console Log_To File This writes a PortaBilling log to the file on disk This is the default option and normally is sufficient for both production and debugging Use other ways of logging only for sp
47. billing smart net BCC Send Statistics Full Statistics v Province State WA Description PostalCode 98154 City Seattle CountrwRegion USA c 2000 2006 PortaOne Inc All rights Reserved www portaone com 99 PORTA Billing 100 Setting up a Wholesale IP Telephony Company HA Add Customer gt fd Save ie Save amp Close Close s s sSsSCs dr MD hoot Customer Name SmartNet Currency USD US Dollar Blocked F Opening Balance B Type Retail V Y Address Info Additional Info Payment Info User Interface Credit Limit Balance Warning Threshold D A Add Customer gt ta sive savegciose coe toot Customer Name SmartNet Currency USD US Dollar Blocked F Opening Balance lo Type Retail E wv E Address Info Additional Info Payment Info User Interface Routing Plan Default Categorizing and Defaults Billing Period Monthly Y Invoice Template Do not create invoice V Terms Due on receipt v Representative Not defined Y Tax ID Callshop Enabled Gi 4 Add Customer gt ea sive ia savexciose cose Lowa Customer Name SmartNet Currency USD US Dollar Blocked F Opening Balance o Type
48. cocarsenceatescsaa ctecsigcseneeanseeiokenecdee 46 Charge reseller for INCOMING calls uo eeseesesssssssesssssssesssesesesees 49 Deal with technical prefixes and numbering formats 50 Locate h323 conf id for a Call sicscsccicssccanvositicncivecsesadventerdeciacssinsadviettaasteessatiaeenes 52 Incorrectly troubleshoot billed Callow cesses 52 Create a custom TCL application uu eeeesssssssssssesssssssssesesesees 54 Make the Periodical payments tab appear in the customer account info PE AEN TEENA E ses cs nests ten Gu E EATI E AEA oneveneen tices 55 Prevent ANI number from being used as a PIN 55 Make a custom report from PortaBilling sesser 56 Use ODBC to connect to PortaBilling ecco 56 Use redirect number feature uu ccccscssssecscscssssssssssssescssssssssesesssssssssesesees 63 Configure outgoing connection to vendor if sending calls using a gatekeeper so that the remote IP address is not known in advance 63 Force PortaBilling to disconnect after a customer calls over his credit E eee aceon tester EE ETEEN ona EOE 64 Create accounts to be used for SIP S rVIC S ccc 64 Integrate PB logins in your website wo cece 64 Configure online web SIGNUP ccc ccceceecesssstsssssssssssssssssssssesesesesees 65 Z L111 1 ae arn ari ERANO FFAS ErEN 68 Configuration files ssssssssesssrssssssssesssceressissrorsssesieviresssvrssrostsrtssrtaroareseisissnosrestesatss 69 FIO A T ea e E A A E E 73 c 2000 2006 PortaOne Inc Al
49. ctions Currency Balance E mail Delete O Telecom USD 43 37330 yoip telecom com c 2000 2006 PortaOne I nc All rights Reserved www portaone com 1 g PORTA Billing 100 Setting up a Wholesale IP Telephony Company i 4 Add Vendor gt sove Jed sovencose coef Woe E Vengor Name SPT Telecom Currency USD US Dollar Opening Balance Address Info Additional Info User Interface E Company Name SPT Telecom Contact a Mr ths J Phone 420 2 24010100 a Firs Name Fax m Las ame Alt Phone a Addtpss Y Celnici 10 Alt Contact E mail billing spt cz BCC Summary Only Province State Posi Code 11721 City E Prague E Description CoumtriRegion czech Republic Ba Hw Add Vendor gt ea sive led sovencose coe W Vendor Name SPT Telecom Currency USD US Dollar Opening Balance Categorizing and Defaults Billing Period E 4 Add Yendor gt E save i savegciose cose toot Vendor Name SPT Telecom Currency USD US Dollar Opening Balance o v Address Info Additional Info User Interface Login Time Zone Europe Prague Password Web Interface Language v Access Level Vendor
50. d es ee fs 37 8 910 11 12 13 14 38 15 16 17 18 19 20 21 39 22 23 24 25 26 27 28 40 29 30 Jan 2004 Mo TuWe ThFr Sa Su 1 il ie es ae 2 Boe eo a a il 3 12 13 14 15 16 17 18 4 19 20 21 22 23 24 25 5 26 27 26 29 30 31 May 2004 Mo TuWe ThFr Sa Su 18 il ie 19 ies a ies fe a ed 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 Mo TuWe ThFr Sa Su 40 fl ee ed fe 44 Be e ed ee de 42 13 14 15 16 17 16 19 43 20 21 22 23 24 25 26 44 27 26 29 30 31 Feb 2004 Mo TuWe ThFr Sa Su 5 1 6 E eo 2 S aG a T 910 11 12 13 14 15 8 16 17 18 19 20 21 22 9 23 24 25 26 27 26 29 Jun 2004 Mo TuWe ThFr Sa Su 23 E a ie ed a a 24 7 6 9 10 11 12 13 25 14 15 16 17 16 19 20 26 21 22 23 24 25 26 27 27 26 29 30 gt Nov 2003 Mo TuWe ThFr Sa Su 44 i 43456 7 8 9 46 10 11 12 13 14 15 16 47 17 16 19 20 21 22 23 48 24 25 26 27 26 29 30 Mar 2004 Mo TuWe ThFr Sa Su 10 i 2 ied es a e 114 8 91011121314 12 15 16 17 18 19 20 21 13 22 23 24 25 26 27 28 14 29 30 31 Jul 2004 Mo Tu We ThFr Sa Su 27 T E es 20 5 Bb i ed ed a 29 12 13 14 15 16 17 16 30 19 20 21 22 23 24 25 31 26 27 26 29 30 31 You can download pre calculated statistics in CSV format for previous days or obtain data online using Custom Query For pre calculated statistics click on the vendor at left then choose the statistics period from the calendar Pre calculated statistics will look like t
51. e then open it in Excel 4 You should see something similar to the screenshot below i File Edit View Insert Format Tools Data Window Help l x Deh 46RwY SSeS o Q A2 e arial 10 vi BZ UES 3 Ble 2 A AB 420 Sk ae eT A lt a RS Tl ae JT ae a el a ee a A 1 Name Currency Description An Termi USD What we charge our customers for their calls we terminate Off peak P Free Seconds Post Call Login Fee Connect Fee 0 0 D Destinatior Countr Descriptior Interval 1_ Interval N Price 1 Price N Offpeak In Off peak In Off peak FOff peak P Forbidder Hidden Discontin Effective From 420 CZECH REPUBLIC Proper 4 4 gt Dl M csv An _Termination 2 f 4 Read Sum 38391 34809 5 Edit the file by adding more rows with rate data so that it looks similar to the screenshot below 6 Note that the columns Country and Description are only for reference purposes and are ignored during the import Also when using the default template you must fill in the data in the Offpeak columns even if your tariff does not have an off peak period use the clipboard to easily copy values for the 4 peak columns 7 Also note that you may use only those phone prefixes which you have already defined as destinations see Create destinations above i File Edit View Insert Format Tools Data Window Help l x DEASY teI Bre 4 MB arial 10 BlU S33 He amp Oo A 420602 1 Name Currency Descriptio
52. e between the tariff he charges his customer An and the tariff he is being charged by the vendor B c 2000 2006 PortaOne Inc All rights Reserved www portaone com 5 PORTA Billing 100 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 that the hostname be the same as the h323 id hostname lt h323 id gt ip domain name lt default domain gt NOTE vsa h323 gw id hostname domain 2 NTP NOTE It is very important to have reliable time services 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 lt your interface to the world gt h323 gateway voip interface h323 gateway voip id lt gatekeeper id gt ipaddr lt IP gt lt port gt h323 gqateway voip h323 id lt h323_id gt NOTE If you want to use a virtual interface then add the line h323 gateway voip bind srcaddr lt IP gt
53. ecial debug purposes For logging to file give the filename For logging to the syslog give description in t torm Of Syslog lt Tracility gt lt pri6rity gt 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 the lifetime of calls in the call cache Radius_Retransmits 5 Radius_Timeout 3 In order to know when we should no longer expect any packets we need to know the maximum possible delay with which the request can be delivered to radius the last possible retransmit Alive_Interval 60 If we bill by keep alive requests we need to know what is the interval between them Incoming_Session_Lifetime 10 Call lifetime after incoming call leg has been disconnected Default_Lifetime 120 Default lifetime of the call Suggestions c 2000 2006 PortaOne I nc All rights Reserved www portaone com 70 PORTA Billing 100 Maintenance No_Remote_IP_Auth no Whether PortaBilling should warn you when it seems that your gateways are not authenticating incoming VolP sessions Admin server and web interface The configuration file is called porta admin conf and is located in the home porta admin etc directory It is automatically created by the installation program and populated with the initial configuration You might wish to edit it so that the system will bet
54. ed statistics for today or a report with certain other parameters for example divided by hour so that you see how the ASR evolved during the day you can use the Custom query report This z Ff 8 extracts data directly from the database so use it with caution in order not to overload the server c 2000 2006 PortaOne Inc All rights Reserved www portaone com 34 PORTA Billing 100 Statistics and Monitoring Tools Gi w Custom Query Pe 8 cise a obees i tog Customer ALL Vendor ALL v Destination SS From 2004 02 23 YYYY MM DD 00 00 00 HH MI 55 E To 2004 02 24 YYYY MM DD 00 00 00 HH MI 55 Split No split Y Show results Customer s Calls Billable Calls Duration min sec ASR ALOC 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 both ASR and Cost Revenue parameters are shown on the Custom Query report Billing statistics Customer CDRs Lists of all customers CDRs are calculated daily and are split into files according to each customer s billing period These pre calculated statistics can be automatically mailed to the customer They are also available for download by the customer on the self care pages and for your staff on the admin interface Different types of CDR files are available depending
55. en an account owner accesses the web self care pages to see a list of his calls the time will be shown in the time zone most appropriate for him o Web Interface Language The language to be used on the customer self care web interface 5 Click l Save amp Close a confirmation screen will indicate that the account has been created 6 Repeat steps 3 5 if the customer has more than one remote gateway c 2000 2006 PortaOne I nc All rights Reserved www portaone com 27 PORTA Billing 100 Statistics and Monitoring Tools 5 a Statistics and Monitoring Tools PORTA Billing 100 Statistics and Monitoring Tools Billing server health monitoring Entire system load These statistics are accessible from the main admin menu via the System load link in the Statistics section This graph shows the number of calls registered by a production system every 15 minutes normal calls with duration gt Q green areas and calls with zero duration red line The most recent information appearing on the right hand side of the graph is an hour old or less 6 0 4i 4 0 mi Po Pa LPa 7 ae 2 0 0 0 F 16 00 18 00 20 00 22 00 0000 0zi 00 OF 00 0G 00 O8 00 1000 12 00 614 00 16 00 B billable calls W zero duration calls Figure 5 1 Number of calls If the disconnect time on the CDR does not fall within the past 15 minutes the call may not be finished and hence will not be reflected on the
56. ent 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 gets invoiced to the wholesale customer In addition you can use the Custom Query report which is identical to the Custom Query report in the ASR statistics c 2000 2006 PortaOne Inc All rights Reserved www portaone com 40 PORTA Li Billing100 How to c 2000 2006 PortaOne I nc All rights Reserved www portaone com How to 41 PORTA Billing100 How to Charge my calling card customers XX min extra when they call a toll free line This is very easy to do with PortaBilline s Accessibility feature 1 Create two tariffs one with your normal rates for example 0 13 dollar min for calls to Czech Republic and the other one with toll free rates including your toll free costs 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 plus the costs of one minute on the toll free line In order to make a 3 minute call the customer will spend about 4 minutes on the line while listening to voice prompts entering a PIN destination and waiting for an answer Additionally situations where a customer will enter an incorrect PIN or be unable to reach his party at all should be taken into account Therefore usually TollFree_ P
57. f 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 interval see the Enter Rates section above Post Call Surcharge Percentage of the amount charged for the call Login Fee Amount to be charged immediately after the first user authentication 1 e after user enters his PIN Connect Fee Amount to be charged for each connected call with a non zero duration Round charged amount Instead of calculating CDRs with a 5 decimal place precision round up CDR amount values e g to cents so that 1 16730 becomes 1 17 Formula Default rating formula which will be applied to every rate created in the tariff If you leave this empty the old style rating will be used 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 for a tariff named cust ABC Easy Call 1800 the short description will provide better information for your reseller ABC who will be using this tariff
58. g conf Only full qualified email addresses no local aliases please Global last_resort_email admin yourdomain com If a 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 appear in the From field of email alerts Suspicious_Time_Threshold_sec 86400 Maximum acceptable difference in time sent by the gateway and current time on the server Default is 24 hours SQL _ Trace 0 Whether all SQL queries and their results should be logged to the PortaBilling log file Use with caution and only when a detailed debug is necessary since this produces huge log files Master DSN DBI mysgl database porta billing User root Password xXXXXxX Connect parameters for the master database Simultaneous login prevention for debit accounts 4 Fraud_Detection Active Yes Turn the fraud protection on Test_Mode No Turn the fraud detection on Debit accounts will be allowed to login more than once but an email alert will be sent Recovery_Time_sec 1800 After a debit account is successfully authenticated how long should this information should be kept in the memory Default is 30 minutes A longer recovery time will increase the 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 data
59. g the data source create an MySQL user on slave DB with read only permissions Please examine 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 in the configuration form c 2000 2006 PortaOne I nc All rights Reserved www portaone com PORTA Billing100 How to r ODBC Data Source Administrator User DSN System DSN File OSN Drivers Tracing Connection Fooling 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 rivodbie3 best MySQL ODBC 3 51 Driver Configure An ODBC User data source stores information about how to connect to the indicated data provider A User data source is only visible to you and can only be used on the current machine OF Cancel Help MySQL ODBC 3 51 Driver DSN Configuration V Ed This dialog helps you in configuring the ODBC Data Source Name that you can use to connect to MySQL server DSN Information Data Source Name PortaBilling Description Portabiling database MySQL Connection Parameters e Host Sernver Marmelor IF porta biling slave z Databaze Mame porta biling Mi Lj SQL User reports Password EA Port if not 3306 230
60. gon to the slave mysql server using the mysql command mysql uroot p lt root password gt porta billing Recall log_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 2006 PortaOne Inc All rights Reserved www portaone com 7 5 PORTA Billing100 Maintenance At this point the mysql server must be restarted for replication to continue The following are the commands to stop and start mysql on a typical FreeBSD system asr local etc rc d mysql server stop usr local etc rce d mysql server start On RedHat Linux systems the commands may be usr etc init d mysql stop usr etc init d mysgl start The location may vary depending on the operating system If in doubt ask your system administrator To ensure that replication has resumed logon to the server and check the slave status show slave status In the second row of the Slave_Running column you will see Yes c 2000 2006 PortaOne I nc All rights Reserved www portaone com 76
61. gs 3 Value in User Name is correct but reports Did not find account customer Check the accessibility for the account s product It may be that even if you have such an account its accessibility is incorrect Call was billed but the phone number in the billing is incorrect not in E 164 format and there is a Mismatch in rates or destinations error Cause missing or incorrect translation rule on connection to the vendor Remedy assign a translation rule read the Deal with technical prefixes and numbering formats section Call was billed and the phone number in the billing is correct but there is a Mismatch in rates or destinations error Cause missing rate for this phone prefix in the tariff Remedy create a rate for this destination in the tariff 5 Ifyou are unable to solve the problem by yourself submit a problem report to support portaone com Please make sure that you include the following in your email A detailed description of the call flow and what seems to be incorrect H323 conf id of the call Relevant items from the porta billing log Create a custom TCL application Sometimes you need a special call handling or IVR functionality which is not available in the applications you already have For example you need a prepaid card IVR which will perform ANI authentication prior to PIN authentication First of all check the TCL applications available as part of the Cisco TC
62. h details file might be useful when the amount of calls is very 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 and 16 last day inclusive sent on the 1 day Monthly 1 last day inclusive sent on the 1 of the next month Payment info tab O O Credit limit If left empty there is no credit limit for this customer Balance Warning Threshold Customer can be notified by email when his balance is dangerously close to the credit limit and his service will soon be blocked Here you can enter the value for the warning threshold as follows Asa percentage e g 90 A warning will be sent when the customet s balance exceeds this percentage of his credit limit Thus if his credit limit is 1000 00 and the threshold is 90 a warning will be sent as soon as the balance is over 900 00 This is only applicable when the customer has a positive credit limit Asan absolute value A warning will be sent as soon as the balance exceeds the specified value c 2000 2006 PortaOne I nc All rights Reserved www portaone com P 4 PORTA Billing 100 Setting up a Wholesale IP Telephony Company User Interface Time zone This parameter serves two pur
63. hat portion of data which was not uploaded as an attachment so you can try to import it 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 X e A tariff for each account s billing scheme For example if you plan to charge your customers more when they access toll free lines instead of local ones you need two tariffs i e Normal and Using Toll free line e A tariff with the termination costs for each termination partner you have e If you have resellers also create tariffs that you will use for charging each of them Do not create tariffs which will be applied to your resellers subscribers yet First create customers and 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 Each of the remote customer gateways will be represented as an account and billed accordingly Hence we need to create a product for this account in order to have a defined way of billing it 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 the H Add icon 3 Fill
64. he New Node form o Node name A short descriptive name for this node will be used in the select menus N c 2000 2006 PortaOne I nc All rights Reserved www portaone com 10 PORTA Billing100 Setting up a Wholesale IP Telephony Company o H323 ID h323 id recommended hostname domainname o H323 Password If you plan to use the default Cisco remote IP authentication script put cisco here o NAS IP Address IP address of the gateway o Auth Translation rule Use to convert a dialed number to the desired format o Type VoIP node type select VOIP GW o Manufacturer Select Cisco or Quintum o Radius Client Select if this node will be communicating with the billing system o Radius Key If this node is a radius client enter the shared secret here must be the same as that configured in NAS as a key in the radius server configuration o Radius Source IP Unless your gateway has multiple network interfaces the value here should be the same as NAS IP Address 4 Click ml Save amp Close 5 Repeat steps 2 4 until all of your nodes have been entered NOTE There is some propagation delay between the database and the Radius server configuration file but no more than 15 minutes Create Tariff A tariff is a single price list for call services A tariff combines conditions which are applicable to every call regardless of the called destination per destination rates Normally
65. he customer te 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 customer a volume lot of 50 000 minutes to Prague Czech Republic 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 4 000 which is incorrect However if you configured your rate as shown below and entered an average price per minute the cost revenue statistics would show the actual figure of 1 500 c 2000 2006 PortaOne I nc All rights Reserved www portaone com 4g PORTA Billing100 How to E 4 ABC volume based tariff rates Effective From Destination non 202 refi Geant Interval sec Price USD min Volume ay Effective From one elete First Next First Next min YYYY MM DD HH24 MI SS CAIC J ajaja 5 4202 CZECH REPUBLIC Prague 1 1 0 11000 0 11000 50000 2004 02 24 00 19 42 Edit Destination Country Description Charge reseller for incoming calls A very common situation is that in which you provide the reseller with billing gateways and other required components When an end user makes a call you charge the reseller according to your wholesale rates But now the resel
66. he following Ei Microgedt Encel SOQ 0 24 60 PaeTeccey I e E Mew fert Foma Took Dae indo Hele Acrobat OS MR GAY DB T E Ma oe p aa nt Ae ie A 36 7166213490 EN 7135815372 E IIA 35 3175813555 Ei Bs Al Jes EA JISE ME TESSA unknown 7i Ea 12576007 gnn afi G34 14699 28 unknyan 50 Junknown 1 F BZU zaja E J A 7 E Changed Time marsec Changed Amount USO B E l D E F Country Descneaian Connect Time Ba S21 Deh Cust Srt anwan 1104 EE BAbJ5p219 Dey en toll free BOUL 8 29 S05 BAbIS692 17 Det Sales BH2004 14 32 1 18 Babar 15 Delt er boll trav BSUS BB 00 FO Sra 25 gt RUSSIAN FEDER TRO Proper DANAJA J34 Du 1025550 BAHAMAS Proper B2004 15 35 0 00 Vd a BAHAMAS Praper Bad 16 34 OO THAE BAHAR AS Proper Be WS QO IDS 2 4SE4F8 16 North Avrerica ESDM 15 23 0 00 14S CAMADA Oriani Bad 16 25 i 14051216 UNITED STATES Wisconsin BA 15 23 Wad 33162020317 FRANCE Proper E2004 15 21 0 30 TEAS 1a UNITED STATES here York ind 16 19 Oa ELLA TOKELAU Proper BERADA 15 14 QO ESD 15 18 0 30 13103135237 UNITED STATES Califomia The following data is available e Total number of calls 111 0 153 0 033 a s i i m i i OE 0 015 0 0115 OTS u 0 015 e Number of calls with non zero duration billable calls e ASR e Total call duration e Average Length of Call ALOC Numbers are aggregated per destination prefix with a subtotal per country and a total for all calls Should you ne
67. his product 4 Click lel Save Click on the Accessibility tab to edit this product s accessibility i 4 Product Management 8 O oa O Managed By Search Search none E Cara Hame Currency Managed By Description Delete Prepaid cards USD None Prepaid cards HA Add Product gt E save sovenciore cose i Lent Product Name Customer SmartNet Termination ke Currency USD US Dollar v Managed By None v General Info Breakage 0 Maintenance Period None Maintenance Fee Account default ACL Account self care Y Info URL Description What we charge customer SmartNet for calls they terminate to us fj M Edit Customer SmartNet Termination Product Er Gl Save amp Close Ratetookup Logout Product Name Customer SmartNet Termination Currency USD Managed By None General Info Info Accessibility Notepad Edit Node Tariff CLD Info Digits Delete lel any usb _ Termination services IBA Enter Node and Tariff into the product s accessibility list For incoming VoIP traffic we normally do not really need different accessibility entries as just one row with ANY node and tariff should be enough However if for example you want to let a customer send traffic c 2000 2006 PortaOne I nc All rights Reserved www portaone com 1 g PORTA Billing 100 Setting u
68. ically disconnects the call Create accounts to be used for SIP services There are no special requirements as to how such accounts should be created You use the same interface to create and manage accounts for all services supported by PortaBilling H323 SIP Thereafter accounts can use H323 SIP or SIP amp H323 services depending on their product s accessibility So if you plan for accounts with a certain product to be able to login to the SIP server and make outgoing calls be sure to include the PortaSIP node with the appropriate tariff in the Accessibility for this product Integrate PB logins in your website 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 gt Login lt input type text name user value gt Password lt input type password name password value gt c 2000 2006 PortaOne Inc All rights Reserved www portaone com 6 4 PORTA Billing100 How to lt input type button value Login onClick submit gt lt input type hidden name redirectOnLoginError value www myweb com gt lt form gt redirectOnLoginError in case of unsuccessful login PortaBilling will redirect the browser to the URL specified in the value attribute Configure online web signup Typical steps for Web Subscription configuration Decide where you ate going
69. inePayment 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 6o For a better understanding of the following material it is highly recommended that you read the Replication in MySQL chapter at www mysql com or follow this 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 However in our case the master database should not be stopped Let s go through the procedure step by step 1 Make sure slave database has stopped slave thread Logon to the MySQL slave database using the mysql command At the slave server shell command prompt enter the following command mysql uroot p lt mysql root password gt porta billing c 2000 2006 PortaOne I nc All rights Reserved www portaone com 73 PORTA Billing100 Maintenance After that you will see the mysql command prompt Query the slave server status by entering this command show slave status MySQL displays a table with the status of the slave replication Important You should see No as a value in the Slave_Running column If You see Yes stop
70. ing web There are no scripts for a redirect number functionality in the Cisco TCL package You may wish to implement this functionality in house or 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 will make it more intelligent in terms of choosing a customer support center IP telephony private line auto ringdown In the case of a combination of ANI CLI authentication and immediate call forwarding you may map phone lines from one world region to another This is advantageous in that you will require only one local access number Mapping is dependant on ANI CLI Configure outgoing connection to vendor if sending calls using a gatekeeper so that the remote IP address is not known in advance In this situation you clearly cannot use a VoIP to Vendor connection since the IP address of the remote gateway will be assigned dynamically The solution is to set up an IPIPGW and use it to send traffic to this vendor If you only have one such vendor whose termination IP address is unknown beforehand and are sure that everything sent to the unknown IP address is going to this vendor you can use a special feature in PortaBilling t
71. l rights Reserved www portaone com J PORTA Billing100 PortaBilling Guide Part Il Preface This document provides PortaBillinge100 users with the most common examples and guidelines for setting up a VoIP network The last section of the document answers the most frequent questions users ask after running PortaBilline100 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 always contain the latest material on enhancements occurring between minor releases The online copy of this guide is always up to date and integrates the latest changes to the product You can access the latest copy of this guide at www portaone con resources documentation Conventions This publication uses the following conventions Commands and keywords are in boldface Terminal sessions console screens and system file names are displayed in fixed width font Caution means reader beware You are capable of doing something that might result in a 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 that you can save time by performing the action described in the paragraph Tips are information that might help you to solve a problem c 2000 2006 PortaOne Inc All rights Reserved www portaone com 3 PORTA Billing 100 Setti
72. ler wishes to give his subscribers the ability to use either a local access line or a toll free line The reseller can use the accessibility feature to charge subscribers by different tariffs depending on the access number But what amount do you charge the reseller Obviously when somebody calls a toll free line and then calls to 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 crosses 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 tariff which describes charges for incoming access numbers and which 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 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 sectio
73. ll have the following structure S File Edit Yiew Insert Format Tools Data Window Help y Oe 6RY SBAS BF amp 4 O ara 10 BZU Al v Account BS C D E E G H From To Country Description Connect Time Charged Charged Charged Time Time Amount min sec Sec USD 03 00 160 0 15661 01 00 60 0 02426 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 1680 0 15661 01 00 60 0 04085 08 00 480 0 25664 01 00 60 0 01666 21 00 1260 1 42989 50 00 00 3000 3 38407 01 00 60 0 01666 E y Account 5167583578 unknown 1620944635 7188514399 2971379160 unknown 3818446434 7189345246 3860327653 7189539069 9348239454 2488900081 2971379160 unknown 6109656857 unknown 6109656857 unknown 7533308111 2123430383 2971379160 unknown 9210417860 9175199147 73474521511 RUSSIAN FEDERATIC 31 01 04 23 57 70125289892 RUSSIAN Saint Peters 31 01 04 23 56 17708536266 UNITED S Georgia 31 01 04 23 56 3 80412E 11 UKRAINE Proper 31 01 04 23 52 78121142201 RUSSIAN Saint Peters 31 01 04 23 52 70121142201 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 73032237983 RUSSIAN FEDERATIC 31 01 04 23 29 2739293329 7183314906 73462353477 RUSSIAN FEDERATIC 31 01 04 23 22 2971
74. lling100 How to Authenticate and bill my customers by the IP address of their gateway This is another example of how easy it is to implement different billing schemes with PortaBilling For IP based billing you just have to do the following 1 Create a tariff and a product Since Node and CLD only make sense for incoming telephony calls set node to ANY and leave CLD blank for the IP based billing product 2 Use the corresponding application on your gateway to handle the call You can use the Cisco application remote_ip_authenticate or create your own The only important thing is that the IP address of the remote GW be in the User Name attribute in the AAA requests which will go to the billing Here is a sample configuration aaa new model authentication login h323 group radius aaa authorization exec h323 group radius aaa accounting connection h323 stop only group radius I gw accounting h323 vsa I call application voice remote_ip tftp remote_ip_authenticate 1 1 1 tcl l dial peer voice 11 voip application remote_ip incoming called number 3 Create a customer who will own these accounts 4 Create accounts with an Account ID identical to the IP address of the remote gateway and enter cisco as the VoIP password for this account Use volume based billing When you define a rate in a volume based tariff and assign a volume lot to it it will decrease with every call Note that volume
75. n An Termi USD What we charge our customers for their calls we terminate Offpeak P Free Seco Post Call Login Fee Connect Fee 0 0 Destinatior Country Descriptior Interval 1 Interval N Price1 PriceN Off peak In Offpeak In Offpeak P Offpeak P Forbidden Hidden Discontinu Effective Fr 420 CZECH RE Proper 1 0 05 0 05 0 05 0 05 2 3 4 5 6 7 8 9 IP KER SS Dl M csv An _Termination 1 A 4 Ready Sum 420606 36 8 Save the file in Excel You will probably get a warning from Excel that your file may contain features that are not compatible with CSV Comma delimited Ignore this and choose Yes to retain CSV format 9 Close the file in Excel If you performed step 6 then disregard the message Do you want to save the changes you made as this is only caused by the fact that your format is not the native Excel XLS format 10 Go back to the PortaBilling web interface and the Edit Tariff screen 11 Click on the Upload button 12 Either enter the name of your file manually or click Browse and choose the file 13 Click l Save amp Close You should return to the Edit Tariff screen where a message will inform you of the status of the import Also you will recetve email confirmation about the tariff upload If any c 2000 2006 PortaOne I nc All rights Reserved www portaone com 1 5 PORTA Billing100 Setting up a Wholesale IP Telephony Company operation has failed you will receive t
76. n ChargeCustomerForIncomingCalls 1 4 Define a PSTN from vendor connection which will describe the point where calls are delivered to your network from the vendor c 2000 2006 PortaOne I nc All rights Reserved www portaone com 49 PORTA Billing100 How to 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 al Save amp Close Now when an account belonging to the reseller makes a call to the toll free number 18001234567 and there is a 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 your termination cost e For the vendor who provided the toll free line a CDR will be created which describes your incoming call cost e For the reseller two CDRs will be created and his balance will be modified accordingly O for the call to 42021234567 according to his outgoing tariff wholesale rates O for the call to 18001234567 according
77. ng up a Wholesale IP Telephony Company Setting up a Wholesale IP Telephony Company Wholesale voice is a growth market with service providers building new capacities and launching new services The primary wholesale service is long distance transport and aggregation with the key advantage being that country specific features and domestic calling regulations are not required The principal beneficiaries are developing countries where in many cases the quality of VoIP is superior to that of traditional PSTN services c 2000 2006 PortaOne I nc 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 The Minutes Ageregation and Resale service including ASP Termination allows wholesale network providers to collect traffic from multiple originating providers then aggregate and deliver it to the termination providers they select PORTA Billing 100 Customer1 gw example Vendor The provider in this scenario is the owner of termination node POP gw example1 This is a typical example of a VoIP network where customers pay the provider to terminate traffic at point An while the provider himself pays the vendor for traffic at point B The provider makes his profit on the differenc
78. nly important thing is that ANI CLD must be in the User Name attribute in the AAA requests which go to the billing Cisco gateways usually have a number of ANI CLI 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 fax_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_npw Authenticate with ani NULL collect if that fails clid col now lt 3 Authenticate with ani NULL and 3 tries collecting clid_col_npw_npw Authenticate with ani NULL and 3 tries without pw DEFAULT Default system session application session t old Session Application in TCL fax hop ons 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 NULL 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 Tesh debs CCard seth 3 ed prep
79. o handle this situation create a VoIP to Vendor connection and enter ANY as the remote IP address Any outgoing VoIP c 2000 2006 PortaOne Inc All rights Reserved www portaone com 63 PORTA Billing100 How to call which goes neither to one of your trusted nodes nor any IP addresses explicitly defined in other connections will match this connection If you have more than one such vendor whose remote IP is not known in advance this method is no longer applicable If you are using tech prefixes so that the phone number changes based on which carrier is being used e g a call to 42021234567 will go to vendor A as 12345 42021234567 and to vendor B as 9876542021234567 you can use connection match by prefix In the example above enter PREFIX 12345 in the Remote IP field for the connection to vendor A and PREFIX 98765 for the connection to vendor B Such a prefix connection will be matched only if the call does not go via a connection with a specific IP address or to a trusted node Force PortaBilling to disconnect after a customer calls over his credit limit There is no need for PortaBilling to do this as the gateway is able to by itself When the gateway authorizes an account to make a call in PortaBilling PortaBilling returns a maximum credit time h323 credit time RADIUS attribute in the case of a successful authorization When the gateway connects the call it starts a timer when the timer hits zero it automat
80. on pattern port 0 D dial peer voice 11 voip application remote_ip incoming called number c 2000 2006 PortaOne I nc All rights Reserved www portaone com 7 PORTA Billing 100 Setting up a Wholesale IP Telephony Company NOTE There is an Advanced remote authenticate application available at http store portaone com It contains many extra features beyond the default Cisco application therefore we recommend using it instead of that application Billing configuration Please see the PortaBilling Administrator Interface PDF file for detailed instructions on how to navigate and operate in the web interface and detailed explanations of particular fields Initial configuration of PortaBilling The following steps are normally performed only once after the system has been installed This includes e Visit Company Info from the main menu Enter information about your company and set up a base currency Of course this does not limit your operations to this currency only However on reports such as cost revenue different currencies will be converted to the one you specify here e From the main menu choose Users and create login entries for users who will be working with the system It is not recommended that the default PortaBilling root user pb root be used for any operations other than initial set up e Make sure you are able to login as the newly created user and change the password for the pb root user
81. or 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 lt 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 current rates should be kept CustomerWeb Pager 50 Interval 1 AccountWeb Interval 1 Pager 50 TraceCall Pager 50 Interval 1 Invoice Pager 50 Interval 1 Stats GrossMargin_Interval 1 GrossMargin_Measure day month GrossMargin_Measure day c 2000 2006 PortaOne I nc All rights Reserved www portaone com 79 PORTA Billing100 Maintenance GrossMargin_MaxAge max age in days GrossMargin_MaxAge 1000 ASR_days 90 ASR_weeks 52 ASR_month 10 RRD It is not recommended to change these parameters without a good grasp of RRD principles Load_delay_seconds 3600 Zero_call_length 10 Load_delay_interval 900 when ASR graph appears ASR_Threshold 5 StatCalc Interval 0 Mask Onl
82. ose in order to exit to the Vendor Management screen A c 2000 2006 PortaOne Inc All rights Reserved www portaone com 241 PORTA Billing 100 Setting up a Wholesale IP Telephony Company 9 Repeat steps 2 7 to add connections for other vendors Create a Customer A customer is an owner of accounts The customer s contact information is used to distribute generated account data and account usage information _ In the Management section of Admin Index choose Customers On the Customer Management page choose Add 3 Fill in the New Customer form Please note that there are several tabs with extra information available on the screen The most important fields are N E Customer Management gt Badd cose PB togout tog Type Representative Search Direct Customers v CDRs Hame Accounts Subcustomers Currency Type Credit limit Balance E mail Status Delete O Prepaid card test USD Retail 0 00000 Gi 4 Add Customer gt E save sivenctore coef oe Customer Name SmartNet i Currency USD US Dollar Blocked O Opening Balance Type Retail v Address Info Additional Info Payment Info User Interface Company Name SmartNet Ltd Contact MriMs J Phone First Name df Fax Last Name Alt Phone Address 7500 25th St NE Alt Contact E mail
83. p a Wholesale IP Telephony Company to your gateway A but not gateway B this can be achieved by using accessibility entries 1 When the Accessibility tab is selected click on the El Add icon Choose ANY as node choose the tariff with which you want to bill your customer and leave the 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 the providers of incoming toll free lines 1 In the Management section of the Admin interface choose Vendors On the Vendor Management page choose 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 o Currency The currency in which this vendor charges you Oo Opening balance Starting balance for the vendor default is Zero Additional info o Billing period Split period for vendor statistics User Interface o Time zone The time zone which the vendor uses for his billing period Statistics will be divided into periods according to this time zone 4 Click el Save amp Close 5 Repeat steps 2 4 to add all of your vendors Gi M Vendor Management e eaaa o aose i toca O Search CDRs Name Conne
84. physical line Although it might be a good idea to implement call authorization so that you can control which destinations the customer is allowed to call to we will not discuss this here For port based billing you need only do the following 1 For each such customer create a tariff that you want to use to bill the customer and a product Only one row in Accessibility is necessary with the node ANY and the tariff you have created 2 Now you must make sure that each call made by that customer is tagged as belonging to him Use the corresponding application on yout gateway to handle the call You can use the Cisco application app_session_name or create your own The often difficult part in gateway configuration is designing dial peers to match certain voice ports Dial peers should resemble the following configuration dial peer voice 1 pots application client_on_port_1l direct inward dial port 1 D They will be listed with an operation status of down as the port specification must be accompanied by a number matching a specification for example dial peer voice 1 pots application client_on_port_1l incoming called number c 2000 2006 PortaOne Inc All rights Reserved www portaone com 4 4 PORTA Billing100 How to 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 i e this dial peer will match any
85. poses First of all it defines in which time zone the customer will see his CDRs It also defines which time zone will be used to divide 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 Click ml Save amp Close to save your work See the PortaBilling Administrator Interface for more information Create Accounts NOTE Before generating accounts for a production system read the section on Provisioning prepaid accounts 1 Go to the Customers screen the screen which contains a list of customers It should look like the screenshot below 2 Next to the customer name click on the 22 icon the one in the Accounts column which will take you to the account management for that customer Gi 4 Customer Management gt E add cose ff i bogout B too Type Representative Search Direct Customers v ANY CDRs Hame Accounts Subcustomers Currency Type Credit limit Balance Status Delete O Prepaid card test USD Retail 0 00000 O SmartNet USD Retail 0 00000 admin smartnet com x G A Accounts of Retail Customer SmartNet gt ew aaa account generator close B tog Account ID awe Crame i M Add Account fo
86. r Retail Customer SmartNet gt E save el sovencose coef tno a MAccount ID 205 12 34 56 a Product USD Customer SmartNet Termination vi o SBlocked CO Opening Balance o jE B Account Info Subscriber Additional Info Life Cycle User Interface a mype Debit Credit Voucher Credit Limit WVolP Password cisco E mail E Batch smartnet New batch E V c 2000 2006 PortaOne I nc All rights Reserved www portaone com 95 PORTA Billing 100 Setting up a Wholesale IP Telephony Company fj Accounts of Retail Customer SmartNet gt Eads B Account Generator cose MM toot Account ID aa Jj Show Accounts CDRs Account ID Idle days Currency Balance Open Balance Credit Limit Type Product Batch Status e 205 12 34 56 USD 0 00000 0 00000 Credit Customer SmartNet termination smartnetip 3 Now click on Add 4 Fill in the Add account form o Account ID Identification of the account value to be sent in the User Name attribute For an account which represents a remote gateway this is normally an IP address o Product Choose the product which you would like your accounts to use o Blocked Check this if you want to create the account as initially blocked Oo Opening balance The initial balance on the card For credit accounts the opening balance is normally zero
87. r when replication has been 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 c 2000 2006 PortaOne I nc All rights Reserved www portaone com 30 PORTA Billing 100 Statistics and Monitoring Tools Normally these values will depend on the processes running on the server such as the Radius daemon the Apache httpd server statistics collection tools and so on Larger values can indicate other client connections to the server If the number of threads on the slave name server is 0 this means the replication process is down and requires administrator attention see section 2 4 for details c 2000 2006 PortaOne I nc All rights Reserved www portaone com 31 PORTA Billing100 Statistics and Monitoring Tools VoIP network performance statistics Connection load You can monitor load and quality parameters for individual connections To see a list of the available connections follow the Connections link from the Statistics section in the main menu E A Connection Load ease O O O O ito Vendor PSTH from Vendor PSTH to Vendor VolP to Vendor Proxied VolP to Vendor Termination SPT Telecom X Telecom After you select a vendor and a particular connection you will see its load graph 100 7 400 120 calls 18 00 00 00 06 00 12 00 18 00 00 00 E Load E Setup Time W AS
88. ribed to the PortaBilling mail alerts especially Missing critical information This will help you to detect problems early 2 Find the h323 conf id for this call This is a unique ID a string of four hex numbers generated by the gateway when the call was started which will help you to exactly identify c 2000 2006 PortaOne I nc All rights Reserved www portaone com 59 PORTA Billing 100 How to this particular call among all the others You can find this ID by doing one of the following Looking at the statistics on your gateway Going to the radius details directory var log radacc entering the subdirectory for the corresponding gateway and using a program like more or less to browse the file You can search by the number you dialed or account PIN number or just browse the records near the end of the file Browsing the PortaBilline log var log porta billing 1log for the number you dialed account PIN number or just browsing the records near the end of the file 3 Look in the PortaBilling log var log porta bi Lling log ot use View logs on the web interface to find all of the information about call processing there Note Normally we receive information about each of the call legs separately so it is necessary that you check the log entry regarding the processing of all call legs and the final call clean up 4 The following are typical error situations Call was not billed
89. rice Ordinary_Price X Toll_FreeCost where X is a ratio between the total duration of incoming toll free calls and the total duration of outgoing calls 2 Make sure your IVR script supports the PortaBilling Original CLD feature 3 Create a product for your calling cards and make two entries in Accessibility e one with a CLD equal to your toll free number and Toll free tariff e another with a 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 ANI based billing you only need to do the following 1 Create a tariff or tariffs and a product Note If you are providing both prepaid cards and ANI based billing take measures to prevent fraud e g someone could dial your IVR and enter their neighbor s home c 2000 2006 PortaOne I nc All rights Reserved www portaone com 42 PORTA Billing 100 How to phone number as the PIN When creating accessibility for the ANI based billing product separate it from prepaid cards by using a different access phone number a different node or different PIN lengths for the prepaid cards 2 Use the corresponding application on your gateway to handle the call You can use one of the default Cisco applications clid_ or create your own The o
90. ription First Next First Next HH24 MI SS SC ed LA eee 1 0 45000 0 15000 2004 07 29 Enter Rates Rates are per destination prices Please refer to the System Concepts chapter for more details on billing parameters Managing rates online Managing rates online is very convenient for maintaining existing rate tables and for reference purposes In the case of new price lists or major updates the offline method is better 1 On the Tariff Management page you will see a list of available tariffs Click the L Rates icon next to the name of the tariff When you are in Tariff Management for a particular tariff click on i Rates in the toolbar 2 Inthe Edit Rates screen click Add 3 Fill in the required information o Destination Destination prefix may be entered directly e g 47 for Norway or you can access the destinations directory by clicking the Destination link in the column header Here you can find the desired prefix by country name NOTE The phone prefix you are trying to create a rate for must already exist in Destinations 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
91. rovided by MySGL AB MySOQL AB is a commercial 98 PORTA Li Billing100 2 MySQL Connector ODBC 3 51 Start Installation You are now ready to install MySQL Connector ODBC 3 51 Press the Next Button to begin the installation or the Back i button to reenter the installation information MySQ Http waa msg conn MySQL Connector ODBC 3 51 Installing a gt CAWINO OWS Sustense modi 3 all Current File Copying tile All Files Time Remaining O minutes 0 seconds ise Installation Wizard c 2000 2006 PortaOne I nc All rights Reserved www portaone com How to 59 PORTA Billing 100 How to lt 2 MySQL Connector ODBC 3 51 MyS Http a msg conn 3 Click Finish Finished MySQL Connector ODBC 3 51 has been successtully installed on your system For more information about MyODBCC visit tho aan msg com products myodbe MySQL AB offers a full palette of Professional Services to help vou design 4 better database schema and optimise your MySOL Server parameters in order to increase the throughput of your applicatiors Support Support from the developers of the MySQL Server Training Training for the MySQL Server Consulting Consulting tailored to your specific MySQL needs For more information visit Http aan msg conn services Press FINISH button to exit from the installation Configuring ODBC Before configurin
92. ter suit your needs porta admin conf Global System_Name MyBilling Enter a distinctive name for 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 should be in the From field of outgoing emails Time_Zone America New_York Default time zone 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 a master parameter and can be altered for individual forms Porta_Realm admin 443 accounts 8445 cc_ staff 8446 customer 8444 Ports that different parts of the web interface are using Master DSN DBI mysql database porta billing host porta billing master User root Password XXXX PrintError 1 Connect parameters for the master database Slave DSN DBI mysql database porta billing mysql_socket tmp mysql slave sock User root Password xxxXxx PrintError 1 Connect parameters for the slave database Backup Keep 1 X Rates Max age days Max_age 60 c 2000 2006 PortaOne Inc All rights Reserved www portaone com 71 PORTA Billing100 Maintenance Pager 25 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 generat
93. 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 you charge the reseller for the actual incoming call duration 1 e exactly the same duration you are charged by the toll free line vendor Deal with technical prefixes and numbering formats Different termination partners often require that you send them numbers in some specific format For example your termination partner might require usage of the technical prefix 98907 so you have to send him 58901 42021234567 instead of 42021234567 while your local phone provider requires that outgoing call numbers be dialed without the 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 different numbering formats Of course it is better to use a c 2000 2006 PortaOne I nc All rights Reserved www portaone com 50 PORTA Billing100 How to single numbering format internally Our recommendation is to use the E 164 format in billing and on your network An E 164 compliant number is one consisting of lt countrycode gt lt areacode gt lt phoneH gt Examples of valid E 164 numbers are 42021234567 and 16049876543 The following numbers are not valid E 164 numbers 6049876543 NANP format 0114202123456
94. u in the Add tariff form 2 Enter the default rates These rates should not be volume based keep the Volume Time column empty rather these are the rates to be used when the volume lot has been 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 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 El ABC volume based tariff rates Effective From Destination m E Cero Coe Edit Destination Country Description Interval sec Price USD min Volume m Effective From 4 in Delete First Next First Hext min YYYY MM DD HH24 MI SS JL Ji JL __ 00o 5 420 CZECH REPUBLIC Proper 0 00000 0 00000 2004 02 24 00 04 11 420 CZECH REPUBLIC Proper 0 00000 0 00000 2004 02 24 00 00 47 amp CZECH REPUBLIC Prague 0 00000 0 00000 2004 02 24 00 04 24 CZECH REPUBLIC Prague 0 00000 0 00000 2004 02 24 00 01 01 amp Reliable cost revenue figures when using volume based billing If in addition to the volume lot you want to include price parameters in the rate this will not be used in creating a CDR for t
95. ule Tariff Description Capacity Delete qu test v j G Prepaia caras w al atest ISDNO s 011 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 the providers of incoming toll free lines 1 In the Management section of the Admin interface choose Vendors 2 Click on the Connections icon next to the vendor name 3 Choose the connection type PSTN to Vendor VoIP to Vendor etc by clicking on the corresponding tab 4 Press Add to add a new connection Fill in the connection information If you send traffic to the vendor via telephony choose the node and enter an optional port pattern If you send traffic via VoIP enter the remote IP address Choose the tariff which defines your termination costs for this connection vendor Description and Capacity are mandatory for all connection types 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 vendot specific format 7 Click lel Save 8 Repeat steps 3 5 to add more connections to the same vendor then click Cl
96. um of durations for all call types divided by the maximum value in seconds The result is shown as a percentage value multiplied by 100 ASR calculations Assumption Connection load less than 5 is not representative of ASR calculating 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 is calculated as the ratio between the total setup time of all calls during the given period and the maximum value in seconds capacity 900sec ASR statistics Follow the ASR link from the Statistics section in the main menu c 2000 2006 PortaOne Inc All rights Reserved www portaone com 33 PORTA Billing 100 Statistics and Monitoring Tools Gl h Vendor reports gt S coe ots toot 96 Search Download Options V Call Center Colo Central iBasis Metrocom NDNT DirectNet PaeTec RadioNet SIP ua2ua T Systems Teleglobe Aug 2003 Mo TuWe ThFr Sa Su 31 le 32 4 E5 i ee We ee l 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 TuWe ThFr Sa Su Sees 50 6 9 10 11 12 13 14 51 15 16 17 18 19 20 21 52 22 23 24 25 26 27 26 53 29 30 31 Apr 2004 Mo TuWe ThFr Sa Su 14 il ee es 155 6 7 8 9 1011 16 12 13 14 15 16 17 18 47 19 20 21 22 23 24 25 18 26 27 26 29 30 Sep 2003 Mo TuWe ThFr Sa Su 36 a ie e
97. us even if a hacker calls your access number 12345 for prepaid cards and attempts to enter his neighbor s phone number as a PIN the call will not be authorized since although such an account exists its product only allows usage with the access number 12346 However you might need to create an advanced service in which a single access number can be used for both ANI and PIN based services When the customer calls in the system checks his ANI and if the ANI is OK it asks for a destination number Otherwise it gives the option of entering either a PIN or a phone number password In this case you must prevent account misuse in a different way c 2000 2006 PortaOne I nc All rights Reserved www portaone com 99 PORTA Billing100 How to e ANI accounts should always be created with a non empty VoIP password Prepaid cards should be created with an empty VoIP password e Modify the TCL script so that when the first authentication by ANI is done the billing will receive User Name ANI and a special flag skip password Thus authentication will be successful if such an account exists otherwise it will fail and the user will be prompted for a PIN e When a user enters a PIN the PIN is provided in the User Name and the Password attribute is empty The system checks for such an account and since the password is empty for prepaid card VoIP authentication is successful If somebody tries to enter an ANI number

PortaBilling: User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents