Installation Guide

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/

Step 5 - Create 1 entry per customer in the [CustomerMaster] table.

Step 6 - Create 1 entry per IP address you accept traffic from in the [IPAddressMaster] table.

Step 7 - If the CDR you import do not contain a CustomerID field create 1 entry per DID in the [DIDMaster] table.

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.

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.

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

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

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

Step 14 - Review our [Performance Tuning] recommendations.

Step 15 - 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].

Support - email support@opencdrrate.org

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

-The OpenCDRRate team from DTH Software, Inc