Installation Guide

If you have any trouble setting up the system, please contact our [Support]. We are happy to offer some assistance with the install/configuration. No charge.

Step 1 - Install Postgres on your Linux or Windows server. We recommend using the latest stable release.

http://www.postgresql.org/download/

Step 2 - Create your OPENCDRRATE database. Navicat and pgadmin3 have nice utilities to manage postgres installations if you are unfamiliar with postgres management.

Step 3 - Enable the PL/pgSQL language.

https://wiki-bsse.ethz.ch/display/ITDOC/Enable+PLpgSQL

Step 4 - Install all the system [Tables]. Download: https://sourceforge.net/projects/opencdrrate/files/Tables/

You can download them individually or use the _AllTables file.

Step 5 - Create 1 entry per customer in the [CustomerMaster] table. You can also enter them through the [PHP Admin Portal] by clicking 'Customers' on the main page.

Step 6 - Create 1 entry per IP address you accept traffic from in the [IPAddressMaster] table. You can also enter them through the [PHP Admin Portal] by clicking 'IP Addresses' on the main page.

Step 7 - If the CDR you import do not contain a CustomerID field create 1 entry per DID in the [DIDMaster] table. You can also enter them through the [PHP Admin Portal] by clicking 'DIDs' on the main page.

Step 8 - Load all your rates into the rate tables. You can click on each call type on the Home page to see what rate tables need to be loaded. Rates can also be loaded via the [PHP Admin Portal] by clicking 'Customer Rates' off the main page.

Step 9 - Load the [TieredOriginationRateCenterMaster]. This is required if you are using the system to rate origination.

Step 10 - Load the taxes you want to charge into the [CustomerTaxSetup] table. You can also enter them through the [PHP Admin Portal] by clicking 'Customer Tax Setup' on the main page.

Step 11 - Install all the system [Functions]. Download: https://sourceforge.net/projects/opencdrrate/files/Functions/

You can download them individually or use the _AllFunctions file.

Step 12 - Install all the system views. Download: https://sourceforge.net/projects/opencdrrate/files/Views/

You can download them individually or use the _AllViews file.

Step 13 - Configure system backups. We also recommend off-site storage.

Step 14 - Configure the following postgres [Functions] to run once per hour. These functions should not be run at the same time.

fnCategorizeCDR
fnRateIndeterminateJurisdictionCDR
fnRateInternationalCDR
fnRateInterstateCDR
fnRateIntrastateCDR
fnRateSimpleTerminationCDR
fnRateTieredOriginationCDR
fnRateTollFreeOriginationCDR

Step 15 Install the [PHP Admin Portal]. [Installation Guide - Admin Portal]

Step 16 - Review our [Performance Tuning] recommendations.

Step 17 - You can click on each call type on the Home page to see what tables to load and what functions to use for each call type we rate.

This software is distributed under the GPLv3 [License].

Questions? Contact [Support]

Follow us on twitter to received new feature notifications: http://www.twitter.com/opencdrrate/

-The OpenCDRRate team from DTH Software, Inc